/*
 * 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.reactiverse.pgclient;

import io.vertx.codegen.annotations.Fluent;
import io.vertx.codegen.annotations.GenIgnore;
import io.vertx.codegen.annotations.VertxGen;
import io.vertx.core.*;

import java.util.List;
import java.util.stream.Collector;

A connection to Postgres.
Author:
Julien Viet, Emad Alblueshi/**
 * A connection to Postgres.
 *
 * @author <a href="mailto:julien@julienviet.com">Julien Viet</a>
 * @author <a href="mailto:emad.albloushi@gmail.com">Emad Alblueshi</a>
 */
@VertxGen
public interface PgConnection extends PgClient {

  
Create a prepared query.
Params:
sql – the sql
handler – the handler notified with the prepared query asynchronously/**
   * Create a prepared query.
   *
   * @param sql the sql
   * @param handler the handler notified with the prepared query asynchronously
   */
  @Fluent
  PgConnection prepare(String sql, Handler<AsyncResult<PgPreparedQuery>> handler);

  
Set an handler called with connection errors.
Params:
handler – the handler
Returns:
a reference to this, so the API can be used fluently/**
   * Set an handler called with connection errors.
   *
   * @param handler the handler
   * @return a reference to this, so the API can be used fluently
   */
  @Fluent
  PgConnection exceptionHandler(Handler<Throwable> handler);

  
Set an handler called when the connection is closed.
Params:
handler – the handler
Returns:
a reference to this, so the API can be used fluently/**
   * Set an handler called when the connection is closed.
   *
   * @param handler the handler
   * @return a reference to this, so the API can be used fluently
   */
  @Fluent
  PgConnection closeHandler(Handler<Void> handler);

  
Begin a transaction and returns a PgTransaction for controlling and tracking this transaction. 

When the connection is explicitely closed, any inflight transaction is rollbacked.
Returns:
the transaction instance/**
   * Begin a transaction and returns a {@link PgTransaction} for controlling and tracking
   * this transaction.
   * <p/>
   * When the connection is explicitely closed, any inflight transaction is rollbacked.
   *
   * @return the transaction instance
   */
  PgTransaction begin();

  
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. 
Params:
handler – the handler
Returns:
the transaction instance/**
   * Set an handler called when the connection receives notification on a channel.
   * <p/>
   * The handler is called with the {@link PgNotification} and has access to the channel name
   * and the notification payload.
   *
   * @param handler the handler
   * @return the transaction instance
   */
  @Fluent
  PgConnection notificationHandler(Handler<PgNotification> handler);

  
Returns:
The process ID of the target backend/**
   * @return The process ID of the target backend
   */
  int processId();

  
Returns:
The secret key for the target backend/**
   * @return The secret key for the target backend
   */
  int secretKey();

  
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.
Params:
handler – the handler notified if cancelling request is sent
Returns:
a reference to this, so the API can be used fluently/**
   * Send a request cancellation message to tell the server to cancel processing request in this connection.
   * <br>Note: Use this with caution because the cancellation signal may or may not have any effect.
   *
   * @param handler the handler notified if cancelling request is sent
   * @return a reference to this, so the API can be used fluently
   */
  PgConnection cancelRequest(Handler<AsyncResult<Void>> handler);

  
Returns:
whether the connection uses SSL/**
   * @return whether the connection uses SSL
   */
  boolean isSSL();

  
Close the current connection after all the pending commands have been processed.
/**
   * Close the current connection after all the pending commands have been processed.
   */
  void close();

  @Override
  PgConnection preparedQuery(String sql, Handler<AsyncResult<PgRowSet>> handler);

  @Override
  @GenIgnore
  <R> PgConnection preparedQuery(String sql, Collector<Row, ?, R> collector, Handler<AsyncResult<PgResult<R>>> handler);

  @Override
  PgConnection query(String sql, Handler<AsyncResult<PgRowSet>> handler);

  @Override
  @GenIgnore
  <R> PgConnection query(String sql, Collector<Row, ?, R> collector, Handler<AsyncResult<PgResult<R>>> handler);

  @Override
  PgConnection preparedQuery(String sql, Tuple arguments, Handler<AsyncResult<PgRowSet>> handler);

  @Override
  @GenIgnore
  <R> PgConnection preparedQuery(String sql, Tuple arguments, Collector<Row, ?, R> collector, Handler<AsyncResult<PgResult<R>>> handler);

  @Override
  PgConnection preparedBatch(String sql, List<Tuple> batch, Handler<AsyncResult<PgRowSet>> handler);

  @Override
  @GenIgnore
  <R> PgConnection preparedBatch(String sql, List<Tuple> batch, Collector<Row, ?, R> collector, Handler<AsyncResult<PgResult<R>>> handler);
}