Pierre
65da4efdad
Phase 13 : sogoms-cron
- Jobs planifiés avec schedule cron standard
- Types: query_email, http, service
- Actions: list, trigger, status
Phase 16 : Réorganisation config/apps/{app}/
- Tous les fichiers d'une app dans un seul dossier
- Migration prokov vers nouvelle structure
Phase 17 : sogoms-admin
- Interface web d'administration (Go templates + htmx)
- Auth sessions cookies signées HMAC-SHA256
- Rôles super_admin / app_admin avec permissions
Phase 19 : Création d'app via Admin UI
- Formulaire création app avec config DB/auth
- Bouton "Scanner la base" : introspection + schema.yaml
- Rechargement automatique sogoway via SIGHUP
Infrastructure :
- sogoctl : socket de contrôle /run/sogoctl.sock
- sogoway : reload config sur SIGHUP sans restart
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
45 lines
1.0 KiB
YAML
45 lines
1.0 KiB
YAML
# Scénario: Liste des statuts
|
|
name: statuses_list
|
|
version: "1.0"
|
|
description: Retourne les statuts avec filtres optionnels
|
|
|
|
input:
|
|
optional:
|
|
- project_id
|
|
- global
|
|
validation:
|
|
project_id:
|
|
type: int
|
|
global:
|
|
type: bool
|
|
|
|
steps:
|
|
- id: get_statuses
|
|
service: db
|
|
action: query
|
|
params:
|
|
query: |
|
|
SELECT s.*,
|
|
(SELECT COUNT(*) FROM tasks t WHERE t.status_id = s.id) as task_count
|
|
FROM statuses s
|
|
WHERE s.user_id = ?
|
|
AND (
|
|
(? IS NOT NULL AND (s.project_id = ? OR s.project_id IS NULL))
|
|
OR (? IS NOT NULL AND s.project_id IS NULL)
|
|
OR (? IS NULL AND ? IS NULL)
|
|
)
|
|
ORDER BY s.position ASC, s.code ASC
|
|
args:
|
|
- "{{auth.user_id}}"
|
|
- "{{input.project_id}}"
|
|
- "{{input.project_id}}"
|
|
- "{{input.global}}"
|
|
- "{{input.project_id}}"
|
|
- "{{input.global}}"
|
|
|
|
output:
|
|
status: 200
|
|
body:
|
|
success: true
|
|
data: "{{steps.get_statuses.result}}"
|