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