I: pbuilder: network access will be disabled during build I: Current time: Wed Jul 28 01:44:01 +14 2021 I: pbuilder-time-stamp: 1627386241 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.3CcUKw5d/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/30978/tmp/hooks/D01_modify_environment starting debug: Running on jtx1c. 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/30978/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/30978/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]="arm-unknown-linux-gnueabihf") 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=armhf DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=4' DIRSTACK=() DISTRIBUTION= EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=arm HOST_ARCH=armhf IFS=' ' INVOCATION_ID=2f8b7198e274429380ef8ed9da7fad96 LANG=C LANGUAGE=it_CH:it LC_ALL=C MACHTYPE=arm-unknown-linux-gnueabihf MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnueabihf 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=30978 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.8ZwQZIGrkW/pbuilderrc_N5nz --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.8ZwQZIGrkW/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=114 SUDO_UID=108 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://10.0.0.15:8000/ I: uname -a Linux i-capture-the-hostname 5.10.0-8-arm64 #1 SMP Debian 5.10.46-2 (2021-07-20) aarch64 GNU/Linux I: ls -l /bin total 3580 -rwxr-xr-x 1 root root 816764 Jun 22 16:26 bash -rwxr-xr-x 3 root root 26052 Jul 21 2020 bunzip2 -rwxr-xr-x 3 root root 26052 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 26052 Jul 21 2020 bzip2 -rwxr-xr-x 1 root root 9636 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 26668 Sep 23 2020 cat -rwxr-xr-x 1 root root 43104 Sep 23 2020 chgrp -rwxr-xr-x 1 root root 38984 Sep 23 2020 chmod -rwxr-xr-x 1 root root 43112 Sep 23 2020 chown -rwxr-xr-x 1 root root 92616 Sep 23 2020 cp -rwxr-xr-x 1 root root 75524 Dec 11 2020 dash -rwxr-xr-x 1 root root 75880 Sep 23 2020 date -rwxr-xr-x 1 root root 55436 Sep 23 2020 dd -rwxr-xr-x 1 root root 59912 Sep 23 2020 df -rwxr-xr-x 1 root root 96764 Sep 23 2020 dir -rwxr-xr-x 1 root root 55012 Feb 8 04:38 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 22508 Sep 23 2020 echo -rwxr-xr-x 1 root root 28 Nov 10 2020 egrep -rwxr-xr-x 1 root root 22496 Sep 23 2020 false -rwxr-xr-x 1 root root 28 Nov 10 2020 fgrep -rwxr-xr-x 1 root root 47492 Feb 8 04:38 findmnt -rwsr-xr-x 1 root root 26076 Feb 27 06:12 fusermount -rwxr-xr-x 1 root root 124508 Nov 10 2020 grep -rwxr-xr-x 2 root root 2346 Mar 3 13:30 gunzip -rwxr-xr-x 1 root root 6376 Mar 3 13:30 gzexe -rwxr-xr-x 1 root root 64212 Mar 3 13:30 gzip -rwxr-xr-x 1 root root 13784 Nov 8 2019 hostname -rwxr-xr-x 1 root root 43180 Sep 23 2020 ln -rwxr-xr-x 1 root root 35068 Feb 8 2020 login -rwxr-xr-x 1 root root 96764 Sep 23 2020 ls -rwxr-xr-x 1 root root 99940 Feb 8 04:38 lsblk -rwxr-xr-x 1 root root 51408 Sep 23 2020 mkdir -rwxr-xr-x 1 root root 43184 Sep 23 2020 mknod -rwxr-xr-x 1 root root 30780 Sep 23 2020 mktemp -rwxr-xr-x 1 root root 34408 Feb 8 04:38 more -rwsr-xr-x 1 root root 34400 Feb 8 04:38 mount -rwxr-xr-x 1 root root 9824 Feb 8 04:38 mountpoint -rwxr-xr-x 1 root root 88524 Sep 23 2020 mv lrwxrwxrwx 1 root root 8 Nov 8 2019 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 19 05:38 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 26652 Sep 23 2020 pwd lrwxrwxrwx 1 root root 4 Jun 22 16:26 rbash -> bash -rwxr-xr-x 1 root root 30740 Sep 23 2020 readlink -rwxr-xr-x 1 root root 43104 Sep 23 2020 rm -rwxr-xr-x 1 root root 30732 Sep 23 2020 rmdir -rwxr-xr-x 1 root root 14144 Sep 28 2020 run-parts -rwxr-xr-x 1 root root 76012 Dec 23 2018 sed lrwxrwxrwx 1 root root 4 Jul 28 01:44 sh -> bash lrwxrwxrwx 1 root root 4 Jul 26 23:25 sh.distrib -> dash -rwxr-xr-x 1 root root 22532 Sep 23 2020 sleep -rwxr-xr-x 1 root root 55360 Sep 23 2020 stty -rwsr-xr-x 1 root root 46704 Feb 8 04:38 su -rwxr-xr-x 1 root root 22532 Sep 23 2020 sync -rwxr-xr-x 1 root root 340872 Feb 17 23:55 tar -rwxr-xr-x 1 root root 9808 Sep 28 2020 tempfile -rwxr-xr-x 1 root root 67696 Sep 23 2020 touch -rwxr-xr-x 1 root root 22496 Sep 23 2020 true -rwxr-xr-x 1 root root 9636 Feb 27 06:12 ulockmgr_server -rwsr-xr-x 1 root root 22108 Feb 8 04:38 umount -rwxr-xr-x 1 root root 22520 Sep 23 2020 uname -rwxr-xr-x 2 root root 2346 Mar 3 13:30 uncompress -rwxr-xr-x 1 root root 96764 Sep 23 2020 vdir -rwxr-xr-x 1 root root 38512 Feb 8 04:38 wdctl lrwxrwxrwx 1 root root 8 Nov 8 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 3 13:30 zcat -rwxr-xr-x 1 root root 1678 Mar 3 13:30 zcmp -rwxr-xr-x 1 root root 5880 Mar 3 13:30 zdiff -rwxr-xr-x 1 root root 29 Mar 3 13:30 zegrep -rwxr-xr-x 1 root root 29 Mar 3 13:30 zfgrep -rwxr-xr-x 1 root root 2081 Mar 3 13:30 zforce -rwxr-xr-x 1 root root 7585 Mar 3 13:30 zgrep -rwxr-xr-x 1 root root 2206 Mar 3 13:30 zless -rwxr-xr-x 1 root root 1842 Mar 3 13:30 zmore -rwxr-xr-x 1 root root 4553 Mar 3 13:30 znew I: user script /srv/workspace/pbuilder/30978/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: armhf Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19398 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.15-go{a} golang-1.15-src{a} golang-any{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-text-dev{a} golang-pq-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu67{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsigsegv2{a} libsqlite3-dev{a} libsub-override-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 46 newly installed, 0 to remove and 0 not upgraded. Need to get 80.7 MB of archives. After unpacking 447 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main armhf bsdextrautils armhf 2.36.1-7 [138 kB] Get: 2 http://deb.debian.org/debian bullseye/main armhf libuchardet0 armhf 0.0.7-1 [65.0 kB] Get: 3 http://deb.debian.org/debian bullseye/main armhf groff-base armhf 1.22.4-6 [847 kB] Get: 4 http://deb.debian.org/debian bullseye/main armhf libpipeline1 armhf 1.5.3-1 [30.1 kB] Get: 5 http://deb.debian.org/debian bullseye/main armhf man-db armhf 2.9.4-2 [1319 kB] Get: 6 http://deb.debian.org/debian bullseye/main armhf sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main armhf libmagic-mgc armhf 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main armhf libmagic1 armhf 1:5.39-3 [117 kB] Get: 9 http://deb.debian.org/debian bullseye/main armhf file armhf 1:5.39-3 [68.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main armhf gettext-base armhf 0.21-4 [171 kB] Get: 11 http://deb.debian.org/debian bullseye/main armhf libsigsegv2 armhf 2.13-1 [34.0 kB] Get: 12 http://deb.debian.org/debian bullseye/main armhf m4 armhf 1.4.18-5 [192 kB] Get: 13 http://deb.debian.org/debian bullseye/main armhf autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main armhf autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main armhf automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main armhf autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main armhf libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main armhf libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main armhf dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main armhf libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main armhf libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main armhf libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main armhf dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main armhf libelf1 armhf 0.183-1 [161 kB] Get: 25 http://deb.debian.org/debian bullseye/main armhf dwz armhf 0.13+20210201-1 [179 kB] Get: 26 http://deb.debian.org/debian bullseye/main armhf libicu67 armhf 67.1-7 [8319 kB] Get: 27 http://deb.debian.org/debian bullseye/main armhf libxml2 armhf 2.9.10+dfsg-6.7 [602 kB] Get: 28 http://deb.debian.org/debian bullseye/main armhf gettext armhf 0.21-4 [1243 kB] Get: 29 http://deb.debian.org/debian bullseye/main armhf intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main armhf po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main armhf debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main armhf dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main armhf golang-1.15-src armhf 1.15.9-6 [13.8 MB] Get: 34 http://deb.debian.org/debian bullseye/main armhf golang-1.15-go armhf 1.15.9-6 [43.1 MB] Get: 35 http://deb.debian.org/debian bullseye/main armhf golang-src armhf 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main armhf golang-go armhf 2:1.15~1 [23.9 kB] Get: 37 http://deb.debian.org/debian bullseye/main armhf golang-any armhf 2:1.15~1 [4976 B] Get: 38 http://deb.debian.org/debian bullseye/main armhf golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main armhf golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main armhf golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main armhf libsqlite3-dev armhf 3.34.1-3 [890 kB] Get: 44 http://deb.debian.org/debian bullseye/main armhf golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main armhf golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Get: 46 http://deb.debian.org/debian bullseye/main armhf golang-pq-dev all 1.3.0-1 [3092 B] Fetched 80.7 MB in 19s (4267 kB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package bsdextrautils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19398 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-7_armhf.deb ... Unpacking bsdextrautils (2.36.1-7) ... Selecting previously unselected package libuchardet0:armhf. Preparing to unpack .../01-libuchardet0_0.0.7-1_armhf.deb ... Unpacking libuchardet0:armhf (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_armhf.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:armhf. Preparing to unpack .../03-libpipeline1_1.5.3-1_armhf.deb ... Unpacking libpipeline1:armhf (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_armhf.deb ... Unpacking man-db (2.9.4-2) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../05-sensible-utils_0.0.14_all.deb ... Unpacking sensible-utils (0.0.14) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../06-libmagic-mgc_1%3a5.39-3_armhf.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:armhf. Preparing to unpack .../07-libmagic1_1%3a5.39-3_armhf.deb ... Unpacking libmagic1:armhf (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_armhf.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_armhf.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:armhf. Preparing to unpack .../10-libsigsegv2_2.13-1_armhf.deb ... Unpacking libsigsegv2:armhf (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_armhf.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.12.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.12.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.12.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.12.0-1) ... Selecting previously unselected package libelf1:armhf. Preparing to unpack .../23-libelf1_0.183-1_armhf.deb ... Unpacking libelf1:armhf (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_armhf.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:armhf. Preparing to unpack .../25-libicu67_67.1-7_armhf.deb ... Unpacking libicu67:armhf (67.1-7) ... Selecting previously unselected package libxml2:armhf. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_armhf.deb ... Unpacking libxml2:armhf (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_armhf.deb ... Unpacking gettext (0.21-4) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../28-intltool-debian_0.35.0+20060710.5_all.deb ... Unpacking intltool-debian (0.35.0+20060710.5) ... Selecting previously unselected package po-debconf. Preparing to unpack .../29-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../30-debhelper_13.3.4_all.deb ... Unpacking debhelper (13.3.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../31-dh-golang_1.51_all.deb ... Unpacking dh-golang (1.51) ... Selecting previously unselected package golang-1.15-src. Preparing to unpack .../32-golang-1.15-src_1.15.9-6_armhf.deb ... Unpacking golang-1.15-src (1.15.9-6) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.9-6_armhf.deb ... Unpacking golang-1.15-go (1.15.9-6) ... Selecting previously unselected package golang-src:armhf. Preparing to unpack .../34-golang-src_2%3a1.15~1_armhf.deb ... Unpacking golang-src:armhf (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_armhf.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:armhf. Preparing to unpack .../36-golang-any_2%3a1.15~1_armhf.deb ... Unpacking golang-any:armhf (2:1.15~1) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../37-golang-github-go-sql-driver-mysql-dev_1.5.0-1_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../38-golang-github-lib-pq-dev_1.3.0-1_all.deb ... Unpacking golang-github-lib-pq-dev (1.3.0-1) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../39-golang-golang-x-sys-dev_0.0~git20210124.22da62e-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../40-golang-golang-x-text-dev_0.3.6-1_all.deb ... Unpacking golang-golang-x-text-dev (0.3.6-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../41-golang-golang-x-net-dev_1%3a0.0+git20210119.5f4716e+dfsg-4_all.deb ... Unpacking golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Selecting previously unselected package libsqlite3-dev:armhf. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_armhf.deb ... Unpacking libsqlite3-dev:armhf (3.34.1-3) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev. Preparing to unpack .../43-golang-github-mattn-go-sqlite3-dev_1.6.0~ds1-2_all.deb ... Unpacking golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../44-golang-github-ziutek-mymysql-dev_1.5.4+git20170206.23.0582bcf-2_all.deb ... Unpacking golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Selecting previously unselected package golang-pq-dev. Preparing to unpack .../45-golang-pq-dev_1.3.0-1_all.deb ... Unpacking golang-pq-dev (1.3.0-1) ... Setting up libpipeline1:armhf (1.5.3-1) ... Setting up bsdextrautils (2.36.1-7) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:armhf (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.9-6) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libdebhelper-perl (13.3.4) ... Setting up golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Setting up libmagic1:armhf (1:5.39-3) ... Setting up gettext-base (0.21-4) ... Setting up golang-github-lib-pq-dev (1.3.0-1) ... Setting up file (1:5.39-3) ... Setting up autotools-dev (20180224.1+nmu1) ... Setting up libsqlite3-dev:armhf (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:armhf (2.13-1) ... Setting up autopoint (0.21-4) ... Setting up sensible-utils (0.0.14) ... Setting up golang-golang-x-text-dev (0.3.6-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Setting up libuchardet0:armhf (0.0.7-1) ... Setting up libsub-override-perl (0.09-2) ... Setting up golang-pq-dev (1.3.0-1) ... Setting up golang-src:armhf (2:1.15~1) ... Setting up golang-1.15-go (1.15.9-6) ... Setting up libelf1:armhf (0.183-1) ... Setting up libxml2:armhf (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.12.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up golang-go (2:1.15~1) ... Setting up m4 (1.4.18-5) ... Setting up golang-any:armhf (2:1.15~1) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.12.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Setting up debhelper (13.3.4) ... Setting up dh-golang (1.51) ... Processing triggers for libc-bin (2.31-13) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps 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 armhf libnumber-compare-perl all 0.03-1.1 [6956 B] Get:2 http://deb.debian.org/debian bullseye/main armhf libtext-glob-perl all 0.11-1 [8888 B] Get:3 http://deb.debian.org/debian bullseye/main armhf libfile-find-rule-perl all 0.34-1 [30.6 kB] Get:4 http://deb.debian.org/debian bullseye/main armhf usrmerge all 25 [13.0 kB] debconf: delaying package configuration, since apt-utils is not installed Fetched 59.5 kB in 0s (713 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 ... 33702 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 hostname: Name or service not known I: Running cd /build/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture armhf debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 4 gopkg.in/gorp.v1 internal/race internal/unsafeheader internal/cpu runtime/internal/sys unicode sync/atomic internal/bytealg runtime/internal/atomic runtime/internal/math unicode/utf8 math/bits internal/testlog runtime math internal/reflectlite sync errors sort io internal/oserror strconv syscall bytes strings reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context internal/poll internal/fmtsort os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 4 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.272703 drop table if exists "invoice_test"; [] gorptest: 11:46:08.273719 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.273840 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.273943 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.274029 drop table if exists "person_test"; [] gorptest: 11:46:08.274108 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.274186 drop table if exists "id_created_test"; [] gorptest: 11:46:08.274289 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.274383 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.274462 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.274560 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.274635 drop table if exists "time_test"; [] gorptest: 11:46:08.274766 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.279877 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.283547 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.287734 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.291850 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.295958 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.300501 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.304450 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.308331 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.312468 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.316233 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.320268 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.324329 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.324494 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.324624 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.324751 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.324866 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.324984 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.325069 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.325176 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.325290 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.325382 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.325485 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.325574 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.325657 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:46:08.325737 drop table if exists "invoice_test"; [] gorptest: 11:46:08.329319 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.332765 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.336734 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.340957 drop table if exists "person_test"; [] gorptest: 11:46:08.344519 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.359216 drop table if exists "id_created_test"; [] gorptest: 11:46:08.363344 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.367170 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.372899 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.376143 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.379296 drop table if exists "time_test"; [] gorptest: 11:46:08.382682 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.11s) === RUN TestTruncateTables 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.383512 drop table if exists "invoice_test"; [] gorptest: 11:46:08.384309 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.384485 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.384660 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.384828 drop table if exists "person_test"; [] gorptest: 11:46:08.385069 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.385245 drop table if exists "id_created_test"; [] gorptest: 11:46:08.385406 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.385556 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.385725 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.385877 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.386028 drop table if exists "time_test"; [] gorptest: 11:46:08.386221 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.390495 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.393650 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.397580 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.400958 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.403893 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.407210 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.410191 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.414305 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.417690 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.421458 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.424093 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.427448 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.427577 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.427663 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.427746 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.427834 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.427907 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.427985 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.428068 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.428174 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.428260 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.428345 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.428421 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.428491 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:46:08.428648 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386368428565736 2:1627386368428565736 3:"Bob" 4:"Smith" 5:1] gorptest: 11:46:08.431950 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 11:46:08.435361 delete from "invoice_test"; [] gorptest: 11:46:08.438570 delete from "invoice_tag_test"; [] gorptest: 11:46:08.442021 delete from "alias_trans_field_test"; [] gorptest: 11:46:08.444742 delete from "invoice_override_test"; [] gorptest: 11:46:08.448156 delete from "person_test"; [] gorptest: 11:46:08.450955 delete from "ignored_column_test"; [] gorptest: 11:46:08.453895 delete from "id_created_test"; [] gorptest: 11:46:08.457314 delete from "type_conv_test"; [] gorptest: 11:46:08.460300 delete from "embedded_struct_test"; [] gorptest: 11:46:08.464130 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.466806 delete from "embedded_autoincr_test"; [] gorptest: 11:46:08.469198 delete from "time_test"; [] gorptest: 11:46:08.472411 delete from "id_created_test"; [] gorptest: 11:46:08.475099 SELECT * FROM person_test [] gorptest: 11:46:08.475499 SELECT * FROM invoice_test [] gorptest: 11:46:08.475759 drop table if exists "invoice_test"; [] gorptest: 11:46:08.479218 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.482761 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.486574 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.489400 drop table if exists "person_test"; [] gorptest: 11:46:08.492506 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.495843 drop table if exists "id_created_test"; [] gorptest: 11:46:08.499144 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.502776 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.505433 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.507747 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.510721 drop table if exists "time_test"; [] gorptest: 11:46:08.514054 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.13s) === RUN TestCustomDateType gorptest: 11:46:08.514732 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 11:46:08.519062 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2021-07-27 11:46:08 +0000 UTC] gorptest: 11:46:08.522402 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 11:46:08.522702 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.01s) === RUN TestUIntPrimaryKey gorptest: 11:46:08.526061 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:46:08.529957 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:46:08.532611 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 11:46:08.536133 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 11:46:08.539478 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 11:46:08.542781 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 11:46:08.545511 drop table if exists "PersonUInt64"; [] gorptest: 11:46:08.548784 drop table if exists "PersonUInt32"; [] gorptest: 11:46:08.552406 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.03s) === RUN TestSetUniqueTogether gorptest: 11:46:08.555765 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 11:46:08.560124 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 11:46:08.563230 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 11:46:08.563510 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 11:46:08.563718 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 11:46:08.567045 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.02s) === RUN TestPersistentUser gorptest: 11:46:08.571231 drop table if exists PersistentUser [] gorptest: 11:46:08.571711 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:46:08.575333 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:46:08.578207 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 11:46:08.578500 select * from PersistentUser [] gorptest: 11:46:08.578774 select * from PersistentUser [] gorptest: 11:46:08.578999 select * from PersistentUser [] gorptest: 11:46:08.579212 select Id from PersistentUser [] gorptest: 11:46:08.579371 select mykey from PersistentUser [] gorptest: 11:46:08.579528 select PassedTraining from PersistentUser [] gorptest: 11:46:08.579679 select Id from PersistentUser [] gorptest: 11:46:08.579835 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.01s) === RUN TestNamedQueryMap gorptest: 11:46:08.583654 drop table if exists PersistentUser [] gorptest: 11:46:08.584291 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:46:08.587703 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:46:08.590200 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 11:46:08.593583 select * from PersistentUser where mykey = ? [1:43] gorptest: 11:46:08.593839 select * from PersistentUser where mykey = ? [1:43] gorptest: 11:46:08.594022 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 11:46:08.594210 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 11:46:08.594397 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.01s) === RUN TestNamedQueryStruct gorptest: 11:46:08.597727 drop table if exists PersistentUser [] gorptest: 11:46:08.598381 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 11:46:08.602108 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 11:46:08.605694 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 11:46:08.608317 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 11:46:08.608614 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.01s) === RUN TestReturnsNonNilSlice 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.612443 drop table if exists "invoice_test"; [] gorptest: 11:46:08.612906 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.613005 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.613086 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.613170 drop table if exists "person_test"; [] gorptest: 11:46:08.613251 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.613334 drop table if exists "id_created_test"; [] gorptest: 11:46:08.613414 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.613495 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.613584 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.613654 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.613722 drop table if exists "time_test"; [] gorptest: 11:46:08.613836 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.618277 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.621598 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.625017 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.628379 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.631713 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.635639 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.638947 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.641840 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.645691 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.649384 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.653428 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.657123 select * from invoice_test where id=99999 [] gorptest: 11:46:08.657489 select * from invoice_test where id=99999 [] gorptest: 11:46:08.657751 drop table if exists "invoice_test"; [] gorptest: 11:46:08.662000 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.665346 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.668245 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.672046 drop table if exists "person_test"; [] gorptest: 11:46:08.675125 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.678342 drop table if exists "id_created_test"; [] gorptest: 11:46:08.681333 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.684744 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.688222 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.690992 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.693563 drop table if exists "time_test"; [] gorptest: 11:46:08.696122 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.08s) === RUN TestOverrideVersionCol gorptest: 11:46:08.696571 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 11:46:08.701000 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] gorptest: 11:46:08.701343 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.01s) === RUN TestOptimisticLocking 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.705371 drop table if exists "invoice_test"; [] gorptest: 11:46:08.706014 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.706119 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.706206 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.706325 drop table if exists "person_test"; [] gorptest: 11:46:08.706402 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.706482 drop table if exists "id_created_test"; [] gorptest: 11:46:08.706554 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.706744 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.706828 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.706915 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.707006 drop table if exists "time_test"; [] gorptest: 11:46:08.707103 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.710160 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.713090 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.716455 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.720335 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.723537 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.726621 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.729262 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.732627 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.736221 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.739579 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.742619 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.745641 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386368745550958 2:1627386368745550958 3:"Bob" 4:"Smith" 5:1] gorptest: 11:46:08.748682 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:08.748985 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386368745550958 2:1627386368745550958 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 11:46:08.752372 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386368745550958 2:1627386368745550958 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 11:46:08.752557 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:08.752746 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 11:46:08.752866 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:08.753004 drop table if exists "invoice_test"; [] gorptest: 11:46:08.756725 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.759603 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.762968 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.766342 drop table if exists "person_test"; [] gorptest: 11:46:08.770018 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.774539 drop table if exists "id_created_test"; [] gorptest: 11:46:08.778786 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.782222 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.785444 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.788680 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.792034 drop table if exists "time_test"; [] gorptest: 11:46:08.794988 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.09s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 11:46:08.795503 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 11:46:08.798735 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 11:46:08.801873 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 11:46:08.802370 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] gorptest: 11:46:08.805817 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 11:46:08.806175 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.01s) === RUN TestColumnProps gorptest: 11:46:08.810331 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 11:46:08.813979 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 11:46:08.816994 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 11:46:08.817234 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 11:46:08.817414 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 11:46:08.817530 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.01s) === RUN TestRawSelect 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.821501 drop table if exists "invoice_test"; [] gorptest: 11:46:08.822124 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.822274 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.822410 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.822532 drop table if exists "person_test"; [] gorptest: 11:46:08.822655 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.822789 drop table if exists "id_created_test"; [] gorptest: 11:46:08.822911 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.823095 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.823221 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.823380 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.823510 drop table if exists "time_test"; [] gorptest: 11:46:08.823659 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.827326 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:08.831060 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:08.834890 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.839060 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:08.841959 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.845044 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:08.847924 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:08.851263 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:08.855265 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:08.858397 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:08.861420 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:08.864349 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386368864280222 2:1627386368864280222 3:"bob" 4:"smith" 5:1] gorptest: 11:46:08.867215 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 11:46:08.870499 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 11:46:08.870867 drop table if exists "invoice_test"; [] gorptest: 11:46:08.874609 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.878182 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.881744 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.885102 drop table if exists "person_test"; [] gorptest: 11:46:08.888530 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.891708 drop table if exists "id_created_test"; [] gorptest: 11:46:08.895213 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.909119 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.944813 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.949673 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.978787 drop table if exists "time_test"; [] gorptest: 11:46:08.989320 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.17s) === RUN TestHooks 2021/07/27 11:46:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:08.990425 drop table if exists "invoice_test"; [] gorptest: 11:46:08.991492 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:08.991811 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:08.992057 drop table if exists "invoice_override_test"; [] gorptest: 11:46:08.992272 drop table if exists "person_test"; [] gorptest: 11:46:08.992507 drop table if exists "ignored_column_test"; [] gorptest: 11:46:08.992707 drop table if exists "id_created_test"; [] gorptest: 11:46:08.992903 drop table if exists "type_conv_test"; [] gorptest: 11:46:08.993099 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:08.993293 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:08.993490 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:08.993705 drop table if exists "time_test"; [] gorptest: 11:46:08.993954 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:08.999248 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.003860 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.008181 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.011524 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.014588 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.017725 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.021857 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.025626 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.028880 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.031793 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.035052 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.038739 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386369038644547 2:1627386369038644547 3:"bob" 4:"smith" 5:1] gorptest: 11:46:09.043052 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:09.043528 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1627386369038644547 2:1627386369038644547 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 11:46:09.046830 select * from person_test where id = ? [1:1] gorptest: 11:46:09.047277 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 11:46:09.050432 drop table if exists "invoice_test"; [] gorptest: 11:46:09.053761 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.056851 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.059308 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.062612 drop table if exists "person_test"; [] gorptest: 11:46:09.066570 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.069907 drop table if exists "id_created_test"; [] gorptest: 11:46:09.073216 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.076249 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.079163 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.082723 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.086316 drop table if exists "time_test"; [] gorptest: 11:46:09.089455 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.10s) === RUN TestTransaction 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.090161 drop table if exists "invoice_test"; [] gorptest: 11:46:09.090923 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.091036 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.091122 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.091198 drop table if exists "person_test"; [] gorptest: 11:46:09.091271 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.091345 drop table if exists "id_created_test"; [] gorptest: 11:46:09.091417 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.091490 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.091566 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.091642 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.091717 drop table if exists "time_test"; [] gorptest: 11:46:09.091846 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.094728 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.097860 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.101419 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.105852 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.109227 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.112526 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.115707 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.118930 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.122647 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.125845 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.128749 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.132345 begin; [] gorptest: 11:46:09.132484 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 11:46:09.132826 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 11:46:09.132924 commit; [] gorptest: 11:46:09.135670 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.135925 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 11:46:09.136113 drop table if exists "invoice_test"; [] gorptest: 11:46:09.139753 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.142748 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.146132 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.149813 drop table if exists "person_test"; [] gorptest: 11:46:09.153159 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.156652 drop table if exists "id_created_test"; [] gorptest: 11:46:09.159469 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.162514 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.165179 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.168418 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.172182 drop table if exists "time_test"; [] gorptest: 11:46:09.175220 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.09s) === RUN TestSavepoint 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.175721 drop table if exists "invoice_test"; [] gorptest: 11:46:09.176186 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.176282 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.176364 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.176447 drop table if exists "person_test"; [] gorptest: 11:46:09.176529 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.176610 drop table if exists "id_created_test"; [] gorptest: 11:46:09.176696 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.176783 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.176866 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.176981 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.177062 drop table if exists "time_test"; [] gorptest: 11:46:09.177166 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.180328 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.183498 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.186575 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.190417 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.193885 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.196798 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.200189 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.202823 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.206470 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.210073 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.214198 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.218480 begin; [] gorptest: 11:46:09.218647 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 11:46:09.219161 select memo from invoice_test [] gorptest: 11:46:09.219319 savepoint "foo" [1:] gorptest: 11:46:09.219368 select memo from invoice_test [] gorptest: 11:46:09.219521 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 11:46:09.219703 select memo from invoice_test [] gorptest: 11:46:09.219815 rollback to savepoint "foo" [1:] gorptest: 11:46:09.219874 select memo from invoice_test [] gorptest: 11:46:09.219966 rollback; [] gorptest: 11:46:09.220242 drop table if exists "invoice_test"; [] gorptest: 11:46:09.223611 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.226922 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.231045 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.236835 drop table if exists "person_test"; [] gorptest: 11:46:09.240203 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.243375 drop table if exists "id_created_test"; [] gorptest: 11:46:09.247094 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.250856 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.254848 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.258077 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.261227 drop table if exists "time_test"; [] gorptest: 11:46:09.264259 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.09s) === RUN TestMultiple 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.264848 drop table if exists "invoice_test"; [] gorptest: 11:46:09.265339 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.265435 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.265521 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.265601 drop table if exists "person_test"; [] gorptest: 11:46:09.265686 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.265782 drop table if exists "id_created_test"; [] gorptest: 11:46:09.265868 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.265943 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.266019 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.266100 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.266188 drop table if exists "time_test"; [] gorptest: 11:46:09.266378 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.269799 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.272612 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.276185 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.279722 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.283645 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.288204 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.292116 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.296623 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.300234 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.303972 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.306342 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.310089 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 11:46:09.313600 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 11:46:09.317020 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 11:46:09.319952 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 11:46:09.323100 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.325468 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 11:46:09.328887 drop table if exists "invoice_test"; [] gorptest: 11:46:09.332231 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.335568 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.338792 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.342462 drop table if exists "person_test"; [] gorptest: 11:46:09.345305 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.348314 drop table if exists "id_created_test"; [] gorptest: 11:46:09.351058 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.354205 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.357917 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.360726 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.363689 drop table if exists "time_test"; [] gorptest: 11:46:09.366540 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.10s) === RUN TestCrud 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.367019 drop table if exists "invoice_test"; [] gorptest: 11:46:09.367506 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.367601 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.367686 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.367765 drop table if exists "person_test"; [] gorptest: 11:46:09.367856 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.367935 drop table if exists "id_created_test"; [] gorptest: 11:46:09.368010 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.368095 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.368170 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.368381 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.368505 drop table if exists "time_test"; [] gorptest: 11:46:09.368676 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.372355 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.375469 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.378840 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.382810 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.385717 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.389017 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.391976 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.395729 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.399206 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.402316 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.404898 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.408158 delete from invoice_test [] gorptest: 11:46:09.411069 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 11:46:09.414572 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.415041 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] gorptest: 11:46:09.418455 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.418811 select * from invoice_test [] gorptest: 11:46:09.419186 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.421958 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 11:46:09.422172 delete from invoice_tag_test [] gorptest: 11:46:09.425388 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] gorptest: 11:46:09.428283 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:46:09.428706 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] gorptest: 11:46:09.431867 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:46:09.432214 select * from invoice_tag_test [] gorptest: 11:46:09.432601 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:46:09.435976 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 11:46:09.436259 delete from alias_trans_field_test [] gorptest: 11:46:09.439124 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 11:46:09.442220 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:46:09.442478 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 11:46:09.445690 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:46:09.445883 select * from alias_trans_field_test [] gorptest: 11:46:09.446094 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:46:09.448951 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 11:46:09.449168 drop table if exists "invoice_test"; [] gorptest: 11:46:09.452447 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.456239 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.459337 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.462666 drop table if exists "person_test"; [] gorptest: 11:46:09.465058 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.467885 drop table if exists "id_created_test"; [] gorptest: 11:46:09.471208 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.474294 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.477706 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.481026 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.484179 drop table if exists "time_test"; [] gorptest: 11:46:09.487477 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.12s) === RUN TestWithIgnoredColumn 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.487959 drop table if exists "invoice_test"; [] gorptest: 11:46:09.488402 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.488501 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.488586 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.488675 drop table if exists "person_test"; [] gorptest: 11:46:09.488758 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.488834 drop table if exists "id_created_test"; [] gorptest: 11:46:09.488919 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.488997 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.489071 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.489151 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.489228 drop table if exists "time_test"; [] gorptest: 11:46:09.489328 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.492403 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.495583 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.499335 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.502727 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.506023 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.508725 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.512044 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.515229 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.518651 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.521711 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.524902 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.528787 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 11:46:09.531702 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:46:09.531922 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:46:09.534934 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 11:46:09.535159 drop table if exists "invoice_test"; [] gorptest: 11:46:09.538046 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.541221 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.544364 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.547994 drop table if exists "person_test"; [] gorptest: 11:46:09.550950 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.553877 drop table if exists "id_created_test"; [] gorptest: 11:46:09.557119 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.560388 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.563996 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.566615 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.569821 drop table if exists "time_test"; [] gorptest: 11:46:09.573343 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.09s) === RUN TestTypeConversionExample 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.573820 drop table if exists "invoice_test"; [] gorptest: 11:46:09.574384 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.574529 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.574696 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.574830 drop table if exists "person_test"; [] gorptest: 11:46:09.574952 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.575070 drop table if exists "id_created_test"; [] gorptest: 11:46:09.575200 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.575334 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.575452 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.575570 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.575685 drop table if exists "time_test"; [] gorptest: 11:46:09.575855 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.581441 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.585449 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.589034 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.592293 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.596004 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.599180 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.603145 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.606097 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.609545 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.611958 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.615395 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.618846 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] gorptest: 11:46:09.621790 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:46:09.622187 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] gorptest: 11:46:09.625859 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:46:09.626403 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 11:46:09.629853 drop table if exists "invoice_test"; [] gorptest: 11:46:09.634408 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.638039 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.641120 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.644875 drop table if exists "person_test"; [] gorptest: 11:46:09.648192 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.651579 drop table if exists "id_created_test"; [] gorptest: 11:46:09.654587 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.657771 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.660634 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.663857 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.667498 drop table if exists "time_test"; [] gorptest: 11:46:09.670206 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.10s) === RUN TestWithEmbeddedStruct 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.670818 drop table if exists "invoice_test"; [] gorptest: 11:46:09.671316 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.671413 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.671614 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.671696 drop table if exists "person_test"; [] gorptest: 11:46:09.671801 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.671899 drop table if exists "id_created_test"; [] gorptest: 11:46:09.672004 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.672128 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.672211 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.672369 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.672452 drop table if exists "time_test"; [] gorptest: 11:46:09.672610 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.675798 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.679274 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.682491 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.686496 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.689176 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.692086 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.695466 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.698137 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.702131 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.705241 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.709050 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.711554 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 11:46:09.714436 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 11:46:09.714728 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 11:46:09.718138 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 11:46:09.718438 select * from embedded_struct_test [] gorptest: 11:46:09.718712 drop table if exists "invoice_test"; [] gorptest: 11:46:09.721621 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.724935 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.728643 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.731418 drop table if exists "person_test"; [] gorptest: 11:46:09.733978 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.736612 drop table if exists "id_created_test"; [] gorptest: 11:46:09.739755 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.743828 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.747667 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.750833 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.754236 drop table if exists "time_test"; [] gorptest: 11:46:09.757594 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.09s) === RUN TestWithEmbeddedStructBeforeAutoincr 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.758161 drop table if exists "invoice_test"; [] gorptest: 11:46:09.758965 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.759131 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.759288 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.759433 drop table if exists "person_test"; [] gorptest: 11:46:09.759564 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.759715 drop table if exists "id_created_test"; [] gorptest: 11:46:09.759826 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.759981 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.760101 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.760240 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.760376 drop table if exists "time_test"; [] gorptest: 11:46:09.760546 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.767173 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.770901 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.773954 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.777295 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.780190 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.783941 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.787176 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.790435 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.793723 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.796304 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.799901 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.803108 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 11:46:09.806451 drop table if exists "invoice_test"; [] gorptest: 11:46:09.810091 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.812777 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.815645 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.818897 drop table if exists "person_test"; [] gorptest: 11:46:09.822716 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.825967 drop table if exists "id_created_test"; [] gorptest: 11:46:09.829263 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.832113 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.835077 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.838465 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.841084 drop table if exists "time_test"; [] gorptest: 11:46:09.843842 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.09s) === RUN TestWithEmbeddedAutoincr 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.844487 drop table if exists "invoice_test"; [] gorptest: 11:46:09.845121 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.845269 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.845406 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.845527 drop table if exists "person_test"; [] gorptest: 11:46:09.845649 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.845770 drop table if exists "id_created_test"; [] gorptest: 11:46:09.845896 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.846025 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.846160 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.846301 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.846427 drop table if exists "time_test"; [] gorptest: 11:46:09.846610 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.850085 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.854334 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.857280 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.860579 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.863237 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.866953 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.870925 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.874877 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.878371 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.882012 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.885944 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.889497 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 11:46:09.893192 drop table if exists "invoice_test"; [] gorptest: 11:46:09.895470 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.898392 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.901569 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.905465 drop table if exists "person_test"; [] gorptest: 11:46:09.908960 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.912332 drop table if exists "id_created_test"; [] gorptest: 11:46:09.915270 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.918186 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.921512 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.924215 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.929186 drop table if exists "time_test"; [] gorptest: 11:46:09.933072 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.09s) === RUN TestSelectVal gorptest: 11:46:09.933742 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 11:46:09.938582 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] gorptest: 11:46:09.941686 select Int64 from TableWithNull where Str='abc' [] gorptest: 11:46:09.941908 select count(*) from TableWithNull [] gorptest: 11:46:09.942041 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 11:46:09.942165 select Int64 from TableWithNull where Str='notfound' [] gorptest: 11:46:09.942282 select Int64 from TableWithNull where Str='abc' [] gorptest: 11:46:09.942391 select Float64 from TableWithNull where Str='abc' [] gorptest: 11:46:09.942483 select min(Float64) from TableWithNull [] gorptest: 11:46:09.942590 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 11:46:09.942720 select Float64 from TableWithNull where Str='notfound' [] gorptest: 11:46:09.942814 select Float64 from TableWithNull where Str='abc' [] gorptest: 11:46:09.942911 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:46:09.943004 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 11:46:09.943088 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:46:09.943179 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 11:46:09.943314 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 11:46:09.943428 select Str from TableWithNull where Int64=? [1:78] gorptest: 11:46:09.943529 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows 2021/07/27 11:46:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:09.947416 drop table if exists "invoice_test"; [] gorptest: 11:46:09.948082 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:09.948234 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:09.948375 drop table if exists "invoice_override_test"; [] gorptest: 11:46:09.948502 drop table if exists "person_test"; [] gorptest: 11:46:09.948636 drop table if exists "ignored_column_test"; [] gorptest: 11:46:09.948777 drop table if exists "id_created_test"; [] gorptest: 11:46:09.948906 drop table if exists "type_conv_test"; [] gorptest: 11:46:09.949032 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:09.949157 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:09.949284 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:09.949410 drop table if exists "time_test"; [] gorptest: 11:46:09.949567 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.953949 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:09.957748 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:09.961893 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:09.965734 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:09.969304 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.972378 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:09.975565 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:09.979428 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:09.982272 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:09.985516 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:09.988446 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:09.992275 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386369992180707 2:1627386369992180707 3:"Bob" 4:"Smith" 5:1] gorptest: 11:46:09.995768 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386369995719160 2:1627386369995719160 3:"Jane" 4:"Smith" 5:1] gorptest: 11:46:09.998673 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386369998624912 2:1627386369998624912 3:"Mike" 4:"Smith" 5:1] gorptest: 11:46:10.001476 drop table if exists "invoice_test"; [] gorptest: 11:46:10.004961 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.008242 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.011162 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.014692 drop table if exists "person_test"; [] gorptest: 11:46:10.018410 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.021210 drop table if exists "id_created_test"; [] gorptest: 11:46:10.024256 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.027174 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.030431 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.034139 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.037609 drop table if exists "time_test"; [] gorptest: 11:46:10.040198 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.09s) === RUN TestWithStringPk gorptest: 11:46:10.040549 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 11:46:10.043606 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 11:46:10.046970 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.01s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.051065 drop table if exists "invoice_test"; [] gorptest: 11:46:10.051780 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.051914 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.052068 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.052255 drop table if exists "person_test"; [] gorptest: 11:46:10.052376 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.052519 drop table if exists "id_created_test"; [] gorptest: 11:46:10.052733 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.052875 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.053025 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.053209 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.053339 drop table if exists "time_test"; [] gorptest: 11:46:10.053558 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.057240 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.060879 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.063540 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.067120 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.070051 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.073972 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.076864 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.080513 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.083521 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.086680 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.089684 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.093032 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-27 11:15:10.092967653 +0000 UTC] gorptest: 11:46:10.096890 insert into "time_test" ("Id","Time") values (null,?); [1:2021-07-27 11:16:11.092967653 +0000 UTC] gorptest: 11:46:10.100144 SELECT id FROM time_test WHERE Time < ? [1:2021-07-27 11:16:10.092967653 +0000 UTC] gorptest: 11:46:10.100392 drop table if exists "invoice_test"; [] gorptest: 11:46:10.103136 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.106107 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.109675 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.112830 drop table if exists "person_test"; [] gorptest: 11:46:10.115864 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.119000 drop table if exists "id_created_test"; [] gorptest: 11:46:10.122117 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.125559 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.128577 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.131354 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.134807 drop table if exists "time_test"; [] gorptest: 11:46:10.138184 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.09s) === RUN TestInvoicePersonView 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.138917 drop table if exists "invoice_test"; [] gorptest: 11:46:10.139688 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.139836 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.140031 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.140168 drop table if exists "person_test"; [] gorptest: 11:46:10.140320 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.140437 drop table if exists "id_created_test"; [] gorptest: 11:46:10.140616 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.140695 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.140838 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.140914 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.141013 drop table if exists "time_test"; [] gorptest: 11:46:10.141169 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.144631 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.147348 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.150954 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.154455 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.158001 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.160791 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.164947 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.174663 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.178852 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.182876 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.186523 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.190074 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386370190005887 2:1627386370190005887 3:"bob" 4:"smith" 5:1] gorptest: 11:46:10.193718 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 11:46:10.196911 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 11:46:10.197405 drop table if exists "invoice_test"; [] gorptest: 11:46:10.201275 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.204615 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.207308 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.210315 drop table if exists "person_test"; [] gorptest: 11:46:10.212991 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.216561 drop table if exists "id_created_test"; [] gorptest: 11:46:10.220014 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.223274 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.225847 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.228416 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.231765 drop table if exists "time_test"; [] gorptest: 11:46:10.234583 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.10s) === RUN TestQuoteTableNames 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.235241 drop table if exists "invoice_test"; [] gorptest: 11:46:10.235882 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.236039 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.236178 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.236316 drop table if exists "person_test"; [] gorptest: 11:46:10.236449 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.236571 drop table if exists "id_created_test"; [] gorptest: 11:46:10.236685 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.236811 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.236950 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.237075 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.237191 drop table if exists "time_test"; [] gorptest: 11:46:10.237376 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.240903 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.244386 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.246771 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.250116 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.252825 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.255835 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.259775 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.262758 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.266526 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.269214 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.272600 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.08s) === RUN TestSelectTooManyCols 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.314748 drop table if exists "invoice_test"; [] gorptest: 11:46:10.315210 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.315293 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.315369 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.315455 drop table if exists "person_test"; [] gorptest: 11:46:10.315528 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.315596 drop table if exists "id_created_test"; [] gorptest: 11:46:10.315660 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.315740 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.315809 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.315876 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.315942 drop table if exists "time_test"; [] gorptest: 11:46:10.316046 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.319545 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.322775 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.326721 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.329813 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.333417 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.336090 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.339645 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.342675 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.346095 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.349025 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.351955 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.355804 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386370355735508 2:1627386370355735508 3:"bob" 4:"smith" 5:1] gorptest: 11:46:10.358647 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386370358542094 2:1627386370358542094 3:"jane" 4:"doe" 5:1] gorptest: 11:46:10.361919 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:10.362242 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 11:46:10.362665 select * from person_test where Id=? [1:1] gorptest: 11:46:10.362981 select * from person_test order by fname asc [] gorptest: 11:46:10.363450 drop table if exists "invoice_test"; [] gorptest: 11:46:10.367466 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.370471 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.373133 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.375983 drop table if exists "person_test"; [] gorptest: 11:46:10.379552 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.382814 drop table if exists "id_created_test"; [] gorptest: 11:46:10.386166 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.389068 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.391937 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.395338 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.398508 drop table if exists "time_test"; [] gorptest: 11:46:10.402045 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.09s) === RUN TestSelectSingleVal 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.402740 drop table if exists "invoice_test"; [] gorptest: 11:46:10.403388 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.403535 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.403681 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.403799 drop table if exists "person_test"; [] gorptest: 11:46:10.403920 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.404039 drop table if exists "id_created_test"; [] gorptest: 11:46:10.404157 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.404271 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.404386 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.404504 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.404636 drop table if exists "time_test"; [] gorptest: 11:46:10.404785 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.407981 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.411678 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.414542 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.418107 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.421236 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.424698 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.428133 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.432142 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.436419 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.440392 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.444372 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.447792 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386370447701815 2:1627386370447701815 3:"bob" 4:"smith" 5:1] gorptest: 11:46:10.451398 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 11:46:10.451740 select * from person_test where Id=? [1:1] gorptest: 11:46:10.452027 select FName from person_test where Id=? [1:1] gorptest: 11:46:10.452192 select * from person_test where Id=? [1:1] gorptest: 11:46:10.452424 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 11:46:10.452621 select * from person_test where Id=? [1:-2222] gorptest: 11:46:10.452856 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1627386370452793742 2:1627386370452793742 3:"bob" 4:"smith" 5:1] gorptest: 11:46:10.456009 select * from person_test where Fname='bob' [] gorptest: 11:46:10.456335 select * from person_test where Id=-123 [] gorptest: 11:46:10.456500 select * from person_test where Id=-123 [] gorptest: 11:46:10.456609 select * from person_test where Id=-123 [] gorptest: 11:46:10.456773 select * from person_test where Id=-123 [] gorptest: 11:46:10.456887 drop table if exists "invoice_test"; [] gorptest: 11:46:10.459599 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.462607 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.466417 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.469571 drop table if exists "person_test"; [] gorptest: 11:46:10.473100 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.476487 drop table if exists "id_created_test"; [] gorptest: 11:46:10.479811 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.484037 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.487935 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.491117 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.493632 drop table if exists "time_test"; [] gorptest: 11:46:10.496149 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.09s) === RUN TestSelectAlias 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.496635 drop table if exists "invoice_test"; [] gorptest: 11:46:10.497109 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.497215 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.497298 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.497396 drop table if exists "person_test"; [] gorptest: 11:46:10.497488 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.497574 drop table if exists "id_created_test"; [] gorptest: 11:46:10.497650 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.497727 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.497813 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.497888 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.497961 drop table if exists "time_test"; [] gorptest: 11:46:10.498069 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.501867 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.505216 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.508670 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.511648 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.514659 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.517019 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.519970 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.523628 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.526554 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.530430 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.533063 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.536346 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 11:46:10.539158 select * from id_created_test where Id=1 [] gorptest: 11:46:10.539382 SELECT *, 1 AS external FROM id_created_test [] gorptest: 11:46:10.539625 drop table if exists "invoice_test"; [] gorptest: 11:46:10.542866 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.546420 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.549530 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.553074 drop table if exists "person_test"; [] gorptest: 11:46:10.555919 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.558451 drop table if exists "id_created_test"; [] gorptest: 11:46:10.561797 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.565360 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.568744 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.571718 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.574237 drop table if exists "time_test"; [] gorptest: 11:46:10.577297 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.08s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.577896 drop table if exists "invoice_test"; [] gorptest: 11:46:10.578418 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.578519 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.578604 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.578691 drop table if exists "person_test"; [] gorptest: 11:46:10.578776 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.578852 drop table if exists "id_created_test"; [] gorptest: 11:46:10.578933 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.579011 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.579087 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.579166 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.579242 drop table if exists "time_test"; [] gorptest: 11:46:10.579387 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.583472 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.586545 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.590138 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.593118 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.596411 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.599253 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.602200 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.605170 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.608767 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.611621 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.614785 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.618276 drop table if exists "invoice_test"; [] gorptest: 11:46:10.620749 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.624059 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.627178 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.630556 drop table if exists "person_test"; [] gorptest: 11:46:10.633674 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.636227 drop table if exists "id_created_test"; [] gorptest: 11:46:10.639481 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.642478 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.645513 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.648502 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.651452 drop table if exists "time_test"; [] gorptest: 11:46:10.654660 drop table if exists "id_created_test"; [] gorptest: 11:46:10.654783 drop table if exists "single_column_table"; [] gorptest: 11:46:10.654904 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.658705 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.661296 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.664567 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.667774 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.671514 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.674649 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.677607 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.680138 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.683084 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.685646 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.688947 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.692714 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 11:46:10.692878 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 11:46:10.696521 delete from "invoice_test"; [] gorptest: 11:46:10.698869 delete from "invoice_tag_test"; [] gorptest: 11:46:10.701886 delete from "alias_trans_field_test"; [] gorptest: 11:46:10.704527 delete from "invoice_override_test"; [] gorptest: 11:46:10.707268 delete from "person_test"; [] gorptest: 11:46:10.710473 delete from "ignored_column_test"; [] gorptest: 11:46:10.713070 delete from "id_created_test"; [] gorptest: 11:46:10.716266 delete from "type_conv_test"; [] gorptest: 11:46:10.718900 delete from "embedded_struct_test"; [] gorptest: 11:46:10.721654 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.723986 delete from "embedded_autoincr_test"; [] gorptest: 11:46:10.726840 delete from "time_test"; [] gorptest: 11:46:10.729278 delete from "id_created_test"; [] gorptest: 11:46:10.732272 delete from "single_column_table"; [] gorptest: 11:46:10.735740 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 11:46:10.735960 drop table if exists "invoice_test"; [] gorptest: 11:46:10.738476 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.741207 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.744669 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.748878 drop table if exists "person_test"; [] gorptest: 11:46:10.752779 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.756607 drop table if exists "id_created_test"; [] gorptest: 11:46:10.761242 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.765412 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.769648 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.772950 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.775880 drop table if exists "time_test"; [] gorptest: 11:46:10.778867 drop table if exists "id_created_test"; [] gorptest: 11:46:10.778991 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.20s) === RUN TestPrepare 2021/07/27 11:46:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 11:46:10.782304 drop table if exists "invoice_test"; [] gorptest: 11:46:10.782812 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.782916 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.783001 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.783079 drop table if exists "person_test"; [] gorptest: 11:46:10.783156 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.783250 drop table if exists "id_created_test"; [] gorptest: 11:46:10.783337 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.783413 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.783488 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.783575 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.783644 drop table if exists "time_test"; [] gorptest: 11:46:10.783736 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.787520 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 11:46:10.790611 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 11:46:10.794534 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 11:46:10.798101 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 11:46:10.802707 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.806864 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 11:46:10.811689 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 11:46:10.816943 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 11:46:10.820615 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 11:46:10.825783 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 11:46:10.829539 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 11:46:10.833449 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 11:46:10.836453 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 11:46:10.839483 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 11:46:10.842769 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 11:46:10.843080 begin; [] gorptest: 11:46:10.843152 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 11:46:10.843410 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:46:10.844100 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:46:10.844306 commit; [] gorptest: 11:46:10.846912 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 11:46:10.847232 drop table if exists "invoice_test"; [] gorptest: 11:46:10.850342 drop table if exists "invoice_tag_test"; [] gorptest: 11:46:10.854683 drop table if exists "alias_trans_field_test"; [] gorptest: 11:46:10.858941 drop table if exists "invoice_override_test"; [] gorptest: 11:46:10.864247 drop table if exists "person_test"; [] gorptest: 11:46:10.868699 drop table if exists "ignored_column_test"; [] gorptest: 11:46:10.872245 drop table if exists "id_created_test"; [] gorptest: 11:46:10.876179 drop table if exists "type_conv_test"; [] gorptest: 11:46:10.880942 drop table if exists "embedded_struct_test"; [] gorptest: 11:46:10.885910 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 11:46:10.889989 drop table if exists "embedded_autoincr_test"; [] gorptest: 11:46:10.893326 drop table if exists "time_test"; [] gorptest: 11:46:10.896939 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.12s) PASS ok gopkg.in/gorp.v1 2.642s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary dpkg-genchanges --build=binary >../golang-gopkg-gorp.v1_1.7.2-2_armhf.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: user script /srv/workspace/pbuilder/30978/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/30978/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/30978 and its subdirectories I: Current time: Wed Jul 28 01:46:18 +14 2021 I: pbuilder-time-stamp: 1627386378