/** * @see org.opencms.db.I_CmsHistoryDriver#readPublishTag(org.opencms.db.CmsDbContext, long) */ public int readPublishTag(CmsDbContext dbc, long maxdate) throws CmsDataAccessException { int maxVersion = 0; try { Query q = m_sqlManager.createQuery(dbc, C_PROJECTS_HISTORY_READ_TAG_FOR_DATE); q.setParameter(1, Long.valueOf(maxdate)); try { maxVersion = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return maxVersion; }
q.setParameter(1, resourceId.toString()); try { resourceVersion = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { structureVersion = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) {
projectPublishTag = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()) + 1; } catch (NoResultException e) { resourcePublishTag = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()) + 1; } catch (NoResultException e) { resourcePublishTag = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()) + 1; } catch (NoResultException e) {
/** * @see org.opencms.db.I_CmsUserDriver#existsGroup(org.opencms.db.CmsDbContext, java.lang.String) */ public boolean existsGroup(CmsDbContext dbc, String groupFqn) throws CmsDataAccessException { boolean result = false; try { Query q = m_sqlManager.createQuery(dbc, C_GROUPS_CHECK_BY_NAME_2); q.setParameter(1, CmsOrganizationalUnit.getSimpleName(groupFqn)); q.setParameter(2, CmsOrganizationalUnit.SEPARATOR + CmsOrganizationalUnit.getParentFqn(groupFqn)); int count = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); if (count > 0) { result = true; } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return result; }
/** * @see org.opencms.db.I_CmsUserDriver#existsUser(org.opencms.db.CmsDbContext, java.lang.String) */ public boolean existsUser(CmsDbContext dbc, String userFqn) throws CmsDataAccessException { boolean result = false; try { Query q = m_sqlManager.createQuery(dbc, C_USERS_CHECK_BY_NAME_2); q.setParameter(1, CmsOrganizationalUnit.getSimpleName(userFqn)); q.setParameter(2, CmsOrganizationalUnit.SEPARATOR + CmsOrganizationalUnit.getParentFqn(userFqn)); int count = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); if (count > 0) { result = true; } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return result; }
/** * @see org.opencms.db.I_CmsHistoryDriver#readMaxPublishTag(CmsDbContext, CmsUUID) */ public int readMaxPublishTag(CmsDbContext dbc, CmsUUID resourceId) throws CmsDataAccessException { int result = 0; try { Query q = m_sqlManager.createQuery(dbc, C_RESOURCES_READ_MAX_PUBLISH_TAG); q.setParameter(1, resourceId.toString()); try { result = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return result; }
/** * @see org.opencms.db.I_CmsHistoryDriver#getAllDeletedEntries(org.opencms.db.CmsDbContext) */ public List<I_CmsHistoryResource> getAllDeletedEntries(CmsDbContext dbc) throws CmsDataAccessException { Query q = null; List<I_CmsHistoryResource> entries = new ArrayList<I_CmsHistoryResource>(); try { // get all not-deleted historical entries that may come in question q = m_sqlManager.createQuery(dbc, C_STRUCTURE_HISTORY_READ_DELETED); @SuppressWarnings("unchecked") List<Object[]> res = q.getResultList(); for (Object[] obj : res) { CmsUUID structureId = new CmsUUID((String)obj[0]); int version = CmsDataTypeUtil.numberToInt((Integer)obj[1]); entries.add(readResource(dbc, structureId, version)); } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return entries; }
/** * @see org.opencms.db.I_CmsHistoryDriver#getAllNotDeletedEntries(CmsDbContext) */ public List<I_CmsHistoryResource> getAllNotDeletedEntries(CmsDbContext dbc) throws CmsDataAccessException { List<I_CmsHistoryResource> entries = new ArrayList<I_CmsHistoryResource>(); try { // get all not-deleted historical entries that may come in question Query q = m_sqlManager.createQuery(dbc, C_STRUCTURE_HISTORY_READ_NOTDELETED); @SuppressWarnings("unchecked") List<Object[]> res = q.getResultList(); for (Object[] o : res) { CmsUUID structureId = new CmsUUID((String)o[0]); int version = CmsDataTypeUtil.numberToInt((Number)o[1]); entries.add(readResource(dbc, structureId, version)); } } catch (PersistenceException e) { throw new CmsDbSqlException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return entries; }
/** * @see org.opencms.db.I_CmsHistoryDriver#readLastVersion(org.opencms.db.CmsDbContext, org.opencms.util.CmsUUID) */ public int readLastVersion(CmsDbContext dbc, CmsUUID structureId) throws CmsDataAccessException { int lastVersion = 0; try { Query q = m_sqlManager.createQuery(dbc, C_STRUCTURE_HISTORY_MAXVER); q.setParameter(1, structureId.toString()); try { lastVersion = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { // do nothing } catch (NullPointerException e) { lastVersion = 0; } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return lastVersion; }
q.setParameter(2, Integer.valueOf(resource.getPublishTag())); try { pubTag = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { String propertyKey = (String)o[0]; String propertyValue = (String)o[1]; int mappingType = CmsDataTypeUtil.numberToInt((Number)o[2]); String propertyKey = (String)o[0]; String propertyValue = (String)o[1]; int mappingType = CmsDataTypeUtil.numberToInt((Number)o[2]);
/** * @see org.opencms.db.I_CmsVfsDriver#validateStructureIdExists(org.opencms.db.CmsDbContext, CmsUUID, org.opencms.util.CmsUUID) */ public boolean validateStructureIdExists(CmsDbContext dbc, CmsUUID projectId, CmsUUID structureId) throws CmsDataAccessException { boolean found = false; int count = 0; try { Query q = m_sqlManager.createQuery(dbc, projectId, C_RESOURCES_SELECT_STRUCTURE_ID); q.setParameter(1, structureId.toString()); try { count = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); found = (count == 1); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return found; }
/** * @see org.opencms.db.I_CmsVfsDriver#validateResourceIdExists(org.opencms.db.CmsDbContext, CmsUUID, org.opencms.util.CmsUUID) */ public boolean validateResourceIdExists(CmsDbContext dbc, CmsUUID projectId, CmsUUID resourceId) throws CmsDataAccessException { boolean exists = false; try { Query q = m_sqlManager.createQuery(dbc, projectId, C_RESOURCES_READ_RESOURCE_STATE); q.setParameter(1, resourceId.toString()); try { @SuppressWarnings("unused") int state = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); exists = true; } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return exists; }
/** * Counts the number of siblings of a resource.<p> * * @param dbc the current database context * @param projectId the current project id * @param resourceId the resource id to count the number of siblings from * * @return number of siblings * @throws CmsDataAccessException if something goes wrong */ public int countSiblings(CmsDbContext dbc, CmsUUID projectId, CmsUUID resourceId) throws CmsDataAccessException { int count = 0; try { Query q = m_sqlManager.createQuery(dbc, projectId, C_RESOURCES_COUNT_SIBLINGS); q.setParameter(1, resourceId.toString()); try { count = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return count; }
/** * Returns the resource state of the given resource.<p> * * @param dbc the database context * @param projectId the id of the project * @param resource the resource to read the resource state for * * @return the resource state of the given resource * * @throws CmsDataAccessException if something goes wrong */ protected CmsResourceState internalReadResourceState(CmsDbContext dbc, CmsUUID projectId, CmsResource resource) throws CmsDataAccessException { CmsResourceState state = CmsResource.STATE_KEEP; try { Query q = m_sqlManager.createQuery(dbc, projectId, C_READ_RESOURCE_STATE); q.setParameter(1, resource.getResourceId().toString()); try { state = CmsResourceState.valueOf(CmsDataTypeUtil.numberToInt((Number)q.getSingleResult())); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return state; }
/** * Returns the structure state of the given resource.<p> * * @param dbc the database context * @param projectId the id of the project * @param resource the resource to read the structure state for * * @return the structure state of the given resource * * @throws CmsDataAccessException if something goes wrong */ protected CmsResourceState internalReadStructureState(CmsDbContext dbc, CmsUUID projectId, CmsResource resource) throws CmsDataAccessException { CmsResourceState state = CmsResource.STATE_KEEP; try { Query q = m_sqlManager.createQuery(dbc, projectId, C_READ_STRUCTURE_STATE); q.setParameter(1, resource.getStructureId().toString()); try { state = CmsResourceState.valueOf(CmsDataTypeUtil.numberToInt((Number)q.getSingleResult())); } catch (NoResultException e) { // do nothing } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return state; }
for (Object[] obj : res) { CmsUUID structureId = new CmsUUID((String)obj[0]); int version = CmsDataTypeUtil.numberToInt((Integer)obj[1]); subResources.add(readResource(dbc, structureId, version));
/** * Returns the count of properties for a property definition.<p> * * @param dbc the current database context * @param propertyDefinition the property definition to test * @param projectId the ID of the current project * * @return the amount of properties for a property definition * @throws CmsDataAccessException if something goes wrong */ protected int internalCountProperties(CmsDbContext dbc, CmsPropertyDefinition propertyDefinition, CmsUUID projectId) throws CmsDataAccessException { int count = 0; try { // create statement Query q = m_sqlManager.createQuery(dbc, projectId, C_PROPERTIES_READALL_COUNT); q.setParameter(1, propertyDefinition.getId().toString()); try { count = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { throw new CmsDbConsistencyException( Messages.get().container(Messages.ERR_COUNTING_PROPERTIES_1, propertyDefinition.getName())); } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return count; }
/** * Returns the amount of properties for a propertydefinition.<p> * * @param dbc the current database context * @param metadef the propertydefinition to test * @param projectId the ID of the current project * * @return the amount of properties for a propertydefinition * @throws CmsDataAccessException if something goes wrong */ protected int internalCountProperties(CmsDbContext dbc, CmsPropertyDefinition metadef, CmsUUID projectId) throws CmsDataAccessException { int returnValue; try { // create statement Query q = m_sqlManager.createQuery(dbc, projectId, C_PROPERTIES_READALL_COUNT); q.setParameter(1, metadef.getId().toString()); try { returnValue = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) { throw new CmsDbConsistencyException( Messages.get().container(Messages.ERR_NO_PROPERTIES_FOR_PROPERTYDEF_1, metadef.getName())); } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } return returnValue; }
q.setParameter(1, resourceName); try { returnValue = CmsDataTypeUtil.numberToInt((Number)q.getSingleResult()); } catch (NoResultException e) {
resource.getResourceId(), resource.getStructureId()); int structureVersion = CmsDataTypeUtil.numberToInt(versions.get("structure")); int resourceVersion = CmsDataTypeUtil.numberToInt(versions.get("resource"));