Main Page   Namespace List   Class Hierarchy   Compound List   File List   Namespace Members   Compound Members   File Members  

mysqlpp::Row Class Reference

Manages rows from a result set. More...

#include <row.h>

Inheritance diagram for mysqlpp::Row:

Inheritance graph
[legend]
Collaboration diagram for mysqlpp::Row:

Collaboration graph
[legend]
List of all members.

Public Methods

 Row ()
 Default constructor.

MYSQLPP_EXPORT Row (const MYSQL_ROW &d, const ResUse *r, unsigned long *jj, bool te=true)
 Create a row object.

MYSQLPP_EXPORT ~Row ()
 Destroy object.

const ResUseparent () const
 Get a reference to our parent class.

MYSQLPP_EXPORT size_type size () const
 Get the number of fields in the row.

MYSQLPP_EXPORT const ColData operator[] (const char *field) const
 Get the value of a field given its name.

const ColData operator[] (size_type i) const
 Get the value of a field given its index.

MYSQLPP_EXPORT const ColData at (size_type i) const
 Get the value of a field given its index.

const char * raw_data (int i) const
 Return the value of a field given its index, in raw form.

 operator bool () const
 Returns true if there is data in the row.

template<class Manip> value_list_ba< Row, Manip > value_list (const char *d=",", Manip m=quote) const
 Get a list of the values in this row.

template<class Manip> value_list_b< Row, Manip > value_list (const char *d, const std::vector< bool > &vb, Manip m=quote) const
 Get a list of the values in this row.

value_list_b< Row, quote_type0value_list (const std::vector< bool > &vb) const
 Get a list of the values in this row.

