#! /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)