models.py - main - alpa26/CookIt

models.py
61 строка2 KB
alpa26
add recepts func
17 окт 2025, 12:20
17 окт 2025, 12:2035a3eb6
from sqlalchemy import Column, Integer, String, Text, ForeignKey, DateTime, BigInteger
from sqlalchemy.orm import relationship
from datetime import datetime
from database import Base

class User(Base):
    __tablename__ = "users"

    id = Column(Integer, primary_key=True)
    google_id = Column(String, unique=True, index=True)
    email = Column(String, unique=True, index=True)
    name = Column(String)
    avatar_url = Column(String)
    created_at = Column(DateTime, default=datetime.utcnow)

    recipes = relationship("Recipe", back_populates="author")
    favorites = relationship("Favorite", back_populates="user")


class Recipe(Base):
    __tablename__ = "recipes"

    id = Column(Integer, primary_key=True)
    title = Column(String)
    description = Column(Text)
    image_url = Column(String)
    created_at = Column(DateTime, default=datetime.utcnow)

    created_by = Column(Integer, ForeignKey("users.id"))
    author = relationship("User", back_populates="recipes")

    favorited_by = relationship("Favorite", back_populates="recipe")


class Favorite(Base):
    __tablename__ = "favorites"

    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey("users.id"))
    recipe_id = Column(Integer, ForeignKey("recipes.id"))
    created_at = Column(DateTime, default=datetime.utcnow)

    user = relationship("User", back_populates="favorites")
    recipe = relationship("Recipe", back_populates="favorited_by")

class KukingCategory(Base):
    __tablename__ = "kuking_category"

    id_category = Column(BigInteger, primary_key=True, index=True)
    category_name = Column(String(45), nullable=False)


class KukingRecept(Base):
    __tablename__ = "kuking_recepts"

    id_recepts = Column(BigInteger, primary_key=True, index=True)
    recept_category = Column(BigInteger, ForeignKey("kuking_category.id_category"), nullable=False)
    podcategory = Column(String(100), default="разное")
    recept_name = Column(String(100), nullable=False)
    recept_sostav = Column(Text)
    recept_instuction = Column(Text, nullable=False)