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