models.py 642 B

1234567891011121314151617181920212223242526
  1. from sqlalchemy import Column, Integer, String, ForeignKey
  2. from sqlalchemy.orm import relationship
  3. from database import Base
  4. class User(Base):
  5. __tablename__ = "users"
  6. id = Column(Integer, primary_key=True, index=True)
  7. name = Column(String)
  8. email = Column(String)
  9. password = Column(String)
  10. posts = relationship("Post", back_populates="owner")
  11. class Post(Base):
  12. __tablename__ = "posts"
  13. id = Column(Integer, primary_key=True, index=True)
  14. title = Column(String)
  15. content = Column(String)
  16. user_id = Column(Integer, ForeignKey("users.id"))
  17. owner = relationship("User", back_populates="posts")