mirror of
https://github.com/memohai/Memoh.git
synced 2026-04-27 07:16:19 +09:00
Acbox
90ac222bc9
- Add `enable` column (default false) to search_providers and tts_providers tables - Auto-create default entries for all provider types on startup (disabled by default) - Add enable/disable Switch toggle in frontend for both search and TTS providers - Show green status dot in sidebar for enabled providers, sort enabled first - Filter bot settings dropdowns to only show enabled providers
39 lines
911 B
SQL
39 lines
911 B
SQL
-- name: CreateTtsProvider :one
|
|
INSERT INTO tts_providers (name, provider, config, enable)
|
|
VALUES (
|
|
sqlc.arg(name),
|
|
sqlc.arg(provider),
|
|
sqlc.arg(config),
|
|
sqlc.arg(enable)
|
|
)
|
|
RETURNING *;
|
|
|
|
-- name: GetTtsProviderByID :one
|
|
SELECT * FROM tts_providers WHERE id = sqlc.arg(id);
|
|
|
|
-- name: GetTtsProviderByName :one
|
|
SELECT * FROM tts_providers WHERE name = sqlc.arg(name);
|
|
|
|
-- name: ListTtsProviders :many
|
|
SELECT * FROM tts_providers
|
|
ORDER BY created_at DESC;
|
|
|
|
-- name: ListTtsProvidersByProvider :many
|
|
SELECT * FROM tts_providers
|
|
WHERE provider = sqlc.arg(provider)
|
|
ORDER BY created_at DESC;
|
|
|
|
-- name: UpdateTtsProvider :one
|
|
UPDATE tts_providers
|
|
SET
|
|
name = sqlc.arg(name),
|
|
provider = sqlc.arg(provider),
|
|
config = sqlc.arg(config),
|
|
enable = sqlc.arg(enable),
|
|
updated_at = now()
|
|
WHERE id = sqlc.arg(id)
|
|
RETURNING *;
|
|
|
|
-- name: DeleteTtsProvider :exec
|
|
DELETE FROM tts_providers WHERE id = sqlc.arg(id);
|