/*
 * Copyright (C) 2017 Julien Viet
 *
 * 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.vertx.sqlclient.impl;

import io.vertx.sqlclient.PoolOptions;
import io.vertx.sqlclient.Pool;
import io.vertx.sqlclient.SqlConnection;
import io.vertx.sqlclient.Transaction;
import io.vertx.sqlclient.impl.command.CommandBase;
import io.vertx.sqlclient.impl.command.CommandResponse;
import io.vertx.sqlclient.impl.command.CommandScheduler;
import io.vertx.core.AsyncResult;
import io.vertx.core.Context;
import io.vertx.core.Future;
import io.vertx.core.Handler;
import io.vertx.core.Vertx;
import io.vertx.core.VertxException;

Todo : - handle timeout when acquiring a connection - for per statement pooling, have several physical connection and use the less busy one to avoid head of line blocking effect
Author:Julien Viet, Emad Alblueshi
/** * Todo : * * - handle timeout when acquiring a connection * - for per statement pooling, have several physical connection and use the less busy one to avoid head of line blocking effect * * @author <a href="mailto:julien@julienviet.com">Julien Viet</a> * @author <a href="mailto:emad.albloushi@gmail.com">Emad Alblueshi</a> */
public abstract class PoolBase<P extends PoolBase<P>> extends SqlClientBase<P> implements Pool { private final Context context; private final ConnectionPool pool; private final boolean closeVertx; public PoolBase(Context context, boolean closeVertx, PoolOptions options) { int maxSize = options.getMaxSize(); if (maxSize < 1) { throw new IllegalArgumentException("Pool max size must be > 0"); } this.context = context; this.pool = new ConnectionPool(this::connect, maxSize, options.getMaxWaitQueueSize()); this.closeVertx = closeVertx; } public abstract void connect(Handler<AsyncResult<Connection>> completionHandler); @Override public void getConnection(Handler<AsyncResult<SqlConnection>> handler) { Context current = Vertx.currentContext(); if (current == context) { pool.acquire(new ConnectionWaiter(handler)); } else { context.runOnContext(v -> getConnection(handler)); } } @Override public void begin(Handler<AsyncResult<Transaction>> handler) { getConnection(ar -> { if (ar.succeeded()) { SqlConnectionImpl conn = (SqlConnectionImpl) ar.result(); Transaction tx = conn.begin(true); handler.handle(Future.succeededFuture(tx)); } else { handler.handle(Future.failedFuture(ar.cause())); } }); } @Override public <R> void schedule(CommandBase<R> cmd, Handler<? super CommandResponse<R>> handler) { Context current = Vertx.currentContext(); if (current == context) { pool.acquire(new CommandWaiter() { // SHOULD BE IT !!!!! @Override protected void onSuccess(Connection conn) { cmd.handler = ar -> { ar.scheduler = new CommandScheduler() { @Override public <R> void schedule(CommandBase<R> cmd, Handler<? super CommandResponse<R>> handler) { cmd.handler = cr -> { cr.scheduler = this; handler.handle(cr); }; conn.schedule(cmd); } }; handler.handle(ar); }; conn.schedule(cmd); conn.close(this); } @Override protected void onFailure(Throwable cause) { cmd.handler = handler; cmd.fail(cause); } }); } else { context.runOnContext(v -> schedule(cmd, handler)); } } private abstract class CommandWaiter implements Connection.Holder, Handler<AsyncResult<Connection>> { protected abstract void onSuccess(Connection conn); protected abstract void onFailure(Throwable cause); @Override public void handleNotification(int processId, String channel, String payload) { // What should we do ? } @Override public void handle(AsyncResult<Connection> ar) { if (ar.succeeded()) { Connection conn = ar.result(); conn.init(this); onSuccess(conn); } else { onFailure(ar.cause()); } } @Override public void handleClosed() { } @Override public void handleException(Throwable err) { } } protected abstract SqlConnectionImpl wrap(Context context, Connection conn); private class ConnectionWaiter implements Handler<AsyncResult<Connection>> { private final Handler<AsyncResult<SqlConnection>> handler; private ConnectionWaiter(Handler<AsyncResult<SqlConnection>> handler) { this.handler = handler; } @Override public void handle(AsyncResult<Connection> ar) { if (ar.succeeded()) { Connection conn = ar.result(); SqlConnectionImpl holder = wrap(context, conn); conn.init(holder); handler.handle(Future.succeededFuture(holder)); } else { handler.handle(Future.failedFuture(ar.cause())); } } } protected void doClose() { pool.close(); if (closeVertx) { context.owner().close(); } } @Override public void close() { Context current = Vertx.currentContext(); if (current == context) { doClose(); } else { context.runOnContext(v -> doClose()); } } }