query.properties

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

PROPERTIES
2,408 行
字号
1234
#
# 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 attributes
#
C_PROJECTS_PUBLISH_TAG_0=PUBLISH_TAG
C_PROJECTS_PROJECT_ID_0=PROJECT_ID
C_PROJECTS_USER_ID_0=USER_ID
C_PROJECTS_GROUP_ID_0=GROUP_ID
C_PROJECTS_MANAGERGROUP_ID_0=MANAGERGROUP_ID
C_PROJECTS_PROJECT_NAME_0=PROJECT_NAME
C_PROJECTS_PROJECT_DESCRIPTION_0=PROJECT_DESCRIPTION
C_PROJECTS_PROJECT_FLAGS_0=PROJECT_FLAGS
C_PROJECTS_DATE_CREATED_0=DATE_CREATED
C_PROJECTS_PROJECT_TYPE_0=PROJECT_TYPE
C_PROJECTS_PROJECT_OU_0=PROJECT_OU
C_PROJECT_PUBLISHDATE_0=PROJECT_PUBLISHDATE
C_PROJECT_PUBLISHED_BY_0=PROJECT_PUBLISHED_BY
	
#
# Project queries
#
C_PROJECTS_CREATE_10=\
INSERT INTO CMS_PROJECTS \
	(PROJECT_ID,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_NAME,\
	PROJECT_DESCRIPTION,\
	PROJECT_FLAGS,\
	DATE_CREATED,\
	PROJECT_TYPE,\
	PROJECT_OU)\
VALUES \
	(?,?,?,?,?,?,?,?,?,?)
	
C_PROJECTS_WRITE_6=\
UPDATE \
	CMS_PROJECTS \
SET \
	PROJECT_DESCRIPTION=?,\
	GROUP_ID=?,\
	MANAGERGROUP_ID=?,\
	PROJECT_FLAGS=?,\
	PROJECT_TYPE=? \
WHERE \
	CMS_PROJECTS.PROJECT_ID=?
	
C_PROJECTS_READ_1=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.PROJECT_ID=? \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME

C_PROJECTS_READ_BYUSER_1=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.USER_ID=? \
	AND CMS_PROJECTS.PROJECT_FLAGS=0 \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME
	
	
C_PROJECTS_READ_BYGROUP_2=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	(CMS_PROJECTS.GROUP_ID=? OR CMS_PROJECTS.MANAGERGROUP_ID=?) \
	AND CMS_PROJECTS.PROJECT_FLAGS=0 \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME
	
	
C_PROJECTS_READ_BYOU_1=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.PROJECT_OU LIKE ? \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME
	
	
C_PROJECTS_READ_BYMANAGER_1=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.MANAGERGROUP_ID=? \
    AND CMS_PROJECTS.PROJECT_FLAGS=0 \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME
                    
                    
C_PROJECTS_READ_BYNAME_2=\
SELECT \
	CMS_PROJECTS.PROJECT_ID,\
	CMS_PROJECTS.PROJECT_NAME,\
	CMS_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_PROJECTS.USER_ID,\
	CMS_PROJECTS.GROUP_ID,\
	CMS_PROJECTS.MANAGERGROUP_ID,\
	CMS_PROJECTS.PROJECT_FLAGS,\
	CMS_PROJECTS.DATE_CREATED,\
	CMS_PROJECTS.PROJECT_TYPE,\
	CMS_PROJECTS.PROJECT_OU \
FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.PROJECT_NAME=? \
	AND CMS_PROJECTS.PROJECT_OU=? \
ORDER BY \
	CMS_PROJECTS.PROJECT_OU, CMS_PROJECTS.PROJECT_NAME                          
                    
	
C_PROJECTS_DELETE_1=\
DELETE FROM \
	CMS_PROJECTS \
WHERE \
	CMS_PROJECTS.PROJECT_ID=?
                 
                    
#
# Project history queries
#
C_PROJECTS_HISTORY_CREATE=\
INSERT INTO CMS_HISTORY_PROJECTS \
	(PUBLISH_TAG,\
	PROJECT_ID,\
	PROJECT_NAME,\
	PROJECT_PUBLISHDATE,\
	PROJECT_PUBLISHED_BY,\
	USER_ID,\
	GROUP_ID,\
	MANAGERGROUP_ID,\
	PROJECT_DESCRIPTION,\
	DATE_CREATED,\
	PROJECT_TYPE,\
	PROJECT_OU) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?,?,?)
                         
                         
