Tue Jul 27 11:41:38 UTC 2021 I: starting to build golang-gopkg-gorp.v1/bullseye/armhf on jenkins on '2021-07-27 11:41' Tue Jul 27 11:41:38 UTC 2021 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/armhf_25/3645/console.log Tue Jul 27 11:41:38 UTC 2021 I: Downloading source for bullseye/golang-gopkg-gorp.v1=1.7.2-2 --2021-07-27 11:41:38-- 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% 117M=0s 2021-07-27 11:41:38 (117 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Tue Jul 27 11:41:38 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 Jul 27 11:41:38 UTC 2021 I: Checking whether the package is not for us Tue Jul 27 11:41:38 UTC 2021 I: Starting 1st build on remote node virt32c-armhf-rb.debian.net. Tue Jul 27 11:41:38 UTC 2021 I: Preparing to do remote build '1' on virt32c-armhf-rb.debian.net. Tue Jul 27 11:43:54 UTC 2021 I: Deleting $TMPDIR on virt32c-armhf-rb.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Mon Jul 26 23:41:44 -12 2021 I: pbuilder-time-stamp: 1627386104 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.vsPvgxtE/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/17951/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='armhf' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=3' DISTRIBUTION='' HOME='/root' HOST_ARCH='armhf' IFS=' ' INVOCATION_ID='d516c31855184389ae2c644b313d6e71' 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='17951' 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.8ZwQZIGrkW/pbuilderrc_SNaG --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='113' SUDO_UID='107' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://10.0.0.15:8000/' I: uname -a Linux virt32c 5.10.0-8-armmp-lpae #1 SMP Debian 5.10.46-2 (2021-07-20) armv7l GNU/Linux I: ls -l /bin total 3580 -rwxr-xr-x 1 root root 816764 Jun 21 14:26 bash -rwxr-xr-x 3 root root 26052 Jul 20 2020 bunzip2 -rwxr-xr-x 3 root root 26052 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 26052 Jul 20 2020 bzip2 -rwxr-xr-x 1 root root 9636 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 26668 Sep 22 2020 cat -rwxr-xr-x 1 root root 43104 Sep 22 2020 chgrp -rwxr-xr-x 1 root root 38984 Sep 22 2020 chmod -rwxr-xr-x 1 root root 43112 Sep 22 2020 chown -rwxr-xr-x 1 root root 92616 Sep 22 2020 cp -rwxr-xr-x 1 root root 75524 Dec 10 2020 dash -rwxr-xr-x 1 root root 75880 Sep 22 2020 date -rwxr-xr-x 1 root root 55436 Sep 22 2020 dd -rwxr-xr-x 1 root root 59912 Sep 22 2020 df -rwxr-xr-x 1 root root 96764 Sep 22 2020 dir -rwxr-xr-x 1 root root 55012 Feb 7 02:38 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 22508 Sep 22 2020 echo -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep -rwxr-xr-x 1 root root 22496 Sep 22 2020 false -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep -rwxr-xr-x 1 root root 47492 Feb 7 02:38 findmnt -rwsr-xr-x 1 root root 26076 Feb 26 04:12 fusermount -rwxr-xr-x 1 root root 124508 Nov 9 2020 grep -rwxr-xr-x 2 root root 2346 Mar 2 11:30 gunzip -rwxr-xr-x 1 root root 6376 Mar 2 11:30 gzexe -rwxr-xr-x 1 root root 64212 Mar 2 11:30 gzip -rwxr-xr-x 1 root root 13784 Nov 6 2019 hostname -rwxr-xr-x 1 root root 43180 Sep 22 2020 ln -rwxr-xr-x 1 root root 35068 Feb 7 2020 login -rwxr-xr-x 1 root root 96764 Sep 22 2020 ls -rwxr-xr-x 1 root root 99940 Feb 7 02:38 lsblk -rwxr-xr-x 1 root root 51408 Sep 22 2020 mkdir -rwxr-xr-x 1 root root 43184 Sep 22 2020 mknod -rwxr-xr-x 1 root root 30780 Sep 22 2020 mktemp -rwxr-xr-x 1 root root 34408 Feb 7 02:38 more -rwsr-xr-x 1 root root 34400 Feb 7 02:38 mount -rwxr-xr-x 1 root root 9824 Feb 7 02:38 mountpoint -rwxr-xr-x 1 root root 88524 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 26652 Sep 22 2020 pwd lrwxrwxrwx 1 root root 4 Jun 21 14:26 rbash -> bash -rwxr-xr-x 1 root root 30740 Sep 22 2020 readlink -rwxr-xr-x 1 root root 43104 Sep 22 2020 rm -rwxr-xr-x 1 root root 30732 Sep 22 2020 rmdir -rwxr-xr-x 1 root root 14144 Sep 27 2020 run-parts -rwxr-xr-x 1 root root 76012 Dec 22 2018 sed lrwxrwxrwx 1 root root 4 Jul 25 21:25 sh -> dash -rwxr-xr-x 1 root root 22532 Sep 22 2020 sleep -rwxr-xr-x 1 root root 55360 Sep 22 2020 stty -rwsr-xr-x 1 root root 46704 Feb 7 02:38 su -rwxr-xr-x 1 root root 22532 Sep 22 2020 sync -rwxr-xr-x 1 root root 340872 Feb 16 21:55 tar -rwxr-xr-x 1 root root 9808 Sep 27 2020 tempfile -rwxr-xr-x 1 root root 67696 Sep 22 2020 touch -rwxr-xr-x 1 root root 22496 Sep 22 2020 true -rwxr-xr-x 1 root root 9636 Feb 26 04:12 ulockmgr_server -rwsr-xr-x 1 root root 22108 Feb 7 02:38 umount -rwxr-xr-x 1 root root 22520 Sep 22 2020 uname -rwxr-xr-x 2 root root 2346 Mar 2 11:30 uncompress -rwxr-xr-x 1 root root 96764 Sep 22 2020 vdir -rwxr-xr-x 1 root root 38512 Feb 7 02:38 wdctl lrwxrwxrwx 1 root root 8 Nov 6 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 2 11:30 zcat -rwxr-xr-x 1 root root 1678 Mar 2 11:30 zcmp -rwxr-xr-x 1 root root 5880 Mar 2 11:30 zdiff -rwxr-xr-x 1 root root 29 Mar 2 11:30 zegrep -rwxr-xr-x 1 root root 29 Mar 2 11:30 zfgrep -rwxr-xr-x 1 root root 2081 Mar 2 11:30 zforce -rwxr-xr-x 1 root root 7585 Mar 2 11:30 zgrep -rwxr-xr-x 1 root root 2206 Mar 2 11:30 zless -rwxr-xr-x 1 root root 1842 Mar 2 11:30 zmore -rwxr-xr-x 1 root root 4553 Mar 2 11:30 znew I: user script /srv/workspace/pbuilder/17951/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: armhf 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 ... 19398 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.7 MB of archives. After unpacking 447 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main armhf bsdextrautils armhf 2.36.1-7 [138 kB] Get: 2 http://deb.debian.org/debian bullseye/main armhf libuchardet0 armhf 0.0.7-1 [65.0 kB] Get: 3 http://deb.debian.org/debian bullseye/main armhf groff-base armhf 1.22.4-6 [847 kB] Get: 4 http://deb.debian.org/debian bullseye/main armhf libpipeline1 armhf 1.5.3-1 [30.1 kB] Get: 5 http://deb.debian.org/debian bullseye/main armhf man-db armhf 2.9.4-2 [1319 kB] Get: 6 http://deb.debian.org/debian bullseye/main armhf sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main armhf libmagic-mgc armhf 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main armhf libmagic1 armhf 1:5.39-3 [117 kB] Get: 9 http://deb.debian.org/debian bullseye/main armhf file armhf 1:5.39-3 [68.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main armhf gettext-base armhf 0.21-4 [171 kB] Get: 11 http://deb.debian.org/debian bullseye/main armhf libsigsegv2 armhf 2.13-1 [34.0 kB] Get: 12 http://deb.debian.org/debian bullseye/main armhf m4 armhf 1.4.18-5 [192 kB] Get: 13 http://deb.debian.org/debian bullseye/main armhf autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main armhf autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main armhf automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main armhf autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main armhf libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main armhf libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main armhf dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main armhf libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main armhf libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main armhf libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main armhf dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main armhf libelf1 armhf 0.183-1 [161 kB] Get: 25 http://deb.debian.org/debian bullseye/main armhf dwz armhf 0.13+20210201-1 [179 kB] Get: 26 http://deb.debian.org/debian bullseye/main armhf libicu67 armhf 67.1-7 [8319 kB] Get: 27 http://deb.debian.org/debian bullseye/main armhf libxml2 armhf 2.9.10+dfsg-6.7 [602 kB] Get: 28 http://deb.debian.org/debian bullseye/main armhf gettext armhf 0.21-4 [1243 kB] Get: 29 http://deb.debian.org/debian bullseye/main armhf intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main armhf po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main armhf debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main armhf dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main armhf golang-1.15-src armhf 1.15.9-6 [13.8 MB] Get: 34 http://deb.debian.org/debian bullseye/main armhf golang-1.15-go armhf 1.15.9-6 [43.1 MB] Get: 35 http://deb.debian.org/debian bullseye/main armhf golang-src armhf 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main armhf golang-go armhf 2:1.15~1 [23.9 kB] Get: 37 http://deb.debian.org/debian bullseye/main armhf golang-any armhf 2:1.15~1 [4976 B] Get: 38 http://deb.debian.org/debian bullseye/main armhf golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main armhf golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main armhf libsqlite3-dev armhf 3.34.1-3 [890 kB] Get: 44 http://deb.debian.org/debian bullseye/main armhf golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main armhf 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 armhf golang-pq-dev all 1.3.0-1 [3092 B] Fetched 80.7 MB in 6s (14.3 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 ... 19398 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-7_armhf.deb ... Unpacking bsdextrautils (2.36.1-7) ... Selecting previously unselected package libuchardet0:armhf. Preparing to unpack .../01-libuchardet0_0.0.7-1_armhf.deb ... Unpacking libuchardet0:armhf (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_armhf.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:armhf. Preparing to unpack .../03-libpipeline1_1.5.3-1_armhf.deb ... Unpacking libpipeline1:armhf (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_armhf.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_armhf.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:armhf. Preparing to unpack .../07-libmagic1_1%3a5.39-3_armhf.deb ... Unpacking libmagic1:armhf (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_armhf.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_armhf.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:armhf. Preparing to unpack .../10-libsigsegv2_2.13-1_armhf.deb ... Unpacking libsigsegv2:armhf (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_armhf.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:armhf. Preparing to unpack .../23-libelf1_0.183-1_armhf.deb ... Unpacking libelf1:armhf (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_armhf.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:armhf. Preparing to unpack .../25-libicu67_67.1-7_armhf.deb ... Unpacking libicu67:armhf (67.1-7) ... Selecting previously unselected package libxml2:armhf. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_armhf.deb ... Unpacking libxml2:armhf (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_armhf.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_armhf.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_armhf.deb ... Unpacking golang-1.15-go (1.15.9-6) ... Selecting previously unselected package golang-src:armhf. Preparing to unpack .../34-golang-src_2%3a1.15~1_armhf.deb ... Unpacking golang-src:armhf (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_armhf.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:armhf. Preparing to unpack .../36-golang-any_2%3a1.15~1_armhf.deb ... Unpacking golang-any:armhf (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:armhf. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_armhf.deb ... Unpacking libsqlite3-dev:armhf (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:armhf (1.5.3-1) ... Setting up bsdextrautils (2.36.1-7) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:armhf (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:armhf (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:armhf (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:armhf (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:armhf (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:armhf (2:1.15~1) ... Setting up golang-1.15-go (1.15.9-6) ... Setting up libelf1:armhf (0.183-1) ... Setting up libxml2:armhf (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:armhf (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 armhf 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 3 gopkg.in/gorp.v1 internal/unsafeheader internal/cpu runtime/internal/sys internal/race runtime/internal/math sync/atomic internal/bytealg runtime/internal/atomic unicode unicode/utf8 runtime math/bits math internal/testlog internal/reflectlite sync errors sort io internal/oserror syscall strconv bytes strings reflect time internal/syscall/unix internal/syscall/execenv regexp/syntax context internal/poll regexp os internal/fmtsort fmt database/sql/driver log database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 3 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2021/07/27 11:43:26 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:26.459937 drop table if exists "invoice_test"; [] gorptest: 11:43:26.462951 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:26.463232 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:26.463445 drop table if exists "invoice_override_test"; [] gorptest: 11:43:26.463579 drop table if exists "person_test"; [] gorptest: 11:43:26.463735 drop table if exists "ignored_column_test"; [] gorptest: 11:43:26.463890 drop table if exists "id_created_test"; [] gorptest: 11:43:26.464018 drop table if exists "type_conv_test"; [] gorptest: 11:43:26.464158 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:26.464287 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:26.464465 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:26.464669 drop table if exists "time_test"; [] gorptest: 11:43:26.464904 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:26.483760 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: 11:43:26.502963 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:26.520926 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:26.539947 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:26.590604 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:26.608138 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:26.627614 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:26.653890 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:26.669691 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:26.735406 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:26.758852 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:26.775982 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: 11:43:26.776182 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: 11:43:26.776300 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:26.776403 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: 11:43:26.776512 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: 11:43:26.776621 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:26.776701 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:26.776792 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:26.776911 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:26.777005 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:26.777096 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: 11:43:26.777209 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:26.777318 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:43:26.777394 drop table if exists "invoice_test"; [] gorptest: 11:43:26.792047 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:26.815723 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:26.833492 drop table if exists "invoice_override_test"; [] gorptest: 11:43:26.851578 drop table if exists "person_test"; [] gorptest: 11:43:26.868982 drop table if exists "ignored_column_test"; [] gorptest: 11:43:26.892084 drop table if exists "id_created_test"; [] gorptest: 11:43:26.910686 drop table if exists "type_conv_test"; [] gorptest: 11:43:26.936217 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:26.950765 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:26.966053 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:26.978808 drop table if exists "time_test"; [] gorptest: 11:43:26.991686 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.53s) === RUN TestTruncateTables 2021/07/27 11:43:26 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:26.992435 drop table if exists "invoice_test"; [] gorptest: 11:43:26.993064 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:26.993206 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:26.993359 drop table if exists "invoice_override_test"; [] gorptest: 11:43:26.993482 drop table if exists "person_test"; [] gorptest: 11:43:26.993646 drop table if exists "ignored_column_test"; [] gorptest: 11:43:26.993747 drop table if exists "id_created_test"; [] gorptest: 11:43:26.993892 drop table if exists "type_conv_test"; [] gorptest: 11:43:26.994013 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:26.994148 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:26.994266 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:26.994380 drop table if exists "time_test"; [] gorptest: 11:43:26.994522 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:27.009268 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: 11:43:27.027514 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:27.044463 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:27.058566 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:27.070595 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:27.084813 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:27.098210 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:27.111818 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:27.124296 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:27.138227 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:27.152760 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:27.169083 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: 11:43:27.169275 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: 11:43:27.169378 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:27.169468 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: 11:43:27.169572 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: 11:43:27.169674 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:27.169749 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:27.169840 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:27.169951 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:27.170032 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:27.170164 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: 11:43:27.170282 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:27.170373 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:43:27.170579 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386207170497792 2:1627386207170497792 3:"Bob" 4:"Smith" 5:1] gorptest: 11:43:27.182297 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 11:43:27.195398 delete from "invoice_test"; [] gorptest: 11:43:27.206599 delete from "invoice_tag_test"; [] gorptest: 11:43:27.222747 delete from "alias_trans_field_test"; [] gorptest: 11:43:27.233686 delete from "invoice_override_test"; [] gorptest: 11:43:27.285002 delete from "person_test"; [] gorptest: 11:43:27.297891 delete from "ignored_column_test"; [] gorptest: 11:43:27.311244 delete from "id_created_test"; [] gorptest: 11:43:27.328437 delete from "type_conv_test"; [] gorptest: 11:43:27.340589 delete from "embedded_struct_test"; [] gorptest: 11:43:27.352102 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:27.365595 delete from "embedded_autoincr_test"; [] gorptest: 11:43:27.377748 delete from "time_test"; [] gorptest: 11:43:27.390043 delete from "id_created_test"; [] gorptest: 11:43:27.401236 SELECT * FROM person_test [] gorptest: 11:43:27.401602 SELECT * FROM invoice_test [] gorptest: 11:43:27.401859 drop table if exists "invoice_test"; [] gorptest: 11:43:27.416210 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:27.435673 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:27.448904 drop table if exists "invoice_override_test"; [] gorptest: 11:43:27.460924 drop table if exists "person_test"; [] gorptest: 11:43:27.473799 drop table if exists "ignored_column_test"; [] gorptest: 11:43:27.485558 drop table if exists "id_created_test"; [] gorptest: 11:43:27.498427 drop table if exists "type_conv_test"; [] gorptest: 11:43:27.509800 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:27.522561 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:27.534071 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:27.548770 drop table if exists "time_test"; [] gorptest: 11:43:27.560238 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.57s) === RUN TestCustomDateType gorptest: 11:43:27.560715 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 11:43:27.619507 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2021-07-27 11:43:27 +0000 UTC] gorptest: 11:43:27.633322 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 11:43:27.633696 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.09s) === RUN TestUIntPrimaryKey gorptest: 11:43:27.647481 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:43:27.660545 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:43:27.673463 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:43:27.685918 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 11:43:27.698872 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 11:43:27.711307 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 11:43:27.724739 drop table if exists "PersonUInt64"; [] gorptest: 11:43:27.737640 drop table if exists "PersonUInt32"; [] gorptest: 11:43:27.752404 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.12s) === RUN TestSetUniqueTogether gorptest: 11:43:27.764661 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 11:43:27.779382 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 11:43:27.794771 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 11:43:27.795101 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 11:43:27.795295 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 11:43:27.807628 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.06s) === RUN TestPersistentUser gorptest: 11:43:27.824533 drop table if exists PersistentUser [] gorptest: 11:43:27.825202 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:43:27.840423 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:43:27.855510 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 11:43:27.855889 select * from PersistentUser [] gorptest: 11:43:27.856149 select * from PersistentUser [] gorptest: 11:43:27.856379 select * from PersistentUser [] gorptest: 11:43:27.856596 select Id from PersistentUser [] gorptest: 11:43:27.856774 select mykey from PersistentUser [] gorptest: 11:43:27.856932 select PassedTraining from PersistentUser [] gorptest: 11:43:27.857084 select Id from PersistentUser [] gorptest: 11:43:27.857304 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.13s) === RUN TestNamedQueryMap gorptest: 11:43:27.949932 drop table if exists PersistentUser [] gorptest: 11:43:27.950706 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:43:27.981815 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:43:27.999876 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 11:43:28.031117 select * from PersistentUser where mykey = ? [1:43] gorptest: 11:43:28.031591 select * from PersistentUser where mykey = ? [1:43] gorptest: 11:43:28.031901 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 11:43:28.032199 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 11:43:28.032441 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.10s) === RUN TestNamedQueryStruct gorptest: 11:43:28.050939 drop table if exists PersistentUser [] gorptest: 11:43:28.051690 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:43:28.079293 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:43:28.093300 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 11:43:28.114215 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 11:43:28.114667 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.08s) === RUN TestReturnsNonNilSlice 2021/07/27 11:43:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:28.131358 drop table if exists "invoice_test"; [] gorptest: 11:43:28.131969 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:28.132093 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:28.132185 drop table if exists "invoice_override_test"; [] gorptest: 11:43:28.132270 drop table if exists "person_test"; [] gorptest: 11:43:28.132375 drop table if exists "ignored_column_test"; [] gorptest: 11:43:28.132482 drop table if exists "id_created_test"; [] gorptest: 11:43:28.132594 drop table if exists "type_conv_test"; [] gorptest: 11:43:28.132686 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:28.132774 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:28.132859 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:28.132942 drop table if exists "time_test"; [] gorptest: 11:43:28.133047 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:28.147532 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: 11:43:28.163279 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:28.184356 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:28.198560 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:28.213270 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:28.236118 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:28.255199 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:28.278102 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:28.292690 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:28.311964 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:28.335999 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:28.369185 select * from invoice_test where id=99999 [] gorptest: 11:43:28.370927 select * from invoice_test where id=99999 [] gorptest: 11:43:28.371320 drop table if exists "invoice_test"; [] gorptest: 11:43:28.403646 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:28.432879 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:28.454785 drop table if exists "invoice_override_test"; [] gorptest: 11:43:28.470976 drop table if exists "person_test"; [] gorptest: 11:43:28.484996 drop table if exists "ignored_column_test"; [] gorptest: 11:43:28.504842 drop table if exists "id_created_test"; [] gorptest: 11:43:28.519256 drop table if exists "type_conv_test"; [] gorptest: 11:43:28.545385 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:28.563834 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:28.590761 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:28.611931 drop table if exists "time_test"; [] gorptest: 11:43:28.635742 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.50s) === RUN TestOverrideVersionCol gorptest: 11:43:28.636218 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 11:43:28.658420 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: 11:43:28.658749 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.05s) === RUN TestOptimisticLocking 2021/07/27 11:43:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:28.682984 drop table if exists "invoice_test"; [] gorptest: 11:43:28.683653 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:28.683761 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:28.683846 drop table if exists "invoice_override_test"; [] gorptest: 11:43:28.683949 drop table if exists "person_test"; [] gorptest: 11:43:28.684038 drop table if exists "ignored_column_test"; [] gorptest: 11:43:28.684120 drop table if exists "id_created_test"; [] gorptest: 11:43:28.684201 drop table if exists "type_conv_test"; [] gorptest: 11:43:28.684282 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:28.684386 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:28.684544 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:28.684643 drop table if exists "time_test"; [] gorptest: 11:43:28.684751 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:28.701230 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: 11:43:28.727259 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:28.748466 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:28.763319 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:28.779602 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:28.795772 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:28.821741 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:28.843484 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:28.857824 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:28.890689 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:28.905015 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:28.926604 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386208926525058 2:1627386208926525058 3:"Bob" 4:"Smith" 5:1] gorptest: 11:43:28.956456 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:28.956948 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386208926525058 2:1627386208926525058 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 11:43:28.978192 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386208926525058 2:1627386208926525058 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 11:43:28.978529 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:28.978854 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 11:43:28.979040 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:28.979262 drop table if exists "invoice_test"; [] gorptest: 11:43:29.005043 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:29.021702 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:29.041057 drop table if exists "invoice_override_test"; [] gorptest: 11:43:29.054916 drop table if exists "person_test"; [] gorptest: 11:43:29.071395 drop table if exists "ignored_column_test"; [] gorptest: 11:43:29.093214 drop table if exists "id_created_test"; [] gorptest: 11:43:29.109366 drop table if exists "type_conv_test"; [] gorptest: 11:43:29.123791 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:29.157234 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:29.178393 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:29.208196 drop table if exists "time_test"; [] gorptest: 11:43:29.228301 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.55s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 11:43:29.228858 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 11:43:29.246707 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 11:43:29.261645 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 11:43:29.262184 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: 11:43:29.283712 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 11:43:29.284156 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.07s) === RUN TestColumnProps gorptest: 11:43:29.303163 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 11:43:29.322258 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 11:43:29.338422 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 11:43:29.338864 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 11:43:29.339104 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 11:43:29.339328 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.06s) === RUN TestRawSelect 2021/07/27 11:43:29 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: 11:43:29.358703 drop table if exists "invoice_test"; [] gorptest: 11:43:29.359382 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:29.359520 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:29.359654 drop table if exists "invoice_override_test"; [] gorptest: 11:43:29.359782 drop table if exists "person_test"; [] gorptest: 11:43:29.359911 drop table if exists "ignored_column_test"; [] gorptest: 11:43:29.360033 drop table if exists "id_created_test"; [] gorptest: 11:43:29.360157 drop table if exists "type_conv_test"; [] gorptest: 11:43:29.360279 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:29.360396 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:29.360486 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:29.360664 drop table if exists "time_test"; [] gorptest: 11:43:29.360824 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:29.383725 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: 11:43:29.410584 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:29.430075 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:29.442499 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:29.459930 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:29.478998 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:29.503108 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:29.518541 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:29.536394 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:29.555363 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:29.571323 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:29.587894 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386209587795057 2:1627386209587795057 3:"bob" 4:"smith" 5:1] gorptest: 11:43:29.600930 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 11:43:29.614222 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 11:43:29.614691 drop table if exists "invoice_test"; [] gorptest: 11:43:29.627515 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:29.655720 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:29.675525 drop table if exists "invoice_override_test"; [] gorptest: 11:43:29.697892 drop table if exists "person_test"; [] gorptest: 11:43:29.722449 drop table if exists "ignored_column_test"; [] gorptest: 11:43:29.743882 drop table if exists "id_created_test"; [] gorptest: 11:43:29.766024 drop table if exists "type_conv_test"; [] gorptest: 11:43:29.782083 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:29.800037 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:29.816429 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:29.834270 drop table if exists "time_test"; [] gorptest: 11:43:29.850432 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.49s) === RUN TestHooks 2021/07/27 11:43:29 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: 11:43:29.851050 drop table if exists "invoice_test"; [] gorptest: 11:43:29.851675 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:29.851816 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:29.851938 drop table if exists "invoice_override_test"; [] gorptest: 11:43:29.852075 drop table if exists "person_test"; [] gorptest: 11:43:29.852194 drop table if exists "ignored_column_test"; [] gorptest: 11:43:29.852315 drop table if exists "id_created_test"; [] gorptest: 11:43:29.852449 drop table if exists "type_conv_test"; [] gorptest: 11:43:29.852598 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:29.852745 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:29.852888 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:29.853026 drop table if exists "time_test"; [] gorptest: 11:43:29.853161 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:29.867139 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: 11:43:29.881900 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:29.898789 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:29.916039 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:29.928165 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:29.939714 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:29.953662 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:29.965468 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:29.980008 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:30.001263 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:30.019883 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:30.033191 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386210033081453 2:1627386210033081453 3:"bob" 4:"smith" 5:1] gorptest: 11:43:30.045814 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:30.046256 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386210033081453 2:1627386210033081453 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 11:43:30.060766 select * from person_test where id = ? [1:1] gorptest: 11:43:30.061236 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 11:43:30.079665 drop table if exists "invoice_test"; [] gorptest: 11:43:30.091961 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:30.110009 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:30.130210 drop table if exists "invoice_override_test"; [] gorptest: 11:43:30.146945 drop table if exists "person_test"; [] gorptest: 11:43:30.161505 drop table if exists "ignored_column_test"; [] gorptest: 11:43:30.173750 drop table if exists "id_created_test"; [] gorptest: 11:43:30.192004 drop table if exists "type_conv_test"; [] gorptest: 11:43:30.204840 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:30.221358 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:30.232996 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:30.250484 drop table if exists "time_test"; [] gorptest: 11:43:30.265028 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.41s) === RUN TestTransaction 2021/07/27 11:43:30 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:30.265597 drop table if exists "invoice_test"; [] gorptest: 11:43:30.266193 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:30.266715 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:30.266912 drop table if exists "invoice_override_test"; [] gorptest: 11:43:30.267011 drop table if exists "person_test"; [] gorptest: 11:43:30.267103 drop table if exists "ignored_column_test"; [] gorptest: 11:43:30.267213 drop table if exists "id_created_test"; [] gorptest: 11:43:30.267312 drop table if exists "type_conv_test"; [] gorptest: 11:43:30.267404 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:30.267492 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:30.267593 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:30.267689 drop table if exists "time_test"; [] gorptest: 11:43:30.267835 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:30.283010 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: 11:43:30.295525 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:30.315309 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:30.330402 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:30.346180 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:30.362102 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:30.376866 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:30.393378 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:30.404707 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:30.463908 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:30.476861 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:30.489625 begin; [] gorptest: 11:43:30.489811 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 11:43:30.490334 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 11:43:30.490469 commit; [] gorptest: 11:43:30.514377 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:30.514754 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 11:43:30.514992 drop table if exists "invoice_test"; [] gorptest: 11:43:30.530928 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:30.547417 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:30.562357 drop table if exists "invoice_override_test"; [] gorptest: 11:43:30.577369 drop table if exists "person_test"; [] gorptest: 11:43:30.593427 drop table if exists "ignored_column_test"; [] gorptest: 11:43:30.615916 drop table if exists "id_created_test"; [] gorptest: 11:43:30.657420 drop table if exists "type_conv_test"; [] gorptest: 11:43:30.675375 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:30.691496 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:30.711260 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:30.723028 drop table if exists "time_test"; [] gorptest: 11:43:30.735387 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.47s) === RUN TestSavepoint 2021/07/27 11:43:30 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:30.736058 drop table if exists "invoice_test"; [] gorptest: 11:43:30.736684 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:30.736800 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:30.736943 drop table if exists "invoice_override_test"; [] gorptest: 11:43:30.737086 drop table if exists "person_test"; [] gorptest: 11:43:30.737214 drop table if exists "ignored_column_test"; [] gorptest: 11:43:30.737379 drop table if exists "id_created_test"; [] gorptest: 11:43:30.737542 drop table if exists "type_conv_test"; [] gorptest: 11:43:30.737739 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:30.737880 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:30.738022 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:30.738719 drop table if exists "time_test"; [] gorptest: 11:43:30.738949 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:30.758413 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: 11:43:30.772226 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:30.789698 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:30.806409 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:30.823557 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:30.835351 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:30.851785 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:30.863987 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:30.876298 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:30.887884 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:30.900064 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:30.911591 begin; [] gorptest: 11:43:30.911801 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 11:43:30.912271 select memo from invoice_test [] gorptest: 11:43:30.912431 savepoint "foo" [1:] gorptest: 11:43:30.912467 select memo from invoice_test [] gorptest: 11:43:30.912576 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 11:43:30.912706 select memo from invoice_test [] gorptest: 11:43:30.912815 rollback to savepoint "foo" [1:] gorptest: 11:43:30.912870 select memo from invoice_test [] gorptest: 11:43:30.912935 rollback; [] gorptest: 11:43:30.913167 drop table if exists "invoice_test"; [] gorptest: 11:43:30.925343 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:30.936547 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:30.948818 drop table if exists "invoice_override_test"; [] gorptest: 11:43:30.960403 drop table if exists "person_test"; [] gorptest: 11:43:30.972549 drop table if exists "ignored_column_test"; [] gorptest: 11:43:30.985996 drop table if exists "id_created_test"; [] gorptest: 11:43:31.018962 drop table if exists "type_conv_test"; [] gorptest: 11:43:31.042949 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:31.062008 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:31.076227 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:31.087265 drop table if exists "time_test"; [] gorptest: 11:43:31.100961 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.37s) === RUN TestMultiple 2021/07/27 11:43:31 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: 11:43:31.101627 drop table if exists "invoice_test"; [] gorptest: 11:43:31.102253 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:31.102391 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:31.102504 drop table if exists "invoice_override_test"; [] gorptest: 11:43:31.102621 drop table if exists "person_test"; [] gorptest: 11:43:31.102757 drop table if exists "ignored_column_test"; [] gorptest: 11:43:31.102909 drop table if exists "id_created_test"; [] gorptest: 11:43:31.103039 drop table if exists "type_conv_test"; [] gorptest: 11:43:31.103193 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:31.103338 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:31.103466 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:31.103570 drop table if exists "time_test"; [] gorptest: 11:43:31.103704 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:31.115191 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: 11:43:31.140782 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:31.159496 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:31.175406 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:31.187838 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:31.198999 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:31.210516 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:31.232780 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:31.249621 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:31.265315 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:31.282596 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:31.294990 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 11:43:31.307301 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 11:43:31.319096 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 11:43:31.331739 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 11:43:31.347681 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:31.360640 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 11:43:31.372751 drop table if exists "invoice_test"; [] gorptest: 11:43:31.385231 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:31.397222 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:31.411468 drop table if exists "invoice_override_test"; [] gorptest: 11:43:31.430338 drop table if exists "person_test"; [] gorptest: 11:43:31.445098 drop table if exists "ignored_column_test"; [] gorptest: 11:43:31.486954 drop table if exists "id_created_test"; [] gorptest: 11:43:31.507328 drop table if exists "type_conv_test"; [] gorptest: 11:43:31.526721 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:31.548006 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:31.566320 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:31.585897 drop table if exists "time_test"; [] gorptest: 11:43:31.605909 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.50s) === RUN TestCrud 2021/07/27 11:43:31 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: 11:43:31.606759 drop table if exists "invoice_test"; [] gorptest: 11:43:31.607449 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:31.607592 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:31.607704 drop table if exists "invoice_override_test"; [] gorptest: 11:43:31.607814 drop table if exists "person_test"; [] gorptest: 11:43:31.607924 drop table if exists "ignored_column_test"; [] gorptest: 11:43:31.608034 drop table if exists "id_created_test"; [] gorptest: 11:43:31.608179 drop table if exists "type_conv_test"; [] gorptest: 11:43:31.608304 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:31.608419 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:31.608532 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:31.608643 drop table if exists "time_test"; [] gorptest: 11:43:31.608821 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:31.636587 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: 11:43:31.654882 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:31.673858 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:31.697481 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:31.715296 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:31.732921 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:31.753065 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:31.766339 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:31.791215 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:31.805158 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:31.822889 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:31.835671 delete from invoice_test [] gorptest: 11:43:31.847942 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 11:43:31.860388 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:31.860925 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: 11:43:31.875493 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:31.875886 select * from invoice_test [] gorptest: 11:43:31.876209 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:31.890374 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:43:31.890734 delete from invoice_tag_test [] gorptest: 11:43:31.918105 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: 11:43:31.947105 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:43:31.947681 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: 11:43:31.960787 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:43:31.961192 select * from invoice_tag_test [] gorptest: 11:43:31.961566 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:43:31.975307 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:43:31.975617 delete from alias_trans_field_test [] gorptest: 11:43:31.987427 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 11:43:32.000420 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:43:32.000865 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 11:43:32.013027 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:43:32.013352 select * from alias_trans_field_test [] gorptest: 11:43:32.013608 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:43:32.036126 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:43:32.036456 drop table if exists "invoice_test"; [] gorptest: 11:43:32.050667 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:32.065740 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:32.082733 drop table if exists "invoice_override_test"; [] gorptest: 11:43:32.097959 drop table if exists "person_test"; [] gorptest: 11:43:32.110908 drop table if exists "ignored_column_test"; [] gorptest: 11:43:32.123539 drop table if exists "id_created_test"; [] gorptest: 11:43:32.147255 drop table if exists "type_conv_test"; [] gorptest: 11:43:32.162666 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:32.186491 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:32.203055 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:32.227248 drop table if exists "time_test"; [] gorptest: 11:43:32.240412 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.63s) === RUN TestWithIgnoredColumn 2021/07/27 11:43:32 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:32.241088 drop table if exists "invoice_test"; [] gorptest: 11:43:32.241697 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:32.241864 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:32.241995 drop table if exists "invoice_override_test"; [] gorptest: 11:43:32.242163 drop table if exists "person_test"; [] gorptest: 11:43:32.242302 drop table if exists "ignored_column_test"; [] gorptest: 11:43:32.242407 drop table if exists "id_created_test"; [] gorptest: 11:43:32.242509 drop table if exists "type_conv_test"; [] gorptest: 11:43:32.242609 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:32.242764 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:32.242906 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:32.243044 drop table if exists "time_test"; [] gorptest: 11:43:32.243236 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:32.267531 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: 11:43:32.280209 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:32.293625 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:32.306173 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:32.320836 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:32.334020 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:32.347562 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:32.359429 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:32.372269 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:32.384299 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:32.398800 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:32.410922 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 11:43:32.434221 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:43:32.434585 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:43:32.449665 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:43:32.450010 drop table if exists "invoice_test"; [] gorptest: 11:43:32.464728 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:32.478221 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:32.492092 drop table if exists "invoice_override_test"; [] gorptest: 11:43:32.504698 drop table if exists "person_test"; [] gorptest: 11:43:32.518226 drop table if exists "ignored_column_test"; [] gorptest: 11:43:32.546802 drop table if exists "id_created_test"; [] gorptest: 11:43:32.559661 drop table if exists "type_conv_test"; [] gorptest: 11:43:32.571274 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:32.583910 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:32.595603 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:32.608655 drop table if exists "time_test"; [] gorptest: 11:43:32.621652 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.38s) === RUN TestTypeConversionExample 2021/07/27 11:43:32 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:32.622324 drop table if exists "invoice_test"; [] gorptest: 11:43:32.622912 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:32.623044 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:32.623134 drop table if exists "invoice_override_test"; [] gorptest: 11:43:32.623247 drop table if exists "person_test"; [] gorptest: 11:43:32.623412 drop table if exists "ignored_column_test"; [] gorptest: 11:43:32.623562 drop table if exists "id_created_test"; [] gorptest: 11:43:32.623723 drop table if exists "type_conv_test"; [] gorptest: 11:43:32.623851 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:32.623991 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:32.624690 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:32.624866 drop table if exists "time_test"; [] gorptest: 11:43:32.624996 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:32.637712 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: 11:43:32.649387 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:32.667157 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:32.683117 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:32.698438 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:32.719379 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:32.734429 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:32.749134 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:32.761400 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:32.774019 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:32.786661 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:32.846189 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: 11:43:32.859302 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:43:32.859749 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: 11:43:32.871885 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:43:32.872254 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:43:32.885339 drop table if exists "invoice_test"; [] gorptest: 11:43:32.897665 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:32.911028 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:32.923413 drop table if exists "invoice_override_test"; [] gorptest: 11:43:32.952790 drop table if exists "person_test"; [] gorptest: 11:43:32.966947 drop table if exists "ignored_column_test"; [] gorptest: 11:43:32.980170 drop table if exists "id_created_test"; [] gorptest: 11:43:33.004167 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.018168 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.032758 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.046845 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.070272 drop table if exists "time_test"; [] gorptest: 11:43:33.083740 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.46s) === RUN TestWithEmbeddedStruct 2021/07/27 11:43:33 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: 11:43:33.084403 drop table if exists "invoice_test"; [] gorptest: 11:43:33.085009 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:33.085139 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:33.085249 drop table if exists "invoice_override_test"; [] gorptest: 11:43:33.085345 drop table if exists "person_test"; [] gorptest: 11:43:33.085464 drop table if exists "ignored_column_test"; [] gorptest: 11:43:33.085571 drop table if exists "id_created_test"; [] gorptest: 11:43:33.085696 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.085790 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.085901 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.086015 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.086112 drop table if exists "time_test"; [] gorptest: 11:43:33.086860 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.120839 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: 11:43:33.135243 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:33.147774 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.163116 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:33.176217 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:33.191384 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:33.205130 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:33.220715 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:33.233298 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:33.252158 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:33.264859 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:33.278426 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 11:43:33.312117 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 11:43:33.312585 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 11:43:33.325534 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 11:43:33.325889 select * from embedded_struct_test [] gorptest: 11:43:33.326173 drop table if exists "invoice_test"; [] gorptest: 11:43:33.343419 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:33.356941 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:33.370619 drop table if exists "invoice_override_test"; [] gorptest: 11:43:33.387527 drop table if exists "person_test"; [] gorptest: 11:43:33.412661 drop table if exists "ignored_column_test"; [] gorptest: 11:43:33.427128 drop table if exists "id_created_test"; [] gorptest: 11:43:33.440824 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.454609 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.484723 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.498583 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.522376 drop table if exists "time_test"; [] gorptest: 11:43:33.539577 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.46s) === RUN TestWithEmbeddedStructBeforeAutoincr 2021/07/27 11:43:33 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: 11:43:33.540264 drop table if exists "invoice_test"; [] gorptest: 11:43:33.540855 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:33.540971 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:33.541057 drop table if exists "invoice_override_test"; [] gorptest: 11:43:33.541143 drop table if exists "person_test"; [] gorptest: 11:43:33.541238 drop table if exists "ignored_column_test"; [] gorptest: 11:43:33.541345 drop table if exists "id_created_test"; [] gorptest: 11:43:33.541460 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.541572 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.541685 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.541791 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.541897 drop table if exists "time_test"; [] gorptest: 11:43:33.542012 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.555905 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: 11:43:33.569789 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:33.584080 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.597996 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:33.610385 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:33.641975 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:33.666449 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:33.680931 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:33.695667 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:33.709315 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:33.727329 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:33.741133 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 11:43:33.754163 drop table if exists "invoice_test"; [] gorptest: 11:43:33.767708 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:33.779538 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:33.793524 drop table if exists "invoice_override_test"; [] gorptest: 11:43:33.806278 drop table if exists "person_test"; [] gorptest: 11:43:33.820125 drop table if exists "ignored_column_test"; [] gorptest: 11:43:33.836114 drop table if exists "id_created_test"; [] gorptest: 11:43:33.855331 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.869931 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.883428 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.894812 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.907423 drop table if exists "time_test"; [] gorptest: 11:43:33.919293 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.38s) === RUN TestWithEmbeddedAutoincr 2021/07/27 11:43:33 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: 11:43:33.919992 drop table if exists "invoice_test"; [] gorptest: 11:43:33.920549 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:33.920658 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:33.920750 drop table if exists "invoice_override_test"; [] gorptest: 11:43:33.920829 drop table if exists "person_test"; [] gorptest: 11:43:33.920943 drop table if exists "ignored_column_test"; [] gorptest: 11:43:33.921077 drop table if exists "id_created_test"; [] gorptest: 11:43:33.921217 drop table if exists "type_conv_test"; [] gorptest: 11:43:33.921329 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:33.921419 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:33.921517 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:33.921607 drop table if exists "time_test"; [] gorptest: 11:43:33.921711 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.934441 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: 11:43:33.953424 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:33.966336 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:33.978388 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:33.991242 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.002719 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.049738 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:34.062830 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:34.078175 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:34.090679 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:34.111281 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:34.124025 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 11:43:34.137290 drop table if exists "invoice_test"; [] gorptest: 11:43:34.149465 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:34.162459 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:34.178869 drop table if exists "invoice_override_test"; [] gorptest: 11:43:34.192050 drop table if exists "person_test"; [] gorptest: 11:43:34.203683 drop table if exists "ignored_column_test"; [] gorptest: 11:43:34.215971 drop table if exists "id_created_test"; [] gorptest: 11:43:34.227510 drop table if exists "type_conv_test"; [] gorptest: 11:43:34.240005 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:34.252024 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:34.264806 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:34.275957 drop table if exists "time_test"; [] gorptest: 11:43:34.288444 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.37s) === RUN TestSelectVal gorptest: 11:43:34.289090 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 11:43:34.300946 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: 11:43:34.313941 select Int64 from TableWithNull where Str='abc' [] gorptest: 11:43:34.314288 select count(*) from TableWithNull [] gorptest: 11:43:34.314497 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 11:43:34.314707 select Int64 from TableWithNull where Str='notfound' [] gorptest: 11:43:34.314897 select Int64 from TableWithNull where Str='abc' [] gorptest: 11:43:34.315072 select Float64 from TableWithNull where Str='abc' [] gorptest: 11:43:34.315225 select min(Float64) from TableWithNull [] gorptest: 11:43:34.315384 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 11:43:34.315548 select Float64 from TableWithNull where Str='notfound' [] gorptest: 11:43:34.315673 select Float64 from TableWithNull where Str='abc' [] gorptest: 11:43:34.315806 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:43:34.315948 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 11:43:34.316071 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:43:34.316205 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 11:43:34.316448 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 11:43:34.316674 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:43:34.316850 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.04s) === RUN TestVersionMultipleRows 2021/07/27 11:43:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:34.329496 drop table if exists "invoice_test"; [] gorptest: 11:43:34.330147 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:34.330309 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:34.330457 drop table if exists "invoice_override_test"; [] gorptest: 11:43:34.330586 drop table if exists "person_test"; [] gorptest: 11:43:34.330709 drop table if exists "ignored_column_test"; [] gorptest: 11:43:34.330823 drop table if exists "id_created_test"; [] gorptest: 11:43:34.330940 drop table if exists "type_conv_test"; [] gorptest: 11:43:34.331486 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:34.331669 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:34.331806 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:34.331940 drop table if exists "time_test"; [] gorptest: 11:43:34.332099 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:34.345480 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: 11:43:34.357743 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:34.371078 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:34.383297 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:34.426540 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.441393 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.454966 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:34.471043 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:34.485132 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:34.500399 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:34.514938 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:34.528391 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386214528305656 2:1627386214528305656 3:"Bob" 4:"Smith" 5:1] gorptest: 11:43:34.543596 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386214543528203 2:1627386214543528203 3:"Jane" 4:"Smith" 5:1] gorptest: 11:43:34.560205 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386214560102442 2:1627386214560102442 3:"Mike" 4:"Smith" 5:1] gorptest: 11:43:34.571476 drop table if exists "invoice_test"; [] gorptest: 11:43:34.603420 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:34.619443 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:34.638439 drop table if exists "invoice_override_test"; [] gorptest: 11:43:34.656981 drop table if exists "person_test"; [] gorptest: 11:43:34.671644 drop table if exists "ignored_column_test"; [] gorptest: 11:43:34.691231 drop table if exists "id_created_test"; [] gorptest: 11:43:34.706489 drop table if exists "type_conv_test"; [] gorptest: 11:43:34.719618 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:34.728889 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:34.743123 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:34.760204 drop table if exists "time_test"; [] gorptest: 11:43:34.775285 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.45s) === RUN TestWithStringPk gorptest: 11:43:34.775841 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 11:43:34.793066 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 11:43:34.815349 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.06s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2021/07/27 11:43:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:43:34.838952 drop table if exists "invoice_test"; [] gorptest: 11:43:34.839621 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:34.839729 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:34.839816 drop table if exists "invoice_override_test"; [] gorptest: 11:43:34.839899 drop table if exists "person_test"; [] gorptest: 11:43:34.840006 drop table if exists "ignored_column_test"; [] gorptest: 11:43:34.840105 drop table if exists "id_created_test"; [] gorptest: 11:43:34.840191 drop table if exists "type_conv_test"; [] gorptest: 11:43:34.840279 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:34.840373 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:34.840461 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:34.840546 drop table if exists "time_test"; [] gorptest: 11:43:34.840676 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:34.853374 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: 11:43:34.867429 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:34.881416 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:34.891659 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:34.906330 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.921869 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:34.937927 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:34.950364 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:34.965122 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:34.988241 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:35.001954 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:35.015373 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-27 11:12:35.015297184 +0000 UTC] gorptest: 11:43:35.029155 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-27 11:13:36.015297184 +0000 UTC] gorptest: 11:43:35.041738 SELECT id FROM time_test WHERE Time < ? [1:2021-07-27 11:13:35.015297184 +0000 UTC] gorptest: 11:43:35.042113 drop table if exists "invoice_test"; [] gorptest: 11:43:35.055048 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:35.064650 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:35.080815 drop table if exists "invoice_override_test"; [] gorptest: 11:43:35.097973 drop table if exists "person_test"; [] gorptest: 11:43:35.113717 drop table if exists "ignored_column_test"; [] gorptest: 11:43:35.127898 drop table if exists "id_created_test"; [] gorptest: 11:43:35.143045 drop table if exists "type_conv_test"; [] gorptest: 11:43:35.159109 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:35.176253 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:35.190195 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:35.204792 drop table if exists "time_test"; [] gorptest: 11:43:35.221547 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.38s) === RUN TestInvoicePersonView 2021/07/27 11:43:35 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: 11:43:35.222274 drop table if exists "invoice_test"; [] gorptest: 11:43:35.222878 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:35.223016 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:35.223155 drop table if exists "invoice_override_test"; [] gorptest: 11:43:35.223303 drop table if exists "person_test"; [] gorptest: 11:43:35.223397 drop table if exists "ignored_column_test"; [] gorptest: 11:43:35.223496 drop table if exists "id_created_test"; [] gorptest: 11:43:35.223580 drop table if exists "type_conv_test"; [] gorptest: 11:43:35.223664 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:35.223746 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:35.223831 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:35.223913 drop table if exists "time_test"; [] gorptest: 11:43:35.224528 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:35.234190 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: 11:43:35.245900 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:35.261806 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:35.278927 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:35.294650 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:35.309659 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:35.324251 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:35.340559 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:35.356111 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:35.369208 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:35.383874 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:35.398518 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386215398441690 2:1627386215398441690 3:"bob" 4:"smith" 5:1] gorptest: 11:43:35.412369 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 11:43:35.427518 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 11:43:35.427951 drop table if exists "invoice_test"; [] gorptest: 11:43:35.442065 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:35.450301 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:35.464588 drop table if exists "invoice_override_test"; [] gorptest: 11:43:35.479531 drop table if exists "person_test"; [] gorptest: 11:43:35.496382 drop table if exists "ignored_column_test"; [] gorptest: 11:43:35.512503 drop table if exists "id_created_test"; [] gorptest: 11:43:35.526369 drop table if exists "type_conv_test"; [] gorptest: 11:43:35.538798 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:35.553031 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:35.570464 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:35.586645 drop table if exists "time_test"; [] gorptest: 11:43:35.601623 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.38s) === RUN TestQuoteTableNames 2021/07/27 11:43:35 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: 11:43:35.602258 drop table if exists "invoice_test"; [] gorptest: 11:43:35.602830 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:35.602952 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:35.603054 drop table if exists "invoice_override_test"; [] gorptest: 11:43:35.603141 drop table if exists "person_test"; [] gorptest: 11:43:35.603264 drop table if exists "ignored_column_test"; [] gorptest: 11:43:35.603363 drop table if exists "id_created_test"; [] gorptest: 11:43:35.603467 drop table if exists "type_conv_test"; [] gorptest: 11:43:35.603545 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:35.603641 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:35.603731 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:35.603844 drop table if exists "time_test"; [] gorptest: 11:43:35.603961 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:35.619243 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: 11:43:35.635053 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:35.650476 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:35.667953 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:35.682482 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:35.697985 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:35.709963 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:35.726048 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:35.740695 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:35.753547 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:35.768498 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.36s) === RUN TestSelectTooManyCols 2021/07/27 11:43:35 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: 11:43:35.960938 drop table if exists "invoice_test"; [] gorptest: 11:43:35.961618 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:35.961780 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:35.961889 drop table if exists "invoice_override_test"; [] gorptest: 11:43:35.962006 drop table if exists "person_test"; [] gorptest: 11:43:35.962180 drop table if exists "ignored_column_test"; [] gorptest: 11:43:35.962316 drop table if exists "id_created_test"; [] gorptest: 11:43:35.962973 drop table if exists "type_conv_test"; [] gorptest: 11:43:35.963205 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:35.963375 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:35.963504 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:35.963628 drop table if exists "time_test"; [] gorptest: 11:43:35.963786 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:35.976997 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: 11:43:35.989392 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:36.002310 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:36.014204 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:36.029473 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.048592 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.064030 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:36.082757 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:36.102176 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:36.116575 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:36.132002 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:36.145702 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386216145614862 2:1627386216145614862 3:"bob" 4:"smith" 5:1] gorptest: 11:43:36.160903 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386216160834749 2:1627386216160834749 3:"jane" 4:"doe" 5:1] gorptest: 11:43:36.172903 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:36.173338 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 11:43:36.173655 select * from person_test where Id=? [1:1] gorptest: 11:43:36.173983 select * from person_test order by fname asc [] gorptest: 11:43:36.174392 drop table if exists "invoice_test"; [] gorptest: 11:43:36.187520 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:36.199411 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:36.212689 drop table if exists "invoice_override_test"; [] gorptest: 11:43:36.226106 drop table if exists "person_test"; [] gorptest: 11:43:36.241858 drop table if exists "ignored_column_test"; [] gorptest: 11:43:36.253558 drop table if exists "id_created_test"; [] gorptest: 11:43:36.269320 drop table if exists "type_conv_test"; [] gorptest: 11:43:36.281277 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:36.297221 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:36.309322 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:36.322199 drop table if exists "time_test"; [] gorptest: 11:43:36.338693 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.38s) === RUN TestSelectSingleVal 2021/07/27 11:43:36 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: 11:43:36.339462 drop table if exists "invoice_test"; [] gorptest: 11:43:36.340194 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:36.340361 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:36.340489 drop table if exists "invoice_override_test"; [] gorptest: 11:43:36.340597 drop table if exists "person_test"; [] gorptest: 11:43:36.340704 drop table if exists "ignored_column_test"; [] gorptest: 11:43:36.340798 drop table if exists "id_created_test"; [] gorptest: 11:43:36.340907 drop table if exists "type_conv_test"; [] gorptest: 11:43:36.341008 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:36.341141 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:36.341318 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:36.341497 drop table if exists "time_test"; [] gorptest: 11:43:36.341679 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:36.358557 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: 11:43:36.372690 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:36.385847 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:36.398478 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:36.412671 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.424986 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.440037 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:36.455889 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:36.470920 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:36.488500 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:36.501684 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:36.514297 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386216514213858 2:1627386216514213858 3:"bob" 4:"smith" 5:1] gorptest: 11:43:36.527798 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:43:36.528216 select * from person_test where Id=? [1:1] gorptest: 11:43:36.528570 select FName from person_test where Id=? [1:1] gorptest: 11:43:36.528760 select * from person_test where Id=? [1:1] gorptest: 11:43:36.529199 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 11:43:36.529485 select * from person_test where Id=? [1:-2222] gorptest: 11:43:36.529767 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386216529718238 2:1627386216529718238 3:"bob" 4:"smith" 5:1] gorptest: 11:43:36.555746 select * from person_test where Fname='bob' [] gorptest: 11:43:36.556291 select * from person_test where Id=-123 [] gorptest: 11:43:36.556533 select * from person_test where Id=-123 [] gorptest: 11:43:36.556806 select * from person_test where Id=-123 [] gorptest: 11:43:36.557028 select * from person_test where Id=-123 [] gorptest: 11:43:36.557278 drop table if exists "invoice_test"; [] gorptest: 11:43:36.573635 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:36.596531 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:36.609383 drop table if exists "invoice_override_test"; [] gorptest: 11:43:36.622921 drop table if exists "person_test"; [] gorptest: 11:43:36.635949 drop table if exists "ignored_column_test"; [] gorptest: 11:43:36.648574 drop table if exists "id_created_test"; [] gorptest: 11:43:36.659989 drop table if exists "type_conv_test"; [] gorptest: 11:43:36.673083 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:36.686996 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:36.701739 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:36.715983 drop table if exists "time_test"; [] gorptest: 11:43:36.728605 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.39s) === RUN TestSelectAlias 2021/07/27 11:43:36 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: 11:43:36.729189 drop table if exists "invoice_test"; [] gorptest: 11:43:36.729875 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:36.730015 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:36.730144 drop table if exists "invoice_override_test"; [] gorptest: 11:43:36.730344 drop table if exists "person_test"; [] gorptest: 11:43:36.730500 drop table if exists "ignored_column_test"; [] gorptest: 11:43:36.730634 drop table if exists "id_created_test"; [] gorptest: 11:43:36.730754 drop table if exists "type_conv_test"; [] gorptest: 11:43:36.730869 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:36.730991 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:36.731114 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:36.731322 drop table if exists "time_test"; [] gorptest: 11:43:36.731489 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:36.744397 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: 11:43:36.757660 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:36.770592 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:36.783639 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:36.806440 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.819545 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:36.833784 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:36.846776 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:36.858868 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:36.871839 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:36.886471 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:36.899946 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 11:43:36.911674 select * from id_created_test where Id=1 [] gorptest: 11:43:36.911990 SELECT *, 1 AS external FROM id_created_test [] gorptest: 11:43:36.912335 drop table if exists "invoice_test"; [] gorptest: 11:43:36.925488 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:36.938152 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:36.954601 drop table if exists "invoice_override_test"; [] gorptest: 11:43:36.974351 drop table if exists "person_test"; [] gorptest: 11:43:36.990191 drop table if exists "ignored_column_test"; [] gorptest: 11:43:37.006929 drop table if exists "id_created_test"; [] gorptest: 11:43:37.025141 drop table if exists "type_conv_test"; [] gorptest: 11:43:37.041542 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:37.058493 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.075727 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:37.094055 drop table if exists "time_test"; [] gorptest: 11:43:37.111119 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.38s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2021/07/27 11:43:37 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: 11:43:37.111878 drop table if exists "invoice_test"; [] gorptest: 11:43:37.112497 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:37.112641 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:37.113186 drop table if exists "invoice_override_test"; [] gorptest: 11:43:37.113371 drop table if exists "person_test"; [] gorptest: 11:43:37.113495 drop table if exists "ignored_column_test"; [] gorptest: 11:43:37.113592 drop table if exists "id_created_test"; [] gorptest: 11:43:37.113701 drop table if exists "type_conv_test"; [] gorptest: 11:43:37.113809 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:37.113934 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.114061 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:37.114261 drop table if exists "time_test"; [] gorptest: 11:43:37.114419 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:37.131129 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: 11:43:37.147124 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:37.157506 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:37.171090 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:37.182021 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:37.199015 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:37.227310 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:37.242572 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:37.259060 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:37.274949 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:37.290324 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:37.302597 drop table if exists "invoice_test"; [] gorptest: 11:43:37.318025 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:37.334703 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:37.351298 drop table if exists "invoice_override_test"; [] gorptest: 11:43:37.369479 drop table if exists "person_test"; [] gorptest: 11:43:37.385439 drop table if exists "ignored_column_test"; [] gorptest: 11:43:37.401725 drop table if exists "id_created_test"; [] gorptest: 11:43:37.410612 drop table if exists "type_conv_test"; [] gorptest: 11:43:37.425220 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:37.438795 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.455600 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:37.472275 drop table if exists "time_test"; [] gorptest: 11:43:37.492670 drop table if exists "id_created_test"; [] gorptest: 11:43:37.492939 drop table if exists "single_column_table"; [] gorptest: 11:43:37.493157 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: 11:43:37.507066 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: 11:43:37.532114 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:37.549372 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: 11:43:37.577015 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: 11:43:37.591522 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:37.607725 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:37.623644 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:37.639571 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:37.653208 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:37.662518 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: 11:43:37.674599 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:37.686497 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:43:37.686664 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 11:43:37.701056 delete from "invoice_test"; [] gorptest: 11:43:37.713426 delete from "invoice_tag_test"; [] gorptest: 11:43:37.722528 delete from "alias_trans_field_test"; [] gorptest: 11:43:37.731370 delete from "invoice_override_test"; [] gorptest: 11:43:37.739449 delete from "person_test"; [] gorptest: 11:43:37.747314 delete from "ignored_column_test"; [] gorptest: 11:43:37.754658 delete from "id_created_test"; [] gorptest: 11:43:37.762106 delete from "type_conv_test"; [] gorptest: 11:43:37.769693 delete from "embedded_struct_test"; [] gorptest: 11:43:37.777474 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.788715 delete from "embedded_autoincr_test"; [] gorptest: 11:43:37.796416 delete from "time_test"; [] gorptest: 11:43:37.804268 delete from "id_created_test"; [] gorptest: 11:43:37.811891 delete from "single_column_table"; [] gorptest: 11:43:37.821081 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 11:43:37.821399 drop table if exists "invoice_test"; [] gorptest: 11:43:37.830472 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:37.838723 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:37.851644 drop table if exists "invoice_override_test"; [] gorptest: 11:43:37.862520 drop table if exists "person_test"; [] gorptest: 11:43:37.878411 drop table if exists "ignored_column_test"; [] gorptest: 11:43:37.892226 drop table if exists "id_created_test"; [] gorptest: 11:43:37.902395 drop table if exists "type_conv_test"; [] gorptest: 11:43:37.911335 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:37.921866 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.930289 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:37.939657 drop table if exists "time_test"; [] gorptest: 11:43:37.948025 drop table if exists "id_created_test"; [] gorptest: 11:43:37.948204 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.85s) === RUN TestPrepare 2021/07/27 11:43:37 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: 11:43:37.958198 drop table if exists "invoice_test"; [] gorptest: 11:43:37.958822 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:37.958939 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:37.959041 drop table if exists "invoice_override_test"; [] gorptest: 11:43:37.959141 drop table if exists "person_test"; [] gorptest: 11:43:37.959288 drop table if exists "ignored_column_test"; [] gorptest: 11:43:37.959404 drop table if exists "id_created_test"; [] gorptest: 11:43:37.959514 drop table if exists "type_conv_test"; [] gorptest: 11:43:37.959609 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:37.959703 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:37.959807 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:37.959906 drop table if exists "time_test"; [] gorptest: 11:43:37.960030 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:37.973156 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: 11:43:37.982467 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:43:37.991627 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:43:38.000641 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:43:38.009245 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:38.017673 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:43:38.025921 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:43:38.034470 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:43:38.043150 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:43:38.051030 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:43:38.060092 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:43:38.069508 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 11:43:38.079875 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 11:43:38.089981 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 11:43:38.099622 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 11:43:38.100038 begin; [] gorptest: 11:43:38.100101 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 11:43:38.100482 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:43:38.101366 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:43:38.101614 commit; [] gorptest: 11:43:38.120147 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:43:38.120563 drop table if exists "invoice_test"; [] gorptest: 11:43:38.129175 drop table if exists "invoice_tag_test"; [] gorptest: 11:43:38.139526 drop table if exists "alias_trans_field_test"; [] gorptest: 11:43:38.149541 drop table if exists "invoice_override_test"; [] gorptest: 11:43:38.160605 drop table if exists "person_test"; [] gorptest: 11:43:38.169770 drop table if exists "ignored_column_test"; [] gorptest: 11:43:38.180414 drop table if exists "id_created_test"; [] gorptest: 11:43:38.189350 drop table if exists "type_conv_test"; [] gorptest: 11:43:38.199390 drop table if exists "embedded_struct_test"; [] gorptest: 11:43:38.207784 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:43:38.217441 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:43:38.226068 drop table if exists "time_test"; [] gorptest: 11:43:38.235884 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.28s) PASS ok gopkg.in/gorp.v1 11.795s 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_armhf.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/17951 and its subdirectories I: Current time: Mon Jul 26 23:43:50 -12 2021 I: pbuilder-time-stamp: 1627386230 Tue Jul 27 11:43:56 UTC 2021 I: 1st build successful. Starting 2nd build on remote node jtx1c-armhf-rb.debian.net. Tue Jul 27 11:43:56 UTC 2021 I: Preparing to do remote build '2' on jtx1c-armhf-rb.debian.net. Tue Jul 27 11:46:22 UTC 2021 I: Deleting $TMPDIR on jtx1c-armhf-rb.debian.net. Tue Jul 27 11:46:25 UTC 2021 I: golang-gopkg-gorp.v1_1.7.2-2_armhf.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 8595e51a3d3540914a39023f7fd8199ea66f7089 5171 golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb be0fc9ba8d5ca20cb9cdeecda5667f8b80b4ca9ab0c11882b3601e260802485b 5171 golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 3d87a15bd6972b31afe448ed77ea3c78 5171 devel optional golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Tue Jul 27 11:46:27 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.8ZwQZIGrkW/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.changes /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.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.923s) 0.923s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.017s) 0.017s 10 calls diffoscope.comparators.binary.FilesystemFile 0.000s 8 calls abc.DotChangesFile Tue Jul 27 11:46:29 UTC 2021 I: diffoscope 177 found no differences in the changes files, and a .buildinfo file also exists. Tue Jul 27 11:46:29 UTC 2021 I: golang-gopkg-gorp.v1 from bullseye built successfully and reproducibly on armhf. Tue Jul 27 11:46:30 UTC 2021 I: Submitting .buildinfo files to external archives: Tue Jul 27 11:46:30 UTC 2021 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc Tue Jul 27 11:46:32 UTC 2021 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc Tue Jul 27 11:46:33 UTC 2021 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Tue Jul 27 11:46:33 UTC 2021 I: Done submitting .buildinfo files. Tue Jul 27 11:46:33 UTC 2021 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc'