def _init():
global _initted
if _initted:
return
_initted = True
global _metadata
global _tables
_metadata = sa.MetaData()
_tables = init_tables(_metadata)
def __init__(self, engine, pool):
self.indexes = []
self.engine = engine
self.pool = pool
self.metadata = sa.MetaData(engine)
self.inspector = reflection.Inspector.from_engine(engine)
self.tables = {}
self.aux_tables = {}
self.files_tables = {}
self._resources_by_path = {}
self.schema = {}
def test_5():
metadata = sa.MetaData()
tbl = sa.Table('sensor_values_t', metadata,
sa.Column('id', sa.BigInteger, primary_key=True),
sa.Column('key', sa.String(50)))
async def go():
async with aiopg.sa.create_engine(dsn) as engine:
async with engine.acquire() as conn:
await conn.execute("TRUNCATE TABLE foglamp.sensor_values_t;")
for idx in range(0, ROWS_COUNT):
await conn.execute(
tbl.insert().values(key=id_generator(10)))
loop = asyncio.get_event_loop()
loop.run_until_complete(go())
def metadata() -> sa.MetaData:
result = sa.MetaData()
sa.Table(
'AccountRolesLog', result,
sa.Column('id',
sa.Integer,
index=True,
nullable=False,
primary_key=True),
sa.Column('created_at',
sa.DateTime,
server_default=sa_functions.now(),
index=True,
nullable=False),
sa.Column('created_by', sa.Unicode, index=True, nullable=False),
sa.Column('request_info', sa.UnicodeText, nullable=None),
sa.Column('account_id', sa.String, index=True, nullable=False),
sa.Column('action', sa.String(1), index=True, nullable=False),
sa.Column('role_ids', postgresql.ARRAY(sa.String(32)), nullable=False),
sa.Index('idx_arl_role_ids', 'role_ids', postgresql_using='gin'))
sa.Table(
'AccountRoles', result,
sa.Column('account_id',
sa.String,
index=True,
nullable=False,
primary_key=True),
sa.Column('role_ids', postgresql.ARRAY(sa.String(32)), nullable=False),
sa.Column('log_id',
sa.Integer,
sa.ForeignKey('AccountRolesLog.id'),
index=True,
nullable=False,
unique=True),
sa.Index('idx_ar_role_ids', 'role_ids', postgresql_using='gin'))
return result
async def get_db(dsn: str, **engine_kwargs) -> aiopg.sa.Engine:
engine = sa.create_engine(dsn)
meta = sa.MetaData()
order_table = sa.Table('orders', meta, autoload=True, autoload_with=engine)
trade_history_table = sa.Table('trade_history',
meta,
autoload=True,
autoload_with=engine)
order_pairs = sa.Table('order_pairs',
meta,
autoload=True,
autoload_with=engine)
engine.dispose()
async_engine = await aiopg.sa.create_engine(dsn=dsn, **engine_kwargs)
async_engine.meta = meta
async_engine.tables = {
'orders': order_table,
'trade_history': trade_history_table,
'order_pairs': order_pairs,
}
return async_engine
def test_2():
metadata = sa.MetaData()
tbl = sa.Table('sensor_values_t', metadata,
sa.Column('id', sa.BigInteger, primary_key=True),
sa.Column('key', sa.String(50)))
async def go():
async with aiopg.sa.create_engine(dsn) as engine:
async with engine.acquire() as conn:
await conn.execute(tbl.insert().values(key=id_generator(10)))
# !F!
print("DBG 1")
#async for row in conn.execute(tbl.select().where(tbl.c.key=='9f2acad687df4ae7b7faeef8affdd0a9') ):
async for row in conn.execute(
tbl.select().where(tbl.c.key == '6b110c8ca02')):
print(row.id, row.key)
print("DBG 2")
loop = asyncio.get_event_loop()
loop.run_until_complete(go())
import aiopg.sa
import sqlalchemy as sa
from aiohttp.web import Application
from .settings import config
METADATA = sa.MetaData()
image = sa.Table(
"image",
METADATA,
sa.Column("id", sa.Integer(), primary_key=True),
sa.Column("origin", sa.String(), nullable=False, unique=True),
sa.Column("url_big", sa.String(), nullable=False),
sa.Column("url_thumb", sa.String(), nullable=False),
sa.Column(
"indexed_at",
sa.DateTime(),
nullable=False,
server_default=sa.text("(now() at time zone 'utc')"),
),
)
image_color = sa.Table(
"image_color",
METADATA,
sa.Column("id", sa.Integer(), primary_key=True),
sa.Column("image_id",
sa.Integer(),
sa.ForeignKey("image.id"),
nullable=False),
import aiopg.sa
import sqlalchemy as sa
from sanic_study.main import app
meta = sa.MetaData()
question = sa.Table(
'question', meta,
sa.Column('id', sa.Integer, nullable=False),
sa.Column('question_text', sa.String(200), nullable=False),
sa.Column('pub_date', sa.Date, nullable=False),
sa.PrimaryKeyConstraint('id', name='question_id_pkey')
)
choice = sa.Table(
'choice', meta,
sa.Column('id', sa.Integer, nullable=False),
sa.Column('question_id', sa.Integer, nullable=False),
sa.Column('choice_text', sa.String(200), nullable=False),
sa.Column('votes', sa.Integer, server_default="0", nullable=False),
sa.PrimaryKeyConstraint('id', name='choice_id_pkey'),
sa.ForeignKeyConstraint(['question_id'], [question.c.id],
name='choice_question_id_fkey',
ondelete='CASCADE')
)
async def init_pg(app):
def create_tables():
engine = get_sa_engine()
metadata = sa.MetaData()
init_tables(metadata)
metadata.create_all(engine)
