--- /srv/reproducible-results/rbuild-debian/r-b-build.f7v5hbWd/b1/libpqxx_7.9.1-2_i386.changes +++ /srv/reproducible-results/rbuild-debian/r-b-build.f7v5hbWd/b2/libpqxx_7.9.1-2_i386.changes ├── Files │ @@ -1,5 +1,5 @@ │ │ dde861e4704ea97fb81a2c8667125e3a 2270440 debug optional libpqxx-7.9-dbgsym_7.9.1-2_i386.deb │ d27ba071ce85217e6852692e09519a82 206540 libs optional libpqxx-7.9_7.9.1-2_i386.deb │ 1f2d4cf4f99f35130189d09c4451e839 375668 libdevel optional libpqxx-dev_7.9.1-2_i386.deb │ - 0aae110a995372e74682fd019450c1a5 2603020 doc optional libpqxx-doc_7.9.1-2_all.deb │ + 9a743f559247eb3677a51a978984aaba 2604700 doc optional libpqxx-doc_7.9.1-2_all.deb ├── libpqxx-doc_7.9.1-2_all.deb │ ├── file list │ │ @@ -1,3 +1,3 @@ │ │ -rw-r--r-- 0 0 0 4 2024-07-10 18:27:49.000000 debian-binary │ │ --rw-r--r-- 0 0 0 31976 2024-07-10 18:27:49.000000 control.tar.xz │ │ --rw-r--r-- 0 0 0 2570852 2024-07-10 18:27:49.000000 data.tar.xz │ │ +-rw-r--r-- 0 0 0 32020 2024-07-10 18:27:49.000000 control.tar.xz │ │ +-rw-r--r-- 0 0 0 2572488 2024-07-10 18:27:49.000000 data.tar.xz │ ├── control.tar.xz │ │ ├── control.tar │ │ │ ├── ./control │ │ │ │ @@ -1,13 +1,13 @@ │ │ │ │ Package: libpqxx-doc │ │ │ │ Source: libpqxx │ │ │ │ Version: 7.9.1-2 │ │ │ │ Architecture: all │ │ │ │ Maintainer: Debian PostgreSQL team │ │ │ │ -Installed-Size: 13312 │ │ │ │ +Installed-Size: 13361 │ │ │ │ Suggests: libpqxx-dev (>= 7.9.1-2) │ │ │ │ Section: doc │ │ │ │ Priority: optional │ │ │ │ Multi-Arch: foreign │ │ │ │ Homepage: https://github.com/jtv/libpqxx/ │ │ │ │ Description: C++ library to connect to PostgreSQL (documentation) │ │ │ │ C++ library to enable user programs to communicate with │ │ │ ├── ./md5sums │ │ │ │ ├── ./md5sums │ │ │ │ │┄ Files differ │ ├── data.tar.xz │ │ ├── data.tar │ │ │ ├── file list │ │ │ │ @@ -57,22 +57,22 @@ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 7476 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connecting-members.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 16230 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connecting.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 678 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connecting.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 27344 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connection-members.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 113472 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connection.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5513 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connection.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 29785 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator-members.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 62527 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 75521 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1037 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 734 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator__coll__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 7752 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator__coll__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 769 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator__inherit__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8763 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator__inherit__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 25117 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator-members.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 31660 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 37135 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1273 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1052 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator__coll__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 11447 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator__coll__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 776 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator__inherit__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8876 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator__inherit__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 20910 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__row__iterator-members.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 24738 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__row__iterator.html │ │ │ │ @@ -316,18 +316,18 @@ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 9532 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range-members.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 22537 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 643 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 10254 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range__bound-members.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 14961 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range__bound.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 618 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1range__bound.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19948 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1result-members.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 52421 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1result.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 62624 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1result.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 2267 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1result.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19732 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row-members.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 51379 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 60574 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1893 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 421 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row__coll__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 4514 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row__coll__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 753 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row__inherit__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8703 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row__inherit__graph.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 658 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1sql__error__coll__graph.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5836 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1sql__error__coll__graph.png │ │ │ │ @@ -385,15 +385,15 @@ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 9688 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/connection-sql__cursor_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8828 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/connection-stream__from_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8758 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/connection-stream__to_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 14179 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/connection-transaction_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 128127 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/connection_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 257528 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/conversions_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 59526 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/cursor_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 36027 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/datatypes.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 36021 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/datatypes.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 13979 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dbtransaction_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19448 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/deprecated.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5220 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dir_09456df80b5baeba1147d2b9ef5f002c.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 397 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dir_09456df80b5baeba1147d2b9ef5f002c_dep.map │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1838 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dir_09456df80b5baeba1147d2b9ef5f002c_dep.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 11099 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dir_3abbb4e2076021b5d2239498be5fcb30.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1544 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dir_3abbb4e2076021b5d2239498be5fcb30.js │ │ │ │ @@ -416,15 +416,15 @@ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 45631 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/doxygen.css │ │ │ │ -rw-r--r-- 0 root (0) root (0) 15461 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/doxygen.svg │ │ │ │ -rw-r--r-- 0 root (0) root (0) 7704 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/dynsections.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 11900 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/encoding__group_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 137794 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/encodings_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8272 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/errorhandler-connection_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 17748 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/errorhandler_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 9567 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/escaping.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 9569 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/escaping.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 144139 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/except_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 81786 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/field_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 25190 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/files.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 223 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/files_dup.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1996 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/folderclosed.svg │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1996 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/folderclosedd.svg │ │ │ │ -rw-r--r-- 0 root (0) root (0) 3269 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/folderopen.svg │ │ │ │ @@ -821,67 +821,67 @@ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 111 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/nav_hd.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 2167 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtree.css │ │ │ │ -rw-r--r-- 0 root (0) root (0) 15935 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtree.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5932 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreedata.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19176 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex0.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 21143 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex1.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19444 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex2.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 15188 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex3.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 15184 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex3.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 18077 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex4.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 17719 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex5.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 17723 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex5.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 271 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/navtreeindex6.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 13252 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/nontransaction_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 15955 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/notification_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 122 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/open.png │ │ │ │ -rw-r--r-- 0 root (0) root (0) 6420 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/pages.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 10844 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/parameters.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 10846 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/parameters.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 53070 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/params_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5810 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/performance.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 29854 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/pipeline_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 696 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/plus.svg │ │ │ │ -rw-r--r-- 0 root (0) root (0) 696 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/plusd.svg │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8892 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/pqxx-source_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 13309 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/prepared.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 13311 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/prepared.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 4859 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/prepared__statement_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 101843 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/range_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 5685 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/resize.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8659 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result-connection_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 10652 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result-creation_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8755 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result-pipeline_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8590 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result-sql__cursor_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 47760 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 30983 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result__iter_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 61623 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result__iterator_8hxx_source.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 49500 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result_8hxx_source.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 33088 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result__iter_8hxx_source.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 64819 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/result__iterator_8hxx_source.html │ │ │ │ -rw-r--r-- 0 root (0) root (0) 19458 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/robusttransaction_8hxx_source.html │ │ │ │ --rw-r--r-- 0 root (0) root (0) 90886 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/row_8hxx_source.html │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 95674 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/row_8hxx_source.html │ │ │ │ drwxr-xr-x 0 root (0) root (0) 0 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/ │ │ │ │ -rw-r--r-- 0 root (0) root (0) 7418 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_0.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 4742 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_1.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 6978 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_10.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 21004 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_11.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 7440 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_12.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 2857 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_13.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 21001 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_11.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 7434 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_12.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 2858 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_13.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 906 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_14.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1394 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_15.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 95 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_16.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 94 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_16.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1207 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_17.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 319 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_18.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 15181 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_2.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 4706 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_3.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 8727 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_4.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 6995 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_5.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 5454 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_6.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 15180 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_2.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 4707 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_3.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 8728 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_4.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 6996 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_5.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 5455 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_6.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1038 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_7.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 5821 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_8.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 5822 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_8.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 147 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_9.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 2860 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_a.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 2861 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_a.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1297 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_b.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 8996 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_c.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 8994 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_c.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 8813 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_d.js │ │ │ │ --rw-r--r-- 0 root (0) root (0) 6245 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_e.js │ │ │ │ +-rw-r--r-- 0 root (0) root (0) 6249 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_e.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 4374 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/all_f.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 875 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_0.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 1086 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_1.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 975 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_10.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 835 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_11.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 157 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_12.js │ │ │ │ -rw-r--r-- 0 root (0) root (0) 85 2024-07-10 18:27:49.000000 ./usr/share/doc/libpqxx-doc/doxygen-html/search/classes_13.js │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/accessing-results.html │ │ │ │ @@ -93,38 +93,38 @@ │ │ │ │
Accessing results and result rows
│ │ │ │ │ │ │ │
│ │ │ │

A query produces a result set consisting of rows, and each row consists of fields. There are several ways to receive this data.

│ │ │ │

The fields are "untyped." That is to say, libpqxx has no opinion on what their types are. The database sends the data in a very flexible textual format. When you read a field, you specify what type you want it to be, and libpqxx converts the text format to that type for you.

│ │ │ │

If a value does not conform to the format for the type you specify, the conversion fails. For example, if you have strings that all happen to contain numbers, you can read them as int. But if any of the values is empty, or it's null (for a type that doesn't support null), or it's some string that does not look like an integer, or it's too large, you can't convert it to int.

│ │ │ │

So usually, reading result data from the database means not just retrieving the data; it also means converting it to some target type.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Querying rows of data

│ │ │ │

The simplest way to query rows of data is to call one of a transaction's "query" functions, passing as template arguments the types of columns you want to get back (e.g. int, std::string, double, and so on) and as a regular argument the query itself.

│ │ │ │

You can then iterate over the result to go over the rows of data:

│ │ │ │
for (auto [id, value] :
│ │ │ │
tx.query<int, std::string>("SELECT id, name FROM item"))
│ │ │ │
{
│ │ │ │
std::cout << id << '\t' << value << '\n';
│ │ │ │
}
│ │ │ │

The "query" functions execute your query, load the complete result data from the database, and then as you iterate, convert each row it received to a tuple of C++ types that you indicated.

│ │ │ │

There are different query functions for querying any number of rows (query()); querying just one row of data as a std::tuple and throwing an error if there's more than one row (query1()); or querying

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Streaming rows

│ │ │ │

There's another way to go through the rows coming out of a query. It's usually easier and faster if there are a lot of rows, but there are drawbacks.

│ │ │ │

One, you start getting rows before all the data has come in from the database. That speeds things up, but what happens if you lose your network connection while transferring the data? Your application may already have processed some of the data before finding out that the rest isn't coming. If that is a problem for your application, streaming may not be the right choice.

│ │ │ │

