def get(self, event_id):
conn = sqlite3.connect('alumni.db')
c = conn.cursor()
user_id = stuff.email_to_user_id(session['email'])
data = (event_id, user_id)
c.execute("SELECT state FROM attendees WHERE eventID = ? AND userID = ?", data)
res = c.fetchall()
if res.__len__() == 0:
return {}, 404
return {'state': res[0]}, 200
def post(self, event_id):
parser = reqparse.RequestParser()
parser.add_argument('comment')
args = parser.parse_args()
conn = sqlite3.connect('alumni.db')
c = conn.cursor()
user_id = stuff.email_to_user_id(session['email'])
data = (event_id, user_id, args['comment'], int(round(time.time() * 1000)))
c.execute("INSERT INTO announcements (eventID, userID, comment, posted) VALUES (?, ?, ?, ?)", data)
conn.commit()
print data
return {}, 200
def put(self, event_id):
parser = reqparse.RequestParser()
parser.add_argument('state')
args = parser.parse_args()
conn = sqlite3.connect('alumni.db')
c = conn.cursor()
user_id = stuff.email_to_user_id(session['email'])
data = (event_id, user_id)
c.execute("SELECT * FROM attendees WHERE eventID = ? AND userID = ?", data)
conn.commit()
data = (args['state'], event_id, user_id)
if c.fetchall().__len__() == 0:
c.execute("INSERT INTO attendees (state, eventID, userID) VALUES (?, ?, ?)", data)
conn.commit()
else:
c.execute("UPDATE attendees SET state = ? WHERE eventID = ? AND userID = ?", data)
conn.commit()
return {}
def post(self):
parser = reqparse.RequestParser()
parser.add_argument('name')
parser.add_argument('startdate')
parser.add_argument('enddate')
parser.add_argument('description')
args = parser.parse_args()
conn = sqlite3.connect('alumni.db')
c = conn.cursor()
data = (int(round(time.time() * 1000)), stuff.email_to_user_id(session['email']), args['name'], stuff.nl2br(args['description']), args['startdate'], args['enddate'])
c.execute("INSERT INTO events (created, userID, name, description, startdate, enddate) VALUES (?, ?, ?, ?, ?, ?)", data)
id = (int(c.lastrowid),)
c.execute('SELECT * FROM events WHERE id = ?', id)
conn.commit()
r = [dict((c.description[i][0], value) for i, value in enumerate(row)) for row in c.fetchall()]
c.connection.close()
return r[0] if r else None
