I: pbuilder: network access will be disabled during build I: Current time: Wed Aug 10 12:58:37 +14 2022 I: pbuilder-time-stamp: 1660085917 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: using eatmydata during job I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.ujfzrKl1/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/30150/tmp/hooks/D01_modify_environment starting debug: Running on ionos16-i386. 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/30150/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/30150/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]="i686-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=i386 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=18' DIRSTACK=() DISTRIBUTION= EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=i686 HOST_ARCH=i386 IFS=' ' INVOCATION_ID=fc498b7d5f914d059d5345020b3ff8b0 LANG=C LANGUAGE=de_CH:de LC_ALL=C LD_LIBRARY_PATH=/usr/lib/libeatmydata LD_PRELOAD=libeatmydata.so MACHTYPE=i686-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=30150 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.gtGSnlgoHt/pbuilderrc_1apH --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.gtGSnlgoHt/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=112 SUDO_UID=107 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://85.184.249.68:3128 I: uname -a Linux i-capture-the-hostname 4.19.0-17-amd64 #1 SMP Debian 4.19.194-2 (2021-06-21) x86_64 GNU/Linux I: ls -l /bin total 5776 -rwxr-xr-x 1 root root 1367848 Jun 22 2021 bash -rwxr-xr-x 3 root root 38280 Jul 21 2020 bunzip2 -rwxr-xr-x 3 root root 38280 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 38280 Jul 21 2020 bzip2 -rwxr-xr-x 1 root root 17768 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 38824 Sep 23 2020 cat -rwxr-xr-x 1 root root 71624 Sep 23 2020 chgrp -rwxr-xr-x 1 root root 67528 Sep 23 2020 chmod -rwxr-xr-x 1 root root 75752 Sep 23 2020 chown -rwxr-xr-x 1 root root 157960 Sep 23 2020 cp -rwxr-xr-x 1 root root 128724 Dec 11 2020 dash -rwxr-xr-x 1 root root 124904 Sep 23 2020 date -rwxr-xr-x 1 root root 92172 Sep 23 2020 dd -rwxr-xr-x 1 root root 100752 Sep 23 2020 df -rwxr-xr-x 1 root root 153964 Sep 23 2020 dir -rwxr-xr-x 1 root root 83644 Feb 8 2021 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 34664 Sep 23 2020 echo -rwxr-xr-x 1 root root 28 Nov 10 2020 egrep -rwxr-xr-x 1 root root 34664 Sep 23 2020 false -rwxr-xr-x 1 root root 28 Nov 10 2020 fgrep -rwxr-xr-x 1 root root 71928 Feb 8 2021 findmnt -rwsr-xr-x 1 root root 30112 Feb 27 2021 fusermount -rwxr-xr-x 1 root root 210488 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 100952 Mar 3 2021 gzip -rwxr-xr-x 1 root root 21916 Nov 8 2019 hostname -rwxr-xr-x 1 root root 83980 Sep 23 2020 ln -rwxr-xr-x 1 root root 55572 Feb 8 2020 login -rwxr-xr-x 1 root root 153964 Sep 23 2020 ls -rwxr-xr-x 1 root root 153124 Feb 8 2021 lsblk -rwxr-xr-x 1 root root 96328 Sep 23 2020 mkdir -rwxr-xr-x 1 root root 79912 Sep 23 2020 mknod -rwxr-xr-x 1 root root 47048 Sep 23 2020 mktemp -rwxr-xr-x 1 root root 58920 Feb 8 2021 more -rwsr-xr-x 1 root root 50720 Feb 8 2021 mount -rwxr-xr-x 1 root root 13856 Feb 8 2021 mountpoint -rwxr-xr-x 1 root root 157996 Sep 23 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 38824 Sep 23 2020 pwd lrwxrwxrwx 1 root root 4 Jun 22 2021 rbash -> bash -rwxr-xr-x 1 root root 46984 Sep 23 2020 readlink -rwxr-xr-x 1 root root 75720 Sep 23 2020 rm -rwxr-xr-x 1 root root 46984 Sep 23 2020 rmdir -rwxr-xr-x 1 root root 22292 Sep 28 2020 run-parts -rwxr-xr-x 1 root root 125036 Dec 23 2018 sed lrwxrwxrwx 1 root root 4 Aug 10 12:58 sh -> bash lrwxrwxrwx 1 root root 4 Aug 9 05:46 sh.distrib -> dash -rwxr-xr-x 1 root root 34696 Sep 23 2020 sleep -rwxr-xr-x 1 root root 83880 Sep 23 2020 stty -rwsr-xr-x 1 root root 79396 Feb 8 2021 su -rwxr-xr-x 1 root root 34696 Sep 23 2020 sync -rwxr-xr-x 1 root root 602584 Feb 17 2021 tar -rwxr-xr-x 1 root root 13860 Sep 28 2020 tempfile -rwxr-xr-x 1 root root 108520 Sep 23 2020 touch -rwxr-xr-x 1 root root 34664 Sep 23 2020 true -rwxr-xr-x 1 root root 17768 Feb 27 2021 ulockmgr_server -rwsr-xr-x 1 root root 30236 Feb 8 2021 umount -rwxr-xr-x 1 root root 34664 Sep 23 2020 uname -rwxr-xr-x 2 root root 2346 Mar 3 2021 uncompress -rwxr-xr-x 1 root root 153964 Sep 23 2020 vdir -rwxr-xr-x 1 root root 63024 Feb 8 2021 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/30150/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: i386 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19675 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.15-go{a} golang-1.15-src{a} golang-any{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-text-dev{a} golang-pq-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu67{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsigsegv2{a} libsqlite3-dev{a} libsub-override-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 46 newly installed, 0 to remove and 0 not upgraded. Need to get 84.8 MB of archives. After unpacking 454 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main i386 bsdextrautils i386 2.36.1-7 [148 kB] Get: 2 http://deb.debian.org/debian bullseye/main i386 libuchardet0 i386 0.0.7-1 [67.9 kB] Get: 3 http://deb.debian.org/debian bullseye/main i386 groff-base i386 1.22.4-6 [952 kB] Get: 4 http://deb.debian.org/debian bullseye/main i386 libpipeline1 i386 1.5.3-1 [36.8 kB] Get: 5 http://deb.debian.org/debian bullseye/main i386 man-db i386 2.9.4-2 [1367 kB] Get: 6 http://deb.debian.org/debian bullseye/main i386 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main i386 libmagic-mgc i386 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main i386 libmagic1 i386 1:5.39-3 [133 kB] Get: 9 http://deb.debian.org/debian bullseye/main i386 file i386 1:5.39-3 [69.0 kB] Get: 10 http://deb.debian.org/debian bullseye/main i386 gettext-base i386 0.21-4 [176 kB] Get: 11 http://deb.debian.org/debian bullseye/main i386 libsigsegv2 i386 2.13-1 [35.1 kB] Get: 12 http://deb.debian.org/debian bullseye/main i386 m4 i386 1.4.18-5 [206 kB] Get: 13 http://deb.debian.org/debian bullseye/main i386 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main i386 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main i386 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main i386 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main i386 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main i386 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main i386 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main i386 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main i386 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main i386 libfile-stripnondeterminism-perl all 1.11.0-1 [25.6 kB] Get: 23 http://deb.debian.org/debian bullseye/main i386 dh-strip-nondeterminism all 1.11.0-1 [15.3 kB] Get: 24 http://deb.debian.org/debian bullseye/main i386 libelf1 i386 0.183-1 [171 kB] Get: 25 http://deb.debian.org/debian bullseye/main i386 dwz i386 0.13+20210201-1 [179 kB] Get: 26 http://deb.debian.org/debian bullseye/main i386 libicu67 i386 67.1-7 [8775 kB] Get: 27 http://deb.debian.org/debian bullseye/main i386 libxml2 i386 2.9.10+dfsg-6.7 [728 kB] Get: 28 http://deb.debian.org/debian bullseye/main i386 gettext i386 0.21-4 [1322 kB] Get: 29 http://deb.debian.org/debian bullseye/main i386 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main i386 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main i386 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main i386 dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main i386 golang-1.15-src i386 1.15.9-5 [13.8 MB] Get: 34 http://deb.debian.org/debian bullseye/main i386 golang-1.15-go i386 1.15.9-5 [46.2 MB] Get: 35 http://deb.debian.org/debian bullseye/main i386 golang-src i386 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main i386 golang-go i386 2:1.15~1 [24.0 kB] Get: 37 http://deb.debian.org/debian bullseye/main i386 golang-any i386 2:1.15~1 [4980 B] Get: 38 http://deb.debian.org/debian bullseye/main i386 golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main i386 golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main i386 golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main i386 libsqlite3-dev i386 3.34.1-3 [1001 kB] Get: 44 http://deb.debian.org/debian bullseye/main i386 golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main i386 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Get: 46 http://deb.debian.org/debian bullseye/main i386 golang-pq-dev all 1.3.0-1 [3092 B] Fetched 84.8 MB in 1s (62.5 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 ... 19675 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-7_i386.deb ... Unpacking bsdextrautils (2.36.1-7) ... Selecting previously unselected package libuchardet0:i386. Preparing to unpack .../01-libuchardet0_0.0.7-1_i386.deb ... Unpacking libuchardet0:i386 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_i386.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:i386. Preparing to unpack .../03-libpipeline1_1.5.3-1_i386.deb ... Unpacking libpipeline1:i386 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_i386.deb ... Unpacking man-db (2.9.4-2) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../05-sensible-utils_0.0.14_all.deb ... Unpacking sensible-utils (0.0.14) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../06-libmagic-mgc_1%3a5.39-3_i386.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:i386. Preparing to unpack .../07-libmagic1_1%3a5.39-3_i386.deb ... Unpacking libmagic1:i386 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_i386.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_i386.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:i386. Preparing to unpack .../10-libsigsegv2_2.13-1_i386.deb ... Unpacking libsigsegv2:i386 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_i386.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.11.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.11.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.11.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.11.0-1) ... Selecting previously unselected package libelf1:i386. Preparing to unpack .../23-libelf1_0.183-1_i386.deb ... Unpacking libelf1:i386 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_i386.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:i386. Preparing to unpack .../25-libicu67_67.1-7_i386.deb ... Unpacking libicu67:i386 (67.1-7) ... Selecting previously unselected package libxml2:i386. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_i386.deb ... Unpacking libxml2:i386 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_i386.deb ... Unpacking gettext (0.21-4) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../28-intltool-debian_0.35.0+20060710.5_all.deb ... Unpacking intltool-debian (0.35.0+20060710.5) ... Selecting previously unselected package po-debconf. Preparing to unpack .../29-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../30-debhelper_13.3.4_all.deb ... Unpacking debhelper (13.3.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../31-dh-golang_1.51_all.deb ... Unpacking dh-golang (1.51) ... Selecting previously unselected package golang-1.15-src. Preparing to unpack .../32-golang-1.15-src_1.15.9-5_i386.deb ... Unpacking golang-1.15-src (1.15.9-5) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.9-5_i386.deb ... Unpacking golang-1.15-go (1.15.9-5) ... Selecting previously unselected package golang-src:i386. Preparing to unpack .../34-golang-src_2%3a1.15~1_i386.deb ... Unpacking golang-src:i386 (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_i386.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:i386. Preparing to unpack .../36-golang-any_2%3a1.15~1_i386.deb ... Unpacking golang-any:i386 (2:1.15~1) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../37-golang-github-go-sql-driver-mysql-dev_1.5.0-1_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../38-golang-github-lib-pq-dev_1.3.0-1_all.deb ... Unpacking golang-github-lib-pq-dev (1.3.0-1) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../39-golang-golang-x-sys-dev_0.0~git20210124.22da62e-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../40-golang-golang-x-text-dev_0.3.6-1_all.deb ... Unpacking golang-golang-x-text-dev (0.3.6-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../41-golang-golang-x-net-dev_1%3a0.0+git20210119.5f4716e+dfsg-4_all.deb ... Unpacking golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Selecting previously unselected package libsqlite3-dev:i386. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_i386.deb ... Unpacking libsqlite3-dev:i386 (3.34.1-3) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev. Preparing to unpack .../43-golang-github-mattn-go-sqlite3-dev_1.6.0~ds1-2_all.deb ... Unpacking golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../44-golang-github-ziutek-mymysql-dev_1.5.4+git20170206.23.0582bcf-2_all.deb ... Unpacking golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Selecting previously unselected package golang-pq-dev. Preparing to unpack .../45-golang-pq-dev_1.3.0-1_all.deb ... Unpacking golang-pq-dev (1.3.0-1) ... Setting up libpipeline1:i386 (1.5.3-1) ... Setting up bsdextrautils (2.36.1-7) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:i386 (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.9-5) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libdebhelper-perl (13.3.4) ... Setting up golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Setting up libmagic1:i386 (1:5.39-3) ... Setting up gettext-base (0.21-4) ... Setting up golang-github-lib-pq-dev (1.3.0-1) ... Setting up file (1:5.39-3) ... Setting up autotools-dev (20180224.1+nmu1) ... Setting up libsqlite3-dev:i386 (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:i386 (2.13-1) ... Setting up autopoint (0.21-4) ... Setting up sensible-utils (0.0.14) ... Setting up golang-golang-x-text-dev (0.3.6-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Setting up libuchardet0:i386 (0.0.7-1) ... Setting up libsub-override-perl (0.09-2) ... Setting up golang-pq-dev (1.3.0-1) ... Setting up golang-src:i386 (2:1.15~1) ... Setting up golang-1.15-go (1.15.9-5) ... Setting up libelf1:i386 (0.183-1) ... Setting up libxml2:i386 (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.11.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up golang-go (2:1.15~1) ... Setting up m4 (1.4.18-5) ... Setting up golang-any:i386 (2:1.15~1) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.11.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Setting up debhelper (13.3.4) ... Setting up dh-golang (1.51) ... Processing triggers for libc-bin (2.31-12) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps Reading package lists... Building dependency tree... Reading state information... The following additional packages will be installed: libfile-find-rule-perl libnumber-compare-perl libtext-glob-perl The following NEW packages will be installed: libfile-find-rule-perl libnumber-compare-perl libtext-glob-perl usrmerge 0 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. Need to get 59.5 kB of archives. After this operation, 157 kB of additional disk space will be used. Get:1 http://deb.debian.org/debian bullseye/main i386 libnumber-compare-perl all 0.03-1.1 [6956 B] Get:2 http://deb.debian.org/debian bullseye/main i386 libtext-glob-perl all 0.11-1 [8888 B] Get:3 http://deb.debian.org/debian bullseye/main i386 libfile-find-rule-perl all 0.34-1 [30.6 kB] Get:4 http://deb.debian.org/debian bullseye/main i386 usrmerge all 25 [13.0 kB] debconf: delaying package configuration, since apt-utils is not installed Fetched 59.5 kB in 0s (5170 kB/s) Selecting previously unselected package libnumber-compare-perl. (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 ... 33978 files and directories currently installed.) Preparing to unpack .../libnumber-compare-perl_0.03-1.1_all.deb ... Unpacking libnumber-compare-perl (0.03-1.1) ... Selecting previously unselected package libtext-glob-perl. Preparing to unpack .../libtext-glob-perl_0.11-1_all.deb ... Unpacking libtext-glob-perl (0.11-1) ... Selecting previously unselected package libfile-find-rule-perl. Preparing to unpack .../libfile-find-rule-perl_0.34-1_all.deb ... Unpacking libfile-find-rule-perl (0.34-1) ... Selecting previously unselected package usrmerge. Preparing to unpack .../archives/usrmerge_25_all.deb ... Unpacking usrmerge (25) ... Setting up libtext-glob-perl (0.11-1) ... Setting up libnumber-compare-perl (0.03-1.1) ... Setting up libfile-find-rule-perl (0.34-1) ... Setting up usrmerge (25) ... The system has been successfully converted. Processing triggers for man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. I: Building the package I: Running cd /build/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture i386 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 18 gopkg.in/gorp.v1 internal/race internal/unsafeheader unicode/utf8 math/bits runtime/internal/atomic internal/cpu runtime/internal/sys sync/atomic unicode math internal/testlog runtime/internal/math internal/bytealg runtime internal/reflectlite sync errors sort internal/oserror io strconv syscall bytes strings regexp/syntax reflect internal/syscall/execenv internal/syscall/unix time regexp context internal/poll os internal/fmtsort 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 18 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2022/08/09 22:59:17 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: 22:59:17.772709 drop table if exists "invoice_test"; [] gorptest: 22:59:17.773222 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:17.773279 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:17.773304 drop table if exists "invoice_override_test"; [] gorptest: 22:59:17.773327 drop table if exists "person_test"; [] gorptest: 22:59:17.773355 drop table if exists "ignored_column_test"; [] gorptest: 22:59:17.773383 drop table if exists "id_created_test"; [] gorptest: 22:59:17.773415 drop table if exists "type_conv_test"; [] gorptest: 22:59:17.773447 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:17.773479 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:17.773510 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:17.773542 drop table if exists "time_test"; [] gorptest: 22:59:17.773584 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:17.784518 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: 22:59:17.793187 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:17.801979 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:17.810484 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:17.820095 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:17.828452 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:17.836907 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:17.845736 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:17.855396 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:17.864255 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:17.872773 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:17.880872 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: 22:59:17.880935 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: 22:59:17.880967 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:17.880993 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: 22:59:17.881056 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: 22:59:17.881103 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:17.881126 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:17.881153 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:17.881179 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:17.881201 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:17.881227 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: 22:59:17.881248 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:17.881271 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:59:17.881290 drop table if exists "invoice_test"; [] gorptest: 22:59:17.887866 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:17.894449 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:17.900772 drop table if exists "invoice_override_test"; [] gorptest: 22:59:17.907596 drop table if exists "person_test"; [] gorptest: 22:59:17.914222 drop table if exists "ignored_column_test"; [] gorptest: 22:59:17.920944 drop table if exists "id_created_test"; [] gorptest: 22:59:17.927291 drop table if exists "type_conv_test"; [] gorptest: 22:59:17.934351 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:17.941254 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:17.947827 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:17.954335 drop table if exists "time_test"; [] gorptest: 22:59:17.960683 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.19s) === RUN TestTruncateTables 2022/08/09 22:59:17 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: 22:59:17.960894 drop table if exists "invoice_test"; [] gorptest: 22:59:17.961087 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:17.961125 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:17.961155 drop table if exists "invoice_override_test"; [] gorptest: 22:59:17.961190 drop table if exists "person_test"; [] gorptest: 22:59:17.961223 drop table if exists "ignored_column_test"; [] gorptest: 22:59:17.961252 drop table if exists "id_created_test"; [] gorptest: 22:59:17.961276 drop table if exists "type_conv_test"; [] gorptest: 22:59:17.961299 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:17.961324 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:17.961351 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:17.961383 drop table if exists "time_test"; [] gorptest: 22:59:17.961433 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:17.967862 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: 22:59:17.974772 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:17.981276 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:17.988264 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:17.994935 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.002273 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.008524 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:18.015155 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:18.021565 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:18.028121 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:18.034649 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:18.040846 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: 22:59:18.040902 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: 22:59:18.040930 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:18.040958 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: 22:59:18.040983 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: 22:59:18.041004 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.041042 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.041069 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:18.041091 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:18.041117 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:18.041140 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: 22:59:18.041173 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:18.041199 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:59:18.041261 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085958041230640 2:1660085958041230640 3:"Bob" 4:"Smith" 5:1] gorptest: 22:59:18.048182 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 22:59:18.055798 delete from "invoice_test"; [] gorptest: 22:59:18.062838 delete from "invoice_tag_test"; [] gorptest: 22:59:18.068619 delete from "alias_trans_field_test"; [] gorptest: 22:59:18.077302 delete from "invoice_override_test"; [] gorptest: 22:59:18.083882 delete from "person_test"; [] gorptest: 22:59:18.090032 delete from "ignored_column_test"; [] gorptest: 22:59:18.096286 delete from "id_created_test"; [] gorptest: 22:59:18.104354 delete from "type_conv_test"; [] gorptest: 22:59:18.110509 delete from "embedded_struct_test"; [] gorptest: 22:59:18.116317 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:18.122743 delete from "embedded_autoincr_test"; [] gorptest: 22:59:18.128368 delete from "time_test"; [] gorptest: 22:59:18.135304 delete from "id_created_test"; [] gorptest: 22:59:18.141186 SELECT * FROM person_test [] gorptest: 22:59:18.141301 SELECT * FROM invoice_test [] gorptest: 22:59:18.141424 drop table if exists "invoice_test"; [] gorptest: 22:59:18.147737 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:18.154620 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:18.160691 drop table if exists "invoice_override_test"; [] gorptest: 22:59:18.167569 drop table if exists "person_test"; [] gorptest: 22:59:18.173325 drop table if exists "ignored_column_test"; [] gorptest: 22:59:18.180508 drop table if exists "id_created_test"; [] gorptest: 22:59:18.186717 drop table if exists "type_conv_test"; [] gorptest: 22:59:18.194501 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:18.202343 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:18.208782 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:18.214954 drop table if exists "time_test"; [] gorptest: 22:59:18.220788 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.26s) === RUN TestCustomDateType gorptest: 22:59:18.220945 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 22:59:18.227510 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2022-08-09 22:59:18 +0000 UTC] gorptest: 22:59:18.233650 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 22:59:18.233772 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.02s) === RUN TestUIntPrimaryKey gorptest: 22:59:18.240077 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:59:18.247491 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:59:18.254355 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:59:18.260694 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 22:59:18.266717 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 22:59:18.273705 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 22:59:18.279581 drop table if exists "PersonUInt64"; [] gorptest: 22:59:18.285383 drop table if exists "PersonUInt32"; [] gorptest: 22:59:18.291481 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.06s) === RUN TestSetUniqueTogether gorptest: 22:59:18.297440 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 22:59:18.305348 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 22:59:18.314267 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 22:59:18.314398 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 22:59:18.314455 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 22:59:18.323320 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.04s) === RUN TestPersistentUser gorptest: 22:59:18.333420 drop table if exists PersistentUser [] gorptest: 22:59:18.333651 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:59:18.342591 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:59:18.352688 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 22:59:18.352789 select * from PersistentUser [] gorptest: 22:59:18.352871 select * from PersistentUser [] gorptest: 22:59:18.352983 select * from PersistentUser [] gorptest: 22:59:18.353082 select Id from PersistentUser [] gorptest: 22:59:18.353131 select mykey from PersistentUser [] gorptest: 22:59:18.353173 select PassedTraining from PersistentUser [] gorptest: 22:59:18.353211 select Id from PersistentUser [] gorptest: 22:59:18.353255 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.03s) === RUN TestNamedQueryMap gorptest: 22:59:18.363075 drop table if exists PersistentUser [] gorptest: 22:59:18.363336 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:59:18.372333 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:59:18.381179 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 22:59:18.390121 select * from PersistentUser where mykey = ? [1:43] gorptest: 22:59:18.390286 select * from PersistentUser where mykey = ? [1:43] gorptest: 22:59:18.390420 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 22:59:18.390552 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 22:59:18.390677 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.04s) === RUN TestNamedQueryStruct gorptest: 22:59:18.399882 drop table if exists PersistentUser [] gorptest: 22:59:18.400146 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:59:18.410038 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:59:18.419637 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 22:59:18.430015 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 22:59:18.430217 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.04s) === RUN TestReturnsNonNilSlice 2022/08/09 22:59:18 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:18.439606 drop table if exists "invoice_test"; [] gorptest: 22:59:18.439851 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:18.439928 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:18.439978 drop table if exists "invoice_override_test"; [] gorptest: 22:59:18.440049 drop table if exists "person_test"; [] gorptest: 22:59:18.440098 drop table if exists "ignored_column_test"; [] gorptest: 22:59:18.440166 drop table if exists "id_created_test"; [] gorptest: 22:59:18.440225 drop table if exists "type_conv_test"; [] gorptest: 22:59:18.440294 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:18.440363 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:18.440423 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:18.440466 drop table if exists "time_test"; [] gorptest: 22:59:18.440531 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:18.449391 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: 22:59:18.458177 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:18.467324 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:18.476654 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:18.486052 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.495326 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:18.504289 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:18.513598 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:18.523249 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:18.532535 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:18.542674 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:18.551742 select * from invoice_test where id=99999 [] gorptest: 22:59:18.551846 select * from invoice_test where id=99999 [] gorptest: 22:59:18.551917 drop table if exists "invoice_test"; [] gorptest: 22:59:19.096631 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:19.484284 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:19.527876 drop table if exists "invoice_override_test"; [] gorptest: 22:59:19.583456 drop table if exists "person_test"; [] gorptest: 22:59:19.654005 drop table if exists "ignored_column_test"; [] gorptest: 22:59:19.706969 drop table if exists "id_created_test"; [] gorptest: 22:59:19.796053 drop table if exists "type_conv_test"; [] gorptest: 22:59:19.891304 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:19.997238 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:20.169952 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:20.373350 drop table if exists "time_test"; [] gorptest: 22:59:20.598286 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (2.16s) === RUN TestOverrideVersionCol gorptest: 22:59:20.598518 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 22:59:20.697261 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: 22:59:20.697395 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.28s) === RUN TestOptimisticLocking 2022/08/09 22:59:20 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:20.880213 drop table if exists "invoice_test"; [] gorptest: 22:59:20.880485 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:20.880535 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:20.880599 drop table if exists "invoice_override_test"; [] gorptest: 22:59:20.880661 drop table if exists "person_test"; [] gorptest: 22:59:20.880711 drop table if exists "ignored_column_test"; [] gorptest: 22:59:20.880773 drop table if exists "id_created_test"; [] gorptest: 22:59:20.880831 drop table if exists "type_conv_test"; [] gorptest: 22:59:20.880891 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:20.880945 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:20.881016 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:20.881074 drop table if exists "time_test"; [] gorptest: 22:59:20.881137 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:20.887309 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: 22:59:20.894555 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:20.900699 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:20.906918 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:20.912631 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:20.923973 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:20.931404 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:20.937391 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:20.942897 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:20.948672 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:20.954406 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:20.960240 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085960960220343 2:1660085960960220343 3:"Bob" 4:"Smith" 5:1] gorptest: 22:59:20.966879 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:20.967056 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1660085960960220343 2:1660085960960220343 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 22:59:20.973982 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1660085960960220343 2:1660085960960220343 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 22:59:20.974107 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:20.974242 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 22:59:20.974322 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:20.974441 drop table if exists "invoice_test"; [] gorptest: 22:59:20.981279 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:20.986989 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:20.993208 drop table if exists "invoice_override_test"; [] gorptest: 22:59:20.998883 drop table if exists "person_test"; [] gorptest: 22:59:21.004700 drop table if exists "ignored_column_test"; [] gorptest: 22:59:21.011327 drop table if exists "id_created_test"; [] gorptest: 22:59:21.017205 drop table if exists "type_conv_test"; [] gorptest: 22:59:21.023894 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:21.029326 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:21.038258 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:21.044532 drop table if exists "time_test"; [] gorptest: 22:59:21.050662 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.17s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 22:59:21.050969 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 22:59:21.057276 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 22:59:21.063223 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 22:59:21.063388 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: 22:59:21.069466 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 22:59:21.069634 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.02s) === RUN TestColumnProps gorptest: 22:59:21.075850 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 22:59:21.084444 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 22:59:21.090476 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 22:59:21.090606 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 22:59:21.090729 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 22:59:21.090846 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.02s) === RUN TestRawSelect 2022/08/09 22:59:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:21.097212 drop table if exists "invoice_test"; [] gorptest: 22:59:21.097421 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:21.097475 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:21.097519 drop table if exists "invoice_override_test"; [] gorptest: 22:59:21.097575 drop table if exists "person_test"; [] gorptest: 22:59:21.097633 drop table if exists "ignored_column_test"; [] gorptest: 22:59:21.097715 drop table if exists "id_created_test"; [] gorptest: 22:59:21.097768 drop table if exists "type_conv_test"; [] gorptest: 22:59:21.097828 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:21.097882 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:21.097947 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:21.098010 drop table if exists "time_test"; [] gorptest: 22:59:21.098079 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:21.104000 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: 22:59:21.109800 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:21.119142 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:21.128374 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:21.138431 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:21.145919 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:21.152366 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:21.158550 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:21.164700 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:21.171871 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:21.177936 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:21.184230 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085961184212790 2:1660085961184212790 3:"bob" 4:"smith" 5:1] gorptest: 22:59:21.190286 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 22:59:21.196142 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 22:59:21.196290 drop table if exists "invoice_test"; [] gorptest: 22:59:21.202398 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:21.208715 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:21.214859 drop table if exists "invoice_override_test"; [] gorptest: 22:59:21.220968 drop table if exists "person_test"; [] gorptest: 22:59:21.227429 drop table if exists "ignored_column_test"; [] gorptest: 22:59:21.233555 drop table if exists "id_created_test"; [] gorptest: 22:59:21.240650 drop table if exists "type_conv_test"; [] gorptest: 22:59:21.246856 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:21.252732 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:21.258913 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:21.269808 drop table if exists "time_test"; [] gorptest: 22:59:21.278348 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.18s) === RUN TestHooks 2022/08/09 22:59:21 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:21.278618 drop table if exists "invoice_test"; [] gorptest: 22:59:21.278842 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:21.278905 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:21.278961 drop table if exists "invoice_override_test"; [] gorptest: 22:59:21.279054 drop table if exists "person_test"; [] gorptest: 22:59:21.279112 drop table if exists "ignored_column_test"; [] gorptest: 22:59:21.279171 drop table if exists "id_created_test"; [] gorptest: 22:59:21.279230 drop table if exists "type_conv_test"; [] gorptest: 22:59:21.279283 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:21.279341 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:21.279399 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:21.279457 drop table if exists "time_test"; [] gorptest: 22:59:21.279530 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:21.289158 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: 22:59:21.298024 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:21.306908 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:21.316134 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:21.324933 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:21.333549 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:21.343179 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:21.351832 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:21.360649 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:21.369375 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:21.378414 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:21.386926 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085961386904771 2:1660085961386904771 3:"bob" 4:"smith" 5:1] gorptest: 22:59:21.396163 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:21.396317 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1660085961386904771 2:1660085961386904771 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 22:59:21.406214 select * from person_test where id = ? [1:1] gorptest: 22:59:21.406376 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 22:59:21.414946 drop table if exists "invoice_test"; [] gorptest: 22:59:21.424664 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:21.433797 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:21.441914 drop table if exists "invoice_override_test"; [] gorptest: 22:59:21.452038 drop table if exists "person_test"; [] gorptest: 22:59:21.460800 drop table if exists "ignored_column_test"; [] gorptest: 22:59:21.469494 drop table if exists "id_created_test"; [] gorptest: 22:59:21.479773 drop table if exists "type_conv_test"; [] gorptest: 22:59:21.498771 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:22.217106 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:22.240725 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:22.264710 drop table if exists "time_test"; [] gorptest: 22:59:22.292740 drop table if exists "id_created_test"; [] --- PASS: TestHooks (1.01s) === RUN TestTransaction 2022/08/09 22:59:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:22.293067 drop table if exists "invoice_test"; [] gorptest: 22:59:22.293388 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:22.293436 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:22.293480 drop table if exists "invoice_override_test"; [] gorptest: 22:59:22.293522 drop table if exists "person_test"; [] gorptest: 22:59:22.293563 drop table if exists "ignored_column_test"; [] gorptest: 22:59:22.293603 drop table if exists "id_created_test"; [] gorptest: 22:59:22.293643 drop table if exists "type_conv_test"; [] gorptest: 22:59:22.293683 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:22.293725 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:22.293771 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:22.293825 drop table if exists "time_test"; [] gorptest: 22:59:22.293886 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:22.320747 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: 22:59:22.344754 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:22.366486 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:22.379791 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:22.389994 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:22.408729 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:22.432639 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:22.464753 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:22.488749 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:22.512754 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:22.536747 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:22.561763 begin; [] gorptest: 22:59:22.561857 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 22:59:22.562076 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 22:59:22.562140 commit; [] gorptest: 22:59:22.575226 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:22.575432 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 22:59:22.575540 drop table if exists "invoice_test"; [] gorptest: 22:59:22.588910 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:22.603925 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:22.626456 drop table if exists "invoice_override_test"; [] gorptest: 22:59:22.652741 drop table if exists "person_test"; [] gorptest: 22:59:22.676752 drop table if exists "ignored_column_test"; [] gorptest: 22:59:22.700748 drop table if exists "id_created_test"; [] gorptest: 22:59:22.724747 drop table if exists "type_conv_test"; [] gorptest: 22:59:22.741688 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:22.755904 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:22.767720 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:22.796709 drop table if exists "time_test"; [] gorptest: 22:59:22.828700 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.54s) === RUN TestSavepoint 2022/08/09 22:59:22 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:22.829010 drop table if exists "invoice_test"; [] gorptest: 22:59:22.829324 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:22.829372 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:22.829413 drop table if exists "invoice_override_test"; [] gorptest: 22:59:22.829454 drop table if exists "person_test"; [] gorptest: 22:59:22.829494 drop table if exists "ignored_column_test"; [] gorptest: 22:59:22.829536 drop table if exists "id_created_test"; [] gorptest: 22:59:22.829576 drop table if exists "type_conv_test"; [] gorptest: 22:59:22.829615 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:22.829654 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:22.829696 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:22.829736 drop table if exists "time_test"; [] gorptest: 22:59:22.829789 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:22.860732 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: 22:59:22.888725 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:22.912743 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:22.938102 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:22.951864 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:22.961478 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:22.970933 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:22.979520 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:23.004735 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:23.032729 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:23.052722 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:23.080753 begin; [] gorptest: 22:59:23.080845 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 22:59:23.081065 select memo from invoice_test [] gorptest: 22:59:23.081138 savepoint "foo" [1:] gorptest: 22:59:23.081154 select memo from invoice_test [] gorptest: 22:59:23.081209 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 22:59:23.081266 select memo from invoice_test [] gorptest: 22:59:23.081301 rollback to savepoint "foo" [1:] gorptest: 22:59:23.081320 select memo from invoice_test [] gorptest: 22:59:23.081347 rollback; [] gorptest: 22:59:23.081475 drop table if exists "invoice_test"; [] gorptest: 22:59:23.099397 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.110961 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.131652 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.148936 drop table if exists "person_test"; [] gorptest: 22:59:23.172712 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.200706 drop table if exists "id_created_test"; [] gorptest: 22:59:23.224733 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.248712 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.276743 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.298291 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.309817 drop table if exists "time_test"; [] gorptest: 22:59:23.319315 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.49s) === RUN TestMultiple 2022/08/09 22:59:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:23.319678 drop table if exists "invoice_test"; [] gorptest: 22:59:23.320065 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.320115 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.320158 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.320201 drop table if exists "person_test"; [] gorptest: 22:59:23.320244 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.320286 drop table if exists "id_created_test"; [] gorptest: 22:59:23.320395 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.320442 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.320483 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.320524 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.320585 drop table if exists "time_test"; [] gorptest: 22:59:23.320648 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.336027 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: 22:59:23.364716 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:23.392727 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.416725 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:23.444755 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.472728 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.491511 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:23.504577 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:23.515541 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:23.523005 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:23.529836 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:23.538773 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 22:59:23.548897 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 22:59:23.554737 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 22:59:23.560964 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 22:59:23.566316 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:23.571781 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 22:59:23.577401 drop table if exists "invoice_test"; [] gorptest: 22:59:23.583148 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.588948 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.594620 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.602863 drop table if exists "person_test"; [] gorptest: 22:59:23.611213 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.621542 drop table if exists "id_created_test"; [] gorptest: 22:59:23.627186 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.632852 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.638880 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.649790 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.658332 drop table if exists "time_test"; [] gorptest: 22:59:23.664589 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.35s) === RUN TestCrud 2022/08/09 22:59:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:23.664805 drop table if exists "invoice_test"; [] gorptest: 22:59:23.665002 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.665039 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.665063 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.665091 drop table if exists "person_test"; [] gorptest: 22:59:23.665120 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.665147 drop table if exists "id_created_test"; [] gorptest: 22:59:23.665174 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.665200 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.665229 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.665259 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.665290 drop table if exists "time_test"; [] gorptest: 22:59:23.665331 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.672693 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: 22:59:23.678472 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:23.687311 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.694046 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:23.700110 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.705716 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.712211 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:23.720943 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:23.726941 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:23.733024 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:23.739779 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:23.746011 delete from invoice_test [] gorptest: 22:59:23.752156 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 22:59:23.758078 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:23.758249 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: 22:59:23.766092 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:23.766217 select * from invoice_test [] gorptest: 22:59:23.766367 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:23.772245 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:59:23.772350 delete from invoice_tag_test [] gorptest: 22:59:23.778474 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: 22:59:23.786707 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:59:23.786928 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: 22:59:23.793106 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:59:23.793235 select * from invoice_tag_test [] gorptest: 22:59:23.793432 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:59:23.800095 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:59:23.800197 delete from alias_trans_field_test [] gorptest: 22:59:23.806741 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 22:59:23.813160 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:59:23.813263 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 22:59:23.821700 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:59:23.821808 select * from alias_trans_field_test [] gorptest: 22:59:23.821920 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:59:23.827974 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:59:23.828056 drop table if exists "invoice_test"; [] gorptest: 22:59:23.834083 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.840278 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.846347 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.852674 drop table if exists "person_test"; [] gorptest: 22:59:23.859107 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.866170 drop table if exists "id_created_test"; [] gorptest: 22:59:23.874940 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.881104 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.888019 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.894040 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.900854 drop table if exists "time_test"; [] gorptest: 22:59:23.907218 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.24s) === RUN TestWithIgnoredColumn 2022/08/09 22:59:23 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:23.907467 drop table if exists "invoice_test"; [] gorptest: 22:59:23.907709 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:23.907759 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:23.907817 drop table if exists "invoice_override_test"; [] gorptest: 22:59:23.907881 drop table if exists "person_test"; [] gorptest: 22:59:23.907925 drop table if exists "ignored_column_test"; [] gorptest: 22:59:23.907968 drop table if exists "id_created_test"; [] gorptest: 22:59:23.908009 drop table if exists "type_conv_test"; [] gorptest: 22:59:23.908051 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:23.908091 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:23.908133 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:23.908175 drop table if exists "time_test"; [] gorptest: 22:59:23.908227 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.914258 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: 22:59:23.920482 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:23.926741 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:23.934168 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:23.942673 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.948761 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:23.954863 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:23.960841 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:23.967005 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:23.973160 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:23.979995 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:23.988012 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 22:59:23.994112 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:59:23.994271 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:59:24.000835 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:59:24.000928 drop table if exists "invoice_test"; [] gorptest: 22:59:24.007887 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.014141 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.020055 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.026269 drop table if exists "person_test"; [] gorptest: 22:59:24.032802 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.039539 drop table if exists "id_created_test"; [] gorptest: 22:59:24.046165 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.052368 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.058450 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.067999 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.074404 drop table if exists "time_test"; [] gorptest: 22:59:24.080902 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.17s) === RUN TestTypeConversionExample 2022/08/09 22:59:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:24.081196 drop table if exists "invoice_test"; [] gorptest: 22:59:24.081410 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.081468 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.081518 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.081572 drop table if exists "person_test"; [] gorptest: 22:59:24.081618 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.081667 drop table if exists "id_created_test"; [] gorptest: 22:59:24.081711 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.081760 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.081802 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.081852 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.081900 drop table if exists "time_test"; [] gorptest: 22:59:24.081961 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.087913 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: 22:59:24.094381 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:24.101202 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.108193 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:24.115591 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.122544 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.128815 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:24.136157 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:24.143230 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:24.148803 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:24.154718 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:24.161134 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: 22:59:24.167174 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:59:24.167309 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: 22:59:24.173611 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:59:24.173733 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:59:24.179838 drop table if exists "invoice_test"; [] gorptest: 22:59:24.186109 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.192508 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.202057 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.212436 drop table if exists "person_test"; [] gorptest: 22:59:24.218462 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.225142 drop table if exists "id_created_test"; [] gorptest: 22:59:24.234379 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.240741 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.246960 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.252941 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.259867 drop table if exists "time_test"; [] gorptest: 22:59:24.266116 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.19s) === RUN TestWithEmbeddedStruct 2022/08/09 22:59:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:24.266337 drop table if exists "invoice_test"; [] gorptest: 22:59:24.266551 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.266601 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.266641 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.266680 drop table if exists "person_test"; [] gorptest: 22:59:24.266727 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.266775 drop table if exists "id_created_test"; [] gorptest: 22:59:24.266819 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.266863 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.266906 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.266948 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.266990 drop table if exists "time_test"; [] gorptest: 22:59:24.267050 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.272817 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: 22:59:24.279234 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:24.285722 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.291862 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:24.298312 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.304620 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.310875 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:24.317584 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:24.324068 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:24.330158 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:24.336250 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:24.342790 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 22:59:24.349090 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 22:59:24.349228 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 22:59:24.356195 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 22:59:24.356289 select * from embedded_struct_test [] gorptest: 22:59:24.356399 drop table if exists "invoice_test"; [] gorptest: 22:59:24.363974 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.370892 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.376925 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.383918 drop table if exists "person_test"; [] gorptest: 22:59:24.390651 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.399286 drop table if exists "id_created_test"; [] gorptest: 22:59:24.406141 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.413400 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.419638 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.426660 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.433224 drop table if exists "time_test"; [] gorptest: 22:59:24.439383 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.17s) === RUN TestWithEmbeddedStructBeforeAutoincr 2022/08/09 22:59:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:24.439636 drop table if exists "invoice_test"; [] gorptest: 22:59:24.439839 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.439889 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.439934 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.439978 drop table if exists "person_test"; [] gorptest: 22:59:24.440033 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.440078 drop table if exists "id_created_test"; [] gorptest: 22:59:24.440128 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.440177 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.440226 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.440275 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.440323 drop table if exists "time_test"; [] gorptest: 22:59:24.440381 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.447540 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: 22:59:24.454442 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:24.460793 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.469202 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:24.475927 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.482192 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.488687 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:24.496064 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:24.502546 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:24.509772 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:24.516020 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:24.522365 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 22:59:24.529571 drop table if exists "invoice_test"; [] gorptest: 22:59:24.536213 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.543246 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.549660 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.556929 drop table if exists "person_test"; [] gorptest: 22:59:24.565527 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.572222 drop table if exists "id_created_test"; [] gorptest: 22:59:24.578273 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.584821 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.591736 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.599212 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.606826 drop table if exists "time_test"; [] gorptest: 22:59:24.614047 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.17s) === RUN TestWithEmbeddedAutoincr 2022/08/09 22:59:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:24.614294 drop table if exists "invoice_test"; [] gorptest: 22:59:24.614500 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.614549 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.614594 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.614637 drop table if exists "person_test"; [] gorptest: 22:59:24.614680 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.614722 drop table if exists "id_created_test"; [] gorptest: 22:59:24.614764 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.614814 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.614863 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.614912 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.614961 drop table if exists "time_test"; [] gorptest: 22:59:24.615019 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.622413 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: 22:59:24.628554 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:24.634830 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.641680 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:24.648354 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.657707 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.664679 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:24.671744 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:24.678290 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:24.685392 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:24.691616 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:24.697954 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 22:59:24.705266 drop table if exists "invoice_test"; [] gorptest: 22:59:24.711523 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.717946 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.724064 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.730501 drop table if exists "person_test"; [] gorptest: 22:59:24.738682 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.750893 drop table if exists "id_created_test"; [] gorptest: 22:59:24.762060 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.771788 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.778046 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.784042 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.790555 drop table if exists "time_test"; [] gorptest: 22:59:24.796176 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.18s) === RUN TestSelectVal gorptest: 22:59:24.796395 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 22:59:24.802857 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: 22:59:24.808852 select Int64 from TableWithNull where Str='abc' [] gorptest: 22:59:24.808966 select count(*) from TableWithNull [] gorptest: 22:59:24.809025 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 22:59:24.809111 select Int64 from TableWithNull where Str='notfound' [] gorptest: 22:59:24.809171 select Int64 from TableWithNull where Str='abc' [] gorptest: 22:59:24.809234 select Float64 from TableWithNull where Str='abc' [] gorptest: 22:59:24.809295 select min(Float64) from TableWithNull [] gorptest: 22:59:24.809362 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 22:59:24.809429 select Float64 from TableWithNull where Str='notfound' [] gorptest: 22:59:24.809493 select Float64 from TableWithNull where Str='abc' [] gorptest: 22:59:24.809554 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:59:24.809615 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 22:59:24.809674 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:59:24.809740 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 22:59:24.809844 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 22:59:24.809927 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:59:24.809998 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.02s) === RUN TestVersionMultipleRows 2022/08/09 22:59:24 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:24.817743 drop table if exists "invoice_test"; [] gorptest: 22:59:24.817964 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.818014 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.818062 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.818106 drop table if exists "person_test"; [] gorptest: 22:59:24.818160 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.818210 drop table if exists "id_created_test"; [] gorptest: 22:59:24.818258 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.818306 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.818355 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.818408 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:24.818457 drop table if exists "time_test"; [] gorptest: 22:59:24.818515 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.829214 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: 22:59:24.835469 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:24.842833 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:24.849446 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:24.855867 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.862771 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:24.868859 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:24.875520 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:24.882187 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:24.888837 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:24.896806 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:24.905699 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085964905674974 2:1660085964905674974 3:"Bob" 4:"Smith" 5:1] gorptest: 22:59:24.912864 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085964912846275 2:1660085964912846275 3:"Jane" 4:"Smith" 5:1] gorptest: 22:59:24.919883 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085964919864852 2:1660085964919864852 3:"Mike" 4:"Smith" 5:1] gorptest: 22:59:24.926329 drop table if exists "invoice_test"; [] gorptest: 22:59:24.932542 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:24.939676 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:24.946194 drop table if exists "invoice_override_test"; [] gorptest: 22:59:24.952916 drop table if exists "person_test"; [] gorptest: 22:59:24.959507 drop table if exists "ignored_column_test"; [] gorptest: 22:59:24.968295 drop table if exists "id_created_test"; [] gorptest: 22:59:24.977888 drop table if exists "type_conv_test"; [] gorptest: 22:59:24.984292 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:24.991494 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:24.998015 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.005198 drop table if exists "time_test"; [] gorptest: 22:59:25.014714 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.20s) === RUN TestWithStringPk gorptest: 22:59:25.014882 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 22:59:25.021563 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 22:59:25.027692 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.02s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2022/08/09 22:59:25 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: 22:59:25.034466 drop table if exists "invoice_test"; [] gorptest: 22:59:25.034690 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.034740 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.034788 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.034830 drop table if exists "person_test"; [] gorptest: 22:59:25.034873 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.034924 drop table if exists "id_created_test"; [] gorptest: 22:59:25.034966 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.035008 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.035050 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.035093 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.035142 drop table if exists "time_test"; [] gorptest: 22:59:25.035205 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.041306 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: 22:59:25.048462 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.058303 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.064517 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.070569 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.076913 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.083355 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.089707 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.095665 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:25.101944 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:25.108343 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:25.115274 insert into "time_test" ("Id","Time") values (null,?); [1:2022-08-09 22:28:25.115253711 +0000 UTC] gorptest: 22:59:25.121282 insert into "time_test" ("Id","Time") values (null,?); [1:2022-08-09 22:29:26.115253711 +0000 UTC] gorptest: 22:59:25.127769 SELECT id FROM time_test WHERE Time < ? [1:2022-08-09 22:29:25.115253711 +0000 UTC] gorptest: 22:59:25.127887 drop table if exists "invoice_test"; [] gorptest: 22:59:25.134259 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.140797 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.147075 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.156182 drop table if exists "person_test"; [] gorptest: 22:59:25.162757 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.169181 drop table if exists "id_created_test"; [] gorptest: 22:59:25.175556 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.182136 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.188306 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.195971 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.202168 drop table if exists "time_test"; [] gorptest: 22:59:25.208169 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.17s) === RUN TestInvoicePersonView 2022/08/09 22:59:25 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: 22:59:25.208354 drop table if exists "invoice_test"; [] gorptest: 22:59:25.208576 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.208643 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.208704 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.208755 drop table if exists "person_test"; [] gorptest: 22:59:25.208804 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.208846 drop table if exists "id_created_test"; [] gorptest: 22:59:25.208888 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.208930 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.208982 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.209031 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.209080 drop table if exists "time_test"; [] gorptest: 22:59:25.209133 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.215182 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: 22:59:25.222246 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.228459 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.234435 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.240656 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.246922 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.253494 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.259496 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.265932 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:25.274452 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:25.282909 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:25.290050 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085965290026704 2:1660085965290026704 3:"bob" 4:"smith" 5:1] gorptest: 22:59:25.296039 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 22:59:25.304382 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 22:59:25.304513 drop table if exists "invoice_test"; [] gorptest: 22:59:25.310490 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.317170 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.323203 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.329459 drop table if exists "person_test"; [] gorptest: 22:59:25.335768 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.341522 drop table if exists "id_created_test"; [] gorptest: 22:59:25.351199 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.368366 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.377926 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.385178 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.392246 drop table if exists "time_test"; [] gorptest: 22:59:25.399066 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.19s) === RUN TestQuoteTableNames 2022/08/09 22:59:25 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: 22:59:25.399262 drop table if exists "invoice_test"; [] gorptest: 22:59:25.399474 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.399525 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.399573 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.399616 drop table if exists "person_test"; [] gorptest: 22:59:25.399659 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.399709 drop table if exists "id_created_test"; [] gorptest: 22:59:25.399763 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.399818 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.399866 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.399915 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.399961 drop table if exists "time_test"; [] gorptest: 22:59:25.400019 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.406573 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: 22:59:25.413839 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.422728 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.429690 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.436892 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.443430 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.449658 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.455846 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.462893 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:25.471401 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:25.478143 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.17s) === RUN TestSelectTooManyCols 2022/08/09 22:59:25 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: 22:59:25.573349 drop table if exists "invoice_test"; [] gorptest: 22:59:25.573556 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.573616 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.573666 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.573712 drop table if exists "person_test"; [] gorptest: 22:59:25.573757 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.573807 drop table if exists "id_created_test"; [] gorptest: 22:59:25.573854 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.573902 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.573950 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.573994 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.574034 drop table if exists "time_test"; [] gorptest: 22:59:25.574086 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.580077 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: 22:59:25.586101 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.595795 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.604311 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.610902 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.618055 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.624658 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.633721 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.643094 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:25.649340 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:25.655673 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:25.661914 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085965661896173 2:1660085965661896173 3:"bob" 4:"smith" 5:1] gorptest: 22:59:25.668210 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085965668183208 2:1660085965668183208 3:"jane" 4:"doe" 5:1] gorptest: 22:59:25.674401 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:25.674513 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 22:59:25.674622 select * from person_test where Id=? [1:1] gorptest: 22:59:25.674732 select * from person_test order by fname asc [] gorptest: 22:59:25.674881 drop table if exists "invoice_test"; [] gorptest: 22:59:25.683634 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.690261 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.696439 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.703624 drop table if exists "person_test"; [] gorptest: 22:59:25.709847 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.717449 drop table if exists "id_created_test"; [] gorptest: 22:59:25.724765 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.731482 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.737667 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.745330 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.752665 drop table if exists "time_test"; [] gorptest: 22:59:25.758639 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.19s) === RUN TestSelectSingleVal 2022/08/09 22:59:25 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: 22:59:25.758840 drop table if exists "invoice_test"; [] gorptest: 22:59:25.759050 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.759108 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.759158 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.759207 drop table if exists "person_test"; [] gorptest: 22:59:25.759256 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.759299 drop table if exists "id_created_test"; [] gorptest: 22:59:25.759341 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.759392 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.759439 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.759489 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.759536 drop table if exists "time_test"; [] gorptest: 22:59:25.759590 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.765891 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: 22:59:25.771967 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.778314 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.785267 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.792196 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.799026 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.805195 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.815003 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.821040 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:25.827367 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:25.833565 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:25.839565 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085965839547427 2:1660085965839547427 3:"bob" 4:"smith" 5:1] gorptest: 22:59:25.846604 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:59:25.846729 select * from person_test where Id=? [1:1] gorptest: 22:59:25.846855 select FName from person_test where Id=? [1:1] gorptest: 22:59:25.846924 select * from person_test where Id=? [1:1] gorptest: 22:59:25.847054 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 22:59:25.847180 select * from person_test where Id=? [1:-2222] gorptest: 22:59:25.847306 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1660085965847289317 2:1660085965847289317 3:"bob" 4:"smith" 5:1] gorptest: 22:59:25.853322 select * from person_test where Fname='bob' [] gorptest: 22:59:25.853483 select * from person_test where Id=-123 [] gorptest: 22:59:25.853569 select * from person_test where Id=-123 [] gorptest: 22:59:25.853651 select * from person_test where Id=-123 [] gorptest: 22:59:25.853735 select * from person_test where Id=-123 [] gorptest: 22:59:25.853811 drop table if exists "invoice_test"; [] gorptest: 22:59:25.859723 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.866283 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.872706 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.879756 drop table if exists "person_test"; [] gorptest: 22:59:25.885938 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.893008 drop table if exists "id_created_test"; [] gorptest: 22:59:25.899269 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.906123 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.912223 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.920110 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.926155 drop table if exists "time_test"; [] gorptest: 22:59:25.932750 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.17s) === RUN TestSelectAlias 2022/08/09 22:59:25 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: 22:59:25.932992 drop table if exists "invoice_test"; [] gorptest: 22:59:25.933225 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:25.933286 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:25.933338 drop table if exists "invoice_override_test"; [] gorptest: 22:59:25.933390 drop table if exists "person_test"; [] gorptest: 22:59:25.933439 drop table if exists "ignored_column_test"; [] gorptest: 22:59:25.933491 drop table if exists "id_created_test"; [] gorptest: 22:59:25.933540 drop table if exists "type_conv_test"; [] gorptest: 22:59:25.933582 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:25.933626 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:25.933675 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:25.933718 drop table if exists "time_test"; [] gorptest: 22:59:25.933771 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.940010 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: 22:59:25.946248 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:25.952631 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:25.958520 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:25.965530 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.971516 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:25.977583 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:25.985682 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:25.992162 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:26.008132 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:26.017377 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:26.023468 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 22:59:26.030063 select * from id_created_test where Id=1 [] gorptest: 22:59:26.030160 SELECT *, 1 AS external FROM id_created_test [] gorptest: 22:59:26.030245 drop table if exists "invoice_test"; [] gorptest: 22:59:26.036952 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:26.043819 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:26.050001 drop table if exists "invoice_override_test"; [] gorptest: 22:59:26.057074 drop table if exists "person_test"; [] gorptest: 22:59:26.063645 drop table if exists "ignored_column_test"; [] gorptest: 22:59:26.069939 drop table if exists "id_created_test"; [] gorptest: 22:59:26.076914 drop table if exists "type_conv_test"; [] gorptest: 22:59:26.083366 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:26.090551 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:26.096893 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:26.103304 drop table if exists "time_test"; [] gorptest: 22:59:26.112657 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.18s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2022/08/09 22:59:26 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:26.112900 drop table if exists "invoice_test"; [] gorptest: 22:59:26.113078 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:26.113117 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:26.113148 drop table if exists "invoice_override_test"; [] gorptest: 22:59:26.113180 drop table if exists "person_test"; [] gorptest: 22:59:26.113212 drop table if exists "ignored_column_test"; [] gorptest: 22:59:26.113237 drop table if exists "id_created_test"; [] gorptest: 22:59:26.113261 drop table if exists "type_conv_test"; [] gorptest: 22:59:26.113286 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:26.113314 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:26.113346 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:26.113378 drop table if exists "time_test"; [] gorptest: 22:59:26.113415 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:26.122550 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: 22:59:26.131504 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:26.140841 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:26.152819 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:26.162039 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:26.171471 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:26.182095 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:26.191031 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:26.203030 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:26.212544 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:26.221116 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:26.230451 drop table if exists "invoice_test"; [] gorptest: 22:59:26.242433 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:26.251976 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:26.263519 drop table if exists "invoice_override_test"; [] gorptest: 22:59:26.272804 drop table if exists "person_test"; [] gorptest: 22:59:26.283317 drop table if exists "ignored_column_test"; [] gorptest: 22:59:26.295105 drop table if exists "id_created_test"; [] gorptest: 22:59:26.304075 drop table if exists "type_conv_test"; [] gorptest: 22:59:26.312892 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:26.322040 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:26.330925 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:26.340057 drop table if exists "time_test"; [] gorptest: 22:59:26.348709 drop table if exists "id_created_test"; [] gorptest: 22:59:26.348785 drop table if exists "single_column_table"; [] gorptest: 22:59:26.348858 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: 22:59:26.358117 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: 22:59:26.367207 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:26.376698 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: 22:59:26.382920 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: 22:59:27.101677 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:27.108468 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:27.115867 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:27.122396 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:27.130272 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:27.139506 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: 22:59:27.146154 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:27.155839 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:59:27.155896 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 22:59:27.165611 delete from "invoice_test"; [] gorptest: 22:59:27.174324 delete from "invoice_tag_test"; [] gorptest: 22:59:27.180357 delete from "alias_trans_field_test"; [] gorptest: 22:59:27.188531 delete from "invoice_override_test"; [] gorptest: 22:59:27.195145 delete from "person_test"; [] gorptest: 22:59:27.201888 delete from "ignored_column_test"; [] gorptest: 22:59:27.209660 delete from "id_created_test"; [] gorptest: 22:59:27.216059 delete from "type_conv_test"; [] gorptest: 22:59:27.222165 delete from "embedded_struct_test"; [] gorptest: 22:59:27.228200 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:27.234385 delete from "embedded_autoincr_test"; [] gorptest: 22:59:27.240718 delete from "time_test"; [] gorptest: 22:59:27.246968 delete from "id_created_test"; [] gorptest: 22:59:27.253505 delete from "single_column_table"; [] gorptest: 22:59:27.260649 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 22:59:27.260745 drop table if exists "invoice_test"; [] gorptest: 22:59:27.266908 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:27.274375 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:27.281407 drop table if exists "invoice_override_test"; [] gorptest: 22:59:27.287898 drop table if exists "person_test"; [] gorptest: 22:59:27.294332 drop table if exists "ignored_column_test"; [] gorptest: 22:59:27.300632 drop table if exists "id_created_test"; [] gorptest: 22:59:27.306669 drop table if exists "type_conv_test"; [] gorptest: 22:59:27.312599 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:27.319468 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:27.325903 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:27.332224 drop table if exists "time_test"; [] gorptest: 22:59:27.338811 drop table if exists "id_created_test"; [] gorptest: 22:59:27.338887 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (1.23s) === RUN TestPrepare 2022/08/09 22:59:27 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:59:27.345414 drop table if exists "invoice_test"; [] gorptest: 22:59:27.345664 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:27.345717 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:27.345762 drop table if exists "invoice_override_test"; [] gorptest: 22:59:27.345824 drop table if exists "person_test"; [] gorptest: 22:59:27.345887 drop table if exists "ignored_column_test"; [] gorptest: 22:59:27.345941 drop table if exists "id_created_test"; [] gorptest: 22:59:27.345998 drop table if exists "type_conv_test"; [] gorptest: 22:59:27.346060 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:27.346103 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:27.346153 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:27.346204 drop table if exists "time_test"; [] gorptest: 22:59:27.346258 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:27.352264 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: 22:59:27.357964 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:59:27.364020 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:59:27.371121 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:59:27.377764 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:27.384800 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:59:27.391457 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:59:27.398982 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:59:27.405583 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:59:27.412202 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:59:27.418756 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:59:27.425414 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 22:59:27.431781 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 22:59:27.438317 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 22:59:27.445856 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 22:59:27.446011 begin; [] gorptest: 22:59:27.446059 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 22:59:27.446168 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:59:27.446471 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:59:27.446589 commit; [] gorptest: 22:59:27.452686 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:59:27.452843 drop table if exists "invoice_test"; [] gorptest: 22:59:27.459696 drop table if exists "invoice_tag_test"; [] gorptest: 22:59:27.466499 drop table if exists "alias_trans_field_test"; [] gorptest: 22:59:27.473261 drop table if exists "invoice_override_test"; [] gorptest: 22:59:27.480231 drop table if exists "person_test"; [] gorptest: 22:59:27.486973 drop table if exists "ignored_column_test"; [] gorptest: 22:59:27.493417 drop table if exists "id_created_test"; [] gorptest: 22:59:27.499858 drop table if exists "type_conv_test"; [] gorptest: 22:59:27.506556 drop table if exists "embedded_struct_test"; [] gorptest: 22:59:27.513055 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:59:27.519547 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:59:27.526093 drop table if exists "time_test"; [] gorptest: 22:59:27.533379 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.19s) PASS ok gopkg.in/gorp.v1 9.767s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary dpkg-genchanges --build=binary >../golang-gopkg-gorp.v1_1.7.2-2_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) I: copying local configuration I: user script /srv/workspace/pbuilder/30150/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/30150/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/30150 and its subdirectories I: Current time: Wed Aug 10 12:59:30 +14 2022 I: pbuilder-time-stamp: 1660085970