I'm looking for a way to call the JDBC function
timestampadd<http://db.apache.org/derby/docs/10.2/ref/rrefjdbc88908.html> in
my queries built with jOOQ. The typical output SQL should look like:
{fn timestampadd(SQL_TSI_YEAR, 5, CUSTOMER.BIRTH)}
I implemented my solution by extending CustomField:
public class JdbcTimestampAddField extends CustomField<Timestamp> {
private final String interval;
private final Field<Integer> count;
private final Field<Timestamp> timestamp;
public JdbcTimestampAddField(String interval, Field<Integer> count,
Field<?> timestamp) {
super("timestampadd", SQLDataType.TIMESTAMP);
this.interval = interval;
this.timestamp = timestamp.cast(SQLDataType.TIMESTAMP);
this.count = count;
}
public JdbcTimestampAddField(String interval, Field<Integer> count, Date
timestamp) {
this(interval, count, val(timestamp));
}
public JdbcTimestampAddField(String interval, int count, Field<?>
timestamp) {
this(interval, val(count), timestamp);
}
public JdbcTimestampAddField(String interval, int count, Date timestamp) {
this(interval, count, val(timestamp));
}
@Override
public void toSQL(RenderContext context) {
context.sql("{fn TIMESTAMPADD(" + interval + ", ");
context.sql(context.render(count));
context.sql(", ");
context.sql(context.render(timestamp));
context.sql(")}");
}
@Override
public void bind(BindContext context) throws DataAccessException {
context.visit(count);
context.visit(timestamp);
}
}
and building my own DerbyDsl namespace:
public class DerbyDsl {
public static Field<Timestamp> timestampAdd(Field<Integer> yearsCount,
Field<Integer> monthsCount, Field<Integer> daysCount, Field<?> timestamp) {
return timestampAddDays(daysCount, timestampAddMonths(monthsCount,
timestampAddYears(yearsCount, timestamp)));
}
public static Field<Timestamp> timestampAdd(int yearsCount, int
monthsCount, int daysCount, Field<?> timestamp) {
return timestampAdd(val(yearsCount), val(monthsCount), val(daysCount),
timestamp);
}
public static Field<Timestamp> timestampAddYears(Field<Integer> count,
Field<?> timestamp) {
return new JdbcTimestampAddField("SQL_TSI_YEAR", count, timestamp);
}
public static Field<Timestamp> timestampAddMonths(Field<Integer> count,
Field<?> timestamp) {
return new JdbcTimestampAddField("SQL_TSI_MONTH", count, timestamp);
}
public static Field<Timestamp> timestampAddDays(Field<Integer> count,
Field<?> timestamp) {
return new JdbcTimestampAddField("SQL_TSI_DAY", count, timestamp);
}}
Is there a better way to solve this problem? Did I make any mistake in my
implementation that pass my tests but are waiting in the shadows to screw
everything up?
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
