summaryrefslogtreecommitdiff
path: root/src/lib/pgsql/pgsql_connection.cc
AgeCommit message (Collapse)Author
2022-01-25[#2284] fixed indentation and spacesRazvan Becheriu
2022-01-25[#2284] Fixed asserts in PostgresSQL support codeThomas Markwalder
src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc Fixed an incorrect tagged statement src/lib/pgsql/pgsql_connection.* PgSqlConnection::executePreparedStatement() - new convenience function to executing prepared statements PgSqlConnection::selectQuery() PgSqlConnection::insertQuery() PgSqlConnection::updateDeleteQuery() - now calls executePreparedStatement() src/lib/pgsql/pgsql_exchange.cc PsqlBindArray::toText() - emits text for empty array src/lib/pgsql/tests/pgsql_connection_unittest.cc TEST_F(PgSqlConnectionTest, executePreparedStatement) - new test
2022-01-18[#95] Additional review commentsThomas Markwalder
src/hooks/dhcp/mysql_cb/mysql_cb_dhcp4.cc src/hooks/dhcp/mysql_cb/tests/mysql_cb_dhcp4_unittest.cc Commentary clean up src/lib/pgsql/pgsql_connection.cc src/lib/pgsql/tests/pgsql_connection_unittest.cc PgSqlConnection::createSavepoint() PgSqlConnection::rollbackToSavepoint() - now throw InvalidOperation instead Unexpected
2022-01-18[#95] Addressed initial review commentsThomas Markwalder
src/hooks/dhcp/pgsql_cb/pgsql_cb_impl.cc PgSqlConfigBackendImpl::createUpdateServer() - reworked to use savepoints. src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.cc src/hooks/dhcp/pgsql_cb/pgsql_query_macros_dhcp.h src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp4_unittest.cc src/lib/pgsql/tests/pgsql_exchange_unittest.cc minor clean up src/lib/database/db_log.* Added new log enums src/lib/database/db_messages.mes New log messages: DATABASE_PGSQL_CREATE_SAVEPOINT DATABASE_PGSQL_ROLLBACK_SAVEPOINT src/lib/pgsql/pgsql_connection.* PgSqlConnection::createSavepoint() PgSqlConnection::rollbackToSavepoint() PgSqlConnection::executeSQL() - new functions src/lib/pgsql/tests/pgsql_connection_unittest.cc TEST_F(PgSqlConnectionTest, savepoints) - new test
2022-01-18[#95] All Queries - CRUD for serversThomas Markwalder
src/hooks/dhcp/pgsql_cb/Makefile.am New files: pgsql_query_macros.h pgsql_cb_dhcp4.cc pgsql_cb_dhcp4.h src/hooks/dhcp/pgsql_cb/pgsql_cb_dhcp4.* Initial implementation - includes CRUD for servers src/hooks/dhcp/pgsql_cb/pgsql_cb_impl.* PgSqlConfigBackendImpl::getStatement() PgSqlConfigBackendImpl::selectQuery() PgSqlConfigBackendImpl::insertQuery() PgSqlConfigBackendImpl::updateDeleteQuery() PgSqlConfigBackendImpl::createAuditRevision() PgSqlConfigBackendImpl::getRecentAuditEntries() PgSqlConfigBackendImpl::deleteFromTable() PgSqlConfigBackendImpl::getLastInsertId() PgSqlConfigBackendImpl::createInputRelayBinding() PgSqlConfigBackendImpl::createOptionValueBinding() PgSqlConfigBackendImpl::getServer() PgSqlConfigBackendImpl::getServers() PgSqlConfigBackendImpl::createUpdateServer() PgSqlConfigBackendImpl::attachElementToServers() PgSqlConfigBackendImpl::addRelayBinding() PgSqlConfigBackendImpl::addOptionValueBinding() PgSqlConfigBackendImpl::addRequiredClassesBinding() PgSqlConfigBackendImpl::addOptionValueBinding() src/hooks/dhcp/pgsql_cb/pgsql_cb_messages.mes New messages src/hooks/dhcp/pgsql_cb/tests/Makefile.am New file:pgsql_cb_dhcp4_unittest.cc src/hooks/dhcp/pgsql_cb/tests/pgsql_cb_dhcp4_unittest.cc New file src/lib/config_backend/base_config_backend.h src/lib/config_backend/tests/config_backend_mgr_unittest.cc src/lib/database/backend_selector.h src/lib/database/backend_selector.cc src/lib/database/tests/backend_selector_unittest.cc "pgsql" -> "postgresql" BackendSelector::Type::PGSQL -> BackendSelector::Type::POSTGRESQL src/lib/pgsql/pgsql_connection.cc Added NULL_KEY PgSqlConnection::checkStatementError() - throws DuplicateEntry and NullKeyError src/lib/pgsql/pgsql_connection.h Added NULL_KEY Upped PGSQL_MAX_PARAMETERS_IN_QUERY to 128; src/lib/pgsql/pgsql_exchange.* PsqlBindArray::popBack() - new function Cleaned up AddOptional functions PsqlBindArray::add(const ConstElementPtr& value) - new
2022-01-06[#34] Chekpoint: added easy casesFrancis Dupont
2021-12-21[#2183] Transaction ref counts, addOptionalIntegerThomas Markwalder
src/lib/pgsql/pgsql_connection.* PgSqlConnection - added transaction reference counting PgSqlConnection::isTransactionStarted() - new function src/lib/pgsql/pgsql_exchange.* PsqlBindArray::toText(size_t index) - split out from toText(void) to permit single column value calls. PsqlbindArray addOptionalInteger(const util::Optional<T>& value) - new template function src/lib/pgsql/tests/pgsql_connection_unittest.cc TEST_F(PgSqlConnectionTest, transactions) - new test src/lib/pgsql/tests/pgsql_exchange_unittest.cc TEST(PsqlBindArray, addOptionalInteger) - new test
2021-12-21[#2183] Removed unecessary use of smart pointer in PgSqlConnectionThomas Markwalder
modified: src/lib/pgsql/pgsql_connection.cc
2021-12-21[#2183] Added query functions to PgSqlConnectionThomas Markwalder
src/lib/pgsql/pgsql_connection.cc PgSqlConnection::selectQuery() PgSqlConnection::insertQuery() PgSqlConnection::updateDeleteQuery() Moved PgSqlResult to pgsql_exchange.* src/lib/pgsql/tests/Makefile.am Added new files: pgsql_basics.h pgsql_connection_unittest.cc src/lib/pgsql/tests/pgsql_exchange_unittest.cc Extracted common components to pgqsql_basics.h src/lib/pgsql/tests/pgsql_basics.h New file that contains with common text fixture, PgSqlBasics, extracted from pgsql_exchange_unittest.cc src/lib/pgsql/tests/pgsql_connection_unittest.cc New file with unit tests for new PgSqlConnection functions
2021-08-16[#2025] simplify concatenating strings (minor)Andrei Pavel
2020-12-09[#1375] added IOService to mysql and postgresql connectionsRazvan Becheriu
2020-08-12[#1369] Addressed review commentsThomas Markwalder
2020-08-12[#1369] Fixed some minor postgresql issuesThomas Markwalder
2020-08-12[#1396] Implement CB connection recoveryThomas Markwalder
src/bin/dhcp4/ctrl_dhcp4_srv.cc ControlledDhcpv4Srv::dbReconnect() - added logic to reopen CB backends (if any configured) src/lib/database/database_connection.* Added DbConnectionUnusable exception DatabaseConnection - added: unusable_ marUnusable() checkUnusable() src/lib/mysql/mysql_connection.* MySqlConnection::checkError() - calls markUnusable() Added invocations of DatabaseConnection::checkUnusable() to functions using the connection src/lib/pgsql/pgsql_connection.cc PgSqlConnection::checkStatementError() - calls markUnusable()
2020-02-06[#1108] Servers execute shutdown on unrecoverable DBsThomas Markwalder
Added ChangeLog entry src/bin/dhcp4/ctrl_dhcp4_srv.* ControlledDhcpv4Srv::dbLostCallback() - schedules a shutdown once retries have been exhausted/disableld src/bin/dhcp6/ctrl_dhcp6_srv.* ControlledDhcpv6Srv::dbLostCallback() - schedules a shutdown once retries have been exhausted/disableld src/lib/database/database_connection.h class DbUnrecoverableError - new exception src/lib/mysql/mysql_connection.h MySqlConnection::check_error() - throws DbUnrecoverableError instead of calling exit() src/lib/pgsql/pgsql_connection.* PgSqlConnection::checkStatementError() - throws DbUnrecoverableError instead of calling exit()
2020-01-27[#1098] adjusted code for releaseMichal Nowikowski
- update copyright dates - prepare messages files - added release entry in ChangeLog file
2020-01-24[#1040] handle update and deleteRazvan Becheriu
2019-12-04[#1008] Changed getVersion for the host (vs lease) codeFrancis Dupont
2019-12-04[1008-move-database-schema-version-check-to-database-libraries] Moved ↵Francis Dupont
getVersion codes to databases
2018-09-03[#92,!13] Moved PgSqlConnection and PgSqlExchange to libkea-pgsql.Marcin Siodelski