|
6
|
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
|
|
|
31 class MySqlQuery(object):
|
|
|
32 """Query to a database"""
|
|
|
33
|
|
|
34 def __init__(self, cursor, verbosity = 0):
|
|
|
35 self.verbosity = verbosity
|
|
|
36 self.cursor = cursor
|
|
|
37 self.insertedId = None
|
|
|
38
|
|
|
39
|
|
|
40 def __del__(self):
|
|
|
41 self.cursor.close()
|
|
|
42
|
|
|
43
|
|
|
44 def execute(self, query, insertion = False):
|
|
|
45 if self.verbosity > 99:
|
|
|
46 print "Querying %s" % (query)
|
|
|
47 try:
|
|
|
48 results = self.cursor.execute(query)
|
|
|
49 except Exception:
|
|
|
50 raise Exception("Error! Command \"%s\" failed!" % (query))
|
|
|
51 if insertion:
|
|
|
52 return self.cursor.lastrowid
|
|
|
53 return results
|
|
|
54
|
|
|
55
|
|
|
56 def executeFormat(self, query, parameters):
|
|
|
57 if self.verbosity > 99:
|
|
|
58 print "Querying %s |" % (query),
|
|
|
59 for parameter in parameters:
|
|
|
60 print parameter,
|
|
|
61 print
|
|
|
62 results = self.cursor.execute(query, parameters)
|
|
|
63 return results
|
|
|
64
|
|
|
65
|
|
|
66 def getLine(self):
|
|
|
67 return self.cursor.fetchone()
|
|
|
68
|
|
|
69
|
|
|
70 def getLines(self, lines = None):
|
|
|
71 if lines == None:
|
|
|
72 return self.cursor.fetchall()
|
|
|
73 return self.cursor.fetchmany(lines)
|
|
|
74
|
|
|
75
|
|
|
76 def isEmpty(self):
|
|
|
77 self.getLines()
|
|
|
78 return self.cursor.rowcount == None or self.cursor.rowcount == 0
|
|
|
79
|
|
|
80
|
|
|
81 def getInsertedId(self):
|
|
|
82 return self.insertedId
|
|
|
83
|
|
|
84
|
|
|
85 def getIterator(self):
|
|
|
86 line = self.getLine()
|
|
|
87 while line != None:
|
|
|
88 yield line
|
|
|
89 line = self.getLine()
|
|
|
90
|
|
|
91
|
|
|
92 def show(self):
|
|
|
93 for line in self.getIterator():
|
|
|
94 print line
|
