16 lines
577 B
SQL
16 lines
577 B
SQL
-- name: CreateChannel :one
|
|
INSERT INTO notification_channels (id, project_id, type, config, secret_enc)
|
|
VALUES ($1, $2, $3, $4, $5) RETURNING *;
|
|
|
|
-- name: ListChannels :many
|
|
SELECT * FROM notification_channels WHERE project_id = $1 ORDER BY created_at;
|
|
|
|
-- name: ListEnabledChannels :many
|
|
SELECT * FROM notification_channels WHERE project_id = $1 AND enabled ORDER BY created_at;
|
|
|
|
-- name: GetChannel :one
|
|
SELECT * FROM notification_channels WHERE id = $1 AND project_id = $2;
|
|
|
|
-- name: DeleteChannel :exec
|
|
DELETE FROM notification_channels WHERE id = $1 AND project_id = $2;
|