src/modules/db_postgres/km_pg_con.h
0761b7c2
 /*
  * Copyright (C) 2003 August.Net Services, LLC
e7d59684
  * Copyright (C) 2008 1&1 Internet AG
0761b7c2
  *
2881cb88
  * This file is part of Kamailio, a free SIP server.
0761b7c2
  *
2881cb88
  * Kamailio is free software; you can redistribute it and/or modify
0761b7c2
  * it under the terms of the GNU General Public License as published by
  * the Free Software Foundation; either version 2 of the License, or
  * (at your option) any later version
  *
2881cb88
  * Kamailio is distributed in the hope that it will be useful,
0761b7c2
  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  * GNU General Public License for more details.
  *
  * You should have received a copy of the GNU General Public License 
  * along with this program; if not, write to the Free Software 
9e1ff448
  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
0761b7c2
  *
  */
 
e7d59684
 /*! \file
  *  \brief DB_POSTGRES :: Core
  *  \ingroup db_postgres
  *  Module: \ref db_mysql
  */
0761b7c2
 
d5d63560
 #ifndef KM_PG_CON_H
 #define KM_PG_CON_H
0761b7c2
 
a7bac3b9
 #include "../../lib/srdb1/db_pool.h"
 #include "../../lib/srdb1/db_id.h"
0761b7c2
 
 #include <time.h>
 #include <libpq-fe.h>
 
e7d59684
 
 /*! Postgres specific connection data */
60f177bf
 struct pg_con
 {
 	struct db_id *id;	  /*!< Connection identifier */
 	unsigned int ref;	  /*!< Reference count */
 	struct pool_con *next; /*!< Next connection in the pool */
0761b7c2
 
60f177bf
 	int connected; /*!< connection status */
 	char *sqlurl; /*!< the url we are connected to, all connection memory parents from this */
 	PGconn *con;	   /*!< this is the postgres connection */
 	PGresult *res;	 /*!< this is the current result */
 	char **row;		   /*!< Actual row in the result */
 	time_t timestamp;  /*!< Timestamp of last query */
 	int affected_rows; /*!< Number of rows affected by the last statement */
 	int transaction; /*!< indicates whether a multi-query transaction is currently open */
0761b7c2
 };
 
60f177bf
 #define CON_SQLURL(db_con) (((struct pg_con *)((db_con)->tail))->sqlurl)
 #define CON_RESULT(db_con) (((struct pg_con *)((db_con)->tail))->res)
 #define CON_CONNECTION(db_con) (((struct pg_con *)((db_con)->tail))->con)
 #define CON_CONNECTED(db_con) (((struct pg_con *)((db_con)->tail))->connected)
 #define CON_ROW(db_con) (((struct pg_con *)((db_con)->tail))->row)
 #define CON_TIMESTAMP(db_con) (((struct pg_con *)((db_con)->tail))->timestamp)
 #define CON_ID(db_con) (((struct pg_con *)((db_con)->tail))->id)
 #define CON_AFFECTED(db_con) \
 	(((struct pg_con *)((db_con)->tail))->affected_rows)
 #define CON_TRANSACTION(db_con) \
 	(((struct pg_con *)((db_con)->tail))->transaction)
0761b7c2
 
 /*
  * Create a new connection structure,
  * open the PostgreSQL connection and set reference count to 1
  */
60f177bf
 struct pg_con *db_postgres_new_connection(struct db_id *id);
0761b7c2
 
 /*
  * Close the connection and release memory
  */
60f177bf
 void db_postgres_free_connection(struct pool_con *con);
0761b7c2
 
d5d63560
 #endif /* KM_PG_CON_H */