17 #ifndef PostgreSQLInterface_H_
18 #define PostgreSQLInterface_H_
26 #include <PassiveTimer.h>
27 #include <DBInterface.h>
40 virtual bool nconnect(
const std::string& host,
const std::string& user,
41 const std::string& pswd,
const std::string& dbname,
42 unsigned int port = 5432)
override;
43 virtual bool close()
override;
44 virtual bool isConnection()
const override;
45 virtual bool ping()
const override;
47 virtual DBResult query(
const std::string& q )
override;
48 virtual const std::string lastQuery()
override;
50 virtual bool insert(
const std::string& q )
override;
51 bool insertAndSaveRowid(
const std::string& q );
52 virtual double insert_id()
override;
53 void save_inserted_id(
const pqxx::result& res );
55 typedef std::list<std::string> Record;
56 typedef std::vector<Record> Data;
59 bool copy(
const std::string& tblname,
const std::list<std::string>& cols,
const Data& data );
61 virtual const std::string error()
override;
67 void makeResult(
DBResult& dbres,
const pqxx::result& res );
68 std::shared_ptr<pqxx::connection> db;
71 double last_inserted_id;