xadrv/postgres/pq.c

0001 /**
0002  * @brief Postgres PQ Connection
0003  *
0004  * @file pq.c
0005  */
0006 /* -----------------------------------------------------------------------------
0007  * Enduro/X Middleware Platform for Distributed Transaction Processing
0008  * Copyright (C) 2009-2016, ATR Baltic, Ltd. All Rights Reserved.
0009  * Copyright (C) 2017-2023, Mavimax, Ltd. All Rights Reserved.
0010  * This software is released under one of the following licenses:
0011  * AGPL (with Java and Go exceptions) or Mavimax's license for commercial use.
0012  * See LICENSE file for full text.
0013  * -----------------------------------------------------------------------------
0014  * AGPL license:
0015  *
0016  * This program is free software; you can redistribute it and/or modify it under
0017  * the terms of the GNU Affero General Public License, version 3 as published
0018  * by the Free Software Foundation;
0019  *
0020  * This program is distributed in the hope that it will be useful, but WITHOUT ANY
0021  * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
0022  * PARTICULAR PURPOSE. See the GNU Affero General Public License, version 3
0023  * for more details.
0024  *
0025  * You should have received a copy of the GNU Affero General Public License along
0026  * with this program; if not, write to the Free Software Foundation, Inc.,
0027  * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
0028  *
0029  * -----------------------------------------------------------------------------
0030  * A commercial use license is available from Mavimax, Ltd
0031  * contact@mavimax.com
0032  * -----------------------------------------------------------------------------
0033  */
0034 #include <string.h>
0035 #include <stdio.h>
0036 #include <stdlib.h>
0037
0038 #include <ndrstandard.h>
0039 #include <ndebug.h>
0040 #include <atmi.h>
0041
0042 #include "utlist.h"
0043
0044 #include <xa.h>
0045 #include <pgxa.h>
0046 #include <thlock.h>
0047 /*---------------------------Externs------------------------------------*/
0048 /*---------------------------Macros-------------------------------------*/
0049 /*---------------------------Enums--------------------------------------*/
0050 /*---------------------------Typedefs-----------------------------------*/
0051 /*---------------------------Globals------------------------------------*/
0052 /*---------------------------Statics------------------------------------*/
0053 /*---------------------------Prototypes---------------------------------*/
0054
0055
0056 /**
0057  * Perform connect.
0058  * Uses only URL, format user=%s password=%s dbname=%s hostaddr=%s port=%d
0059  * @param conndata parsed connection data
0060  * @param connname connection name
0061  * @return NULL (connection failed) or connection object
0062  */
0063 expublic PGconn * ndrx_pg_connect(ndrx_pgconnect_t *conndata, char *connname)
0064 {
0065     PGconn *ret = NULL;
0066
0067     NDRX_LOG(log_debug, "Establishing PQ connection: [%s]", conndata);
0068
0069     ret = PQconnectdb(conndata->url);
0070
0071     if (PQstatus(ret) != CONNECTION_OK)
0072     {
0073         NDRX_LOG(log_error, "ERROR: Connection to database failed: %s",
0074                 PQerrorMessage(ret));
0075         PQfinish(ret);
0076         ret = NULL;
0077     }
0078
0079 out:
0080
0081     return ret;
0082 }
0083
0084 /**
0085  * disconnect from postgres
0086  * @param conn current connection object
0087  * @param connname connection name
0088  * @return EXSUCCEED/EXFAIL
0089  */
0090 expublic int ndrx_pg_disconnect(PGconn *conn, char *connname)
0091 {
0092     int ret = EXSUCCEED;
0093
0094     NDRX_LOG(log_debug, "Closing PQ connection: [%s]", connname);
0095
0096     PQfinish(conn);
0097
0098 out:
0099     return ret;
0100 }
0101
0102
0103 /* vim: set ts=4 sw=4 et smartindent: */