testsoci.cpp

#define SOCI_USE_BOOST

#include <boost-tuple.h>

#include <soci.h>
#include <postgresql/soci-postgresql.h>

using namespace soci;

/*
CREATE TABLE test_soci
(
col_int int,
col_str varchar(100)
);
*/

int main()
{

  typedef boost::tuple<int, std::string> row_test_soci;

  session sql(postgresql,
              "host=10.0.0.30 user=test password=test dbname=test");

  rowset< row_test_soci > rs = (
    sql.prepare << "SELECT col_int, col_str FROM TEST_SOCI"
    );

  for(rowset< row_test_soci >::const_iterator it = rs.begin();
      it != rs.end();
      ++it)
  {
    std::cout << "col_int: " << it->get<0>() << ", "
              << "col_str: " << it->get<1>() << std::endl;
  }

  return 0;

}