C_PROJECTS_HISTORY_READ=\
SELECT \
	CMS_HISTORY_PROJECTS.PUBLISH_TAG,\
	CMS_HISTORY_PROJECTS.PROJECT_ID,\
	CMS_HISTORY_PROJECTS.PROJECT_NAME,\
	CMS_HISTORY_PROJECTS.PROJECT_PUBLISHDATE,\
	CMS_HISTORY_PROJECTS.PROJECT_PUBLISHED_BY,\
	CMS_HISTORY_PROJECTS.USER_ID,\
	CMS_HISTORY_PROJECTS.GROUP_ID,\
	CMS_HISTORY_PROJECTS.MANAGERGROUP_ID,\
	CMS_HISTORY_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_HISTORY_PROJECTS.DATE_CREATED,\
	CMS_HISTORY_PROJECTS.PROJECT_TYPE,\
	CMS_HISTORY_PROJECTS.PROJECT_OU \
FROM \
	CMS_HISTORY_PROJECTS \
WHERE \
	CMS_HISTORY_PROJECTS.PUBLISH_TAG=?
                         
                                 
C_PROJECTS_HISTORY_READ_ALL=\
SELECT \
	CMS_HISTORY_PROJECTS.PUBLISH_TAG,\
	CMS_HISTORY_PROJECTS.PROJECT_ID,\
	CMS_HISTORY_PROJECTS.PROJECT_NAME,\
	CMS_HISTORY_PROJECTS.PROJECT_PUBLISHDATE,\
	CMS_HISTORY_PROJECTS.PROJECT_PUBLISHED_BY,\
	CMS_HISTORY_PROJECTS.PROJECT_DESCRIPTION,\
	CMS_HISTORY_PROJECTS.USER_ID,\
	CMS_HISTORY_PROJECTS.GROUP_ID,\
	CMS_HISTORY_PROJECTS.MANAGERGROUP_ID,\
	CMS_HISTORY_PROJECTS.DATE_CREATED,\
	CMS_HISTORY_PROJECTS.PROJECT_TYPE,\
	CMS_HISTORY_PROJECTS.PROJECT_OU \
FROM \
	CMS_HISTORY_PROJECTS \
ORDER BY \
	CMS_HISTORY_PROJECTS.PUBLISH_TAG DESC
    
                         
C_PROJECTRESOURCES_HISTORY_CREATE=\
INSERT INTO CMS_HISTORY_PROJECTRESOURCES \
	(PUBLISH_TAG,\
	PROJECT_ID,\
	RESOURCE_PATH) \
VALUES \
	(?,?,?)
                           
                                 
C_PROJECTRESOURCES_HISTORY_READ=\
SELECT \
	CMS_HISTORY_PROJECTRESOURCES.RESOURCE_PATH \
FROM \
	CMS_HISTORY_PROJECTRESOURCES \
WHERE \
	CMS_HISTORY_PROJECTRESOURCES.PUBLISH_TAG=?
	
	
#
# Project resource queries
#
C_PROJECTRESOURCES_CREATE_2=\
INSERT INTO CMS_PROJECTRESOURCES \
	(PROJECT_ID,\
	RESOURCE_PATH) \
VALUES \
	(?,?)


C_PROJECTRESOURCES_DELETE_2=\
DELETE FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	CMS_PROJECTRESOURCES.PROJECT_ID=? \
	AND CMS_PROJECTRESOURCES.RESOURCE_PATH=?
                          
                          
C_PROJECTRESOURCES_DELETEALL_1=\
DELETE FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	CMS_PROJECTRESOURCES.PROJECT_ID=?

	
C_PROJECTRESOURCES_READ_2=\
SELECT \
	CMS_PROJECTRESOURCES.RESOURCE_PATH \
FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	CMS_PROJECTRESOURCES.PROJECT_ID=? \
	AND CMS_PROJECTRESOURCES.RESOURCE_PATH=?
	
	
C_PROJECTRESOURCES_READ_BY_ID_1=\
SELECT \
	CMS_PROJECTRESOURCES.RESOURCE_PATH \
FROM \
	CMS_PROJECTRESOURCES \
WHERE \
	CMS_PROJECTRESOURCES.PROJECT_ID=?
	
#
# CMS_RESOURCE_LOCKS queries
#
C_RESOURCE_LOCKS_READALL=\
SELECT \
	CMS_RESOURCE_LOCKS.RESOURCE_PATH,\
	CMS_RESOURCE_LOCKS.USER_ID,\
	CMS_RESOURCE_LOCKS.PROJECT_ID,\
	CMS_RESOURCE_LOCKS.LOCK_TYPE \
FROM \
	CMS_RESOURCE_LOCKS

C_RESOURCE_LOCKS_DELETEALL=\
DELETE \
FROM \
	CMS_RESOURCE_LOCKS

C_RESOURCE_LOCK_WRITE=\
INSERT INTO CMS_RESOURCE_LOCKS \
	(RESOURCE_PATH,\
	USER_ID,\
	PROJECT_ID,\
	LOCK_TYPE) \
VALUES \
	(?,?,?,?)
	

