def display_appartements():
db = get_db()
posts = db.execute('SELECT * FROM appartement').fetchall()
return to_json(posts)
def delete_appartement(id):
db = get_db()
delete = db.execute('DELETE FROM appartement WHERE id = ?', (id))
db.commit()
return to_json(delete)
def display_appartement(id):
db = get_db()
appart = db.execute('SELECT * FROM appartement WHERE id = ?',
(id, )).fetchone()
return to_json([appart])
def delete_proprietaire(id):
db = get_db()
delete = db.execute('DELETE FROM proprietaire WHERE id = ?', (id))
db.commit()
return to_json(delete)
def display_proprietaires():
db = get_db()
posts = db.execute('SELECT * FROM proprietaire').fetchall()
return to_json(posts)
def display_proprietaire(id):
db = get_db()
proprio = db.execute('SELECT * FROM proprietaire WHERE id = ?',
(id, )).fetchone()
return to_json([proprio])
def display_appartements(ville_id):
db = get_db()
villes = db.execute('SELECT * FROM appartement WHERE ville_id = ?',
(ville_id)).fetchall()
return to_json(villes)