I: pbuilder: network access will be disabled during build I: Current time: Wed Jun 7 20:26:25 +14 2023 I: pbuilder-time-stamp: 1686119185 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/29263/tmp/hooks/D01_modify_environment starting debug: Running on virt64a. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash '/bin/sh' -> '/bin/bash' lrwxrwxrwx 1 root root 9 Jun 7 20:26 /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/29263/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/29263/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]="arm-unknown-linux-gnueabihf") 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=armhf DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=4 ' DIRSTACK=() DISTRIBUTION=bookworm EUID=0 FUNCNAME=([0]="Echo" [1]="main") GROUPS=() HOME=/root HOSTNAME=i-capture-the-hostname HOSTTYPE=arm HOST_ARCH=armhf IFS=' ' INVOCATION_ID=95e55903225e4e81abaad3705ac60774 LANG=C LANGUAGE=it_CH:it LC_ALL=C MACHTYPE=arm-unknown-linux-gnueabihf MAIL=/var/mail/root OPTERR=1 OPTIND=1 OSTYPE=linux-gnueabihf 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=29263 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.tsxup2au/pbuilderrc_aTGV --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.tsxup2au/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID=114 SUDO_UID=108 SUDO_USER=jenkins TERM=unknown TZ=/usr/share/zoneinfo/Etc/GMT-14 UID=0 USER=root _='I: set' http_proxy=http://10.0.0.15:3142/ I: uname -a Linux i-capture-the-hostname 5.10.0-23-arm64 #1 SMP Debian 5.10.179-1 (2023-05-12) aarch64 GNU/Linux I: ls -l /bin total 5072 -rwxr-xr-x 1 root root 838488 Apr 24 11:24 bash -rwxr-xr-x 3 root root 67144 Sep 19 2022 bunzip2 -rwxr-xr-x 3 root root 67144 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 67144 Sep 19 2022 bzip2 -rwxr-xr-x 1 root root 67112 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 67632 Sep 21 2022 cat -rwxr-xr-x 1 root root 67676 Sep 21 2022 chgrp -rwxr-xr-x 1 root root 67644 Sep 21 2022 chmod -rwxr-xr-x 1 root root 67684 Sep 21 2022 chown -rwxr-xr-x 1 root root 133532 Sep 21 2022 cp -rwxr-xr-x 1 root root 132868 Jan 6 03:20 dash -rwxr-xr-x 1 root root 133220 Sep 21 2022 date -rwxr-xr-x 1 root root 67732 Sep 21 2022 dd -rwxr-xr-x 1 root root 68104 Sep 21 2022 df -rwxr-xr-x 1 root root 133632 Sep 21 2022 dir -rwxr-xr-x 1 root root 59128 Mar 23 23: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 67560 Sep 21 2022 echo -rwxr-xr-x 1 root root 41 Jan 25 04:43 egrep -rwxr-xr-x 1 root root 67548 Sep 21 2022 false -rwxr-xr-x 1 root root 41 Jan 25 04:43 fgrep -rwxr-xr-x 1 root root 55748 Mar 23 23:02 findmnt -rwsr-xr-x 1 root root 26208 Mar 23 22:15 fusermount -rwxr-xr-x 1 root root 128608 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 64220 Apr 10 2022 gzip -rwxr-xr-x 1 root root 67032 Dec 20 03:33 hostname -rwxr-xr-x 1 root root 67720 Sep 21 2022 ln -rwxr-xr-x 1 root root 35132 Mar 23 23:51 login -rwxr-xr-x 1 root root 133632 Sep 21 2022 ls -rwxr-xr-x 1 root root 136808 Mar 23 23:02 lsblk -rwxr-xr-x 1 root root 67800 Sep 21 2022 mkdir -rwxr-xr-x 1 root root 67764 Sep 21 2022 mknod -rwxr-xr-x 1 root root 67596 Sep 21 2022 mktemp -rwxr-xr-x 1 root root 38504 Mar 23 23:02 more -rwsr-xr-x 1 root root 38496 Mar 23 23:02 mount -rwxr-xr-x 1 root root 9824 Mar 23 23:02 mountpoint -rwxr-xr-x 1 root root 133532 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 67608 Sep 21 2022 pwd lrwxrwxrwx 1 root root 4 Apr 24 11:24 rbash -> bash -rwxr-xr-x 1 root root 67600 Sep 21 2022 readlink -rwxr-xr-x 1 root root 67672 Sep 21 2022 rm -rwxr-xr-x 1 root root 67600 Sep 21 2022 rmdir -rwxr-xr-x 1 root root 67400 Nov 3 2022 run-parts -rwxr-xr-x 1 root root 133372 Jan 6 09:55 sed lrwxrwxrwx 1 root root 9 Jun 7 20:26 sh -> /bin/bash -rwxr-xr-x 1 root root 67584 Sep 21 2022 sleep -rwxr-xr-x 1 root root 67644 Sep 21 2022 stty -rwsr-xr-x 1 root root 50800 Mar 23 23:02 su -rwxr-xr-x 1 root root 67584 Sep 21 2022 sync -rwxr-xr-x 1 root root 336764 Apr 7 04:25 tar -rwxr-xr-x 1 root root 67144 Nov 3 2022 tempfile -rwxr-xr-x 1 root root 133224 Sep 21 2022 touch -rwxr-xr-x 1 root root 67548 Sep 21 2022 true -rwxr-xr-x 1 root root 9768 Mar 23 22:15 ulockmgr_server -rwsr-xr-x 1 root root 22108 Mar 23 23:02 umount -rwxr-xr-x 1 root root 67572 Sep 21 2022 uname -rwxr-xr-x 2 root root 2346 Apr 10 2022 uncompress -rwxr-xr-x 1 root root 133632 Sep 21 2022 vdir -rwxr-xr-x 1 root root 42608 Mar 23 23: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/29263/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: armhf 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 ... 19324 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.19-go{a} golang-1.19-src{a} golang-any{a} golang-github-davecgh-go-spew-dev{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-gorilla-securecookie-dev{a} golang-github-gorilla-sessions-dev{a} golang-github-hashicorp-go-uuid-dev{a} golang-github-jcmturner-aescts.v2-dev{a} golang-github-jcmturner-dnsutils.v2-dev{a} golang-github-jcmturner-gofork-dev{a} golang-github-jcmturner-goidentity.v6-dev{a} golang-github-jcmturner-gokrb5.v8-dev{a} golang-github-jcmturner-rpc.v2-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-pmezard-go-difflib-dev{a} golang-github-stretchr-objx-dev{a} golang-github-stretchr-testify-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-crypto-dev{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-term-dev{a} golang-golang-x-text-dev{a} golang-gopkg-yaml.v3-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsqlite3-dev{a} libsub-override-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 60 newly installed, 0 to remove and 0 not upgraded. Need to get 101 MB of archives. After unpacking 564 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bookworm/main armhf sensible-utils all 0.0.17+nmu1 [19.0 kB] Get: 2 http://deb.debian.org/debian bookworm/main armhf libmagic-mgc armhf 1:5.44-3 [305 kB] Get: 3 http://deb.debian.org/debian bookworm/main armhf libmagic1 armhf 1:5.44-3 [96.5 kB] Get: 4 http://deb.debian.org/debian bookworm/main armhf file armhf 1:5.44-3 [41.6 kB] Get: 5 http://deb.debian.org/debian bookworm/main armhf gettext-base armhf 0.21-12 [157 kB] Get: 6 http://deb.debian.org/debian bookworm/main armhf libuchardet0 armhf 0.0.7-1 [65.0 kB] Get: 7 http://deb.debian.org/debian bookworm/main armhf groff-base armhf 1.22.4-10 [825 kB] Get: 8 http://deb.debian.org/debian bookworm/main armhf bsdextrautils armhf 2.38.1-5+b1 [78.6 kB] Get: 9 http://deb.debian.org/debian bookworm/main armhf libpipeline1 armhf 1.5.7-1 [33.6 kB] Get: 10 http://deb.debian.org/debian bookworm/main armhf man-db armhf 2.11.2-2 [1351 kB] Get: 11 http://deb.debian.org/debian bookworm/main armhf m4 armhf 1.4.19-3 [265 kB] Get: 12 http://deb.debian.org/debian bookworm/main armhf autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian bookworm/main armhf autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian bookworm/main armhf automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian bookworm/main armhf autopoint all 0.21-12 [495 kB] Get: 16 http://deb.debian.org/debian bookworm/main armhf libdebhelper-perl all 13.11.4 [81.2 kB] Get: 17 http://deb.debian.org/debian bookworm/main armhf libtool all 2.4.7-5 [517 kB] Get: 18 http://deb.debian.org/debian bookworm/main armhf dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian bookworm/main armhf libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian bookworm/main armhf libsub-override-perl all 0.09-4 [9304 B] Get: 21 http://deb.debian.org/debian bookworm/main armhf libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian bookworm/main armhf dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian bookworm/main armhf libelf1 armhf 0.188-2.1 [170 kB] Get: 24 http://deb.debian.org/debian bookworm/main armhf dwz armhf 0.15-1 [101 kB] Get: 25 http://deb.debian.org/debian bookworm/main armhf libicu72 armhf 72.1-3 [9048 kB] Get: 26 http://deb.debian.org/debian bookworm/main armhf libxml2 armhf 2.9.14+dfsg-1.2 [591 kB] Get: 27 http://deb.debian.org/debian bookworm/main armhf gettext armhf 0.21-12 [1229 kB] Get: 28 http://deb.debian.org/debian bookworm/main armhf intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian bookworm/main armhf po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian bookworm/main armhf debhelper all 13.11.4 [942 kB] Get: 31 http://deb.debian.org/debian bookworm/main armhf dh-golang all 1.59 [27.8 kB] Get: 32 http://deb.debian.org/debian bookworm/main armhf golang-1.19-src all 1.19.8-2 [18.3 MB] Get: 33 http://deb.debian.org/debian bookworm/main armhf golang-1.19-go armhf 1.19.8-2 [56.9 MB] Get: 34 http://deb.debian.org/debian bookworm/main armhf golang-src all 2:1.19~1 [5756 B] Get: 35 http://deb.debian.org/debian bookworm/main armhf golang-go armhf 2:1.19~1 [45.0 kB] Get: 36 http://deb.debian.org/debian bookworm/main armhf golang-any armhf 2:1.19~1 [5876 B] Get: 37 http://deb.debian.org/debian bookworm/main armhf golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian bookworm/main armhf golang-github-go-sql-driver-mysql-dev all 1.5.0-2 [70.9 kB] Get: 39 http://deb.debian.org/debian bookworm/main armhf golang-github-gorilla-securecookie-dev all 1.1.1-2 [12.2 kB] Get: 40 http://deb.debian.org/debian bookworm/main armhf golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian bookworm/main armhf golang-github-hashicorp-go-uuid-dev all 1.0.2-2 [8480 B] Get: 42 http://deb.debian.org/debian bookworm/main armhf golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian bookworm/main armhf golang-github-stretchr-objx-dev all 0.5.0-1 [25.5 kB] Get: 44 http://deb.debian.org/debian bookworm/main armhf golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian bookworm/main armhf golang-github-stretchr-testify-dev all 1.8.1-1 [67.9 kB] Get: 46 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian bookworm/main armhf golang-golang-x-sys-dev all 0.3.0-1 [393 kB] Get: 51 http://deb.debian.org/debian bookworm/main armhf golang-golang-x-text-dev all 0.7.0-1 [3863 kB] Get: 52 http://deb.debian.org/debian bookworm/main armhf golang-golang-x-net-dev all 1:0.7.0+dfsg-1 [731 kB] Get: 53 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 54 http://deb.debian.org/debian bookworm/main armhf golang-golang-x-term-dev all 0.3.0-1 [14.6 kB] Get: 55 http://deb.debian.org/debian bookworm/main armhf golang-golang-x-crypto-dev all 1:0.4.0-1 [1449 kB] Get: 56 http://deb.debian.org/debian bookworm/main armhf golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian bookworm/main armhf golang-github-lib-pq-dev all 1.10.7-2 [84.1 kB] Get: 58 http://deb.debian.org/debian bookworm/main armhf libsqlite3-dev armhf 3.40.1-2 [926 kB] Get: 59 http://deb.debian.org/debian bookworm/main armhf golang-github-mattn-go-sqlite3-dev armhf 1.14.16~ds1-1 [82.2 kB] Get: 60 http://deb.debian.org/debian bookworm/main armhf golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 101 MB in 5s (20.8 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19324 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_armhf.deb ... Unpacking libmagic-mgc (1:5.44-3) ... Selecting previously unselected package libmagic1:armhf. Preparing to unpack .../02-libmagic1_1%3a5.44-3_armhf.deb ... Unpacking libmagic1:armhf (1:5.44-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.44-3_armhf.deb ... Unpacking file (1:5.44-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-12_armhf.deb ... Unpacking gettext-base (0.21-12) ... Selecting previously unselected package libuchardet0:armhf. Preparing to unpack .../05-libuchardet0_0.0.7-1_armhf.deb ... Unpacking libuchardet0:armhf (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.22.4-10_armhf.deb ... Unpacking groff-base (1.22.4-10) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.38.1-5+b1_armhf.deb ... Unpacking bsdextrautils (2.38.1-5+b1) ... Selecting previously unselected package libpipeline1:armhf. Preparing to unpack .../08-libpipeline1_1.5.7-1_armhf.deb ... Unpacking libpipeline1:armhf (1.5.7-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.11.2-2_armhf.deb ... Unpacking man-db (2.11.2-2) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-3_armhf.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:armhf. Preparing to unpack .../22-libelf1_0.188-2.1_armhf.deb ... Unpacking libelf1:armhf (0.188-2.1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1_armhf.deb ... Unpacking dwz (0.15-1) ... Selecting previously unselected package libicu72:armhf. Preparing to unpack .../24-libicu72_72.1-3_armhf.deb ... Unpacking libicu72:armhf (72.1-3) ... Selecting previously unselected package libxml2:armhf. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.2_armhf.deb ... Unpacking libxml2:armhf (2.9.14+dfsg-1.2) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-12_armhf.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_armhf.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:armhf. Preparing to unpack .../34-golang-go_2%3a1.19~1_armhf.deb ... Unpacking golang-go:armhf (2:1.19~1) ... Selecting previously unselected package golang-any:armhf. Preparing to unpack .../35-golang-any_2%3a1.19~1_armhf.deb ... Unpacking golang-any:armhf (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:armhf. Preparing to unpack .../57-libsqlite3-dev_3.40.1-2_armhf.deb ... Unpacking libsqlite3-dev:armhf (3.40.1-2) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:armhf. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.16~ds1-1_armhf.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:armhf (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:armhf (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:armhf (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:armhf (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:armhf (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:armhf (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:armhf (0.188-2.1) ... Setting up golang-github-gorilla-securecookie-dev (1.1.1-2) ... Setting up libxml2:armhf (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:armhf (2:1.19~1) ... Setting up golang-any:armhf (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:armhf (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/29263/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/29263/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 armhf 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 4 gopkg.in/gorp.v1 internal/goarch internal/unsafeheader internal/goexperiment internal/abi internal/cpu internal/goos runtime/internal/math runtime/internal/sys runtime/internal/syscall internal/race sync/atomic unicode unicode/utf8 internal/itoa math/bits math internal/bytealg runtime/internal/atomic runtime internal/reflectlite sync internal/testlog errors sort io internal/oserror strconv syscall internal/safefilepath bytes path strings reflect regexp/syntax internal/syscall/unix time internal/syscall/execenv regexp context internal/poll io/fs internal/fmtsort os fmt log database/sql/driver database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 4 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2023/06/07 20:30:58 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: 20:30:58.377296 drop table if exists "invoice_test"; [] gorptest: 20:30:58.378565 drop table if exists "invoice_tag_test"; [] gorptest: 20:30:58.378730 drop table if exists "alias_trans_field_test"; [] gorptest: 20:30:58.378844 drop table if exists "invoice_override_test"; [] gorptest: 20:30:58.378926 drop table if exists "person_test"; [] gorptest: 20:30:58.378999 drop table if exists "ignored_column_test"; [] gorptest: 20:30:58.379070 drop table if exists "id_created_test"; [] gorptest: 20:30:58.379147 drop table if exists "type_conv_test"; [] gorptest: 20:30:58.379225 drop table if exists "embedded_struct_test"; [] gorptest: 20:30:58.379301 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:30:58.379574 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:30:58.379705 drop table if exists "time_test"; [] gorptest: 20:30:58.379844 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:05.628912 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: 20:31:06.224602 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:07.506133 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:10.621565 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:10.857096 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:10.996156 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:11.229153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:11.412157 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:11.591743 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:11.848139 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:12.210753 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:12.382271 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: 20:31:12.382586 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: 20:31:12.382784 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:12.382950 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: 20:31:12.383111 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: 20:31:12.383238 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:12.383358 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:12.383542 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:12.383677 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:12.383794 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:12.383927 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: 20:31:12.384065 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:12.384198 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 20:31:12.384317 drop table if exists "invoice_test"; [] gorptest: 20:31:12.511107 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:12.610242 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:14.582315 drop table if exists "invoice_override_test"; [] gorptest: 20:31:14.602136 drop table if exists "person_test"; [] gorptest: 20:31:14.615921 drop table if exists "ignored_column_test"; [] gorptest: 20:31:14.625018 drop table if exists "id_created_test"; [] gorptest: 20:31:14.646772 drop table if exists "type_conv_test"; [] gorptest: 20:31:14.674102 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:14.718875 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:14.742132 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:14.753509 drop table if exists "time_test"; [] gorptest: 20:31:14.762058 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (16.39s) === RUN TestTruncateTables 2023/06/07 20:31:14 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: 20:31:14.762817 drop table if exists "invoice_test"; [] gorptest: 20:31:14.763691 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:14.763809 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:14.763915 drop table if exists "invoice_override_test"; [] gorptest: 20:31:14.764028 drop table if exists "person_test"; [] gorptest: 20:31:14.764139 drop table if exists "ignored_column_test"; [] gorptest: 20:31:14.764294 drop table if exists "id_created_test"; [] gorptest: 20:31:14.764499 drop table if exists "type_conv_test"; [] gorptest: 20:31:14.764580 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:14.764646 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:14.764736 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:14.764834 drop table if exists "time_test"; [] gorptest: 20:31:14.764943 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:14.773089 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: 20:31:14.781763 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:14.790530 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:14.805993 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:14.846045 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:14.865151 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:14.873821 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:14.882589 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:14.932582 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:14.943307 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:14.952316 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:14.967246 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: 20:31:14.967608 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: 20:31:14.968147 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:14.968302 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: 20:31:14.968446 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: 20:31:14.968705 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:14.968902 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:14.969020 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:14.969172 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:14.969320 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:14.969510 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: 20:31:14.969660 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:14.969769 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 20:31:14.969948 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119474969882710 2:1686119474969882710 3:"Bob" 4:"Smith" 5:1] gorptest: 20:31:15.013517 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 20:31:15.027169 delete from "invoice_test"; [] gorptest: 20:31:15.037745 delete from "invoice_tag_test"; [] gorptest: 20:31:15.046326 delete from "alias_trans_field_test"; [] gorptest: 20:31:15.054855 delete from "invoice_override_test"; [] gorptest: 20:31:15.064125 delete from "person_test"; [] gorptest: 20:31:15.072126 delete from "ignored_column_test"; [] gorptest: 20:31:15.079955 delete from "id_created_test"; [] gorptest: 20:31:15.087667 delete from "type_conv_test"; [] gorptest: 20:31:15.095647 delete from "embedded_struct_test"; [] gorptest: 20:31:15.103791 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:15.113843 delete from "embedded_autoincr_test"; [] gorptest: 20:31:15.122058 delete from "time_test"; [] gorptest: 20:31:15.130042 delete from "id_created_test"; [] gorptest: 20:31:15.138046 SELECT * FROM person_test [] gorptest: 20:31:15.146189 SELECT * FROM invoice_test [] gorptest: 20:31:15.146473 drop table if exists "invoice_test"; [] gorptest: 20:31:15.204580 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:15.213142 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:15.222004 drop table if exists "invoice_override_test"; [] gorptest: 20:31:15.230489 drop table if exists "person_test"; [] gorptest: 20:31:15.239062 drop table if exists "ignored_column_test"; [] gorptest: 20:31:15.251945 drop table if exists "id_created_test"; [] gorptest: 20:31:15.279244 drop table if exists "type_conv_test"; [] gorptest: 20:31:15.309909 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:15.320171 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:15.336017 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:15.345057 drop table if exists "time_test"; [] gorptest: 20:31:15.359497 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.60s) === RUN TestCustomDateType gorptest: 20:31:15.360144 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 20:31:15.403680 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-06-07 20:31:15 +1400 +14] gorptest: 20:31:15.412451 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 20:31:15.420208 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.14s) === RUN TestUIntPrimaryKey gorptest: 20:31:15.497085 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 20:31:16.028253 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 20:31:16.888420 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 20:31:17.072289 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 20:31:17.130694 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 20:31:17.191350 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 20:31:17.251047 drop table if exists "PersonUInt64"; [] gorptest: 20:31:17.508312 drop table if exists "PersonUInt32"; [] gorptest: 20:31:17.812579 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (2.50s) === RUN TestSetUniqueTogether gorptest: 20:31:17.999111 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 20:31:18.030087 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 20:31:18.039538 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 20:31:18.039975 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 20:31:18.040210 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 20:31:18.250547 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.38s) === RUN TestPersistentUser gorptest: 20:31:18.382049 drop table if exists PersistentUser [] gorptest: 20:31:18.383234 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 20:31:18.394162 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 20:31:18.405317 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 20:31:18.405762 select * from PersistentUser [] gorptest: 20:31:18.406105 select * from PersistentUser [] gorptest: 20:31:18.406396 select * from PersistentUser [] gorptest: 20:31:18.406685 select Id from PersistentUser [] gorptest: 20:31:18.406915 select mykey from PersistentUser [] gorptest: 20:31:18.407131 select PassedTraining from PersistentUser [] gorptest: 20:31:18.407371 select Id from PersistentUser [] gorptest: 20:31:18.407644 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.12s) === RUN TestNamedQueryMap gorptest: 20:31:18.502469 drop table if exists PersistentUser [] gorptest: 20:31:18.503514 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 20:31:18.705048 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 20:31:18.811696 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 20:31:18.941626 select * from PersistentUser where mykey = ? [1:43] gorptest: 20:31:18.942169 select * from PersistentUser where mykey = ? [1:43] gorptest: 20:31:18.942504 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 20:31:18.942849 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 20:31:18.943141 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.46s) === RUN TestNamedQueryStruct gorptest: 20:31:18.962530 drop table if exists PersistentUser [] gorptest: 20:31:18.963585 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 20:31:18.974098 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 20:31:18.981727 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 20:31:18.996909 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 20:31:18.997452 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.04s) === RUN TestReturnsNonNilSlice 2023/06/07 20:31:19 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: 20:31:19.005736 drop table if exists "invoice_test"; [] gorptest: 20:31:19.006513 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:19.006677 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:19.006811 drop table if exists "invoice_override_test"; [] gorptest: 20:31:19.006937 drop table if exists "person_test"; [] gorptest: 20:31:19.007071 drop table if exists "ignored_column_test"; [] gorptest: 20:31:19.007200 drop table if exists "id_created_test"; [] gorptest: 20:31:19.007328 drop table if exists "type_conv_test"; [] gorptest: 20:31:19.007509 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:19.007645 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:19.007775 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:19.007901 drop table if exists "time_test"; [] gorptest: 20:31:19.008079 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:19.027313 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: 20:31:19.042860 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:19.051283 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:19.060097 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:19.068671 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:19.333897 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:19.404569 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:19.429197 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:19.439768 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:19.448548 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:19.457500 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:19.581811 select * from invoice_test where id=99999 [] gorptest: 20:31:19.582296 select * from invoice_test where id=99999 [] gorptest: 20:31:19.582751 drop table if exists "invoice_test"; [] gorptest: 20:31:19.943485 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:20.242690 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:20.638784 drop table if exists "invoice_override_test"; [] gorptest: 20:31:21.002752 drop table if exists "person_test"; [] gorptest: 20:31:21.556245 drop table if exists "ignored_column_test"; [] gorptest: 20:31:21.588558 drop table if exists "id_created_test"; [] gorptest: 20:31:21.603960 drop table if exists "type_conv_test"; [] gorptest: 20:31:21.659304 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:22.000509 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:22.550679 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:23.124060 drop table if exists "time_test"; [] gorptest: 20:31:23.332521 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (4.33s) === RUN TestOverrideVersionCol gorptest: 20:31:23.333291 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 20:31:23.361027 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: 20:31:23.361495 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.04s) === RUN TestOptimisticLocking 2023/06/07 20:31:23 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: 20:31:23.377962 drop table if exists "invoice_test"; [] gorptest: 20:31:23.378827 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:23.379023 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:23.379142 drop table if exists "invoice_override_test"; [] gorptest: 20:31:23.379248 drop table if exists "person_test"; [] gorptest: 20:31:23.379362 drop table if exists "ignored_column_test"; [] gorptest: 20:31:23.379516 drop table if exists "id_created_test"; [] gorptest: 20:31:23.379633 drop table if exists "type_conv_test"; [] gorptest: 20:31:23.379744 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:23.379855 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:23.379966 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:23.380085 drop table if exists "time_test"; [] gorptest: 20:31:23.380224 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:23.406285 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: 20:31:23.431553 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:23.447209 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:23.460608 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:23.485666 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:23.511902 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:23.530690 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:23.562019 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:23.591377 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:23.606070 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:23.620698 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:23.629211 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119483629133630 2:1686119483629133630 3:"Bob" 4:"Smith" 5:1] gorptest: 20:31:23.653539 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:23.654085 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1686119483629133630 2:1686119483629133630 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 20:31:23.669301 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1686119483629133630 2:1686119483629133630 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 20:31:23.669688 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:23.670087 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 20:31:23.670306 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:23.670610 drop table if exists "invoice_test"; [] gorptest: 20:31:23.695832 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:23.711540 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:23.739287 drop table if exists "invoice_override_test"; [] gorptest: 20:31:23.750911 drop table if exists "person_test"; [] gorptest: 20:31:23.762337 drop table if exists "ignored_column_test"; [] gorptest: 20:31:23.770267 drop table if exists "id_created_test"; [] gorptest: 20:31:23.777567 drop table if exists "type_conv_test"; [] gorptest: 20:31:23.785562 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:23.806763 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:23.814350 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:23.823768 drop table if exists "time_test"; [] gorptest: 20:31:23.833624 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.46s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 20:31:23.834602 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 20:31:23.857254 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 20:31:23.865530 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 20:31:23.866153 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: 20:31:23.873844 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 20:31:23.874344 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.06s) === RUN TestColumnProps gorptest: 20:31:23.890783 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 20:31:23.916414 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 20:31:23.930635 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 20:31:23.931148 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 20:31:23.931581 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 20:31:23.931845 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.07s) === RUN TestRawSelect 2023/06/07 20:31:23 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: 20:31:23.960445 drop table if exists "invoice_test"; [] gorptest: 20:31:23.961475 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:23.961616 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:23.961769 drop table if exists "invoice_override_test"; [] gorptest: 20:31:23.961906 drop table if exists "person_test"; [] gorptest: 20:31:23.962049 drop table if exists "ignored_column_test"; [] gorptest: 20:31:23.962162 drop table if exists "id_created_test"; [] gorptest: 20:31:23.962298 drop table if exists "type_conv_test"; [] gorptest: 20:31:23.962408 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:23.966313 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:23.966436 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:23.966547 drop table if exists "time_test"; [] gorptest: 20:31:23.966725 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:23.995363 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: 20:31:24.022626 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:24.031343 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:24.039563 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:24.047665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:24.074343 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:24.087540 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:24.102693 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:24.131147 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:24.146947 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:24.191373 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:24.224143 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119484224031194 2:1686119484224031194 3:"bob" 4:"smith" 5:1] gorptest: 20:31:24.254868 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 20:31:24.290659 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 20:31:24.291290 drop table if exists "invoice_test"; [] gorptest: 20:31:24.318464 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:24.348909 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:24.368313 drop table if exists "invoice_override_test"; [] gorptest: 20:31:24.395235 drop table if exists "person_test"; [] gorptest: 20:31:24.411903 drop table if exists "ignored_column_test"; [] gorptest: 20:31:24.439161 drop table if exists "id_created_test"; [] gorptest: 20:31:24.453551 drop table if exists "type_conv_test"; [] gorptest: 20:31:24.481430 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:24.493749 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:24.524456 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:24.542616 drop table if exists "time_test"; [] gorptest: 20:31:24.569466 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.61s) === RUN TestHooks 2023/06/07 20:31:24 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: 20:31:24.570214 drop table if exists "invoice_test"; [] gorptest: 20:31:24.571142 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:24.571256 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:24.571335 drop table if exists "invoice_override_test"; [] gorptest: 20:31:24.571405 drop table if exists "person_test"; [] gorptest: 20:31:24.571844 drop table if exists "ignored_column_test"; [] gorptest: 20:31:24.571942 drop table if exists "id_created_test"; [] gorptest: 20:31:24.572092 drop table if exists "type_conv_test"; [] gorptest: 20:31:24.572198 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:24.572285 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:24.572383 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:24.572461 drop table if exists "time_test"; [] gorptest: 20:31:24.572617 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:24.591726 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: 20:31:24.626078 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:24.660280 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:24.692468 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:24.712609 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:24.739081 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:24.964243 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:24.994557 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:25.018893 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:25.043992 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:25.060946 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:25.089272 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119485089186648 2:1686119485089186648 3:"bob" 4:"smith" 5:1] gorptest: 20:31:25.103236 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:25.103811 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1686119485089186648 2:1686119485089186648 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 20:31:25.130892 select * from person_test where id = ? [1:1] gorptest: 20:31:25.131554 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 20:31:25.161476 drop table if exists "invoice_test"; [] gorptest: 20:31:25.189536 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:25.204992 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:25.237216 drop table if exists "invoice_override_test"; [] gorptest: 20:31:25.253321 drop table if exists "person_test"; [] gorptest: 20:31:25.278657 drop table if exists "ignored_column_test"; [] gorptest: 20:31:25.292594 drop table if exists "id_created_test"; [] gorptest: 20:31:25.322539 drop table if exists "type_conv_test"; [] gorptest: 20:31:25.335384 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:25.364949 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:25.392219 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:25.413269 drop table if exists "time_test"; [] gorptest: 20:31:25.442746 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.87s) === RUN TestTransaction 2023/06/07 20:31:25 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: 20:31:25.443523 drop table if exists "invoice_test"; [] gorptest: 20:31:25.444286 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:25.444410 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:25.444520 drop table if exists "invoice_override_test"; [] gorptest: 20:31:25.444635 drop table if exists "person_test"; [] gorptest: 20:31:25.444776 drop table if exists "ignored_column_test"; [] gorptest: 20:31:25.444893 drop table if exists "id_created_test"; [] gorptest: 20:31:25.444990 drop table if exists "type_conv_test"; [] gorptest: 20:31:25.445087 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:25.445197 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:25.445308 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:25.445419 drop table if exists "time_test"; [] gorptest: 20:31:25.445559 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:25.458838 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: 20:31:25.495199 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:25.521382 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:25.544289 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:25.571562 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:25.597866 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:25.614849 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:25.634371 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:25.663891 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:25.692730 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:25.721433 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:25.747117 begin; [] gorptest: 20:31:25.747393 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 20:31:25.748285 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 20:31:25.748496 commit; [] gorptest: 20:31:25.781437 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:25.781926 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 20:31:25.782267 drop table if exists "invoice_test"; [] gorptest: 20:31:25.810700 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:25.828358 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:25.857927 drop table if exists "invoice_override_test"; [] gorptest: 20:31:25.889519 drop table if exists "person_test"; [] gorptest: 20:31:25.921546 drop table if exists "ignored_column_test"; [] gorptest: 20:31:26.088980 drop table if exists "id_created_test"; [] gorptest: 20:31:26.201462 drop table if exists "type_conv_test"; [] gorptest: 20:31:26.264045 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:26.272319 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:26.284193 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:26.304015 drop table if exists "time_test"; [] gorptest: 20:31:26.319086 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.88s) === RUN TestSavepoint 2023/06/07 20:31:26 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: 20:31:26.319957 drop table if exists "invoice_test"; [] gorptest: 20:31:26.320827 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:26.320998 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:26.321152 drop table if exists "invoice_override_test"; [] gorptest: 20:31:26.321301 drop table if exists "person_test"; [] gorptest: 20:31:26.321437 drop table if exists "ignored_column_test"; [] gorptest: 20:31:26.321542 drop table if exists "id_created_test"; [] gorptest: 20:31:26.321678 drop table if exists "type_conv_test"; [] gorptest: 20:31:26.321815 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:26.321944 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:26.322089 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:26.322215 drop table if exists "time_test"; [] gorptest: 20:31:26.322390 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:26.330638 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: 20:31:26.339317 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:26.348408 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:26.361224 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:26.372799 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:26.387347 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:26.398946 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:26.408309 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:26.416183 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:26.424356 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:26.435652 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:26.443638 begin; [] gorptest: 20:31:26.443897 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 20:31:26.444494 select memo from invoice_test [] gorptest: 20:31:26.444824 savepoint "foo" [1:] gorptest: 20:31:26.444915 select memo from invoice_test [] gorptest: 20:31:26.445121 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 20:31:26.445350 select memo from invoice_test [] gorptest: 20:31:26.445492 rollback to savepoint "foo" [1:] gorptest: 20:31:26.445565 select memo from invoice_test [] gorptest: 20:31:26.445726 rollback; [] gorptest: 20:31:26.446034 drop table if exists "invoice_test"; [] gorptest: 20:31:26.469418 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:26.480546 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:26.488201 drop table if exists "invoice_override_test"; [] gorptest: 20:31:26.496136 drop table if exists "person_test"; [] gorptest: 20:31:26.503811 drop table if exists "ignored_column_test"; [] gorptest: 20:31:26.517710 drop table if exists "id_created_test"; [] gorptest: 20:31:26.583779 drop table if exists "type_conv_test"; [] gorptest: 20:31:26.612786 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:26.640969 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:26.664348 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:26.696034 drop table if exists "time_test"; [] gorptest: 20:31:26.727187 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.41s) === RUN TestMultiple 2023/06/07 20:31:26 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: 20:31:26.728084 drop table if exists "invoice_test"; [] gorptest: 20:31:26.729155 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:26.729326 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:26.729437 drop table if exists "invoice_override_test"; [] gorptest: 20:31:26.729541 drop table if exists "person_test"; [] gorptest: 20:31:26.729847 drop table if exists "ignored_column_test"; [] gorptest: 20:31:26.729970 drop table if exists "id_created_test"; [] gorptest: 20:31:26.730095 drop table if exists "type_conv_test"; [] gorptest: 20:31:26.730189 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:26.730280 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:26.730385 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:26.730501 drop table if exists "time_test"; [] gorptest: 20:31:26.730639 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:26.754576 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: 20:31:26.762714 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:26.770734 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:26.778981 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:26.787119 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:26.794903 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:26.815074 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:26.822694 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:26.831660 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:26.840112 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:26.848447 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:26.860228 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 20:31:26.925454 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 20:31:26.940767 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 20:31:26.955954 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 20:31:26.969209 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:26.990520 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 20:31:26.999105 drop table if exists "invoice_test"; [] gorptest: 20:31:27.007304 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:27.016266 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:27.024238 drop table if exists "invoice_override_test"; [] gorptest: 20:31:27.036781 drop table if exists "person_test"; [] gorptest: 20:31:27.044667 drop table if exists "ignored_column_test"; [] gorptest: 20:31:27.068450 drop table if exists "id_created_test"; [] gorptest: 20:31:27.076341 drop table if exists "type_conv_test"; [] gorptest: 20:31:27.084051 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:27.091680 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:27.102856 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:27.111951 drop table if exists "time_test"; [] gorptest: 20:31:27.121118 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.39s) === RUN TestCrud 2023/06/07 20:31:27 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: 20:31:27.121860 drop table if exists "invoice_test"; [] gorptest: 20:31:27.122675 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:27.122805 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:27.122914 drop table if exists "invoice_override_test"; [] gorptest: 20:31:27.123046 drop table if exists "person_test"; [] gorptest: 20:31:27.123148 drop table if exists "ignored_column_test"; [] gorptest: 20:31:27.123277 drop table if exists "id_created_test"; [] gorptest: 20:31:27.123402 drop table if exists "type_conv_test"; [] gorptest: 20:31:27.123767 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:27.123916 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:27.124077 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:27.124220 drop table if exists "time_test"; [] gorptest: 20:31:27.124383 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:27.143164 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: 20:31:27.153833 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:27.163094 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:27.172205 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:27.181622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:27.202388 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:27.210759 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:27.219525 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:27.227086 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:27.235128 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:27.243594 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:27.254731 delete from invoice_test [] gorptest: 20:31:27.277486 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 20:31:27.285509 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:27.285998 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: 20:31:27.293581 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:27.294003 select * from invoice_test [] gorptest: 20:31:27.294510 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:27.302173 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 20:31:27.302519 delete from invoice_tag_test [] gorptest: 20:31:27.328728 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: 20:31:27.379867 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 20:31:27.380445 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: 20:31:27.408356 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 20:31:27.409004 select * from invoice_tag_test [] gorptest: 20:31:27.409515 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 20:31:27.427747 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 20:31:27.428147 delete from alias_trans_field_test [] gorptest: 20:31:27.463983 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 20:31:27.493696 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 20:31:27.494184 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 20:31:27.505394 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 20:31:27.505827 select * from alias_trans_field_test [] gorptest: 20:31:27.506160 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 20:31:27.513578 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 20:31:27.513902 drop table if exists "invoice_test"; [] gorptest: 20:31:27.525795 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:27.539738 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:27.547810 drop table if exists "invoice_override_test"; [] gorptest: 20:31:27.555810 drop table if exists "person_test"; [] gorptest: 20:31:27.564062 drop table if exists "ignored_column_test"; [] gorptest: 20:31:27.571383 drop table if exists "id_created_test"; [] gorptest: 20:31:27.579990 drop table if exists "type_conv_test"; [] gorptest: 20:31:27.587934 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:27.606279 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:27.614640 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:27.623301 drop table if exists "time_test"; [] gorptest: 20:31:27.635522 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.52s) === RUN TestWithIgnoredColumn 2023/06/07 20:31:27 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: 20:31:27.637112 drop table if exists "invoice_test"; [] gorptest: 20:31:27.637928 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:27.638049 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:27.638171 drop table if exists "invoice_override_test"; [] gorptest: 20:31:27.638293 drop table if exists "person_test"; [] gorptest: 20:31:27.638410 drop table if exists "ignored_column_test"; [] gorptest: 20:31:27.638526 drop table if exists "id_created_test"; [] gorptest: 20:31:27.638641 drop table if exists "type_conv_test"; [] gorptest: 20:31:27.638752 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:27.638864 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:27.638971 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:27.639075 drop table if exists "time_test"; [] gorptest: 20:31:27.639214 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:27.651241 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: 20:31:27.660537 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:27.669232 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:27.698306 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:27.715412 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:27.745177 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:27.777579 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:27.807138 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:27.826852 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:27.852910 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:27.880138 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:27.900040 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 20:31:27.909037 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 20:31:27.909888 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 20:31:27.923500 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 20:31:27.924131 drop table if exists "invoice_test"; [] gorptest: 20:31:27.954055 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:27.970641 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:27.997574 drop table if exists "invoice_override_test"; [] gorptest: 20:31:28.016923 drop table if exists "person_test"; [] gorptest: 20:31:28.050443 drop table if exists "ignored_column_test"; [] gorptest: 20:31:28.066494 drop table if exists "id_created_test"; [] gorptest: 20:31:28.091255 drop table if exists "type_conv_test"; [] gorptest: 20:31:28.104731 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:28.130612 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:28.160633 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:28.206279 drop table if exists "time_test"; [] gorptest: 20:31:28.223621 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.59s) === RUN TestTypeConversionExample 2023/06/07 20:31:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 20:31:28.224524 drop table if exists "invoice_test"; [] gorptest: 20:31:28.225463 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:28.225579 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:28.225683 drop table if exists "invoice_override_test"; [] gorptest: 20:31:28.225780 drop table if exists "person_test"; [] gorptest: 20:31:28.225913 drop table if exists "ignored_column_test"; [] gorptest: 20:31:28.226029 drop table if exists "id_created_test"; [] gorptest: 20:31:28.226122 drop table if exists "type_conv_test"; [] gorptest: 20:31:28.226218 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:28.226359 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:28.226480 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:28.226575 drop table if exists "time_test"; [] gorptest: 20:31:28.226719 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:28.257447 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: 20:31:28.286428 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:28.315198 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:28.356946 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:28.371989 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:28.397759 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:28.411715 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:28.438344 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:28.455759 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:28.509783 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:28.524822 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:28.554479 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: 20:31:28.582476 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 20:31:28.583033 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: 20:31:28.611903 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 20:31:28.612618 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 20:31:28.651544 drop table if exists "invoice_test"; [] gorptest: 20:31:28.678423 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:28.694813 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:28.722525 drop table if exists "invoice_override_test"; [] gorptest: 20:31:28.751572 drop table if exists "person_test"; [] gorptest: 20:31:28.778858 drop table if exists "ignored_column_test"; [] gorptest: 20:31:28.792515 drop table if exists "id_created_test"; [] gorptest: 20:31:28.819606 drop table if exists "type_conv_test"; [] gorptest: 20:31:28.845183 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:28.860344 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:28.886179 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:28.902257 drop table if exists "time_test"; [] gorptest: 20:31:28.928563 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.70s) === RUN TestWithEmbeddedStruct 2023/06/07 20:31:28 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 20:31:28.929376 drop table if exists "invoice_test"; [] gorptest: 20:31:28.930134 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:28.930232 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:28.930317 drop table if exists "invoice_override_test"; [] gorptest: 20:31:28.930405 drop table if exists "person_test"; [] gorptest: 20:31:28.930491 drop table if exists "ignored_column_test"; [] gorptest: 20:31:28.930576 drop table if exists "id_created_test"; [] gorptest: 20:31:28.930659 drop table if exists "type_conv_test"; [] gorptest: 20:31:28.930745 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:28.930828 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:28.930915 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:28.930999 drop table if exists "time_test"; [] gorptest: 20:31:28.931111 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:28.948826 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: 20:31:28.983387 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:29.012410 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:29.043295 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:29.060039 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:29.116486 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:29.143044 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:29.160163 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:29.167782 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:29.175677 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:29.196782 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:29.210279 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 20:31:29.222357 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 20:31:29.222840 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 20:31:29.265509 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 20:31:29.265997 select * from embedded_struct_test [] gorptest: 20:31:29.266370 drop table if exists "invoice_test"; [] gorptest: 20:31:29.287968 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:29.310348 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:29.321575 drop table if exists "invoice_override_test"; [] gorptest: 20:31:29.341030 drop table if exists "person_test"; [] gorptest: 20:31:29.348723 drop table if exists "ignored_column_test"; [] gorptest: 20:31:29.356882 drop table if exists "id_created_test"; [] gorptest: 20:31:29.371329 drop table if exists "type_conv_test"; [] gorptest: 20:31:29.379390 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:29.387647 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:29.414123 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:29.442666 drop table if exists "time_test"; [] gorptest: 20:31:29.474957 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.55s) === RUN TestWithEmbeddedStructBeforeAutoincr 2023/06/07 20:31:29 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: 20:31:29.475867 drop table if exists "invoice_test"; [] gorptest: 20:31:29.476688 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:29.476869 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:29.476991 drop table if exists "invoice_override_test"; [] gorptest: 20:31:29.477098 drop table if exists "person_test"; [] gorptest: 20:31:29.477203 drop table if exists "ignored_column_test"; [] gorptest: 20:31:29.477301 drop table if exists "id_created_test"; [] gorptest: 20:31:29.477409 drop table if exists "type_conv_test"; [] gorptest: 20:31:29.477517 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:29.477633 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:29.477744 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:29.477858 drop table if exists "time_test"; [] gorptest: 20:31:29.478000 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:29.515365 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: 20:31:29.541989 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:29.578479 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:29.596551 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:29.622610 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:29.658103 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:29.698204 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:29.731911 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:29.764203 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:29.794886 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:29.839374 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:30.088865 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 20:31:30.174988 drop table if exists "invoice_test"; [] gorptest: 20:31:30.220358 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:30.231848 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:30.249972 drop table if exists "invoice_override_test"; [] gorptest: 20:31:30.274849 drop table if exists "person_test"; [] gorptest: 20:31:30.285821 drop table if exists "ignored_column_test"; [] gorptest: 20:31:30.295743 drop table if exists "id_created_test"; [] gorptest: 20:31:30.314945 drop table if exists "type_conv_test"; [] gorptest: 20:31:30.325800 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:30.335201 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:30.344663 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:30.353250 drop table if exists "time_test"; [] gorptest: 20:31:30.361325 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.89s) === RUN TestWithEmbeddedAutoincr 2023/06/07 20:31:30 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: 20:31:30.362154 drop table if exists "invoice_test"; [] gorptest: 20:31:30.362954 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:30.363078 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:30.363191 drop table if exists "invoice_override_test"; [] gorptest: 20:31:30.363302 drop table if exists "person_test"; [] gorptest: 20:31:30.363412 drop table if exists "ignored_column_test"; [] gorptest: 20:31:30.363802 drop table if exists "id_created_test"; [] gorptest: 20:31:30.363921 drop table if exists "type_conv_test"; [] gorptest: 20:31:30.364038 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:30.364151 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:30.364360 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:30.364487 drop table if exists "time_test"; [] gorptest: 20:31:30.364611 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:30.382682 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: 20:31:30.399232 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:30.420012 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:30.428931 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:30.437139 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:30.447379 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:30.457025 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:30.478513 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:30.486912 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:30.496231 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:30.504669 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:30.524336 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 20:31:30.538361 drop table if exists "invoice_test"; [] gorptest: 20:31:30.557146 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:30.566799 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:30.577170 drop table if exists "invoice_override_test"; [] gorptest: 20:31:30.595959 drop table if exists "person_test"; [] gorptest: 20:31:30.605085 drop table if exists "ignored_column_test"; [] gorptest: 20:31:30.618527 drop table if exists "id_created_test"; [] gorptest: 20:31:30.626567 drop table if exists "type_conv_test"; [] gorptest: 20:31:30.634880 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:30.646323 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:30.658795 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:30.667811 drop table if exists "time_test"; [] gorptest: 20:31:30.675304 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.31s) === RUN TestSelectVal gorptest: 20:31:30.676235 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 20:31:30.684597 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: 20:31:30.692746 select Int64 from TableWithNull where Str='abc' [] gorptest: 20:31:30.693116 select count(*) from TableWithNull [] gorptest: 20:31:30.693345 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 20:31:30.693594 select Int64 from TableWithNull where Str='notfound' [] gorptest: 20:31:30.693808 select Int64 from TableWithNull where Str='abc' [] gorptest: 20:31:30.694098 select Float64 from TableWithNull where Str='abc' [] gorptest: 20:31:30.694313 select min(Float64) from TableWithNull [] gorptest: 20:31:30.694542 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 20:31:30.694797 select Float64 from TableWithNull where Str='notfound' [] gorptest: 20:31:30.694998 select Float64 from TableWithNull where Str='abc' [] gorptest: 20:31:30.695214 select Str from TableWithNull where Int64=? [1:78] gorptest: 20:31:30.695474 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 20:31:30.695678 select Str from TableWithNull where Int64=? [1:78] gorptest: 20:31:30.695891 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 20:31:30.696196 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 20:31:30.696436 select Str from TableWithNull where Int64=? [1:78] gorptest: 20:31:30.696661 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.03s) === RUN TestVersionMultipleRows 2023/06/07 20:31:30 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: 20:31:30.708081 drop table if exists "invoice_test"; [] gorptest: 20:31:30.708980 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:30.709107 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:30.709217 drop table if exists "invoice_override_test"; [] gorptest: 20:31:30.709333 drop table if exists "person_test"; [] gorptest: 20:31:30.709452 drop table if exists "ignored_column_test"; [] gorptest: 20:31:30.709563 drop table if exists "id_created_test"; [] gorptest: 20:31:30.709671 drop table if exists "type_conv_test"; [] gorptest: 20:31:30.709776 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:30.709881 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:30.709988 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:30.710090 drop table if exists "time_test"; [] gorptest: 20:31:30.710226 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:30.739669 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: 20:31:30.748830 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:30.760140 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:30.769223 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:30.780842 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:30.788933 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:30.811586 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:30.820684 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:30.828523 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:30.836218 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:30.844282 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:30.854646 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119490854572529 2:1686119490854572529 3:"Bob" 4:"Smith" 5:1] gorptest: 20:31:30.872788 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119490872646742 2:1686119490872646742 3:"Jane" 4:"Smith" 5:1] gorptest: 20:31:30.880678 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119490880622557 2:1686119490880622557 3:"Mike" 4:"Smith" 5:1] gorptest: 20:31:30.888435 drop table if exists "invoice_test"; [] gorptest: 20:31:30.896252 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:30.904076 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:30.911672 drop table if exists "invoice_override_test"; [] gorptest: 20:31:30.919879 drop table if exists "person_test"; [] gorptest: 20:31:30.927896 drop table if exists "ignored_column_test"; [] gorptest: 20:31:30.947366 drop table if exists "id_created_test"; [] gorptest: 20:31:30.955203 drop table if exists "type_conv_test"; [] gorptest: 20:31:30.963028 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:30.970669 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:30.978841 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:30.986827 drop table if exists "time_test"; [] gorptest: 20:31:30.994725 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.29s) === RUN TestWithStringPk gorptest: 20:31:30.995527 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 20:31:31.004095 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 20:31:31.023280 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.04s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2023/06/07 20:31:31 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: 20:31:31.032192 drop table if exists "invoice_test"; [] gorptest: 20:31:31.033046 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.033214 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.033354 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.033507 drop table if exists "person_test"; [] gorptest: 20:31:31.033621 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.033779 drop table if exists "id_created_test"; [] gorptest: 20:31:31.033888 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.034044 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.034181 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.034314 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.034447 drop table if exists "time_test"; [] gorptest: 20:31:31.034602 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.042214 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: 20:31:31.050211 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:31.057852 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.065574 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:31.073147 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.081041 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.101010 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:31.108736 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:31.116472 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:31.128141 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:31.137027 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:31.149916 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-07 06:00:31.149823266 +0000 UTC] gorptest: 20:31:31.158788 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-07 06:01:32.149823266 +0000 UTC] gorptest: 20:31:31.184970 SELECT id FROM time_test WHERE Time < ? [1:2023-06-07 06:01:31.149823266 +0000 UTC] gorptest: 20:31:31.185475 drop table if exists "invoice_test"; [] gorptest: 20:31:31.194599 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.202712 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.210986 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.218923 drop table if exists "person_test"; [] gorptest: 20:31:31.226291 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.235174 drop table if exists "id_created_test"; [] gorptest: 20:31:31.257901 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.280832 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.302261 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.313560 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.321234 drop table if exists "time_test"; [] gorptest: 20:31:31.328409 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.30s) === RUN TestInvoicePersonView 2023/06/07 20:31:31 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: 20:31:31.329310 drop table if exists "invoice_test"; [] gorptest: 20:31:31.330045 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.330186 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.330300 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.330437 drop table if exists "person_test"; [] gorptest: 20:31:31.330579 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.330696 drop table if exists "id_created_test"; [] gorptest: 20:31:31.330807 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.330953 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.331063 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.331202 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.331318 drop table if exists "time_test"; [] gorptest: 20:31:31.331538 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.339256 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: 20:31:31.356394 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:31.364230 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.372574 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:31.380337 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.388215 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.396162 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:31.407633 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:31.415552 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:31.438237 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:31.446221 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:31.454019 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119491453922818 2:1686119491453922818 3:"bob" 4:"smith" 5:1] gorptest: 20:31:31.462103 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 20:31:31.469802 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 20:31:31.470328 drop table if exists "invoice_test"; [] gorptest: 20:31:31.478936 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.488200 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.499245 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.515330 drop table if exists "person_test"; [] gorptest: 20:31:31.523800 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.531740 drop table if exists "id_created_test"; [] gorptest: 20:31:31.539784 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.548074 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.555498 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.563030 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.574429 drop table if exists "time_test"; [] gorptest: 20:31:31.587697 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.26s) === RUN TestQuoteTableNames 2023/06/07 20:31:31 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: 20:31:31.588578 drop table if exists "invoice_test"; [] gorptest: 20:31:31.589599 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.589855 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.589992 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.590075 drop table if exists "person_test"; [] gorptest: 20:31:31.590178 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.590268 drop table if exists "id_created_test"; [] gorptest: 20:31:31.590360 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.590500 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.590635 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.590752 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.590839 drop table if exists "time_test"; [] gorptest: 20:31:31.590981 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.598570 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: 20:31:31.605935 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:31.613586 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.621527 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:31.629141 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.636821 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:31.658476 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:31.666901 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:31.674928 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:31.682876 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:31.788104 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.34s) === RUN TestSelectTooManyCols 2023/06/07 20:31:31 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: 20:31:31.932894 drop table if exists "invoice_test"; [] gorptest: 20:31:31.933701 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:31.933869 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:31.934021 drop table if exists "invoice_override_test"; [] gorptest: 20:31:31.934172 drop table if exists "person_test"; [] gorptest: 20:31:31.934321 drop table if exists "ignored_column_test"; [] gorptest: 20:31:31.934472 drop table if exists "id_created_test"; [] gorptest: 20:31:31.934611 drop table if exists "type_conv_test"; [] gorptest: 20:31:31.934751 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:31.934885 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:31.935010 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:31.935142 drop table if exists "time_test"; [] gorptest: 20:31:31.935300 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.943573 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: 20:31:31.951837 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:31.963668 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:31.989300 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:32.010665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.019401 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.030004 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:32.044185 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:32.057574 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:32.067251 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:32.076211 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:32.091908 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119492091830867 2:1686119492091830867 3:"bob" 4:"smith" 5:1] gorptest: 20:31:32.102123 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119492102062332 2:1686119492102062332 3:"jane" 4:"doe" 5:1] gorptest: 20:31:32.122804 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:32.123297 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 20:31:32.123757 select * from person_test where Id=? [1:1] gorptest: 20:31:32.124117 select * from person_test order by fname asc [] gorptest: 20:31:32.124521 drop table if exists "invoice_test"; [] gorptest: 20:31:32.133379 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.142316 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.150855 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.160297 drop table if exists "person_test"; [] gorptest: 20:31:32.183788 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.192033 drop table if exists "id_created_test"; [] gorptest: 20:31:32.199887 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.207930 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.215968 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.233240 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.244595 drop table if exists "time_test"; [] gorptest: 20:31:32.267335 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.34s) === RUN TestSelectSingleVal 2023/06/07 20:31:32 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: 20:31:32.268224 drop table if exists "invoice_test"; [] gorptest: 20:31:32.269100 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.269206 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.269291 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.269376 drop table if exists "person_test"; [] gorptest: 20:31:32.269459 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.269537 drop table if exists "id_created_test"; [] gorptest: 20:31:32.269618 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.269700 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.269780 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.269882 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.269992 drop table if exists "time_test"; [] gorptest: 20:31:32.270148 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.282093 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: 20:31:32.290774 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:32.298639 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.306677 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:32.314797 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.323237 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.331515 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:32.351539 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:32.359570 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:32.367629 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:32.375309 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:32.383489 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119492383389889 2:1686119492383389889 3:"bob" 4:"smith" 5:1] gorptest: 20:31:32.391149 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 20:31:32.391928 select * from person_test where Id=? [1:1] gorptest: 20:31:32.392342 select FName from person_test where Id=? [1:1] gorptest: 20:31:32.392593 select * from person_test where Id=? [1:1] gorptest: 20:31:32.392970 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 20:31:32.393237 select * from person_test where Id=? [1:-2222] gorptest: 20:31:32.393491 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1686119492393449630 2:1686119492393449630 3:"bob" 4:"smith" 5:1] gorptest: 20:31:32.401393 select * from person_test where Fname='bob' [] gorptest: 20:31:32.401921 select * from person_test where Id=-123 [] gorptest: 20:31:32.402175 select * from person_test where Id=-123 [] gorptest: 20:31:32.402418 select * from person_test where Id=-123 [] gorptest: 20:31:32.402643 select * from person_test where Id=-123 [] gorptest: 20:31:32.402911 drop table if exists "invoice_test"; [] gorptest: 20:31:32.411348 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.430552 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.438556 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.446503 drop table if exists "person_test"; [] gorptest: 20:31:32.454574 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.462044 drop table if exists "id_created_test"; [] gorptest: 20:31:32.469732 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.477458 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.485082 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.503391 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.511197 drop table if exists "time_test"; [] gorptest: 20:31:32.518784 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.25s) === RUN TestSelectAlias 2023/06/07 20:31:32 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: 20:31:32.519977 drop table if exists "invoice_test"; [] gorptest: 20:31:32.520903 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.521066 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.521176 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.521357 drop table if exists "person_test"; [] gorptest: 20:31:32.521478 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.521700 drop table if exists "id_created_test"; [] gorptest: 20:31:32.521856 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.522068 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.522225 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.522368 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.522497 drop table if exists "time_test"; [] gorptest: 20:31:32.522644 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.530590 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: 20:31:32.538790 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:32.546834 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.554839 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:32.573568 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.581788 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.589823 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:32.598207 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:32.606747 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:32.615024 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:32.622928 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:32.630873 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 20:31:32.650371 select * from id_created_test where Id=1 [] gorptest: 20:31:32.650818 SELECT *, 1 AS external FROM id_created_test [] gorptest: 20:31:32.651252 drop table if exists "invoice_test"; [] gorptest: 20:31:32.660573 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.668449 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.676193 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.684196 drop table if exists "person_test"; [] gorptest: 20:31:32.692047 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.700227 drop table if exists "id_created_test"; [] gorptest: 20:31:32.708372 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.725734 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.734019 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.741887 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.750007 drop table if exists "time_test"; [] gorptest: 20:31:32.757589 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.24s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2023/06/07 20:31:32 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: 20:31:32.758567 drop table if exists "invoice_test"; [] gorptest: 20:31:32.759303 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.759484 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.759601 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.759744 drop table if exists "person_test"; [] gorptest: 20:31:32.759903 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.760063 drop table if exists "id_created_test"; [] gorptest: 20:31:32.760174 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.760336 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.760449 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.760634 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.760799 drop table if exists "time_test"; [] gorptest: 20:31:32.760972 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.768521 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: 20:31:32.783950 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:32.792520 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:32.810793 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:32.819160 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.827348 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:32.835179 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:32.842925 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:32.851100 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:32.859769 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:32.868598 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:32.887034 drop table if exists "invoice_test"; [] gorptest: 20:31:32.894841 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:32.902808 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:32.910695 drop table if exists "invoice_override_test"; [] gorptest: 20:31:32.918789 drop table if exists "person_test"; [] gorptest: 20:31:32.926405 drop table if exists "ignored_column_test"; [] gorptest: 20:31:32.934249 drop table if exists "id_created_test"; [] gorptest: 20:31:32.942101 drop table if exists "type_conv_test"; [] gorptest: 20:31:32.960927 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:32.968948 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:32.979706 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:32.987340 drop table if exists "time_test"; [] gorptest: 20:31:32.994835 drop table if exists "id_created_test"; [] gorptest: 20:31:32.995149 drop table if exists "single_column_table"; [] gorptest: 20:31:32.995346 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: 20:31:33.003105 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: 20:31:33.010919 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:33.029781 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: 20:31:33.037855 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: 20:31:33.045808 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:33.053500 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:33.061249 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:33.068897 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:33.076606 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:33.084268 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: 20:31:33.105118 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:33.112907 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 20:31:33.113172 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 20:31:33.122910 delete from "invoice_test"; [] gorptest: 20:31:33.133444 delete from "invoice_tag_test"; [] gorptest: 20:31:33.140617 delete from "alias_trans_field_test"; [] gorptest: 20:31:33.147736 delete from "invoice_override_test"; [] gorptest: 20:31:33.154703 delete from "person_test"; [] gorptest: 20:31:33.161343 delete from "ignored_column_test"; [] gorptest: 20:31:33.183299 delete from "id_created_test"; [] gorptest: 20:31:33.190649 delete from "type_conv_test"; [] gorptest: 20:31:33.197377 delete from "embedded_struct_test"; [] gorptest: 20:31:33.204404 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:33.211331 delete from "embedded_autoincr_test"; [] gorptest: 20:31:33.218828 delete from "time_test"; [] gorptest: 20:31:33.225897 delete from "id_created_test"; [] gorptest: 20:31:33.236888 delete from "single_column_table"; [] gorptest: 20:31:33.250764 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 20:31:33.251130 drop table if exists "invoice_test"; [] gorptest: 20:31:33.258525 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:33.266069 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:33.273694 drop table if exists "invoice_override_test"; [] gorptest: 20:31:33.281496 drop table if exists "person_test"; [] gorptest: 20:31:33.288688 drop table if exists "ignored_column_test"; [] gorptest: 20:31:33.296882 drop table if exists "id_created_test"; [] gorptest: 20:31:33.312256 drop table if exists "type_conv_test"; [] gorptest: 20:31:33.326725 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:33.334737 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:33.342586 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:33.350682 drop table if exists "time_test"; [] gorptest: 20:31:33.358399 drop table if exists "id_created_test"; [] gorptest: 20:31:33.358687 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.61s) === RUN TestPrepare 2023/06/07 20:31:33 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 20:31:33.367798 drop table if exists "invoice_test"; [] gorptest: 20:31:33.368618 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:33.368826 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:33.368952 drop table if exists "invoice_override_test"; [] gorptest: 20:31:33.369070 drop table if exists "person_test"; [] gorptest: 20:31:33.369177 drop table if exists "ignored_column_test"; [] gorptest: 20:31:33.369270 drop table if exists "id_created_test"; [] gorptest: 20:31:33.369367 drop table if exists "type_conv_test"; [] gorptest: 20:31:33.369485 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:33.369602 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:33.369705 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:33.369810 drop table if exists "time_test"; [] gorptest: 20:31:33.369961 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:33.382211 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: 20:31:33.400485 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 20:31:33.408979 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 20:31:33.422529 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 20:31:33.430555 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:33.438385 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 20:31:33.450850 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 20:31:33.459270 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 20:31:33.468606 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 20:31:33.486964 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 20:31:33.497132 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 20:31:33.506328 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 20:31:33.514526 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 20:31:33.523639 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 20:31:33.534608 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 20:31:33.535505 begin; [] gorptest: 20:31:33.535675 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 20:31:33.536164 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 20:31:33.537792 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 20:31:33.538178 commit; [] gorptest: 20:31:33.544950 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 20:31:33.545512 drop table if exists "invoice_test"; [] gorptest: 20:31:33.552722 drop table if exists "invoice_tag_test"; [] gorptest: 20:31:33.571014 drop table if exists "alias_trans_field_test"; [] gorptest: 20:31:33.578989 drop table if exists "invoice_override_test"; [] gorptest: 20:31:33.586779 drop table if exists "person_test"; [] gorptest: 20:31:33.594282 drop table if exists "ignored_column_test"; [] gorptest: 20:31:33.601828 drop table if exists "id_created_test"; [] gorptest: 20:31:33.609218 drop table if exists "type_conv_test"; [] gorptest: 20:31:33.617014 drop table if exists "embedded_struct_test"; [] gorptest: 20:31:33.624574 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 20:31:33.643844 drop table if exists "embedded_autoincr_test"; [] gorptest: 20:31:33.651640 drop table if exists "time_test"; [] gorptest: 20:31:33.659254 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.29s) PASS ok gopkg.in/gorp.v1 35.296s 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_armhf.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_armhf.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/29263/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/29263/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/29263 and its subdirectories I: Current time: Wed Jun 7 20:31:45 +14 2023 I: pbuilder-time-stamp: 1686119505