import sqlalchemy as sa
from aiopg.sa import create_engine

metadata=sa.MetaData()
tbl=sa.Table(
        'tbl',
        metadata,
        sa.Column('id', sa.Integer, primary_key=True),
        sa.Column('val', sa.String(255))
)

app=web.Application()

app['db'] = yield from create_engine()