diff 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
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/SMART/Java/Python/removeAllTmpTables.py	Fri Jan 18 04:54:14 2013 -0500
@@ -0,0 +1,64 @@
+#! /usr/bin/env python
+#
+# Copyright INRA-URGI 2009-2010
+# 
+# This software is governed by the CeCILL license under French law and
+# abiding by the rules of distribution of free software. You can use,
+# modify and/ or redistribute the software under the terms of the CeCILL
+# license as circulated by CEA, CNRS and INRIA at the following URL
+# "http://www.cecill.info".
+# 
+# As a counterpart to the access to the source code and rights to copy,
+# modify and redistribute granted by the license, users are provided only
+# with a limited warranty and the software's author, the holder of the
+# economic rights, and the successive licensors have only limited
+# liability.
+# 
+# In this respect, the user's attention is drawn to the risks associated
+# with loading, using, modifying and/or developing or reproducing the
+# software by the user in light of its specific status of free software,
+# that may mean that it is complicated to manipulate, and that also
+# therefore means that it is reserved for developers and experienced
+# professionals having in-depth computer knowledge. Users are therefore
+# encouraged to load and test the software's suitability as regards their
+# requirements in conditions enabling the security of their systems and/or
+# data to be ensured and, more generally, to use and operate it in the
+# same conditions as regards security.
+# 
+# The fact that you are presently reading this means that you have had
+# knowledge of the CeCILL license and that you accept its terms.
+#
+"""Remove all tmp tables in the MySQL database"""
+
+import os
+import glob
+from optparse import OptionParser
+from SMART.Java.Python.mySql.MySqlConnection import *
+
+
+if __name__ == "__main__":
+    
+    description = "Remove Tables v1.0.2: Remove tables in the local MySQL database. [Category: Other]"
+
+    parser = OptionParser(description = description)
+    parser.add_option("-t", "--tmp",     dest="tmp",     action="store_true",    default=False, help="Remove temporary tables only [format: bool] [default: false]")
+    parser.add_option("-f", "--files", dest="files", action="store_false", default=True,    help="Do not remove temporary files [format: bool] [default: true]")
+    (options, args) = parser.parse_args()
+    
+    print "Removing temporary databases:"
+    if options.files:
+        for tmpFile in glob.glob("smartdb*"):
+            print "    removing %s" % (tmpFile)
+            os.unlink(tmpFile)
+    print "Removing temporary files:"
+    if options.files:
+        for tmpFile in glob.glob("tmp*.dat"):
+            print "    removing %s" % (tmpFile)
+            os.unlink(tmpFile)
+        for tmpFile in glob.glob("tmp*.R"):
+            print "    removing %s" % (tmpFile)
+            os.unlink(tmpFile)
+        for tmpFile in glob.glob("tmp*.Rout"):
+            print "    removing %s" % (tmpFile)
+            os.unlink(tmpFile)
+