class TrendMaker(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) date = db.Column(db.Date) windowsize = db.Column(db.Integer, default=1) uid = db.Column(db.BigInteger(11, unsigned=True)) timestamp = db.Column(db.BigInteger(20, unsigned=True)) user_info = db.Column(db.Text) weibo_info = db.Column(db.Text) domain = db.Column(db.String(20)) rank = db.Column(db.Integer) value = db.Column(db.Integer) key_item = db.Column(db.Text) def __init__(self, topic, date, windowsize, uid, timestamp, user_info, weibo_info, domain, rank, value, key_item): self.topic = topic self.date = date self.windowsize = windowsize self.uid = uid self.timestamp = timestamp self.user_info = user_info self.weibo_info = weibo_info self.domain = domain self.rank = rank self.value = value self.key_item = key_item
class IndexTopic(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.Text) count = db.Column(db.Integer) # 微博数 user_count = db.Column(db.Integer) # 用户数 begin = db.Column(db.BigInteger(10, unsigned=True)) # 起始时间 end = db.Column(db.BigInteger(10, unsigned=True)) # 终止时间 area = db.Column(db.Text) # 地理区域 key_words = db.Column(db.Text) # 关键词 opinion = db.Column(db.Text) # 代表文本 media_opinion = db.Column(db.Text) # 媒体观点 def __init__(self, topic, count, user_count, begin, end, area, key_words, opinion, media_opinion): self.topic = topic self.count = count self.user_count = user_count self.begin = begin self.end = end self.area = area self.key_words = key_words self.opinion = opinion self.media_opinion = media_opinion @classmethod def _name(cls): return u'IndexTopic'
class TrendPusher(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) date = db.Column(db.Date) windowsize = db.Column(db.Integer, default=1) uid = db.Column(db.BigInteger(11, unsigned=True)) timestamp = db.Column(db.BigInteger(20, unsigned=True)) user_info = db.Column(db.Text) weibo_info = db.Column(db.Text) domain = db.Column(db.String(20)) rank = db.Column(db.Integer) def __init__(self, topic, date, windowsize, uid, timestamp, user_info, weibo_info, domain, rank): self.topic = topic self.date = date self.windowsize = windowsize self.uid = uid self.timestamp = timestamp self.user_info = user_info self.weibo_info = weibo_info self.domain = domain self.rank = rank @classmethod def _name(cls): return u'TrendPusher'
class Topics(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) def __init__(self, topic, start_ts, end_ts): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts
class PropagateCountNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) dcount = db.Column(db.Text) # dcount={'other':count}领域对应的count···❯ def __init__(self, topic, range, end, dcount): self.topic = topic self.range = range self.end = end self.dcount = dcount
class QuotaDurationExp(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) exp = db.Column(db.Float) def __init__(self, topic, start_ts, end_ts, exp): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.exp = exp
class QuotaAttentionExp(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) exp = db.Column(db.Text) # exp={'media':x1, 'other':x2, 'opinion_leader':x3, 'oversea':x4, 'folk':x5} def __init__(self, topic, start_ts, end_ts, exp): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.exp = exp
class PlaceSensitivity(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) words = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, words): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.words = words
class QuotaMediaImportance(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) media_importance = db.Column(db.Float) def __init__(self, topic, start_ts, end_ts, media_importance): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.media_importance = media_importance
class QuotaSentiment(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) sratio = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, sratio): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.sratio = sratio
class QuotaGeoPenetration(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) pcount = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, pcount): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.pcount = pcount
class OpinionTestTime(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) child_topic = db.Column(db.Text) start_ts = db.Column(db.BigInteger(20, unsigned=True)) end_ts = db.Column(db.BigInteger(20, unsigned=True)) def __init__(self, topic, child_topic, start_ts, end_ts): self.topic = topic self.child_topic = child_topic self.start_ts = start_ts self.end_ts = end_ts
class PropagateCount(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) mtype = db.Column(db.Integer(1, unsigned=True)) dcount = db.Column(db.Text) # dcount={domain:count}领域对应的count def __init__(self, topic, range, end, mtype, dcount): self.topic = topic self.range = range self.end = end self.mtype = mtype self.dcount = dcount
class SentimentCount(db.Model): #情绪绝对数量曲线--已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) sentiment = db.Column(db.Integer(1, unsigned=True)) count = db.Column(db.BigInteger(20, unsigned=True)) def __init__(self, query, range, end, sentiment, count): self.query = query self.range = range self.end = end self.sentiment = sentiment self.count = count
class QuotaSensitivity(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) classfication = db.Column(db.Integer(1, unsigned=True)) # ['category':1, 'word':2, 'place':3] score = db.Column(db.Float) # 1<=score<=5 def __init__(self, topic, start_ts, end_ts, classfication, score): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.classfication = classfication self.score = score
class QuotaImportance(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) score = db.Column(db.Float) weight = db.Column(db.Float) # 0<=weight<=1 def __init__(self, topic, start_ts, end_ts, score, weight): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.score = score # 0<=score<1 self.weight = weight
class QuotaQuickness(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) domain = db.Column(db.String(20)) quickness = db.Column(db.Float) def __init__(self, topic, start_ts, end_ts, domain, quickness): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.domain = domain self.quickness = quickness
class FirstUserNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(20, unsigned=True)) end_ts = db.Column(db.BigInteger(20, unsigned=True)) timestamp = db.Column(db.BigInteger(20, unsigned=True)) news_info = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, timestamp, news_info): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.timestamp = timestamp self.news_info = news_info
class SentimentGeo(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) sentiment = db.Column(db.Integer(1, unsigned=True)) geo_count = db.Column(db.Text) def __init__(self, topic, range, end, sentiment, geo_count): self.topic = topic self.range = range self.end = end self.sentiment = sentiment self.geo_count = geo_count
class CityTopicCount(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) mtype = db.Column(db.Integer(1, unsigned=True)) #message_type:原创-1、转发-2、评论-3 ccount = db.Column(db.Text) #city_count:{city:count} def __init__(self, topic, range, end, mtype, ccount): self.topic = query self.range = range self.end = end self.mtype = mtype self.ccount = ccount
class PropagateKeywords(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) mtype = db.Column(db.Integer(1, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=True), 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
class QuotaCoverage(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) coverage = db.Column(db.Float) def __init__(self, topic, start_ts, end_ts, coverage): self.topic = topic self.start_ts = start_ts self.end_ts = end_ts self.coverage = coverage @classmethod def _name(cls): return u'QuotaCoverage'
class SentimentCountRatio(db.Model): #情绪相对比例曲线--已改 id = db.Column(db.Integer, primary_key=True) query = db.Column(db.String(100)) #话题名 end = db.Column(db.BigInteger(20, unsigned=True)) #时间 range = db.Column(db.BigInteger(10, unsigned=True)) ratio = db.Column(db.Float) #相对比例 sentiment = db.Column(db.Integer( 1, unsigned=True)) #情绪类型('happy','angry','sad') def __init__(self, query, end, range, ratio, sentiment): self.query = query self.end = end self.ts = ts self.ratio = ratio self.sentiment = sentiment
class PropagateWeibos(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) mtype = db.Column(db.Integer(1, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=True), primary_key=True) weibos = db.Column(db.Text) # weibos=[weibos] def __init__(self, topic, end, range, mtype, limit, weibos): self.topic = topic self.end = end self.range = range self.mtype = mtype self.limit = limit self.weibos = weibos
class QuotaFInvolved(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) f_involved = db.Column(db.Float) def __init__(self, topic, start_ts, end_ts, f_involved): self.topic = topic self, start_ts = start_ts self.end_ts = end_ts self.f_involved = f_involved @classmethod def _name(cls): return u'QuotaFInvolved'
class LocalBridge(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) date = db.Column(db.Date) windowsize = db.Column(db.Integer, default=1) a_node = db.Column(db.BigInteger(11, unsigned=True)) b_node = db.Column(db.BigInteger(11, unsigned=True)) span_ab = db.Column(db.Integer) def __init__(self, topic, date, windowsize, a_node, b_node, span_ab): self.topic = topic self.date = date self.windowsize = windowsize self.a_node = a_node self.b_node = b_node self.span_ab = span_ab
class PersonSensitivity(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) start_ts = db.Column(db.BigInteger(10, unsigned=True)) end_ts = db.Column(db.BigInteger(10, unsigned=True)) person = db.Column(db.Text) def __init__(self, topic, start_ts, end_ts, person): self.topic = topic self.start_ts = start_ts self_end_ts = end_ts self.person = person @classmethod def _name(cls): return u'PersonSensitivity'
class CityTopicCountNews(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) mtype = db.Column(db.Integer(1, unsigned=True)) #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 = topic self.range = range self.end = end self.mtype = mtype self.ccount = ccount self.first_item = first_item
class SentimentWeibos(db.Model): #情绪微博--已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=True), primary_key=True) sentiment = db.Column(db.Integer(1, unsigned=True)) 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
class SentimentKeywords(db.Model): #情绪关键词---已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(100)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=True), primary_key=True) sentiment = db.Column(db.Integer(1, unsigned=True)) 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