Wed Jul 7 16:27:46 UTC 2021 I: starting to build golang-gopkg-gorp.v1/bullseye/i386 on jenkins on '2021-07-07 16:27' Wed Jul 7 16:27:46 UTC 2021 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/i386_3/11889/console.log Wed Jul 7 16:27:46 UTC 2021 I: Downloading source for bullseye/golang-gopkg-gorp.v1=1.7.2-2 --2021-07-07 16:27:46-- 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% 178M=0s 2021-07-07 16:27:46 (178 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Wed Jul 7 16:27:46 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----- Wed Jul 7 16:27:46 UTC 2021 I: Checking whether the package is not for us Wed Jul 7 16:27:46 UTC 2021 I: Starting 1st build on remote node ionos2-i386.debian.net. Wed Jul 7 16:27:46 UTC 2021 I: Preparing to do remote build '1' on ionos2-i386.debian.net. Wed Jul 7 16:35:35 UTC 2021 I: Deleting $TMPDIR on ionos2-i386.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Wed Jul 7 04:27:48 -12 2021 I: pbuilder-time-stamp: 1625675268 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: using eatmydata during job 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.x9CRHFag/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/20348/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='i386' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=10' DISTRIBUTION='' HOME='/root' HOST_ARCH='i386' IFS=' ' INVOCATION_ID='536bb416aaf640208b22a3c0ede53252' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' LD_LIBRARY_PATH='/usr/lib/libeatmydata' LD_PRELOAD='libeatmydata.so' 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='20348' 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.gtGSnlgoHt/pbuilderrc_NkXe --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='112' SUDO_UID='107' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://78.137.99.97:3128' I: uname -a Linux ionos2-i386 4.19.0-17-686-pae #1 SMP Debian 4.19.194-2 (2021-06-21) i686 GNU/Linux I: ls -l /bin total 5776 -rwxr-xr-x 1 root root 1367848 Jun 21 14:25 bash -rwxr-xr-x 3 root root 38280 Jul 20 2020 bunzip2 -rwxr-xr-x 3 root root 38280 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 38280 Jul 20 2020 bzip2 -rwxr-xr-x 1 root root 17768 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 38824 Sep 22 2020 cat -rwxr-xr-x 1 root root 71624 Sep 22 2020 chgrp -rwxr-xr-x 1 root root 67528 Sep 22 2020 chmod -rwxr-xr-x 1 root root 75752 Sep 22 2020 chown -rwxr-xr-x 1 root root 157960 Sep 22 2020 cp -rwxr-xr-x 1 root root 128724 Dec 10 2020 dash -rwxr-xr-x 1 root root 124904 Sep 22 2020 date -rwxr-xr-x 1 root root 92172 Sep 22 2020 dd -rwxr-xr-x 1 root root 100752 Sep 22 2020 df -rwxr-xr-x 1 root root 153964 Sep 22 2020 dir -rwxr-xr-x 1 root root 83644 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 34664 Sep 22 2020 echo -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep -rwxr-xr-x 1 root root 34664 Sep 22 2020 false -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep -rwxr-xr-x 1 root root 71928 Feb 7 02:38 findmnt -rwsr-xr-x 1 root root 30112 Feb 26 04:12 fusermount -rwxr-xr-x 1 root root 210488 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 100952 Mar 2 11:30 gzip -rwxr-xr-x 1 root root 21916 Nov 6 2019 hostname -rwxr-xr-x 1 root root 83980 Sep 22 2020 ln -rwxr-xr-x 1 root root 55572 Feb 7 2020 login -rwxr-xr-x 1 root root 153964 Sep 22 2020 ls -rwxr-xr-x 1 root root 153124 Feb 7 02:38 lsblk -rwxr-xr-x 1 root root 96328 Sep 22 2020 mkdir -rwxr-xr-x 1 root root 79912 Sep 22 2020 mknod -rwxr-xr-x 1 root root 47048 Sep 22 2020 mktemp -rwxr-xr-x 1 root root 58920 Feb 7 02:38 more -rwsr-xr-x 1 root root 50720 Feb 7 02:38 mount -rwxr-xr-x 1 root root 13856 Feb 7 02:38 mountpoint -rwxr-xr-x 1 root root 157996 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 38824 Sep 22 2020 pwd lrwxrwxrwx 1 root root 4 Jun 21 14:25 rbash -> bash -rwxr-xr-x 1 root root 46984 Sep 22 2020 readlink -rwxr-xr-x 1 root root 75720 Sep 22 2020 rm -rwxr-xr-x 1 root root 46984 Sep 22 2020 rmdir -rwxr-xr-x 1 root root 22292 Sep 27 2020 run-parts -rwxr-xr-x 1 root root 125036 Dec 22 2018 sed lrwxrwxrwx 1 root root 4 Jul 4 02:20 sh -> dash -rwxr-xr-x 1 root root 34696 Sep 22 2020 sleep -rwxr-xr-x 1 root root 83880 Sep 22 2020 stty -rwsr-xr-x 1 root root 79396 Feb 7 02:38 su -rwxr-xr-x 1 root root 34696 Sep 22 2020 sync -rwxr-xr-x 1 root root 602584 Feb 16 21:55 tar -rwxr-xr-x 1 root root 13860 Sep 27 2020 tempfile -rwxr-xr-x 1 root root 108520 Sep 22 2020 touch -rwxr-xr-x 1 root root 34664 Sep 22 2020 true -rwxr-xr-x 1 root root 17768 Feb 26 04:12 ulockmgr_server -rwsr-xr-x 1 root root 30236 Feb 7 02:38 umount -rwxr-xr-x 1 root root 34664 Sep 22 2020 uname -rwxr-xr-x 2 root root 2346 Mar 2 11:30 uncompress -rwxr-xr-x 1 root root 153964 Sep 22 2020 vdir -rwxr-xr-x 1 root root 63024 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/20348/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: i386 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 ... 19675 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 84.8 MB of archives. After unpacking 454 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main i386 bsdextrautils i386 2.36.1-7 [148 kB] Get: 2 http://deb.debian.org/debian bullseye/main i386 libuchardet0 i386 0.0.7-1 [67.9 kB] Get: 3 http://deb.debian.org/debian bullseye/main i386 groff-base i386 1.22.4-6 [952 kB] Get: 4 http://deb.debian.org/debian bullseye/main i386 libpipeline1 i386 1.5.3-1 [36.8 kB] Get: 5 http://deb.debian.org/debian bullseye/main i386 man-db i386 2.9.4-2 [1367 kB] Get: 6 http://deb.debian.org/debian bullseye/main i386 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main i386 libmagic-mgc i386 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main i386 libmagic1 i386 1:5.39-3 [133 kB] Get: 9 http://deb.debian.org/debian bullseye/main i386 file i386 1:5.39-3 [69.0 kB] Get: 10 http://deb.debian.org/debian bullseye/main i386 gettext-base i386 0.21-4 [176 kB] Get: 11 http://deb.debian.org/debian bullseye/main i386 libsigsegv2 i386 2.13-1 [35.1 kB] Get: 12 http://deb.debian.org/debian bullseye/main i386 m4 i386 1.4.18-5 [206 kB] Get: 13 http://deb.debian.org/debian bullseye/main i386 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main i386 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main i386 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main i386 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main i386 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main i386 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main i386 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main i386 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main i386 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main i386 libfile-stripnondeterminism-perl all 1.11.0-1 [25.6 kB] Get: 23 http://deb.debian.org/debian bullseye/main i386 dh-strip-nondeterminism all 1.11.0-1 [15.3 kB] Get: 24 http://deb.debian.org/debian bullseye/main i386 libelf1 i386 0.183-1 [171 kB] Get: 25 http://deb.debian.org/debian bullseye/main i386 dwz i386 0.13+20210201-1 [179 kB] Get: 26 http://deb.debian.org/debian bullseye/main i386 libicu67 i386 67.1-7 [8775 kB] Get: 27 http://deb.debian.org/debian bullseye/main i386 libxml2 i386 2.9.10+dfsg-6.7 [728 kB] Get: 28 http://deb.debian.org/debian bullseye/main i386 gettext i386 0.21-4 [1322 kB] Get: 29 http://deb.debian.org/debian bullseye/main i386 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main i386 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main i386 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main i386 dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main i386 golang-1.15-src i386 1.15.9-5 [13.8 MB] Get: 34 http://deb.debian.org/debian bullseye/main i386 golang-1.15-go i386 1.15.9-5 [46.2 MB] Get: 35 http://deb.debian.org/debian bullseye/main i386 golang-src i386 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main i386 golang-go i386 2:1.15~1 [24.0 kB] Get: 37 http://deb.debian.org/debian bullseye/main i386 golang-any i386 2:1.15~1 [4980 B] Get: 38 http://deb.debian.org/debian bullseye/main i386 golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main i386 golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main i386 libsqlite3-dev i386 3.34.1-3 [1001 kB] Get: 44 http://deb.debian.org/debian bullseye/main i386 golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main i386 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 i386 golang-pq-dev all 1.3.0-1 [3092 B] Fetched 84.8 MB in 14s (5859 kB/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 ... 19675 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-7_i386.deb ... Unpacking bsdextrautils (2.36.1-7) ... Selecting previously unselected package libuchardet0:i386. Preparing to unpack .../01-libuchardet0_0.0.7-1_i386.deb ... Unpacking libuchardet0:i386 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_i386.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:i386. Preparing to unpack .../03-libpipeline1_1.5.3-1_i386.deb ... Unpacking libpipeline1:i386 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_i386.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_i386.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:i386. Preparing to unpack .../07-libmagic1_1%3a5.39-3_i386.deb ... Unpacking libmagic1:i386 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_i386.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_i386.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:i386. Preparing to unpack .../10-libsigsegv2_2.13-1_i386.deb ... Unpacking libsigsegv2:i386 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_i386.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.11.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.11.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.11.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.11.0-1) ... Selecting previously unselected package libelf1:i386. Preparing to unpack .../23-libelf1_0.183-1_i386.deb ... Unpacking libelf1:i386 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_i386.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:i386. Preparing to unpack .../25-libicu67_67.1-7_i386.deb ... Unpacking libicu67:i386 (67.1-7) ... Selecting previously unselected package libxml2:i386. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_i386.deb ... Unpacking libxml2:i386 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_i386.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-5_i386.deb ... Unpacking golang-1.15-src (1.15.9-5) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.9-5_i386.deb ... Unpacking golang-1.15-go (1.15.9-5) ... Selecting previously unselected package golang-src:i386. Preparing to unpack .../34-golang-src_2%3a1.15~1_i386.deb ... Unpacking golang-src:i386 (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_i386.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:i386. Preparing to unpack .../36-golang-any_2%3a1.15~1_i386.deb ... Unpacking golang-any:i386 (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:i386. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_i386.deb ... Unpacking libsqlite3-dev:i386 (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:i386 (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:i386 (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.9-5) ... 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:i386 (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:i386 (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:i386 (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:i386 (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:i386 (2:1.15~1) ... Setting up golang-1.15-go (1.15.9-5) ... Setting up libelf1:i386 (0.183-1) ... Setting up libxml2:i386 (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.11.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:i386 (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.11.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-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/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 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 i386 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 10 gopkg.in/gorp.v1 internal/unsafeheader internal/race math/bits unicode/utf8 unicode runtime/internal/atomic sync/atomic runtime/internal/sys internal/cpu internal/testlog math runtime/internal/math internal/bytealg runtime internal/reflectlite sync errors sort internal/oserror io strconv syscall bytes strings reflect regexp/syntax regexp internal/syscall/unix internal/syscall/execenv time internal/fmtsort context internal/poll os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 10 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2021/07/07 16:34:56 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: 16:34:56.922440 drop table if exists "invoice_test"; [] gorptest: 16:34:56.963270 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:56.963436 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:56.963529 drop table if exists "invoice_override_test"; [] gorptest: 16:34:56.963614 drop table if exists "person_test"; [] gorptest: 16:34:56.963747 drop table if exists "ignored_column_test"; [] gorptest: 16:34:56.963888 drop table if exists "id_created_test"; [] gorptest: 16:34:56.964009 drop table if exists "type_conv_test"; [] gorptest: 16:34:56.964118 drop table if exists "embedded_struct_test"; [] gorptest: 16:34:56.964290 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:56.964386 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:34:56.964472 drop table if exists "time_test"; [] gorptest: 16:34:56.964608 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:57.080246 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: 16:34:57.197752 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:34:57.220421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:57.233036 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:34:57.249663 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:57.273316 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:57.292343 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:34:57.327310 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:34:57.362842 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:34:57.397098 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:34:57.418460 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:34:57.473246 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: 16:34:57.473428 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: 16:34:57.473524 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:34:57.473643 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: 16:34:57.473725 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: 16:34:57.473789 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:57.473849 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:57.473911 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:34:57.474011 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:34:57.474098 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:34:57.474167 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: 16:34:57.474314 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:34:57.474402 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 16:34:57.474460 drop table if exists "invoice_test"; [] gorptest: 16:34:57.555113 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:57.634413 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:57.715241 drop table if exists "invoice_override_test"; [] gorptest: 16:34:57.738776 drop table if exists "person_test"; [] gorptest: 16:34:57.743665 drop table if exists "ignored_column_test"; [] gorptest: 16:34:57.749196 drop table if exists "id_created_test"; [] gorptest: 16:34:57.794500 drop table if exists "type_conv_test"; [] gorptest: 16:34:57.847115 drop table if exists "embedded_struct_test"; [] gorptest: 16:34:57.874817 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:57.885347 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:34:57.914658 drop table if exists "time_test"; [] gorptest: 16:34:57.933802 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (1.01s) === RUN TestTruncateTables 2021/07/07 16:34:57 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: 16:34:57.934314 drop table if exists "invoice_test"; [] gorptest: 16:34:57.934760 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:57.934853 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:57.934926 drop table if exists "invoice_override_test"; [] gorptest: 16:34:57.935040 drop table if exists "person_test"; [] gorptest: 16:34:57.935114 drop table if exists "ignored_column_test"; [] gorptest: 16:34:57.935227 drop table if exists "id_created_test"; [] gorptest: 16:34:57.935300 drop table if exists "type_conv_test"; [] gorptest: 16:34:57.935389 drop table if exists "embedded_struct_test"; [] gorptest: 16:34:57.935461 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:57.935541 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:34:57.935641 drop table if exists "time_test"; [] gorptest: 16:34:57.935767 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:57.970593 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: 16:34:57.986110 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:34:57.999730 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:58.023589 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:34:58.030716 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:58.146480 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:58.196541 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:34:58.204621 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:34:58.212233 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:34:58.219158 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:34:58.224952 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:34:58.232238 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: 16:34:58.232397 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: 16:34:58.232468 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:34:58.232542 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: 16:34:58.232614 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: 16:34:58.232677 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:58.232765 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:58.232853 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:34:58.232946 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:34:58.233035 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:34:58.233126 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: 16:34:58.233215 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:34:58.233294 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 16:34:58.233451 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675698233392668 2:1625675698233392668 3:"Bob" 4:"Smith" 5:1] gorptest: 16:34:58.243397 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 16:34:58.250155 delete from "invoice_test"; [] gorptest: 16:34:58.255255 delete from "invoice_tag_test"; [] gorptest: 16:34:58.259324 delete from "alias_trans_field_test"; [] gorptest: 16:34:58.273471 delete from "invoice_override_test"; [] gorptest: 16:34:58.291267 delete from "person_test"; [] gorptest: 16:34:58.330797 delete from "ignored_column_test"; [] gorptest: 16:34:58.347253 delete from "id_created_test"; [] gorptest: 16:34:58.370713 delete from "type_conv_test"; [] gorptest: 16:34:58.396327 delete from "embedded_struct_test"; [] gorptest: 16:34:58.426556 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:58.527157 delete from "embedded_autoincr_test"; [] gorptest: 16:34:58.582277 delete from "time_test"; [] gorptest: 16:34:58.608118 delete from "id_created_test"; [] gorptest: 16:34:58.634133 SELECT * FROM person_test [] gorptest: 16:34:58.634442 SELECT * FROM invoice_test [] gorptest: 16:34:58.634649 drop table if exists "invoice_test"; [] gorptest: 16:34:58.662753 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:58.669404 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:58.679032 drop table if exists "invoice_override_test"; [] gorptest: 16:34:58.686468 drop table if exists "person_test"; [] gorptest: 16:34:58.694465 drop table if exists "ignored_column_test"; [] gorptest: 16:34:58.726650 drop table if exists "id_created_test"; [] gorptest: 16:34:58.734234 drop table if exists "type_conv_test"; [] gorptest: 16:34:58.768106 drop table if exists "embedded_struct_test"; [] gorptest: 16:34:58.782442 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:58.828003 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:34:58.847914 drop table if exists "time_test"; [] gorptest: 16:34:58.884197 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.95s) === RUN TestCustomDateType gorptest: 16:34:58.884465 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 16:34:58.908238 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2021-07-07 16:34:58 +0000 UTC] gorptest: 16:34:59.016811 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 16:34:59.017087 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.15s) === RUN TestUIntPrimaryKey gorptest: 16:34:59.037999 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 16:34:59.054049 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 16:34:59.090548 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 16:34:59.109196 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 16:34:59.142432 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 16:34:59.166964 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 16:34:59.174649 drop table if exists "PersonUInt64"; [] gorptest: 16:34:59.181331 drop table if exists "PersonUInt32"; [] gorptest: 16:34:59.198873 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.16s) === RUN TestSetUniqueTogether gorptest: 16:34:59.203035 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 16:34:59.210170 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 16:34:59.226302 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 16:34:59.226480 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 16:34:59.226601 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 16:34:59.270993 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.08s) === RUN TestPersistentUser gorptest: 16:34:59.278230 drop table if exists PersistentUser [] gorptest: 16:34:59.278791 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 16:34:59.292965 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 16:34:59.306758 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 16:34:59.307037 select * from PersistentUser [] gorptest: 16:34:59.307221 select * from PersistentUser [] gorptest: 16:34:59.307377 select * from PersistentUser [] gorptest: 16:34:59.307529 select Id from PersistentUser [] gorptest: 16:34:59.307654 select mykey from PersistentUser [] gorptest: 16:34:59.307802 select PassedTraining from PersistentUser [] gorptest: 16:34:59.307898 select Id from PersistentUser [] gorptest: 16:34:59.308030 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.04s) === RUN TestNamedQueryMap gorptest: 16:34:59.321735 drop table if exists PersistentUser [] gorptest: 16:34:59.322505 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 16:34:59.328731 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 16:34:59.334120 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 16:34:59.347969 select * from PersistentUser where mykey = ? [1:43] gorptest: 16:34:59.348287 select * from PersistentUser where mykey = ? [1:43] gorptest: 16:34:59.348515 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 16:34:59.348766 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 16:34:59.348967 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.04s) === RUN TestNamedQueryStruct gorptest: 16:34:59.363233 drop table if exists PersistentUser [] gorptest: 16:34:59.363770 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 16:34:59.370906 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 16:34:59.377241 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 16:34:59.382570 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 16:34:59.382947 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.03s) === RUN TestReturnsNonNilSlice 2021/07/07 16:34:59 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: 16:34:59.389376 drop table if exists "invoice_test"; [] gorptest: 16:34:59.389850 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:59.389914 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:59.390002 drop table if exists "invoice_override_test"; [] gorptest: 16:34:59.390123 drop table if exists "person_test"; [] gorptest: 16:34:59.390252 drop table if exists "ignored_column_test"; [] gorptest: 16:34:59.390446 drop table if exists "id_created_test"; [] gorptest: 16:34:59.390556 drop table if exists "type_conv_test"; [] gorptest: 16:34:59.390675 drop table if exists "embedded_struct_test"; [] gorptest: 16:34:59.390783 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:34:59.390909 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:34:59.391015 drop table if exists "time_test"; [] gorptest: 16:34:59.391114 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:59.410803 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: 16:34:59.446411 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:34:59.475471 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:34:59.543197 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:34:59.582588 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:59.634746 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:34:59.738583 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:34:59.806507 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:34:59.831148 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:34:59.838001 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:34:59.851536 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:34:59.858897 select * from invoice_test where id=99999 [] gorptest: 16:34:59.859221 select * from invoice_test where id=99999 [] gorptest: 16:34:59.859458 drop table if exists "invoice_test"; [] gorptest: 16:34:59.868007 drop table if exists "invoice_tag_test"; [] gorptest: 16:34:59.902532 drop table if exists "alias_trans_field_test"; [] gorptest: 16:34:59.938934 drop table if exists "invoice_override_test"; [] gorptest: 16:34:59.946598 drop table if exists "person_test"; [] gorptest: 16:34:59.974560 drop table if exists "ignored_column_test"; [] gorptest: 16:35:00.018311 drop table if exists "id_created_test"; [] gorptest: 16:35:00.126386 drop table if exists "type_conv_test"; [] gorptest: 16:35:00.141876 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:00.155118 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:00.190313 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:00.219997 drop table if exists "time_test"; [] gorptest: 16:35:00.226844 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.84s) === RUN TestOverrideVersionCol gorptest: 16:35:00.227623 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 16:35:00.322849 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: 16:35:00.323281 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.14s) === RUN TestOptimisticLocking 2021/07/07 16:35:00 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: 16:35:00.366758 drop table if exists "invoice_test"; [] gorptest: 16:35:00.367225 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:00.367352 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:00.367445 drop table if exists "invoice_override_test"; [] gorptest: 16:35:00.367533 drop table if exists "person_test"; [] gorptest: 16:35:00.367618 drop table if exists "ignored_column_test"; [] gorptest: 16:35:00.367707 drop table if exists "id_created_test"; [] gorptest: 16:35:00.367790 drop table if exists "type_conv_test"; [] gorptest: 16:35:00.367938 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:00.368036 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:00.368257 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:00.368348 drop table if exists "time_test"; [] gorptest: 16:35:00.368452 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:00.379947 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: 16:35:00.392111 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:00.403973 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:00.409033 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:00.415372 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:00.421714 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:00.428132 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:00.433625 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:00.455734 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:00.464107 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:00.470241 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:00.476165 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675700476112900 2:1625675700476112900 3:"Bob" 4:"Smith" 5:1] gorptest: 16:35:00.481748 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:00.482132 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1625675700476112900 2:1625675700476112900 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 16:35:00.511627 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1625675700476112900 2:1625675700476112900 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 16:35:00.512042 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:00.512505 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 16:35:00.512789 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:00.513093 drop table if exists "invoice_test"; [] gorptest: 16:35:00.521133 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:00.546949 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:00.579049 drop table if exists "invoice_override_test"; [] gorptest: 16:35:00.635128 drop table if exists "person_test"; [] gorptest: 16:35:00.655275 drop table if exists "ignored_column_test"; [] gorptest: 16:35:00.662028 drop table if exists "id_created_test"; [] gorptest: 16:35:00.767429 drop table if exists "type_conv_test"; [] gorptest: 16:35:00.846580 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:00.876191 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:00.955096 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:00.971780 drop table if exists "time_test"; [] gorptest: 16:35:00.983090 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.62s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 16:35:00.983581 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 16:35:00.991355 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 16:35:00.996838 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 16:35:00.997226 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: 16:35:01.034693 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 16:35:01.035535 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.17s) === RUN TestColumnProps gorptest: 16:35:01.157244 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 16:35:01.171060 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 16:35:01.175408 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 16:35:01.175629 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 16:35:01.175799 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 16:35:01.175903 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.06s) === RUN TestRawSelect 2021/07/07 16:35:01 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: 16:35:01.219021 drop table if exists "invoice_test"; [] gorptest: 16:35:01.219381 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:01.219452 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:01.219504 drop table if exists "invoice_override_test"; [] gorptest: 16:35:01.219553 drop table if exists "person_test"; [] gorptest: 16:35:01.219622 drop table if exists "ignored_column_test"; [] gorptest: 16:35:01.219676 drop table if exists "id_created_test"; [] gorptest: 16:35:01.219729 drop table if exists "type_conv_test"; [] gorptest: 16:35:01.219778 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:01.219826 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:01.219892 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:01.219940 drop table if exists "time_test"; [] gorptest: 16:35:01.220003 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:01.231646 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: 16:35:01.258731 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:01.266619 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:01.275498 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:01.291091 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:01.320431 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:01.327320 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:01.333416 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:01.340621 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:01.347021 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:01.364187 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:01.438372 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675701438284561 2:1625675701438284561 3:"bob" 4:"smith" 5:1] gorptest: 16:35:01.459899 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 16:35:01.465670 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 16:35:01.465968 drop table if exists "invoice_test"; [] gorptest: 16:35:01.478985 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:01.539339 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:01.546299 drop table if exists "invoice_override_test"; [] gorptest: 16:35:01.552480 drop table if exists "person_test"; [] gorptest: 16:35:01.583919 drop table if exists "ignored_column_test"; [] gorptest: 16:35:01.622796 drop table if exists "id_created_test"; [] gorptest: 16:35:01.655107 drop table if exists "type_conv_test"; [] gorptest: 16:35:01.684595 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:01.690697 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:01.715156 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:01.731146 drop table if exists "time_test"; [] gorptest: 16:35:01.763455 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.54s) === RUN TestHooks 2021/07/07 16:35:01 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: 16:35:01.764210 drop table if exists "invoice_test"; [] gorptest: 16:35:01.764817 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:01.764957 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:01.765067 drop table if exists "invoice_override_test"; [] gorptest: 16:35:01.765178 drop table if exists "person_test"; [] gorptest: 16:35:01.765295 drop table if exists "ignored_column_test"; [] gorptest: 16:35:01.765433 drop table if exists "id_created_test"; [] gorptest: 16:35:01.765547 drop table if exists "type_conv_test"; [] gorptest: 16:35:01.765705 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:01.765859 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:01.765972 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:01.766089 drop table if exists "time_test"; [] gorptest: 16:35:01.766269 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:01.786503 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: 16:35:01.791085 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:01.795049 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:01.838561 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:01.895885 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:01.908357 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:01.913962 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:01.927204 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:01.966298 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:02.022396 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:02.070466 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:02.125436 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675702125358060 2:1625675702125358060 3:"bob" 4:"smith" 5:1] gorptest: 16:35:02.132564 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:02.132804 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1625675702125358060 2:1625675702125358060 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 16:35:02.143117 select * from person_test where id = ? [1:1] gorptest: 16:35:02.143417 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 16:35:02.175488 drop table if exists "invoice_test"; [] gorptest: 16:35:02.198634 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:02.238821 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:02.306401 drop table if exists "invoice_override_test"; [] gorptest: 16:35:02.368311 drop table if exists "person_test"; [] gorptest: 16:35:02.372836 drop table if exists "ignored_column_test"; [] gorptest: 16:35:02.395033 drop table if exists "id_created_test"; [] gorptest: 16:35:02.423015 drop table if exists "type_conv_test"; [] gorptest: 16:35:02.436488 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:02.444388 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:02.458766 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:02.471968 drop table if exists "time_test"; [] gorptest: 16:35:02.479483 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.72s) === RUN TestTransaction 2021/07/07 16:35:02 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: 16:35:02.480051 drop table if exists "invoice_test"; [] gorptest: 16:35:02.480528 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:02.480647 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:02.480769 drop table if exists "invoice_override_test"; [] gorptest: 16:35:02.480863 drop table if exists "person_test"; [] gorptest: 16:35:02.480982 drop table if exists "ignored_column_test"; [] gorptest: 16:35:02.481150 drop table if exists "id_created_test"; [] gorptest: 16:35:02.481272 drop table if exists "type_conv_test"; [] gorptest: 16:35:02.481416 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:02.481536 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:02.481706 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:02.481848 drop table if exists "time_test"; [] gorptest: 16:35:02.482014 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:02.518853 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: 16:35:02.562892 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:02.602851 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:02.623267 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:02.662773 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:02.698293 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:02.739058 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:02.752273 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:02.770839 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:02.784824 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:02.791461 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:02.797213 begin; [] gorptest: 16:35:02.797330 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 16:35:02.797649 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 16:35:02.797729 commit; [] gorptest: 16:35:02.815021 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:02.815350 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 16:35:02.815491 drop table if exists "invoice_test"; [] gorptest: 16:35:02.828104 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:02.843234 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:02.849238 drop table if exists "invoice_override_test"; [] gorptest: 16:35:02.898526 drop table if exists "person_test"; [] gorptest: 16:35:02.953014 drop table if exists "ignored_column_test"; [] gorptest: 16:35:02.959423 drop table if exists "id_created_test"; [] gorptest: 16:35:03.067801 drop table if exists "type_conv_test"; [] gorptest: 16:35:03.112078 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:03.159447 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:03.172140 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:03.177192 drop table if exists "time_test"; [] gorptest: 16:35:03.184555 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.70s) === RUN TestSavepoint 2021/07/07 16:35:03 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: 16:35:03.185061 drop table if exists "invoice_test"; [] gorptest: 16:35:03.185587 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:03.185721 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:03.185810 drop table if exists "invoice_override_test"; [] gorptest: 16:35:03.185900 drop table if exists "person_test"; [] gorptest: 16:35:03.186031 drop table if exists "ignored_column_test"; [] gorptest: 16:35:03.186116 drop table if exists "id_created_test"; [] gorptest: 16:35:03.186244 drop table if exists "type_conv_test"; [] gorptest: 16:35:03.186376 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:03.186448 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:03.186517 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:03.186624 drop table if exists "time_test"; [] gorptest: 16:35:03.186755 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:03.194111 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: 16:35:03.200975 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:03.247167 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:03.254610 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:03.272376 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:03.276435 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:03.315153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:03.382236 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:03.470457 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:03.486298 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:03.538352 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:03.628062 begin; [] gorptest: 16:35:03.628285 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 16:35:03.628676 select memo from invoice_test [] gorptest: 16:35:03.628848 savepoint "foo" [1:] gorptest: 16:35:03.628918 select memo from invoice_test [] gorptest: 16:35:03.629061 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 16:35:03.629215 select memo from invoice_test [] gorptest: 16:35:03.629325 rollback to savepoint "foo" [1:] gorptest: 16:35:03.629413 select memo from invoice_test [] gorptest: 16:35:03.629515 rollback; [] gorptest: 16:35:03.629788 drop table if exists "invoice_test"; [] gorptest: 16:35:03.639626 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:03.659610 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:03.667913 drop table if exists "invoice_override_test"; [] gorptest: 16:35:03.834405 drop table if exists "person_test"; [] gorptest: 16:35:03.871144 drop table if exists "ignored_column_test"; [] gorptest: 16:35:03.875661 drop table if exists "id_created_test"; [] gorptest: 16:35:03.881457 drop table if exists "type_conv_test"; [] gorptest: 16:35:03.918743 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:04.054417 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:04.198440 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:04.346301 drop table if exists "time_test"; [] gorptest: 16:35:04.430464 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (1.25s) === RUN TestMultiple 2021/07/07 16:35:04 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: 16:35:04.431145 drop table if exists "invoice_test"; [] gorptest: 16:35:04.431705 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:04.431853 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:04.431988 drop table if exists "invoice_override_test"; [] gorptest: 16:35:04.432098 drop table if exists "person_test"; [] gorptest: 16:35:04.432186 drop table if exists "ignored_column_test"; [] gorptest: 16:35:04.432323 drop table if exists "id_created_test"; [] gorptest: 16:35:04.432452 drop table if exists "type_conv_test"; [] gorptest: 16:35:04.432565 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:04.432698 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:04.432815 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:04.432957 drop table if exists "time_test"; [] gorptest: 16:35:04.433076 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:04.538338 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: 16:35:04.646478 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:04.723861 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:04.771217 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:04.810231 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:04.831853 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:04.844115 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:04.859328 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:04.865989 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:04.871040 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:04.875291 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:04.891156 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 16:35:04.905332 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 16:35:04.918779 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 16:35:04.958909 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 16:35:04.975253 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:04.979774 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 16:35:04.985834 drop table if exists "invoice_test"; [] gorptest: 16:35:05.038403 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:05.098380 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:05.142926 drop table if exists "invoice_override_test"; [] gorptest: 16:35:05.170792 drop table if exists "person_test"; [] gorptest: 16:35:05.298940 drop table if exists "ignored_column_test"; [] gorptest: 16:35:05.370807 drop table if exists "id_created_test"; [] gorptest: 16:35:05.426858 drop table if exists "type_conv_test"; [] gorptest: 16:35:05.562833 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:05.626832 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:05.639823 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:05.678360 drop table if exists "time_test"; [] gorptest: 16:35:05.700920 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (1.27s) === RUN TestCrud 2021/07/07 16:35:05 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: 16:35:05.701628 drop table if exists "invoice_test"; [] gorptest: 16:35:05.702309 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:05.702485 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:05.702595 drop table if exists "invoice_override_test"; [] gorptest: 16:35:05.702747 drop table if exists "person_test"; [] gorptest: 16:35:05.702853 drop table if exists "ignored_column_test"; [] gorptest: 16:35:05.703393 drop table if exists "id_created_test"; [] gorptest: 16:35:05.703599 drop table if exists "type_conv_test"; [] gorptest: 16:35:05.703800 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:05.703987 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:05.704138 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:05.704294 drop table if exists "time_test"; [] gorptest: 16:35:05.704457 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:05.783181 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: 16:35:05.789487 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:05.835088 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:05.854787 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:05.861287 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:05.868539 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:05.881198 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:05.922593 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:05.967149 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:06.070535 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:06.174986 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:06.266336 delete from invoice_test [] gorptest: 16:35:06.302310 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 16:35:06.442816 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:06.443476 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: 16:35:06.542447 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:06.542904 select * from invoice_test [] gorptest: 16:35:06.543306 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:06.570998 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 16:35:06.571328 delete from invoice_tag_test [] gorptest: 16:35:06.663075 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: 16:35:06.718504 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 16:35:06.719090 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: 16:35:06.818824 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 16:35:06.819158 select * from invoice_tag_test [] gorptest: 16:35:06.819612 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 16:35:06.827717 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 16:35:06.828119 delete from alias_trans_field_test [] gorptest: 16:35:06.832864 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 16:35:06.840944 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 16:35:06.841300 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 16:35:06.862402 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 16:35:06.862602 select * from alias_trans_field_test [] gorptest: 16:35:06.862765 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 16:35:06.903144 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 16:35:06.903561 drop table if exists "invoice_test"; [] gorptest: 16:35:06.962326 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:06.975237 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:07.046299 drop table if exists "invoice_override_test"; [] gorptest: 16:35:07.110399 drop table if exists "person_test"; [] gorptest: 16:35:07.175277 drop table if exists "ignored_column_test"; [] gorptest: 16:35:07.242278 drop table if exists "id_created_test"; [] gorptest: 16:35:07.255454 drop table if exists "type_conv_test"; [] gorptest: 16:35:07.291563 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:07.306618 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:07.320609 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:07.350192 drop table if exists "time_test"; [] gorptest: 16:35:07.379203 drop table if exists "id_created_test"; [] --- PASS: TestCrud (1.68s) === RUN TestWithIgnoredColumn 2021/07/07 16:35:07 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: 16:35:07.379993 drop table if exists "invoice_test"; [] gorptest: 16:35:07.380601 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:07.380757 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:07.380935 drop table if exists "invoice_override_test"; [] gorptest: 16:35:07.381057 drop table if exists "person_test"; [] gorptest: 16:35:07.381175 drop table if exists "ignored_column_test"; [] gorptest: 16:35:07.381303 drop table if exists "id_created_test"; [] gorptest: 16:35:07.381446 drop table if exists "type_conv_test"; [] gorptest: 16:35:07.381561 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:07.381847 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:07.381960 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:07.382072 drop table if exists "time_test"; [] gorptest: 16:35:07.382235 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:07.418971 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: 16:35:07.526246 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:07.630200 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:07.674544 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:07.703236 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:07.814745 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:07.822809 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:07.858492 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:07.959278 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:07.995201 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:08.042642 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:08.079213 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 16:35:08.107442 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 16:35:08.107861 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 16:35:08.119200 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 16:35:08.119438 drop table if exists "invoice_test"; [] gorptest: 16:35:08.124295 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:08.135127 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:08.141470 drop table if exists "invoice_override_test"; [] gorptest: 16:35:08.154750 drop table if exists "person_test"; [] gorptest: 16:35:08.167578 drop table if exists "ignored_column_test"; [] gorptest: 16:35:08.172579 drop table if exists "id_created_test"; [] gorptest: 16:35:08.186916 drop table if exists "type_conv_test"; [] gorptest: 16:35:08.209330 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:08.247399 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:08.275924 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:08.327575 drop table if exists "time_test"; [] gorptest: 16:35:08.362576 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.98s) === RUN TestTypeConversionExample 2021/07/07 16:35:08 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: 16:35:08.363279 drop table if exists "invoice_test"; [] gorptest: 16:35:08.363941 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:08.364081 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:08.364214 drop table if exists "invoice_override_test"; [] gorptest: 16:35:08.364302 drop table if exists "person_test"; [] gorptest: 16:35:08.364414 drop table if exists "ignored_column_test"; [] gorptest: 16:35:08.364547 drop table if exists "id_created_test"; [] gorptest: 16:35:08.364683 drop table if exists "type_conv_test"; [] gorptest: 16:35:08.364775 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:08.364885 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:08.365025 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:08.365114 drop table if exists "time_test"; [] gorptest: 16:35:08.365259 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:08.373425 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: 16:35:08.410662 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:08.439636 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:08.482579 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:08.539344 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:08.616362 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:08.651153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:08.686623 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:08.699033 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:08.755015 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:08.818380 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:08.926560 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: 16:35:08.963230 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 16:35:08.963699 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: 16:35:08.970923 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 16:35:08.971179 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 16:35:08.975021 drop table if exists "invoice_test"; [] gorptest: 16:35:08.995426 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:09.022907 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:09.158520 drop table if exists "invoice_override_test"; [] gorptest: 16:35:09.166415 drop table if exists "person_test"; [] gorptest: 16:35:09.173297 drop table if exists "ignored_column_test"; [] gorptest: 16:35:09.214615 drop table if exists "id_created_test"; [] gorptest: 16:35:09.298582 drop table if exists "type_conv_test"; [] gorptest: 16:35:09.351353 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:09.386444 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:09.433522 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:09.486231 drop table if exists "time_test"; [] gorptest: 16:35:09.550693 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (1.19s) === RUN TestWithEmbeddedStruct 2021/07/07 16:35:09 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: 16:35:09.551293 drop table if exists "invoice_test"; [] gorptest: 16:35:09.551842 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:09.551970 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:09.552083 drop table if exists "invoice_override_test"; [] gorptest: 16:35:09.552193 drop table if exists "person_test"; [] gorptest: 16:35:09.552325 drop table if exists "ignored_column_test"; [] gorptest: 16:35:09.552481 drop table if exists "id_created_test"; [] gorptest: 16:35:09.552618 drop table if exists "type_conv_test"; [] gorptest: 16:35:09.552730 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:09.552867 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:09.552976 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:09.553081 drop table if exists "time_test"; [] gorptest: 16:35:09.553215 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:09.596972 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: 16:35:09.614891 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:09.620109 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:09.670302 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:09.715193 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:09.721677 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:09.746715 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:09.755210 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:09.775811 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:09.807614 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:09.838638 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:09.846497 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 16:35:09.866658 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 16:35:09.866895 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 16:35:09.879460 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 16:35:09.879715 select * from embedded_struct_test [] gorptest: 16:35:09.879963 drop table if exists "invoice_test"; [] gorptest: 16:35:09.886451 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:09.892074 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:09.898093 drop table if exists "invoice_override_test"; [] gorptest: 16:35:09.902631 drop table if exists "person_test"; [] gorptest: 16:35:09.914963 drop table if exists "ignored_column_test"; [] gorptest: 16:35:09.920151 drop table if exists "id_created_test"; [] gorptest: 16:35:09.925676 drop table if exists "type_conv_test"; [] gorptest: 16:35:09.970733 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:09.976475 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.011143 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.019046 drop table if exists "time_test"; [] gorptest: 16:35:10.025243 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.47s) === RUN TestWithEmbeddedStructBeforeAutoincr 2021/07/07 16:35:10 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: 16:35:10.025693 drop table if exists "invoice_test"; [] gorptest: 16:35:10.026039 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:10.026132 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:10.026191 drop table if exists "invoice_override_test"; [] gorptest: 16:35:10.026295 drop table if exists "person_test"; [] gorptest: 16:35:10.026349 drop table if exists "ignored_column_test"; [] gorptest: 16:35:10.026445 drop table if exists "id_created_test"; [] gorptest: 16:35:10.026514 drop table if exists "type_conv_test"; [] gorptest: 16:35:10.026618 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:10.026671 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.026756 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.026823 drop table if exists "time_test"; [] gorptest: 16:35:10.026911 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.040104 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: 16:35:10.131425 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:10.137473 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.141660 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:10.159341 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:10.194916 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:10.222732 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:10.235832 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:10.243574 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:10.285322 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:10.292505 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:10.305503 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 16:35:10.321731 drop table if exists "invoice_test"; [] gorptest: 16:35:10.339522 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:10.350727 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:10.374352 drop table if exists "invoice_override_test"; [] gorptest: 16:35:10.386818 drop table if exists "person_test"; [] gorptest: 16:35:10.396375 drop table if exists "ignored_column_test"; [] gorptest: 16:35:10.403019 drop table if exists "id_created_test"; [] gorptest: 16:35:10.408585 drop table if exists "type_conv_test"; [] gorptest: 16:35:10.413816 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:10.427421 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.439145 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.457190 drop table if exists "time_test"; [] gorptest: 16:35:10.483738 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.46s) === RUN TestWithEmbeddedAutoincr 2021/07/07 16:35:10 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: 16:35:10.484274 drop table if exists "invoice_test"; [] gorptest: 16:35:10.484730 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:10.484789 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:10.484854 drop table if exists "invoice_override_test"; [] gorptest: 16:35:10.484910 drop table if exists "person_test"; [] gorptest: 16:35:10.484965 drop table if exists "ignored_column_test"; [] gorptest: 16:35:10.485020 drop table if exists "id_created_test"; [] gorptest: 16:35:10.485074 drop table if exists "type_conv_test"; [] gorptest: 16:35:10.485128 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:10.485182 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.485255 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.485313 drop table if exists "time_test"; [] gorptest: 16:35:10.485388 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.496001 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: 16:35:10.504612 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:10.511319 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.527600 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:10.535131 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:10.540868 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:10.546919 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:10.559924 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:10.566809 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:10.571058 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:10.626569 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:10.630649 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 16:35:10.637344 drop table if exists "invoice_test"; [] gorptest: 16:35:10.646926 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:10.659574 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:10.665965 drop table if exists "invoice_override_test"; [] gorptest: 16:35:10.690747 drop table if exists "person_test"; [] gorptest: 16:35:10.704032 drop table if exists "ignored_column_test"; [] gorptest: 16:35:10.715652 drop table if exists "id_created_test"; [] gorptest: 16:35:10.738782 drop table if exists "type_conv_test"; [] gorptest: 16:35:10.756063 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:10.762205 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.799455 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.805298 drop table if exists "time_test"; [] gorptest: 16:35:10.850624 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.37s) === RUN TestSelectVal gorptest: 16:35:10.851243 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 16:35:10.870861 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: 16:35:10.877204 select Int64 from TableWithNull where Str='abc' [] gorptest: 16:35:10.877425 select count(*) from TableWithNull [] gorptest: 16:35:10.877627 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 16:35:10.877790 select Int64 from TableWithNull where Str='notfound' [] gorptest: 16:35:10.877920 select Int64 from TableWithNull where Str='abc' [] gorptest: 16:35:10.878076 select Float64 from TableWithNull where Str='abc' [] gorptest: 16:35:10.878193 select min(Float64) from TableWithNull [] gorptest: 16:35:10.878338 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 16:35:10.878492 select Float64 from TableWithNull where Str='notfound' [] gorptest: 16:35:10.878628 select Float64 from TableWithNull where Str='abc' [] gorptest: 16:35:10.878749 select Str from TableWithNull where Int64=? [1:78] gorptest: 16:35:10.878862 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 16:35:10.878972 select Str from TableWithNull where Int64=? [1:78] gorptest: 16:35:10.879084 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 16:35:10.879213 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 16:35:10.879333 select Str from TableWithNull where Int64=? [1:78] gorptest: 16:35:10.879452 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.05s) === RUN TestVersionMultipleRows 2021/07/07 16:35:10 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: 16:35:10.899632 drop table if exists "invoice_test"; [] gorptest: 16:35:10.900187 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:10.900320 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:10.900437 drop table if exists "invoice_override_test"; [] gorptest: 16:35:10.900543 drop table if exists "person_test"; [] gorptest: 16:35:10.900666 drop table if exists "ignored_column_test"; [] gorptest: 16:35:10.900805 drop table if exists "id_created_test"; [] gorptest: 16:35:10.900965 drop table if exists "type_conv_test"; [] gorptest: 16:35:10.901103 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:10.901226 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:10.901364 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:10.901487 drop table if exists "time_test"; [] gorptest: 16:35:10.901687 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.906188 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: 16:35:10.946406 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:10.970988 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:10.977947 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:10.984086 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:11.022148 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:11.029150 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:11.033482 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:11.119696 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:11.162411 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:11.242426 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:11.346537 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675711346450107 2:1625675711346450107 3:"Bob" 4:"Smith" 5:1] gorptest: 16:35:11.387409 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675711387313039 2:1625675711387313039 3:"Jane" 4:"Smith" 5:1] gorptest: 16:35:11.399497 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675711399454266 2:1625675711399454266 3:"Mike" 4:"Smith" 5:1] gorptest: 16:35:11.403590 drop table if exists "invoice_test"; [] gorptest: 16:35:11.415352 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:11.421427 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:11.428942 drop table if exists "invoice_override_test"; [] gorptest: 16:35:11.470325 drop table if exists "person_test"; [] gorptest: 16:35:11.615549 drop table if exists "ignored_column_test"; [] gorptest: 16:35:11.754322 drop table if exists "id_created_test"; [] gorptest: 16:35:11.890355 drop table if exists "type_conv_test"; [] gorptest: 16:35:11.921368 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:11.951429 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:11.957490 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:11.970684 drop table if exists "time_test"; [] gorptest: 16:35:11.977311 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (1.08s) === RUN TestWithStringPk gorptest: 16:35:11.977548 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 16:35:11.984437 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 16:35:11.988031 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.03s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2021/07/07 16:35:12 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: 16:35:12.011403 drop table if exists "invoice_test"; [] gorptest: 16:35:12.011754 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:12.011820 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:12.011905 drop table if exists "invoice_override_test"; [] gorptest: 16:35:12.011953 drop table if exists "person_test"; [] gorptest: 16:35:12.012016 drop table if exists "ignored_column_test"; [] gorptest: 16:35:12.012065 drop table if exists "id_created_test"; [] gorptest: 16:35:12.012130 drop table if exists "type_conv_test"; [] gorptest: 16:35:12.012179 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:12.012230 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:12.012279 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:12.012339 drop table if exists "time_test"; [] gorptest: 16:35:12.012457 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:12.017143 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: 16:35:12.039386 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:12.051082 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:12.074969 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:12.130365 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:12.242335 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:12.290268 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:12.371299 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:12.394678 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:12.475221 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:12.488180 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:12.522687 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-07 16:04:12.522604861 +0000 UTC] gorptest: 16:35:12.535538 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-07 16:05:13.522604861 +0000 UTC] gorptest: 16:35:12.550886 SELECT id FROM time_test WHERE Time < ? [1:2021-07-07 16:05:12.522604861 +0000 UTC] gorptest: 16:35:12.551172 drop table if exists "invoice_test"; [] gorptest: 16:35:12.558710 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:12.579900 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:12.586802 drop table if exists "invoice_override_test"; [] gorptest: 16:35:12.593651 drop table if exists "person_test"; [] gorptest: 16:35:12.607097 drop table if exists "ignored_column_test"; [] gorptest: 16:35:12.619249 drop table if exists "id_created_test"; [] gorptest: 16:35:12.654697 drop table if exists "type_conv_test"; [] gorptest: 16:35:12.667453 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:12.671954 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:12.678777 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:12.714768 drop table if exists "time_test"; [] gorptest: 16:35:12.727092 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.72s) === RUN TestInvoicePersonView 2021/07/07 16:35:12 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: 16:35:12.727667 drop table if exists "invoice_test"; [] gorptest: 16:35:12.728157 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:12.728250 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:12.728365 drop table if exists "invoice_override_test"; [] gorptest: 16:35:12.728464 drop table if exists "person_test"; [] gorptest: 16:35:12.728605 drop table if exists "ignored_column_test"; [] gorptest: 16:35:12.728750 drop table if exists "id_created_test"; [] gorptest: 16:35:12.728894 drop table if exists "type_conv_test"; [] gorptest: 16:35:12.729034 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:12.729178 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:12.729327 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:12.729457 drop table if exists "time_test"; [] gorptest: 16:35:12.729610 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:12.747844 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: 16:35:12.792273 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:12.834814 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:12.950382 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:13.010388 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:13.017664 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:13.031352 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:13.058950 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:13.075140 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:13.081427 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:13.090064 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:13.095641 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675713095584423 2:1625675713095584423 3:"bob" 4:"smith" 5:1] gorptest: 16:35:13.130330 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 16:35:13.170363 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 16:35:13.170867 drop table if exists "invoice_test"; [] gorptest: 16:35:13.318321 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:13.423420 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:13.441287 drop table if exists "invoice_override_test"; [] gorptest: 16:35:13.459743 drop table if exists "person_test"; [] gorptest: 16:35:13.494776 drop table if exists "ignored_column_test"; [] gorptest: 16:35:13.501785 drop table if exists "id_created_test"; [] gorptest: 16:35:13.511820 drop table if exists "type_conv_test"; [] gorptest: 16:35:13.521865 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:13.528227 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:13.535263 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:13.539527 drop table if exists "time_test"; [] gorptest: 16:35:13.545663 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.82s) === RUN TestQuoteTableNames 2021/07/07 16:35:13 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: 16:35:13.547059 drop table if exists "invoice_test"; [] gorptest: 16:35:13.547487 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:13.547566 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:13.547624 drop table if exists "invoice_override_test"; [] gorptest: 16:35:13.547680 drop table if exists "person_test"; [] gorptest: 16:35:13.547751 drop table if exists "ignored_column_test"; [] gorptest: 16:35:13.547846 drop table if exists "id_created_test"; [] gorptest: 16:35:13.547942 drop table if exists "type_conv_test"; [] gorptest: 16:35:13.550528 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:13.550605 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:13.550671 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:13.550733 drop table if exists "time_test"; [] gorptest: 16:35:13.550826 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:13.556081 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: 16:35:13.566804 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:13.573801 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:13.607670 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:13.614266 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:13.625980 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:13.631344 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:13.635176 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:13.646789 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:13.667493 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:13.695935 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.72s) === RUN TestSelectTooManyCols 2021/07/07 16:35:14 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: 16:35:14.264015 drop table if exists "invoice_test"; [] gorptest: 16:35:14.264501 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:14.264613 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:14.264707 drop table if exists "invoice_override_test"; [] gorptest: 16:35:14.264790 drop table if exists "person_test"; [] gorptest: 16:35:14.264886 drop table if exists "ignored_column_test"; [] gorptest: 16:35:14.264984 drop table if exists "id_created_test"; [] gorptest: 16:35:14.265066 drop table if exists "type_conv_test"; [] gorptest: 16:35:14.265168 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:14.265246 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:14.265328 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:14.265428 drop table if exists "time_test"; [] gorptest: 16:35:14.265530 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:14.283428 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: 16:35:14.287396 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:14.292700 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:14.299746 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:14.306720 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:14.319411 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:14.352380 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:14.390375 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:14.494418 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:14.535352 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:14.567457 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:14.574516 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675714574468781 2:1625675714574468781 3:"bob" 4:"smith" 5:1] gorptest: 16:35:14.614369 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675714614310998 2:1625675714614310998 3:"jane" 4:"doe" 5:1] gorptest: 16:35:14.731265 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:14.731602 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 16:35:14.731967 select * from person_test where Id=? [1:1] gorptest: 16:35:14.732261 select * from person_test order by fname asc [] gorptest: 16:35:14.732693 drop table if exists "invoice_test"; [] gorptest: 16:35:14.766391 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:14.802433 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:14.826357 drop table if exists "invoice_override_test"; [] gorptest: 16:35:14.834734 drop table if exists "person_test"; [] gorptest: 16:35:14.885760 drop table if exists "ignored_column_test"; [] gorptest: 16:35:14.929142 drop table if exists "id_created_test"; [] gorptest: 16:35:14.944054 drop table if exists "type_conv_test"; [] gorptest: 16:35:14.952256 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:14.960063 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:14.968037 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:14.989280 drop table if exists "time_test"; [] gorptest: 16:35:15.003741 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.74s) === RUN TestSelectSingleVal 2021/07/07 16:35:15 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: 16:35:15.004268 drop table if exists "invoice_test"; [] gorptest: 16:35:15.004759 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:15.004892 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:15.004967 drop table if exists "invoice_override_test"; [] gorptest: 16:35:15.005080 drop table if exists "person_test"; [] gorptest: 16:35:15.005152 drop table if exists "ignored_column_test"; [] gorptest: 16:35:15.005242 drop table if exists "id_created_test"; [] gorptest: 16:35:15.005333 drop table if exists "type_conv_test"; [] gorptest: 16:35:15.005460 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:15.005529 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:15.005639 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:15.005750 drop table if exists "time_test"; [] gorptest: 16:35:15.005939 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:15.018028 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: 16:35:15.021894 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:15.027511 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:15.055659 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:15.067882 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:15.083542 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:15.099088 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:15.105725 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:15.135022 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:15.148335 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:15.156912 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:15.202956 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675715202840980 2:1625675715202840980 3:"bob" 4:"smith" 5:1] gorptest: 16:35:15.266866 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 16:35:15.267331 select * from person_test where Id=? [1:1] gorptest: 16:35:15.267637 select FName from person_test where Id=? [1:1] gorptest: 16:35:15.267820 select * from person_test where Id=? [1:1] gorptest: 16:35:15.268111 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 16:35:15.268353 select * from person_test where Id=? [1:-2222] gorptest: 16:35:15.268593 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1625675715268557115 2:1625675715268557115 3:"bob" 4:"smith" 5:1] gorptest: 16:35:15.280630 select * from person_test where Fname='bob' [] gorptest: 16:35:15.281123 select * from person_test where Id=-123 [] gorptest: 16:35:15.281344 select * from person_test where Id=-123 [] gorptest: 16:35:15.281525 select * from person_test where Id=-123 [] gorptest: 16:35:15.281754 select * from person_test where Id=-123 [] gorptest: 16:35:15.281947 drop table if exists "invoice_test"; [] gorptest: 16:35:15.302628 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:15.315042 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:15.327183 drop table if exists "invoice_override_test"; [] gorptest: 16:35:15.341645 drop table if exists "person_test"; [] gorptest: 16:35:15.345853 drop table if exists "ignored_column_test"; [] gorptest: 16:35:15.352890 drop table if exists "id_created_test"; [] gorptest: 16:35:15.356586 drop table if exists "type_conv_test"; [] gorptest: 16:35:15.370977 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:15.378513 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:15.384764 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:15.414867 drop table if exists "time_test"; [] gorptest: 16:35:15.435770 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.43s) === RUN TestSelectAlias 2021/07/07 16:35:15 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: 16:35:15.436244 drop table if exists "invoice_test"; [] gorptest: 16:35:15.436667 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:15.436761 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:15.436829 drop table if exists "invoice_override_test"; [] gorptest: 16:35:15.436936 drop table if exists "person_test"; [] gorptest: 16:35:15.437029 drop table if exists "ignored_column_test"; [] gorptest: 16:35:15.437119 drop table if exists "id_created_test"; [] gorptest: 16:35:15.437190 drop table if exists "type_conv_test"; [] gorptest: 16:35:15.437277 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:15.437346 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:15.437431 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:15.437532 drop table if exists "time_test"; [] gorptest: 16:35:15.437666 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:15.466863 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: 16:35:15.507510 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:15.551574 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:15.556511 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:15.562994 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:15.567564 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:15.575001 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:15.580776 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:15.585641 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:15.590883 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:15.594019 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:15.599140 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 16:35:15.610579 select * from id_created_test where Id=1 [] gorptest: 16:35:15.610845 SELECT *, 1 AS external FROM id_created_test [] gorptest: 16:35:15.611064 drop table if exists "invoice_test"; [] gorptest: 16:35:15.618455 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:15.695722 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:15.701084 drop table if exists "invoice_override_test"; [] gorptest: 16:35:15.707674 drop table if exists "person_test"; [] gorptest: 16:35:15.714081 drop table if exists "ignored_column_test"; [] gorptest: 16:35:15.736202 drop table if exists "id_created_test"; [] gorptest: 16:35:15.742488 drop table if exists "type_conv_test"; [] gorptest: 16:35:15.747913 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:15.754930 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:15.761186 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:15.802309 drop table if exists "time_test"; [] gorptest: 16:35:15.938327 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.50s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2021/07/07 16:35:15 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: 16:35:15.939105 drop table if exists "invoice_test"; [] gorptest: 16:35:15.939741 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:15.939864 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:15.940015 drop table if exists "invoice_override_test"; [] gorptest: 16:35:15.940170 drop table if exists "person_test"; [] gorptest: 16:35:15.940288 drop table if exists "ignored_column_test"; [] gorptest: 16:35:15.940401 drop table if exists "id_created_test"; [] gorptest: 16:35:15.940537 drop table if exists "type_conv_test"; [] gorptest: 16:35:15.940647 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:15.940757 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:15.940867 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:15.940976 drop table if exists "time_test"; [] gorptest: 16:35:15.941153 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:16.019473 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: 16:35:16.027709 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:16.062272 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:16.127098 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:16.154962 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:16.161695 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:16.202829 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:16.208032 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:16.246471 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:16.275212 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:16.314447 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:16.377056 drop table if exists "invoice_test"; [] gorptest: 16:35:16.384128 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:16.391428 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:16.398460 drop table if exists "invoice_override_test"; [] gorptest: 16:35:16.404170 drop table if exists "person_test"; [] gorptest: 16:35:16.434511 drop table if exists "ignored_column_test"; [] gorptest: 16:35:16.526305 drop table if exists "id_created_test"; [] gorptest: 16:35:16.538564 drop table if exists "type_conv_test"; [] gorptest: 16:35:16.582238 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:16.607308 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:16.634455 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:16.638913 drop table if exists "time_test"; [] gorptest: 16:35:16.651144 drop table if exists "id_created_test"; [] gorptest: 16:35:16.651367 drop table if exists "single_column_table"; [] gorptest: 16:35:16.651505 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: 16:35:16.686406 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: 16:35:16.722201 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:16.795363 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: 16:35:16.876284 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: 16:35:16.884176 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:16.918313 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:16.978315 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:17.007125 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:17.047221 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:17.054460 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: 16:35:17.162372 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:17.262452 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 16:35:17.262693 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 16:35:17.328696 delete from "invoice_test"; [] gorptest: 16:35:17.358362 delete from "invoice_tag_test"; [] gorptest: 16:35:17.466341 delete from "alias_trans_field_test"; [] gorptest: 16:35:17.570221 delete from "invoice_override_test"; [] gorptest: 16:35:17.670392 delete from "person_test"; [] gorptest: 16:35:17.770281 delete from "ignored_column_test"; [] gorptest: 16:35:17.870406 delete from "id_created_test"; [] gorptest: 16:35:17.952039 delete from "type_conv_test"; [] gorptest: 16:35:17.978301 delete from "embedded_struct_test"; [] gorptest: 16:35:18.056175 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:18.086203 delete from "embedded_autoincr_test"; [] gorptest: 16:35:18.146443 delete from "time_test"; [] gorptest: 16:35:18.246258 delete from "id_created_test"; [] gorptest: 16:35:18.346356 delete from "single_column_table"; [] gorptest: 16:35:18.463307 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 16:35:18.463763 drop table if exists "invoice_test"; [] gorptest: 16:35:18.490410 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:18.626387 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:18.742408 drop table if exists "invoice_override_test"; [] gorptest: 16:35:18.922639 drop table if exists "person_test"; [] gorptest: 16:35:18.960761 drop table if exists "ignored_column_test"; [] gorptest: 16:35:18.968952 drop table if exists "id_created_test"; [] gorptest: 16:35:18.990853 drop table if exists "type_conv_test"; [] gorptest: 16:35:19.026380 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:19.055658 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:19.090293 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:19.168113 drop table if exists "time_test"; [] gorptest: 16:35:19.190984 drop table if exists "id_created_test"; [] gorptest: 16:35:19.191153 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (3.29s) === RUN TestPrepare 2021/07/07 16:35:19 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: 16:35:19.229348 drop table if exists "invoice_test"; [] gorptest: 16:35:19.230025 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:19.230188 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:19.230335 drop table if exists "invoice_override_test"; [] gorptest: 16:35:19.230462 drop table if exists "person_test"; [] gorptest: 16:35:19.230631 drop table if exists "ignored_column_test"; [] gorptest: 16:35:19.230792 drop table if exists "id_created_test"; [] gorptest: 16:35:19.230938 drop table if exists "type_conv_test"; [] gorptest: 16:35:19.231084 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:19.231231 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:19.231380 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:19.231553 drop table if exists "time_test"; [] gorptest: 16:35:19.231739 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:19.258985 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: 16:35:19.286735 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 16:35:19.307051 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 16:35:19.418415 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 16:35:19.530352 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:19.638363 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 16:35:19.710403 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 16:35:19.770682 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 16:35:19.791126 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 16:35:19.834298 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 16:35:19.886353 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 16:35:19.938437 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 16:35:19.958787 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 16:35:19.971775 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 16:35:19.975650 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 16:35:19.976045 begin; [] gorptest: 16:35:19.976094 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 16:35:19.976437 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 16:35:19.977212 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 16:35:19.977489 commit; [] gorptest: 16:35:19.983611 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 16:35:19.984002 drop table if exists "invoice_test"; [] gorptest: 16:35:19.990044 drop table if exists "invoice_tag_test"; [] gorptest: 16:35:20.001622 drop table if exists "alias_trans_field_test"; [] gorptest: 16:35:20.007240 drop table if exists "invoice_override_test"; [] gorptest: 16:35:20.023527 drop table if exists "person_test"; [] gorptest: 16:35:20.028003 drop table if exists "ignored_column_test"; [] gorptest: 16:35:20.039015 drop table if exists "id_created_test"; [] gorptest: 16:35:20.043244 drop table if exists "type_conv_test"; [] gorptest: 16:35:20.049619 drop table if exists "embedded_struct_test"; [] gorptest: 16:35:20.055315 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 16:35:20.068130 drop table if exists "embedded_autoincr_test"; [] gorptest: 16:35:20.102242 drop table if exists "time_test"; [] gorptest: 16:35:20.166333 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.94s) PASS ok gopkg.in/gorp.v1 23.270s 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_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) 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/20348 and its subdirectories I: Current time: Wed Jul 7 04:35:34 -12 2021 I: pbuilder-time-stamp: 1625675734 Wed Jul 7 16:35:36 UTC 2021 I: 1st build successful. Starting 2nd build on remote node ionos16-i386.debian.net. Wed Jul 7 16:35:36 UTC 2021 I: Preparing to do remote build '2' on ionos16-i386.debian.net. Wed Jul 7 16:36:30 UTC 2021 I: Deleting $TMPDIR on ionos16-i386.debian.net. Wed Jul 7 16:36:31 UTC 2021 I: golang-gopkg-gorp.v1_1.7.2-2_i386.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 32d6e6ed8d7b9109558c3c9ee91f92d90125d952 5257 golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 783034752b89aa9c08000ce9538c6e5dd440dc3f558f2ae1bbdbb831a36038b1 5257 golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb adc48bcad8e1c933f246f684f08806a8 5257 devel optional golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo Wed Jul 7 16:36:32 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.gtGSnlgoHt/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/b1/golang-gopkg-gorp.v1_1.7.2-2_i386.changes /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/b2/golang-gopkg-gorp.v1_1.7.2-2_i386.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.324s) 0.324s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.021s) 0.020s 10 calls diffoscope.comparators.binary.FilesystemFile 0.000s 8 calls abc.DotChangesFile Wed Jul 7 16:36:34 UTC 2021 I: diffoscope 177 found no differences in the changes files, and a .buildinfo file also exists. Wed Jul 7 16:36:34 UTC 2021 I: golang-gopkg-gorp.v1 from bullseye built successfully and reproducibly on i386. Wed Jul 7 16:36:35 UTC 2021 I: Submitting .buildinfo files to external archives: Wed Jul 7 16:36:35 UTC 2021 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo.asc Wed Jul 7 16:36:35 UTC 2021 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo.asc Wed Jul 7 16:36:37 UTC 2021 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Wed Jul 7 16:36:37 UTC 2021 I: Done submitting .buildinfo files. Wed Jul 7 16:36:37 UTC 2021 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo.asc'