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 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 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 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)