Interface ISqlDialect

Namespace: redb.Core.Query
Assembly: redb.Core.dll

SQL syntax abstraction for different DBMS support.
IMPORTANT: Implementations in different projects MAY DIFFER!

PostgreSqlDialect: CASE WHEN (tested - 15 ms on 15K objects)
MsSqlDialect: will be later, possibly different implementation

Current focus: PostgreSQL + performance.

public interface ISqlDialect

Properties

ProviderName

Provider name (PostgreSQL, SqlServer, MySql)

string ProviderName { get; }

Methods

FormatArrayContains(string, string)

Array containment check: = ANY($1) for PostgreSQL, IN for MSSQL

string FormatArrayContains(string column, string paramName)

FormatPagination(int?, int?)

Pagination format: LIMIT/OFFSET for PostgreSQL, TOP/OFFSET for MSSQL

string FormatPagination(int? limit, int? offset)

FormatParameter(int)

Parameter format: $1 for PostgreSQL, for MSSQL

string FormatParameter(int index)

FormatPvtColumn(long, string, string)

PVT column for CASE WHEN approach.

string FormatPvtColumn(long structureId, string dbColumn, string alias)

GetDbTypeName(string)

Mapping of redb types to SQL types

string GetDbTypeName(string redbType)

LazyLoader_GetObjectJson()

Get object as JSON via get_object_json. Params: $1=objectId, $2=maxDepth

string LazyLoader_GetObjectJson()

LazyLoader_GetObjectJsonBatch()

Get multiple objects as JSON via get_object_json batch. Params: $1=objectIds array

string LazyLoader_GetObjectJsonBatch()

LazyLoader_SelectObjectBase()

Get object base fields (without Props). Params: $1=objectId

string LazyLoader_SelectObjectBase()

LazyLoader_SelectObjectHash()

Get object hash for cache validation. Params: $1=objectId

string LazyLoader_SelectObjectHash()

ListItems_Delete()

DELETE list item by ID. Params: $1=itemId

string ListItems_Delete()

ListItems_Insert()

INSERT list item. Params: $1=id, $2=idList, $3=value, $4=alias, $5=idObject

string ListItems_Insert()

ListItems_SelectById()

SELECT list item by ID. Params: $1=itemId

string ListItems_SelectById()

ListItems_SelectByListId()

SELECT list items by list ID. Params: $1=listId

string ListItems_SelectByListId()

ListItems_SelectByListIdAndValue()

SELECT list item by list ID and value. Params: $1=listId, $2=value

string ListItems_SelectByListIdAndValue()

ListItems_SelectByObjectId()

SELECT list items by object reference. Params: $1=objectId

string ListItems_SelectByObjectId()

ListItems_Update()

UPDATE list item. Params: $1=value, $2=alias, $3=idObject, $4=id

string ListItems_Update()

ListItems_UpdateAliasAndObject()

UPDATE list item alias and idObject. Params: $1=alias, $2=idObject, $3=id

string ListItems_UpdateAliasAndObject()

Lists_Delete()

DELETE list by ID. Params: $1=listId

string Lists_Delete()

Lists_Insert()

INSERT new list. Params: $1=id, $2=name, $3=alias

string Lists_Insert()

Lists_IsUsedInStructures()

Check if list is used in structures. Params: $1=listId

string Lists_IsUsedInStructures()

Lists_SelectAll()

SELECT all lists ordered by name.

string Lists_SelectAll()

Lists_SelectById()

SELECT list by ID. Params: $1=listId

string Lists_SelectById()

Lists_SelectByName()

SELECT list by name. Params: $1=name

string Lists_SelectByName()

Lists_Update()

UPDATE list. Params: $1=name, $2=alias, $3=id

string Lists_Update()

ObjectStorage_CheckObjectExists()

Check if object exists by ID. Params: $1=objectId

string ObjectStorage_CheckObjectExists()

ObjectStorage_DeleteById()

DELETE object by ID. Params: $1=objectId

string ObjectStorage_DeleteById()

ObjectStorage_DeleteByIds()

DELETE objects by IDs (bulk). Params: $1=objectIds (array)

string ObjectStorage_DeleteByIds()

ObjectStorage_DeleteValuesByObjectId()

DELETE all values for object. Params: $1=objectId

string ObjectStorage_DeleteValuesByObjectId()

ObjectStorage_GetObjectJson()

SELECT object as JSON. Params: $1=objectId, $2=depth

