mirror of
https://github.com/Kyren223/eko.git
synced 2025-09-05 21:18:14 +00:00
31 lines
544 B
SQL
31 lines
544 B
SQL
-- name: GetNetworkById :one
|
|
SELECT * FROM networks
|
|
WHERE id = ?;
|
|
|
|
-- name: CreateNetwork :one
|
|
INSERT INTO networks (
|
|
id, owner_id, name, is_public,
|
|
icon, bg_hex_color, fg_hex_color
|
|
) VALUES (
|
|
?, ?, ?, ?,
|
|
?, ?, ?
|
|
)
|
|
RETURNING *;
|
|
|
|
-- name: TransferNetwork :one
|
|
UPDATE networks SET
|
|
owner_id = ?
|
|
WHERE id = ?
|
|
RETURNING *;
|
|
|
|
-- name: UpdateNetwork :one
|
|
UPDATE networks SET
|
|
name = ?, icon = ?,
|
|
bg_hex_color = ?, fg_hex_color = ?,
|
|
is_public = ?
|
|
WHERE id = ?
|
|
RETURNING *;
|
|
|
|
-- name: DeleteNetwork :exec
|
|
DELETE FROM networks WHERE id = ?;
|