query.properties

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

PROPERTIES
2,408 行
字号
1234
C_RESOURCES_HISTORY_READ_VERSION=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS_HISTORY},\
	CMS_HISTORY_RESOURCES.PROJECT_LASTMODIFIED AS LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_HISTORY} \
WHERE \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID=? \
	AND CMS_HISTORY_STRUCTURE.VERSION=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE_HISTORY}
	
C_HISTORY_READ_CONTENT=\
SELECT \
	CMS_CONTENTS.FILE_CONTENT \
FROM \
	CMS_CONTENTS \
WHERE \
	CMS_CONTENTS.RESOURCE_ID=? \
	AND CMS_CONTENTS.PUBLISH_TAG_TO>=? \
	AND CMS_CONTENTS.PUBLISH_TAG_FROM<=?
	
############
# This query is just used by deprecated methods
# remove it as soon as possible
# see org.opencms.db.I_CmsHistoryDriver#readFile(CmsDbContext, CmsUUID, int)
############	
C_FILES_READ_HISTORY_BYID=\
SELECT \
	${C_RESOURCES_SELECT_ATTRIBS_HISTORY},\
	CMS_HISTORY_RESOURCES.PROJECT_LASTMODIFIED AS LOCKED_IN_PROJECT \
FROM \
	${C_RESOURCES_SELECT_TABLES_HISTORY}\
WHERE \
	CMS_HISTORY_STRUCTURE.STRUCTURE_ID=? \
	AND CMS_HISTORY_STRUCTURE.PUBLISH_TAG=? \
	AND ${C_JOIN_STRUCTURE_RESOURCE_HISTORY} 


C_OFFLINE_FILE_CONTENT_DELETE=\
DELETE FROM \
	CMS_OFFLINE_CONTENTS \
WHERE \
	CMS_OFFLINE_CONTENTS.RESOURCE_ID=?


#
# Property definitions
#
C_PROPERTYDEF_ID=PROPERTYDEF_ID
C_PROPERTYDEF_NAME=PROPERTYDEF_NAME
C_PROPERTYDEF_TYPE=PROPERTYDEF_TYPE


C_PROPERTYDEF_READ=\
SELECT \
	* \
FROM \
	CMS_${PROJECT}_PROPERTYDEF \
WHERE \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_NAME=?	
	
C_PROPERTYDEF_READ_HISTORY=\
SELECT \
	* \
FROM \
	CMS_HISTORY_PROPERTYDEF \
WHERE \
	CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_NAME=?
	
C_PROPERTYDEF_READALL=\
SELECT \
	* \
FROM \
	CMS_${PROJECT}_PROPERTYDEF	
	
C_PROPERTYDEF_CREATE=\
INSERT INTO CMS_${PROJECT}_PROPERTYDEF (\
	PROPERTYDEF_ID,\
	PROPERTYDEF_NAME,\
	PROPERTYDEF_TYPE) \
VALUES \
	(?,?,?)
	
	
C_PROPERTYDEF_CREATE_HISTORY=\
INSERT INTO CMS_HISTORY_PROPERTYDEF (\
	PROPERTYDEF_ID,\
	PROPERTYDEF_NAME,\
	PROPERTYDEF_TYPE) \
VALUES \
	(?,?,?)
	
	
C_PROPERTYDEF_DELETE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTYDEF \
WHERE \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_ID=?
	
	
C_PROPERTYDEF_DELETE_HISTORY=\
DELETE FROM \
	CMS_HISTORY_PROPERTYDEF \
WHERE \
	CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_ID=?


#
# Properties
#
C_PROPERTY_VALUE=PROPERTY_VALUE
C_PROPERTY_RESOURCE_ID=RESOURCE_ID


C_PROPERTIES_READALL_COUNT=\
SELECT \
	COUNT(*) \
FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=?

	
C_PROPERTIES_UPDATE=\
UPDATE \
	CMS_${PROJECT}_PROPERTIES \
SET \
	PROPERTY_VALUE=? \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE=? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=?

	
C_PROPERTIES_CREATE=\
INSERT INTO CMS_${PROJECT}_PROPERTIES \
	(PROPERTY_ID,\
	PROPERTYDEF_ID,\
	PROPERTY_MAPPING_ID,\
	PROPERTY_MAPPING_TYPE,\
	PROPERTY_VALUE) \
VALUES \
	(?,?,?,?,?)
	
	
C_PROPERTIES_HISTORY_CREATE=\
INSERT INTO CMS_HISTORY_PROPERTIES \
	(STRUCTURE_ID,\
	PROPERTYDEF_ID,\
	PROPERTY_MAPPING_ID,\
	PROPERTY_MAPPING_TYPE,\
	PROPERTY_VALUE,\
	PUBLISH_TAG) \
