policydatabase.properties

这是linux下ssl vpn的实现程序

getPolicy.selectById=SELECT * FROM policy WHERE id=?
getPolicies.select=SELECT * FROM policy
createPolicy.insert=INSERT INTO policy (policy_type_id, policy_name, policy_description, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?);
createPolicy.lastInsertId=SELECT LAST_INSERT_ID() as id FROM policy_id
createPolicy.insert.childPolicy=INSERT INTO policy_children (policy_id, policy_child_id) VALUES (?,?);
createPolicy.insert.deleteChildPolicies=DELETE FROM policy_children WHERE policy_id=?;
updatePolicy.update=UPDATE policy SET policy_type_id=?, policy_name=?, policy_description=?,parent_resource_permission=?,date_amended=? WHERE id=?
deletePolicy.delete=DELETE FROM policy WHERE id=?
deletePolicy.relationships1=DELETE FROM policy_principal_relationship WHERE policy_id=?
deletePolicy.relationships2=DELETE FROM policy_resource_relationship WHERE policy_id=?
grantPolicyToPrincipal.insert=INSERT INTO policy_principal_relationship (policy_id,principal_id, principal_type) VALUES (?,?,?);
revokePolicyFromPrincipal.delete=DELETE FROM policy_principal_relationship WHERE policy_id=? AND principal_id=?;
revokeAllPoliciesFromPrincipal.delete=DELETE FROM policy_principal_relationship WHERE principal_id=?;
isPolicyGrantedToPrincipal.select=SELECT * FROM policy_principal_relationship WHERE policy_id=? AND principal_id=?;
attachResourceToPolicy.insert=INSERT INTO policy_resource_relationship (resource_id,resource_type,policy_id,sequence) VALUES (?,?,?,?);
detachResourceFromPolicy.delete=DELETE FROM policy_resource_relationship WHERE resource_id=? AND resource_type=? AND policy_id=?
isResourceAttachedToPolicy.select=SELECT * FROM policy_resource_relationship WHERE  resource_id=? AND resource_type=? AND policy_id=?
getPoliciesAttachedToResource.select=SELECT * from policy, policy_resource_relationship where policy_resource_relationship.policy_id=policy.id and policy_resource_relationship.resource_id=? and policy_resource_relationship.resource_type=? ORDER BY sequence ASC
getPrincipalsGrantedPolicy.select=SELECT * from policy_principal_relationship WHERE policy_id=?
revokePolicyFromAllPrincipals.delete=DELETE FROM policy_principal_relationship WHERE policy_id=?
createResourcePermission.insert=INSERT INTO resource_permission (resource_name, resource_class, resource_description, onward_delegation, parent_resource_permission, date_created, date_amended) VALUES (?,?,?,?,?,?,?);
createResourcePermission.lastInsertId=SELECT LAST_INSERT_ID() as id FROM resource_permission
getPolicyByName.selectByName=SELECT * FROM policy WHERE policy_name=?
getResourcePermissions.select=SELECT * FROM resource_permission,resource_permission_permissions WHERE resource_permission_id=resource_id
getChildPolicies.select=SELECT * FROM  policy_children WHERE policy_id=?
getParentPolicies.select=SELECT * FROM  policy_children WHERE policy_child_id=?
getResourcePermissionByName.select=SELECT * FROM resource_permission,resource_permission_permissions WHERE resource_name=? AND resource_permission_id=resource_id
getResourcePermission.select=SELECT * FROM resource_permission,resource_permission_permissions WHERE resource_id=? AND resource_permission_id=resource_id 
getGrantedResourcesOfType.select=SELECT resource_id FROM policy,policy_resource_relationship WHERE policy.id = 0 AND policy.id = policy_resource_relationship.policy_id AND  policy_resource_relationship.resource_type=? UNION DISTINCT SELECT resource_id FROM policy,policy_resource_relationship,policy_principal_relationship WHERE policy.id = policy_resource_relationship.policy_id AND policy.id = policy_principal_relationship.policy_id AND principal_id=? AND principal_type=? AND resource_type=?
isPrincipalGranted.selectAny=SELECT resource_type FROM policy,policy_resource_relationship WHERE policy.id = 0  AND policy.id = policy_resource_relationship.policy_id  UNION DISTINCT SELECT resource_type FROM policy,policy_resource_relationship,policy_principal_relationship WHERE policy.id = policy_resource_relationship.policy_id AND id = policy_principal_relationship.policy_id AND principal_id=? AND principal_type=?
isPrincipalGranted.selectType=SELECT resource_type FROM policy,policy_resource_relationship WHERE policy.id = 0 AND policy.id = policy_resource_relationship.policy_id AND policy_resource_relationship.resource_type=? UNION DISTINCT SELECT resource_type FROM policy,policy_resource_relationship,policy_principal_relationship WHERE policy.id = policy_resource_relationship.policy_id AND policy.id = policy_principal_relationship.policy_id AND principal_id=? AND principal_type=? AND resource_type=?
deleteResourcePermission.delete=DELETE from resource_permission where resource_id=?
deleteResourcePermission.policyRelationship=DELETE FROM policy_resource_relationship WHERE resource_id=?
deleteResourcePermission.delegation=DELETE FROM resource_permission_delegation WHERE resource_permission_id=?
deleteResourcePermissionRelationships.delete=DELETE from resource_permission_permissions WHERE resource_permission_id=?
updateResourcePermission.update=UPDATE resource_permission SET resource_name=?,resource_description=?,onward_delegation=?,parent_resource_permission=?,date_amended=? WHERE resource_id=?
updateResourcePermission.insertPermissions=INSERT INTO resource_permission_permissions (resource_permission_id, resource_type_id, permission_id) VALUES (?,?,?);
getResourcePermissionDelegatedPolicies.select=SELECT * from policy, resource_permission_delegation where resource_permission_delegation.policy_id=policy.id and resource_permission_delegation.resource_permission_id=?
addResourcePermissionDelegationToPolicy.insert=INSERT INTO resource_permission_delegation (resource_permission_id,policy_id) VALUES (?,?);
removeResourcePermissionDelegationFromPolicy.delete=DELETE FROM resource_permission_delegation WHERE resource_permission_id=? AND policy_id=? AND policy_id=?
clearResourcePermissionDelegation.delete=DELETE FROM resource_permission_delegation WHERE resource_permission_id=?