def Obtener(self, id):
sql_tareas = "SELECT Id,Nombre,Completado FROM tareas WHERE Id = %d" % (
id, )
res = mysql.run_query(sql_tareas)
tarea = Tarea()
for t in res:
tarea.Id = t[0]
tarea.Nombre = t[1]
tarea.Completado = int(t[2])
return tarea if tarea.Id != -1 else None
pass
def ObtenerTodos(self):
sql_tareas = mysql.run_query("SELECT Id,Nombre,Completado FROM tareas")
tareas = []
for row in sql_tareas:
t = Tarea()
t.Id = row[0]
t.Nombre = row[1]
t.Completado = int(row[2])
tareas.append(t)
pass
return tareas
def Editar(self, tarea):
sql_tareas = "UPDATE tareas SET Nombre = '%s', Completado = %s WHERE Id = %d" % (
tarea.Nombre, tarea.Completado, tarea.Id)
mysql.run_query(sql_tareas)
pass
def Eliminar(self, id):
query = "DELETE FROM tareas where Id = %d " % (id, )
#print query
mysql.run_query(query)
pass
def Agregar(self, tarea):
query = "INSERT INTO tareas(Nombre,Completado) values('%s',%d)" % (
tarea.Nombre, tarea.Completado)
#print query
mysql.run_query(query)
pass