Source file src/edge-infra.dev/pkg/sds/emergencyaccess/authservice/storage/database/sql/queries.go

Documentation: edge-infra.dev/pkg/sds/emergencyaccess/authservice/storage/database/sql

     1  package datasql
     2  
     3  const (
     4  	SelectProjectIDAndBannerID = `
     5  	SELECT project_id, banner_edge_id FROM banners
     6  	WHERE 
     7  		(
     8  			banner_edge_id = $1
     9  			OR banner_name = $2
    10  		)
    11  	;`
    12  
    13  	SelectStoreID = `
    14  	SELECT cluster_edge_id FROM clusters
    15      WHERE 
    16  		(
    17  			cluster_edge_id = $1
    18      		OR cluster_name = $2
    19  		)
    20      	AND banner_edge_id = $3
    21  	;`
    22  
    23  	SelectTerminalID = `
    24  	SELECT terminal_id FROM terminals
    25      WHERE 
    26  		(
    27  			terminal_id = $1
    28      		OR hostname = $2
    29  		)
    30      	AND cluster_edge_id = $3
    31  	;`
    32  )
    33  

View as plain text