Pierre
a4694a10d1
Nouveaux services:
- sogoms-logs : logging centralisé avec rotation
- sogoms-smtp : envoi emails avec templates YAML
Nouvelles fonctionnalités:
- Queries YAML externalisées (config/queries/{app}/)
- CRUD générique paramétrable
- Filtres par rôle (default, admin)
- Templates email (config/emails/{app}/)
Documentation:
- DOCTECH.md : documentation technique complète
- README.md : vision et roadmap
- TODO.md : phases 11-15 planifiées
Roadmap:
- Phase 11: sogoms-crypt (chiffrement)
- Phase 12: sogoms-imap/mailproc (emails)
- Phase 13: sogoms-cron (tâches planifiées)
- Phase 14: sogoms-push (MQTT temps réel)
- Phase 15: sogoms-schema (API auto-générée)
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
26 lines
852 B
YAML
26 lines
852 B
YAML
# Requêtes d'authentification
|
|
|
|
# Données chargées après login réussi
|
|
login_data:
|
|
projects: >
|
|
SELECT id, parent_id, name, description, position, created_at, updated_at
|
|
FROM projects WHERE user_id = ? ORDER BY position
|
|
tasks: >
|
|
SELECT id, project_id, status_id, title, description, priority,
|
|
date_start, date_end, time_estimated, time_spent, billing, position,
|
|
created_at, updated_at
|
|
FROM tasks WHERE user_id = ? ORDER BY position
|
|
tags: >
|
|
SELECT id, name, color, created_at
|
|
FROM tags WHERE user_id = ?
|
|
statuses: >
|
|
SELECT id, project_id, code, name, color, position, created_at
|
|
FROM statuses WHERE user_id = ? ORDER BY code
|
|
|
|
# Requêtes unitaires
|
|
user_by_email: >
|
|
SELECT id, email, name, password FROM users WHERE email = ?
|
|
|
|
user_by_id: >
|
|
SELECT id, email, name, created_at FROM users WHERE id = ?
|