class User(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(20), unique=True) password = db.Column(db.String(20), nullable=False) email = db.Column(db.String(20)) status = db.Column(db.Integer, default=0) url = db.Column(db.String(255), default='/upload/default.jpg') js = db.Column(db.Integer, default=1) bid = db.Column(db.Integer, default=0) def __init__(self, u, p, e): ##初始化的时候传进来0 默认普通用户 self.username = u self.password = p self.email = e def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return True def get_id(self): return unicode(self.id) def __repr__(self): return 'user %s' % self.username
class PetModel(db.Model): __tablename__ = 'pet' id = db.Column(name='id', primary_key=True, autoincrement=True, type_=db.Integer) name = db.Column(name='name', type_=db.String(100)) owner = db.Column(name='owner_id', type_=db.Integer) age = db.Column(name='age', type_=db.SmallInteger) photo = db.Column(name='photo', type_=db.String(100)) createdAt = db.Column(name='created_at', type_=db.DateTime) createdBy = db.Column(name='created_by', type_=db.String(150)) modifiedAt = db.Column(name='modified_at', type_=db.DateTime) modifiedBy = db.Column(name='modified_by', type_=db.String(150))
class Chat(db.Model): __tablename__ = 'chats' _id = db.Column(db.String(512), primary_key=True) time = db.Column(db.String(512)) userid = db.Column(db.String(512)) ip = db.Column(db.String(512)) # is_real = db.Column(db.Boolean) text = db.Column(db.String(1024)) def __repr__(self): return '<Chats %s>' % self._id
class Store_Word(db.Model): __tablename__ = 'words' print(__tablename__) word_id = db.Column(db.Integer, primary_key=True) print(word_id) every_word = db.Column(db.String(32), index=True) print(every_word)
class Book(db.Model): __tablename__ = 'books' id = db.Column(db.Integer, primary_key=True, autoincrement=True) isbn = db.Column(db.String(50)) name = db.Column(db.String(16), unique=True) price = db.Column(db.Float, default=0) num = db.Column(db.Integer, default=1) author = db.Column(db.String(20)) status = db.Column(db.Integer, default=1) borrowable = db.Column(db.Integer, default=1) def __repr__(self): return 'Book: %s %s' % (self.name, self.author_id) def __init__(self, isbn, name, price, author, num): self.isbn = isbn self.name = name self.price = price self.author = author self.num = num
class Dialogue(db.Model): """ 对话文本 """ __tablename__ = "DIALOGUE_DIALOGUE" ID = db.Column(db.String(50), primary_key=True, nullable=False, comment="ID") CREATE_DATETIME = db.Column(db.DateTime, default=datetime.now(), nullable=False, comment="创建时间") EMAIL = db.Column(db.String(60), index=True, nullable=False, default="", unique=True, comment="邮箱账号") IDENTITY = db.Column(db.Enum("Agent", "User"), nullable=False, comment="发送者身份") UTTERANCE = db.Column(db.String(255), nullable=False, default="", comment="文本内容") def __repr__(self): return '<Dialogue Email: %s>\n' % self.EMAIL def to_json(self): """ Dialogue字符串格式化 """ return { 'ID': self.ID, 'CREATE_DATETIME': self.CREATE_DATETIME.strftime('%Y-%m-%d %H:%M:%S'), 'EMAIL': self.EMAIL, 'IDENTITY': self.IDENTITY, 'UTTERANCE': self.UTTERANCE, }
class UserProfile(db.Model, UserMixin): """ 用户画像 """ __tablename__ = "DIALOGUE_USERPROFILE" ID = db.Column(db.String(50), primary_key=True, nullable=False, comment="ID") CREATE_DATETIME = db.Column(db.DateTime, default=datetime.now(), nullable=False, comment="创建时间") LAST_DATETIME = db.Column(db.DateTime, index=True, nullable=False, comment="最后登录时间") UPDATE_DATETIME = db.Column(db.DateTime, nullable=False, comment="更新时间") EMAIL = db.Column(db.String(60), index=True, nullable=False, default="", unique=True, comment="邮箱账号") NAME = db.Column(db.String(50), nullable=False, default="", comment="名称") AVATAR_URL = db.Column(db.String(255), nullable=False, default="", comment="图片地址") SEX = db.Column(db.String(1), nullable=False, default="0", comment="性别") AGE = db.Column(db.Integer, nullable=False, default=0, comment="年龄") Contact = db.Column(db.String(30), nullable=False, default="", comment="联系方式") def __repr__(self): return '<UserProfile name: %s>\n' % self.NAME def to_json(self): """ UserProfile字符串格式化 """ return { 'ID': self.ID, 'CREATE_DATETIME': self.CREATE_DATETIME.strftime('%Y-%m-%d %H:%M:%S'), 'LAST_DATETIME': self.LAST_DATETIME.strftime('%Y-%m-%d %H:%M:%S'), 'UPDATE_DATETIME': self.UPDATE_DATETIME.strftime('%Y-%m-%d %H:%M:%S'), 'EMAIL': self.EMAIL, 'NAME': self.NAME, 'AVATAR_URL': self.AVATAR_URL, 'SEX': self.SEX, 'AGE': self.AGE, 'Contact': self.Contact, }