string ObjectStorage_GetObjectJson()

ObjectStorage_GetObjectsJsonBulk()

SELECT objects as JSON (bulk). Params: $1=objectIds (array), $2=depth

string ObjectStorage_GetObjectsJsonBulk()

ObjectStorage_InsertObject()

INSERT new object with all fields.

string ObjectStorage_InsertObject()

ObjectStorage_LockObjectsForUpdate()

Lock objects for update (row locking). Params: $1=objectIds (array)

string ObjectStorage_LockObjectsForUpdate()

ObjectStorage_SelectAllTypes()

SELECT all types (for cache preload). No params.

string ObjectStorage_SelectAllTypes()

ObjectStorage_SelectExistingIds()

SELECT existing object IDs from array. Params: $1=objectIds (array)

string ObjectStorage_SelectExistingIds()

ObjectStorage_SelectIdHash()

SELECT only Id and Hash for object. Params: $1=objectId

string ObjectStorage_SelectIdHash()

ObjectStorage_SelectIdHashScheme()

SELECT Id, Hash, IdScheme for cache check. Params: $1=objectId

string ObjectStorage_SelectIdHashScheme()

ObjectStorage_SelectObjectById()

SELECT all base fields for object by ID. Params: $1=objectId

string ObjectStorage_SelectObjectById()

ObjectStorage_SelectObjectsByIds()

SELECT all base fields for objects by IDs. Params: $1=objectIds (array)

string ObjectStorage_SelectObjectsByIds()

ObjectStorage_SelectSchemeById()

SELECT scheme by ID. Params: $1=schemeId

string ObjectStorage_SelectSchemeById()

ObjectStorage_SelectSchemeIdByObjectId()

SELECT scheme ID for object. Params: $1=objectId

string ObjectStorage_SelectSchemeIdByObjectId()

ObjectStorage_SelectSchemeIdsForObjects()

SELECT scheme IDs for objects. Params: $1=objectIds (array)

string ObjectStorage_SelectSchemeIdsForObjects()

ObjectStorage_SelectSchemesByIds()

SELECT schemes by IDs. Params: $1=schemeIds (array)

string ObjectStorage_SelectSchemesByIds()

ObjectStorage_SelectStructuresWithMetadata()

SELECT structure metadata by scheme ID. Params: $1=schemeId

string ObjectStorage_SelectStructuresWithMetadata()

ObjectStorage_SelectStructureTypes()

SELECT structure types by IDs. Params: $1=structureIds (array)

string ObjectStorage_SelectStructureTypes()

ObjectStorage_SelectTypeById()

SELECT type info by ID. Params: $1=typeId

string ObjectStorage_SelectTypeById()

ObjectStorage_SelectValueById()

SELECT single value by ID. Params: $1=valueId

string ObjectStorage_SelectValueById()

ObjectStorage_SelectValuesForObjects()

SELECT all values for object IDs (ChangeTracking). Params: $1=objectIds (array)

string ObjectStorage_SelectValuesForObjects()

ObjectStorage_SelectValuesWithTypes()

SELECT existing values with types. Params: $1=objectId, $2=structureIds (array)

string ObjectStorage_SelectValuesWithTypes()

ObjectStorage_UpdateObject()

UPDATE object with all fields.

string ObjectStorage_UpdateObject()

Permissions_Count()

SELECT COUNT of all permissions

string Permissions_Count()

Permissions_CountByRole()

SELECT COUNT of permissions by role. Params: $1=roleId

string Permissions_CountByRole()

Permissions_CountByUser()

SELECT COUNT of permissions by user. Params: $1=userId

string Permissions_CountByUser()

Permissions_Delete()

DELETE permission by ID. Params: $1=permissionId

string Permissions_Delete()

Permissions_DeleteByRole()

DELETE permissions by role. Params: $1=roleId

string Permissions_DeleteByRole()

Permissions_DeleteByUser()

DELETE all permissions by user. Params: $1=userId

string Permissions_DeleteByUser()

Permissions_DeleteByUserRoleObject()

DELETE permission by user/role/object. Params: $1=userId, $2=roleId, $3=objectId

string Permissions_DeleteByUserRoleObject()

Permissions_GetEffectiveForObject()

Get user permissions for object via SQL function or query.

string Permissions_GetEffectiveForObject()

Permissions_Insert()

INSERT new permission. Params: $1=id, $2=userId, $3=roleId, $4=refId, $5=select, $6=insert, $7=update, $8=delete

