33 lines
1.0 KiB
Python
33 lines
1.0 KiB
Python
"""evenement_model.py — Accès aux données pour l'entité "evenement" (planning)."""
|
|
|
|
|
|
def insert(db, titre, description, date_debut, date_fin, createur_sub):
|
|
query = (
|
|
"INSERT INTO evenements (titre, description, date_debut, date_fin, createur_sub) "
|
|
"VALUES (%s, %s, %s, %s, %s)"
|
|
)
|
|
return db.execute(query, (titre, description, date_debut, date_fin, createur_sub))
|
|
|
|
|
|
def fetch_all(db):
|
|
query = (
|
|
"SELECT id, titre, description, date_debut, date_fin, createur_sub, created_at "
|
|
"FROM evenements ORDER BY date_debut ASC"
|
|
)
|
|
return db.fetch_all(query)
|
|
|
|
|
|
def get(db, evenement_id):
|
|
query = (
|
|
"SELECT id, titre, description, date_debut, date_fin, createur_sub, created_at "
|
|
"FROM evenements WHERE id = %s"
|
|
)
|
|
return db.fetch_one(query, (evenement_id,))
|
|
|
|
|
|
def delete(db, evenement_id):
|
|
query = "DELETE FROM evenements WHERE id = %s"
|
|
with db.cursor(commit=True) as cur:
|
|
cur.execute(query, (evenement_id,))
|
|
return cur.rowcount
|