Python Database 예제들

예제 #1

파일: test_postgre.py 프로젝트: YauheniLiubich/Aiogram_TG_bot_like

import asyncio
from utils.db_api.postgresql import Database


async def test():
    await db.create_table_news()
    # await db.add_news(user_id=1, content='Test', photo_id='Test', caption='Test', username='******')
    # await db.add_news(user_id=2, content='Test', photo_id='Test', caption='Test', username='******')
    # await db.add_news(user_id=3, content='Test', photo_id='Test', caption='Test', username='******')
    # await db.add_news(user_id=4, content='Test', photo_id='Test', caption='Test', username='******')
    # news = await db.select_all_news()
    # print(news[0])
    news = await db.select_one_news(id=2)
    print(news)


loop = asyncio.get_event_loop()
db = Database(loop)

loop.run_until_complete(test())

예제 #2

import asyncio

from utils.db_api.postgresql import Database


async def setup_psql():
    await db.create()


loop = asyncio.get_event_loop()
db = Database()

loop.run_until_complete(db.select_all_users())

예제 #3

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

from data import config
from utils.db_api.postgresql import Database

bot = Bot(token=config.BOT_TOKEN, parse_mode=types.ParseMode.HTML)
storage = MemoryStorage()
dp = Dispatcher(bot, storage=storage)
db = Database(loop=dp.loop)

예제 #4

파일: loader.py 프로젝트: Amantais/DeathNoteBot

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

from data import config
from utils.db_api.postgresql import Database, DatabaseNote

bot = Bot(token=config.BOT_TOKEN, parse_mode=types.ParseMode.HTML)
storage = MemoryStorage()
dp = Dispatcher(bot, storage=storage)
db = Database()
db_note = DatabaseNote()

예제 #5

    # import datetime
    # current_datetime = await db.test()
    # current_datetime2 = await db.test2()
    # print(current_datetime.minute)
    # print(current_datetime2)
    # print(current_datetime2 == current_datetime)

    # print(learning_translates[0][2].year)
    # print(datetime.date.today())
    # print(learning_translates[0][2] == datetime.date)

    # await db.set_learning_translate(129, 26)

    # translates = await db.learning_translates(131)
    # translate_values = [x[0] for x in translates]
    # print(random.choice(translate_values))

    # repetition_number = await db.check_repition_number(41)
    # print(repetition_number)

    # translate = await db.translate_info(40)
    # print(translate)

    print("Success!")


loop = asyncio.get_event_loop()
db = loop.run_until_complete(Database.create())
loop.run_until_complete(test())