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)