SQL Class Reference

#include <sql.h>

List of all members.

Detailed Description

Parameters specification in SQL query are:

• :s - variable should be formated as SQL string, special chars will be escaped depending on if it is value to insert or data for SQL LIKE keyword.
• :d - variable should be formatted as integer
• :f - variable should be formatted as floating point number

You can escape ":" by putting double "::" in query.

Conversion between database type and C++ type is done using StoreableFilter instances. dba::SQLArchive has default mappings for all C++ types for which Debea provides filters. You can change those mappings using SQLArchive::mapType(). You can add new filters for other C++ types in the same way.

Use operator<< to feed query with parameter data from C++ variables, and into() to specify C++ variables where data read from database should written.

Some examples:

  //insert some data into table
  pAr.getOStream().sendUpdate(
    dba::SQL("INSERT INTO data(intval,strval) VALUES(:d,:s)") << 1 << "test"
  );

  //vars to put data in
  std::string strval;
  int intval;
  //and read inserted row
  std::auto_ptr<dba::DbResult> res(
    pAr.getIStream().sendQuery(dba::SQL("SELECT strval,intval FROM data").into(strval).into(intval))
  );

see Parameterized SQL statements for complete example.

Constructor & Destructor Documentation

Member Function Documentation

• sql.h