Python create_pool Examples

Example #1

class DatabaseManager:
    cur: Connection = asyncio.get_event_loop().run_until_complete(
        create_pool())

    async def query(self, arg, values=None):
        try:
            if values == None:
                await self.cur.execute(arg)
            else:
                await self.cur.execute(arg, *values)
        except UniqueViolationError:
            pass

    async def fetchone(self, arg, values=None):
        try:
            if values == None:
                row = await self.cur.fetchrow(arg)
            else:
                row = await self.cur.fetchrow(arg, *values)
            return row
        except UniqueViolationError:
            pass

    async def fetchall(self, arg, values=None):
        try:
            if values == None:
                row = await self.cur.fetch(arg)
            else:
                row = await self.cur.fetch(arg, *values)
            return row
        except UniqueViolationError:
            pass

Example #2

File: app.py Project: IvanVShakirov/TelegramBot

def main():
    storage = MemoryStorage()

    bot = Bot(token=BOT_TOKEN, parse_mode="HTML", proxy=TELEGRAM_PROXY)
    dp = Dispatcher(bot, storage=storage)
    pool = dp.loop.run_until_complete(create_pool())
    db = DBCommands(pool)

    async def on_shutdown(dp):
        await bot.close()

    async def on_startup(dp):
        await asyncio.sleep(10)
        await create_db()
        await bot.send_message(ADMIN_ID, "Я запущен!")

    reg_handlers(dp, bot, db)

    executor.start_polling(dp, on_shutdown=on_shutdown, on_startup=on_startup)

Example #3

File: app.py Project: Los-shot/awesome-python-webapp

    env = Environment(
        loader = FileSystemLoader(path),
        autoescape = select_autoescape(['html', 'xml'])
    )
    env.filters['datetimeformat'] = datetimeformat

def datetimeformat(value, format='%H:%M / %d-%m-%Y'):
    date = datetime.fromtimestamp(value)
    return date.strftime(format)

def add_static(app):
    PROJECT_PATH = pathlib.Path(__file__).parent
    app.router.add_static('/static/',PROJECT_PATH / 'static')

async def init():
    app = web.Application(middlewares = [logger_factory,auth_factory,response_factory])
    init_jinja2()
    handlerframe.add_routes(app,'handlers')
    add_static(app)
    runner = web.AppRunner(app)
    await runner.setup()
    site = web.TCPSite(runner,'127.0.0.1',9000)
    await site.start()
    logging.info('server start at http://127.0.0.1:9000...')

from config import configs

loop = asyncio.get_event_loop()
tasks = [init(),sql.create_pool(host = configs['db']['host'],user = configs['db']['user'],password = configs['db']['password'],db = configs['db']['database'])]
loop.run_until_complete(asyncio.wait(tasks))
loop.run_forever()

Example #4

import asyncio
import logging

from aiogram import Bot
from aiogram import Dispatcher
from aiogram.contrib.fsm_storage.memory import MemoryStorage

from config import TOKEN
from sql import create_pool

# from aiogram.contrib.fsm_storage.redis import RedisStorage2

logging.basicConfig(
    format=
    u'%(filename)s [LINE:%(lineno)d] #%(levelname)-8s [%(asctime)s]  %(message)s',
    level=logging.INFO)
loop = asyncio.get_event_loop()

# Set up storage (either in Redis or Memory)
storage = MemoryStorage()
# storage = RedisStorage2()

bot = Bot(token=TOKEN, parse_mode="HTML")
dp = Dispatcher(bot, storage=storage)

bot.db = loop.run_until_complete(create_pool())

Example #5

import asyncio
import logging

from aiogram import Bot
from aiogram import Dispatcher
from aiogram.contrib.fsm_storage.memory import MemoryStorage

from config import TOKEN
from sql import create_pool, create_db

# from aiogram.contrib.fsm_storage.redis import RedisStorage2

logging.basicConfig(
    format=
    u'%(filename)s [LINE:%(lineno)d] #%(levelname)-8s [%(asctime)s]  %(message)s',
    level=logging.INFO)
# loop = asyncio.get_event_loop()
# Поток нам не нужен, т.к. он и так создается в диспатчере.

# Set up storage (either in Redis or Memory)
storage = MemoryStorage()
# storage = RedisStorage2()

bot = Bot(token=TOKEN, parse_mode="HTML")
dp = Dispatcher(bot, storage=storage)

db = dp.loop.run_until_complete(create_pool())