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