|
6
|
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
|
