I: pbuilder: network access will be disabled during build I: Current time: Sun Apr 23 12:34:20 +14 2023 I: pbuilder-time-stamp: 1682202860 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bookworm-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. 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: 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: cannot verify inline signature for ./golang-gopkg-gorp.v1_1.7.2-2.dsc: no acceptable signature found 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/14986/tmp/hooks/D01_modify_environment starting debug: Running on codethink12-arm64. 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 '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 Apr 23 12:34 /bin/sh -> /bin/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/14986/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/14986/tmp/hooks/D02_print_environment starting I: set BASH=/bin/sh BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath BASH_ALIASES=() BASH_ARGC=() BASH_ARGV=() BASH_CMDS=() BASH_LINENO=([0]="12" [1]="0") BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") BASH_VERSINFO=([0]="5" [1]="2" [2]="15" [3]="1" [4]="release" [5]="aarch64-unknown-linux-gnu") BASH_VERSION='5.2.15(1)-release' BUILDDIR=/build BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' BUILDUSERNAME=pbuilder2 BUILD_ARCH=arm64 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=8' DIRSTACK=() DISTRIBUTION=bookworm EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/var/lib/jenkins HOSTNAME=i-capture-the-hostname HOSTTYPE=aarch64 HOST_ARCH=arm64 IFS=' ' LANG=C LANGUAGE=nl_BE:nl LC_ALL=C MACHTYPE=aarch64-unknown-linux-gnu MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnu PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path PBCURRENTCOMMANDLINEOPERATION=build PBUILDER_OPERATION=build PBUILDER_PKGDATADIR=/usr/share/pbuilder PBUILDER_PKGLIBDIR=/usr/lib/pbuilder PBUILDER_SYSCONFDIR=/etc PIPESTATUS=([0]="0") POSIXLY_CORRECT=y PPID=14986 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/r-b-build.UL7eA8ov/pbuilderrc_QUwk --distribution bookworm --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.UL7eA8ov/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=117 SUDO_UID=110 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root USERNAME=root _='I: set' http_proxy=http://192.168.101.16:3128 I: uname -a Linux i-capture-the-hostname 4.15.0-209-generic #220-Ubuntu SMP Tue Mar 21 19:52:44 UTC 2023 aarch64 GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 Apr 22 00:25 /bin -> usr/bin I: user script /srv/workspace/pbuilder/14986/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: arm64 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 ... 19616 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.19-go{a} golang-1.19-src{a} golang-any{a} golang-github-davecgh-go-spew-dev{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-gorilla-securecookie-dev{a} golang-github-gorilla-sessions-dev{a} golang-github-hashicorp-go-uuid-dev{a} golang-github-jcmturner-aescts.v2-dev{a} golang-github-jcmturner-dnsutils.v2-dev{a} golang-github-jcmturner-gofork-dev{a} golang-github-jcmturner-goidentity.v6-dev{a} golang-github-jcmturner-gokrb5.v8-dev{a} golang-github-jcmturner-rpc.v2-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-pmezard-go-difflib-dev{a} golang-github-stretchr-objx-dev{a} golang-github-stretchr-testify-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-crypto-dev{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-term-dev{a} golang-golang-x-text-dev{a} golang-gopkg-yaml.v3-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1{a} libpipeline1{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, 60 newly installed, 0 to remove and 0 not upgraded. Need to get 101 MB of archives. After unpacking 598 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bookworm/main arm64 sensible-utils all 0.0.17+nmu1 [19.0 kB] Get: 2 http://deb.debian.org/debian bookworm/main arm64 libmagic-mgc arm64 1:5.44-3 [305 kB] Get: 3 http://deb.debian.org/debian bookworm/main arm64 libmagic1 arm64 1:5.44-3 [98.5 kB] Get: 4 http://deb.debian.org/debian bookworm/main arm64 file arm64 1:5.44-3 [42.5 kB] Get: 5 http://deb.debian.org/debian bookworm/main arm64 gettext-base arm64 0.21-12 [159 kB] Get: 6 http://deb.debian.org/debian bookworm/main arm64 libuchardet0 arm64 0.0.7-1 [67.9 kB] Get: 7 http://deb.debian.org/debian bookworm/main arm64 groff-base arm64 1.22.4-10 [861 kB] Get: 8 http://deb.debian.org/debian bookworm/main arm64 bsdextrautils arm64 2.38.1-5+b1 [86.9 kB] Get: 9 http://deb.debian.org/debian bookworm/main arm64 libpipeline1 arm64 1.5.7-1 [36.4 kB] Get: 10 http://deb.debian.org/debian bookworm/main arm64 man-db arm64 2.11.2-2 [1369 kB] Get: 11 http://deb.debian.org/debian bookworm/main arm64 m4 arm64 1.4.19-3 [276 kB] Get: 12 http://deb.debian.org/debian bookworm/main arm64 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian bookworm/main arm64 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian bookworm/main arm64 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian bookworm/main arm64 autopoint all 0.21-12 [495 kB] Get: 16 http://deb.debian.org/debian bookworm/main arm64 libdebhelper-perl all 13.11.4 [81.2 kB] Get: 17 http://deb.debian.org/debian bookworm/main arm64 libtool all 2.4.7-5 [517 kB] Get: 18 http://deb.debian.org/debian bookworm/main arm64 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian bookworm/main arm64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian bookworm/main arm64 libsub-override-perl all 0.09-4 [9304 B] Get: 21 http://deb.debian.org/debian bookworm/main arm64 libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian bookworm/main arm64 dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian bookworm/main arm64 libelf1 arm64 0.188-2.1 [173 kB] Get: 24 http://deb.debian.org/debian bookworm/main arm64 dwz arm64 0.15-1 [101 kB] Get: 25 http://deb.debian.org/debian bookworm/main arm64 libicu72 arm64 72.1-3 [9204 kB] Get: 26 http://deb.debian.org/debian bookworm/main arm64 libxml2 arm64 2.9.14+dfsg-1.1+b3 [619 kB] Get: 27 http://deb.debian.org/debian bookworm/main arm64 gettext arm64 0.21-12 [1248 kB] Get: 28 http://deb.debian.org/debian bookworm/main arm64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian bookworm/main arm64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian bookworm/main arm64 debhelper all 13.11.4 [942 kB] Get: 31 http://deb.debian.org/debian bookworm/main arm64 dh-golang all 1.59 [27.8 kB] Get: 32 http://deb.debian.org/debian bookworm/main arm64 golang-1.19-src all 1.19.8-2 [18.3 MB] Get: 33 http://deb.debian.org/debian bookworm/main arm64 golang-1.19-go arm64 1.19.8-2 [56.6 MB] Get: 34 http://deb.debian.org/debian bookworm/main arm64 golang-src all 2:1.19~1 [5756 B] Get: 35 http://deb.debian.org/debian bookworm/main arm64 golang-go arm64 2:1.19~1 [45.0 kB] Get: 36 http://deb.debian.org/debian bookworm/main arm64 golang-any arm64 2:1.19~1 [5876 B] Get: 37 http://deb.debian.org/debian bookworm/main arm64 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian bookworm/main arm64 golang-github-go-sql-driver-mysql-dev all 1.5.0-2 [70.9 kB] Get: 39 http://deb.debian.org/debian bookworm/main arm64 golang-github-gorilla-securecookie-dev all 1.1.1-2 [12.2 kB] Get: 40 http://deb.debian.org/debian bookworm/main arm64 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian bookworm/main arm64 golang-github-hashicorp-go-uuid-dev all 1.0.2-2 [8480 B] Get: 42 http://deb.debian.org/debian bookworm/main arm64 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian bookworm/main arm64 golang-github-stretchr-objx-dev all 0.5.0-1 [25.5 kB] Get: 44 http://deb.debian.org/debian bookworm/main arm64 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian bookworm/main arm64 golang-github-stretchr-testify-dev all 1.8.1-1 [67.9 kB] Get: 46 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian bookworm/main arm64 golang-golang-x-sys-dev all 0.3.0-1 [393 kB] Get: 51 http://deb.debian.org/debian bookworm/main arm64 golang-golang-x-text-dev all 0.7.0-1 [3863 kB] Get: 52 http://deb.debian.org/debian bookworm/main arm64 golang-golang-x-net-dev all 1:0.7.0+dfsg-1 [731 kB] Get: 53 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 54 http://deb.debian.org/debian bookworm/main arm64 golang-golang-x-term-dev all 0.3.0-1 [14.6 kB] Get: 55 http://deb.debian.org/debian bookworm/main arm64 golang-golang-x-crypto-dev all 1:0.4.0-1 [1449 kB] Get: 56 http://deb.debian.org/debian bookworm/main arm64 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian bookworm/main arm64 golang-github-lib-pq-dev all 1.10.7-2 [84.1 kB] Get: 58 http://deb.debian.org/debian bookworm/main arm64 libsqlite3-dev arm64 3.40.1-2 [979 kB] Get: 59 http://deb.debian.org/debian bookworm/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.16~ds1-1 [82.2 kB] Get: 60 http://deb.debian.org/debian bookworm/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 101 MB in 2s (56.8 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (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 ... 19616 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.17+nmu1_all.deb ... Unpacking sensible-utils (0.0.17+nmu1) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.44-3_arm64.deb ... Unpacking libmagic-mgc (1:5.44-3) ... Selecting previously unselected package libmagic1:arm64. Preparing to unpack .../02-libmagic1_1%3a5.44-3_arm64.deb ... Unpacking libmagic1:arm64 (1:5.44-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.44-3_arm64.deb ... Unpacking file (1:5.44-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-12_arm64.deb ... Unpacking gettext-base (0.21-12) ... Selecting previously unselected package libuchardet0:arm64. Preparing to unpack .../05-libuchardet0_0.0.7-1_arm64.deb ... Unpacking libuchardet0:arm64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.22.4-10_arm64.deb ... Unpacking groff-base (1.22.4-10) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.38.1-5+b1_arm64.deb ... Unpacking bsdextrautils (2.38.1-5+b1) ... Selecting previously unselected package libpipeline1:arm64. Preparing to unpack .../08-libpipeline1_1.5.7-1_arm64.deb ... Unpacking libpipeline1:arm64 (1.5.7-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.11.2-2_arm64.deb ... Unpacking man-db (2.11.2-2) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-3_arm64.deb ... Unpacking m4 (1.4.19-3) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.71-3_all.deb ... Unpacking autoconf (2.71-3) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20220109.1_all.deb ... Unpacking autotools-dev (20220109.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.16.5-1.3_all.deb ... Unpacking automake (1:1.16.5-1.3) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.21-12_all.deb ... Unpacking autopoint (0.21-12) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.11.4_all.deb ... Unpacking libdebhelper-perl (13.11.4) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.4.7-5_all.deb ... Unpacking libtool (2.4.7-5) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-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 .../19-libsub-override-perl_0.09-4_all.deb ... Unpacking libsub-override-perl (0.09-4) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../20-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../21-dh-strip-nondeterminism_1.13.1-1_all.deb ... Unpacking dh-strip-nondeterminism (1.13.1-1) ... Selecting previously unselected package libelf1:arm64. Preparing to unpack .../22-libelf1_0.188-2.1_arm64.deb ... Unpacking libelf1:arm64 (0.188-2.1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1_arm64.deb ... Unpacking dwz (0.15-1) ... Selecting previously unselected package libicu72:arm64. Preparing to unpack .../24-libicu72_72.1-3_arm64.deb ... Unpacking libicu72:arm64 (72.1-3) ... Selecting previously unselected package libxml2:arm64. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.1+b3_arm64.deb ... Unpacking libxml2:arm64 (2.9.14+dfsg-1.1+b3) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-12_arm64.deb ... Unpacking gettext (0.21-12) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../27-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../28-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../29-debhelper_13.11.4_all.deb ... Unpacking debhelper (13.11.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../30-dh-golang_1.59_all.deb ... Unpacking dh-golang (1.59) ... Selecting previously unselected package golang-1.19-src. Preparing to unpack .../31-golang-1.19-src_1.19.8-2_all.deb ... Unpacking golang-1.19-src (1.19.8-2) ... Selecting previously unselected package golang-1.19-go. Preparing to unpack .../32-golang-1.19-go_1.19.8-2_arm64.deb ... Unpacking golang-1.19-go (1.19.8-2) ... Selecting previously unselected package golang-src. Preparing to unpack .../33-golang-src_2%3a1.19~1_all.deb ... Unpacking golang-src (2:1.19~1) ... Selecting previously unselected package golang-go:arm64. Preparing to unpack .../34-golang-go_2%3a1.19~1_arm64.deb ... Unpacking golang-go:arm64 (2:1.19~1) ... Selecting previously unselected package golang-any:arm64. Preparing to unpack .../35-golang-any_2%3a1.19~1_arm64.deb ... Unpacking golang-any:arm64 (2:1.19~1) ... Selecting previously unselected package golang-github-davecgh-go-spew-dev. Preparing to unpack .../36-golang-github-davecgh-go-spew-dev_1.1.1-3_all.deb ... Unpacking golang-github-davecgh-go-spew-dev (1.1.1-3) ... 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-2_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-2) ... Selecting previously unselected package golang-github-gorilla-securecookie-dev. Preparing to unpack .../38-golang-github-gorilla-securecookie-dev_1.1.1-2_all.deb ... Unpacking golang-github-gorilla-securecookie-dev (1.1.1-2) ... Selecting previously unselected package golang-github-gorilla-sessions-dev. Preparing to unpack .../39-golang-github-gorilla-sessions-dev_1.2.1-1_all.deb ... Unpacking golang-github-gorilla-sessions-dev (1.2.1-1) ... Selecting previously unselected package golang-github-hashicorp-go-uuid-dev. Preparing to unpack .../40-golang-github-hashicorp-go-uuid-dev_1.0.2-2_all.deb ... Unpacking golang-github-hashicorp-go-uuid-dev (1.0.2-2) ... Selecting previously unselected package golang-github-pmezard-go-difflib-dev. Preparing to unpack .../41-golang-github-pmezard-go-difflib-dev_1.0.0-3_all.deb ... Unpacking golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Selecting previously unselected package golang-github-stretchr-objx-dev. Preparing to unpack .../42-golang-github-stretchr-objx-dev_0.5.0-1_all.deb ... Unpacking golang-github-stretchr-objx-dev (0.5.0-1) ... Selecting previously unselected package golang-gopkg-yaml.v3-dev. Preparing to unpack .../43-golang-gopkg-yaml.v3-dev_3.0.1-3_all.deb ... Unpacking golang-gopkg-yaml.v3-dev (3.0.1-3) ... Selecting previously unselected package golang-github-stretchr-testify-dev. Preparing to unpack .../44-golang-github-stretchr-testify-dev_1.8.1-1_all.deb ... Unpacking golang-github-stretchr-testify-dev (1.8.1-1) ... Selecting previously unselected package golang-github-jcmturner-aescts.v2-dev. Preparing to unpack .../45-golang-github-jcmturner-aescts.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-dnsutils.v2-dev. Preparing to unpack .../46-golang-github-jcmturner-dnsutils.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-gofork-dev. Preparing to unpack .../47-golang-github-jcmturner-gofork-dev_1.0.0-4_all.deb ... Unpacking golang-github-jcmturner-gofork-dev (1.0.0-4) ... Selecting previously unselected package golang-github-jcmturner-goidentity.v6-dev. Preparing to unpack .../48-golang-github-jcmturner-goidentity.v6-dev_6.0.1-2_all.deb ... Unpacking golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../49-golang-golang-x-sys-dev_0.3.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.3.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../50-golang-golang-x-text-dev_0.7.0-1_all.deb ... Unpacking golang-golang-x-text-dev (0.7.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../51-golang-golang-x-net-dev_1%3a0.7.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.7.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../52-golang-github-jcmturner-rpc.v2-dev_2.0.3-2_all.deb ... Unpacking golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../53-golang-golang-x-term-dev_0.3.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.3.0-1) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../54-golang-golang-x-crypto-dev_1%3a0.4.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.4.0-1) ... Selecting previously unselected package golang-github-jcmturner-gokrb5.v8-dev. Preparing to unpack .../55-golang-github-jcmturner-gokrb5.v8-dev_8.4.3-2_all.deb ... Unpacking golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../56-golang-github-lib-pq-dev_1.10.7-2_all.deb ... Unpacking golang-github-lib-pq-dev (1.10.7-2) ... Selecting previously unselected package libsqlite3-dev:arm64. Preparing to unpack .../57-libsqlite3-dev_3.40.1-2_arm64.deb ... Unpacking libsqlite3-dev:arm64 (3.40.1-2) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:arm64. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.16~ds1-1_arm64.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:arm64 (1.14.16~ds1-1) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../59-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) ... Setting up libpipeline1:arm64 (1.5.7-1) ... Setting up golang-github-jcmturner-gofork-dev (1.0.0-4) ... Setting up golang-github-hashicorp-go-uuid-dev (1.0.2-2) ... Setting up libicu72:arm64 (72.1-3) ... Setting up bsdextrautils (2.38.1-5+b1) ... Setting up golang-github-stretchr-objx-dev (0.5.0-1) ... Setting up libmagic-mgc (1:5.44-3) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up golang-gopkg-yaml.v3-dev (3.0.1-3) ... Setting up libdebhelper-perl (13.11.4) ... Setting up golang-golang-x-sys-dev (0.3.0-1) ... Setting up libmagic1:arm64 (1:5.44-3) ... Setting up golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Setting up gettext-base (0.21-12) ... Setting up golang-1.19-src (1.19.8-2) ... Setting up m4 (1.4.19-3) ... Setting up golang-golang-x-term-dev (0.3.0-1) ... Setting up file (1:5.44-3) ... Setting up golang-github-davecgh-go-spew-dev (1.1.1-3) ... Setting up autotools-dev (20220109.1) ... Setting up libsqlite3-dev:arm64 (3.40.1-2) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up golang-github-stretchr-testify-dev (1.8.1-1) ... Setting up golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Setting up autopoint (0.21-12) ... Setting up autoconf (2.71-3) ... Setting up sensible-utils (0.0.17+nmu1) ... Setting up golang-golang-x-text-dev (0.7.0-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-2) ... Setting up libuchardet0:arm64 (0.0.7-1) ... Setting up libsub-override-perl (0.09-4) ... Setting up golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Setting up golang-src (2:1.19~1) ... Setting up libelf1:arm64 (0.188-2.1) ... Setting up golang-github-gorilla-securecookie-dev (1.1.1-2) ... Setting up libxml2:arm64 (2.9.14+dfsg-1.1+b3) ... Setting up golang-github-gorilla-sessions-dev (1.2.1-1) ... Setting up golang-1.19-go (1.19.8-2) ... Setting up automake (1:1.16.5-1.3) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... Setting up gettext (0.21-12) ... Setting up golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Setting up libtool (2.4.7-5) ... Setting up golang-go:arm64 (2:1.19~1) ... Setting up golang-any:arm64 (2:1.19~1) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:arm64 (1.14.16~ds1-1) ... Setting up golang-golang-x-net-dev (1:0.7.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.13.1-1) ... Setting up dwz (0.15-1) ... Setting up groff-base (1.22.4-10) ... Setting up golang-golang-x-crypto-dev (1:0.4.0-1) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Setting up man-db (2.11.2-2) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.11.4) ... Setting up golang-github-lib-pq-dev (1.10.7-2) ... Setting up dh-golang (1.59) ... Processing triggers for libc-bin (2.36-9) ... 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... usrmerge is already the newest version (35). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. I: Building the package I: user script /srv/workspace/pbuilder/14986/tmp/hooks/A99_set_merged_usr starting Re-configuring usrmerge... I: user script /srv/workspace/pbuilder/14986/tmp/hooks/A99_set_merged_usr finished hostname: Temporary failure in name resolution 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 arm64 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 8 gopkg.in/gorp.v1 internal/goarch internal/unsafeheader internal/goexperiment internal/cpu internal/goos internal/race runtime/internal/syscall unicode/utf8 sync/atomic unicode internal/abi runtime/internal/math runtime/internal/sys internal/itoa math/bits runtime/internal/atomic internal/bytealg math runtime internal/reflectlite sync internal/testlog errors sort internal/oserror internal/safefilepath io path strconv syscall bytes strings reflect regexp/syntax time internal/syscall/execenv internal/syscall/unix regexp context io/fs internal/poll os internal/fmtsort fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 8 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.247199 drop table if exists "invoice_test"; [] gorptest: 12:35:28.248287 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.248387 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.248503 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.248593 drop table if exists "person_test"; [] gorptest: 12:35:28.248689 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.248807 drop table if exists "id_created_test"; [] gorptest: 12:35:28.248911 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.249008 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.249104 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.249219 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.249308 drop table if exists "time_test"; [] gorptest: 12:35:28.249412 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.250271 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: 12:35:28.250807 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.251313 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.251909 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.252429 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.252947 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.253445 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.253956 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.254472 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.254981 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.255486 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.256004 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: 12:35:28.256137 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: 12:35:28.256253 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.256362 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: 12:35:28.256491 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: 12:35:28.256604 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.256704 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.256835 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.256948 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.257055 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.257161 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: 12:35:28.257264 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.257364 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:35:28.257457 drop table if exists "invoice_test"; [] gorptest: 12:35:28.257946 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.258384 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.258825 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.259411 drop table if exists "person_test"; [] gorptest: 12:35:28.259848 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.260281 drop table if exists "id_created_test"; [] gorptest: 12:35:28.260713 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.261166 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.261595 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.262025 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.262453 drop table if exists "time_test"; [] gorptest: 12:35:28.262878 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.02s) === RUN TestTruncateTables 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.263350 drop table if exists "invoice_test"; [] gorptest: 12:35:28.263901 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.263999 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.264087 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.264166 drop table if exists "person_test"; [] gorptest: 12:35:28.264252 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.264334 drop table if exists "id_created_test"; [] gorptest: 12:35:28.264416 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.264501 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.264581 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.264663 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.264761 drop table if exists "time_test"; [] gorptest: 12:35:28.264881 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.265429 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: 12:35:28.265950 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.266458 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.267035 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.267550 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.268047 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.268561 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.269099 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.269677 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.270194 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.270724 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.271251 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: 12:35:28.271379 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: 12:35:28.271476 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.271589 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: 12:35:28.271696 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: 12:35:28.271790 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.271879 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.271969 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.272084 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.272206 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.272310 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: 12:35:28.272403 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.272490 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:35:28.272627 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928272580947 2:1682202928272580947 3:"Bob" 4:"Smith" 5:1] gorptest: 12:35:28.273051 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 12:35:28.273405 delete from "invoice_test"; [] gorptest: 12:35:28.273664 delete from "invoice_tag_test"; [] gorptest: 12:35:28.273915 delete from "alias_trans_field_test"; [] gorptest: 12:35:28.274169 delete from "invoice_override_test"; [] gorptest: 12:35:28.274433 delete from "person_test"; [] gorptest: 12:35:28.274679 delete from "ignored_column_test"; [] gorptest: 12:35:28.274925 delete from "id_created_test"; [] gorptest: 12:35:28.275186 delete from "type_conv_test"; [] gorptest: 12:35:28.275433 delete from "embedded_struct_test"; [] gorptest: 12:35:28.275678 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.275924 delete from "embedded_autoincr_test"; [] gorptest: 12:35:28.276172 delete from "time_test"; [] gorptest: 12:35:28.276418 delete from "id_created_test"; [] gorptest: 12:35:28.276661 SELECT * FROM person_test [] gorptest: 12:35:28.276932 SELECT * FROM invoice_test [] gorptest: 12:35:28.277141 drop table if exists "invoice_test"; [] gorptest: 12:35:28.277582 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.278012 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.278437 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.278981 drop table if exists "person_test"; [] gorptest: 12:35:28.279428 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.279860 drop table if exists "id_created_test"; [] gorptest: 12:35:28.280285 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.280712 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.281157 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.281586 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.282008 drop table if exists "time_test"; [] gorptest: 12:35:28.282428 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.02s) === RUN TestCustomDateType gorptest: 12:35:28.282764 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 12:35:28.283781 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-04-23 12:35:28 +1400 +14] gorptest: 12:35:28.284141 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 12:35:28.284373 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey gorptest: 12:35:28.285041 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:35:28.285966 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:35:28.286464 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:35:28.286976 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 12:35:28.287329 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 12:35:28.287665 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 12:35:28.287980 drop table if exists "PersonUInt64"; [] gorptest: 12:35:28.288423 drop table if exists "PersonUInt32"; [] gorptest: 12:35:28.288885 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether gorptest: 12:35:28.289531 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 12:35:28.290594 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 12:35:28.290958 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 12:35:28.291174 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 12:35:28.291343 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 12:35:28.291693 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser gorptest: 12:35:28.292560 drop table if exists PersistentUser [] gorptest: 12:35:28.293324 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:35:28.293885 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:35:28.294259 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 12:35:28.294488 select * from PersistentUser [] gorptest: 12:35:28.294714 select * from PersistentUser [] gorptest: 12:35:28.294934 select * from PersistentUser [] gorptest: 12:35:28.295144 select Id from PersistentUser [] gorptest: 12:35:28.295317 select mykey from PersistentUser [] gorptest: 12:35:28.295468 select PassedTraining from PersistentUser [] gorptest: 12:35:28.295607 select Id from PersistentUser [] gorptest: 12:35:28.295751 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap gorptest: 12:35:28.296329 drop table if exists PersistentUser [] gorptest: 12:35:28.296927 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:35:28.297450 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:35:28.297761 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 12:35:28.298141 select * from PersistentUser where mykey = ? [1:43] gorptest: 12:35:28.298389 select * from PersistentUser where mykey = ? [1:43] gorptest: 12:35:28.298626 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 12:35:28.298881 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 12:35:28.299099 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct gorptest: 12:35:28.299688 drop table if exists PersistentUser [] gorptest: 12:35:28.300261 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:35:28.300803 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:35:28.301122 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 12:35:28.301437 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 12:35:28.301700 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.302389 drop table if exists "invoice_test"; [] gorptest: 12:35:28.302903 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.302988 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.303060 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.303148 drop table if exists "person_test"; [] gorptest: 12:35:28.303226 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.303327 drop table if exists "id_created_test"; [] gorptest: 12:35:28.303424 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.303512 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.303606 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.303695 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.303778 drop table if exists "time_test"; [] gorptest: 12:35:28.303880 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.304421 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: 12:35:28.305064 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.305571 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.306149 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.306664 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.307162 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.307674 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.308190 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.308697 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.309227 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.309743 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.310248 select * from invoice_test where id=99999 [] gorptest: 12:35:28.310474 select * from invoice_test where id=99999 [] gorptest: 12:35:28.310689 drop table if exists "invoice_test"; [] gorptest: 12:35:28.311116 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.311547 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.311975 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.312520 drop table if exists "person_test"; [] gorptest: 12:35:28.312969 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.313396 drop table if exists "id_created_test"; [] gorptest: 12:35:28.313841 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.314281 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.314720 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.315147 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.315573 drop table if exists "time_test"; [] gorptest: 12:35:28.315998 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol gorptest: 12:35:28.316348 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 12:35:28.317448 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: 12:35:28.317688 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.318517 drop table if exists "invoice_test"; [] gorptest: 12:35:28.319078 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.319188 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.319270 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.319344 drop table if exists "person_test"; [] gorptest: 12:35:28.319415 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.319485 drop table if exists "id_created_test"; [] gorptest: 12:35:28.319577 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.319662 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.319736 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.319822 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.319916 drop table if exists "time_test"; [] gorptest: 12:35:28.320025 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.320570 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: 12:35:28.321113 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.321630 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.322217 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.322745 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.323252 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.323768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.324296 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.324926 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.325446 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.325959 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.326493 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928326451745 2:1682202928326451745 3:"Bob" 4:"Smith" 5:1] gorptest: 12:35:28.326870 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.327152 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928326451745 2:1682202928326451745 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 12:35:28.327519 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928326451745 2:1682202928326451745 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 12:35:28.327725 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.327983 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 12:35:28.328161 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.328376 drop table if exists "invoice_test"; [] gorptest: 12:35:28.328823 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.329255 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.329683 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.330218 drop table if exists "person_test"; [] gorptest: 12:35:28.330663 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.331092 drop table if exists "id_created_test"; [] gorptest: 12:35:28.331520 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.331962 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.332390 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.332836 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.333264 drop table if exists "time_test"; [] gorptest: 12:35:28.333686 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.02s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 12:35:28.334088 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 12:35:28.335076 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 12:35:28.335397 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 12:35:28.335723 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: 12:35:28.336189 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 12:35:28.336434 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps gorptest: 12:35:28.337171 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 12:35:28.338199 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 12:35:28.338584 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 12:35:28.338824 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 12:35:28.339074 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 12:35:28.339265 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.340173 drop table if exists "invoice_test"; [] gorptest: 12:35:28.340720 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.340835 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.340938 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.341032 drop table if exists "person_test"; [] gorptest: 12:35:28.341114 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.341196 drop table if exists "id_created_test"; [] gorptest: 12:35:28.341274 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.341354 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.341439 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.341549 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.341651 drop table if exists "time_test"; [] gorptest: 12:35:28.341776 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.342337 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: 12:35:28.342866 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.343388 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.343974 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.344497 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.345032 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.345546 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.346065 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.346580 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.347096 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.347614 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.348154 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928348121166 2:1682202928348121166 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.348532 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 12:35:28.349024 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 12:35:28.349311 drop table if exists "invoice_test"; [] gorptest: 12:35:28.349767 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.350203 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.350628 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.351161 drop table if exists "person_test"; [] gorptest: 12:35:28.351609 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.352034 drop table if exists "id_created_test"; [] gorptest: 12:35:28.352477 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.352929 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.353352 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.353806 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.354234 drop table if exists "time_test"; [] gorptest: 12:35:28.354667 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.01s) === RUN TestHooks 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.355127 drop table if exists "invoice_test"; [] gorptest: 12:35:28.355687 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.355790 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.355875 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.355959 drop table if exists "person_test"; [] gorptest: 12:35:28.356052 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.356142 drop table if exists "id_created_test"; [] gorptest: 12:35:28.356228 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.356309 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.356388 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.356469 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.356547 drop table if exists "time_test"; [] gorptest: 12:35:28.356661 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.357218 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: 12:35:28.357740 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.358246 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.358832 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.359447 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.359982 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.360533 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.361165 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.361717 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.362261 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.362791 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.363375 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928363329426 2:1682202928363329426 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.363785 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.364071 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928363329426 2:1682202928363329426 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 12:35:28.364426 select * from person_test where id = ? [1:1] gorptest: 12:35:28.364736 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 12:35:28.365095 drop table if exists "invoice_test"; [] gorptest: 12:35:28.365550 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.366001 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.366445 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.367005 drop table if exists "person_test"; [] gorptest: 12:35:28.367473 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.367930 drop table if exists "id_created_test"; [] gorptest: 12:35:28.368379 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.368827 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.369263 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.369697 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.370140 drop table if exists "time_test"; [] gorptest: 12:35:28.370578 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.02s) === RUN TestTransaction 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.371053 drop table if exists "invoice_test"; [] gorptest: 12:35:28.371621 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.371717 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.371820 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.371938 drop table if exists "person_test"; [] gorptest: 12:35:28.372042 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.372140 drop table if exists "id_created_test"; [] gorptest: 12:35:28.372246 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.372352 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.372446 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.372550 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.372655 drop table if exists "time_test"; [] gorptest: 12:35:28.372794 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.373374 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: 12:35:28.373902 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.374421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.375011 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.375543 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.376047 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.376569 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.377202 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.377725 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.378243 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.378759 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.379267 begin; [] gorptest: 12:35:28.379376 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 12:35:28.379655 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 12:35:28.379783 commit; [] gorptest: 12:35:28.379977 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.380221 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 12:35:28.380442 drop table if exists "invoice_test"; [] gorptest: 12:35:28.380912 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.381355 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.381789 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.382341 drop table if exists "person_test"; [] gorptest: 12:35:28.382786 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.383224 drop table if exists "id_created_test"; [] gorptest: 12:35:28.383654 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.384136 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.384577 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.385034 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.385468 drop table if exists "time_test"; [] gorptest: 12:35:28.385910 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.02s) === RUN TestSavepoint 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.386355 drop table if exists "invoice_test"; [] gorptest: 12:35:28.386905 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.387022 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.387135 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.387232 drop table if exists "person_test"; [] gorptest: 12:35:28.387332 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.387417 drop table if exists "id_created_test"; [] gorptest: 12:35:28.387497 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.387589 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.387696 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.387782 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.387864 drop table if exists "time_test"; [] gorptest: 12:35:28.387958 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.388512 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: 12:35:28.389145 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.389680 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.390284 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.390821 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.391335 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.391864 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.392393 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.392951 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.393492 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.394016 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.394540 begin; [] gorptest: 12:35:28.394662 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 12:35:28.394928 select memo from invoice_test [] gorptest: 12:35:28.395091 savepoint "foo" [1:] gorptest: 12:35:28.395140 select memo from invoice_test [] gorptest: 12:35:28.395294 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 12:35:28.395446 select memo from invoice_test [] gorptest: 12:35:28.395580 rollback to savepoint "foo" [1:] gorptest: 12:35:28.395640 select memo from invoice_test [] gorptest: 12:35:28.395790 rollback; [] gorptest: 12:35:28.395943 drop table if exists "invoice_test"; [] gorptest: 12:35:28.396371 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.396828 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.397265 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.397809 drop table if exists "person_test"; [] gorptest: 12:35:28.398249 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.398675 drop table if exists "id_created_test"; [] gorptest: 12:35:28.399108 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.399537 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.399969 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.400405 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.400869 drop table if exists "time_test"; [] gorptest: 12:35:28.401294 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.02s) === RUN TestMultiple 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.401736 drop table if exists "invoice_test"; [] gorptest: 12:35:28.402264 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.402359 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.402460 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.402559 drop table if exists "person_test"; [] gorptest: 12:35:28.402648 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.402731 drop table if exists "id_created_test"; [] gorptest: 12:35:28.402817 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.402902 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.403013 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.403105 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.403211 drop table if exists "time_test"; [] gorptest: 12:35:28.403324 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.403879 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: 12:35:28.404408 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.404947 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.405540 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.406063 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.406573 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.407087 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.407610 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.408135 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.408662 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.409316 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.409899 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 12:35:28.410277 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 12:35:28.410652 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 12:35:28.410997 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 12:35:28.411336 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.411647 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 12:35:28.411938 drop table if exists "invoice_test"; [] gorptest: 12:35:28.412385 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.412845 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.413284 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.413838 drop table if exists "person_test"; [] gorptest: 12:35:28.414292 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.414745 drop table if exists "id_created_test"; [] gorptest: 12:35:28.415191 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.415647 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.416090 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.416524 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.416979 drop table if exists "time_test"; [] gorptest: 12:35:28.417424 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.02s) === RUN TestCrud 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.417873 drop table if exists "invoice_test"; [] gorptest: 12:35:28.418453 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.418559 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.418675 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.418777 drop table if exists "person_test"; [] gorptest: 12:35:28.418876 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.418959 drop table if exists "id_created_test"; [] gorptest: 12:35:28.419027 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.419096 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.419162 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.419230 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.419297 drop table if exists "time_test"; [] gorptest: 12:35:28.419405 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.419971 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: 12:35:28.420520 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.421138 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.421757 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.422312 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.422827 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.423374 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.423915 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.424446 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.425079 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.425624 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.426167 delete from invoice_test [] gorptest: 12:35:28.426469 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 12:35:28.426870 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.427181 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: 12:35:28.427535 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.427779 select * from invoice_test [] gorptest: 12:35:28.428063 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.428373 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:35:28.428572 delete from invoice_tag_test [] gorptest: 12:35:28.428878 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: 12:35:28.429279 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:35:28.429551 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: 12:35:28.429900 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:35:28.430131 select * from invoice_tag_test [] gorptest: 12:35:28.430418 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:35:28.430720 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:35:28.430912 delete from alias_trans_field_test [] gorptest: 12:35:28.431168 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 12:35:28.431506 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:35:28.431712 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 12:35:28.432018 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:35:28.432200 select * from alias_trans_field_test [] gorptest: 12:35:28.432423 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:35:28.432714 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:35:28.432897 drop table if exists "invoice_test"; [] gorptest: 12:35:28.433341 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.433787 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.434279 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.434823 drop table if exists "person_test"; [] gorptest: 12:35:28.435252 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.435706 drop table if exists "id_created_test"; [] gorptest: 12:35:28.436145 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.436574 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.437020 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.437453 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.437879 drop table if exists "time_test"; [] gorptest: 12:35:28.438300 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.02s) === RUN TestWithIgnoredColumn 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.438714 drop table if exists "invoice_test"; [] gorptest: 12:35:28.439280 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.439368 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.439434 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.439495 drop table if exists "person_test"; [] gorptest: 12:35:28.439563 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.439665 drop table if exists "id_created_test"; [] gorptest: 12:35:28.439744 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.439810 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.439872 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.439933 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.439997 drop table if exists "time_test"; [] gorptest: 12:35:28.440101 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.440633 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: 12:35:28.441292 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.441796 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.442376 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.442888 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.443410 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.443909 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.444422 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.444959 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.445530 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.446073 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.446657 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 12:35:28.447041 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:35:28.447280 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:35:28.447627 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:35:28.447818 drop table if exists "invoice_test"; [] gorptest: 12:35:28.448313 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.448787 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.449265 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.449842 drop table if exists "person_test"; [] gorptest: 12:35:28.450308 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.450781 drop table if exists "id_created_test"; [] gorptest: 12:35:28.451239 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.451691 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.452147 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.452600 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.453149 drop table if exists "time_test"; [] gorptest: 12:35:28.453611 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.02s) === RUN TestTypeConversionExample 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.454148 drop table if exists "invoice_test"; [] gorptest: 12:35:28.454763 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.454857 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.454968 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.455078 drop table if exists "person_test"; [] gorptest: 12:35:28.455167 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.455243 drop table if exists "id_created_test"; [] gorptest: 12:35:28.455325 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.455422 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.455523 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.455618 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.455705 drop table if exists "time_test"; [] gorptest: 12:35:28.455800 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.456385 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: 12:35:28.456966 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.457524 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.458143 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.458684 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.459246 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.459802 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.460340 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.461014 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.461553 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.462091 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.462772 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: 12:35:28.463149 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:35:28.463460 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: 12:35:28.463811 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:35:28.464081 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:35:28.464402 drop table if exists "invoice_test"; [] gorptest: 12:35:28.464872 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.465334 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.465789 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.466374 drop table if exists "person_test"; [] gorptest: 12:35:28.466833 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.467276 drop table if exists "id_created_test"; [] gorptest: 12:35:28.467713 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.468181 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.468639 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.469116 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.469566 drop table if exists "time_test"; [] gorptest: 12:35:28.470047 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.02s) === RUN TestWithEmbeddedStruct 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.470516 drop table if exists "invoice_test"; [] gorptest: 12:35:28.471111 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.471212 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.471298 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.471395 drop table if exists "person_test"; [] gorptest: 12:35:28.471491 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.471578 drop table if exists "id_created_test"; [] gorptest: 12:35:28.471680 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.471779 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.471860 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.471937 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.472005 drop table if exists "time_test"; [] gorptest: 12:35:28.472086 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.472640 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: 12:35:28.473191 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.473722 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.474346 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.474876 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.475417 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.475960 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.476505 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.477219 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.477797 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.478349 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.478926 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 12:35:28.479316 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 12:35:28.479606 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 12:35:28.479978 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 12:35:28.480205 select * from embedded_struct_test [] gorptest: 12:35:28.480461 drop table if exists "invoice_test"; [] gorptest: 12:35:28.480935 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.481377 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.481830 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.482418 drop table if exists "person_test"; [] gorptest: 12:35:28.482867 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.483333 drop table if exists "id_created_test"; [] gorptest: 12:35:28.483825 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.484289 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.484762 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.485212 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.485655 drop table if exists "time_test"; [] gorptest: 12:35:28.486101 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.02s) === RUN TestWithEmbeddedStructBeforeAutoincr 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.486555 drop table if exists "invoice_test"; [] gorptest: 12:35:28.487136 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.487233 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.487312 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.487388 drop table if exists "person_test"; [] gorptest: 12:35:28.487491 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.487583 drop table if exists "id_created_test"; [] gorptest: 12:35:28.487691 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.487803 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.487904 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.487992 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.488079 drop table if exists "time_test"; [] gorptest: 12:35:28.488174 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.488733 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: 12:35:28.489290 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.489822 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.490438 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.490975 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.491515 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.492046 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.492570 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.493099 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.493626 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.494152 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.494686 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 12:35:28.495029 drop table if exists "invoice_test"; [] gorptest: 12:35:28.495455 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.495883 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.496305 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.497007 drop table if exists "person_test"; [] gorptest: 12:35:28.497440 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.497874 drop table if exists "id_created_test"; [] gorptest: 12:35:28.498298 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.498731 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.499154 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.499592 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.500023 drop table if exists "time_test"; [] gorptest: 12:35:28.500440 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.500881 drop table if exists "invoice_test"; [] gorptest: 12:35:28.501445 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.501539 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.501632 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.501719 drop table if exists "person_test"; [] gorptest: 12:35:28.501795 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.501865 drop table if exists "id_created_test"; [] gorptest: 12:35:28.501934 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.502002 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.502070 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.502146 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.502218 drop table if exists "time_test"; [] gorptest: 12:35:28.502301 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.502875 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: 12:35:28.503403 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.503916 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.504515 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.505067 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.505569 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.506094 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.506610 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.507124 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.507638 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.508159 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.508875 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 12:35:28.509235 drop table if exists "invoice_test"; [] gorptest: 12:35:28.509676 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.510121 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.510562 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.511115 drop table if exists "person_test"; [] gorptest: 12:35:28.511556 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.511995 drop table if exists "id_created_test"; [] gorptest: 12:35:28.512433 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.512909 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.513346 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.513790 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.514240 drop table if exists "time_test"; [] gorptest: 12:35:28.514673 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal gorptest: 12:35:28.515070 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 12:35:28.516106 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: 12:35:28.516452 select Int64 from TableWithNull where Str='abc' [] gorptest: 12:35:28.516656 select count(*) from TableWithNull [] gorptest: 12:35:28.516859 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 12:35:28.517060 select Int64 from TableWithNull where Str='notfound' [] gorptest: 12:35:28.517233 select Int64 from TableWithNull where Str='abc' [] gorptest: 12:35:28.517409 select Float64 from TableWithNull where Str='abc' [] gorptest: 12:35:28.517584 select min(Float64) from TableWithNull [] gorptest: 12:35:28.517788 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 12:35:28.517990 select Float64 from TableWithNull where Str='notfound' [] gorptest: 12:35:28.518166 select Float64 from TableWithNull where Str='abc' [] gorptest: 12:35:28.518356 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:35:28.518552 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 12:35:28.518720 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:35:28.518900 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 12:35:28.519128 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 12:35:28.519346 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:35:28.519542 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.520298 drop table if exists "invoice_test"; [] gorptest: 12:35:28.520863 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.520958 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.521043 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.521121 drop table if exists "person_test"; [] gorptest: 12:35:28.521212 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.521326 drop table if exists "id_created_test"; [] gorptest: 12:35:28.521415 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.521502 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.521581 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.521661 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.521739 drop table if exists "time_test"; [] gorptest: 12:35:28.521832 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.522382 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: 12:35:28.522936 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.523452 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.524060 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.524588 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.525122 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.525657 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.526173 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.526689 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.527209 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.527732 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.528287 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928528234993 2:1682202928528234993 3:"Bob" 4:"Smith" 5:1] gorptest: 12:35:28.528660 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928528637016 2:1682202928528637016 3:"Jane" 4:"Smith" 5:1] gorptest: 12:35:28.529167 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928529142161 2:1682202928529142161 3:"Mike" 4:"Smith" 5:1] gorptest: 12:35:28.529513 drop table if exists "invoice_test"; [] gorptest: 12:35:28.529953 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.530390 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.530831 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.531376 drop table if exists "person_test"; [] gorptest: 12:35:28.531831 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.532262 drop table if exists "id_created_test"; [] gorptest: 12:35:28.532686 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.533130 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.533608 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.534036 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.534462 drop table if exists "time_test"; [] gorptest: 12:35:28.534882 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk gorptest: 12:35:28.535250 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 12:35:28.536215 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 12:35:28.536511 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.537624 drop table if exists "invoice_test"; [] gorptest: 12:35:28.538154 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.538263 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.538344 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.538421 drop table if exists "person_test"; [] gorptest: 12:35:28.538494 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.538564 drop table if exists "id_created_test"; [] gorptest: 12:35:28.538658 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.538760 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.538839 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.538913 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.538984 drop table if exists "time_test"; [] gorptest: 12:35:28.539068 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.539614 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: 12:35:28.540148 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.540663 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.541274 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.541801 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.542318 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.542833 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.543361 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.543870 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.544382 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.545014 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.545561 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-22 22:04:28.545518553 +0000 UTC] gorptest: 12:35:28.545929 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-22 22:05:29.545518553 +0000 UTC] gorptest: 12:35:28.546278 SELECT id FROM time_test WHERE Time < ? [1:2023-04-22 22:05:28.545518553 +0000 UTC] gorptest: 12:35:28.546510 drop table if exists "invoice_test"; [] gorptest: 12:35:28.546934 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.547366 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.547794 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.548332 drop table if exists "person_test"; [] gorptest: 12:35:28.548795 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.549226 drop table if exists "id_created_test"; [] gorptest: 12:35:28.549652 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.550088 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.550513 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.550947 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.551372 drop table if exists "time_test"; [] gorptest: 12:35:28.551814 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.552244 drop table if exists "invoice_test"; [] gorptest: 12:35:28.552817 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.552915 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.552993 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.553068 drop table if exists "person_test"; [] gorptest: 12:35:28.553138 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.553208 drop table if exists "id_created_test"; [] gorptest: 12:35:28.553277 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.553352 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.553435 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.553568 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.553648 drop table if exists "time_test"; [] gorptest: 12:35:28.553749 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.554309 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: 12:35:28.554851 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.555372 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.555970 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.556501 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.557028 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.557547 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.558055 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.558567 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.559087 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.559621 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.560162 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928560127888 2:1682202928560127888 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.560552 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 12:35:28.561053 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 12:35:28.561345 drop table if exists "invoice_test"; [] gorptest: 12:35:28.561787 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.562222 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.562646 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.563198 drop table if exists "person_test"; [] gorptest: 12:35:28.563642 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.564072 drop table if exists "id_created_test"; [] gorptest: 12:35:28.564496 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.564943 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.565372 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.565793 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.566221 drop table if exists "time_test"; [] gorptest: 12:35:28.566640 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.567085 drop table if exists "invoice_test"; [] gorptest: 12:35:28.567664 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.567764 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.567849 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.567930 drop table if exists "person_test"; [] gorptest: 12:35:28.568006 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.568109 drop table if exists "id_created_test"; [] gorptest: 12:35:28.568199 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.568274 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.568346 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.568416 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.568485 drop table if exists "time_test"; [] gorptest: 12:35:28.568587 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.569162 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: 12:35:28.569685 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.570189 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.570775 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.571294 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.571792 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.572303 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.572837 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.573353 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.573868 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.574398 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.581224 drop table if exists "invoice_test"; [] gorptest: 12:35:28.581788 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.581880 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.581981 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.582078 drop table if exists "person_test"; [] gorptest: 12:35:28.582179 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.582276 drop table if exists "id_created_test"; [] gorptest: 12:35:28.582377 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.582475 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.582574 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.582676 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.582787 drop table if exists "time_test"; [] gorptest: 12:35:28.582917 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.583488 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: 12:35:28.584016 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.584544 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.585160 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.585689 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.586197 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.586707 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.587231 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.587759 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.588281 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.588834 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.589385 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928589350998 2:1682202928589350998 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.589777 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928589739862 2:1682202928589739862 3:"jane" 4:"doe" 5:1] gorptest: 12:35:28.590145 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.590400 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 12:35:28.590647 select * from person_test where Id=? [1:1] gorptest: 12:35:28.590911 select * from person_test order by fname asc [] gorptest: 12:35:28.591228 drop table if exists "invoice_test"; [] gorptest: 12:35:28.591669 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.592112 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.592553 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.593233 drop table if exists "person_test"; [] gorptest: 12:35:28.593714 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.594154 drop table if exists "id_created_test"; [] gorptest: 12:35:28.594597 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.595030 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.595469 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.595916 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.596347 drop table if exists "time_test"; [] gorptest: 12:35:28.596803 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.02s) === RUN TestSelectSingleVal 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.597249 drop table if exists "invoice_test"; [] gorptest: 12:35:28.597807 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.597907 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.598013 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.598109 drop table if exists "person_test"; [] gorptest: 12:35:28.598209 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.598305 drop table if exists "id_created_test"; [] gorptest: 12:35:28.598403 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.598503 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.598624 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.598721 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.598822 drop table if exists "time_test"; [] gorptest: 12:35:28.598939 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.599488 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: 12:35:28.600015 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.600531 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.601143 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.601665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.602172 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.602681 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.603201 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.603776 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.604319 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.604984 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.605543 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928605508028 2:1682202928605508028 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.605915 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:35:28.606172 select * from person_test where Id=? [1:1] gorptest: 12:35:28.606461 select FName from person_test where Id=? [1:1] gorptest: 12:35:28.606650 select * from person_test where Id=? [1:1] gorptest: 12:35:28.606935 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 12:35:28.607193 select * from person_test where Id=? [1:-2222] gorptest: 12:35:28.607451 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928607419966 2:1682202928607419966 3:"bob" 4:"smith" 5:1] gorptest: 12:35:28.607815 select * from person_test where Fname='bob' [] gorptest: 12:35:28.608107 select * from person_test where Id=-123 [] gorptest: 12:35:28.608299 select * from person_test where Id=-123 [] gorptest: 12:35:28.608501 select * from person_test where Id=-123 [] gorptest: 12:35:28.608683 select * from person_test where Id=-123 [] gorptest: 12:35:28.608882 drop table if exists "invoice_test"; [] gorptest: 12:35:28.609325 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.609765 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.610206 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.610761 drop table if exists "person_test"; [] gorptest: 12:35:28.611219 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.611661 drop table if exists "id_created_test"; [] gorptest: 12:35:28.612098 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.612531 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.612998 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.613445 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.613875 drop table if exists "time_test"; [] gorptest: 12:35:28.614319 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.02s) === RUN TestSelectAlias 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.614820 drop table if exists "invoice_test"; [] gorptest: 12:35:28.615411 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.615521 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.615623 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.615715 drop table if exists "person_test"; [] gorptest: 12:35:28.615809 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.615902 drop table if exists "id_created_test"; [] gorptest: 12:35:28.615997 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.616089 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.616181 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.616277 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.616383 drop table if exists "time_test"; [] gorptest: 12:35:28.616501 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.617170 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: 12:35:28.617728 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.618258 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.618873 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.619415 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.619935 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.620462 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.621023 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.621552 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.622091 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.622635 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.623178 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 12:35:28.623517 select * from id_created_test where Id=1 [] gorptest: 12:35:28.623781 SELECT *, 1 AS external FROM id_created_test [] gorptest: 12:35:28.624075 drop table if exists "invoice_test"; [] gorptest: 12:35:28.625288 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.625739 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.626184 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.626752 drop table if exists "person_test"; [] gorptest: 12:35:28.627197 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.627650 drop table if exists "id_created_test"; [] gorptest: 12:35:28.628113 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.628608 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.629067 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.629514 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.629969 drop table if exists "time_test"; [] gorptest: 12:35:28.630417 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.02s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.631008 drop table if exists "invoice_test"; [] gorptest: 12:35:28.631551 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.631641 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.631720 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.631792 drop table if exists "person_test"; [] gorptest: 12:35:28.631872 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.631951 drop table if exists "id_created_test"; [] gorptest: 12:35:28.632026 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.632101 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.632192 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.632295 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.632379 drop table if exists "time_test"; [] gorptest: 12:35:28.632485 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.633121 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: 12:35:28.633645 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.634155 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.634737 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.635265 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.635767 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.636284 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.636823 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.637336 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.637859 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.638386 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.638896 drop table if exists "invoice_test"; [] gorptest: 12:35:28.639334 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.639765 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.640189 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.640735 drop table if exists "person_test"; [] gorptest: 12:35:28.641246 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.641685 drop table if exists "id_created_test"; [] gorptest: 12:35:28.642108 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.642547 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.642985 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.643408 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.643827 drop table if exists "time_test"; [] gorptest: 12:35:28.644245 drop table if exists "id_created_test"; [] gorptest: 12:35:28.644352 drop table if exists "single_column_table"; [] gorptest: 12:35:28.644462 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: 12:35:28.645027 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: 12:35:28.645561 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.646071 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: 12:35:28.646657 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: 12:35:28.647183 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.647679 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.648188 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.648700 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.649281 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.649801 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: 12:35:28.650316 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.650816 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:35:28.650937 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 12:35:28.651458 delete from "invoice_test"; [] gorptest: 12:35:28.651725 delete from "invoice_tag_test"; [] gorptest: 12:35:28.651978 delete from "alias_trans_field_test"; [] gorptest: 12:35:28.652234 delete from "invoice_override_test"; [] gorptest: 12:35:28.652508 delete from "person_test"; [] gorptest: 12:35:28.652784 delete from "ignored_column_test"; [] gorptest: 12:35:28.653051 delete from "id_created_test"; [] gorptest: 12:35:28.653347 delete from "type_conv_test"; [] gorptest: 12:35:28.653606 delete from "embedded_struct_test"; [] gorptest: 12:35:28.653866 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.654126 delete from "embedded_autoincr_test"; [] gorptest: 12:35:28.654407 delete from "time_test"; [] gorptest: 12:35:28.654664 delete from "id_created_test"; [] gorptest: 12:35:28.654909 delete from "single_column_table"; [] gorptest: 12:35:28.655196 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 12:35:28.655395 drop table if exists "invoice_test"; [] gorptest: 12:35:28.655816 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.656247 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.656672 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.657251 drop table if exists "person_test"; [] gorptest: 12:35:28.657678 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.658112 drop table if exists "id_created_test"; [] gorptest: 12:35:28.658540 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.658966 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.659396 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.659837 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.660265 drop table if exists "time_test"; [] gorptest: 12:35:28.660686 drop table if exists "id_created_test"; [] gorptest: 12:35:28.660814 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.03s) === RUN TestPrepare 2023/04/23 12:35:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:35:28.661671 drop table if exists "invoice_test"; [] gorptest: 12:35:28.662227 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.662314 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.662379 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.662443 drop table if exists "person_test"; [] gorptest: 12:35:28.662503 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.662564 drop table if exists "id_created_test"; [] gorptest: 12:35:28.662623 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.662681 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.662740 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.662801 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.662865 drop table if exists "time_test"; [] gorptest: 12:35:28.662956 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.663511 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: 12:35:28.664029 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:35:28.664535 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:35:28.665201 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 12:35:28.665723 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.666216 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:35:28.666729 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:35:28.667236 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:35:28.667744 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:35:28.668278 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:35:28.668817 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:35:28.669356 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 12:35:28.669747 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 12:35:28.670089 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 12:35:28.670424 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 12:35:28.670739 begin; [] gorptest: 12:35:28.670815 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 12:35:28.671037 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:35:28.671839 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:35:28.672090 commit; [] gorptest: 12:35:28.672274 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:35:28.672552 drop table if exists "invoice_test"; [] gorptest: 12:35:28.673110 drop table if exists "invoice_tag_test"; [] gorptest: 12:35:28.673541 drop table if exists "alias_trans_field_test"; [] gorptest: 12:35:28.673971 drop table if exists "invoice_override_test"; [] gorptest: 12:35:28.674523 drop table if exists "person_test"; [] gorptest: 12:35:28.674959 drop table if exists "ignored_column_test"; [] gorptest: 12:35:28.675382 drop table if exists "id_created_test"; [] gorptest: 12:35:28.675806 drop table if exists "type_conv_test"; [] gorptest: 12:35:28.676237 drop table if exists "embedded_struct_test"; [] gorptest: 12:35:28.676659 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:35:28.677106 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:35:28.677539 drop table if exists "time_test"; [] gorptest: 12:35:28.677951 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.02s) PASS ok gopkg.in/gorp.v1 0.440s 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 --destdir=debian/golang-gopkg-gorp.v1-dev/ -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 -O../golang-gopkg-gorp.v1_1.7.2-2_arm64.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_arm64.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/14986/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/14986/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/14986 and its subdirectories I: Current time: Sun Apr 23 12:35:35 +14 2023 I: pbuilder-time-stamp: 1682202935