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 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 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 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 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 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