@Override
public Pipeable<U> jerialize(Recurser<T, U> recurser, DSL<T, U> dsl, Card domain)
throws JerializerException {
ObjectDSL<T, U> objectDSL = dsl.seeObject();
objectDSL.seeList(
"additionalName",
new RefImpl(recurser.seeCustomRefList(dsl, domain.getAdditionalNameRef(), String.class)));
objectDSL.seeCustom(
"adr", new RefImpl(recurser.seeCustom(dsl, domain.getAdrRef(), AddressContainer.class)));
objectDSL.seeString("bday", domain.getBdayRef());
objectDSL.seeCustom(
"email",
new RefImpl(
recurser.seeCustomMap(
dsl, domain.getEmailRef(), net.exathunk.jereal.base.core.JThing.class)));
objectDSL.seeString("familyName", domain.getFamilyNameRef());
objectDSL.seeString("fn", domain.getFnRef());
objectDSL.seeCustom(
"geo", new RefImpl(recurser.seeCustom(dsl, domain.getGeoRef(), GeoContainer.class)));
objectDSL.seeString("givenName", domain.getGivenNameRef());
objectDSL.seeList(
"honorificPrefix",
new RefImpl(recurser.seeCustomRefList(dsl, domain.getHonorificPrefixRef(), String.class)));
objectDSL.seeList(
"honorificSuffix",
new RefImpl(recurser.seeCustomRefList(dsl, domain.getHonorificSuffixRef(), String.class)));
objectDSL.seeString("logo", domain.getLogoRef());
objectDSL.seeString("nickname", domain.getNicknameRef());
objectDSL.seeCustom(
"org",
new RefImpl(
recurser.seeCustomMap(
dsl, domain.getOrgRef(), net.exathunk.jereal.base.core.JThing.class)));
objectDSL.seeString("photo", domain.getPhotoRef());
objectDSL.seeString("role", domain.getRoleRef());
objectDSL.seeString("sound", domain.getSoundRef());
objectDSL.seeCustom(
"tel",
new RefImpl(
recurser.seeCustomMap(
dsl, domain.getTelRef(), net.exathunk.jereal.base.core.JThing.class)));
objectDSL.seeString("title", domain.getTitleRef());
objectDSL.seeString("tz", domain.getTzRef());
objectDSL.seeString("url", domain.getUrlRef());
return objectDSL;
}
@Override
protected final int execute(ExecuteContext ctx, ExecuteListener listener) throws SQLException {
if (returning.isEmpty()) {
return super.execute(ctx, listener);
} else {
int result = 1;
ResultSet rs;
switch (ctx.configuration().dialect()) {
// SQLite can select _rowid_ after the insert
case SQLITE:
{
listener.executeStart(ctx);
result = ctx.statement().executeUpdate();
listener.executeEnd(ctx);
DSLContext create =
DSL.using(ctx.connection(), SQLDialect.SQLITE, ctx.configuration().settings());
returned =
create
.select(returning)
.from(getInto())
.where(rowid().equal(rowid().getDataType().convert(create.lastID())))
.fetchInto(getInto());
return result;
}
// Sybase can select @@identity after the insert
// TODO [#832] Fix this. This might be a driver issue. JDBC
// Generated keys don't work with jconn3, but they seem to work
// with jTDS (which is used for Sybase ASE integration)
case CUBRID:
case SYBASE:
{
listener.executeStart(ctx);
result = ctx.statement().executeUpdate();
listener.executeEnd(ctx);
selectReturning(ctx.configuration(), create(ctx.configuration()).lastID());
return result;
}
// Some dialects can only retrieve "identity" (AUTO_INCREMENT) values
// Additional values have to be fetched explicitly
// [#1260] TODO CUBRID supports this, but there's a JDBC bug
case ASE:
case DERBY:
case H2:
case INGRES:
case MYSQL:
case SQLSERVER:
{
listener.executeStart(ctx);
result = ctx.statement().executeUpdate();
listener.executeEnd(ctx);
rs = ctx.statement().getGeneratedKeys();
try {
List<Object> list = new ArrayList<Object>();
// Some JDBC drivers seem to illegally return null
// from getGeneratedKeys() sometimes
if (rs != null) {
while (rs.next()) {
list.add(rs.getObject(1));
}
}
selectReturning(ctx.configuration(), list.toArray());
return result;
} finally {
JDBCUtils.safeClose(rs);
}
}
// Firebird and Postgres can execute the INSERT .. RETURNING
// clause like a select clause. JDBC support is not implemented
// in the Postgres JDBC driver
case FIREBIRD:
case POSTGRES:
{
listener.executeStart(ctx);
rs = ctx.statement().executeQuery();
listener.executeEnd(ctx);
break;
}
// These dialects have full JDBC support
case DB2:
case HSQLDB:
case ORACLE:
default:
{
listener.executeStart(ctx);
result = ctx.statement().executeUpdate();
listener.executeEnd(ctx);
rs = ctx.statement().getGeneratedKeys();
break;
}
}
ExecuteContext ctx2 = new DefaultExecuteContext(ctx.configuration());
ExecuteListener listener2 = new ExecuteListeners(ctx2);
ctx2.resultSet(rs);
returned =
new CursorImpl<R>(ctx2, listener2, fieldArray(returning), null, true, false)
.fetch()
.into(getInto());
return result;
}
}
public BatchSingle(Configuration configuration, Query query) {
this.create = DSL.using(configuration);
this.configuration = configuration;
this.query = query;
this.allBindValues = new ArrayList<Object[]>();
}
BatchCRUD(Configuration configuration, Action action, TableRecord<?>[] records) {
this.create = DSL.using(configuration);
this.configuration = configuration;
this.action = action;
this.records = records;
}
@Override
public <A extends PushableContext<A, B>, B extends Questionable> Pipeable<B> acceptDSL(
DSL<A, B> dsl) {
return dsl.seeLong(this);
}