Tue Sep 7 00:52:11 UTC 2021 I: starting to build golang-gopkg-gorp.v1/bullseye/arm64 on jenkins on '2021-09-07 00:52' Tue Sep 7 00:52:11 UTC 2021 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/arm64_5/37727/console.log Tue Sep 7 00:52:11 UTC 2021 I: Downloading source for bullseye/golang-gopkg-gorp.v1=1.7.2-2 --2021-09-07 00:52:11-- http://cdn-fastly.deb.debian.org/debian/pool/main/g/golang-gopkg-gorp.v1/golang-gopkg-gorp.v1_1.7.2-2.dsc Connecting to 78.137.99.97:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2257 (2.2K) Saving to: ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ 0K .. 100% 10.6M=0s 2021-09-07 00:52:11 (10.6 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Tue Sep 7 00:52:11 UTC 2021 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 Sep 7 00:52:11 UTC 2021 I: Checking whether the package is not for us Tue Sep 7 00:52:11 UTC 2021 I: Starting 1st build on remote node codethink10-arm64.debian.net. Tue Sep 7 00:52:11 UTC 2021 I: Preparing to do remote build '1' on codethink10-arm64.debian.net. Tue Sep 7 00:53:26 UTC 2021 I: Deleting $TMPDIR on codethink10-arm64.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Mon Sep 6 12:52:15 -12 2021 I: pbuilder-time-stamp: 1630975935 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration 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: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.upUtiF35/trustedkeys.kbx': General error gpgv: Signature made Sun Apr 19 02:59:56 2020 -12 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: failed to verify signature on ./golang-gopkg-gorp.v1_1.7.2-2.dsc 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/3099/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build' BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' BUILDUSERNAME='pbuilder1' BUILD_ARCH='arm64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=8' DISTRIBUTION='' HOME='/var/lib/jenkins' HOST_ARCH='arm64' IFS=' ' 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='3099' 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/tmp.PkcIYNWfCc/pbuilderrc_kkRZ --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='117' SUDO_UID='110' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' USERNAME='root' _='/usr/bin/systemd-run' http_proxy='http://192.168.101.16:3128' I: uname -a Linux codethink10-arm64 4.15.0-154-generic #161-Ubuntu SMP Fri Jul 30 13:01:15 UTC 2021 aarch64 GNU/Linux I: ls -l /bin total 5252 -rwxr-xr-x 1 root root 1282512 Aug 4 08:25 bash -rwxr-xr-x 3 root root 34808 Jul 20 2020 bunzip2 -rwxr-xr-x 3 root root 34808 Jul 20 2020 bzcat lrwxrwxrwx 1 root root 6 Jul 20 2020 bzcmp -> bzdiff -rwxr-xr-x 1 root root 2225 Jul 20 2020 bzdiff lrwxrwxrwx 1 root root 6 Jul 20 2020 bzegrep -> bzgrep -rwxr-xr-x 1 root root 4877 Sep 4 2019 bzexe lrwxrwxrwx 1 root root 6 Jul 20 2020 bzfgrep -> bzgrep -rwxr-xr-x 1 root root 3775 Jul 20 2020 bzgrep -rwxr-xr-x 3 root root 34808 Jul 20 2020 bzip2 -rwxr-xr-x 1 root root 14264 Jul 20 2020 bzip2recover lrwxrwxrwx 1 root root 6 Jul 20 2020 bzless -> bzmore -rwxr-xr-x 1 root root 1297 Jul 20 2020 bzmore -rwxr-xr-x 1 root root 39832 Sep 22 2020 cat -rwxr-xr-x 1 root root 64512 Sep 22 2020 chgrp -rwxr-xr-x 1 root root 60368 Sep 22 2020 chmod -rwxr-xr-x 1 root root 64528 Sep 22 2020 chown -rwxr-xr-x 1 root root 138896 Sep 22 2020 cp -rwxr-xr-x 1 root root 129544 Dec 10 2020 dash -rwxr-xr-x 1 root root 101384 Sep 22 2020 date -rwxr-xr-x 1 root root 80984 Sep 22 2020 dd -rwxr-xr-x 1 root root 89824 Sep 22 2020 df -rwxr-xr-x 1 root root 143088 Sep 22 2020 dir -rwxr-xr-x 1 root root 76152 Jul 28 07:09 dmesg lrwxrwxrwx 1 root root 8 Nov 6 2019 dnsdomainname -> hostname lrwxrwxrwx 1 root root 8 Nov 6 2019 domainname -> hostname -rwxr-xr-x 1 root root 35632 Sep 22 2020 echo -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep -rwxr-xr-x 1 root root 31512 Sep 22 2020 false -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep -rwxr-xr-x 1 root root 64856 Jul 28 07:09 findmnt -rwsr-xr-x 1 root root 34824 Feb 26 2021 fusermount -rwxr-xr-x 1 root root 178400 Nov 9 2020 grep -rwxr-xr-x 2 root root 2346 Mar 2 2021 gunzip -rwxr-xr-x 1 root root 6376 Mar 2 2021 gzexe -rwxr-xr-x 1 root root 93744 Mar 2 2021 gzip -rwxr-xr-x 1 root root 18440 Nov 6 2019 hostname -rwxr-xr-x 1 root root 68720 Sep 22 2020 ln -rwxr-xr-x 1 root root 52720 Feb 7 2020 login -rwxr-xr-x 1 root root 143088 Sep 22 2020 ls -rwxr-xr-x 1 root root 161960 Jul 28 07:09 lsblk -rwxr-xr-x 1 root root 85200 Sep 22 2020 mkdir -rwxr-xr-x 1 root root 68744 Sep 22 2020 mknod -rwxr-xr-x 1 root root 43976 Sep 22 2020 mktemp -rwxr-xr-x 1 root root 51368 Jul 28 07:09 more -rwsr-xr-x 1 root root 51360 Jul 28 07:09 mount -rwxr-xr-x 1 root root 14496 Jul 28 07:09 mountpoint -rwxr-xr-x 1 root root 134808 Sep 22 2020 mv lrwxrwxrwx 1 root root 8 Nov 6 2019 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 18 03:38 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 35720 Sep 22 2020 pwd lrwxrwxrwx 1 root root 4 Aug 4 08:25 rbash -> bash -rwxr-xr-x 1 root root 43872 Sep 22 2020 readlink -rwxr-xr-x 1 root root 68592 Sep 22 2020 rm -rwxr-xr-x 1 root root 43880 Sep 22 2020 rmdir -rwxr-xr-x 1 root root 19208 Sep 27 2020 run-parts -rwxr-xr-x 1 root root 114016 Dec 22 2018 sed lrwxrwxrwx 1 root root 4 Aug 20 21:24 sh -> dash -rwxr-xr-x 1 root root 35656 Sep 22 2020 sleep -rwxr-xr-x 1 root root 72640 Sep 22 2020 stty -rwsr-xr-x 1 root root 67776 Jul 28 07:09 su -rwxr-xr-x 1 root root 35672 Sep 22 2020 sync -rwxr-xr-x 1 root root 535768 Feb 16 2021 tar -rwxr-xr-x 1 root root 10568 Sep 27 2020 tempfile -rwxr-xr-x 1 root root 89120 Sep 22 2020 touch -rwxr-xr-x 1 root root 31512 Sep 22 2020 true -rwxr-xr-x 1 root root 14264 Feb 26 2021 ulockmgr_server -rwsr-xr-x 1 root root 30880 Jul 28 07:09 umount -rwxr-xr-x 1 root root 35640 Sep 22 2020 uname -rwxr-xr-x 2 root root 2346 Mar 2 2021 uncompress -rwxr-xr-x 1 root root 143088 Sep 22 2020 vdir -rwxr-xr-x 1 root root 59584 Jul 28 07:09 wdctl lrwxrwxrwx 1 root root 8 Nov 6 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 2 2021 zcat -rwxr-xr-x 1 root root 1678 Mar 2 2021 zcmp -rwxr-xr-x 1 root root 5880 Mar 2 2021 zdiff -rwxr-xr-x 1 root root 29 Mar 2 2021 zegrep -rwxr-xr-x 1 root root 29 Mar 2 2021 zfgrep -rwxr-xr-x 1 root root 2081 Mar 2 2021 zforce -rwxr-xr-x 1 root root 7585 Mar 2 2021 zgrep -rwxr-xr-x 1 root root 2206 Mar 2 2021 zless -rwxr-xr-x 1 root root 1842 Mar 2 2021 zmore -rwxr-xr-x 1 root root 4553 Mar 2 2021 znew I: user script /srv/workspace/pbuilder/3099/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: arm64 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 ... 19646 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.15-go{a} golang-1.15-src{a} golang-any{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-text-dev{a} golang-pq-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu67{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsigsegv2{a} libsqlite3-dev{a} libsub-override-perl{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, 46 newly installed, 0 to remove and 0 not upgraded. Need to get 80.8 MB of archives. After unpacking 475 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main arm64 bsdextrautils arm64 2.36.1-8 [142 kB] Get: 2 http://deb.debian.org/debian bullseye/main arm64 libuchardet0 arm64 0.0.7-1 [67.9 kB] Get: 3 http://deb.debian.org/debian bullseye/main arm64 groff-base arm64 1.22.4-6 [883 kB] Get: 4 http://deb.debian.org/debian bullseye/main arm64 libpipeline1 arm64 1.5.3-1 [33.0 kB] Get: 5 http://deb.debian.org/debian bullseye/main arm64 man-db arm64 2.9.4-2 [1336 kB] Get: 6 http://deb.debian.org/debian bullseye/main arm64 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main arm64 libmagic-mgc arm64 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main arm64 libmagic1 arm64 1:5.39-3 [121 kB] Get: 9 http://deb.debian.org/debian bullseye/main arm64 file arm64 1:5.39-3 [69.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main arm64 gettext-base arm64 0.21-4 [173 kB] Get: 11 http://deb.debian.org/debian bullseye/main arm64 libsigsegv2 arm64 2.13-1 [34.7 kB] Get: 12 http://deb.debian.org/debian bullseye/main arm64 m4 arm64 1.4.18-5 [199 kB] Get: 13 http://deb.debian.org/debian bullseye/main arm64 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main arm64 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main arm64 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main arm64 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main arm64 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main arm64 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main arm64 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main arm64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main arm64 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main arm64 libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main arm64 dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main arm64 libelf1 arm64 0.183-1 [164 kB] Get: 25 http://deb.debian.org/debian bullseye/main arm64 dwz arm64 0.13+20210201-1 [155 kB] Get: 26 http://deb.debian.org/debian bullseye/main arm64 libicu67 arm64 67.1-7 [8467 kB] Get: 27 http://deb.debian.org/debian bullseye/main arm64 libxml2 arm64 2.9.10+dfsg-6.7 [629 kB] Get: 28 http://deb.debian.org/debian bullseye/main arm64 gettext arm64 0.21-4 [1261 kB] Get: 29 http://deb.debian.org/debian bullseye/main arm64 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main arm64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main arm64 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main arm64 dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main arm64 golang-1.15-src arm64 1.15.9-6 [13.8 MB] Get: 34 http://deb.debian.org/debian bullseye/main arm64 golang-1.15-go arm64 1.15.9-6 [43.0 MB] Get: 35 http://deb.debian.org/debian bullseye/main arm64 golang-src arm64 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main arm64 golang-go arm64 2:1.15~1 [23.9 kB] Get: 37 http://deb.debian.org/debian bullseye/main arm64 golang-any arm64 2:1.15~1 [4976 B] Get: 38 http://deb.debian.org/debian bullseye/main arm64 golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main arm64 golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main arm64 golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main arm64 golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main arm64 golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main arm64 libsqlite3-dev arm64 3.34.1-3 [911 kB] Get: 44 http://deb.debian.org/debian bullseye/main arm64 golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Get: 46 http://deb.debian.org/debian bullseye/main arm64 golang-pq-dev all 1.3.0-1 [3092 B] Fetched 80.8 MB in 1s (56.7 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package bsdextrautils. (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 ... 19646 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-8_arm64.deb ... Unpacking bsdextrautils (2.36.1-8) ... Selecting previously unselected package libuchardet0:arm64. Preparing to unpack .../01-libuchardet0_0.0.7-1_arm64.deb ... Unpacking libuchardet0:arm64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_arm64.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:arm64. Preparing to unpack .../03-libpipeline1_1.5.3-1_arm64.deb ... Unpacking libpipeline1:arm64 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_arm64.deb ... Unpacking man-db (2.9.4-2) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../05-sensible-utils_0.0.14_all.deb ... Unpacking sensible-utils (0.0.14) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../06-libmagic-mgc_1%3a5.39-3_arm64.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:arm64. Preparing to unpack .../07-libmagic1_1%3a5.39-3_arm64.deb ... Unpacking libmagic1:arm64 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_arm64.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_arm64.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:arm64. Preparing to unpack .../10-libsigsegv2_2.13-1_arm64.deb ... Unpacking libsigsegv2:arm64 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_arm64.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.12.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.12.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.12.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.12.0-1) ... Selecting previously unselected package libelf1:arm64. Preparing to unpack .../23-libelf1_0.183-1_arm64.deb ... Unpacking libelf1:arm64 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_arm64.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:arm64. Preparing to unpack .../25-libicu67_67.1-7_arm64.deb ... Unpacking libicu67:arm64 (67.1-7) ... Selecting previously unselected package libxml2:arm64. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_arm64.deb ... Unpacking libxml2:arm64 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_arm64.deb ... Unpacking gettext (0.21-4) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../28-intltool-debian_0.35.0+20060710.5_all.deb ... Unpacking intltool-debian (0.35.0+20060710.5) ... Selecting previously unselected package po-debconf. Preparing to unpack .../29-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../30-debhelper_13.3.4_all.deb ... Unpacking debhelper (13.3.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../31-dh-golang_1.51_all.deb ... Unpacking dh-golang (1.51) ... Selecting previously unselected package golang-1.15-src. Preparing to unpack .../32-golang-1.15-src_1.15.9-6_arm64.deb ... Unpacking golang-1.15-src (1.15.9-6) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.9-6_arm64.deb ... Unpacking golang-1.15-go (1.15.9-6) ... Selecting previously unselected package golang-src:arm64. Preparing to unpack .../34-golang-src_2%3a1.15~1_arm64.deb ... Unpacking golang-src:arm64 (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_arm64.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:arm64. Preparing to unpack .../36-golang-any_2%3a1.15~1_arm64.deb ... Unpacking golang-any:arm64 (2:1.15~1) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../37-golang-github-go-sql-driver-mysql-dev_1.5.0-1_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../38-golang-github-lib-pq-dev_1.3.0-1_all.deb ... Unpacking golang-github-lib-pq-dev (1.3.0-1) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../39-golang-golang-x-sys-dev_0.0~git20210124.22da62e-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../40-golang-golang-x-text-dev_0.3.6-1_all.deb ... Unpacking golang-golang-x-text-dev (0.3.6-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../41-golang-golang-x-net-dev_1%3a0.0+git20210119.5f4716e+dfsg-4_all.deb ... Unpacking golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Selecting previously unselected package libsqlite3-dev:arm64. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_arm64.deb ... Unpacking libsqlite3-dev:arm64 (3.34.1-3) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev. Preparing to unpack .../43-golang-github-mattn-go-sqlite3-dev_1.6.0~ds1-2_all.deb ... Unpacking golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../44-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) ... Selecting previously unselected package golang-pq-dev. Preparing to unpack .../45-golang-pq-dev_1.3.0-1_all.deb ... Unpacking golang-pq-dev (1.3.0-1) ... Setting up libpipeline1:arm64 (1.5.3-1) ... Setting up bsdextrautils (2.36.1-8) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:arm64 (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.9-6) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libdebhelper-perl (13.3.4) ... Setting up golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Setting up libmagic1:arm64 (1:5.39-3) ... Setting up gettext-base (0.21-4) ... Setting up golang-github-lib-pq-dev (1.3.0-1) ... Setting up file (1:5.39-3) ... Setting up autotools-dev (20180224.1+nmu1) ... Setting up libsqlite3-dev:arm64 (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:arm64 (2.13-1) ... Setting up autopoint (0.21-4) ... Setting up sensible-utils (0.0.14) ... Setting up golang-golang-x-text-dev (0.3.6-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Setting up libuchardet0:arm64 (0.0.7-1) ... Setting up libsub-override-perl (0.09-2) ... Setting up golang-pq-dev (1.3.0-1) ... Setting up golang-src:arm64 (2:1.15~1) ... Setting up golang-1.15-go (1.15.9-6) ... Setting up libelf1:arm64 (0.183-1) ... Setting up libxml2:arm64 (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.12.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up golang-go (2:1.15~1) ... Setting up m4 (1.4.18-5) ... Setting up golang-any:arm64 (2:1.15~1) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.12.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Setting up debhelper (13.3.4) ... Setting up dh-golang (1.51) ... Processing triggers for libc-bin (2.31-13) ... 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/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 arm64 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 8 gopkg.in/gorp.v1 internal/race internal/cpu unicode/utf8 runtime/internal/sys internal/unsafeheader runtime/internal/atomic sync/atomic math/bits unicode runtime/internal/math internal/bytealg math internal/testlog runtime internal/reflectlite sync errors sort internal/oserror io strconv syscall bytes strings reflect regexp/syntax internal/syscall/unix internal/syscall/execenv time regexp context internal/poll internal/fmtsort os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 8 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2021/09/07 00:53:18 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: 00:53:18.526856 drop table if exists "invoice_test"; [] gorptest: 00:53:18.527841 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.527955 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.528034 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.528118 drop table if exists "person_test"; [] gorptest: 00:53:18.528196 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.528270 drop table if exists "id_created_test"; [] gorptest: 00:53:18.528367 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.528444 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.528535 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.528620 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.528696 drop table if exists "time_test"; [] gorptest: 00:53:18.528809 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.529724 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: 00:53:18.530239 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.530750 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.531324 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.531807 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.532273 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.532756 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.533257 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.533741 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.534238 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.534743 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.535257 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: 00:53:18.535402 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: 00:53:18.535510 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.535618 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: 00:53:18.535724 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: 00:53:18.535815 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.535915 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.536011 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.536088 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.536165 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.536241 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: 00:53:18.536306 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.536376 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:53:18.536435 drop table if exists "invoice_test"; [] gorptest: 00:53:18.536902 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.537431 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.537819 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.538327 drop table if exists "person_test"; [] gorptest: 00:53:18.538723 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.539116 drop table if exists "id_created_test"; [] gorptest: 00:53:18.539539 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.539934 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.540322 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.540710 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.541210 drop table if exists "time_test"; [] gorptest: 00:53:18.541622 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.02s) === RUN TestTruncateTables 2021/09/07 00:53:18 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: 00:53:18.542227 drop table if exists "invoice_test"; [] gorptest: 00:53:18.542781 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.542916 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.543051 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.543162 drop table if exists "person_test"; [] gorptest: 00:53:18.543283 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.543365 drop table if exists "id_created_test"; [] gorptest: 00:53:18.543437 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.543507 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.543588 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.543684 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.543760 drop table if exists "time_test"; [] gorptest: 00:53:18.543863 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.544424 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: 00:53:18.544996 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.545503 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.546070 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.546562 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.547052 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.547529 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.548015 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.548508 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.549023 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.549513 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.550021 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: 00:53:18.550154 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: 00:53:18.550256 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.550377 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: 00:53:18.550495 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: 00:53:18.550605 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.550713 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.550840 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.550959 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.551071 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.551199 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: 00:53:18.551301 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.551395 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:53:18.551568 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998551512161 2:1630975998551512161 3:"Bob" 4:"Smith" 5:1] gorptest: 00:53:18.552026 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 00:53:18.552368 delete from "invoice_test"; [] gorptest: 00:53:18.552626 delete from "invoice_tag_test"; [] gorptest: 00:53:18.552884 delete from "alias_trans_field_test"; [] gorptest: 00:53:18.553158 delete from "invoice_override_test"; [] gorptest: 00:53:18.553429 delete from "person_test"; [] gorptest: 00:53:18.553818 delete from "ignored_column_test"; [] gorptest: 00:53:18.554179 delete from "id_created_test"; [] gorptest: 00:53:18.554478 delete from "type_conv_test"; [] gorptest: 00:53:18.554794 delete from "embedded_struct_test"; [] gorptest: 00:53:18.555104 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.555365 delete from "embedded_autoincr_test"; [] gorptest: 00:53:18.555667 delete from "time_test"; [] gorptest: 00:53:18.555933 delete from "id_created_test"; [] gorptest: 00:53:18.556262 SELECT * FROM person_test [] gorptest: 00:53:18.556609 SELECT * FROM invoice_test [] gorptest: 00:53:18.556866 drop table if exists "invoice_test"; [] gorptest: 00:53:18.557457 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.557958 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.558436 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.558988 drop table if exists "person_test"; [] gorptest: 00:53:18.559437 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.559851 drop table if exists "id_created_test"; [] gorptest: 00:53:18.560276 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.560710 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.561152 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.561595 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.562041 drop table if exists "time_test"; [] gorptest: 00:53:18.562473 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.02s) === RUN TestCustomDateType gorptest: 00:53:18.562955 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 00:53:18.564109 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2021-09-07 00:53:18 +0000 UTC] gorptest: 00:53:18.564550 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 00:53:18.564839 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey gorptest: 00:53:18.565657 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:53:18.566659 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:53:18.567196 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:53:18.567740 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 00:53:18.568112 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 00:53:18.568453 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 00:53:18.568782 drop table if exists "PersonUInt64"; [] gorptest: 00:53:18.569275 drop table if exists "PersonUInt32"; [] gorptest: 00:53:18.569705 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether gorptest: 00:53:18.570397 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 00:53:18.571486 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 00:53:18.571875 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 00:53:18.572105 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 00:53:18.572297 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 00:53:18.572645 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser gorptest: 00:53:18.573523 drop table if exists PersistentUser [] gorptest: 00:53:18.574066 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:53:18.574832 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:53:18.575198 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 00:53:18.575459 select * from PersistentUser [] gorptest: 00:53:18.575686 select * from PersistentUser [] gorptest: 00:53:18.575889 select * from PersistentUser [] gorptest: 00:53:18.576102 select Id from PersistentUser [] gorptest: 00:53:18.576274 select mykey from PersistentUser [] gorptest: 00:53:18.576440 select PassedTraining from PersistentUser [] gorptest: 00:53:18.576596 select Id from PersistentUser [] gorptest: 00:53:18.576745 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap gorptest: 00:53:18.577486 drop table if exists PersistentUser [] gorptest: 00:53:18.578036 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:53:18.578682 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:53:18.579042 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 00:53:18.579451 select * from PersistentUser where mykey = ? [1:43] gorptest: 00:53:18.579750 select * from PersistentUser where mykey = ? [1:43] gorptest: 00:53:18.580008 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 00:53:18.580284 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 00:53:18.580535 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct gorptest: 00:53:18.581495 drop table if exists PersistentUser [] gorptest: 00:53:18.582095 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:53:18.582725 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:53:18.583077 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 00:53:18.583444 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 00:53:18.583766 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice 2021/09/07 00:53:18 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: 00:53:18.584619 drop table if exists "invoice_test"; [] gorptest: 00:53:18.585174 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.585301 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.585425 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.585529 drop table if exists "person_test"; [] gorptest: 00:53:18.585628 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.585734 drop table if exists "id_created_test"; [] gorptest: 00:53:18.585841 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.585955 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.586074 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.586182 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.586278 drop table if exists "time_test"; [] gorptest: 00:53:18.586394 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.586997 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: 00:53:18.587502 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.587994 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.588557 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.589199 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.589710 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.590230 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.590750 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.591263 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.591771 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.592269 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.592772 select * from invoice_test where id=99999 [] gorptest: 00:53:18.593043 select * from invoice_test where id=99999 [] gorptest: 00:53:18.593264 drop table if exists "invoice_test"; [] gorptest: 00:53:18.593804 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.594240 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.594723 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.595342 drop table if exists "person_test"; [] gorptest: 00:53:18.595794 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.596235 drop table if exists "id_created_test"; [] gorptest: 00:53:18.596656 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.597104 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.597530 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.597964 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.598402 drop table if exists "time_test"; [] gorptest: 00:53:18.598827 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol gorptest: 00:53:18.599277 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 00:53:18.600423 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: 00:53:18.600685 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2021/09/07 00:53:18 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: 00:53:18.601585 drop table if exists "invoice_test"; [] gorptest: 00:53:18.602115 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.602224 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.602380 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.602473 drop table if exists "person_test"; [] gorptest: 00:53:18.602554 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.602636 drop table if exists "id_created_test"; [] gorptest: 00:53:18.602731 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.602815 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.602907 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.602986 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.603070 drop table if exists "time_test"; [] gorptest: 00:53:18.603218 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.603872 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: 00:53:18.604392 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.604876 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.605584 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.606102 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.606598 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.607130 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.607661 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.608171 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.608681 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.609299 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.609869 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998609819550 2:1630975998609819550 3:"Bob" 4:"Smith" 5:1] gorptest: 00:53:18.610279 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.610585 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1630975998609819550 2:1630975998609819550 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 00:53:18.610985 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1630975998609819550 2:1630975998609819550 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 00:53:18.611206 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.611443 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 00:53:18.611609 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.611832 drop table if exists "invoice_test"; [] gorptest: 00:53:18.612325 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.612745 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.613204 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.613758 drop table if exists "person_test"; [] gorptest: 00:53:18.614238 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.614668 drop table if exists "id_created_test"; [] gorptest: 00:53:18.615086 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.615510 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.615946 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.616375 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.616809 drop table if exists "time_test"; [] gorptest: 00:53:18.617260 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.02s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 00:53:18.617852 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 00:53:18.618870 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 00:53:18.619206 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 00:53:18.619568 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: 00:53:18.619971 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 00:53:18.620245 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps gorptest: 00:53:18.621092 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 00:53:18.622162 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 00:53:18.622641 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 00:53:18.622949 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 00:53:18.623199 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 00:53:18.623418 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect 2021/09/07 00:53:18 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: 00:53:18.624453 drop table if exists "invoice_test"; [] gorptest: 00:53:18.625230 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.625360 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.625514 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.625658 drop table if exists "person_test"; [] gorptest: 00:53:18.625798 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.625942 drop table if exists "id_created_test"; [] gorptest: 00:53:18.626085 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.626226 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.626364 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.626511 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.626653 drop table if exists "time_test"; [] gorptest: 00:53:18.626815 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.627452 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: 00:53:18.627976 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.628487 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.629179 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.629706 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.630203 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.630717 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.631250 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.631766 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.632303 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.632809 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.633414 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998633354408 2:1630975998633354408 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.633837 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 00:53:18.634199 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 00:53:18.634538 drop table if exists "invoice_test"; [] gorptest: 00:53:18.635061 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.635499 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.635927 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.636525 drop table if exists "person_test"; [] gorptest: 00:53:18.637051 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.637496 drop table if exists "id_created_test"; [] gorptest: 00:53:18.637941 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.638396 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.638864 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.639307 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.639710 drop table if exists "time_test"; [] gorptest: 00:53:18.640100 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.02s) === RUN TestHooks 2021/09/07 00:53:18 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: 00:53:18.640567 drop table if exists "invoice_test"; [] gorptest: 00:53:18.641312 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.641469 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.641627 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.641741 drop table if exists "person_test"; [] gorptest: 00:53:18.641842 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.641945 drop table if exists "id_created_test"; [] gorptest: 00:53:18.642074 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.642222 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.642354 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.642459 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.642550 drop table if exists "time_test"; [] gorptest: 00:53:18.642685 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.643334 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: 00:53:18.643930 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.644498 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.645153 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.645669 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.646180 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.646716 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.647246 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.647928 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.648593 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.649131 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.649721 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998649664421 2:1630975998649664421 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.650191 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.650512 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1630975998649664421 2:1630975998649664421 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 00:53:18.650916 select * from person_test where id = ? [1:1] gorptest: 00:53:18.651262 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 00:53:18.651607 drop table if exists "invoice_test"; [] gorptest: 00:53:18.652075 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.652542 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.653230 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.653836 drop table if exists "person_test"; [] gorptest: 00:53:18.654338 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.654852 drop table if exists "id_created_test"; [] gorptest: 00:53:18.655424 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.655942 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.656401 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.656880 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.657654 drop table if exists "time_test"; [] gorptest: 00:53:18.658126 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.02s) === RUN TestTransaction 2021/09/07 00:53:18 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: 00:53:18.658798 drop table if exists "invoice_test"; [] gorptest: 00:53:18.659533 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.659683 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.659805 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.659926 drop table if exists "person_test"; [] gorptest: 00:53:18.660043 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.660190 drop table if exists "id_created_test"; [] gorptest: 00:53:18.660318 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.660453 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.660573 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.660730 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.660877 drop table if exists "time_test"; [] gorptest: 00:53:18.661200 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.661948 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: 00:53:18.662521 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.663058 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.663664 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.664181 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.664694 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.665433 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.666048 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.666605 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.667163 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.667726 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.668294 begin; [] gorptest: 00:53:18.668443 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 00:53:18.668791 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 00:53:18.668938 commit; [] gorptest: 00:53:18.669196 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.669515 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 00:53:18.669757 drop table if exists "invoice_test"; [] gorptest: 00:53:18.670348 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.670818 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.671283 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.671850 drop table if exists "person_test"; [] gorptest: 00:53:18.672306 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.672758 drop table if exists "id_created_test"; [] gorptest: 00:53:18.673238 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.673694 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.674180 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.674723 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.675183 drop table if exists "time_test"; [] gorptest: 00:53:18.675624 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.02s) === RUN TestSavepoint 2021/09/07 00:53:18 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: 00:53:18.676252 drop table if exists "invoice_test"; [] gorptest: 00:53:18.676872 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.677069 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.677183 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.677294 drop table if exists "person_test"; [] gorptest: 00:53:18.677411 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.677509 drop table if exists "id_created_test"; [] gorptest: 00:53:18.677628 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.677717 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.677816 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.677917 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.678016 drop table if exists "time_test"; [] gorptest: 00:53:18.678138 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.678717 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: 00:53:18.679250 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.679803 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.680368 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.680875 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.681469 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.681973 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.682488 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.682992 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.683484 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.683991 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.684501 begin; [] gorptest: 00:53:18.684679 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 00:53:18.685072 select memo from invoice_test [] gorptest: 00:53:18.685233 savepoint "foo" [1:] gorptest: 00:53:18.685272 select memo from invoice_test [] gorptest: 00:53:18.685415 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 00:53:18.685583 select memo from invoice_test [] gorptest: 00:53:18.685702 rollback to savepoint "foo" [1:] gorptest: 00:53:18.685752 select memo from invoice_test [] gorptest: 00:53:18.685823 rollback; [] gorptest: 00:53:18.686009 drop table if exists "invoice_test"; [] gorptest: 00:53:18.686527 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.686982 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.687403 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.687861 drop table if exists "person_test"; [] gorptest: 00:53:18.688277 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.688711 drop table if exists "id_created_test"; [] gorptest: 00:53:18.689142 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.689544 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.689935 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.690331 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.690723 drop table if exists "time_test"; [] gorptest: 00:53:18.691132 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.02s) === RUN TestMultiple 2021/09/07 00:53:18 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: 00:53:18.691701 drop table if exists "invoice_test"; [] gorptest: 00:53:18.692293 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.692438 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.692571 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.692689 drop table if exists "person_test"; [] gorptest: 00:53:18.692815 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.692955 drop table if exists "id_created_test"; [] gorptest: 00:53:18.693094 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.693208 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.693322 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.693446 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.693562 drop table if exists "time_test"; [] gorptest: 00:53:18.693711 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.694325 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: 00:53:18.694856 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.695357 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.695973 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.696496 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.697030 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.697540 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.698053 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.698604 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.699121 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.699643 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.700227 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 00:53:18.700649 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 00:53:18.701064 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 00:53:18.701451 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 00:53:18.701791 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.702090 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 00:53:18.702372 drop table if exists "invoice_test"; [] gorptest: 00:53:18.702839 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.703272 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.703677 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.704215 drop table if exists "person_test"; [] gorptest: 00:53:18.704627 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.705145 drop table if exists "id_created_test"; [] gorptest: 00:53:18.705569 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.705989 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.706407 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.706830 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.707302 drop table if exists "time_test"; [] gorptest: 00:53:18.707722 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.02s) === RUN TestCrud 2021/09/07 00:53:18 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: 00:53:18.708267 drop table if exists "invoice_test"; [] gorptest: 00:53:18.708823 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.708978 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.709102 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.709227 drop table if exists "person_test"; [] gorptest: 00:53:18.709356 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.709470 drop table if exists "id_created_test"; [] gorptest: 00:53:18.709590 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.709714 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.709842 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.709959 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.710082 drop table if exists "time_test"; [] gorptest: 00:53:18.710223 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.710815 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: 00:53:18.711344 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.711876 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.712448 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.712967 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.713462 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.713957 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.714456 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.714956 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.715454 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.715956 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.716448 delete from invoice_test [] gorptest: 00:53:18.716769 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 00:53:18.717183 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.717488 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] gorptest: 00:53:18.717828 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.718051 select * from invoice_test [] gorptest: 00:53:18.718332 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.718651 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:53:18.718844 delete from invoice_tag_test [] gorptest: 00:53:18.719161 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: 00:53:18.719541 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:53:18.719825 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] gorptest: 00:53:18.720168 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:53:18.720414 select * from invoice_tag_test [] gorptest: 00:53:18.720703 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:53:18.721040 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:53:18.721230 delete from alias_trans_field_test [] gorptest: 00:53:18.721509 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 00:53:18.721857 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:53:18.722083 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 00:53:18.722451 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:53:18.722646 select * from alias_trans_field_test [] gorptest: 00:53:18.722869 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:53:18.723177 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:53:18.723346 drop table if exists "invoice_test"; [] gorptest: 00:53:18.723816 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.724255 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.724682 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.725247 drop table if exists "person_test"; [] gorptest: 00:53:18.725664 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.726085 drop table if exists "id_created_test"; [] gorptest: 00:53:18.726504 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.726919 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.727339 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.727756 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.728193 drop table if exists "time_test"; [] gorptest: 00:53:18.728626 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.02s) === RUN TestWithIgnoredColumn 2021/09/07 00:53:18 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: 00:53:18.729346 drop table if exists "invoice_test"; [] gorptest: 00:53:18.729909 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.730056 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.730198 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.730326 drop table if exists "person_test"; [] gorptest: 00:53:18.730449 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.730582 drop table if exists "id_created_test"; [] gorptest: 00:53:18.730718 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.730842 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.730974 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.731122 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.731258 drop table if exists "time_test"; [] gorptest: 00:53:18.731413 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.732024 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: 00:53:18.732545 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.733097 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.733689 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.734202 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.734711 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.735223 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.735741 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.736259 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.736801 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.737344 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.737883 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 00:53:18.738269 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:53:18.738525 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:53:18.738851 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:53:18.739037 drop table if exists "invoice_test"; [] gorptest: 00:53:18.739489 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.739942 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.740385 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.740948 drop table if exists "person_test"; [] gorptest: 00:53:18.741400 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.741854 drop table if exists "id_created_test"; [] gorptest: 00:53:18.742288 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.742781 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.743217 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.743654 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.744082 drop table if exists "time_test"; [] gorptest: 00:53:18.744510 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.02s) === RUN TestTypeConversionExample 2021/09/07 00:53:18 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: 00:53:18.745130 drop table if exists "invoice_test"; [] gorptest: 00:53:18.745713 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.745841 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.745949 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.746072 drop table if exists "person_test"; [] gorptest: 00:53:18.746196 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.746324 drop table if exists "id_created_test"; [] gorptest: 00:53:18.746447 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.746570 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.746692 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.746822 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.746941 drop table if exists "time_test"; [] gorptest: 00:53:18.747109 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.747701 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: 00:53:18.748224 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.748734 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.749563 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.750094 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.750585 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.751083 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.751595 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.752112 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.752630 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.753171 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.753876 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: 00:53:18.754291 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:53:18.754677 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: 00:53:18.755076 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:53:18.755329 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:53:18.755649 drop table if exists "invoice_test"; [] gorptest: 00:53:18.756109 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.756551 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.757024 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.757564 drop table if exists "person_test"; [] gorptest: 00:53:18.757996 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.758418 drop table if exists "id_created_test"; [] gorptest: 00:53:18.758838 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.759276 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.759703 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.760126 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.760547 drop table if exists "time_test"; [] gorptest: 00:53:18.760978 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.02s) === RUN TestWithEmbeddedStruct 2021/09/07 00:53:18 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: 00:53:18.761528 drop table if exists "invoice_test"; [] gorptest: 00:53:18.762089 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.762219 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.762323 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.762434 drop table if exists "person_test"; [] gorptest: 00:53:18.762546 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.762665 drop table if exists "id_created_test"; [] gorptest: 00:53:18.762773 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.762887 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.762994 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.763124 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.763246 drop table if exists "time_test"; [] gorptest: 00:53:18.763370 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.763975 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: 00:53:18.764490 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.765061 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.765671 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.766180 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.766673 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.767178 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.767688 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.768199 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.768713 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.769243 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.769819 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 00:53:18.770218 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 00:53:18.770492 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 00:53:18.770833 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 00:53:18.771026 select * from embedded_struct_test [] gorptest: 00:53:18.771266 drop table if exists "invoice_test"; [] gorptest: 00:53:18.771698 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.772116 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.772522 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.773063 drop table if exists "person_test"; [] gorptest: 00:53:18.773520 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.774029 drop table if exists "id_created_test"; [] gorptest: 00:53:18.774470 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.774895 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.775344 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.775807 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.776249 drop table if exists "time_test"; [] gorptest: 00:53:18.776661 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.02s) === RUN TestWithEmbeddedStructBeforeAutoincr 2021/09/07 00:53:18 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: 00:53:18.777201 drop table if exists "invoice_test"; [] gorptest: 00:53:18.777757 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.777886 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.778002 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.778114 drop table if exists "person_test"; [] gorptest: 00:53:18.778224 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.778333 drop table if exists "id_created_test"; [] gorptest: 00:53:18.778449 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.778568 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.778680 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.778794 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.778904 drop table if exists "time_test"; [] gorptest: 00:53:18.779036 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.779643 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: 00:53:18.780170 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.780681 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.781285 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.781862 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.782423 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.782951 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.783482 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.784031 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.784564 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.785296 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.785870 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 00:53:18.786231 drop table if exists "invoice_test"; [] gorptest: 00:53:18.786678 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.787197 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.787769 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.788336 drop table if exists "person_test"; [] gorptest: 00:53:18.788795 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.789276 drop table if exists "id_created_test"; [] gorptest: 00:53:18.789735 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.790201 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.790681 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.791174 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.791627 drop table if exists "time_test"; [] gorptest: 00:53:18.792089 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.02s) === RUN TestWithEmbeddedAutoincr 2021/09/07 00:53:18 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: 00:53:18.792684 drop table if exists "invoice_test"; [] gorptest: 00:53:18.793389 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.793561 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.793728 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.793894 drop table if exists "person_test"; [] gorptest: 00:53:18.794062 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.794208 drop table if exists "id_created_test"; [] gorptest: 00:53:18.794348 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.794479 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.794602 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.794752 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.794901 drop table if exists "time_test"; [] gorptest: 00:53:18.795084 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.796007 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: 00:53:18.796936 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.797613 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.798233 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.798769 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.799285 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.799791 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.800299 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.800791 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.801336 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.801848 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.802427 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 00:53:18.802905 drop table if exists "invoice_test"; [] gorptest: 00:53:18.803405 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.803924 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.804403 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.804984 drop table if exists "person_test"; [] gorptest: 00:53:18.805498 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.805988 drop table if exists "id_created_test"; [] gorptest: 00:53:18.806446 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.806860 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.807321 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.807804 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.808282 drop table if exists "time_test"; [] gorptest: 00:53:18.808683 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.02s) === RUN TestSelectVal gorptest: 00:53:18.809149 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 00:53:18.810228 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: 00:53:18.810594 select Int64 from TableWithNull where Str='abc' [] gorptest: 00:53:18.810807 select count(*) from TableWithNull [] gorptest: 00:53:18.810949 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 00:53:18.811089 select Int64 from TableWithNull where Str='notfound' [] gorptest: 00:53:18.811202 select Int64 from TableWithNull where Str='abc' [] gorptest: 00:53:18.811307 select Float64 from TableWithNull where Str='abc' [] gorptest: 00:53:18.811415 select min(Float64) from TableWithNull [] gorptest: 00:53:18.811535 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 00:53:18.811658 select Float64 from TableWithNull where Str='notfound' [] gorptest: 00:53:18.811763 select Float64 from TableWithNull where Str='abc' [] gorptest: 00:53:18.811891 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:53:18.812018 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 00:53:18.812124 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:53:18.812236 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 00:53:18.812426 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 00:53:18.812582 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:53:18.812730 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows 2021/09/07 00:53:18 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: 00:53:18.813860 drop table if exists "invoice_test"; [] gorptest: 00:53:18.814378 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.814474 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.814546 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.814616 drop table if exists "person_test"; [] gorptest: 00:53:18.814686 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.814781 drop table if exists "id_created_test"; [] gorptest: 00:53:18.814854 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.814926 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.814997 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.815070 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.815138 drop table if exists "time_test"; [] gorptest: 00:53:18.815242 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.815762 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: 00:53:18.816214 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.816654 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.817206 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.817666 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.818132 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.818596 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.819071 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.819534 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.820010 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.820474 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.821001 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998820950965 2:1630975998820950965 3:"Bob" 4:"Smith" 5:1] gorptest: 00:53:18.821393 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998821366330 2:1630975998821366330 3:"Jane" 4:"Smith" 5:1] gorptest: 00:53:18.821727 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998821702614 2:1630975998821702614 3:"Mike" 4:"Smith" 5:1] gorptest: 00:53:18.822026 drop table if exists "invoice_test"; [] gorptest: 00:53:18.822407 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.822779 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.823169 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.823657 drop table if exists "person_test"; [] gorptest: 00:53:18.824094 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.824482 drop table if exists "id_created_test"; [] gorptest: 00:53:18.824870 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.825280 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.825666 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.826060 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.826432 drop table if exists "time_test"; [] gorptest: 00:53:18.826787 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk gorptest: 00:53:18.827136 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 00:53:18.828085 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 00:53:18.828431 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2021/09/07 00:53:18 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: 00:53:18.829510 drop table if exists "invoice_test"; [] gorptest: 00:53:18.829979 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.830081 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.830165 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.830286 drop table if exists "person_test"; [] gorptest: 00:53:18.830407 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.830515 drop table if exists "id_created_test"; [] gorptest: 00:53:18.830615 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.830709 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.830795 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.830880 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.830964 drop table if exists "time_test"; [] gorptest: 00:53:18.831058 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.831593 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: 00:53:18.832081 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.832551 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.833318 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.833801 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.834242 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.834698 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.835168 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.835644 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.836105 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.836569 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.837083 insert into "time_test" ("Id","Time") values (null,?); [1:2021-09-07 00:22:18.837037675 +0000 UTC] gorptest: 00:53:18.837442 insert into "time_test" ("Id","Time") values (null,?); [1:2021-09-07 00:23:19.837037675 +0000 UTC] gorptest: 00:53:18.837773 SELECT id FROM time_test WHERE Time < ? [1:2021-09-07 00:23:18.837037675 +0000 UTC] gorptest: 00:53:18.838022 drop table if exists "invoice_test"; [] gorptest: 00:53:18.838429 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.838830 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.839227 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.839729 drop table if exists "person_test"; [] gorptest: 00:53:18.840122 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.840510 drop table if exists "id_created_test"; [] gorptest: 00:53:18.840893 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.841299 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.841687 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.842074 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.842450 drop table if exists "time_test"; [] gorptest: 00:53:18.842848 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView 2021/09/07 00:53:18 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: 00:53:18.843337 drop table if exists "invoice_test"; [] gorptest: 00:53:18.843823 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.843948 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.844057 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.844155 drop table if exists "person_test"; [] gorptest: 00:53:18.844251 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.844336 drop table if exists "id_created_test"; [] gorptest: 00:53:18.844430 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.844531 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.844631 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.844732 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.844830 drop table if exists "time_test"; [] gorptest: 00:53:18.845000 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.845532 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: 00:53:18.846018 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.846481 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.847027 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.847509 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.847977 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.848441 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.848928 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.849415 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.849893 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.850382 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.850893 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998850847539 2:1630975998850847539 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.851271 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 00:53:18.851611 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 00:53:18.851924 drop table if exists "invoice_test"; [] gorptest: 00:53:18.852363 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.852767 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.853180 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.853667 drop table if exists "person_test"; [] gorptest: 00:53:18.854077 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.854470 drop table if exists "id_created_test"; [] gorptest: 00:53:18.854869 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.855270 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.855693 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.856096 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.856502 drop table if exists "time_test"; [] gorptest: 00:53:18.856897 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames 2021/09/07 00:53:18 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: 00:53:18.857388 drop table if exists "invoice_test"; [] gorptest: 00:53:18.857875 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.858006 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.858123 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.858289 drop table if exists "person_test"; [] gorptest: 00:53:18.858432 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.858556 drop table if exists "id_created_test"; [] gorptest: 00:53:18.858676 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.858799 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.858916 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.859034 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.859151 drop table if exists "time_test"; [] gorptest: 00:53:18.859286 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.859808 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: 00:53:18.860303 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.860773 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.861331 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.861804 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.862256 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.862728 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.863205 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.863672 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.864149 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.864632 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols 2021/09/07 00:53:18 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: 00:53:18.871259 drop table if exists "invoice_test"; [] gorptest: 00:53:18.871756 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.871887 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.872004 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.872125 drop table if exists "person_test"; [] gorptest: 00:53:18.872273 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.872395 drop table if exists "id_created_test"; [] gorptest: 00:53:18.872508 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.872633 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.872749 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.872889 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.873036 drop table if exists "time_test"; [] gorptest: 00:53:18.873176 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.873698 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: 00:53:18.874179 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.874646 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.875175 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.875658 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.876129 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.876615 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.877121 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.877593 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.878065 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.878578 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.879175 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998879119513 2:1630975998879119513 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.879558 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998879532438 2:1630975998879532438 3:"jane" 4:"doe" 5:1] gorptest: 00:53:18.879916 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.880157 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 00:53:18.880382 select * from person_test where Id=? [1:1] gorptest: 00:53:18.880622 select * from person_test order by fname asc [] gorptest: 00:53:18.880985 drop table if exists "invoice_test"; [] gorptest: 00:53:18.881439 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.881832 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.882232 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.882657 drop table if exists "person_test"; [] gorptest: 00:53:18.883071 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.883464 drop table if exists "id_created_test"; [] gorptest: 00:53:18.883847 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.884247 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.884650 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.885107 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.885526 drop table if exists "time_test"; [] gorptest: 00:53:18.885938 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.02s) === RUN TestSelectSingleVal 2021/09/07 00:53:18 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: 00:53:18.886442 drop table if exists "invoice_test"; [] gorptest: 00:53:18.886957 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.887097 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.887209 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.887315 drop table if exists "person_test"; [] gorptest: 00:53:18.887416 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.887525 drop table if exists "id_created_test"; [] gorptest: 00:53:18.887632 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.887736 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.887861 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.887981 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.888094 drop table if exists "time_test"; [] gorptest: 00:53:18.888227 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.888759 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: 00:53:18.889307 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.889781 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.890320 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.890790 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.891246 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.891728 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.892216 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.892692 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.893317 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.893794 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.894309 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998894263132 2:1630975998894263132 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.894694 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:53:18.894966 select * from person_test where Id=? [1:1] gorptest: 00:53:18.895226 select FName from person_test where Id=? [1:1] gorptest: 00:53:18.895381 select * from person_test where Id=? [1:1] gorptest: 00:53:18.895607 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 00:53:18.895812 select * from person_test where Id=? [1:-2222] gorptest: 00:53:18.896012 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1630975998895986392 2:1630975998895986392 3:"bob" 4:"smith" 5:1] gorptest: 00:53:18.896343 select * from person_test where Fname='bob' [] gorptest: 00:53:18.896609 select * from person_test where Id=-123 [] gorptest: 00:53:18.896756 select * from person_test where Id=-123 [] gorptest: 00:53:18.896880 select * from person_test where Id=-123 [] gorptest: 00:53:18.897222 select * from person_test where Id=-123 [] gorptest: 00:53:18.897392 drop table if exists "invoice_test"; [] gorptest: 00:53:18.897845 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.898265 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.898664 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.899155 drop table if exists "person_test"; [] gorptest: 00:53:18.899571 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.899967 drop table if exists "id_created_test"; [] gorptest: 00:53:18.900358 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.900751 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.901220 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.901608 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.901997 drop table if exists "time_test"; [] gorptest: 00:53:18.902384 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.02s) === RUN TestSelectAlias 2021/09/07 00:53:18 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: 00:53:18.902834 drop table if exists "invoice_test"; [] gorptest: 00:53:18.903332 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.903451 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.903554 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.903651 drop table if exists "person_test"; [] gorptest: 00:53:18.903752 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.903852 drop table if exists "id_created_test"; [] gorptest: 00:53:18.903949 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.904048 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.904146 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.904249 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.904348 drop table if exists "time_test"; [] gorptest: 00:53:18.904464 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.905064 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: 00:53:18.905556 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.906035 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.906593 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.907076 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.907553 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.908027 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.908493 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.909012 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.909497 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.909976 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.910478 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 00:53:18.910802 select * from id_created_test where Id=1 [] gorptest: 00:53:18.911031 SELECT *, 1 AS external FROM id_created_test [] gorptest: 00:53:18.911294 drop table if exists "invoice_test"; [] gorptest: 00:53:18.912251 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.912651 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.913141 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.913656 drop table if exists "person_test"; [] gorptest: 00:53:18.914058 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.914455 drop table if exists "id_created_test"; [] gorptest: 00:53:18.914861 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.915254 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.915658 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.916060 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.916450 drop table if exists "time_test"; [] gorptest: 00:53:18.916839 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2021/09/07 00:53:18 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: 00:53:18.917553 drop table if exists "invoice_test"; [] gorptest: 00:53:18.918028 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.918140 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.918238 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.918333 drop table if exists "person_test"; [] gorptest: 00:53:18.918425 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.918516 drop table if exists "id_created_test"; [] gorptest: 00:53:18.918622 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.918731 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.918827 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.918929 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.919026 drop table if exists "time_test"; [] gorptest: 00:53:18.919145 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.919662 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: 00:53:18.920146 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.920619 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.921217 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.921692 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.922157 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.922639 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.923108 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.923580 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.924050 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.924512 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.925046 drop table if exists "invoice_test"; [] gorptest: 00:53:18.925502 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.925904 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.926315 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.926838 drop table if exists "person_test"; [] gorptest: 00:53:18.927241 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.927638 drop table if exists "id_created_test"; [] gorptest: 00:53:18.928046 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.928447 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.928840 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.929315 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.929711 drop table if exists "time_test"; [] gorptest: 00:53:18.930100 drop table if exists "id_created_test"; [] gorptest: 00:53:18.930228 drop table if exists "single_column_table"; [] gorptest: 00:53:18.930347 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: 00:53:18.930847 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: 00:53:18.931330 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.931800 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: 00:53:18.932342 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: 00:53:18.932823 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.933534 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.934011 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.934514 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.934993 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.935481 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: 00:53:18.935951 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.936408 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:53:18.936533 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 00:53:18.937113 delete from "invoice_test"; [] gorptest: 00:53:18.937366 delete from "invoice_tag_test"; [] gorptest: 00:53:18.937609 delete from "alias_trans_field_test"; [] gorptest: 00:53:18.937853 delete from "invoice_override_test"; [] gorptest: 00:53:18.938111 delete from "person_test"; [] gorptest: 00:53:18.938351 delete from "ignored_column_test"; [] gorptest: 00:53:18.938589 delete from "id_created_test"; [] gorptest: 00:53:18.938828 delete from "type_conv_test"; [] gorptest: 00:53:18.939065 delete from "embedded_struct_test"; [] gorptest: 00:53:18.939314 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.939554 delete from "embedded_autoincr_test"; [] gorptest: 00:53:18.939796 delete from "time_test"; [] gorptest: 00:53:18.940036 delete from "id_created_test"; [] gorptest: 00:53:18.940278 delete from "single_column_table"; [] gorptest: 00:53:18.940579 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 00:53:18.940787 drop table if exists "invoice_test"; [] gorptest: 00:53:18.941269 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.941678 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.942095 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.942588 drop table if exists "person_test"; [] gorptest: 00:53:18.942992 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.943392 drop table if exists "id_created_test"; [] gorptest: 00:53:18.943796 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.944213 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.944616 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.945097 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.945510 drop table if exists "time_test"; [] gorptest: 00:53:18.945899 drop table if exists "id_created_test"; [] gorptest: 00:53:18.946036 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.03s) === RUN TestPrepare 2021/09/07 00:53:18 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: 00:53:18.946892 drop table if exists "invoice_test"; [] gorptest: 00:53:18.947414 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.947524 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.947618 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.947709 drop table if exists "person_test"; [] gorptest: 00:53:18.947803 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.947898 drop table if exists "id_created_test"; [] gorptest: 00:53:18.947989 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.948081 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.948174 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.948280 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.948382 drop table if exists "time_test"; [] gorptest: 00:53:18.948495 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.949202 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: 00:53:18.949706 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:53:18.950192 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:53:18.950743 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:53:18.951221 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.951687 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:53:18.952153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:53:18.952621 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:53:18.953157 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:53:18.953631 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:53:18.954121 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:53:18.954651 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 00:53:18.955021 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 00:53:18.955353 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 00:53:18.955682 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 00:53:18.955985 begin; [] gorptest: 00:53:18.956042 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 00:53:18.956260 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:53:18.957029 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:53:18.957227 commit; [] gorptest: 00:53:18.957404 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:53:18.957695 drop table if exists "invoice_test"; [] gorptest: 00:53:18.958178 drop table if exists "invoice_tag_test"; [] gorptest: 00:53:18.959062 drop table if exists "alias_trans_field_test"; [] gorptest: 00:53:18.959911 drop table if exists "invoice_override_test"; [] gorptest: 00:53:18.960874 drop table if exists "person_test"; [] gorptest: 00:53:18.961766 drop table if exists "ignored_column_test"; [] gorptest: 00:53:18.962546 drop table if exists "id_created_test"; [] gorptest: 00:53:18.963323 drop table if exists "type_conv_test"; [] gorptest: 00:53:18.964099 drop table if exists "embedded_struct_test"; [] gorptest: 00:53:18.964857 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:53:18.965790 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:53:18.966504 drop table if exists "time_test"; [] gorptest: 00:53:18.967205 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.02s) PASS ok gopkg.in/gorp.v1 0.450s 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 -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 dpkg-genchanges --build=binary >../golang-gopkg-gorp.v1_1.7.2-2_arm64.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/3099 and its subdirectories I: Current time: Mon Sep 6 12:53:25 -12 2021 I: pbuilder-time-stamp: 1630976005 Tue Sep 7 00:53:27 UTC 2021 I: 1st build successful. Starting 2nd build on remote node codethink9-arm64.debian.net. Tue Sep 7 00:53:27 UTC 2021 I: Preparing to do remote build '2' on codethink9-arm64.debian.net. Tue Sep 7 00:54:41 UTC 2021 I: Deleting $TMPDIR on codethink9-arm64.debian.net. Tue Sep 7 00:54:41 UTC 2021 I: golang-gopkg-gorp.v1_1.7.2-2_arm64.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 f401dd07939d63cfe20f746d80087967ca38e6fe 5247 golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb e55d5feccdd6222e5ba1a5f440dfa55b2664b43cd937ffd2c8c9a4a9db68c86e 5247 golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb e1f3f17c23083f96242f001cd8e0a7ba 5247 devel optional golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo Tue Sep 7 00:55:04 UTC 2021 I: diffoscope 177 will be used to compare the two builds: # Profiling output for: /usr/bin/diffoscope --html /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/b1/golang-gopkg-gorp.v1_1.7.2-2_arm64.changes /srv/reproducible-results/rbuild-debian/tmp.PkcIYNWfCc/b2/golang-gopkg-gorp.v1_1.7.2-2_arm64.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.374s) 0.374s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.024s) 0.023s 10 calls diffoscope.comparators.binary.FilesystemFile 0.000s 8 calls abc.DotChangesFile Tue Sep 7 00:55:59 UTC 2021 I: diffoscope 177 found no differences in the changes files, and a .buildinfo file also exists. Tue Sep 7 00:55:59 UTC 2021 I: golang-gopkg-gorp.v1 from bullseye built successfully and reproducibly on arm64. Tue Sep 7 00:56:00 UTC 2021 I: Submitting .buildinfo files to external archives: Tue Sep 7 00:56:01 UTC 2021 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo.asc Tue Sep 7 00:56:01 UTC 2021 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo.asc Tue Sep 7 00:56:03 UTC 2021 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Tue Sep 7 00:56:03 UTC 2021 I: Done submitting .buildinfo files. Tue Sep 7 00:56:03 UTC 2021 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo.asc'