📄 query.properties

📁 cms是开源的框架
💻 PROPERTIES
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
#
# The pattern _${PROJECT}_ in table names is replaced by the SqlManager with 
# "_ONLINE_" or "_OFFLINE_" to choose the right database tables for
# SQL queries that are project dependent!
#

#
# Project table attribs
#
C_PROJECTS_PROJECT_ID=PROJECT_ID
C_PROJECTS_USER_ID=USER_ID
C_PROJECTS_GROUP_ID=GROUP_ID
C_PROJECTS_MANAGERGROUP_ID=MANAGERGROUP_ID
C_PROJECTS_TASK_ID=TASK_ID
C_PROJECTS_PROJECT_NAME=PROJECT_NAME
C_PROJECTS_PROJECT_DESCRIPTION=PROJECT_DESCRIPTION
C_PROJECTS_PROJECT_FLAGS=PROJECT_FLAGS
C_PROJECTS_DATE_CREATED=DATE_CREATED
C_PROJECTS_PROJECT_TYPE=PROJECT_TYPE

C_PROJECTS_RECORD=\
	PROJECT_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	TASK_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE

	
#
# Project queries
#
C_PROJECTS_CREATE=\
INSERT INTO CMS_PROJECTS \
	(PROJECT_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	TASK_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE)\
VALUES \
	(?,?,?,?,?,?,?,?,?,?)
	
C_PROJECTS_WRITE=\
UPDATE \
	CMS_PROJECTS \
SET \
	PROJECT_DESCRIPTION=?,\
	GROUP_ID=?,\
	MANAGERGROUP_ID=?,\
	PROJECT_FLAGS=?,\
	PROJECT_TYPE=? \
WHERE \
	PROJECT_ID=?
	
C_PROJECTS_READ=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	PROJECT_ID=? \
ORDER BY \
	PROJECT_NAME


C_PROJECTS_READ_BYTASK=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	TASK_ID=? \
ORDER BY \
	PROJECT_NAME
	
	
C_PROJECTS_READ_BYUSER=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	USER_ID=? \
	AND PROJECT_FLAGS=0 \
ORDER BY \
	PROJECT_NAME
	
	
C_PROJECTS_READ_BYGROUP=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	(GROUP_ID=? OR MANAGERGROUP_ID=?) \
	AND PROJECT_FLAGS=0 \
ORDER BY \
	PROJECT_NAME
	
	
C_PROJECTS_READ_BYFLAG=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	PROJECT_FLAGS=? \
ORDER BY \
	PROJECT_NAME
	
	
C_PROJECTS_READ_BYMANAGER=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	MANAGERGROUP_ID=? \
                          AND PROJECT_FLAGS=0 \
ORDER BY \
	PROJECT_NAME
                    
                    
C_PROJECTS_READ_BYNAME=\
SELECT \
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_PROJECTS \
WHERE \
	PROJECT_NAME=? \
ORDER BY \
	PROJECT_NAME                          
                    
	
C_PROJECTS_DELETE=\
DELETE FROM \
	CMS_PROJECTS \
WHERE \
	PROJECT_ID=?
                 
                    
C_RESOURCES_UNMARK=\
UPDATE \
	CMS_OFFLINE_RESOURCES \
SET \
	PROJECT_LASTMODIFIED=0 \
WHERE \
	PROJECT_LASTMODIFIED=?
                    
                    
#
# Project history queries
#
C_PROJECTS_CREATE_BACKUP=\
INSERT INTO CMS_BACKUP_PROJECTS \
	(PUBLISH_TAG,\
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_PUBLISHDATE,\
	PROJECT_PUBLISHED_BY,\
	PROJECT_PUBLISHED_BY_NAME,\
	USER_ID,\
	USER_NAME,\
	GROUP_ID,\
	GROUP_NAME,\
	MANAGERGROUP_ID,\
	MANAGERGROUP_NAME,\
	PROJECT_DESCRIPTION,\
	DATE_CREATED,\
	PROJECT_TYPE,\
	TASK_ID) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
                         
                         
C_PROJECTS_READBYVERSION_BACKUP=\
SELECT \
	PUBLISH_TAG,\
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_PUBLISHDATE,\
	PROJECT_PUBLISHED_BY,\
	PROJECT_PUBLISHED_BY_NAME,\
	USER_ID,\
	USER_NAME,\
	GROUP_ID,\
	GROUP_NAME,\
	MANAGERGROUP_ID,\
	MANAGERGROUP_NAME,\
	PROJECT_DESCRIPTION,\
	DATE_CREATED,\
	PROJECT_TYPE,\
	TASK_ID \
