query.properties

来自「找了很久才找到到源代码」· PROPERTIES 代码 · 共 2,408 行 · 第 1/4 页

PROPERTIES
2,408 行
字号
1234
C_PRINCIPALS_HISTORY_ID=PRINCIPAL_ID
C_PRINCIPALS_HISTORY_NAME=PRINCIPAL_NAME
C_PRINCIPALS_HISTORY_DESCRIPTION=PRINCIPAL_DESCRIPTION
C_PRINCIPALS_HISTORY_EMAIL=PRINCIPAL_EMAIL
C_PRINCIPALS_HISTORY_OU=PRINCIPAL_OU
C_PRINCIPALS_HISTORY_TYPE=PRINCIPAL_TYPE
C_PRINCIPALS_HISTORY_USERDELETED=PRINCIPAL_USERDELETED
C_PRINCIPALS_HISTORY_DATEDELETED=PRINCIPAL_DATEDELETED

C_PRINCIPAL_HISTORY_ATTRIBS=\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_ID,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_NAME,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_DESCRIPTION,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_OU,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_EMAIL,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_TYPE,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_USERDELETED,\
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_DATEDELETED

C_HISTORY_PRINCIPAL_CREATE=\
INSERT INTO CMS_HISTORY_PRINCIPALS \
	(PRINCIPAL_ID,\
	PRINCIPAL_NAME,\
	PRINCIPAL_DESCRIPTION,\
	PRINCIPAL_OU,\
	PRINCIPAL_EMAIL,\
	PRINCIPAL_TYPE,\
	PRINCIPAL_USERDELETED,\
	PRINCIPAL_DATEDELETED) \
VALUES \
	(?,?,?,?,?,?,?,?)
	
C_HISTORY_PRINCIPAL_READ=\
SELECT \
	${C_PRINCIPAL_HISTORY_ATTRIBS} \
FROM \
	CMS_HISTORY_PRINCIPALS \
WHERE \
	CMS_HISTORY_PRINCIPALS.PRINCIPAL_ID=?

C_PROJECTS_HISTORY_READ_TAG_FOR_DATE=\
SELECT \
	MAX(CMS_HISTORY_PROJECTS.PUBLISH_TAG) \
FROM \
	CMS_HISTORY_PROJECTS \
WHERE \
	CMS_HISTORY_PROJECTS.PROJECT_PUBLISHDATE<?

		
C_HISTORY_EXISTS_RESOURCE=\
SELECT \
	CMS_HISTORY_RESOURCES.RESOURCE_ID \
FROM \
	CMS_HISTORY_RESOURCES \
WHERE \
	CMS_HISTORY_RESOURCES.RESOURCE_ID=? \
	AND CMS_HISTORY_RESOURCES.PUBLISH_TAG=?


C_STRUCTURE_HISTORY_READ_SUBRESOURCES=\
SELECT DISTINCT \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID, MAX(CMS_HISTORY_STRUCTURE.VERSION) \
FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
    CMS_HISTORY_STRUCTURE.PARENT_ID=? \
GROUP BY \
    CMS_HISTORY_STRUCTURE.STRUCTURE_ID


C_STRUCTURE_HISTORY_READ_NOTDELETED=\
SELECT \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID, MAX(CMS_HISTORY_STRUCTURE.VERSION) \
FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
    CMS_HISTORY_STRUCTURE.STRUCTURE_ID IN (SELECT CMS_ONLINE_STRUCTURE.STRUCTURE_ID FROM CMS_ONLINE_STRUCTURE) \
GROUP BY \
    CMS_HISTORY_STRUCTURE.STRUCTURE_ID

    
C_STRUCTURE_HISTORY_READ_DELETED=\
SELECT \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID, MAX(CMS_HISTORY_STRUCTURE.VERSION) \
FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
    CMS_HISTORY_STRUCTURE.STRUCTURE_ID NOT IN (SELECT CMS_ONLINE_STRUCTURE.STRUCTURE_ID FROM CMS_ONLINE_STRUCTURE) \
GROUP BY \
    CMS_HISTORY_STRUCTURE.STRUCTURE_ID

C_HISTORY_READ_MAXTAG_FOR_VERSION=\
SELECT \
	MAX(CMS_HISTORY_STRUCTURE.PUBLISH_TAG) \
FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID=? \
	AND CMS_HISTORY_STRUCTURE.VERSION<?


C_PROPERTIES_HISTORY_DELETE=\
DELETE FROM \
	CMS_HISTORY_PROPERTIES \
WHERE \
	CMS_HISTORY_PROPERTIES.STRUCTURE_ID=? \
	AND CMS_HISTORY_PROPERTIES.PUBLISH_TAG<?


C_STRUCTURE_HISTORY_DELETE=\
DELETE FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID=? \
	AND CMS_HISTORY_STRUCTURE.PUBLISH_TAG<?


C_HISTORY_READ_MIN_USED_TAG=\
SELECT \
	MIN(PUBLISH_TAG) \
FROM \
	CMS_HISTORY_STRUCTURE \
WHERE \
	CMS_HISTORY_STRUCTURE.RESOURCE_ID=?


C_RESOURCES_HISTORY_DELETE=\
DELETE FROM \
	CMS_HISTORY_RESOURCES \
WHERE \
	CMS_HISTORY_RESOURCES.RESOURCE_ID=? \
	AND CMS_HISTORY_RESOURCES.PUBLISH_TAG<?


C_CONTENT_HISTORY_DELETE=\
DELETE FROM \
	CMS_CONTENTS \
WHERE \
	CMS_CONTENTS.ONLINE_FLAG = 0 \
	AND CMS_CONTENTS.RESOURCE_ID=? \
	AND CMS_CONTENTS.PUBLISH_TAG_TO<?


#
# Warning: Expects C_STATE_DELETED = 3 and all states >= 0 / <= 3
#
C_SELECT_NONDELETED_VFS_SIBLINGS=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID=? \
	AND CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE IN(0,1,2) \
	AND ${C_JOIN_STRUCTURE_RESOURCE} \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC

	
C_SELECT_VFS_SIBLINGS=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE} \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC	
			
#
#	Access Control Entries
#
C_ACCESS_RESOURCE_ID_0=RESOURCE_ID
C_ACCESS_PRINCIPAL_ID_0=PRINCIPAL_ID
C_ACCESS_ACCESS_ALLOWED_0=ACCESS_ALLOWED
C_ACCESS_ACCESS_DENIED_0=ACCESS_DENIED
C_ACCESS_ACCESS_FLAGS_0=ACCESS_FLAGS

C_ACCESS_CREATE_5=\
INSERT INTO CMS_${PROJECT}_ACCESSCONTROL \
	(RESOURCE_ID,\
	PRINCIPAL_ID,\
	ACCESS_ALLOWED,\
	ACCESS_DENIED,\
	ACCESS_FLAGS) \
VALUES \
	(?,?,?,?,?)
	
	
C_ACCESS_UPDATE_5=\
UPDATE \
	CMS_${PROJECT}_ACCESSCONTROL \
SET \
	ACCESS_ALLOWED=?,\
	ACCESS_DENIED=?,\
	ACCESS_FLAGS=? \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=? \
	AND CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID = ?
	
	
C_ACCESS_SET_FLAGS_ALL_2=\
UPDATE \
	CMS_${PROJECT}_ACCESSCONTROL \
SET \
	ACCESS_FLAGS=ACCESS_FLAGS+? \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=?
	
	
C_ACCESS_REMOVE_2=\
DELETE FROM \
	CMS_${PROJECT}_ACCESSCONTROL \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=? \
	AND CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID = ?
	
	
C_ACCESS_REMOVE_ALL_1=\
DELETE FROM \
	CMS_${PROJECT}_ACCESSCONTROL \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=?
	
C_ACCESS_REMOVE_ALL_FOR_PRINCIPAL_1=\
DELETE FROM \
	CMS_${PROJECT}_ACCESSCONTROL \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID=?

	
C_ACCESS_READ_ENTRY_2=\
SELECT \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID,\
	CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_ALLOWED,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_DENIED,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_FLAGS \
FROM \
	CMS_${PROJECT}_ACCESSCONTROL \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=? \
	AND CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID = ?
	
		
C_ACCESS_READ_ENTRIES_1=\
SELECT \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID,\
	CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_ALLOWED,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_DENIED,\
	CMS_${PROJECT}_ACCESSCONTROL.ACCESS_FLAGS \
