-- name: UpsertDefaultProxy :exec

-- The default proxy is implied and not actually stored in the database.

-- So we need to store it's configuration here for display purposes.

-- The functional values are immutable and controlled implicitly.

INSERT INTO site_configs (key, value)

VALUES

('default_proxy_display_name', @display_name :: text),

('default_proxy_icon_url', @icon_url :: text)

ON CONFLICT

(key)

DO UPDATE SET value = EXCLUDED.value WHERE site_configs.key = EXCLUDED.key

;

-- name: GetDefaultProxyConfig :one

SELECT

COALESCE((SELECT value FROM site_configs WHERE key = 'default_proxy_display_name'), 'Default') :: text AS display_name,

COALESCE((SELECT value FROM site_configs WHERE key = 'default_proxy_icon_url'), '/emojis/1f3e1.png') :: text AS icon_url

;

-- name: InsertDeploymentID :exec

INSERT INTO site_configs (key, value) VALUES ('deployment_id', $1);

-- name: GetDeploymentID :one

SELECT value FROM site_configs WHERE key = 'deployment_id';

-- name: InsertDERPMeshKey :exec

INSERT INTO site_configs (key, value) VALUES ('derp_mesh_key', $1);

-- name: GetDERPMeshKey :one

SELECT value FROM site_configs WHERE key = 'derp_mesh_key';

-- name: UpsertLastUpdateCheck :exec

INSERT INTO site_configs (key, value) VALUES ('last_update_check', $1)

ON CONFLICT (key) DO UPDATE SET value = $1 WHERE site_configs.key = 'last_update_check';

-- name: GetLastUpdateCheck :one

SELECT value FROM site_configs WHERE key = 'last_update_check';

-- name: UpsertServiceBanner :exec

INSERT INTO site_configs (key, value) VALUES ('service_banner', $1)

ON CONFLICT (key) DO UPDATE SET value = $1 WHERE site_configs.key = 'service_banner';

-- name: GetServiceBanner :one

SELECT value FROM site_configs WHERE key = 'service_banner';

-- name: UpsertLogoURL :exec

INSERT INTO site_configs (key, value) VALUES ('logo_url', $1)

ON CONFLICT (key) DO UPDATE SET value = $1 WHERE site_configs.key = 'logo_url';

-- name: GetLogoURL :one

SELECT value FROM site_configs WHERE key = 'logo_url';

-- name: UpsertApplicationName :exec

INSERT INTO site_configs (key, value) VALUES ('application_name', $1)

ON CONFLICT (key) DO UPDATE SET value = $1 WHERE site_configs.key = 'application_name';

-- name: GetApplicationName :one

SELECT value FROM site_configs WHERE key = 'application_name';

-- name: GetAppSecurityKey :one

SELECT value FROM site_configs WHERE key = 'app_signing_key';

-- name: UpsertAppSecurityKey :exec

INSERT INTO site_configs (key, value) VALUES ('app_signing_key', $1)

ON CONFLICT (key) DO UPDATE set value = $1 WHERE site_configs.key = 'app_signing_key';

-- name: GetOAuthSigningKey :one

SELECT value FROM site_configs WHERE key = 'oauth_signing_key';

-- name: UpsertOAuthSigningKey :exec

INSERT INTO site_configs (key, value) VALUES ('oauth_signing_key', $1)

ON CONFLICT (key) DO UPDATE set value = $1 WHERE site_configs.key = 'oauth_signing_key';