def eventsList(netid):
'''
Returns JSON for the list of upcoming events (currently, for testing, we return events from the last month as well).
'''
query = "select title, event_id, poster, name, time_start, time_end, description, entry, entry_description from pam_event, pam_club WHERE pam_club.club_id = pam_event.club_id AND DATE(time_start) > '2012-04-10'";
database = "tigerapps"
return getJSONForQuery(query, database)
def clubEvents(netid):
'''
Returns JSON information for the events for the given club.
Parameters:
name: HTTP GET (required) (ex. name=Cannon)
'''
name = request.args.get("name")
if name == None:
return "Invalid request: missing name argument"
query = "select title, event_id, poster, time_start, time_end, description, entry, entry_description, name from pam_event, pam_club where pam_event.club_id = pam_club.club_id and DATE(time_start) > '2012-04-10' and name = %s ORDER BY time_start"
database = "tigerapps"
params = (name, )
return getJSONForQuery(query, database, params = params)
def eventInfo(netid):
'''
Returns JSON information for the given event.
Parameters:
event_id: HTTP GET (required) (ex. event_id=105)
'''
event_id = request.args.get("event_id")
if event_id == None:
return "Invalid request: missing event_id argument"
query = "select title, poster, event_id, time_start, time_end, description, entry, entry_description, name from pam_event, pam_club where pam_event.club_id = pam_club.club_id and event_id = %s"
database = "tigerapps"
params = (event_id, )
return getJSONForQuery(query, database, params = params)
def get_messages(netid):
'''
Returns the most recent 50 messages in the chat database in JSON.
'''
past = request.args.get("past")
if (past == None):
past = "-1"
try:
p = int(past)
except ValueError:
return "Nice try! No funky SQL injection attacks in my territory!"
query = "SELECT * FROM chatitems WHERE id > %s ORDER BY added DESC LIMIT 50"
database = "istreet"
params = (p, )
return getJSONForQuery(query, database, params = params)
def clubsList(netid):
'''
Returns JSON information for the list of 11 clubs.
'''
return getJSONForQuery("select club_id, name from pam_club", "tigerapps")