FROM \
	CMS_${PROJECT}_ACCESSCONTROL \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=?

	
C_SELECT_PUBLISHED_RESOURCES=\
SELECT \
	CMS_PUBLISH_HISTORY.STRUCTURE_ID,\
	CMS_PUBLISH_HISTORY.RESOURCE_ID,\
	CMS_PUBLISH_HISTORY.RESOURCE_PATH,\
	CMS_PUBLISH_HISTORY.RESOURCE_STATE,\
	CMS_PUBLISH_HISTORY.RESOURCE_TYPE,\
	CMS_PUBLISH_HISTORY.SIBLING_COUNT,\
	CMS_PUBLISH_HISTORY.PUBLISH_TAG \
FROM \
	CMS_PUBLISH_HISTORY \
WHERE \
	CMS_PUBLISH_HISTORY.HISTORY_ID=? \
ORDER BY \
	CMS_PUBLISH_HISTORY.RESOURCE_TYPE ASC,\
	CMS_PUBLISH_HISTORY.RESOURCE_STATE ASC,\
	CMS_PUBLISH_HISTORY.RESOURCE_PATH ASC

C_DELETE_PUBLISH_HISTORY=\
DELETE FROM \
	CMS_PUBLISH_HISTORY \
WHERE \
	CMS_PUBLISH_HISTORY.PUBLISH_TAG>=0 \
	AND CMS_PUBLISH_HISTORY.PUBLISH_TAG<?
	
#
# Publish jobs
#
C_PUBLISHJOB_CREATE=\
INSERT INTO CMS_PUBLISH_JOBS \
	(HISTORY_ID,\
	PROJECT_ID,\
	PROJECT_NAME,\
	USER_ID,\
	PUBLISH_LOCALE,\
	PUBLISH_FLAGS,\
	RESOURCE_COUNT,\
	ENQUEUE_TIME,\
	START_TIME,\
	FINISH_TIME, \
	PUBLISH_LIST) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?,?)
	
C_PUBLISHJOB_DELETE=\
DELETE FROM \
	CMS_PUBLISH_JOBS \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
C_PUBLISHJOB_DELETE_PUBLISHLIST=\
UPDATE \
	CMS_PUBLISH_JOBS \
SET \
	PUBLISH_LIST=NULL \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
C_PUBLISHJOB_READ_JOBS_IN_TIMERANGE=\
SELECT \
	CMS_PUBLISH_JOBS.HISTORY_ID,\
	CMS_PUBLISH_JOBS.PROJECT_ID,\
	CMS_PUBLISH_JOBS.PROJECT_NAME,\
	CMS_PUBLISH_JOBS.USER_ID,\
	CMS_PUBLISH_JOBS.PUBLISH_LOCALE,\
	CMS_PUBLISH_JOBS.PUBLISH_FLAGS,\
	CMS_PUBLISH_JOBS.RESOURCE_COUNT,\
	CMS_PUBLISH_JOBS.ENQUEUE_TIME,\
	CMS_PUBLISH_JOBS.START_TIME,\
	CMS_PUBLISH_JOBS.FINISH_TIME \
FROM \
	CMS_PUBLISH_JOBS \
WHERE \
	CMS_PUBLISH_JOBS.FINISH_TIME>=? \
	AND CMS_PUBLISH_JOBS.FINISH_TIME<=? \
ORDER BY \
	CMS_PUBLISH_JOBS.ENQUEUE_TIME ASC	

C_PUBLISHJOB_READ_JOB=\
SELECT \
	CMS_PUBLISH_JOBS.HISTORY_ID,\
	CMS_PUBLISH_JOBS.PROJECT_ID,\
	CMS_PUBLISH_JOBS.PROJECT_NAME,\
	CMS_PUBLISH_JOBS.USER_ID,\
	CMS_PUBLISH_JOBS.PUBLISH_LOCALE,\
	CMS_PUBLISH_JOBS.PUBLISH_FLAGS,\
	CMS_PUBLISH_JOBS.RESOURCE_COUNT,\
	CMS_PUBLISH_JOBS.ENQUEUE_TIME,\
	CMS_PUBLISH_JOBS.START_TIME,\
	CMS_PUBLISH_JOBS.FINISH_TIME \
