Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy import Column, Integer, String
- from sqlalchemy.orm import relationship
- from .base import Base as BaseModel
- class User(BaseModel, declarative_base()):
- __tablename__ = 'users'
- id = Column(Integer, primary_key=True)
- username = Column(String(16))
- password = Column(String(16))
- nickname = Column(String(16))
- secret_question = Column(String(50))
- secret_answer = Column(String(50))
- role = Column(Integer)
- is_banned = relationship("BannedUser", uselist=False, back_populates='users')
- from sqlalchemy.ext.declarative import declarative_base
- from sqlalchemy import Column, Integer, String, DateTime, ForeignKey
- from sqlalchemy.orm import relationship
- from .base import Base as BaseModel
- class BannedUser(BaseModel, declarative_base()):
- __tablename__ = 'banned_users'
- id = Column(Integer, primary_key=True)
- user_id = Column(Integer, ForeignKey('users.id'))
- user = relationship('User', back_populates='banned_users')
- reason = Column(String)
- time_end = Column(DateTime)
- ...
- class User(BaseModel, declarative_base()):
- __tablename__ = 'users'
- ...
- is_banned = relationship("BannedUser", uselist=False, back_ref='user')
- ...
- ...
- class User(BaseModel, declarative_base()):
- __tablename__ = 'users'
- ...
- is_banned = relationship("BannedUser", uselist=False, back_populates='user')
- ...
- class BannedUser(BaseModel, declarative_base()):
- __tablename__ = 'banned_users'
- ...
- user = relationship('User', back_populates='is_banned')
- ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement