def get(self, primary, relationship, secondary):
print "SingleRelationship"
exec_cmd_temptables(primary, secondary, relationship)
cursor.execute(cmd_query)
data = cursor.fetchall()
scene_return, level_return, room_return = parseData(data)
return jsonify({
'scene_results': scene_return,
'level_results': level_return,
'room_results': room_return
}), 200
def get(self):
cursor.execute(cmd_query)
data = cursor.fetchall()
sceneid_to_hash = {}
for row in data:
sceneid_to_hash[row[0]] = row[1]
return jsonify({
'hashes' : sceneid_to_hash
}), 200
def call_many_by_object(object):
cursor.execute(cmd_createtable2, (object))
cursor.execute(cmd_2, (object))
cursor.execute(cmd_21)
data = cursor.fetchall()
scene_return, level_return, room_return = parse_data_vis(data)
return jsonify({
'scene_results': scene_return,
'level_results': level_return,
'room_results': room_return
}), 200
def call_few_by_object(object):
cursor.execute(cmd_createtable2, (object))
cursor.execute(cmd_3, (object))
cursor.execute(cmd_31)
data = cursor.fetchall()
scene_return, level_return, room_return = parseData(data)
return jsonify({
'enhanced_vis': True,
'scene_results': scene_return,
'level_results': level_return,
'room_results': room_return
}), 200
def exec_cmd_query(order):
cursor.execute(cmd_query % order)
def exec_cmd_createtables(roomtype):
cursor.execute(cmd_createtable, (roomtype, roomtype))
def exec_cmd_temptables(pri_class, sec_class, relationship):
cursor.execute(cmd_temptables, (pri_class, pri_class, \
sec_class, sec_class, \
relationship))
def get(self):
cursor.execute('''SELECT COUNT(id) AS numScenes FROM scenes ''')
data = cursor.fetchall()
count = int(filter(str.isdigit, str(data)))
return jsonify({'numScenes': count}), 200
def exec_cmd_query(object):
cursor.execute(cmd_query)
def exec_cmd_createtables(object):
cursor.execute(cmd_createtables, (object, object))
def exec_cmd_query():
cursor.execute(cmd_query)
def exec_cmd_createtables(order):
cursor.execute(cmd_createtable % order)
def exec_cmd_empty():
cursor.execute(cmd_empty)
def exec_cmd_query():
cursor.execute(select_rooms_cmd)
def exec_cmd_createtables(roomtype, object):
cursor.execute(cmd_createtables, (object, object, roomtype, roomtype))
def exec_cmd_query(order):
cursor.execute(select_rooms_cmd % order)
