diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-02-25 22:24:53 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-02-25 22:24:53 +0000 |
| commit | a6be6d86457a0b5dc982a0d4c7128a510313506d (patch) | |
| tree | 1296ebbdfcd3f326013d2730e91be0c279cec0de /libpqpp/pq-modifycommand.cpp | |
| parent | Refactor to use std::string as buffer and increase test coverage (diff) | |
| download | libdbpp-postgresql-a6be6d86457a0b5dc982a0d4c7128a510313506d.tar.bz2 libdbpp-postgresql-a6be6d86457a0b5dc982a0d4c7128a510313506d.tar.xz libdbpp-postgresql-a6be6d86457a0b5dc982a0d4c7128a510313506d.zip | |
Reuse prepared statements
Diffstat (limited to 'libpqpp/pq-modifycommand.cpp')
| -rw-r--r-- | libpqpp/pq-modifycommand.cpp | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/libpqpp/pq-modifycommand.cpp b/libpqpp/pq-modifycommand.cpp index 4c4ca0c..e59908e 100644 --- a/libpqpp/pq-modifycommand.cpp +++ b/libpqpp/pq-modifycommand.cpp @@ -7,7 +7,7 @@ PQ::ModifyCommand::ModifyCommand(Connection * conn, const std::string & sql, uns DB::Command(sql), DB::ModifyCommand(sql), PQ::Command(conn, sql, no), - prepared(false) + hash(std::hash<std::string>()(sql)) { } @@ -15,24 +15,25 @@ PQ::ModifyCommand::~ModifyCommand() { } -void +PQ::Connection::PreparedStatements::const_iterator PQ::ModifyCommand::prepare() const { - if (!prepared) { - std::string psql; - psql.reserve(sql.length() + 20); - prepareSql(psql, sql); - c->checkResultFree(PQprepare( - c->conn, stmntName.c_str(), psql.c_str(), values.size(), NULL), PGRES_COMMAND_OK); - prepared = true; + auto i = c->preparedStatements.find(hash); + if (i != c->preparedStatements.end()) { + return i; } + std::string psql; + psql.reserve(sql.length() + 20); + prepareSql(psql, sql); + c->checkResultFree(PQprepare( + c->conn, stmntName.c_str(), psql.c_str(), values.size(), NULL), PGRES_COMMAND_OK); + return c->preparedStatements.insert({hash, stmntName}).first; } unsigned int PQ::ModifyCommand::execute(bool anc) { - prepare(); - PGresult * res = PQexecPrepared(c->conn, stmntName.c_str(), values.size(), &values.front(), &lengths.front(), NULL, 0); + PGresult * res = PQexecPrepared(c->conn, prepare()->second.c_str(), values.size(), &values.front(), &lengths.front(), NULL, 0); c->checkResult(res, PGRES_COMMAND_OK, PGRES_TUPLES_OK); unsigned int rows = atoi(PQcmdTuples(res)); PQclear(res); |