string Permissions_Insert()

Permissions_SelectById()

SELECT permission by ID. Params: $1=permissionId

string Permissions_SelectById()

Permissions_SelectByObject()

SELECT permissions by object. Params: $1=objectId

string Permissions_SelectByObject()

Permissions_SelectByRole()

SELECT permissions by role. Params: $1=roleId

string Permissions_SelectByRole()

Permissions_SelectByUser()

SELECT permissions by user. Params: $1=userId

string Permissions_SelectByUser()

Permissions_SelectByUserRoleObject()

SELECT permission by user/role/object. Params: $1=userId, $2=roleId, $3=objectId

string Permissions_SelectByUserRoleObject()

Permissions_SelectReadableObjectIds()

SELECT readable object IDs for user. Params: $1=userId

string Permissions_SelectReadableObjectIds()

Permissions_SelectUserRoleIds()

SELECT user's role IDs. Params: $1=userId

string Permissions_SelectUserRoleIds()

Permissions_Update()

UPDATE permission flags. Params: $1=select, $2=insert, $3=update, $4=delete, $5=permissionId

string Permissions_Update()

Query_AggregateArrayGroupedSql()

SQL for array grouped aggregation.

string Query_AggregateArrayGroupedSql()

Query_AggregateBatchPreviewSql()

SQL for aggregate batch preview.

string Query_AggregateBatchPreviewSql()

Query_AggregateBatchSql()

SQL for aggregate batch function.

string Query_AggregateBatchSql()

Query_AggregateFieldSql()

SQL for aggregate field.

string Query_AggregateFieldSql()

Query_AggregateGroupedSql()

SQL for grouped aggregation.

string Query_AggregateGroupedSql()

Query_BigintArrayCast()

Bigint array cast. PostgreSQL: "::bigint[]"

string Query_BigintArrayCast()

Query_CheckPermissionSql()

SQL for checking user permission on object.

string Query_CheckPermissionSql()

Query_CountTemplate()

SQL template for COUNT query. Params: functionName

string Query_CountTemplate()

Query_GetIdsWithAncestorsSql(string)

SQL for getting all IDs with their ancestors using recursive CTE.

string Query_GetIdsWithAncestorsSql(string idsString)

Query_GetParentIdsFromDescendantsSql(string, int)

SQL for getting parent IDs from descendant IDs using recursive CTE.

string Query_GetParentIdsFromDescendantsSql(string idsString, int depthLimit)

Query_HasAncestorNormalSql(string)

SQL for HasAncestor normal search - extracts IDs from JSON result.

string Query_HasAncestorNormalSql(string functionName)

Query_HasAncestorTreeSql(string)

SQL for HasAncestor tree search - extracts IDs from JSON result.

string Query_HasAncestorTreeSql(string functionName)

Query_HasDescendantSql(string)

SQL for HasDescendant search - extracts IDs from JSON result.

string Query_HasDescendantSql(string functionName)

Query_JsonCast()

JSON cast expression for the database.

string Query_JsonCast()

Query_LoadObjectsByIdsSql(string, int)

SQL for loading objects by IDs as JSON.

string Query_LoadObjectsByIdsSql(string idsString, int maxDepth)

Query_ProjectionByIdsTemplate(string)

SQL for projection by structure IDs query.

string Query_ProjectionByIdsTemplate(string structureIdsArray)

Query_ProjectionByPathsTemplate()

SQL for projection by paths query.

string Query_ProjectionByPathsTemplate()

Query_SearchFullTemplate()

SQL template for full search query with distinct and facets. Params: functionName

string Query_SearchFullTemplate()

Query_SearchObjectsBaseFunction()

Name of the search function for objects base fields only (lazy loading).

string Query_SearchObjectsBaseFunction()

Query_SearchObjectsFunction()

Name of the search function for objects with facets (eager loading).

string Query_SearchObjectsFunction()

Query_SearchObjectsProjectionByIdsFunction()

Name of the search function with projection by IDs.

string Query_SearchObjectsProjectionByIdsFunction()

Query_SearchObjectsProjectionByPathsFunction()

Name of the search function with projection by paths.

string Query_SearchObjectsProjectionByPathsFunction()

Query_SearchObjectsSimpleSql()

SQL for simple search objects (used in distinct).

string Query_SearchObjectsSimpleSql()

Query_SearchTemplate()