# CMS_RESOURCE_LOCKS column names: 
C_RESOURCE_LOCKS_RESOURCE_PATH=RESOURCE_PATH
C_RESOURCE_LOCKS_USER_ID=USER_ID
C_RESOURCE_LOCKS_PROJECT_ID=PROJECT_ID
C_RESOURCE_LOCKS_LOCK_TYPE=LOCK_TYPE

						   
#
# Database table attribs required to create a valid resource instance
#
C_RESOURCES_RESOURCE_ID=RESOURCE_ID
C_RESOURCES_STRUCTURE_ID=STRUCTURE_ID
C_RESOURCES_PUBLISH_TAG=PUBLISH_TAG
C_RESOURCES_HISTORY_VERSION=VERSION
C_RESOURCES_HISTORY_PARENTID=PARENT_ID
C_RESOURCES_VERSION=RESOURCE_VERSION
C_RESOURCES_STRUCTURE_VERSION=STRUCTURE_VERSION
C_RESOURCES_RESOURCE_TYPE=RESOURCE_TYPE
C_RESOURCES_RESOURCE_FLAGS=RESOURCE_FLAGS
C_RESOURCES_RESOURCE_PATH=RESOURCE_PATH
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_DATE_CONTENT=DATE_CONTENT
C_RESOURCES_USER_CREATED=USER_CREATED
C_RESOURCES_USER_LASTMODIFIED=USER_LASTMODIFIED
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 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}_STRUCTURE.STRUCTURE_VERSION,\
	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 AS LOCKED_IN_PROJECT,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_SIZE,\
	CMS_${PROJECT}_RESOURCES.DATE_CONTENT,\
	CMS_${PROJECT}_RESOURCES.SIBLING_COUNT,\
	CMS_${PROJECT}_RESOURCES.RESOURCE_VERSION
	
C_RESOURCES_SELECT_TABLES=CMS_${PROJECT}_STRUCTURE,CMS_${PROJECT}_RESOURCES

C_RESOURCES_SELECT_ATTRIBS_HISTORY=\
	CMS_HISTORY_STRUCTURE.PUBLISH_TAG, \
	CMS_HISTORY_STRUCTURE.VERSION,\
	CMS_HISTORY_STRUCTURE.STRUCTURE_VERSION,\
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID,\
	CMS_HISTORY_STRUCTURE.RESOURCE_PATH,\
	CMS_HISTORY_STRUCTURE.STRUCTURE_STATE,\
	CMS_HISTORY_STRUCTURE.DATE_RELEASED,\
	CMS_HISTORY_STRUCTURE.DATE_EXPIRED,\
	CMS_HISTORY_STRUCTURE.PARENT_ID,\
	CMS_HISTORY_RESOURCES.RESOURCE_ID,\
	CMS_HISTORY_RESOURCES.RESOURCE_TYPE,\
	CMS_HISTORY_RESOURCES.RESOURCE_FLAGS,\
	CMS_HISTORY_RESOURCES.RESOURCE_STATE,\
	CMS_HISTORY_RESOURCES.DATE_CREATED,\
	CMS_HISTORY_RESOURCES.DATE_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.USER_CREATED,\
	CMS_HISTORY_RESOURCES.USER_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.PROJECT_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.RESOURCE_SIZE,\
	CMS_HISTORY_RESOURCES.DATE_CONTENT,\
	CMS_HISTORY_RESOURCES.RESOURCE_VERSION,\
	CMS_HISTORY_RESOURCES.SIBLING_COUNT
	
C_HISTORY_SELECT_RESOURCE=\
	CMS_HISTORY_RESOURCES.PUBLISH_TAG,\
	CMS_HISTORY_RESOURCES.RESOURCE_ID,\
	CMS_HISTORY_RESOURCES.RESOURCE_TYPE,\
	CMS_HISTORY_RESOURCES.RESOURCE_FLAGS,\
	CMS_HISTORY_RESOURCES.RESOURCE_STATE,\
	CMS_HISTORY_RESOURCES.DATE_CREATED,\
	CMS_HISTORY_RESOURCES.DATE_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.USER_CREATED,\
	CMS_HISTORY_RESOURCES.USER_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.PROJECT_LASTMODIFIED,\
	CMS_HISTORY_RESOURCES.RESOURCE_SIZE,\
	CMS_HISTORY_RESOURCES.DATE_CONTENT,\
	CMS_HISTORY_RESOURCES.SIBLING_COUNT,\
	CMS_HISTORY_RESOURCES.RESOURCE_VERSION,\
	CMS_HISTORY_RESOURCES.PROJECT_LASTMODIFIED AS LOCKED_IN_PROJECT
	
C_RESOURCES_SELECT_TABLES_HISTORY=CMS_HISTORY_STRUCTURE,CMS_HISTORY_RESOURCES

