I: pbuilder: network access will be disabled during build I: Current time: Thu May 16 02:19:15 +14 2024 I: pbuilder-time-stamp: 1715775555 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/unstable-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 Sun Apr 19 14:59:56 2020 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/3458744/tmp/hooks/D01_modify_environment starting debug: Running on infom01-amd64. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 May 15 12:19 /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/3458744/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/3458744/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]="21" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") BASH_VERSION='5.2.21(1)-release' BUILDDIR=/build/reproducible-path BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' BUILDUSERNAME=pbuilder2 BUILD_ARCH=amd64 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=12 ' DIRSTACK=() DISTRIBUTION=unstable EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=x86_64 HOST_ARCH=amd64 IFS=' ' INVOCATION_ID=7e6ffa6b2c9b482d8e4912504114810a LANG=C LANGUAGE=et_EE:et LC_ALL=C MACHTYPE=x86_64-pc-linux-gnu MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnu PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path PBCURRENTCOMMANDLINEOPERATION=build PBUILDER_OPERATION=build PBUILDER_PKGDATADIR=/usr/share/pbuilder PBUILDER_PKGLIBDIR=/usr/lib/pbuilder PBUILDER_SYSCONFDIR=/etc PIPESTATUS=([0]="0") POSIXLY_CORRECT=y PPID=3458744 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.HRoYUfuE/pbuilderrc_DeCs --distribution unstable --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.HRoYUfuE/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=109 SUDO_UID=104 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' I: uname -a Linux i-capture-the-hostname 6.1.0-21-cloud-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.90-1 (2024-05-03) x86_64 GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 May 14 07:42 /bin -> usr/bin I: user script /srv/workspace/pbuilder/3458744/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19701 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.22-go{a} golang-1.22-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} libelf1t64{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1t64{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 71.5 MB of archives. After unpacking 371 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian unstable/main amd64 sensible-utils all 0.0.22 [22.4 kB] Get: 2 http://deb.debian.org/debian unstable/main amd64 libmagic-mgc amd64 1:5.45-3 [314 kB] Get: 3 http://deb.debian.org/debian unstable/main amd64 libmagic1t64 amd64 1:5.45-3 [105 kB] Get: 4 http://deb.debian.org/debian unstable/main amd64 file amd64 1:5.45-3 [42.9 kB] Get: 5 http://deb.debian.org/debian unstable/main amd64 gettext-base amd64 0.21-14+b1 [161 kB] Get: 6 http://deb.debian.org/debian unstable/main amd64 libuchardet0 amd64 0.0.8-1+b1 [68.8 kB] Get: 7 http://deb.debian.org/debian unstable/main amd64 groff-base amd64 1.23.0-4 [1180 kB] Get: 8 http://deb.debian.org/debian unstable/main amd64 bsdextrautils amd64 2.40.1-1 [94.1 kB] Get: 9 http://deb.debian.org/debian unstable/main amd64 libpipeline1 amd64 1.5.7-2 [38.0 kB] Get: 10 http://deb.debian.org/debian unstable/main amd64 man-db amd64 2.12.1-1 [1411 kB] Get: 11 http://deb.debian.org/debian unstable/main amd64 m4 amd64 1.4.19-4 [287 kB] Get: 12 http://deb.debian.org/debian unstable/main amd64 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian unstable/main amd64 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian unstable/main amd64 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian unstable/main amd64 autopoint all 0.21-14 [496 kB] Get: 16 http://deb.debian.org/debian unstable/main amd64 libdebhelper-perl all 13.15.3 [88.0 kB] Get: 17 http://deb.debian.org/debian unstable/main amd64 libtool all 2.4.7-7 [517 kB] Get: 18 http://deb.debian.org/debian unstable/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian unstable/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian unstable/main amd64 libsub-override-perl all 0.10-1 [10.6 kB] Get: 21 http://deb.debian.org/debian unstable/main amd64 libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian unstable/main amd64 dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian unstable/main amd64 libelf1t64 amd64 0.191-1+b1 [189 kB] Get: 24 http://deb.debian.org/debian unstable/main amd64 dwz amd64 0.15-1+b1 [110 kB] Get: 25 http://deb.debian.org/debian unstable/main amd64 libicu72 amd64 72.1-4+b1 [9395 kB] Get: 26 http://deb.debian.org/debian unstable/main amd64 libxml2 amd64 2.9.14+dfsg-1.3+b3 [692 kB] Get: 27 http://deb.debian.org/debian unstable/main amd64 gettext amd64 0.21-14+b1 [1301 kB] Get: 28 http://deb.debian.org/debian unstable/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian unstable/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian unstable/main amd64 debhelper all 13.15.3 [901 kB] Get: 31 http://deb.debian.org/debian unstable/main amd64 dh-golang all 1.62 [24.7 kB] Get: 32 http://deb.debian.org/debian unstable/main amd64 golang-1.22-src all 1.22.3-1 [18.8 MB] Get: 33 http://deb.debian.org/debian unstable/main amd64 golang-1.22-go amd64 1.22.3-1 [24.7 MB] Get: 34 http://deb.debian.org/debian unstable/main amd64 golang-src all 2:1.22~3 [5020 B] Get: 35 http://deb.debian.org/debian unstable/main amd64 golang-go amd64 2:1.22~3 [44.2 kB] Get: 36 http://deb.debian.org/debian unstable/main amd64 golang-any amd64 2:1.22~3 [5104 B] Get: 37 http://deb.debian.org/debian unstable/main amd64 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian unstable/main amd64 golang-github-go-sql-driver-mysql-dev all 1.7.1-2 [74.6 kB] Get: 39 http://deb.debian.org/debian unstable/main amd64 golang-github-gorilla-securecookie-dev all 1.1.2-1 [14.0 kB] Get: 40 http://deb.debian.org/debian unstable/main amd64 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian unstable/main amd64 golang-github-hashicorp-go-uuid-dev all 1.0.3-1 [8636 B] Get: 42 http://deb.debian.org/debian unstable/main amd64 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian unstable/main amd64 golang-github-stretchr-objx-dev all 0.5.2-1 [25.5 kB] Get: 44 http://deb.debian.org/debian unstable/main amd64 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian unstable/main amd64 golang-github-stretchr-testify-dev all 1.9.0-1 [74.7 kB] Get: 46 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-sys-dev all 0.19.0-1 [402 kB] Get: 51 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-term-dev all 0.19.0-1 [14.7 kB] Get: 52 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-text-dev all 0.14.0-2 [4001 kB] Get: 53 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-crypto-dev all 1:0.22.0-1 [1672 kB] Get: 54 http://deb.debian.org/debian unstable/main amd64 golang-golang-x-net-dev all 1:0.24.0+dfsg-1 [895 kB] Get: 55 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 56 http://deb.debian.org/debian unstable/main amd64 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian unstable/main amd64 golang-github-lib-pq-dev all 1.10.9-2 [86.6 kB] Get: 58 http://deb.debian.org/debian unstable/main amd64 libsqlite3-dev amd64 3.45.3-1 [1088 kB] Get: 59 http://deb.debian.org/debian unstable/main amd64 golang-github-mattn-go-sqlite3-dev amd64 1.14.19~ds1-1 [83.4 kB] Get: 60 http://deb.debian.org/debian unstable/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 71.5 MB in 1s (111 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 ... 19701 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.22_all.deb ... Unpacking sensible-utils (0.0.22) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.45-3_amd64.deb ... Unpacking libmagic-mgc (1:5.45-3) ... Selecting previously unselected package libmagic1t64:amd64. Preparing to unpack .../02-libmagic1t64_1%3a5.45-3_amd64.deb ... Unpacking libmagic1t64:amd64 (1:5.45-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.45-3_amd64.deb ... Unpacking file (1:5.45-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-14+b1_amd64.deb ... Unpacking gettext-base (0.21-14+b1) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../05-libuchardet0_0.0.8-1+b1_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.8-1+b1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-4_amd64.deb ... Unpacking groff-base (1.23.0-4) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.40.1-1_amd64.deb ... Unpacking bsdextrautils (2.40.1-1) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../08-libpipeline1_1.5.7-2_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.7-2) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.12.1-1_amd64.deb ... Unpacking man-db (2.12.1-1) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-4_amd64.deb ... Unpacking m4 (1.4.19-4) ... 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-14_all.deb ... Unpacking autopoint (0.21-14) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.15.3_all.deb ... Unpacking libdebhelper-perl (13.15.3) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.4.7-7_all.deb ... Unpacking libtool (2.4.7-7) ... 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.10-1_all.deb ... Unpacking libsub-override-perl (0.10-1) ... 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 libelf1t64:amd64. Preparing to unpack .../22-libelf1t64_0.191-1+b1_amd64.deb ... Unpacking libelf1t64:amd64 (0.191-1+b1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1+b1_amd64.deb ... Unpacking dwz (0.15-1+b1) ... Selecting previously unselected package libicu72:amd64. Preparing to unpack .../24-libicu72_72.1-4+b1_amd64.deb ... Unpacking libicu72:amd64 (72.1-4+b1) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.3+b3_amd64.deb ... Unpacking libxml2:amd64 (2.9.14+dfsg-1.3+b3) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-14+b1_amd64.deb ... Unpacking gettext (0.21-14+b1) ... 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.15.3_all.deb ... Unpacking debhelper (13.15.3) ... Selecting previously unselected package dh-golang. Preparing to unpack .../30-dh-golang_1.62_all.deb ... Unpacking dh-golang (1.62) ... Selecting previously unselected package golang-1.22-src. Preparing to unpack .../31-golang-1.22-src_1.22.3-1_all.deb ... Unpacking golang-1.22-src (1.22.3-1) ... Selecting previously unselected package golang-1.22-go. Preparing to unpack .../32-golang-1.22-go_1.22.3-1_amd64.deb ... Unpacking golang-1.22-go (1.22.3-1) ... Selecting previously unselected package golang-src. Preparing to unpack .../33-golang-src_2%3a1.22~3_all.deb ... Unpacking golang-src (2:1.22~3) ... Selecting previously unselected package golang-go:amd64. Preparing to unpack .../34-golang-go_2%3a1.22~3_amd64.deb ... Unpacking golang-go:amd64 (2:1.22~3) ... Selecting previously unselected package golang-any:amd64. Preparing to unpack .../35-golang-any_2%3a1.22~3_amd64.deb ... Unpacking golang-any:amd64 (2:1.22~3) ... 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.7.1-2_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Selecting previously unselected package golang-github-gorilla-securecookie-dev. Preparing to unpack .../38-golang-github-gorilla-securecookie-dev_1.1.2-1_all.deb ... Unpacking golang-github-gorilla-securecookie-dev (1.1.2-1) ... 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.3-1_all.deb ... Unpacking golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... 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.2-1_all.deb ... Unpacking golang-github-stretchr-objx-dev (0.5.2-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.9.0-1_all.deb ... Unpacking golang-github-stretchr-testify-dev (1.9.0-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.19.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.19.0-1) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../50-golang-golang-x-term-dev_0.19.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.19.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../51-golang-golang-x-text-dev_0.14.0-2_all.deb ... Unpacking golang-golang-x-text-dev (0.14.0-2) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../52-golang-golang-x-crypto-dev_1%3a0.22.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.22.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../53-golang-golang-x-net-dev_1%3a0.24.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.24.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../54-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-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.9-2_all.deb ... Unpacking golang-github-lib-pq-dev (1.10.9-2) ... Selecting previously unselected package libsqlite3-dev:amd64. Preparing to unpack .../57-libsqlite3-dev_3.45.3-1_amd64.deb ... Unpacking libsqlite3-dev:amd64 (3.45.3-1) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:amd64. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.19~ds1-1_amd64.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:amd64 (1.14.19~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:amd64 (1.5.7-2) ... Setting up golang-github-jcmturner-gofork-dev (1.0.0-4) ... Setting up golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... Setting up libicu72:amd64 (72.1-4+b1) ... Setting up bsdextrautils (2.40.1-1) ... Setting up golang-github-stretchr-objx-dev (0.5.2-1) ... Setting up libmagic-mgc (1:5.45-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.15.3) ... Setting up golang-golang-x-sys-dev (0.19.0-1) ... Setting up libmagic1t64:amd64 (1:5.45-3) ... Setting up golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Setting up gettext-base (0.21-14+b1) ... Setting up m4 (1.4.19-4) ... Setting up golang-golang-x-term-dev (0.19.0-1) ... Setting up file (1:5.45-3) ... Setting up libelf1t64:amd64 (0.191-1+b1) ... Setting up golang-github-davecgh-go-spew-dev (1.1.1-3) ... Setting up autotools-dev (20220109.1) ... Setting up libsqlite3-dev:amd64 (3.45.3-1) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up golang-github-stretchr-testify-dev (1.9.0-1) ... Setting up golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Setting up golang-1.22-src (1.22.3-1) ... Setting up autopoint (0.21-14) ... Setting up autoconf (2.71-3) ... Setting up dwz (0.15-1+b1) ... Setting up sensible-utils (0.0.22) ... Setting up golang-golang-x-text-dev (0.14.0-2) ... Setting up golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Setting up libuchardet0:amd64 (0.0.8-1+b1) ... Setting up libsub-override-perl (0.10-1) ... Setting up golang-golang-x-crypto-dev (1:0.22.0-1) ... Setting up golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Setting up golang-src (2:1.22~3) ... Setting up golang-github-gorilla-securecookie-dev (1.1.2-1) ... Setting up libxml2:amd64 (2.9.14+dfsg-1.3+b3) ... Setting up golang-github-gorilla-sessions-dev (1.2.1-1) ... 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-14+b1) ... Setting up golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Setting up libtool (2.4.7-7) ... Setting up golang-1.22-go (1.22.3-1) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:amd64 (1.14.19~ds1-1) ... Setting up golang-golang-x-net-dev (1:0.24.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.13.1-1) ... Setting up groff-base (1.23.0-4) ... Setting up golang-go:amd64 (2:1.22~3) ... 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.12.1-1) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-any:amd64 (2:1.22~3) ... Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.15.3) ... Setting up golang-github-lib-pq-dev (1.10.9-2) ... Setting up dh-golang (1.62) ... Processing triggers for libc-bin (2.38-11) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: user script /srv/workspace/pbuilder/3458744/tmp/hooks/A99_set_merged_usr starting Not re-configuring usrmerge for unstable I: user script /srv/workspace/pbuilder/3458744/tmp/hooks/A99_set_merged_usr finished hostname: Name or service not known I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 12 gopkg.in/gorp.v1 internal/unsafeheader internal/race internal/goarch internal/coverage/rtcov internal/goos unicode/utf8 internal/itoa sync/atomic math/bits internal/godebugs internal/chacha8rand internal/goexperiment unicode runtime/internal/atomic internal/cpu runtime/internal/syscall internal/abi runtime/internal/math runtime/internal/sys cmp log/internal slices internal/bytealg math runtime internal/reflectlite sync internal/testlog errors sort io internal/oserror strconv path internal/safefilepath syscall bytes strings reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context internal/poll io/fs os internal/fmtsort fmt database/sql/driver log database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 12 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2024/05/15 12:20:45 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:20:45.177156 drop table if exists "invoice_test"; [] gorptest: 12:20:45.177676 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:45.177699 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:45.177714 drop table if exists "invoice_override_test"; [] gorptest: 12:20:45.177728 drop table if exists "person_test"; [] gorptest: 12:20:45.177741 drop table if exists "ignored_column_test"; [] gorptest: 12:20:45.177753 drop table if exists "id_created_test"; [] gorptest: 12:20:45.177765 drop table if exists "type_conv_test"; [] gorptest: 12:20:45.177777 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:45.177789 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:45.177801 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:45.177813 drop table if exists "time_test"; [] gorptest: 12:20:45.177837 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:45.214672 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:20:45.235183 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:45.254730 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:20:45.271711 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:20:45.286622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:45.301494 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:45.333956 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:45.361851 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:45.401078 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:45.458293 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:45.512878 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:45.558643 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:20:45.558740 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:20:45.558766 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:45.558788 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:20:45.558807 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:20:45.558824 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:45.558838 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:45.558855 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:45.558872 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:45.558889 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:20:45.558905 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:20:45.558921 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:45.558935 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:20:45.558950 drop table if exists "invoice_test"; [] gorptest: 12:20:45.581237 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:45.607470 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:45.636834 drop table if exists "invoice_override_test"; [] gorptest: 12:20:45.681058 drop table if exists "person_test"; [] gorptest: 12:20:45.736190 drop table if exists "ignored_column_test"; [] gorptest: 12:20:45.791488 drop table if exists "id_created_test"; [] gorptest: 12:20:45.840463 drop table if exists "type_conv_test"; [] gorptest: 12:20:45.878643 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:45.920444 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:45.950568 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:45.992116 drop table if exists "time_test"; [] gorptest: 12:20:46.026608 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.85s) === RUN TestTruncateTables 2024/05/15 12:20:46 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:20:46.026862 drop table if exists "invoice_test"; [] gorptest: 12:20:46.027069 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:46.027084 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:46.027095 drop table if exists "invoice_override_test"; [] gorptest: 12:20:46.027106 drop table if exists "person_test"; [] gorptest: 12:20:46.027116 drop table if exists "ignored_column_test"; [] gorptest: 12:20:46.027126 drop table if exists "id_created_test"; [] gorptest: 12:20:46.027135 drop table if exists "type_conv_test"; [] gorptest: 12:20:46.027145 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:46.027155 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:46.027165 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:46.027175 drop table if exists "time_test"; [] gorptest: 12:20:46.027191 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:46.067248 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:20:46.102681 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:46.160699 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:20:46.206653 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:20:46.242618 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:46.270572 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:46.294421 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:46.310841 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:46.332176 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:46.381942 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:46.424232 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:46.458692 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:20:46.458779 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:20:46.458802 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:46.458819 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:20:46.458834 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:20:46.458847 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:46.458859 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:46.458873 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:46.458887 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:46.458901 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:20:46.458915 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:20:46.458928 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:46.458940 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:20:46.458988 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775646458971601 2:1715775646458971601 3:"Bob" 4:"Smith" 5:1] gorptest: 12:20:46.480342 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:20:46.631441 delete from "invoice_test"; [] gorptest: 12:20:46.678648 delete from "invoice_tag_test"; [] gorptest: 12:20:46.730695 delete from "alias_trans_field_test"; [] gorptest: 12:20:46.796702 delete from "invoice_override_test"; [] gorptest: 12:20:46.830699 delete from "person_test"; [] gorptest: 12:20:46.866662 delete from "ignored_column_test"; [] gorptest: 12:20:46.883010 delete from "id_created_test"; [] gorptest: 12:20:46.903012 delete from "type_conv_test"; [] gorptest: 12:20:46.928178 delete from "embedded_struct_test"; [] gorptest: 12:20:46.986680 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:47.018582 delete from "embedded_autoincr_test"; [] gorptest: 12:20:47.069838 delete from "time_test"; [] gorptest: 12:20:47.094405 delete from "id_created_test"; [] gorptest: 12:20:47.110069 SELECT * FROM person_test [] gorptest: 12:20:47.110275 SELECT * FROM invoice_test [] gorptest: 12:20:47.110325 drop table if exists "invoice_test"; [] gorptest: 12:20:47.135802 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:47.166059 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:47.185607 drop table if exists "invoice_override_test"; [] gorptest: 12:20:47.222859 drop table if exists "person_test"; [] gorptest: 12:20:47.250673 drop table if exists "ignored_column_test"; [] gorptest: 12:20:47.276051 drop table if exists "id_created_test"; [] gorptest: 12:20:47.310921 drop table if exists "type_conv_test"; [] gorptest: 12:20:47.362625 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:47.386652 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:47.414208 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:47.448257 drop table if exists "time_test"; [] gorptest: 12:20:47.473019 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (1.45s) === RUN TestCustomDateType gorptest: 12:20:47.473290 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 12:20:47.520253 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-05-15 12:20:47 +0000 UTC] gorptest: 12:20:47.675044 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 12:20:47.677089 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.23s) === RUN TestUIntPrimaryKey gorptest: 12:20:47.705697 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:20:47.734453 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:20:47.766693 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 12:20:47.800338 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 12:20:47.831067 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 12:20:47.866616 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 12:20:47.905857 drop table if exists "PersonUInt64"; [] gorptest: 12:20:47.938653 drop table if exists "PersonUInt32"; [] gorptest: 12:20:47.969984 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.30s) === RUN TestSetUniqueTogether gorptest: 12:20:48.003041 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:20:48.032021 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 12:20:48.080808 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 12:20:48.080963 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 12:20:48.081007 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 12:20:48.115448 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.14s) === RUN TestPersistentUser gorptest: 12:20:48.143335 drop table if exists PersistentUser [] gorptest: 12:20:48.143569 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:20:48.185644 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:20:48.214636 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 12:20:48.214852 select * from PersistentUser [] gorptest: 12:20:48.214944 select * from PersistentUser [] gorptest: 12:20:48.214988 select * from PersistentUser [] gorptest: 12:20:48.215028 select Id from PersistentUser [] gorptest: 12:20:48.215055 select mykey from PersistentUser [] gorptest: 12:20:48.215082 select PassedTraining from PersistentUser [] gorptest: 12:20:48.215111 select Id from PersistentUser [] gorptest: 12:20:48.215138 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.14s) === RUN TestNamedQueryMap gorptest: 12:20:48.278916 drop table if exists PersistentUser [] gorptest: 12:20:48.279284 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:20:48.305151 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:20:48.341376 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 12:20:48.359434 select * from PersistentUser where mykey = ? [1:43] gorptest: 12:20:48.359546 select * from PersistentUser where mykey = ? [1:43] gorptest: 12:20:48.359598 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 12:20:48.359653 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 12:20:48.359695 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.14s) === RUN TestNamedQueryStruct gorptest: 12:20:48.416238 drop table if exists PersistentUser [] gorptest: 12:20:48.416624 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 12:20:48.458367 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 12:20:48.488388 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 12:20:48.528980 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 12:20:48.529153 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.15s) === RUN TestReturnsNonNilSlice 2024/05/15 12:20:48 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:20:48.564675 drop table if exists "invoice_test"; [] gorptest: 12:20:48.564942 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:48.564963 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:48.564978 drop table if exists "invoice_override_test"; [] gorptest: 12:20:48.564991 drop table if exists "person_test"; [] gorptest: 12:20:48.565006 drop table if exists "ignored_column_test"; [] gorptest: 12:20:48.565018 drop table if exists "id_created_test"; [] gorptest: 12:20:48.565032 drop table if exists "type_conv_test"; [] gorptest: 12:20:48.565045 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:48.565059 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:48.565072 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:48.565088 drop table if exists "time_test"; [] gorptest: 12:20:48.565109 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:48.582631 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:20:48.602270 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:48.649591 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:20:48.689767 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:20:48.724488 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:48.746619 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:48.798724 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:48.878629 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:48.911899 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:48.958624 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:49.002762 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:49.034544 select * from invoice_test where id=99999 [] gorptest: 12:20:49.034682 select * from invoice_test where id=99999 [] gorptest: 12:20:49.034727 drop table if exists "invoice_test"; [] gorptest: 12:20:49.170772 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:49.207851 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:49.258596 drop table if exists "invoice_override_test"; [] gorptest: 12:20:49.284607 drop table if exists "person_test"; [] gorptest: 12:20:49.329107 drop table if exists "ignored_column_test"; [] gorptest: 12:20:49.390635 drop table if exists "id_created_test"; [] gorptest: 12:20:49.424608 drop table if exists "type_conv_test"; [] gorptest: 12:20:49.460713 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:49.495816 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:49.518175 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:49.540775 drop table if exists "time_test"; [] gorptest: 12:20:49.570597 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (1.01s) === RUN TestOverrideVersionCol gorptest: 12:20:49.570842 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:20:49.622290 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:20:49.622443 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.08s) === RUN TestOptimisticLocking 2024/05/15 12:20:49 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:20:49.653655 drop table if exists "invoice_test"; [] gorptest: 12:20:49.653881 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:49.653898 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:49.653910 drop table if exists "invoice_override_test"; [] gorptest: 12:20:49.653921 drop table if exists "person_test"; [] gorptest: 12:20:49.653931 drop table if exists "ignored_column_test"; [] gorptest: 12:20:49.653941 drop table if exists "id_created_test"; [] gorptest: 12:20:49.653951 drop table if exists "type_conv_test"; [] gorptest: 12:20:49.653960 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:49.653970 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:49.653981 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:49.653991 drop table if exists "time_test"; [] gorptest: 12:20:49.654008 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:49.696457 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:20:49.806600 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:49.846559 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:20:49.903389 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:20:49.936600 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:49.993796 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:50.032652 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:50.226708 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:50.289923 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:50.374389 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:50.426760 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:50.478669 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775650478642861 2:1715775650478642861 3:"Bob" 4:"Smith" 5:1] gorptest: 12:20:50.533185 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:20:50.533322 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715775650478642861 2:1715775650478642861 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 12:20:50.558151 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715775650478642861 2:1715775650478642861 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 12:20:50.558286 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:20:50.558358 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 12:20:50.558392 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:20:50.558427 drop table if exists "invoice_test"; [] gorptest: 12:20:50.584379 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:50.651320 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:50.678539 drop table if exists "invoice_override_test"; [] gorptest: 12:20:50.730768 drop table if exists "person_test"; [] gorptest: 12:20:50.786610 drop table if exists "ignored_column_test"; [] gorptest: 12:20:50.810801 drop table if exists "id_created_test"; [] gorptest: 12:20:50.837899 drop table if exists "type_conv_test"; [] gorptest: 12:20:50.902626 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:50.946687 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:50.986658 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:51.034624 drop table if exists "time_test"; [] gorptest: 12:20:51.065621 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (1.41s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 12:20:51.065891 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 12:20:51.122698 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 12:20:51.158604 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 12:20:51.158759 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:20:51.206669 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 12:20:51.206824 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.18s) === RUN TestColumnProps gorptest: 12:20:51.246716 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 12:20:51.269103 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 12:20:51.298583 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 12:20:51.298720 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:20:51.298787 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 12:20:51.298825 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.09s) === RUN TestRawSelect 2024/05/15 12:20:51 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:20:51.337786 drop table if exists "invoice_test"; [] gorptest: 12:20:51.338018 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:51.338034 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:51.338045 drop table if exists "invoice_override_test"; [] gorptest: 12:20:51.338056 drop table if exists "person_test"; [] gorptest: 12:20:51.338065 drop table if exists "ignored_column_test"; [] gorptest: 12:20:51.338076 drop table if exists "id_created_test"; [] gorptest: 12:20:51.338085 drop table if exists "type_conv_test"; [] gorptest: 12:20:51.338096 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:51.338107 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:51.338117 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:51.338127 drop table if exists "time_test"; [] gorptest: 12:20:51.338143 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:51.366688 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:20:51.390569 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:51.426682 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:20:51.481963 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:20:51.528869 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:51.570682 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:51.591300 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:51.626622 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:51.650852 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:51.697934 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:51.724104 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:51.754645 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775651754625835 2:1715775651754625835 3:"bob" 4:"smith" 5:1] gorptest: 12:20:51.786755 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:20:51.818572 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:20:51.818725 drop table if exists "invoice_test"; [] gorptest: 12:20:51.846559 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:51.862677 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:51.885787 drop table if exists "invoice_override_test"; [] gorptest: 12:20:51.977626 drop table if exists "person_test"; [] gorptest: 12:20:52.022856 drop table if exists "ignored_column_test"; [] gorptest: 12:20:52.073391 drop table if exists "id_created_test"; [] gorptest: 12:20:52.130750 drop table if exists "type_conv_test"; [] gorptest: 12:20:52.164868 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:52.194610 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:52.222575 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:52.261154 drop table if exists "time_test"; [] gorptest: 12:20:52.295353 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.96s) === RUN TestHooks 2024/05/15 12:20:52 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:20:52.295700 drop table if exists "invoice_test"; [] gorptest: 12:20:52.295956 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:52.295981 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:52.295994 drop table if exists "invoice_override_test"; [] gorptest: 12:20:52.296005 drop table if exists "person_test"; [] gorptest: 12:20:52.296015 drop table if exists "ignored_column_test"; [] gorptest: 12:20:52.296025 drop table if exists "id_created_test"; [] gorptest: 12:20:52.296035 drop table if exists "type_conv_test"; [] gorptest: 12:20:52.296045 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:52.296054 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:52.296064 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:52.296074 drop table if exists "time_test"; [] gorptest: 12:20:52.296093 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:52.333937 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:20:52.370606 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:52.402039 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:20:52.430633 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:20:52.463016 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:52.516513 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:52.566638 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:52.607213 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:52.654663 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:52.685956 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:52.734598 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:52.774673 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775652774651584 2:1715775652774651584 3:"bob" 4:"smith" 5:1] gorptest: 12:20:52.839016 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:20:52.839196 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715775652774651584 2:1715775652774651584 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 12:20:52.906601 select * from person_test where id = ? [1:1] gorptest: 12:20:52.906748 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 12:20:52.932597 drop table if exists "invoice_test"; [] gorptest: 12:20:52.989629 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:53.027684 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:53.070820 drop table if exists "invoice_override_test"; [] gorptest: 12:20:53.095914 drop table if exists "person_test"; [] gorptest: 12:20:53.132013 drop table if exists "ignored_column_test"; [] gorptest: 12:20:53.170958 drop table if exists "id_created_test"; [] gorptest: 12:20:53.226516 drop table if exists "type_conv_test"; [] gorptest: 12:20:53.302608 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:53.318214 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:53.335205 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:53.362682 drop table if exists "time_test"; [] gorptest: 12:20:53.428648 drop table if exists "id_created_test"; [] --- PASS: TestHooks (1.13s) === RUN TestTransaction 2024/05/15 12:20:53 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:20:53.428929 drop table if exists "invoice_test"; [] gorptest: 12:20:53.429158 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:53.429174 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:53.429187 drop table if exists "invoice_override_test"; [] gorptest: 12:20:53.429198 drop table if exists "person_test"; [] gorptest: 12:20:53.429209 drop table if exists "ignored_column_test"; [] gorptest: 12:20:53.429220 drop table if exists "id_created_test"; [] gorptest: 12:20:53.429231 drop table if exists "type_conv_test"; [] gorptest: 12:20:53.429242 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:53.429254 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:53.429266 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:53.429276 drop table if exists "time_test"; [] gorptest: 12:20:53.429295 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:53.474820 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:20:53.503931 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:53.534585 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:20:53.573055 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:20:53.658290 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:53.709055 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:53.738789 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:53.770657 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:53.818268 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:53.897016 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:53.938560 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:53.978609 begin; [] gorptest: 12:20:53.978704 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 12:20:53.982702 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 12:20:53.982749 commit; [] gorptest: 12:20:54.024500 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:54.024613 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 12:20:54.024656 drop table if exists "invoice_test"; [] gorptest: 12:20:54.040654 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:54.068777 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:54.110631 drop table if exists "invoice_override_test"; [] gorptest: 12:20:54.157195 drop table if exists "person_test"; [] gorptest: 12:20:54.384592 drop table if exists "ignored_column_test"; [] gorptest: 12:20:54.422598 drop table if exists "id_created_test"; [] gorptest: 12:20:54.446550 drop table if exists "type_conv_test"; [] gorptest: 12:20:54.474757 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:54.506664 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:54.570714 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:54.606593 drop table if exists "time_test"; [] gorptest: 12:20:54.653934 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (1.23s) === RUN TestSavepoint 2024/05/15 12:20:54 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:20:54.654212 drop table if exists "invoice_test"; [] gorptest: 12:20:54.654458 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:54.654986 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:54.655007 drop table if exists "invoice_override_test"; [] gorptest: 12:20:54.655021 drop table if exists "person_test"; [] gorptest: 12:20:54.655034 drop table if exists "ignored_column_test"; [] gorptest: 12:20:54.655046 drop table if exists "id_created_test"; [] gorptest: 12:20:54.655059 drop table if exists "type_conv_test"; [] gorptest: 12:20:54.655071 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:54.655084 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:54.655096 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:54.655108 drop table if exists "time_test"; [] gorptest: 12:20:54.655129 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:54.709495 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:20:54.761180 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:54.787320 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:20:54.834648 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:20:54.871702 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:54.941479 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:55.006621 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:55.034574 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:55.107683 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:55.130587 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:55.150829 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:55.174966 begin; [] gorptest: 12:20:55.175023 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 12:20:55.175138 select memo from invoice_test [] gorptest: 12:20:55.175179 savepoint "foo" [1:] gorptest: 12:20:55.175186 select memo from invoice_test [] gorptest: 12:20:55.175215 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:20:55.175246 select memo from invoice_test [] gorptest: 12:20:55.175264 rollback to savepoint "foo" [1:] gorptest: 12:20:55.175272 select memo from invoice_test [] gorptest: 12:20:55.175284 rollback; [] gorptest: 12:20:55.175361 drop table if exists "invoice_test"; [] gorptest: 12:20:55.285682 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:56.015562 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:56.606594 drop table if exists "invoice_override_test"; [] gorptest: 12:20:56.666641 drop table if exists "person_test"; [] gorptest: 12:20:56.698723 drop table if exists "ignored_column_test"; [] gorptest: 12:20:56.743498 drop table if exists "id_created_test"; [] gorptest: 12:20:56.794739 drop table if exists "type_conv_test"; [] gorptest: 12:20:56.822927 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:56.850290 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:56.874714 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:56.922589 drop table if exists "time_test"; [] gorptest: 12:20:56.957374 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (2.30s) === RUN TestMultiple 2024/05/15 12:20:56 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:20:56.957597 drop table if exists "invoice_test"; [] gorptest: 12:20:56.957792 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:56.957808 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:56.957819 drop table if exists "invoice_override_test"; [] gorptest: 12:20:56.957830 drop table if exists "person_test"; [] gorptest: 12:20:56.957840 drop table if exists "ignored_column_test"; [] gorptest: 12:20:56.957849 drop table if exists "id_created_test"; [] gorptest: 12:20:56.957859 drop table if exists "type_conv_test"; [] gorptest: 12:20:56.957868 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:56.957878 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:56.957887 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:56.957897 drop table if exists "time_test"; [] gorptest: 12:20:56.957912 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:56.990759 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:20:57.043924 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:57.071874 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:20:57.128840 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:20:57.154852 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:57.210649 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:57.242619 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:57.274589 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:57.314641 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:57.341556 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:57.386584 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:57.422570 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 12:20:57.462574 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 12:20:57.494544 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:20:57.518851 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:20:57.538675 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:57.562582 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 12:20:57.586169 drop table if exists "invoice_test"; [] gorptest: 12:20:57.607874 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:57.634678 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:57.654603 drop table if exists "invoice_override_test"; [] gorptest: 12:20:57.682572 drop table if exists "person_test"; [] gorptest: 12:20:57.698614 drop table if exists "ignored_column_test"; [] gorptest: 12:20:57.724643 drop table if exists "id_created_test"; [] gorptest: 12:20:57.750594 drop table if exists "type_conv_test"; [] gorptest: 12:20:57.782553 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:57.802775 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:57.834971 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:57.874304 drop table if exists "time_test"; [] gorptest: 12:20:57.898345 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.94s) === RUN TestCrud 2024/05/15 12:20:57 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:20:57.898611 drop table if exists "invoice_test"; [] gorptest: 12:20:57.898854 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:57.898870 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:57.898882 drop table if exists "invoice_override_test"; [] gorptest: 12:20:57.898893 drop table if exists "person_test"; [] gorptest: 12:20:57.898903 drop table if exists "ignored_column_test"; [] gorptest: 12:20:57.898913 drop table if exists "id_created_test"; [] gorptest: 12:20:57.898924 drop table if exists "type_conv_test"; [] gorptest: 12:20:57.898935 drop table if exists "embedded_struct_test"; [] gorptest: 12:20:57.898947 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:20:57.898957 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:20:57.898966 drop table if exists "time_test"; [] gorptest: 12:20:57.898983 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:20:57.927037 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:20:57.946577 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:20:57.987801 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:20:58.030847 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:20:58.053265 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:58.068214 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:20:58.094721 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:20:58.130555 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:20:58.166594 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:20:58.190576 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:20:58.230716 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:20:58.258657 delete from invoice_test [] gorptest: 12:20:58.276257 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:20:58.298916 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:58.299045 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:7839095937257966570 2:4041297204808139179 3:"random 2696765179502899615" 4:0 5:true 6:1] gorptest: 12:20:58.329918 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:58.330089 select * from invoice_test [] gorptest: 12:20:58.330197 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:58.366626 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 12:20:58.366765 delete from invoice_tag_test [] gorptest: 12:20:58.388082 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:20:58.427049 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:20:58.427276 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:7409970030226928715 2:1119421891304776682 3:"random 6544090929377558607" 4:33 5:false 6:1] gorptest: 12:20:58.458744 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:20:58.458947 select * from invoice_tag_test [] gorptest: 12:20:58.459034 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:20:58.487186 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 12:20:58.487257 delete from alias_trans_field_test [] gorptest: 12:20:58.516653 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 12:20:58.538656 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:20:58.538854 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 6654488622459004037" 2:1] gorptest: 12:20:58.562590 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:20:58.562704 select * from alias_trans_field_test [] gorptest: 12:20:58.562765 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:20:58.586594 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 12:20:58.586703 drop table if exists "invoice_test"; [] gorptest: 12:20:58.610596 drop table if exists "invoice_tag_test"; [] gorptest: 12:20:58.641138 drop table if exists "alias_trans_field_test"; [] gorptest: 12:20:58.686550 drop table if exists "invoice_override_test"; [] gorptest: 12:20:58.717404 drop table if exists "person_test"; [] gorptest: 12:20:58.750604 drop table if exists "ignored_column_test"; [] gorptest: 12:20:59.820677 drop table if exists "id_created_test"; [] gorptest: 12:20:59.934607 drop table if exists "type_conv_test"; [] gorptest: 12:20:59.962652 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:00.010659 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:00.051098 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:00.086860 drop table if exists "time_test"; [] gorptest: 12:21:00.128370 drop table if exists "id_created_test"; [] --- PASS: TestCrud (2.23s) === RUN TestWithIgnoredColumn 2024/05/15 12:21:00 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:00.128624 drop table if exists "invoice_test"; [] gorptest: 12:21:00.128848 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:00.128865 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:00.128876 drop table if exists "invoice_override_test"; [] gorptest: 12:21:00.128886 drop table if exists "person_test"; [] gorptest: 12:21:00.128897 drop table if exists "ignored_column_test"; [] gorptest: 12:21:00.128906 drop table if exists "id_created_test"; [] gorptest: 12:21:00.128916 drop table if exists "type_conv_test"; [] gorptest: 12:21:00.128926 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:00.128936 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:00.128946 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:00.128956 drop table if exists "time_test"; [] gorptest: 12:21:00.128973 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:00.154665 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:21:00.183086 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:00.219837 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:21:00.264306 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:21:00.308622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:00.334599 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:00.371743 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:00.411655 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:00.438803 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:00.482797 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:00.519699 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:00.558647 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 12:21:00.585501 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:21:00.585735 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:21:00.609468 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 12:21:00.609600 drop table if exists "invoice_test"; [] gorptest: 12:21:00.666619 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:00.703919 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:00.753954 drop table if exists "invoice_override_test"; [] gorptest: 12:21:00.794607 drop table if exists "person_test"; [] gorptest: 12:21:00.809894 drop table if exists "ignored_column_test"; [] gorptest: 12:21:00.824640 drop table if exists "id_created_test"; [] gorptest: 12:21:00.846646 drop table if exists "type_conv_test"; [] gorptest: 12:21:00.862604 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:00.879420 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:00.912148 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:00.930601 drop table if exists "time_test"; [] gorptest: 12:21:00.954797 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.83s) === RUN TestTypeConversionExample 2024/05/15 12:21:00 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:00.955365 drop table if exists "invoice_test"; [] gorptest: 12:21:00.955728 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:00.955744 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:00.955756 drop table if exists "invoice_override_test"; [] gorptest: 12:21:00.955768 drop table if exists "person_test"; [] gorptest: 12:21:00.955781 drop table if exists "ignored_column_test"; [] gorptest: 12:21:00.955793 drop table if exists "id_created_test"; [] gorptest: 12:21:00.955805 drop table if exists "type_conv_test"; [] gorptest: 12:21:00.955816 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:00.955829 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:00.955841 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:00.955852 drop table if exists "time_test"; [] gorptest: 12:21:00.955918 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:00.967403 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:21:00.983181 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:01.004360 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:21:01.025592 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:21:01.054568 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:01.071910 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:01.095515 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:01.132192 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:01.175220 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:01.203005 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:01.234554 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:01.250834 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:21:01.266617 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:21:01.266758 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:21:01.286583 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:21:01.286711 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 12:21:01.305472 drop table if exists "invoice_test"; [] gorptest: 12:21:01.326536 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:01.359916 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:01.387214 drop table if exists "invoice_override_test"; [] gorptest: 12:21:01.413357 drop table if exists "person_test"; [] gorptest: 12:21:01.438562 drop table if exists "ignored_column_test"; [] gorptest: 12:21:01.455301 drop table if exists "id_created_test"; [] gorptest: 12:21:01.474632 drop table if exists "type_conv_test"; [] gorptest: 12:21:01.494643 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:01.506563 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:01.530566 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:01.554531 drop table if exists "time_test"; [] gorptest: 12:21:01.570587 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.62s) === RUN TestWithEmbeddedStruct 2024/05/15 12:21:01 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:01.570840 drop table if exists "invoice_test"; [] gorptest: 12:21:01.571059 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:01.571073 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:01.571084 drop table if exists "invoice_override_test"; [] gorptest: 12:21:01.571095 drop table if exists "person_test"; [] gorptest: 12:21:01.571105 drop table if exists "ignored_column_test"; [] gorptest: 12:21:01.571116 drop table if exists "id_created_test"; [] gorptest: 12:21:01.571127 drop table if exists "type_conv_test"; [] gorptest: 12:21:01.571137 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:01.571147 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:01.571157 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:01.571166 drop table if exists "time_test"; [] gorptest: 12:21:01.571183 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:01.582539 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:21:01.602552 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:01.614600 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:21:01.630550 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:21:01.642622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:01.658986 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:01.698911 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:01.715800 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:01.758665 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:01.790315 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:01.812728 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:01.838607 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 12:21:01.873764 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 12:21:01.873995 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 12:21:01.908613 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 12:21:01.908777 select * from embedded_struct_test [] gorptest: 12:21:01.908839 drop table if exists "invoice_test"; [] gorptest: 12:21:01.922777 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:01.951315 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:01.978622 drop table if exists "invoice_override_test"; [] gorptest: 12:21:02.008589 drop table if exists "person_test"; [] gorptest: 12:21:02.035608 drop table if exists "ignored_column_test"; [] gorptest: 12:21:02.056707 drop table if exists "id_created_test"; [] gorptest: 12:21:02.085136 drop table if exists "type_conv_test"; [] gorptest: 12:21:02.114603 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:02.126809 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:02.146690 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:02.170607 drop table if exists "time_test"; [] gorptest: 12:21:02.186695 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.62s) === RUN TestWithEmbeddedStructBeforeAutoincr 2024/05/15 12:21:02 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:02.187050 drop table if exists "invoice_test"; [] gorptest: 12:21:02.187329 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:02.187345 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:02.187358 drop table if exists "invoice_override_test"; [] gorptest: 12:21:02.187368 drop table if exists "person_test"; [] gorptest: 12:21:02.187379 drop table if exists "ignored_column_test"; [] gorptest: 12:21:02.187391 drop table if exists "id_created_test"; [] gorptest: 12:21:02.187401 drop table if exists "type_conv_test"; [] gorptest: 12:21:02.187411 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:02.187422 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:02.187432 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:02.187442 drop table if exists "time_test"; [] gorptest: 12:21:02.187463 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:02.210560 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:21:02.222599 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:02.234550 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:21:02.253753 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:21:02.274827 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:02.297945 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:02.313239 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:02.334933 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:02.362127 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:02.380397 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:02.401038 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:02.434579 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 12:21:02.456771 drop table if exists "invoice_test"; [] gorptest: 12:21:02.488378 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:02.525787 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:02.547530 drop table if exists "invoice_override_test"; [] gorptest: 12:21:02.575800 drop table if exists "person_test"; [] gorptest: 12:21:02.610626 drop table if exists "ignored_column_test"; [] gorptest: 12:21:02.628811 drop table if exists "id_created_test"; [] gorptest: 12:21:02.678678 drop table if exists "type_conv_test"; [] gorptest: 12:21:02.705676 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:02.732797 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:02.767142 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:02.804398 drop table if exists "time_test"; [] gorptest: 12:21:02.822991 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.64s) === RUN TestWithEmbeddedAutoincr 2024/05/15 12:21:02 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:02.823333 drop table if exists "invoice_test"; [] gorptest: 12:21:02.823642 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:02.823660 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:02.823675 drop table if exists "invoice_override_test"; [] gorptest: 12:21:02.823688 drop table if exists "person_test"; [] gorptest: 12:21:02.823703 drop table if exists "ignored_column_test"; [] gorptest: 12:21:02.823716 drop table if exists "id_created_test"; [] gorptest: 12:21:02.823728 drop table if exists "type_conv_test"; [] gorptest: 12:21:02.823741 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:02.823754 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:02.823766 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:02.823778 drop table if exists "time_test"; [] gorptest: 12:21:02.823798 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:02.840399 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:21:02.857483 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:02.880906 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:21:02.902313 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:21:02.941074 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:02.959144 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:02.987088 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:03.004742 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:03.032695 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:03.050965 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:03.074786 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:03.103893 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 12:21:03.123961 drop table if exists "invoice_test"; [] gorptest: 12:21:03.149436 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:03.166326 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:03.190517 drop table if exists "invoice_override_test"; [] gorptest: 12:21:03.410986 drop table if exists "person_test"; [] gorptest: 12:21:03.419386 drop table if exists "ignored_column_test"; [] gorptest: 12:21:03.426233 drop table if exists "id_created_test"; [] gorptest: 12:21:03.438499 drop table if exists "type_conv_test"; [] gorptest: 12:21:03.443939 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:03.454564 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:03.463018 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:03.474175 drop table if exists "time_test"; [] gorptest: 12:21:03.481002 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.66s) === RUN TestSelectVal gorptest: 12:21:03.481318 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 12:21:03.497063 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:21:03.510594 select Int64 from TableWithNull where Str='abc' [] gorptest: 12:21:03.510758 select count(*) from TableWithNull [] gorptest: 12:21:03.510811 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 12:21:03.510862 select Int64 from TableWithNull where Str='notfound' [] gorptest: 12:21:03.510905 select Int64 from TableWithNull where Str='abc' [] gorptest: 12:21:03.510943 select Float64 from TableWithNull where Str='abc' [] gorptest: 12:21:03.510976 select min(Float64) from TableWithNull [] gorptest: 12:21:03.511026 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 12:21:03.511101 select Float64 from TableWithNull where Str='notfound' [] gorptest: 12:21:03.511151 select Float64 from TableWithNull where Str='abc' [] gorptest: 12:21:03.511192 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:21:03.511231 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 12:21:03.511261 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:21:03.511297 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 12:21:03.511344 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 12:21:03.511385 select Str from TableWithNull where Int64=? [1:78] gorptest: 12:21:03.511422 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.06s) === RUN TestVersionMultipleRows 2024/05/15 12:21:03 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:03.538794 drop table if exists "invoice_test"; [] gorptest: 12:21:03.540556 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:03.540605 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:03.540641 drop table if exists "invoice_override_test"; [] gorptest: 12:21:03.540670 drop table if exists "person_test"; [] gorptest: 12:21:03.540688 drop table if exists "ignored_column_test"; [] gorptest: 12:21:03.540704 drop table if exists "id_created_test"; [] gorptest: 12:21:03.540719 drop table if exists "type_conv_test"; [] gorptest: 12:21:03.540734 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:03.540750 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:03.540765 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:03.540780 drop table if exists "time_test"; [] gorptest: 12:21:03.540805 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:03.564384 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:21:03.578334 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:03.598714 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:21:03.619494 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:21:03.635776 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:03.660234 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:03.690807 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:03.719299 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:03.734786 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:03.758614 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:03.777131 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:03.800055 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775663800014943 2:1715775663800014943 3:"Bob" 4:"Smith" 5:1] gorptest: 12:21:03.825133 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775663825105176 2:1715775663825105176 3:"Jane" 4:"Smith" 5:1] gorptest: 12:21:03.840906 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775663840882434 2:1715775663840882434 3:"Mike" 4:"Smith" 5:1] gorptest: 12:21:03.872204 drop table if exists "invoice_test"; [] gorptest: 12:21:03.882658 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:03.898923 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:03.926654 drop table if exists "invoice_override_test"; [] gorptest: 12:21:03.944603 drop table if exists "person_test"; [] gorptest: 12:21:03.980886 drop table if exists "ignored_column_test"; [] gorptest: 12:21:04.014610 drop table if exists "id_created_test"; [] gorptest: 12:21:04.030606 drop table if exists "type_conv_test"; [] gorptest: 12:21:04.056398 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:04.082759 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:04.106580 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:04.125982 drop table if exists "time_test"; [] gorptest: 12:21:04.132572 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.59s) === RUN TestWithStringPk gorptest: 12:21:04.132757 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 12:21:04.147937 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 12:21:04.162638 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.04s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2024/05/15 12:21:04 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:04.169431 drop table if exists "invoice_test"; [] gorptest: 12:21:04.169631 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:04.169647 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:04.169660 drop table if exists "invoice_override_test"; [] gorptest: 12:21:04.169671 drop table if exists "person_test"; [] gorptest: 12:21:04.169681 drop table if exists "ignored_column_test"; [] gorptest: 12:21:04.169690 drop table if exists "id_created_test"; [] gorptest: 12:21:04.169700 drop table if exists "type_conv_test"; [] gorptest: 12:21:04.169709 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:04.169718 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:04.169728 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:04.169738 drop table if exists "time_test"; [] gorptest: 12:21:04.169762 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:04.190561 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:21:04.195406 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:04.210426 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:21:04.224864 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:21:04.242697 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:04.250959 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:04.266661 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:04.272183 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:04.291173 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:04.306656 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:04.319875 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:04.338606 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-15 11:50:04.338581341 +0000 UTC] gorptest: 12:21:04.354572 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-15 11:51:05.338581341 +0000 UTC] gorptest: 12:21:04.368790 SELECT id FROM time_test WHERE Time < ? [1:2024-05-15 11:51:04.338581341 +0000 UTC] gorptest: 12:21:04.368971 drop table if exists "invoice_test"; [] gorptest: 12:21:04.386550 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:04.414583 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:04.430215 drop table if exists "invoice_override_test"; [] gorptest: 12:21:04.446821 drop table if exists "person_test"; [] gorptest: 12:21:04.461106 drop table if exists "ignored_column_test"; [] gorptest: 12:21:04.478960 drop table if exists "id_created_test"; [] gorptest: 12:21:04.490494 drop table if exists "type_conv_test"; [] gorptest: 12:21:04.498658 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:04.507406 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:04.514144 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:04.524268 drop table if exists "time_test"; [] gorptest: 12:21:04.543599 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.37s) === RUN TestInvoicePersonView 2024/05/15 12:21:04 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:04.544382 drop table if exists "invoice_test"; [] gorptest: 12:21:04.544888 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:04.544909 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:04.544923 drop table if exists "invoice_override_test"; [] gorptest: 12:21:04.544935 drop table if exists "person_test"; [] gorptest: 12:21:04.544948 drop table if exists "ignored_column_test"; [] gorptest: 12:21:04.544964 drop table if exists "id_created_test"; [] gorptest: 12:21:04.544976 drop table if exists "type_conv_test"; [] gorptest: 12:21:04.544988 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:04.545001 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:04.545013 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:04.545025 drop table if exists "time_test"; [] gorptest: 12:21:04.545048 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:04.553022 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:21:04.566066 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:04.580014 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:21:04.596238 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:21:04.610596 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:04.624096 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:04.642600 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:04.658572 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:04.674768 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:04.683851 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:04.694758 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:04.706799 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775664706779704 2:1715775664706779704 3:"bob" 4:"smith" 5:1] gorptest: 12:21:04.726736 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:21:04.742578 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:21:04.742748 drop table if exists "invoice_test"; [] gorptest: 12:21:04.754667 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:04.773197 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:04.787702 drop table if exists "invoice_override_test"; [] gorptest: 12:21:04.810606 drop table if exists "person_test"; [] gorptest: 12:21:04.826021 drop table if exists "ignored_column_test"; [] gorptest: 12:21:04.840078 drop table if exists "id_created_test"; [] gorptest: 12:21:04.860988 drop table if exists "type_conv_test"; [] gorptest: 12:21:04.874722 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:04.893969 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:05.298978 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:05.318168 drop table if exists "time_test"; [] gorptest: 12:21:05.334687 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.79s) === RUN TestQuoteTableNames 2024/05/15 12:21:05 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:05.335042 drop table if exists "invoice_test"; [] gorptest: 12:21:05.335352 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:05.335380 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:05.335395 drop table if exists "invoice_override_test"; [] gorptest: 12:21:05.335417 drop table if exists "person_test"; [] gorptest: 12:21:05.335447 drop table if exists "ignored_column_test"; [] gorptest: 12:21:05.335470 drop table if exists "id_created_test"; [] gorptest: 12:21:05.335483 drop table if exists "type_conv_test"; [] gorptest: 12:21:05.335496 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:05.335509 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:05.335522 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:05.335534 drop table if exists "time_test"; [] gorptest: 12:21:05.335556 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:05.340624 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:21:05.349827 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:05.362540 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:21:05.376540 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:21:05.388024 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:05.410235 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:05.434269 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:05.446654 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:05.458010 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:05.479461 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:05.498604 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.32s) === RUN TestSelectTooManyCols 2024/05/15 12:21:05 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:05.656718 drop table if exists "invoice_test"; [] gorptest: 12:21:05.657033 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:05.657055 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:05.657073 drop table if exists "invoice_override_test"; [] gorptest: 12:21:05.657088 drop table if exists "person_test"; [] gorptest: 12:21:05.657103 drop table if exists "ignored_column_test"; [] gorptest: 12:21:05.657119 drop table if exists "id_created_test"; [] gorptest: 12:21:05.657135 drop table if exists "type_conv_test"; [] gorptest: 12:21:05.657149 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:05.657166 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:05.657181 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:05.657196 drop table if exists "time_test"; [] gorptest: 12:21:05.657223 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:05.666330 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:21:05.676670 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:05.685911 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:21:05.698237 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:21:05.708655 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:05.718066 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:05.728631 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:05.738125 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:05.748695 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:05.758412 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:05.768740 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:05.776429 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775665776399387 2:1715775665776399387 3:"bob" 4:"smith" 5:1] gorptest: 12:21:05.788163 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775665788151604 2:1715775665788151604 3:"jane" 4:"doe" 5:1] gorptest: 12:21:05.800364 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:21:05.800470 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 12:21:05.800560 select * from person_test where Id=? [1:1] gorptest: 12:21:05.800634 select * from person_test order by fname asc [] gorptest: 12:21:05.800716 drop table if exists "invoice_test"; [] gorptest: 12:21:05.810548 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:05.822022 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:05.834656 drop table if exists "invoice_override_test"; [] gorptest: 12:21:05.849303 drop table if exists "person_test"; [] gorptest: 12:21:05.862571 drop table if exists "ignored_column_test"; [] gorptest: 12:21:05.874712 drop table if exists "id_created_test"; [] gorptest: 12:21:05.886191 drop table if exists "type_conv_test"; [] gorptest: 12:21:05.898621 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:05.910651 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:05.928516 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:05.950651 drop table if exists "time_test"; [] gorptest: 12:21:05.955858 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.30s) === RUN TestSelectSingleVal 2024/05/15 12:21:05 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:05.956151 drop table if exists "invoice_test"; [] gorptest: 12:21:05.956386 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:05.956407 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:05.956424 drop table if exists "invoice_override_test"; [] gorptest: 12:21:05.956439 drop table if exists "person_test"; [] gorptest: 12:21:05.956453 drop table if exists "ignored_column_test"; [] gorptest: 12:21:05.956466 drop table if exists "id_created_test"; [] gorptest: 12:21:05.956479 drop table if exists "type_conv_test"; [] gorptest: 12:21:05.956491 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:05.956504 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:05.956516 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:05.956529 drop table if exists "time_test"; [] gorptest: 12:21:05.956548 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:05.966831 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:21:05.978168 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:05.990107 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:21:06.004636 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:21:06.016645 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.028820 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.046161 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:06.066741 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:06.080416 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:06.096341 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:06.112891 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:06.126084 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775666126053191 2:1715775666126053191 3:"bob" 4:"smith" 5:1] gorptest: 12:21:06.142247 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 12:21:06.142410 select * from person_test where Id=? [1:1] gorptest: 12:21:06.142527 select FName from person_test where Id=? [1:1] gorptest: 12:21:06.142581 select * from person_test where Id=? [1:1] gorptest: 12:21:06.142649 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 12:21:06.142712 select * from person_test where Id=? [1:-2222] gorptest: 12:21:06.142778 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715775666142767092 2:1715775666142767092 3:"bob" 4:"smith" 5:1] gorptest: 12:21:06.158610 select * from person_test where Fname='bob' [] gorptest: 12:21:06.158794 select * from person_test where Id=-123 [] gorptest: 12:21:06.158839 select * from person_test where Id=-123 [] gorptest: 12:21:06.158873 select * from person_test where Id=-123 [] gorptest: 12:21:06.158901 select * from person_test where Id=-123 [] gorptest: 12:21:06.158931 drop table if exists "invoice_test"; [] gorptest: 12:21:06.170575 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:06.184753 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:06.198379 drop table if exists "invoice_override_test"; [] gorptest: 12:21:06.214010 drop table if exists "person_test"; [] gorptest: 12:21:06.228372 drop table if exists "ignored_column_test"; [] gorptest: 12:21:06.242191 drop table if exists "id_created_test"; [] gorptest: 12:21:06.256529 drop table if exists "type_conv_test"; [] gorptest: 12:21:06.270113 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:06.284392 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:06.300260 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:06.314685 drop table if exists "time_test"; [] gorptest: 12:21:06.328338 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.37s) === RUN TestSelectAlias 2024/05/15 12:21:06 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:21:06.328602 drop table if exists "invoice_test"; [] gorptest: 12:21:06.328829 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:06.328864 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:06.328884 drop table if exists "invoice_override_test"; [] gorptest: 12:21:06.328900 drop table if exists "person_test"; [] gorptest: 12:21:06.328914 drop table if exists "ignored_column_test"; [] gorptest: 12:21:06.328929 drop table if exists "id_created_test"; [] gorptest: 12:21:06.328943 drop table if exists "type_conv_test"; [] gorptest: 12:21:06.328992 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:06.329163 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:06.329187 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:06.329204 drop table if exists "time_test"; [] gorptest: 12:21:06.329231 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:06.341974 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:21:06.356055 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:06.370924 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:21:06.386994 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:21:06.400504 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.416687 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.430700 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:06.446215 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:06.460200 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:06.484071 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:06.494077 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:06.506033 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 12:21:06.526504 select * from id_created_test where Id=1 [] gorptest: 12:21:06.526601 SELECT *, 1 AS external FROM id_created_test [] gorptest: 12:21:06.526681 drop table if exists "invoice_test"; [] gorptest: 12:21:06.535760 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:06.551893 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:06.564475 drop table if exists "invoice_override_test"; [] gorptest: 12:21:06.578430 drop table if exists "person_test"; [] gorptest: 12:21:06.590393 drop table if exists "ignored_column_test"; [] gorptest: 12:21:06.602561 drop table if exists "id_created_test"; [] gorptest: 12:21:06.616051 drop table if exists "type_conv_test"; [] gorptest: 12:21:06.628451 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:06.639907 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:06.653410 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:06.663857 drop table if exists "time_test"; [] gorptest: 12:21:06.674376 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.35s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2024/05/15 12:21:06 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:21:06.674712 drop table if exists "invoice_test"; [] gorptest: 12:21:06.674934 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:06.674975 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:06.674993 drop table if exists "invoice_override_test"; [] gorptest: 12:21:06.675006 drop table if exists "person_test"; [] gorptest: 12:21:06.675019 drop table if exists "ignored_column_test"; [] gorptest: 12:21:06.675041 drop table if exists "id_created_test"; [] gorptest: 12:21:06.675061 drop table if exists "type_conv_test"; [] gorptest: 12:21:06.675073 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:06.675089 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:06.675112 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:06.675137 drop table if exists "time_test"; [] gorptest: 12:21:06.675254 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:06.683991 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:21:06.696431 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:06.708171 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:21:06.722769 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:21:06.734757 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.746688 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:06.758256 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:06.781894 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:06.797075 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:06.818617 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:06.830604 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:06.842555 drop table if exists "invoice_test"; [] gorptest: 12:21:06.854680 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:06.861668 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:06.866911 drop table if exists "invoice_override_test"; [] gorptest: 12:21:06.874769 drop table if exists "person_test"; [] gorptest: 12:21:06.888438 drop table if exists "ignored_column_test"; [] gorptest: 12:21:06.898799 drop table if exists "id_created_test"; [] gorptest: 12:21:06.908332 drop table if exists "type_conv_test"; [] gorptest: 12:21:06.917932 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:06.927979 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:06.938528 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:06.948402 drop table if exists "time_test"; [] gorptest: 12:21:06.964489 drop table if exists "id_created_test"; [] gorptest: 12:21:06.964535 drop table if exists "single_column_table"; [] gorptest: 12:21:06.964575 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:21:06.978702 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:21:06.988439 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:06.998803 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:21:07.010401 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:21:07.023909 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:07.044626 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:07.054927 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:07.064479 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:07.074651 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:21:07.084134 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:21:07.094634 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:07.106571 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 12:21:07.106633 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 12:21:07.119901 delete from "invoice_test"; [] gorptest: 12:21:07.129992 delete from "invoice_tag_test"; [] gorptest: 12:21:07.140680 delete from "alias_trans_field_test"; [] gorptest: 12:21:07.150691 delete from "invoice_override_test"; [] gorptest: 12:21:07.162721 delete from "person_test"; [] gorptest: 12:21:07.176288 delete from "ignored_column_test"; [] gorptest: 12:21:07.192593 delete from "id_created_test"; [] gorptest: 12:21:07.202279 delete from "type_conv_test"; [] gorptest: 12:21:07.218170 delete from "embedded_struct_test"; [] gorptest: 12:21:07.228951 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:07.246593 delete from "embedded_autoincr_test"; [] gorptest: 12:21:07.262582 delete from "time_test"; [] gorptest: 12:21:07.278571 delete from "id_created_test"; [] gorptest: 12:21:07.288785 delete from "single_column_table"; [] gorptest: 12:21:07.302076 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 12:21:07.302221 drop table if exists "invoice_test"; [] gorptest: 12:21:07.318584 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:07.334585 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:07.350621 drop table if exists "invoice_override_test"; [] gorptest: 12:21:07.366717 drop table if exists "person_test"; [] gorptest: 12:21:07.382560 drop table if exists "ignored_column_test"; [] gorptest: 12:21:07.398558 drop table if exists "id_created_test"; [] gorptest: 12:21:07.414554 drop table if exists "type_conv_test"; [] gorptest: 12:21:07.430677 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:07.442552 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:07.454554 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:07.465580 drop table if exists "time_test"; [] gorptest: 12:21:07.478546 drop table if exists "id_created_test"; [] gorptest: 12:21:07.478596 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.82s) === RUN TestPrepare 2024/05/15 12:21:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 12:21:07.490756 drop table if exists "invoice_test"; [] gorptest: 12:21:07.490989 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:07.491009 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:07.491023 drop table if exists "invoice_override_test"; [] gorptest: 12:21:07.491036 drop table if exists "person_test"; [] gorptest: 12:21:07.491048 drop table if exists "ignored_column_test"; [] gorptest: 12:21:07.491061 drop table if exists "id_created_test"; [] gorptest: 12:21:07.491073 drop table if exists "type_conv_test"; [] gorptest: 12:21:07.491085 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:07.491097 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:07.491110 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:07.491122 drop table if exists "time_test"; [] gorptest: 12:21:07.491142 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 12:21:07.506545 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:21:07.520162 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 12:21:07.538543 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:21:07.554543 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:21:07.570651 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:07.586533 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 12:21:07.606534 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 12:21:07.626530 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 12:21:07.646533 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 12:21:07.662529 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 12:21:07.678558 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 12:21:07.694568 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:21:07.710533 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:21:07.726522 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 12:21:07.742525 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 12:21:07.742621 begin; [] gorptest: 12:21:07.742648 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 12:21:07.742719 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:21:07.742966 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:21:07.743009 commit; [] gorptest: 12:21:07.758526 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 12:21:07.758611 drop table if exists "invoice_test"; [] gorptest: 12:21:07.774531 drop table if exists "invoice_tag_test"; [] gorptest: 12:21:07.790522 drop table if exists "alias_trans_field_test"; [] gorptest: 12:21:07.806529 drop table if exists "invoice_override_test"; [] gorptest: 12:21:07.822527 drop table if exists "person_test"; [] gorptest: 12:21:07.838524 drop table if exists "ignored_column_test"; [] gorptest: 12:21:07.854521 drop table if exists "id_created_test"; [] gorptest: 12:21:07.870701 drop table if exists "type_conv_test"; [] gorptest: 12:21:07.886540 drop table if exists "embedded_struct_test"; [] gorptest: 12:21:07.902539 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 12:21:07.913183 drop table if exists "embedded_autoincr_test"; [] gorptest: 12:21:07.926569 drop table if exists "time_test"; [] gorptest: 12:21:07.942808 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.45s) PASS ok gopkg.in/gorp.v1 22.791s 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_amd64.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: user script /srv/workspace/pbuilder/3458744/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/3458744/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/3458744 and its subdirectories I: Current time: Thu May 16 02:21:11 +14 2024 I: pbuilder-time-stamp: 1715775671