I: pbuilder: network access will be disabled during build I: Current time: Wed Jan 19 14:28:22 +14 2022 I: pbuilder-time-stamp: 1642552102 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.7vZhrPrk/trustedkeys.kbx': General error gpgv: Signature made Mon Apr 20 04:59:56 2020 +14 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/550690/tmp/hooks/D01_modify_environment starting debug: Running on ionos11-amd64. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash Removing 'diversion of /bin/sh to /bin/sh.distrib by dash' Adding 'diversion of /bin/sh to /bin/sh.distrib by bash' Removing 'diversion of /usr/share/man/man1/sh.1.gz to /usr/share/man/man1/sh.distrib.1.gz by dash' Adding 'diversion of /usr/share/man/man1/sh.1.gz to /usr/share/man/man1/sh.distrib.1.gz by bash' I: Setting pbuilder2's login shell to /bin/bash I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other I: user script /srv/workspace/pbuilder/550690/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/550690/tmp/hooks/D02_print_environment starting I: set BASH=/bin/sh BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:hostcomplete:interactive_comments:progcomp:promptvars:sourcepath BASH_ALIASES=() BASH_ARGC=() BASH_ARGV=() BASH_CMDS=() BASH_LINENO=([0]="12" [1]="0") BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") BASH_VERSINFO=([0]="5" [1]="1" [2]="4" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") BASH_VERSION='5.1.4(1)-release' BUILDDIR=/build BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' BUILDUSERNAME=pbuilder2 BUILD_ARCH=amd64 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=15' DIRSTACK=() DISTRIBUTION= EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=x86_64 HOST_ARCH=amd64 IFS=' ' INVOCATION_ID=dc754ee3547042c99b0df68ac92251cf LANG=C LANGUAGE=et_EE:et LC_ALL=C MACHTYPE=x86_64-pc-linux-gnu MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnu PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path PBCURRENTCOMMANDLINEOPERATION=build PBUILDER_OPERATION=build PBUILDER_PKGDATADIR=/usr/share/pbuilder PBUILDER_PKGLIBDIR=/usr/lib/pbuilder PBUILDER_SYSCONFDIR=/etc PIPESTATUS=([0]="0") POSIXLY_CORRECT=y PPID=550690 PS4='+ ' PWD=/ SHELL=/bin/bash SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix SHLVL=3 SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/pbuilderrc_j876 --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=111 SUDO_UID=106 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://78.137.99.97:3128 I: uname -a Linux i-capture-the-hostname 5.10.0-10-amd64 #1 SMP Debian 5.10.84-1 (2021-12-08) x86_64 GNU/Linux I: ls -l /bin total 5476 -rwxr-xr-x 1 root root 1234376 Aug 5 10:25 bash -rwxr-xr-x 3 root root 38984 Jul 21 2020 bunzip2 -rwxr-xr-x 3 root root 38984 Jul 21 2020 bzcat lrwxrwxrwx 1 root root 6 Jul 21 2020 bzcmp -> bzdiff -rwxr-xr-x 1 root root 2225 Jul 21 2020 bzdiff lrwxrwxrwx 1 root root 6 Jul 21 2020 bzegrep -> bzgrep -rwxr-xr-x 1 root root 4877 Sep 5 2019 bzexe lrwxrwxrwx 1 root root 6 Jul 21 2020 bzfgrep -> bzgrep -rwxr-xr-x 1 root root 3775 Jul 21 2020 bzgrep -rwxr-xr-x 3 root root 38984 Jul 21 2020 bzip2 -rwxr-xr-x 1 root root 18424 Jul 21 2020 bzip2recover lrwxrwxrwx 1 root root 6 Jul 21 2020 bzless -> bzmore -rwxr-xr-x 1 root root 1297 Jul 21 2020 bzmore -rwxr-xr-x 1 root root 43936 Sep 24 2020 cat -rwxr-xr-x 1 root root 72672 Sep 24 2020 chgrp -rwxr-xr-x 1 root root 64448 Sep 24 2020 chmod -rwxr-xr-x 1 root root 72672 Sep 24 2020 chown -rwxr-xr-x 1 root root 151168 Sep 24 2020 cp -rwxr-xr-x 1 root root 125560 Dec 11 2020 dash -rwxr-xr-x 1 root root 113664 Sep 24 2020 date -rwxr-xr-x 1 root root 80968 Sep 24 2020 dd -rwxr-xr-x 1 root root 93936 Sep 24 2020 df -rwxr-xr-x 1 root root 147176 Sep 24 2020 dir -rwxr-xr-x 1 root root 84440 Jul 29 09:09 dmesg lrwxrwxrwx 1 root root 8 Nov 8 2019 dnsdomainname -> hostname lrwxrwxrwx 1 root root 8 Nov 8 2019 domainname -> hostname -rwxr-xr-x 1 root root 39712 Sep 24 2020 echo -rwxr-xr-x 1 root root 28 Nov 10 2020 egrep -rwxr-xr-x 1 root root 39680 Sep 24 2020 false -rwxr-xr-x 1 root root 28 Nov 10 2020 fgrep -rwxr-xr-x 1 root root 69032 Jul 29 09:09 findmnt -rwsr-xr-x 1 root root 34896 Feb 27 2021 fusermount -rwxr-xr-x 1 root root 203072 Nov 10 2020 grep -rwxr-xr-x 2 root root 2346 Mar 3 2021 gunzip -rwxr-xr-x 1 root root 6376 Mar 3 2021 gzexe -rwxr-xr-x 1 root root 98048 Mar 3 2021 gzip -rwxr-xr-x 1 root root 22600 Nov 8 2019 hostname -rwxr-xr-x 1 root root 72840 Sep 24 2020 ln -rwxr-xr-x 1 root root 56952 Feb 8 2020 login -rwxr-xr-x 1 root root 147176 Sep 24 2020 ls -rwxr-xr-x 1 root root 149736 Jul 29 09:09 lsblk -rwxr-xr-x 1 root root 85184 Sep 24 2020 mkdir -rwxr-xr-x 1 root root 76896 Sep 24 2020 mknod -rwxr-xr-x 1 root root 48064 Sep 24 2020 mktemp -rwxr-xr-x 1 root root 59632 Jul 29 09:09 more -rwsr-xr-x 1 root root 55528 Jul 29 09:09 mount -rwxr-xr-x 1 root root 18664 Jul 29 09:09 mountpoint -rwxr-xr-x 1 root root 147080 Sep 24 2020 mv lrwxrwxrwx 1 root root 8 Nov 8 2019 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 19 2021 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 43872 Sep 24 2020 pwd lrwxrwxrwx 1 root root 4 Aug 5 10:25 rbash -> bash -rwxr-xr-x 1 root root 52032 Sep 24 2020 readlink -rwxr-xr-x 1 root root 72704 Sep 24 2020 rm -rwxr-xr-x 1 root root 52032 Sep 24 2020 rmdir -rwxr-xr-x 1 root root 27472 Sep 28 2020 run-parts -rwxr-xr-x 1 root root 122224 Dec 23 2018 sed lrwxrwxrwx 1 root root 4 Jan 19 14:28 sh -> bash lrwxrwxrwx 1 root root 4 Jan 7 23:24 sh.distrib -> dash -rwxr-xr-x 1 root root 43808 Sep 24 2020 sleep -rwxr-xr-x 1 root root 84928 Sep 24 2020 stty -rwsr-xr-x 1 root root 71912 Jul 29 09:09 su -rwxr-xr-x 1 root root 39744 Sep 24 2020 sync -rwxr-xr-x 1 root root 531928 Feb 17 2021 tar -rwxr-xr-x 1 root root 14456 Sep 28 2020 tempfile -rwxr-xr-x 1 root root 101408 Sep 24 2020 touch -rwxr-xr-x 1 root root 39680 Sep 24 2020 true -rwxr-xr-x 1 root root 14328 Feb 27 2021 ulockmgr_server -rwsr-xr-x 1 root root 35040 Jul 29 09:09 umount -rwxr-xr-x 1 root root 39744 Sep 24 2020 uname -rwxr-xr-x 2 root root 2346 Mar 3 2021 uncompress -rwxr-xr-x 1 root root 147176 Sep 24 2020 vdir -rwxr-xr-x 1 root root 63744 Jul 29 09:09 wdctl lrwxrwxrwx 1 root root 8 Nov 8 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 3 2021 zcat -rwxr-xr-x 1 root root 1678 Mar 3 2021 zcmp -rwxr-xr-x 1 root root 5880 Mar 3 2021 zdiff -rwxr-xr-x 1 root root 29 Mar 3 2021 zegrep -rwxr-xr-x 1 root root 29 Mar 3 2021 zfgrep -rwxr-xr-x 1 root root 2081 Mar 3 2021 zforce -rwxr-xr-x 1 root root 7585 Mar 3 2021 zgrep -rwxr-xr-x 1 root root 2206 Mar 3 2021 zless -rwxr-xr-x 1 root root 1842 Mar 3 2021 zmore -rwxr-xr-x 1 root root 4553 Mar 3 2021 znew I: user script /srv/workspace/pbuilder/550690/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19655 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 85.6 MB of archives. After unpacking 480 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main amd64 bsdextrautils amd64 2.36.1-8 [145 kB] Get: 2 http://deb.debian.org/debian bullseye/main amd64 libuchardet0 amd64 0.0.7-1 [67.8 kB] Get: 3 http://deb.debian.org/debian bullseye/main amd64 groff-base amd64 1.22.4-6 [936 kB] Get: 4 http://deb.debian.org/debian bullseye/main amd64 libpipeline1 amd64 1.5.3-1 [34.3 kB] Get: 5 http://deb.debian.org/debian bullseye/main amd64 man-db amd64 2.9.4-2 [1354 kB] Get: 6 http://deb.debian.org/debian bullseye/main amd64 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main amd64 libmagic-mgc amd64 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main amd64 libmagic1 amd64 1:5.39-3 [126 kB] Get: 9 http://deb.debian.org/debian bullseye/main amd64 file amd64 1:5.39-3 [69.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main amd64 gettext-base amd64 0.21-4 [175 kB] Get: 11 http://deb.debian.org/debian bullseye/main amd64 libsigsegv2 amd64 2.13-1 [34.8 kB] Get: 12 http://deb.debian.org/debian bullseye/main amd64 m4 amd64 1.4.18-5 [204 kB] Get: 13 http://deb.debian.org/debian bullseye/main amd64 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main amd64 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main amd64 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main amd64 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main amd64 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main amd64 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main amd64 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main amd64 libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main amd64 dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main amd64 libelf1 amd64 0.183-1 [165 kB] Get: 25 http://deb.debian.org/debian bullseye/main amd64 dwz amd64 0.13+20210201-1 [175 kB] Get: 26 http://deb.debian.org/debian bullseye/main amd64 libicu67 amd64 67.1-7 [8622 kB] Get: 27 http://deb.debian.org/debian bullseye/main amd64 libxml2 amd64 2.9.10+dfsg-6.7 [693 kB] Get: 28 http://deb.debian.org/debian bullseye/main amd64 gettext amd64 0.21-4 [1311 kB] Get: 29 http://deb.debian.org/debian bullseye/main amd64 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main amd64 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main amd64 dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main amd64 golang-1.15-src amd64 1.15.15-1~deb11u2 [13.9 MB] Get: 34 http://deb.debian.org/debian bullseye/main amd64 golang-1.15-go amd64 1.15.15-1~deb11u2 [47.4 MB] Get: 35 http://deb.debian.org/debian bullseye/main amd64 golang-src amd64 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main amd64 golang-go amd64 2:1.15~1 [23.9 kB] Get: 37 http://deb.debian.org/debian bullseye/main amd64 golang-any amd64 2:1.15~1 [4976 B] Get: 38 http://deb.debian.org/debian bullseye/main amd64 golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main amd64 golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main amd64 libsqlite3-dev amd64 3.34.1-3 [963 kB] Get: 44 http://deb.debian.org/debian bullseye/main amd64 golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main amd64 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 amd64 golang-pq-dev all 1.3.0-1 [3092 B] Fetched 85.6 MB in 2s (54.2 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package bsdextrautils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19655 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-8_amd64.deb ... Unpacking bsdextrautils (2.36.1-8) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../01-libuchardet0_0.0.7-1_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_amd64.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../03-libpipeline1_1.5.3-1_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_amd64.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_amd64.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:amd64. Preparing to unpack .../07-libmagic1_1%3a5.39-3_amd64.deb ... Unpacking libmagic1:amd64 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_amd64.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_amd64.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:amd64. Preparing to unpack .../10-libsigsegv2_2.13-1_amd64.deb ... Unpacking libsigsegv2:amd64 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_amd64.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.12.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.12.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.12.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.12.0-1) ... Selecting previously unselected package libelf1:amd64. Preparing to unpack .../23-libelf1_0.183-1_amd64.deb ... Unpacking libelf1:amd64 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_amd64.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:amd64. Preparing to unpack .../25-libicu67_67.1-7_amd64.deb ... Unpacking libicu67:amd64 (67.1-7) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_amd64.deb ... Unpacking libxml2:amd64 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_amd64.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.15-1~deb11u2_amd64.deb ... Unpacking golang-1.15-src (1.15.15-1~deb11u2) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.15-1~deb11u2_amd64.deb ... Unpacking golang-1.15-go (1.15.15-1~deb11u2) ... Selecting previously unselected package golang-src:amd64. Preparing to unpack .../34-golang-src_2%3a1.15~1_amd64.deb ... Unpacking golang-src:amd64 (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_amd64.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:amd64. Preparing to unpack .../36-golang-any_2%3a1.15~1_amd64.deb ... Unpacking golang-any:amd64 (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:amd64. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_amd64.deb ... Unpacking libsqlite3-dev:amd64 (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:amd64 (1.5.3-1) ... Setting up bsdextrautils (2.36.1-8) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:amd64 (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.15-1~deb11u2) ... 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:amd64 (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:amd64 (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:amd64 (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:amd64 (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:amd64 (2:1.15~1) ... Setting up golang-1.15-go (1.15.15-1~deb11u2) ... Setting up libelf1:amd64 (0.183-1) ... Setting up libxml2:amd64 (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.12.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up golang-go (2:1.15~1) ... Setting up m4 (1.4.18-5) ... Setting up golang-any:amd64 (2:1.15~1) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.12.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Setting up debhelper (13.3.4) ... Setting up dh-golang (1.51) ... Processing triggers for libc-bin (2.31-13+deb11u2) ... 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 hostname: Name or service not known I: Running cd /build/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 15 gopkg.in/gorp.v1 internal/unsafeheader sync/atomic runtime/internal/sys unicode/utf8 runtime/internal/atomic math/bits internal/race internal/cpu unicode runtime/internal/math internal/testlog internal/bytealg math runtime internal/reflectlite sync errors sort internal/oserror io strconv syscall bytes strings reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context internal/poll internal/fmtsort os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 15 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2022/01/19 00:29: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: 00:29:01.756731 drop table if exists "invoice_test"; [] gorptest: 00:29:01.757251 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.757306 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.757364 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.757413 drop table if exists "person_test"; [] gorptest: 00:29:01.757455 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.757496 drop table if exists "id_created_test"; [] gorptest: 00:29:01.757541 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.757577 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.757620 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.757659 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.757705 drop table if exists "time_test"; [] gorptest: 00:29:01.757760 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.758129 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.758324 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.758502 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.758717 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.758899 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.759100 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.759282 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.759469 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.759648 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.760849 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.761042 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.761236 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.761286 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.761324 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.761366 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.761407 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.761445 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.761474 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.761512 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.761546 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.761582 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.761619 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.761655 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.761690 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:29:01.761726 drop table if exists "invoice_test"; [] gorptest: 00:29:01.761954 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.762123 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.762292 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.762559 drop table if exists "person_test"; [] gorptest: 00:29:01.762716 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.762883 drop table if exists "id_created_test"; [] gorptest: 00:29:01.763051 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.763218 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.763372 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.763551 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.763701 drop table if exists "time_test"; [] gorptest: 00:29:01.763853 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables 2022/01/19 00:29: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: 00:29:01.764105 drop table if exists "invoice_test"; [] gorptest: 00:29:01.764305 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.764358 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.764408 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.764539 drop table if exists "person_test"; [] gorptest: 00:29:01.764603 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.764659 drop table if exists "id_created_test"; [] gorptest: 00:29:01.764705 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.764756 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.764801 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.764844 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.764886 drop table if exists "time_test"; [] gorptest: 00:29:01.764930 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.765127 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.765307 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.765495 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.765707 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.765889 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.766073 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.766269 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.766446 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.766621 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.766798 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.766979 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.767155 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.767196 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.767229 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.767264 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.767297 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.767330 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.767358 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.767392 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.767444 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.767477 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.767510 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.767542 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.767570 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:29:01.767634 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141767610208 2:1642552141767610208 3:"Bob" 4:"Smith" 5:1] gorptest: 00:29:01.767791 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 00:29:01.767915 delete from "invoice_test"; [] gorptest: 00:29:01.768008 delete from "invoice_tag_test"; [] gorptest: 00:29:01.768092 delete from "alias_trans_field_test"; [] gorptest: 00:29:01.768171 delete from "invoice_override_test"; [] gorptest: 00:29:01.768273 delete from "person_test"; [] gorptest: 00:29:01.768351 delete from "ignored_column_test"; [] gorptest: 00:29:01.768452 delete from "id_created_test"; [] gorptest: 00:29:01.768562 delete from "type_conv_test"; [] gorptest: 00:29:01.768653 delete from "embedded_struct_test"; [] gorptest: 00:29:01.768734 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.768821 delete from "embedded_autoincr_test"; [] gorptest: 00:29:01.768939 delete from "time_test"; [] gorptest: 00:29:01.769028 delete from "id_created_test"; [] gorptest: 00:29:01.769121 SELECT * FROM person_test [] gorptest: 00:29:01.769222 SELECT * FROM invoice_test [] gorptest: 00:29:01.769320 drop table if exists "invoice_test"; [] gorptest: 00:29:01.769517 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.769684 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.769833 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.770074 drop table if exists "person_test"; [] gorptest: 00:29:01.770237 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.770399 drop table if exists "id_created_test"; [] gorptest: 00:29:01.770553 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.770704 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.770890 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.771046 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.771196 drop table if exists "time_test"; [] gorptest: 00:29:01.771347 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType gorptest: 00:29:01.771496 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 00:29:01.771882 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2022-01-19 00:29:01 +0000 UTC] gorptest: 00:29:01.772016 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 00:29:01.772096 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey gorptest: 00:29:01.772338 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:29:01.772729 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:29:01.772909 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 00:29:01.773090 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 00:29:01.773234 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 00:29:01.773351 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 00:29:01.773488 drop table if exists "PersonUInt64"; [] gorptest: 00:29:01.773654 drop table if exists "PersonUInt32"; [] gorptest: 00:29:01.773808 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether gorptest: 00:29:01.774058 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 00:29:01.774439 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 00:29:01.774583 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 00:29:01.774666 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 00:29:01.774729 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 00:29:01.774855 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser gorptest: 00:29:01.775244 drop table if exists PersistentUser [] gorptest: 00:29:01.775430 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:29:01.775635 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:29:01.775763 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 00:29:01.775834 select * from PersistentUser [] gorptest: 00:29:01.775913 select * from PersistentUser [] gorptest: 00:29:01.775994 select * from PersistentUser [] gorptest: 00:29:01.776070 select Id from PersistentUser [] gorptest: 00:29:01.776120 select mykey from PersistentUser [] gorptest: 00:29:01.776163 select PassedTraining from PersistentUser [] gorptest: 00:29:01.776209 select Id from PersistentUser [] gorptest: 00:29:01.776264 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap gorptest: 00:29:01.776495 drop table if exists PersistentUser [] gorptest: 00:29:01.776681 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:29:01.776888 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:29:01.777012 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 00:29:01.777169 select * from PersistentUser where mykey = ? [1:43] gorptest: 00:29:01.777256 select * from PersistentUser where mykey = ? [1:43] gorptest: 00:29:01.777341 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 00:29:01.777432 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 00:29:01.777504 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct gorptest: 00:29:01.777732 drop table if exists PersistentUser [] gorptest: 00:29:01.777946 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 00:29:01.778153 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 00:29:01.778272 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 00:29:01.778398 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 00:29:01.778481 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice 2022/01/19 00:29: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: 00:29:01.778753 drop table if exists "invoice_test"; [] gorptest: 00:29:01.778932 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.778986 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.779033 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.779085 drop table if exists "person_test"; [] gorptest: 00:29:01.779127 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.779177 drop table if exists "id_created_test"; [] gorptest: 00:29:01.779226 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.779274 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.779316 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.779366 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.779414 drop table if exists "time_test"; [] gorptest: 00:29:01.779470 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.779658 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.779837 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.780017 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.780224 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.780400 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.780597 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.780779 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.781003 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.781205 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.781416 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.781638 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.781834 select * from invoice_test where id=99999 [] gorptest: 00:29:01.781928 select * from invoice_test where id=99999 [] gorptest: 00:29:01.782017 drop table if exists "invoice_test"; [] gorptest: 00:29:01.782192 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.782365 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.782556 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.782786 drop table if exists "person_test"; [] gorptest: 00:29:01.782946 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.783107 drop table if exists "id_created_test"; [] gorptest: 00:29:01.783270 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.783452 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.783613 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.783770 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.783930 drop table if exists "time_test"; [] gorptest: 00:29:01.784085 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol gorptest: 00:29:01.784235 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 00:29:01.784621 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] gorptest: 00:29:01.784722 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2022/01/19 00:29: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: 00:29:01.785071 drop table if exists "invoice_test"; [] gorptest: 00:29:01.785255 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.785303 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.785346 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.785389 drop table if exists "person_test"; [] gorptest: 00:29:01.785433 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.785478 drop table if exists "id_created_test"; [] gorptest: 00:29:01.785522 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.785566 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.785615 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.785663 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.785707 drop table if exists "time_test"; [] gorptest: 00:29:01.785754 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.785945 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.786134 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.786310 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.786522 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.786706 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.786886 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.787073 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.787258 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.787448 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.787647 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.787826 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.788014 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141787997501 2:1642552141787997501 3:"Bob" 4:"Smith" 5:1] gorptest: 00:29:01.788154 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.788281 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1642552141787997501 2:1642552141787997501 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 00:29:01.788648 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1642552141787997501 2:1642552141787997501 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 00:29:01.788733 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.788821 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 00:29:01.788868 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.788937 drop table if exists "invoice_test"; [] gorptest: 00:29:01.789097 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.789256 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.789419 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.789632 drop table if exists "person_test"; [] gorptest: 00:29:01.789802 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.789957 drop table if exists "id_created_test"; [] gorptest: 00:29:01.790115 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.790271 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.790430 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.790589 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.790741 drop table if exists "time_test"; [] gorptest: 00:29:01.790895 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.01s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 00:29:01.791089 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 00:29:01.791427 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 00:29:01.791541 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 00:29:01.791659 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] gorptest: 00:29:01.791794 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 00:29:01.791899 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps gorptest: 00:29:01.792126 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 00:29:01.792505 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 00:29:01.792672 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 00:29:01.792762 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 00:29:01.792847 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 00:29:01.792905 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect 2022/01/19 00:29: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: 00:29:01.793282 drop table if exists "invoice_test"; [] gorptest: 00:29:01.793487 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.793547 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.793593 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.793634 drop table if exists "person_test"; [] gorptest: 00:29:01.793671 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.793721 drop table if exists "id_created_test"; [] gorptest: 00:29:01.793768 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.793815 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.793856 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.793898 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.793938 drop table if exists "time_test"; [] gorptest: 00:29:01.793985 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.794176 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.794379 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.794586 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.794819 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.795027 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.795241 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.795441 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.795642 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.795845 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.796052 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.796267 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.796492 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141796475982 2:1642552141796475982 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.796639 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 00:29:01.796763 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 00:29:01.796873 drop table if exists "invoice_test"; [] gorptest: 00:29:01.797039 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.797192 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.797348 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.797585 drop table if exists "person_test"; [] gorptest: 00:29:01.797746 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.797898 drop table if exists "id_created_test"; [] gorptest: 00:29:01.798050 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.798197 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.798352 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.798498 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.798640 drop table if exists "time_test"; [] gorptest: 00:29:01.798784 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.01s) === RUN TestHooks 2022/01/19 00:29: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: 00:29:01.798935 drop table if exists "invoice_test"; [] gorptest: 00:29:01.799126 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.799181 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.799219 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.799254 drop table if exists "person_test"; [] gorptest: 00:29:01.799293 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.799339 drop table if exists "id_created_test"; [] gorptest: 00:29:01.799381 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.799424 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.799485 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.799530 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.799573 drop table if exists "time_test"; [] gorptest: 00:29:01.799625 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.799816 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.799991 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.800160 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.800359 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.800728 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.800922 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.801096 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.801271 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.801452 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.801624 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.801798 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.801983 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141801966625 2:1642552141801966625 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.802122 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.802208 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1642552141801966625 2:1642552141801966625 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 00:29:01.802338 select * from person_test where id = ? [1:1] gorptest: 00:29:01.802456 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 00:29:01.802566 drop table if exists "invoice_test"; [] gorptest: 00:29:01.802715 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.802867 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.803011 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.803225 drop table if exists "person_test"; [] gorptest: 00:29:01.803435 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.803612 drop table if exists "id_created_test"; [] gorptest: 00:29:01.803763 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.803914 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.804068 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.804217 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.804365 drop table if exists "time_test"; [] gorptest: 00:29:01.804537 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.01s) === RUN TestTransaction 2022/01/19 00:29: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: 00:29:01.804716 drop table if exists "invoice_test"; [] gorptest: 00:29:01.804901 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.804945 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.804983 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.805028 drop table if exists "person_test"; [] gorptest: 00:29:01.805070 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.805104 drop table if exists "id_created_test"; [] gorptest: 00:29:01.805141 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.805180 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.805223 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.805291 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.805334 drop table if exists "time_test"; [] gorptest: 00:29:01.805374 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.805576 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.805768 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.805947 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.806144 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.806315 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.806484 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.806655 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.806822 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.806994 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.807165 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.807336 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.807528 begin; [] gorptest: 00:29:01.807571 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 00:29:01.807676 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 00:29:01.807709 commit; [] gorptest: 00:29:01.807770 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.807845 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 00:29:01.807917 drop table if exists "invoice_test"; [] gorptest: 00:29:01.808073 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.808221 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.808374 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.808596 drop table if exists "person_test"; [] gorptest: 00:29:01.808755 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.808913 drop table if exists "id_created_test"; [] gorptest: 00:29:01.809059 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.809208 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.809356 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.809510 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.809666 drop table if exists "time_test"; [] gorptest: 00:29:01.809823 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.01s) === RUN TestSavepoint 2022/01/19 00:29: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: 00:29:01.810005 drop table if exists "invoice_test"; [] gorptest: 00:29:01.810187 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.810247 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.810289 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.810325 drop table if exists "person_test"; [] gorptest: 00:29:01.810372 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.810412 drop table if exists "id_created_test"; [] gorptest: 00:29:01.810447 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.810496 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.810552 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.810594 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.810635 drop table if exists "time_test"; [] gorptest: 00:29:01.810687 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.810876 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.811054 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.811237 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.811483 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.811676 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.811856 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.812033 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.812217 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.812409 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.812625 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.812803 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.812989 begin; [] gorptest: 00:29:01.813028 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 00:29:01.813118 select memo from invoice_test [] gorptest: 00:29:01.813161 savepoint "foo" [1:] gorptest: 00:29:01.813178 select memo from invoice_test [] gorptest: 00:29:01.813227 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 00:29:01.813272 select memo from invoice_test [] gorptest: 00:29:01.813298 rollback to savepoint "foo" [1:] gorptest: 00:29:01.813320 select memo from invoice_test [] gorptest: 00:29:01.813351 rollback; [] gorptest: 00:29:01.813421 drop table if exists "invoice_test"; [] gorptest: 00:29:01.813577 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.813737 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.813897 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.814111 drop table if exists "person_test"; [] gorptest: 00:29:01.814272 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.814425 drop table if exists "id_created_test"; [] gorptest: 00:29:01.814590 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.814738 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.814887 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.815044 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.815200 drop table if exists "time_test"; [] gorptest: 00:29:01.815355 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.01s) === RUN TestMultiple 2022/01/19 00:29: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: 00:29:01.815524 drop table if exists "invoice_test"; [] gorptest: 00:29:01.815717 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.815762 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.815805 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.815852 drop table if exists "person_test"; [] gorptest: 00:29:01.815897 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.815934 drop table if exists "id_created_test"; [] gorptest: 00:29:01.815973 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.816020 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.816055 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.816090 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.816140 drop table if exists "time_test"; [] gorptest: 00:29:01.816182 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.816371 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.816578 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.816757 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.816981 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.817168 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.817345 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.817532 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.817717 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.817902 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.818097 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.818285 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.818491 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 00:29:01.818668 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 00:29:01.818809 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 00:29:01.818987 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 00:29:01.819120 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.819234 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 00:29:01.819330 drop table if exists "invoice_test"; [] gorptest: 00:29:01.819507 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.819705 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.819866 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.820140 drop table if exists "person_test"; [] gorptest: 00:29:01.820320 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.820751 drop table if exists "id_created_test"; [] gorptest: 00:29:01.820920 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.821079 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.821257 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.821426 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.821583 drop table if exists "time_test"; [] gorptest: 00:29:01.821741 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.01s) === RUN TestCrud 2022/01/19 00:29: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: 00:29:01.821932 drop table if exists "invoice_test"; [] gorptest: 00:29:01.822148 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.822192 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.822240 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.822282 drop table if exists "person_test"; [] gorptest: 00:29:01.822318 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.822367 drop table if exists "id_created_test"; [] gorptest: 00:29:01.822406 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.822452 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.822493 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.822532 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.822575 drop table if exists "time_test"; [] gorptest: 00:29:01.822619 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.822814 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.823004 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.823199 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.823427 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.823610 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.823802 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.824004 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.824215 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.824448 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.824696 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.824913 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.825121 delete from invoice_test [] gorptest: 00:29:01.825256 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 00:29:01.825437 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.825567 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] gorptest: 00:29:01.825706 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.825798 select * from invoice_test [] gorptest: 00:29:01.825912 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.826058 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 00:29:01.826134 delete from invoice_tag_test [] gorptest: 00:29:01.826248 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] gorptest: 00:29:01.826387 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:29:01.826486 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] gorptest: 00:29:01.826615 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:29:01.826693 select * from invoice_tag_test [] gorptest: 00:29:01.826845 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:29:01.826953 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 00:29:01.827013 delete from alias_trans_field_test [] gorptest: 00:29:01.827120 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 00:29:01.827251 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:29:01.827332 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 00:29:01.827452 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:29:01.827521 select * from alias_trans_field_test [] gorptest: 00:29:01.827595 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:29:01.827701 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 00:29:01.827756 drop table if exists "invoice_test"; [] gorptest: 00:29:01.827928 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.828097 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.828265 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.828508 drop table if exists "person_test"; [] gorptest: 00:29:01.828671 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.828831 drop table if exists "id_created_test"; [] gorptest: 00:29:01.828988 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.829140 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.829297 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.829453 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.829607 drop table if exists "time_test"; [] gorptest: 00:29:01.829766 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.01s) === RUN TestWithIgnoredColumn 2022/01/19 00:29: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: 00:29:01.829960 drop table if exists "invoice_test"; [] gorptest: 00:29:01.830148 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.830199 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.830259 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.830309 drop table if exists "person_test"; [] gorptest: 00:29:01.830352 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.830388 drop table if exists "id_created_test"; [] gorptest: 00:29:01.830451 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.830515 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.830578 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.830639 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.830711 drop table if exists "time_test"; [] gorptest: 00:29:01.830770 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.830971 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.831151 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.831331 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.831535 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.831712 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.831890 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.832063 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.832242 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.832422 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.832832 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.833013 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.833199 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 00:29:01.833331 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:29:01.833444 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:29:01.833549 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 00:29:01.833614 drop table if exists "invoice_test"; [] gorptest: 00:29:01.833772 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.833944 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.834103 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.834320 drop table if exists "person_test"; [] gorptest: 00:29:01.834497 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.834670 drop table if exists "id_created_test"; [] gorptest: 00:29:01.834845 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.834995 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.835141 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.835292 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.835453 drop table if exists "time_test"; [] gorptest: 00:29:01.835595 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.01s) === RUN TestTypeConversionExample 2022/01/19 00:29: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: 00:29:01.835765 drop table if exists "invoice_test"; [] gorptest: 00:29:01.835947 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.835992 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.836032 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.836076 drop table if exists "person_test"; [] gorptest: 00:29:01.836114 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.836152 drop table if exists "id_created_test"; [] gorptest: 00:29:01.836193 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.836235 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.836270 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.836318 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.836359 drop table if exists "time_test"; [] gorptest: 00:29:01.836408 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.836618 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.836790 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.836967 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.837162 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.837332 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.837501 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.837664 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.837856 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.838039 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.838214 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.838386 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.838641 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] gorptest: 00:29:01.838780 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:29:01.838895 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] gorptest: 00:29:01.839016 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:29:01.839108 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 00:29:01.839213 drop table if exists "invoice_test"; [] gorptest: 00:29:01.839367 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.839554 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.839729 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.839948 drop table if exists "person_test"; [] gorptest: 00:29:01.840113 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.840277 drop table if exists "id_created_test"; [] gorptest: 00:29:01.840444 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.840614 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.840769 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.840935 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.841093 drop table if exists "time_test"; [] gorptest: 00:29:01.841245 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.01s) === RUN TestWithEmbeddedStruct 2022/01/19 00:29: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: 00:29:01.841433 drop table if exists "invoice_test"; [] gorptest: 00:29:01.841613 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.841665 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.841715 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.841759 drop table if exists "person_test"; [] gorptest: 00:29:01.841807 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.841857 drop table if exists "id_created_test"; [] gorptest: 00:29:01.841898 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.841945 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.841981 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.842026 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.842076 drop table if exists "time_test"; [] gorptest: 00:29:01.842125 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.842319 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.842508 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.842687 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.842946 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.843146 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.843324 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.843529 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.843707 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.843883 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.844071 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.844246 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.844450 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 00:29:01.844601 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 00:29:01.844685 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 00:29:01.844809 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 00:29:01.844883 select * from embedded_struct_test [] gorptest: 00:29:01.844960 drop table if exists "invoice_test"; [] gorptest: 00:29:01.845124 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.845287 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.845447 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.845663 drop table if exists "person_test"; [] gorptest: 00:29:01.845822 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.845979 drop table if exists "id_created_test"; [] gorptest: 00:29:01.846139 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.846296 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.846457 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.846612 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.846770 drop table if exists "time_test"; [] gorptest: 00:29:01.846920 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.01s) === RUN TestWithEmbeddedStructBeforeAutoincr 2022/01/19 00:29: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: 00:29:01.847169 drop table if exists "invoice_test"; [] gorptest: 00:29:01.847360 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.847410 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.847454 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.847492 drop table if exists "person_test"; [] gorptest: 00:29:01.847535 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.847571 drop table if exists "id_created_test"; [] gorptest: 00:29:01.847617 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.847664 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.847706 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.847757 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.847805 drop table if exists "time_test"; [] gorptest: 00:29:01.847856 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.848047 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.848229 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.848410 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.848637 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.848814 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.849009 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.849220 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.849429 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.849641 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.849846 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.850054 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.850282 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 00:29:01.850426 drop table if exists "invoice_test"; [] gorptest: 00:29:01.850609 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.850799 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.850970 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.851190 drop table if exists "person_test"; [] gorptest: 00:29:01.851354 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.851504 drop table if exists "id_created_test"; [] gorptest: 00:29:01.851660 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.851815 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.851971 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.852134 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.852291 drop table if exists "time_test"; [] gorptest: 00:29:01.852462 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr 2022/01/19 00:29: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: 00:29:01.852647 drop table if exists "invoice_test"; [] gorptest: 00:29:01.852828 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.852878 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.852928 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.852978 drop table if exists "person_test"; [] gorptest: 00:29:01.853022 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.853070 drop table if exists "id_created_test"; [] gorptest: 00:29:01.853118 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.853162 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.853200 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.853241 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.853276 drop table if exists "time_test"; [] gorptest: 00:29:01.853327 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.853544 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.853729 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.853913 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.854124 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.854316 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.854513 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.854702 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.854895 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.855081 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.855263 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.855452 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.855646 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 00:29:01.855774 drop table if exists "invoice_test"; [] gorptest: 00:29:01.855934 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.856092 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.856258 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.856489 drop table if exists "person_test"; [] gorptest: 00:29:01.856654 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.856810 drop table if exists "id_created_test"; [] gorptest: 00:29:01.856970 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.857127 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.857290 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.857451 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.857619 drop table if exists "time_test"; [] gorptest: 00:29:01.857774 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal gorptest: 00:29:01.857915 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 00:29:01.858276 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] gorptest: 00:29:01.858399 select Int64 from TableWithNull where Str='abc' [] gorptest: 00:29:01.858454 select count(*) from TableWithNull [] gorptest: 00:29:01.858496 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 00:29:01.858549 select Int64 from TableWithNull where Str='notfound' [] gorptest: 00:29:01.858600 select Int64 from TableWithNull where Str='abc' [] gorptest: 00:29:01.858664 select Float64 from TableWithNull where Str='abc' [] gorptest: 00:29:01.858706 select min(Float64) from TableWithNull [] gorptest: 00:29:01.858750 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 00:29:01.858808 select Float64 from TableWithNull where Str='notfound' [] gorptest: 00:29:01.858847 select Float64 from TableWithNull where Str='abc' [] gorptest: 00:29:01.858890 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:29:01.858932 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 00:29:01.858970 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:29:01.859011 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 00:29:01.859099 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 00:29:01.859148 select Str from TableWithNull where Int64=? [1:78] gorptest: 00:29:01.859191 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows 2022/01/19 00:29: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: 00:29:01.859451 drop table if exists "invoice_test"; [] gorptest: 00:29:01.859660 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.859698 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.859737 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.859775 drop table if exists "person_test"; [] gorptest: 00:29:01.859811 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.859846 drop table if exists "id_created_test"; [] gorptest: 00:29:01.859881 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.859925 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.859963 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.860000 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.860043 drop table if exists "time_test"; [] gorptest: 00:29:01.860086 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.860275 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.860828 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.861018 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.861232 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.861420 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.861598 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.861780 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.861954 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.862126 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.862296 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.862475 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.862667 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141862650909 2:1642552141862650909 3:"Bob" 4:"Smith" 5:1] gorptest: 00:29:01.862801 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141862790778 2:1642552141862790778 3:"Jane" 4:"Smith" 5:1] gorptest: 00:29:01.862934 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141862924301 2:1642552141862924301 3:"Mike" 4:"Smith" 5:1] gorptest: 00:29:01.863059 drop table if exists "invoice_test"; [] gorptest: 00:29:01.863212 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.863366 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.863543 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.863749 drop table if exists "person_test"; [] gorptest: 00:29:01.863907 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.864053 drop table if exists "id_created_test"; [] gorptest: 00:29:01.864195 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.864346 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.864530 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.864698 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.864844 drop table if exists "time_test"; [] gorptest: 00:29:01.864997 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk gorptest: 00:29:01.865117 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 00:29:01.865437 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 00:29:01.865565 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2022/01/19 00:29: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: 00:29:01.866122 drop table if exists "invoice_test"; [] gorptest: 00:29:01.866310 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.866364 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.866414 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.866461 drop table if exists "person_test"; [] gorptest: 00:29:01.866502 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.866545 drop table if exists "id_created_test"; [] gorptest: 00:29:01.866583 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.866624 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.866661 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.866701 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.866742 drop table if exists "time_test"; [] gorptest: 00:29:01.866786 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.866988 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.867173 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.867357 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.867609 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.867808 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.867989 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.868171 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.868361 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.868572 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.868751 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.868927 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.869127 insert into "time_test" ("Id","Time") values (null,?); [1:2022-01-18 23:58:01.869108338 +0000 UTC] gorptest: 00:29:01.869261 insert into "time_test" ("Id","Time") values (null,?); [1:2022-01-18 23:59:02.869108338 +0000 UTC] gorptest: 00:29:01.869392 SELECT id FROM time_test WHERE Time < ? [1:2022-01-18 23:59:01.869108338 +0000 UTC] gorptest: 00:29:01.869471 drop table if exists "invoice_test"; [] gorptest: 00:29:01.869634 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.869800 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.869963 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.870183 drop table if exists "person_test"; [] gorptest: 00:29:01.870349 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.870507 drop table if exists "id_created_test"; [] gorptest: 00:29:01.870656 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.870828 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.870991 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.871144 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.871300 drop table if exists "time_test"; [] gorptest: 00:29:01.871472 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView 2022/01/19 00:29: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: 00:29:01.871681 drop table if exists "invoice_test"; [] gorptest: 00:29:01.871862 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.871913 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.871956 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.872010 drop table if exists "person_test"; [] gorptest: 00:29:01.872054 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.872095 drop table if exists "id_created_test"; [] gorptest: 00:29:01.872129 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.872183 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.872225 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.872266 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.872320 drop table if exists "time_test"; [] gorptest: 00:29:01.872373 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.872820 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.873009 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.873198 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.873443 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.873629 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.873805 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.873986 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.874161 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.874359 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.874564 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.874761 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.874978 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141874958421 2:1642552141874958421 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.875149 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 00:29:01.875299 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 00:29:01.875422 drop table if exists "invoice_test"; [] gorptest: 00:29:01.875613 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.875793 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.875971 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.876235 drop table if exists "person_test"; [] gorptest: 00:29:01.876400 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.876599 drop table if exists "id_created_test"; [] gorptest: 00:29:01.876769 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.876923 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.877079 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.877235 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.877389 drop table if exists "time_test"; [] gorptest: 00:29:01.877544 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames 2022/01/19 00:29: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: 00:29:01.877733 drop table if exists "invoice_test"; [] gorptest: 00:29:01.877922 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.877972 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.878021 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.878097 drop table if exists "person_test"; [] gorptest: 00:29:01.878146 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.878182 drop table if exists "id_created_test"; [] gorptest: 00:29:01.878224 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.878277 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.878314 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.878354 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.878398 drop table if exists "time_test"; [] gorptest: 00:29:01.878444 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.878664 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.878850 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.879032 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.879240 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.879440 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.879633 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.879817 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.879996 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.880178 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.880353 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.880543 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols 2022/01/19 00:29: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: 00:29:01.883004 drop table if exists "invoice_test"; [] gorptest: 00:29:01.883194 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.883238 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.883281 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.883326 drop table if exists "person_test"; [] gorptest: 00:29:01.883376 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.883446 drop table if exists "id_created_test"; [] gorptest: 00:29:01.883483 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.883524 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.883559 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.883601 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.883642 drop table if exists "time_test"; [] gorptest: 00:29:01.883685 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.883874 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.884052 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.884231 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.884448 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.884636 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.884824 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.885007 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.885179 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.885363 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.885543 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.885731 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.885937 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141885920251 2:1642552141885920251 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.886078 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141886068181 2:1642552141886068181 3:"jane" 4:"doe" 5:1] gorptest: 00:29:01.886214 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.886323 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 00:29:01.886430 select * from person_test where Id=? [1:1] gorptest: 00:29:01.886525 select * from person_test order by fname asc [] gorptest: 00:29:01.886639 drop table if exists "invoice_test"; [] gorptest: 00:29:01.886800 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.886959 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.887117 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.887332 drop table if exists "person_test"; [] gorptest: 00:29:01.887503 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.887671 drop table if exists "id_created_test"; [] gorptest: 00:29:01.887839 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.888003 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.888165 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.888333 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.888509 drop table if exists "time_test"; [] gorptest: 00:29:01.888703 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.01s) === RUN TestSelectSingleVal 2022/01/19 00:29: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: 00:29:01.888885 drop table if exists "invoice_test"; [] gorptest: 00:29:01.889070 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.889128 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.889178 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.889225 drop table if exists "person_test"; [] gorptest: 00:29:01.889265 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.889300 drop table if exists "id_created_test"; [] gorptest: 00:29:01.889355 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.889407 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.889454 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.889499 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.889543 drop table if exists "time_test"; [] gorptest: 00:29:01.889587 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.889777 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.889981 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.890157 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.890362 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.890543 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.890732 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.890915 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.891093 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.891267 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.891456 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.891634 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.891825 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141891808438 2:1642552141891808438 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.891967 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 00:29:01.892054 select * from person_test where Id=? [1:1] gorptest: 00:29:01.892153 select FName from person_test where Id=? [1:1] gorptest: 00:29:01.892206 select * from person_test where Id=? [1:1] gorptest: 00:29:01.892303 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 00:29:01.892400 select * from person_test where Id=? [1:-2222] gorptest: 00:29:01.892529 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1642552141892516268 2:1642552141892516268 3:"bob" 4:"smith" 5:1] gorptest: 00:29:01.892666 select * from person_test where Fname='bob' [] gorptest: 00:29:01.892775 select * from person_test where Id=-123 [] gorptest: 00:29:01.892832 select * from person_test where Id=-123 [] gorptest: 00:29:01.892892 select * from person_test where Id=-123 [] gorptest: 00:29:01.892943 select * from person_test where Id=-123 [] gorptest: 00:29:01.893001 drop table if exists "invoice_test"; [] gorptest: 00:29:01.893159 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.893336 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.893535 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.893787 drop table if exists "person_test"; [] gorptest: 00:29:01.893972 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.894149 drop table if exists "id_created_test"; [] gorptest: 00:29:01.894323 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.894487 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.894650 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.894819 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.894992 drop table if exists "time_test"; [] gorptest: 00:29:01.895160 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.01s) === RUN TestSelectAlias 2022/01/19 00:29: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: 00:29:01.895378 drop table if exists "invoice_test"; [] gorptest: 00:29:01.895558 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.895605 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.895644 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.895681 drop table if exists "person_test"; [] gorptest: 00:29:01.895716 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.895763 drop table if exists "id_created_test"; [] gorptest: 00:29:01.895810 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.895845 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.895880 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.895925 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.895961 drop table if exists "time_test"; [] gorptest: 00:29:01.896011 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.896192 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.896368 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.896560 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.896760 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.896939 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.897110 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.897279 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.897452 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.897626 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.897819 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.897999 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.898169 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 00:29:01.898287 select * from id_created_test where Id=1 [] gorptest: 00:29:01.898366 SELECT *, 1 AS external FROM id_created_test [] gorptest: 00:29:01.898450 drop table if exists "invoice_test"; [] gorptest: 00:29:01.898854 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.899023 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.899186 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.899448 drop table if exists "person_test"; [] gorptest: 00:29:01.899610 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.899771 drop table if exists "id_created_test"; [] gorptest: 00:29:01.899939 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.900098 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.900254 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.900411 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.900614 drop table if exists "time_test"; [] gorptest: 00:29:01.900778 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2022/01/19 00:29: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: 00:29:01.901016 drop table if exists "invoice_test"; [] gorptest: 00:29:01.901197 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.901242 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.901284 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.901325 drop table if exists "person_test"; [] gorptest: 00:29:01.901366 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.901401 drop table if exists "id_created_test"; [] gorptest: 00:29:01.901448 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.901489 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.901524 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.901575 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.901623 drop table if exists "time_test"; [] gorptest: 00:29:01.901670 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.901873 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.902052 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.902231 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.902437 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.902610 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.902791 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.902966 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.903147 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.903333 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.903539 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.903890 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.904076 drop table if exists "invoice_test"; [] gorptest: 00:29:01.904273 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.905106 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.905292 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.905541 drop table if exists "person_test"; [] gorptest: 00:29:01.905711 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.905874 drop table if exists "id_created_test"; [] gorptest: 00:29:01.906038 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.906201 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.906356 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.906529 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.906688 drop table if exists "time_test"; [] gorptest: 00:29:01.906836 drop table if exists "id_created_test"; [] gorptest: 00:29:01.906886 drop table if exists "single_column_table"; [] gorptest: 00:29:01.906944 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.907130 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.907311 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.907495 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.907700 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.907882 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.908054 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.908230 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.908451 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.908642 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.908825 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.909005 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.909179 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 00:29:01.909224 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 00:29:01.909407 delete from "invoice_test"; [] gorptest: 00:29:01.909512 delete from "invoice_tag_test"; [] gorptest: 00:29:01.909608 delete from "alias_trans_field_test"; [] gorptest: 00:29:01.909699 delete from "invoice_override_test"; [] gorptest: 00:29:01.909804 delete from "person_test"; [] gorptest: 00:29:01.909890 delete from "ignored_column_test"; [] gorptest: 00:29:01.909988 delete from "id_created_test"; [] gorptest: 00:29:01.910074 delete from "type_conv_test"; [] gorptest: 00:29:01.910171 delete from "embedded_struct_test"; [] gorptest: 00:29:01.910256 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.910348 delete from "embedded_autoincr_test"; [] gorptest: 00:29:01.910437 delete from "time_test"; [] gorptest: 00:29:01.910521 delete from "id_created_test"; [] gorptest: 00:29:01.910635 delete from "single_column_table"; [] gorptest: 00:29:01.910759 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 00:29:01.910827 drop table if exists "invoice_test"; [] gorptest: 00:29:01.910983 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.911142 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.911297 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.911528 drop table if exists "person_test"; [] gorptest: 00:29:01.911687 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.911844 drop table if exists "id_created_test"; [] gorptest: 00:29:01.911994 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.912148 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.912304 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.912531 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.912687 drop table if exists "time_test"; [] gorptest: 00:29:01.912840 drop table if exists "id_created_test"; [] gorptest: 00:29:01.912903 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) === RUN TestPrepare 2022/01/19 00:29: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: 00:29:01.913293 drop table if exists "invoice_test"; [] gorptest: 00:29:01.913518 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.913568 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.913628 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.913665 drop table if exists "person_test"; [] gorptest: 00:29:01.913707 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.913750 drop table if exists "id_created_test"; [] gorptest: 00:29:01.913799 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.913847 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.913897 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.913939 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.913985 drop table if exists "time_test"; [] gorptest: 00:29:01.914052 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.914253 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 00:29:01.914457 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 00:29:01.914644 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 00:29:01.914848 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 00:29:01.915025 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.915200 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 00:29:01.915385 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 00:29:01.915574 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 00:29:01.915755 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 00:29:01.915931 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 00:29:01.916102 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 00:29:01.916304 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 00:29:01.916469 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 00:29:01.916602 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 00:29:01.916755 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 00:29:01.916865 begin; [] gorptest: 00:29:01.916915 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 00:29:01.916998 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:29:01.917321 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:29:01.917421 commit; [] gorptest: 00:29:01.917496 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 00:29:01.917600 drop table if exists "invoice_test"; [] gorptest: 00:29:01.917842 drop table if exists "invoice_tag_test"; [] gorptest: 00:29:01.918240 drop table if exists "alias_trans_field_test"; [] gorptest: 00:29:01.918622 drop table if exists "invoice_override_test"; [] gorptest: 00:29:01.919072 drop table if exists "person_test"; [] gorptest: 00:29:01.919414 drop table if exists "ignored_column_test"; [] gorptest: 00:29:01.919769 drop table if exists "id_created_test"; [] gorptest: 00:29:01.920084 drop table if exists "type_conv_test"; [] gorptest: 00:29:01.920397 drop table if exists "embedded_struct_test"; [] gorptest: 00:29:01.920725 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 00:29:01.921011 drop table if exists "embedded_autoincr_test"; [] gorptest: 00:29:01.921321 drop table if exists "time_test"; [] gorptest: 00:29:01.921630 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.01s) PASS ok gopkg.in/gorp.v1 0.171s 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_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: user script /srv/workspace/pbuilder/550690/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/550690/tmp/hooks/B01_cleanup finished 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/550690 and its subdirectories I: Current time: Wed Jan 19 14:29:05 +14 2022 I: pbuilder-time-stamp: 1642552145