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())
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())
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)
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()
# 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())