async def main() -> None:
db = Aerie(DATABASE_URL)
# create tables
await db.schema.drop_tables()
await db.schema.create_tables()
# create some users
async with db.transaction() as tx:
stmt = insert(users).values([
{
'id': 1,
'name': 'One'
},
{
'id': 2,
'name': 'Two'
},
{
'id': 3,
'name': 'Three'
},
])
await tx.execute(stmt)
result = await tx.execute(
text('select * from users where id = :user_id'), {'user_id': 2})
user_id2 = result.one()
print('User with ID 2 has name: %s' % user_id2.name)
# you can read db w/o transaction
user_id3 = await db.execute('select * from users where id = :user_id', {
'user_id': 3
}).one()
print('User with ID 3 has name: %s' % user_id3.name)
async def main() -> None:
db = Aerie(DATABASE_URL)
# create tables
await db.schema.drop_tables()
await db.schema.create_tables()
# create some users
async with db.transaction() as tx:
await tx.execute(
insert(users).values([
{
'id': 1,
'name': 'One'
},
{
'id': 2,
'name': 'Two'
},
{
'id': 3,
'name': 'Three'
},
]))
stmt = select(users).where(users.c.id == 2)
result = await tx.execute(stmt)
user_id2 = result.one()
print('User with ID 2 has name: %s' % user_id2.name)
# you can read db w/o transaction
stmt = select(users).where(users.c.id == 3)
user_id3 = await db.execute(stmt).one()
print('User with ID 3 has name: %s' % user_id3.name)