def fetch(db, path): sLocation = '' # path[8:-4] # need to figure out how to pull this from path, pass as added parameter #goal is to list the incoming donations waiting to be received today at this location db.query("""SELECT * FROM donation inner join donor on donation.donor_id = donor.id inner join person on donor.id = person.id inner join location on location.id = donor.loc_id and location.id = '""" + sLocation + """' group by donor.id """) #this seems way too complicated, am I doing something wrong? r = db.store_result() return jsonify_db_result.proc(r)
def fetch(db, path): db.query("""SELECT * FROM location inner join open_hors on location.id = open_hors.loc_id """) r = db.store_result() return jsonify_db_result.proc(r)
def fetch(db): db.query("""SELECT * FROM itemtype """) r = db.store_result() return jsonify_db_result.proc(r)
def fetch(db, path): sUserID = '' #id from path db.query("""SELECT * FROM """) r = db.store_result() return jsonify_db_result.proc(r)