async def insertdb(database_uri, titles): async with asyncpgsa.create_pool(dsn=database_uri) as conn: for tit in titles: slug = slugify(tit) query = f"insert into game(title, slug, platform_id) values ('{tit}', '{slug}', '1');" # print(tit, '+++', slug) await conn.execute(query)
def pool(event_loop): _pool = event_loop.run_until_complete(asyncpgsa.create_pool(host=HOST, port=PORT, database='postgres', user=USER, password=PASS, min_size=1, max_size=10)) yield _pool
def pool(event_loop): _pool = event_loop.run_until_complete( asyncpgsa.create_pool(host=HOST, port=PORT, database='postgres', user=USER, password=PASS, min_size=1, max_size=10)) yield _pool
async def main(): titles = await parse_csv(csv_file) async with asyncpgsa.create_pool(dsn=database_uri) as conn: for tit in titles: print(tit) img = (static + '/' + tit + '.jpg') slug = slugify(tit) query = """insert into game_xbox360(title, slug, image, platform_id) values ($1, $2, $3, '1');""" print(query) await conn.execute(query, tit, slug, img)
async def init_db(config): async with pg.create_pool( host=str(config.db_addr[0]), port=config.db_addr[1], user=config.db_user, password=config.db_password, database=config.db_name, min_size=1, max_size=3, ) as pool: if config.drop_tables: await drop_tables(config, pool) if config.create_tables: await create_tables(config, pool) if config.populate_fixtures: await populate_fixtures(config, pool)
def pool(event_loop): from asyncpgsa import create_pool from . import HOST, PORT, USER, PASS, DB_NAME pool = create_pool(min_size=1, max_size=3, host=HOST, port=PORT, user=USER, password=PASS, database=DB_NAME, timeout=1, loop=event_loop) event_loop.run_until_complete(pool) try: yield pool finally: event_loop.run_until_complete(pool.close())
def pool(event_loop): from asyncpgsa import create_pool from . import HOST, PORT, USER, PASS, DB_NAME pool = create_pool( min_size=1, max_size=3, host=HOST, port=PORT, user=USER, password=PASS, database=DB_NAME, timeout=1, loop=event_loop ) event_loop.run_until_complete(pool) try: yield pool finally: event_loop.run_until_complete(pool.close())
async def cleanup_ctx_databases(app, cfg_key='default', app_key='db'): import asyncpgsa from dvhb_hybrid.amodels import AppModels app.models = app.m = AppModels(app) async def init(connection): for t in ['json', 'jsonb']: await connection.set_type_codec( t, encoder=lambda x: x, decoder=json.loads, schema='pg_catalog', ) dbparams = app.context.config.databases.get(cfg_key) if 'uri' in dbparams: dbargs, dbkwargs = (dbparams.uri, ), {} else: dbargs, dbkwargs = (), dbparams async with asyncpgsa.create_pool(*dbargs, init=init, **dbkwargs) as pool: app[app_key] = pool yield