class OpinionTopic(db.Model):#话题、观点对应表 id = db.Column(db.Integer, primary_key=True) topic = db.Column(db.String(20))#话题 opinion = db.Column(db.String(20))#观点 def __init__(self, topic, opinion): self.topic = topic self.opinion = opinion
class OpinionTestWeibos(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) child_topic = db.Column(db.String(20)) weibos = db.Column(db.Text) def __init__(self, topic, child_topic, weibos): self.topic = topic self.child_topic = child_topic self.weibos = weibos
class OpinionTestKeywords(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) child_topic = db.Column(db.String(20)) keywords = db.Column(db.Text) def __init__(self, topic, child_topic, keywords): self.topic = topic self.child_topic = child_topic self.keywords = keywords
class SentimentPoint(db.Model):#情绪拐点 id = db.Column(db.Integer, primary_key=True) topic = db.Column(db.String(20))#话题名 stype = db.Column(db.String(20))#拐点情绪类型标签('happy','angry','sad') ts = db.Column(db.BigInteger(20, unsigned=True))#拐点时间 def __init__(self, topic, stype, ts): self.topic = topic self.stype = stype self.ts = ts
class OpinionTestRatio(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) topic = db.Column(db.String(20)) #ts = db.clumns(db.BigInteger(10),unsigned=True) child_topic = db.Column(db.String(20)) ratio = db.Column(db.Float) def __init__(self, topic, child_topic, ratio): self.topc = topic self.child_topic = child_topic self.ratio = ratio
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 TopicIdentification(db.Model): id = db.Column(db.Integer, primary_key=True) topic = db.Column(db.String(20)) rank = db.Column(db.Integer) userId = db.Column(db.BigInteger(11, unsigned=True)) identifyDate = db.Column(db.Date) identifyWindow = db.Column(db.Integer, default=1) identifyMethod = db.Column(db.String(20), default='pagerank') def __init__(self, topic, rank, userId, identifyDate, identifyWindow, identifyMethod): self.topic = topic self.rank = rank self.userId = userId self.identifyDate = identifyDate self.identifyWindow = identifyWindow self.identifyMethod = identifyMethod
class QuicknessCount(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)) domain = db.Column(db.String(20)) topnum = db.Column(db.BigInteger(20, unsigned=True)) allnum = db.Column(db.BigInteger(20, unsigned=True)) def __init__(self, topic, range, end, mtype, domain, topnum, allnum): self.topic = topic self.range = range self.end = end self.mtype = mtype self.domain = domain self.topnum = topnum self.allnum = allnum
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 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 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 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 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
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
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 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 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
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 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)) #sentiment = db.Column(db.Integer(1, unsigned=True)) #ratio = db.Column(db.Float) 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 PropagateCount(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)) 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 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 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) 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 SentimentCount(db.Model):#情绪绝对数量曲线--已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(20)) 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 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 SentimentCountRatio(db.Model):#情绪相对比例曲线--已改 id = db.Column(db.Integer, primary_key=True) query = db.Column(db.String(20))#话题名 end = db.Column(db.BigInteger(20, unsigned=True))#时间 range = db.Column(db.BigInteger(10, unsigned=True)) count = db.Column(db.BigInteger(20, unsigned=True)) allcount = db.Column(db.BigInteger(20, unsigned=True)) sentiment = db.Column(db.Integer(1, unsigned=True))#情绪类型('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
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 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.BigInteger(10, unsigned=True))#起始时间 end = db.Column(db.BigInteger(10, unsigned=True))#终止时间 db_date = db.Column(db.BigInteger(10, unsigned=True))#入库时间❯ 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
class SentimentKeywords(db.Model):#情绪关键词---已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=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
class SentimentWeibos(db.Model):#情绪微博--已改 id = db.Column(db.Integer, primary_key=True, autoincrement=True) query = db.Column(db.String(20)) end = db.Column(db.BigInteger(10, unsigned=True)) range = db.Column(db.BigInteger(10, unsigned=True)) limit = db.Column(db.BigInteger(10, unsigned=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