36 lines
1.1 KiB
MySQL
36 lines
1.1 KiB
MySQL
|
-- name: ListEtapesByTablo :many
|
||
|
|
SELECT id, tablo_id, title, description, position, created_at, updated_at
|
||
|
|
FROM etapes
|
||
|
|
WHERE tablo_id = $1
|
||
|
|
ORDER BY position, created_at;
|
||
|
|
|
||
|
|
-- name: InsertEtape :one
|
||
|
|
INSERT INTO etapes (tablo_id, title, description, position)
|
||
|
|
VALUES ($1, $2, $3, $4)
|
||
|
|
RETURNING id, tablo_id, title, description, position, created_at, updated_at;
|
||
|
|
|
||
|
|
-- name: GetEtapeByID :one
|
||
|
|
SELECT id, tablo_id, title, description, position, created_at, updated_at
|
||
|
|
FROM etapes
|
||
|
|
WHERE id = $1 AND tablo_id = $2;
|
||
|
|
|
||
|
|
-- name: UpdateEtape :one
|
||
|
|
UPDATE etapes
|
||
|
|
SET title = $3, description = $4, updated_at = now()
|
||
|
|
WHERE id = $1 AND tablo_id = $2
|
||
|
|
RETURNING id, tablo_id, title, description, position, created_at, updated_at;
|
||
|
|
|
||
|
|
-- name: DeleteEtape :exec
|
||
|
|
DELETE FROM etapes WHERE id = $1 AND tablo_id = $2;
|
||
|
|
|
||
|
|
-- name: MaxEtapePositionByTablo :one
|
||
|
|
SELECT COALESCE(MAX(position), 0)::integer AS max_position
|
||
|
|
FROM etapes
|
||
|
|
WHERE tablo_id = $1;
|
||
|
|
|
||
|
|
-- name: UpdateEtapePosition :one
|
||
|
|
UPDATE etapes
|
||
|
|
SET position = $3, updated_at = now()
|
||
|
|
WHERE id = $1 AND tablo_id = $2
|
||
|
|
RETURNING id, tablo_id, title, description, position, created_at, updated_at;
|