def check_db_version(): import db from utils.log import log, log_colors setup_message = """ Your database is not set up. Please run: docker-compose run api python bin/db_reset.py """ migrate_message = """ You're running an old version of the database. Please run this command to get the latest: docker-compose run api python bin/db_migrate.py """ version = db.version() latest_version = 0 # will come from the migrate module if version == -1: log(setup_message, color=log_colors.FAIL, dedent=True) sys.exit(1) elif version < latest_version: log(migrate_message, color=log_colors.FAIL, dedent=True) sys.exit(1) else: log('DB structure OK')
class DBEnv: def __init__(self, *args, **kwargs): self._cobj = apply(db.DBEnv, args, kwargs) def close(self, *args, **kwargs): return apply(self._cobj.close, args, kwargs) def open(self, *args, **kwargs): return apply(self._cobj.open, args, kwargs) def remove(self, *args, **kwargs): return apply(self._cobj.remove, args, kwargs) def set_shm_key(self, *args, **kwargs): return apply(self._cobj.set_shm_key, args, kwargs) def set_cachesize(self, *args, **kwargs): return apply(self._cobj.set_cachesize, args, kwargs) def set_data_dir(self, *args, **kwargs): return apply(self._cobj.set_data_dir, args, kwargs) def set_flags(self, *args, **kwargs): return apply(self._cobj.set_flags, args, kwargs) def set_lg_bsize(self, *args, **kwargs): return apply(self._cobj.set_lg_bsize, args, kwargs) def set_lg_dir(self, *args, **kwargs): return apply(self._cobj.set_lg_dir, args, kwargs) def set_lg_max(self, *args, **kwargs): return apply(self._cobj.set_lg_max, args, kwargs) def set_lk_detect(self, *args, **kwargs): return apply(self._cobj.set_lk_detect, args, kwargs) def set_lk_max(self, *args, **kwargs): return apply(self._cobj.set_lk_max, args, kwargs) def set_lk_max_locks(self, *args, **kwargs): return apply(self._cobj.set_lk_max_locks, args, kwargs) def set_lk_max_lockers(self, *args, **kwargs): return apply(self._cobj.set_lk_max_lockers, args, kwargs) def set_lk_max_objects(self, *args, **kwargs): return apply(self._cobj.set_lk_max_objects, args, kwargs) def set_mp_mmapsize(self, *args, **kwargs): return apply(self._cobj.set_mp_mmapsize, args, kwargs) def set_timeout(self, *args, **kwargs): return apply(self._cobj.set_timeout, args, kwargs) def set_tmp_dir(self, *args, **kwargs): return apply(self._cobj.set_tmp_dir, args, kwargs) def txn_begin(self, *args, **kwargs): return apply(self._cobj.txn_begin, args, kwargs) def txn_checkpoint(self, *args, **kwargs): return apply(self._cobj.txn_checkpoint, args, kwargs) def txn_stat(self, *args, **kwargs): return apply(self._cobj.txn_stat, args, kwargs) def set_tx_max(self, *args, **kwargs): return apply(self._cobj.set_tx_max, args, kwargs) def lock_detect(self, *args, **kwargs): return apply(self._cobj.lock_detect, args, kwargs) def lock_get(self, *args, **kwargs): return apply(self._cobj.lock_get, args, kwargs) def lock_id(self, *args, **kwargs): return apply(self._cobj.lock_id, args, kwargs) def lock_put(self, *args, **kwargs): return apply(self._cobj.lock_put, args, kwargs) def lock_stat(self, *args, **kwargs): return apply(self._cobj.lock_stat, args, kwargs) def log_archive(self, *args, **kwargs): return apply(self._cobj.log_archive, args, kwargs) def set_get_returns_none(self, *args, **kwargs): return apply(self._cobj.set_get_returns_none, args, kwargs) if db.version() >= (4, 1): def dbremove(self, *args, **kwargs): return apply(self._cobj.dbremove, args, kwargs) def dbrename(self, *args, **kwargs): return apply(self._cobj.dbrename, args, kwargs) def set_encrypt(self, *args, **kwargs): return apply(self._cobj.set_encrypt, args, kwargs)
class DB(DictMixin): def __init__(self, dbenv, *args, **kwargs): # give it the proper DBEnv C object that its expecting self._cobj = apply(db.DB, (dbenv._cobj, ) + args, kwargs) # TODO are there other dict methods that need to be overridden? def __len__(self): return len(self._cobj) def __getitem__(self, arg): return self._cobj[arg] def __setitem__(self, key, value): self._cobj[key] = value def __delitem__(self, arg): del self._cobj[arg] def append(self, *args, **kwargs): return apply(self._cobj.append, args, kwargs) def associate(self, *args, **kwargs): return apply(self._cobj.associate, args, kwargs) def close(self, *args, **kwargs): return apply(self._cobj.close, args, kwargs) def consume(self, *args, **kwargs): return apply(self._cobj.consume, args, kwargs) def consume_wait(self, *args, **kwargs): return apply(self._cobj.consume_wait, args, kwargs) def cursor(self, *args, **kwargs): return apply(self._cobj.cursor, args, kwargs) def delete(self, *args, **kwargs): return apply(self._cobj.delete, args, kwargs) def fd(self, *args, **kwargs): return apply(self._cobj.fd, args, kwargs) def get(self, *args, **kwargs): return apply(self._cobj.get, args, kwargs) def pget(self, *args, **kwargs): return apply(self._cobj.pget, args, kwargs) def get_both(self, *args, **kwargs): return apply(self._cobj.get_both, args, kwargs) def get_byteswapped(self, *args, **kwargs): return apply(self._cobj.get_byteswapped, args, kwargs) def get_size(self, *args, **kwargs): return apply(self._cobj.get_size, args, kwargs) def get_type(self, *args, **kwargs): return apply(self._cobj.get_type, args, kwargs) def join(self, *args, **kwargs): return apply(self._cobj.join, args, kwargs) def key_range(self, *args, **kwargs): return apply(self._cobj.key_range, args, kwargs) def has_key(self, *args, **kwargs): return apply(self._cobj.has_key, args, kwargs) def items(self, *args, **kwargs): return apply(self._cobj.items, args, kwargs) def keys(self, *args, **kwargs): return apply(self._cobj.keys, args, kwargs) def open(self, *args, **kwargs): return apply(self._cobj.open, args, kwargs) def put(self, *args, **kwargs): return apply(self._cobj.put, args, kwargs) def remove(self, *args, **kwargs): return apply(self._cobj.remove, args, kwargs) def rename(self, *args, **kwargs): return apply(self._cobj.rename, args, kwargs) def set_bt_minkey(self, *args, **kwargs): return apply(self._cobj.set_bt_minkey, args, kwargs) def set_cachesize(self, *args, **kwargs): return apply(self._cobj.set_cachesize, args, kwargs) def set_flags(self, *args, **kwargs): return apply(self._cobj.set_flags, args, kwargs) def set_h_ffactor(self, *args, **kwargs): return apply(self._cobj.set_h_ffactor, args, kwargs) def set_h_nelem(self, *args, **kwargs): return apply(self._cobj.set_h_nelem, args, kwargs) def set_lorder(self, *args, **kwargs): return apply(self._cobj.set_lorder, args, kwargs) def set_pagesize(self, *args, **kwargs): return apply(self._cobj.set_pagesize, args, kwargs) def set_re_delim(self, *args, **kwargs): return apply(self._cobj.set_re_delim, args, kwargs) def set_re_len(self, *args, **kwargs): return apply(self._cobj.set_re_len, args, kwargs) def set_re_pad(self, *args, **kwargs): return apply(self._cobj.set_re_pad, args, kwargs) def set_re_source(self, *args, **kwargs): return apply(self._cobj.set_re_source, args, kwargs) def set_q_extentsize(self, *args, **kwargs): return apply(self._cobj.set_q_extentsize, args, kwargs) def stat(self, *args, **kwargs): return apply(self._cobj.stat, args, kwargs) def sync(self, *args, **kwargs): return apply(self._cobj.sync, args, kwargs) def type(self, *args, **kwargs): return apply(self._cobj.type, args, kwargs) def upgrade(self, *args, **kwargs): return apply(self._cobj.upgrade, args, kwargs) def values(self, *args, **kwargs): return apply(self._cobj.values, args, kwargs) def verify(self, *args, **kwargs): return apply(self._cobj.verify, args, kwargs) def set_get_returns_none(self, *args, **kwargs): return apply(self._cobj.set_get_returns_none, args, kwargs) if db.version() >= (4, 1): def set_encrypt(self, *args, **kwargs): return apply(self._cobj.set_encrypt, args, kwargs)
class DBEnv: def __init__(self, *args, **kwargs): self._cobj = db.DBEnv(*args, **kwargs) def close(self, *args, **kwargs): return self._cobj.close(*args, **kwargs) def open(self, *args, **kwargs): return self._cobj.open(*args, **kwargs) def remove(self, *args, **kwargs): return self._cobj.remove(*args, **kwargs) def set_shm_key(self, *args, **kwargs): return self._cobj.set_shm_key(*args, **kwargs) def set_cachesize(self, *args, **kwargs): return self._cobj.set_cachesize(*args, **kwargs) def set_data_dir(self, *args, **kwargs): return self._cobj.set_data_dir(*args, **kwargs) def set_flags(self, *args, **kwargs): return self._cobj.set_flags(*args, **kwargs) def set_lg_bsize(self, *args, **kwargs): return self._cobj.set_lg_bsize(*args, **kwargs) def set_lg_dir(self, *args, **kwargs): return self._cobj.set_lg_dir(*args, **kwargs) def set_lg_max(self, *args, **kwargs): return self._cobj.set_lg_max(*args, **kwargs) def set_lk_detect(self, *args, **kwargs): return self._cobj.set_lk_detect(*args, **kwargs) if db.version() < (4, 5): def set_lk_max(self, *args, **kwargs): return self._cobj.set_lk_max(*args, **kwargs) def set_lk_max_locks(self, *args, **kwargs): return self._cobj.set_lk_max_locks(*args, **kwargs) def set_lk_max_lockers(self, *args, **kwargs): return self._cobj.set_lk_max_lockers(*args, **kwargs) def set_lk_max_objects(self, *args, **kwargs): return self._cobj.set_lk_max_objects(*args, **kwargs) def set_mp_mmapsize(self, *args, **kwargs): return self._cobj.set_mp_mmapsize(*args, **kwargs) def set_timeout(self, *args, **kwargs): return self._cobj.set_timeout(*args, **kwargs) def set_tmp_dir(self, *args, **kwargs): return self._cobj.set_tmp_dir(*args, **kwargs) def txn_begin(self, *args, **kwargs): return self._cobj.txn_begin(*args, **kwargs) def txn_checkpoint(self, *args, **kwargs): return self._cobj.txn_checkpoint(*args, **kwargs) def txn_stat(self, *args, **kwargs): return self._cobj.txn_stat(*args, **kwargs) def set_tx_max(self, *args, **kwargs): return self._cobj.set_tx_max(*args, **kwargs) def set_tx_timestamp(self, *args, **kwargs): return self._cobj.set_tx_timestamp(*args, **kwargs) def lock_detect(self, *args, **kwargs): return self._cobj.lock_detect(*args, **kwargs) def lock_get(self, *args, **kwargs): return self._cobj.lock_get(*args, **kwargs) def lock_id(self, *args, **kwargs): return self._cobj.lock_id(*args, **kwargs) def lock_put(self, *args, **kwargs): return self._cobj.lock_put(*args, **kwargs) def lock_stat(self, *args, **kwargs): return self._cobj.lock_stat(*args, **kwargs) def log_archive(self, *args, **kwargs): return self._cobj.log_archive(*args, **kwargs) def set_get_returns_none(self, *args, **kwargs): return self._cobj.set_get_returns_none(*args, **kwargs) def log_stat(self, *args, **kwargs): return self._cobj.log_stat(*args, **kwargs) def dbremove(self, *args, **kwargs): return self._cobj.dbremove(*args, **kwargs) def dbrename(self, *args, **kwargs): return self._cobj.dbrename(*args, **kwargs) def set_encrypt(self, *args, **kwargs): return self._cobj.set_encrypt(*args, **kwargs) if db.version() >= (4, 4): def fileid_reset(self, *args, **kwargs): return self._cobj.fileid_reset(*args, **kwargs) def lsn_reset(self, *args, **kwargs): return self._cobj.lsn_reset(*args, **kwargs)
import db # create conncetion object conn = db.connect('test.db') db.version(conn) # insert statement query = "INSERT INTO student (name,rollnumber,age) VALUES ('Suresh',1004,29)" db.insert(conn, query) # select multiple records query = "SELECT * from student" result = db.fetchall(conn, query) for r in result: print(r) # select one record query = "SELECT * from student where id = 1" result = db.fetchone(conn, query) print(result) # update a record query = "UPDATE student SET age=30 WHERE id=2" db.update(conn, query) # delete a record query = "DELETE from student WHERE id = 3" db.delete(conn, query) # close connection db.close(conn)
def test_version(self): version = db.version() assert isinstance(version, int)