stmt

Documentation

Index

• Constants

Constants

const ActivateUser = `
UPDATE inventory.users
SET    user_is_active = 'yes'::boolean
WHERE  user_id = $1::uuid;`

const AddPermission = `` /* 338-byte string literal not displayed */

const AddPermissionCategory = `` /* 255-byte string literal not displayed */

const AddServers = `` /* 443-byte string literal not displayed */

const BucketCstProps = `` /* 303-byte string literal not displayed */

const BucketCustomPropertyForDelete = `` /* 367-byte string literal not displayed */

const BucketOncProps = `` /* 283-byte string literal not displayed */

const BucketOncallPropertyForDelete = `` /* 337-byte string literal not displayed */

const BucketServicePropertyForDelete = `` /* 342-byte string literal not displayed */

const BucketSvcProps = `` /* 169-byte string literal not displayed */

const BucketSysProps = `` /* 184-byte string literal not displayed */

const BucketSystemPropertyForDelete = `` /* 165-byte string literal not displayed */

const CheckDetailsForDelete = `` /* 356-byte string literal not displayed */

const CheckUserActive = `
SELECT user_is_active
FROM   inventory.users
WHERE  user_id = $1::uuid
AND    NOT user_is_deleted;`

const ClusterBucketId = `
SELECT sc.bucket_id
FROM   soma.clusters sc
WHERE  sc.cluster_id = $1;`

const ClusterCstProps = `` /* 305-byte string literal not displayed */

const ClusterCustomPropertyForDelete = `` /* 368-byte string literal not displayed */

const ClusterOncProps = `` /* 285-byte string literal not displayed */

const ClusterOncallPropertyForDelete = `` /* 338-byte string literal not displayed */

const ClusterServicePropertyForDelete = `` /* 343-byte string literal not displayed */

const ClusterSvcProps = `` /* 171-byte string literal not displayed */

const ClusterSysProps = `` /* 186-byte string literal not displayed */

const ClusterSystemPropertyForDelete = `` /* 166-byte string literal not displayed */

const DeletePermission = `
DELETE FROM soma.permissions
WHERE permission_id = $1::uuid;`

const DeletePermissionCategory = `
DELETE FROM soma.permission_types
WHERE permission_type = $1::varchar;`

const DeleteServers = `` /* 196-byte string literal not displayed */

const FindUserID = `
SELECT user_id
FROM   inventory.users
WHERE  user_uid = $1::varchar
AND    NOT user_is_deleted;`

const ForestAddRepository = `` /* 563-byte string literal not displayed */

const ForestLoadRepository = `` /* 155-byte string literal not displayed */

const ForestRebuildDeleteChecks = `
UPDATE soma.checks sc
SET    deleted = 'yes'::boolean
WHERE  sc.repository_id = $1::uuid;`

const ForestRebuildDeleteInstances = `` /* 156-byte string literal not displayed */

const ForestRepoNameById = `
SELECT repository_name,
       organizational_team_id
FROM   soma.repositories
WHERE  repository_id = $1::uuid;`

const GrantGlobalOrSystemToUser = `` /* 209-byte string literal not displayed */

const GrantLimitedRepoToUser = `` /* 210-byte string literal not displayed */

const GroupBucketId = `
SELECT sg.bucket_id
FROM   soma.groups sg
WHERE  sg.group_id = $1;`

const GroupCstProps = `` /* 301-byte string literal not displayed */

const GroupCustomPropertyForDelete = `` /* 366-byte string literal not displayed */

const GroupOncProps = `` /* 281-byte string literal not displayed */

const GroupOncallPropertyForDelete = `` /* 336-byte string literal not displayed */

const GroupServicePropertyForDelete = `` /* 341-byte string literal not displayed */

const GroupSvcProps = `` /* 167-byte string literal not displayed */

const GroupSysProps = `` /* 182-byte string literal not displayed */

const GroupSystemPropertyForDelete = `` /* 164-byte string literal not displayed */

const InsertToken = `` /* 168-byte string literal not displayed */

insert a new token into the database

