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
