comparison SMART/Java/Python/mySql/MySqlQuery.py @ 6:769e306b7933

Change the repository level.
author yufei-luo
date Fri, 18 Jan 2013 04:54:14 -0500
parents
children 94ab73e8a190
comparison
equal deleted inserted replaced
5:ea3082881bf8 6:769e306b7933
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