Fichiers
Théo GastineletClaude Sonnet 5.5 ff42faca16 vercors.me : collecte Météo-France / Infoclimat / VP2, archive SQLite, accueil en carte, forum (squelette)
- collecte : collecter_meteofrance, extraire_infoclimat, extraire_vp2, archiver_historique, importer_opendata ; WeatherLink allégé (alleger)
- tests : meteofrance, infoclimat, vp2, archive, opendata (tous verts)
- maquettes/accueil-carte : sources de la maquette (générateurs de tuiles, page, À propos, CGU, confidentialité)
- forum : noyau local (rôles, droits, SQLite, serveur de test, 18 tests)
- deploy : Caddyfile.vercors.me.v2 (non appliqué)

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-11-04 02:24:57 +01:00

178 lignes
7.7 KiB
Python

"""Logique du forum : toutes les actions passent par un contrôle de droits."""
import db
import roles
TITRE_MAX, CORPS_MAX = 150, 20000
class Refus(Exception):
"""Action interdite (rôle insuffisant, sujet verrouillé...)."""
class Invalide(Exception):
"""Données incorrectes ou objet introuvable."""
class Forum:
def __init__(self, chemin=":memory:"):
self.con = db.connecter(chemin)
# --- utilisateurs -------------------------------------------------
def utilisateur(self, hub_id, nom=None):
"""Retourne l'utilisateur lié à ce compte Hub (créé 'membre' au besoin)."""
r = self.con.execute("SELECT * FROM users WHERE hub_id=?", (hub_id,)).fetchone()
if r is None:
self.con.execute("INSERT INTO users(hub_id,display_name) VALUES (?,?)",
(hub_id, (nom or hub_id)[:60]))
self.con.commit()
r = self.con.execute("SELECT * FROM users WHERE hub_id=?", (hub_id,)).fetchone()
return r
@staticmethod
def role_de(user):
return roles.VISITEUR if user is None else user["role"]
def changer_role(self, acteur, hub_id, nouveau):
if not roles.peut(self.role_de(acteur), "changer_role"):
raise Refus("changer_role")
if nouveau not in roles.ORDRE[1:]:
raise Invalide("rôle inconnu")
cible = self.con.execute("SELECT id FROM users WHERE hub_id=?", (hub_id,)).fetchone()
if cible is None:
raise Invalide("utilisateur inconnu")
if cible["id"] == acteur["id"] and nouveau != roles.ADMIN:
raise Refus("un administrateur ne se rétrograde pas lui-même")
self.con.execute("UPDATE users SET role=? WHERE id=?", (nouveau, cible["id"]))
self.con.commit()
# --- lecture ------------------------------------------------------
def categories(self):
return self.con.execute("SELECT * FROM categories ORDER BY position").fetchall()
def sujets(self, user, slug=None):
voit = roles.peut(self.role_de(user), "voir_masques")
sql = ("SELECT t.*, c.name AS cat_name, c.slug, u.display_name AS auteur,"
" (SELECT COUNT(*) FROM posts p WHERE p.topic_id=t.id AND (p.hidden=0 OR ?)) AS n"
" FROM topics t JOIN categories c ON c.id=t.category_id"
" JOIN users u ON u.id=t.author_id WHERE (t.hidden=0 OR ?)")
args = [int(voit), int(voit)]
if slug:
sql += " AND c.slug=?"
args.append(slug)
return self.con.execute(sql + " ORDER BY t.id DESC", args).fetchall()
def sujet(self, user, topic_id):
"""Retourne (sujet, messages). Masqué = introuvable pour un non-modérateur."""
voit = roles.peut(self.role_de(user), "voir_masques")
t = self.con.execute(
"SELECT t.*, c.name AS cat_name FROM topics t JOIN categories c"
" ON c.id=t.category_id WHERE t.id=?", (topic_id,)).fetchone()
if t is None or (t["hidden"] and not voit):
raise Invalide("sujet introuvable")
msgs = self.con.execute(
"SELECT p.id,p.topic_id,p.author_id,p.body,p.created_at,p.edited_at,p.hidden,"
" u.display_name AS auteur FROM posts p JOIN users u ON u.id=p.author_id"
" WHERE p.topic_id=? AND (p.hidden=0 OR ?) ORDER BY p.id", (topic_id, int(voit))
).fetchall()
return t, msgs
# --- écriture -----------------------------------------------------
@staticmethod
def _texte(s, maxi, nom):
s = (s or "").strip()
if not s or len(s) > maxi:
raise Invalide("%s vide ou trop long" % nom)
return s
def creer_sujet(self, user, slug, titre, corps, ip=None):
cat = self.con.execute("SELECT * FROM categories WHERE slug=?", (slug,)).fetchone()
if cat is None:
raise Invalide("catégorie inconnue")
if not roles.peut(self.role_de(user), "creer_sujet", cat["min_role_topic"]):
raise Refus("creer_sujet")
titre = self._texte(titre, TITRE_MAX, "titre")
corps = self._texte(corps, CORPS_MAX, "message")
cur = self.con.execute("INSERT INTO topics(category_id,title,author_id) VALUES (?,?,?)",
(cat["id"], titre, user["id"]))
self.con.execute("INSERT INTO posts(topic_id,author_id,body,ip) VALUES (?,?,?,?)",
(cur.lastrowid, user["id"], corps, ip))
self.con.commit()
return cur.lastrowid
def repondre(self, user, topic_id, corps, ip=None):
if not roles.peut(self.role_de(user), "repondre"):
raise Refus("repondre")
t, _ = self.sujet(user, topic_id)
if t["locked"]:
raise Refus("sujet verrouillé")
corps = self._texte(corps, CORPS_MAX, "message")
cur = self.con.execute("INSERT INTO posts(topic_id,author_id,body,ip) VALUES (?,?,?,?)",
(topic_id, user["id"], corps, ip))
self.con.commit()
return cur.lastrowid
def _post(self, post_id):
p = self.con.execute("SELECT * FROM posts WHERE id=?", (post_id,)).fetchone()
if p is None:
raise Invalide("message introuvable")
return p
def modifier_message(self, user, post_id, corps):
if not roles.peut(self.role_de(user), "modifier_son_message"):
raise Refus("modifier_son_message")
p = self._post(post_id)
if p["author_id"] != user["id"] or p["hidden"]:
raise Refus("pas votre message")
corps = self._texte(corps, CORPS_MAX, "message")
self.con.execute("UPDATE posts SET body=?, edited_at=datetime('now') WHERE id=?",
(corps, post_id))
self.con.commit()
def signaler(self, user, post_id, motif):
if not roles.peut(self.role_de(user), "signaler"):
raise Refus("signaler")
p = self._post(post_id)
if p["hidden"]:
raise Invalide("message introuvable")
motif = self._texte(motif, 500, "motif")
self.con.execute("INSERT OR IGNORE INTO reports(post_id,reporter_id,reason)"
" VALUES (?,?,?)", (post_id, user["id"], motif))
self.con.commit()
def signalements(self, user):
if not roles.peut(self.role_de(user), "voir_signalements"):
raise Refus("voir_signalements")
return self.con.execute(
"SELECT r.*, p.body, p.topic_id FROM reports r JOIN posts p ON p.id=r.post_id"
" ORDER BY r.id DESC").fetchall()
def masquer_message(self, user, post_id, masque=True):
if not roles.peut(self.role_de(user), "masquer"):
raise Refus("masquer")
self._post(post_id)
self.con.execute("UPDATE posts SET hidden=? WHERE id=?", (int(masque), post_id))
self.con.commit()
def masquer_sujet(self, user, topic_id, masque=True):
if not roles.peut(self.role_de(user), "masquer"):
raise Refus("masquer")
self.sujet(user, topic_id)
self.con.execute("UPDATE topics SET hidden=? WHERE id=?", (int(masque), topic_id))
self.con.commit()
def verrouiller(self, user, topic_id, verrou=True):
if not roles.peut(self.role_de(user), "verrouiller"):
raise Refus("verrouiller")
self.sujet(user, topic_id)
self.con.execute("UPDATE topics SET locked=? WHERE id=?", (int(verrou), topic_id))
self.con.commit()
# --- RGPD ---------------------------------------------------------
def purger_ips(self, mois=13):
"""Efface les adresses IP de plus de `mois` mois. Retourne le nombre de lignes."""
cur = self.con.execute(
"UPDATE posts SET ip=NULL WHERE ip IS NOT NULL"
" AND created_at < datetime('now', ?)", ("-%d months" % mois,))
self.con.commit()
return cur.rowcount