io.vertx.ext.jdbc.impl.actions.JDBCCallable Maven / Gradle / Ivy

Go to download
/*
 * Copyright (c) 2011-2014 The original author or authors
 * ------------------------------------------------------
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * and Apache License v2.0 which accompanies this distribution.
 *
 *     The Eclipse Public License is available at
 *     http://www.eclipse.org/legal/epl-v10.html
 *
 *     The Apache License v2.0 is available at
 *     http://www.opensource.org/licenses/apache2.0.php
 *
 * You may elect to redistribute this code under either of these licenses.
 */

package io.vertx.ext.jdbc.impl.actions;

import io.vertx.core.json.JsonArray;
import io.vertx.ext.jdbc.spi.JDBCColumnDescriptorProvider;
import io.vertx.ext.sql.SQLOptions;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.JDBCType;
import java.sql.ParameterMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collections;

/**
 * @author Paulo Lopes
 */
public class JDBCCallable extends AbstractJDBCAction {

  private final String sql;
  private final JsonArray in;
  private final JsonArray out;

  public JDBCCallable(JDBCStatementHelper helper, SQLOptions options, String sql, JsonArray in, JsonArray out) {
    super(helper, options);
    this.sql = sql;
    this.in = in;
    this.out = out;
  }

  @Override
  public io.vertx.ext.sql.ResultSet execute(Connection conn) throws SQLException {
    try (CallableStatement statement = conn.prepareCall(sql)) {
      // apply statement options
      applyStatementOptions(statement);

      CallableOutParams outParams = createOutParams(out);
      ParameterMetaData md = new CachedParameterMetaData(statement).putOutParams(outParams);
      JDBCColumnDescriptorProvider provider = JDBCColumnDescriptorProvider.fromParameterMetaData(md);
      fillStatement(statement, in, out, provider);

      boolean retResult = statement.execute();

      io.vertx.ext.sql.ResultSet resultSet = null;

      if (retResult) {
        io.vertx.ext.sql.ResultSet ref = null;
        // normal return only
        while (retResult) {
          try (ResultSet rs = statement.getResultSet()) {
            // 1st rs
            if (ref == null) {
              resultSet = asList(rs);
              ref = resultSet;
            } else {
              ref.setNext(asList(rs));
              ref = ref.getNext();
            }
            if (!outParams.isEmpty()) {
              // add the registered outputs
              ref.setOutput(convertOutputs(statement, provider));
            }
          }
          retResult = statement.getMoreResults();
        }
      } else {
        if (!outParams.isEmpty()) {
          // only outputs are available
          resultSet = new io.vertx.ext.sql.ResultSet(Collections.emptyList(), Collections.emptyList(), null).setOutput(convertOutputs(statement, provider));
        }
      }

      // no return
      return resultSet;
    }
  }

  private JsonArray convertOutputs(CallableStatement statement, JDBCColumnDescriptorProvider provider) throws SQLException {
    JsonArray result = new JsonArray();

    for (int i = 0; i < out.size(); i++) {
      Object var = out.getValue(i);

      if (var != null) {
        Object value = statement.getObject(i + 1);
        if (value == null) {
          result.addNull();
        } else if (value instanceof ResultSet) {
          result.add(asList((ResultSet) value).toJson());
        } else {
          result.add(helper.getDecoder().parse(statement, i + 1, provider));
        }
      } else {
        result.addNull();
      }
    }

    return result;
  }

  private static CallableOutParams createOutParams(JsonArray out) {
    CallableOutParams params = CallableOutParams.create();
    if (out != null) {
      for (int i = 0; i < out.size(); i++) {
        final Object param = out.getValue(i);
        if (param instanceof Integer) {
          params.put(i + 1, (Integer) param);
        } else if (param instanceof JDBCType) {
          params.put(i + 1, (JDBCType) param);
        } else if (param != null) {
          params.put(i + 1, param.toString());
        }
      }
    }

    return params;
  }
}