def executeStatement(self, query):
connection = None
try:
connection = MysqlConnection(
config.dbHost,
config.dbUser,
config.dbPassword,
config.dbName,
config.dbPort)
connection.openConnection()
connection.createCursor()
connection.executeStatement(query)
return connection.getResults()
except:
raise
finally:
self.closeConnection(connection)
def executeUpdate(self, query):
connection = None
idInsert = 0
try:
connection = MysqlConnection(
config.dbHost,
config.dbUser,
config.dbPassword,
config.dbName,
config.dbPort)
connection.openConnection()
connection.createCursor()
connection.executeStatement(query)
connection.executeCommit()
except:
raise
finally:
self.closeConnection(connection)
