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>
74 lines
1.5 KiB
YAML
74 lines
1.5 KiB
YAML
# Requêtes CRUD tasks
|
|
|
|
list:
|
|
query: >
|
|
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
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
order: "position ASC"
|
|
|
|
list_by_project:
|
|
query: >
|
|
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 project_id = :project_id
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
order: "position ASC"
|
|
|
|
show:
|
|
query: >
|
|
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 id = :id
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
|
|
create:
|
|
table: tasks
|
|
fields:
|
|
- user_id
|
|
- project_id
|
|
- status_id
|
|
- title
|
|
- description
|
|
- priority
|
|
- date_start
|
|
- date_end
|
|
- time_estimated
|
|
- time_spent
|
|
- billing
|
|
- position
|
|
|
|
update:
|
|
table: tasks
|
|
fields:
|
|
- project_id
|
|
- status_id
|
|
- title
|
|
- description
|
|
- priority
|
|
- date_start
|
|
- date_end
|
|
- time_estimated
|
|
- time_spent
|
|
- billing
|
|
- position
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|
|
|
|
delete:
|
|
table: tasks
|
|
filters:
|
|
default: "user_id = :user_id"
|
|
admin: ""
|