VALUES \
	(?,?,?,?,?,?)


C_PROPERTIES_READ=\
SELECT \
	CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_${PROJECT}_PROPERTYDEF,\
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_NAME=? \
    AND CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_ID \
	AND \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
			OR \
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=?\
	)
                     
                     
C_PROPERTIES_READALL=\
SELECT \
	CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_NAME,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_VALUE,\
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_${PROJECT}_PROPERTYDEF,\
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
			OR \
		CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=?\
	) \
	AND \
	(\
		CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=CMS_${PROJECT}_PROPERTYDEF.PROPERTYDEF_ID\
	)                     
                     

C_PROPERTIES_HISTORY_READ_PUBTAG=\
SELECT \
	MAX(CMS_HISTORY_PROPERTIES.PUBLISH_TAG) \
FROM \
	CMS_HISTORY_PROPERTIES \
WHERE \
	CMS_HISTORY_PROPERTIES.STRUCTURE_ID=? \
	AND CMS_HISTORY_PROPERTIES.PUBLISH_TAG<=?


C_PROPERTIES_HISTORY_READALL_RES=\
SELECT \
	CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_NAME, \
	CMS_HISTORY_PROPERTIES.PROPERTY_VALUE,\
	CMS_HISTORY_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_HISTORY_PROPERTIES,\
	CMS_HISTORY_PROPERTYDEF \
WHERE \
	CMS_HISTORY_PROPERTIES.PROPERTYDEF_ID=CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_ID \
	AND CMS_HISTORY_PROPERTIES.PROPERTY_MAPPING_ID=? \
	AND CMS_HISTORY_PROPERTIES.PUBLISH_TAG=?
                            
	
C_PROPERTIES_HISTORY_READALL_STR=\
SELECT \
	CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_NAME, \
	CMS_HISTORY_PROPERTIES.PROPERTY_VALUE,\
	CMS_HISTORY_PROPERTIES.PROPERTY_MAPPING_TYPE \
FROM \
	CMS_HISTORY_PROPERTIES,\
	CMS_HISTORY_PROPERTYDEF \
WHERE \
	CMS_HISTORY_PROPERTIES.PROPERTYDEF_ID=CMS_HISTORY_PROPERTYDEF.PROPERTYDEF_ID \
	AND CMS_HISTORY_PROPERTIES.STRUCTURE_ID=? \
	AND CMS_HISTORY_PROPERTIES.PUBLISH_TAG=?
                            
	
C_PROPERTIES_DELETE_ALL_STRUCTURE_AND_RESOURCE_VALUES=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	(\
		PROPERTY_MAPPING_ID=? \
		AND PROPERTY_MAPPING_TYPE=?\
	) \
	OR \
	(\
		PROPERTY_MAPPING_ID=? \
		AND PROPERTY_MAPPING_TYPE=?\
	)
	
	
C_PROPERTIES_DELETE_ALL_VALUES_FOR_MAPPING_TYPE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE=?
	
	
C_PROPERTIES_DELETE=\
DELETE FROM \
	CMS_${PROJECT}_PROPERTIES \
WHERE \
	CMS_${PROJECT}_PROPERTIES.PROPERTYDEF_ID=?  \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_ID=? \
	AND CMS_${PROJECT}_PROPERTIES.PROPERTY_MAPPING_TYPE=?
	

#
# Groups
#
C_GROUPS_GROUP_ID_0=GROUP_ID
C_GROUPS_PARENT_GROUP_ID_0=PARENT_GROUP_ID
C_GROUPS_GROUP_NAME_0=GROUP_NAME
C_GROUPS_GROUP_DESCRIPTION_0=GROUP_DESCRIPTION
C_GROUPS_GROUP_FLAGS_0=GROUP_FLAGS
C_GROUPS_GROUP_OU_0=GROUP_OU

C_GROUPS_READ_BY_NAME_2=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	CMS_GROUPS.GROUP_NAME=? AND \
	CMS_GROUPS.GROUP_OU=?
	
	
C_GROUPS_READ_BY_ID_1=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	CMS_GROUPS.GROUP_ID=?
	
	
C_GROUPS_CREATE_GROUP_6=\
INSERT INTO CMS_GROUPS (\
	GROUP_ID,\
	PARENT_GROUP_ID,\
	GROUP_NAME,\
	GROUP_DESCRIPTION,\
	GROUP_FLAGS,\
	GROUP_OU) \
VALUES \
	(?,?,?,?,?,?)
	
	
