All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.jooq.impl.TableRecordImpl Maven / Gradle / Ivy

The newest version!
/*
 * Copyright (c) 2009-2016, Data Geekery GmbH (http://www.datageekery.com)
 * All rights reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Other licenses:
 * -----------------------------------------------------------------------------
 * Commercial licenses for this work are available. These replace the above
 * ASL 2.0 and offer limited warranties, support, maintenance, and commercial
 * database integrations.
 *
 * For more information, please visit: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */
package org.jooq.impl;

import static java.lang.Boolean.TRUE;
import static java.util.Arrays.asList;
import static org.jooq.SQLDialect.DERBY;
import static org.jooq.SQLDialect.H2;
import static org.jooq.SQLDialect.MARIADB;
import static org.jooq.SQLDialect.MYSQL;
// ...
import static org.jooq.impl.RecordDelegate.delegate;
import static org.jooq.impl.RecordDelegate.RecordLifecycleType.INSERT;
import static org.jooq.impl.Tools.EMPTY_FIELD;
import static org.jooq.impl.Tools.indexOrFail;
import static org.jooq.impl.Tools.DataKey.DATA_OMIT_RETURNING_CLAUSE;

import java.math.BigInteger;
import java.sql.Timestamp;
import java.util.Arrays;
import java.util.Collection;
import java.util.LinkedHashSet;

import org.jooq.Converter;
import org.jooq.DSLContext;
import org.jooq.Field;
import org.jooq.ForeignKey;
import org.jooq.Identity;
import org.jooq.InsertQuery;
import org.jooq.Record;
import org.jooq.Row;
import org.jooq.StoreQuery;
import org.jooq.Table;
import org.jooq.TableField;
import org.jooq.TableRecord;
import org.jooq.UniqueKey;
import org.jooq.UpdatableRecord;
import org.jooq.tools.JooqLogger;

