def executeResultsQuery(self, query):
"""Execute a query for which the database will return results.
For example a SELECT query.
"""
config = Config.dbinfo().copy()
db = connector.Connect(**config)
cursor = db.cursor()
cursor.execute(query)
results = cursor.fetchall()
cursor.close()
db.close()
return results
def executeUpdateQuery(self, query):
"""Execute a query that needs to be committed to the database.
For example, an INSERT or UPDATE query.
"""
config = Config.dbinfo().copy()
db = connector.Connect(**config)
cursor = db.cursor()
cursor.execute(query)
db.commit()
cursor.close()
db.close()
return
def executeMultipleUpdateQueries(self, queries):
"""This method is idential to self.executeUpdateQuery
except that it takes a list of query strings and executes each in turn
"""
config = Config.dbinfo().copy()
db = connector.Connect(**config)
cursor = db.cursor()
for query in queries:
cursor.execute(query)
db.commit()
cursor.close()
db.close()
return
def executeMultipleResultsQueries(self, queries):
"""This method is idential to self.executeResultsQuery
except that it takes a list of query strings, executes each in turn
and returns a corresponding list of results.
"""
results = []
config = Config.dbinfo().copy()
db = connector.Connect(**config)
cursor = db.cursor()
for query in queries:
cursor.execute(query)
result = cursor.fetchall()
results.append(result)
cursor.close()
db.close()
return results
