class User(SqlAlchemyBase, UserMixin): __tablename__ = 'user' id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True) login = sqlalchemy.Column(sqlalchemy.String(128), nullable=False, unique=True) password = sqlalchemy.Column(sqlalchemy.String(255), nullable=False)
class User(db.Model, UserMixin): #用户数据表类 __tablename__ = "users" id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True) username = sqlalchemy.Column(sqlalchemy.String(64), unique=True, index=True) role_id = sqlalchemy.Column(sqlalchemy.Integer, sqlalchemy.ForeignKey('roles.id')) hash_password = sqlalchemy.Column(sqlalchemy.String(28))
class Tag(SqlAlchemyBase): __tablename__ = 'tag' id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True) text = sqlalchemy.Column(sqlalchemy.String(32), nullable=False) message_id = sqlalchemy.Column(sqlalchemy.Integer, sqlalchemy.ForeignKey('message.id'), nullable=False)
class Message(SqlAlchemyBase): __tablename__ = 'message' id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True) text = sqlalchemy.Column(sqlalchemy.String(1024), nullable=False) def __init__(self, text, tags): self.text = text.strip() self.tags = [Tag(text=tag.strip()) for tag in tags.split(',')]
class Books(db.Model): id = sq.Column(sq.Integer, primary_key=True) book = sq.Column(sq.String(255)) author = sq.Column(sq.String(255))
class Role(db.Model): #角色数据表类 __tablename__ = "roles" id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True) name = sqlalchemy.Column(sqlalchemy.String(64), unique=True, index=True)