protected ValueReadQuery buildSelectQuery() { ValueReadQuery query = new ValueReadQuery(); query.addArgument(getNameFieldName()); StringWriter writer = new StringWriter(); writer.write("SELECT " + getCounterFieldName()); writer.write(" FROM " + getQualifiedTableName()); writer.write(" WHERE " + getNameFieldName()); writer.write(" = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; }
protected ValueReadQuery buildSelectQuery() { ValueReadQuery query = new ValueReadQuery(); query.addArgument(getNameFieldName()); StringWriter writer = new StringWriter(); writer.write("SELECT " + getCounterFieldName()); writer.write(" FROM " + getQualifiedTableName()); writer.write(" WHERE " + getNameFieldName()); writer.write(" = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; }
protected ValueReadQuery buildSelectQuery() { ValueReadQuery query = new ValueReadQuery(); query.addArgument(getNameFieldName()); StringWriter writer = new StringWriter(); writer.write("SELECT " + getCounterFieldName()); writer.write(" FROM " + getQualifiedTableName()); writer.write(" WHERE " + getNameFieldName()); writer.write(" = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; }
protected DataModifyQuery buildUpdateQuery() { DataModifyQuery query = new DataModifyQuery(); query.addArgument(getNameFieldName()); query.addArgument("PREALLOC_SIZE"); StringWriter writer = new StringWriter(); writer.write("UPDATE " + getQualifiedTableName()); writer.write(" SET " + getCounterFieldName()); writer.write(" = " + getCounterFieldName()); writer.write(" + #PREALLOC_SIZE"); writer.write(" WHERE " + getNameFieldName() + " = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; } }
protected DataModifyQuery buildUpdateQuery() { DataModifyQuery query = new DataModifyQuery(); query.addArgument(getNameFieldName()); query.addArgument("PREALLOC_SIZE"); StringWriter writer = new StringWriter(); writer.write("UPDATE " + getQualifiedTableName()); writer.write(" SET " + getCounterFieldName()); writer.write(" = " + getCounterFieldName()); writer.write(" + #PREALLOC_SIZE"); writer.write(" WHERE " + getNameFieldName() + " = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; } }
protected DataModifyQuery buildUpdateQuery() { DataModifyQuery query = new DataModifyQuery(); query.addArgument(getNameFieldName()); query.addArgument("PREALLOC_SIZE"); StringWriter writer = new StringWriter(); writer.write("UPDATE " + getQualifiedTableName()); writer.write(" SET " + getCounterFieldName()); writer.write(" = " + getCounterFieldName()); writer.write(" + #PREALLOC_SIZE"); writer.write(" WHERE " + getNameFieldName() + " = #" + getNameFieldName()); query.setSQLString(writer.toString()); return query; } }
/** * This returns the Sequence Table's qualified name, without delimiting. * @param session * @return the qualified table name */ protected String getSequenceTableName(Session session) { String sequenceTableName = null; if (session.getProject().usesSequencing()) { Sequence sequence = session.getLogin().getDefaultSequence(); if (sequence instanceof TableSequence) { sequenceTableName = ((TableSequence)sequence).getQualifiedTableName(); } } return sequenceTableName; }
/** * This returns the Sequence Table's qualified name, without delimiting. * @param session * @return the qualified table name */ protected String getSequenceTableName(Session session) { String sequenceTableName = null; if (session.getProject().usesSequencing()) { Sequence sequence = session.getLogin().getDefaultSequence(); if (sequence instanceof TableSequence) { sequenceTableName = ((TableSequence)sequence).getQualifiedTableName(); } } return sequenceTableName; }