/*
 * Copyright 2016 requery.io
 *
 * 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.
 */

package io.requery.sql;

import io.requery.query.BaseScalar;
import io.requery.query.Scalar;
import io.requery.query.element.QueryElement;
import io.requery.sql.gen.DefaultOutput;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * Extends {@link UpdateOperation} specifically for binding to an entity, skipping the query
 * parameters to avoid boxing overhead.
 */
abstract class EntityUpdateOperation extends UpdateOperation {

    EntityUpdateOperation(RuntimeConfiguration configuration, GeneratedResultReader resultReader) {
        super(configuration, resultReader);
    }

    @Override
    public Scalar<Integer> evaluate(final QueryElement<Scalar<Integer>> query) {
        return new BaseScalar<Integer>(configuration.getWriteExecutor()) {
            @Override
            public Integer evaluate() {
                // doesn't use the query params, just maps to the parameterBinder callback
                QueryBuilder qb = new QueryBuilder(configuration.getQueryBuilderOptions());
                DefaultOutput output =
                new DefaultOutput(configuration, query, qb, null, false);
                String sql = output.toSql();
                int result;
                try (Connection connection = configuration.getConnection()) {
                    StatementListener listener = configuration.getStatementListener();
                    try (PreparedStatement statement = prepare(sql, connection)) {
                        bindParameters(statement);
                        listener.beforeExecuteUpdate(statement, sql, null);
                        result = statement.executeUpdate();
                        listener.afterExecuteUpdate(statement, result);
                        readGeneratedKeys(0, statement);
                    }
                } catch (SQLException e) {
                    throw new StatementExecutionException(e, sql);
                }
                return result;
            }
        };
    }

    public abstract int bindParameters(PreparedStatement statement) throws SQLException;
}