Object blob = getBlob(entry); String statement = null; if (blob instanceof byte[]) + insertFields(m_resourceTableIdField, m_resourceTableOtherFields, "BINARY_ENTITY, XML") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? , NULL )"; + insertFields(m_resourceTableIdField, m_resourceTableOtherFields, "XML, BINARY_ENTITY ") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ?, NULL )"; Object[] fields = new Object[flds.length + 2]; System.arraycopy(flds, 0, fields, 1, flds.length); fields[0] = caseId(entry.getId()); fields[fields.length - 1] = blob; Edit edit = editResource(id); if (edit == null)
public boolean isEmpty() { // count int count = countAllResources(); return (count == 0); }
public List getAllResourcesWhereLike(String field, String value) { String sql = singleStorageSql.getXmlLikeSql(field, m_resourceTableName); Object[] fields = new Object[1]; fields[0] = value; // %%% + "order by " + m_resourceTableOrderField + " asc"; return loadResources(sql, fields); }
public Object readSqlResultRecord(ResultSet result) { try { // read the id m_resourceTableIdField String id = result.getString(1); // read the xml String xml = result.getString(2); byte[] blob = result.getBytes(3); if (!filter.accept(caseId(id))) return null; return readResource(xml, blob); } catch (SQLException ignore) { return null; } } });
/** * Get the Resource with this id, or null if not found. * * @param id * The id. * @return The Resource with this id, or null if not found. */ public Entity getResource(String id) { Entity entry = null; // get the user from the db List xml = null; String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); xml = loadResources(sql, fields); if (!xml.isEmpty()) { // create the Resource from the db xml entry = (Entity) xml.get(0); } return entry; }
Object blob = getBlob(edit); String statement = null; if (blob instanceof byte[]) + updateSet(m_resourceTableOtherFields) + " BINARY_ENTITY = ?, XML = NULL where ( " + m_resourceTableIdField + " = ? )"; + updateSet(m_resourceTableOtherFields) + " XML = ?, BINARY_ENTITY = NULL where ( " + m_resourceTableIdField + " = ? )"; System.arraycopy(flds, 0, fields, 0, flds.length); fields[fields.length - 2] = blob; fields[fields.length - 1] = caseId(edit.getId()); lockFields[1] = internalRecordId(caseId(edit.getId())); boolean ok = m_sql.dbWrite(statement, lockFields); if (!ok)
Object blob = getBlob(entry); String statement = null; if (blob instanceof byte[]) + insertDeleteFields(m_resourceTableIdField, m_resourceTableOtherFields, "RESOURCE_UUID", "DELETE_DATE", "DELETE_USERID", "BINARY_ENTITY, XML") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? ,? ,? ,?, NULL)"; + insertDeleteFields(m_resourceTableIdField, m_resourceTableOtherFields, "RESOURCE_UUID", "DELETE_DATE", "DELETE_USERID", "XML, BINARY_ENTITY") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? ,? ,? ,?, NULL)"; Object[] fields = new Object[flds.length + 5]; System.arraycopy(flds, 0, fields, 1, flds.length); fields[0] = caseId(entry.getId()); Edit edit = editResource(id); if (edit == null)
+ StorageUtils.escapeSql(caseId(id)) + "' )" + " for update nowait"; lock = m_sql.dbReadLock(statement, new SqlReader() + StorageUtils.escapeSql(caseId(id)) + "' )" + " for update nowait"; lock = m_sql.dbReadLock(statement, new SqlReader() Entity entry = getResource(id); if (entry == null) return null; fields[1] = internalRecordId(caseId(id)); fields[2] = TimeService.newTime(); fields[3] = sessionId; Entity entry = getResource(id); if (entry == null) return null;
lockFields[1] = internalRecordId(caseId(edit.getId())); boolean ok = m_sql.dbWrite(statement, lockFields); if (!ok)
/** * Check if a Resource by this id exists. * * @param id * The id. * @return true if a Resource by this id exists, false if not. */ public boolean checkResource(String id) { // just see if the record exists String sql = singleStorageSql.getResourceIdSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); List ids = m_sql.dbRead(sql, fields, null); return (!ids.isEmpty()); }
m_collectionStore = new BaseDbDualSingleStorage(m_collectionTableName, "COLLECTION_ID", COLLECTION_FIELDS, m_locksInDb, "collection", collectionUser, m_sqlService); m_collectionStorageFields = BaseDbDualSingleStorage.STORAGE_FIELDS; m_resourceStore = new BaseDbDualSingleStorage(m_resourceTableName, "RESOURCE_ID", (bodyInFile ? RESOURCE_FIELDS_FILE_CONTEXT : RESOURCE_FIELDS_CONTEXT ), m_locksInDb, "resource", resourceUser, m_sqlService); m_resourceDeleteStore = new BaseDbDualSingleStorage(m_resourceDeleteTableName, "RESOURCE_ID", (bodyInFile ? RESOURCE_FIELDS_FILE_CONTEXT : RESOURCE_FIELDS_CONTEXT ), m_locksInDb, "resource", resourceUser, m_sqlService, m_resourceStore); // support for SAK-12874
Object blob = getBlob(edit); String statement = null; if (blob instanceof byte[]) + updateSet(m_resourceTableOtherFields) + " BINARY_ENTITY = ?, XML = NULL where ( RESOURCE_UUID = ? )"; + updateSet(m_resourceTableOtherFields) + " XML = ?, BINARY_ENTITY = NULL where ( RESOURCE_UUID = ? )"; lockFields[1] = internalRecordId(caseId(edit.getId())); boolean ok = m_sql.dbWrite(statement, lockFields); if (!ok)
Object blob = getBlob(entry); String statement = null; if (blob instanceof byte[]) + insertDeleteFields(m_resourceTableIdField, m_resourceTableOtherFields, "RESOURCE_UUID", "DELETE_DATE", "DELETE_USERID", "BINARY_ENTITY, XML") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? ,? ,? ,?, NULL)"; + insertDeleteFields(m_resourceTableIdField, m_resourceTableOtherFields, "RESOURCE_UUID", "DELETE_DATE", "DELETE_USERID", "XML, BINARY_ENTITY") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? ,? ,? ,?, NULL)"; Object[] fields = new Object[flds.length + 5]; System.arraycopy(flds, 0, fields, 1, flds.length); fields[0] = caseId(entry.getId()); Edit edit = editResource(id); if (edit == null)
+ StorageUtils.escapeSql(caseId(id)) + "' )" + " for update nowait"; lock = m_sql.dbReadLock(statement, new SqlReader() + StorageUtils.escapeSql(caseId(id)) + "' )" + " for update nowait"; lock = m_sql.dbReadLock(statement, new SqlReader() Entity entry = getResource(id); if (entry == null) return null; fields[1] = internalRecordId(caseId(id)); fields[2] = TimeService.newTime(); fields[3] = sessionId; Entity entry = getResource(id); if (entry == null) return null;
lockFields[1] = internalRecordId(caseId(edit.getId())); boolean ok = m_sql.dbWrite(statement, lockFields); if (!ok)
public Object readSqlResultRecord(ResultSet result) { try { // read the id m_resourceTableIdField String id = result.getString(1); // read the xml String xml = result.getString(2); byte[] blob = result.getBytes(3); if (!filter.accept(caseId(id))) return null; return readResource(xml, blob); } catch (SQLException ignore) { return null; } } });
/** * Get the Resource with this id, or null if not found. * * @param id * The id. * @return The Resource with this id, or null if not found. */ public Entity getResource(String id) { Entity entry = null; // get the user from the db List xml = null; String sql = singleStorageSql.getXmlSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); xml = loadResources(sql, fields); if (!xml.isEmpty()) { // create the Resource from the db xml entry = (Entity) xml.get(0); } return entry; }
/** * Check if a Resource by this id exists. * * @param id * The id. * @return true if a Resource by this id exists, false if not. */ public boolean checkResource(String id) { // just see if the record exists String sql = singleStorageSql.getResourceIdSql(m_resourceTableIdField, m_resourceTableName); Object fields[] = new Object[1]; fields[0] = caseId(id); List ids = m_sql.dbRead(sql, fields, null); return (!ids.isEmpty()); }
Object blob = getBlob(edit); String statement = null; if (blob instanceof byte[]) + updateSet(m_resourceTableOtherFields) + " BINARY_ENTITY = ?, XML = NULL where ( " + m_resourceTableIdField + " = ? )"; + updateSet(m_resourceTableOtherFields) + " XML = ?, BINARY_ENTITY = NULL where ( " + m_resourceTableIdField + " = ? )"; System.arraycopy(flds, 0, fields, 0, flds.length); fields[fields.length - 2] = blob; fields[fields.length - 1] = caseId(edit.getId()); lockFields[1] = internalRecordId(caseId(edit.getId())); boolean ok = m_sql.dbWrite(statement, lockFields); if (!ok)
Object blob = getBlob(entry); String statement = null; if (blob instanceof byte[]) + insertFields(m_resourceTableIdField, m_resourceTableOtherFields, "BINARY_ENTITY, XML") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ? , NULL )"; + insertFields(m_resourceTableIdField, m_resourceTableOtherFields, "XML, BINARY_ENTITY ") + " values ( ?, " + valuesParams(m_resourceTableOtherFields) + " ?, NULL )"; Object[] fields = new Object[flds.length + 2]; System.arraycopy(flds, 0, fields, 1, flds.length); fields[0] = caseId(entry.getId()); fields[fields.length - 1] = blob; Edit edit = editResource(id); if (edit == null)