class DegreeCentralityUser(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) date = db.Column(db.Date) windowsize = db.Column(db.Integer, default=1) rank = db.Column(db.Integer) userid = db.Column(db.Integer()) dc = db.Column(db.Float) def __init__(self, topic, date, windowsize, rank, userid, dc): self.topic = topic self.date = date self.windowsize = windowsize self.rank = rank self.userid = userid self.dc = dc @classmethod def _name(cls): return u'DegreeCentralityUser'
class SentimentWeibos(db.Model):#情绪微博--已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(100)) end = db.Column(db.Integer()) range = db.Column(db.Integer()) limit = db.Column(db.Integer()) sentiment = db.Column(db.Integer()) weibos = db.Column(db.Text) def __init__(self, query, range, limit, end, sentiment, weibos): self.query = query self.range = range self.limit = limit self.end = end self.sentiment = sentiment self.weibos = weibos @classmethod def _name(cls): return u'SentimentWeibos'
class TsRank(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) rank = db.Column(db.Integer) uid = db.Column(db.Integer()) date = db.Column(db.Date) windowsize = db.Column(db.Integer, default=1) tr = db.Column(db.Float) def __init__(self, topic, rank, uid, date, windowsize, tr): self.topic = topic self.rank = rank self.uid = uid self.date = date self.windowsize = windowsize self.tr = tr @classmethod def _name(cls): return u'TsRank'
class PropagateNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.Integer()) range = db.Column(db.Integer()) mtype = db.Column(db.Integer()) limit = db.Column(db.Integer(), primary_key=True) news = db.Column(db.Text) # news=[news] def __init__(self, topic, end, range, mtype, limit, news): self.topic = topic self.end = end self.range = range self.mtype = mtype self.limit = limit self.news = news @classmethod def _name(cls): return u'PropagateNews'
class TopicStatus(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) module = db.Column(db.String(10))# 显示是哪个模块---moodlens/evolution/propagate/identify status = db.Column(db.Integer)# 1: completed 0: computing, -1:not compute, -2:delete topic = db.Column(db.Text) start = db.Column(db.Integer())#起始时间 end = db.Column(db.Integer())#终止时间 db_date = db.Column(db.Integer())#入库时间❯ def __init__(self, module, status, topic, start, end, db_date): self.module = module self.status = status self.topic = topic self.start = start self.end = end self.db_date = db_date @classmethod def _name(cls): return u'TopicStatus'
class PropagateKeywordsNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.Integer()) range = db.Column(db.Integer()) mtype = db.Column(db.Integer()) limit = db.Column(db.Integer(), primary_key=True) kcount = db.Column(db.Text) # kcount=[terms] def __init__(self, topic, end, range, mtype, limit, kcount): self.topic = topic self.end = end self.range = range self.limit = limit self.mtype = mtype self.kcount = kcount @classmethod def _name(cls): return u'PropagateKeywordsNews'
class SentimentKeywords(db.Model):#情绪关键词---已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(100)) end = db.Column(db.Integer()) range = db.Column(db.Integer()) limit = db.Column(db.Integer()) sentiment = db.Column(db.Integer()) kcount = db.Column(db.Text) def __init__(self, query, range, limit, end, sentiment, kcount): self.query = query self.range = range self.limit = limit self.end = end self.sentiment = sentiment self.kcount = kcount @classmethod def _name(cls): return u'SentimentKeywords'
class CityTopicCountNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.Integer()) range = db.Column(db.Integer()) mtype = db.Column(db.Integer()) #message_type:原创-1、转发-2 ccount = db.Column(db.Text) #city_count:{city:count} first_item = db.Column(db.Text) # 原创 初始微博 其他类型为空 def __init__(self, topic, range, end, mtype, ccount, first_item): self.topic = query self.range = range self.end = end self.mtype = mtype self.ccount = ccount self.first_item = first_item @classmethod def _name(cls): return u'CityTopicCountNews'
class SentimentCountRatio(db.Model):#情绪相对比例曲线--已改 id = db.Column(db.Integer, primary_key=True) query = db.Column(db.String(100))#话题名 end = db.Column(db.Integer())#时间 range = db.Column(db.Integer()) count = db.Column(db.Integer()) allcount = db.Column(db.Integer()) sentiment = db.Column(db.Integer())#情绪类型('happy','angry','sad') def __init__(self, query, end, range, sentiment, count, allcount): self.query = query self.end = end self.ts = ts self.count = count self.allcount = allcount self.sentiment = sentiment @classmethod def _name(cls): return u'SentimentCountRatio'
class TrendPusherNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) start_ts = db.Column(db.Integer()) end_ts = db.Column(db.Integer()) news_id = db.Column(db.Text) timestamp = db.Column(db.Integer()) comments_count = db.Column(db.Integer) news_info = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, news_id, timestamp, comments_count, news_info): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.news_id = news_id self.timestamp = timestamp self.comments_count = comments_count self.news_info = news_info @classmethod def _name(cls): return u'TrendPusherNews'
class Opinion(db.Model): id = db.Column(db.Integer, primary_key=True) opinionTopic = db.Column(db.Integer)#话题、观点对应表中id字段 start = db.Column(db.Integer())#开始时间 end = db.Column(db.Integer())#结束时间 count = db.Column(db.Integer)#所占微博数量 opinionWord = db.Column(db.String(20))#关键词 positive = db.Column(db.Float)#正极性情绪比例 nagetive = db.Column(db.Float)#负极性情绪比例 def __init__(self, opinionTopic, start, end, count, opinionWord, positive, nagetive): self.opinionTopic = opinionTopic self.start = start self.end = end self.count = count self.opinionWord = opinionWord self.positive = positive self.nagetive = nagetive @classmethod def _name(cls): return u'Opinion'