Tue Jun 4 10:29:48 UTC 2024 I: starting to build golang-gopkg-gorp.v1/unstable/amd64 on jenkins on '2024-06-04 10:29' Tue Jun 4 10:29:48 UTC 2024 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/amd64_7/23521/console.log Tue Jun 4 10:29:48 UTC 2024 I: Downloading source for unstable/golang-gopkg-gorp.v1=1.7.2-2 --2024-06-04 10:29:48-- http://deb.debian.org/debian/pool/main/g/golang-gopkg-gorp.v1/golang-gopkg-gorp.v1_1.7.2-2.dsc Connecting to 46.16.76.132:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2257 (2.2K) [text/prs.lines.tag] Saving to: ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ 0K .. 100% 351M=0s 2024-06-04 10:29:48 (351 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Tue Jun 4 10:29:48 UTC 2024 I: golang-gopkg-gorp.v1_1.7.2-2.dsc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 3.0 (quilt) Source: golang-gopkg-gorp.v1 Binary: golang-gopkg-gorp.v1-dev Architecture: all Version: 1.7.2-2 Maintainer: Debian Go Packaging Team Uploaders: Pirate Praveen Homepage: https://github.com/go-gorp/gorp Standards-Version: 4.5.0 Vcs-Browser: https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1 Vcs-Git: https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1.git Testsuite: autopkgtest-pkg-go Build-Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev Package-List: golang-gopkg-gorp.v1-dev deb devel optional arch=all Checksums-Sha1: 2e6c04f1ca458b823029eec4c51ba40603255da4 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz bb7c09284f48f1c97a0ded67b382e55e75072591 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Checksums-Sha256: 8b443ae1e4435f005b9ee7dfcfe3aab4aeeb4bd0131c9729f93788178cb261d2 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz ad67e36f4b6be743fb215ff83513f5d99c0b7ce2a847ca5ff1f1047060a82887 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Files: a0b0d4b76dbac1ec83378e470166fdec 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz e3925e5666a5dcb9d7ca28a80cb5b893 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Go-Import-Path: gopkg.in/gorp.v1 -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEE0whj4mAg5UP0cZqDj1PgGTspS3UFAl6cZ2wACgkQj1PgGTsp S3Uz3A//ZFGpjTXhy9rtNIFOj9Bz83Lz6qjL8iB6GSpYLayOk3rvcsECBhLzcI8j iCI9aqXUf/PH1pDx8TrcWCWtLqd8tHQFx0C52rLdy+MNTbMs5aN0xX8Lgy+6XYqv 7kSPAmLLF7aOPIwDvXDdCndu0zVV88ywZy/AzCK4QBTvQwdgnMg1yRxPQnvApJ53 4y0vjS915uIWF/2NW/T/dCLvcSO9Vcy8rcCgM+25Mob/KsN7aAyC+KYZjXgGtnz4 QD1mDe+b09ZlTKqcCYjQotTZdJV0nlehEaQzcGE10MnHuf2zw2XjdTpk6Ba/aH3P S0saS18pDw6Nr+TAgjBOH28oFi9lf8M6OZFwhwZ4KCe/hz3ruuLEFjPC+D1vuBks 5iy00WTmhhizDfMcfiGypmRJ0RimsfEPBqRFS2JCNr/+qGCkOgpCUD3NQuWVc0GI lIQ20zBNGMgYTroAqvn9Ls5VOL3ClWQ4G7MQ90zBRrkqWrvGOqfnmfNsDXvovQfA XnKyPY80C1O4vE12fENRjvJ8KZdnD3Wa+BMe+o2nCiXEuGeIBbrSfWbcErIBxefZ JKJf8TnVxIrEV/LaDIauejzL74hfi3LZCWy+8Ey1g18kktA6tG6sDxvnWPqTl5j1 9VqvEVa8h+vZJswFlThx5BO1aA9U3FkEFm2iU/aOAg+DxZtyRZw= =pQf6 -----END PGP SIGNATURE----- Tue Jun 4 10:29:48 UTC 2024 I: Checking whether the package is not for us Tue Jun 4 10:29:48 UTC 2024 I: Starting 1st build on remote node ionos11-amd64.debian.net. Tue Jun 4 10:29:48 UTC 2024 I: Preparing to do remote build '1' on ionos11-amd64.debian.net. Tue Jun 4 10:33:02 UTC 2024 I: Deleting $TMPDIR on ionos11-amd64.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Mon Jun 3 22:29:50 -12 2024 I: pbuilder-time-stamp: 1717496990 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/unstable-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: Signature made Sun Apr 19 14:59:56 2020 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify inline signature for ./golang-gopkg-gorp.v1_1.7.2-2.dsc: no acceptable signature found dpkg-source: info: extracting golang-gopkg-gorp.v1 in golang-gopkg-gorp.v1-1.7.2 dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2.orig.tar.xz dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/2173520/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build/reproducible-path' BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' BUILDUSERNAME='pbuilder1' BUILD_ARCH='amd64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=20 ' DISTRIBUTION='unstable' HOME='/root' HOST_ARCH='amd64' IFS=' ' INVOCATION_ID='4a3aa34ced8d4eca888bc933c8e8de2b' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' MAIL='/var/mail/root' OPTIND='1' PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' PBCURRENTCOMMANDLINEOPERATION='build' PBUILDER_OPERATION='build' PBUILDER_PKGDATADIR='/usr/share/pbuilder' PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' PBUILDER_SYSCONFDIR='/etc' PPID='2173520' PS1='# ' PS2='> ' PS4='+ ' PWD='/' SHELL='/bin/bash' SHLVL='2' SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/pbuilderrc_TspX --distribution unstable --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='111' SUDO_UID='106' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://46.16.76.132:3128' I: uname -a Linux ionos11-amd64 6.1.0-21-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.90-1 (2024-05-03) x86_64 GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 Jun 3 07:43 /bin -> usr/bin I: user script /srv/workspace/pbuilder/2173520/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19705 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.22-go{a} golang-1.22-src{a} golang-any{a} golang-github-davecgh-go-spew-dev{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-gorilla-securecookie-dev{a} golang-github-gorilla-sessions-dev{a} golang-github-hashicorp-go-uuid-dev{a} golang-github-jcmturner-aescts.v2-dev{a} golang-github-jcmturner-dnsutils.v2-dev{a} golang-github-jcmturner-gofork-dev{a} golang-github-jcmturner-goidentity.v6-dev{a} golang-github-jcmturner-gokrb5.v8-dev{a} golang-github-jcmturner-rpc.v2-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-pmezard-go-difflib-dev{a} golang-github-stretchr-objx-dev{a} golang-github-stretchr-testify-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-crypto-dev{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-term-dev{a} golang-golang-x-text-dev{a} golang-gopkg-yaml.v3-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1t64{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1t64{a} libpipeline1{a} libsqlite3-dev{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 59 newly installed, 0 to remove and 0 not upgraded. Need to get 71.5 MB of archives. After unpacking 371 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian unstable/main amd64 sensible-utils all 0.0.22 [22.4 kB] Get: 2 http://deb.debian.org/debian unstable/main amd64 libmagic-mgc amd64 1:5.45-3 [314 kB] Get: 3 http://deb.debian.org/debian unstable/main amd64 libmagic1t64 amd64 1:5.45-3 [105 kB] Get: 4 http://deb.debian.org/debian unstable/main amd64 file amd64 1:5.45-3 [42.9 kB] Get: 5 http://deb.debian.org/debian unstable/main amd64 gettext-base amd64 0.21-14+b1 [161 kB] Get: 6 http://deb.debian.org/debian unstable/main amd64 libuchardet0 amd64 0.0.8-1+b1 [68.8 kB] Get: 7 http://deb.debian.org/debian unstable/main amd64 groff-base amd64 1.23.0-4 [1180 kB] Get: 8 http://deb.debian.org/debian unstable/main amd64 bsdextrautils amd64 2.40.1-8 [96.0 kB] Get: 9 http://deb.debian.org/debian unstable/main amd64 libpipeline1 amd64 1.5.7-2 [38.0 kB] Get: 10 http://deb.debian.org/debian unstable/main amd64 man-db amd64 2.12.1-1 [1411 kB] Get: 11 http://deb.debian.org/debian unstable/main amd64 m4 amd64 1.4.19-4 [287 kB] Get: 12 http://deb.debian.org/debian unstable/main amd64 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian unstable/main amd64 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian unstable/main amd64 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian unstable/main amd64 autopoint all 0.21-14 [496 kB] Get: 16 http://deb.debian.org/debian unstable/main amd64 libdebhelper-perl all 13.15.3 [88.0 kB] Get: 17 http://deb.debian.org/debian unstable/main amd64 libtool all 2.4.7-7 [517 kB] Get: 18 http://deb.debian.org/debian unstable/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian unstable/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian unstable/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [19.5 kB] Get: 21 http://deb.debian.org/debian unstable/main amd64 dh-strip-nondeterminism all 1.14.0-1 [8448 B] Get: 22 http://deb.debian.org/debian unstable/main amd64 libelf1t64 amd64 0.191-1+b1 [189 kB] Get: 23 http://deb.debian.org/debian unstable/main amd64 dwz amd64 0.15-1+b1 [110 kB] Get: 24 http://deb.debian.org/debian unstable/main amd64 libicu72 amd64 72.1-4+b1 [9395 kB] Get: 25 http://deb.debian.org/debian unstable/main amd64 libxml2 amd64 2.12.7+dfsg-3 [670 kB] Get: 26 http://deb.debian.org/debian unstable/main amd64 gettext amd64 0.21-14+b1 [1301 kB] Get: 27 http://deb.debian.org/debian unstable/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 28 http://deb.debian.org/debian unstable/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 29 http://deb.debian.org/debian unstable/main amd64 debhelper all 13.15.3 [901 kB] Get: 30 http://deb.debian.org/debian unstable/main amd64 dh-golang all 1.62 [24.7 kB] Get: 31 http://deb.debian.org/debian unstable/main amd64 golang-1.22-src all 1.22.3-1 [18.8 MB] Get: 32 http://deb.debian.org/debian unstable/main amd64 golang-1.22-go amd64 1.22.3-1 [24.7 MB] Get: 33 http://deb.debian.org/debian unstable/main amd64 golang-src all 2:1.22~3 [5020 B] Get: 34 http://deb.debian.org/debian unstable/main amd64 golang-go amd64 2:1.22~3 [44.2 kB] Get: 35 http://deb.debian.org/debian unstable/main amd64 golang-any amd64 2:1.22~3 [5104 B] Get: 36 http://deb.debian.org/debian unstable/main amd64 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 37 http://deb.debian.org/debian unstable/main amd64 golang-github-go-sql-driver-mysql-dev all 1.7.1-2 [74.6 kB] Get: 38 http://deb.debian.org/debian unstable/main amd64 golang-github-gorilla-securecookie-dev all 1.1.2-1 [14.0 kB] Get: 39 http://deb.debian.org/debian unstable/main amd64 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 40 http://deb.debian.org/debian unstable/main amd64 golang-github-hashicorp-go-uuid-dev all 1.0.3-1 [8636 B] Get: 41 http://deb.debian.org/debian unstable/main amd64 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 42 http://deb.debian.org/debian unstable/main amd64 golang-github-stretchr-objx-dev all 0.5.2-1 [25.5 kB] Get: 43 http://deb.debian.org/debian unstable/main amd64 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 44 http://deb.debian.org/debian unstable/main amd64 golang-github-stretchr-testify-dev all 1.9.0-1 [74.7 kB] Get: 45 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 46 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 47 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 48 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 49 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-sys-dev all 0.20.0-1 [430 kB] Get: 50 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-term-dev all 0.20.0-1 [14.8 kB] Get: 51 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-text-dev all 0.15.0-1 [4006 kB] Get: 52 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-crypto-dev all 1:0.23.0-1 [1689 kB] Get: 53 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-net-dev all 1:0.25.0+dfsg-1 [895 kB] Get: 54 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 55 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 56 http://deb.debian.org/debian unstable/main amd64 golang-github-lib-pq-dev all 1.10.9-2 [86.6 kB] Get: 57 http://deb.debian.org/debian unstable/main amd64 libsqlite3-dev amd64 3.46.0-1 [1096 kB] Get: 58 http://deb.debian.org/debian unstable/main amd64 golang-github-mattn-go-sqlite3-dev amd64 1.14.19~ds1-1 [83.4 kB] Get: 59 http://deb.debian.org/debian unstable/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 71.5 MB in 2s (30.6 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19705 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.22_all.deb ... Unpacking sensible-utils (0.0.22) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.45-3_amd64.deb ... Unpacking libmagic-mgc (1:5.45-3) ... Selecting previously unselected package libmagic1t64:amd64. Preparing to unpack .../02-libmagic1t64_1%3a5.45-3_amd64.deb ... Unpacking libmagic1t64:amd64 (1:5.45-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.45-3_amd64.deb ... Unpacking file (1:5.45-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-14+b1_amd64.deb ... Unpacking gettext-base (0.21-14+b1) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../05-libuchardet0_0.0.8-1+b1_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.8-1+b1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-4_amd64.deb ... Unpacking groff-base (1.23.0-4) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.40.1-8_amd64.deb ... Unpacking bsdextrautils (2.40.1-8) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../08-libpipeline1_1.5.7-2_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.7-2) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.12.1-1_amd64.deb ... Unpacking man-db (2.12.1-1) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-4_amd64.deb ... Unpacking m4 (1.4.19-4) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.71-3_all.deb ... Unpacking autoconf (2.71-3) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20220109.1_all.deb ... Unpacking autotools-dev (20220109.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.16.5-1.3_all.deb ... Unpacking automake (1:1.16.5-1.3) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.21-14_all.deb ... Unpacking autopoint (0.21-14) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.15.3_all.deb ... Unpacking libdebhelper-perl (13.15.3) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.4.7-7_all.deb ... Unpacking libtool (2.4.7-7) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../19-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../20-dh-strip-nondeterminism_1.14.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.14.0-1) ... Selecting previously unselected package libelf1t64:amd64. Preparing to unpack .../21-libelf1t64_0.191-1+b1_amd64.deb ... Unpacking libelf1t64:amd64 (0.191-1+b1) ... Selecting previously unselected package dwz. Preparing to unpack .../22-dwz_0.15-1+b1_amd64.deb ... Unpacking dwz (0.15-1+b1) ... Selecting previously unselected package libicu72:amd64. Preparing to unpack .../23-libicu72_72.1-4+b1_amd64.deb ... Unpacking libicu72:amd64 (72.1-4+b1) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../24-libxml2_2.12.7+dfsg-3_amd64.deb ... Unpacking libxml2:amd64 (2.12.7+dfsg-3) ... Selecting previously unselected package gettext. Preparing to unpack .../25-gettext_0.21-14+b1_amd64.deb ... Unpacking gettext (0.21-14+b1) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../26-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../27-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../28-debhelper_13.15.3_all.deb ... Unpacking debhelper (13.15.3) ... Selecting previously unselected package dh-golang. Preparing to unpack .../29-dh-golang_1.62_all.deb ... Unpacking dh-golang (1.62) ... Selecting previously unselected package golang-1.22-src. Preparing to unpack .../30-golang-1.22-src_1.22.3-1_all.deb ... Unpacking golang-1.22-src (1.22.3-1) ... Selecting previously unselected package golang-1.22-go. Preparing to unpack .../31-golang-1.22-go_1.22.3-1_amd64.deb ... Unpacking golang-1.22-go (1.22.3-1) ... Selecting previously unselected package golang-src. Preparing to unpack .../32-golang-src_2%3a1.22~3_all.deb ... Unpacking golang-src (2:1.22~3) ... Selecting previously unselected package golang-go:amd64. Preparing to unpack .../33-golang-go_2%3a1.22~3_amd64.deb ... Unpacking golang-go:amd64 (2:1.22~3) ... Selecting previously unselected package golang-any:amd64. Preparing to unpack .../34-golang-any_2%3a1.22~3_amd64.deb ... Unpacking golang-any:amd64 (2:1.22~3) ... Selecting previously unselected package golang-github-davecgh-go-spew-dev. Preparing to unpack .../35-golang-github-davecgh-go-spew-dev_1.1.1-3_all.deb ... Unpacking golang-github-davecgh-go-spew-dev (1.1.1-3) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../36-golang-github-go-sql-driver-mysql-dev_1.7.1-2_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Selecting previously unselected package golang-github-gorilla-securecookie-dev. Preparing to unpack .../37-golang-github-gorilla-securecookie-dev_1.1.2-1_all.deb ... Unpacking golang-github-gorilla-securecookie-dev (1.1.2-1) ... Selecting previously unselected package golang-github-gorilla-sessions-dev. Preparing to unpack .../38-golang-github-gorilla-sessions-dev_1.2.1-1_all.deb ... Unpacking golang-github-gorilla-sessions-dev (1.2.1-1) ... Selecting previously unselected package golang-github-hashicorp-go-uuid-dev. Preparing to unpack .../39-golang-github-hashicorp-go-uuid-dev_1.0.3-1_all.deb ... Unpacking golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... Selecting previously unselected package golang-github-pmezard-go-difflib-dev. Preparing to unpack .../40-golang-github-pmezard-go-difflib-dev_1.0.0-3_all.deb ... Unpacking golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Selecting previously unselected package golang-github-stretchr-objx-dev. Preparing to unpack .../41-golang-github-stretchr-objx-dev_0.5.2-1_all.deb ... Unpacking golang-github-stretchr-objx-dev (0.5.2-1) ... Selecting previously unselected package golang-gopkg-yaml.v3-dev. Preparing to unpack .../42-golang-gopkg-yaml.v3-dev_3.0.1-3_all.deb ... Unpacking golang-gopkg-yaml.v3-dev (3.0.1-3) ... Selecting previously unselected package golang-github-stretchr-testify-dev. Preparing to unpack .../43-golang-github-stretchr-testify-dev_1.9.0-1_all.deb ... Unpacking golang-github-stretchr-testify-dev (1.9.0-1) ... Selecting previously unselected package golang-github-jcmturner-aescts.v2-dev. Preparing to unpack .../44-golang-github-jcmturner-aescts.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-dnsutils.v2-dev. Preparing to unpack .../45-golang-github-jcmturner-dnsutils.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-gofork-dev. Preparing to unpack .../46-golang-github-jcmturner-gofork-dev_1.0.0-4_all.deb ... Unpacking golang-github-jcmturner-gofork-dev (1.0.0-4) ... Selecting previously unselected package golang-github-jcmturner-goidentity.v6-dev. Preparing to unpack .../47-golang-github-jcmturner-goidentity.v6-dev_6.0.1-2_all.deb ... Unpacking golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../48-golang-golang-x-sys-dev_0.20.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.20.0-1) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../49-golang-golang-x-term-dev_0.20.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.20.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../50-golang-golang-x-text-dev_0.15.0-1_all.deb ... Unpacking golang-golang-x-text-dev (0.15.0-1) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../51-golang-golang-x-crypto-dev_1%3a0.23.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.23.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../52-golang-golang-x-net-dev_1%3a0.25.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.25.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../53-golang-github-jcmturner-rpc.v2-dev_2.0.3-2_all.deb ... Unpacking golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Selecting previously unselected package golang-github-jcmturner-gokrb5.v8-dev. Preparing to unpack .../54-golang-github-jcmturner-gokrb5.v8-dev_8.4.3-2_all.deb ... Unpacking golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../55-golang-github-lib-pq-dev_1.10.9-2_all.deb ... Unpacking golang-github-lib-pq-dev (1.10.9-2) ... Selecting previously unselected package libsqlite3-dev:amd64. Preparing to unpack .../56-libsqlite3-dev_3.46.0-1_amd64.deb ... Unpacking libsqlite3-dev:amd64 (3.46.0-1) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:amd64. Preparing to unpack .../57-golang-github-mattn-go-sqlite3-dev_1.14.19~ds1-1_amd64.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:amd64 (1.14.19~ds1-1) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../58-golang-github-ziutek-mymysql-dev_1.5.4+git20170206.23.0582bcf-2_all.deb ... Unpacking golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libpipeline1:amd64 (1.5.7-2) ... Setting up golang-github-jcmturner-gofork-dev (1.0.0-4) ... Setting up golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... Setting up libicu72:amd64 (72.1-4+b1) ... Setting up bsdextrautils (2.40.1-8) ... Setting up golang-github-stretchr-objx-dev (0.5.2-1) ... Setting up libmagic-mgc (1:5.45-3) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up golang-gopkg-yaml.v3-dev (3.0.1-3) ... Setting up libdebhelper-perl (13.15.3) ... Setting up golang-golang-x-sys-dev (0.20.0-1) ... Setting up libmagic1t64:amd64 (1:5.45-3) ... Setting up golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Setting up gettext-base (0.21-14+b1) ... Setting up m4 (1.4.19-4) ... Setting up golang-golang-x-term-dev (0.20.0-1) ... Setting up file (1:5.45-3) ... Setting up libelf1t64:amd64 (0.191-1+b1) ... Setting up golang-github-davecgh-go-spew-dev (1.1.1-3) ... Setting up autotools-dev (20220109.1) ... Setting up libsqlite3-dev:amd64 (3.46.0-1) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up golang-github-stretchr-testify-dev (1.9.0-1) ... Setting up golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Setting up golang-1.22-src (1.22.3-1) ... Setting up autopoint (0.21-14) ... Setting up autoconf (2.71-3) ... Setting up dwz (0.15-1+b1) ... Setting up sensible-utils (0.0.22) ... Setting up golang-golang-x-text-dev (0.15.0-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Setting up libuchardet0:amd64 (0.0.8-1+b1) ... Setting up golang-golang-x-crypto-dev (1:0.23.0-1) ... Setting up golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Setting up golang-src (2:1.22~3) ... Setting up golang-github-gorilla-securecookie-dev (1.1.2-1) ... Setting up libxml2:amd64 (2.12.7+dfsg-3) ... Setting up golang-github-gorilla-sessions-dev (1.2.1-1) ... Setting up automake (1:1.16.5-1.3) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... Setting up gettext (0.21-14+b1) ... Setting up golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Setting up libtool (2.4.7-7) ... Setting up golang-1.22-go (1.22.3-1) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:amd64 (1.14.19~ds1-1) ... Setting up golang-golang-x-net-dev (1:0.25.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.14.0-1) ... Setting up groff-base (1.23.0-4) ... Setting up golang-go:amd64 (2:1.22~3) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Setting up man-db (2.12.1-1) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-any:amd64 (2:1.22~3) ... Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.15.3) ... Setting up golang-github-lib-pq-dev (1.10.9-2) ... Setting up dh-golang (1.62) ... Processing triggers for libc-bin (2.38-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 20 gopkg.in/gorp.v1 internal/coverage/rtcov internal/unsafeheader cmp log/internal internal/goarch internal/goos internal/godebugs unicode/utf8 internal/goexperiment unicode internal/cpu math/bits internal/race internal/itoa sync/atomic runtime/internal/syscall runtime/internal/atomic internal/chacha8rand runtime/internal/math internal/abi runtime/internal/sys slices internal/bytealg math runtime internal/reflectlite sync internal/testlog errors sort internal/oserror io internal/safefilepath path strconv syscall bytes strings reflect regexp/syntax internal/syscall/execenv internal/syscall/unix time regexp internal/fmtsort context io/fs internal/poll os fmt database/sql/driver log database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 20 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2024/06/04 10:32:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:11.352203 drop table if exists "invoice_test"; [] gorptest: 10:32:11.352969 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:11.353014 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:11.353044 drop table if exists "invoice_override_test"; [] gorptest: 10:32:11.353072 drop table if exists "person_test"; [] gorptest: 10:32:11.353100 drop table if exists "ignored_column_test"; [] gorptest: 10:32:11.353127 drop table if exists "id_created_test"; [] gorptest: 10:32:11.353154 drop table if exists "type_conv_test"; [] gorptest: 10:32:11.353181 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:11.353209 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:11.353236 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:11.353263 drop table if exists "time_test"; [] gorptest: 10:32:11.353305 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.377485 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:11.395248 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:11.413697 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.452897 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:11.471309 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.488809 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.512382 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:11.545239 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:11.563144 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:11.579411 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:11.601294 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:11.618421 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.618587 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:11.618629 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:11.618669 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.618707 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:11.618741 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.618775 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.618810 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:11.618846 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:11.618881 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:11.618918 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:11.618952 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:11.618985 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 10:32:11.619017 drop table if exists "invoice_test"; [] gorptest: 10:32:11.632385 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:11.646591 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:11.661302 drop table if exists "invoice_override_test"; [] gorptest: 10:32:11.676795 drop table if exists "person_test"; [] gorptest: 10:32:11.691366 drop table if exists "ignored_column_test"; [] gorptest: 10:32:11.704166 drop table if exists "id_created_test"; [] gorptest: 10:32:11.715941 drop table if exists "type_conv_test"; [] gorptest: 10:32:11.726160 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:11.736778 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:11.749425 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:11.765600 drop table if exists "time_test"; [] gorptest: 10:32:11.776451 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.42s) === RUN TestTruncateTables 2024/06/04 10:32:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:11.776887 drop table if exists "invoice_test"; [] gorptest: 10:32:11.777232 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:11.777271 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:11.777301 drop table if exists "invoice_override_test"; [] gorptest: 10:32:11.777329 drop table if exists "person_test"; [] gorptest: 10:32:11.777358 drop table if exists "ignored_column_test"; [] gorptest: 10:32:11.777387 drop table if exists "id_created_test"; [] gorptest: 10:32:11.777415 drop table if exists "type_conv_test"; [] gorptest: 10:32:11.777443 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:11.777471 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:11.777499 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:11.777528 drop table if exists "time_test"; [] gorptest: 10:32:11.777567 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.789897 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:11.811459 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:11.843327 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.864078 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:11.875775 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.887444 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.899111 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:11.914432 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:11.925214 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:11.940829 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:11.952581 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:11.971998 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.972170 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:11.972226 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:11.972266 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:11.972306 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:11.972345 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.972377 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:11.972411 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:11.972448 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:11.972483 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:11.972518 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:11.972551 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:11.972583 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 10:32:11.972650 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497131972624550 2:1717497131972624550 3:"Bob" 4:"Smith" 5:1] gorptest: 10:32:11.982580 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 10:32:11.998214 delete from "invoice_test"; [] gorptest: 10:32:12.016073 delete from "invoice_tag_test"; [] gorptest: 10:32:12.027591 delete from "alias_trans_field_test"; [] gorptest: 10:32:12.038673 delete from "invoice_override_test"; [] gorptest: 10:32:12.049943 delete from "person_test"; [] gorptest: 10:32:12.061580 delete from "ignored_column_test"; [] gorptest: 10:32:12.075646 delete from "id_created_test"; [] gorptest: 10:32:12.088666 delete from "type_conv_test"; [] gorptest: 10:32:12.107983 delete from "embedded_struct_test"; [] gorptest: 10:32:12.475561 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:12.899303 delete from "embedded_autoincr_test"; [] gorptest: 10:32:13.524711 delete from "time_test"; [] gorptest: 10:32:14.365586 delete from "id_created_test"; [] gorptest: 10:32:15.041746 SELECT * FROM person_test [] gorptest: 10:32:15.042026 SELECT * FROM invoice_test [] gorptest: 10:32:15.042097 drop table if exists "invoice_test"; [] gorptest: 10:32:15.515328 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:16.163216 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:16.975195 drop table if exists "invoice_override_test"; [] gorptest: 10:32:17.754098 drop table if exists "person_test"; [] gorptest: 10:32:18.841674 drop table if exists "ignored_column_test"; [] gorptest: 10:32:19.504243 drop table if exists "id_created_test"; [] gorptest: 10:32:19.523639 drop table if exists "type_conv_test"; [] gorptest: 10:32:19.543054 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:19.563692 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:19.582908 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:19.594478 drop table if exists "time_test"; [] gorptest: 10:32:19.615870 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (7.84s) === RUN TestCustomDateType gorptest: 10:32:19.616287 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 10:32:19.685066 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-06-04 10:32:19 +0000 UTC] gorptest: 10:32:19.703638 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 10:32:19.703915 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.10s) === RUN TestUIntPrimaryKey gorptest: 10:32:19.720967 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 10:32:19.739769 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 10:32:19.758227 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 10:32:19.771987 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 10:32:19.790710 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 10:32:19.812642 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 10:32:19.831377 drop table if exists "PersonUInt64"; [] gorptest: 10:32:19.845616 drop table if exists "PersonUInt32"; [] gorptest: 10:32:19.861143 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.15s) === RUN TestSetUniqueTogether gorptest: 10:32:19.875563 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 10:32:19.900939 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 10:32:19.920426 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 10:32:19.920691 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 10:32:19.920827 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 10:32:19.938827 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.08s) === RUN TestPersistentUser gorptest: 10:32:19.959951 drop table if exists PersistentUser [] gorptest: 10:32:19.960631 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 10:32:19.975666 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 10:32:19.990286 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 10:32:19.990697 select * from PersistentUser [] gorptest: 10:32:19.990822 select * from PersistentUser [] gorptest: 10:32:19.990921 select * from PersistentUser [] gorptest: 10:32:19.991017 select Id from PersistentUser [] gorptest: 10:32:19.991093 select mykey from PersistentUser [] gorptest: 10:32:19.991157 select PassedTraining from PersistentUser [] gorptest: 10:32:19.991233 select Id from PersistentUser [] gorptest: 10:32:19.991297 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.06s) === RUN TestNamedQueryMap gorptest: 10:32:20.016521 drop table if exists PersistentUser [] gorptest: 10:32:20.016984 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 10:32:20.027632 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 10:32:20.041225 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 10:32:20.129272 select * from PersistentUser where mykey = ? [1:43] gorptest: 10:32:20.129598 select * from PersistentUser where mykey = ? [1:43] gorptest: 10:32:20.129708 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 10:32:20.129871 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 10:32:20.129969 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.13s) === RUN TestNamedQueryStruct gorptest: 10:32:20.142155 drop table if exists PersistentUser [] gorptest: 10:32:20.142643 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 10:32:20.159831 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 10:32:20.176451 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 10:32:20.187789 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 10:32:20.188196 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.07s) === RUN TestReturnsNonNilSlice 2024/06/04 10:32:20 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:20.211142 drop table if exists "invoice_test"; [] gorptest: 10:32:20.211638 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:20.211735 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:20.211834 drop table if exists "invoice_override_test"; [] gorptest: 10:32:20.211873 drop table if exists "person_test"; [] gorptest: 10:32:20.212001 drop table if exists "ignored_column_test"; [] gorptest: 10:32:20.212090 drop table if exists "id_created_test"; [] gorptest: 10:32:20.212181 drop table if exists "type_conv_test"; [] gorptest: 10:32:20.212259 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:20.212339 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:20.212443 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:20.212533 drop table if exists "time_test"; [] gorptest: 10:32:20.212659 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:20.226176 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:20.240607 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:20.256651 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:20.269503 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:20.294208 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:20.310058 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:20.324944 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:20.340077 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:20.418388 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:20.440777 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:20.458027 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:20.476346 select * from invoice_test where id=99999 [] gorptest: 10:32:20.476598 select * from invoice_test where id=99999 [] gorptest: 10:32:20.476686 drop table if exists "invoice_test"; [] gorptest: 10:32:20.489564 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:20.507501 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:20.522165 drop table if exists "invoice_override_test"; [] gorptest: 10:32:20.535540 drop table if exists "person_test"; [] gorptest: 10:32:20.547411 drop table if exists "ignored_column_test"; [] gorptest: 10:32:20.561092 drop table if exists "id_created_test"; [] gorptest: 10:32:20.573904 drop table if exists "type_conv_test"; [] gorptest: 10:32:20.592766 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:20.612380 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:20.624706 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:20.641604 drop table if exists "time_test"; [] gorptest: 10:32:20.660950 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.45s) === RUN TestOverrideVersionCol gorptest: 10:32:20.661492 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 10:32:21.086150 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] gorptest: 10:32:21.086437 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.60s) === RUN TestOptimisticLocking 2024/06/04 10:32:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:21.262790 drop table if exists "invoice_test"; [] gorptest: 10:32:21.263273 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:21.263337 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:21.263394 drop table if exists "invoice_override_test"; [] gorptest: 10:32:21.263453 drop table if exists "person_test"; [] gorptest: 10:32:21.263510 drop table if exists "ignored_column_test"; [] gorptest: 10:32:21.263564 drop table if exists "id_created_test"; [] gorptest: 10:32:21.263638 drop table if exists "type_conv_test"; [] gorptest: 10:32:21.263698 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:21.263760 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:21.263815 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:21.263870 drop table if exists "time_test"; [] gorptest: 10:32:21.263972 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:21.289556 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:21.304358 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:21.318419 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:21.340074 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:21.353142 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:21.366522 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:21.387706 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:21.405332 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:21.427416 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:21.446324 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:21.462830 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:21.477541 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497141477494616 2:1717497141477494616 3:"Bob" 4:"Smith" 5:1] gorptest: 10:32:21.488433 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:21.488733 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717497141477494616 2:1717497141477494616 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 10:32:21.501873 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717497141477494616 2:1717497141477494616 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 10:32:21.502116 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:21.502252 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 10:32:21.502321 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:21.502393 drop table if exists "invoice_test"; [] gorptest: 10:32:21.515054 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:21.529862 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:21.547770 drop table if exists "invoice_override_test"; [] gorptest: 10:32:21.582144 drop table if exists "person_test"; [] gorptest: 10:32:21.612306 drop table if exists "ignored_column_test"; [] gorptest: 10:32:21.631471 drop table if exists "id_created_test"; [] gorptest: 10:32:21.644625 drop table if exists "type_conv_test"; [] gorptest: 10:32:21.655719 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:21.668470 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:21.680973 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:21.695175 drop table if exists "time_test"; [] gorptest: 10:32:21.705106 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.44s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 10:32:21.705785 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 10:32:21.731088 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 10:32:21.741059 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 10:32:21.741402 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] gorptest: 10:32:21.752035 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 10:32:21.752379 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.06s) === RUN TestColumnProps gorptest: 10:32:21.765428 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 10:32:21.778292 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 10:32:21.790977 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 10:32:21.791349 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 10:32:21.791553 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 10:32:21.791680 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.04s) === RUN TestRawSelect 2024/06/04 10:32:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:21.802878 drop table if exists "invoice_test"; [] gorptest: 10:32:21.803334 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:21.803387 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:21.803429 drop table if exists "invoice_override_test"; [] gorptest: 10:32:21.803510 drop table if exists "person_test"; [] gorptest: 10:32:21.803573 drop table if exists "ignored_column_test"; [] gorptest: 10:32:21.803638 drop table if exists "id_created_test"; [] gorptest: 10:32:21.803717 drop table if exists "type_conv_test"; [] gorptest: 10:32:21.803798 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:21.803891 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:21.803949 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:21.804042 drop table if exists "time_test"; [] gorptest: 10:32:21.804140 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:21.816614 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:21.830353 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:21.840332 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:21.871411 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:21.883026 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:21.894611 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:21.909254 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:21.926206 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:21.938156 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:21.954193 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:21.981544 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:21.996602 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497141996551050 2:1717497141996551050 3:"bob" 4:"smith" 5:1] gorptest: 10:32:22.017169 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 10:32:22.038757 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 10:32:22.039175 drop table if exists "invoice_test"; [] gorptest: 10:32:22.058613 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:22.070016 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:22.082109 drop table if exists "invoice_override_test"; [] gorptest: 10:32:22.094941 drop table if exists "person_test"; [] gorptest: 10:32:22.109184 drop table if exists "ignored_column_test"; [] gorptest: 10:32:22.126762 drop table if exists "id_created_test"; [] gorptest: 10:32:22.141300 drop table if exists "type_conv_test"; [] gorptest: 10:32:22.156364 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:22.172787 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:22.186900 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:22.216894 drop table if exists "time_test"; [] gorptest: 10:32:22.233331 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.43s) === RUN TestHooks 2024/06/04 10:32:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:22.234096 drop table if exists "invoice_test"; [] gorptest: 10:32:22.234535 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:22.234637 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:22.234738 drop table if exists "invoice_override_test"; [] gorptest: 10:32:22.234837 drop table if exists "person_test"; [] gorptest: 10:32:22.234947 drop table if exists "ignored_column_test"; [] gorptest: 10:32:22.235055 drop table if exists "id_created_test"; [] gorptest: 10:32:22.235166 drop table if exists "type_conv_test"; [] gorptest: 10:32:22.235266 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:22.235367 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:22.235423 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:22.235458 drop table if exists "time_test"; [] gorptest: 10:32:22.235528 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:22.251782 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:22.263224 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:22.279699 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:22.302126 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:22.324007 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:22.346348 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:22.362095 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:22.380617 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:22.398031 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:22.415703 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:22.433048 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:22.451894 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497142451850043 2:1717497142451850043 3:"bob" 4:"smith" 5:1] gorptest: 10:32:22.478003 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:22.478431 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717497142451850043 2:1717497142451850043 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 10:32:22.921689 select * from person_test where id = ? [1:1] gorptest: 10:32:22.922146 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 10:32:22.932070 drop table if exists "invoice_test"; [] gorptest: 10:32:22.947953 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:22.958407 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:22.976370 drop table if exists "invoice_override_test"; [] gorptest: 10:32:22.992998 drop table if exists "person_test"; [] gorptest: 10:32:23.004157 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.022311 drop table if exists "id_created_test"; [] gorptest: 10:32:23.032887 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.046805 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.058245 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.068816 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.086153 drop table if exists "time_test"; [] gorptest: 10:32:23.097652 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.86s) === RUN TestTransaction 2024/06/04 10:32:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:23.098327 drop table if exists "invoice_test"; [] gorptest: 10:32:23.098701 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:23.098794 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:23.098884 drop table if exists "invoice_override_test"; [] gorptest: 10:32:23.098968 drop table if exists "person_test"; [] gorptest: 10:32:23.099057 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.099139 drop table if exists "id_created_test"; [] gorptest: 10:32:23.099234 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.099317 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.099403 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.099486 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.099564 drop table if exists "time_test"; [] gorptest: 10:32:23.099659 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.122195 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:23.143576 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:23.156465 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.172694 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:23.186185 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.199763 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.212998 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:23.223871 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:23.234134 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:23.245498 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:23.257557 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:23.267632 begin; [] gorptest: 10:32:23.267930 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 10:32:23.268351 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 10:32:23.268481 commit; [] gorptest: 10:32:23.282451 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:23.282835 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 10:32:23.282993 drop table if exists "invoice_test"; [] gorptest: 10:32:23.311152 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:23.321694 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:23.335237 drop table if exists "invoice_override_test"; [] gorptest: 10:32:23.372932 drop table if exists "person_test"; [] gorptest: 10:32:23.396971 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.419596 drop table if exists "id_created_test"; [] gorptest: 10:32:23.430521 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.452449 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.465865 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.477496 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.489071 drop table if exists "time_test"; [] gorptest: 10:32:23.500994 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.40s) === RUN TestSavepoint 2024/06/04 10:32:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:23.501686 drop table if exists "invoice_test"; [] gorptest: 10:32:23.502199 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:23.502662 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:23.502726 drop table if exists "invoice_override_test"; [] gorptest: 10:32:23.502779 drop table if exists "person_test"; [] gorptest: 10:32:23.502839 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.502894 drop table if exists "id_created_test"; [] gorptest: 10:32:23.502934 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.502985 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.503028 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.503112 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.503159 drop table if exists "time_test"; [] gorptest: 10:32:23.510196 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.521374 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:23.535044 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:23.581480 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.603170 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:23.616161 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.643969 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.658280 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:23.669431 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:23.693083 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:23.702337 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:23.712073 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:23.723923 begin; [] gorptest: 10:32:23.724126 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 10:32:23.724406 select memo from invoice_test [] gorptest: 10:32:23.724737 savepoint "foo" [1:] gorptest: 10:32:23.724769 select memo from invoice_test [] gorptest: 10:32:23.724862 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 10:32:23.724957 select memo from invoice_test [] gorptest: 10:32:23.725017 rollback to savepoint "foo" [1:] gorptest: 10:32:23.725045 select memo from invoice_test [] gorptest: 10:32:23.725096 rollback; [] gorptest: 10:32:23.725309 drop table if exists "invoice_test"; [] gorptest: 10:32:23.735139 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:23.748531 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:23.758797 drop table if exists "invoice_override_test"; [] gorptest: 10:32:23.774334 drop table if exists "person_test"; [] gorptest: 10:32:23.788536 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.809202 drop table if exists "id_created_test"; [] gorptest: 10:32:23.821922 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.836018 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.848799 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.861442 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.877825 drop table if exists "time_test"; [] gorptest: 10:32:23.890466 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.39s) === RUN TestMultiple 2024/06/04 10:32:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:23.890928 drop table if exists "invoice_test"; [] gorptest: 10:32:23.891367 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:23.891422 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:23.891471 drop table if exists "invoice_override_test"; [] gorptest: 10:32:23.891521 drop table if exists "person_test"; [] gorptest: 10:32:23.891562 drop table if exists "ignored_column_test"; [] gorptest: 10:32:23.891609 drop table if exists "id_created_test"; [] gorptest: 10:32:23.891658 drop table if exists "type_conv_test"; [] gorptest: 10:32:23.891700 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:23.891737 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:23.891775 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:23.891814 drop table if exists "time_test"; [] gorptest: 10:32:23.891867 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.903843 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:23.915142 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:23.929975 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:23.941354 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:23.952000 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.971526 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:23.983331 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:23.996730 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:24.014335 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:24.029275 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:24.047980 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:24.058138 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 10:32:24.072754 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 10:32:24.088451 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 10:32:24.106167 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 10:32:24.125780 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:24.150999 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 10:32:24.163485 drop table if exists "invoice_test"; [] gorptest: 10:32:24.186318 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:24.208408 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:24.219935 drop table if exists "invoice_override_test"; [] gorptest: 10:32:24.229832 drop table if exists "person_test"; [] gorptest: 10:32:24.248564 drop table if exists "ignored_column_test"; [] gorptest: 10:32:24.262225 drop table if exists "id_created_test"; [] gorptest: 10:32:24.273280 drop table if exists "type_conv_test"; [] gorptest: 10:32:24.284389 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:24.296891 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:24.309858 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:24.326460 drop table if exists "time_test"; [] gorptest: 10:32:24.342529 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.45s) === RUN TestCrud 2024/06/04 10:32:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:24.343166 drop table if exists "invoice_test"; [] gorptest: 10:32:24.343538 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:24.343574 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:24.343607 drop table if exists "invoice_override_test"; [] gorptest: 10:32:24.343712 drop table if exists "person_test"; [] gorptest: 10:32:24.343810 drop table if exists "ignored_column_test"; [] gorptest: 10:32:24.343910 drop table if exists "id_created_test"; [] gorptest: 10:32:24.344016 drop table if exists "type_conv_test"; [] gorptest: 10:32:24.344116 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:24.344214 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:24.344316 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:24.344408 drop table if exists "time_test"; [] gorptest: 10:32:24.344527 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:24.366427 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:24.377475 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:24.389353 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:24.401728 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:24.416894 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:24.426764 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:24.443819 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:24.456331 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:24.471310 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:24.486050 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:24.501299 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:24.513289 delete from invoice_test [] gorptest: 10:32:24.525642 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 10:32:24.537513 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:24.537900 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:529304171213454911 2:2495851084990673249 3:"random 5033868385969805842" 4:0 5:true 6:1] gorptest: 10:32:24.547266 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:24.547604 select * from invoice_test [] gorptest: 10:32:24.547783 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:24.556510 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 10:32:24.556886 delete from invoice_tag_test [] gorptest: 10:32:24.568132 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] gorptest: 10:32:24.583469 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 10:32:24.583734 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:6440918368277172312 2:8784200896587139135 3:"random 2988947233269335447" 4:33 5:false 6:1] gorptest: 10:32:24.594346 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 10:32:24.594736 select * from invoice_tag_test [] gorptest: 10:32:24.594933 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 10:32:24.611764 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 10:32:24.611982 delete from alias_trans_field_test [] gorptest: 10:32:24.625477 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 10:32:24.636791 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 10:32:24.637192 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 6415061631335082899" 2:1] gorptest: 10:32:24.649425 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 10:32:24.649759 select * from alias_trans_field_test [] gorptest: 10:32:24.649948 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 10:32:24.667692 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 10:32:24.668052 drop table if exists "invoice_test"; [] gorptest: 10:32:24.684658 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:24.723443 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:24.743472 drop table if exists "invoice_override_test"; [] gorptest: 10:32:24.757002 drop table if exists "person_test"; [] gorptest: 10:32:24.774692 drop table if exists "ignored_column_test"; [] gorptest: 10:32:24.785946 drop table if exists "id_created_test"; [] gorptest: 10:32:24.796587 drop table if exists "type_conv_test"; [] gorptest: 10:32:24.814553 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:24.827829 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:24.840199 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:24.853340 drop table if exists "time_test"; [] gorptest: 10:32:24.869839 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.53s) === RUN TestWithIgnoredColumn 2024/06/04 10:32:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:24.870355 drop table if exists "invoice_test"; [] gorptest: 10:32:24.870761 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:24.870804 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:24.870846 drop table if exists "invoice_override_test"; [] gorptest: 10:32:24.870889 drop table if exists "person_test"; [] gorptest: 10:32:24.870928 drop table if exists "ignored_column_test"; [] gorptest: 10:32:24.870968 drop table if exists "id_created_test"; [] gorptest: 10:32:24.871008 drop table if exists "type_conv_test"; [] gorptest: 10:32:24.871045 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:24.871082 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:24.871122 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:24.871162 drop table if exists "time_test"; [] gorptest: 10:32:24.871218 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:24.885103 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:24.901188 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:25.589184 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:26.002150 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:26.014072 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:26.025089 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:26.041007 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:26.055398 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:26.104460 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:26.127491 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:26.145221 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:26.163079 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 10:32:26.175330 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 10:32:26.175633 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 10:32:26.218529 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 10:32:26.218777 drop table if exists "invoice_test"; [] gorptest: 10:32:26.231720 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:26.253416 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:26.266406 drop table if exists "invoice_override_test"; [] gorptest: 10:32:26.281241 drop table if exists "person_test"; [] gorptest: 10:32:26.294649 drop table if exists "ignored_column_test"; [] gorptest: 10:32:26.311158 drop table if exists "id_created_test"; [] gorptest: 10:32:26.324380 drop table if exists "type_conv_test"; [] gorptest: 10:32:26.347408 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:26.371178 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:26.390221 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:26.410146 drop table if exists "time_test"; [] gorptest: 10:32:26.440985 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (1.57s) === RUN TestTypeConversionExample 2024/06/04 10:32:26 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:26.441524 drop table if exists "invoice_test"; [] gorptest: 10:32:26.441993 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:26.442046 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:26.442085 drop table if exists "invoice_override_test"; [] gorptest: 10:32:26.442126 drop table if exists "person_test"; [] gorptest: 10:32:26.442167 drop table if exists "ignored_column_test"; [] gorptest: 10:32:26.442207 drop table if exists "id_created_test"; [] gorptest: 10:32:26.442247 drop table if exists "type_conv_test"; [] gorptest: 10:32:26.442287 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:26.442329 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:26.442373 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:26.442416 drop table if exists "time_test"; [] gorptest: 10:32:26.442470 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:26.468653 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:26.488628 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:26.508861 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:26.521567 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:26.562539 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:26.619884 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:26.639614 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:26.651173 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:26.664784 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:26.679856 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:26.710370 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:26.727914 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] gorptest: 10:32:26.761301 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 10:32:26.761615 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] gorptest: 10:32:26.792172 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 10:32:26.795156 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 10:32:26.810900 drop table if exists "invoice_test"; [] gorptest: 10:32:26.822943 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:26.843285 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:26.855221 drop table if exists "invoice_override_test"; [] gorptest: 10:32:26.878565 drop table if exists "person_test"; [] gorptest: 10:32:26.898936 drop table if exists "ignored_column_test"; [] gorptest: 10:32:26.952633 drop table if exists "id_created_test"; [] gorptest: 10:32:26.973129 drop table if exists "type_conv_test"; [] gorptest: 10:32:26.992452 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:27.013017 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:27.033850 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:27.060038 drop table if exists "time_test"; [] gorptest: 10:32:27.078623 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.64s) === RUN TestWithEmbeddedStruct 2024/06/04 10:32:27 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:27.079140 drop table if exists "invoice_test"; [] gorptest: 10:32:27.079587 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:27.079647 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:27.079691 drop table if exists "invoice_override_test"; [] gorptest: 10:32:27.079736 drop table if exists "person_test"; [] gorptest: 10:32:27.079780 drop table if exists "ignored_column_test"; [] gorptest: 10:32:27.079825 drop table if exists "id_created_test"; [] gorptest: 10:32:27.080893 drop table if exists "type_conv_test"; [] gorptest: 10:32:27.080986 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:27.081034 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:27.081090 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:27.081133 drop table if exists "time_test"; [] gorptest: 10:32:27.081187 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:27.096803 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:27.120795 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:27.136749 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:27.152466 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:27.163585 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:27.175933 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:27.201348 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:27.214050 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:27.230660 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:27.410194 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:27.421967 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:27.438604 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 10:32:27.482375 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 10:32:27.482655 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 10:32:27.511907 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 10:32:27.512153 select * from embedded_struct_test [] gorptest: 10:32:27.512277 drop table if exists "invoice_test"; [] gorptest: 10:32:27.529285 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:27.542869 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:27.554179 drop table if exists "invoice_override_test"; [] gorptest: 10:32:27.586238 drop table if exists "person_test"; [] gorptest: 10:32:27.601109 drop table if exists "ignored_column_test"; [] gorptest: 10:32:27.614057 drop table if exists "id_created_test"; [] gorptest: 10:32:27.627968 drop table if exists "type_conv_test"; [] gorptest: 10:32:27.646153 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:27.664889 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:27.679480 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:27.689747 drop table if exists "time_test"; [] gorptest: 10:32:27.709961 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.63s) === RUN TestWithEmbeddedStructBeforeAutoincr 2024/06/04 10:32:27 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:27.712514 drop table if exists "invoice_test"; [] gorptest: 10:32:27.712905 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:27.713015 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:27.713053 drop table if exists "invoice_override_test"; [] gorptest: 10:32:27.713089 drop table if exists "person_test"; [] gorptest: 10:32:27.713128 drop table if exists "ignored_column_test"; [] gorptest: 10:32:27.713174 drop table if exists "id_created_test"; [] gorptest: 10:32:27.713209 drop table if exists "type_conv_test"; [] gorptest: 10:32:27.713250 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:27.713291 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:27.713331 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:27.713366 drop table if exists "time_test"; [] gorptest: 10:32:27.713413 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:27.729437 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:27.744306 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:27.763761 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:27.787155 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:27.806213 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:27.912412 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:27.974656 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:27.987838 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:28.007277 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:28.021364 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:28.038281 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:28.059486 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 10:32:28.073741 drop table if exists "invoice_test"; [] gorptest: 10:32:28.083378 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:28.095134 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:28.108931 drop table if exists "invoice_override_test"; [] gorptest: 10:32:28.128049 drop table if exists "person_test"; [] gorptest: 10:32:28.138219 drop table if exists "ignored_column_test"; [] gorptest: 10:32:28.149490 drop table if exists "id_created_test"; [] gorptest: 10:32:28.161359 drop table if exists "type_conv_test"; [] gorptest: 10:32:28.175788 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:28.196277 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:28.209209 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:28.219668 drop table if exists "time_test"; [] gorptest: 10:32:28.235070 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.52s) === RUN TestWithEmbeddedAutoincr 2024/06/04 10:32:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:28.236032 drop table if exists "invoice_test"; [] gorptest: 10:32:28.236812 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:28.236863 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:28.236903 drop table if exists "invoice_override_test"; [] gorptest: 10:32:28.237641 drop table if exists "person_test"; [] gorptest: 10:32:28.237671 drop table if exists "ignored_column_test"; [] gorptest: 10:32:28.237698 drop table if exists "id_created_test"; [] gorptest: 10:32:28.237725 drop table if exists "type_conv_test"; [] gorptest: 10:32:28.237752 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:28.237778 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:28.237844 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:28.237872 drop table if exists "time_test"; [] gorptest: 10:32:28.238441 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:28.250287 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:28.270682 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:28.284434 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:28.298565 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:28.310776 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:28.335923 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:28.500810 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:28.515369 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:28.529651 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:28.544449 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:28.558083 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:28.572678 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 10:32:28.588244 drop table if exists "invoice_test"; [] gorptest: 10:32:28.605138 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:28.617943 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:28.633604 drop table if exists "invoice_override_test"; [] gorptest: 10:32:28.650208 drop table if exists "person_test"; [] gorptest: 10:32:28.664369 drop table if exists "ignored_column_test"; [] gorptest: 10:32:28.680055 drop table if exists "id_created_test"; [] gorptest: 10:32:28.690662 drop table if exists "type_conv_test"; [] gorptest: 10:32:28.704432 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:28.720884 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:28.740597 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:28.757557 drop table if exists "time_test"; [] gorptest: 10:32:28.771009 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.54s) === RUN TestSelectVal gorptest: 10:32:28.771496 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 10:32:28.785725 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] gorptest: 10:32:28.801899 select Int64 from TableWithNull where Str='abc' [] gorptest: 10:32:28.802079 select count(*) from TableWithNull [] gorptest: 10:32:28.802088 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 10:32:28.802154 select Int64 from TableWithNull where Str='notfound' [] gorptest: 10:32:28.802208 select Int64 from TableWithNull where Str='abc' [] gorptest: 10:32:28.802261 select Float64 from TableWithNull where Str='abc' [] gorptest: 10:32:28.802313 select min(Float64) from TableWithNull [] gorptest: 10:32:28.802376 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 10:32:28.802523 select Float64 from TableWithNull where Str='notfound' [] gorptest: 10:32:28.802546 select Float64 from TableWithNull where Str='abc' [] gorptest: 10:32:28.802546 select Str from TableWithNull where Int64=? [1:78] gorptest: 10:32:28.802594 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 10:32:28.802644 select Str from TableWithNull where Int64=? [1:78] gorptest: 10:32:28.802789 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 10:32:28.802939 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 10:32:28.802976 select Str from TableWithNull where Int64=? [1:78] gorptest: 10:32:28.803068 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.05s) === RUN TestVersionMultipleRows 2024/06/04 10:32:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:28.822584 drop table if exists "invoice_test"; [] gorptest: 10:32:28.822979 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:28.822979 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:28.822982 drop table if exists "invoice_override_test"; [] gorptest: 10:32:28.823017 drop table if exists "person_test"; [] gorptest: 10:32:28.823051 drop table if exists "ignored_column_test"; [] gorptest: 10:32:28.823163 drop table if exists "id_created_test"; [] gorptest: 10:32:28.823198 drop table if exists "type_conv_test"; [] gorptest: 10:32:28.823244 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:28.823272 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:28.823303 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:28.823303 drop table if exists "time_test"; [] gorptest: 10:32:28.823383 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:28.847469 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:28.860568 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:29.078186 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:30.094210 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:30.321835 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:30.343841 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:30.362110 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:30.375033 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:30.395626 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:30.412525 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:30.426133 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:30.438698 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497150438640780 2:1717497150438640780 3:"Bob" 4:"Smith" 5:1] gorptest: 10:32:30.451070 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497150451036544 2:1717497150451036544 3:"Jane" 4:"Smith" 5:1] gorptest: 10:32:30.473260 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497150473218660 2:1717497150473218660 3:"Mike" 4:"Smith" 5:1] gorptest: 10:32:30.500014 drop table if exists "invoice_test"; [] gorptest: 10:32:30.738339 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:30.752028 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:30.769392 drop table if exists "invoice_override_test"; [] gorptest: 10:32:30.786622 drop table if exists "person_test"; [] gorptest: 10:32:30.803716 drop table if exists "ignored_column_test"; [] gorptest: 10:32:30.816277 drop table if exists "id_created_test"; [] gorptest: 10:32:30.830886 drop table if exists "type_conv_test"; [] gorptest: 10:32:30.844350 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:30.857128 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:30.876098 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:30.890653 drop table if exists "time_test"; [] gorptest: 10:32:30.904443 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (2.08s) === RUN TestWithStringPk gorptest: 10:32:30.904861 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 10:32:30.919943 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 10:32:30.934457 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.04s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2024/06/04 10:32:30 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:30.945280 drop table if exists "invoice_test"; [] gorptest: 10:32:30.945835 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:30.945886 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:30.945921 drop table if exists "invoice_override_test"; [] gorptest: 10:32:30.945955 drop table if exists "person_test"; [] gorptest: 10:32:30.945987 drop table if exists "ignored_column_test"; [] gorptest: 10:32:30.946020 drop table if exists "id_created_test"; [] gorptest: 10:32:30.946053 drop table if exists "type_conv_test"; [] gorptest: 10:32:30.946291 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:30.946345 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:30.946386 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:30.946424 drop table if exists "time_test"; [] gorptest: 10:32:30.946551 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:30.969780 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:30.980363 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:31.004674 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:31.022723 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:31.040953 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:31.058244 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:31.214595 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:31.228475 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:31.249273 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:31.261990 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:31.280443 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:31.760611 insert into "time_test" ("Id","Time") values (null,?); [1:2024-06-04 10:01:31.760566174 +0000 UTC] gorptest: 10:32:32.236710 insert into "time_test" ("Id","Time") values (null,?); [1:2024-06-04 10:02:32.760566174 +0000 UTC] gorptest: 10:32:32.256271 SELECT id FROM time_test WHERE Time < ? [1:2024-06-04 10:02:31.760566174 +0000 UTC] gorptest: 10:32:32.256532 drop table if exists "invoice_test"; [] gorptest: 10:32:32.279689 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:32.302806 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:32.330752 drop table if exists "invoice_override_test"; [] gorptest: 10:32:32.349958 drop table if exists "person_test"; [] gorptest: 10:32:32.361136 drop table if exists "ignored_column_test"; [] gorptest: 10:32:32.371268 drop table if exists "id_created_test"; [] gorptest: 10:32:32.386544 drop table if exists "type_conv_test"; [] gorptest: 10:32:32.410086 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:32.430318 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:32.457964 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:32.468145 drop table if exists "time_test"; [] gorptest: 10:32:32.480182 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (1.54s) === RUN TestInvoicePersonView 2024/06/04 10:32:32 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:32.480658 drop table if exists "invoice_test"; [] gorptest: 10:32:32.481134 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:32.481177 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:32.481213 drop table if exists "invoice_override_test"; [] gorptest: 10:32:32.481252 drop table if exists "person_test"; [] gorptest: 10:32:32.481293 drop table if exists "ignored_column_test"; [] gorptest: 10:32:32.481333 drop table if exists "id_created_test"; [] gorptest: 10:32:32.481374 drop table if exists "type_conv_test"; [] gorptest: 10:32:32.481419 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:32.481464 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:32.481505 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:32.481553 drop table if exists "time_test"; [] gorptest: 10:32:32.481612 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:32.501023 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:32.519035 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:32.536617 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:32.554492 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:32.583623 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:32.762524 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:32.782607 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:32.807966 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:32.819630 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:33.043346 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:33.079886 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:33.100275 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497153100229331 2:1717497153100229331 3:"bob" 4:"smith" 5:1] gorptest: 10:32:33.133456 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 10:32:33.157333 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 10:32:33.157655 drop table if exists "invoice_test"; [] gorptest: 10:32:33.173459 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:33.190857 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:33.209607 drop table if exists "invoice_override_test"; [] gorptest: 10:32:33.228532 drop table if exists "person_test"; [] gorptest: 10:32:33.242344 drop table if exists "ignored_column_test"; [] gorptest: 10:32:33.260165 drop table if exists "id_created_test"; [] gorptest: 10:32:33.284747 drop table if exists "type_conv_test"; [] gorptest: 10:32:33.904084 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:34.178724 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:34.211242 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:34.364117 drop table if exists "time_test"; [] gorptest: 10:32:34.413536 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (1.93s) === RUN TestQuoteTableNames 2024/06/04 10:32:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:34.414307 drop table if exists "invoice_test"; [] gorptest: 10:32:34.414786 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:34.414880 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:34.414964 drop table if exists "invoice_override_test"; [] gorptest: 10:32:34.415044 drop table if exists "person_test"; [] gorptest: 10:32:34.415129 drop table if exists "ignored_column_test"; [] gorptest: 10:32:34.415210 drop table if exists "id_created_test"; [] gorptest: 10:32:34.415289 drop table if exists "type_conv_test"; [] gorptest: 10:32:34.415365 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:34.415449 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:34.415523 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:34.415605 drop table if exists "time_test"; [] gorptest: 10:32:34.415688 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:34.598110 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:34.642135 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:34.770004 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:34.787073 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:34.806677 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:34.825101 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:34.840985 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:34.996796 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:36.053158 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:36.300836 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:36.714594 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (5.88s) === RUN TestSelectTooManyCols 2024/06/04 10:32:40 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:40.293556 drop table if exists "invoice_test"; [] gorptest: 10:32:40.293979 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:40.294213 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:40.294265 drop table if exists "invoice_override_test"; [] gorptest: 10:32:40.294296 drop table if exists "person_test"; [] gorptest: 10:32:40.294324 drop table if exists "ignored_column_test"; [] gorptest: 10:32:40.294351 drop table if exists "id_created_test"; [] gorptest: 10:32:40.294378 drop table if exists "type_conv_test"; [] gorptest: 10:32:40.294405 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:40.294433 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:40.294472 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:40.294504 drop table if exists "time_test"; [] gorptest: 10:32:40.294541 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:40.310196 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:40.329324 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:40.348785 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:40.364110 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:40.375661 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:40.390783 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:40.423771 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:40.453042 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:40.475250 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:40.491237 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:40.508325 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:40.521688 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497160521643131 2:1717497160521643131 3:"bob" 4:"smith" 5:1] gorptest: 10:32:40.533209 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497160533174886 2:1717497160533174886 3:"jane" 4:"doe" 5:1] gorptest: 10:32:40.552858 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:40.553095 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 10:32:40.553214 select * from person_test where Id=? [1:1] gorptest: 10:32:40.553321 select * from person_test order by fname asc [] gorptest: 10:32:40.553467 drop table if exists "invoice_test"; [] gorptest: 10:32:40.569518 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:40.583290 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:40.595792 drop table if exists "invoice_override_test"; [] gorptest: 10:32:40.612288 drop table if exists "person_test"; [] gorptest: 10:32:40.623581 drop table if exists "ignored_column_test"; [] gorptest: 10:32:40.647723 drop table if exists "id_created_test"; [] gorptest: 10:32:40.661713 drop table if exists "type_conv_test"; [] gorptest: 10:32:40.675652 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:40.691008 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:40.703581 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:40.719339 drop table if exists "time_test"; [] gorptest: 10:32:40.731802 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.44s) === RUN TestSelectSingleVal 2024/06/04 10:32:40 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:40.732232 drop table if exists "invoice_test"; [] gorptest: 10:32:40.732707 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:40.732743 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:40.732793 drop table if exists "invoice_override_test"; [] gorptest: 10:32:40.732829 drop table if exists "person_test"; [] gorptest: 10:32:40.732859 drop table if exists "ignored_column_test"; [] gorptest: 10:32:40.732891 drop table if exists "id_created_test"; [] gorptest: 10:32:40.732934 drop table if exists "type_conv_test"; [] gorptest: 10:32:40.732976 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:40.733028 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:40.735197 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:40.735252 drop table if exists "time_test"; [] gorptest: 10:32:40.735317 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:40.750419 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:40.887469 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:40.903723 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:40.919358 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:40.932416 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:40.950982 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:40.963313 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:40.980442 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:40.997696 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:41.014016 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:41.027570 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:41.042996 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497161042954095 2:1717497161042954095 3:"bob" 4:"smith" 5:1] gorptest: 10:32:41.057986 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 10:32:41.058222 select * from person_test where Id=? [1:1] gorptest: 10:32:41.058399 select FName from person_test where Id=? [1:1] gorptest: 10:32:41.058456 select * from person_test where Id=? [1:1] gorptest: 10:32:41.058554 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 10:32:41.058903 select * from person_test where Id=? [1:-2222] gorptest: 10:32:41.058991 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717497161058978370 2:1717497161058978370 3:"bob" 4:"smith" 5:1] gorptest: 10:32:41.076461 select * from person_test where Fname='bob' [] gorptest: 10:32:41.076722 select * from person_test where Id=-123 [] gorptest: 10:32:41.076771 select * from person_test where Id=-123 [] gorptest: 10:32:41.076813 select * from person_test where Id=-123 [] gorptest: 10:32:41.076854 select * from person_test where Id=-123 [] gorptest: 10:32:41.076900 drop table if exists "invoice_test"; [] gorptest: 10:32:41.090772 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:41.106871 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:41.123533 drop table if exists "invoice_override_test"; [] gorptest: 10:32:41.138157 drop table if exists "person_test"; [] gorptest: 10:32:41.157225 drop table if exists "ignored_column_test"; [] gorptest: 10:32:41.172690 drop table if exists "id_created_test"; [] gorptest: 10:32:41.189653 drop table if exists "type_conv_test"; [] gorptest: 10:32:41.204612 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:41.223815 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:41.266529 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:41.487840 drop table if exists "time_test"; [] gorptest: 10:32:41.772563 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (1.04s) === RUN TestSelectAlias 2024/06/04 10:32:41 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:41.772984 drop table if exists "invoice_test"; [] gorptest: 10:32:41.773520 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:41.773555 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:41.773584 drop table if exists "invoice_override_test"; [] gorptest: 10:32:41.773616 drop table if exists "person_test"; [] gorptest: 10:32:41.773643 drop table if exists "ignored_column_test"; [] gorptest: 10:32:41.773768 drop table if exists "id_created_test"; [] gorptest: 10:32:41.773852 drop table if exists "type_conv_test"; [] gorptest: 10:32:41.773893 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:41.773934 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:41.773977 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:41.774026 drop table if exists "time_test"; [] gorptest: 10:32:41.774065 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:41.790566 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:41.808668 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:41.822215 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:41.837211 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:41.853758 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:41.872200 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:41.883296 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:41.918064 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:42.156348 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:42.175184 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:42.190043 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:42.203955 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 10:32:42.221605 select * from id_created_test where Id=1 [] gorptest: 10:32:42.221914 SELECT *, 1 AS external FROM id_created_test [] gorptest: 10:32:42.222033 drop table if exists "invoice_test"; [] gorptest: 10:32:42.250068 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:42.288690 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:42.324645 drop table if exists "invoice_override_test"; [] gorptest: 10:32:42.341243 drop table if exists "person_test"; [] gorptest: 10:32:42.355868 drop table if exists "ignored_column_test"; [] gorptest: 10:32:42.375721 drop table if exists "id_created_test"; [] gorptest: 10:32:42.393348 drop table if exists "type_conv_test"; [] gorptest: 10:32:42.407627 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:42.421653 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:42.435543 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:42.446605 drop table if exists "time_test"; [] gorptest: 10:32:42.460082 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.69s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2024/06/04 10:32:42 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:42.462594 drop table if exists "invoice_test"; [] gorptest: 10:32:42.463278 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:42.463322 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:42.463362 drop table if exists "invoice_override_test"; [] gorptest: 10:32:42.463567 drop table if exists "person_test"; [] gorptest: 10:32:42.463623 drop table if exists "ignored_column_test"; [] gorptest: 10:32:42.463683 drop table if exists "id_created_test"; [] gorptest: 10:32:42.463724 drop table if exists "type_conv_test"; [] gorptest: 10:32:42.463762 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:42.463802 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:42.463842 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:42.463880 drop table if exists "time_test"; [] gorptest: 10:32:42.463932 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:42.482988 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:42.495483 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:42.518770 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:42.534407 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:42.546259 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:42.559957 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:42.578190 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:42.591802 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:42.605596 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:42.621564 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:42.641213 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:42.657609 drop table if exists "invoice_test"; [] gorptest: 10:32:42.670327 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:42.681184 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:42.699325 drop table if exists "invoice_override_test"; [] gorptest: 10:32:42.712865 drop table if exists "person_test"; [] gorptest: 10:32:42.723778 drop table if exists "ignored_column_test"; [] gorptest: 10:32:42.734364 drop table if exists "id_created_test"; [] gorptest: 10:32:42.744918 drop table if exists "type_conv_test"; [] gorptest: 10:32:42.765521 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:42.779980 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:42.792712 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:42.804128 drop table if exists "time_test"; [] gorptest: 10:32:42.821562 drop table if exists "id_created_test"; [] gorptest: 10:32:42.821703 drop table if exists "single_column_table"; [] gorptest: 10:32:42.821761 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:42.838278 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:42.851687 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:42.866016 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:42.877094 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:42.897867 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:42.926071 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:42.939219 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:42.955652 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:42.969694 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:42.992738 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:43.008396 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:43.020792 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 10:32:43.020932 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 10:32:43.053281 delete from "invoice_test"; [] gorptest: 10:32:43.070418 delete from "invoice_tag_test"; [] gorptest: 10:32:43.292519 delete from "alias_trans_field_test"; [] gorptest: 10:32:43.315306 delete from "invoice_override_test"; [] gorptest: 10:32:43.346246 delete from "person_test"; [] gorptest: 10:32:43.366126 delete from "ignored_column_test"; [] gorptest: 10:32:43.390190 delete from "id_created_test"; [] gorptest: 10:32:43.418312 delete from "type_conv_test"; [] gorptest: 10:32:43.450096 delete from "embedded_struct_test"; [] gorptest: 10:32:43.478106 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:43.506045 delete from "embedded_autoincr_test"; [] gorptest: 10:32:43.534226 delete from "time_test"; [] gorptest: 10:32:43.550644 delete from "id_created_test"; [] gorptest: 10:32:43.571705 delete from "single_column_table"; [] gorptest: 10:32:43.598981 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 10:32:43.599229 drop table if exists "invoice_test"; [] gorptest: 10:32:43.614973 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:43.633372 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:43.659595 drop table if exists "invoice_override_test"; [] gorptest: 10:32:43.702050 drop table if exists "person_test"; [] gorptest: 10:32:43.726109 drop table if exists "ignored_column_test"; [] gorptest: 10:32:43.751187 drop table if exists "id_created_test"; [] gorptest: 10:32:43.782567 drop table if exists "type_conv_test"; [] gorptest: 10:32:43.806162 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:43.836188 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:43.858421 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:43.878277 drop table if exists "time_test"; [] gorptest: 10:32:43.902133 drop table if exists "id_created_test"; [] gorptest: 10:32:43.902287 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (1.48s) === RUN TestPrepare 2024/06/04 10:32:43 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 10:32:43.946445 drop table if exists "invoice_test"; [] gorptest: 10:32:43.946912 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:43.947057 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:43.947101 drop table if exists "invoice_override_test"; [] gorptest: 10:32:43.947101 drop table if exists "person_test"; [] gorptest: 10:32:43.947101 drop table if exists "ignored_column_test"; [] gorptest: 10:32:43.947128 drop table if exists "id_created_test"; [] gorptest: 10:32:43.947167 drop table if exists "type_conv_test"; [] gorptest: 10:32:43.947215 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:43.947251 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:43.947289 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:43.947419 drop table if exists "time_test"; [] gorptest: 10:32:43.947479 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:43.980219 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 10:32:44.000968 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 10:32:44.034417 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 10:32:44.056135 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 10:32:44.073127 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:44.094466 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 10:32:44.138120 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 10:32:44.170238 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 10:32:44.250068 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 10:32:44.266174 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 10:32:44.290201 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 10:32:44.322134 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 10:32:44.350232 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 10:32:44.386135 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 10:32:44.426019 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 10:32:44.426369 begin; [] gorptest: 10:32:44.426423 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 10:32:44.426676 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 10:32:44.427163 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 10:32:44.428630 commit; [] gorptest: 10:32:44.466157 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 10:32:44.466507 drop table if exists "invoice_test"; [] gorptest: 10:32:44.490663 drop table if exists "invoice_tag_test"; [] gorptest: 10:32:44.519983 drop table if exists "alias_trans_field_test"; [] gorptest: 10:32:44.554246 drop table if exists "invoice_override_test"; [] gorptest: 10:32:44.586197 drop table if exists "person_test"; [] gorptest: 10:32:44.622250 drop table if exists "ignored_column_test"; [] gorptest: 10:32:44.633784 drop table if exists "id_created_test"; [] gorptest: 10:32:44.647703 drop table if exists "type_conv_test"; [] gorptest: 10:32:44.670051 drop table if exists "embedded_struct_test"; [] gorptest: 10:32:44.694093 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 10:32:44.717373 drop table if exists "embedded_autoincr_test"; [] gorptest: 10:32:44.734261 drop table if exists "time_test"; [] gorptest: 10:32:44.761717 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.82s) PASS ok gopkg.in/gorp.v1 33.424s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install --destdir=debian/golang-gopkg-gorp.v1-dev/ -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem I: cleaning the build env I: removing directory /srv/workspace/pbuilder/2173520 and its subdirectories I: Current time: Mon Jun 3 22:33:00 -12 2024 I: pbuilder-time-stamp: 1717497180 Tue Jun 4 10:33:02 UTC 2024 I: 1st build successful. Starting 2nd build on remote node ionos15-amd64.debian.net. Tue Jun 4 10:33:02 UTC 2024 I: Preparing to do remote build '2' on ionos15-amd64.debian.net. Tue Jun 4 10:33:53 UTC 2024 I: Deleting $TMPDIR on ionos15-amd64.debian.net. Tue Jun 4 10:33:53 UTC 2024 I: golang-gopkg-gorp.v1_1.7.2-2_amd64.changes: Format: 1.8 Date: Sun, 19 Apr 2020 20:26:27 +0530 Source: golang-gopkg-gorp.v1 Binary: golang-gopkg-gorp.v1-dev Architecture: all Version: 1.7.2-2 Distribution: unstable Urgency: medium Maintainer: Debian Go Packaging Team Changed-By: Pirate Praveen Description: golang-gopkg-gorp.v1-dev - Go Relational Persistence - an ORM-ish library for Go (library) Changes: golang-gopkg-gorp.v1 (1.7.2-2) unstable; urgency=medium . * Source only upload for testing migration Checksums-Sha1: b0ff3c44f5e5144378ef12551b8a933ebc0ad14a 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 716e8f445e7e7e6520c39cd7ceb72290fe562159 6083 golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb e55aa06523a739d536d107eed4a25b976b94b7893b7416c69e4477fd87c73248 6083 golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 2893a9ca22dfdedbd608cf3a1c267fa9 6083 devel optional golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Tue Jun 4 10:33:54 UTC 2024 I: diffoscope 269 will be used to compare the two builds: Running as unit: rb-diffoscope-amd64_7-23521.service # Profiling output for: /usr/bin/diffoscope --timeout 7200 --html /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.changes /srv/reproducible-results/rbuild-debian/r-b-build.w0RUi6oF/b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.changes ## command (total time: 0.000s) 0.000s 1 call cmp (internal) ## has_same_content_as (total time: 0.000s) 0.000s 1 call abc.DotChangesFile ## main (total time: 0.373s) 0.373s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.016s) 0.016s 12 calls diffoscope.comparators.binary.FilesystemFile ## specialize (total time: 0.000s) 0.000s 1 call specialize Finished with result: success Main processes terminated with: code=exited/status=0 Service runtime: 732ms CPU time consumed: 730ms Tue Jun 4 10:33:55 UTC 2024 I: diffoscope 269 found no differences in the changes files, and a .buildinfo file also exists. Tue Jun 4 10:33:55 UTC 2024 I: golang-gopkg-gorp.v1 from unstable built successfully and reproducibly on amd64. Tue Jun 4 10:33:57 UTC 2024 I: Submitting .buildinfo files to external archives: Tue Jun 4 10:33:57 UTC 2024 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc Tue Jun 4 10:33:59 UTC 2024 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc Tue Jun 4 10:34:01 UTC 2024 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Tue Jun 4 10:34:01 UTC 2024 I: Done submitting .buildinfo files. Tue Jun 4 10:34:01 UTC 2024 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc'