@Override public String getSelectIdRowSql() { if (selectIdRowSql == null) { selectIdRowSql = String.format("SELECT %s FROM %s WHERE %s = ?", config.idColumnName(), getTableName(), config.idColumnName()); } return selectIdRowSql; }
@Override public String getSelectIdRowSql() { if (selectIdRowSql == null) { selectIdRowSql = String.format("SELECT %s FROM %s WHERE %s = cast(? as %s)", config.idColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectIdRowSql; }
@Override public String getSelectRowSql() { if (selectRowSql == null) { selectRowSql = String.format("SELECT %s, %s FROM %s WHERE %s = ?", config.idColumnName(), config.dataColumnName(), getTableName(), config.idColumnName()); } return selectRowSql; }
@Override public String getDeleteRowSql() { if (deleteRowSql == null) { deleteRowSql = String.format("DELETE FROM %s WHERE %s = ?", getTableName(), config.idColumnName()); } return deleteRowSql; }
@Override public String getSelectIdRowSql() { if (selectIdRowSql == null) { selectIdRowSql = String.format("SELECT %s FROM %s WHERE %s = convert(%s,?)", config.idColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectIdRowSql; }
@Override public String getSelectRowSql() { if (selectRowSql == null) { selectRowSql = String.format("SELECT %s, %s FROM %s WHERE %s = cast(? as %s)", config.idColumnName(), config.dataColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectRowSql; }
@Override public String getSelectRowSql() { if (selectRowSql == null) { selectRowSql = String.format("SELECT %s, %s FROM %s WHERE %s = convert(%s,?)", config.idColumnName(), config.dataColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectRowSql; }
@Override public String getLoadAllRowsSql() { if (loadAllRowsSql == null) { loadAllRowsSql = String.format("SELECT %s, %s FROM %s", config.dataColumnName(), config.idColumnName(), getTableName()); } return loadAllRowsSql; }
@Override public String getDeleteRowSql() { if (deleteRowSql == null) { deleteRowSql = String.format("DELETE FROM %s WHERE %s = cast(? as %s)", getTableName(), config.idColumnName(), config.idColumnType()); } return deleteRowSql; }
@Override public String getDeleteRowSql() { if (deleteRowSql == null) { deleteRowSql = String.format("DELETE FROM %s WHERE %s = convert(%s,?)", getTableName(), config.idColumnName(), config.idColumnType()); } return deleteRowSql; }
@Override public String getSelectMultipleRowSql(int numberOfParams) { String selectCriteria = config.idColumnName() + " = convert(" + config.idColumnType() + ",?)"; return getSelectMultipleRowSql(numberOfParams, selectCriteria); }
@Override public String getSelectMultipleRowSql(int numberOfParams) { String selectCriteria = config.idColumnName() + " = cast(? as " + config.idColumnType() + ")"; return getSelectMultipleRowSql(numberOfParams, selectCriteria); }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = ?", getTableName(), config.timestampColumnName(), config.dataColumnName(), config.idColumnName()); } return updateRowSql; }
@Override public String getUpsertRowSql() { if (upsertRowSql == null) { upsertRowSql = String.format("%1$s ON CONFLICT (%2$s) DO UPDATE SET %3$s = EXCLUDED.%3$s, %4$s = EXCLUDED.%4$s", getInsertRowSql(), config.idColumnName(), config.dataColumnName(), config.timestampColumnName()); } return upsertRowSql; } }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = ?", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName()); } return updateRowSql; }
@Override public String getLoadNonExpiredAllRowsSql() { if (loadAllNonExpiredRowsSql == null) { loadAllNonExpiredRowsSql = String.format("SELECT %1$s, %2$s, %3$s FROM %4$s WHERE %3$s > ? OR %3$s < 0", config.dataColumnName(), config.idColumnName(), config.timestampColumnName(), getTableName()); } return loadAllNonExpiredRowsSql; }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = cast(? as %s)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName(), config.idColumnType()); } return updateRowSql; }
@Override public String getUpsertRowSql() { if (upsertRowSql == null) { if (metaData.isSegmentedDisabled()) { upsertRowSql = String.format("MERGE INTO %1$s (%2$s, %3$s, %4$s) KEY(%4$s) VALUES(?, ?, ?)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName()); } else { upsertRowSql = String.format("MERGE INTO %1$s (%2$s, %3$s, %4$s, %5$s) KEY(%4$s) VALUES(?, ?, ?, ?)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName(), config.segmentColumnName()); } } return upsertRowSql; }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = convert(%s,?)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName(), config.idColumnType()); } return updateRowSql; }
@Override public String getInsertRowSql() { if (insertRowSql == null) { if (metaData.isSegmentedDisabled()) { insertRowSql = String.format("INSERT INTO %s (%s,%s,%s) VALUES (?,?,?)", getTableName(), config.idColumnName(), config.timestampColumnName(), config.dataColumnName()); } else { insertRowSql = String.format("INSERT INTO %s (%s,%s,%s,%s) VALUES (?,?,?,?)", getTableName(), config.idColumnName(), config.timestampColumnName(), config.dataColumnName(), config.segmentColumnName()); } } return insertRowSql; }