def save(self):
db = db_open_connection()
db['cursor'].execute("INSERT INTO users VALUES (" +
self.map_attrs_for_query() + ")")
db_close_connection(db)
def destroy(self):
db = db_open_connection()
db['cursor'].execute("DELETE FROM consulates WHERE id = " +
str(self.id))
db_close_connection(db)
def all():
db = db_open_connection()
cursor = db['cursor'].execute("SELECT * FROM consulates")
result_data = Consulate.cursor_to_list(cursor)
db_close_connection(db)
return result_data
def find(filter_name, filter_value):
db = db_open_connection()
cursor = db['cursor'].execute(
"\
SELECT * FROM consulates \
WHERE " + filter_name + " = " +
Consulate.to_sql_str(filter_name, filter_value))
result_data = Consulate.cursor_to_list(cursor)
db_close_connection(db)
return result_data
def check_credentials(username, password):
db = db_open_connection()
cursor = db['cursor'].execute("\
SELECT id FROM users \
WHERE (username = \'" + username + "\' AND password = \'" +
password + "\')")
result_data = cursor.fetchone()
db_close_connection(db)
if result_data is None:
return -1
else:
return result_data[0]
def modify(self, object_params, requested_id):
db = db_open_connection()
claves = object_params.keys()
columnas = ''
for clave in claves:
columnas = columnas + str(clave) + '=?, '
columnas = columnas[:-2]
sql = "UPDATE consulates SET " + columnas + " WHERE id=?"
values = object_params.values()
values.append(requested_id)
db['cursor'].execute(sql, values)
db_close_connection(db)