FROM \
	CMS_BACKUP_PROJECTS \
WHERE \
	PUBLISH_TAG=?
                         
                                 
C_PROJECTS_READLAST_BACKUP=\
SELECT \
	PUBLISH_TAG,\
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_PUBLISHDATE,\
	PROJECT_PUBLISHED_BY,\
	PROJECT_PUBLISHED_BY_NAME,\
	PROJECT_DESCRIPTION,\
	TASK_ID,\
	USER_ID,\
	USER_NAME,\
	GROUP_ID,\
	GROUP_NAME,\
	MANAGERGROUP_ID,\
	MANAGERGROUP_NAME,\
	DATE_CREATED,\
	PROJECT_TYPE \
FROM \
	CMS_BACKUP_PROJECTS \
ORDER BY \
	PUBLISH_TAG DESC
    
                         
C_PROJECTRESOURCES_CREATE_BACKUP=\
INSERT INTO CMS_BACKUP_PROJECTRESOURCES \
	(PUBLISH_TAG,\
	PROJECT_ID,\
	RESOURCE_PATH) \
VALUES \
	(?,?,?)
                           
                                 
C_PROJECTRESOURCES_READ_BACKUP=\
SELECT \
	RESOURCE_PATH \
FROM \
	CMS_BACKUP_PROJECTRESOURCES \
WHERE \
	PUBLISH_TAG=?
	
	
#
# Project resource queries
#
C_PROJECTRESOURCES_CREATE=\
INSERT INTO CMS_PROJECTRESOURCES \
	(PROJECT_ID,RESOURCE_PATH) \
VALUES \
	(?,?)


C_PROJECTRESOURCES_DELETE=\
DELETE FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	PROJECT_ID=? \
	AND RESOURCE_PATH=?
                          
                          
C_PROJECTRESOURCES_DELETEALL=\
DELETE FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	PROJECT_ID=?

	
C_PROJECTRESOURCES_READ=\
SELECT \
	RESOURCE_PATH \
FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	PROJECT_ID=? \
	AND RESOURCE_PATH=?
	
	
C_PROJECTRESOURCES_READ_BY_ID=\
SELECT \
	RESOURCE_PATH \
FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	PROJECT_ID=?
	
						   
#
# Database table attribs required to create a valid resource instance
#
C_RESOURCES_RESOURCE_ID=RESOURCE_ID
C_RESOURCES_STRUCTURE_ID=STRUCTURE_ID
C_RESOURCES_BACKUP_ID=BACKUP_ID
C_RESOURCES_PUBLISH_TAG=PUBLISH_TAG
C_RESOURCES_VERSION_ID=VERSION_ID
C_RESOURCES_RESOURCE_TYPE=RESOURCE_TYPE
C_RESOURCES_RESOURCE_FLAGS=RESOURCE_FLAGS
C_RESOURCES_CONTENT_ID=CONTENT_ID
C_RESOURCES_RESOURCE_PATH=RESOURCE_PATH
C_RESOURCES_USER_NAME=USER_NAME
C_RESOURCES_GROUP_NAME=GROUP_NAME
C_RESOURCES_PROJECT_LASTMODIFIED=PROJECT_LASTMODIFIED
C_PROJECT_ID_RESOURCES=CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED
C_RESOURCE_FLAGS=RESOURCE_FLAGS
C_RESOURCES_STATE=RESOURCE_STATE
C_RESOURCES_DATE_CREATED=DATE_CREATED
C_RESOURCES_DATE_LASTMODIFIED=DATE_LASTMODIFIED
C_RESOURCES_DATE_RELEASED=DATE_RELEASED
C_RESOURCES_DATE_EXPIRED=DATE_EXPIRED
C_RESOURCES_SIZE=RESOURCE_SIZE
C_RESOURCES_USER_CREATED=USER_CREATED
C_RESOURCES_USER_CREATED_NAME=USER_CREATED_NAME
C_RESOURCES_USER_LASTMODIFIED=USER_LASTMODIFIED
C_RESOURCES_LASTMODIFIED_BY_NAME=USER_LASTMODIFIED_NAME
C_RESOURCES_FILE_CONTENT=FILE_CONTENT
C_RESOURCES_STRUCTURE_STATE=STRUCTURE_STATE
C_RESOURCES_SIBLING_COUNT=SIBLING_COUNT

