rdbModel::MysqlResults Class Reference

#include <MysqlResults.h>

Inheritance diagram for rdbModel::MysqlResults:

Public Member Functions
virtual	~MysqlResults ()
virtual unsigned int	getNRows () const
	Return number of rows in results.
virtual bool	getRow (std::vector< std::string > &fields, unsigned int i=0, bool clear=true)
virtual bool	getRowPtrs (std::vector< std::string * > &fieldPtrs, unsigned int i=0, bool clear=true)
virtual bool	getRowCon (char *par, unsigned long *treesize, unsigned int *runFrm, unsigned int *runTo, unsigned int i=0, bool clear=true)
Public Member Functions inherited from rdbModel::ResultHandle
	ResultHandle ()
virtual	~ResultHandle ()

Friends
class	MysqlConnection

Additional Inherited Members
Static Public Member Functions inherited from rdbModel::ResultHandle
static void	cleanFieldPtrs (std::vector< std::string * > &fields)

Detailed Description

Concrete implementation of ResultHandle, to accompany MysqlConnection.

Definition at line 16 of file MysqlResults.h.

Constructor & Destructor Documentation

~MysqlResults()

rdbModel::MysqlResults::~MysqlResults ( )

virtual

Definition at line 17 of file MysqlResults.cxx.

                              {
    mysql_free_result(m_myres);
  }

Member Function Documentation

getNRows()

unsigned int rdbModel::MysqlResults::getNRows ( ) const

virtual

Return number of rows in results.

Implements rdbModel::ResultHandle.

Definition at line 21 of file MysqlResults.cxx.

                                            {
    return mysql_num_rows(m_myres);
  }

getRow()

bool rdbModel::MysqlResults::getRow ( std::vector< std::string > & fields, unsigned int i = 0, bool clear = true )

virtual

Get array of field values for ith row of result set

Implements rdbModel::ResultHandle.

Definition at line 25 of file MysqlResults.cxx.

                                                        {
    mysql_data_seek(m_myres, i);
    MYSQL_ROW myRow = mysql_fetch_row(m_myres);
 
    unsigned nFields = mysql_num_fields(m_myres);
 
 
    if (clear) fields.clear();
 
    for (unsigned int iField = 0; iField < nFields; iField++) {
      if (myRow[iField]) fields.push_back(std::string(myRow[iField]));
      else fields.push_back("");
    }
 
    return true;
  }

getRowCon()

bool rdbModel::MysqlResults::getRowCon ( char * par, unsigned long * treesize, unsigned int * runFrm, unsigned int * runTo, unsigned int i = 0, bool clear = true )

virtual

Implements rdbModel::ResultHandle.

Definition at line 64 of file MysqlResults.cxx.

                                                                  {
    mysql_data_seek(m_myres, i);
    MYSQL_ROW myRow = mysql_fetch_row(m_myres);
    unsigned nFields = mysql_num_fields(m_myres);
    unsigned long* lengths;
    lengths = mysql_fetch_lengths(m_myres);
 
    for (unsigned int iField = 0; iField <nFields; iField++) {
      if (myRow[iField]&&iField<(nFields-4)){
    memcpy(par+1024000*iField,myRow[iField],lengths[iField]);
    treesize[iField] = lengths[iField];
      }
    }
 
    *runFrm =facilities::Util::stringToInt(myRow[nFields-4]);
    *runTo =facilities::Util::stringToInt(myRow[nFields-3]);
  std::cout<<" CalVerSft is "<<myRow[nFields-2]<<"  File name  is "<<myRow[nFields-1]<<std::endl;
 
    return true;
 
  }

getRowPtrs()

bool rdbModel::MysqlResults::getRowPtrs ( std::vector< std::string * > & fieldPtrs, unsigned int i = 0, bool clear = true )

virtual

Get array of field values for ith row of result set. If a field value is NULL, return a zero ptr for that element of the array.

--> It is the responsibility of the caller to delete the strings containing the field values. See service cleanFieldPtrs in base class ResultHandle.

Implements rdbModel::ResultHandle.

Definition at line 43 of file MysqlResults.cxx.

                                                            {
 
    mysql_data_seek(m_myres, i);
    MYSQL_ROW myRow = mysql_fetch_row(m_myres);
 
    unsigned nFields = mysql_num_fields(m_myres);
 
 
    if (clear) fields.clear();
 
    for (unsigned int iField = 0; iField < nFields; iField++) {
      if (myRow[iField]) fields.push_back(new std::string(myRow[iField]));
      else fields.push_back(0);
    }
 
    return true;
 
  }

Friends And Related Symbol Documentation

MysqlConnection

friend class MysqlConnection

friend

Definition at line 17 of file MysqlResults.h.

---

The documentation for this class was generated from the following files:

• MysqlResults.h
• MysqlResults.cxx