I: pbuilder: network access will be disabled during build I: Current time: Thu May 30 17:15:39 +14 2024 I: pbuilder-time-stamp: 1717038939 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/trixie-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/1609280/tmp/hooks/D01_modify_environment starting debug: Running on ionos11-amd64. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 May 30 03:16 /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/1609280/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/1609280/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=20 ' DIRSTACK=() DISTRIBUTION=trixie EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=x86_64 HOST_ARCH=amd64 IFS=' ' INVOCATION_ID=fc685a3b5a664a50aef1c19fb30e5106 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=1609280 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.1sgelxFH/pbuilderrc_Bp0o --distribution trixie --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.1sgelxFH/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=111 SUDO_UID=106 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://46.16.76.132:3128 I: uname -a Linux i-capture-the-hostname 6.1.0-21-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 28 11:25 /bin -> usr/bin I: user script /srv/workspace/pbuilder/1609280/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 ... 19699 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} 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, 59 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 trixie/main amd64 sensible-utils all 0.0.22 [22.4 kB] Get: 2 http://deb.debian.org/debian trixie/main amd64 libmagic-mgc amd64 1:5.45-3 [314 kB] Get: 3 http://deb.debian.org/debian trixie/main amd64 libmagic1t64 amd64 1:5.45-3 [105 kB] Get: 4 http://deb.debian.org/debian trixie/main amd64 file amd64 1:5.45-3 [42.9 kB] Get: 5 http://deb.debian.org/debian trixie/main amd64 gettext-base amd64 0.21-14+b1 [161 kB] Get: 6 http://deb.debian.org/debian trixie/main amd64 libuchardet0 amd64 0.0.8-1+b1 [68.8 kB] Get: 7 http://deb.debian.org/debian trixie/main amd64 groff-base amd64 1.23.0-4 [1180 kB] Get: 8 http://deb.debian.org/debian trixie/main amd64 bsdextrautils amd64 2.40.1-2 [94.2 kB] Get: 9 http://deb.debian.org/debian trixie/main amd64 libpipeline1 amd64 1.5.7-2 [38.0 kB] Get: 10 http://deb.debian.org/debian trixie/main amd64 man-db amd64 2.12.1-1 [1411 kB] Get: 11 http://deb.debian.org/debian trixie/main amd64 m4 amd64 1.4.19-4 [287 kB] Get: 12 http://deb.debian.org/debian trixie/main amd64 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian trixie/main amd64 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian trixie/main amd64 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian trixie/main amd64 autopoint all 0.21-14 [496 kB] Get: 16 http://deb.debian.org/debian trixie/main amd64 libdebhelper-perl all 13.15.3 [88.0 kB] Get: 17 http://deb.debian.org/debian trixie/main amd64 libtool all 2.4.7-7 [517 kB] Get: 18 http://deb.debian.org/debian trixie/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian trixie/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian trixie/main amd64 libfile-stripnondeterminism-perl all 1.14.0-1 [19.5 kB] Get: 21 http://deb.debian.org/debian trixie/main amd64 dh-strip-nondeterminism all 1.14.0-1 [8448 B] Get: 22 http://deb.debian.org/debian trixie/main amd64 libelf1t64 amd64 0.191-1+b1 [189 kB] Get: 23 http://deb.debian.org/debian trixie/main amd64 dwz amd64 0.15-1+b1 [110 kB] Get: 24 http://deb.debian.org/debian trixie/main amd64 libicu72 amd64 72.1-4+b1 [9395 kB] Get: 25 http://deb.debian.org/debian trixie/main amd64 libxml2 amd64 2.9.14+dfsg-1.3+b3 [692 kB] Get: 26 http://deb.debian.org/debian trixie/main amd64 gettext amd64 0.21-14+b1 [1301 kB] Get: 27 http://deb.debian.org/debian trixie/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 28 http://deb.debian.org/debian trixie/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 29 http://deb.debian.org/debian trixie/main amd64 debhelper all 13.15.3 [901 kB] Get: 30 http://deb.debian.org/debian trixie/main amd64 dh-golang all 1.62 [24.7 kB] Get: 31 http://deb.debian.org/debian trixie/main amd64 golang-1.22-src all 1.22.3-1 [18.8 MB] Get: 32 http://deb.debian.org/debian trixie/main amd64 golang-1.22-go amd64 1.22.3-1 [24.7 MB] Get: 33 http://deb.debian.org/debian trixie/main amd64 golang-src all 2:1.22~3 [5020 B] Get: 34 http://deb.debian.org/debian trixie/main amd64 golang-go amd64 2:1.22~3 [44.2 kB] Get: 35 http://deb.debian.org/debian trixie/main amd64 golang-any amd64 2:1.22~3 [5104 B] Get: 36 http://deb.debian.org/debian trixie/main amd64 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 37 http://deb.debian.org/debian trixie/main amd64 golang-github-go-sql-driver-mysql-dev all 1.7.1-2 [74.6 kB] Get: 38 http://deb.debian.org/debian trixie/main amd64 golang-github-gorilla-securecookie-dev all 1.1.2-1 [14.0 kB] Get: 39 http://deb.debian.org/debian trixie/main amd64 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 40 http://deb.debian.org/debian trixie/main amd64 golang-github-hashicorp-go-uuid-dev all 1.0.3-1 [8636 B] Get: 41 http://deb.debian.org/debian trixie/main amd64 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 42 http://deb.debian.org/debian trixie/main amd64 golang-github-stretchr-objx-dev all 0.5.2-1 [25.5 kB] Get: 43 http://deb.debian.org/debian trixie/main amd64 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 44 http://deb.debian.org/debian trixie/main amd64 golang-github-stretchr-testify-dev all 1.9.0-1 [74.7 kB] Get: 45 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 46 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 47 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 48 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 49 http://deb.debian.org/debian trixie/main amd64 golang-golang-x-sys-dev all 0.20.0-1 [430 kB] Get: 50 http://deb.debian.org/debian trixie/main amd64 golang-golang-x-term-dev all 0.20.0-1 [14.8 kB] Get: 51 http://deb.debian.org/debian trixie/main amd64 golang-golang-x-text-dev all 0.15.0-1 [4006 kB] Get: 52 http://deb.debian.org/debian trixie/main amd64 golang-golang-x-crypto-dev all 1:0.23.0-1 [1689 kB] Get: 53 http://deb.debian.org/debian trixie/main amd64 golang-golang-x-net-dev all 1:0.25.0+dfsg-1 [895 kB] Get: 54 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 55 http://deb.debian.org/debian trixie/main amd64 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 56 http://deb.debian.org/debian trixie/main amd64 golang-github-lib-pq-dev all 1.10.9-2 [86.6 kB] Get: 57 http://deb.debian.org/debian trixie/main amd64 libsqlite3-dev amd64 3.45.3-1 [1088 kB] Get: 58 http://deb.debian.org/debian trixie/main amd64 golang-github-mattn-go-sqlite3-dev amd64 1.14.19~ds1-1 [83.4 kB] Get: 59 http://deb.debian.org/debian trixie/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 71.5 MB in 7s (10.8 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19699 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-2_amd64.deb ... Unpacking bsdextrautils (2.40.1-2) ... 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 libfile-stripnondeterminism-perl. Preparing to unpack .../19-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../20-dh-strip-nondeterminism_1.14.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.14.0-1) ... Selecting previously unselected package libelf1t64:amd64. Preparing to unpack .../21-libelf1t64_0.191-1+b1_amd64.deb ... Unpacking libelf1t64:amd64 (0.191-1+b1) ... Selecting previously unselected package dwz. Preparing to unpack .../22-dwz_0.15-1+b1_amd64.deb ... Unpacking dwz (0.15-1+b1) ... Selecting previously unselected package libicu72:amd64. Preparing to unpack .../23-libicu72_72.1-4+b1_amd64.deb ... Unpacking libicu72:amd64 (72.1-4+b1) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../24-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 .../25-gettext_0.21-14+b1_amd64.deb ... Unpacking gettext (0.21-14+b1) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../26-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 .../27-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../28-debhelper_13.15.3_all.deb ... Unpacking debhelper (13.15.3) ... Selecting previously unselected package dh-golang. Preparing to unpack .../29-dh-golang_1.62_all.deb ... Unpacking dh-golang (1.62) ... Selecting previously unselected package golang-1.22-src. Preparing to unpack .../30-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 .../31-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 .../32-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 .../33-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 .../34-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 .../35-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 .../36-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 .../37-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 .../38-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 .../39-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 .../40-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 .../41-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 .../42-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 .../43-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 .../44-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 .../45-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 .../46-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 .../47-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 .../48-golang-golang-x-sys-dev_0.20.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.20.0-1) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../49-golang-golang-x-term-dev_0.20.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.20.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../50-golang-golang-x-text-dev_0.15.0-1_all.deb ... Unpacking golang-golang-x-text-dev (0.15.0-1) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../51-golang-golang-x-crypto-dev_1%3a0.23.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.23.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../52-golang-golang-x-net-dev_1%3a0.25.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.25.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../53-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 .../54-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 .../55-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 .../56-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 .../57-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 .../58-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-2) ... 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.20.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.20.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.15.0-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Setting up libuchardet0:amd64 (0.0.8-1+b1) ... Setting up golang-golang-x-crypto-dev (1:0.23.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.14.0-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.25.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.14.0-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/1609280/tmp/hooks/A99_set_merged_usr starting Not re-configuring usrmerge for trixie I: user script /srv/workspace/pbuilder/1609280/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 20 gopkg.in/gorp.v1 internal/unsafeheader internal/coverage/rtcov internal/godebugs internal/goarch unicode/utf8 cmp internal/goexperiment internal/race internal/itoa math/bits log/internal internal/cpu internal/goos unicode sync/atomic runtime/internal/syscall runtime/internal/atomic internal/chacha8rand runtime/internal/math runtime/internal/sys internal/abi slices internal/bytealg math runtime internal/reflectlite sync internal/testlog sort errors internal/oserror io internal/safefilepath path strconv syscall bytes strings reflect regexp/syntax time internal/syscall/execenv internal/syscall/unix 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 20 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2024/05/30 03:18:36 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: 03:18:36.801616 drop table if exists "invoice_test"; [] gorptest: 03:18:36.802387 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:36.802426 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:36.802455 drop table if exists "invoice_override_test"; [] gorptest: 03:18:36.802483 drop table if exists "person_test"; [] gorptest: 03:18:36.802506 drop table if exists "ignored_column_test"; [] gorptest: 03:18:36.802537 drop table if exists "id_created_test"; [] gorptest: 03:18:36.802560 drop table if exists "type_conv_test"; [] gorptest: 03:18:36.802595 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:36.802621 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:36.802648 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:36.802672 drop table if exists "time_test"; [] gorptest: 03:18:36.802716 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:36.870846 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: 03:18:36.884620 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:36.901705 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:36.916118 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:36.930766 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:36.946785 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:36.961555 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:36.976367 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:36.989873 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:37.008519 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:37.025554 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:37.040167 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: 03:18:37.040368 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: 03:18:37.040400 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:37.040413 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: 03:18:37.040482 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: 03:18:37.040508 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.040550 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.040580 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:37.040614 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:37.040651 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:37.040679 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: 03:18:37.040709 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:37.040752 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 03:18:37.040782 drop table if exists "invoice_test"; [] gorptest: 03:18:37.050135 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:37.060647 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:37.070778 drop table if exists "invoice_override_test"; [] gorptest: 03:18:37.079441 drop table if exists "person_test"; [] gorptest: 03:18:37.089015 drop table if exists "ignored_column_test"; [] gorptest: 03:18:37.099728 drop table if exists "id_created_test"; [] gorptest: 03:18:37.110295 drop table if exists "type_conv_test"; [] gorptest: 03:18:37.122387 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:37.133398 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:37.145650 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:37.155560 drop table if exists "time_test"; [] gorptest: 03:18:37.164071 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.36s) === RUN TestTruncateTables 2024/05/30 03:18:37 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: 03:18:37.164564 drop table if exists "invoice_test"; [] gorptest: 03:18:37.164893 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:37.164984 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:37.165013 drop table if exists "invoice_override_test"; [] gorptest: 03:18:37.165039 drop table if exists "person_test"; [] gorptest: 03:18:37.165069 drop table if exists "ignored_column_test"; [] gorptest: 03:18:37.165093 drop table if exists "id_created_test"; [] gorptest: 03:18:37.165124 drop table if exists "type_conv_test"; [] gorptest: 03:18:37.165155 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:37.165180 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:37.165209 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:37.165236 drop table if exists "time_test"; [] gorptest: 03:18:37.165274 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:37.176576 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: 03:18:37.187096 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:37.201890 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:37.210979 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:37.219984 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.229999 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.239752 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:37.255830 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:37.266578 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:37.278900 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:37.291904 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:37.304324 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: 03:18:37.304462 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: 03:18:37.304490 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:37.304538 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: 03:18:37.304578 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: 03:18:37.304605 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.304650 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.304696 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:37.304737 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:37.304757 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:37.304808 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: 03:18:37.304840 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:37.304867 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 03:18:37.304962 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039117304915913 2:1717039117304915913 3:"Bob" 4:"Smith" 5:1] gorptest: 03:18:37.317068 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 03:18:37.330817 delete from "invoice_test"; [] gorptest: 03:18:37.341165 delete from "invoice_tag_test"; [] gorptest: 03:18:37.354463 delete from "alias_trans_field_test"; [] gorptest: 03:18:37.367663 delete from "invoice_override_test"; [] gorptest: 03:18:37.393695 delete from "person_test"; [] gorptest: 03:18:37.404788 delete from "ignored_column_test"; [] gorptest: 03:18:37.414686 delete from "id_created_test"; [] gorptest: 03:18:37.423931 delete from "type_conv_test"; [] gorptest: 03:18:37.434702 delete from "embedded_struct_test"; [] gorptest: 03:18:37.444484 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:37.454065 delete from "embedded_autoincr_test"; [] gorptest: 03:18:37.462941 delete from "time_test"; [] gorptest: 03:18:37.472726 delete from "id_created_test"; [] gorptest: 03:18:37.482409 SELECT * FROM person_test [] gorptest: 03:18:37.482711 SELECT * FROM invoice_test [] gorptest: 03:18:37.482790 drop table if exists "invoice_test"; [] gorptest: 03:18:37.493955 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:37.503374 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:37.510849 drop table if exists "invoice_override_test"; [] gorptest: 03:18:37.517395 drop table if exists "person_test"; [] gorptest: 03:18:37.526809 drop table if exists "ignored_column_test"; [] gorptest: 03:18:37.535760 drop table if exists "id_created_test"; [] gorptest: 03:18:37.550491 drop table if exists "type_conv_test"; [] gorptest: 03:18:37.560909 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:37.571336 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:37.581659 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:37.591891 drop table if exists "time_test"; [] gorptest: 03:18:37.601487 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.44s) === RUN TestCustomDateType gorptest: 03:18:37.602015 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 03:18:37.611455 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-05-30 03:18:37 +0000 UTC] gorptest: 03:18:37.620157 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 03:18:37.620389 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.03s) === RUN TestUIntPrimaryKey gorptest: 03:18:37.633485 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 03:18:37.646315 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 03:18:37.658275 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 03:18:37.670196 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 03:18:37.679481 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 03:18:37.689832 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 03:18:37.699687 drop table if exists "PersonUInt64"; [] gorptest: 03:18:37.710835 drop table if exists "PersonUInt32"; [] gorptest: 03:18:37.723067 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.10s) === RUN TestSetUniqueTogether gorptest: 03:18:37.733563 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 03:18:37.743048 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 03:18:37.753359 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 03:18:37.753549 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 03:18:37.753609 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 03:18:37.764573 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.04s) === RUN TestPersistentUser gorptest: 03:18:37.774900 drop table if exists PersistentUser [] gorptest: 03:18:37.775293 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 03:18:37.784907 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 03:18:37.795891 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 03:18:37.796111 select * from PersistentUser [] gorptest: 03:18:37.796227 select * from PersistentUser [] gorptest: 03:18:37.796308 select * from PersistentUser [] gorptest: 03:18:37.796380 select Id from PersistentUser [] gorptest: 03:18:37.796429 select mykey from PersistentUser [] gorptest: 03:18:37.796532 select PassedTraining from PersistentUser [] gorptest: 03:18:37.796532 select Id from PersistentUser [] gorptest: 03:18:37.796615 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.03s) === RUN TestNamedQueryMap gorptest: 03:18:37.806302 drop table if exists PersistentUser [] gorptest: 03:18:37.806698 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 03:18:37.816267 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 03:18:37.825777 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 03:18:37.837034 select * from PersistentUser where mykey = ? [1:43] gorptest: 03:18:37.837372 select * from PersistentUser where mykey = ? [1:43] gorptest: 03:18:37.837487 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 03:18:37.837673 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 03:18:37.837833 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.04s) === RUN TestNamedQueryStruct gorptest: 03:18:37.849534 drop table if exists PersistentUser [] gorptest: 03:18:37.850107 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 03:18:37.861739 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 03:18:37.871136 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 03:18:37.883022 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 03:18:37.883278 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.04s) === RUN TestReturnsNonNilSlice 2024/05/30 03:18:37 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: 03:18:37.894257 drop table if exists "invoice_test"; [] gorptest: 03:18:37.894640 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:37.894667 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:37.894692 drop table if exists "invoice_override_test"; [] gorptest: 03:18:37.894722 drop table if exists "person_test"; [] gorptest: 03:18:37.894749 drop table if exists "ignored_column_test"; [] gorptest: 03:18:37.894782 drop table if exists "id_created_test"; [] gorptest: 03:18:37.894815 drop table if exists "type_conv_test"; [] gorptest: 03:18:37.894839 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:37.894868 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:37.894898 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:37.894916 drop table if exists "time_test"; [] gorptest: 03:18:37.894959 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:37.911052 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: 03:18:37.923104 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:37.932875 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:37.943492 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:37.957090 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.967100 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:37.980179 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:37.990567 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:38.002177 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:38.012155 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:38.022399 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:38.032999 select * from invoice_test where id=99999 [] gorptest: 03:18:38.033240 select * from invoice_test where id=99999 [] gorptest: 03:18:38.033350 drop table if exists "invoice_test"; [] gorptest: 03:18:38.047046 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.056904 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.068624 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.079737 drop table if exists "person_test"; [] gorptest: 03:18:38.092892 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.104929 drop table if exists "id_created_test"; [] gorptest: 03:18:38.117593 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.128654 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.139481 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.148792 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.160053 drop table if exists "time_test"; [] gorptest: 03:18:38.185842 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.29s) === RUN TestOverrideVersionCol gorptest: 03:18:38.186165 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 03:18:38.196055 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: 03:18:38.196312 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.02s) === RUN TestOptimisticLocking 2024/05/30 03:18:38 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: 03:18:38.208375 drop table if exists "invoice_test"; [] gorptest: 03:18:38.208752 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.208804 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.208835 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.208859 drop table if exists "person_test"; [] gorptest: 03:18:38.208887 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.208921 drop table if exists "id_created_test"; [] gorptest: 03:18:38.208944 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.208978 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.209009 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.209027 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.209042 drop table if exists "time_test"; [] gorptest: 03:18:38.209104 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.218836 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: 03:18:38.228090 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:38.238847 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.249589 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:38.258824 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:38.270607 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:38.279353 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:38.290200 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:38.300460 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:38.310048 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:38.320579 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:38.330745 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039118330741613 2:1717039118330741613 3:"Bob" 4:"Smith" 5:1] gorptest: 03:18:38.341562 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:38.341911 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717039118330741613 2:1717039118330741613 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 03:18:38.351861 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717039118330741613 2:1717039118330741613 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 03:18:38.352072 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:38.352170 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 03:18:38.352224 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:38.352281 drop table if exists "invoice_test"; [] gorptest: 03:18:38.362469 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.372674 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.383096 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.394761 drop table if exists "person_test"; [] gorptest: 03:18:38.406183 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.419991 drop table if exists "id_created_test"; [] gorptest: 03:18:38.430834 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.441696 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.451537 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.460869 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.474948 drop table if exists "time_test"; [] gorptest: 03:18:38.485571 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.28s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 03:18:38.486064 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 03:18:38.496383 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 03:18:38.506663 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 03:18:38.506916 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: 03:18:38.516559 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 03:18:38.517246 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.04s) === RUN TestColumnProps gorptest: 03:18:38.527310 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 03:18:38.536388 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 03:18:38.545786 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 03:18:38.546034 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 03:18:38.546124 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 03:18:38.546167 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.03s) === RUN TestRawSelect 2024/05/30 03:18:38 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: 03:18:38.555592 drop table if exists "invoice_test"; [] gorptest: 03:18:38.555929 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.555977 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.556005 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.556032 drop table if exists "person_test"; [] gorptest: 03:18:38.556068 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.556121 drop table if exists "id_created_test"; [] gorptest: 03:18:38.556168 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.556203 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.556225 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.556258 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.556287 drop table if exists "time_test"; [] gorptest: 03:18:38.556320 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.569975 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: 03:18:38.580603 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:38.590088 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.599600 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:38.616122 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:38.648240 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:38.658220 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:38.677402 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:38.690493 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:38.704519 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:38.718463 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:38.737074 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039118736993849 2:1717039118736993849 3:"bob" 4:"smith" 5:1] gorptest: 03:18:38.747697 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 03:18:38.761915 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 03:18:38.762205 drop table if exists "invoice_test"; [] gorptest: 03:18:38.774990 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.788645 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.810339 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.820289 drop table if exists "person_test"; [] gorptest: 03:18:38.832180 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.859195 drop table if exists "id_created_test"; [] gorptest: 03:18:38.872257 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.884623 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.898453 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.911770 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.924279 drop table if exists "time_test"; [] gorptest: 03:18:38.935372 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.38s) === RUN TestHooks 2024/05/30 03:18:38 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: 03:18:38.935850 drop table if exists "invoice_test"; [] gorptest: 03:18:38.936160 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:38.936201 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:38.936228 drop table if exists "invoice_override_test"; [] gorptest: 03:18:38.936256 drop table if exists "person_test"; [] gorptest: 03:18:38.936286 drop table if exists "ignored_column_test"; [] gorptest: 03:18:38.936311 drop table if exists "id_created_test"; [] gorptest: 03:18:38.936340 drop table if exists "type_conv_test"; [] gorptest: 03:18:38.936382 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:38.936425 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:38.936456 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:38.936482 drop table if exists "time_test"; [] gorptest: 03:18:38.936522 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.948040 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: 03:18:38.963020 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:38.979475 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:38.990741 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:39.005622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.019493 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.030743 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:39.041379 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:39.052059 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:39.060687 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:39.070400 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:39.084496 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039119084457978 2:1717039119084457978 3:"bob" 4:"smith" 5:1] gorptest: 03:18:39.093988 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:39.094216 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1717039119084457978 2:1717039119084457978 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 03:18:39.105783 select * from person_test where id = ? [1:1] gorptest: 03:18:39.106878 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 03:18:39.116449 drop table if exists "invoice_test"; [] gorptest: 03:18:39.130789 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.142267 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.151054 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.164066 drop table if exists "person_test"; [] gorptest: 03:18:39.174056 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.183280 drop table if exists "id_created_test"; [] gorptest: 03:18:39.193288 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.207886 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.219007 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.233035 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.243373 drop table if exists "time_test"; [] gorptest: 03:18:39.257619 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.32s) === RUN TestTransaction 2024/05/30 03:18:39 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: 03:18:39.258105 drop table if exists "invoice_test"; [] gorptest: 03:18:39.258556 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.258594 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.258623 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.258656 drop table if exists "person_test"; [] gorptest: 03:18:39.258684 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.258712 drop table if exists "id_created_test"; [] gorptest: 03:18:39.258749 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.258777 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.258804 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.258833 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.258860 drop table if exists "time_test"; [] gorptest: 03:18:39.258947 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.274153 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: 03:18:39.284936 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:39.298986 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.319765 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:39.330477 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.339538 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.352406 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:39.361954 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:39.372574 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:39.384522 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:39.398125 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:39.415077 begin; [] gorptest: 03:18:39.415223 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 03:18:39.415506 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 03:18:39.415563 commit; [] gorptest: 03:18:39.433196 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:39.434033 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 03:18:39.434123 drop table if exists "invoice_test"; [] gorptest: 03:18:39.450111 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.463202 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.478145 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.488746 drop table if exists "person_test"; [] gorptest: 03:18:39.498898 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.511422 drop table if exists "id_created_test"; [] gorptest: 03:18:39.521387 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.535378 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.551104 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.559209 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.569853 drop table if exists "time_test"; [] gorptest: 03:18:39.582317 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.32s) === RUN TestSavepoint 2024/05/30 03:18:39 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: 03:18:39.582780 drop table if exists "invoice_test"; [] gorptest: 03:18:39.583167 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.583217 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.583261 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.583302 drop table if exists "person_test"; [] gorptest: 03:18:39.583340 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.583378 drop table if exists "id_created_test"; [] gorptest: 03:18:39.583421 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.583456 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.583487 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.583518 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.583560 drop table if exists "time_test"; [] gorptest: 03:18:39.583614 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.596498 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: 03:18:39.613640 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:39.629412 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.641101 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:39.650780 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.662747 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.674878 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:39.686012 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:39.698499 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:39.708239 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:39.717508 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:39.732867 begin; [] gorptest: 03:18:39.732992 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 03:18:39.734507 select memo from invoice_test [] gorptest: 03:18:39.734614 savepoint "foo" [1:] gorptest: 03:18:39.734629 select memo from invoice_test [] gorptest: 03:18:39.734688 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 03:18:39.734737 select memo from invoice_test [] gorptest: 03:18:39.734768 rollback to savepoint "foo" [1:] gorptest: 03:18:39.734785 select memo from invoice_test [] gorptest: 03:18:39.734809 rollback; [] gorptest: 03:18:39.734897 drop table if exists "invoice_test"; [] gorptest: 03:18:39.743947 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.754146 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.766530 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.778631 drop table if exists "person_test"; [] gorptest: 03:18:39.787601 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.800145 drop table if exists "id_created_test"; [] gorptest: 03:18:39.813485 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.824016 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.837888 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.851178 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.860717 drop table if exists "time_test"; [] gorptest: 03:18:39.872606 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.29s) === RUN TestMultiple 2024/05/30 03:18:39 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: 03:18:39.872985 drop table if exists "invoice_test"; [] gorptest: 03:18:39.873367 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:39.873404 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:39.873433 drop table if exists "invoice_override_test"; [] gorptest: 03:18:39.873461 drop table if exists "person_test"; [] gorptest: 03:18:39.873489 drop table if exists "ignored_column_test"; [] gorptest: 03:18:39.873516 drop table if exists "id_created_test"; [] gorptest: 03:18:39.873544 drop table if exists "type_conv_test"; [] gorptest: 03:18:39.873573 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:39.873601 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:39.873628 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:39.873656 drop table if exists "time_test"; [] gorptest: 03:18:39.873693 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.883045 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: 03:18:39.892400 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:39.901857 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:39.914660 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:39.924745 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.935941 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:39.949230 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:39.959013 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:39.969111 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:39.982150 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:39.991431 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:40.001860 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 03:18:40.013186 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 03:18:40.024836 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 03:18:40.036317 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 03:18:40.047561 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:40.064527 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 03:18:40.075088 drop table if exists "invoice_test"; [] gorptest: 03:18:40.085947 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.098127 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.108459 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.120255 drop table if exists "person_test"; [] gorptest: 03:18:40.129056 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.138518 drop table if exists "id_created_test"; [] gorptest: 03:18:40.148210 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.157523 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.166521 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.176684 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.186936 drop table if exists "time_test"; [] gorptest: 03:18:40.196552 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.32s) === RUN TestCrud 2024/05/30 03:18:40 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: 03:18:40.196979 drop table if exists "invoice_test"; [] gorptest: 03:18:40.197299 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.197329 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.197357 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.197386 drop table if exists "person_test"; [] gorptest: 03:18:40.197414 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.197441 drop table if exists "id_created_test"; [] gorptest: 03:18:40.197467 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.197506 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.197534 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.197561 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.197588 drop table if exists "time_test"; [] gorptest: 03:18:40.197624 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:40.209706 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: 03:18:40.219105 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:40.228168 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:40.239613 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:40.248824 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:40.259262 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:40.268374 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:40.280537 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:40.297582 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:40.318120 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:40.331980 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:40.341671 delete from invoice_test [] gorptest: 03:18:40.351372 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 03:18:40.359966 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:40.360226 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:172841050843841131 2:2051436845602972180 3:"random 8397671482982524" 4:0 5:true 6:1] gorptest: 03:18:40.370496 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:40.370687 select * from invoice_test [] gorptest: 03:18:40.370800 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:40.386347 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 03:18:40.386540 delete from invoice_tag_test [] gorptest: 03:18:40.402316 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: 03:18:40.414026 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 03:18:40.414289 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:4792985098101968964 2:6820745024043872095 3:"random 7012438719321672441" 4:33 5:false 6:1] gorptest: 03:18:40.432243 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 03:18:40.432470 select * from invoice_tag_test [] gorptest: 03:18:40.432598 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 03:18:40.445636 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 03:18:40.445863 delete from alias_trans_field_test [] gorptest: 03:18:40.456108 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 03:18:40.476236 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 03:18:40.476499 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 7136847736887653425" 2:1] gorptest: 03:18:40.486982 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 03:18:40.487183 select * from alias_trans_field_test [] gorptest: 03:18:40.487265 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 03:18:40.498272 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 03:18:40.498448 drop table if exists "invoice_test"; [] gorptest: 03:18:40.511384 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.520999 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.531761 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.547873 drop table if exists "person_test"; [] gorptest: 03:18:40.560411 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.574107 drop table if exists "id_created_test"; [] gorptest: 03:18:40.587035 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.600155 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.613925 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.622941 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.637198 drop table if exists "time_test"; [] gorptest: 03:18:40.650348 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.45s) === RUN TestWithIgnoredColumn 2024/05/30 03:18:40 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: 03:18:40.650805 drop table if exists "invoice_test"; [] gorptest: 03:18:40.651162 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.651223 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.651265 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.651298 drop table if exists "person_test"; [] gorptest: 03:18:40.651330 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.651363 drop table if exists "id_created_test"; [] gorptest: 03:18:40.651395 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.651428 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.651460 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.651493 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.651530 drop table if exists "time_test"; [] gorptest: 03:18:40.651575 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:40.664481 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: 03:18:40.676380 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:40.688712 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:40.699527 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:40.709856 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:40.721880 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:40.731292 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:40.740646 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:40.749958 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:40.761959 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:40.770996 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:40.780004 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 03:18:40.788640 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 03:18:40.788879 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 03:18:40.799292 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 03:18:40.799477 drop table if exists "invoice_test"; [] gorptest: 03:18:40.810159 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.821323 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.835577 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.846618 drop table if exists "person_test"; [] gorptest: 03:18:40.855987 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.868394 drop table if exists "id_created_test"; [] gorptest: 03:18:40.882244 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.895617 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.909582 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.922987 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.934363 drop table if exists "time_test"; [] gorptest: 03:18:40.944111 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.29s) === RUN TestTypeConversionExample 2024/05/30 03:18:40 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: 03:18:40.944557 drop table if exists "invoice_test"; [] gorptest: 03:18:40.944955 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:40.944990 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:40.945022 drop table if exists "invoice_override_test"; [] gorptest: 03:18:40.945055 drop table if exists "person_test"; [] gorptest: 03:18:40.945088 drop table if exists "ignored_column_test"; [] gorptest: 03:18:40.945372 drop table if exists "id_created_test"; [] gorptest: 03:18:40.945449 drop table if exists "type_conv_test"; [] gorptest: 03:18:40.945607 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:40.945651 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:40.945684 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:40.945716 drop table if exists "time_test"; [] gorptest: 03:18:40.945762 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:40.960029 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: 03:18:40.975807 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:40.998528 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:41.018902 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:41.029472 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:41.051254 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:41.061206 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:41.071255 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:41.086749 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:41.101568 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:41.117557 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:41.129061 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: 03:18:41.138696 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 03:18:41.138983 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: 03:18:41.149944 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 03:18:41.150146 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 03:18:41.164959 drop table if exists "invoice_test"; [] gorptest: 03:18:41.178503 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:41.192524 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:41.204483 drop table if exists "invoice_override_test"; [] gorptest: 03:18:41.215285 drop table if exists "person_test"; [] gorptest: 03:18:41.239250 drop table if exists "ignored_column_test"; [] gorptest: 03:18:41.258061 drop table if exists "id_created_test"; [] gorptest: 03:18:41.271982 drop table if exists "type_conv_test"; [] gorptest: 03:18:41.288500 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:41.305613 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:41.318344 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:41.329302 drop table if exists "time_test"; [] gorptest: 03:18:41.339645 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.40s) === RUN TestWithEmbeddedStruct 2024/05/30 03:18:41 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: 03:18:41.340125 drop table if exists "invoice_test"; [] gorptest: 03:18:41.340883 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:41.340919 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:41.340946 drop table if exists "invoice_override_test"; [] gorptest: 03:18:41.340974 drop table if exists "person_test"; [] gorptest: 03:18:41.341000 drop table if exists "ignored_column_test"; [] gorptest: 03:18:41.341027 drop table if exists "id_created_test"; [] gorptest: 03:18:41.341053 drop table if exists "type_conv_test"; [] gorptest: 03:18:41.341080 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:41.341107 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:41.341133 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:41.341159 drop table if exists "time_test"; [] gorptest: 03:18:41.341196 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:41.380419 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: 03:18:41.394429 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:41.404497 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:41.414170 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:41.425263 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:41.435349 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:41.450876 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:41.461763 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:41.477234 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:41.490130 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:41.502064 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:41.512584 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 03:18:41.521722 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 03:18:41.521951 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 03:18:41.538354 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 03:18:41.540016 select * from embedded_struct_test [] gorptest: 03:18:41.540153 drop table if exists "invoice_test"; [] gorptest: 03:18:41.549767 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:41.561887 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:41.571918 drop table if exists "invoice_override_test"; [] gorptest: 03:18:41.580805 drop table if exists "person_test"; [] gorptest: 03:18:41.590820 drop table if exists "ignored_column_test"; [] gorptest: 03:18:41.600841 drop table if exists "id_created_test"; [] gorptest: 03:18:41.610554 drop table if exists "type_conv_test"; [] gorptest: 03:18:41.623945 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:41.637228 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:41.646597 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:41.655583 drop table if exists "time_test"; [] gorptest: 03:18:41.670691 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.33s) === RUN TestWithEmbeddedStructBeforeAutoincr 2024/05/30 03:18:41 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: 03:18:41.671417 drop table if exists "invoice_test"; [] gorptest: 03:18:41.671849 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:41.671888 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:41.671919 drop table if exists "invoice_override_test"; [] gorptest: 03:18:41.671953 drop table if exists "person_test"; [] gorptest: 03:18:41.671982 drop table if exists "ignored_column_test"; [] gorptest: 03:18:41.672017 drop table if exists "id_created_test"; [] gorptest: 03:18:41.672045 drop table if exists "type_conv_test"; [] gorptest: 03:18:41.672074 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:41.672108 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:41.672136 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:41.672179 drop table if exists "time_test"; [] gorptest: 03:18:41.672304 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:41.688839 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: 03:18:41.701289 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:41.711456 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:41.722242 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:41.734898 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:41.793836 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:42.124220 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:42.215501 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:42.264677 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:42.352684 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:42.621563 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:43.168268 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 03:18:43.997566 drop table if exists "invoice_test"; [] gorptest: 03:18:44.017412 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:44.030034 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:44.042223 drop table if exists "invoice_override_test"; [] gorptest: 03:18:44.055601 drop table if exists "person_test"; [] gorptest: 03:18:44.068779 drop table if exists "ignored_column_test"; [] gorptest: 03:18:44.082941 drop table if exists "id_created_test"; [] gorptest: 03:18:44.097726 drop table if exists "type_conv_test"; [] gorptest: 03:18:44.109235 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:44.119081 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:44.131965 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:44.145259 drop table if exists "time_test"; [] gorptest: 03:18:44.155968 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (2.48s) === RUN TestWithEmbeddedAutoincr 2024/05/30 03:18:44 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: 03:18:44.156422 drop table if exists "invoice_test"; [] gorptest: 03:18:44.156737 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:44.156776 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:44.156805 drop table if exists "invoice_override_test"; [] gorptest: 03:18:44.156840 drop table if exists "person_test"; [] gorptest: 03:18:44.156873 drop table if exists "ignored_column_test"; [] gorptest: 03:18:44.156902 drop table if exists "id_created_test"; [] gorptest: 03:18:44.156935 drop table if exists "type_conv_test"; [] gorptest: 03:18:44.156968 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:44.157002 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:44.157034 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:44.157062 drop table if exists "time_test"; [] gorptest: 03:18:44.157105 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:44.167174 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: 03:18:44.181470 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:44.196441 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:44.207243 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:44.219213 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:44.234273 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:44.245971 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:44.256183 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:44.270163 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:44.279974 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:44.292765 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:44.306182 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 03:18:44.316202 drop table if exists "invoice_test"; [] gorptest: 03:18:44.330697 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:44.344309 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:44.354157 drop table if exists "invoice_override_test"; [] gorptest: 03:18:44.368625 drop table if exists "person_test"; [] gorptest: 03:18:44.379719 drop table if exists "ignored_column_test"; [] gorptest: 03:18:44.394159 drop table if exists "id_created_test"; [] gorptest: 03:18:44.408205 drop table if exists "type_conv_test"; [] gorptest: 03:18:44.421762 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:44.447197 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:44.463174 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:44.481213 drop table if exists "time_test"; [] gorptest: 03:18:44.496744 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.34s) === RUN TestSelectVal gorptest: 03:18:44.497209 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 03:18:44.510814 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: 03:18:44.527657 select Int64 from TableWithNull where Str='abc' [] gorptest: 03:18:44.527925 select count(*) from TableWithNull [] gorptest: 03:18:44.528000 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 03:18:44.528063 select Int64 from TableWithNull where Str='notfound' [] gorptest: 03:18:44.528115 select Int64 from TableWithNull where Str='abc' [] gorptest: 03:18:44.528165 select Float64 from TableWithNull where Str='abc' [] gorptest: 03:18:44.528215 select min(Float64) from TableWithNull [] gorptest: 03:18:44.528290 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 03:18:44.528351 select Float64 from TableWithNull where Str='notfound' [] gorptest: 03:18:44.528399 select Float64 from TableWithNull where Str='abc' [] gorptest: 03:18:44.528449 select Str from TableWithNull where Int64=? [1:78] gorptest: 03:18:44.528505 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 03:18:44.528549 select Str from TableWithNull where Int64=? [1:78] gorptest: 03:18:44.528607 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 03:18:44.528726 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 03:18:44.528791 select Str from TableWithNull where Int64=? [1:78] gorptest: 03:18:44.528846 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.04s) === RUN TestVersionMultipleRows 2024/05/30 03:18:44 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: 03:18:44.540664 drop table if exists "invoice_test"; [] gorptest: 03:18:44.541039 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:44.541078 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:44.541107 drop table if exists "invoice_override_test"; [] gorptest: 03:18:44.541141 drop table if exists "person_test"; [] gorptest: 03:18:44.541169 drop table if exists "ignored_column_test"; [] gorptest: 03:18:44.541204 drop table if exists "id_created_test"; [] gorptest: 03:18:44.541231 drop table if exists "type_conv_test"; [] gorptest: 03:18:44.541261 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:44.541296 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:44.541329 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:44.541357 drop table if exists "time_test"; [] gorptest: 03:18:44.541411 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:44.549841 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: 03:18:44.562512 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:44.575270 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:44.587061 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:44.599678 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:44.610178 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:44.619421 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:45.179007 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:45.435765 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:45.452743 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:45.463728 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:45.477842 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039125477774158 2:1717039125477774158 3:"Bob" 4:"Smith" 5:1] gorptest: 03:18:45.496344 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039125496308711 2:1717039125496308711 3:"Jane" 4:"Smith" 5:1] gorptest: 03:18:45.506447 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039125506404513 2:1717039125506404513 3:"Mike" 4:"Smith" 5:1] gorptest: 03:18:45.517075 drop table if exists "invoice_test"; [] gorptest: 03:18:45.527977 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:45.547089 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:45.558379 drop table if exists "invoice_override_test"; [] gorptest: 03:18:45.572579 drop table if exists "person_test"; [] gorptest: 03:18:45.586632 drop table if exists "ignored_column_test"; [] gorptest: 03:18:45.600580 drop table if exists "id_created_test"; [] gorptest: 03:18:45.611807 drop table if exists "type_conv_test"; [] gorptest: 03:18:45.622239 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:45.638191 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:45.650312 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:45.661608 drop table if exists "time_test"; [] gorptest: 03:18:45.675580 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (1.14s) === RUN TestWithStringPk gorptest: 03:18:45.675931 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 03:18:45.686630 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 03:18:45.702384 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.04s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2024/05/30 03:18: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: 03:18:45.721206 drop table if exists "invoice_test"; [] gorptest: 03:18:45.722907 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:45.722950 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:45.722980 drop table if exists "invoice_override_test"; [] gorptest: 03:18:45.723034 drop table if exists "person_test"; [] gorptest: 03:18:45.723071 drop table if exists "ignored_column_test"; [] gorptest: 03:18:45.723100 drop table if exists "id_created_test"; [] gorptest: 03:18:45.723137 drop table if exists "type_conv_test"; [] gorptest: 03:18:45.723166 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:45.723199 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:45.723228 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:45.723261 drop table if exists "time_test"; [] gorptest: 03:18:45.723299 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:45.739446 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: 03:18:45.752634 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:45.762523 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:45.774691 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:45.789708 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:45.801399 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:45.811935 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:45.825223 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:45.839473 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:45.850201 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:45.868696 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:45.883183 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-30 02:47:45.883142096 +0000 UTC] gorptest: 03:18:45.902081 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-30 02:48:46.883142096 +0000 UTC] gorptest: 03:18:45.928833 SELECT id FROM time_test WHERE Time < ? [1:2024-05-30 02:48:45.883142096 +0000 UTC] gorptest: 03:18:45.929086 drop table if exists "invoice_test"; [] gorptest: 03:18:45.946122 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:45.956521 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:45.966992 drop table if exists "invoice_override_test"; [] gorptest: 03:18:45.979912 drop table if exists "person_test"; [] gorptest: 03:18:45.989769 drop table if exists "ignored_column_test"; [] gorptest: 03:18:46.004219 drop table if exists "id_created_test"; [] gorptest: 03:18:46.024932 drop table if exists "type_conv_test"; [] gorptest: 03:18:46.044783 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:46.062301 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:46.072769 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:46.088470 drop table if exists "time_test"; [] gorptest: 03:18:46.103203 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.38s) === RUN TestInvoicePersonView 2024/05/30 03:18: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: 03:18:46.103994 drop table if exists "invoice_test"; [] gorptest: 03:18:46.104336 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:46.104374 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:46.104404 drop table if exists "invoice_override_test"; [] gorptest: 03:18:46.104438 drop table if exists "person_test"; [] gorptest: 03:18:46.104470 drop table if exists "ignored_column_test"; [] gorptest: 03:18:46.104504 drop table if exists "id_created_test"; [] gorptest: 03:18:46.104539 drop table if exists "type_conv_test"; [] gorptest: 03:18:46.104572 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:46.104612 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:46.104648 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:46.104677 drop table if exists "time_test"; [] gorptest: 03:18:46.104720 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:46.119403 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: 03:18:46.132887 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:46.145367 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:46.156231 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:46.166063 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:46.184498 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:46.195895 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:46.208725 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:46.222783 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:46.239063 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:46.249555 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:46.264335 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039126264298285 2:1717039126264298285 3:"bob" 4:"smith" 5:1] gorptest: 03:18:46.279058 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 03:18:46.298162 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 03:18:46.298432 drop table if exists "invoice_test"; [] gorptest: 03:18:46.318416 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:46.529375 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:46.540248 drop table if exists "invoice_override_test"; [] gorptest: 03:18:46.550972 drop table if exists "person_test"; [] gorptest: 03:18:46.561484 drop table if exists "ignored_column_test"; [] gorptest: 03:18:46.577858 drop table if exists "id_created_test"; [] gorptest: 03:18:46.593510 drop table if exists "type_conv_test"; [] gorptest: 03:18:46.606382 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:46.628393 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:46.644783 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:46.659484 drop table if exists "time_test"; [] gorptest: 03:18:46.673644 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.57s) === RUN TestQuoteTableNames 2024/05/30 03:18: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: 03:18:46.674149 drop table if exists "invoice_test"; [] gorptest: 03:18:46.674528 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:46.674575 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:46.674613 drop table if exists "invoice_override_test"; [] gorptest: 03:18:46.674656 drop table if exists "person_test"; [] gorptest: 03:18:46.674705 drop table if exists "ignored_column_test"; [] gorptest: 03:18:46.674754 drop table if exists "id_created_test"; [] gorptest: 03:18:46.674799 drop table if exists "type_conv_test"; [] gorptest: 03:18:46.674847 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:46.674884 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:46.674926 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:46.674962 drop table if exists "time_test"; [] gorptest: 03:18:46.675018 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:46.690485 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: 03:18:46.703652 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:46.716055 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:46.728167 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:46.739142 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:46.751045 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:46.763173 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:46.775590 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:46.787500 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:46.798583 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:46.811449 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.32s) === RUN TestSelectTooManyCols 2024/05/30 03:18: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: 03:18:46.992792 drop table if exists "invoice_test"; [] gorptest: 03:18:46.993134 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:46.993173 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:46.993202 drop table if exists "invoice_override_test"; [] gorptest: 03:18:46.993236 drop table if exists "person_test"; [] gorptest: 03:18:46.993264 drop table if exists "ignored_column_test"; [] gorptest: 03:18:46.993297 drop table if exists "id_created_test"; [] gorptest: 03:18:46.993326 drop table if exists "type_conv_test"; [] gorptest: 03:18:46.993359 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:46.993388 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:46.993421 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:46.993449 drop table if exists "time_test"; [] gorptest: 03:18:46.993498 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.004654 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: 03:18:47.015396 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:47.027039 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.037636 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:47.050835 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.067759 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.081264 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:47.093558 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:47.103832 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:47.114759 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:47.123632 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:47.133480 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039127133440811 2:1717039127133440811 3:"bob" 4:"smith" 5:1] gorptest: 03:18:47.142630 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039127142559278 2:1717039127142559278 3:"jane" 4:"doe" 5:1] gorptest: 03:18:47.155566 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:47.155813 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 03:18:47.155897 select * from person_test where Id=? [1:1] gorptest: 03:18:47.155987 select * from person_test order by fname asc [] gorptest: 03:18:47.156104 drop table if exists "invoice_test"; [] gorptest: 03:18:47.164327 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:47.175014 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:47.184030 drop table if exists "invoice_override_test"; [] gorptest: 03:18:47.195043 drop table if exists "person_test"; [] gorptest: 03:18:47.209618 drop table if exists "ignored_column_test"; [] gorptest: 03:18:47.220099 drop table if exists "id_created_test"; [] gorptest: 03:18:47.231590 drop table if exists "type_conv_test"; [] gorptest: 03:18:47.242548 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:47.253301 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:47.264354 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:47.272927 drop table if exists "time_test"; [] gorptest: 03:18:47.282619 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.29s) === RUN TestSelectSingleVal 2024/05/30 03:18:47 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: 03:18:47.283131 drop table if exists "invoice_test"; [] gorptest: 03:18:47.283547 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:47.283598 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:47.283638 drop table if exists "invoice_override_test"; [] gorptest: 03:18:47.283667 drop table if exists "person_test"; [] gorptest: 03:18:47.283702 drop table if exists "ignored_column_test"; [] gorptest: 03:18:47.283772 drop table if exists "id_created_test"; [] gorptest: 03:18:47.283810 drop table if exists "type_conv_test"; [] gorptest: 03:18:47.283862 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:47.283896 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:47.283929 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:47.283956 drop table if exists "time_test"; [] gorptest: 03:18:47.283995 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.295917 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: 03:18:47.307449 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:47.318146 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.327789 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:47.341181 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.354658 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.364694 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:47.374055 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:47.392598 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:47.403703 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:47.414540 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:47.427122 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039127427083516 2:1717039127427083516 3:"bob" 4:"smith" 5:1] gorptest: 03:18:47.441070 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 03:18:47.441320 select * from person_test where Id=? [1:1] gorptest: 03:18:47.441443 select FName from person_test where Id=? [1:1] gorptest: 03:18:47.441503 select * from person_test where Id=? [1:1] gorptest: 03:18:47.441581 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 03:18:47.441663 select * from person_test where Id=? [1:-2222] gorptest: 03:18:47.441745 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1717039127441731284 2:1717039127441731284 3:"bob" 4:"smith" 5:1] gorptest: 03:18:47.452766 select * from person_test where Fname='bob' [] gorptest: 03:18:47.453044 select * from person_test where Id=-123 [] gorptest: 03:18:47.453103 select * from person_test where Id=-123 [] gorptest: 03:18:47.453147 select * from person_test where Id=-123 [] gorptest: 03:18:47.453194 select * from person_test where Id=-123 [] gorptest: 03:18:47.453248 drop table if exists "invoice_test"; [] gorptest: 03:18:47.464925 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:47.475233 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:47.487763 drop table if exists "invoice_override_test"; [] gorptest: 03:18:47.506212 drop table if exists "person_test"; [] gorptest: 03:18:47.515819 drop table if exists "ignored_column_test"; [] gorptest: 03:18:47.524400 drop table if exists "id_created_test"; [] gorptest: 03:18:47.534119 drop table if exists "type_conv_test"; [] gorptest: 03:18:47.543877 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:47.557578 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:47.574918 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:47.593102 drop table if exists "time_test"; [] gorptest: 03:18:47.607319 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.32s) === RUN TestSelectAlias 2024/05/30 03:18:47 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: 03:18:47.607789 drop table if exists "invoice_test"; [] gorptest: 03:18:47.608135 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:47.608174 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:47.608203 drop table if exists "invoice_override_test"; [] gorptest: 03:18:47.608236 drop table if exists "person_test"; [] gorptest: 03:18:47.608270 drop table if exists "ignored_column_test"; [] gorptest: 03:18:47.608312 drop table if exists "id_created_test"; [] gorptest: 03:18:47.608340 drop table if exists "type_conv_test"; [] gorptest: 03:18:47.608372 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:47.608406 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:47.608438 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:47.608466 drop table if exists "time_test"; [] gorptest: 03:18:47.608509 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.639145 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: 03:18:47.684912 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:47.740760 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:47.776314 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:47.788764 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.800855 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:47.816646 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:47.831031 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:47.842048 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:47.856967 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:47.870061 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:47.881232 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 03:18:47.892989 select * from id_created_test where Id=1 [] gorptest: 03:18:47.893281 SELECT *, 1 AS external FROM id_created_test [] gorptest: 03:18:47.893456 drop table if exists "invoice_test"; [] gorptest: 03:18:47.906061 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:47.920619 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:47.936255 drop table if exists "invoice_override_test"; [] gorptest: 03:18:47.947751 drop table if exists "person_test"; [] gorptest: 03:18:47.962909 drop table if exists "ignored_column_test"; [] gorptest: 03:18:47.979044 drop table if exists "id_created_test"; [] gorptest: 03:18:47.998388 drop table if exists "type_conv_test"; [] gorptest: 03:18:48.014015 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:48.027215 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:48.039418 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:48.055778 drop table if exists "time_test"; [] gorptest: 03:18:48.071411 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.46s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2024/05/30 03:18: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: 03:18:48.071960 drop table if exists "invoice_test"; [] gorptest: 03:18:48.072318 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:48.072362 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:48.072391 drop table if exists "invoice_override_test"; [] gorptest: 03:18:48.072430 drop table if exists "person_test"; [] gorptest: 03:18:48.072464 drop table if exists "ignored_column_test"; [] gorptest: 03:18:48.072497 drop table if exists "id_created_test"; [] gorptest: 03:18:48.072530 drop table if exists "type_conv_test"; [] gorptest: 03:18:48.072564 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:48.072596 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:48.072624 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:48.072657 drop table if exists "time_test"; [] gorptest: 03:18:48.072710 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:48.089383 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: 03:18:48.099403 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:48.110822 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:48.122206 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:48.133264 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:48.265524 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:48.379983 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:48.389739 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:48.402186 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:48.411865 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:48.428409 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:48.438766 drop table if exists "invoice_test"; [] gorptest: 03:18:48.448774 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:48.462418 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:48.472250 drop table if exists "invoice_override_test"; [] gorptest: 03:18:48.483433 drop table if exists "person_test"; [] gorptest: 03:18:48.494378 drop table if exists "ignored_column_test"; [] gorptest: 03:18:48.511548 drop table if exists "id_created_test"; [] gorptest: 03:18:48.521354 drop table if exists "type_conv_test"; [] gorptest: 03:18:48.534391 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:48.544291 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:48.554554 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:48.564311 drop table if exists "time_test"; [] gorptest: 03:18:48.574225 drop table if exists "id_created_test"; [] gorptest: 03:18:48.574351 drop table if exists "single_column_table"; [] gorptest: 03:18:48.574432 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: 03:18:48.585221 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: 03:18:48.595529 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:48.609391 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: 03:18:48.618354 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: 03:18:48.631362 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:48.643603 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:48.653168 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:48.663005 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:48.673589 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:48.683802 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: 03:18:48.695964 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:48.710327 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 03:18:48.710450 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 03:18:48.728853 delete from "invoice_test"; [] gorptest: 03:18:48.740220 delete from "invoice_tag_test"; [] gorptest: 03:18:48.752318 delete from "alias_trans_field_test"; [] gorptest: 03:18:48.766504 delete from "invoice_override_test"; [] gorptest: 03:18:48.777129 delete from "person_test"; [] gorptest: 03:18:48.792679 delete from "ignored_column_test"; [] gorptest: 03:18:48.802590 delete from "id_created_test"; [] gorptest: 03:18:48.813709 delete from "type_conv_test"; [] gorptest: 03:18:48.824495 delete from "embedded_struct_test"; [] gorptest: 03:18:48.833748 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:48.843561 delete from "embedded_autoincr_test"; [] gorptest: 03:18:48.853671 delete from "time_test"; [] gorptest: 03:18:48.864564 delete from "id_created_test"; [] gorptest: 03:18:48.874941 delete from "single_column_table"; [] gorptest: 03:18:48.884720 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 03:18:48.884918 drop table if exists "invoice_test"; [] gorptest: 03:18:48.896331 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:48.904988 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:48.914056 drop table if exists "invoice_override_test"; [] gorptest: 03:18:48.928002 drop table if exists "person_test"; [] gorptest: 03:18:48.936597 drop table if exists "ignored_column_test"; [] gorptest: 03:18:48.947812 drop table if exists "id_created_test"; [] gorptest: 03:18:48.956274 drop table if exists "type_conv_test"; [] gorptest: 03:18:48.968975 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:48.982804 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:48.998715 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:49.011498 drop table if exists "time_test"; [] gorptest: 03:18:49.022709 drop table if exists "id_created_test"; [] gorptest: 03:18:49.022823 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.97s) === RUN TestPrepare 2024/05/30 03:18: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: 03:18:49.041115 drop table if exists "invoice_test"; [] gorptest: 03:18:49.041493 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:49.041530 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:49.041559 drop table if exists "invoice_override_test"; [] gorptest: 03:18:49.041594 drop table if exists "person_test"; [] gorptest: 03:18:49.041628 drop table if exists "ignored_column_test"; [] gorptest: 03:18:49.041657 drop table if exists "id_created_test"; [] gorptest: 03:18:49.041702 drop table if exists "type_conv_test"; [] gorptest: 03:18:49.041738 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:49.041772 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:49.041863 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:49.041903 drop table if exists "time_test"; [] gorptest: 03:18:49.041947 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:49.052017 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: 03:18:49.066272 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 03:18:49.079214 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 03:18:49.092468 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 03:18:49.102859 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:49.116989 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 03:18:49.128029 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 03:18:49.138629 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 03:18:49.148899 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 03:18:49.162044 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 03:18:49.171662 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 03:18:49.185548 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 03:18:49.195851 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 03:18:49.205104 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 03:18:49.214163 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 03:18:49.214487 begin; [] gorptest: 03:18:49.214543 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 03:18:49.214726 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 03:18:49.215187 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 03:18:49.215277 commit; [] gorptest: 03:18:49.227162 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 03:18:49.227428 drop table if exists "invoice_test"; [] gorptest: 03:18:49.237674 drop table if exists "invoice_tag_test"; [] gorptest: 03:18:49.248363 drop table if exists "alias_trans_field_test"; [] gorptest: 03:18:49.258360 drop table if exists "invoice_override_test"; [] gorptest: 03:18:49.267710 drop table if exists "person_test"; [] gorptest: 03:18:49.277955 drop table if exists "ignored_column_test"; [] gorptest: 03:18:49.298736 drop table if exists "id_created_test"; [] gorptest: 03:18:49.308971 drop table if exists "type_conv_test"; [] gorptest: 03:18:49.322182 drop table if exists "embedded_struct_test"; [] gorptest: 03:18:49.332455 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 03:18:49.341901 drop table if exists "embedded_autoincr_test"; [] gorptest: 03:18:49.351572 drop table if exists "time_test"; [] gorptest: 03:18:49.361560 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.32s) PASS ok gopkg.in/gorp.v1 12.570s 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/1609280/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/1609280/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/1609280 and its subdirectories I: Current time: Thu May 30 17:18:57 +14 2024 I: pbuilder-time-stamp: 1717039137