annotate SMART/Java/Python/mySql/MySqlConnection.py @ 46:169d364ddd91

Uploaded
author m-zytnicki
date Mon, 30 Sep 2013 03:19:26 -0400
parents 44d5973c188c
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
36
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
1 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
2 # Copyright INRA-URGI 2009-2010
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
3 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
4 # This software is governed by the CeCILL license under French law and
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
5 # abiding by the rules of distribution of free software. You can use,
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
6 # modify and/ or redistribute the software under the terms of the CeCILL
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
7 # license as circulated by CEA, CNRS and INRIA at the following URL
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
8 # "http://www.cecill.info".
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
9 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
10 # As a counterpart to the access to the source code and rights to copy,
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
11 # modify and redistribute granted by the license, users are provided only
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
12 # with a limited warranty and the software's author, the holder of the
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
13 # economic rights, and the successive licensors have only limited
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
14 # liability.
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
15 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
16 # In this respect, the user's attention is drawn to the risks associated
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
17 # with loading, using, modifying and/or developing or reproducing the
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
18 # software by the user in light of its specific status of free software,
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
19 # that may mean that it is complicated to manipulate, and that also
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
20 # therefore means that it is reserved for developers and experienced
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
21 # professionals having in-depth computer knowledge. Users are therefore
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
22 # encouraged to load and test the software's suitability as regards their
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
23 # requirements in conditions enabling the security of their systems and/or
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
24 # data to be ensured and, more generally, to use and operate it in the
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
25 # same conditions as regards security.
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
26 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
27 # The fact that you are presently reading this means that you have had
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
28 # knowledge of the CeCILL license and that you accept its terms.
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
29 #
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
30 #! /usr/bin/env python
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
31 import os
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
32 import random
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
33 import sqlite3
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
34 from SMART.Java.Python.mySql.MySqlQuery import MySqlQuery
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
35
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
36
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
37 class MySqlConnection(object):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
38 """Connection to a database"""
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
39
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
40 def __init__(self, verbosity = 0):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
41 self.verbosity = verbosity
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
42 self.databaseName = os.path.join(os.environ.get("SMARTTMPPATH", "."), "smartdb%d" % random.randint(0, 100000))
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
43 self.connection = sqlite3.connect(self.databaseName)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
44 self.executeQuery("PRAGMA journal_mode = OFF")
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
45 self.executeQuery("PRAGMA synchronous = 0")
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
46 self.executeQuery("PRAGMA locking_mode = EXCLUSIVE")
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
47 self.executeQuery("PRAGMA count_change = OFF")
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
48 self.executeQuery("PRAGMA temp_store = 2")
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
49
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
50 def __del__(self):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
51 self.connection.close()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
52
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
53
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
54 def createDatabase(self):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
55 pass
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
56
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
57
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
58 def deleteDatabase(self):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
59 if os.path.exists(self.databaseName):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
60 os.remove(self.databaseName)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
61
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
62
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
63 def executeQuery(self, command, insertion = False):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
64 cursor = self.connection.cursor()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
65 query = MySqlQuery(cursor, self.verbosity)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
66 try:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
67 result = query.execute(command, insertion)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
68 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
69 except:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
70 result = query.execute(command, insertion)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
71 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
72 if insertion:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
73 return result
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
74 else:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
75 return query
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
76
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
77
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
78 def executeManyQueries(self, commands):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
79 cursor = self.connection.cursor()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
80 query = MySqlQuery(cursor, self.verbosity)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
81 try:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
82 for cpt, command in enumerate(commands):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
83 query.execute(command)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
84 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
85 except:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
86 for cpt, command in enumerate(commands):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
87 query.execute(command)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
88 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
89
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
90
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
91 def executeManyQueriesIterator(self, table):
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
92 cursor = self.connection.cursor()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
93 query = MySqlQuery(cursor, self.verbosity)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
94 try:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
95 for command in table.getIterator():
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
96 query.execute(command)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
97 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
98 except:
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
99 for command in table.getIterator():
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
100 query.execute(command)
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
101 self.connection.commit()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
102
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
103
46
169d364ddd91 Uploaded
m-zytnicki
parents: 36
diff changeset
104 def executeFormattedQuery(self, command, *parameters):
36
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
105 cursor = self.connection.cursor()
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
106 query = MySqlQuery(cursor, self.verbosity)
46
169d364ddd91 Uploaded
m-zytnicki
parents: 36
diff changeset
107 query.executeFormat(command, parameters)
36
44d5973c188c Uploaded
m-zytnicki
parents:
diff changeset
108 self.connection.commit()
46
169d364ddd91 Uploaded
m-zytnicki
parents: 36
diff changeset
109 return query