const InvalidateUserCredential = `` /* 325-byte string literal not displayed */

const JobResultForId = `` /* 290-byte string literal not displayed */

const JobResultsForList = `` /* 297-byte string literal not displayed */

const ListAllCapabilities = `` /* 274-byte string literal not displayed */

const ListAllMonitoringSystems = `
SELECT monitoring_id,
       monitoring_name
FROM   soma.monitoring_systems;`

const ListAllOutstandingJobs = `
SELECT job_id,
       job_type
FROM   soma.jobs
WHERE  job_status != 'processed';`

const ListAllRepositories = `
SELECT repository_id,
       repository_name
FROM   soma.repositories;`

const ListNodes = `
SELECT node_id,
       node_name
FROM   soma.nodes
WHERE  node_online;`

const ListPermission = `
SELECT permission_id,
       permission_name
FROM   soma.permissions;`

const ListPermissionCategory = `
SELECT spt.permission_type
FROM   soma.permission_types spt;`

const ListScopedCapabilities = `` /* 832-byte string literal not displayed */

const ListScopedMonitoringSystems = `` /* 743-byte string literal not displayed */

const ListScopedOutstandingJobs = `` /* 436-byte string literal not displayed */

const ListScopedRepositories = `` /* 932-byte string literal not displayed */

const ListServers = `` /* 202-byte string literal not displayed */

const ListTeams = `
SELECT organizational_team_id,
       organizational_team_name
FROM   inventory.organizational_teams;`

const ListUsers = `
SELECT user_id,
       user_uid
FROM   inventory.users;`

const LoadAllTokens = `
SELECT token,
       salt,
       valid_from,
       valid_until
FROM   auth.tokens
WHERE  NOW() < valid_until;`

startup loading all tokens

const LoadAllUserCredentials = `` /* 377-byte string literal not displayed */

const LoadGlobalOrSystemUserGrants = `
SELECT grant_id,
       user_id,
       permission_id
FROM   soma.authorizations_global;`

const LoadPermissions = `
SELECT permission_id,
       permission_name
FROM   soma.permissions;`

const LoadRootFlags = `
SELECT flag,
       status
FROM   root.flags;`

'restricted' => true|false 'disabled' => true|false

const LoadRootPassword = `` /* 363-byte string literal not displayed */

const LoadUserTeamMapping = `` /* 240-byte string literal not displayed */

const NodeBucketId = `
SELECT snba.bucket_id
FROM   soma.node_bucket_assignment snba
WHERE  snba.node_id = $1;`

const NodeCstProps = `` /* 299-byte string literal not displayed */

const NodeCustomPropertyForDelete = `` /* 365-byte string literal not displayed */

const NodeOncProps = `` /* 277-byte string literal not displayed */

const NodeOncallPropertyForDelete = `` /* 333-byte string literal not displayed */

const NodeServicePropertyForDelete = `` /* 340-byte string literal not displayed */

const NodeSvcProps = `` /* 165-byte string literal not displayed */

const NodeSysProps = `` /* 180-byte string literal not displayed */

const NodeSystemPropertyForDelete = `` /* 198-byte string literal not displayed */

const PurgeServers = `` /* 146-byte string literal not displayed */

const RepoCstProps = `` /* 311-byte string literal not displayed */

const RepoCustomPropertyForDelete = `` /* 356-byte string literal not displayed */

const RepoOncProps = `` /* 291-byte string literal not displayed */

const RepoOncallPropertyForDelete = `` /* 326-byte string literal not displayed */

const RepoServicePropertyForDelete = `` /* 331-byte string literal not displayed */

const RepoSvcProps = `` /* 177-byte string literal not displayed */

const RepoSysProps = `` /* 192-byte string literal not displayed */

const RepoSystemPropertyForDelete = `` /* 169-byte string literal not displayed */

const RevokeGlobalOrSystemFromUser = `
DELETE FROM soma.authorizations_global
WHERE grant_id = $1::uuid;`

const RevokeLimitedRepoFromUser = `
DELETE FROM soma.authorizations_repository
WHERE grant_id = $1::uuid;`

