Skip to content

Commit 2b71e38

Browse files
authored
feat: add status to tailnet mapping query (coder#10936)
Adds the `status` column to the mapping query so that we can add graceful disconnect logic around it
1 parent f431aa5 commit 2b71e38

File tree

2 files changed

+10
-8
lines changed

2 files changed

+10
-8
lines changed

coderd/database/queries.sql.go

Lines changed: 8 additions & 6 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

coderd/database/queries/tailnet.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -190,12 +190,12 @@ FROM tailnet_tunnels
190190
WHERE tailnet_tunnels.dst_id = $1;
191191

192192
-- name: GetTailnetTunnelPeerBindings :many
193-
SELECT tailnet_tunnels.dst_id as peer_id, tailnet_peers.coordinator_id, tailnet_peers.updated_at, tailnet_peers.node
193+
SELECT tailnet_tunnels.dst_id as peer_id, tailnet_peers.coordinator_id, tailnet_peers.updated_at, tailnet_peers.node, tailnet_peers.status
194194
FROM tailnet_tunnels
195195
INNER JOIN tailnet_peers ON tailnet_tunnels.dst_id = tailnet_peers.id
196196
WHERE tailnet_tunnels.src_id = $1
197197
UNION
198-
SELECT tailnet_tunnels.src_id as peer_id, tailnet_peers.coordinator_id, tailnet_peers.updated_at, tailnet_peers.node
198+
SELECT tailnet_tunnels.src_id as peer_id, tailnet_peers.coordinator_id, tailnet_peers.updated_at, tailnet_peers.node, tailnet_peers.status
199199
FROM tailnet_tunnels
200200
INNER JOIN tailnet_peers ON tailnet_tunnels.src_id = tailnet_peers.id
201201
WHERE tailnet_tunnels.dst_id = $1;

0 commit comments

Comments
 (0)