C_GROUPS_WRITE_GROUP_4=\
UPDATE \
	CMS_GROUPS \
SET \
	GROUP_DESCRIPTION=?,\
	GROUP_FLAGS=?,\
	PARENT_GROUP_ID=? \
WHERE \
	CMS_GROUPS.GROUP_ID=?
	
	
C_GROUPS_DELETE_GROUP_2=\
DELETE FROM \
	CMS_GROUPS \
WHERE \
	CMS_GROUPS.GROUP_NAME=? AND \
	CMS_GROUPS.GROUP_OU=?
	
	
C_GROUPS_GROUP_OU_EQUALS_1	=GROUP_OU = ?
C_GROUPS_GROUP_OU_LIKE_1	=GROUP_OU LIKE ?
C_GROUPS_SELECT_GROUPS_1	=GROUP_FLAGS < ?
C_GROUPS_SELECT_ROLES_1		=GROUP_FLAGS >= ?
C_GROUPS_ORDER_0			=ORDER BY GROUP_OU, GROUP_NAME

C_GROUPS_GET_GROUPS_0=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE 
	
	
C_GROUPS_GET_CHILD_1=\
SELECT \
	* \
FROM \
	CMS_GROUPS \
WHERE \
	CMS_GROUPS.PARENT_GROUP_ID=?
	
	
# Query is built within the CmsUserDriver class
C_GROUPS_GET_GROUPS_OF_USER_1=\
SELECT \
	* \
FROM \
	CMS_GROUPS G,\
	CMS_GROUPUSERS GU \
WHERE \
	GU.USER_ID=? \
    AND G.GROUP_ID=GU.GROUP_ID \
    AND
	

	
C_GROUPS_ADD_USER_TO_GROUP_3=\
INSERT INTO CMS_GROUPUSERS \
	(GROUP_ID,\
	USER_ID,\
	GROUPUSER_FLAGS) \
VALUES \
	(?,?,?)
	
	
C_GROUPS_USER_IN_GROUP_2=\
SELECT \
	* \
FROM \
	CMS_GROUPUSERS \
WHERE \
	CMS_GROUPUSERS.GROUP_ID=? \
	AND CMS_GROUPUSERS.USER_ID=?
	
	
C_GROUPS_GET_USERS_OF_GROUP_2=\
SELECT \
	U.USER_ID,\
	U.USER_NAME,\
	U.USER_PASSWORD,\
	U.USER_FIRSTNAME,\
	U.USER_LASTNAME,\
	U.USER_EMAIL,\
	U.USER_LASTLOGIN,\
	U.USER_FLAGS,\
	U.USER_OU,\
	U.USER_DATECREATED \
FROM \
	CMS_GROUPS G, \
	CMS_USERS U, \
	CMS_GROUPUSERS GU \
WHERE \
	G.GROUP_NAME=? \
	AND G.GROUP_OU=? \
	AND G.GROUP_OU=U.USER_OU \
    AND U.USER_ID=GU.USER_ID \
    AND GU.GROUP_ID=G.GROUP_ID \
ORDER BY \
	U.USER_OU,U.USER_NAME

	
C_GROUPS_GET_ALL_USERS_OF_GROUP_2=\
SELECT \
	U.USER_ID,\
	U.USER_NAME,\
	U.USER_PASSWORD,\
	U.USER_FIRSTNAME,\
	U.USER_LASTNAME,\
	U.USER_EMAIL,\
	U.USER_LASTLOGIN,\
	U.USER_FLAGS,\
	U.USER_OU,\
	U.USER_DATECREATED \
FROM \
	CMS_GROUPS G, \
	CMS_USERS U, \
	CMS_GROUPUSERS GU \
WHERE \
	G.GROUP_NAME=? \
	AND G.GROUP_OU=? \
    AND U.USER_ID=GU.USER_ID \
    AND GU.GROUP_ID=G.GROUP_ID \
ORDER BY \
	U.USER_OU,U.USER_NAME

	
C_GROUPS_REMOVE_USER_FROM_GROUP_2=\
DELETE FROM \
	CMS_GROUPUSERS \
WHERE \
	CMS_GROUPUSERS.GROUP_ID=? \
	AND CMS_GROUPUSERS.USER_ID=?


#
# Users
#
C_USERS_USER_ID_0=USER_ID
C_USERS_USER_NAME_0=USER_NAME
C_USERS_USER_PASSWORD_0=USER_PASSWORD
C_USERS_USER_FIRSTNAME_0=USER_FIRSTNAME
C_USERS_USER_LASTNAME_0=USER_LASTNAME
C_USERS_USER_LASTLOGIN_0=USER_LASTLOGIN
C_USERS_USER_FLAGS_0=USER_FLAGS
C_USERS_USER_EMAIL_0=USER_EMAIL
C_USERS_USER_OU_0=USER_OU
C_USERS_USER_DATECREATED_0=USER_DATECREATED

