class BaseDataBase(object):
ast_translator = MySQLSQLASTTranslator()
def __init__(self, beansdb=None, autocommit=True,
report=lambda *args, **kwargs: None):
self._beansdb = beansdb
self._local = DbLocal(autocommit=autocommit)
self.report = report
self._tables = None
self._index_rows_mapping = {}
self.enable_log = False
self._models = []
def add_lazy_func(self, func):
self._local.add_lazy_func(func)
def _run_lazy_funcs(self):
while True:
try:
func = self._local._lazy_funcs.popleft()
except IndexError:
return
try:
func()
except Exception:
self.report()
def add_commit_handler(self, handler):
self._local.add_commit_handler(handler)
def _run_commit_handlers(self):
while True:
try:
handler = self._local._commit_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception:
self.report()
def add_rollback_handler(self, handler):
self._local.add_rollback_handler(handler)
def _run_rollback_handlers(self):
while True:
try:
handler = self._local._rollback_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception: # pragma: no cover
self.report() # pragma: no cover
def get_tables(self):
if self._tables is None:
c = self.get_cursor()
try:
c.execute('SHOW TABLES')
self._tables = {t for t, in c}
except Exception: # pragma: no cover
return set() # pragma: no cover
return self._tables
def get_index_rows(self, table_name):
if table_name not in self._index_rows_mapping:
try:
tables = self.get_tables()
if table_name not in tables:
return []
c = self.get_cursor()
c.execute('SHOW INDEX FROM `{}`'.format(
table_name
))
self._index_rows_mapping[table_name] = c.fetchall()
except Exception: # pragma: no cover
return [] # pragma: no cover
return self._index_rows_mapping[table_name]
def get_cursor(self):
raise NotImplementedError
def gen_tables_schema(self):
asts = [
self.to_model_table_schema_sql_ast(m)
for m in self._models
]
return self.ast_translator.translate([
'PROGN'
] + asts)[0]
@classmethod
def to_model_table_schema_sql_ast(cls, model):
# pylint: disable=too-many-statements
ast = ['CREATE_TABLE', False, True, model._get_table_name()]
create_difinition_ast = ['CREATE_DEFINITION']
for k in model.__sorted_fields__:
f = getattr(model, k)
f_schema_ast = [
'FIELD', f.name, f.type, f.length,
f.charset, f.default, f.noneable,
f.auto_increment, f.deparse
]
create_difinition_ast.append(f_schema_ast)
create_difinition_ast.append([
'KEY', 'PRIMARY', None, [
x for x in model.__primary_key__
]
])
for key in model.__index_keys__:
key_name = 'idx_' + '_'.join(map(to_camel_case, key))
names = []
for p in key:
f = getattr(model, p)
if not isinstance(f, BaseField):
break # pragma: no cover
names.append(f.name)
else:
if not names:
continue
create_difinition_ast.append([
'KEY', 'INDEX', key_name, names
])
for key in model.__unique_keys__:
key_name = 'uk_' + '_'.join(map(to_camel_case, key))
names = []
for p in key:
f = getattr(model, p)
if not isinstance(f, BaseField):
break # pragma: no cover
names.append(f.name)
else:
if not names:
continue # pragma: no cover
create_difinition_ast.append([
'KEY', 'UNIQUE', key_name, names
])
ast.append(create_difinition_ast)
table_options_ast = ['TABLE_OPTIONS']
if model._options.table_engine is not None:
table_options_ast.append(['ENGINE', model._options.table_engine])
if model._options.table_charset is not None:
table_options_ast.append([
'DEFAULT CHARSET',
model._options.table_charset
])
ast.append(table_options_ast)
return ast
def create_all(self):
schema = self.gen_tables_schema()
with self.transaction():
for sql in get_sqls(schema.split('\n')):
self.sql_execute(sql)
def register_model(self, model_cls):
self._models.append(model_cls)
def log(self, sql, params=None, level=logging.INFO):
if not self.enable_log:
return
cur = self.get_cursor()
log_sql(cur, sql, params=params, level=level)
def beansdb_log(self, cmd, args, kwargs, level=logging.INFO):
if not self.enable_log:
return
def mapper(x):
if isinstance(x, str_types):
return x
try:
return json.dumps(x)
except Exception:
return '<UNKOWN>'
try:
msg = '[BEANSDB]: {} {}'.format(cmd, ' '.join(map(mapper, args)))
logger.log(msg=msg, level=level)
except Exception: # pragma: no cover
pass # pragma: no cover
@property
def autocommit(self):
return self._local._autocommit
@autocommit.setter
def autocommit(self, autommit):
self._local._autocommit = autommit
def begin(self):
pass
def sql_execute(self, sql, params=None):
raise NotImplementedError
def sql_commit(self):
raise NotImplementedError
def sql_rollback(self):
raise NotImplementedError
def ast_execute(self, sql_ast):
sql, params = self.ast_translator.translate(sql_ast)
return self.execute(sql, params=params)
def execute(self, sql, params=None):
self.log(sql, params)
return self.sql_execute(sql, params)
def commit_beansdb(self):
self._do_beansdb_commands()
def commit(self):
res = self.sql_commit()
self.log('COMMIT')
self.commit_beansdb()
self._run_lazy_funcs()
self._run_commit_handlers()
return res
def rollback(self):
res = self.sql_rollback()
self.log('ROLLBACK')
self._local.pop_beansdb_transaction()
self._local.clear_lazy_funcs()
self._run_rollback_handlers()
return res
def push_transaction(self, transaction):
self._local._transactions.append(transaction)
def pop_transaction(self):
self._local._transactions.pop()
def cancel_transaction(self):
if not self.in_transaction():
return False
for tran in self._local._transactions:
tran.cancel()
return True
@property
def transaction_depth(self):
return len(self._local._transactions)
def in_transaction(self):
return self.transaction_depth > 0
def transaction(self):
return Transaction(self)
@need_beansdb
def db_get(self, k, default=None):
return self._beansdb.get(k, default)
@need_beansdb
def db_get_multi(self, ks):
return self._beansdb.get_multi(ks)
@need_beansdb_commit
@need_beansdb
def db_set(self, *args, **kwargs):
self._local.append_beansdb_commands(('set', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_set_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('set_multi', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete_multi', args, kwargs))
def _do_beansdb_commands(self):
if not self._beansdb:
return
while True:
cmds = self._local.shift_beansdb_transaction()
if not cmds:
break
try:
for cmd, args, kwargs in cmds:
func = getattr(self._beansdb, cmd)
func(*args, **kwargs)
self.beansdb_log(cmd, args, kwargs)
except Exception:
self._local.insert_beansdb_commands(*cmds)
break
class BaseDataBase(object):
ast_translator = MySQLSQLASTTranslator()
def __init__(self,
beansdb=None,
autocommit=True,
report=lambda *args, **kwargs: None):
self._beansdb = beansdb
self._local = DbLocal(autocommit=autocommit)
self.report = report
self._tables = None
self._index_rows_mapping = {}
self.enable_log = False
self._models: List[Model] = []
self.modified_cursors = ThreadedObject(Queue)
def add_lazy_func(self, func):
self._local.add_lazy_func(func)
def _run_lazy_funcs(self):
while True:
try:
func = self._local._lazy_funcs.popleft()
except IndexError:
return
try:
func()
except Exception:
self.report()
def add_commit_handler(self, handler):
self._local.add_commit_handler(handler)
def _run_commit_handlers(self):
while True:
try:
handler = self._local._commit_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception:
self.report()
def add_rollback_handler(self, handler):
self._local.add_rollback_handler(handler)
def _run_rollback_handlers(self):
while True:
try:
handler = self._local._rollback_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception: # pragma: no cover
self.report() # pragma: no cover
def get_tables(self):
if self._tables is None:
try:
with self.transaction():
c = self.get_cursor()
c.execute('SHOW TABLES')
self._tables = {t for t, in c}
except Exception: # pragma: no cover
return set() # pragma: no cover
return self._tables
PATTERN_TYPE = re.compile(r'(?P<type>[a-zA-Z]+)(\((?P<len>\d+)\))?')
def get_fields(self,
table_name: str) -> List[Tuple[str, type, Optional[int]]]:
fields = []
try:
with self.transaction():
c = self.get_cursor()
c.execute(f'DESC `{table_name}`')
for name, type_str, _, _, _, _ in c:
m = self.PATTERN_TYPE.search(type_str)
if not m:
continue
type_ = (m.group('type') or '').lower()
len_ = m.group('len')
if not len_:
f_len = None
else:
f_len = int(len_)
f_type = str
if type_ in ('int', 'smallint', 'tinyint'):
f_type = int
elif type_ in ('datetime', 'timestamp'):
f_type = datetime
elif type_ in ('date', ):
f_type = date
fields.append((name, f_type, f_len))
except Exception as e: # pragma: no cover
logger.error('get fields from %s failed: %s', table_name, str(e))
return fields
def get_index_rows(self, table_name):
if table_name not in self._index_rows_mapping:
try:
tables = self.get_tables()
if table_name not in tables:
return []
with self.transaction():
c = self.get_cursor()
c.execute('SHOW INDEX FROM `{}`'.format(table_name))
self._index_rows_mapping[table_name] = c.fetchall()
except Exception: # pragma: no cover
return [] # pragma: no cover
return self._index_rows_mapping[table_name]
def gen_tables_schemas(self):
asts = self.to_db_types_sql_asts() + self.to_db_table_schema_sql_asts(
) + self.to_db_indexes_sql_asts()
for ast in asts:
yield self.ast_translator.translate(ast)
# return self.ast_translator.translate(['PROGN'] + asts)[0]
def to_db_indexes_sql_asts(self) -> List[AST]:
asts = []
for model in self._models:
for key in reduce_indexes(model.__index_keys__):
key_name = 'idx_' + '_'.join(map(to_camel_case, key))
names = []
for p in key:
f = getattr(model, p)
if not isinstance(f, BaseField):
break # pragma: no cover
names.append(f.name)
else:
if not names:
continue
asts.append([
'CREATE_INDEX', True, key_name,
model._get_table_name(), names
])
return asts
def to_db_types_sql_asts(self) -> List[AST]:
return []
@classmethod
def _get_field_type_params(cls, f: BaseField) -> Tuple:
return f.type, f.length, f.charset, f.default, f.noneable, f.auto_increment, f.deparse
def to_db_table_schema_sql_asts(self) -> List[AST]:
exist_table_names = self.get_tables()
asts = [
self._to_db_table_schema_sql_ast(m) for m in self._models
if m._get_table_name() not in exist_table_names
]
for m in self._models:
table_name = m._get_table_name()
if table_name not in exist_table_names:
continue
exist_fields = self.get_fields(table_name)
exist_fields_mapping = {field[0]: field for field in exist_fields}
for attr_name in m.__ordered_field_attr_names__:
f: BaseField = getattr(m, attr_name)
if f.name not in exist_fields_mapping:
asts.append(['ADD_FIELD', table_name, f.name] +
list(self._get_field_type_params(f)))
continue
exist_field = exist_fields_mapping[f.name]
if f.type is str and exist_field[2] != f.length:
asts.append(['MODIFY_FIELD', table_name, f.name] +
list(self._get_field_type_params(f)))
return asts
@classmethod
def _to_db_table_schema_sql_ast(cls, model: Model) -> AST:
# pylint: disable=too-many-statements
ast = ['CREATE_TABLE', False, True, model._get_table_name()]
create_definition_ast = ['CREATE_DEFINITION']
for k in model.__sorted_fields__:
f = getattr(model, k)
f_schema_ast = ['FIELD', f.name] + list(
cls._get_field_type_params(f))
create_definition_ast.append(f_schema_ast)
create_definition_ast.append(
['KEY', 'PRIMARY', None,
list(model.__primary_key__)])
for key in model.__unique_keys__:
key_name = 'uk_' + '_'.join(map(to_camel_case, key))
names = []
for p in key:
f = getattr(model, p)
if not isinstance(f, BaseField):
break # pragma: no cover
names.append(f.name)
else:
if not names:
continue # pragma: no cover
create_definition_ast.append(
['KEY', 'UNIQUE', key_name, names])
ast.append(create_definition_ast)
table_options_ast = ['TABLE_OPTIONS']
if model._options.table_engine is not None:
table_options_ast.append(['ENGINE', model._options.table_engine])
if model._options.table_charset is not None:
table_options_ast.append(
['DEFAULT CHARSET', model._options.table_charset])
ast.append(table_options_ast)
return ast
def create_all(self):
with self.transaction():
for sql, params in self.gen_tables_schemas():
try:
self.sql_execute(sql, params)
except Exception as e:
logger.error('cannot execute sql: %s with %s: %s', sql,
params, e)
raise
def register_model(self, model_cls):
self._models.append(model_cls)
def log(self, sql, params=None, level=logging.INFO):
if not self.enable_log:
return
cur = self.get_cursor()
cur.log(sql, params=params, level=level)
def beansdb_log(self, cmd, args, kwargs, level=logging.INFO):
if not self.enable_log:
return
def mapper(x):
if isinstance(x, str_types):
return x
try:
return json.dumps(x)
except Exception:
return '<UNKNOWN>'
msg = '[BEANSDB]: {} {}'.format(cmd, ' '.join(map(mapper, args)))
logger.log(msg=msg, level=level)
@property
def autocommit(self):
return self._local._autocommit
@autocommit.setter
def autocommit(self, autommit):
self._local._autocommit = autommit
def begin(self):
pass
def get_cursor(self) -> OLOCursor:
raise NotImplementedError
def sql_execute(self, sql, params=None, **kwargs): # pylint: disable=W
cmd = None
try:
cmd, _ = parse_execute_sql(sql)
except Exception: # pragma: no cover pylint: disable=W
pass # pragma: no cover
cur = self.get_cursor()
res = cur.execute(sql, params, **kwargs)
self.modified_cursors.put_nowait(cur)
if cmd == 'select':
return cur.fetchall()
cur.is_modified = True
if (not kwargs.get('executemany') and cmd == 'insert'):
last_rowid = cur.get_last_rowid()
if last_rowid:
return last_rowid
return res
def sql_commit(self):
first_err = None
commited = set()
while not self.modified_cursors.empty():
try:
cur = self.modified_cursors.get_nowait()
try:
if cur.conn not in commited:
commited.add(cur.conn)
cur.conn.commit()
self.log('COMMIT')
cur.is_modified = False
except Exception as e: # pragma: no cover pylint: disable=W
if first_err is None: # pragma: no cover
first_err = e # pragma: no cover
except Empty: # pragma: no cover
pass # pragma: no cover
if first_err is not None:
raise first_err # pragma: no cover pylint: disable=E
def sql_rollback(self):
first_err = None
rollbacked = set()
while not self.modified_cursors.empty():
try:
cur = self.modified_cursors.get_nowait()
try:
if cur.conn not in rollbacked:
rollbacked.add(cur.conn)
cur.conn.rollback()
self.log('ROLLBACK')
cur.is_modified = False
except Exception as e: # pragma: no cover pylint: disable=W
if first_err is None: # pragma: no cover
first_err = e # pragma: no cover
except Empty: # pragma: no cover
pass # pragma: no cover
if first_err is not None:
raise first_err # pragma: no cover pylint: disable=E
def ast_execute(self, sql_ast):
sql, params = self.ast_translator.translate(sql_ast)
return self.execute(sql, params=params)
def execute(self, sql, params=None):
return self.sql_execute(sql, params)
def commit_beansdb(self):
self._do_beansdb_commands()
def commit(self):
res = self.sql_commit() # pylint: disable=assignment-from-no-return
self.commit_beansdb()
self._run_lazy_funcs()
self._run_commit_handlers()
return res
def rollback(self):
res = self.sql_rollback() # pylint: disable=assignment-from-no-return
self._local.pop_beansdb_transaction()
self._local.clear_lazy_funcs()
self._run_rollback_handlers()
return res
def push_transaction(self, transaction):
self._local._transactions.append(transaction)
def pop_transaction(self):
self._local._transactions.pop()
def cancel_transaction(self):
if not self.in_transaction():
return False
for tran in self._local._transactions:
tran.cancel()
return True
@property
def transaction_depth(self):
return len(self._local._transactions)
def in_transaction(self):
return self.transaction_depth > 0
def get_last_transaction(self):
return self._local._transactions[-1]
def transaction(self):
return Transaction(self)
@need_beansdb
def db_get(self, k, default=None):
return self._beansdb.get(k, default)
@need_beansdb
def db_get_multi(self, ks):
return self._beansdb.get_multi(ks)
@need_beansdb_commit
@need_beansdb
def db_set(self, *args, **kwargs):
self._local.append_beansdb_commands(('set', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_set_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('set_multi', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete_multi', args, kwargs))
def _do_beansdb_commands(self):
if not self._beansdb:
return
while True:
cmds = self._local.shift_beansdb_transaction()
if not cmds:
break
try:
for cmd, args, kwargs in cmds:
func = getattr(self._beansdb, cmd)
func(*args, **kwargs)
self.beansdb_log(cmd, args, kwargs)
except Exception:
self._local.insert_beansdb_commands(*cmds)
break
class BaseDataBase(object):
def __init__(self,
beansdb=None,
autocommit=True,
report=lambda *args, **kwargs: None):
self._beansdb = beansdb
self._local = DbLocal(autocommit=autocommit)
self.report = report
self._tables = None
self._index_rows_mapping = {}
self.enable_log = False
def add_lazy_func(self, func):
self._local.add_lazy_func(func)
def _run_lazy_funcs(self):
while True:
try:
func = self._local._lazy_funcs.popleft()
except IndexError:
return
try:
func()
except Exception:
self.report()
def add_commit_handler(self, handler):
self._local.add_commit_handler(handler)
def _run_commit_handlers(self):
while True:
try:
handler = self._local._commit_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception:
self.report()
def add_rollback_handler(self, handler):
self._local.add_rollback_handler(handler)
def _run_rollback_handlers(self):
while True:
try:
handler = self._local._rollback_handlers.popleft()
except IndexError:
return
try:
handler()
except Exception: # pragma: no cover
self.report() # pragma: no cover
def get_tables(self):
if self._tables is None:
c = self.get_cursor()
try:
c.execute('SHOW TABLES')
self._tables = {t for t, in c}
except Exception: # pragma: no cover
return set() # pragma: no cover
return self._tables
def get_index_rows(self, table_name):
if table_name not in self._index_rows_mapping:
try:
tables = self.get_tables()
if table_name not in tables:
return []
c = self.get_cursor()
c.execute('SHOW INDEX FROM `{}`'.format(table_name))
self._index_rows_mapping[table_name] = c.fetchall()
except Exception: # pragma: no cover
return [] # pragma: no cover
return self._index_rows_mapping[table_name]
def get_cursor(self):
raise NotImplementedError
def log(self, sql, params=None, level=logging.INFO):
if not self.enable_log:
return
cur = self.get_cursor()
log_sql(cur, sql, params=params, level=level)
def beansdb_log(self, cmd, args, kwargs, level=logging.INFO):
if not self.enable_log:
return
def mapper(x):
if isinstance(x, basestring):
return x
try:
return json.dumps(x)
except Exception:
return '<UNKOWN>'
try:
msg = '[BEANSDB]: {} {}'.format(cmd, ' '.join(map(mapper, args)))
logger.log(msg=msg, level=level)
except Exception: # pragma: no cover
pass # pragma: no cover
@property
def autocommit(self):
return self._local._autocommit
@autocommit.setter
def autocommit(self, autommit):
self._local._autocommit = autommit
def begin(self):
pass
def sql_execute(self, sql, params=None):
raise NotImplementedError
def sql_commit(self):
raise NotImplementedError
def sql_rollback(self):
raise NotImplementedError
def execute(self, sql, params=None):
self.log(sql, params)
return self.sql_execute(sql, params)
def commit_beansdb(self):
self._do_beansdb_commands()
def commit(self):
res = self.sql_commit()
self.log('COMMIT')
self.commit_beansdb()
self._run_lazy_funcs()
self._run_commit_handlers()
return res
def rollback(self):
res = self.sql_rollback()
self.log('ROLLBACK')
self._local.pop_beansdb_transaction()
self._local.clear_lazy_funcs()
self._run_rollback_handlers()
return res
def push_transaction(self, transaction):
self._local._transactions.append(transaction)
def pop_transaction(self):
self._local._transactions.pop()
def cancel_transaction(self):
if not self.in_transaction():
return False
for tran in self._local._transactions:
tran.cancel()
return True
@property
def transaction_depth(self):
return len(self._local._transactions)
def in_transaction(self):
return self.transaction_depth > 0
def transaction(self):
return Transaction(self)
@need_beansdb
def db_get(self, k, default=None):
return self._beansdb.get(k, default)
@need_beansdb
def db_get_multi(self, ks):
return self._beansdb.get_multi(ks)
@need_beansdb_commit
@need_beansdb
def db_set(self, *args, **kwargs):
self._local.append_beansdb_commands(('set', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_set_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('set_multi', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete', args, kwargs))
@need_beansdb_commit
@need_beansdb
def db_delete_multi(self, *args, **kwargs):
self._local.append_beansdb_commands(('delete_multi', args, kwargs))
def _do_beansdb_commands(self):
if not self._beansdb:
return
while True:
cmds = self._local.shift_beansdb_transaction()
if not cmds:
break
try:
for cmd, args, kwargs in cmds:
func = getattr(self._beansdb, cmd)
func(*args, **kwargs)
self.beansdb_log(cmd, args, kwargs)
except Exception:
self._local.insert_beansdb_commands(*cmds)
break