SQL template for search query result. Params: functionName

string Query_SearchTemplate()

Query_SearchTreeObjectsBaseFunction()

Name of the tree search function base fields only (lazy loading).

string Query_SearchTreeObjectsBaseFunction()

Query_SearchTreeObjectsFunction()

Name of the tree search function (eager loading).

string Query_SearchTreeObjectsFunction()

Query_SearchWithDistinctTemplate()

SQL template for search query with distinct. Params: functionName

string Query_SearchWithDistinctTemplate()

Query_SqlPreviewBaseFunction()

SQL preview function name for base (lazy loading) search.

string Query_SqlPreviewBaseFunction()

Query_SqlPreviewFunction()

SQL preview function name for regular search.

string Query_SqlPreviewFunction()

Query_SqlPreviewTemplate()

SQL for SQL preview function.

string Query_SqlPreviewTemplate()

Query_TextArrayCast()

Text array cast. PostgreSQL: "::text[]"

string Query_TextArrayCast()

Query_TreeCountNormalSql(string)

SQL for tree count query (normal search).

string Query_TreeCountNormalSql(string functionName)

Query_TreeCountWithParentIdsSql(string)

SQL for tree COUNT with parent_ids array.

string Query_TreeCountWithParentIdsSql(string functionName)

Query_TreeSearchNormalSql(string)

SQL for tree search query (normal search).

string Query_TreeSearchNormalSql(string functionName)

Query_TreeSearchWithParentIdsSql(string)

SQL for tree search with multiple parent IDs.

string Query_TreeSearchWithParentIdsSql(string functionName)

Query_TreeSqlPreviewBaseFunction()

SQL preview function name for tree base (lazy loading) search.

string Query_TreeSqlPreviewBaseFunction()

Query_TreeSqlPreviewFunction()

SQL preview function name for tree search.

string Query_TreeSqlPreviewFunction()

Query_TreeSqlPreviewTemplate(string)

SQL for tree SQL preview.

string Query_TreeSqlPreviewTemplate(string functionName)

Query_WindowSql()

SQL for window query.

string Query_WindowSql()

QuoteIdentifier(string)

Identifier escaping: "name" for PostgreSQL, [name] for MSSQL

string QuoteIdentifier(string name)

Roles_Count()

SELECT COUNT of all roles

string Roles_Count()

Roles_Delete()

DELETE role by ID. Params: $1=roleId

string Roles_Delete()

Roles_ExistsById()

Check role exists by ID. Params: $1=roleId

string Roles_ExistsById()

Roles_ExistsByName()

Check if role name exists (excluding role). Params: $1=name, $2=excludeId (optional)

string Roles_ExistsByName()

Roles_ExistsByNameExcluding()

Check if role name exists excluding specific role. Params: $1=name, $2=excludeId

string Roles_ExistsByNameExcluding()

Roles_Insert()

INSERT new role. Params: $1=id, $2=name

string Roles_Insert()

Roles_SelectAll()

SELECT all roles ordered by name. Returns: Id, Name, IdConfiguration

string Roles_SelectAll()

Roles_SelectById()

SELECT role by ID. Returns: Id, Name, IdConfiguration

string Roles_SelectById()

Roles_SelectByName()

SELECT role by name. Returns: Id, Name, IdConfiguration

string Roles_SelectByName()

Roles_SelectConfigurationId()

SELECT role configuration ID. Params: $1=roleId

string Roles_SelectConfigurationId()

Roles_SelectIdByName()

SELECT role by name. Params: $1=roleName

string Roles_SelectIdByName()

Roles_UpdateConfiguration()

UPDATE role configuration. Params: $1=configId, $2=roleId

string Roles_UpdateConfiguration()

Roles_UpdateName()

UPDATE role name. Params: $1=newName, $2=roleId

string Roles_UpdateName()

Schemes_ExistsByName()

Check scheme exists by name. Params: $1=name

string Schemes_ExistsByName()

Schemes_GetStructureTree()

Get structure tree JSON. Params: $1=schemeId

string Schemes_GetStructureTree()

Schemes_Insert()

INSERT new scheme. Params: $1=id, $2=name, $3=alias, $4=type

string Schemes_Insert()

Schemes_InsertObject()

INSERT Object scheme. Params: $1=id, $2=name, $3=type

string Schemes_InsertObject()

Schemes_MigrateStructureType()

Migrate structure type. Params: $1=structureId, $2=oldType, $3=newType, $4=dryRun

