Debea Library 1.4.2
dba::SQLUtils

SQLUtils Class Reference
[Public API]

common SQL utilities More...

#include <sqlutils.h>

List of all members.


Static Public Member Functions

static SQL createIN (const std::set< std::string > &pSet)
 Create IN clause from set of string values.
static SQL createIN (const std::vector< int > &pSet)
 Create part of SQL SELECT for use with in clause.
static SQL createIN (const std::vector< id > &pSet)
 Create part of SQL SELECT for use with in clause.
static SQL createIN (const std::set< int > &pSet)
 Create IN clause from set of int values.
static std::string escapeSQLData (const std::string &pData)
 Escape text string to conform SQL standard.
static std::string escapeSQLLike (const std::string &pData)
 Escape string used for LIKE clause to conform SQL standard.
static int getMax (DbConnection &pConn, const char *pTable, const char *pIntCol)
 Get maximum value from one of columns.
static std::string setSQLVal (const std::string &pVal)
 surround string by single quotes

Detailed Description

common SQL utilities

Member Function Documentation

static SQL createIN ( const std::set< std::string > &  pSet  )  [static]

Create IN clause from set of string values.

Parameters:
pSet list of values for in clause
Returns:
string with IN clause

static SQL createIN ( const std::vector< int > &  pSet  )  [static]

Create part of SQL SELECT for use with in clause.

Parameters:
pSet list of values for in clause
Returns:
string with IN clause

static SQL createIN ( const std::vector< id > &  pSet  )  [static]

Create part of SQL SELECT for use with in clause.

Parameters:
pSet list of values for in clause
Returns:
string with IN clause

static SQL createIN ( const std::set< int > &  pSet  )  [static]

Create IN clause from set of int values.

Parameters:
pSet list of values for in clause
Returns:
string with IN clause

static std::string escapeSQLData ( const std::string &  pData  )  [static]

Escape text string to conform SQL standard.

Parameters:
pData string to modify
Returns:
escaped string

static std::string escapeSQLLike ( const std::string &  pData  )  [static]

Escape string used for LIKE clause to conform SQL standard.

Parameters:
pData string to modify
Returns:
escaped string

static int getMax ( DbConnection &  pConn,
const char *  pTable,
const char *  pIntCol 
) [static]

Get maximum value from one of columns.

Parameters:
pConn pointer to open database connection
pTable name of table
pIntCol name of column
Returns:
fetched value

static std::string setSQLVal ( const std::string &  pVal  )  [static]

surround string by single quotes

Parameters:
pVal string to quote
Returns:
pVal with quotes

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

Documentation
Quick start
Examples

API Documentation
Class hierarchy
Member index
API Reference
Store filters
Store table macros
Back
Generated by doxygen at Fri Oct 22 23:15:46 2010