def setup(): # initialize schema engine = Db.create_engine(echo=False) build_metadata().create_all(engine) # tune auto vacuum/analyze reset_autovac() # default rows sqls = [ "INSERT INTO hive_state (block_num, db_version, steem_per_mvest, usd_per_steem, sbd_per_steem, dgpo) VALUES (0, 3, 0, 0, 0, '')", "INSERT INTO hive_blocks (num, hash, created_at) VALUES (0, '0000000000000000000000000000000000000000', '2016-03-24 16:04:57')", "INSERT INTO hive_accounts (name, created_at) VALUES ('miners', '2016-03-24 16:05:00')", "INSERT INTO hive_accounts (name, created_at) VALUES ('null', '2016-03-24 16:05:00')", "INSERT INTO hive_accounts (name, created_at) VALUES ('temp', '2016-03-24 16:05:00')", "INSERT INTO hive_accounts (name, created_at) VALUES ('initminer', '2016-03-24 16:05:00')" ] for sql in sqls: Db.instance().query(sql)
def teardown(): """Drop all tables""" engine = Db.create_engine(echo=True) metadata = build_metadata() metadata.drop_all(engine)
def teardown(): engine = Db.create_engine(echo=True) metadata = build_metadata() metadata.drop_all(engine)