string Schemes_MigrateStructureType()

Schemes_SelectAll()

SELECT all schemes.

string Schemes_SelectAll()

Schemes_SelectById()

SELECT scheme by ID. Params: $1=schemeId

string Schemes_SelectById()

Schemes_SelectByName()

SELECT scheme by name. Params: $1=name

string Schemes_SelectByName()

Schemes_SelectHashById()

SELECT scheme hash by ID. Params: $1=schemeId

string Schemes_SelectHashById()

Schemes_SelectObjectByName()

SELECT Object scheme by name and type. Params: $1=name, $2=type

string Schemes_SelectObjectByName()

Schemes_SyncMetadataCache()

Sync metadata cache for scheme. Params: $1=schemeId

string Schemes_SyncMetadataCache()

Schemes_UpdateHash()

UPDATE scheme structure hash. Params: $1=hash, $2=schemeId

string Schemes_UpdateHash()

Schemes_UpdateName()

Update scheme name by ID.

string Schemes_UpdateName()

SoftDelete_ClaimOrphanedTask()

SQL to atomically claim an orphaned task (prevent race condition in cluster).

string SoftDelete_ClaimOrphanedTask()

SoftDelete_GetDeletionProgress()

SQL query to get deletion progress for a specific trash container.

string SoftDelete_GetDeletionProgress()

SoftDelete_GetOrphanedTasks()

SQL query to get orphaned deletion tasks (for recovery at startup).

string SoftDelete_GetOrphanedTasks()

SoftDelete_GetUserActiveDeletions()

SQL query to get all active deletions for a user.

string SoftDelete_GetUserActiveDeletions()

SoftDelete_MarkForDeletion()

SQL to mark objects for soft-deletion.

string SoftDelete_MarkForDeletion()

SoftDelete_PurgeTrash()

SQL to purge (physically delete) objects from trash container.

string SoftDelete_PurgeTrash()

Structures_DeleteByIds(IEnumerable<long>)

DELETE structures by IDs. Params: dynamic IN clause

string Structures_DeleteByIds(IEnumerable<long> ids)

Structures_Insert()

INSERT new structure.

string Structures_Insert()

Structures_SelectByScheme()

SELECT full structures by scheme. Params: $1=schemeId

string Structures_SelectByScheme()

Structures_SelectBySchemeCacheable()

SELECT structures with cache fields by scheme. Params: $1=schemeId

string Structures_SelectBySchemeCacheable()

Structures_SelectBySchemeShort()

SELECT structures short fields by scheme. Params: $1=schemeId

string Structures_SelectBySchemeShort()

Structures_UpdateAlias()

UPDATE structure alias. Params: $1=alias, $2=structureId

string Structures_UpdateAlias()

Structures_UpdateAllowNotNull()

UPDATE structure allow_not_null. Params: $1=allowNotNull, $2=structureId

string Structures_UpdateAllowNotNull()

Structures_UpdateCollectionType()

UPDATE structure collection type. Params: $1=collectionType, $2=structureId

string Structures_UpdateCollectionType()

Structures_UpdateKeyType()

UPDATE structure key type. Params: $1=keyType, $2=structureId

string Structures_UpdateKeyType()

Structures_UpdateType()

UPDATE structure type. Params: $1=typeId, $2=structureId

string Structures_UpdateType()

Tree_DeleteObjectsByIds()

DELETE objects by IDs. Params: $1=objectIds (array)

string Tree_DeleteObjectsByIds()

Tree_DeleteValuesByObjectIds()

DELETE values by object IDs. Params: $1=objectIds (array)

string Tree_DeleteValuesByObjectIds()

Tree_GetObjectJson()

Get object as JSON. Params: $1=objectId, $2=depth

string Tree_GetObjectJson()

Tree_ObjectExists()

Check if object exists. Params: $1=objectId

string Tree_ObjectExists()

Tree_SelectChildrenBase()

SELECT all children base fields by parent (Pro PVT polymorphic mode).

string Tree_SelectChildrenBase()

Tree_SelectChildrenBySchemeBase()

SELECT children base fields by parent and scheme (Pro PVT mode).

string Tree_SelectChildrenBySchemeBase()

Tree_SelectChildrenJson()

SELECT children with JSON by parent and scheme. Params: $1=parentId, $2=schemeId

string Tree_SelectChildrenJson()

Tree_SelectParentId()

