Mercurial > repos > yufei-luo > s_mart

comparison commons/tools/MysqlConnect.py @ 18:94ab73e8a190

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author m-zytnicki
date Mon, 29 Apr 2013 03:20:15 -0400
parents
children
comparison
equal deleted inserted replaced
17:b0e8584489e6 18:94ab73e8a190
1 # Copyright INRA (Institut National de la Recherche Agronomique)
2 # http://www.inra.fr
3 # http://urgi.versailles.inra.fr
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 from commons.core.sql.DbMySql import DbMySql
32 from commons.core.utils.RepetOptionParser import RepetOptionParser
33
34 def main():
35 description = "Check MySQL connection on a node"
36 usage = "MysqlConnect.py -n hostname"
37
38 parser = RepetOptionParser(description = description, usage = usage, version = "v1.0")
39 parser.add_option( "-n", "--node", dest = "node", type = "string", help = "node name", default = "")
40 parser.add_option( "-C", "--config", dest = "config", type = "string", help = "path to config file", default = "")
41
42 options, args = parser.parse_args()
43
44 node = options.node
45
46 try:
47 if options.config != "":
48 idbMySQL = DbMySql(cfgFileName = options.config)
49 else:
50 idbMySQL = DbMySql()
51 print "SUCCESS to connect to MySQL database from '%s'" % node
52 except SystemExit:
53 print "FAILED to connect to MySQL database from '%s'" % node
54
55 if __name__ == '__main__':
56 main()