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>
56 lines
998 B
YAML
56 lines
998 B
YAML
# Requêtes CRUD statuses
|
|
|
|
list:
|
|
query: >
|
|
SELECT id, project_id, code, name, color, position, created_at
|
|
FROM statuses
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
order: "code ASC"
|
|
|
|
list_by_project:
|
|
query: >
|
|
SELECT id, project_id, code, name, color, position, created_at
|
|
FROM statuses WHERE (project_id = :project_id OR project_id IS NULL)
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
order: "code ASC"
|
|
|
|
show:
|
|
query: >
|
|
SELECT id, project_id, code, name, color, position, created_at
|
|
FROM statuses WHERE id = :id
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
|
|
create:
|
|
table: statuses
|
|
fields:
|
|
- user_id
|
|
- project_id
|
|
- code
|
|
- name
|
|
- color
|
|
- position
|
|
|
|
update:
|
|
table: statuses
|
|
fields:
|
|
- project_id
|
|
- code
|
|
- name
|
|
- color
|
|
- position
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
|
|
delete:
|
|
table: statuses
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|