***********************
** FILE NAME : database.h
** SYSTEM NAME :
-** VERSION NUMBER : $Revision: 1.11 $
+** VERSION NUMBER : $Revision: 1.12 $
**
** DESCRIPTION : Classes to provide an abstract layer on the Gnucomo
** database.
/*****************************
$Log: database.h,v $
- Revision 1.11 2007-01-11 13:50:10 arjen
+ Revision 1.12 2011-03-24 10:21:43 arjen
+ Adjusted to new version of libpqxx.
+
+ Revision 1.11 2007/01/11 13:50:10 arjen
Experimental start of database OO abstraction layer.
Revision 1.10 2003/12/04 10:39:36 arjen
*****************************/
-/* static const char *RCSID = "$Id: database.h,v 1.11 2007-01-11 13:50:10 arjen Exp $"; */
+/* static const char *RCSID = "$Id: database.h,v 1.12 2011-03-24 10:21:43 arjen Exp $"; */
-#include <pqxx/connection.h>
-#include <pqxx/transaction.h>
-#include <pqxx/result.h>
+#include <pqxx/connection>
+#include <pqxx/transaction>
+#include <pqxx/result>
#include "gnucomo_config.h"
/*
class gnucomo_database
{
gnucomo_config *cfg;
- pqxx::Connection *dbconn;
- pqxx::Transaction *dbxact;
+ pqxx::connection *dbconn;
+ //pqxx::transaction<pqxx::serializable> *dbxact;
+ pqxx::work *dbxact;
- pqxx::Result last_result;
+ pqxx::result last_result;
public:
int Query(String qry)
{
-
- last_result = dbxact->Exec(qry);
+ try
+ {
+ last_result = dbxact->exec((char *)qry);
#ifdef DEBUG
std::cerr << "Query " << qry << " returned "
<< last_result.size() << " tuples.\n";
#endif
+ }
+ catch (const pqxx::pqxx_exception &e)
+ {
+ std::cerr << "Error in QUERY " << qry << ":\n";
+ std::cerr << e.base().what() << std::endl;
+ }
+
return last_result.size();
}
- pqxx::Result Result()
+ pqxx::result Result()
{
return last_result;
}
// The field value of a specific result.
- String Field(pqxx::Result res, int tuple, const char *fieldname)
+ String Field(pqxx::result res, int tuple, const char *fieldname)
{
return String(res[tuple][fieldname].c_str());
}