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)
