def select(self, query, bind=None):
try:
if bind:
self.cursor.execute(query, bind)
else:
self.cursor.execute(query)
except:
log.exception()
raise
def _dmlmany(self, statement, binds=None, autocommit=True):
try:
self.cursor.executemany(statement, binds)
if autocommit:
self.commit()
return self.cursor.rowcount
except:
log.exception()
if autocommit:
self.rollback()
raise
def select(self, statement, bind=None):
"""SELECT 문 실행을 위한 method
:param statement: string. SQL 문장. (template 문자열, binding 변수 형식 모두 사용가능.)
:param bind: tuple or list. binding 변수값.
"""
try:
if bind is None:
self.cursor.execute(statement)
else:
self.cursor.execute(statement, bind)
except:
log.exception()
raise
def __init__(self, user, passwd, dbname, host="localhost", port=3306, charset="utf8"):
DBWrapper.__init__(self)
try:
log.debug(f"MySql connection info. ({host}:{user}/{passwd}@{dbname}")
self.connector = MySQLdb.connect(host, user, passwd, dbname, port=port, charset=charset)
except:
log.exception()
raise
try:
self.cursor = self.connector.cursor()
except:
log.exception()
raise
def __init__(self, filename, auto_commit=None):
DBWrapper.__init__(self)
try:
log.debug("Sqlite connection info. (%s)" % filename)
# autoCommit : None | DEFERRED | IMMEDIATE | EXCLUSIVE
self.connector = sqlite3.connect(filename, isolation_level=auto_commit)
# self.connector = sqlite3.connect(filename)
except:
log.exception()
raise
try:
self.cursor = self.connector.cursor()
except:
log.exception()
raise