#
# these strings are used as replacements for ${XXX} patterns in SQL statements when the properties hash is loaded
#

# patterns for insert statements
C_TABLE_RESOURCES_ATTRIBS=\
	RESOURCE_ID,\
	RESOURCE_TYPE,\
	RESOURCE_FLAGS,\
	DATE_CREATED,\
	USER_CREATED,\
	DATE_LASTMODIFIED,\
	USER_LASTMODIFIED,\
	RESOURCE_STATE,\
	RESOURCE_SIZE,\
	PROJECT_LASTMODIFIED,\
	SIBLING_COUNT
C_TABLE_RESOURCES_VALUES=?,?,?,?,?,?,?,?,?,?,?

C_TABLE_STRUCTURE_ATTRIBS=\
	STRUCTURE_ID,\
	RESOURCE_ID,\
	RESOURCE_PATH,\
	STRUCTURE_STATE, \
	DATE_RELEASED, \
	DATE_EXPIRED
C_TABLE_STRUCTURE_VALUES=?,?,?,?,?,?

# patterns for statements to select resources/folders (= selections without content)
# THINGS TO KNOW: don't select the project-ID attrib. of the structure table per default!
# There are cases, where the project-ID attrib. of the project-resources tab. is used
# as the project-ID!
C_RESOURCES_SELECT_ATTRIBS=\
    CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID,\
	CMS_${PROJECT}_STRUCTURE.RESOURCE_ID,\
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH,\
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE,\
	CMS_${PROJECT}_STRUCTURE.DATE_RELEASED,\
	CMS_${PROJECT}_STRUCTURE.DATE_EXPIRED,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_TYPE,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_FLAGS,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_STATE,\
	CMS_${PROJECT}_RESOURCES.DATE_CREATED,\
	CMS_${PROJECT}_RESOURCES.DATE_LASTMODIFIED,\
	CMS_${PROJECT}_RESOURCES.USER_CREATED,\
	CMS_${PROJECT}_RESOURCES.USER_LASTMODIFIED,\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE,\
	CMS_${PROJECT}_RESOURCES.SIBLING_COUNT
	
C_RESOURCES_SELECT_TABLES=CMS_${PROJECT}_STRUCTURE,CMS_${PROJECT}_RESOURCES

C_RESOURCES_SELECT_ATTRIBS_BACKUP=\
	CMS_BACKUP_STRUCTURE.BACKUP_ID, \
	CMS_BACKUP_STRUCTURE.PUBLISH_TAG, \
	CMS_BACKUP_STRUCTURE.VERSION_ID,\
	CMS_BACKUP_STRUCTURE.STRUCTURE_ID,\
	CMS_BACKUP_STRUCTURE.RESOURCE_PATH,\
	CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,\
	CMS_BACKUP_STRUCTURE.DATE_RELEASED,\
	CMS_BACKUP_STRUCTURE.DATE_EXPIRED,\
	CMS_BACKUP_RESOURCES.RESOURCE_ID,\
	CMS_BACKUP_RESOURCES.RESOURCE_TYPE,\
	CMS_BACKUP_RESOURCES.RESOURCE_FLAGS,\
	CMS_BACKUP_RESOURCES.RESOURCE_STATE,\
	CMS_BACKUP_RESOURCES.DATE_CREATED,\
	CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,\
	CMS_BACKUP_RESOURCES.USER_CREATED,\
	CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,\
	CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED,\
	CMS_BACKUP_RESOURCES.RESOURCE_SIZE,\
	CMS_BACKUP_RESOURCES.SIBLING_COUNT,\
	CMS_BACKUP_RESOURCES.USER_CREATED_NAME,\
	CMS_BACKUP_RESOURCES.USER_LASTMODIFIED_NAME
	
C_RESOURCES_SELECT_TABLES_BACKUP=CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES

#
# Patterns for statements to select files (= selections WITH content)
#
C_FILES_SELECT_ATTRIBS=\
CMS_${PROJECT}_STRUCTURE.*,\
CMS_${PROJECT}_RESOURCES.*,\
CMS_${PROJECT}_CONTENTS.CONTENT_ID,\
CMS_${PROJECT}_CONTENTS.FILE_CONTENT,\
CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT

