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 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,
}
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 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 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 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