logging.basicConfig(level=logging.INFO, format="%(name)s - %(levelname)s - %(message)s")
logger = logging.getLogger(__name__)
from asyncdb import AsyncDB, AsyncPool
from asyncdb.exceptions import NoDataFound, ProviderError
from asyncdb.providers.redis import redis, redisPool
redis_url = "redis://localhost:6379/3"
rd = AsyncPool("redis", dsn=redis_url, loop=loop)
# rd = redisPool(dsn=redis_url, loop=loop)
loop.run_until_complete(rd.connect())
ot = AsyncDB('redis', dsn=redis_url, loop=loop)
loop.run_until_complete(ot.connection())
async def test_redis(conn):
await conn.execute("set", "Test1", "UltraTest")
await conn.set("Test2", "No More Test")
if await conn.exists("Test1", "Test2"):
value = await conn.get("Test1")
print(value)
await conn.setex("Test3", "Expiration Data", 10)
await conn.persist("Test3")
value = await conn.get("Test3")
print(value)
user = {
"Name": "Pradeep",
"port": "3306",
"database": "test",
"DEBUG": True,
}
# With mysqlPool
pool = mysqlPool(loop=loop, params=params)
loop.run_until_complete(pool.connect())
db = loop.run_until_complete(pool.acquire())
conn = db.get_connection()
loop.run_until_complete(pool.release())
pool.terminate()
# With AsyncDB
pool = AsyncDB("mysql", loop=loop, params=params)
conn = loop.run_until_complete(pool.connection())
cursor = loop.run_until_complete(pool.cursor())
result, error = loop.run_until_complete(pool.execute("TRUNCATE TABLE color"))
print("-- execute", result)
data = [
("Red", "#ff0000"),
("Green", "#00ff00"),
("Blue", "#0000ff"),
("Cyan", "#00ffff"),
("Magenta", "#ff00ff"),
("Yellow", "#ffff00"),
("Black", "#000000"),
("White", "#ffffff"),
]
"database": "navigator_dev",
"DEBUG": True,
}
# pool = AsyncPool('pg', loop=loop, params=params)
pool = pgPool(loop=loop, params=params)
loop.run_until_complete(pool.connect())
db = loop.run_until_complete(pool.acquire())
loop.run_until_complete(pool.release(connection=db.get_connection()))
pool.terminate()
# running new multi-threaded async SA (using aiopg)
args = {"server_settings": {"application_name": "Testing"}}
p = AsyncDB("pg", params=params, **args)
loop.run_until_complete(p.connection())
sql = "SELECT * FROM troc.query_util WHERE query_slug = '{}'".format(
"walmart_stores")
result, error = loop.run_until_complete(p.query(sql))
print(result)
async def cursor(d):
async for record in await d.cursor(
"SELECT store_id, store_name FROM walmart.stores"):
print(record)
loop.run_until_complete(cursor(p))