Two, streaming only works for some types of query. The stream() function wraps your query in a PostgreSQL COPY command, and COPY only supports a few commands: SELECT, VALUES, or an INSERT, UPDATE, or DELETE with a RETURNING clause. See the COPY documentation here: [ https://www.postgresql.org/docs/current/sql-copy.html ](https://www.postgresql.org/docs/current/sql-copy.html).

│ │ │ │

Three, when you convert a field to a "view" type (such as std::string_view or pqxx::bytes_view), the view points to underlying data which only stays valid until you iterate to the next row or exit the loop. So if you want to use that data for longer than a single iteration of the streaming loop, you'll have to store it somewhere yourself.

│ │ │ │

Now for the good news. Streaming does make it very easy to query data and loop over it, and often faster than with the "query" or "exec" functions:

│ │ │ │
for (auto [id, name, x, y] :
│ │ │ │
tx.stream<int, std::string_view, float, float>(
│ │ │ │
"SELECT id, name, x, y FROM point"))
│ │ │ │
process(id + 1, "point-" + name, x * 10.0, y * 10.0);
│ │ │ │

The conversion to C++ types (here int, std::string_view, and two floats) is built into the function. You never even see row objects, field objects, iterators, or conversion methods. You just put in your query and you receive your data.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Results with metadata

│ │ │ │

Sometimes you want more from a query result than just rows of data. You may need to know right away how many rows of result data you received, or how many rows your UPDATE statement has affected, or the names of the columns, etc.

│ │ │ │

For that, use the transaction's "exec" query execution functions. Apart from a few exceptions, these return a pqxx::result object. A result is a container of pqxx::row objects, so you can iterate them as normal, or index them like you would index an array. Each row in turn is a container of pqxx::field, Each field holds a value, but doesn't know its type. You specify the type when you read the value.

│ │ │ │

For example, your code might do:

│ │ │ │
pqxx::result r = tx.exec("SELECT * FROM mytable");
│ │ │ │
for (auto const &row: r)
│ │ │ │
{
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/binary.html │ │ │ │ @@ -103,15 +103,15 @@ │ │ │ │
std::string hi{"Hello binary world"};
│ │ │ │
my_blob.write(pqxx::binary_cast(hi);
│ │ │ │
pqxx::binary_cast
bytes_view binary_cast(TYPE const &data)
Cast binary data to a type that libpqxx will recognise as binary.
Definition util.hxx:409
│ │ │ │

The other takes a pointer and a size:

│ │ │ │
char const greeting[] = "Hello binary world";
│ │ │ │
char const *hi = greeting;
│ │ │ │
my_blob.write(pqxx::binary_cast(hi, sizeof(greeting)));
│ │ │ │ -

│ │ │ │ +

│ │ │ │ Caveats

│ │ │ │

There are some restrictions on binary_cast that you must be aware of.

│ │ │ │

First, your data must of a type that gives us bytes. So: char, unsigned char, signed char, int8_t, uint8_t, or of course std::byte. You can't feed in a vector of double, or anything like that.

│ │ │ │

Second, the data must be laid out as a contiguous block in memory. If there's no std::data() implementation for your type, it's not suitable.

│ │ │ │

Third, binary_cast only constructs something like a std::string_view. It does not make a copy of your actual data. So, make sure that your data remains alive and in the same place while you're using it.

│ │ │ │
│ │ │ │ │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1basic__ilostream.html │ │ │ │ @@ -151,15 +151,15 @@ │ │ │ │  basic_ilostream (dbtransaction &t, oid o, largeobject::size_type buf_size=512) │ │ │ │  Create a basic_ilostream.
│ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │
template<typename CHAR = char, typename TRAITS = std::char_traits<CHAR>>
│ │ │ │ class pqxx::basic_ilostream< CHAR, TRAITS >

Input stream that gets its data from a large object.

│ │ │ │ -
Deprecated:
Access large objects directly using the blob class.
│ │ │ │ +
Deprecated:
Access large objects directly using the blob class.
│ │ │ │

This class worked like any other istream, but to read data from a large object. It supported all formatting and streaming operations of std::istream.

│ │ │ │

This functionality was considered too fragile and complex, so it has been replaced with a single, much simpler class.

│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ │ │ │ │

◆ basic_ilostream() [1/2]

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1basic__lostream.html │ │ │ │ @@ -151,15 +151,15 @@ │ │ │ │  basic_lostream (dbtransaction &t, oid o, largeobject::size_type buf_size=512) │ │ │ │  Create a basic_lostream.
│ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │
template<typename CHAR = char, typename TRAITS = std::char_traits<CHAR>>
│ │ │ │ class pqxx::basic_lostream< CHAR, TRAITS >

Stream that reads and writes a large object.

│ │ │ │ -
Deprecated:
Access large objects directly using the blob class.
│ │ │ │ +
Deprecated:
Access large objects directly using the blob class.
│ │ │ │

This worked like a std::iostream, but to read data from, or write data to, a large object. It supported all formatting and streaming operations of std::iostream.

│ │ │ │

This functionality was considered too fragile and complex, so it has been replaced with a single, much simpler class.

│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ │ │ │ │

◆ basic_lostream() [1/2]

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1basic__olostream.html │ │ │ │ @@ -151,15 +151,15 @@ │ │ │ │  basic_olostream (dbtransaction &t, oid o, largeobject::size_type buf_size=512) │ │ │ │  Create a basic_olostream.
│ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │
template<typename CHAR = char, typename TRAITS = std::char_traits<CHAR>>
│ │ │ │ class pqxx::basic_olostream< CHAR, TRAITS >

Output stream that writes data back to a large object.

│ │ │ │ -
Deprecated:
Access large objects directly using the blob class.
│ │ │ │ +
Deprecated:
Access large objects directly using the blob class.
│ │ │ │

This worked like any other ostream, but to write data to a large object. It supported all formatting and streaming operations of std::ostream.

│ │ │ │

This functionality was considered too fragile and complex, so it has been replaced with a single, much simpler class.

│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ │ │ │ │

◆ basic_olostream() [1/2]

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1connection.html │ │ │ │ @@ -1408,15 +1408,15 @@ │ │ │ │ ) │ │ │ │ & │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Set session variable, using SQL's SET command.

│ │ │ │ -
Deprecated:
To set a session variable, use set_session_var. To set a transaction-local variable, execute an SQL SET command.
│ │ │ │ +
Deprecated:
To set a session variable, use set_session_var. To set a transaction-local variable, execute an SQL SET command.
│ │ │ │
Warning
When setting a string value, you must escape and quote it first. Use the quote() function to do that.
│ │ │ │
│ │ │ │ This executes an SQL query, so do not get or set variables while a table stream or pipeline is active on the same connection.
│ │ │ │
Parameters
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__result__iterator.html │ │ │ │ @@ -128,298 +128,298 @@ │ │ │ │ │ │ │ │ │ │ │ │
[legend]
│ │ │ │
varVariable to set.
valueNew value for Var. This can be any SQL expression. If it's a string, be sure that it's properly escaped and quoted.
│ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │

│ │ │ │ Public Types

│ │ │ │ -using iterator_category = std::random_access_iterator_tag
iterator_category = std::random_access_iterator_tag
 
│ │ │ │ -using value_type = row const
value_type = row const
 
│ │ │ │ -using pointer = row const *
pointer = row const *
 
│ │ │ │ -using reference = row
reference = row
 
│ │ │ │ -using size_type = result_size_type
size_type = result_size_type
 
│ │ │ │ -using difference_type = result_difference_type
difference_type = result_difference_type
 
- Public Types inherited from pqxx::row
│ │ │ │ -using size_type = row_size_type
size_type = row_size_type
 
│ │ │ │ -using difference_type = row_difference_type
difference_type = row_difference_type
 
│ │ │ │ -using const_iterator = const_row_iterator
const_iterator = const_row_iterator
 
│ │ │ │ -using iterator = const_iterator
iterator = const_iterator
 
│ │ │ │ -using reference = field
reference = field
 
│ │ │ │ -using pointer = const_row_iterator
pointer = const_row_iterator
 
│ │ │ │ -using const_reverse_iterator = const_reverse_row_iterator
const_reverse_iterator = const_reverse_row_iterator
 
│ │ │ │ -using reverse_iterator = const_reverse_iterator
reverse_iterator = const_reverse_iterator
 
│ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +pointer  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ +row &  │ │ │ │ │ │ │ │ │ │ │ │ +row &  │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +constexpr size_type  │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ - │ │ │ │ - │ │ │ │ + │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE bool  │ │ │ │ │ │ │ │ │ │ │ │

│ │ │ │ Public Member Functions

│ │ │ │ - const_result_iterator () noexcept=default
const_result_iterator () noexcept=default
 Create an iterator, but in an unusable state.
 
│ │ │ │ - const_result_iterator (const_result_iterator const &) noexcept=default
const_result_iterator (const_result_iterator const &) noexcept=default
 Copy an iterator.
 
│ │ │ │ - const_result_iterator (const_result_iterator &&) noexcept=default
const_result_iterator (const_result_iterator &&) noexcept=default
 Move an iterator.
 
│ │ │ │ - const_result_iterator (row const &t) noexcept
const_result_iterator (row const &t) noexcept
 Begin iterating a row.
 
Dereferencing operators

An iterator "points to" its own row, which is also itself. This makes it easy to address a result as a two-dimensional container, without going through the intermediate step of dereferencing the iterator. It makes the interface similar to C pointer/array semantics.

│ │ │ │

IIRC Alex Stepanov, the inventor of the STL, once remarked that having this as standard behaviour for pointers would be useful in some algorithms. So even if this makes me look foolish, I would seem to be in distinguished company.

│ │ │ │
│ │ │ │ -pointer operator-> () const
operator-> () const
 Dereference the iterator.
 
│ │ │ │ -reference operator* () const
operator* () const
 Dereference the iterator.
 
Manipulations
│ │ │ │ -const_result_iterator & operator= (const_result_iterator const &rhs)
operator= (const_result_iterator const &rhs)
 
│ │ │ │ -const_result_iterator & operator= (const_result_iterator &&rhs)
operator= (const_result_iterator &&rhs)
 
│ │ │ │ -const_result_iterator operator++ (int) &
operator++ (int) &
 
│ │ │ │ const_result_iterator & operator++ ()
 
│ │ │ │ -const_result_iterator operator-- (int) &
operator-- (int) &
 
│ │ │ │ const_result_iterator & operator-- ()
 
│ │ │ │ -const_result_iterator & operator+= (difference_type i)
operator+= (difference_type i)
 
│ │ │ │ -const_result_iterator & operator-= (difference_type i)
operator-= (difference_type i)
 
│ │ │ │ -void swap (const_result_iterator &other) noexcept
swap (const_result_iterator &other) noexcept
 Interchange two iterators in an exception-safe manner.
 
Comparisons
│ │ │ │ -bool operator== (const_result_iterator const &i) const
operator== (const_result_iterator const &i) const
 
│ │ │ │ -bool operator!= (const_result_iterator const &i) const
operator!= (const_result_iterator const &i) const
 
│ │ │ │ -bool operator< (const_result_iterator const &i) const
operator< (const_result_iterator const &i) const
 
│ │ │ │ -bool operator<= (const_result_iterator const &i) const
operator<= (const_result_iterator const &i) const
 
│ │ │ │ -bool operator> (const_result_iterator const &i) const
operator> (const_result_iterator const &i) const
 
│ │ │ │ -bool operator>= (const_result_iterator const &i) const
operator>= (const_result_iterator const &i) const
 
Field access
│ │ │ │ -reference back () const noexcept
back () const noexcept
 
│ │ │ │ -reference front () const noexcept
front () const noexcept
 
│ │ │ │ -reference at (size_type) const
at (size_type) const
 
reference at (zview col_name) const
reference at (zview col_name) const
 
│ │ │ │ -constexpr result::size_type rownumber () const noexcept
rownumber () const noexcept
 Row number, assuming this is a real row and not end()/rend().
 
- Public Member Functions inherited from pqxx::row
│ │ │ │ - row (row &&) noexcept=default
row (row &&) noexcept=default
 
│ │ │ │ - row (row const &) noexcept=default
row (row const &) noexcept=default
 
│ │ │ │ -row & operator= (row const &) noexcept=default
operator= (row const &) noexcept=default
 
│ │ │ │ -row & operator= (row &&) noexcept=default
operator= (row &&) noexcept=default
 
│ │ │ │ -PQXX_PURE bool operator== (row const &) const noexcept
operator== (row const &) const noexcept
 
│ │ │ │ -bool operator!= (row const &rhs) const noexcept
operator!= (row const &rhs) const noexcept
 
│ │ │ │ -const_iterator begin () const noexcept
begin () const noexcept
 
│ │ │ │ -const_iterator cbegin () const noexcept
cbegin () const noexcept
 
│ │ │ │ -const_iterator end () const noexcept
end () const noexcept
 
│ │ │ │ -const_iterator cend () const noexcept
cend () const noexcept
 
│ │ │ │ -reference front () const noexcept
front () const noexcept
 
│ │ │ │ -reference back () const noexcept
back () const noexcept
 
│ │ │ │ -const_reverse_row_iterator rbegin () const noexcept
rbegin () const noexcept
 
│ │ │ │ -const_reverse_row_iterator crbegin () const noexcept
crbegin () const noexcept
 
│ │ │ │ -const_reverse_row_iterator rend () const noexcept
rend () const noexcept
 
│ │ │ │ -const_reverse_row_iterator crend () const noexcept
crend () const noexcept
 
│ │ │ │ -reference operator[] (size_type) const noexcept
operator[] (size_type) const noexcept
 
reference operator[] (zview col_name) const
reference operator[] (zview col_name) const
 
│ │ │ │ -reference at (size_type) const
at (size_type) const
 
reference at (zview col_name) const
reference at (zview col_name) const
 
│ │ │ │ -constexpr size_type size () const noexcept
size () const noexcept
 
│ │ │ │ -constexpr result::size_type rownumber () const noexcept
rownumber () const noexcept
 Row number, assuming this is a real row and not end()/rend().
 
│ │ │ │ -size_type column_number (zview col_name) const
column_number (zview col_name) const
 Number of given column (throws exception if it doesn't exist).
 
│ │ │ │ -oid column_type (size_type) const
column_type (size_type) const
 Return a column's type.
 
│ │ │ │ -oid column_type (zview col_name) const
column_type (zview col_name) const
 Return a column's type.
 
│ │ │ │ -oid column_table (size_type col_num) const
column_table (size_type col_num) const
 What table did this column come from?
 
│ │ │ │ -oid column_table (zview col_name) const
column_table (zview col_name) const
 What table did this column come from?
 
size_type table_column (size_type) const
size_type table_column (size_type) const
 What column number in its table did this result column come from?
 
│ │ │ │ -size_type table_column (zview col_name) const
table_column (zview col_name) const
 What column number in its table did this result column come from?
 
│ │ │ │ -constexpr result::size_type num () const noexcept
num () const noexcept
 
template<typename Tuple >
void to (Tuple &t) const
template<typename Tuple >
void to (Tuple &t) const
 Extract entire row's values into a tuple.
 
template<typename... TYPE>
std::tuple< TYPE... > as () const
std::tuple< TYPE... > as () const
 Extract entire row's values into a tuple.
 
│ │ │ │ -void swap (row &) noexcept
swap (row &) noexcept
 
row slice (size_type sbegin, size_type send) const
row slice (size_type sbegin, size_type send) const
 
│ │ │ │ -PQXX_PURE bool empty () const noexcept
empty () const noexcept
 Is this a row without fields? Can only happen to a slice.
 
│ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +difference_type  │ │ │ │ │ │ │ │

Arithmetic operators

│ │ │ │ -class pqxx::result
pqxx::result
 
│ │ │ │ -const_result_iterator operator+ (difference_type, const_result_iterator const &)
operator+ (difference_type, const_result_iterator const &)
 
│ │ │ │ -const_result_iterator operator+ (difference_type) const
operator+ (difference_type) const
 
│ │ │ │ -const_result_iterator operator- (difference_type) const
operator- (difference_type) const
 
│ │ │ │ -difference_type operator- (const_result_iterator const &) const
operator- (const_result_iterator const &) const
 
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ - │ │ │ │ + │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ +template<typenameTuple > │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├── html2text {} │ │ │ │ │ @@ -9,234 +9,234 @@ │ │ │ │ │ [+]Inheritance diagram for pqxx::const_result_iterator: │ │ │ │ │ [Inheritance graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ [+]Collaboration diagram for pqxx::const_result_iterator: │ │ │ │ │ [Collaboration graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ PPuubblliicc TTyyppeess │ │ │ │ │ -using  iitteerraattoorr__ccaatteeggoorryy = std::random_access_iterator_tag │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr__ccaatteeggoorryy = std::random_access_iterator_tag │ │ │ │ │   │ │ │ │ │ -using  vvaalluuee__ttyyppee = _r_o_w const │ │ │ │ │ +_u_s_i_n_g  vvaalluuee__ttyyppee = _r_o_w _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -using  ppooiinntteerr = _r_o_w const * │ │ │ │ │ +_u_s_i_n_g  ppooiinntteerr = _r_o_w _c_o_n_s_t * │ │ │ │ │   │ │ │ │ │ -using  rreeffeerreennccee = _r_o_w │ │ │ │ │ +_u_s_i_n_g  rreeffeerreennccee = _r_o_w │ │ │ │ │   │ │ │ │ │ -using  ssiizzee__ttyyppee = _r_e_s_u_l_t___s_i_z_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ssiizzee__ttyyppee = _r_e_s_u_l_t___s_i_z_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ [-] Public Types inherited from _p_q_x_x_:_:_r_o_w │ │ │ │ │ -using  ssiizzee__ttyyppee = _r_o_w___s_i_z_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ssiizzee__ttyyppee = _r_o_w___s_i_z_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ddiiffffeerreennccee__ttyyppee = _r_o_w___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ddiiffffeerreennccee__ttyyppee = _r_o_w___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  rreeffeerreennccee = _f_i_e_l_d │ │ │ │ │ +_u_s_i_n_g  rreeffeerreennccee = _f_i_e_l_d │ │ │ │ │   │ │ │ │ │ -using  ppooiinntteerr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ppooiinntteerr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ PPuubblliicc MMeemmbbeerr FFuunnccttiioonnss │ │ │ │ │ -   ccoonnsstt__rreessuulltt__iitteerraattoorr () noexcept=default │ │ │ │ │ +   ccoonnsstt__rreessuulltt__iitteerraattoorr () _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   Create an iterator, but in an unusable state. │ │ │ │ │   │ │ │ │ │ -   ccoonnsstt__rreessuulltt__iitteerraattoorr (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &) noexcept=default │ │ │ │ │ +   ccoonnsstt__rreessuulltt__iitteerraattoorr (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   Copy an iterator. │ │ │ │ │   │ │ │ │ │   ccoonnsstt__rreessuulltt__iitteerraattoorr (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &&) │ │ │ │ │ - noexcept=default │ │ │ │ │ + _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   Move an iterator. │ │ │ │ │   │ │ │ │ │ -   ccoonnsstt__rreessuulltt__iitteerraattoorr (_r_o_w const &t) noexcept │ │ │ │ │ +   ccoonnsstt__rreessuulltt__iitteerraattoorr (_r_o_w _c_o_n_s_t &_t) _n_o_e_x_c_e_p_t │ │ │ │ │   Begin iterating a _r_o_w. │ │ │ │ │   │ │ │ │ │ Dereferencing operators │ │ │ │ │ An iterator "points to" its own row, which is also itself. This makes it easy │ │ │ │ │ to address a _r_e_s_u_l_t as a two-dimensional container, without going through the │ │ │ │ │ intermediate step of dereferencing the iterator. It makes the interface similar │ │ │ │ │ to C pointer/array semantics. │ │ │ │ │ IIRC Alex Stepanov, the inventor of the STL, once remarked that having this as │ │ │ │ │ standard behaviour for pointers would be useful in some algorithms. So even if │ │ │ │ │ this makes me look foolish, I would seem to be in distinguished company. │ │ │ │ │ - pointer  ooppeerraattoorr-->> () const │ │ │ │ │ + _p_o_i_n_t_e_r  ooppeerraattoorr-->> () _c_o_n_s_t │ │ │ │ │   Dereference the iterator. │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ooppeerraattoorr** () const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ooppeerraattoorr** () _c_o_n_s_t │ │ │ │ │   Dereference the iterator. │ │ │ │ │   │ │ │ │ │ Manipulations │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &rhs) │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_r_h_s) │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &&rhs) │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &&_r_h_s) │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++++ (int) & │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++++ (_i_n_t) & │ │ │ │ │   │ │ │ │ │ _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++++ () │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr---- (int) & │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr---- (_i_n_t) & │ │ │ │ │   │ │ │ │ │ _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr---- () │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++== (difference_type i) │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++== (difference_type _i) │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr--== (difference_type i) │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr--== (difference_type _i) │ │ │ │ │   │ │ │ │ │ - void  sswwaapp (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &other) noexcept │ │ │ │ │ + _v_o_i_d  sswwaapp (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r &_o_t_h_e_r) _n_o_e_x_c_e_p_t │ │ │ │ │   Interchange two iterators in an exception-safe │ │ │ │ │ manner. │ │ │ │ │   │ │ │ │ │ Comparisons │ │ │ │ │ - bool  ooppeerraattoorr==== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr==== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr!!== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr!!== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr<< (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr<< (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr<<== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr<<== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr>> (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr>> (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr>>== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &i) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr>>== (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ Field access │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  bbaacckk () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  bbaacckk () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ffrroonntt () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ffrroonntt () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  aatt (size_type) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  aatt (size_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -constexpr result::size_type  rroowwnnuummbbeerr () const noexcept │ │ │ │ │ +_c_o_n_s_t_e_x_p_r result::size_type  rroowwnnuummbbeerr () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Row number, assuming this is a real row and not │ │ │ │ │ end()/rend(). │ │ │ │ │   │ │ │ │ │ [-] Public Member Functions inherited from _p_q_x_x_:_:_r_o_w │ │ │ │ │ -   rrooww (_r_o_w &&) noexcept=default │ │ │ │ │ +   rrooww (_r_o_w &&) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ -   rrooww (_r_o_w const &) noexcept=default │ │ │ │ │ +   rrooww (_r_o_w _c_o_n_s_t &) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - _r_o_w &  ooppeerraattoorr== (_r_o_w const &) noexcept=default │ │ │ │ │ + _r_o_w &  ooppeerraattoorr== (_r_o_w _c_o_n_s_t &) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - _r_o_w &  ooppeerraattoorr== (_r_o_w &&) noexcept=default │ │ │ │ │ + _r_o_w &  ooppeerraattoorr== (_r_o_w &&) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - PQXX_PURE bool  ooppeerraattoorr==== (_r_o_w const &) const noexcept │ │ │ │ │ + PQXX_PURE _b_o_o_l  ooppeerraattoorr==== (_r_o_w _c_o_n_s_t &) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr!!== (_r_o_w const &rhs) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr!!== (_r_o_w _c_o_n_s_t &_r_h_s) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ffrroonntt () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ffrroonntt () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  bbaacckk () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  bbaacckk () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rrbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rrbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rreenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rreenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrreenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrreenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ooppeerraattoorr[[]] (size_type) const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ooppeerraattoorr[[]] (size_type) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _o_p_e_r_a_t_o_r_[_] (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _o_p_e_r_a_t_o_r_[_] (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  aatt (size_type) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  aatt (size_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - constexpr size_type  ssiizzee () const noexcept │ │ │ │ │ + _c_o_n_s_t_e_x_p_r size_type  ssiizzee () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ -constexpr result::size_type  rroowwnnuummbbeerr () const noexcept │ │ │ │ │ +_c_o_n_s_t_e_x_p_r result::size_type  rroowwnnuummbbeerr () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Row number, assuming this is a real row and not │ │ │ │ │ end()/rend(). │ │ │ │ │   │ │ │ │ │ - size_type  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w col_name) const │ │ │ │ │ + size_type  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   Number of given column (throws exception if it │ │ │ │ │ doesn't exist). │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (size_type) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (size_type) _c_o_n_s_t │ │ │ │ │   Return a column's type. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   Return a column's type. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (size_type col_num) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (size_type _c_o_l___n_u_m) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - size_type  _t_a_b_l_e___c_o_l_u_m_n (size_type) const │ │ │ │ │ + size_type  _t_a_b_l_e___c_o_l_u_m_n (size_type) _c_o_n_s_t │ │ │ │ │   What column number in its table did this result │ │ │ │ │ column come from? │ │ │ │ │   │ │ │ │ │ - size_type  ttaabbllee__ccoolluummnn (_z_v_i_e_w col_name) const │ │ │ │ │ + size_type  ttaabbllee__ccoolluummnn (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What column number in its table did this result │ │ │ │ │ column come from? │ │ │ │ │   │ │ │ │ │ -constexpr result::size_type  nnuumm () const noexcept │ │ │ │ │ +_c_o_n_s_t_e_x_p_r result::size_type  nnuumm () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - void  _t_o (Tuple &t) const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_u_p_l_e > │ │ │ │ │ + _v_o_i_d  _t_o (_T_u_p_l_e &_t) _c_o_n_s_t │ │ │ │ │   Extract entire row's values into a tuple. │ │ │ │ │   │ │ │ │ │ template │ │ │ │ │ - std::tuple< TYPE... >  _a_s () const │ │ │ │ │ + std::tuple< TYPE... >  _a_s () _c_o_n_s_t │ │ │ │ │   Extract entire row's values into a tuple. │ │ │ │ │   │ │ │ │ │ - void  sswwaapp (_r_o_w &) noexcept │ │ │ │ │ + _v_o_i_d  sswwaapp (_r_o_w &) _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_o_w  _s_l_i_c_e (size_type sbegin, size_type send) const │ │ │ │ │ + _r_o_w  _s_l_i_c_e (size_type _s_b_e_g_i_n, size_type _s_e_n_d) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - PQXX_PURE bool  eemmppttyy () const noexcept │ │ │ │ │ + PQXX_PURE _b_o_o_l  eemmppttyy () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Is this a row without fields? Can only happen to a │ │ │ │ │ slice. │ │ │ │ │   │ │ │ │ │ ********** AArriitthhmmeettiicc ooppeerraattoorrss ********** │ │ │ │ │ - class  ppqqxxxx::::rreessuulltt │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::rreessuulltt │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type, _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ +_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type, _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ &) │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type) const │ │ │ │ │ +_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type) const │ │ │ │ │ +_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &) const │ │ │ │ │ + difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ AAddddiittiioonnaall IInnhheerriitteedd MMeemmbbeerrss │ │ │ │ │ [-] Protected Member Functions inherited from _p_q_x_x_:_:_r_o_w │ │ │ │ │ -   _r_o_w (_r_e_s_u_l_t const &r, _r_e_s_u_l_t___s_i_z_e___t_y_p_e index, size_type │ │ │ │ │ - cols) noexcept │ │ │ │ │ +   _r_o_w (_r_e_s_u_l_t _c_o_n_s_t &_r, _r_e_s_u_l_t___s_i_z_e___t_y_p_e index, size_type │ │ │ │ │ + _c_o_l_s) _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - void  cchheecckk__ssiizzee (size_type expected) const │ │ │ │ │ + _v_o_i_d  cchheecckk__ssiizzee (size_type _e_x_p_e_c_t_e_d) _c_o_n_s_t │ │ │ │ │   Throw _u_s_a_g_e___e_r_r_o_r if row size is not expected. │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - TUPLE  _a_s___t_u_p_l_e () const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_U_P_L_E > │ │ │ │ │ + _T_U_P_L_E  _a_s___t_u_p_l_e () _c_o_n_s_t │ │ │ │ │   Convert to a given tuple of values, don't check sizes. │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - void  ccoonnvveerrtt (Tuple &t) const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_u_p_l_e > │ │ │ │ │ + _v_o_i_d  ccoonnvveerrtt (_T_u_p_l_e &_t) _c_o_n_s_t │ │ │ │ │   Convert entire row to tuple fields, without checking row │ │ │ │ │ size. │ │ │ │ │   │ │ │ │ │ [-] Protected Attributes inherited from _p_q_x_x_:_:_r_o_w │ │ │ │ │ _r_e_s_u_l_t  mm__rreessuulltt │ │ │ │ │   Result set of which this is one row. │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1const__reverse__result__iterator.html │ │ │ │ @@ -130,141 +130,141 @@ │ │ │ │ │ │ │ │ │ │ │ │
[legend]
│ │ │ │

│ │ │ │ Additional Inherited Members

- Protected Member Functions inherited from pqxx::row
 row (result const &r, result_size_type index, size_type cols) noexcept
 row (result const &r, result_size_type index, size_type cols) noexcept
 
│ │ │ │ -void check_size (size_type expected) const
check_size (size_type expected) const
 Throw usage_error if row size is not expected.
 
template<typename TUPLE >
TUPLE as_tuple () const
template<typename TUPLE >
TUPLE as_tuple () const
 Convert to a given tuple of values, don't check sizes.
 
│ │ │ │ -template<typename Tuple >
void convert (Tuple &t) const
void convert (Tuple &t) const
 Convert entire row to tuple fields, without checking row size.
 
- Protected Attributes inherited from pqxx::row
│ │ │ │ result m_result
 Result set of which this is one row.
 
│ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │

│ │ │ │ Public Types

│ │ │ │ -using super = const_result_iterator
super = const_result_iterator
 
│ │ │ │ -using iterator_type = const_result_iterator
iterator_type = const_result_iterator
 
│ │ │ │ -using value_type = iterator_type::value_type
value_type = iterator_type::value_type
 
│ │ │ │ -using reference = iterator_type::reference
reference = iterator_type::reference
 
│ │ │ │ -using difference_type = result_difference_type
difference_type = result_difference_type
 
│ │ │ │ -using iterator_category = std::random_access_iterator_tag
iterator_category = std::random_access_iterator_tag
 
│ │ │ │ -using pointer = row const *
pointer = row const *
 
│ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator &  │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +difference_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_result_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +difference_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ │ │ │ │

│ │ │ │ Public Member Functions

│ │ │ │ - const_reverse_result_iterator ()=default
const_reverse_result_iterator ()=default
 Create an iterator, but in an unusable state.
 
│ │ │ │ - const_reverse_result_iterator (const_reverse_result_iterator const &rhs)=default
const_reverse_result_iterator (const_reverse_result_iterator const &rhs)=default
 Copy an iterator.
 
│ │ │ │ - const_reverse_result_iterator (const_result_iterator const &rhs)
const_reverse_result_iterator (const_result_iterator const &rhs)
 Copy a reverse iterator from a regular iterator.
 
│ │ │ │ - const_reverse_result_iterator (const_result_iterator const &&rhs)
const_reverse_result_iterator (const_result_iterator const &&rhs)
 Move a regular iterator into a reverse iterator.
 
│ │ │ │ -PQXX_PURE const_result_iterator base () const noexcept
base () const noexcept
 Return the underlying "regular" iterator (as per standard library).
 
Manipulations
│ │ │ │ -const_reverse_result_iterator & operator= (const_reverse_result_iterator const &r)
operator= (const_reverse_result_iterator const &r)
 
│ │ │ │ -const_reverse_result_iterator & operator= (const_reverse_result_iterator &&r)
operator= (const_reverse_result_iterator &&r)
 
│ │ │ │ const_reverse_result_iterator & operator++ ()
 
│ │ │ │ -const_reverse_result_iterator operator++ (int) &
operator++ (int) &
 
│ │ │ │ const_reverse_result_iterator & operator-- ()
 
│ │ │ │ -const_reverse_result_iterator operator-- (int) &
operator-- (int) &
 
│ │ │ │ -const_reverse_result_iterator & operator+= (difference_type i)
operator+= (difference_type i)
 
│ │ │ │ -const_reverse_result_iterator & operator-= (difference_type i)
operator-= (difference_type i)
 
│ │ │ │ -void swap (const_reverse_result_iterator &other) noexcept
swap (const_reverse_result_iterator &other) noexcept
 
Arithmetic operators
│ │ │ │ -const_reverse_result_iterator operator+ (difference_type i) const
operator+ (difference_type i) const
 
│ │ │ │ -const_reverse_result_iterator operator- (difference_type i)
operator- (difference_type i)
 
│ │ │ │ -difference_type operator- (const_reverse_result_iterator const &rhs) const
operator- (const_reverse_result_iterator const &rhs) const
 
Comparisons
│ │ │ │ -bool operator== (const_reverse_result_iterator const &rhs) const noexcept
operator== (const_reverse_result_iterator const &rhs) const noexcept
 
│ │ │ │ -bool operator!= (const_reverse_result_iterator const &rhs) const noexcept
operator!= (const_reverse_result_iterator const &rhs) const noexcept
 
│ │ │ │ -bool operator< (const_reverse_result_iterator const &rhs) const
operator< (const_reverse_result_iterator const &rhs) const
 
│ │ │ │ -bool operator<= (const_reverse_result_iterator const &rhs) const
operator<= (const_reverse_result_iterator const &rhs) const
 
│ │ │ │ -bool operator> (const_reverse_result_iterator const &rhs) const
operator> (const_reverse_result_iterator const &rhs) const
 
│ │ │ │ -bool operator>= (const_reverse_result_iterator const &rhs) const
operator>= (const_reverse_result_iterator const &rhs) const
 
Dereferencing operators
│ │ │ │ -const_result_iterator operator- (difference_type) const
operator- (difference_type) const
 Dereference iterator.
 
│ │ │ │ -difference_type operator- (const_result_iterator const &) const
operator- (const_result_iterator const &) const
 Dereference iterator.
 
│ │ │ │ -reference operator* () const
operator* () const
 Dereference iterator.
 
Field access
│ │ │ │ -reference back () const noexcept
back () const noexcept
 
│ │ │ │ -reference front () const noexcept
front () const noexcept
 
│ │ │ │ -reference at (size_type) const
at (size_type) const
 
reference at (zview col_name) const
reference at (zview col_name) const
 
│ │ │ │ -constexpr result::size_type rownumber () const noexcept
rownumber () const noexcept
 Row number, assuming this is a real row and not end()/rend().
 
│ │ │ │

Detailed Description

│ │ │ │

Reverse iterator for result. Use as result::const_reverse_iterator.

│ │ │ │

Member Function Documentation

│ │ │ │ │ │ │ │ ├── html2text {} │ │ │ │ │ @@ -9,120 +9,120 @@ │ │ │ │ │ [+]Inheritance diagram for pqxx::const_reverse_result_iterator: │ │ │ │ │ [Inheritance graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ [+]Collaboration diagram for pqxx::const_reverse_result_iterator: │ │ │ │ │ [Collaboration graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ PPuubblliicc TTyyppeess │ │ │ │ │ -using  ssuuppeerr = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ssuuppeerr = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  iitteerraattoorr__ttyyppee = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr__ttyyppee = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  vvaalluuee__ttyyppee = iterator_type::value_type │ │ │ │ │ +_u_s_i_n_g  vvaalluuee__ttyyppee = _i_t_e_r_a_t_o_r___t_y_p_e_:_:_v_a_l_u_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  rreeffeerreennccee = _i_t_e_r_a_t_o_r___t_y_p_e_:_:_r_e_f_e_r_e_n_c_e │ │ │ │ │ +_u_s_i_n_g  rreeffeerreennccee = _i_t_e_r_a_t_o_r___t_y_p_e_:_:_r_e_f_e_r_e_n_c_e │ │ │ │ │   │ │ │ │ │ -using  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  iitteerraattoorr__ccaatteeggoorryy = std::random_access_iterator_tag │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr__ccaatteeggoorryy = std::random_access_iterator_tag │ │ │ │ │   │ │ │ │ │ -using  ppooiinntteerr = _r_o_w const * │ │ │ │ │ +_u_s_i_n_g  ppooiinntteerr = _r_o_w _c_o_n_s_t * │ │ │ │ │   │ │ │ │ │ PPuubblliicc MMeemmbbeerr FFuunnccttiioonnss │ │ │ │ │ -   ccoonnsstt__rreevveerrssee__rreessuulltt__iitteerraattoorr ()=default │ │ │ │ │ +   ccoonnsstt__rreevveerrssee__rreessuulltt__iitteerraattoorr ()=_d_e_f_a_u_l_t │ │ │ │ │   Create an iterator, but in an unusable state. │ │ │ │ │   │ │ │ │ │   ccoonnsstt__rreevveerrssee__rreessuulltt__iitteerraattoorr │ │ │ │ │ - (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &rhs)=default │ │ │ │ │ + (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &_r_h_s)=_d_e_f_a_u_l_t │ │ │ │ │   Copy an iterator. │ │ │ │ │   │ │ │ │ │   ccoonnsstt__rreevveerrssee__rreessuulltt__iitteerraattoorr │ │ │ │ │ - (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &rhs) │ │ │ │ │ + (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &_r_h_s) │ │ │ │ │   Copy a reverse iterator from a regular │ │ │ │ │ iterator. │ │ │ │ │   │ │ │ │ │   ccoonnsstt__rreevveerrssee__rreessuulltt__iitteerraattoorr │ │ │ │ │ - (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &&rhs) │ │ │ │ │ + (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &&_r_h_s) │ │ │ │ │   Move a regular iterator into a reverse │ │ │ │ │ iterator. │ │ │ │ │   │ │ │ │ │ -PQXX_PURE _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  bbaassee () const noexcept │ │ │ │ │ +PQXX_PURE _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  bbaassee () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Return the underlying "regular" iterator (as │ │ │ │ │ per standard library). │ │ │ │ │   │ │ │ │ │ Manipulations │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &r) │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &_r) │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &&r) │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &&_r) │ │ │ │ │   │ │ │ │ │ _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++++ () │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++++ (int) & │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++++ (_i_n_t) & │ │ │ │ │   │ │ │ │ │ _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr---- () │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr---- (int) & │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr---- (_i_n_t) & │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++== (difference_type i) │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr++== (difference_type _i) │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr--== (difference_type i) │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &  ooppeerraattoorr--== (difference_type _i) │ │ │ │ │   │ │ │ │ │ - void  sswwaapp (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &other) │ │ │ │ │ - noexcept │ │ │ │ │ + _v_o_i_d  sswwaapp (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r &_o_t_h_e_r) │ │ │ │ │ + _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ Arithmetic operators │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type i) const │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr++ (difference_type _i) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type i) │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type _i) │ │ │ │ │   │ │ │ │ │ - difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &rhs) const │ │ │ │ │ + difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &_r_h_s) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ Comparisons │ │ │ │ │ - bool  ooppeerraattoorr==== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ - const &rhs) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr==== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ + _c_o_n_s_t &_r_h_s) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr!!== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ - const &rhs) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr!!== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ + _c_o_n_s_t &_r_h_s) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr<< (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &rhs) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr<< (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &_r_h_s) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr<<== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ - const &rhs) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr<<== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ + _c_o_n_s_t &_r_h_s) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr>> (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r const │ │ │ │ │ - &rhs) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr>> (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t │ │ │ │ │ + &_r_h_s) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr>>== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ - const &rhs) const │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr>>== (_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ + _c_o_n_s_t &_r_h_s) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ Dereferencing operators │ │ │ │ │ - _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type) const │ │ │ │ │ + _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r  ooppeerraattoorr-- (difference_type) _c_o_n_s_t │ │ │ │ │   Dereference iterator. │ │ │ │ │   │ │ │ │ │ - difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r const &) │ │ │ │ │ - const │ │ │ │ │ + difference_type  ooppeerraattoorr-- (_c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r _c_o_n_s_t &) │ │ │ │ │ + _c_o_n_s_t │ │ │ │ │   Dereference iterator. │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ooppeerraattoorr** () const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ooppeerraattoorr** () _c_o_n_s_t │ │ │ │ │   Dereference iterator. │ │ │ │ │   │ │ │ │ │ Field access │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  bbaacckk () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  bbaacckk () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ffrroonntt () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ffrroonntt () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  aatt (size_type) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  aatt (size_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - constexpr result::size_type  rroowwnnuummbbeerr () const noexcept │ │ │ │ │ + _c_o_n_s_t_e_x_p_r result::size_type  rroowwnnuummbbeerr () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Row number, assuming this is a real row and │ │ │ │ │ not end()/rend(). │ │ │ │ │   │ │ │ │ │ ********** DDeettaaiilleedd DDeessccrriippttiioonn ********** │ │ │ │ │ Reverse iterator for result. Use as result::const_reverse_iterator. │ │ │ │ │ ********** MMeemmbbeerr FFuunnccttiioonn DDooccuummeennttaattiioonn ********** │ │ │ │ │ ********** _?◆_? aatt(()) ********** │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1largeobject.html │ │ │ │ @@ -171,15 +171,15 @@ │ │ │ │   │ │ │ │ │ │ │ │ PQXX_PRIVATE std::string reason (connection const &, int err) const │ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │

Identity of a large object.

│ │ │ │ -
Deprecated:
Use the blob class instead.
│ │ │ │ +
Deprecated:
Use the blob class instead.
│ │ │ │

Encapsulates the identity of a large object.

│ │ │ │

A largeobject must be accessed only from within a backend transaction, but the object's identity remains valid as long as the object exists.

│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ │ │ │ │

◆ largeobject() [1/5]

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1largeobject__streambuf.html │ │ │ │ @@ -190,15 +190,15 @@ │ │ │ │ │ │ │ │ virtual int_type underflow () override │ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │
template<typename CHAR = char, typename TRAITS = std::char_traits<CHAR>>
│ │ │ │ class pqxx::largeobject_streambuf< CHAR, TRAITS >

Streambuf to use large objects in standard I/O streams.

│ │ │ │ -
Deprecated:
Access large objects directly using the blob class.
│ │ │ │ +
Deprecated:
Access large objects directly using the blob class.
│ │ │ │

The standard streambuf classes provide uniform access to data storage such as files or string buffers, so they can be accessed using standard input or output streams. This streambuf implementation provided similar access to large objects, so they could be read and written using the same stream classes.

│ │ │ │

This functionality was considered too fragile and complex, so it has been replaced with a single, much simpler class.

│ │ │ │

Member Data Documentation

│ │ │ │ │ │ │ │

◆ default_mode

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1largeobjectaccess.html │ │ │ │ @@ -238,15 +238,15 @@ │ │ │ │   │ │ │ │ bool operator>= (largeobject const &other) const │ │ │ │  Compare object identities.
│ │ │ │   │ │ │ │ │ │ │ │

Detailed Description

│ │ │ │

Accessor for large object's contents.

│ │ │ │ -
Deprecated:
Use the blob class instead.
│ │ │ │ +
Deprecated:
Use the blob class instead.
│ │ │ │

Member Typedef Documentation

│ │ │ │ │ │ │ │

◆ openmode

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1params.html │ │ │ │ @@ -183,15 +183,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
(binarystring const & value) &
│ │ │ │
│ │ │ │ -
Deprecated:
Append binarystring parameter.
│ │ │ │ +
Deprecated:
Append binarystring parameter.
│ │ │ │

The binarystring must stay valid for as long as the params remains active.

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ append() [2/6]

│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1result.html │ │ │ │ @@ -100,205 +100,206 @@ │ │ │ │ │ │ │ │

Result set containing data returned by a query or command. │ │ │ │ More...

│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │

│ │ │ │ Public Types

│ │ │ │ -using size_type = result_size_type
size_type = result_size_type
 
│ │ │ │ -using difference_type = result_difference_type
difference_type = result_difference_type
 
│ │ │ │ -using reference = row
reference = row
 
│ │ │ │ -using const_iterator = const_result_iterator
const_iterator = const_result_iterator
 
│ │ │ │ -using pointer = const_iterator
pointer = const_iterator
 
│ │ │ │ -using iterator = const_iterator
iterator = const_iterator
 
│ │ │ │ -using const_reverse_iterator = const_reverse_result_iterator
const_reverse_iterator = const_reverse_result_iterator
 
│ │ │ │ -using reverse_iterator = const_reverse_iterator
reverse_iterator = const_reverse_iterator
 
│ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +result &  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE size_type  │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE bool  │ │ │ │ │ │ │ │ │ │ │ │ +size_type  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +row  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +field  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │

│ │ │ │ Public Member Functions

│ │ │ │ - result (result const &rhs) noexcept=default
result (result const &rhs) noexcept=default
 
│ │ │ │ - result (result &&rhs) noexcept=default
result (result &&rhs) noexcept=default
 
result & operator= (result const &rhs) noexcept=default
result & operator= (result const &rhs) noexcept=default
 Assign one result to another.
 
│ │ │ │ -result & operator= (result &&rhs) noexcept=default
operator= (result &&rhs) noexcept=default
 Assign one result to another, invaliding the old one.
 
Comparisons

You can compare results for equality. Beware: this is a very strict, dumb comparison. The smallest difference between two results (such as a string "Foo" versus a string "foo") will make them unequal.

│ │ │ │
│ │ │ │ -bool operator== (result const &) const noexcept
operator== (result const &) const noexcept
 Compare two results for equality.
 
│ │ │ │ -bool operator!= (result const &rhs) const noexcept
operator!= (result const &rhs) const noexcept
 Compare two results for inequality.
 
template<typename... TYPE>
auto iter () const
auto iter () const
 Iterate rows, reading them directly into a tuple of "TYPE...".
 
│ │ │ │ -const_reverse_iterator rbegin () const
rbegin () const
 
│ │ │ │ -const_reverse_iterator crbegin () const
crbegin () const
 
│ │ │ │ -const_reverse_iterator rend () const
rend () const
 
│ │ │ │ -const_reverse_iterator crend () const
crend () const
 
│ │ │ │ -const_iterator begin () const noexcept
begin () const noexcept
 
│ │ │ │ -const_iterator cbegin () const noexcept
cbegin () const noexcept
 
│ │ │ │ -const_iterator end () const noexcept
end () const noexcept
 
│ │ │ │ -const_iterator cend () const noexcept
cend () const noexcept
 
│ │ │ │ -reference front () const noexcept
front () const noexcept
 
│ │ │ │ -reference back () const noexcept
back () const noexcept
 
│ │ │ │ -PQXX_PURE size_type size () const noexcept
size () const noexcept
 
│ │ │ │ -PQXX_PURE bool empty () const noexcept
empty () const noexcept
 
│ │ │ │ -size_type capacity () const noexcept
capacity () const noexcept
 
void swap (result &) noexcept
void swap (result &) noexcept
 Exchange two result values in an exception-safe manner.
 
row operator[] (size_type i) const noexcept
row operator[] (size_type i) const noexcept
 Index a row by number.
 
│ │ │ │ -row at (size_type) const
at (size_type) const
 Index a row by number, but check that the row number is valid.
 
│ │ │ │ -field at (size_type, row_size_type) const
at (size_type, row_size_type) const
 Index a field by row number and column number.
 
void clear () noexcept
void clear () noexcept
 Let go of the result's data.
 
│ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE row_size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +row_size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +charconst *  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +row_size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +row_size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE std::string const &  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ - │ │ │ │ + │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │

Column information

│ │ │ │ -class pqxx::internal::gate::result_pipeline
pqxx::internal::gate::result_pipeline
 
│ │ │ │ -class pqxx::field
pqxx::field
 
│ │ │ │ -class pqxx::internal::gate::result_creation
pqxx::internal::gate::result_creation
 
│ │ │ │ -class pqxx::internal::gate::result_connection
pqxx::internal::gate::result_connection
 
│ │ │ │ -class pqxx::internal::gate::result_row
pqxx::internal::gate::result_row
 
│ │ │ │ -class pqxx::internal::gate::result_sql_cursor
pqxx::internal::gate::result_sql_cursor
 
│ │ │ │ -PQXX_PURE row_size_type columns () const noexcept
columns () const noexcept
 Number of columns in result.
 
│ │ │ │ -row_size_type column_number (zview name) const
column_number (zview name) const
 Number of given column (throws exception if it doesn't exist).
 
│ │ │ │ -char const * column_name (row_size_type number) const &
column_name (row_size_type number) const &
 Name of column with this number (throws exception if it doesn't exist)
 
int column_storage (row_size_type number) const
int column_storage (row_size_type number) const
 Server-side storage size for field of column's type, in bytes.
 
int column_type_modifier (row_size_type number) const noexcept
int column_type_modifier (row_size_type number) const noexcept
 Type modifier of the column with this number.
 
│ │ │ │ -oid column_type (row_size_type col_num) const
column_type (row_size_type col_num) const
 Return column's type, as an OID from the system catalogue.
 
│ │ │ │ -oid column_type (zview col_name) const
column_type (zview col_name) const
 Return column's type, as an OID from the system catalogue.
 
│ │ │ │ -oid column_table (row_size_type col_num) const
column_table (row_size_type col_num) const
 What table did this column come from?
 
│ │ │ │ -oid column_table (zview col_name) const
column_table (zview col_name) const
 What table did this column come from?
 
│ │ │ │ -row_size_type table_column (row_size_type col_num) const
table_column (row_size_type col_num) const
 What column in its table did this column come from?
 
│ │ │ │ -row_size_type table_column (zview col_name) const
table_column (zview col_name) const
 What column in its table did this column come from?
 
│ │ │ │ -PQXX_PURE std::string const & query () const &noexcept
query () const &noexcept
 Query that produced this result, if available (empty string otherwise)
 
PQXX_PURE oid inserted_oid () const
PQXX_PURE oid inserted_oid () const
 If command was an INSERT of 1 row, return oid of the inserted row.
 
PQXX_PURE size_type affected_rows () const
PQXX_PURE size_type affected_rows () const
 If command was INSERT, UPDATE, or DELETE: number of affected rows.
 
template<typename CALLABLE >
void for_each (CALLABLE &&func) const
template<typename CALLABLE >
void for_each (CALLABLE &&func) const
 Run func on each row, passing the row's fields as parameters.
 
│ │ │ │

Detailed Description

│ │ │ │

Result set containing data returned by a query or command.

│ │ │ │

This behaves as a container (as defined by the C++ standard library) and provides random access const iterators to iterate over its rows. You can also access a row by indexing a result R by the row's zero-based number:

│ │ │ │ -
for (result::size_type i=0; i < std::size(R); ++i) Process(R[i]);
│ │ │ │ +
for (result::size_type i=0; i < std::size(R); ++i) Process(R[i]);
│ │ │ │ +
pqxx::const_reverse_result_iterator
Reverse iterator for result. Use as result::const_reverse_iterator.
Definition result_iterator.hxx:194
│ │ │ │

Result sets in libpqxx are lightweight, reference-counted wrapper objects which are relatively small and cheap to copy. Think of a result object as a "smart pointer" to an underlying result set.

│ │ │ │
Warning
The result set that a result object points to is not thread-safe. If you copy a result object, it still refers to the same underlying result set. So never copy, destroy, query, or otherwise access a result while another thread may be copying, destroying, querying, or otherwise accessing the same result set–even if it is doing so through a different result object!
│ │ │ │

Member Function Documentation

│ │ │ │ │ │ │ │

◆ affected_rows()

│ │ │ │ │ │ │ │
│ │ │ │ @@ -324,15 +325,15 @@ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
void pqxx::result::clear void pqxx::result::clear ()
│ │ │ │ 		│ │ │ │ @@ -350,15 +351,15 @@ │ │ │ │ │ │ │ │

◆ column_storage()

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
int pqxx::result::column_storage int pqxx::result::column_storage (row_size_type number) const
│ │ │ │
│ │ │ │ @@ -374,15 +375,15 @@ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ @@ -402,23 +403,23 @@ │ │ │ │ │ │ │ │ │ │ │ │

◆ for_each()

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ -template<typename CALLABLE >
│ │ │ │ +template<typename CALLABLE >
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
int pqxx::result::column_type_modifier int pqxx::result::column_type_modifier (row_size_type number) const
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ @@ -428,17 +429,17 @@ │ │ │ │ │ │ │ │

Run func on each row, passing the row's fields as parameters.

│ │ │ │

Goes through the rows from first to last. You provide a callable func.

│ │ │ │

For each row in the result, for_each will call func. It converts the row's fields to the types of func's parameters, and pass them to func.

│ │ │ │

(Therefore func must have a single signature. It can't be a generic lambda, or an object of a class with multiple overloaded function call operators. Otherwise, for_each will have no way to detect a parameter list without ambiguity.)

│ │ │ │

If any of your parameter types is std::string_view, it refers to the underlying storage of this result.

│ │ │ │

If any of your parameter types is a reference type, its argument will refer to a temporary value which only lives for the duration of that single invocation to func. If the reference is an lvalue reference, it must be const.

│ │ │ │ -

For example, this queries employee names and salaries from the database and prints how much each would like to earn instead:

tx.exec("SELECT name, salary FROM employee").for_each(
│ │ │ │ -
[](std::string_view name, float salary){
│ │ │ │ -
std::cout << name << " would like " << salary * 2 << ".\n";
│ │ │ │ +

For example, this queries employee names and salaries from the database and prints how much each would like to earn instead:

tx.exec("SELECT name, salary FROM employee").for_each(
│ │ │ │ +
[](std::string_view name, float salary){
│ │ │ │ +
std::cout << name << " would like " << salary * 2 << ".\n";
│ │ │ │
})
│ │ │ │

If func throws an exception, processing stops at that point and propagates the exception.

│ │ │ │
Exceptions
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
void pqxx::result::for_each void pqxx::result::for_each (CALLABLE && CALLABLE && func) const
│ │ │ │ 		│ │ │ │ inline
│ │ │ │ │ │ │ │
pqxx::usage_errorif func's number of parameters does not match the number of columns in this result.
│ │ │ │ │ │ │ │ @@ -475,15 +476,15 @@ │ │ │ │
│ │ │ │ template<typename... TYPE>
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
auto pqxx::result::iter auto pqxx::result::iter () const
│ │ │ │ 		│ │ │ │ @@ -506,15 +507,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ @@ -562,15 +563,15 @@ │ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
result & pqxx::result::operator= (result const & result const & rhs)
│ │ │ │ 		│ │ │ │ defaultnoexcept
│ │ │ │ │ │ │ │ │ │ │ │ ├── html2text {} │ │ │ │ │ @@ -3,175 +3,178 @@ │ │ │ │ │ Loading... │ │ │ │ │ Searching... │ │ │ │ │ No Matches │ │ │ │ │ _P_u_b_l_i_c_ _T_y_p_e_s | _P_u_b_l_i_c_ _M_e_m_b_e_r_ _F_u_n_c_t_i_o_n_s | _L_i_s_t_ _o_f_ _a_l_l_ _m_e_m_b_e_r_s │ │ │ │ │ pqxx::result Class Reference │ │ │ │ │ Result set containing data returned by a query or command. _M_o_r_e_._._. │ │ │ │ │ PPuubblliicc TTyyppeess │ │ │ │ │ -using  ssiizzee__ttyyppee = _r_e_s_u_l_t___s_i_z_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ssiizzee__ttyyppee = _r_e_s_u_l_t___s_i_z_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ddiiffffeerreennccee__ttyyppee = _r_e_s_u_l_t___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  rreeffeerreennccee = _r_o_w │ │ │ │ │ +_u_s_i_n_g  rreeffeerreennccee = _r_o_w │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  ppooiinntteerr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ppooiinntteerr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ PPuubblliicc MMeemmbbeerr FFuunnccttiioonnss │ │ │ │ │ -   rreessuulltt (_r_e_s_u_l_t const &rhs) noexcept=default │ │ │ │ │ +   rreessuulltt (_r_e_s_u_l_t _c_o_n_s_t &_r_h_s) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ -   rreessuulltt (_r_e_s_u_l_t &&rhs) noexcept=default │ │ │ │ │ +   rreessuulltt (_r_e_s_u_l_t &&_r_h_s) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - _r_e_s_u_l_t &  _o_p_e_r_a_t_o_r_= (_r_e_s_u_l_t const &rhs) noexcept=default │ │ │ │ │ + _r_e_s_u_l_t &  _o_p_e_r_a_t_o_r_= (_r_e_s_u_l_t _c_o_n_s_t &_r_h_s) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   Assign one result to another. │ │ │ │ │   │ │ │ │ │ - _r_e_s_u_l_t &  ooppeerraattoorr== (_r_e_s_u_l_t &&rhs) noexcept=default │ │ │ │ │ + _r_e_s_u_l_t &  ooppeerraattoorr== (_r_e_s_u_l_t &&_r_h_s) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   Assign one result to another, invaliding the old one. │ │ │ │ │   │ │ │ │ │ Comparisons │ │ │ │ │ You can compare results for equality. Beware: this is a very strict, dumb │ │ │ │ │ comparison. The smallest difference between two results (such as a string "Foo" │ │ │ │ │ versus a string "foo") will make them unequal. │ │ │ │ │ - bool  ooppeerraattoorr==== (_r_e_s_u_l_t const &) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr==== (_r_e_s_u_l_t _c_o_n_s_t &) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Compare two results for equality. │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr!!== (_r_e_s_u_l_t const &rhs) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr!!== (_r_e_s_u_l_t _c_o_n_s_t &_r_h_s) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Compare two results for inequality. │ │ │ │ │   │ │ │ │ │ template │ │ │ │ │ - auto  _i_t_e_r () const │ │ │ │ │ + _a_u_t_o  _i_t_e_r () _c_o_n_s_t │ │ │ │ │   Iterate rows, reading them directly into a tuple of │ │ │ │ │ "TYPE...". │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  rrbbeeggiinn () const │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  rrbbeeggiinn () _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () const │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  rreenndd () const │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  rreenndd () _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ -_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  ccrreenndd () const │ │ │ │ │ +_c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r  ccrreenndd () _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ffrroonntt () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ffrroonntt () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  bbaacckk () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  bbaacckk () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - PQXX_PURE size_type  ssiizzee () const noexcept │ │ │ │ │ + PQXX_PURE size_type  ssiizzee () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - PQXX_PURE bool  eemmppttyy () const noexcept │ │ │ │ │ + PQXX_PURE _b_o_o_l  eemmppttyy () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - size_type  ccaappaacciittyy () const noexcept │ │ │ │ │ + size_type  ccaappaacciittyy () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - void  _s_w_a_p (_r_e_s_u_l_t &) noexcept │ │ │ │ │ + _v_o_i_d  _s_w_a_p (_r_e_s_u_l_t &) _n_o_e_x_c_e_p_t │ │ │ │ │   Exchange two result values in an exception-safe manner. │ │ │ │ │   │ │ │ │ │ - _r_o_w  _o_p_e_r_a_t_o_r_[_] (size_type i) const noexcept │ │ │ │ │ + _r_o_w  _o_p_e_r_a_t_o_r_[_] (size_type _i) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Index a row by number. │ │ │ │ │   │ │ │ │ │ - _r_o_w  aatt (size_type) const │ │ │ │ │ + _r_o_w  aatt (size_type) _c_o_n_s_t │ │ │ │ │   Index a row by number, but check that the row number is │ │ │ │ │ valid. │ │ │ │ │   │ │ │ │ │ - _f_i_e_l_d  aatt (size_type, _r_o_w___s_i_z_e___t_y_p_e) const │ │ │ │ │ + _f_i_e_l_d  aatt (size_type, _r_o_w___s_i_z_e___t_y_p_e) _c_o_n_s_t │ │ │ │ │   Index a field by row number and column number. │ │ │ │ │   │ │ │ │ │ - void  _c_l_e_a_r () noexcept │ │ │ │ │ + _v_o_i_d  _c_l_e_a_r () _n_o_e_x_c_e_p_t │ │ │ │ │   Let go of the result's data. │ │ │ │ │   │ │ │ │ │ ********** CCoolluummnn iinnffoorrmmaattiioonn ********** │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ppiippeelliinnee │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ppiippeelliinnee │ │ │ │ │   │ │ │ │ │ - class  ppqqxxxx::::ffiieelldd │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::ffiieelldd │ │ │ │ │   │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ccrreeaattiioonn │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ccrreeaattiioonn │ │ │ │ │   │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ccoonnnneeccttiioonn │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ccoonnnneeccttiioonn │ │ │ │ │   │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__rrooww │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__rrooww │ │ │ │ │   │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ssqqll__ccuurrssoorr │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::ggaattee::::rreessuulltt__ssqqll__ccuurrssoorr │ │ │ │ │   │ │ │ │ │ - PQXX_PURE _r_o_w___s_i_z_e___t_y_p_e  ccoolluummnnss () const noexcept │ │ │ │ │ + PQXX_PURE _r_o_w___s_i_z_e___t_y_p_e  ccoolluummnnss () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Number of columns in result. │ │ │ │ │   │ │ │ │ │ - _r_o_w___s_i_z_e___t_y_p_e  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w name) const │ │ │ │ │ + _r_o_w___s_i_z_e___t_y_p_e  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w name) _c_o_n_s_t │ │ │ │ │   Number of given column (throws exception if it │ │ │ │ │ doesn't exist). │ │ │ │ │   │ │ │ │ │ - char const *  ccoolluummnn__nnaammee (_r_o_w___s_i_z_e___t_y_p_e number) const & │ │ │ │ │ + _c_h_a_r _c_o_n_s_t *  ccoolluummnn__nnaammee (_r_o_w___s_i_z_e___t_y_p_e _n_u_m_b_e_r) _c_o_n_s_t & │ │ │ │ │   Name of column with this number (throws │ │ │ │ │ exception if it doesn't exist) │ │ │ │ │   │ │ │ │ │ - int  _c_o_l_u_m_n___s_t_o_r_a_g_e (_r_o_w___s_i_z_e___t_y_p_e number) const │ │ │ │ │ + _i_n_t  _c_o_l_u_m_n___s_t_o_r_a_g_e (_r_o_w___s_i_z_e___t_y_p_e _n_u_m_b_e_r) _c_o_n_s_t │ │ │ │ │   Server-side storage size for field of column's │ │ │ │ │ type, in bytes. │ │ │ │ │   │ │ │ │ │ - int  _c_o_l_u_m_n___t_y_p_e___m_o_d_i_f_i_e_r (_r_o_w___s_i_z_e___t_y_p_e number) │ │ │ │ │ - const noexcept │ │ │ │ │ + _i_n_t  _c_o_l_u_m_n___t_y_p_e___m_o_d_i_f_i_e_r (_r_o_w___s_i_z_e___t_y_p_e _n_u_m_b_e_r) │ │ │ │ │ + _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Type modifier of the column with this number. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (_r_o_w___s_i_z_e___t_y_p_e col_num) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (_r_o_w___s_i_z_e___t_y_p_e _c_o_l___n_u_m) _c_o_n_s_t │ │ │ │ │   Return column's type, as an OID from the system │ │ │ │ │ catalogue. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   Return column's type, as an OID from the system │ │ │ │ │ catalogue. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (_r_o_w___s_i_z_e___t_y_p_e col_num) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (_r_o_w___s_i_z_e___t_y_p_e _c_o_l___n_u_m) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - _r_o_w___s_i_z_e___t_y_p_e  ttaabbllee__ccoolluummnn (_r_o_w___s_i_z_e___t_y_p_e col_num) const │ │ │ │ │ + _r_o_w___s_i_z_e___t_y_p_e  ttaabbllee__ccoolluummnn (_r_o_w___s_i_z_e___t_y_p_e _c_o_l___n_u_m) _c_o_n_s_t │ │ │ │ │   What column in its table did this column come │ │ │ │ │ from? │ │ │ │ │   │ │ │ │ │ - _r_o_w___s_i_z_e___t_y_p_e  ttaabbllee__ccoolluummnn (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_o_w___s_i_z_e___t_y_p_e  ttaabbllee__ccoolluummnn (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What column in its table did this column come │ │ │ │ │ from? │ │ │ │ │   │ │ │ │ │ -PQXX_PURE std::string const &  qquueerryy () const &noexcept │ │ │ │ │ +PQXX_PURE std::string _c_o_n_s_t &  qquueerryy () _c_o_n_s_t &_n_o_e_x_c_e_p_t │ │ │ │ │   Query that produced this result, if available │ │ │ │ │ (empty string otherwise) │ │ │ │ │   │ │ │ │ │ - PQXX_PURE _o_i_d  _i_n_s_e_r_t_e_d___o_i_d () const │ │ │ │ │ + PQXX_PURE _o_i_d  _i_n_s_e_r_t_e_d___o_i_d () _c_o_n_s_t │ │ │ │ │   If command was an INSERT of 1 row, return oid of │ │ │ │ │ the inserted row. │ │ │ │ │   │ │ │ │ │ - PQXX_PURE size_type  _a_f_f_e_c_t_e_d___r_o_w_s () const │ │ │ │ │ + PQXX_PURE size_type  _a_f_f_e_c_t_e_d___r_o_w_s () _c_o_n_s_t │ │ │ │ │   If command was INSERT, UPDATE, or DELETE: number │ │ │ │ │ of affected rows. │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - void  _f_o_r___e_a_c_h (CALLABLE &&func) const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _C_A_L_L_A_B_L_E > │ │ │ │ │ + _v_o_i_d  _f_o_r___e_a_c_h (_C_A_L_L_A_B_L_E &&_f_u_n_c) _c_o_n_s_t │ │ │ │ │   Run func on each row, passing the row's fields │ │ │ │ │ as parameters. │ │ │ │ │   │ │ │ │ │ ********** DDeettaaiilleedd DDeessccrriippttiioonn ********** │ │ │ │ │ Result set containing data returned by a query or command. │ │ │ │ │ This behaves as a container (as defined by the C++ standard library) and │ │ │ │ │ provides random access const iterators to iterate over its rows. You can also │ │ │ │ │ access a row by indexing a result R by the row's zero-based number: │ │ │ │ │ -for (result::size_type i=0; i < std::size(R); ++i) Process(R[i]); │ │ │ │ │ +for (result::size_type _i=0; _i < std::size(_R); ++_i) _P_r_o_c_e_s_s(_R[_i]); │ │ │ │ │ +_p_q_x_x_:_:_c_o_n_s_t___r_e_v_e_r_s_e___r_e_s_u_l_t___i_t_e_r_a_t_o_r │ │ │ │ │ +Reverse iterator for result. Use as result::const_reverse_iterator. │ │ │ │ │ +DDeeffiinniittiioonn result_iterator.hxx:194 │ │ │ │ │ Result sets in libpqxx are lightweight, reference-counted wrapper objects which │ │ │ │ │ are relatively small and cheap to copy. Think of a result object as a "smart │ │ │ │ │ pointer" to an underlying result set. │ │ │ │ │ Warning │ │ │ │ │ The result set that a result object points to is not thread-safe. If you │ │ │ │ │ copy a result object, it still refers to the same underlying result set. │ │ │ │ │ So never copy, destroy, query, or otherwise access a result while another │ │ │ │ │ @@ -181,40 +184,40 @@ │ │ │ │ │ ********** _?◆_? aaffffeecctteedd__rroowwss(()) ********** │ │ │ │ │ pqxx::result::size_type pqxx::result::affected_rows ( ) const │ │ │ │ │ If command was INSERT, UPDATE, or DELETE: number of affected rows. │ │ │ │ │ Returns │ │ │ │ │ Number of affected rows if last command was INSERT, UPDATE, or DELETE; │ │ │ │ │ zero for all other commands. │ │ │ │ │ ********** _?◆_? cclleeaarr(()) ********** │ │ │ │ │ -void pqxx::result:: ( ) inlinenoexcept │ │ │ │ │ +_v_o_i_d pqxx::result:: ( ) inlinenoexcept │ │ │ │ │ clear │ │ │ │ │ Let go of the result's data. │ │ │ │ │ Use this if you need to deallocate the result data earlier than you can destroy │ │ │ │ │ the result object itself. │ │ │ │ │ Multiple result objects can refer to the same set of underlying data. The │ │ │ │ │ underlying data will be deallocated once all result objects that refer to it │ │ │ │ │ are cleared or destroyed. │ │ │ │ │ ********** _?◆_? ccoolluummnn__ssttoorraaggee(()) ********** │ │ │ │ │ -int pqxx::result::column_storage ( _r_o_w___s_i_z_e___t_y_p_e  nnuummbbeerr ) const │ │ │ │ │ +_i_n_t pqxx::result::column_storage ( _r_o_w___s_i_z_e___t_y_p_e  nnuummbbeerr ) const │ │ │ │ │ Server-side storage size for field of column's type, in bytes. │ │ │ │ │ Returns the size of the server's internal representation of the column's data │ │ │ │ │ type. A negative value indicates the data type is variable-length. │ │ │ │ │ ********** _?◆_? ccoolluummnn__ttyyppee__mmooddiiffiieerr(()) ********** │ │ │ │ │ -int pqxx::result::column_type_modifier ( _r_o_w___s_i_z_e___t_y_p_e  nnuummbbeerr ) const noexcept │ │ │ │ │ +_i_n_t pqxx::result::column_type_modifier ( _r_o_w___s_i_z_e___t_y_p_e  nnuummbbeerr ) const noexcept │ │ │ │ │ Type modifier of the column with this number. │ │ │ │ │ The meaning of modifier values is type-specific; they typically indicate │ │ │ │ │ precision or size limits. │ │ │ │ │ UUssee tthhiiss oonnllyy iiff yyoouu kknnooww wwhhaatt yyoouu''rree ddooiinngg.. Most applications do not need it, │ │ │ │ │ and most types do not use modifiers. │ │ │ │ │ The value -1 indicates "no information available." │ │ │ │ │ Warning │ │ │ │ │ There is no check for errors, such as an invalid column number. │ │ │ │ │ ********** _?◆_? ffoorr__eeaacchh(()) ********** │ │ │ │ │ -template │ │ │ │ │ -void pqxx::result::for_each ( CALLABLE &&  ffuunncc ) const inline │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _C_A_L_L_A_B_L_E > │ │ │ │ │ +_v_o_i_d pqxx::result::for_each ( _C_A_L_L_A_B_L_E &&  ffuunncc ) const inline │ │ │ │ │ Run func on each row, passing the row's fields as parameters. │ │ │ │ │ Goes through the rows from first to last. You provide a callable func. │ │ │ │ │ For each row in the result, for_each will call func. It converts the row's │ │ │ │ │ fields to the types of func's parameters, and pass them to func. │ │ │ │ │ (Therefore func must have a ssiinnggllee signature. It can't be a generic lambda, or │ │ │ │ │ an object of a class with multiple overloaded function call operators. │ │ │ │ │ Otherwise, for_each will have no way to detect a parameter list without │ │ │ │ │ @@ -222,17 +225,17 @@ │ │ │ │ │ If any of your parameter types is std::string_view, it refers to the underlying │ │ │ │ │ storage of this result. │ │ │ │ │ If any of your parameter types is a reference type, its argument will refer to │ │ │ │ │ a temporary value which only lives for the duration of that single invocation │ │ │ │ │ to func. If the reference is an lvalue reference, it must be const. │ │ │ │ │ For example, this queries employee names and salaries from the database and │ │ │ │ │ prints how much each would like to earn instead: │ │ │ │ │ -tx.exec("SELECT name, salary FROM employee").for_each( │ │ │ │ │ -[](std::string_view name, float salary){ │ │ │ │ │ -std::cout << name << " would like " << salary * 2 << ".\n"; │ │ │ │ │ +_t_x.exec("SELECT name, salary FROM employee").for_each( │ │ │ │ │ +[](std::string_view name, float _s_a_l_a_r_y){ │ │ │ │ │ +std::cout << name << " would like " << _s_a_l_a_r_y * 2 << ".\n"; │ │ │ │ │ }) │ │ │ │ │ If func throws an exception, processing stops at that point and propagates the │ │ │ │ │ exception. │ │ │ │ │ Exceptions │ │ │ │ │ _p_q_x_x_:_:_u_s_a_g_e___e_r_r_o_r if func's number of parameters does not match the │ │ │ │ │ number of columns in this result. │ │ │ │ │ The parameter types must have conversions from PostgreSQL's string format │ │ │ │ │ @@ -241,32 +244,32 @@ │ │ │ │ │ _p_q_x_x_:_:_o_i_d pqxx::result::inserted_oid ( ) const │ │ │ │ │ If command was an INSERT of 1 row, return oid of the inserted row. │ │ │ │ │ Returns │ │ │ │ │ Identifier of inserted row if exactly one row was inserted, or _o_i_d___n_o_n_e │ │ │ │ │ otherwise. │ │ │ │ │ ********** _?◆_? iitteerr(()) ********** │ │ │ │ │ template │ │ │ │ │ -auto pqxx::result::iter ( ) const inline │ │ │ │ │ +_a_u_t_o pqxx::result::iter ( ) const inline │ │ │ │ │ Iterate rows, reading them directly into a tuple of "TYPE...". │ │ │ │ │ Converts the fields to values of the given respective types. │ │ │ │ │ Use this only with a ranged "for" loop. The iteration produces std:: │ │ │ │ │ tuple which you can "unpack" to a series of auto variables. │ │ │ │ │ ********** _?◆_? ooppeerraattoorr==(()) ********** │ │ │ │ │ -_r_e_s_u_l_t & pqxx::result:: ( _r_e_s_u_l_t const &  rrhhss ) defaultnoexcept │ │ │ │ │ +_r_e_s_u_l_t & pqxx::result:: ( _r_e_s_u_l_t _c_o_n_s_t &  rrhhss ) defaultnoexcept │ │ │ │ │ operator= │ │ │ │ │ Assign one result to another. │ │ │ │ │ Copying results is cheap: it copies only smart pointers, but the actual data │ │ │ │ │ stays in the same place. │ │ │ │ │ ********** _?◆_? ooppeerraattoorr[[]](()) ********** │ │ │ │ │ _p_q_x_x_:_:_r_o_w pqxx::result::operator[] ( size_type  ii ) const noexcept │ │ │ │ │ Index a row by number. │ │ │ │ │ This returns a _r_o_w object. Generally you should not keep the row around as a │ │ │ │ │ variable, but if you do, make sure that your variable is a row, not a row&. │ │ │ │ │ ********** _?◆_? sswwaapp(()) ********** │ │ │ │ │ -void pqxx::result:: ( _r_e_s_u_l_t &  rrhhss ) noexcept │ │ │ │ │ +_v_o_i_d pqxx::result:: ( _r_e_s_u_l_t &  rrhhss ) noexcept │ │ │ │ │ swap │ │ │ │ │ Exchange two result values in an exception-safe manner. │ │ │ │ │ If the swap fails, the two values will be exactly as they were before. │ │ │ │ │ The swap is not necessarily thread-safe. │ │ │ │ │ =============================================================================== │ │ │ │ │ The documentation for this class was generated from the following files: │ │ │ │ │ * /build/reproducible-path/libpqxx-7.9.1/include/pqxx/_r_e_s_u_l_t_._h_x_x │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1row.html │ │ │ │ @@ -126,121 +126,121 @@ │ │ │ │ │ │ │ │ │ │ │ │
[legend]
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
void pqxx::result::swap void pqxx::result::swap (result & rhs)
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │ │ │ │ │ +using  │ │ │ │ │ │ │ │

│ │ │ │ Public Types

│ │ │ │ -using size_type = row_size_type
size_type = row_size_type
 
│ │ │ │ -using difference_type = row_difference_type
difference_type = row_difference_type
 
│ │ │ │ -using const_iterator = const_row_iterator
const_iterator = const_row_iterator
 
│ │ │ │ -using iterator = const_iterator
iterator = const_iterator
 
│ │ │ │ -using reference = field
reference = field
 
│ │ │ │ -using pointer = const_row_iterator
pointer = const_row_iterator
 
│ │ │ │ -using const_reverse_iterator = const_reverse_row_iterator
const_reverse_iterator = const_reverse_row_iterator
 
│ │ │ │ -using reverse_iterator = const_reverse_iterator
reverse_iterator = const_reverse_iterator
 
│ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ +  │ │ │ │ │ │ │ │ │ │ │ │ +row &  │ │ │ │ │ │ │ │ │ │ │ │ +row &  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE bool  │ │ │ │ │ │ │ │ │ │ │ │ +bool  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_iterator  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +const_reverse_row_iterator  │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +reference  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +constexpr size_type  │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ │ │ │ │

│ │ │ │ Public Member Functions

│ │ │ │ - row (row &&) noexcept=default
row (row &&) noexcept=default
 
│ │ │ │ - row (row const &) noexcept=default
row (row const &) noexcept=default
 
│ │ │ │ -row & operator= (row const &) noexcept=default
operator= (row const &) noexcept=default
 
│ │ │ │ -row & operator= (row &&) noexcept=default
operator= (row &&) noexcept=default
 
Comparison
│ │ │ │ -PQXX_PURE bool operator== (row const &) const noexcept
operator== (row const &) const noexcept
 
│ │ │ │ -bool operator!= (row const &rhs) const noexcept
operator!= (row const &rhs) const noexcept
 
│ │ │ │ -const_iterator begin () const noexcept
begin () const noexcept
 
│ │ │ │ -const_iterator cbegin () const noexcept
cbegin () const noexcept
 
│ │ │ │ -const_iterator end () const noexcept
end () const noexcept
 
│ │ │ │ -const_iterator cend () const noexcept
cend () const noexcept
 
Field access
│ │ │ │ -reference front () const noexcept
front () const noexcept
 
│ │ │ │ -reference back () const noexcept
back () const noexcept
 
│ │ │ │ -const_reverse_row_iterator rbegin () const noexcept
rbegin () const noexcept
 
│ │ │ │ -const_reverse_row_iterator crbegin () const noexcept
crbegin () const noexcept
 
│ │ │ │ -const_reverse_row_iterator rend () const noexcept
rend () const noexcept
 
│ │ │ │ -const_reverse_row_iterator crend () const noexcept
crend () const noexcept
 
│ │ │ │ -reference operator[] (size_type) const noexcept
operator[] (size_type) const noexcept
 
reference operator[] (zview col_name) const
reference operator[] (zview col_name) const
 
│ │ │ │ -reference at (size_type) const
at (size_type) const
 
reference at (zview col_name) const
reference at (zview col_name) const
 
│ │ │ │ -constexpr size_type size () const noexcept
size () const noexcept
 
│ │ │ │ -constexpr result::size_type rownumber () const noexcept
rownumber () const noexcept
 Row number, assuming this is a real row and not end()/rend().
 
│ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +class  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ @@ -250,80 +250,81 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +oid  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +size_type  │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +constexpr result::size_type  │ │ │ │ │ │ │ │ - │ │ │ │ - │ │ │ │ + │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +PQXX_PURE bool  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ +void  │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ - │ │ │ │ + │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ +template<typenameTuple > │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │

Column information

│ │ │ │ -class const_row_iterator
const_row_iterator
 
│ │ │ │ -class result
result
 
│ │ │ │ template<typename... T>
class pqxx::internal::result_iter
class pqxx::internal::result_iter
 
│ │ │ │ -class field
field
 
│ │ │ │ result m_result
 Result set of which this is one row.
 
result::size_type m_index = 0
 Row number.
 First column in slice. This row ignores lower-numbered columns.
 
│ │ │ │ size_type m_end = 0
 End column in slice. This row only sees lower-numbered columns.
 
│ │ │ │ -size_type column_number (zview col_name) const
column_number (zview col_name) const
 Number of given column (throws exception if it doesn't exist).
 
│ │ │ │ -oid column_type (size_type) const
column_type (size_type) const
 Return a column's type.
 
│ │ │ │ -oid column_type (zview col_name) const
column_type (zview col_name) const
 Return a column's type.
 
│ │ │ │ -oid column_table (size_type col_num) const
column_table (size_type col_num) const
 What table did this column come from?
 
│ │ │ │ -oid column_table (zview col_name) const
column_table (zview col_name) const
 What table did this column come from?
 
size_type table_column (size_type) const
size_type table_column (size_type) const
 What column number in its table did this result column come from?
 
│ │ │ │ -size_type table_column (zview col_name) const
table_column (zview col_name) const
 What column number in its table did this result column come from?
 
│ │ │ │ -constexpr result::size_type num () const noexcept
num () const noexcept
 
template<typename Tuple >
void to (Tuple &t) const
template<typename Tuple >
void to (Tuple &t) const
 Extract entire row's values into a tuple.
 
template<typename... TYPE>
std::tuple< TYPE... > as () const
std::tuple< TYPE... > as () const
 Extract entire row's values into a tuple.
 
│ │ │ │ -void swap (row &) noexcept
swap (row &) noexcept
 
row slice (size_type sbegin, size_type send) const
row slice (size_type sbegin, size_type send) const
 
│ │ │ │ -PQXX_PURE bool empty () const noexcept
empty () const noexcept
 Is this a row without fields? Can only happen to a slice.
 
 row (result const &r, result_size_type index, size_type cols) noexcept
 row (result const &r, result_size_type index, size_type cols) noexcept
 
│ │ │ │ -void check_size (size_type expected) const
check_size (size_type expected) const
 Throw usage_error if row size is not expected.
 
template<typename TUPLE >
TUPLE as_tuple () const
template<typename TUPLE >
TUPLE as_tuple () const
 Convert to a given tuple of values, don't check sizes.
 
│ │ │ │ -template<typename Tuple >
void convert (Tuple &t) const
void convert (Tuple &t) const
 Convert entire row to tuple fields, without checking row size.
 
│ │ │ │

Detailed Description

│ │ │ │

Reference to one row in a result.

│ │ │ │

A row represents one row (also called a row) in a query result set. It also acts as a container mapping column numbers or names to field values (see below):

│ │ │ │ -
cout << row["date"].c_str() << ": " << row["name"].c_str() << endl;
│ │ │ │ +
cout << row["date"].c_str() << ": " << row["name"].c_str() << endl;
│ │ │ │ +
pqxx::const_reverse_row_iterator
Reverse iterator for a row. Use as row::const_reverse_iterator.
Definition row.hxx:406
│ │ │ │
pqxx::row
Reference to one row in a result.
Definition row.hxx:47
│ │ │ │

The row itself acts like a (non-modifyable) container, complete with its own const_iterator and const_reverse_iterator.

│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ │ │ │ │

◆ row()

│ │ │ │ │ │ │ │
│ │ │ │ @@ -331,15 +332,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ @@ -409,21 +410,21 @@ │ │ │ │ │ │ │ │ │ │ │ │

◆ as_tuple()

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ -template<typename TUPLE >
│ │ │ │ +template<typename TUPLE >
│ │ │ │
pqxx::row::row (result const & result const & r,
result_size_type index,
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
TUPLE pqxx::row::as_tuple TUPLE pqxx::row::as_tuple () const
│ │ │ │ 		│ │ │ │ @@ -497,15 +498,15 @@ │ │ │ │ ) const
│ │ │ │
│ │ │ │

Produce a slice of this row, containing the given range of columns.

│ │ │ │ -
Deprecated:
I haven't heard of anyone caring about row slicing at all in at least the last 15 years. Yet it adds complexity, so unless anyone files a bug explaining why they really need this feature, I'm going to remove it. Even if they do, the feature may need an update.
│ │ │ │ +
Deprecated:
I haven't heard of anyone caring about row slicing at all in at least the last 15 years. Yet it adds complexity, so unless anyone files a bug explaining why they really need this feature, I'm going to remove it. Even if they do, the feature may need an update.
│ │ │ │

The slice runs from the range's starting column to the range's end column, exclusive. It looks just like a normal result row, except slices can be empty.

│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ table_column()

│ │ │ │ │ │ │ │ @@ -536,23 +537,23 @@ │ │ │ │ │ │ │ │ │ │ │ │

◆ to()

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ -template<typename Tuple >
│ │ │ │ +template<typename Tuple >
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├── html2text {} │ │ │ │ │ @@ -9,88 +9,88 @@ │ │ │ │ │ [+]Inheritance diagram for pqxx::row: │ │ │ │ │ [Inheritance graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ [+]Collaboration diagram for pqxx::row: │ │ │ │ │ [Collaboration graph] │ │ │ │ │ [_l_e_g_e_n_d] │ │ │ │ │ PPuubblliicc TTyyppeess │ │ │ │ │ -using  ssiizzee__ttyyppee = _r_o_w___s_i_z_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ssiizzee__ttyyppee = _r_o_w___s_i_z_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ddiiffffeerreennccee__ttyyppee = _r_o_w___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │ +_u_s_i_n_g  ddiiffffeerreennccee__ttyyppee = _r_o_w___d_i_f_f_e_r_e_n_c_e___t_y_p_e │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__iitteerraattoorr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  iitteerraattoorr = _c_o_n_s_t___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  rreeffeerreennccee = _f_i_e_l_d │ │ │ │ │ +_u_s_i_n_g  rreeffeerreennccee = _f_i_e_l_d │ │ │ │ │   │ │ │ │ │ -using  ppooiinntteerr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ppooiinntteerr = _c_o_n_s_t___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  ccoonnsstt__rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ -using  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │ +_u_s_i_n_g  rreevveerrssee__iitteerraattoorr = _c_o_n_s_t___r_e_v_e_r_s_e___i_t_e_r_a_t_o_r │ │ │ │ │   │ │ │ │ │ PPuubblliicc MMeemmbbeerr FFuunnccttiioonnss │ │ │ │ │ -   rrooww (_r_o_w &&) noexcept=default │ │ │ │ │ +   rrooww (_r_o_w &&) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ -   rrooww (_r_o_w const &) noexcept=default │ │ │ │ │ +   rrooww (_r_o_w _c_o_n_s_t &) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - _r_o_w &  ooppeerraattoorr== (_r_o_w const &) noexcept=default │ │ │ │ │ + _r_o_w &  ooppeerraattoorr== (_r_o_w _c_o_n_s_t &) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ - _r_o_w &  ooppeerraattoorr== (_r_o_w &&) noexcept=default │ │ │ │ │ + _r_o_w &  ooppeerraattoorr== (_r_o_w &&) _n_o_e_x_c_e_p_t=_d_e_f_a_u_l_t │ │ │ │ │   │ │ │ │ │ Comparison │ │ │ │ │ - PQXX_PURE bool  ooppeerraattoorr==== (_r_o_w const &) const noexcept │ │ │ │ │ + PQXX_PURE _b_o_o_l  ooppeerraattoorr==== (_r_o_w _c_o_n_s_t &) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - bool  ooppeerraattoorr!!== (_r_o_w const &rhs) const noexcept │ │ │ │ │ + _b_o_o_l  ooppeerraattoorr!!== (_r_o_w _c_o_n_s_t &_r_h_s) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  bbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  ccbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  eenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___i_t_e_r_a_t_o_r  cceenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ Field access │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ffrroonntt () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ffrroonntt () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  bbaacckk () const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  bbaacckk () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rrbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rrbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrrbbeeggiinn () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rreenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  rreenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrreenndd () const noexcept │ │ │ │ │ + _c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r  ccrreenndd () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  ooppeerraattoorr[[]] (size_type) const noexcept │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  ooppeerraattoorr[[]] (size_type) _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _o_p_e_r_a_t_o_r_[_] (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _o_p_e_r_a_t_o_r_[_] (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  aatt (size_type) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  aatt (size_type) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w col_name) const │ │ │ │ │ + _r_e_f_e_r_e_n_c_e  _a_t (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - constexpr size_type  ssiizzee () const noexcept │ │ │ │ │ + _c_o_n_s_t_e_x_p_r size_type  ssiizzee () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ -constexpr result::size_type  rroowwnnuummbbeerr () const noexcept │ │ │ │ │ +_c_o_n_s_t_e_x_p_r result::size_type  rroowwnnuummbbeerr () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Row number, assuming this is a real row and not │ │ │ │ │ end()/rend(). │ │ │ │ │   │ │ │ │ │ ********** CCoolluummnn iinnffoorrmmaattiioonn ********** │ │ │ │ │ - class  ccoonnsstt__rrooww__iitteerraattoorr │ │ │ │ │ + _c_l_a_s_s  ccoonnsstt__rrooww__iitteerraattoorr │ │ │ │ │   │ │ │ │ │ - class  rreessuulltt │ │ │ │ │ + _c_l_a_s_s  rreessuulltt │ │ │ │ │   │ │ │ │ │ template │ │ │ │ │ - class  ppqqxxxx::::iinntteerrnnaall::::rreessuulltt__iitteerr │ │ │ │ │ + _c_l_a_s_s  ppqqxxxx::::iinntteerrnnaall::::rreessuulltt__iitteerr │ │ │ │ │   │ │ │ │ │ - class  ffiieelldd │ │ │ │ │ + _c_l_a_s_s  ffiieelldd │ │ │ │ │   │ │ │ │ │ _r_e_s_u_l_t  mm__rreessuulltt │ │ │ │ │   Result set of which this is one row. │ │ │ │ │   │ │ │ │ │ result::size_type  _m___i_n_d_e_x = 0 │ │ │ │ │   Row number. │ │ │ │ │   │ │ │ │ │ @@ -98,86 +98,89 @@ │ │ │ │ │   First column in slice. This row ignores lower- │ │ │ │ │ numbered columns. │ │ │ │ │   │ │ │ │ │ size_type  mm__eenndd = 0 │ │ │ │ │   End column in slice. This row only sees lower- │ │ │ │ │ numbered columns. │ │ │ │ │   │ │ │ │ │ - size_type  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w col_name) const │ │ │ │ │ + size_type  ccoolluummnn__nnuummbbeerr (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   Number of given column (throws exception if it │ │ │ │ │ doesn't exist). │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (size_type) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (size_type) _c_o_n_s_t │ │ │ │ │   Return a column's type. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttyyppee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   Return a column's type. │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (size_type col_num) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (size_type _c_o_l___n_u_m) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w col_name) const │ │ │ │ │ + _o_i_d  ccoolluummnn__ttaabbllee (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What table did this column come from? │ │ │ │ │   │ │ │ │ │ - size_type  _t_a_b_l_e___c_o_l_u_m_n (size_type) const │ │ │ │ │ + size_type  _t_a_b_l_e___c_o_l_u_m_n (size_type) _c_o_n_s_t │ │ │ │ │   What column number in its table did this result │ │ │ │ │ column come from? │ │ │ │ │   │ │ │ │ │ - size_type  ttaabbllee__ccoolluummnn (_z_v_i_e_w col_name) const │ │ │ │ │ + size_type  ttaabbllee__ccoolluummnn (_z_v_i_e_w _c_o_l___n_a_m_e) _c_o_n_s_t │ │ │ │ │   What column number in its table did this result │ │ │ │ │ column come from? │ │ │ │ │   │ │ │ │ │ -constexpr result::size_type  nnuumm () const noexcept │ │ │ │ │ +_c_o_n_s_t_e_x_p_r result::size_type  nnuumm () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - void  _t_o (Tuple &t) const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_u_p_l_e > │ │ │ │ │ + _v_o_i_d  _t_o (_T_u_p_l_e &_t) _c_o_n_s_t │ │ │ │ │   Extract entire row's values into a tuple. │ │ │ │ │   │ │ │ │ │ template │ │ │ │ │ - std::tuple< TYPE... >  _a_s () const │ │ │ │ │ + std::tuple< TYPE... >  _a_s () _c_o_n_s_t │ │ │ │ │   Extract entire row's values into a tuple. │ │ │ │ │   │ │ │ │ │ - void  sswwaapp (_r_o_w &) noexcept │ │ │ │ │ + _v_o_i_d  sswwaapp (_r_o_w &) _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - _r_o_w  _s_l_i_c_e (size_type sbegin, size_type send) const │ │ │ │ │ + _r_o_w  _s_l_i_c_e (size_type _s_b_e_g_i_n, size_type _s_e_n_d) _c_o_n_s_t │ │ │ │ │   │ │ │ │ │ - PQXX_PURE bool  eemmppttyy () const noexcept │ │ │ │ │ + PQXX_PURE _b_o_o_l  eemmppttyy () _c_o_n_s_t _n_o_e_x_c_e_p_t │ │ │ │ │   Is this a row without fields? Can only happen to a │ │ │ │ │ slice. │ │ │ │ │   │ │ │ │ │ -   _r_o_w (_r_e_s_u_l_t const &r, _r_e_s_u_l_t___s_i_z_e___t_y_p_e index, │ │ │ │ │ - size_type cols) noexcept │ │ │ │ │ +   _r_o_w (_r_e_s_u_l_t _c_o_n_s_t &_r, _r_e_s_u_l_t___s_i_z_e___t_y_p_e index, │ │ │ │ │ + size_type _c_o_l_s) _n_o_e_x_c_e_p_t │ │ │ │ │   │ │ │ │ │ - void  cchheecckk__ssiizzee (size_type expected) const │ │ │ │ │ + _v_o_i_d  cchheecckk__ssiizzee (size_type _e_x_p_e_c_t_e_d) _c_o_n_s_t │ │ │ │ │   Throw _u_s_a_g_e___e_r_r_o_r if row size is not expected. │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - TUPLE  _a_s___t_u_p_l_e () const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_U_P_L_E > │ │ │ │ │ + _T_U_P_L_E  _a_s___t_u_p_l_e () _c_o_n_s_t │ │ │ │ │   Convert to a given tuple of values, don't check │ │ │ │ │ sizes. │ │ │ │ │   │ │ │ │ │ -template │ │ │ │ │ - void  ccoonnvveerrtt (Tuple &t) const │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_u_p_l_e > │ │ │ │ │ + _v_o_i_d  ccoonnvveerrtt (_T_u_p_l_e &_t) _c_o_n_s_t │ │ │ │ │   Convert entire row to tuple fields, without │ │ │ │ │ checking row size. │ │ │ │ │   │ │ │ │ │ ********** DDeettaaiilleedd DDeessccrriippttiioonn ********** │ │ │ │ │ Reference to one row in a result. │ │ │ │ │ A row represents one row (also called a row) in a query result set. It also │ │ │ │ │ acts as a container mapping column numbers or names to field values (see │ │ │ │ │ below): │ │ │ │ │ -cout << _r_o_w["date"].c_str() << ": " << _r_o_w["name"].c_str() << endl; │ │ │ │ │ +_c_o_u_t << _r_o_w["date"].c_str() << ": " << _r_o_w["name"].c_str() << _e_n_d_l; │ │ │ │ │ +_p_q_x_x_:_:_c_o_n_s_t___r_e_v_e_r_s_e___r_o_w___i_t_e_r_a_t_o_r │ │ │ │ │ +Reverse iterator for a row. Use as row::const_reverse_iterator. │ │ │ │ │ +DDeeffiinniittiioonn row.hxx:406 │ │ │ │ │ _p_q_x_x_:_:_r_o_w │ │ │ │ │ Reference to one row in a result. │ │ │ │ │ DDeeffiinniittiioonn row.hxx:47 │ │ │ │ │ The row itself acts like a (non-modifyable) container, complete with its own │ │ │ │ │ const_iterator and const_reverse_iterator. │ │ │ │ │ ********** CCoonnssttrruuccttoorr && DDeessttrruuccttoorr DDooccuummeennttaattiioonn ********** │ │ │ │ │ ********** _?◆_? rrooww(()) ********** │ │ │ │ │ -pqxx::row::row ( _r_e_s_u_l_t const &  rr, │ │ │ │ │ +pqxx::row::row ( _r_e_s_u_l_t _c_o_n_s_t &  rr, │ │ │ │ │ _r_e_s_u_l_t___s_i_z_e___t_y_p_e  iinnddeexx, protectednoexcept │ │ │ │ │ size_type  ccoollss  │ │ │ │ │ ) │ │ │ │ │ Implementation of the _p_q_x_x_:_:_r_e_s_u_l_t class and support classes. │ │ │ │ │ _p_q_x_x_:_:_r_e_s_u_l_t represents the set of result rows from a database query. │ │ │ │ │ Copyright (c) 2000-2024, Jeroen T. Vermeulen. │ │ │ │ │ See COPYING for copyright license. If you did not receive a file called COPYING │ │ │ │ │ @@ -191,16 +194,16 @@ │ │ │ │ │ Converts to the types of the tuple's respective fields. │ │ │ │ │ The types must have conversions from PostgreSQL's text format defined; see │ │ │ │ │ _S_u_p_p_o_r_t_i_n_g_ _a_d_d_i_t_i_o_n_a_l_ _d_a_t_a_ _t_y_p_e_s. │ │ │ │ │ Exceptions │ │ │ │ │ _u_s_a_g_e___e_r_r_o_r If the number of columns in the row does not match the number │ │ │ │ │ of fields in t. │ │ │ │ │ ********** _?◆_? aass__ttuuppllee(()) ********** │ │ │ │ │ -template │ │ │ │ │ -TUPLE pqxx::row::as_tuple ( ) const inlineprotected │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_U_P_L_E > │ │ │ │ │ +_T_U_P_L_E pqxx::row::as_tuple ( ) const inlineprotected │ │ │ │ │ Convert to a given tuple of values, don't check sizes. │ │ │ │ │ We need this for cases where we have a full tuple of field types, but not a │ │ │ │ │ parameter pack. │ │ │ │ │ ********** _?◆_? aatt(()) ********** │ │ │ │ │ _p_q_x_x_:_:_f_i_e_l_d pqxx::row::at ( _z_v_i_e_w  ccooll__nnaammee ) const │ │ │ │ │ Address field by name. │ │ │ │ │ Warning │ │ │ │ │ @@ -229,16 +232,16 @@ │ │ │ │ │ from a column in a table. If the column is computed in any other way, a │ │ │ │ │ logic_error will be thrown. │ │ │ │ │ Parameters │ │ │ │ │ col_num a zero-based column number in this result set │ │ │ │ │ Returns │ │ │ │ │ a zero-based column number in originating table │ │ │ │ │ ********** _?◆_? ttoo(()) ********** │ │ │ │ │ -template │ │ │ │ │ -void pqxx::row::to ( Tuple &  tt ) const inline │ │ │ │ │ +template<_t_y_p_e_n_a_m_e _T_u_p_l_e > │ │ │ │ │ +_v_o_i_d pqxx::row::to ( _T_u_p_l_e &  tt ) const inline │ │ │ │ │ Extract entire row's values into a tuple. │ │ │ │ │ Converts to the types of the tuple's respective fields. │ │ │ │ │ The types in the tuple must have conversions from PostgreSQL's text format │ │ │ │ │ defined; see _S_u_p_p_o_r_t_i_n_g_ _a_d_d_i_t_i_o_n_a_l_ _d_a_t_a_ _t_y_p_e_s. │ │ │ │ │ Exceptions │ │ │ │ │ _u_s_a_g_e___e_r_r_o_r If the number of columns in the row does not match the number │ │ │ │ │ of fields in t. │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1stream__from.html │ │ │ │ @@ -209,15 +209,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ - │ │ │ │ + │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
void pqxx::row::to void pqxx::row::to (Tuple & Tuple & t) const
│ │ │ │ 		│ │ │ │ inline
 
static stream_from table (transaction_base &tx, table_path path, std::initializer_list< std::string_view > columns={})
 Factory: Stream data from a given table.
 
│ │ │ │

Detailed Description

│ │ │ │

Stream data from the database.

│ │ │ │ -
Deprecated:
Use transaction_base::stream.
│ │ │ │ +
Deprecated:
Use transaction_base::stream.
│ │ │ │

For larger data sets, retrieving data this way is likely to be faster than executing a query and then iterating and converting the rows fields. You will also be able to start processing before all of the data has come in.

│ │ │ │

There are also downsides. Not all kinds of query will work in a stream. But straightforward SELECT and UPDATE ... RETURNING queries should work. This function makes use of pqxx::stream_from, which in turn uses PostgreSQL's COPY command, so see the documentation for those to get the full details.

│ │ │ │

There are other downsides. If there stream encounters an error, it may leave the entire connection in an unusable state, so you'll have to give the whole thing up. Finally, opening a stream puts the connection in a special state, so you won't be able to do many other things with the connection or the transaction while the stream is open.

│ │ │ │

There are two ways of starting a stream: you stream either all rows in a table (using one of the factories, table() or raw_table()), or the results of a query (using the query() factory).

│ │ │ │

Usually you'll want the stream convenience wrapper in transaction_base, * so you don't need to deal with this class directly.

│ │ │ │
Warning
While a stream is active, you cannot execute queries, open a pipeline, etc. on the same transaction. A transaction can have at most one object of a type derived from pqxx::transaction_focus active on it at a time.
│ │ │ │

Constructor & Destructor Documentation

│ │ │ │ @@ -250,15 +250,15 @@ │ │ │ │
)
│ │ │ │
│ │ │ │ │ │ │ │

Execute query, and stream over the results.

│ │ │ │ -
Deprecated:
Use factory function query instead.
│ │ │ │ +
Deprecated:
Use factory function query instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [2/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -287,15 +287,15 @@ │ │ │ │
)
│ │ │ │
│ │ │ │ │ │ │ │

Stream all rows in table, all columns.

│ │ │ │ -
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ +
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [3/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -346,15 +346,15 @@ │ │ │ │
│ │ │ │ inline
│ │ │ │
│ │ │ │ │ │ │ │

Stream given columns from all rows in table.

│ │ │ │ -
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ +
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [4/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -399,15 +399,15 @@ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Stream given columns from all rows in table.

│ │ │ │ -
Deprecated:
Use factory function query instead.
│ │ │ │ +
Deprecated:
Use factory function query instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [5/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -436,15 +436,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ -
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ +
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [6/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -481,15 +481,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ -
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ +
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_from() [7/7]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -524,15 +524,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ ) │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ -
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ +
Deprecated:
Use factories table or raw_table instead.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │

Member Function Documentation

│ │ │ │ │ │ │ │

◆ complete()

│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/classpqxx_1_1stream__to.html │ │ │ │ @@ -222,15 +222,15 @@ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Create a stream, without specifying columns.

│ │ │ │ -
Deprecated:
Use table or raw_table as a factory.
│ │ │ │ +
Deprecated:
Use table or raw_table as a factory.
│ │ │ │

Fields will be inserted in whatever order the columns have in the database.

│ │ │ │

You'll probably want to specify the columns, so that the mapping between your data fields and the table is explicit in your code, and not hidden in an "implicit contract" between your code and your schema.

│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ stream_to() [2/3]

│ │ │ │ @@ -271,15 +271,15 @@ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Create a stream, specifying column names as a container of strings.

│ │ │ │ -
Deprecated:
Use table or raw_table as a factory.
│ │ │ │ +
Deprecated:
Use table or raw_table as a factory.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ stream_to() [3/3]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -324,15 +324,15 @@ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Create a stream, specifying column names as a sequence of strings.

│ │ │ │ -
Deprecated:
Use table or raw_table as a factory.
│ │ │ │ +
Deprecated:
Use table or raw_table as a factory.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Member Function Documentation

│ │ │ │ │ │ │ │

◆ complete()

│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/datatypes.html │ │ │ │ @@ -93,52 +93,52 @@ │ │ │ │
Supporting additional data types
│ │ │ │ │ │ │ │
│ │ │ │

Communication with the database mostly happens in a text format. When you include an integer value in a query, either you use to_string to convert it to that text format, or under the bonnet, libpqxx does it for you. When you get a query result field "as a float," libpqxx converts from the text format to a floating-point type. These conversions are everywhere in libpqxx.

│ │ │ │

The conversion system supports many built-in types, but it is also extensible. You can "teach" libpqxx (in the scope of your own application) to convert additional types of values to and from PostgreSQL's string format.

│ │ │ │

This is massively useful, but it's not for the faint of heart. You'll need to specialise some templates. And, the API for doing this can change with any major libpqxx release.

│ │ │ │

If that happens, your code may fail to compile with the newer libpqxx version, and you'll have to go through the NEWS file to find the API changes. Usually it'll be a small change, like an additional function you need to implement, or a constant you need to define.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Converting types

│ │ │ │

In your application, a conversion is driven entirely by a C++ type you specify. The value's SQL type on the database side has nothing to do with it. Nor is there anything in the string that would identify its type. Your code says "convert to this type" and libpqxx does it.

│ │ │ │

So, if you've SELECTed a 64-bit integer from the database, and you try to convert it to a C++ short, one of two things will happen: either the number is small enough to fit in your short and it just works, or else it throws a conversion exception. Similarly, if you try to read a 32-bit SQL int as a C++ 32-bit unsigned int, that'll work fine, unless the value happens to be negative. In such cases the conversion will throw a conversion_error.

│ │ │ │

Or, your database table might have a text column, but a given field may contain a string that looks just like a number. You can convert that value to an integer type just fine. Or to a floating-point type. All that matters to the conversion is the actual value, and the type your code specifies.

│ │ │ │

In some cases the templates for these conversions can tell the type from the arguments you pass them:

│ │ │ │
auto x = to_string(99);
│ │ │ │

In other cases you may need to instantiate template explicitly:

│ │ │ │
auto y = from_string<int>("99");
│ │ │ │ -

│ │ │ │ +

│ │ │ │ Supporting a new type

│ │ │ │

Let's say you have some other SQL type which you want to be able to store in, or retrieve from, the database. What would it take to support that?

│ │ │ │

Sometimes you do not need complete support. You might need a conversion to a string but not from a string, for example. You write out the conversion at compile time, so don't be too afraid to be incomplete. If you leave out one of these steps, it's not going to crash at run time or mess up your data. The worst that can happen is that your code won't build.

│ │ │ │

So what do you need for a complete conversion?

│ │ │ │

First off, of course, you need a C++ type. It may be your own, but it doesn't have to be. It could be a type from a third-party library, or even one from the standard library that libpqxx does not yet support.

│ │ │ │

First thing to do is specialise the pqxx::type_name variable to give the type a human-readable name. That allows libpqxx error messages and such to talk about the type. If you don't define a name, libpqxx will try to figure one out with some help from the compiler, but it may not always be easy to read.

│ │ │ │

Then, does your type have a built-in null value? For example, a char * can be null on the C++ side. Or some types are always null, such as nullptr. You specialise the pqxx::nullness template to specify the details.

│ │ │ │

Finally, you specialise the pqxx::string_traits template. This is where you define the actual conversions.

│ │ │ │

Let's go through these steps one by one.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Your type

│ │ │ │

You'll need a type for which the conversions are not yet defined, because the C++ type is what determines the right conversion. One type, one set of conversions.

│ │ │ │

The type doesn't have to be one that you create. The conversion logic was designed such that you can build it around any type. So you can just as easily build a conversion for a type that's defined somewhere else. There's no need to include any special methods or other members inside the type itself. That's also why libpqxx can convert built-in types like int.

│ │ │ │

By the way, if the type is an enum, you don't need to do any of this. Just invoke the preprocessor macro PQXX_DECLARE_ENUM_CONVERSION, from the global namespace near the top of your translation unit, and pass the type as an argument.

│ │ │ │

The library also provides specialisations for std::optional<T>, std::shared_ptr<T>, and std::unique_ptr<T>. If you have conversions for T, you'll also automatically have conversions for those.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Specialise <tt>type_name</tt>

│ │ │ │

When errors happen during conversion, libpqxx will compose error messages for the user. Sometimes these will include the name of the type that's being converted.

│ │ │ │

To tell libpqxx the name of each type, there's a template variable called pqxx::type_name. For any given type T, it should have a specialisation that provides that T's human-readable name:

│ │ │ │
// T is your type.
│ │ │ │
namespace pqxx
│ │ │ │
{
│ │ │ │
template<> std::string const type_name<T>{"My T type's name"};
│ │ │ │
}
│ │ │ │
pqxx
The home of all libpqxx classes, functions, templates, etc.
Definition array.cxx:27
│ │ │ │

(Yes, this means that you need to define something inside the pqxx namespace. Future versions of libpqxx may move this into a separate namespace.)

│ │ │ │

Define this early on in your translation unit, before any code that might cause libpqxx to need the name. That way, the libpqxx code which needs to know the type's name can see your definition.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Specialise <tt>nullness</tt>

│ │ │ │

A struct template pqxx::nullness defines whether your type has a natural "null value" built in. If so, it also provides member functions for producing and recognising null values.

│ │ │ │

The simplest scenario is also the most common: most types don't have a null value built in. There is no "null `int`" in C++. In that kind of case, just derive your nullness traits from pqxx::no_null as a shorthand:

│ │ │ │
// T is your type.
│ │ │ │
namespace pqxx
│ │ │ │
{
│ │ │ │
template<> struct nullness<T> : pqxx::no_null<T> {};
│ │ │ │ @@ -172,15 +172,15 @@ │ │ │ │
}
│ │ │ │
pqxx::nullness::is_null
static bool is_null(TYPE const &value)
Is value a null?
│ │ │ │
pqxx::nullness::null
static TYPE null()
Return a null value.
│ │ │ │
pqxx::nullness::has_null
static bool has_null
Does this type have a null value?
Definition strconv.hxx:93
│ │ │ │
pqxx::nullness::always_null
static bool always_null
Is this type always null?
Definition strconv.hxx:96
│ │ │ │

You may be wondering why there's a function to produce a null value, but also a function to check whether a value is null. Why not just compare the value to the result of null()? Because two null values may not be equal (like in SQL, where NULL <> NULL). Or T may have multiple different null values. Or T may override the comparison operator to behave in some unusual way.

│ │ │ │

As a third case, your type may be one that always represents a null value. This is the case for std::nullptr_t and std::nullopt_t. In that case, you set nullness<TYPE>::always_null to true (as well as has_null of course), and you won't need to define any actual conversions.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Specialise <tt>string_traits</tt>

│ │ │ │

This part is the most work. You can skip it for types that are always null, but those will be rare.

│ │ │ │

The APIs for doing this are designed so that you don't need to allocate memory on the free store, also known as "the heap": new/delete. Memory allocation can be hidden inside std::string, std::vector, etc. The conversion API allows you to use std::string for convenience, or memory buffers for speed.

│ │ │ │

Start by specialising the pqxx::string_traits template. You don't absolutely have to implement all parts of this API. Generally, if it compilers, you're OK for the time being. Just bear in mind that future libpqxx versions may change the API — or how it uses the API internally.

│ │ │ │
namespace pqxx
│ │ │ │
{
│ │ │ │
// T is your type.
│ │ │ │ @@ -211,22 +211,22 @@ │ │ │ │
pqxx::string_traits::from_string
static TYPE from_string(std::string_view text)
Parse a string representation of a TYPE value.
│ │ │ │
pqxx::string_traits::size_buffer
static std::size_t size_buffer(TYPE const &value) noexcept
Estimate how much buffer space is needed to represent value.
│ │ │ │
pqxx::string_traits::to_buf
static zview to_buf(char *begin, char *end, TYPE const &value)
Return a string_view representing value, plus terminating zero.
│ │ │ │
pqxx::string_traits::converts_to_string
static constexpr bool converts_to_string
Is conversion from TYPE to strings supported?
Definition strconv.hxx:158
│ │ │ │
pqxx::string_traits::into_buf
static char * into_buf(char *begin, char *end, TYPE const &value)
Write value's string representation into buffer at begin.
│ │ │ │
pqxx::string_traits::converts_from_string
static constexpr bool converts_from_string
Is conversion from string_view to TYPE supported?
Definition strconv.hxx:164
│ │ │ │

You'll also need to write those member functions, or as many of them as needed to get your code to build.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ <tt>from_string</tt>

│ │ │ │

We start off simple: from_string parses a string as a value of T, and returns that value.

│ │ │ │

The string may or may not be zero-terminated; it's just the string_view from beginning to end (with end being exclusive). In your tests, be sure to cover cases where the string does not end in a zero byte!

│ │ │ │

It's perfectly possible that the string doesn't actually represent a T value. Mistakes happen. There can be corner cases. When you run into this, throw a pqxx::conversion_error.

│ │ │ │

(Of course it's also possible that you run into some other error, so it's fine to throw different exceptions as well. But when it's definitely "this is not │ │ │ │ the right format for a `T`," throw conversion_error.)

│ │ │ │ -

│ │ │ │ +

│ │ │ │ <tt>to_buf</tt>

│ │ │ │

In this function, you convert a value of T into a string that the postgres server will understand.

│ │ │ │

The caller will provide you with a buffer where you can write the string, if you need it: from begin to end exclusive. It's a half-open interval, so don't access *end.

│ │ │ │

If the buffer is insufficient for you to do the conversion, throw a pqxx::conversion_overrun. It doesn't have to be exact: you can be a little pessimistic and demand a bit more space than you need. Just be sure to throw the exception if there's any risk of overrunning the buffer.

│ │ │ │

You don't have to use the buffer for this function though. For example, pqxx::string_traits<bool>::to_buf returns a compile-time constant string and completely ignores the buffer.

│ │ │ │

Even if you do use the buffer, your string does not have to start at the beginning of the buffer. For example, the integer conversions may work from right to left, if that's easier: they can start by writing the least significant digit to the end of the buffer, divide the remainder by 10, and repeat for the next digit.

│ │ │ │

Return a pqxx::zview. This is basically a std::string_view, but with one difference: when you create a zview you guarantee that there is a valid zero byte right after the string_view. The zero byte does not count as part of its size, but it has to be there.

│ │ │ │ @@ -234,36 +234,36 @@ │ │ │ │
void invariant(zview z)
│ │ │ │
{
│ │ │ │
assert(z[std::size(z)] == 0);
│ │ │ │
}
│ │ │ │

The trailing zero should not go inside the zview, but if you convert into the buffer, do make sure you that trailing stays inside the buffer, i.e. before the end. (If there's no room for that zero inside the buffer, throw pqxx::conversion_error).

│ │ │ │

Beware of locales when converting. If you use standard library features like sprintf, they may obey whatever locale is currently set on the system where the code runs. That means that a simple integer like 1000000 may come out as "1000000" on your system, but as "1,000,000" on mine, or as "1.000.000" for somebody else, and on an Indian system it may be "1,00,000". Don't let that happen, or it will confuse things. Use only non-locale-sensitive library functions. Values coming from or going to the database should be in fixed, non-localised formats.

│ │ │ │

If your conversions need to deal with fields in types that libpqxx already supports, you can use the conversion functions for those: pqxx::from_string, pqxx::to_string, pqxx::to_buf. They in turn will call the string_traits specialisations for those types. Or, you can call their string_traits directly.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ <tt>into_buf</tt>

│ │ │ │

This is a stricter version of to_buf. All the same requirements apply, but in addition you must write your string into the given buffer, starting exactly at begin.

│ │ │ │

That's why this function returns just a simple pointer: the address right behind the trailing zero. If the caller wants to use the string, they can find it at begin. If they want to write another value into the rest of the buffer, they can continue writing at the location you returned.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ <tt>size_buffer</tt>

│ │ │ │

Here you estimate how much buffer space you need for converting a T to a string. Be precise if you can, but pessimistic if you must. It's usually better to waste a few bytes of space than to spend a lot of time computing the exact buffer space you need. And failing the conversion because you under-budgeted the buffer is worst of all.

│ │ │ │

Include the trailing zero in the buffer size. If your to_buf takes more space than just what's needed to store the result, include that too.

│ │ │ │

Make size_buffer a constexpr function if you can. It can allow the caller to allocate the buffer on the stack, with a size known at compile time.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Optional: Specialise <tt>is_unquoted_safe</tt>

│ │ │ │

When converting arrays or composite values to strings, libpqxx may need to quote values and escape any special characters. This takes time.

│ │ │ │

Some types though, such as integral or floating-point types, can never have any special characters such as quotes, commas, or backslashes in their string representations. In such cases, there's no need to quote or escape such values in SQL arrays or composite types.

│ │ │ │

If your type is like that, you can tell libpqxx about this by defining:

│ │ │ │
namespace pqxx
│ │ │ │
{
│ │ │ │
// T is your type.
│ │ │ │
template<> inline constexpr bool is_unquoted_safe<T>{true};
│ │ │ │
}
│ │ │ │

The code that converts this type of field to strings in an array or a composite type can then use a simpler, more efficient variant of the code. It's always safe to leave this out; it's just an optimisation for when you're completely sure that it's safe.

│ │ │ │

Do not do this if a string representation of your type may contain a comma; semicolon; parenthesis; brace; quote; backslash; newline; or any other character that might need escaping.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Optional: Specialise <tt>param_format</tt>

│ │ │ │

This one you don't generally need to worry about. Read on if you're writing a type which represents raw binary data, or if you're writing a template where some specialisations may contain raw binary data.

│ │ │ │

When you call parameterised statements, or prepared statements with parameters, libpqxx needs to pass your parameters on to libpq, the underlying C-level PostgreSQL client library.

│ │ │ │

There are two formats for doing that: text and binary. In the first, we represent all values as strings in the PostgreSQL text format, and the server then converts them into its own internal binary representation. That's what those string conversions above are all about, and it's what we do for almost all types of parameters.

│ │ │ │

But we do it differently when the parameter is a contiguous series of raw bytes and the corresponding SQL type is BYTEA. There is a text format for those, but we bypass it for efficiency. The server can use the binary data in the exact same form, without any conversion or extra processing. The binary data is also twice as compact during transport.

│ │ │ │

(People sometimes ask why we can't just treat all types as binary. However the general case isn't so clear-cut. The binary formats are not documented, there are no guarantees that they will be platform-independent or that they will remain stable across postgres releases, and there's no really solid way to detect when we might get the format wrong. On top of all that, the conversions aren't necessarily as straightforward and efficient as they sound. So, for the general case, libpqxx sticks with the text formats. Raw binary data alone stands out as a clear win.)

│ │ │ │

Long story short, the machinery for passing parameters needs to know: is this parameter a binary string, or not? In the normal case it can assume "no," and that's what it does. The text format is always a safe choice; we just try to use the binary format where it's faster.

│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/deprecated.html │ │ │ │ @@ -93,81 +93,81 @@ │ │ │ │
Deprecated List
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │
Class pqxx::basic_fieldstream< CHAR, TRAITS >
│ │ │ │
To convert a field's value string to some other type, e.g. to an int, use the field's as<...>() member function. To read a field efficiently just as a string, use its c_str() or its as<std::string_vview>().
│ │ │ │
Class pqxx::basic_ilostream< CHAR, TRAITS >
│ │ │ │ -
Access large objects directly using the blob class.
│ │ │ │ +
Access large objects directly using the blob class.
│ │ │ │
Class pqxx::basic_lostream< CHAR, TRAITS >
│ │ │ │ -
Access large objects directly using the blob class.
│ │ │ │ +
Access large objects directly using the blob class.
│ │ │ │
Class pqxx::basic_olostream< CHAR, TRAITS >
│ │ │ │ -
Access large objects directly using the blob class.
│ │ │ │ +
Access large objects directly using the blob class.
│ │ │ │
Class pqxx::binarystring
│ │ │ │
Use bytes and bytes_view for binary data. In C++20 or better, any contiguous_range of std::byte will do.
│ │ │ │
Member pqxx::blob::read (std::vector< std::byte, ALLOC > &buf)
│ │ │ │
As libpqxx moves to C++20 as its baseline language version, this will take and return std::span<std::byte>.
│ │ │ │
Member pqxx::connection::set_variable (std::string_view var, std::string_view value) &
│ │ │ │ -
To set a session variable, use set_session_var. To set a transaction-local variable, execute an SQL SET command.
│ │ │ │ +
To set a session variable, use set_session_var. To set a transaction-local variable, execute an SQL SET command.
│ │ │ │
Member pqxx::connection_base
│ │ │ │ -
Old base class for connection. They are now the same class.
│ │ │ │ -
Member pqxx::encrypt_password (zview user, zview password)
│ │ │ │ -
Use connection::encrypt_password instead.
│ │ │ │ +
Old base class for connection. They are now the same class.
│ │ │ │
Member pqxx::encrypt_password (char const user[], char const password[])
│ │ │ │ -
Use connection::encrypt_password instead.
│ │ │ │ +
Use connection::encrypt_password instead.
│ │ │ │ +
Member pqxx::encrypt_password (zview user, zview password)
│ │ │ │ +
Use connection::encrypt_password instead.
│ │ │ │
Member pqxx::fieldstream
│ │ │ │
Read a field using field::as<...>() or field::c_str().
│ │ │ │
Member pqxx::from_query
│ │ │ │ -
Use transaction_base::stream instead of stream_from.
│ │ │ │ +
Use transaction_base::stream instead of stream_from.
│ │ │ │
Struct pqxx::from_query_t
│ │ │ │ -
Use stream_from::query() instead.
│ │ │ │ +
Use stream_from::query() instead.
│ │ │ │
Member pqxx::from_table
│ │ │ │ -
Use transaction_base::stream instead of stream_from.
│ │ │ │ +
Use transaction_base::stream instead of stream_from.
│ │ │ │
Struct pqxx::from_table_t
│ │ │ │ -
Use stream_from::table() instead.
│ │ │ │ +
Use stream_from::table() instead.
│ │ │ │
Class pqxx::internal::dynamic_params< IT, ACCESSOR >
│ │ │ │
Use params instead.
│ │ │ │
Class pqxx::largeobject
│ │ │ │ -
Use the blob class instead.
│ │ │ │ +
Use the blob class instead.
│ │ │ │
Class pqxx::largeobject_streambuf< CHAR, TRAITS >
│ │ │ │ -
Access large objects directly using the blob class.
│ │ │ │ +
Access large objects directly using the blob class.
│ │ │ │
Class pqxx::largeobjectaccess
│ │ │ │ -
Use the blob class instead.
│ │ │ │ +
Use the blob class instead.
│ │ │ │
Member pqxx::operator<< (std::basic_ostream< CHAR > &s, field const &value)
│ │ │ │
The C++ streams library is not great to work with. In particular, error handling is easy to get wrong. So you're probably better off doing this by hand.
│ │ │ │
Member pqxx::params::append (binarystring const &value) &
│ │ │ │ -
Append binarystring parameter.
│ │ │ │ +
Append binarystring parameter.
│ │ │ │
Namespace pqxx::prepare
│ │ │ │ -
The new params class replaces all of this.
│ │ │ │ +
The new params class replaces all of this.
│ │ │ │
Member pqxx::row::slice (size_type sbegin, size_type send) const
│ │ │ │ -
I haven't heard of anyone caring about row slicing at all in at least the last 15 years. Yet it adds complexity, so unless anyone files a bug explaining why they really need this feature, I'm going to remove it. Even if they do, the feature may need an update.
│ │ │ │ +
I haven't heard of anyone caring about row slicing at all in at least the last 15 years. Yet it adds complexity, so unless anyone files a bug explaining why they really need this feature, I'm going to remove it. Even if they do, the feature may need an update.
│ │ │ │
Class pqxx::stream_from
│ │ │ │ -
Use transaction_base::stream.
│ │ │ │ -
Member pqxx::stream_from::stream_from (transaction_base &, from_query_t, std::string_view query)
│ │ │ │ -
Use factory function query instead.
│ │ │ │ -
Member pqxx::stream_from::stream_from (transaction_base &, from_table_t, std::string_view table)
│ │ │ │ -
Use factories table or raw_table instead.
│ │ │ │ +
Use transaction_base::stream.
│ │ │ │
Member pqxx::stream_from::stream_from (transaction_base &, from_table_t, std::string_view table, Iter columns_begin, Iter columns_end)
│ │ │ │ -
Use factories table or raw_table instead.
│ │ │ │ -
Member pqxx::stream_from::stream_from (transaction_base &tx, from_table_t, std::string_view table, Columns const &columns)
│ │ │ │ -
Use factory function query instead.
│ │ │ │ -
Member pqxx::stream_from::stream_from (transaction_base &tx, std::string_view table)
│ │ │ │ -
Use factories table or raw_table instead.
│ │ │ │ -
Member pqxx::stream_from::stream_from (transaction_base &tx, std::string_view table, Columns const &columns)
│ │ │ │ -
Use factories table or raw_table instead.
│ │ │ │ +
Use factories table or raw_table instead.
│ │ │ │
Member pqxx::stream_from::stream_from (transaction_base &, std::string_view table, Iter columns_begin, Iter columns_end)
│ │ │ │ -
Use factories table or raw_table instead.
│ │ │ │ -
Member pqxx::stream_to::stream_to (transaction_base &tx, std::string_view table_name)
│ │ │ │ -
Use table or raw_table as a factory.
│ │ │ │ -
Member pqxx::stream_to::stream_to (transaction_base &, std::string_view table_name, Columns const &columns)
│ │ │ │ -
Use table or raw_table as a factory.
│ │ │ │ +
Use factories table or raw_table instead.
│ │ │ │ +
Member pqxx::stream_from::stream_from (transaction_base &tx, std::string_view table, Columns const &columns)
│ │ │ │ +
Use factories table or raw_table instead.
│ │ │ │ +
Member pqxx::stream_from::stream_from (transaction_base &tx, std::string_view table)
│ │ │ │ +
Use factories table or raw_table instead.
│ │ │ │ +
Member pqxx::stream_from::stream_from (transaction_base &tx, from_table_t, std::string_view table, Columns const &columns)
│ │ │ │ +
Use factory function query instead.
│ │ │ │ +
Member pqxx::stream_from::stream_from (transaction_base &, from_table_t, std::string_view table)
│ │ │ │ +
Use factories table or raw_table instead.
│ │ │ │ +
Member pqxx::stream_from::stream_from (transaction_base &, from_query_t, std::string_view query)
│ │ │ │ +
Use factory function query instead.
│ │ │ │
Member pqxx::stream_to::stream_to (transaction_base &, std::string_view table_name, Iter columns_begin, Iter columns_end)
│ │ │ │ +
Use table or raw_table as a factory.
│ │ │ │ +
Member pqxx::stream_to::stream_to (transaction_base &, std::string_view table_name, Columns const &columns)
│ │ │ │
Use table or raw_table as a factory.
│ │ │ │ +
Member pqxx::stream_to::stream_to (transaction_base &tx, std::string_view table_name)
│ │ │ │ +
Use table or raw_table as a factory.
│ │ │ │
Member pqxx::strip_t
│ │ │ │ -
In C++20 we'll replace this with std::remove_cvref.
│ │ │ │ +
In C++20 we'll replace this with std::remove_cvref.
│ │ │ │
Member pqxx::transaction_base::set_variable (std::string_view var, std::string_view value)
│ │ │ │
To set a transaction-local variable, execute an SQL SET command. To set a session variable, use the connection's set_session_var function.
│ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ ├── html2text {} │ │ │ │ │ @@ -22,18 +22,18 @@ │ │ │ │ │ take and return std::span. │ │ │ │ │ Member _p_q_x_x_:_:_c_o_n_n_e_c_t_i_o_n_:_:_s_e_t___v_a_r_i_a_b_l_e (std::string_view var, std::string_view │ │ │ │ │ value) & │ │ │ │ │ To set a session variable, use _s_e_t___s_e_s_s_i_o_n___v_a_r. To set a transaction- │ │ │ │ │ local variable, execute an SQL SET command. │ │ │ │ │ Member _p_q_x_x_:_:_c_o_n_n_e_c_t_i_o_n___b_a_s_e │ │ │ │ │ Old base class for connection. They are now the same class. │ │ │ │ │ - Member _p_q_x_x_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d (zview user, zview password) │ │ │ │ │ - Use _c_o_n_n_e_c_t_i_o_n_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d instead. │ │ │ │ │ Member _p_q_x_x_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d (char const user[], char const password[]) │ │ │ │ │ Use _c_o_n_n_e_c_t_i_o_n_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d instead. │ │ │ │ │ + Member _p_q_x_x_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d (zview user, zview password) │ │ │ │ │ + Use _c_o_n_n_e_c_t_i_o_n_:_:_e_n_c_r_y_p_t___p_a_s_s_w_o_r_d instead. │ │ │ │ │ Member _p_q_x_x_:_:_f_i_e_l_d_s_t_r_e_a_m │ │ │ │ │ Read a field using _f_i_e_l_d_:_:_a_s<...>() or _f_i_e_l_d_:_:_c___s_t_r_(_). │ │ │ │ │ Member _p_q_x_x_:_:_f_r_o_m___q_u_e_r_y │ │ │ │ │ Use _t_r_a_n_s_a_c_t_i_o_n___b_a_s_e_:_:_s_t_r_e_a_m instead of _s_t_r_e_a_m___f_r_o_m. │ │ │ │ │ Struct _p_q_x_x_:_:_f_r_o_m___q_u_e_r_y___t │ │ │ │ │ Use _s_t_r_e_a_m___f_r_o_m_:_:_q_u_e_r_y_(_) instead. │ │ │ │ │ Member _p_q_x_x_:_:_f_r_o_m___t_a_b_l_e │ │ │ │ │ @@ -59,43 +59,43 @@ │ │ │ │ │ Member _p_q_x_x_:_:_r_o_w_:_:_s_l_i_c_e (size_type sbegin, size_type send) const │ │ │ │ │ I haven't heard of anyone caring about row slicing at all in at least the │ │ │ │ │ last 15 years. Yet it adds complexity, so unless anyone files a bug │ │ │ │ │ explaining why they really need this feature, I'm going to remove it. │ │ │ │ │ Even if they do, the feature may need an update. │ │ │ │ │ Class _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m │ │ │ │ │ Use _t_r_a_n_s_a_c_t_i_o_n___b_a_s_e_:_:_s_t_r_e_a_m. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, _f_r_o_m___q_u_e_r_y___t, │ │ │ │ │ - std::string_view query) │ │ │ │ │ - Use factory function _q_u_e_r_y instead. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, _f_r_o_m___t_a_b_l_e___t, │ │ │ │ │ - std::string_view table) │ │ │ │ │ - Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, _f_r_o_m___t_a_b_l_e___t, │ │ │ │ │ std::string_view table, Iter columns_begin, Iter columns_end) │ │ │ │ │ Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, _f_r_o_m___t_a_b_l_e___t, │ │ │ │ │ - std::string_view table, Columns const &columns) │ │ │ │ │ - Use factory function _q_u_e_r_y instead. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, std::string_view │ │ │ │ │ - table) │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, std::string_view │ │ │ │ │ + table, Iter columns_begin, Iter columns_end) │ │ │ │ │ Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, std::string_view │ │ │ │ │ table, Columns const &columns) │ │ │ │ │ Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, std::string_view │ │ │ │ │ - table, Iter columns_begin, Iter columns_end) │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, std::string_view │ │ │ │ │ + table) │ │ │ │ │ Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___t_o_:_:_s_t_r_e_a_m___t_o (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, std::string_view │ │ │ │ │ - table_name) │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, _f_r_o_m___t_a_b_l_e___t, │ │ │ │ │ + std::string_view table, Columns const &columns) │ │ │ │ │ + Use factory function _q_u_e_r_y instead. │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, _f_r_o_m___t_a_b_l_e___t, │ │ │ │ │ + std::string_view table) │ │ │ │ │ + Use factories _t_a_b_l_e or _r_a_w___t_a_b_l_e instead. │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___f_r_o_m_:_:_s_t_r_e_a_m___f_r_o_m (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, _f_r_o_m___q_u_e_r_y___t, │ │ │ │ │ + std::string_view query) │ │ │ │ │ + Use factory function _q_u_e_r_y instead. │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___t_o_:_:_s_t_r_e_a_m___t_o (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, std::string_view │ │ │ │ │ + table_name, Iter columns_begin, Iter columns_end) │ │ │ │ │ Use _t_a_b_l_e or _r_a_w___t_a_b_l_e as a factory. │ │ │ │ │ Member _p_q_x_x_:_:_s_t_r_e_a_m___t_o_:_:_s_t_r_e_a_m___t_o (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, std::string_view │ │ │ │ │ table_name, Columns const &columns) │ │ │ │ │ Use _t_a_b_l_e or _r_a_w___t_a_b_l_e as a factory. │ │ │ │ │ - Member _p_q_x_x_:_:_s_t_r_e_a_m___t_o_:_:_s_t_r_e_a_m___t_o (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &, std::string_view │ │ │ │ │ - table_name, Iter columns_begin, Iter columns_end) │ │ │ │ │ + Member _p_q_x_x_:_:_s_t_r_e_a_m___t_o_:_:_s_t_r_e_a_m___t_o (_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e &tx, std::string_view │ │ │ │ │ + table_name) │ │ │ │ │ Use _t_a_b_l_e or _r_a_w___t_a_b_l_e as a factory. │ │ │ │ │ Member _p_q_x_x_:_:_s_t_r_i_p___t │ │ │ │ │ In C++20 we'll replace this with std::remove_cvref. │ │ │ │ │ Member _p_q_x_x_:_:_t_r_a_n_s_a_c_t_i_o_n___b_a_s_e_:_:_s_e_t___v_a_r_i_a_b_l_e (std::string_view var, std:: │ │ │ │ │ string_view value) │ │ │ │ │ To set a transaction-local variable, execute an SQL SET command. To set a │ │ │ │ │ session variable, use the connection's set_session_var function. │ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/escaping.html │ │ │ │ @@ -95,30 +95,30 @@ │ │ │ │
│ │ │ │

Writing queries as strings is easy. But sometimes you need a variable in there: ‘"SELECT id FROM user WHERE name = &rsquo;" + name + "'"`.

│ │ │ │

This is dangerous. See the bug? If name can contain quotes, you may have an SQL injection vulnerability there, where users can enter nasty stuff like "`.'; DROP TABLE user`". Or if you're lucky, it's just a nasty bug that you discover when name happens to be "d'Arcy". Or... Well, I was born in a place called _'s-Gravenhage..._

│ │ │ │

There are two ways of dealing with this. One is statement parameters: some SQL execution functions in libpqxx let you write placeholders for such values in your SQL, like $1, $2, etc. When you then pass your variables as the parameter values, they get substituted into the query, but in a safe form.

│ │ │ │

The other is to escape the values yourself, before inserting them into your SQL. This isn't as safe as using parameters, since you need to be really conscientious about it. Use parameters if you can... and libpqxx will do the escaping for you.

│ │ │ │

In escaping, quotes and other problematic characters are marked as "this is │ │ │ │ just a character inside the string, not the end of the string." There are several functions in libpqxx to do this for you.

│ │ │ │ -

│ │ │ │ +

│ │ │ │ SQL injection

│ │ │ │

To understand what SQL injection vulnerabilities are and why they should be prevented, imagine you use the following SQL statement somewhere in your program:

│ │ │ │
tx.exec(
│ │ │ │
"SELECT number, amount "
│ │ │ │
"FROM account "
│ │ │ │
"WHERE allowed_to_see('" + userid + "','" + password + "')");
│ │ │ │

This shows a logged-in user important information on all accounts he is authorized to view. The userid and password strings are variables entered by the user himself.

│ │ │ │

Now, if the user is actually an attacker who knows (or can guess) the general shape of this SQL statement, imagine getting following password:

│ │ │ │
x') OR ('x' = 'x
│ │ │ │

Does that make sense to you? Probably not. But if this is inserted into the SQL string by the C++ code above, the query becomes:

│ │ │ │
SELECT number, amount
│ │ │ │
FROM account
│ │ │ │
WHERE allowed_to_see('user','x') OR ('x' = 'x')
│ │ │ │

Is this what you wanted to happen? Probably not! The neat allowed_to_see() clause is completely circumvented by the "`OR ('x' = 'x')`" clause, which is always true. Therefore, the attacker will get to see all accounts in the database!

│ │ │ │ -

│ │ │ │ +

│ │ │ │ Using the esc functions

│ │ │ │

Here's how you can fix the problem in the example above:

│ │ │ │
tx.exec(
│ │ │ │
"SELECT number, amount "
│ │ │ │
"FROM account "
│ │ │ │
"WHERE allowed_to_see('" + tx.esc(userid) + "', "
│ │ │ │
"'" + tx.esc(password) + "')");
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/namespacepqxx.html │ │ │ │ @@ -916,15 +916,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
struct pqxx::from_query_t
│ │ │ │
│ │ │ │

Marker for stream_from constructors: "stream from query.".

│ │ │ │ -
Deprecated:
Use stream_from::query() instead.
│ │ │ │ +
Deprecated:
Use stream_from::query() instead.
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ pqxx::from_table_t

│ │ │ │ │ │ │ │
│ │ │ │ @@ -932,15 +932,15 @@ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
struct pqxx::from_table_t
│ │ │ │
│ │ │ │

Marker for stream_from constructors: "stream from table.".

│ │ │ │ -
Deprecated:
Use stream_from::table() instead.
│ │ │ │ +
Deprecated:
Use stream_from::table() instead.
│ │ │ │
│ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ pqxx::stream_query

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1002,15 +1002,15 @@ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
using pqxx::connection_base = typedef connection
│ │ │ │
│ │ │ │ -
Deprecated:
Old base class for connection. They are now the same class.
│ │ │ │ +
Deprecated:
Old base class for connection. They are now the same class.
│ │ │ │ │ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │

◆ fieldstream

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1036,15 +1036,15 @@ │ │ │ │ │ │ │ │ using pqxx::strip_t = typedef std::remove_cv_t<std::remove_reference_t<TYPE> > │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Remove any constness, volatile, and reference-ness from a type.

│ │ │ │ -
Deprecated:
In C++20 we'll replace this with std::remove_cvref.
│ │ │ │ +
Deprecated:
In C++20 we'll replace this with std::remove_cvref.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ table_path

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1415,15 +1415,15 @@ │ │ │ │ ) │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Encrypt a password.

│ │ │ │ -
Deprecated:
Use connection::encrypt_password instead.
│ │ │ │ +
Deprecated:
Use connection::encrypt_password instead.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ encrypt_password() [2/2]

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1454,15 +1454,15 @@ │ │ │ │ │ │ │ │ inline │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Encrypt password.

│ │ │ │ -
Deprecated:
Use connection::encrypt_password instead.
│ │ │ │ +
Deprecated:
Use connection::encrypt_password instead.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ from_string()

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1914,15 +1914,15 @@ │ │ │ │ │ │ │ │ constexpr │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Pass this to a stream_from constructor to stream query results.

│ │ │ │ -
Deprecated:
Use transaction_base::stream instead of stream_from.
│ │ │ │ +
Deprecated:
Use transaction_base::stream instead of stream_from.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ from_table

│ │ │ │ │ │ │ │
│ │ │ │ @@ -1939,15 +1939,15 @@ │ │ │ │ │ │ │ │ constexpr │ │ │ │ │ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │

Pass this to a stream_from constructor to stream table contents.

│ │ │ │ -
Deprecated:
Use transaction_base::stream instead of stream_from.
│ │ │ │ +
Deprecated:
Use transaction_base::stream instead of stream_from.
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ │ │ │ │ │

◆ has_generic_bytes_char_traits

│ │ │ │ │ │ │ │
│ │ │ ├── ./usr/share/doc/libpqxx-doc/doxygen-html/namespacepqxx_1_1prepare.html │ │ │ │ @@ -90,15 +90,15 @@ │ │ │ │
│ │ │ │ │ │ │ │
│ │ │ │
pqxx::prepare Namespace Reference
│ │ │ │
│ │ │ │
│ │ │ │

Detailed Description

│ │ │ │ -
Deprecated:
The new params class replaces all of this.
│ │ │ │ +
Deprecated:
The new params class replaces all of this.
│ │ │ │
│ │ │ │
│ │ │ │ │ │ │ │