async def test_create_table(db: DatabaseInterface):
async with db.get_ddl_session() as sess:
await sess.create_table(
table_name, Column.with_name("id", Integer(), primary_key=True),
Column.with_name("name", String(128)),
Column.with_name("balance", Real()))
async with db.get_session() as sess:
assert await sess.fetch("select * from {}".format(table_name)) is None
async def test_add_column(db: DatabaseInterface):
async with db.get_ddl_session() as sess:
await sess.add_column(table_name, Column.with_name("age", Integer()))
assert await get_num_columns(db) == 4