1 package requestservice
2
3 const (
4 getEdgeOSVersionQuery = `
5 SELECT value FROM watched_field_objects
6 INNER JOIN watched_field_values
7 ON watched_field_values.object_id = watched_field_objects.object_id
8 INNER JOIN terminals
9 ON watched_field_objects.cluster_edge_id = terminals.cluster_edge_id
10 WHERE watched_field_objects.cluster_edge_id = $1
11 AND kind = 'Node'
12 AND terminals.terminal_id = $2
13 AND jsonpath = '$.metadata.labels["feature.node.kubernetes.io/ien-version"]'
14 AND deleted IS NOT true
15 ORDER BY watched_at DESC
16 LIMIT 1
17 ;`
18 )
19
View as plain text