/
Matvey_7727
/
Fast_API.pet_project
Обзор
Документация
Войти
/
Matvey_7727
/
Fast_API.pet_project
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
database.py
28 строк
723 B
Matvey_7727
first_commit
18 окт 2024, 18:12
18 окт 2024, 18:12
db25bef
Код
Авторство
О чём код?
from sqlalchemy.ext.asyncio import create_async_engine, async_sessionmaker from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column engine = create_async_engine( "sqlite+aiosqlite:///tasks.db", ) new_session = async_sessionmaker(engine, expire_on_commit=False) class Model(DeclarativeBase): pass class TaskOrm(Model): __tablename__ = "tasks" id: Mapped[int] = mapped_column(primary_key=True) name: Mapped[str] description: Mapped[str | None] async def create_tables(): async with engine.begin() as conn: await conn.run_sync(Model.metadata.create_all) async def delete_tables(): async with engine.begin() as conn: await conn.run_sync(Model.metadata.drop_all)