/**
 * A record implementation for a record originating from a single table
 * 

* This type is for JOOQ INTERNAL USE only. Do not reference directly * * @author Lukas Eder */ public class TableRecordImpl> extends AbstractRecord implements TableRecord { /** * Generated UID */ private static final long serialVersionUID = 3216746611562261641L; private static final JooqLogger log = JooqLogger.getLogger(TableRecordImpl.class); private final Table table; public TableRecordImpl(Table table) { super(table.fields()); this.table = table; } @SuppressWarnings("unchecked") @Override public final R with(Field field, T value) { return (R) super.with(field, value); } @SuppressWarnings("unchecked") @Override public final R with(Field field, U value, Converter converter) { return (R) super.with(field, value, converter); } @Override public final Table getTable() { return table; } /* * Subclasses may override this method */ @Override public Row fieldsRow() { return fields; } /* * Subclasses may override this method */ @SuppressWarnings({ "unchecked", "rawtypes" }) @Override public Row valuesRow() { return new RowImpl(Tools.fields(intoArray(), fields.fields.fields())); } @SuppressWarnings("unchecked") @Override public final R original() { return (R) super.original(); } @SuppressWarnings("unchecked") @Override public final > O fetchParent(ForeignKey key) { return key.fetchParent((R) this); } @Override public final int insert() { return insert(fields.fields.fields); } @Override public final int insert(Field... storeFields) { return storeInsert(storeFields); } @Override public final int insert(Collection> storeFields) { return insert(storeFields.toArray(EMPTY_FIELD)); } final int storeInsert(final Field[] storeFields) { final int[] result = new int[1]; delegate(configuration(), (Record) this, INSERT) .operate(new RecordOperation() { @Override public Record operate(Record record) throws RuntimeException { result[0] = storeInsert0(storeFields); return record; } }); return result[0]; } final int storeInsert0(Field[] storeFields) { DSLContext create = create(); InsertQuery insert = create.insertQuery(getTable()); addChangedValues(storeFields, insert); // Don't store records if no value was set by client code if (!insert.isExecutable()) { if (log.isDebugEnabled()) log.debug("Query is not executable", insert); return 0; } // [#1596] Set timestamp and/or version columns to appropriate values BigInteger version = addRecordVersion(insert); Timestamp timestamp = addRecordTimestamp(insert); // [#814] Refresh identity and/or main unique key values // [#1002] Consider also identity columns of non-updatable records // [#1537] Avoid refreshing identity columns on batch inserts Collection> key = setReturningIfNeeded(insert); int result = insert.execute(); if (result > 0) { for (Field storeField : storeFields) changed(storeField, false); // [#1596] If insert was successful, update timestamp and/or version columns setRecordVersionAndTimestamp(version, timestamp); // [#1859] If an insert was successful try fetching the generated values. getReturningIfNeeded(insert, key); fetched = true; } return result; } final void getReturningIfNeeded(StoreQuery query, Collection> key) { if (key != null && !key.isEmpty()) { R record = query.getReturnedRecord(); if (record != null) { for (Field field : key) { int index = indexOrFail(fieldsRow(), field); Object value = record.get(field); values[index] = value; originals[index] = value; } } // [#1859] In some databases, not all fields can be fetched via getGeneratedKeys() if (asList(DERBY, H2, MARIADB, MYSQL).contains(configuration().family()) && this instanceof UpdatableRecord) ((UpdatableRecord) this).refresh(key.toArray(EMPTY_FIELD)); } } final Collection> setReturningIfNeeded(StoreQuery query) { Collection> key = null; if (configuration() != null) { if (!TRUE.equals(configuration().data(DATA_OMIT_RETURNING_CLAUSE))) { // [#1859] Return also non-key columns if (TRUE.equals(configuration().settings().isReturnAllOnUpdatableRecord())) key = Arrays.asList(fields()); else key = getReturning(); query.setReturning(key); } } return key; } /** * Set a generated version and timestamp value onto this record after * successfully storing the record. */ final void setRecordVersionAndTimestamp(BigInteger version, Timestamp timestamp) { if (version != null) { TableField field = getTable().getRecordVersion(); int fieldIndex = indexOrFail(fieldsRow(), field); Object value = field.getDataType().convert(version); values[fieldIndex] = value; originals[fieldIndex] = value; changed.clear(fieldIndex); } if (timestamp != null) { TableField field = getTable().getRecordTimestamp(); int fieldIndex = indexOrFail(fieldsRow(), field); Object value = field.getDataType().convert(timestamp); values[fieldIndex] = value; originals[fieldIndex] = value; changed.clear(fieldIndex); } } /** * Set all changed values of this record to a store query */ final void addChangedValues(Field[] storeFields, StoreQuery query) { Fields f = new Fields(storeFields); for (Field field : fields.fields.fields) { if (changed(field) && f.field(field) != null) { addValue(query, field); } } } /** * Extracted method to ensure generic type safety. */ final void addValue(StoreQuery store, Field field, Object value) { store.addValue(field, Tools.field(value, field)); } /** * Extracted method to ensure generic type safety. */ final void addValue(StoreQuery store, Field field) { addValue(store, field, get(field)); } /** * Set an updated timestamp value to a store query */ final Timestamp addRecordTimestamp(StoreQuery store) { Timestamp result = null; if (isTimestampOrVersionAvailable()) { TableField timestamp = getTable().getRecordTimestamp(); if (timestamp != null) { // Use Timestamp locally, to provide maximum precision result = new Timestamp(System.currentTimeMillis()); addValue(store, timestamp, result); } } return result; } /** * Set an updated version value to a store query */ final BigInteger addRecordVersion(StoreQuery store) { BigInteger result = null; if (isTimestampOrVersionAvailable()) { TableField version = getTable().getRecordVersion(); if (version != null) { Object value = get(version); // Use BigInteger locally to avoid arithmetic overflows if (value == null) { result = BigInteger.ONE; } else { result = new BigInteger(value.toString()).add(BigInteger.ONE); } addValue(store, version, result); } } return result; } final boolean isTimestampOrVersionAvailable() { return getTable().getRecordTimestamp() != null || getTable().getRecordVersion() != null; } final Collection> getReturning() { Collection> result = new LinkedHashSet>(); Identity identity = getTable().getIdentity(); if (identity != null) result.add(identity.getField()); UniqueKey key = getPrimaryKey(); if (key != null) result.addAll(key.getFields()); return result; } }





© 2015 - 2024 Weber Informatics LLC | Privacy Policy