SELECT parent_id by object ID. Params: $1=objectId

string Tree_SelectParentId()

Tree_SelectPolymorphicChildren()

SELECT polymorphic children with scheme. Params: $1=parentId

string Tree_SelectPolymorphicChildren()

Tree_SelectSchemeAndJson()

SELECT scheme and JSON for object. Params: $1=objectId

string Tree_SelectSchemeAndJson()

Tree_UpdateParent()

UPDATE object parent (move). Params: $1=newParentId, $2=dateModify, $3=whoChangeId, $4=objectId

string Tree_UpdateParent()

Types_SelectAll()

SELECT all types. Returns: _id, _name, _db_type, _type

string Types_SelectAll()

Types_SelectByName()

SELECT type by name. Params: $1=name

string Types_SelectByName()

Users_Count()

SELECT COUNT of all users

string Users_Count()

Users_CountEnabled()

SELECT COUNT of enabled users

string Users_CountEnabled()

Users_ExistsByEmail()

Check email exists. Params: $1=email

string Users_ExistsByEmail()

Users_ExistsById()

Check if user exists by ID. Params: $1=userId

string Users_ExistsById()

Users_ExistsByLogin()

Check login exists. Params: $1=login

string Users_ExistsByLogin()

Users_ExistsByLoginExcluding()

Check login exists excluding user. Params: $1=login, $2=excludeUserId

string Users_ExistsByLoginExcluding()

Users_Insert()

INSERT new user with all fields.

string Users_Insert()

Users_SelectById()

SELECT all user fields by ID. Params: $1=userId

string Users_SelectById()

Users_SelectByLogin()

SELECT all user fields by login. Params: $1=login

string Users_SelectByLogin()

Users_SelectConfigurationId()

SELECT user configuration ID. Params: $1=userId

string Users_SelectConfigurationId()

Users_SelectIdByLogin()

SELECT user by login. Params: $1=login. Returns: Id

string Users_SelectIdByLogin()

Users_SoftDelete()

UPDATE user for soft delete. Params: $1=newLogin, $2=newName, $3=enabled, $4=dateDismiss, $5=userId

string Users_SoftDelete()

Users_Update()

UPDATE user fields.

string Users_Update()

Users_UpdateConfiguration()

UPDATE user configuration. Params: $1=configId, $2=userId

string Users_UpdateConfiguration()

Users_UpdatePassword()

UPDATE user password. Params: $1=hashedPassword, $2=userId

string Users_UpdatePassword()

Users_UpdateStatus()

UPDATE user enabled status. Params: $1=enabled, $2=dateDismiss, $3=userId

string Users_UpdateStatus()

UsersRoles_CountByRole()

SELECT COUNT of users for role. Params: $1=roleId

string UsersRoles_CountByRole()

UsersRoles_Delete()

DELETE user-role assignment. Params: $1=userId, $2=roleId

string UsersRoles_Delete()

UsersRoles_DeleteByRole()

DELETE all user-role assignments for role. Params: $1=roleId

string UsersRoles_DeleteByRole()

UsersRoles_DeleteByUser()

DELETE all user-role assignments for user. Params: $1=userId

string UsersRoles_DeleteByUser()

UsersRoles_Exists()

Check if user-role assignment exists. Params: $1=userId, $2=roleId

string UsersRoles_Exists()

UsersRoles_Insert()

INSERT user-role assignment. Params: $1=id, $2=userId, $3=roleId

string UsersRoles_Insert()

UsersRoles_SelectRolesByUser()

SELECT roles for user. Params: $1=userId. Returns: Id, Name, IdConfiguration

string UsersRoles_SelectRolesByUser()

UsersRoles_SelectUsersByRole()

SELECT users for role. Params: $1=roleId. Returns user fields

string UsersRoles_SelectUsersByRole()

Validation_SelectAllTypes()

SELECT all types for validation.

string Validation_SelectAllTypes()

Validation_SelectSchemeByName()

SELECT scheme by name. Params: $1=schemeName

string Validation_SelectSchemeByName()

Validation_SelectStructuresBySchemeId()

SELECT structures by scheme ID. Params: $1=schemeId

string Validation_SelectStructuresBySchemeId()

Warmup_AllMetadataCaches()

SQL to warmup all metadata caches.

string Warmup_AllMetadataCaches()

WrapSubquery(string, string)

Subquery wrapper: (subquery) AS alias

string WrapSubquery(string subquery, string alias)