I: pbuilder: network access will be disabled during build I: Current time: Mon Jun 24 15:57:12 +14 2024 I: pbuilder-time-stamp: 1719194232 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: using eatmydata during job I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: 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/50239/tmp/hooks/D01_modify_environment starting debug: Running on ionos2-i386. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 Jun 24 01:57 /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/50239/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/50239/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]="i686-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=i386 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=10 ' DIRSTACK=() DISTRIBUTION=trixie EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=i686 HOST_ARCH=i386 IFS=' ' INVOCATION_ID=4a2cbdada98041aba7176f68a4aa3890 LANG=C LANGUAGE=de_CH:de LC_ALL=C LD_LIBRARY_PATH=/usr/lib/libeatmydata LD_PRELOAD=libeatmydata.so MACHTYPE=i686-pc-linux-gnu MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnu PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path PBCURRENTCOMMANDLINEOPERATION=build PBUILDER_OPERATION=build PBUILDER_PKGDATADIR=/usr/share/pbuilder PBUILDER_PKGLIBDIR=/usr/lib/pbuilder PBUILDER_SYSCONFDIR=/etc PIPESTATUS=([0]="0") POSIXLY_CORRECT=y PPID=50239 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.z2j14mqK/pbuilderrc_6Ef1 --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.z2j14mqK/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=112 SUDO_UID=107 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://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 Jun 5 22:35 /bin -> usr/bin I: user script /srv/workspace/pbuilder/50239/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: i386 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19679 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 70.0 MB of archives. After unpacking 367 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian trixie/main i386 sensible-utils all 0.0.23 [24.7 kB] Get: 2 http://deb.debian.org/debian trixie/main i386 libmagic-mgc i386 1:5.45-3 [314 kB] Get: 3 http://deb.debian.org/debian trixie/main i386 libmagic1t64 i386 1:5.45-3 [114 kB] Get: 4 http://deb.debian.org/debian trixie/main i386 file i386 1:5.45-3 [42.9 kB] Get: 5 http://deb.debian.org/debian trixie/main i386 gettext-base i386 0.21-14+b1 [162 kB] Get: 6 http://deb.debian.org/debian trixie/main i386 libuchardet0 i386 0.0.8-1+b1 [69.1 kB] Get: 7 http://deb.debian.org/debian trixie/main i386 groff-base i386 1.23.0-4 [1194 kB] Get: 8 http://deb.debian.org/debian trixie/main i386 bsdextrautils i386 2.40.1-8.1 [100 kB] Get: 9 http://deb.debian.org/debian trixie/main i386 libpipeline1 i386 1.5.7-2 [39.7 kB] Get: 10 http://deb.debian.org/debian trixie/main i386 man-db i386 2.12.1-2 [1421 kB] Get: 11 http://deb.debian.org/debian trixie/main i386 m4 i386 1.4.19-4 [293 kB] Get: 12 http://deb.debian.org/debian trixie/main i386 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian trixie/main i386 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian trixie/main i386 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian trixie/main i386 autopoint all 0.21-14 [496 kB] Get: 16 http://deb.debian.org/debian trixie/main i386 libdebhelper-perl all 13.16 [88.6 kB] Get: 17 http://deb.debian.org/debian trixie/main i386 libtool all 2.4.7-7 [517 kB] Get: 18 http://deb.debian.org/debian trixie/main i386 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian trixie/main i386 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian trixie/main i386 libfile-stripnondeterminism-perl all 1.14.0-1 [19.5 kB] Get: 21 http://deb.debian.org/debian trixie/main i386 dh-strip-nondeterminism all 1.14.0-1 [8448 B] Get: 22 http://deb.debian.org/debian trixie/main i386 libelf1t64 i386 0.191-1+b1 [194 kB] Get: 23 http://deb.debian.org/debian trixie/main i386 dwz i386 0.15-1+b1 [116 kB] Get: 24 http://deb.debian.org/debian trixie/main i386 libicu72 i386 72.1-4+b1 [9549 kB] Get: 25 http://deb.debian.org/debian trixie/main i386 libxml2 i386 2.9.14+dfsg-1.3+b3 [727 kB] Get: 26 http://deb.debian.org/debian trixie/main i386 gettext i386 0.21-14+b1 [1311 kB] Get: 27 http://deb.debian.org/debian trixie/main i386 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 28 http://deb.debian.org/debian trixie/main i386 po-debconf all 1.0.21+nmu1 [248 kB] Get: 29 http://deb.debian.org/debian trixie/main i386 debhelper all 13.16 [891 kB] Get: 30 http://deb.debian.org/debian trixie/main i386 dh-golang all 1.62 [24.7 kB] Get: 31 http://deb.debian.org/debian trixie/main i386 golang-1.22-src all 1.22.4-1 [18.8 MB] Get: 32 http://deb.debian.org/debian trixie/main i386 golang-1.22-go i386 1.22.4-1 [22.8 MB] Get: 33 http://deb.debian.org/debian trixie/main i386 golang-src all 2:1.22~3 [5020 B] Get: 34 http://deb.debian.org/debian trixie/main i386 golang-go i386 2:1.22~3 [44.2 kB] Get: 35 http://deb.debian.org/debian trixie/main i386 golang-any i386 2:1.22~3 [5104 B] Get: 36 http://deb.debian.org/debian trixie/main i386 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 37 http://deb.debian.org/debian trixie/main i386 golang-github-go-sql-driver-mysql-dev all 1.7.1-2 [74.6 kB] Get: 38 http://deb.debian.org/debian trixie/main i386 golang-github-gorilla-securecookie-dev all 1.1.2-1 [14.0 kB] Get: 39 http://deb.debian.org/debian trixie/main i386 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 40 http://deb.debian.org/debian trixie/main i386 golang-github-hashicorp-go-uuid-dev all 1.0.3-1 [8636 B] Get: 41 http://deb.debian.org/debian trixie/main i386 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 42 http://deb.debian.org/debian trixie/main i386 golang-github-stretchr-objx-dev all 0.5.2-1 [25.5 kB] Get: 43 http://deb.debian.org/debian trixie/main i386 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 44 http://deb.debian.org/debian trixie/main i386 golang-github-stretchr-testify-dev all 1.9.0-1 [74.7 kB] Get: 45 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 46 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 47 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 48 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 49 http://deb.debian.org/debian trixie/main i386 golang-golang-x-sys-dev all 0.20.0-1 [430 kB] Get: 50 http://deb.debian.org/debian trixie/main i386 golang-golang-x-term-dev all 0.20.0-1 [14.8 kB] Get: 51 http://deb.debian.org/debian trixie/main i386 golang-golang-x-text-dev all 0.15.0-1 [4006 kB] Get: 52 http://deb.debian.org/debian trixie/main i386 golang-golang-x-crypto-dev all 1:0.23.0-1 [1689 kB] Get: 53 http://deb.debian.org/debian trixie/main i386 golang-golang-x-net-dev all 1:0.25.0+dfsg-1 [895 kB] Get: 54 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 55 http://deb.debian.org/debian trixie/main i386 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 56 http://deb.debian.org/debian trixie/main i386 golang-github-lib-pq-dev all 1.10.9-2 [86.6 kB] Get: 57 http://deb.debian.org/debian trixie/main i386 libsqlite3-dev i386 3.46.0-1 [1181 kB] Get: 58 http://deb.debian.org/debian trixie/main i386 golang-github-mattn-go-sqlite3-dev i386 1.14.19~ds1-1 [83.4 kB] Get: 59 http://deb.debian.org/debian trixie/main i386 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 70.0 MB in 1s (62.4 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 ... 19679 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.23_all.deb ... Unpacking sensible-utils (0.0.23) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.45-3_i386.deb ... Unpacking libmagic-mgc (1:5.45-3) ... Selecting previously unselected package libmagic1t64:i386. Preparing to unpack .../02-libmagic1t64_1%3a5.45-3_i386.deb ... Unpacking libmagic1t64:i386 (1:5.45-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.45-3_i386.deb ... Unpacking file (1:5.45-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-14+b1_i386.deb ... Unpacking gettext-base (0.21-14+b1) ... Selecting previously unselected package libuchardet0:i386. Preparing to unpack .../05-libuchardet0_0.0.8-1+b1_i386.deb ... Unpacking libuchardet0:i386 (0.0.8-1+b1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-4_i386.deb ... Unpacking groff-base (1.23.0-4) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.40.1-8.1_i386.deb ... Unpacking bsdextrautils (2.40.1-8.1) ... Selecting previously unselected package libpipeline1:i386. Preparing to unpack .../08-libpipeline1_1.5.7-2_i386.deb ... Unpacking libpipeline1:i386 (1.5.7-2) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.12.1-2_i386.deb ... Unpacking man-db (2.12.1-2) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-4_i386.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.16_all.deb ... Unpacking libdebhelper-perl (13.16) ... 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:i386. Preparing to unpack .../21-libelf1t64_0.191-1+b1_i386.deb ... Unpacking libelf1t64:i386 (0.191-1+b1) ... Selecting previously unselected package dwz. Preparing to unpack .../22-dwz_0.15-1+b1_i386.deb ... Unpacking dwz (0.15-1+b1) ... Selecting previously unselected package libicu72:i386. Preparing to unpack .../23-libicu72_72.1-4+b1_i386.deb ... Unpacking libicu72:i386 (72.1-4+b1) ... Selecting previously unselected package libxml2:i386. Preparing to unpack .../24-libxml2_2.9.14+dfsg-1.3+b3_i386.deb ... Unpacking libxml2:i386 (2.9.14+dfsg-1.3+b3) ... Selecting previously unselected package gettext. Preparing to unpack .../25-gettext_0.21-14+b1_i386.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.16_all.deb ... Unpacking debhelper (13.16) ... 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.4-1_all.deb ... Unpacking golang-1.22-src (1.22.4-1) ... Selecting previously unselected package golang-1.22-go. Preparing to unpack .../31-golang-1.22-go_1.22.4-1_i386.deb ... Unpacking golang-1.22-go (1.22.4-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:i386. Preparing to unpack .../33-golang-go_2%3a1.22~3_i386.deb ... Unpacking golang-go:i386 (2:1.22~3) ... Selecting previously unselected package golang-any:i386. Preparing to unpack .../34-golang-any_2%3a1.22~3_i386.deb ... Unpacking golang-any:i386 (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:i386. Preparing to unpack .../56-libsqlite3-dev_3.46.0-1_i386.deb ... Unpacking libsqlite3-dev:i386 (3.46.0-1) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:i386. Preparing to unpack .../57-golang-github-mattn-go-sqlite3-dev_1.14.19~ds1-1_i386.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:i386 (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:i386 (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:i386 (72.1-4+b1) ... Setting up bsdextrautils (2.40.1-8.1) ... Setting up golang-github-stretchr-objx-dev (0.5.2-1) ... Setting up libmagic-mgc (1:5.45-3) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up golang-gopkg-yaml.v3-dev (3.0.1-3) ... Setting up libdebhelper-perl (13.16) ... Setting up golang-golang-x-sys-dev (0.20.0-1) ... Setting up libmagic1t64:i386 (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:i386 (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:i386 (3.46.0-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.4-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.23) ... 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:i386 (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:i386 (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.4-1) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:i386 (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:i386 (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-2) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-any:i386 (2:1.22~3) ... Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.16) ... Setting up golang-github-lib-pq-dev (1.10.9-2) ... Setting up dh-golang (1.62) ... Processing triggers for libc-bin (2.38-13) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: user script /srv/workspace/pbuilder/50239/tmp/hooks/A99_set_merged_usr starting Not re-configuring usrmerge for trixie I: user script /srv/workspace/pbuilder/50239/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 i386 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 10 gopkg.in/gorp.v1 internal/unsafeheader internal/goarch internal/race internal/godebugs internal/coverage/rtcov internal/goexperiment internal/goos runtime/internal/syscall runtime/internal/atomic sync/atomic internal/abi internal/cpu runtime/internal/math internal/chacha8rand runtime/internal/sys unicode/utf8 unicode internal/itoa math/bits cmp log/internal internal/bytealg slices math runtime internal/reflectlite sync internal/testlog errors sort internal/oserror io internal/safefilepath path strconv syscall bytes strings reflect regexp/syntax internal/syscall/execenv internal/syscall/unix time regexp context internal/poll io/fs internal/fmtsort os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 10 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2024/06/24 01:58:33 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: 01:58:33.059788 drop table if exists "invoice_test"; [] gorptest: 01:58:33.060587 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.060647 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.060690 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.060746 drop table if exists "person_test"; [] gorptest: 01:58:33.060789 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.060848 drop table if exists "id_created_test"; [] gorptest: 01:58:33.060897 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.060950 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.061000 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.061055 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.061108 drop table if exists "time_test"; [] gorptest: 01:58:33.061200 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.067107 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: 01:58:33.070421 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.076952 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.079967 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.082959 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.085984 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.088882 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.092137 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.095420 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.100210 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.103522 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.106407 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: 01:58:33.106520 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: 01:58:33.106581 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.106641 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: 01:58:33.106705 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: 01:58:33.106761 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.106818 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.106881 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.106936 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.106990 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.107046 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: 01:58:33.107100 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.107164 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 01:58:33.107218 drop table if exists "invoice_test"; [] gorptest: 01:58:33.110867 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.113198 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.116131 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.118360 drop table if exists "person_test"; [] gorptest: 01:58:33.121247 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.123351 drop table if exists "id_created_test"; [] gorptest: 01:58:33.125610 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.134540 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.137746 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.139929 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.142195 drop table if exists "time_test"; [] gorptest: 01:58:33.146166 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.09s) === RUN TestTruncateTables 2024/06/24 01:58:33 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: 01:58:33.146635 drop table if exists "invoice_test"; [] gorptest: 01:58:33.146998 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.147056 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.147107 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.147161 drop table if exists "person_test"; [] gorptest: 01:58:33.147217 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.147269 drop table if exists "id_created_test"; [] gorptest: 01:58:33.147320 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.147370 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.147418 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.147473 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.147537 drop table if exists "time_test"; [] gorptest: 01:58:33.147608 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.227881 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: 01:58:33.269340 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.271441 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.273347 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.275392 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.277353 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.279234 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.280941 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.282820 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.284703 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.286652 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.288551 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: 01:58:33.288650 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: 01:58:33.288714 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.288785 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: 01:58:33.288861 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: 01:58:33.288927 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.288981 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.289042 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.289111 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.289180 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.289256 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: 01:58:33.289341 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.289400 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 01:58:33.289510 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194313289472800 2:1719194313289472800 3:"Bob" 4:"Smith" 5:1] gorptest: 01:58:33.291421 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 01:58:33.293216 delete from "invoice_test"; [] gorptest: 01:58:33.294849 delete from "invoice_tag_test"; [] gorptest: 01:58:33.296664 delete from "alias_trans_field_test"; [] gorptest: 01:58:33.298277 delete from "invoice_override_test"; [] gorptest: 01:58:33.300146 delete from "person_test"; [] gorptest: 01:58:33.301889 delete from "ignored_column_test"; [] gorptest: 01:58:33.303500 delete from "id_created_test"; [] gorptest: 01:58:33.305307 delete from "type_conv_test"; [] gorptest: 01:58:33.307074 delete from "embedded_struct_test"; [] gorptest: 01:58:33.308593 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.310331 delete from "embedded_autoincr_test"; [] gorptest: 01:58:33.312116 delete from "time_test"; [] gorptest: 01:58:33.313821 delete from "id_created_test"; [] gorptest: 01:58:33.315775 SELECT * FROM person_test [] gorptest: 01:58:33.315971 SELECT * FROM invoice_test [] gorptest: 01:58:33.316120 drop table if exists "invoice_test"; [] gorptest: 01:58:33.317974 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.321469 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.323536 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.325511 drop table if exists "person_test"; [] gorptest: 01:58:33.327393 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.329246 drop table if exists "id_created_test"; [] gorptest: 01:58:33.331194 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.333179 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.335124 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.337027 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.338921 drop table if exists "time_test"; [] gorptest: 01:58:33.340713 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.19s) === RUN TestCustomDateType gorptest: 01:58:33.341226 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 01:58:33.343803 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-06-24 01:58:33 +0000 UTC] gorptest: 01:58:33.345754 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 01:58:33.345917 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.01s) === RUN TestUIntPrimaryKey gorptest: 01:58:33.348281 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 01:58:33.350427 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 01:58:33.352357 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 01:58:33.354225 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 01:58:33.355978 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 01:58:33.357763 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 01:58:33.359545 drop table if exists "PersonUInt64"; [] gorptest: 01:58:33.361313 drop table if exists "PersonUInt32"; [] gorptest: 01:58:33.363212 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.02s) === RUN TestSetUniqueTogether gorptest: 01:58:33.366845 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 01:58:33.369303 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 01:58:33.371156 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 01:58:33.371292 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 01:58:33.371382 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 01:58:33.375128 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.01s) === RUN TestPersistentUser gorptest: 01:58:33.377583 drop table if exists PersistentUser [] gorptest: 01:58:33.377926 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 01:58:33.379788 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 01:58:33.381529 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 01:58:33.381659 select * from PersistentUser [] gorptest: 01:58:33.381767 select * from PersistentUser [] gorptest: 01:58:33.381869 select * from PersistentUser [] gorptest: 01:58:33.381979 select Id from PersistentUser [] gorptest: 01:58:33.382050 select mykey from PersistentUser [] gorptest: 01:58:33.382115 select PassedTraining from PersistentUser [] gorptest: 01:58:33.382192 select Id from PersistentUser [] gorptest: 01:58:33.382260 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.01s) === RUN TestNamedQueryMap gorptest: 01:58:33.384151 drop table if exists PersistentUser [] gorptest: 01:58:33.384460 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 01:58:33.386297 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 01:58:33.388101 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 01:58:33.389791 select * from PersistentUser where mykey = ? [1:43] gorptest: 01:58:33.389924 select * from PersistentUser where mykey = ? [1:43] gorptest: 01:58:33.390008 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 01:58:33.390096 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 01:58:33.390173 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.01s) === RUN TestNamedQueryStruct gorptest: 01:58:33.392105 drop table if exists PersistentUser [] gorptest: 01:58:33.392435 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 01:58:33.394204 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 01:58:33.395973 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 01:58:33.397616 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 01:58:33.397749 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.01s) === RUN TestReturnsNonNilSlice 2024/06/24 01:58:33 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: 01:58:33.399557 drop table if exists "invoice_test"; [] gorptest: 01:58:33.399820 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.399857 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.399929 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.399988 drop table if exists "person_test"; [] gorptest: 01:58:33.400032 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.400077 drop table if exists "id_created_test"; [] gorptest: 01:58:33.400118 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.400153 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.400187 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.400222 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.400255 drop table if exists "time_test"; [] gorptest: 01:58:33.400308 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.402203 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: 01:58:33.404604 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.406387 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.408212 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.410098 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.411810 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.413766 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.415810 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.417940 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.419867 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.421973 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.423798 select * from invoice_test where id=99999 [] gorptest: 01:58:33.423927 select * from invoice_test where id=99999 [] gorptest: 01:58:33.424019 drop table if exists "invoice_test"; [] gorptest: 01:58:33.427691 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.440541 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.449858 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.452772 drop table if exists "person_test"; [] gorptest: 01:58:33.460914 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.462919 drop table if exists "id_created_test"; [] gorptest: 01:58:33.473756 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.484148 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.487177 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.489324 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.491255 drop table if exists "time_test"; [] gorptest: 01:58:33.493149 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.09s) === RUN TestOverrideVersionCol gorptest: 01:58:33.493479 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 01:58:33.495758 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: 01:58:33.495878 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2024/06/24 01:58:33 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: 01:58:33.497925 drop table if exists "invoice_test"; [] gorptest: 01:58:33.498173 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.498216 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.498250 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.498283 drop table if exists "person_test"; [] gorptest: 01:58:33.498316 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.498350 drop table if exists "id_created_test"; [] gorptest: 01:58:33.498382 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.498415 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.498448 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.498481 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.498513 drop table if exists "time_test"; [] gorptest: 01:58:33.498559 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.500264 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: 01:58:33.502001 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.503708 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.506109 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.511196 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.513130 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.514832 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.516622 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.518831 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.521037 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.523540 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.525663 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194313525633847 2:1719194313525633847 3:"Bob" 4:"Smith" 5:1] gorptest: 01:58:33.527854 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:33.528027 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1719194313525633847 2:1719194313525633847 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 01:58:33.530078 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1719194313525633847 2:1719194313525633847 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 01:58:33.530174 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:33.530259 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 01:58:33.530319 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:33.530388 drop table if exists "invoice_test"; [] gorptest: 01:58:33.532458 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.534908 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.538041 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.540238 drop table if exists "person_test"; [] gorptest: 01:58:33.541992 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.543725 drop table if exists "id_created_test"; [] gorptest: 01:58:33.546551 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.548669 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.550586 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.552587 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.554490 drop table if exists "time_test"; [] gorptest: 01:58:33.556380 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.06s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 01:58:33.556716 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 01:58:33.558812 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 01:58:33.560571 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 01:58:33.560713 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: 01:58:33.562505 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 01:58:33.562606 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.01s) === RUN TestColumnProps gorptest: 01:58:33.564534 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 01:58:33.566706 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 01:58:33.569322 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 01:58:33.569462 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 01:58:33.569549 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 01:58:33.569610 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.01s) === RUN TestRawSelect 2024/06/24 01:58:33 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: 01:58:33.572532 drop table if exists "invoice_test"; [] gorptest: 01:58:33.572793 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.572834 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.572871 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.572904 drop table if exists "person_test"; [] gorptest: 01:58:33.572937 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.572970 drop table if exists "id_created_test"; [] gorptest: 01:58:33.573003 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.573035 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.573068 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.573102 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.573134 drop table if exists "time_test"; [] gorptest: 01:58:33.573175 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.575695 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: 01:58:33.578207 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.580654 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.583233 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.585296 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.587287 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.591085 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.592748 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.594559 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.596423 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.598127 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.599971 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194313599941140 2:1719194313599941140 3:"bob" 4:"smith" 5:1] gorptest: 01:58:33.601672 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 01:58:33.603373 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 01:58:33.603532 drop table if exists "invoice_test"; [] gorptest: 01:58:33.605323 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.607130 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.608722 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.610603 drop table if exists "person_test"; [] gorptest: 01:58:33.612385 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.614129 drop table if exists "id_created_test"; [] gorptest: 01:58:33.615861 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.617757 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.619574 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.621260 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.624727 drop table if exists "time_test"; [] gorptest: 01:58:33.626701 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.05s) === RUN TestHooks 2024/06/24 01:58:33 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: 01:58:33.627008 drop table if exists "invoice_test"; [] gorptest: 01:58:33.627292 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.627334 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.627369 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.627403 drop table if exists "person_test"; [] gorptest: 01:58:33.627436 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.627471 drop table if exists "id_created_test"; [] gorptest: 01:58:33.627504 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.627537 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.627570 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.627603 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.627637 drop table if exists "time_test"; [] gorptest: 01:58:33.627681 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.629556 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: 01:58:33.631248 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.632838 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.634702 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.636450 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.638035 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.639796 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.641551 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.643158 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.644976 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.646731 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.649853 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194313649824941 2:1719194313649824941 3:"bob" 4:"smith" 5:1] gorptest: 01:58:33.651673 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:33.651802 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1719194313649824941 2:1719194313649824941 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 01:58:33.653458 select * from person_test where id = ? [1:1] gorptest: 01:58:33.653590 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 01:58:33.655264 drop table if exists "invoice_test"; [] gorptest: 01:58:33.656885 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.658655 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.660186 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.662025 drop table if exists "person_test"; [] gorptest: 01:58:33.663700 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.665565 drop table if exists "id_created_test"; [] gorptest: 01:58:33.667385 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.669361 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.671306 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.673430 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.682351 drop table if exists "time_test"; [] gorptest: 01:58:33.684562 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.06s) === RUN TestTransaction 2024/06/24 01:58:33 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: 01:58:33.684969 drop table if exists "invoice_test"; [] gorptest: 01:58:33.685328 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.685384 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.685427 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.685465 drop table if exists "person_test"; [] gorptest: 01:58:33.685505 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.685546 drop table if exists "id_created_test"; [] gorptest: 01:58:33.685586 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.685625 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.685673 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.685713 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.685753 drop table if exists "time_test"; [] gorptest: 01:58:33.685803 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.687940 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: 01:58:33.690053 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.692103 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.696171 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.699076 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.701296 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.703878 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.707508 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.710438 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.713265 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.716584 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.721424 begin; [] gorptest: 01:58:33.721534 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 01:58:33.721743 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 01:58:33.721790 commit; [] gorptest: 01:58:33.737863 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.738152 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 01:58:33.738261 drop table if exists "invoice_test"; [] gorptest: 01:58:33.741182 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.743256 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.745102 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.747804 drop table if exists "person_test"; [] gorptest: 01:58:33.749675 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.752028 drop table if exists "id_created_test"; [] gorptest: 01:58:33.754725 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.757550 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.760320 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.762117 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.764665 drop table if exists "time_test"; [] gorptest: 01:58:33.766245 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.08s) === RUN TestSavepoint 2024/06/24 01:58:33 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: 01:58:33.766578 drop table if exists "invoice_test"; [] gorptest: 01:58:33.766870 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.766911 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.766946 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.766979 drop table if exists "person_test"; [] gorptest: 01:58:33.767013 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.767046 drop table if exists "id_created_test"; [] gorptest: 01:58:33.767079 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.767112 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.767144 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.767177 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.767210 drop table if exists "time_test"; [] gorptest: 01:58:33.767254 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.769904 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: 01:58:33.771728 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.774103 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.776539 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.778696 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.781155 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.783034 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.784859 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.786474 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.788794 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.790638 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.792363 begin; [] gorptest: 01:58:33.792452 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 01:58:33.792617 select memo from invoice_test [] gorptest: 01:58:33.792699 savepoint "foo" [1:] gorptest: 01:58:33.792717 select memo from invoice_test [] gorptest: 01:58:33.792795 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 01:58:33.792872 select memo from invoice_test [] gorptest: 01:58:33.792952 rollback to savepoint "foo" [1:] gorptest: 01:58:33.792976 select memo from invoice_test [] gorptest: 01:58:33.793011 rollback; [] gorptest: 01:58:33.793095 drop table if exists "invoice_test"; [] gorptest: 01:58:33.798189 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.799818 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.801671 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.803559 drop table if exists "person_test"; [] gorptest: 01:58:33.805344 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.807053 drop table if exists "id_created_test"; [] gorptest: 01:58:33.808814 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.810302 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.812163 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.814024 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.815479 drop table if exists "time_test"; [] gorptest: 01:58:33.816989 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.05s) === RUN TestMultiple 2024/06/24 01:58:33 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: 01:58:33.817308 drop table if exists "invoice_test"; [] gorptest: 01:58:33.817593 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.817636 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.817671 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.817704 drop table if exists "person_test"; [] gorptest: 01:58:33.817737 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.817770 drop table if exists "id_created_test"; [] gorptest: 01:58:33.817803 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.817835 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.817867 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.817900 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.817933 drop table if exists "time_test"; [] gorptest: 01:58:33.817977 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.819531 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: 01:58:33.821981 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.823860 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.825691 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.832156 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.834660 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.838495 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.840562 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.843699 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.846599 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.850006 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.852170 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 01:58:33.854096 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 01:58:33.856121 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 01:58:33.858094 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 01:58:33.860111 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.862070 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 01:58:33.864112 drop table if exists "invoice_test"; [] gorptest: 01:58:33.866121 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.868641 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.871149 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.874173 drop table if exists "person_test"; [] gorptest: 01:58:33.876633 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.879108 drop table if exists "id_created_test"; [] gorptest: 01:58:33.881599 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.884129 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.886623 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.889132 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.891624 drop table if exists "time_test"; [] gorptest: 01:58:33.894148 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.08s) === RUN TestCrud 2024/06/24 01:58:33 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: 01:58:33.894486 drop table if exists "invoice_test"; [] gorptest: 01:58:33.894773 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.894815 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.894850 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.894884 drop table if exists "person_test"; [] gorptest: 01:58:33.894917 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.894954 drop table if exists "id_created_test"; [] gorptest: 01:58:33.894991 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.895024 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:33.895057 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:33.895091 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:33.895124 drop table if exists "time_test"; [] gorptest: 01:58:33.895168 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.896997 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: 01:58:33.899121 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:33.901514 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:33.904704 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:33.907200 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.909617 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:33.912047 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:33.914618 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:33.917164 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:33.919640 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:33.922153 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:33.924058 delete from invoice_test [] gorptest: 01:58:33.926699 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 01:58:33.929646 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.929825 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:6705478047075325035 2:6924223510481387923 3:"random 8062507178392661895" 4:0 5:true 6:1] gorptest: 01:58:33.932123 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.932237 select * from invoice_test [] gorptest: 01:58:33.932379 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.934690 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 01:58:33.934794 delete from invoice_tag_test [] gorptest: 01:58:33.937133 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: 01:58:33.940604 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 01:58:33.940759 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:5844410980436984726 2:5787040840286022643 3:"random 9039765007508869946" 4:33 5:false 6:1] gorptest: 01:58:33.942569 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 01:58:33.942674 select * from invoice_tag_test [] gorptest: 01:58:33.942783 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 01:58:33.945137 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 01:58:33.945234 delete from alias_trans_field_test [] gorptest: 01:58:33.947638 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 01:58:33.950648 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 01:58:33.950762 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 1370736024100799636" 2:1] gorptest: 01:58:33.953161 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 01:58:33.953266 select * from alias_trans_field_test [] gorptest: 01:58:33.953349 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 01:58:33.955671 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 01:58:33.955756 drop table if exists "invoice_test"; [] gorptest: 01:58:33.958578 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:33.962131 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:33.965698 drop table if exists "invoice_override_test"; [] gorptest: 01:58:33.969131 drop table if exists "person_test"; [] gorptest: 01:58:33.972128 drop table if exists "ignored_column_test"; [] gorptest: 01:58:33.975171 drop table if exists "id_created_test"; [] gorptest: 01:58:33.978142 drop table if exists "type_conv_test"; [] gorptest: 01:58:33.981062 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.004169 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.006403 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.008403 drop table if exists "time_test"; [] gorptest: 01:58:34.010140 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.12s) === RUN TestWithIgnoredColumn 2024/06/24 01:58:34 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: 01:58:34.010461 drop table if exists "invoice_test"; [] gorptest: 01:58:34.010779 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.010821 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.010856 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.010890 drop table if exists "person_test"; [] gorptest: 01:58:34.010924 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.010957 drop table if exists "id_created_test"; [] gorptest: 01:58:34.010995 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.011028 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.011062 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.011096 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.011129 drop table if exists "time_test"; [] gorptest: 01:58:34.011173 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.012938 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: 01:58:34.014708 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.016810 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.018898 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.020900 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.023048 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.032199 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.052248 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.054863 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.056822 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.058623 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.060545 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 01:58:34.062412 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 01:58:34.062520 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 01:58:34.064173 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 01:58:34.064252 drop table if exists "invoice_test"; [] gorptest: 01:58:34.066156 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.068034 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.069880 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.082820 drop table if exists "person_test"; [] gorptest: 01:58:34.085237 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.087237 drop table if exists "id_created_test"; [] gorptest: 01:58:34.089125 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.090937 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.092705 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.096879 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.098831 drop table if exists "time_test"; [] gorptest: 01:58:34.100662 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.09s) === RUN TestTypeConversionExample 2024/06/24 01:58:34 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: 01:58:34.101334 drop table if exists "invoice_test"; [] gorptest: 01:58:34.101739 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.101782 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.101922 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.101964 drop table if exists "person_test"; [] gorptest: 01:58:34.102096 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.102141 drop table if exists "id_created_test"; [] gorptest: 01:58:34.102265 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.102344 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.102468 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.102515 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.102728 drop table if exists "time_test"; [] gorptest: 01:58:34.102893 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.105591 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: 01:58:34.108126 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.110475 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.112721 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.115102 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.117074 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.119270 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.121215 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.123191 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.125811 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.127765 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.132669 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: 01:58:34.134709 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 01:58:34.134963 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: 01:58:34.137326 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 01:58:34.137557 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 01:58:34.139142 drop table if exists "invoice_test"; [] gorptest: 01:58:34.140825 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.142800 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.144489 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.147351 drop table if exists "person_test"; [] gorptest: 01:58:34.149840 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.152326 drop table if exists "id_created_test"; [] gorptest: 01:58:34.154990 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.157509 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.160170 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.162253 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.164022 drop table if exists "time_test"; [] gorptest: 01:58:34.165658 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.06s) === RUN TestWithEmbeddedStruct 2024/06/24 01:58:34 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: 01:58:34.166184 drop table if exists "invoice_test"; [] gorptest: 01:58:34.166578 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.166621 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.166664 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.166700 drop table if exists "person_test"; [] gorptest: 01:58:34.166734 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.166768 drop table if exists "id_created_test"; [] gorptest: 01:58:34.166812 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.166952 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.167079 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.167129 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.167383 drop table if exists "time_test"; [] gorptest: 01:58:34.167534 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.169206 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: 01:58:34.170915 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.172983 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.174882 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.176669 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.180250 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.182008 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.183795 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.185809 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.187708 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.189518 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.191361 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 01:58:34.194040 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 01:58:34.194292 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 01:58:34.196500 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 01:58:34.196697 select * from embedded_struct_test [] gorptest: 01:58:34.196898 drop table if exists "invoice_test"; [] gorptest: 01:58:34.206775 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.209561 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.211475 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.213802 drop table if exists "person_test"; [] gorptest: 01:58:34.215613 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.217157 drop table if exists "id_created_test"; [] gorptest: 01:58:34.218907 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.227785 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.229847 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.231278 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.236453 drop table if exists "time_test"; [] gorptest: 01:58:34.238382 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.07s) === RUN TestWithEmbeddedStructBeforeAutoincr 2024/06/24 01:58:34 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: 01:58:34.238973 drop table if exists "invoice_test"; [] gorptest: 01:58:34.239407 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.239451 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.239591 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.239638 drop table if exists "person_test"; [] gorptest: 01:58:34.239856 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.239923 drop table if exists "id_created_test"; [] gorptest: 01:58:34.240067 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.240117 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.240341 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.240387 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.240608 drop table if exists "time_test"; [] gorptest: 01:58:34.240753 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.242536 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: 01:58:34.244266 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.246213 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.249478 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.251464 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.253109 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.254821 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.256729 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.258467 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.260310 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.261763 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.263109 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 01:58:34.264997 drop table if exists "invoice_test"; [] gorptest: 01:58:34.267527 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.270572 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.273582 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.277076 drop table if exists "person_test"; [] gorptest: 01:58:34.280090 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.283037 drop table if exists "id_created_test"; [] gorptest: 01:58:34.286143 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.289098 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.292189 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.295663 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.298575 drop table if exists "time_test"; [] gorptest: 01:58:34.301125 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.06s) === RUN TestWithEmbeddedAutoincr 2024/06/24 01:58:34 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: 01:58:34.301675 drop table if exists "invoice_test"; [] gorptest: 01:58:34.302091 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.302138 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.302396 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.302524 drop table if exists "person_test"; [] gorptest: 01:58:34.302660 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.302793 drop table if exists "id_created_test"; [] gorptest: 01:58:34.302935 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.303063 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.303198 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.303324 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.303471 drop table if exists "time_test"; [] gorptest: 01:58:34.303609 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.305350 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: 01:58:34.306907 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.309674 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.320556 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.322570 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.324430 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.326170 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.327582 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.329435 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.330962 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.334058 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.336612 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 01:58:34.339526 drop table if exists "invoice_test"; [] gorptest: 01:58:34.341541 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.344092 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.346623 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.349605 drop table if exists "person_test"; [] gorptest: 01:58:34.352103 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.354597 drop table if exists "id_created_test"; [] gorptest: 01:58:34.357096 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.359596 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.363040 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.365595 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.369091 drop table if exists "time_test"; [] gorptest: 01:58:34.371622 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.07s) === RUN TestSelectVal gorptest: 01:58:34.371926 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 01:58:34.374172 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: 01:58:34.376615 select Int64 from TableWithNull where Str='abc' [] gorptest: 01:58:34.376713 select count(*) from TableWithNull [] gorptest: 01:58:34.376773 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 01:58:34.376834 select Int64 from TableWithNull where Str='notfound' [] gorptest: 01:58:34.376888 select Int64 from TableWithNull where Str='abc' [] gorptest: 01:58:34.376943 select Float64 from TableWithNull where Str='abc' [] gorptest: 01:58:34.376997 select min(Float64) from TableWithNull [] gorptest: 01:58:34.377056 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 01:58:34.377131 select Float64 from TableWithNull where Str='notfound' [] gorptest: 01:58:34.377185 select Float64 from TableWithNull where Str='abc' [] gorptest: 01:58:34.377241 select Str from TableWithNull where Int64=? [1:78] gorptest: 01:58:34.377296 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 01:58:34.377357 select Str from TableWithNull where Int64=? [1:78] gorptest: 01:58:34.377416 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 01:58:34.377528 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 01:58:34.377595 select Str from TableWithNull where Int64=? [1:78] gorptest: 01:58:34.377654 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows 2024/06/24 01:58:34 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: 01:58:34.382284 drop table if exists "invoice_test"; [] gorptest: 01:58:34.382647 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.382690 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.382725 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.382759 drop table if exists "person_test"; [] gorptest: 01:58:34.382793 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.382827 drop table if exists "id_created_test"; [] gorptest: 01:58:34.382859 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.382892 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.382925 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.382959 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.382997 drop table if exists "time_test"; [] gorptest: 01:58:34.383047 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.385241 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: 01:58:34.387521 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.390118 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.394609 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.396601 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.426159 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.436197 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.449028 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.452932 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.455373 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.457337 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.459316 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314459284181 2:1719194314459284181 3:"Bob" 4:"Smith" 5:1] gorptest: 01:58:34.461285 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314461266845 2:1719194314461266845 3:"Jane" 4:"Smith" 5:1] gorptest: 01:58:34.463107 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314463086624 2:1719194314463086624 3:"Mike" 4:"Smith" 5:1] gorptest: 01:58:34.464999 drop table if exists "invoice_test"; [] gorptest: 01:58:34.466973 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.468920 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.470831 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.472945 drop table if exists "person_test"; [] gorptest: 01:58:34.475043 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.476997 drop table if exists "id_created_test"; [] gorptest: 01:58:34.479040 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.480918 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.482628 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.484601 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.486645 drop table if exists "time_test"; [] gorptest: 01:58:34.488584 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.11s) === RUN TestWithStringPk gorptest: 01:58:34.488843 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 01:58:34.491198 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 01:58:34.493119 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.01s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2024/06/24 01:58:34 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: 01:58:34.495938 drop table if exists "invoice_test"; [] gorptest: 01:58:34.496351 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.496415 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.496452 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.496491 drop table if exists "person_test"; [] gorptest: 01:58:34.496534 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.496590 drop table if exists "id_created_test"; [] gorptest: 01:58:34.496643 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.496694 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.496729 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.496768 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.496802 drop table if exists "time_test"; [] gorptest: 01:58:34.496869 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.499075 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: 01:58:34.501833 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.505007 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.508331 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.510406 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.513710 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.516543 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.518193 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.519745 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.521445 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.523298 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.526006 insert into "time_test" ("Id","Time") values (null,?); [1:2024-06-24 01:27:34.525974538 +0000 UTC] gorptest: 01:58:34.527857 insert into "time_test" ("Id","Time") values (null,?); [1:2024-06-24 01:28:35.525974538 +0000 UTC] gorptest: 01:58:34.529504 SELECT id FROM time_test WHERE Time < ? [1:2024-06-24 01:28:34.525974538 +0000 UTC] gorptest: 01:58:34.529659 drop table if exists "invoice_test"; [] gorptest: 01:58:34.531148 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.532907 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.535682 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.538263 drop table if exists "person_test"; [] gorptest: 01:58:34.540917 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.543622 drop table if exists "id_created_test"; [] gorptest: 01:58:34.545480 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.547510 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.551871 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.554082 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.555803 drop table if exists "time_test"; [] gorptest: 01:58:34.557708 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.06s) === RUN TestInvoicePersonView 2024/06/24 01:58:34 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: 01:58:34.558075 drop table if exists "invoice_test"; [] gorptest: 01:58:34.558431 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.558493 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.558541 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.558596 drop table if exists "person_test"; [] gorptest: 01:58:34.558646 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.558696 drop table if exists "id_created_test"; [] gorptest: 01:58:34.558751 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.558807 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.558867 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.558924 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.558982 drop table if exists "time_test"; [] gorptest: 01:58:34.559058 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.561568 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: 01:58:34.563503 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.565330 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.567366 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.569366 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.571149 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.572957 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.574908 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.576998 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.578937 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.580758 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.582442 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314582410179 2:1719194314582410179 3:"bob" 4:"smith" 5:1] gorptest: 01:58:34.584240 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 01:58:34.586192 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 01:58:34.586388 drop table if exists "invoice_test"; [] gorptest: 01:58:34.588317 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.590701 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.593630 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.597203 drop table if exists "person_test"; [] gorptest: 01:58:34.600666 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.604708 drop table if exists "id_created_test"; [] gorptest: 01:58:34.607580 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.610638 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.614048 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.616698 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.619663 drop table if exists "time_test"; [] gorptest: 01:58:34.622119 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.06s) === RUN TestQuoteTableNames 2024/06/24 01:58:34 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: 01:58:34.622529 drop table if exists "invoice_test"; [] gorptest: 01:58:34.622888 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.622951 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.623005 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.623062 drop table if exists "person_test"; [] gorptest: 01:58:34.623116 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.623172 drop table if exists "id_created_test"; [] gorptest: 01:58:34.623230 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.623282 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.623340 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.623402 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.623463 drop table if exists "time_test"; [] gorptest: 01:58:34.623549 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.625572 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: 01:58:34.627635 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.630669 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.634165 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.637149 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.640157 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.643580 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.672143 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.682540 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.684788 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.689212 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.10s) === RUN TestSelectTooManyCols 2024/06/24 01:58:34 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: 01:58:34.723630 drop table if exists "invoice_test"; [] gorptest: 01:58:34.724002 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.724073 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.724139 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.724195 drop table if exists "person_test"; [] gorptest: 01:58:34.724262 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.724317 drop table if exists "id_created_test"; [] gorptest: 01:58:34.724372 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.724436 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.724504 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.724556 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.724611 drop table if exists "time_test"; [] gorptest: 01:58:34.724694 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.727434 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: 01:58:34.730011 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.732847 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.734839 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.737088 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.739484 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.741662 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.745252 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.747467 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.749411 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.751405 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.753364 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314753330533 2:1719194314753330533 3:"bob" 4:"smith" 5:1] gorptest: 01:58:34.755064 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314755043241 2:1719194314755043241 3:"jane" 4:"doe" 5:1] gorptest: 01:58:34.756834 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:34.756994 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 01:58:34.757113 select * from person_test where Id=? [1:1] gorptest: 01:58:34.757253 select * from person_test order by fname asc [] gorptest: 01:58:34.757421 drop table if exists "invoice_test"; [] gorptest: 01:58:34.759281 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.761192 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.762994 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.765214 drop table if exists "person_test"; [] gorptest: 01:58:34.767337 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.769324 drop table if exists "id_created_test"; [] gorptest: 01:58:34.772537 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.774341 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.776292 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.778313 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.780347 drop table if exists "time_test"; [] gorptest: 01:58:34.782551 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.06s) === RUN TestSelectSingleVal 2024/06/24 01:58:34 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: 01:58:34.782913 drop table if exists "invoice_test"; [] gorptest: 01:58:34.783298 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.783358 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.783411 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.783465 drop table if exists "person_test"; [] gorptest: 01:58:34.783523 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.783578 drop table if exists "id_created_test"; [] gorptest: 01:58:34.783641 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.783697 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.783755 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.783815 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.783872 drop table if exists "time_test"; [] gorptest: 01:58:34.783994 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.786327 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: 01:58:34.788371 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.790429 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.792634 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.794775 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.796860 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.798826 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.800900 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.802999 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.805071 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.807242 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.809399 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314809359826 2:1719194314809359826 3:"bob" 4:"smith" 5:1] gorptest: 01:58:34.812235 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 01:58:34.812463 select * from person_test where Id=? [1:1] gorptest: 01:58:34.812625 select FName from person_test where Id=? [1:1] gorptest: 01:58:34.812711 select * from person_test where Id=? [1:1] gorptest: 01:58:34.812860 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 01:58:34.812994 select * from person_test where Id=? [1:-2222] gorptest: 01:58:34.813145 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1719194314813108928 2:1719194314813108928 3:"bob" 4:"smith" 5:1] gorptest: 01:58:34.815045 select * from person_test where Fname='bob' [] gorptest: 01:58:34.815245 select * from person_test where Id=-123 [] gorptest: 01:58:34.815338 select * from person_test where Id=-123 [] gorptest: 01:58:34.815418 select * from person_test where Id=-123 [] gorptest: 01:58:34.815497 select * from person_test where Id=-123 [] gorptest: 01:58:34.815590 drop table if exists "invoice_test"; [] gorptest: 01:58:34.817547 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.819632 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.822187 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.825179 drop table if exists "person_test"; [] gorptest: 01:58:34.827600 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.830208 drop table if exists "id_created_test"; [] gorptest: 01:58:34.833651 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.835706 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.864140 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.871153 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.873373 drop table if exists "time_test"; [] gorptest: 01:58:34.875251 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.09s) === RUN TestSelectAlias 2024/06/24 01:58:34 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: 01:58:34.875594 drop table if exists "invoice_test"; [] gorptest: 01:58:34.875999 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.876060 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.876107 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.876156 drop table if exists "person_test"; [] gorptest: 01:58:34.876209 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.876255 drop table if exists "id_created_test"; [] gorptest: 01:58:34.876304 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.876352 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.876404 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.876454 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.876508 drop table if exists "time_test"; [] gorptest: 01:58:34.876586 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.879485 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: 01:58:34.882234 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.885203 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.887265 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.889144 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.891014 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.892999 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.894748 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.897637 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.899490 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.901871 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.904496 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 01:58:34.906982 select * from id_created_test where Id=1 [] gorptest: 01:58:34.907140 SELECT *, 1 AS external FROM id_created_test [] gorptest: 01:58:34.907305 drop table if exists "invoice_test"; [] gorptest: 01:58:34.910676 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.913241 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.916311 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.918668 drop table if exists "person_test"; [] gorptest: 01:58:34.920792 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.922941 drop table if exists "id_created_test"; [] gorptest: 01:58:34.924972 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.926973 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.928885 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.930720 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.932763 drop table if exists "time_test"; [] gorptest: 01:58:34.934781 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.06s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2024/06/24 01:58:34 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: 01:58:34.935243 drop table if exists "invoice_test"; [] gorptest: 01:58:34.935619 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.935678 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.935727 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.935772 drop table if exists "person_test"; [] gorptest: 01:58:34.935821 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.935869 drop table if exists "id_created_test"; [] gorptest: 01:58:34.935956 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.936017 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.936067 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.936125 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.936176 drop table if exists "time_test"; [] gorptest: 01:58:34.936251 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.938371 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: 01:58:34.940293 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.942504 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:34.944672 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:34.947821 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.950025 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:34.952054 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:34.954194 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:34.957958 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:34.960151 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:34.964957 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:34.967541 drop table if exists "invoice_test"; [] gorptest: 01:58:34.969452 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:34.971745 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:34.973852 drop table if exists "invoice_override_test"; [] gorptest: 01:58:34.976059 drop table if exists "person_test"; [] gorptest: 01:58:34.978016 drop table if exists "ignored_column_test"; [] gorptest: 01:58:34.980057 drop table if exists "id_created_test"; [] gorptest: 01:58:34.982046 drop table if exists "type_conv_test"; [] gorptest: 01:58:34.984046 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:34.985923 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:34.987815 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:34.989846 drop table if exists "time_test"; [] gorptest: 01:58:34.991652 drop table if exists "id_created_test"; [] gorptest: 01:58:34.991720 drop table if exists "single_column_table"; [] gorptest: 01:58:34.991787 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: 01:58:34.993866 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: 01:58:34.995648 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:34.997651 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: 01:58:34.999948 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: 01:58:35.002081 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:35.004724 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:35.007194 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:35.009687 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:35.013494 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:35.015742 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: 01:58:35.018066 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:35.020220 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 01:58:35.020363 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 01:58:35.022962 delete from "invoice_test"; [] gorptest: 01:58:35.025223 delete from "invoice_tag_test"; [] gorptest: 01:58:35.027669 delete from "alias_trans_field_test"; [] gorptest: 01:58:35.030218 delete from "invoice_override_test"; [] gorptest: 01:58:35.041809 delete from "person_test"; [] gorptest: 01:58:35.044662 delete from "ignored_column_test"; [] gorptest: 01:58:35.047288 delete from "id_created_test"; [] gorptest: 01:58:35.049995 delete from "type_conv_test"; [] gorptest: 01:58:35.051709 delete from "embedded_struct_test"; [] gorptest: 01:58:35.054218 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:35.056049 delete from "embedded_autoincr_test"; [] gorptest: 01:58:35.058396 delete from "time_test"; [] gorptest: 01:58:35.060384 delete from "id_created_test"; [] gorptest: 01:58:35.062050 delete from "single_column_table"; [] gorptest: 01:58:35.063812 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 01:58:35.063971 drop table if exists "invoice_test"; [] gorptest: 01:58:35.066178 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:35.069221 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:35.072220 drop table if exists "invoice_override_test"; [] gorptest: 01:58:35.075710 drop table if exists "person_test"; [] gorptest: 01:58:35.079070 drop table if exists "ignored_column_test"; [] gorptest: 01:58:35.081704 drop table if exists "id_created_test"; [] gorptest: 01:58:35.091078 drop table if exists "type_conv_test"; [] gorptest: 01:58:35.093430 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:35.095475 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:35.098411 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:35.100849 drop table if exists "time_test"; [] gorptest: 01:58:35.103012 drop table if exists "id_created_test"; [] gorptest: 01:58:35.103081 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.17s) === RUN TestPrepare 2024/06/24 01:58:35 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: 01:58:35.107935 drop table if exists "invoice_test"; [] gorptest: 01:58:35.108312 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:35.108364 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:35.108413 drop table if exists "invoice_override_test"; [] gorptest: 01:58:35.108461 drop table if exists "person_test"; [] gorptest: 01:58:35.108509 drop table if exists "ignored_column_test"; [] gorptest: 01:58:35.108557 drop table if exists "id_created_test"; [] gorptest: 01:58:35.108604 drop table if exists "type_conv_test"; [] gorptest: 01:58:35.108652 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:35.108700 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:35.108750 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:35.108798 drop table if exists "time_test"; [] gorptest: 01:58:35.108859 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:35.110893 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: 01:58:35.112879 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 01:58:35.115277 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 01:58:35.117308 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 01:58:35.120245 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:35.123150 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 01:58:35.126210 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 01:58:35.129231 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 01:58:35.132210 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 01:58:35.135204 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 01:58:35.138219 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 01:58:35.141206 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 01:58:35.143120 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 01:58:35.145132 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 01:58:35.147204 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 01:58:35.147392 begin; [] gorptest: 01:58:35.147441 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 01:58:35.147582 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 01:58:35.148283 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 01:58:35.148418 commit; [] gorptest: 01:58:35.150175 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 01:58:35.150344 drop table if exists "invoice_test"; [] gorptest: 01:58:35.153995 drop table if exists "invoice_tag_test"; [] gorptest: 01:58:35.162252 drop table if exists "alias_trans_field_test"; [] gorptest: 01:58:35.164632 drop table if exists "invoice_override_test"; [] gorptest: 01:58:35.166713 drop table if exists "person_test"; [] gorptest: 01:58:35.168495 drop table if exists "ignored_column_test"; [] gorptest: 01:58:35.171416 drop table if exists "id_created_test"; [] gorptest: 01:58:35.173328 drop table if exists "type_conv_test"; [] gorptest: 01:58:35.175768 drop table if exists "embedded_struct_test"; [] gorptest: 01:58:35.177749 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 01:58:35.180163 drop table if exists "embedded_autoincr_test"; [] gorptest: 01:58:35.184808 drop table if exists "time_test"; [] gorptest: 01:58:35.187084 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.08s) PASS ok gopkg.in/gorp.v1 2.140s 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_i386.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: user script /srv/workspace/pbuilder/50239/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/50239/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/50239 and its subdirectories I: Current time: Mon Jun 24 15:58:42 +14 2024 I: pbuilder-time-stamp: 1719194322