C_USER_ATTRIBS=\
	CMS_USERS.USER_ID,\
	CMS_USERS.USER_NAME,\
	CMS_USERS.USER_PASSWORD,\
	CMS_USERS.USER_FIRSTNAME,\
	CMS_USERS.USER_LASTNAME,\
	CMS_USERS.USER_EMAIL,\
	CMS_USERS.USER_LASTLOGIN,\
	CMS_USERS.USER_FLAGS,\
	CMS_USERS.USER_OU,\
	CMS_USERS.USER_DATECREATED

C_USERS_ADD_10=\
INSERT INTO CMS_USERS \
	(USER_ID,\
	USER_NAME,\
	USER_PASSWORD,\
	USER_FIRSTNAME,\
	USER_LASTNAME,\
	USER_EMAIL,\
	USER_LASTLOGIN,\
	USER_FLAGS,\
	USER_OU,\
	USER_DATECREATED\
) \
VALUES \
	(?,?,?,?,?,?,?,?,?,?)
	
	
C_USERS_READ_BY_NAME_2=\
SELECT \
	${C_USER_ATTRIBS} \
FROM \
	CMS_USERS \
WHERE \
	CMS_USERS.USER_NAME=? \
    AND CMS_USERS.USER_OU=?
	
	
C_USERS_READ_BY_ID_1=\
SELECT \
	${C_USER_ATTRIBS} \
FROM \
	CMS_USERS \
WHERE \
	CMS_USERS.USER_ID=?
	
	
C_USERS_READ_WITH_PWD_3=\
SELECT \
	${C_USER_ATTRIBS} \
FROM \
	CMS_USERS \
WHERE \
	CMS_USERS.USER_NAME=? \
	AND CMS_USERS.USER_OU=? \
    AND CMS_USERS.USER_PASSWORD=?
	
C_USERS_WRITE_6=\
UPDATE \
	CMS_USERS \
SET \
	USER_FIRSTNAME=?,\
	USER_LASTNAME=?,\
	USER_EMAIL=?,\
	USER_LASTLOGIN=?,\
	USER_FLAGS=? \
WHERE \
	CMS_USERS.USER_ID=?
	
	
C_USERS_DELETE_2=\
DELETE FROM \
	CMS_USERS \
WHERE \
	CMS_USERS.USER_NAME = ? AND \
	CMS_USERS.USER_OU = ?
	

C_USERS_GET_USERS_FOR_ORGUNIT_1=\
SELECT \
	${C_USER_ATTRIBS} \
FROM \
	CMS_USERS \
WHERE \
    CMS_USERS.USER_OU LIKE ? \
ORDER BY \
	CMS_USERS.USER_NAME
	
	
C_USERS_SET_PWD_3=\
UPDATE \
	CMS_USERS \
SET \
	USER_PASSWORD=? \
WHERE \
	CMS_USERS.USER_NAME=? AND \
	CMS_USERS.USER_OU=?
	

C_USERS_SET_ORGUNIT_2=\
UPDATE \
  CMS_USERS \
SET \
  USER_OU = ? \
WHERE \
  CMS_USERS.USER_ID = ?


#
# Userdata
#
C_USERDATA_USERID_0=USER_ID
C_USERDATA_KEY_0=DATA_KEY
C_USERDATA_VALUE_0=DATA_VALUE
C_USERDATA_TYPE_0=DATA_TYPE

C_USERDATA_ATTRIBS=\
	CMS_USERDATA.USER_ID,\
	CMS_USERDATA.DATA_KEY,\
	CMS_USERDATA.DATA_VALUE,\
	CMS_USERDATA.DATA_TYPE

C_USERDATA_WRITE_4=\
INSERT INTO	CMS_USERDATA \
	(USER_ID,\
	DATA_KEY,\
	DATA_VALUE,\
	DATA_TYPE) \
VALUES \
    (?, ?, ?, ?)

C_USERDATA_DELETE_1=\
DELETE FROM CMS_USERDATA \
WHERE \
    CMS_USERDATA.USER_ID = ?
    
C_USERDATA_READ_1=\
SELECT \
	${C_USERDATA_ATTRIBS} \
FROM \
    CMS_USERDATA \
WHERE \
	CMS_USERDATA.USER_ID = ?

#
# User history
#
1234

query.properties - 源码说明

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

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

⌨️ 快捷键说明

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