odbc_sp_who.cpp

Go to the documentation of this file.

Go to the SVN repository for this file.

/* $Id $
 * ===========================================================================
 *
 *                            PUBLIC DOMAIN NOTICE
 *               National Center for Biotechnology Information
 *
 *  This software/database is a "United States Government Work" under the
 *  terms of the United States Copyright Act.  It was written as part of
 *  the author's official duties as a United States Government employee and
 *  thus cannot be copyrighted.  This software/database is freely available
 *  to the public for use. The National Library of Medicine and the U.S.
 *  Government have not placed any restriction on its use or reproduction.
 *
 *  Although all reasonable efforts have been taken to ensure the accuracy
 *  and reliability of the software and data, the NLM and the U.S.
 *  Government do not and cannot warrant the performance or results that
 *  may be obtained by using this software or data. The NLM and the U.S.
 *  Government disclaim all warranties, express or implied, including
 *  warranties of performance, merchantability or fitness for any particular
 *  purpose.
 *
 *  Please cite the author in any work or product based on this material.
 *
 * ===========================================================================
 *
 * Author:  Vladimir Soussov
 *
 * This simple program illustrates how to use the RPC command
 *
 */
 
#include <ncbi_pch.hpp>
 
#include <corelib/ncbiapp.hpp>
#include <dbapi/driver/exception.hpp>
#include <dbapi/driver/odbc/interfaces.hpp>
#include <dbapi/driver/dbapi_svc_mapper.hpp>
#include <common/test_assert.h>  /* This header must go last */
 
 
USING_NCBI_SCOPE;
 
 
class COdbcSpwhoDemoApp : public CNcbiApplication
{
public:
    virtual ~COdbcSpwhoDemoApp(void) {}
 
    virtual int Run(void);
};
 
int
COdbcSpwhoDemoApp::Run(void)
{
    try {
        DBLB_INSTALL_DEFAULT();
 
        CODBCContext my_context;
 
        unique_ptr<CDB_Connection> con(my_context.Connect("msdev1",
                                                          "DBAPI_test",
                                                          "allowed",
                                                          0));
 
        unique_ptr<CDB_RPCCmd> rcmd(con->RPC("sp_who"));
        rcmd->Send();
 
        while (rcmd->HasMoreResults()) {
            unique_ptr<CDB_Result> r(rcmd->Result());
            if (!r.get())
                continue;
 
            if (r->ResultType() == eDB_RowResult) {
                while (r->Fetch()) {
                    for (unsigned int j = 0;  j < r->NofItems(); j++) {
                        EDB_Type rt = r->ItemDataType(j);
                        if (rt == eDB_Char || rt == eDB_VarChar) {
                            CDB_VarChar r_vc;
                            r->GetItem(&r_vc);
                            cout << r->ItemName(j) << ": " << r_vc.AsString()
                                 << " \t";
                        } else if (rt == eDB_Int ||
                                   rt == eDB_SmallInt ||
                                   rt == eDB_TinyInt) {
                            CDB_Int r_in;
                            r->GetItem(&r_in);
                            cout << r->ItemName(j) << ": " << r_in.Value() << ' ';
                        } else
                            r->SkipItem();
                    }
                    cout << endl;
                }
            }
        }
    } catch (CDB_Exception& e) {
        CDB_UserHandler_Stream myExHandler(&cerr);
 
        myExHandler.HandleIt(&e);
        return 1;
    } catch (const CException&) {
        return 1;
    }
 
    return 0;
}
 
int main(int argc, const char* argv[])
{
    return COdbcSpwhoDemoApp().AppMain(argc, argv);
}