C_FILES_SELECT_TABLES_OFFLINE=\
CMS_OFFLINE_STRUCTURE,\
CMS_OFFLINE_RESOURCES,\
CMS_OFFLINE_CONTENTS

C_FILES_SELECT_TABLES_ONLINE=\
CMS_ONLINE_STRUCTURE,\
CMS_ONLINE_RESOURCES,\
CMS_CONTENTS

C_FILES_SELECT_TABLES_HISTORY=\
CMS_HISTORY_RESOURCES,\
CMS_HISTORY_STRUCTURE,\
CMS_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_STRUCTURE_RESOURCE_HISTORY=CMS_HISTORY_STRUCTURE.RESOURCE_ID=CMS_HISTORY_RESOURCES.RESOURCE_ID AND CMS_HISTORY_STRUCTURE.PUBLISH_TAG=CMS_HISTORY_RESOURCES.PUBLISH_TAG

C_JOIN_RESOURCE_OFFLINE_FILE=CMS_OFFLINE_CONTENTS.RESOURCE_ID=CMS_OFFLINE_RESOURCES.RESOURCE_ID
C_JOIN_RESOURCE_ONLINE_FILE=CMS_CONTENTS.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID AND CMS_CONTENTS.ONLINE_FLAG=1


#
# SQL statements
#
C_RESOURCES_UNMARK=\
UPDATE \
	CMS_OFFLINE_RESOURCES \
SET \
	PROJECT_LASTMODIFIED='00000000-0000-0000-0000-000000000000' \
WHERE \
	CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED=?
                    
                    
C_RESOURCES_WRITE=\
INSERT INTO CMS_${PROJECT}_RESOURCES \
	(RESOURCE_ID,\
	RESOURCE_TYPE,\
	RESOURCE_FLAGS,\
	DATE_CREATED,\
	USER_CREATED,\
	DATE_LASTMODIFIED,\
	USER_LASTMODIFIED,\
	RESOURCE_STATE,\
	RESOURCE_SIZE,\
	DATE_CONTENT,\
	PROJECT_LASTMODIFIED,\
	SIBLING_COUNT,\
	RESOURCE_VERSION) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?,?,?,?)


C_RESOURCES_READ_VERSION_RES=\
SELECT \
    CMS_${PROJECT}_RESOURCES.RESOURCE_VERSION \
FROM \
	CMS_${PROJECT}_RESOURCES \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID=?

C_RESOURCES_READ_VERSION_STR=\
SELECT \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_VERSION \
FROM \
	CMS_${PROJECT}_STRUCTURE \
WHERE \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID=?


C_RESOURCES_UPDATE_RESOURCE_VERSION=\
UPDATE \
	CMS_${PROJECT}_RESOURCES \
SET \
	RESOURCE_VERSION = ? \
WHERE \
	CMS_${PROJECT}_RESOURCES.RESOURCE_ID = ?
	 
C_RESOURCES_UPDATE_STRUCTURE_VERSION=\
UPDATE \
	CMS_${PROJECT}_STRUCTURE \
SET \
	STRUCTURE_VERSION = ? \
WHERE \
	CMS_${PROJECT}_STRUCTURE.STRUCTURE_ID = ?
	 
C_STRUCTURE_WRITE=\
INSERT INTO CMS_${PROJECT}_STRUCTURE \
	(STRUCTURE_ID,\
	RESOURCE_ID,\
	RESOURCE_PATH,\
	STRUCTURE_STATE,\
	DATE_RELEASED,\
	DATE_EXPIRED,\
	PARENT_ID,\
	STRUCTURE_VERSION) \
VALUES \
	(?,?,?,?,?,?,?,?)

	
C_RESOURCES_HISTORY_WRITE=\
INSERT INTO CMS_HISTORY_RESOURCES \
    (RESOURCE_ID,\
	RESOURCE_TYPE,\
	RESOURCE_FLAGS,\
	DATE_CREATED,\
	USER_CREATED,\
	DATE_LASTMODIFIED,\
	USER_LASTMODIFIED,\
	RESOURCE_STATE,\
	RESOURCE_SIZE,\
	DATE_CONTENT,\
	PROJECT_LASTMODIFIED,\
	SIBLING_COUNT,\
	RESOURCE_VERSION,\
	PUBLISH_TAG) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?,?,?,?,?)
	
	
C_STRUCTURE_HISTORY_WRITE=\
INSERT INTO CMS_HISTORY_STRUCTURE \
	(STRUCTURE_ID,\
	RESOURCE_ID,\
	RESOURCE_PATH,\
	STRUCTURE_STATE,\
	DATE_RELEASED,\
	DATE_EXPIRED,\
	STRUCTURE_VERSION,\
	PARENT_ID,\
	PUBLISH_TAG,\
	VERSION) \
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=?,\
1234

query.properties - 源码说明

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

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

⌨️ 快捷键说明

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