20 lines
578 B
SQL
20 lines
578 B
SQL
-- name: GetAllAliases :many
|
|
SELECT * FROM virtual_aliases;
|
|
|
|
-- name: GetAliasesByDomain :many
|
|
SELECT * FROM virtual_aliases WHERE domain_id = ?;
|
|
|
|
-- name: GetAliasByID :one
|
|
SELECT * FROM virtual_aliases WHERE id = ?;
|
|
|
|
-- name: GetAliasBySource :one
|
|
SELECT * FROM virtual_aliases WHERE source = ?;
|
|
|
|
-- name: CreateAlias :exec
|
|
INSERT INTO virtual_aliases (domain_id, source, destination) VALUES (?, ?, ?);
|
|
|
|
-- name: DeleteAlias :exec
|
|
DELETE FROM virtual_aliases WHERE id = ?;
|
|
|
|
-- name: CountAliasesByDomain :one
|
|
SELECT COUNT(*) as count FROM virtual_aliases WHERE domain_id = ?;
|