const SearchGlobalSystemGrant = `` /* 208-byte string literal not displayed */

const SearchPermissionByName = `
SELECT permission_id,
       permission_name
FROM   soma.permissions
WHERE  permission_name = $1::varchar;`

const SearchServerByAssetId = `` /* 233-byte string literal not displayed */

const SearchServerByName = `` /* 229-byte string literal not displayed */

const SelectRootToken = `
SELECT token
FROM   root.token;`

the bootstrap token to initialize the system

const SelectToken = `
SELECT salt,
       valid_from,
       valid_until
FROM   auth.tokens
WHERE  token = $1::varchar;`

lookup a specific token (readonly instances)

const SetRootCredentials = `` /* 304-byte string literal not displayed */

const SetUserCredential = `` /* 287-byte string literal not displayed */

const ShowCapability = `` /* 339-byte string literal not displayed */

const ShowConfigNodes = `` /* 315-byte string literal not displayed */

const ShowMonitoringSystem = `` /* 229-byte string literal not displayed */

const ShowNodes = `` /* 205-byte string literal not displayed */

const ShowPermission = `` /* 245-byte string literal not displayed */

const ShowPermissionCategory = `` /* 206-byte string literal not displayed */

const ShowRepository = `` /* 184-byte string literal not displayed */

const ShowServers = `` /* 226-byte string literal not displayed */

const ShowTeams = `` /* 208-byte string literal not displayed */

const ShowUsers = `` /* 285-byte string literal not displayed */

const SyncNodes = `` /* 164-byte string literal not displayed */

const SyncServers = `` /* 263-byte string literal not displayed */

const SyncTeams = `` /* 211-byte string literal not displayed */

const SyncUsers = `` /* 239-byte string literal not displayed */

const TreeBucketsInRepository = `
SELECT bucket_id
FROM   soma.buckets
WHERE  repository_id = $1::uuid;`

const TreeClustersInBucket = `
SELECT cluster_id
FROM   soma.clusters
WHERE  bucket_id = $1::uuid
AND    object_state = 'standalone';`

const TreeClustersInGroup = `
SELECT sgmc.child_cluster_id
FROM   soma.group_membership_clusters sgmc
WHERE  sgmc.group_id = $1::uuid;`

clustersingroup

const TreeGroupsInBucket = `
SELECT group_id
FROM   soma.groups
WHERE  bucket_id = $1::uuid
AND    object_state = 'standalone';`

const TreeGroupsInGroup = `
SELECT sgmg.child_group_id
FROM   soma.group_membership_groups sgmg
WHERE  sgmg.group_id = $1::uuid;`

groupsingroup

const TreeNodesInBucket = `` /* 186-byte string literal not displayed */

const TreeNodesInCluster = `
SELECT scm.node_id
FROM   soma.cluster_membership scm
WHERE  scm.cluster_id = $1::uuid;`

nodesincluster

const TreeNodesInGroup = `
SELECT sgmn.child_node_id
FROM   soma.group_membership_nodes sgmn
WHERE  sgmn.group_id = $1::uuid;`

nodesingroup

const TreeShowBucket = `` /* 203-byte string literal not displayed */

const TreeShowCluster = `` /* 191-byte string literal not displayed */

const TreeShowGroup = `` /* 185-byte string literal not displayed */

const TreeShowNode = `` /* 486-byte string literal not displayed */

const TreeShowRepository = `` /* 194-byte string literal not displayed */

const TxDeleteCheckDetails = `` /* 334-byte string literal not displayed */

const TxMarkCheckConfigDeleted = `
UPDATE soma.check_configurations
SET    deleted = 'yes'::boolean
WHERE  configuration_id = $1::uuid;`

const TxMarkCheckDeleted = `
UPDATE soma.checks
SET    deleted = 'yes'::boolean
WHERE  check_id = $1::uuid;`

const TxMarkCheckInstanceDeleted = `
UPDATE soma.check_instances
SET    deleted = 'yes'::boolean
WHERE  check_instance_id = $1::uuid;`

const UpdateServers = `` /* 292-byte string literal not displayed */