rdbModel::MysqlResults Class Reference

#include <MysqlResults.h>

Inheritance diagram for rdbModel::MysqlResults:

List of all members.

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)
Static Public Member Functions
static void	cleanFieldPtrs (std::vector< std::string * > &fields)
Private Member Functions
	MysqlResults (MYSQL_RES *results=0)
Private Attributes
MYSQL_RES *	m_myres
Friends
class	MysqlConnection

---

Detailed Description

Concrete implementation of ResultHandle, to accompany MysqlConnection.

Definition at line 16 of file MysqlResults.h.

---

Constructor & Destructor Documentation

rdbModel::MysqlResults::~MysqlResults

(

)

[virtual]

Definition at line 17 of file MysqlResults.cxx.

References m_myres.

                              {
    mysql_free_result(m_myres);
  }

rdbModel::MysqlResults::MysqlResults

(

MYSQL_RES *

results = 0

)

[private]

Definition at line 14 of file MysqlResults.cxx.

                                               : m_myres(results) {
  }

---

Member Function Documentation

void rdbModel::ResultHandle::cleanFieldPtrs

(

std::vector< std::string * > &

fields

)

[static, inherited]

Definition at line 7 of file ResultHandle.cxx.

References genRecEmupikp::i.

Referenced by rdbModel::Table::supersedeRow().

                                                                 {
    for (unsigned i = 0; i < fields.size(); i++) {
      if (fields[i] != 0) delete fields[i];
    }
    fields.resize(0);
  }

unsigned int rdbModel::MysqlResults::getNRows

(

)

const [virtual]

Return number of rows in results.

Implements rdbModel::ResultHandle.

Definition at line 21 of file MysqlResults.cxx.

References m_myres.

                                            {
    return mysql_num_rows(m_myres);
  }

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.

References m_myres, and deljobs::string.

                                                        {
    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;
  }

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.

References m_myres.

                                                                          {
    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;

  }

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.

References m_myres, and deljobs::string.

                                                            {

    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 Function Documentation

friend class MysqlConnection [friend]

Definition at line 17 of file MysqlResults.h.

---

Member Data Documentation

MYSQL_RES* rdbModel::MysqlResults::m_myres [private]

Definition at line 64 of file MysqlResults.h.

Referenced by getNRows(), getRow(), getRowCon(), getRowPtrs(), and ~MysqlResults().

---