db/database.cpp

Go to the documentation of this file.

#ifndef         __DATABASE_CPP__
#define         __DATABASE_CPP__

#include        <db/database.h>

namespace       nitro{

        /* virtual */ void                              Database::Connect( const std::string & theConnectionString )
        {
                try
                {
                        Connect( theConnectionString.c_str() );
                }
                catch( nitro::exception e )
                {
                        throw( nitro::exception( std::string( "Database::Connect( const std::string & theConnectionString )::" ) + e.what() , e.code() ) );
                }
                catch( ... )
                {
                        throw( nitro::exception( std::string( "Database::Connect( const std::string & theConnectionString )::An error occured" ) , 0 ) );
                }
        }

        /* virtual */ void                              Database::Query( const std::string & theQueryString )
        {
                try
                {
                        Query( theQueryString.c_str() );
                }
                catch( nitro::exception e )
                {
                        throw( nitro::exception( std::string( "Database::Query( const std::string & theQueryString )::" ) + e.what() , e.code() ) );
                }
                catch( ... )
                {
                        throw( nitro::exception( std::string( "Database::Query( const std::string & theQueryString )::An error occured" ) , 0 ) );
                }
        }

        void                                                    Database::Select( const std::string & What , const std::string & Tables , const std::string & Condition /* = "1 = 1" */ )
        {
                try
                {
                        ClearResult();

                        Query( ( std::string( "SELECT " ) + What + " FROM " + Tables + " WHERE " + Condition ).c_str() );
                }
                catch( nitro::exception e )
                {
                        throw( nitro::exception( std::string( "Database::Select( const std::string & What , const std::string & Tables , const std::string & Condition /* = 1 = 1 */ )::" ) + e.what() , e.code() ) );
                }
                catch( ... )
                {
                        throw( nitro::exception( std::string( "Database::Select( const std::string & What , const std::string & Tables , const std::string & Condition /* = 1 = 1 */ )::An error occured" ) , 0 ) );
                }
        }

        /* virtual */ void                              Database::Insert( const std::string & Table , const std::string & Fields , const std::string & Values )
        {
                try
                {
                        Query( ( std::string( "INSERT INTO " ) + Table + " ( " + Fields + " ) VALUES ( " + Values + " )" ).c_str() );
                }
                catch( nitro::exception e )
                {
                        throw( nitro::exception( std::string( "Database::Insert( const std::string & Table , const std::string & Fields , const std::string & Values )::" ) + e.what() , e.code() ) );
                }
                catch( ... )
                {
                        throw( nitro::exception( std::string( "Database::Insert( const std::string & Table , const std::string & Fields , const std::string & Values )::An error occured" ) , 0 ) );
                }
        }

        /* virtual */ void                              Database::Delete( const std::string & Table , const std::string & Condition /* = "1 = 1" */ )
        {
                try
                {
                        Query( ( std::string( "DELETE FROM " ) + Table + " WHERE " + Condition ).c_str() );
                }
                catch( nitro::exception e )
                {
                        throw( nitro::exception( std::string( "Database::Delete( const std::string & Table , const std::string & Condition )::" ) + e.what() , e.code() ) );
                }
                catch( ... )
                {
                        throw( nitro::exception( std::string( "Database::Delete( const std::string & Table , const std::string & Condition )::An error occured" ) , 0 ) );
                }
        }

        /* virtual */ Database::~Database()
        {
                try
                {
                }
                catch( ... )
                {
                }
        }

};

#endif