uk.co.blackpepper.support.spring.jdbc.jooq.SpringJdbcJooqUtils.java Source code

Introduction

Here is the source code for uk.co.blackpepper.support.spring.jdbc.jooq.SpringJdbcJooqUtils.java

Source

/*
 * Copyright 2014 Black Pepper Software
 *
 * 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 uk.co.blackpepper.support.spring.jdbc.jooq;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import org.jooq.Param;
import org.jooq.Query;
import org.springframework.jdbc.core.PreparedStatementCreator;

import com.google.common.annotations.VisibleForTesting;
import com.google.common.primitives.Ints;

import uk.co.blackpepper.support.spring.jdbc.JdbcUtils;

import static org.springframework.jdbc.core.StatementCreatorUtils.javaTypeToSqlParameterType;

public final class SpringJdbcJooqUtils {

    private SpringJdbcJooqUtils() {
        throw new AssertionError();
    }

    public static PreparedStatementCreator newPreparedStatementCreator(Query query) {
        int[] types = getSqlTypes(query.getParams().values());
        Object[] params = query.getBindValues().toArray();

        return JdbcUtils.newPreparedStatementCreator(query.getSQL(), types, params);
    }

    @VisibleForTesting
    static int[] getSqlTypes(Collection<? extends Param<?>> params) {
        List<Integer> types = new ArrayList<>(params.size());

        for (Param<?> param : params) {
            types.add(javaTypeToSqlParameterType(param.getType()));
        }

        return Ints.toArray(types);
    }
}