pgsqlconnection.cxx

来自「vovida的软交换」· CXX 代码 · 共 162 行

/* ====================================================================
 * The Vovida Software License, Version 1.0 
 * 
 * Copyright (c) 2000 Vovida Networks, Inc.  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 mst 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.
 * 
 * 3. The names "VOCAL", "Vovida Open Communication Application Library",
 *    and "Vovida Open Communication Application Library (VOCAL)" must
 *    not be used to endorse or promote products derived from this
 *    software without prior written permission. For written
 *    permission, please contact [e-mail].
 *
 * 4. Products derived from this software may not be called "VOCAL", nor
 *    may "VOCAL" appear in their name, without prior written
 *    permission of Vovida Networks, Inc.
 * 
 * THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
 * OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND
 * NON-INFRINGEMENT ARE DISCLAIMED.  IN NO EVENT SHALL VOVIDA
 * NETWORKS, INC. OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT DAMAGES
 * IN EXCESS OF $1,000, NOR FOR ANY 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.
 * 
 * ====================================================================
 * 
 * This software consists of voluntary contributions made by Vovida
 * Networks, Inc. and many individuals on behalf of Vovida Networks,
 * Inc.  For more information on Vovida Networks, Inc., please see
 * <http://www.vovida.org/>.
 *
 */
 
 
#include <iostream>
#include <string>
#include <stdio.h>
#include "cpLog.h"
#include "VDbException.hxx"
#include "PGSQLResultset.hxx"
#include "PGSQLConnection.hxx"

using namespace std;

// PGSQLConnection Constructor
PGSQLConnection::PGSQLConnection(const string& dbname, const string& dbhost,
        const string& dbuser, const string& dbpassword)
{
                              // make a connection to postgresql backend
    char* pgport = NULL;      // port of the server
    char* pgoptions = NULL;   // special options to start up the server
    char* pgtty = NULL;       // debugging tty for the server

    cpLog(LOG_DEBUG, "dbname: [%s]", dbname.c_str());
    cpLog(LOG_DEBUG, "dbhost: [%s]", dbhost.c_str());
    cpLog(LOG_DEBUG, "dbuser: [%s]", dbuser.c_str());
    cpLog(LOG_DEBUG, "dbpass: [%s]", dbpassword.c_str());

    cout << "dbname: " << dbname.c_str() << endl;
    cout << "dbhost: " << dbhost.c_str() << endl;
    cout << "dbuser: " << dbuser.c_str() << endl;
    cout << "dbpass: " << dbpassword.c_str() << endl;
    
    myPgSQLConnectionP = PQsetdbLogin( dbhost.c_str(),
    			   	                   pgport,
   			   	                       pgoptions,
           		   	                   pgtty,
    		   		                   dbname.c_str(),
                   		               dbuser.c_str(),
                   		               dbpassword.c_str());	
    // check connection
    if (PQstatus(myPgSQLConnectionP) == CONNECTION_BAD)
    {
        cout << "PGSQLConnection Error: Connection failed" << endl;
        cout << "dbname: " << dbname.c_str() << endl;
        cout << "dbhost: " << dbhost.c_str() << endl;
	    cout << "dbuser: " << dbuser.c_str() << endl;
        cout << "dbpass: " << dbpassword.c_str() << endl;
        cout << PQerrorMessage(myPgSQLConnectionP) << endl;
        string err = "PgSQLConnection Error: Connection failed to database ";

        throw VDbException(err, __FILE__, __LINE__, 0);
    }
};

bool 
PGSQLConnection::checkDBCon()
{
    if(PQstatus(myPgSQLConnectionP) == CONNECTION_BAD){
        return false;
    } else {
        return true;
    }
}    

// Added 17/03/03

// DBSelect- Returns a DBResultset
DBResultset*
PGSQLConnection::DBSQLSelect(const string& Sqlcmd) {

    cpLog(LOG_DEBUG, "Executing SQL Query: %s", Sqlcmd.c_str());
    PGresult*  pgresult;

    pgresult = PQexec(myPgSQLConnectionP, Sqlcmd.c_str());      

    if (!pgresult || PQresultStatus(pgresult) != PGRES_TUPLES_OK)
    {
        string Pgerr = PQresultErrorMessage(pgresult);
        string err = "DBSelect Error: PostgreSQL error: " + Pgerr;         
        // Free memory used by PGresult pointer
        PQclear(pgresult);
        throw VDbException(err, __FILE__, __LINE__, 0);
    }
    else
    {
        myPGSQLResultsetP = new PGSQLResultset(pgresult, "");
    }
    
    return myPGSQLResultsetP;
}


// DBSQLExec - Executes an SQL query
bool
PGSQLConnection::DBSQLExec(const string& Sqlcmd)
{
  cpLog(LOG_DEBUG, "Executing SQL Query: %s", Sqlcmd.c_str());
    PGresult* pgresult;

    pgresult = PQexec(myPgSQLConnectionP, Sqlcmd.c_str());

    if (!pgresult || PQresultStatus(pgresult) != PGRES_COMMAND_OK)
    {
        string Pgerr = PQresultErrorMessage(pgresult);
        string err = "DBSQLExec Error: PostgreSQL error: " + Pgerr;
        // Free memory used by PGresult pointer
        PQclear(pgresult);
        throw VDbException(err, __FILE__, __LINE__, 0);
    }
    // Free memory used by PGresult pointer
    PQclear(pgresult);
    return true;
};