pgsqlconnection.hxx

来自「vovida的软交换」· HXX 代码 · 共 113 行

/* ====================================================================
 * 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 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.
 * 
 * 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/>.
 *
 */

#ifndef PGSQLCONNECTION_HXX
#define PGSQLCONNECTION_HXX

#include <libpq-fe.h>

#include <string>
#include "DBConnection.hxx"

/// Forward Declare PGSQLResultset
class PGSQLResultset;

/// PGSQLConnection class
class PGSQLConnection : public DBConnection
{
    private:
        /// Constructor- make connection to PostgreSQL 
        PGSQLConnection(const string& dbname, 
                const string& dbhost,
                const string& dbuser, 
                const string& dbpassword);

        /// Destructor- free memory associated with PGconn pointer
        virtual ~PGSQLConnection()
        { 
            PQfinish(myPgSQLConnectionP);
        };

        /// Return a resultset object
        virtual DBResultset* DBSQLSelect (const string& Sqlcmd);

        /// Redirect Insert/Update/Delete to generic exec function
        virtual bool DBSQLInsert(const string& Sqlcmd)
	    {return DBSQLExec(Sqlcmd);};
        virtual bool DBSQLUpdate(const string& Sqlcmd)
	    {return DBSQLExec(Sqlcmd);};
        virtual bool DBSQLDelete(const string& Sqlcmd)
	    {return DBSQLExec(Sqlcmd);};

        /// Generic SQLExec function
        virtual bool DBSQLExec(const string& Sqlcmd);

        /// Check connection status
        virtual bool checkDBCon();

        /// PostgreSQL Connection handle
        PGconn* myPgSQLConnectionP;

        /// vector<vector <string> > used by DBDescribe(Domain)
        ResultTabletype myDescribeTable;

        /// vector <string> used by DBDescribe()
        ResultRecordtype myDescribeRecord;

        /// myPgSQLResultsethandle a the pointer to the resultset
        PGSQLResultset* myPGSQLResultsetP;

    public:
        /// The only class authorized to use PGSQLConnection is 
        /// ConnectionManager
        friend class ConnectionManager;
};
#endif