def downloadMap():
mapID = int(request.form['id'])
dac = database_access()
result = dac.get_map_with_items(mapID)
if (result):
return result
else:
return jsonify(result="Map Not Found")
def incrementLevel():
current = int(request.form['mapid'])
print ("Map " + str(current) + " completed")
new = current
dac = database_access()
maximum = dac.get_number_of_levels()
if (current < maximum):
new = current + 1
if current_user.is_authenticated():
dac.update_user_level(current_user.username, new)
return jsonify(level=new)
db.session.add(mi)
mi = MapItems(3,2,7,1)
db.session.add(mi)
mi = MapItems(3,2,13,11)
db.session.add(mi)
mi = MapItems(3,3,16,3)
db.session.add(mi)
U = User("SkyBear", "my_token", "my_secret", 5)
db.session.add(U)
db.session.add(mi)
db.session.commit()
DAC = database_access()
result = DAC.get_user("SkyBear").level
print ("Highest Level: " + str(result))
#getting the map with id 1
#m = db.session.query(Maps).get(1)
#automatically does the join on the map_items table to pull together the result
#item_list = m.items
print ("**********************************\n")
print ("Single map Query through database access: \n")
def alllevels():
dac = database_access()
response = dac.get_number_of_levels()
return jsonify(result=response)