FROM \
	CMS_PUBLISH_JOBS \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
C_PUBLISHJOB_READ_PUBLISHLIST=\
SELECT \
	CMS_PUBLISH_JOBS.HISTORY_ID, \
	CMS_PUBLISH_JOBS.PROJECT_ID, \
	CMS_PUBLISH_JOBS.PUBLISH_LIST \
FROM \
	CMS_PUBLISH_JOBS \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?	
	
C_PUBLISHJOB_READ_REPORT=\
SELECT \
	CMS_PUBLISH_JOBS.PUBLISH_REPORT \
FROM \
	CMS_PUBLISH_JOBS \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
C_PUBLISHJOB_WRITE=\
UPDATE \
	CMS_PUBLISH_JOBS \
SET \
	PROJECT_ID=?,\
	PROJECT_NAME=?,\
	USER_ID=?,\
	PUBLISH_LOCALE=?,\
	PUBLISH_FLAGS=?,\
	RESOURCE_COUNT=?,\
	ENQUEUE_TIME=?,\
	START_TIME=?,\
	FINISH_TIME=? \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
C_PUBLISHJOB_WRITE_REPORT=\
UPDATE \
	CMS_PUBLISH_JOBS \
SET \
	PUBLISH_REPORT=? \
WHERE \
	CMS_PUBLISH_JOBS.HISTORY_ID=?
	
#	
# Static export
#
C_STATICEXPORT_WRITE_PUBLISHED_LINKS=\
INSERT INTO CMS_STATICEXPORT_LINKS \
	(LINK_ID,\
	LINK_RFS_PATH,\
	LINK_TYPE,\
	LINK_PARAMETER,\
	LINK_TIMESTAMP) \
VALUES \
	(?,?,?,?,?)

   
C_STATICEXPORT_READ_PUBLISHED_RESOURCES=\
SELECT \
	COUNT(*) \
FROM \
	CMS_STATICEXPORT_LINKS \
WHERE \
	CMS_STATICEXPORT_LINKS.LINK_RFS_PATH=?    
	

C_STATICEXPORT_DELETE_PUBLISHED_LINKS=\
DELETE FROM \
	CMS_STATICEXPORT_LINKS \
WHERE \
	CMS_STATICEXPORT_LINKS.LINK_RFS_PATH=? \
	AND CMS_STATICEXPORT_LINKS.LINK_TYPE=? \
	AND CMS_STATICEXPORT_LINKS.LINK_PARAMETER=?	

 
C_STATICEXPORT_DELETE_ALL_PUBLISHED_LINKS=\
DELETE FROM \
	CMS_STATICEXPORT_LINKS \
WHERE \
	CMS_STATICEXPORT_LINKS.LINK_TYPE=? 	
  
C_STATICEXPORT_READ_ALL_PUBLISHED_LINKS=\
SELECT \
	CMS_STATICEXPORT_LINKS.LINK_RFS_PATH \
FROM \
	CMS_STATICEXPORT_LINKS \
WHERE \
	CMS_STATICEXPORT_LINKS.LINK_TYPE=? \
	AND CMS_STATICEXPORT_LINKS.LINK_TIMESTAMP>=? 
 
 
C_STATICEXPORT_READ_PUBLISHED_LINK_PARAMETERS=\
SELECT \
	CMS_STATICEXPORT_LINKS.LINK_PARAMETER \
FROM \
	CMS_STATICEXPORT_LINKS \
WHERE \
	CMS_STATICEXPORT_LINKS.LINK_RFS_PATH=?

C_SELECT_RESOURCES_FOR_PRINCIPAL_ATTR=\
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_RESOURCES.USER_CREATED=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE}) \
UNION \
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_RESOURCES.USER_LASTMODIFIED=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE}) 
	
C_SELECT_RESOURCES_FOR_PRINCIPAL_ACE=\
SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
	CMS_${PROJECT}_ACCESSCONTROL, \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_ACCESSCONTROL.PRINCIPAL_ID=? \
	AND CMS_${PROJECT}_ACCESSCONTROL.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND ${C_JOIN_STRUCTURE_RESOURCE} \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH ASC

C_RESOURCES_DELETE_PUBLISH_HISTORY_ENTRY=\
DELETE FROM \
    CMS_PUBLISH_HISTORY \
