Mercurial > repos > yufei-luo > s_mart
comparison SMART/Java/Python/removeAllTmpTables.py @ 6:769e306b7933
Change the repository level.
| author | yufei-luo |
|---|---|
| date | Fri, 18 Jan 2013 04:54:14 -0500 |
| parents | |
| children |
comparison
equal
deleted
inserted
replaced
| 5:ea3082881bf8 | 6:769e306b7933 |
|---|---|
| 1 #! /usr/bin/env python | |
| 2 # | |
| 3 # Copyright INRA-URGI 2009-2010 | |
| 4 # | |
| 5 # This software is governed by the CeCILL license under French law and | |
| 6 # abiding by the rules of distribution of free software. You can use, | |
| 7 # modify and/ or redistribute the software under the terms of the CeCILL | |
| 8 # license as circulated by CEA, CNRS and INRIA at the following URL | |
| 9 # "http://www.cecill.info". | |
| 10 # | |
| 11 # As a counterpart to the access to the source code and rights to copy, | |
| 12 # modify and redistribute granted by the license, users are provided only | |
| 13 # with a limited warranty and the software's author, the holder of the | |
| 14 # economic rights, and the successive licensors have only limited | |
| 15 # liability. | |
| 16 # | |
| 17 # In this respect, the user's attention is drawn to the risks associated | |
| 18 # with loading, using, modifying and/or developing or reproducing the | |
| 19 # software by the user in light of its specific status of free software, | |
| 20 # that may mean that it is complicated to manipulate, and that also | |
| 21 # therefore means that it is reserved for developers and experienced | |
| 22 # professionals having in-depth computer knowledge. Users are therefore | |
| 23 # encouraged to load and test the software's suitability as regards their | |
| 24 # requirements in conditions enabling the security of their systems and/or | |
| 25 # data to be ensured and, more generally, to use and operate it in the | |
| 26 # same conditions as regards security. | |
| 27 # | |
| 28 # The fact that you are presently reading this means that you have had | |
| 29 # knowledge of the CeCILL license and that you accept its terms. | |
| 30 # | |
| 31 """Remove all tmp tables in the MySQL database""" | |
| 32 | |
| 33 import os | |
| 34 import glob | |
| 35 from optparse import OptionParser | |
| 36 from SMART.Java.Python.mySql.MySqlConnection import * | |
| 37 | |
| 38 | |
| 39 if __name__ == "__main__": | |
| 40 | |
| 41 description = "Remove Tables v1.0.2: Remove tables in the local MySQL database. [Category: Other]" | |
| 42 | |
| 43 parser = OptionParser(description = description) | |
| 44 parser.add_option("-t", "--tmp", dest="tmp", action="store_true", default=False, help="Remove temporary tables only [format: bool] [default: false]") | |
| 45 parser.add_option("-f", "--files", dest="files", action="store_false", default=True, help="Do not remove temporary files [format: bool] [default: true]") | |
| 46 (options, args) = parser.parse_args() | |
| 47 | |
| 48 print "Removing temporary databases:" | |
| 49 if options.files: | |
| 50 for tmpFile in glob.glob("smartdb*"): | |
| 51 print " removing %s" % (tmpFile) | |
| 52 os.unlink(tmpFile) | |
| 53 print "Removing temporary files:" | |
| 54 if options.files: | |
| 55 for tmpFile in glob.glob("tmp*.dat"): | |
| 56 print " removing %s" % (tmpFile) | |
| 57 os.unlink(tmpFile) | |
| 58 for tmpFile in glob.glob("tmp*.R"): | |
| 59 print " removing %s" % (tmpFile) | |
| 60 os.unlink(tmpFile) | |
| 61 for tmpFile in glob.glob("tmp*.Rout"): | |
| 62 print " removing %s" % (tmpFile) | |
| 63 os.unlink(tmpFile) | |
| 64 |