class BlogType(db.Model):
__tablename__ = 'blog_type'
id = db.Column(db.INTEGER,
primary_key=True,
nullable=False,
comment='blog type id',
autoincrement=True)
name = db.Column(db.String(20),
unique=True,
nullable=False,
comment='blog type name')
counts = db.Column(db.INTEGER,
nullable=False,
default=0,
comment='this type blog counts')
description = db.Column(db.String(300), nullable=False)
create_time = db.Column(db.DateTime, default=datetime.now)
blogs = db.relationship('Blog', back_populates='blog_types')
def __init__(self, name, description):
self.name = name
self.description = description
def __repr__(self):
return '<name> %s <description> %s' % (self.name, self.description)
class VerifyCode(db.Model):
__tablename__ = 'ver_code'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
user_id = db.Column(db.INTEGER)
code = db.Column(db.INTEGER)
create_time = db.Column(db.DateTime, default=datetime.now)
is_retire = db.Column(db.BOOLEAN)
class Contribute(db.Model):
__tablename__ = 'contribute'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True, comment='table id')
date = db.Column(db.DATE, default=datetime.today(), comment='contribute date')
contribute_counts = db.Column(db.INTEGER, default=0)
con_detail = db.relationship('ContributeDetail', back_populates='cont', cascade='all')
class MessageBorder:
__tablename__ = 'msg_border'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
user = db.Column(db.String(255), nullable=False)
body = db.Column(db.String(512), nullable=False)
timestamps = db.Column(db.DateTime, default=datetime.now)
flag = db.Column(db.INTEGER, default=0, comment='is it not effect?')
class Timeline(db.Model):
__tablename__ = 'timeline'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
title = db.Column(db.String(50), nullable=False)
content = db.Column(db.String(500), nullable=False)
timestamp = db.Column(db.DateTime, default=datetime.now)
abandon = db.Column(db.INTEGER, default=0, comment='0 activate 1 abandon')
class SongCiAuthor(db.Model):
__tablename__ = 'song_ci_author'
id = db.Column(db.INTEGER, primary_key=True, index=True, autoincrement=True)
name = db.Column(db.String(100), index=True, nullable=False)
s_desc = db.Column(db.TEXT)
desc = db.Column(db.TEXT)
cis = db.relationship('SongCi', back_populates='authors', cascade='all')
class Poem(db.Model):
__tablename__ = 'poem'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
author_id = db.Column(db.INTEGER, db.ForeignKey('poet.id'))
title = db.Column(db.String(200), nullable=False)
content = db.Column(db.TEXT, nullable=False)
poets = db.relationship('Poet', back_populates='poems')
class SongCi(db.Model):
__tablename__ = 'song_ci'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
author_id = db.Column(db.INTEGER, db.ForeignKey('song_ci_author.id'))
rhythmic = db.Column(db.String(100), nullable=False)
content = db.Column(db.TEXT, nullable=False)
authors = db.relationship('SongCiAuthor', back_populates='cis')
class BlogHistory(db.Model):
__tablename__ = 'blog_history'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
blog_id = db.Column(db.INTEGER, db.ForeignKey('blog.id'))
save_path = db.Column(db.String(100), nullable=False)
timestamps = db.Column(db.DateTime, default=datetime.now)
blog = db.relationship('Blog', back_populates='blog_history')
class Dynasty(db.Model):
"""
朝代
"""
__tablename__ = 'dynasty'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
name = db.Column(db.String(50), nullable=False)
poets = db.relationship('Poet', back_populates='dynasties', cascade='all')
class LikePhoto(db.Model):
__tablename__ = 'like_photo'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
img_id = db.Column(db.INTEGER, db.ForeignKey('photo.id'))
user_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
timestamp = db.Column(db.DateTime, default=datetime.now)
photo = db.relationship('Photo', back_populates='likes')
user = db.relationship('User', back_populates='likes')
class LoginLog(db.Model):
__tablename__ = 'login_log'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True, comment='login record')
timestamp = db.Column(db.DateTime, default=datetime.now)
login_addr = db.Column(db.String(100), default='')
real_addr = db.Column(db.String(100), default='')
user_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
user = db.relationship('User', back_populates='login_logs')
class ContributeDetail(db.Model):
__tablename__ = 'contribute_detail'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
cont_id = db.Column(db.INTEGER, db.ForeignKey('contribute.id'))
timestamps = db.Column(db.DateTime, default=datetime.now().strftime('%H:%m:%S'))
title = db.Column(db.String(256), default='', nullable=False)
detail_link = db.Column(db.String(256), default='', nullable=False)
cont = db.relationship('Contribute', back_populates='con_detail')
class Contribute(db.Model):
__tablename__ = 'contribute'
id = db.Column(db.INTEGER,
primary_key=True,
autoincrement=True,
comment='table id')
date = db.Column(db.DATE,
default=datetime.today(),
comment='contribute date')
contribute_counts = db.Column(db.INTEGER, default=0)
class Poet(db.Model):
"""唐宋诗人表"""
__tablename__ = 'poet'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True, index=True)
name = db.Column(db.String(100), nullable=False, index=True)
desc = db.Column(db.TEXT, default='')
dynasty_id = db.Column(db.INTEGER, db.ForeignKey('dynasty.id'))
json_id = db.Column(db.String(100), unique=True)
dynasties = db.relationship('Dynasty', back_populates='poets')
poems = db.relationship('Poem', back_populates='poets', cascade='all')
class Role(db.Model):
__tablename__ = 'role'
id = db.Column(db.INTEGER, primary_key=True, nullable=False, comment='role id', autoincrement=True)
name = db.Column(db.String(50), nullable=False, unique=True, comment='role name')
permission = db.Column(db.String(50), nullable=False, unique=True)
users = db.relationship('User', back_populates='roles')
@staticmethod
def init_role():
admin = Role(name='ADMIN', permission='ANY')
db.session.add(admin)
usr = Role(name='USER', permission='SOME')
db.session.add(usr)
db.session.commit()
class Notification(db.Model):
__tablename__ = 'notification'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
type = db.Column(db.INTEGER, default=0, comment='notification type 0 blog 1 photo')
target_id = db.Column(db.INTEGER)
target_name = db.Column(db.String(200))
send_user = db.Column(db.String(40))
receive_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
msg = db.Column(db.String(400))
read = db.Column(db.INTEGER, default=0, comment='is readed? 0 no 1 yes')
timestamp = db.Column(db.DateTime, default=datetime.now)
receive_user = db.relationship('User', back_populates='receive_notify')
class Photo(db.Model):
__tablename__ = 'photo'
id = db.Column(db.INTEGER,
primary_key=True,
nullable=False,
comment='photo id',
autoincrement=True)
title = db.Column(db.String(40),
nullable=False,
comment='photo title',
default='""')
description = db.Column(db.String(300),
nullable=False,
comment='photo description',
default='""')
save_path = db.Column(db.String(200),
nullable=False,
comment='photo save path')
save_path_s = db.Column(db.String(200),
nullable=False,
comment='small size')
create_time = db.Column(db.DateTime, default=datetime.now)
level = db.Column(db.INTEGER, default=0)
tags = db.relationship('Tag', secondary=tagging, back_populates='photos')
comments = db.relationship('PhotoComment',
back_populates='photo',
cascade='all')
likes = db.relationship('LikePhoto', back_populates='photo', cascade='all')
class States(db.Model):
__tablename__ = 'states'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
name = db.Column(db.String(40))
timestamp = db.Column(db.DateTime, default=datetime.now)
blog = db.relationship('Blog', back_populates='state')
user = db.relationship('User', back_populates='statuses')
flink = db.relationship('FriendLink', back_populates='status')
@staticmethod
def init_states():
s1 = States(name='正常')
s2 = States(name='禁用')
db.session.add(s1)
db.session.add(s2)
db.session.commit()
class ThirdParty(db.Model):
__tablename__ = 'third_party'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
name = db.Column(db.String(100), unique=True, nullable=False)
user = db.relationship('User', back_populates='third_party', cascade='all')
@staticmethod
def init_tp():
tp = ThirdParty(name='default')
db.session.add(tp)
tp = ThirdParty(name='github')
db.session.add(tp)
tp = ThirdParty(name='weibo')
db.session.add(tp)
tp = ThirdParty(name='qq')
db.session.add(tp)
db.session.commit()
class Plan(db.Model):
__tablename__ = 'plan'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True, comment='table id')
title = db.Column(db.String(50), nullable=False)
total = db.Column(db.INTEGER, nullable=False)
done_count = db.Column(db.INTEGER, nullable=False, default=0)
is_done = db.Column(db.INTEGER, default=0, nullable=False)
timestamps = db.Column(db.DATE, default=datetime.today())
done_time = db.Column(db.DATE)
class MessageBorder(db.Model):
__tablename__ = 'msg_border'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
user_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
parent_id = db.Column(db.INTEGER, default=0)
body = db.Column(db.TEXT, nullable=False)
timestamps = db.Column(db.DateTime, default=datetime.now)
flag = db.Column(db.INTEGER, default=0, comment='is it not effect?')
plain_text = db.Column(db.TEXT, nullable=False)
msg_user = db.relationship('User', back_populates='msg_border')
class DraftBlog(db.Model):
__tablename__ = 'draft'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
title = db.Column(db.String(256), nullable=False, comment='blog title')
content = db.Column(db.Text, nullable=False)
timestamps = db.Column(db.DateTime, default=datetime.now)
brief = db.Column(db.String(512), default='', comment='blog brief introduce')
tag = db.Column(db.INTEGER, default=1, comment='is is draft? 0: no 1: yes')
class PhotoComment(db.Model):
__tablename__ = 'photo_comment'
id = db.Column(db.INTEGER, primary_key=True)
body = db.Column(db.String(400))
timestamp = db.Column(db.DateTime, default=datetime.now, index=True)
parent_id = db.Column(db.INTEGER)
replied_id = db.Column(db.INTEGER, db.ForeignKey('photo_comment.id'))
author_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
photo_id = db.Column(db.INTEGER, db.ForeignKey('photo.id'))
delete_flag = db.Column(db.INTEGER, default=0, comment='this comment delete flag 0 no 1 yes')
photo = db.relationship('Photo', back_populates='comments')
author = db.relationship('User', back_populates='photo_comments')
replies = db.relationship('PhotoComment', back_populates='replied', cascade='all')
replied = db.relationship('PhotoComment', back_populates='replies', remote_side=[id])
class BlogComment(db.Model):
__tablename__ = 'blog_comment'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
body = db.Column(db.Text)
timestamp = db.Column(db.DateTime, default=datetime.now)
parent_id = db.Column(db.INTEGER)
replied_id = db.Column(db.INTEGER, db.ForeignKey('blog_comment.id'))
author_id = db.Column(db.INTEGER, db.ForeignKey('user.id'))
blog_id = db.Column(db.INTEGER, db.ForeignKey('blog.id'))
delete_flag = db.Column(db.INTEGER, default=0, comment='this comment delete flag 0 no 1 yes')
blog = db.relationship('Blog', back_populates='comments')
author = db.relationship('User', back_populates='blog_comments')
replies = db.relationship('BlogComment', back_populates='replied', cascade='all')
replied = db.relationship('BlogComment', back_populates='replies', remote_side=[id])
class FriendLink(db.Model):
__tablename__ = 'friend_link'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
name = db.Column(db.String(40), nullable=False)
link = db.Column(db.String(40), nullable=False)
desc = db.Column(db.String(40), default='')
timestamp = db.Column(db.DateTime, default=datetime.now)
flag = db.Column(db.INTEGER, db.ForeignKey('states.id'))
status = db.relationship(States, back_populates='flink')
class PostContent(db.Model):
__tablename__ = 'post_content'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
content = db.Column(db.VARCHAR(500), default='', comment='')
post_id = db.Column(db.INTEGER)
class OneSentence(db.Model):
__tablename__ = 'one_sentence'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
content = db.Column(db.String(512), default='', nullable=False)
day = db.Column(db.DATE, default=datetime.today())
class One(db.Model):
__tablename__ = 'one'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
content = db.Column(db.String(512), nullable=False, default='')
class Soul(db.Model):
__tablename__ = 'soul'
id = db.Column(db.INTEGER, primary_key=True, autoincrement=True)
title = db.Column(db.String(300), nullable=False)
hits = db.Column(db.String(300), nullable=False, default=1)
