DB::MySQL_ResultSet Class Reference

#include <mysql_db.h>

Inheritance diagram for DB::MySQL_ResultSet:

List of all members.

Public Member Functions
bool	close (void)
bool	next (void)
unsigned long	recordCount (void) const
unsigned int	findColumn (const char *field) const
const char *	getString (const int idx) const
const int	getInteger (const int idx) const
const bool	getBool (const int idx) const
const time_t	getUnixTime (const int idx) const
const double	getDouble (const int idx) const
const float	getFloat (const int idx) const
const long	getLong (const int idx) const
const short	getShort (const int idx) const
void *	operator new (size_t bytes)
void	operator delete (void *ptr)
Protected Member Functions
	MySQL_ResultSet (MYSQL_RES *res)
	~MySQL_ResultSet ()
Private Member Functions
	MySQL_ResultSet ()
	MySQL_ResultSet (const MySQL_ResultSet &old)
const MySQL_ResultSet &	operator= (const MySQL_ResultSet &old)
Private Attributes
MYSQL_RES *	res_
MYSQL_ROW	row_
Friends
class	MySQL_Connection

---

Detailed Description

Definition at line 31 of file mysql_db.h.

---

Constructor & Destructor Documentation

DB::MySQL_ResultSet::MySQL_ResultSet

(

MYSQL_RES *

res

)

[inline, protected]

Definition at line 35 of file mysql_db.h.

: res_(res) {};

DB::MySQL_ResultSet::~MySQL_ResultSet

(

)

[protected]

Definition at line 33 of file mysql_db.cpp.

References res_.

{
    if (res_) {
        ACE_DEBUG((LM_ERROR,"Warning ResultSet wasn't closed or deleted.\n"));
    }
}

DB::MySQL_ResultSet::MySQL_ResultSet

(

)

[inline, private]

Definition at line 38 of file mysql_db.h.

{};

DB::MySQL_ResultSet::MySQL_ResultSet

(

const MySQL_ResultSet &

old

)

[private]

---

Member Function Documentation

bool DB::MySQL_ResultSet::close

(

void

)

[virtual]

Implements DB::ResultSet.

Definition at line 41 of file mysql_db.cpp.

References res_, and row_.

{
    if (!res_) return (false);

    // eat remaining rows, if there are some
    while ((row_ = mysql_fetch_row(res_)) != NULL) {
        ;
    }

    mysql_free_result(res_);
    res_ = NULL;
    delete this;

    return (true);
}

unsigned int DB::MySQL_ResultSet::findColumn

(

const char *

field

)

const [virtual]

Implements DB::ResultSet.

Definition at line 78 of file mysql_db.cpp.

References res_.

{
    unsigned int num_fields;
    unsigned int i;
    MYSQL_FIELD *field;

    num_fields = mysql_num_fields(res_);
    for (i=0; i<num_fields; i++) {
        field = mysql_fetch_field_direct(res_, i);
        if (ACE_OS::strcmp(field->name,fld) == 0) {
            return (i);
        }
    }
    return (i);
}

const bool DB::MySQL_ResultSet::getBool

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 107 of file mysql_db.cpp.

References row_.

{
    if (row_[idx] && row_[idx][0] == '1') {
        return (true);
    }
    return (false);
}

const double DB::MySQL_ResultSet::getDouble

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 165 of file mysql_db.cpp.

References row_.

{
    char *pEnd;
    return ((row_[idx] ? ACE_OS::strtod(row_[idx], &pEnd) : 0));
}

const float DB::MySQL_ResultSet::getFloat

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 172 of file mysql_db.cpp.

References row_.

{
    return ((row_[idx] ? atof(row_[idx]) : 0));
}

const int DB::MySQL_ResultSet::getInteger

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 101 of file mysql_db.cpp.

References row_.

{
    return ((const int) ACE_OS::atoi(row_[idx]));
}

const long DB::MySQL_ResultSet::getLong

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 178 of file mysql_db.cpp.

References row_.

{
    return ((row_[idx] ? atol(row_[idx]) : 0L));
}

const short DB::MySQL_ResultSet::getShort

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 184 of file mysql_db.cpp.

References row_.

{
    return ((short) (row_[idx] ? ACE_OS::atoi(row_[idx]) : 0));
}

const char * DB::MySQL_ResultSet::getString

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 95 of file mysql_db.cpp.

References row_.

{
    return (row_[idx]);
}

const time_t DB::MySQL_ResultSet::getUnixTime

