Select Git revision
Forked from
Automatants / Facial expression detection
Source project has a limited visibility.
models.py 2.35 KiB
<<<<<<< HEAD
"""
Models of the database for magasin app
"""
from sqlalchemy import Column, Integer, DateTime, Float, Interval, String, Text
from db.database import Base
class Records(Base):
"""Records sql table model"""
__tablename__ = "records"
id = Column(Integer, primary_key=True, index=True)
place = Column(String(10))
date = Column(DateTime)
density = Column(Float)
waiting_time = Column(Interval)
class Comments(Base):
"""Comments sql table model"""
__tablename__ = "comments"
id = Column(Integer, primary_key=True, index=True)
content = Column(Text)
published_at = Column(DateTime)
place = Column(String(10))
class News(Base):
"""News sql table model"""
__tablename__ = "news"
id = Column(Integer, primary_key=True, index=True)
title = Column(String(50))
content = Column(Text)
published_at = Column(DateTime)
end_date = Column(DateTime)
place = Column(String(10))
=======
"""
Models of the database for magasin app
"""
from sqlalchemy import Column, Integer, DateTime, Float, Interval, String, Text, Boolean
from db.database import Base
class Records(Base):
"""Records sql table model"""
__tablename__ = "records"
id = Column(Integer, primary_key=True, index=True)
place = Column(String(10))
date = Column(DateTime)
density = Column(Float)
waiting_time = Column(Interval)
class Comments(Base):
"""Comments sql table model"""
__tablename__ = "comments"
id = Column(Integer, primary_key=True, index=True)
comment = Column(Text)
date = Column(DateTime)
place = Column(String(10))
class News(Base):
"""News sql table model"""
__tablename__ = "news"
id = Column(Integer, primary_key=True, index=True)
title = Column(String(50))
content = Column(Text)
published_at = Column(DateTime)
end_date = Column(DateTime)
place = Column(String(10))
class OpeningHours(Base):
"""OpeningHours sql table model"""
__tablename__ = "opening_hours"
id = Column(Integer, primary_key=True, index=True)
place = Column(String(10))
day= Column(Integer)
timeslot = Column(Boolean)
open_hour = Column(Integer)
open_minute = Column(Integer)
close_hour = Column(Integer)
close_minute = Column(Integer)
>>>>>>> db and back routes for restaurants opening hours