ResultQuery<Record> query; Cursor<Record> cursor = query.fetchLazy(fetchSize); cursor.fetchOne(new RecordMapper<Record, Map<String, Object>>() { @Override public Map<String, Object> map(final Record record) { for (Field<?> field : record.fields()) { record.getValue(field, converter); if ("date".equals(field.getDataType().getTypeName())) { resultSet resultSet = cursor.resultSet(); try { Timestamp ts = resultSet.getTimestamp(field.getName()); } catch (SQLException e) { // ...... } } } } );
@Override public final RecordType<?> recordType() { Record record = record(); return record != null ? new Fields<Record>(record.fields()) : null; }
@Override public String toString() { if (records != null && records.length > 0) { Result<Record> result = DSL.using(configuration).newResult(records[0].fields()); result.addAll(Arrays.asList(records)); return result.toString(); } else { return "No Records"; } } }
public <E> E mapperEntityEx(Record r, Class<E> clazz) { try { E entity = clazz.newInstance(); Map<String,Method> entityMethodMap = getSetMethods(clazz); Arrays.asList(r.fields()).forEach(f -> { String name = f.getName(); Object value = r.getValue(name); if (value != null) //opt: when the field's value is null , don't do the set operator, setObjectValue(name, value, entity, entityMethodMap); }); return entity; } catch (InstantiationException | IllegalAccessException e) { e.printStackTrace(); } return null; }
for (Field<?> field : record.fields()) { TableMapping mapping = fieldsMapping.get(field.getName()); if (mapping == null) {
@Override public final Condition and(Record record) { RowN r = new RowImpl(Tools.fields(record.intoArray(), record.fields())); return and(r); }
/** * Wrap a record in a result. */ static final Result<?> result(Record data) { Result<Record> result = using(data.configuration()).newResult(data.fields()); result.add(data); return result; }
@Override public final Condition and(Record record) { RowN r = new RowImpl(Utils.fields(record.intoArray(), record.fields())); return and(r); }
/** * Use a previously obtained set of records as a new Table */ @Support public static <R extends Record> Table<R> table(R... records) { if (records == null || records.length == 0) return (Table<R>) new Dual(); Result<R> result = new ResultImpl(configuration(records[0]), records[0].fields()); result.addAll(Arrays.asList(records)); return table(result); }
for (Field<?> targetField : target.fields()) { Field<?> sourceField = field(targetField);
for (Field<?> targetField : target.fields()) { Field<?> sourceField = field(targetField);