diff options
Diffstat (limited to 'Projekt/app/models.py')
-rw-r--r-- | Projekt/app/models.py | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/Projekt/app/models.py b/Projekt/app/models.py deleted file mode 100644 index 97d1e35..0000000 --- a/Projekt/app/models.py +++ /dev/null @@ -1,31 +0,0 @@ -from sqlalchemy import Column, Integer, String, Boolean, ForeignKey -from sqlalchemy.orm import relationship -from sqlalchemy.sql.expression import text -from sqlalchemy.sql.sqltypes import TIMESTAMP -from .database import Base - -class Post(Base): - __tablename__= "posts" - - id = Column(Integer, primary_key=True, nullable=False) - title = Column(String, nullable=False) - content = Column(String, nullable=False) - published = Column(Boolean, server_default="true", nullable=False) - created_at = Column(TIMESTAMP(timezone=True), nullable=False, server_default=text('now()') ) - - owner_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), nullable=False) - owner = relationship("User") #Fetcib owner_id põhjal( see foreign key) vastava Posti teinud User callsi useri - -class User(Base): - __tablename__ = "users" - - id = Column(Integer, primary_key=True, nullable=False) - email = Column(String, nullable=False, unique = True) - password = Column(String, nullable=False) - created_at = Column(TIMESTAMP(timezone=True), nullable=False, server_default=text('now()') ) - - -class Vote(Base): - __tablename__ = "votes" - user_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), primary_key=True) - post_id = Column(Integer, ForeignKey("posts.id", ondelete="CASCADE"), primary_key=True) |