I: pbuilder: network access will be disabled during build I: Current time: Mon May 22 14:45:41 +14 2023 I: pbuilder-time-stamp: 1684716341 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bookworm-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: Signature made Mon Apr 20 04:59:56 2020 +14 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify inline signature for ./golang-gopkg-gorp.v1_1.7.2-2.dsc: no acceptable signature found dpkg-source: info: extracting golang-gopkg-gorp.v1 in golang-gopkg-gorp.v1-1.7.2 dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2.orig.tar.xz dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/740268/tmp/hooks/D01_modify_environment starting debug: Running on ionos1-amd64. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 May 22 14:45 /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/740268/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/740268/tmp/hooks/D02_print_environment starting I: set BASH=/bin/sh BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath BASH_ALIASES=() BASH_ARGC=() BASH_ARGV=() BASH_CMDS=() BASH_LINENO=([0]="12" [1]="0") BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") BASH_VERSINFO=([0]="5" [1]="2" [2]="15" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") BASH_VERSION='5.2.15(1)-release' BUILDDIR=/build BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' BUILDUSERNAME=pbuilder2 BUILD_ARCH=amd64 DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=15 ' DIRSTACK=() DISTRIBUTION=bookworm EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=x86_64 HOST_ARCH=amd64 IFS=' ' INVOCATION_ID=62b113739b1747008ef5ecadb11fdd81 LANG=C LANGUAGE=et_EE:et LC_ALL=C MACHTYPE=x86_64-pc-linux-gnu MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnu PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path PBCURRENTCOMMANDLINEOPERATION=build PBUILDER_OPERATION=build PBUILDER_PKGDATADIR=/usr/share/pbuilder PBUILDER_PKGLIBDIR=/usr/lib/pbuilder PBUILDER_SYSCONFDIR=/etc PIPESTATUS=([0]="0") POSIXLY_CORRECT=y PPID=740268 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.SPYXWPub/pbuilderrc_OAVO --distribution bookworm --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.SPYXWPub/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=110 SUDO_UID=105 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://78.137.99.97:3128 I: uname -a Linux i-capture-the-hostname 5.10.0-23-amd64 #1 SMP Debian 5.10.179-1 (2023-05-12) x86_64 GNU/Linux I: ls -l /bin total 5632 -rwxr-xr-x 1 root root 1265648 Apr 24 11:23 bash -rwxr-xr-x 3 root root 39224 Sep 19 2022 bunzip2 -rwxr-xr-x 3 root root 39224 Sep 19 2022 bzcat lrwxrwxrwx 1 root root 6 Sep 19 2022 bzcmp -> bzdiff -rwxr-xr-x 1 root root 2225 Sep 19 2022 bzdiff lrwxrwxrwx 1 root root 6 Sep 19 2022 bzegrep -> bzgrep -rwxr-xr-x 1 root root 4893 Nov 28 2021 bzexe lrwxrwxrwx 1 root root 6 Sep 19 2022 bzfgrep -> bzgrep -rwxr-xr-x 1 root root 3775 Sep 19 2022 bzgrep -rwxr-xr-x 3 root root 39224 Sep 19 2022 bzip2 -rwxr-xr-x 1 root root 14568 Sep 19 2022 bzip2recover lrwxrwxrwx 1 root root 6 Sep 19 2022 bzless -> bzmore -rwxr-xr-x 1 root root 1297 Sep 19 2022 bzmore -rwxr-xr-x 1 root root 44016 Sep 21 2022 cat -rwxr-xr-x 1 root root 68656 Sep 21 2022 chgrp -rwxr-xr-x 1 root root 64496 Sep 21 2022 chmod -rwxr-xr-x 1 root root 72752 Sep 21 2022 chown -rwxr-xr-x 1 root root 151152 Sep 21 2022 cp -rwxr-xr-x 1 root root 125640 Jan 6 03:20 dash -rwxr-xr-x 1 root root 121904 Sep 21 2022 date -rwxr-xr-x 1 root root 89240 Sep 21 2022 dd -rwxr-xr-x 1 root root 102200 Sep 21 2022 df -rwxr-xr-x 1 root root 151344 Sep 21 2022 dir -rwxr-xr-x 1 root root 88656 Mar 24 00:02 dmesg lrwxrwxrwx 1 root root 8 Dec 20 03:33 dnsdomainname -> hostname lrwxrwxrwx 1 root root 8 Dec 20 03:33 domainname -> hostname -rwxr-xr-x 1 root root 43856 Sep 21 2022 echo -rwxr-xr-x 1 root root 41 Jan 25 04:43 egrep -rwxr-xr-x 1 root root 35664 Sep 21 2022 false -rwxr-xr-x 1 root root 41 Jan 25 04:43 fgrep -rwxr-xr-x 1 root root 85600 Mar 24 00:02 findmnt -rwsr-xr-x 1 root root 35128 Mar 23 22:35 fusermount -rwxr-xr-x 1 root root 203152 Jan 25 04:43 grep -rwxr-xr-x 2 root root 2346 Apr 10 2022 gunzip -rwxr-xr-x 1 root root 6447 Apr 10 2022 gzexe -rwxr-xr-x 1 root root 98136 Apr 10 2022 gzip -rwxr-xr-x 1 root root 22680 Dec 20 03:33 hostname -rwxr-xr-x 1 root root 72824 Sep 21 2022 ln -rwxr-xr-x 1 root root 53024 Mar 24 02:40 login -rwxr-xr-x 1 root root 151344 Sep 21 2022 ls -rwxr-xr-x 1 root root 207168 Mar 24 00:02 lsblk -rwxr-xr-x 1 root root 97552 Sep 21 2022 mkdir -rwxr-xr-x 1 root root 72912 Sep 21 2022 mknod -rwxr-xr-x 1 root root 43952 Sep 21 2022 mktemp -rwxr-xr-x 1 root root 59712 Mar 24 00:02 more -rwsr-xr-x 1 root root 59704 Mar 24 00:02 mount -rwxr-xr-x 1 root root 18744 Mar 24 00:02 mountpoint -rwxr-xr-x 1 root root 142968 Sep 21 2022 mv lrwxrwxrwx 1 root root 8 Dec 20 03:33 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 3 20:25 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 43952 Sep 21 2022 pwd lrwxrwxrwx 1 root root 4 Apr 24 11:23 rbash -> bash -rwxr-xr-x 1 root root 52112 Sep 21 2022 readlink -rwxr-xr-x 1 root root 72752 Sep 21 2022 rm -rwxr-xr-x 1 root root 56240 Sep 21 2022 rmdir -rwxr-xr-x 1 root root 27560 Nov 3 2022 run-parts -rwxr-xr-x 1 root root 126424 Jan 6 09:55 sed lrwxrwxrwx 1 root root 9 May 22 14:45 sh -> /bin/bash -rwxr-xr-x 1 root root 43888 Sep 21 2022 sleep -rwxr-xr-x 1 root root 85008 Sep 21 2022 stty -rwsr-xr-x 1 root root 72000 Mar 24 00:02 su -rwxr-xr-x 1 root root 39824 Sep 21 2022 sync -rwxr-xr-x 1 root root 531984 Apr 7 04:25 tar -rwxr-xr-x 1 root root 14520 Nov 3 2022 tempfile -rwxr-xr-x 1 root root 109616 Sep 21 2022 touch -rwxr-xr-x 1 root root 35664 Sep 21 2022 true -rwxr-xr-x 1 root root 14568 Mar 23 22:35 ulockmgr_server -rwsr-xr-x 1 root root 35128 Mar 24 00:02 umount -rwxr-xr-x 1 root root 43888 Sep 21 2022 uname -rwxr-xr-x 2 root root 2346 Apr 10 2022 uncompress -rwxr-xr-x 1 root root 151344 Sep 21 2022 vdir -rwxr-xr-x 1 root root 72024 Mar 24 00:02 wdctl lrwxrwxrwx 1 root root 8 Dec 20 03:33 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Apr 10 2022 zcat -rwxr-xr-x 1 root root 1678 Apr 10 2022 zcmp -rwxr-xr-x 1 root root 6460 Apr 10 2022 zdiff -rwxr-xr-x 1 root root 29 Apr 10 2022 zegrep -rwxr-xr-x 1 root root 29 Apr 10 2022 zfgrep -rwxr-xr-x 1 root root 2081 Apr 10 2022 zforce -rwxr-xr-x 1 root root 8103 Apr 10 2022 zgrep -rwxr-xr-x 1 root root 2206 Apr 10 2022 zless -rwxr-xr-x 1 root root 1842 Apr 10 2022 zmore -rwxr-xr-x 1 root root 4577 Apr 10 2022 znew I: user script /srv/workspace/pbuilder/740268/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19596 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.19-go{a} golang-1.19-src{a} golang-any{a} golang-github-davecgh-go-spew-dev{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-gorilla-securecookie-dev{a} golang-github-gorilla-sessions-dev{a} golang-github-hashicorp-go-uuid-dev{a} golang-github-jcmturner-aescts.v2-dev{a} golang-github-jcmturner-dnsutils.v2-dev{a} golang-github-jcmturner-gofork-dev{a} golang-github-jcmturner-goidentity.v6-dev{a} golang-github-jcmturner-gokrb5.v8-dev{a} golang-github-jcmturner-rpc.v2-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-pmezard-go-difflib-dev{a} golang-github-stretchr-objx-dev{a} golang-github-stretchr-testify-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-crypto-dev{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-term-dev{a} golang-golang-x-text-dev{a} golang-gopkg-yaml.v3-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsqlite3-dev{a} libsub-override-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 60 newly installed, 0 to remove and 0 not upgraded. Need to get 108 MB of archives. After unpacking 599 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bookworm/main amd64 sensible-utils all 0.0.17+nmu1 [19.0 kB] Get: 2 http://deb.debian.org/debian bookworm/main amd64 libmagic-mgc amd64 1:5.44-3 [305 kB] Get: 3 http://deb.debian.org/debian bookworm/main amd64 libmagic1 amd64 1:5.44-3 [104 kB] Get: 4 http://deb.debian.org/debian bookworm/main amd64 file amd64 1:5.44-3 [42.5 kB] Get: 5 http://deb.debian.org/debian bookworm/main amd64 gettext-base amd64 0.21-12 [160 kB] Get: 6 http://deb.debian.org/debian bookworm/main amd64 libuchardet0 amd64 0.0.7-1 [67.8 kB] Get: 7 http://deb.debian.org/debian bookworm/main amd64 groff-base amd64 1.22.4-10 [916 kB] Get: 8 http://deb.debian.org/debian bookworm/main amd64 bsdextrautils amd64 2.38.1-5+b1 [86.6 kB] Get: 9 http://deb.debian.org/debian bookworm/main amd64 libpipeline1 amd64 1.5.7-1 [38.5 kB] Get: 10 http://deb.debian.org/debian bookworm/main amd64 man-db amd64 2.11.2-2 [1386 kB] Get: 11 http://deb.debian.org/debian bookworm/main amd64 m4 amd64 1.4.19-3 [287 kB] Get: 12 http://deb.debian.org/debian bookworm/main amd64 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian bookworm/main amd64 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian bookworm/main amd64 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian bookworm/main amd64 autopoint all 0.21-12 [495 kB] Get: 16 http://deb.debian.org/debian bookworm/main amd64 libdebhelper-perl all 13.11.4 [81.2 kB] Get: 17 http://deb.debian.org/debian bookworm/main amd64 libtool all 2.4.7-5 [517 kB] Get: 18 http://deb.debian.org/debian bookworm/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian bookworm/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian bookworm/main amd64 libsub-override-perl all 0.09-4 [9304 B] Get: 21 http://deb.debian.org/debian bookworm/main amd64 libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian bookworm/main amd64 dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian bookworm/main amd64 libelf1 amd64 0.188-2.1 [174 kB] Get: 24 http://deb.debian.org/debian bookworm/main amd64 dwz amd64 0.15-1 [109 kB] Get: 25 http://deb.debian.org/debian bookworm/main amd64 libicu72 amd64 72.1-3 [9376 kB] Get: 26 http://deb.debian.org/debian bookworm/main amd64 libxml2 amd64 2.9.14+dfsg-1.2 [687 kB] Get: 27 http://deb.debian.org/debian bookworm/main amd64 gettext amd64 0.21-12 [1300 kB] Get: 28 http://deb.debian.org/debian bookworm/main amd64 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian bookworm/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian bookworm/main amd64 debhelper all 13.11.4 [942 kB] Get: 31 http://deb.debian.org/debian bookworm/main amd64 dh-golang all 1.59 [27.8 kB] Get: 32 http://deb.debian.org/debian bookworm/main amd64 golang-1.19-src all 1.19.8-2 [18.3 MB] Get: 33 http://deb.debian.org/debian bookworm/main amd64 golang-1.19-go amd64 1.19.8-2 [62.7 MB] Get: 34 http://deb.debian.org/debian bookworm/main amd64 golang-src all 2:1.19~1 [5756 B] Get: 35 http://deb.debian.org/debian bookworm/main amd64 golang-go amd64 2:1.19~1 [45.0 kB] Get: 36 http://deb.debian.org/debian bookworm/main amd64 golang-any amd64 2:1.19~1 [5876 B] Get: 37 http://deb.debian.org/debian bookworm/main amd64 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian bookworm/main amd64 golang-github-go-sql-driver-mysql-dev all 1.5.0-2 [70.9 kB] Get: 39 http://deb.debian.org/debian bookworm/main amd64 golang-github-gorilla-securecookie-dev all 1.1.1-2 [12.2 kB] Get: 40 http://deb.debian.org/debian bookworm/main amd64 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian bookworm/main amd64 golang-github-hashicorp-go-uuid-dev all 1.0.2-2 [8480 B] Get: 42 http://deb.debian.org/debian bookworm/main amd64 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian bookworm/main amd64 golang-github-stretchr-objx-dev all 0.5.0-1 [25.5 kB] Get: 44 http://deb.debian.org/debian bookworm/main amd64 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian bookworm/main amd64 golang-github-stretchr-testify-dev all 1.8.1-1 [67.9 kB] Get: 46 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian bookworm/main amd64 golang-golang-x-sys-dev all 0.3.0-1 [393 kB] Get: 51 http://deb.debian.org/debian bookworm/main amd64 golang-golang-x-text-dev all 0.7.0-1 [3863 kB] Get: 52 http://deb.debian.org/debian bookworm/main amd64 golang-golang-x-net-dev all 1:0.7.0+dfsg-1 [731 kB] Get: 53 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 54 http://deb.debian.org/debian bookworm/main amd64 golang-golang-x-term-dev all 0.3.0-1 [14.6 kB] Get: 55 http://deb.debian.org/debian bookworm/main amd64 golang-golang-x-crypto-dev all 1:0.4.0-1 [1449 kB] Get: 56 http://deb.debian.org/debian bookworm/main amd64 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian bookworm/main amd64 golang-github-lib-pq-dev all 1.10.7-2 [84.1 kB] Get: 58 http://deb.debian.org/debian bookworm/main amd64 libsqlite3-dev amd64 3.40.1-2 [1025 kB] Get: 59 http://deb.debian.org/debian bookworm/main amd64 golang-github-mattn-go-sqlite3-dev amd64 1.14.16~ds1-1 [82.2 kB] Get: 60 http://deb.debian.org/debian bookworm/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 108 MB in 2s (65.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 ... 19596 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.17+nmu1_all.deb ... Unpacking sensible-utils (0.0.17+nmu1) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.44-3_amd64.deb ... Unpacking libmagic-mgc (1:5.44-3) ... Selecting previously unselected package libmagic1:amd64. Preparing to unpack .../02-libmagic1_1%3a5.44-3_amd64.deb ... Unpacking libmagic1:amd64 (1:5.44-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.44-3_amd64.deb ... Unpacking file (1:5.44-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-12_amd64.deb ... Unpacking gettext-base (0.21-12) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../05-libuchardet0_0.0.7-1_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.22.4-10_amd64.deb ... Unpacking groff-base (1.22.4-10) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.38.1-5+b1_amd64.deb ... Unpacking bsdextrautils (2.38.1-5+b1) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../08-libpipeline1_1.5.7-1_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.7-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.11.2-2_amd64.deb ... Unpacking man-db (2.11.2-2) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-3_amd64.deb ... Unpacking m4 (1.4.19-3) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.71-3_all.deb ... Unpacking autoconf (2.71-3) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20220109.1_all.deb ... Unpacking autotools-dev (20220109.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.16.5-1.3_all.deb ... Unpacking automake (1:1.16.5-1.3) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.21-12_all.deb ... Unpacking autopoint (0.21-12) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.11.4_all.deb ... Unpacking libdebhelper-perl (13.11.4) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.4.7-5_all.deb ... Unpacking libtool (2.4.7-5) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../19-libsub-override-perl_0.09-4_all.deb ... Unpacking libsub-override-perl (0.09-4) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../20-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../21-dh-strip-nondeterminism_1.13.1-1_all.deb ... Unpacking dh-strip-nondeterminism (1.13.1-1) ... Selecting previously unselected package libelf1:amd64. Preparing to unpack .../22-libelf1_0.188-2.1_amd64.deb ... Unpacking libelf1:amd64 (0.188-2.1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1_amd64.deb ... Unpacking dwz (0.15-1) ... Selecting previously unselected package libicu72:amd64. Preparing to unpack .../24-libicu72_72.1-3_amd64.deb ... Unpacking libicu72:amd64 (72.1-3) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.2_amd64.deb ... Unpacking libxml2:amd64 (2.9.14+dfsg-1.2) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-12_amd64.deb ... Unpacking gettext (0.21-12) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../27-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../28-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../29-debhelper_13.11.4_all.deb ... Unpacking debhelper (13.11.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../30-dh-golang_1.59_all.deb ... Unpacking dh-golang (1.59) ... Selecting previously unselected package golang-1.19-src. Preparing to unpack .../31-golang-1.19-src_1.19.8-2_all.deb ... Unpacking golang-1.19-src (1.19.8-2) ... Selecting previously unselected package golang-1.19-go. Preparing to unpack .../32-golang-1.19-go_1.19.8-2_amd64.deb ... Unpacking golang-1.19-go (1.19.8-2) ... Selecting previously unselected package golang-src. Preparing to unpack .../33-golang-src_2%3a1.19~1_all.deb ... Unpacking golang-src (2:1.19~1) ... Selecting previously unselected package golang-go:amd64. Preparing to unpack .../34-golang-go_2%3a1.19~1_amd64.deb ... Unpacking golang-go:amd64 (2:1.19~1) ... Selecting previously unselected package golang-any:amd64. Preparing to unpack .../35-golang-any_2%3a1.19~1_amd64.deb ... Unpacking golang-any:amd64 (2:1.19~1) ... Selecting previously unselected package golang-github-davecgh-go-spew-dev. Preparing to unpack .../36-golang-github-davecgh-go-spew-dev_1.1.1-3_all.deb ... Unpacking golang-github-davecgh-go-spew-dev (1.1.1-3) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../37-golang-github-go-sql-driver-mysql-dev_1.5.0-2_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-2) ... Selecting previously unselected package golang-github-gorilla-securecookie-dev. Preparing to unpack .../38-golang-github-gorilla-securecookie-dev_1.1.1-2_all.deb ... Unpacking golang-github-gorilla-securecookie-dev (1.1.1-2) ... Selecting previously unselected package golang-github-gorilla-sessions-dev. Preparing to unpack .../39-golang-github-gorilla-sessions-dev_1.2.1-1_all.deb ... Unpacking golang-github-gorilla-sessions-dev (1.2.1-1) ... Selecting previously unselected package golang-github-hashicorp-go-uuid-dev. Preparing to unpack .../40-golang-github-hashicorp-go-uuid-dev_1.0.2-2_all.deb ... Unpacking golang-github-hashicorp-go-uuid-dev (1.0.2-2) ... Selecting previously unselected package golang-github-pmezard-go-difflib-dev. Preparing to unpack .../41-golang-github-pmezard-go-difflib-dev_1.0.0-3_all.deb ... Unpacking golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Selecting previously unselected package golang-github-stretchr-objx-dev. Preparing to unpack .../42-golang-github-stretchr-objx-dev_0.5.0-1_all.deb ... Unpacking golang-github-stretchr-objx-dev (0.5.0-1) ... Selecting previously unselected package golang-gopkg-yaml.v3-dev. Preparing to unpack .../43-golang-gopkg-yaml.v3-dev_3.0.1-3_all.deb ... Unpacking golang-gopkg-yaml.v3-dev (3.0.1-3) ... Selecting previously unselected package golang-github-stretchr-testify-dev. Preparing to unpack .../44-golang-github-stretchr-testify-dev_1.8.1-1_all.deb ... Unpacking golang-github-stretchr-testify-dev (1.8.1-1) ... Selecting previously unselected package golang-github-jcmturner-aescts.v2-dev. Preparing to unpack .../45-golang-github-jcmturner-aescts.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-dnsutils.v2-dev. Preparing to unpack .../46-golang-github-jcmturner-dnsutils.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-gofork-dev. Preparing to unpack .../47-golang-github-jcmturner-gofork-dev_1.0.0-4_all.deb ... Unpacking golang-github-jcmturner-gofork-dev (1.0.0-4) ... Selecting previously unselected package golang-github-jcmturner-goidentity.v6-dev. Preparing to unpack .../48-golang-github-jcmturner-goidentity.v6-dev_6.0.1-2_all.deb ... Unpacking golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../49-golang-golang-x-sys-dev_0.3.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.3.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../50-golang-golang-x-text-dev_0.7.0-1_all.deb ... Unpacking golang-golang-x-text-dev (0.7.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../51-golang-golang-x-net-dev_1%3a0.7.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.7.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../52-golang-github-jcmturner-rpc.v2-dev_2.0.3-2_all.deb ... Unpacking golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../53-golang-golang-x-term-dev_0.3.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.3.0-1) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../54-golang-golang-x-crypto-dev_1%3a0.4.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.4.0-1) ... Selecting previously unselected package golang-github-jcmturner-gokrb5.v8-dev. Preparing to unpack .../55-golang-github-jcmturner-gokrb5.v8-dev_8.4.3-2_all.deb ... Unpacking golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../56-golang-github-lib-pq-dev_1.10.7-2_all.deb ... Unpacking golang-github-lib-pq-dev (1.10.7-2) ... Selecting previously unselected package libsqlite3-dev:amd64. Preparing to unpack .../57-libsqlite3-dev_3.40.1-2_amd64.deb ... Unpacking libsqlite3-dev:amd64 (3.40.1-2) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:amd64. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.16~ds1-1_amd64.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:amd64 (1.14.16~ds1-1) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../59-golang-github-ziutek-mymysql-dev_1.5.4+git20170206.23.0582bcf-2_all.deb ... Unpacking golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libpipeline1:amd64 (1.5.7-1) ... Setting up golang-github-jcmturner-gofork-dev (1.0.0-4) ... Setting up golang-github-hashicorp-go-uuid-dev (1.0.2-2) ... Setting up libicu72:amd64 (72.1-3) ... Setting up bsdextrautils (2.38.1-5+b1) ... Setting up golang-github-stretchr-objx-dev (0.5.0-1) ... Setting up libmagic-mgc (1:5.44-3) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up golang-gopkg-yaml.v3-dev (3.0.1-3) ... Setting up libdebhelper-perl (13.11.4) ... Setting up golang-golang-x-sys-dev (0.3.0-1) ... Setting up libmagic1:amd64 (1:5.44-3) ... Setting up golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Setting up gettext-base (0.21-12) ... Setting up golang-1.19-src (1.19.8-2) ... Setting up m4 (1.4.19-3) ... Setting up golang-golang-x-term-dev (0.3.0-1) ... Setting up file (1:5.44-3) ... Setting up golang-github-davecgh-go-spew-dev (1.1.1-3) ... Setting up autotools-dev (20220109.1) ... Setting up libsqlite3-dev:amd64 (3.40.1-2) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up golang-github-stretchr-testify-dev (1.8.1-1) ... Setting up golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Setting up autopoint (0.21-12) ... Setting up autoconf (2.71-3) ... Setting up sensible-utils (0.0.17+nmu1) ... Setting up golang-golang-x-text-dev (0.7.0-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-2) ... Setting up libuchardet0:amd64 (0.0.7-1) ... Setting up libsub-override-perl (0.09-4) ... Setting up golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Setting up golang-src (2:1.19~1) ... Setting up libelf1:amd64 (0.188-2.1) ... Setting up golang-github-gorilla-securecookie-dev (1.1.1-2) ... Setting up libxml2:amd64 (2.9.14+dfsg-1.2) ... Setting up golang-github-gorilla-sessions-dev (1.2.1-1) ... Setting up golang-1.19-go (1.19.8-2) ... Setting up automake (1:1.16.5-1.3) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... Setting up gettext (0.21-12) ... Setting up golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Setting up libtool (2.4.7-5) ... Setting up golang-go:amd64 (2:1.19~1) ... Setting up golang-any:amd64 (2:1.19~1) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:amd64 (1.14.16~ds1-1) ... Setting up golang-golang-x-net-dev (1:0.7.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.13.1-1) ... Setting up dwz (0.15-1) ... Setting up groff-base (1.22.4-10) ... Setting up golang-golang-x-crypto-dev (1:0.4.0-1) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Setting up man-db (2.11.2-2) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.11.4) ... Setting up golang-github-lib-pq-dev (1.10.7-2) ... Setting up dh-golang (1.59) ... Processing triggers for libc-bin (2.36-9) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps Reading package lists... Building dependency tree... Reading state information... usrmerge is already the newest version (35). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. I: Building the package I: user script /srv/workspace/pbuilder/740268/tmp/hooks/A99_set_merged_usr starting Re-configuring usrmerge... removed '/etc/unsupported-skip-usrmerge-conversion' The system has been successfully converted. I: user script /srv/workspace/pbuilder/740268/tmp/hooks/A99_set_merged_usr finished hostname: Name or service not known I: Running cd /build/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 15 gopkg.in/gorp.v1 internal/goarch internal/unsafeheader internal/goos internal/cpu unicode/utf8 internal/race runtime/internal/syscall runtime/internal/atomic internal/goexperiment math/bits unicode internal/abi runtime/internal/math runtime/internal/sys sync/atomic internal/itoa internal/bytealg math runtime internal/reflectlite sync internal/testlog errors sort io internal/oserror strconv internal/safefilepath path syscall bytes strings reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context io/fs internal/poll internal/fmtsort os fmt database/sql/driver log database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 15 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.914850 drop table if exists "invoice_test"; [] gorptest: 14:46:37.916918 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.917004 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.917075 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.917126 drop table if exists "person_test"; [] gorptest: 14:46:37.917172 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.917213 drop table if exists "id_created_test"; [] gorptest: 14:46:37.917257 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.917312 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.917360 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.917423 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.917468 drop table if exists "time_test"; [] gorptest: 14:46:37.917566 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.918197 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: 14:46:37.918519 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.918865 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.919367 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.919714 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.920087 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.920451 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.920780 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.921104 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.921441 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.921795 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.922141 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: 14:46:37.922241 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: 14:46:37.922316 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.922381 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: 14:46:37.922453 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: 14:46:37.922518 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.922574 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.922657 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.922731 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.922823 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.922895 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: 14:46:37.922959 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.923054 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 14:46:37.923117 drop table if exists "invoice_test"; [] gorptest: 14:46:37.923677 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.923993 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.924324 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.924904 drop table if exists "person_test"; [] gorptest: 14:46:37.925233 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.925553 drop table if exists "id_created_test"; [] gorptest: 14:46:37.925866 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.926179 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.926484 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.926808 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.927098 drop table if exists "time_test"; [] gorptest: 14:46:37.927596 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.928056 drop table if exists "invoice_test"; [] gorptest: 14:46:37.928490 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.928581 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.928641 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.928716 drop table if exists "person_test"; [] gorptest: 14:46:37.928773 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.928830 drop table if exists "id_created_test"; [] gorptest: 14:46:37.928878 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.928936 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.928985 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.929041 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.929113 drop table if exists "time_test"; [] gorptest: 14:46:37.929206 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.929693 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: 14:46:37.930044 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.930403 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.930846 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.931345 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.931841 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.932175 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.932504 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.932834 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.933124 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.933444 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.933783 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: 14:46:37.933907 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: 14:46:37.933982 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.934050 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: 14:46:37.934112 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: 14:46:37.934200 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.934266 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.934338 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.934422 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.934501 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.934594 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: 14:46:37.934661 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.934705 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 14:46:37.934807 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716397934782063 2:1684716397934782063 3:"Bob" 4:"Smith" 5:1] gorptest: 14:46:37.935125 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 14:46:37.935488 delete from "invoice_test"; [] gorptest: 14:46:37.935729 delete from "invoice_tag_test"; [] gorptest: 14:46:37.935891 delete from "alias_trans_field_test"; [] gorptest: 14:46:37.936049 delete from "invoice_override_test"; [] gorptest: 14:46:37.936217 delete from "person_test"; [] gorptest: 14:46:37.936360 delete from "ignored_column_test"; [] gorptest: 14:46:37.936510 delete from "id_created_test"; [] gorptest: 14:46:37.936672 delete from "type_conv_test"; [] gorptest: 14:46:37.936835 delete from "embedded_struct_test"; [] gorptest: 14:46:37.936983 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.937141 delete from "embedded_autoincr_test"; [] gorptest: 14:46:37.937295 delete from "time_test"; [] gorptest: 14:46:37.937464 delete from "id_created_test"; [] gorptest: 14:46:37.937674 SELECT * FROM person_test [] gorptest: 14:46:37.937919 SELECT * FROM invoice_test [] gorptest: 14:46:37.938050 drop table if exists "invoice_test"; [] gorptest: 14:46:37.938404 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.938694 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.939008 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.939535 drop table if exists "person_test"; [] gorptest: 14:46:37.939856 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.940152 drop table if exists "id_created_test"; [] gorptest: 14:46:37.940494 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.940843 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.941190 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.941532 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.941921 drop table if exists "time_test"; [] gorptest: 14:46:37.942244 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType gorptest: 14:46:37.942546 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 14:46:37.943349 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-05-22 14:46:37 +1400 +14] gorptest: 14:46:37.943616 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 14:46:37.943799 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey gorptest: 14:46:37.944321 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 14:46:37.945030 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 14:46:37.945399 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 14:46:37.945778 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 14:46:37.946069 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 14:46:37.946345 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 14:46:37.946605 drop table if exists "PersonUInt64"; [] gorptest: 14:46:37.946976 drop table if exists "PersonUInt32"; [] gorptest: 14:46:37.947348 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether gorptest: 14:46:37.947835 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 14:46:37.948639 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 14:46:37.948877 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 14:46:37.949020 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 14:46:37.949133 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 14:46:37.949394 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser gorptest: 14:46:37.950283 drop table if exists PersistentUser [] gorptest: 14:46:37.950728 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 14:46:37.951189 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 14:46:37.951460 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 14:46:37.951611 select * from PersistentUser [] gorptest: 14:46:37.951831 select * from PersistentUser [] gorptest: 14:46:37.952012 select * from PersistentUser [] gorptest: 14:46:37.952174 select Id from PersistentUser [] gorptest: 14:46:37.952320 select mykey from PersistentUser [] gorptest: 14:46:37.952422 select PassedTraining from PersistentUser [] gorptest: 14:46:37.952535 select Id from PersistentUser [] gorptest: 14:46:37.952649 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap gorptest: 14:46:37.953185 drop table if exists PersistentUser [] gorptest: 14:46:37.953575 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 14:46:37.953965 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 14:46:37.954190 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 14:46:37.954430 select * from PersistentUser where mykey = ? [1:43] gorptest: 14:46:37.954572 select * from PersistentUser where mykey = ? [1:43] gorptest: 14:46:37.954722 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 14:46:37.954873 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 14:46:37.955021 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct gorptest: 14:46:37.955608 drop table if exists PersistentUser [] gorptest: 14:46:37.956054 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 14:46:37.956423 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 14:46:37.956686 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 14:46:37.956992 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 14:46:37.957218 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.957782 drop table if exists "invoice_test"; [] gorptest: 14:46:37.958113 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.958205 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.958262 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.958307 drop table if exists "person_test"; [] gorptest: 14:46:37.958361 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.958413 drop table if exists "id_created_test"; [] gorptest: 14:46:37.958503 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.958563 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.958613 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.958661 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.958715 drop table if exists "time_test"; [] gorptest: 14:46:37.958808 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.959222 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: 14:46:37.959585 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.959938 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.960365 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.960689 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.961053 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.961439 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.961800 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.962059 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.962307 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.962585 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.962847 select * from invoice_test where id=99999 [] gorptest: 14:46:37.962991 select * from invoice_test where id=99999 [] gorptest: 14:46:37.963086 drop table if exists "invoice_test"; [] gorptest: 14:46:37.963356 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.963599 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.963825 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.964203 drop table if exists "person_test"; [] gorptest: 14:46:37.964443 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.964637 drop table if exists "id_created_test"; [] gorptest: 14:46:37.964879 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.965089 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.965304 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.965594 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.965875 drop table if exists "time_test"; [] gorptest: 14:46:37.966109 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol gorptest: 14:46:37.966367 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 14:46:37.967060 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: 14:46:37.967267 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.967914 drop table if exists "invoice_test"; [] gorptest: 14:46:37.968233 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.968290 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.968335 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.968385 drop table if exists "person_test"; [] gorptest: 14:46:37.968422 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.968489 drop table if exists "id_created_test"; [] gorptest: 14:46:37.968553 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.968604 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.968647 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.968693 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.968729 drop table if exists "time_test"; [] gorptest: 14:46:37.968787 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.969185 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: 14:46:37.969565 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.969827 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.970109 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.970389 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.970659 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.970933 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.971263 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.971526 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.971844 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.972131 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.972374 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716397972351086 2:1684716397972351086 3:"Bob" 4:"Smith" 5:1] gorptest: 14:46:37.972578 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:37.972717 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1684716397972351086 2:1684716397972351086 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 14:46:37.972907 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1684716397972351086 2:1684716397972351086 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 14:46:37.973010 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:37.973115 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 14:46:37.973183 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:37.973305 drop table if exists "invoice_test"; [] gorptest: 14:46:37.973531 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.973757 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.973975 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.974318 drop table if exists "person_test"; [] gorptest: 14:46:37.974543 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.974736 drop table if exists "id_created_test"; [] gorptest: 14:46:37.974944 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.975260 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.975550 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.975823 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.976061 drop table if exists "time_test"; [] gorptest: 14:46:37.976273 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.01s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 14:46:37.976597 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 14:46:37.977147 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 14:46:37.977291 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 14:46:37.977444 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: 14:46:37.977681 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 14:46:37.977804 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps gorptest: 14:46:37.978125 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 14:46:37.978632 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 14:46:37.978835 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 14:46:37.978934 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 14:46:37.979021 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 14:46:37.979099 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.979993 drop table if exists "invoice_test"; [] gorptest: 14:46:37.980271 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.980321 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.980359 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.980404 drop table if exists "person_test"; [] gorptest: 14:46:37.980441 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.980478 drop table if exists "id_created_test"; [] gorptest: 14:46:37.980522 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.980559 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.980596 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.980658 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.980708 drop table if exists "time_test"; [] gorptest: 14:46:37.980754 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.981070 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: 14:46:37.981398 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.981751 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.982012 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.982255 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.982488 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.982720 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.982957 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.983246 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.983610 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.983938 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.984261 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716397984236778 2:1684716397984236778 3:"bob" 4:"smith" 5:1] gorptest: 14:46:37.984482 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 14:46:37.984689 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 14:46:37.984851 drop table if exists "invoice_test"; [] gorptest: 14:46:37.985224 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.985575 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.985924 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.986406 drop table if exists "person_test"; [] gorptest: 14:46:37.986833 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.987229 drop table if exists "id_created_test"; [] gorptest: 14:46:37.987510 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.987756 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.988024 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.988300 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.988565 drop table if exists "time_test"; [] gorptest: 14:46:37.988858 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.01s) === RUN TestHooks 2023/05/22 14:46:37 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:37.989275 drop table if exists "invoice_test"; [] gorptest: 14:46:37.989684 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.989743 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.989797 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.989842 drop table if exists "person_test"; [] gorptest: 14:46:37.989940 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.989989 drop table if exists "id_created_test"; [] gorptest: 14:46:37.990045 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.990091 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.990141 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.990186 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.990238 drop table if exists "time_test"; [] gorptest: 14:46:37.990316 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.990791 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: 14:46:37.991212 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:37.991600 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:37.992067 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:37.992457 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.992750 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:37.993034 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:37.993317 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:37.993659 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:37.993973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:37.994284 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:37.994614 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716397994585963 2:1684716397994585963 3:"bob" 4:"smith" 5:1] gorptest: 14:46:37.994865 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:37.995050 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1684716397994585963 2:1684716397994585963 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 14:46:37.995714 select * from person_test where id = ? [1:1] gorptest: 14:46:37.995911 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 14:46:37.996124 drop table if exists "invoice_test"; [] gorptest: 14:46:37.996464 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:37.996796 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:37.997115 drop table if exists "invoice_override_test"; [] gorptest: 14:46:37.997553 drop table if exists "person_test"; [] gorptest: 14:46:37.997846 drop table if exists "ignored_column_test"; [] gorptest: 14:46:37.998093 drop table if exists "id_created_test"; [] gorptest: 14:46:37.998354 drop table if exists "type_conv_test"; [] gorptest: 14:46:37.998617 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:37.998877 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:37.999146 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:37.999450 drop table if exists "time_test"; [] gorptest: 14:46:37.999716 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.01s) === RUN TestTransaction 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.000080 drop table if exists "invoice_test"; [] gorptest: 14:46:38.000476 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.000590 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.000654 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.000733 drop table if exists "person_test"; [] gorptest: 14:46:38.000793 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.000846 drop table if exists "id_created_test"; [] gorptest: 14:46:38.000904 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.000956 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.001016 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.001071 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.001154 drop table if exists "time_test"; [] gorptest: 14:46:38.001222 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.001659 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: 14:46:38.002080 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.002421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.002765 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.003077 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.003387 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.003712 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.004018 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.004339 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.004647 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.004957 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.005234 begin; [] gorptest: 14:46:38.005360 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 14:46:38.005554 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 14:46:38.005621 commit; [] gorptest: 14:46:38.005738 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.005895 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 14:46:38.006065 drop table if exists "invoice_test"; [] gorptest: 14:46:38.006419 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.006745 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.007028 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.007572 drop table if exists "person_test"; [] gorptest: 14:46:38.007865 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.008133 drop table if exists "id_created_test"; [] gorptest: 14:46:38.008406 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.008667 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.008913 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.009185 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.009496 drop table if exists "time_test"; [] gorptest: 14:46:38.009774 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.01s) === RUN TestSavepoint 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.010136 drop table if exists "invoice_test"; [] gorptest: 14:46:38.010550 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.010615 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.010682 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.010742 drop table if exists "person_test"; [] gorptest: 14:46:38.010807 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.010863 drop table if exists "id_created_test"; [] gorptest: 14:46:38.010908 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.010961 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.011006 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.011059 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.011106 drop table if exists "time_test"; [] gorptest: 14:46:38.011235 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.011629 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: 14:46:38.011988 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.012278 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.012706 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.013053 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.013387 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.013743 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.014076 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.014338 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.014595 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.014838 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.015056 begin; [] gorptest: 14:46:38.015141 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 14:46:38.015431 select memo from invoice_test [] gorptest: 14:46:38.015528 savepoint "foo" [1:] gorptest: 14:46:38.015550 select memo from invoice_test [] gorptest: 14:46:38.015643 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 14:46:38.015711 select memo from invoice_test [] gorptest: 14:46:38.015758 rollback to savepoint "foo" [1:] gorptest: 14:46:38.015777 select memo from invoice_test [] gorptest: 14:46:38.015808 rollback; [] gorptest: 14:46:38.015907 drop table if exists "invoice_test"; [] gorptest: 14:46:38.016116 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.016327 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.016553 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.016874 drop table if exists "person_test"; [] gorptest: 14:46:38.017118 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.017328 drop table if exists "id_created_test"; [] gorptest: 14:46:38.017516 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.017748 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.017969 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.018201 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.018427 drop table if exists "time_test"; [] gorptest: 14:46:38.018659 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.01s) === RUN TestMultiple 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.018992 drop table if exists "invoice_test"; [] gorptest: 14:46:38.019382 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.019434 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.019492 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.019561 drop table if exists "person_test"; [] gorptest: 14:46:38.019612 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.019659 drop table if exists "id_created_test"; [] gorptest: 14:46:38.019697 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.019743 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.019781 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.019830 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.019867 drop table if exists "time_test"; [] gorptest: 14:46:38.019914 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.020248 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: 14:46:38.020520 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.020761 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.021042 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.021293 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.021509 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.021785 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.022019 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.022259 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.022508 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.022747 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.023015 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 14:46:38.023268 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 14:46:38.023474 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 14:46:38.023649 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 14:46:38.023797 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.023945 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 14:46:38.024091 drop table if exists "invoice_test"; [] gorptest: 14:46:38.024398 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.024648 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.024888 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.025291 drop table if exists "person_test"; [] gorptest: 14:46:38.025540 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.025771 drop table if exists "id_created_test"; [] gorptest: 14:46:38.025976 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.026182 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.026376 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.026600 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.026807 drop table if exists "time_test"; [] gorptest: 14:46:38.027007 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.01s) === RUN TestCrud 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.027399 drop table if exists "invoice_test"; [] gorptest: 14:46:38.027803 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.027881 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.027925 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.027958 drop table if exists "person_test"; [] gorptest: 14:46:38.027992 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.028030 drop table if exists "id_created_test"; [] gorptest: 14:46:38.028063 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.028095 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.028134 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.028166 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.028206 drop table if exists "time_test"; [] gorptest: 14:46:38.028250 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.028542 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: 14:46:38.028853 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.029111 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.029433 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.029740 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.030058 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.030306 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.030592 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.030812 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.031048 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.031494 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.031752 delete from invoice_test [] gorptest: 14:46:38.031893 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 14:46:38.032065 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.032212 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] gorptest: 14:46:38.032358 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.032446 select * from invoice_test [] gorptest: 14:46:38.032580 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.032714 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 14:46:38.032803 delete from invoice_tag_test [] gorptest: 14:46:38.032962 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: 14:46:38.033166 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 14:46:38.033288 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] gorptest: 14:46:38.033435 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 14:46:38.033524 select * from invoice_tag_test [] gorptest: 14:46:38.033659 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 14:46:38.033819 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 14:46:38.033901 delete from alias_trans_field_test [] gorptest: 14:46:38.034047 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 14:46:38.034210 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 14:46:38.034320 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 14:46:38.034475 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 14:46:38.034582 select * from alias_trans_field_test [] gorptest: 14:46:38.034674 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 14:46:38.034852 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 14:46:38.034922 drop table if exists "invoice_test"; [] gorptest: 14:46:38.035226 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.035497 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.035732 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.036118 drop table if exists "person_test"; [] gorptest: 14:46:38.036344 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.036541 drop table if exists "id_created_test"; [] gorptest: 14:46:38.036732 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.036944 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.037156 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.037350 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.037560 drop table if exists "time_test"; [] gorptest: 14:46:38.037755 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.01s) === RUN TestWithIgnoredColumn 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.038068 drop table if exists "invoice_test"; [] gorptest: 14:46:38.038339 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.038402 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.038443 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.038476 drop table if exists "person_test"; [] gorptest: 14:46:38.038508 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.038547 drop table if exists "id_created_test"; [] gorptest: 14:46:38.038580 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.038613 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.038645 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.038684 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.038716 drop table if exists "time_test"; [] gorptest: 14:46:38.038775 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.039040 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: 14:46:38.039680 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.040002 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.040441 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.040782 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.041059 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.041309 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.041584 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.041891 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.042134 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.042357 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.042586 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 14:46:38.042770 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 14:46:38.042865 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 14:46:38.043014 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 14:46:38.043082 drop table if exists "invoice_test"; [] gorptest: 14:46:38.043338 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.043572 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.043763 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.044130 drop table if exists "person_test"; [] gorptest: 14:46:38.044355 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.044580 drop table if exists "id_created_test"; [] gorptest: 14:46:38.044772 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.045045 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.045360 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.045683 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.045970 drop table if exists "time_test"; [] gorptest: 14:46:38.046325 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.01s) === RUN TestTypeConversionExample 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.046768 drop table if exists "invoice_test"; [] gorptest: 14:46:38.047227 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.047287 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.047344 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.047403 drop table if exists "person_test"; [] gorptest: 14:46:38.047450 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.047497 drop table if exists "id_created_test"; [] gorptest: 14:46:38.047534 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.047587 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.047634 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.047691 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.047760 drop table if exists "time_test"; [] gorptest: 14:46:38.047819 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.048210 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: 14:46:38.048516 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.048793 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.049155 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.049446 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.049772 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.050087 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.050437 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.050758 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.051150 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.051616 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.052049 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: 14:46:38.052270 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 14:46:38.052455 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: 14:46:38.052682 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 14:46:38.052803 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 14:46:38.052986 drop table if exists "invoice_test"; [] gorptest: 14:46:38.053269 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.053516 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.053818 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.054207 drop table if exists "person_test"; [] gorptest: 14:46:38.054495 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.054750 drop table if exists "id_created_test"; [] gorptest: 14:46:38.055047 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.055381 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.055698 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.056003 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.056341 drop table if exists "time_test"; [] gorptest: 14:46:38.056620 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.01s) === RUN TestWithEmbeddedStruct 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.056979 drop table if exists "invoice_test"; [] gorptest: 14:46:38.057303 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.057354 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.057419 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.057469 drop table if exists "person_test"; [] gorptest: 14:46:38.057521 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.057578 drop table if exists "id_created_test"; [] gorptest: 14:46:38.057632 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.057683 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.057738 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.057786 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.057867 drop table if exists "time_test"; [] gorptest: 14:46:38.057926 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.058278 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: 14:46:38.058586 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.058883 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.059273 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.059578 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.059878 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.060203 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.060583 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.060910 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.061265 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.061585 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.061973 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 14:46:38.062187 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 14:46:38.062345 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 14:46:38.062568 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 14:46:38.062668 select * from embedded_struct_test [] gorptest: 14:46:38.062812 drop table if exists "invoice_test"; [] gorptest: 14:46:38.063085 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.063366 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.063663 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.064035 drop table if exists "person_test"; [] gorptest: 14:46:38.064304 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.064559 drop table if exists "id_created_test"; [] gorptest: 14:46:38.064802 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.065088 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.065409 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.065682 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.065972 drop table if exists "time_test"; [] gorptest: 14:46:38.066260 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.01s) === RUN TestWithEmbeddedStructBeforeAutoincr 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.066633 drop table if exists "invoice_test"; [] gorptest: 14:46:38.067007 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.067060 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.067115 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.067200 drop table if exists "person_test"; [] gorptest: 14:46:38.067246 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.067279 drop table if exists "id_created_test"; [] gorptest: 14:46:38.067313 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.067347 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.067385 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.067418 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.067451 drop table if exists "time_test"; [] gorptest: 14:46:38.067511 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.067782 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: 14:46:38.068032 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.068249 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.068522 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.068754 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.068985 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.069202 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.069417 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.069656 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.069895 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.070124 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.070424 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 14:46:38.070625 drop table if exists "invoice_test"; [] gorptest: 14:46:38.070840 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.071080 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.071383 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.071764 drop table if exists "person_test"; [] gorptest: 14:46:38.072019 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.072212 drop table if exists "id_created_test"; [] gorptest: 14:46:38.072423 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.072613 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.072804 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.073020 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.073229 drop table if exists "time_test"; [] gorptest: 14:46:38.073415 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.073634 drop table if exists "invoice_test"; [] gorptest: 14:46:38.073906 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.073950 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.073984 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.074023 drop table if exists "person_test"; [] gorptest: 14:46:38.074074 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.074116 drop table if exists "id_created_test"; [] gorptest: 14:46:38.074149 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.074182 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.074220 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.074253 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.074291 drop table if exists "time_test"; [] gorptest: 14:46:38.074331 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.074594 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: 14:46:38.074831 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.075083 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.075687 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.076044 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.076429 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.076760 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.077099 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.077383 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.077707 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.077964 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.078244 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 14:46:38.078417 drop table if exists "invoice_test"; [] gorptest: 14:46:38.078605 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.078813 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.079009 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.079378 drop table if exists "person_test"; [] gorptest: 14:46:38.079578 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.079785 drop table if exists "id_created_test"; [] gorptest: 14:46:38.080002 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.080220 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.080464 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.080695 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.080938 drop table if exists "time_test"; [] gorptest: 14:46:38.081151 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal gorptest: 14:46:38.081353 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 14:46:38.081942 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: 14:46:38.082089 select Int64 from TableWithNull where Str='abc' [] gorptest: 14:46:38.082167 select count(*) from TableWithNull [] gorptest: 14:46:38.082231 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 14:46:38.082291 select Int64 from TableWithNull where Str='notfound' [] gorptest: 14:46:38.082351 select Int64 from TableWithNull where Str='abc' [] gorptest: 14:46:38.082411 select Float64 from TableWithNull where Str='abc' [] gorptest: 14:46:38.082465 select min(Float64) from TableWithNull [] gorptest: 14:46:38.082531 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 14:46:38.082617 select Float64 from TableWithNull where Str='notfound' [] gorptest: 14:46:38.082670 select Float64 from TableWithNull where Str='abc' [] gorptest: 14:46:38.082733 select Str from TableWithNull where Int64=? [1:78] gorptest: 14:46:38.082810 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 14:46:38.082877 select Str from TableWithNull where Int64=? [1:78] gorptest: 14:46:38.082950 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 14:46:38.083015 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 14:46:38.083083 select Str from TableWithNull where Int64=? [1:78] gorptest: 14:46:38.083187 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.083542 drop table if exists "invoice_test"; [] gorptest: 14:46:38.083793 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.083837 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.083874 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.083917 drop table if exists "person_test"; [] gorptest: 14:46:38.083951 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.083983 drop table if exists "id_created_test"; [] gorptest: 14:46:38.084021 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.084053 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.084084 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.084118 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.084156 drop table if exists "time_test"; [] gorptest: 14:46:38.084194 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.084438 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: 14:46:38.084689 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.084908 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.085197 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.085481 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.085746 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.085995 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.086270 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.086525 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.086798 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.087024 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.087291 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398087273133 2:1684716398087273133 3:"Bob" 4:"Smith" 5:1] gorptest: 14:46:38.087491 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398087477781 2:1684716398087477781 3:"Jane" 4:"Smith" 5:1] gorptest: 14:46:38.087657 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398087646358 2:1684716398087646358 3:"Mike" 4:"Smith" 5:1] gorptest: 14:46:38.087826 drop table if exists "invoice_test"; [] gorptest: 14:46:38.088020 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.088230 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.088423 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.088742 drop table if exists "person_test"; [] gorptest: 14:46:38.088970 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.089161 drop table if exists "id_created_test"; [] gorptest: 14:46:38.089353 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.089564 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.089779 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.090085 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.090283 drop table if exists "time_test"; [] gorptest: 14:46:38.090504 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk gorptest: 14:46:38.090690 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 14:46:38.091413 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 14:46:38.091577 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.092236 drop table if exists "invoice_test"; [] gorptest: 14:46:38.092497 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.092541 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.092575 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.092614 drop table if exists "person_test"; [] gorptest: 14:46:38.092647 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.092701 drop table if exists "id_created_test"; [] gorptest: 14:46:38.092743 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.092775 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.092814 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.092847 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.092881 drop table if exists "time_test"; [] gorptest: 14:46:38.092927 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.093194 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: 14:46:38.093442 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.093661 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.093936 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.094159 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.094405 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.094620 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.094855 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.095137 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.095475 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.095733 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.096018 insert into "time_test" ("Id","Time") values (null,?); [1:2023-05-22 00:15:38.095995863 +0000 UTC] gorptest: 14:46:38.096211 insert into "time_test" ("Id","Time") values (null,?); [1:2023-05-22 00:16:39.095995863 +0000 UTC] gorptest: 14:46:38.096385 SELECT id FROM time_test WHERE Time < ? [1:2023-05-22 00:16:38.095995863 +0000 UTC] gorptest: 14:46:38.096501 drop table if exists "invoice_test"; [] gorptest: 14:46:38.096743 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.097004 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.097241 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.097555 drop table if exists "person_test"; [] gorptest: 14:46:38.097813 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.098078 drop table if exists "id_created_test"; [] gorptest: 14:46:38.098381 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.098629 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.098961 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.099271 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.099592 drop table if exists "time_test"; [] gorptest: 14:46:38.099911 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.100289 drop table if exists "invoice_test"; [] gorptest: 14:46:38.100685 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.100742 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.100802 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.100861 drop table if exists "person_test"; [] gorptest: 14:46:38.100912 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.100969 drop table if exists "id_created_test"; [] gorptest: 14:46:38.101019 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.101080 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.101134 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.101226 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.101303 drop table if exists "time_test"; [] gorptest: 14:46:38.101368 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.101826 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: 14:46:38.102163 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.102482 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.102856 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.103147 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.103475 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.103779 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.104157 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.104451 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.104763 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.105042 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.105384 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398105350887 2:1684716398105350887 3:"bob" 4:"smith" 5:1] gorptest: 14:46:38.105659 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 14:46:38.105893 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 14:46:38.106071 drop table if exists "invoice_test"; [] gorptest: 14:46:38.106389 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.106642 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.106911 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.107926 drop table if exists "person_test"; [] gorptest: 14:46:38.108302 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.108602 drop table if exists "id_created_test"; [] gorptest: 14:46:38.108963 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.109223 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.109474 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.109703 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.109951 drop table if exists "time_test"; [] gorptest: 14:46:38.110178 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.110541 drop table if exists "invoice_test"; [] gorptest: 14:46:38.110897 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.110960 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.111007 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.111061 drop table if exists "person_test"; [] gorptest: 14:46:38.111106 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.111186 drop table if exists "id_created_test"; [] gorptest: 14:46:38.111262 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.111315 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.111365 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.111405 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.111492 drop table if exists "time_test"; [] gorptest: 14:46:38.111634 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.112038 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: 14:46:38.112360 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.112649 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.113066 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.113402 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.113743 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.114060 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.114429 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.114757 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.115081 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.115376 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.118498 drop table if exists "invoice_test"; [] gorptest: 14:46:38.118801 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.118851 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.118889 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.118936 drop table if exists "person_test"; [] gorptest: 14:46:38.118973 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.119014 drop table if exists "id_created_test"; [] gorptest: 14:46:38.119054 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.119123 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.119191 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.119242 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.119289 drop table if exists "time_test"; [] gorptest: 14:46:38.119335 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.119634 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: 14:46:38.119918 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.120175 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.120490 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.120716 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.120950 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.121167 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.121398 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.121638 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.121907 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.122130 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.122360 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398122340319 2:1684716398122340319 3:"bob" 4:"smith" 5:1] gorptest: 14:46:38.122531 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398122521134 2:1684716398122521134 3:"jane" 4:"doe" 5:1] gorptest: 14:46:38.122718 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:38.122846 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 14:46:38.122956 select * from person_test where Id=? [1:1] gorptest: 14:46:38.123061 select * from person_test order by fname asc [] gorptest: 14:46:38.123253 drop table if exists "invoice_test"; [] gorptest: 14:46:38.123478 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.123716 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.123916 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.124238 drop table if exists "person_test"; [] gorptest: 14:46:38.124485 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.124702 drop table if exists "id_created_test"; [] gorptest: 14:46:38.124942 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.125158 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.125393 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.125609 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.125841 drop table if exists "time_test"; [] gorptest: 14:46:38.126054 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.01s) === RUN TestSelectSingleVal 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.126347 drop table if exists "invoice_test"; [] gorptest: 14:46:38.126623 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.126665 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.126700 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.126738 drop table if exists "person_test"; [] gorptest: 14:46:38.126770 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.126803 drop table if exists "id_created_test"; [] gorptest: 14:46:38.126864 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.126901 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.126941 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.126974 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.127009 drop table if exists "time_test"; [] gorptest: 14:46:38.127056 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.127585 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: 14:46:38.127816 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.128067 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.128348 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.128575 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.128810 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.129041 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.129261 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.129476 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.129738 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.130012 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.130281 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398130259230 2:1684716398130259230 3:"bob" 4:"smith" 5:1] gorptest: 14:46:38.130477 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 14:46:38.130623 select * from person_test where Id=? [1:1] gorptest: 14:46:38.130758 select FName from person_test where Id=? [1:1] gorptest: 14:46:38.130835 select * from person_test where Id=? [1:1] gorptest: 14:46:38.130956 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 14:46:38.131088 select * from person_test where Id=? [1:-2222] gorptest: 14:46:38.131267 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1684716398131251420 2:1684716398131251420 3:"bob" 4:"smith" 5:1] gorptest: 14:46:38.131474 select * from person_test where Fname='bob' [] gorptest: 14:46:38.131622 select * from person_test where Id=-123 [] gorptest: 14:46:38.131772 select * from person_test where Id=-123 [] gorptest: 14:46:38.131843 select * from person_test where Id=-123 [] gorptest: 14:46:38.131908 select * from person_test where Id=-123 [] gorptest: 14:46:38.131977 drop table if exists "invoice_test"; [] gorptest: 14:46:38.132179 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.132391 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.132582 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.132904 drop table if exists "person_test"; [] gorptest: 14:46:38.133154 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.133351 drop table if exists "id_created_test"; [] gorptest: 14:46:38.133540 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.133767 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.133994 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.134188 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.134415 drop table if exists "time_test"; [] gorptest: 14:46:38.134632 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.01s) === RUN TestSelectAlias 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.134902 drop table if exists "invoice_test"; [] gorptest: 14:46:38.135235 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.135279 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.135313 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.135365 drop table if exists "person_test"; [] gorptest: 14:46:38.135403 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.135440 drop table if exists "id_created_test"; [] gorptest: 14:46:38.135478 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.135523 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.135560 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.135598 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.135641 drop table if exists "time_test"; [] gorptest: 14:46:38.135687 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.135999 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: 14:46:38.136273 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.136544 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.136873 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.137186 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.137406 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.137645 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.137901 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.138153 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.138372 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.138614 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.138838 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 14:46:38.139000 select * from id_created_test where Id=1 [] gorptest: 14:46:38.139121 SELECT *, 1 AS external FROM id_created_test [] gorptest: 14:46:38.139268 drop table if exists "invoice_test"; [] gorptest: 14:46:38.139902 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.140116 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.140307 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.140662 drop table if exists "person_test"; [] gorptest: 14:46:38.140863 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.141079 drop table if exists "id_created_test"; [] gorptest: 14:46:38.141321 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.141560 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.141803 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.142017 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.142255 drop table if exists "time_test"; [] gorptest: 14:46:38.142474 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.142795 drop table if exists "invoice_test"; [] gorptest: 14:46:38.143052 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.143120 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.143441 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.143502 drop table if exists "person_test"; [] gorptest: 14:46:38.143538 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.143580 drop table if exists "id_created_test"; [] gorptest: 14:46:38.143616 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.143655 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.143688 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.143722 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.143760 drop table if exists "time_test"; [] gorptest: 14:46:38.143807 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.144123 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: 14:46:38.144374 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.144598 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.144888 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.145142 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.145373 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.145588 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.145829 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.146047 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.146285 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.146610 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.146957 drop table if exists "invoice_test"; [] gorptest: 14:46:38.147314 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.147649 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.147970 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.148441 drop table if exists "person_test"; [] gorptest: 14:46:38.148724 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.148975 drop table if exists "id_created_test"; [] gorptest: 14:46:38.149167 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.149378 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.149570 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.149779 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.149967 drop table if exists "time_test"; [] gorptest: 14:46:38.150178 drop table if exists "id_created_test"; [] gorptest: 14:46:38.150227 drop table if exists "single_column_table"; [] gorptest: 14:46:38.150273 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: 14:46:38.150525 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: 14:46:38.150770 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.150988 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: 14:46:38.151303 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: 14:46:38.151531 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.151800 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.152043 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.152292 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.152540 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.152832 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: 14:46:38.153090 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.153357 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 14:46:38.153415 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 14:46:38.153654 delete from "invoice_test"; [] gorptest: 14:46:38.153769 delete from "invoice_tag_test"; [] gorptest: 14:46:38.153895 delete from "alias_trans_field_test"; [] gorptest: 14:46:38.154006 delete from "invoice_override_test"; [] gorptest: 14:46:38.154147 delete from "person_test"; [] gorptest: 14:46:38.154257 delete from "ignored_column_test"; [] gorptest: 14:46:38.154366 delete from "id_created_test"; [] gorptest: 14:46:38.154491 delete from "type_conv_test"; [] gorptest: 14:46:38.154595 delete from "embedded_struct_test"; [] gorptest: 14:46:38.154721 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.154849 delete from "embedded_autoincr_test"; [] gorptest: 14:46:38.154960 delete from "time_test"; [] gorptest: 14:46:38.155089 delete from "id_created_test"; [] gorptest: 14:46:38.155229 delete from "single_column_table"; [] gorptest: 14:46:38.155389 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 14:46:38.155473 drop table if exists "invoice_test"; [] gorptest: 14:46:38.155672 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.155883 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.156070 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.156390 drop table if exists "person_test"; [] gorptest: 14:46:38.156613 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.156800 drop table if exists "id_created_test"; [] gorptest: 14:46:38.157005 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.157244 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.157486 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.157703 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.157912 drop table if exists "time_test"; [] gorptest: 14:46:38.158151 drop table if exists "id_created_test"; [] gorptest: 14:46:38.158210 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.02s) === RUN TestPrepare 2023/05/22 14:46:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 14:46:38.158830 drop table if exists "invoice_test"; [] gorptest: 14:46:38.159113 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.159180 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.159235 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.159283 drop table if exists "person_test"; [] gorptest: 14:46:38.159317 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.159379 drop table if exists "id_created_test"; [] gorptest: 14:46:38.159413 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.159449 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.159490 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.159534 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.159577 drop table if exists "time_test"; [] gorptest: 14:46:38.159619 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.159871 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: 14:46:38.160117 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 14:46:38.160333 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 14:46:38.160609 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 14:46:38.160851 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.161067 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 14:46:38.161321 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 14:46:38.161545 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 14:46:38.161803 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 14:46:38.162026 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 14:46:38.162268 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 14:46:38.162559 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 14:46:38.162760 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 14:46:38.162935 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 14:46:38.163120 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 14:46:38.163599 begin; [] gorptest: 14:46:38.163647 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 14:46:38.163749 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 14:46:38.164166 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 14:46:38.164291 commit; [] gorptest: 14:46:38.164371 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 14:46:38.164480 drop table if exists "invoice_test"; [] gorptest: 14:46:38.164788 drop table if exists "invoice_tag_test"; [] gorptest: 14:46:38.164983 drop table if exists "alias_trans_field_test"; [] gorptest: 14:46:38.165178 drop table if exists "invoice_override_test"; [] gorptest: 14:46:38.165494 drop table if exists "person_test"; [] gorptest: 14:46:38.165692 drop table if exists "ignored_column_test"; [] gorptest: 14:46:38.165877 drop table if exists "id_created_test"; [] gorptest: 14:46:38.166086 drop table if exists "type_conv_test"; [] gorptest: 14:46:38.166292 drop table if exists "embedded_struct_test"; [] gorptest: 14:46:38.166477 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 14:46:38.166683 drop table if exists "embedded_autoincr_test"; [] gorptest: 14:46:38.166867 drop table if exists "time_test"; [] gorptest: 14:46:38.167070 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.01s) PASS ok gopkg.in/gorp.v1 0.265s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install --destdir=debian/golang-gopkg-gorp.v1-dev/ -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: user script /srv/workspace/pbuilder/740268/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/740268/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/740268 and its subdirectories I: Current time: Mon May 22 14:46:43 +14 2023 I: pbuilder-time-stamp: 1684716403