def closeMySql(self, scode):
MultiDbManager.instance().delMySql(scode)
def createTables(self, scode):
for table in self.databaseMaker.tableQueries:
MultiDbManager.instance().nonSelect(scode, table)
def hasScode(self, scode):
return MultiDbManager.instance().hasScode(scode)
def initMySqlWithDatabase(self, scode, host, port, user, passwd, dbname):
return MultiDbManager.instance().addMySql(scode, host, port, user,
passwd, dbname, self)
def execute(self, scode, sql, params):
return MultiDbManager.instance().execute(scode, sql, params)
def selectOne(self, scode, sql):
result = MultiDbManager.instance().select(scode, sql)
if result is None:
return None
return result[0]
def delete(self, scode, sql):
return MultiDbManager.instance().update(scode, sql)
def insert(self, scode, sql):
return MultiDbManager.instance().insert(scode, sql)
def select(self, scode, sql):
return MultiDbManager.instance().select(scode, sql)
def count(self, scode, sql):
return len(MultiDbManager.instance().select(scode, sql))
def multiQueries(self, scode, queries):
return MultiDbManager.instance().multiQueries(scode, queries)
def upsertQueries(self, scode, queries):
return MultiDbManager.instance().insertQueries(scode, queries)
def updateQuery(self, scode, sql):
return MultiDbManager.instance().update(scode, sql)