Repository navigation
Expand file tree
/
Copy pathchatmcpservers.sql
More file actions
73 lines (69 loc) · 1.56 KB
/
Copy pathchatmcpservers.sql
File metadata and controls
73 lines (69 loc) · 1.56 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
-- name: GetChatMCPServersByChatID :many
SELECT
*
FROM
chat_mcp_servers
WHERE
chat_id = @chat_id::uuid
ORDER BY
slug ASC;
-- name: UpsertChatMCPServer :one
INSERT INTO chat_mcp_servers (
id,
chat_id,
slug,
url,
headers,
headers_key_id,
tool_allow_list,
tool_deny_list,
allow_in_subagents,
forward_coder_headers
) VALUES (
@id::uuid,
@chat_id::uuid,
@slug::text,
@url::text,
@headers::text,
sqlc.narg('headers_key_id')::text,
@tool_allow_list::text[],
@tool_deny_list::text[],
@allow_in_subagents::boolean,
@forward_coder_headers::boolean
)
ON CONFLICT (chat_id, slug) DO UPDATE SET
url = EXCLUDED.url,
headers = EXCLUDED.headers,
headers_key_id = EXCLUDED.headers_key_id,
tool_allow_list = EXCLUDED.tool_allow_list,
tool_deny_list = EXCLUDED.tool_deny_list,
allow_in_subagents = EXCLUDED.allow_in_subagents,
forward_coder_headers = EXCLUDED.forward_coder_headers,
updated_at = now()
RETURNING
*;
-- name: DeleteChatMCPServersByChatIDExcludingSlugs :exec
DELETE FROM
chat_mcp_servers
WHERE
chat_id = @chat_id::uuid
AND NOT (slug = ANY(@slugs::text[]));
-- name: GetChatMCPServersByChatOwnerID :many
SELECT
cms.*
FROM
chat_mcp_servers cms
JOIN
chats ON chats.id = cms.chat_id
WHERE
chats.owner_id = @owner_id::uuid
ORDER BY
cms.id ASC;
-- name: UpdateEncryptedChatMCPServerHeaders :exec
UPDATE
chat_mcp_servers
SET
headers = @headers::text,
headers_key_id = sqlc.narg('headers_key_id')::text
WHERE
id = @id::uuid;