def get(eventid): sql_request = 'SELECT * FROM %s WHERE eventid="%s"' % (TABLENAME, eventid) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) event_row = cursor.fetchone() if event_row is None: return None else: event_data = { 'eventid': int(event_row[0]), 'name': event_row[1], 'description': event_row[2], 'poster_path': event_row[3], 'event_date': event_row[4], 'event_location': event_row[5], 'participants': int(event_row[6]), 'owner': event_row[7] } event = Event(event_data) return event
def ultimo(): sql = 'SELECT eventoid FROM %s ORDER BY eventoid DESC LIMIT 1' % (TABLA) db = get_database() cursor = db.cursor() cursor.execute(sql) fila = cursor.fetchone() return fila[0] or None
def update(self, attrs): sql_request = 'UPDATE %s SET ' % TABLENAME last = len(attrs.keys()) for idx, attr in enumerate(attrs.keys()): sql_request += str(attr) + ' = "' + str(attrs[attr]) + '"' if idx != last - 1: sql_request += ', ' sql_request += 'WHERE eventid="' + str(self.eventid) + '"' print " " print sql_request print " " database = get_database() cursor = database.cursor() try: cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def get_assisted(username): sql_request = 'SELECT event FROM %s WHERE participant="%s"' % ( ASSISTANCE_TABLENAME, username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cur = database.cursor() cursor.execute(sql_request) assited_data = [] user_row = cursor.fetchone() if user_row is None: return None while (user_row <> None): sql_request3 = 'SELECT name FROM %s WHERE eventid="%s"' % ( EVENT_TABLENAME, user_row[0]) cur.execute(sql_request3) event_name = cur.fetchone() assited_data.append((event_name[0], user_row[0])) user_row = cursor.fetchone() #data = User(assited_data).__dict__ return assited_data
def get(eventid): sql_request = 'SELECT * FROM %s WHERE eventid="%s"' % (TABLENAME,eventid) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) event_row = cursor.fetchone() if event_row is None: return None else: event_data = {'eventid' : int(event_row[0]), 'name' : event_row[1], 'description' : event_row[2], 'poster_path' : event_row[3], 'event_date' : event_row[4], 'event_location' : event_row[5], 'participants' : int(event_row[6]), 'owner' : event_row[7] } event = Event(event_data) return event
def get_assisted(username): sql_request = 'SELECT event FROM %s WHERE participant="%s"' % (ASSISTANCE_TABLENAME,username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cur = database.cursor() cursor.execute(sql_request) assited_data = [] user_row = cursor.fetchone() if user_row is None: return None while (user_row <> None): sql_request3 = 'SELECT name FROM %s WHERE eventid="%s"' % (EVENT_TABLENAME,user_row[0]) cur.execute(sql_request3) event_name = cur.fetchone() assited_data.append((event_name[0], user_row[0])) user_row = cursor.fetchone() #data = User(assited_data).__dict__ return assited_data
def all_owned_by(user): sql_request = 'SELECT * FROM %s WHERE owner="%s"' % (TABLENAME, user) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) events_rows = cursor.fetchall() events_data = map( lambda x: { 'eventid': int(x[0]), 'name': x[1], 'description': x[2], 'poster_path': x[3], 'event_date': x[4], 'event_location': x[5], 'participants': int(x[6]), 'owner': x[7] }, events_rows) events = map(lambda x: Event(x), events_data) return events
def all(): sql = 'SELECT * FROM %s' % (TABLA) db = get_database() cursor = db.cursor() cursor.execute(sql) filas = cursor.fetchall() data = map(lambda x:{'eventoid':int(x[0]),'nombre':x[1],'descripcion':x[2],'fecha':x[3],'lugar':x[4],'capacidad':int(x[5]),'afiche':x[6]},filas) eventos = map(lambda x: Evento(x), data) return eventos
def get(eventoid): sql = 'SELECT * FROM %s WHERE eventoid="%s"' % (TABLA,eventoid) db = get_database() cursor = db.cursor() cursor.execute(sql) fila = cursor.fetchone() if fila is None: return None else: data = {'eventoid':int(fila[0]),'nombre':fila[1],'descripcion':fila[2],'fecha':fila[3],'lugar':fila[4],'capacidad':int(fila[5]),'afiche':fila[6]} evento = Evento(data) return evento
def exists(self): sql_request = 'SELECT username FROM %s' % TABLENAME print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) event = cursor.fetchone() return event and len(event) > 0
def authenticate(self): sql_request = 'SELECT username FROM %s WHERE username="******" AND password="******"' % ( TABLENAME, self.user, self.password ) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) user = cursor.fetchone() return user and len(user) > 0
def save(self): db = get_database() cursor = db.cursor() try: sql = 'INSERT INTO %s (eventoid, nombre, descripcion, fecha, lugar, capacidad, afiche) VALUES (NULL,"%s","%s","%s","%s","%s","%s")' % (TABLA, self.nombre, self. descripcion, self.fecha, self.lugar, self.capacidad, self.afiche) cursor.execute(sql) db.commit() return True except Exception as e: db.rollback() print e.message return False
def eliminar(self): sql = 'DELETE FROM %s WHERE eventoid = %d' % (TABLA, self.eventoid) try: db = get_database() cursor = db.cursor() cursor.execute(sql) db.commit() return True except Exception as e: db.rollback() print e.message return False
def exists(self): sql_request = 'SELECT username FROM %s' % TABLENAME print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) user = cursor.fetchone() return user and len(user) > 0
def all(): sql_request = 'SELECT username FROM %s' % (TABLENAME) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) users = cursor.fetchall() return users
def authenticate(self): sql_request = 'SELECT username FROM %s WHERE username="******" AND password="******"' % ( TABLENAME, self.user, self.password) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) user = cursor.fetchone() return user and len(user) > 0
def last_id(): sql_request = 'SELECT eventid FROM %s ORDER BY eventid DESC LIMIT 1' % (TABLENAME) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) event = cursor.fetchone() return event[0] or None
def get_owner(event): sql_request = 'SELECT owner FROM %s WHERE eventid="%s"' % (TABLENAME, event) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) owner_row = cursor.fetchone() return owner_row
def last_id(): sql_request = 'SELECT eventid FROM %s ORDER BY eventid DESC LIMIT 1' % ( TABLENAME) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) event = cursor.fetchone() return event[0] or None
def from_event(event): sql_request = 'SELECT participant, assited, event FROM %s WHERE event="%s"' % ( ASSISTANCE_TABLENAME, event ) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) users = cursor.fetchall() return users
def delete(self): sql_request = 'DELETE FROM %s WHERE participant="%s" AND event="%s"' % (TABLENAME,self.user,self.event) print " " print sql_request print " " try: database = get_database() cursor = database.cursor() cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def from_event(event): sql_request = 'SELECT participant, assited, event FROM %s WHERE event="%s"' % ( ASSISTANCE_TABLENAME, event) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) users = cursor.fetchall() return users
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (username, password) VALUES ("%s", "%s")' % ( TABLENAME, self.user, self.password ) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def delete(self): sql_request = 'DELETE FROM %s WHERE participant="%s" AND event="%s"' % ( TABLENAME, self.user, self.event) print " " print sql_request print " " try: database = get_database() cursor = database.cursor() cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (username, password) VALUES ("%s", "%s")' % ( TABLENAME, self.user, self.password) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def get(user, event): sql_request = 'SELECT participant,event,assited FROM %s WHERE participant="%s" AND event="%s"' % (TABLENAME,user,event) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) row = cursor.fetchone() if row is None: return None else: assistance = Assistance(row[0], int(row[1]), int(row[2])) return assistance
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (participant, event, assited) \ VALUES ("%s", "%s", 0)' % ( TABLENAME, self.user, self.event ) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (participant, event, assited) \ VALUES ("%s", "%s", 0)' % (TABLENAME, self.user, self.event) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def cancel_assistance(username): sql_request = 'UPDATE %s SET assited = 0 WHERE participant = "%s"' % (ASSISTANCE_TABLENAME, username) print " " print sql_request print " " try: database = get_database() cursor = database.cursor() cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def cancel_assistance(username): sql_request = 'UPDATE %s SET assited = 0 WHERE participant = "%s"' % ( ASSISTANCE_TABLENAME, username) print " " print sql_request print " " try: database = get_database() cursor = database.cursor() cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def get(user, event): sql_request = 'SELECT participant,event,assited FROM %s WHERE participant="%s" AND event="%s"' % ( TABLENAME, user, event) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) row = cursor.fetchone() if row is None: return None else: assistance = Assistance(row[0], int(row[1]), int(row[2])) return assistance
def get(username): sql_request = 'SELECT * FROM %s WHERE username="******"' % (TABLENAME, username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) user_row = cursor.fetchone() if user_row is None: return None else: user_data = {'user': user_row[0], 'password': user_row[1]} userid = User(user_data).__dict__ return userid
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (eventid, name, description, \ poster_path, event_date, event_location, n_participants, owner) \ VALUES (NULL, "%s", "%s", "%s", "%s", "%s", "%s", "%s")' % ( TABLENAME, self.name, self.description, self.poster_path, self.event_date, self.event_location, self.n_participants, self.owner) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def update(eventid, att): sql = 'UPDATE %s SET ' % TABLA last = len(att.keys()) for idx, attr in enumerate(att.keys()): sql += str(attr) + ' = "' + str(att[attr]) + '"' if idx != last-1: sql += ', ' sql += 'WHERE eventoid = "' + str(eventid) + '"' db = get_database() cursor = db.cursor() try: cursor.execute(sql) db.commit() return True except Exception as e: db.rollback() print e.message return False
def save(self): database = get_database() cursor = database.cursor() try: sql_request = 'INSERT INTO %s (eventid, name, description, \ poster_path, event_date, event_location, n_participants, owner) \ VALUES (NULL, "%s", "%s", "%s", "%s", "%s", "%s", "%s")' % ( TABLENAME, self.name, self.description, self.poster_path, self.event_date, self.event_location, self.n_participants, self.owner ) print " " print sql_request print " " cursor.execute(sql_request) database.commit() return True except Exception as e: database.rollback() print e.message return False
def get(username): sql_request = 'SELECT * FROM %s WHERE username="******"' % (TABLENAME,username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) user_row = cursor.fetchone() if user_row is None: return None else: user_data = {'user': user_row[0], 'password': user_row[1] } userid = User(user_data).__dict__ return userid
def all_owned_by(user): sql_request = 'SELECT * FROM %s WHERE owner="%s"' % (TABLENAME, user) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) events_rows = cursor.fetchall() events_data = map(lambda x: {'eventid' : int(x[0]), 'name' : x[1], 'description' : x[2], 'poster_path' : x[3], 'event_date' : x[4], 'event_location' : x[5], 'participants' : int(x[6]), 'owner' : x[7]}, events_rows) events = map(lambda x: Event(x), events_data) return events
def get_created(username): sql_request = 'SELECT name, eventid FROM %s WHERE owner="%s"' % ( EVENT_TABLENAME, username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) created_data = [] user_row = cursor.fetchone() if user_row is None: return None while (user_row <> None): created_data.append((user_row[0], user_row[1])) user_row = cursor.fetchone() #data = User(created_data).__dict__ return created_data
def get_created(username): sql_request = 'SELECT name, eventid FROM %s WHERE owner="%s"' % (EVENT_TABLENAME,username) print " " print sql_request print " " database = get_database() cursor = database.cursor() cursor.execute(sql_request) created_data = [] user_row = cursor.fetchone() if user_row is None: return None while (user_row <> None): created_data.append((user_row[0],user_row[1])) user_row = cursor.fetchone() #data = User(created_data).__dict__ return created_data