io.vertx.pgclient

Interface PgConnection

All Superinterfaces:

SqlClient, SqlConnection

public interface PgConnection
extends SqlConnection

A connection to Postgres.

Author:

Julien Viet, Emad Alblueshi

Method Summary

Modifier and Type	Method and Description
PgConnection	cancelRequest(Handler<AsyncResult<Void>> handler) Send a request cancellation message to tell the server to cancel processing request in this connection.
PgConnection	closeHandler(Handler<Void> handler) Set an handler called when the connection is closed.
static void	connect(Vertx vertx, Handler<AsyncResult<PgConnection>> handler) Like connect(Vertx, PgConnectOptions, Handler) with options build from the environment variables.
static void	connect(Vertx vertx, PgConnectOptions options, Handler<AsyncResult<PgConnection>> handler) Connects to the database and returns the connection if that succeeds.
static void	connect(Vertx vertx, String connectionUri, Handler<AsyncResult<PgConnection>> handler) Like connect(Vertx, PgConnectOptions, Handler) with options build from connectionUri.
PgConnection	exceptionHandler(Handler<Throwable> handler) Set an handler called with connection errors.
PgConnection	notificationHandler(Handler<PgNotification> handler) Set an handler called when the connection receives notification on a channel.
PgConnection	prepare(String sql, Handler<AsyncResult<PreparedStatement>> handler) Create a prepared query.
int	processId()
int	secretKey()

Methods inherited from interface io.vertx.sqlclient.SqlConnection

begin, close, databaseMetadata, isSSL

Methods inherited from interface io.vertx.sqlclient.SqlClient

preparedQuery, query

Method Detail

connect

static void connect(Vertx vertx,
                    PgConnectOptions options,
                    Handler<AsyncResult<PgConnection>> handler)

Connects to the database and returns the connection if that succeeds.

The connection interracts directly with the database is not a proxy, so closing the connection will close the underlying connection to the database.

Parameters:

vertx - the vertx instance

options - the connect options

handler - the handler called with the connection or the failure

connect

static void connect(Vertx vertx,
                    Handler<AsyncResult<PgConnection>> handler)

Like connect(Vertx, PgConnectOptions, Handler) with options build from the environment variables.

connect

static void connect(Vertx vertx,
                    String connectionUri,
                    Handler<AsyncResult<PgConnection>> handler)

Like connect(Vertx, PgConnectOptions, Handler) with options build from connectionUri.

notificationHandler

PgConnection notificationHandler(Handler<PgNotification> handler)

Set an handler called when the connection receives notification on a channel.

The handler is called with the PgNotification and has access to the channel name and the notification payload.

Parameters:

handler - the handler

Returns:

the transaction instance

cancelRequest

PgConnection cancelRequest(Handler<AsyncResult<Void>> handler)

Send a request cancellation message to tell the server to cancel processing request in this connection.
Note: Use this with caution because the cancellation signal may or may not have any effect.

Parameters:

handler - the handler notified if cancelling request is sent

Returns:

a reference to this, so the API can be used fluently

processId

int processId()

Returns:

The process ID of the target backend

secretKey

int secretKey()

Returns:

The secret key for the target backend

prepare

PgConnection prepare(String sql,
                     Handler<AsyncResult<PreparedStatement>> handler)

Create a prepared query.

Specified by:

prepare in interface SqlConnection

Parameters:

sql - the sql

handler - the handler notified with the prepared query asynchronously

exceptionHandler

PgConnection exceptionHandler(Handler<Throwable> handler)

Set an handler called with connection errors.

Specified by:

exceptionHandler in interface SqlConnection

Parameters:

handler - the handler

Returns:

a reference to this, so the API can be used fluently

closeHandler

PgConnection closeHandler(Handler<Void> handler)

Description copied from interface: SqlConnection

Set an handler called when the connection is closed.

Specified by:

closeHandler in interface SqlConnection

Parameters:

handler - the handler

Returns:

a reference to this, so the API can be used fluently