C_FILES_SELECT_TABLES=\
CMS_${PROJECT}_STRUCTURE,\
CMS_${PROJECT}_RESOURCES,\
CMS_${PROJECT}_CONTENTS

C_FILES_SELECT_ATTRIBS_BACKUP=\
CMS_BACKUP_RESOURCES.*,\
CMS_BACKUP_STRUCTURE.*,\
CMS_BACKUP_CONTENTS.BACKUP_ID,\
CMS_BACKUP_CONTENTS.CONTENT_ID,\
CMS_BACKUP_CONTENTS.FILE_CONTENT,\
CMS_BACKUP_CONTENTS.PUBLISH_TAG,\
CMS_BACKUP_CONTENTS.VERSION_ID,\
CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT

C_FILES_SELECT_TABLES_BACKUP=\
CMS_BACKUP_RESOURCES,\
CMS_BACKUP_STRUCTURE,\
CMS_BACKUP_CONTENTS

C_JOIN_STRUCTURE_RESOURCE=CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID
C_JOIN_RESOURCE_STRUCTURE=CMS_${PROJECT}_RESOURCES.RESOURCE_ID=CMS_${PROJECT}_STRUCTURE.RESOURCE_ID
C_JOIN_RESOURCE_PROPERTY=CMS_${PROJECT}_STRUCTURE.RESOURCE_ID=CMS_${PROJECT}_PROPERTIES.RESOURCE_ID AND CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH=CMS_${PROJECT}_PROPERTIES.RESOURCE_PATH
C_JOIN_STRUCTURE_RESOURCE_BACKUP=CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID
C_JOIN_RESOURCE_PROPERTY_BACKUP=CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_PROPERTIES.RESOURCE_ID AND CMS_BACKUP_STRUCTURE.RESOURCE_PATH=CMS_BACKUP_PROPERTIES.RESOURCE_PATH

C_JOIN_RESOURCE_FILE=CMS_${PROJECT}_CONTENTS.RESOURCE_ID=CMS_${PROJECT}_RESOURCES.RESOURCE_ID
C_JOIN_RESOURCE_FILE_BACKUP=CMS_BACKUP_RESOURCES.RESOURCE_ID=CMS_BACKUP_CONTENTS.RESOURCE_ID AND CMS_BACKUP_RESOURCES.BACKUP_ID=CMS_BACKUP_CONTENTS.BACKUP_ID


#
# SQL statements
#
C_RESOURCES_WRITE=\
INSERT INTO CMS_${PROJECT}_RESOURCES \
	(${C_TABLE_RESOURCES_ATTRIBS}) \
VALUES \
	(${C_TABLE_RESOURCES_VALUES})


C_STRUCTURE_WRITE=\
INSERT INTO CMS_${PROJECT}_STRUCTURE \
	(${C_TABLE_STRUCTURE_ATTRIBS},PARENT_ID) \
VALUES \
	(${C_TABLE_STRUCTURE_VALUES},?)

	
C_RESOURCES_WRITE_BACKUP=\
INSERT INTO CMS_BACKUP_RESOURCES \
	(${C_TABLE_RESOURCES_ATTRIBS},\
	PUBLISH_TAG,\
	VERSION_ID,\
	BACKUP_ID,\
	USER_CREATED_NAME,\
	USER_LASTMODIFIED_NAME) \
VALUES \
	(${C_TABLE_RESOURCES_VALUES},?,?,?,?,?)
	
	
C_STRUCTURE_WRITE_BACKUP=\
INSERT INTO CMS_BACKUP_STRUCTURE \
	(${C_TABLE_STRUCTURE_ATTRIBS},\
	PUBLISH_TAG,\
	VERSION_ID,\
	BACKUP_ID) \
VALUES \
	(${C_TABLE_STRUCTURE_VALUES},?,?,?)


C_RESOURCES_WRITE_PUBLISH_HISTORY=\
INSERT INTO CMS_PUBLISH_HISTORY \
	(PUBLISH_TAG,\
	STRUCTURE_ID,\
	RESOURCE_ID,\
	RESOURCE_PATH,\
	RESOURCE_STATE,\
	RESOURCE_TYPE,\
	HISTORY_ID,\
	SIBLING_COUNT) \
