models.py

Denjamin

May 9th, 2024

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

Python 1.81 KB | None | 0 0

raw download clone embed print report

from sqlalchemy import create_engine, Column, Integer, String, ForeignKey, Date, Float
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import relationship
Base = declarative_base()
# Модельки
class Publisher(Base):
__tablename__ = 'publisher'
id = Column(Integer, primary_key=True)
name = Column(String)
# Книжки
class Book(Base):
__tablename__ = 'book'
id = Column(Integer, primary_key=True)
title = Column(String)
id_publisher = Column(Integer, ForeignKey('publisher.id'))
publisher = relationship("Publisher", back_populates="books")
# Книжки в магазинах
class Stock(Base):
__tablename__ = 'stock'
id = Column(Integer, primary_key=True)
id_book = Column(Integer, ForeignKey('book.id'))
id_shop = Column(Integer, ForeignKey('shop.id'))
count = Column(Integer)
book = relationship("Book", back_populates="stocks")
shop = relationship("Shop", back_populates="stocks")
# Магазин
class Shop(Base):
__tablename__ = 'shop'
id = Column(Integer, primary_key=True)
name = Column(String)
# Продажи
class Sale(Base):
__tablename__ = 'sale'
id = Column(Integer, primary_key=True)
price = Column(Float)
date_sale = Column(Date)
id_stock = Column(Integer, ForeignKey('stock.id'))
count = Column(Integer)
stock = relationship("Stock", back_populates="sales")
# Настройка обратных связей
Publisher.books = relationship("Book", order_by=Book.id, back_populates="publisher")
Book.stocks = relationship("Stock", order_by=Stock.id, back_populates="book")
Shop.stocks = relationship("Stock", order_by=Stock.id, back_populates="shop")
Stock.sales = relationship("Sale", order_by=Sale.id, back_populates="stock")

Add Comment

Please, Sign In to add comment