/
Revanshiest
/
Forms
Обзор
Документация
Войти
/
Revanshiest
/
Forms
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
database.py
35 строк
1 KB
Revanshiest
feat: full project
26 апр 2026, 04:11
26 апр 2026, 04:11
863d74d
Код
Авторство
О чём код?
from sqlalchemy import create_engine, Column, Integer, String, ForeignKey, JSON from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import sessionmaker, Session SQLALCHEMY_DATABASE_URL = "sqlite:///./sql_app.db" engine = create_engine(SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False}) SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) Base = declarative_base() class User(Base): __tablename__ = "users" id = Column(Integer, primary_key=True, index=True) username = Column(String, unique=True, index=True) hashed_password = Column(String) class Form(Base): __tablename__ = "forms" id = Column(Integer, primary_key=True, index=True) title = Column(String) owner_id = Column(Integer, ForeignKey("users.id")) fields = Column(JSON) class FormResponse(Base): __tablename__ = "responses" id = Column(Integer, primary_key=True, index=True) form_id = Column(Integer, ForeignKey("forms.id")) answer_data = Column(JSON) def get_db(): db = SessionLocal() try: yield db finally: db.close()