def joinGroup():
group_uuid = request.json['uuid']
logger.info("Trying to join group {0}".format(group_uuid))
svc = Neo4JService()
groupList = svc.query(
"MATCH (g:Entity:Org:Group {uuid: {uuid}}) "
"RETURN g", {"uuid": group_uuid})
if len(groupList) == 0:
res = jsonify({"error": "group does not exist"})
res.status_code = 400
return res
else:
group = groupList[0]['g'].properties
groupList = svc.query(
"MATCH (g:Entity:Org:Group {uuid: {uuid}}) "
"MATCH (person:Entity:Org:Person {id: {login}}) "
"MERGE (person)-[r:ASSOCIATED]->(g) "
"RETURN g", {
"uuid": group_uuid,
"login": current_user.get_id()
})
url = url_for('group.showGroup', group_id=group['uuid'])
return jsonify({"url": url})
def createGroup():
group_name = request.json['groupTitle']
logger.info("Trying to create group {0}".format(group_name))
svc = Neo4JService()
groupList = svc.query(
"MATCH (g:Entity:Org:Group {name: {name}}) "
"RETURN g", {"name": group_name})
if len(groupList) > 0:
res = jsonify({"error": "group already exists"})
res.status_code = 400
return res
groupList = svc.query(
"MERGE (g:Entity:Org:Group {name: {name}}) "
"WITH g "
"MATCH (person:Entity:Org:Person {id: {login}}) "
"MERGE (person)-[r:ASSOCIATED]->(g) "
"RETURN g", {
"name": group_name,
"login": current_user.get_id()
})
groupList = svc.query(
"MATCH (g:Entity:Org:Group {name: {name}}) "
"RETURN g", {"name": group_name})
if len(groupList) > 0:
group = groupList[0]['g'].properties
url = url_for('group.showGroup', group_id=group['uuid'])
return jsonify({"url": url})
def me(self):
svc = Neo4JService()
person_uuid = None
personList = svc.query(
"MATCH (a:Entity:Org:Person) WHERE a.id = {login} "
"RETURN a.uuid as uuid", {"login": current_user.get_id()})
if len(personList) > 0:
person_uuid = personList[0]['uuid']
return self.showPerson(person_uuid)
def favoriteGroup():
favorite = request.json['favorite']
group_uuid = request.json['group_uuid']
logger.info("Favouriting group {0} for {1}".format(group_uuid,
current_user.get_id()))
svc = Neo4JService()
if favorite:
svc.query(
"MATCH (group:Entity:Org:Group {uuid: {uuid}}), (person:Entity:Org:Person {id: {login}}) "
"MERGE (person)-[r:LIKES]->(group)", {
"uuid": group_uuid,
"login": current_user.get_id()
})
else:
svc.query(
"MATCH (person:Entity:Org:Person {id: {login}})-[r:LIKES]->(table:Entity:Org:Group {uuid: {uuid}}) "
"DELETE r", {
"uuid": group_uuid,
"login": current_user.get_id()
})
return jsonify({})
def favoriteChart():
favorite = request.json['favorite']
chart_uuid = request.json['chart_uuid']
logger.info("Favouriting chart {0} for {1}".format(chart_uuid,
current_user.get_id()))
svc = Neo4JService()
if favorite:
svc.query(
"MATCH (table:Entity:Tableau:Chart {uuid: {uuid}}), (person:Entity:Org:Person {id: {login}}) "
"MERGE (person)-[r:LIKES]->(table)", {
"uuid": chart_uuid,
"login": current_user.get_id()
})
else:
svc.query(
"MATCH (person:Entity:Org:Person {id: {login}})-[r:LIKES]->(table:Entity:Tableau:Chart {uuid: {uuid}}) "
"DELETE r", {
"uuid": chart_uuid,
"login": current_user.get_id()
})
return jsonify({})
def showPerson(self, person_id):
svc = Neo4JService()
person = {'name': 'Untitled'}
personList = svc.query(
"MATCH (a:Entity:Org:Person) WHERE a.uuid = {uuid} "
"RETURN a", {"uuid": person_id})
if len(personList) > 0:
person = personList[0]['a'].properties
person['link'] = url_for('person.showPerson',
person_id=person['uuid'])
created = []
createList = svc.query(
"MATCH (p:Entity:Org:Person {uuid: {uuid}})-[s:CREATED]->(c)<-[r:CONSUMED]-() "
"RETURN c, labels(c) as l, COUNT(r) as count "
"ORDER BY COUNT(r) DESC "
"LIMIT 20", {"uuid": person_id})
for record in createList:
d = record['c'].properties
d['type'] = discover_type(record['l'])
d['count'] = record['count']
if d['type'] == 'Database:Table':
d['link'] = url_for('table.showTable', table_id=d['uuid'])
elif d['type'] == 'Tableau:Chart':
d['link'] = url_for('chart.showChart', chart_id=d['uuid'])
created.append(d)
groups = []
groupList = svc.query(
"MATCH (p:Entity:Org:Person {uuid: {uuid}})-[s:ASSOCIATED]->(g:Entity:Org:Group) "
"RETURN g", {"uuid": person_id})
for record in groupList:
d = record['g'].properties
d['link'] = url_for('group.showGroup', group_id=d['uuid'])
groups.append(d)
consumed = []
consumptionList = svc.query(
"MATCH (p:Entity:Org:Person {uuid: {uuid}})-[s:CONSUMED]->(c) "
"RETURN c, labels(c) as l", {"uuid": person_id})
for record in consumptionList:
d = record['c'].properties
d['type'] = discover_type(record['l'])
if d['type'] == 'Database:Table':
d['link'] = url_for('table.showTable', table_id=d['uuid'])
elif d['type'] == 'Tableau:Chart':
d['link'] = url_for('chart.showChart', chart_id=d['uuid'])
consumed.append(d)
favorites = []
favoritesList = svc.query(
"MATCH (p:Entity:Org:Person {uuid: {uuid}})-[s:LIKES]->(c) "
"RETURN c, labels(c) as l", {"uuid": person_id})
for record in favoritesList:
d = record['c'].properties
d['type'] = discover_type(record['l'])
if d['type'] == 'Database:Table':
d['link'] = url_for('table.showTable', table_id=d['uuid'])
elif d['type'] == 'Tableau:Chart':
d['link'] = url_for('chart.showChart', chart_id=d['uuid'])
elif d['type'] == 'Org:Group':
d['link'] = url_for('group.showGroup', group_id=d['uuid'])
favorites.append(d)
return self.render('person.html',
person=person,
created=created,
groups=groups,
consumed=consumed,
favorites=favorites)
def showGroup(self, group_id):
svc = Neo4JService()
group = {'name': 'Untitled'}
person_uuid = None
personList = svc.query(
"MATCH (a:Entity:Org:Person) WHERE a.id = {login} "
"RETURN a.uuid as uuid", {"login": current_user.get_id()})
if len(personList) > 0:
person_uuid = personList[0]['uuid']
groupList = svc.query(
"MATCH (a:Entity:Org:Group) WHERE a.uuid = {uuid} "
"RETURN a", {"uuid": group_id})
if len(groupList) > 0:
group = groupList[0]['a'].properties
else:
group['uuid'] = '-1'
groupList = svc.query(
"MATCH (a:Entity:Org:Group {uuid: {uuid}})<-[s:LIKES]-(p:Entity:Org:Person {uuid: {person_uuid}}) "
"RETURN COUNT(s) as count", {
"uuid": group_id,
"person_uuid": person_uuid
})
if len(groupList) > 0:
if groupList[0]['count'] > 0:
group['liked'] = 1
else:
group['liked'] = 0
members = []
memberList = svc.query(
"MATCH (a:Entity:Org:Group {uuid: {uuid}})<-[s:ASSOCIATED]-(p:Entity:Org:Person) "
"RETURN p", {"uuid": group_id})
for record in memberList:
d = record['p'].properties
d['link'] = url_for('person.showPerson', person_id=d['uuid'])
members.append(d)
charts = []
chartList = svc.query(
"MATCH (a:Entity:Org:Group {uuid: {uuid}})<-[s:ASSOCIATED]-(p:Entity:Org:Person)"
"-[b:CREATED]->(c:Entity:Tableau:Chart)<-[r:CONSUMED]-() "
"RETURN c, COUNT(r) as count "
"ORDER BY COUNT(r) DESC "
"LIMIT 10", {"uuid": group_id})
for record in chartList:
d = record['c'].properties
d['link'] = url_for('chart.showChart', chart_id=d['uuid'])
charts.append(d)
tables = []
tableList = svc.query(
"MATCH (a:Entity:Org:Group {uuid: {uuid}})<-[s:ASSOCIATED]-(p:Entity:Org:Person)"
"-[b:CREATED]->(t:Entity:Database:Table)<-[r:CONSUMED]-() "
"RETURN t, COUNT(r) as count "
"ORDER BY COUNT(r) DESC "
"LIMIT 10", {"uuid": group_id})
for record in tableList:
d = record['t'].properties
d['link'] = url_for('table.showTable', table_id=d['uuid'])
tables.append(d)
isMember = False
for member in members:
if member['id'] == current_user.get_id():
isMember = True
return self.render('group.html',
group=group,
members=members,
charts=charts,
tables=tables,
isMember=isMember)
def showChart(self, chart_id):
svc = Neo4JService()
chart = {'name': 'Untitled'}
person_uuid = None
personList = svc.query(
"MATCH (a:Entity:Org:Person) WHERE a.id = {login} "
"RETURN a.uuid as uuid", {"login": current_user.get_id()})
if len(personList) > 0:
person_uuid = personList[0]['uuid']
chartList = svc.query(
"MATCH (a:Entity:Tableau:Chart) WHERE a.uuid = {uuid} "
"RETURN a", {"uuid": chart_id})
if len(chartList) > 0:
chart = chartList[0]['a'].properties
chartList = svc.query(
"MATCH (a:Entity:Tableau:Chart {uuid: {uuid}})<-[s:LIKES]-(p:Entity:Org:Person {uuid: {person_uuid}}) "
"RETURN COUNT(s) as count", {
"uuid": chart_id,
"person_uuid": person_uuid
})
if len(chartList) > 0:
if chartList[0]['count'] > 0:
chart['liked'] = 1
else:
chart['liked'] = 0
creators = []
creatorList = svc.query(
"MATCH (a:Entity:Tableau:Chart {uuid: {uuid}})<-[s:CREATED]-(p:Entity:Org:Person) "
"RETURN p", {"uuid": chart_id})
for record in creatorList:
d = record['p'].properties
d['link'] = url_for('person.showPerson', person_id=d['uuid'])
creators.append(d)
consumers = []
consumerList = svc.query(
"MATCH (a:Entity:Tableau:Chart {uuid: {uuid}})<-[r:CONSUMED]-(p:Entity:Org:Person) "
"RETURN p, COUNT(r) as count "
"ORDER BY COUNT(r) DESC "
"LIMIT 10", {"uuid": chart_id})
for record in consumerList:
d = record['p'].properties
d['link'] = url_for('person.showPerson', person_id=d['uuid'])
consumers.append(d)
tables = []
tablesList = svc.query(
"MATCH (a:Entity:Tableau:Chart {uuid: {uuid}})-[s:CONSUMED]->(t:Entity:Database:Table) "
"RETURN t", {"uuid": chart_id})
for record in tablesList:
d = record['t'].properties
d['link'] = url_for('table.showTable', table_id=d['uuid'])
tables.append(d)
workbook = None
workbookList = svc.query(
"MATCH (a:Entity:Tableau:Chart {uuid: {uuid}})-[s:ASSOCIATED]->(w:Entity:Tableau:Workbook) "
"RETURN w", {"uuid": chart_id})
for record in workbookList:
d = record['w'].properties
workbook = d
return self.render('chart.html',
chart=chart,
creators=creators,
consumers=consumers,
tables=tables,
workbook=workbook)
def showTable(self, table_id):
svc = Neo4JService()
table = {'name': 'Untitled'}
person_uuid = None
personList = svc.query(
"MATCH (a:Entity:Org:Person) WHERE a.id = {login} "
"RETURN a.uuid as uuid", {"login": current_user.get_id()})
if len(personList) > 0:
person_uuid = personList[0]['uuid']
tableList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}}) "
"RETURN a", {"uuid": table_id})
if len(tableList) > 0:
table = tableList[0]['a'].properties
tableList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}})<-[s:LIKES]-(p:Entity:Org:Person {uuid: {person_uuid}}) "
"RETURN COUNT(s) as count", {
"uuid": table_id,
"person_uuid": person_uuid
})
if len(tableList) > 0:
if tableList[0]['count'] > 0:
table['liked'] = 1
else:
table['liked'] = 0
upstream = []
upstreamList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}})-[s:CONSUMED *1..3]->(t:Entity:Database:Table) "
"RETURN t", {"uuid": table_id})
for record in upstreamList:
d = record['t'].properties
d['link'] = url_for('table.showTable', table_id=d['uuid'])
upstream.append(d)
downstream = []
downstreamList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}})<-[s:CONSUMED *1..3]-(t:Entity:Database:Table) "
"RETURN t", {"uuid": table_id})
for record in downstreamList:
d = record['t'].properties
d['link'] = url_for('table.showTable', table_id=d['uuid'])
downstream.append(d)
charts = []
chartList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}})<-[s:CONSUMED]-(c:Entity:Tableau:Chart) "
"RETURN c", {"uuid": table_id})
for record in chartList:
d = record['c'].properties
d['link'] = url_for('chart.showChart', chart_id=d['uuid'])
charts.append(d)
creators = []
creatorList = svc.query(
"MATCH (a:Entity:Database:Table {uuid: {uuid}})<-[s:CREATED]-(p:Entity:Org:Person) "
"RETURN p", {"uuid": table_id})
for record in creatorList:
d = record['p'].properties
d['link'] = url_for('person.showPerson', person_id=d['uuid'])
creators.append(d)
consumers = []
consumerList = svc.query(
"MATCH (t:Entity:Database:Table {uuid: {uuid}})<-[a:CONSUMED]-()"
"<-[b:CONSUMED]-(p:Entity:Org:Person) "
"RETURN p, COUNT(b) as count "
"ORDER BY COUNT(b) DESC "
"LIMIT 10", {"uuid": table_id})
for record in consumerList:
d = record['p'].properties
d['link'] = url_for('person.showPerson', person_id=d['uuid'])
consumers.append(d)
consumerGroups = []
consumerGroupList = svc.query(
"MATCH (t:Entity:Database:Table {uuid: {uuid}})<-[a:CONSUMED]-()"
"<-[b:CONSUMED]-(p:Entity:Org:Person)-[r:ASSOCIATED]->(g:Entity:Org:Group) "
"RETURN g, COUNT(r) as count "
"ORDER BY COUNT(r) DESC "
"LIMIT 10", {"uuid": table_id})
for record in consumerGroupList:
d = record['g'].properties
d['link'] = url_for('group.showGroup', group_id=d['uuid'])
consumerGroups.append(d)
consumptionCount = None
consumptionList = svc.query(
"MATCH (t:Entity:Database:Table {uuid: {uuid}})<-[a:CONSUMED]-()"
"<-[b:CONSUMED]-(p:Entity:Org:Person) "
"RETURN COUNT(b) as count ", {"uuid": table_id})
for record in consumptionList:
consumptionCount = record['count']
return self.render('table.html',
table=table,
upstream=upstream,
downstream=downstream,
charts=charts,
creators=creators,
consumers=consumers,
consumerGroups=consumerGroups,
consumptionCount=consumptionCount)