VALUES \
	(?,?,?,?,?,?,?,?)
	
	
C_RESOURCES_UPDATE_RESOURCES=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_TYPE=?,\
	RESOURCE_FLAGS=?,\
	DATE_LASTMODIFIED=?,\
	USER_LASTMODIFIED=?,\
	RESOURCE_STATE=?,\
	RESOURCE_SIZE=?,\
	PROJECT_LASTMODIFIED=?,\
	SIBLING_COUNT=? \
WHERE \
	RESOURCE_ID=?
	
C_RESOURCES_TRANSFER_RESOURCE=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	CMS_${PROJECT}_RESOURCES.USER_CREATED=?,\
	CMS_${PROJECT}_RESOURCES.USER_LASTMODIFIED=? \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID=?	
	
C_RESOURCES_UPDATE_STRUCTURE=\
UPDATE \
	CMS_${PROJECT}_STRUCTURE \
SET \
	RESOURCE_ID=?,\
	RESOURCE_PATH=?,\
	STRUCTURE_STATE=?, \
	DATE_RELEASED=?, \
	DATE_EXPIRED=?, \
	PARENT_ID=? \
WHERE \
	STRUCTURE_ID=?
	
	
C_RESOURCES_READ_ALL_VERSIONS_BACKUP=\
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS_BACKUP},\
	CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_BACKUP} \
WHERE \
	CMS_BACKUP_STRUCTURE.RESOURCE_PATH=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE_BACKUP}) \
UNION \
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS_BACKUP},\
	CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_BACKUP} \
WHERE \
	CMS_BACKUP_RESOURCES.RESOURCE_ID=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE_BACKUP}) \
ORDER BY \
	VERSION_ID, RESOURCE_PATH ASC


C_RESOURCES_READ_ALL_BACKUP=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS_BACKUP},\
	CMS_BACKUP_RESOURCES.PROJECT_LASTMODIFIED LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_BACKUP} \
WHERE \
	${C_JOIN_STRUCTURE_RESOURCE_BACKUP} \
ORDER BY \
	CMS_BACKUP_RESOURCES.VERSION_ID DESC
	
	
C_RESOURCES_READ_MAX_PUBLISH_TAG=\
SELECT \
	MAX(PUBLISH_TAG) \
FROM \
	CMS_BACKUP_RESOURCES \
WHERE \
	CMS_BACKUP_RESOURCES.RESOURCE_ID=?
	
	
C_RESOURCES_READ=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE} \
ORDER BY \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_STATE ASC
	
	
C_RESOURCES_READBYID=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE}

C_RESOURCES_SELECT_STRUCTURE_ID=\
SELECT \
	COUNT(CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID) \
FROM \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID=?	
		
		
C_RESOURCES_GET_SUBRESOURCES=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS} \
FROM \
	${C_RESOURCES_SELECT_TABLES} \
WHERE \
	CMS_${PROJECT}_STRUCTURE.PARENT_ID=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE}
	
	
C_RESOURCES_GET_SUBRESOURCES_GET_FOLDERS=AND CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE < 0
C_RESOURCES_GET_SUBRESOURCES_GET_FILES=AND CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE >= 0

C_RESOURCES_READ_PARENT_STRUCTURE_ID=\
SELECT \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID \
FROM \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH=?	
		
		
C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF=\
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	CMS_${PROJECT}_PROPERTIES, \
	CMS_${PROJECT}_RESOURCES, \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID = ? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH LIKE ?) \
UNION \
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	CMS_${PROJECT}_PROPERTIES, \
	CMS_${PROJECT}_STRUCTURE, \
	CMS_${PROJECT}_RESOURCES \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID = ? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID = CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_ID = CMS_${PROJECT}_RESOURCES.RESOURCE_ID \
	AND CMS_${PROJECT}_STRUCTURE.RESOURCE_PATH LIKE ?) \
ORDER BY RESOURCE_PATH DESC

C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF_VALUE=\
(SELECT DISTINCT \
	${C_RESOURCES_SELECT_ATTRIBS},\
	CMS_${PROJECT}_RESOURCES.PROJECT_LASTMODIFIED \
FROM \
	CMS_${PROJECT}_PROPERTIES, \
	CMS_${PROJECT}_RESOURCES, \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=? \
12 3 下一页
⌨️ 快捷键说明

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