template<class Manip> value_list_b< Row, Manip > value_list (const char *d, Manip m, bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the values in this row.

value_list_b< Row, quote_type0value_list (const char *d, bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the values in this row.

value_list_b< Row, quote_type0value_list (bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the values in this row.

template<class Manip> value_list_b< Row, Manip > value_list (const char *d, Manip m, std::string s0, std::string s1="", std::string s2="", std::string s3="", std::string s4="", std::string s5="", std::string s6="", std::string s7="", std::string s8="", std::string s9="", std::string sa="", std::string sb="", std::string sc="") const
 Get a list of the values in this row.

value_list_b< Row, quote_type0value_list (const char *d, std::string s0, std::string s1="", std::string s2="", std::string s3="", std::string s4="", std::string s5="", std::string s6="", std::string s7="", std::string s8="", std::string s9="", std::string sa="", std::string sb="", std::string sc="") const
 Get a list of the values in this row.

value_list_b< Row, quote_type0value_list (std::string s0, std::string s1="", std::string s2="", std::string s3="", std::string s4="", std::string s5="", std::string s6="", std::string s7="", std::string s8="", std::string s9="", std::string sa="", std::string sb="", std::string sc="") const
 Get a list of the values in this row.

MYSQLPP_EXPORT value_list_ba<
FieldNames, do_nothing_type0
field_list (const char *d=",") const
 Get a list of the field names in this row.

template<class Manip> value_list_ba< FieldNames,
Manip > 
field_list (const char *d, Manip m) const
 Get a list of the field names in this row.

template<class Manip> value_list_b< FieldNames,
Manip > 
field_list (const char *d, Manip m, const std::vector< bool > &vb) const
 Get a list of the field names in this row.

MYSQLPP_EXPORT value_list_b<
FieldNames, quote_type0
field_list (const char *d, const std::vector< bool > &vb) const
 Get a list of the field names in this row.

MYSQLPP_EXPORT value_list_b<
FieldNames, quote_type0
field_list (const std::vector< bool > &vb) const
 Get a list of the field names in this row.

template<class Manip> value_list_b< FieldNames,
Manip > 
field_list (const char *d, Manip m, bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the field names in this row.

MYSQLPP_EXPORT value_list_b<
FieldNames, quote_type0
field_list (const char *d, bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the field names in this row.

MYSQLPP_EXPORT value_list_b<
FieldNames, quote_type0
field_list (bool t0, bool t1=false, bool t2=false, bool t3=false, bool t4=false, bool t5=false, bool t6=false, bool t7=false, bool t8=false, bool t9=false, bool ta=false, bool tb=false, bool tc=false) const
 Get a list of the field names in this row.

MYSQLPP_EXPORT equal_list_ba<
FieldNames, Row, quote_type0
equal_list (const char *d=",", const char *e="=") const
 Get an "equal list" of the fields and values in this row.

template<class Manip> equal_list_ba< FieldNames,
Row, Manip > 
equal_list (const char *d, const char *e, Manip m) const
 Get an "equal list" of the fields and values in this row.


Detailed Description

Manages rows from a result set.


Constructor & Destructor Documentation

mysqlpp::Row::Row const MYSQL_ROW &    d,
const ResUse   r,
unsigned long *    jj,
bool    te = true
 

Create a row object.

Parameters:
d  MySQL C API row data
r  result set that the row comes from
jj  length of each item in d
te  if true, throw exceptions on errors


Member Function Documentation

const ColData mysqlpp::Row::at size_type    i const
 

Get the value of a field given its index.

If the index is out-of-bounds, the underlying vector is supposed to throw an exception according to the C++ Standard. Whether it actually does this is implementation-dependent.

See also:
operator[]() for caveats about using this function.

template<class Manip>
equal_list_ba< FieldNames, Row, Manip > mysqlpp::Row::equal_list const char *    d,
const char *    e,
Manip    m
const
 

Get an "equal list" of the fields and values in this row.

This method's parameters govern how the returned list will behave when you insert it into a C++ stream:

Parameters:
d  delimiter to use between items
e  the operator to use between elements
m  the manipulator to use for each element
For example, if d is ",", e is " = ", and m is the quote manipulator, then the field and value lists (a, b) (c, d'e) will yield an equal list that gives the following when inserted into a C++ stream:

              'a' = 'c', 'b' = 'd''e'

Notice how the single quote was 'escaped' in the SQL way to avoid a syntax error.

equal_list_ba< FieldNames, Row, quote_type0 > mysqlpp::Row::equal_list const char *    d = ",",
const char *    e = "="
const
 

Get an "equal list" of the fields and values in this row.

When inserted into a C++ stream, the delimiter 'd' will be used between the items, " = " is the relationship operator, and items will be quoted and escaped.

value_list_b< FieldNames, quote_type0 > mysqlpp::Row::field_list bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const
 

Get a list of the field names in this row.

For each true parameter, the field name in that position within the row is added to the returned list. When the list is inserted into a C++ stream, a comma will be placed between the items as a delimiter, and the items will be quoted and escaped.

value_list_b< FieldNames, quote_type0 > mysqlpp::Row::field_list const char *    d,
bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const
 

Get a list of the field names in this row.

For each true parameter, the field name in that position within the row is added to the returned list. When the list is inserted into a C++ stream, the delimiter 'd' will be placed between the items as a delimiter, and the items will be quoted and escaped.

template<class Manip>
value_list_b< FieldNames, Manip > mysqlpp::Row::field_list const char *    d,
Manip    m,
bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const
 

Get a list of the field names in this row.

For each true parameter, the field name in that position within the row is added to the returned list. When the list is inserted into a C++ stream, the delimiter 'd' will be placed between the items as a delimiter, and the manipulator 'm' used before each item.

value_list_b< FieldNames, quote_type0 > mysqlpp::Row::field_list const std::vector< bool > &    vb const
 

Get a list of the field names in this row.

Parameters:
vb  for each true item in this list, add that field name to the returned list; ignore the others
Field names will be quoted and escaped when inserted into a C++ stream, and a comma will be placed between them as a delimiter.

value_list_b< FieldNames, quote_type0 > mysqlpp::Row::field_list const char *    d,
const std::vector< bool > &    vb
const
 

Get a list of the field names in this row.

Parameters:
d  delimiter to place between the items when the list is inserted into a C++ stream
vb  for each true item in this list, add that field name to the returned list; ignore the others
Field names will be quoted and escaped when inserted into a C++ stream.

template<class Manip>
value_list_b< FieldNames, Manip > mysqlpp::Row::field_list const char *    d,
Manip    m,
const std::vector< bool > &    vb
const
 

Get a list of the field names in this row.

Parameters:
d  delimiter to place between the items when the list is inserted into a C++ stream
m  manipulator to use before each item when the list is inserted into a C++ stream
vb  for each true item in this list, add that field name to the returned list; ignore the others

template<class Manip>
value_list_ba< FieldNames, Manip > mysqlpp::Row::field_list const char *    d,
Manip    m
const
 

Get a list of the field names in this row.

Parameters:
d  delimiter to place between the items when the list is inserted into a C++ stream
m  manipulator to use before each item when the list is inserted into a C++ stream

value_list_ba< FieldNames, do_nothing_type0 > mysqlpp::Row::field_list const char *    d = "," const
 

Get a list of the field names in this row.

When inserted into a C++ stream, the delimiter 'd' will be used between the items, and no manipulator will be used on the items.

const ColData mysqlpp::Row::operator[] size_type    i const [inline]
 

Get the value of a field given its index.

If the index value is bad, the underlying std::vector is supposed to throw an exception, according to the Standard.

This function is just syntactic sugar, wrapping the at() method. The at() method is the only way to get at the first field by index, as row[0] is ambiguous: it could call either overload.

See operator[](const char *) for more caveats.

const ColData mysqlpp::Row::operator[] const char *    field const
 

Get the value of a field given its name.

If the field does not exist in this row, we throw a BadFieldName exception.

Note that we return the ColData object by value. The purpose of ColData is to make it easy to convert the string data returned by the MySQL server to some more appropriate type, so you're almost certain to use this operator in a construct like this:

             string s = row["myfield"];

That accesses myfield within the row, returns a temporary ColData object, which is then automatically converted to a std::string and copied into s. That works fine, but beware of this similar but incorrect construct:

             const char* pc = row["myfield"];

This one line of code does what you expect, but pc is then a dangling pointer: it points to memory owned by the temporary ColData object, which will have been destroyed by the time you get around to actually using the pointer.

This function is rather inefficient. If that is a concern for you, use at(), operator[](size_type) or the SSQLS mechanism instead.

const char* mysqlpp::Row::raw_data int    i const [inline]
 

Return the value of a field given its index, in raw form.

This is the same thing as operator[], except that the data isn't converted to a ColData object first. Also, this method does not check for out-of-bounds array indices.

value_list_b<Row, quote_type0> mysqlpp::Row::value_list std::string    s0,
std::string    s1 = "",
std::string    s2 = "",
std::string    s3 = "",
std::string    s4 = "",
std::string    s5 = "",
std::string    s6 = "",
std::string    s7 = "",
std::string    s8 = "",
std::string    s9 = "",
std::string    sa = "",
std::string    sb = "",
std::string    sc = ""
const [inline]
 

Get a list of the values in this row.

The 's' parameters name the fields that will be added to the returned list. When inserted into a C++ stream, a comma will be placed between the items as a delimiter, and items will be quoted and escaped.

value_list_b<Row, quote_type0> mysqlpp::Row::value_list const char *    d,
std::string    s0,
std::string    s1 = "",
std::string    s2 = "",
std::string    s3 = "",
std::string    s4 = "",
std::string    s5 = "",
std::string    s6 = "",
std::string    s7 = "",
std::string    s8 = "",
std::string    s9 = "",
std::string    sa = "",
std::string    sb = "",
std::string    sc = ""
const [inline]
 

Get a list of the values in this row.

The 's' parameters name the fields that will be added to the returned list. When inserted into a C++ stream, the delimiter 'd' will be placed between the items, and items will be quoted and escaped.

template<class Manip>
value_list_b<Row, Manip> mysqlpp::Row::value_list const char *    d,
Manip    m,
std::string    s0,
std::string    s1 = "",
std::string    s2 = "",
std::string    s3 = "",
std::string    s4 = "",
std::string    s5 = "",
std::string    s6 = "",
std::string    s7 = "",
std::string    s8 = "",
std::string    s9 = "",
std::string    sa = "",
std::string    sb = "",
std::string    sc = ""
const [inline]
 

Get a list of the values in this row.

The 's' parameters name the fields that will be added to the returned list. When inserted into a C++ stream, the delimiter 'd' will be placed between the items, and the manipulator 'm' will be inserted before each item.

value_list_b<Row, quote_type0> mysqlpp::Row::value_list bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const [inline]
 

Get a list of the values in this row.

For each true parameter, the value in that position within the row is added to the returned list. When the list is inserted into a C++ stream, the a comma will be placed between the items, as a delimiter, and items will be quoted and escaped.

value_list_b<Row, quote_type0> mysqlpp::Row::value_list const char *    d,
bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const [inline]
 

Get a list of the values in this row.

For each true parameter, the value in that position within the row is added to the returned list. When the list is inserted into a C++ stream, the delimiter 'd' will be placed between the items, and items will be quoted and escaped.

template<class Manip>
value_list_b<Row, Manip> mysqlpp::Row::value_list const char *    d,
Manip    m,
bool    t0,
bool    t1 = false,
bool    t2 = false,
bool    t3 = false,
bool    t4 = false,
bool    t5 = false,
bool    t6 = false,
bool    t7 = false,
bool    t8 = false,
bool    t9 = false,
bool    ta = false,
bool    tb = false,
bool    tc = false
const [inline]
 

Get a list of the values in this row.

For each true parameter, the value in that position within the row is added to the returned list. When the list is inserted into a C++ stream, the delimiter 'd' will be placed between the items, and the manipulator 'm' used before each item.

value_list_b<Row, quote_type0> mysqlpp::Row::value_list const std::vector< bool > &    vb const [inline]
 

Get a list of the values in this row.

Parameters:
vb  for each true item in this list, add that value to the returned list; ignore the others
Items will be quoted and escaped when inserted into a C++ stream, and a comma will be used as a delimiter between the items.

template<class Manip>
value_list_b<Row, Manip> mysqlpp::Row::value_list const char *    d,
const std::vector< bool > &    vb,
Manip    m = quote
const [inline]
 

Get a list of the values in this row.

Parameters:
d  delimiter to use between values
vb  for each true item in this list, add that value to the returned list; ignore the others
m  manipulator to use when inserting values into a stream

template<class Manip>
value_list_ba<Row, Manip> mysqlpp::Row::value_list const char *    d = ",",
Manip    m = quote
const [inline]
 

Get a list of the values in this row.

When inserted into a C++ stream, the delimiter 'd' will be used between the items, and the quoting and escaping rules will be set by the manipulator 'm' you choose.

Parameters:
d  delimiter to use between values
m  manipulator to use when inserting values into a stream


The documentation for this class was generated from the following files:
Generated on Wed Sep 28 07:44:52 2005 for MySQL++ by doxygen1.2.18