11import uuid
22from .database import Base
3- from sqlalchemy import TIMESTAMP , Column , ForeignKey , String , Boolean , text
3+ from sqlalchemy import TIMESTAMP , Column , String , Boolean , text
44from sqlalchemy .dialects .postgresql import UUID
5- from sqlalchemy .orm import relationship
65
76
87class User (Base ):
@@ -19,20 +18,3 @@ class User(Base):
1918 nullable = False , server_default = text ("now()" ))
2019 updated_at = Column (TIMESTAMP (timezone = True ),
2120 nullable = False , server_default = text ("now()" ))
22-
23-
24- class Post (Base ):
25- __tablename__ = 'posts'
26- id = Column (UUID (as_uuid = True ), primary_key = True , nullable = False ,
27- default = uuid .uuid4 )
28- user_id = Column (UUID (as_uuid = True ), ForeignKey (
29- 'users.id' , ondelete = 'CASCADE' ), nullable = False )
30- title = Column (String , nullable = False )
31- content = Column (String , nullable = False )
32- category = Column (String , nullable = False )
33- image = Column (String , nullable = False )
34- created_at = Column (TIMESTAMP (timezone = True ),
35- nullable = False , server_default = text ("now()" ))
36- updated_at = Column (TIMESTAMP (timezone = True ),
37- nullable = False , server_default = text ("now()" ))
38- user = relationship ('User' )
0 commit comments