WHERE \
    CMS_PUBLISH_HISTORY.HISTORY_ID = ? \
    AND CMS_PUBLISH_HISTORY.PUBLISH_TAG = ? \
    AND CMS_PUBLISH_HISTORY.STRUCTURE_ID = ? \
    AND CMS_PUBLISH_HISTORY.RESOURCE_PATH = ?

#
# Content Relation Engine table columns
#
C_RELATION_SOURCE_ID=RELATION_SOURCE_ID
C_RELATION_SOURCE_PATH=RELATION_SOURCE_PATH
C_RELATION_TARGET_ID=RELATION_TARGET_ID
C_RELATION_TARGET_PATH=RELATION_TARGET_PATH
C_RELATION_TYPE=RELATION_TYPE
# All attributes to select
C_RELATIONS_SELECT_ATTRIBS=\
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_SOURCE_ID,\
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_SOURCE_PATH,\
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_ID,\
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH,\
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE


#
# Content Relation Engine filter conditions
#
C_RELATION_FILTER_SOURCE_ID=CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_SOURCE_ID = ?
C_RELATION_FILTER_SOURCE_PATH=CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_SOURCE_PATH LIKE ?
C_RELATION_FILTER_TARGET_ID=CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_ID = ?
C_RELATION_FILTER_TARGET_PATH=CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH LIKE ?
C_RELATION_FILTER_TYPE=CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE IN 


#
# Relation creation query
#
C_CREATE_RELATION=\
INSERT INTO CMS_${PROJECT}_RESOURCE_RELATIONS \
	(RELATION_SOURCE_ID,\
	RELATION_SOURCE_PATH,\
	RELATION_TARGET_ID,\
	RELATION_TARGET_PATH,\
	RELATION_TYPE) \
VALUES \
	(?,?,?,?,?)


C_READ_RELATIONS=\
SELECT DISTINCT \
	${C_RELATIONS_SELECT_ATTRIBS} \
FROM \
	CMS_${PROJECT}_RESOURCE_RELATIONS \
WHERE
# the conditions are build in the vfs driver


C_MOVE_RELATIONS_SOURCE=\
UPDATE \
	CMS_${PROJECT}_RESOURCE_RELATIONS \
SET \
	RELATION_SOURCE_PATH=? \
WHERE \
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_SOURCE_ID=?


C_MOVE_RELATIONS_TARGET=\
UPDATE \
	CMS_${PROJECT}_RESOURCE_RELATIONS \
SET \
	RELATION_TARGET_PATH=? \
WHERE \
	CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_ID=?


C_DELETE_RELATIONS=\
DELETE FROM \
    CMS_${PROJECT}_RESOURCE_RELATIONS \
WHERE
# the conditions are build in the vfs driver

C_RELATIONS_REPAIR_BROKEN=\
UPDATE \
    CMS_${PROJECT}_RESOURCE_RELATIONS \
SET \
    RELATION_TARGET_ID = ? \
WHERE \
    CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH = ? \
    AND CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_ID NOT IN (SELECT CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID FROM CMS_${PROJECT}_STRUCTURE)

C_RELATIONS_UPDATE_BROKEN=\
UPDATE \
    CMS_${PROJECT}_RESOURCE_RELATIONS \
SET \
    RELATION_TARGET_ID = '00000000-0000-0000-0000-000000000000' \
WHERE \
    CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH = ? \
    AND CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_ID NOT IN (SELECT CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID FROM CMS_${PROJECT}_STRUCTURE)

C_READ_STRUCTURE_STATE=\
SELECT \
    CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE \
FROM \
    CMS_${PROJECT}_STRUCTURE \
WHERE \
    CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID = ?

C_READ_RESOURCE_STATE=\
SELECT \
    CMS_${PROJECT}_RESOURCES.RESOURCE_STATE \
FROM \
    CMS_${PROJECT}_RESOURCES \
WHERE \
    CMS_${PROJECT}_RESOURCES.RESOURCE_ID = ?
1234

query.properties - 源码说明

本页面展示了「找了很久才找到到源代码」中的 query.properties 源码文件，采用 PROPERTIES 编程语言编写，共 2,408 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与源代码相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?