class PostWordSeg(db.Model):
__tablename__ = 'postcontentsegs'
id = db.Column(db.Integer, primary_key=True)
postag = db.Column(db.String)
word_id = db.Column(db.Integer, db.ForeignKey('wordsegs.id'))
class Novel(db.Model):
__tablename__ = 'novels'
id = db.Column(db.Integer, primary_key=True)
book_name = db.Column(db.String(64), index=True)
book_url = db.Column(db.String)
book_img = db.Column(db.String)
author = db.Column(db.String(64))
type = db.Column(db.String(64), nullable=True)
last_update = db.Column(db.String(64), nullable=True)
profile = db.Column(db.Text, nullable=True)
keyword = db.Column(db.String)
page = db.Column(db.Integer)
chapters = db.relationship('Chapter', backref='book', lazy='dynamic')
__table_args__ = {'mysql_charset': 'utf8'}
def to_json(self):
json_novel = {
'id': self.id,
'book_url': self.book_url,
'book_name': self.book_name,
'book_img': self.book_img,
'author': self.author,
'type': self.type,
'last_update': self.last_update,
'profile': self.profile,
}
return json_novel
class WordSeg(db.Model):
__tablename__ = 'wordsegs'
id = db.Column(db.Integer, primary_key=True)
wordseg = db.Column(db.String)
sentence_id = db.Column(db.Integer, db.ForeignKey('sentencesegs.id'))
class SentiContent(db.Model):
__tablename__ = 'sentiContent'
id = db.Column(db.Integer, primary_key=True)
senti = db.Column(db.String)
degree = db.Column(db.Float)
sentence_id = db.Column(db.Integer, db.ForeignKey('sentencesegs.id'))
class SentenceSeg(db.Model):
__tablename__ = 'sentencesegs'
id = db.Column(db.Integer, primary_key=True)
sentenceseg = db.Column(db.Text)
chapter_id = db.Column(db.Integer, db.ForeignKey('chapters.id'))
words = db.relationship("WordSeg", backref='sentence', lazy='dynamic')
senti = db.relationship("SentiContent", backref='sentence', lazy='dynamic')
class Content(db.Model):
__tablename__ = 'contents'
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.String)
chapter_id = db.Column(db.Integer, db.ForeignKey('chapters.id'))
def to_json(self):
json_content = {'id': self.chapter_id, 'content': self.content}
return json_content
class Chapter(db.Model):
__tablename__ = 'chapters'
id = db.Column(db.Integer, primary_key=True)
chapter = db.Column(db.String(64))
chapter_url = db.Column(db.String, index=True)
content = db.relationship('Content', backref='chapter', lazy='dynamic')
sentences = db.relationship('SentenceSeg',
backref='chapter',
lazy='dynamic')
book_id = db.Column(db.Integer, db.ForeignKey('novels.id'))
def to_json(self):
json_chapter = {
'id': self.id,
'book_id': self.book_id,
'chapter_name': self.chapter
}
return json_chapter
class Alembic(db.Model):
__tablename__ = 'alembic_version'
version_num = db.Column(db.String(32), primary_key=True, nullable=False)
@staticmethod
def clear_A():
for a in Alembic.query.all():
print(a.version_num)
db.session.delete(a)
db.session.commit()
print('======== data in Table: Alembic cleared!')