src/server/plugins/postgresql/resource.h

Fri, 01 Nov 2024 12:25:52 +0100

author
Olaf Wintermann <olaf.wintermann@gmail.com>
date
Fri, 01 Nov 2024 12:25:52 +0100
changeset 562
69fc4ecc5f60
parent 299
f927ef81a12b
permissions
-rw-r--r--

fix pgext uses a wrong field number, if the column has the same name as a resource or property column

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright 2022 Olaf Wintermann. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   1. Redistributions of source code must retain the above copyright
 *      notice, this list of conditions and the following disclaimer.
 *
 *   2. Redistributions in binary form must reproduce the above copyright
 *      notice, this list of conditions and the following disclaimer in the
 *      documentation and/or other materials provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

#ifndef WS_PG_RESOURCE_H
#define WS_PG_RESOURCE_H

#include "../../public/nsapi.h"

#include <libpq-fe.h>

#ifdef __cplusplus
extern "C" {
#endif

typedef struct PgResourcePool {
    /*
     * ResourcePool parameters
     */
    pblock *param;
    
    /*
     * Cfg memorypool
     */
    pool_handle_t *pool;
    
    /*
     * ResourcePool name
     */
    const char *name;
    
    /*
     * connection string used for PQconnectdb
     */
    char *connection;
    
    
} PgResourcePool;

typedef struct PgResource {
    PGconn *connection;
} PgResource;
    
ResourceType* pg_get_resource_type(void);

void * pg_resourcepool_init(pool_handle_t *pool, const char *rpname, pblock *pb);
void   pg_resourcepool_destroy(PgResourcePool *pg);
void * pg_resourcepool_createresource(PgResourcePool *pg);
void   pg_resourcepool_freeresource(PgResourcePool *pg, PgResource *res);
int    pg_resourcepool_prepare(PgResourcePool *pg, PgResource *res);
int    pg_resourcepool_finish(PgResourcePool *pg, PgResource *res);
void * pg_resourcepool_getresourcedata(PgResource *res);

/*
 * checks if conn is a working connection and logs an error message if not
 * conn can be null (resulting in an error message)
 * if conn is not null but the status is not CONNECTION_OK,
 * conn will be destroyed
 */
int pg_check_connection(int loglevel, const char *rpname, PGconn *connection);

#ifdef __cplusplus
}
#endif

#endif /* WS_PG_RESOURCE_H */

mercurial