def select_gdata(self, info):
# 从"t_texts"和"t_relations"里读取数据，组成JSON
i = 0
_dic = {}
links = list()
nodes = list()
childLinks = list()
childNodes = list()
uid = info.uid
textList = list(db_tpms.select('t_texts', what="id, name, text, attitude", where="uid=\""+uid+"\"", limit=1))
id = textList[0].id
textList1 = list(db_tpms.select('t_texts', what="name, text, attitude", where="sourceid=\""+id+"\"", limit=50))
for t in textList1:
if t.text:
childLinks.append({'source':textList[0].name, 'target':t.name, 'value':'3'})
childNodes.append({'id':t.name, 'text':t.text, 'attitude':t.attitude})
userList = list(db_tpms.select('t_relations', what="sourceuid, targetuid, deep", where="centeruid=\""+uid+"\""))
for x in userList:
if x.sourceuid not in _dic.values():
_dic[i] = x.sourceuid
i+=1
if x.targetuid not in _dic.values():
_dic[i] = x.targetuid
i += 1
for y in userList:
s = y.sourceuid
t = y.targetuid
links.append({'source':self.get_name(s), 'target':self.get_name(t), 'value':y.deep})
for u in _dic.values():
k = 0
for y in userList:
if u == uid:
name = self.get_name(u)
nodes.append({'count':15, 'id':name, 'text':textList[0].text, 'attitude':textList[0].attitude,
'expand':True})
break
if u in [y.sourceuid, y.targetuid]:
k += 1
if k:
name = self.get_name(u)
nodes.append({'count':k, 'id':name})
return {'links':links, 'nodes':nodes, 'childLinks':childLinks, 'childNodes':childNodes}
def get_name(self, uid):
Name = list(
db_tpms.select('t_user', what="name",
where="uid=\"" + uid + "\""))[0]
return Name.name
def select_gdata(self, info):
# 从"t_texts"和"t_relations"里读取数据，组成JSON
i = 0
_dic = {}
links = list()
nodes = list()
childLinks = list()
childNodes = list()
uid = info.uid
textList = list(
db_tpms.select('t_texts',
what="id, name, text, attitude",
where="uid=\"" + uid + "\"",
limit=1))
id = textList[0].id
textList1 = list(
db_tpms.select('t_texts',
what="name, text, attitude",
where="sourceid=\"" + id + "\"",
limit=50))
for t in textList1:
if t.text:
childLinks.append({
'source': textList[0].name,
'target': t.name,
'value': '3'
})
childNodes.append({
'id': t.name,
'text': t.text,
'attitude': t.attitude
})
userList = list(
db_tpms.select('t_relations',
what="sourceuid, targetuid, deep",
where="centeruid=\"" + uid + "\""))
for x in userList:
if x.sourceuid not in _dic.values():
_dic[i] = x.sourceuid
i += 1
if x.targetuid not in _dic.values():
_dic[i] = x.targetuid
i += 1
for y in userList:
s = y.sourceuid
t = y.targetuid
links.append({
'source': self.get_name(s),
'target': self.get_name(t),
'value': y.deep
})
for u in _dic.values():
k = 0
for y in userList:
if u == uid:
name = self.get_name(u)
nodes.append({
'count': 15,
'id': name,
'text': textList[0].text,
'attitude': textList[0].attitude,
'expand': True
})
break
if u in [y.sourceuid, y.targetuid]:
k += 1
if k:
name = self.get_name(u)
nodes.append({'count': k, 'id': name})
return {
'links': links,
'nodes': nodes,
'childLinks': childLinks,
'childNodes': childNodes
}
def get_name(self, uid):
Name = list(db_tpms.select('t_user', what="name", where="uid=\""+uid+"\""))[0]
return Name.name
