def get(self, object):
exec_cmd_createtables(object)
exec_cmd_query(object)
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, roomtype):
exec_cmd_createtable(roomtype)
exec_cmd_query('DESC')
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):
exec_cmd_empty()
exec_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, object):
exec_cmd_createtables(object)
exec_cmd_query(object)
data = cursor.fetchall()
scene_return, level_return, room_return = util.parse_data_vis(data)
return jsonify({
'enhanced_vis' : True,
'scene_results': scene_return,
'level_results': level_return,
'room_results' : room_return}), 200
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 get(self, object):
if isinstance(object, basestring):
return call_few_by_object(object)
exec_cmd_createtables('ASC')
exec_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 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 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