(

const int

idx

)

const [virtual]

Implements DB::ResultSet.

Definition at line 116 of file mysql_db.cpp.

References row_.

{
    struct tm tmp;
    // ACE_DEBUG((LM_DEBUG, ACE_TEXT("Read UnixTime: %s\n"), row_[idx]));

    if (row_[idx]) {
        // switch on the type of field
        // Basically, there are two types of returns I've seen
        // 1. has a hypen and is fully parseable
        // 2. has no hypen and is an older timestamp field
        // The others are raw DATE or TIME
        int Ypos = 0;
        int Mpos = 4;
        int Dpos = 6;
        int hpos = 8;
        int mpos = 10;
        int spos = 12;
        if (strchr(row_[idx], '-') != NULL) {
            ++Mpos;
            Dpos = 8;
            hpos = 11;
            mpos = 14;
            spos = 17;
        }
        tmp.tm_wday = 0;
        tmp.tm_yday = 0;
        tmp.tm_isdst = 0;
        tmp.tm_year = (((row_[idx][Ypos] - '0') * 1000) + ((row_[idx][Ypos+1] - '0') * 100) + ((row_[idx][Ypos+2] - '0') * 10) + (row_[idx][Ypos+3] - '0')) - 1900;
        tmp.tm_mon = (((row_[idx][Mpos] - '0') * 10) + (row_[idx][Mpos+1] - '0')) - 1; /* 0 - 11 */
        tmp.tm_mday = (((row_[idx][Dpos] - '0') * 10) + (row_[idx][Dpos+1] - '0')); /* 1 - 31 */
        tmp.tm_hour = (((row_[idx][hpos] - '0') * 10) + (row_[idx][hpos+1] - '0')) - 1; /* 0 - 23 */
        tmp.tm_min = (((row_[idx][mpos] - '0') * 10) + (row_[idx][mpos+1] - '0')); /* 0-59 */
        tmp.tm_sec = (((row_[idx][spos] - '0') * 10) + (row_[idx][spos+1] - '0')); /* 0-59 */

        /*
        ACE_DEBUG((LM_DEBUG, ACE_TEXT("y=%d m=%d d=%d h=%d m=%d s=%d\n"), 
                   tmp.tm_year,
                   tmp.tm_mon,
                   tmp.tm_mday,
                   tmp.tm_hour,
                   tmp.tm_min,
                   tmp.tm_sec));
        */
        return (mktime(&tmp));
    }
    return (0);
}

bool DB::MySQL_ResultSet::next

(

void

)

[virtual]

Implements DB::ResultSet.

Definition at line 58 of file mysql_db.cpp.

References res_, and row_.

{
    row_ = mysql_fetch_row(res_);
    return ((row_ != NULL ? true : false));
}

void DB::MySQL_ResultSet::operator delete

(

void *

ptr

)

Definition at line 209 of file mysql_db.cpp.

{
  delete [] static_cast <char *> (ptr);
}

void * DB::MySQL_ResultSet::operator new

(

size_t

bytes

)

Definition at line 190 of file mysql_db.cpp.

{
  return (::new char[bytes]);
}

const MySQL_ResultSet& DB::MySQL_ResultSet::operator=

(

const MySQL_ResultSet &

old

)

[private]

unsigned long DB::MySQL_ResultSet::recordCount

(

void

)

const [virtual]

Implements DB::ResultSet.

Definition at line 65 of file mysql_db.cpp.

References res_.

{
    /* NOTE: This call ALWAYS fails because mysql_use_result
       is used, UNTIL all rows have been read. This is documented
       in the MySQL manual.

       I still opt for using mysql_use_result as it reduces
       the traffic/memory requirements on the client side.
    */
    return ((unsigned long) mysql_num_rows(res_));
}

---

Friends And Related Function Documentation

friend class MySQL_Connection [friend]

Definition at line 33 of file mysql_db.h.

---

Member Data Documentation

MYSQL_RES* DB::MySQL_ResultSet::res_ [private]

Definition at line 72 of file mysql_db.h.

Referenced by close(), findColumn(), next(), recordCount(), and ~MySQL_ResultSet().

MYSQL_ROW DB::MySQL_ResultSet::row_ [private]

Definition at line 73 of file mysql_db.h.

Referenced by close(), getBool(), getDouble(), getFloat(), getInteger(), getLong(), getShort(), getString(), getUnixTime(), and next().

---

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

• mysql_db.h
• mysql_db.cpp

---