W: cgroups are not available on the host, not using them. unshare: unshare failed: Cannot allocate memory W: pbuilder: unshare CLONE_NEWNET not available I: pbuilder: network access is available during build! I: Current time: Wed Apr 12 22:19:46 +14 2023 I: pbuilder-time-stamp: 1681287586 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: using eatmydata during job I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: Signature made 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/6627/tmp/hooks/D01_modify_environment starting debug: Running on ionos12-i386. I: Changing host+domainname to test build reproducibility I: Adding a custom variable just for the fun of it... I: Changing /bin/sh to bash lrwxrwxrwx 1 root root 4 Jan 6 03:20 /bin/sh -> dash 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/6627/tmp/hooks/D01_modify_environment finished I: user script /srv/workspace/pbuilder/6627/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build' BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' BUILDUSERNAME='pbuilder2' BUILD_ARCH='i386' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=7' DISTRIBUTION='bookworm' HOME='/root' HOST_ARCH='i386' IFS=' ' LANG='C' LANGUAGE='de_CH:de' LC_ALL='C' LD_LIBRARY_PATH='/usr/lib/libeatmydata' LD_PRELOAD='libeatmydata.so' MAIL='/var/mail/root' OPTIND='1' 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' PPID='6627' PS1='# ' PS2='> ' PS4='+ ' PWD='/' SHELL='/bin/bash' SHLVL='2' 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.sEpfGGrm/pbuilderrc_oCv5 --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.sEpfGGrm/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='112' SUDO_UID='107' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT-14' USER='root' _='/usr/sbin/chroot' http_proxy='http://78.137.99.97:3128' I: uname -a Linux i-capture-the-hostname 5.10.0-21-686-pae #1 SMP Debian 5.10.162-1 (2023-01-21) i686 GNU/Linux I: ls -l /bin total 6040 -rwxr-xr-x 1 root root 1408088 Feb 13 10:21 bash -rwxr-xr-x 3 root root 38404 Sep 19 2022 bunzip2 -rwxr-xr-x 3 root root 38404 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 38404 Sep 19 2022 bzip2 -rwxr-xr-x 1 root root 17892 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 42920 Sep 21 2022 cat -rwxr-xr-x 1 root root 79816 Sep 21 2022 chgrp -rwxr-xr-x 1 root root 67496 Sep 21 2022 chmod -rwxr-xr-x 1 root root 79816 Sep 21 2022 chown -rwxr-xr-x 1 root root 162024 Sep 21 2022 cp -rwxr-xr-x 1 root root 136916 Jan 6 03:20 dash -rwxr-xr-x 1 root root 137160 Sep 21 2022 date -rwxr-xr-x 1 root root 100364 Sep 21 2022 dd -rwxr-xr-x 1 root root 108940 Sep 21 2022 df -rwxr-xr-x 1 root root 162152 Sep 21 2022 dir -rwxr-xr-x 1 root root 87760 Mar 24 00:20 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 38760 Sep 21 2022 echo -rwxr-xr-x 1 root root 41 Jan 25 04:43 egrep -rwxr-xr-x 1 root root 34664 Sep 21 2022 false -rwxr-xr-x 1 root root 41 Jan 25 04:43 fgrep -rwxr-xr-x 1 root root 84272 Mar 24 00:20 findmnt -rwsr-xr-x 1 root root 30240 Mar 23 22:38 fusermount -rwxr-xr-x 1 root root 218680 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 100952 Apr 10 2022 gzip -rwxr-xr-x 1 root root 21916 Dec 20 03:33 hostname -rwxr-xr-x 1 root root 75756 Sep 21 2022 ln -rwxr-xr-x 1 root root 55600 Mar 24 01:43 login -rwxr-xr-x 1 root root 162152 Sep 21 2022 ls -rwxr-xr-x 1 root root 214568 Mar 24 00:20 lsblk -rwxr-xr-x 1 root root 96328 Sep 21 2022 mkdir -rwxr-xr-x 1 root root 84008 Sep 21 2022 mknod -rwxr-xr-x 1 root root 38792 Sep 21 2022 mktemp -rwxr-xr-x 1 root root 63016 Mar 24 00:20 more -rwsr-xr-x 1 root root 58912 Mar 24 00:20 mount -rwxr-xr-x 1 root root 13856 Mar 24 00:20 mountpoint -rwxr-xr-x 1 root root 157932 Sep 21 2022 mv lrwxrwxrwx 1 root root 8 Dec 20 03:33 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Dec 19 07:00 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 38792 Sep 21 2022 pwd lrwxrwxrwx 1 root root 4 Feb 13 10:21 rbash -> bash -rwxr-xr-x 1 root root 51080 Sep 21 2022 readlink -rwxr-xr-x 1 root root 75720 Sep 21 2022 rm -rwxr-xr-x 1 root root 51080 Sep 21 2022 rmdir -rwxr-xr-x 1 root root 22308 Nov 3 06:31 run-parts -rwxr-xr-x 1 root root 133224 Jan 6 09:55 sed lrwxrwxrwx 1 root root 4 Jan 6 03:20 sh -> dash -rwxr-xr-x 1 root root 38760 Sep 21 2022 sleep -rwxr-xr-x 1 root root 87976 Sep 21 2022 stty -rwsr-xr-x 1 root root 83492 Mar 24 00:20 su -rwxr-xr-x 1 root root 38792 Sep 21 2022 sync -rwxr-xr-x 1 root root 602584 Feb 17 2021 tar -rwxr-xr-x 1 root root 13860 Nov 3 06:31 tempfile -rwxr-xr-x 1 root root 120776 Sep 21 2022 touch -rwxr-xr-x 1 root root 34664 Sep 21 2022 true -rwxr-xr-x 1 root root 17892 Mar 23 22:38 ulockmgr_server -rwsr-xr-x 1 root root 30236 Mar 24 00:20 umount -rwxr-xr-x 1 root root 38760 Sep 21 2022 uname -rwxr-xr-x 2 root root 2346 Apr 10 2022 uncompress -rwxr-xr-x 1 root root 162152 Sep 21 2022 vdir -rwxr-xr-x 1 root root 71216 Mar 24 00:20 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/6627/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: i386 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19604 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 107 MB of archives. After unpacking 574 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bookworm/main i386 sensible-utils all 0.0.17+nmu1 [19.0 kB] Get: 2 http://deb.debian.org/debian bookworm/main i386 libmagic-mgc i386 1:5.44-3 [305 kB] Get: 3 http://deb.debian.org/debian bookworm/main i386 libmagic1 i386 1:5.44-3 [114 kB] Get: 4 http://deb.debian.org/debian bookworm/main i386 file i386 1:5.44-3 [42.5 kB] Get: 5 http://deb.debian.org/debian bookworm/main i386 gettext-base i386 0.21-12 [162 kB] Get: 6 http://deb.debian.org/debian bookworm/main i386 libuchardet0 i386 0.0.7-1 [67.9 kB] Get: 7 http://deb.debian.org/debian bookworm/main i386 groff-base i386 1.22.4-10 [932 kB] Get: 8 http://deb.debian.org/debian bookworm/main i386 bsdextrautils i386 2.38.1-5+b1 [90.3 kB] Get: 9 http://deb.debian.org/debian bookworm/main i386 libpipeline1 i386 1.5.7-1 [40.0 kB] Get: 10 http://deb.debian.org/debian bookworm/main i386 man-db i386 2.11.2-2 [1397 kB] Get: 11 http://deb.debian.org/debian bookworm/main i386 m4 i386 1.4.19-3 [294 kB] Get: 12 http://deb.debian.org/debian bookworm/main i386 autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian bookworm/main i386 autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian bookworm/main i386 automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian bookworm/main i386 autopoint all 0.21-12 [495 kB] Get: 16 http://deb.debian.org/debian bookworm/main i386 libdebhelper-perl all 13.11.4 [81.2 kB] Get: 17 http://deb.debian.org/debian bookworm/main i386 libtool all 2.4.7-5 [517 kB] Get: 18 http://deb.debian.org/debian bookworm/main i386 dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian bookworm/main i386 libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian bookworm/main i386 libsub-override-perl all 0.09-4 [9304 B] Get: 21 http://deb.debian.org/debian bookworm/main i386 libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian bookworm/main i386 dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian bookworm/main i386 libelf1 i386 0.188-2.1 [179 kB] Get: 24 http://deb.debian.org/debian bookworm/main i386 dwz i386 0.15-1 [118 kB] Get: 25 http://deb.debian.org/debian bookworm/main i386 libicu72 i386 72.1-3 [9541 kB] Get: 26 http://deb.debian.org/debian bookworm/main i386 libxml2 i386 2.9.14+dfsg-1.1+b3 [720 kB] Get: 27 http://deb.debian.org/debian bookworm/main i386 gettext i386 0.21-12 [1311 kB] Get: 28 http://deb.debian.org/debian bookworm/main i386 intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian bookworm/main i386 po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian bookworm/main i386 debhelper all 13.11.4 [942 kB] Get: 31 http://deb.debian.org/debian bookworm/main i386 dh-golang all 1.59 [27.8 kB] Get: 32 http://deb.debian.org/debian bookworm/main i386 golang-1.19-src all 1.19.8-2 [18.3 MB] Get: 33 http://deb.debian.org/debian bookworm/main i386 golang-1.19-go i386 1.19.8-2 [61.2 MB] Get: 34 http://deb.debian.org/debian bookworm/main i386 golang-src all 2:1.19~1 [5756 B] Get: 35 http://deb.debian.org/debian bookworm/main i386 golang-go i386 2:1.19~1 [45.0 kB] Get: 36 http://deb.debian.org/debian bookworm/main i386 golang-any i386 2:1.19~1 [5872 B] Get: 37 http://deb.debian.org/debian bookworm/main i386 golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian bookworm/main i386 golang-github-go-sql-driver-mysql-dev all 1.5.0-2 [70.9 kB] Get: 39 http://deb.debian.org/debian bookworm/main i386 golang-github-gorilla-securecookie-dev all 1.1.1-2 [12.2 kB] Get: 40 http://deb.debian.org/debian bookworm/main i386 golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian bookworm/main i386 golang-github-hashicorp-go-uuid-dev all 1.0.2-2 [8480 B] Get: 42 http://deb.debian.org/debian bookworm/main i386 golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian bookworm/main i386 golang-github-stretchr-objx-dev all 0.5.0-1 [25.5 kB] Get: 44 http://deb.debian.org/debian bookworm/main i386 golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian bookworm/main i386 golang-github-stretchr-testify-dev all 1.8.1-1 [67.9 kB] Get: 46 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian bookworm/main i386 golang-golang-x-sys-dev all 0.3.0-1 [393 kB] Get: 51 http://deb.debian.org/debian bookworm/main i386 golang-golang-x-text-dev all 0.7.0-1 [3863 kB] Get: 52 http://deb.debian.org/debian bookworm/main i386 golang-golang-x-net-dev all 1:0.7.0+dfsg-1 [731 kB] Get: 53 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 54 http://deb.debian.org/debian bookworm/main i386 golang-golang-x-term-dev all 0.3.0-1 [14.6 kB] Get: 55 http://deb.debian.org/debian bookworm/main i386 golang-golang-x-crypto-dev all 1:0.4.0-1 [1449 kB] Get: 56 http://deb.debian.org/debian bookworm/main i386 golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian bookworm/main i386 golang-github-lib-pq-dev all 1.10.7-2 [84.1 kB] Get: 58 http://deb.debian.org/debian bookworm/main i386 libsqlite3-dev i386 3.40.1-2 [1105 kB] Get: 59 http://deb.debian.org/debian bookworm/main i386 golang-github-mattn-go-sqlite3-dev i386 1.14.16~ds1-1 [82.2 kB] Get: 60 http://deb.debian.org/debian bookworm/main i386 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 107 MB in 3s (40.1 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 ... 19604 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_i386.deb ... Unpacking libmagic-mgc (1:5.44-3) ... Selecting previously unselected package libmagic1:i386. Preparing to unpack .../02-libmagic1_1%3a5.44-3_i386.deb ... Unpacking libmagic1:i386 (1:5.44-3) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.44-3_i386.deb ... Unpacking file (1:5.44-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-12_i386.deb ... Unpacking gettext-base (0.21-12) ... Selecting previously unselected package libuchardet0:i386. Preparing to unpack .../05-libuchardet0_0.0.7-1_i386.deb ... Unpacking libuchardet0:i386 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.22.4-10_i386.deb ... Unpacking groff-base (1.22.4-10) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.38.1-5+b1_i386.deb ... Unpacking bsdextrautils (2.38.1-5+b1) ... Selecting previously unselected package libpipeline1:i386. Preparing to unpack .../08-libpipeline1_1.5.7-1_i386.deb ... Unpacking libpipeline1:i386 (1.5.7-1) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.11.2-2_i386.deb ... Unpacking man-db (2.11.2-2) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-3_i386.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:i386. Preparing to unpack .../22-libelf1_0.188-2.1_i386.deb ... Unpacking libelf1:i386 (0.188-2.1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1_i386.deb ... Unpacking dwz (0.15-1) ... Selecting previously unselected package libicu72:i386. Preparing to unpack .../24-libicu72_72.1-3_i386.deb ... Unpacking libicu72:i386 (72.1-3) ... Selecting previously unselected package libxml2:i386. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.1+b3_i386.deb ... Unpacking libxml2:i386 (2.9.14+dfsg-1.1+b3) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-12_i386.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_i386.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:i386. Preparing to unpack .../34-golang-go_2%3a1.19~1_i386.deb ... Unpacking golang-go:i386 (2:1.19~1) ... Selecting previously unselected package golang-any:i386. Preparing to unpack .../35-golang-any_2%3a1.19~1_i386.deb ... Unpacking golang-any:i386 (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:i386. Preparing to unpack .../57-libsqlite3-dev_3.40.1-2_i386.deb ... Unpacking libsqlite3-dev:i386 (3.40.1-2) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:i386. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.16~ds1-1_i386.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:i386 (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:i386 (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:i386 (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:i386 (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:i386 (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:i386 (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:i386 (0.188-2.1) ... Setting up golang-github-gorilla-securecookie-dev (1.1.1-2) ... Setting up libxml2:i386 (2.9.14+dfsg-1.1+b3) ... 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:i386 (2:1.19~1) ... Setting up golang-any:i386 (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:i386 (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-8) ... 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/6627/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/6627/tmp/hooks/A99_set_merged_usr finished 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 i386 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 7 gopkg.in/gorp.v1 internal/goarch internal/unsafeheader internal/goexperiment internal/goos internal/cpu runtime/internal/syscall runtime/internal/atomic internal/abi runtime/internal/math internal/race runtime/internal/sys sync/atomic unicode/utf8 unicode internal/itoa internal/bytealg math/bits math runtime internal/reflectlite sync internal/testlog errors sort internal/oserror io internal/safefilepath path strconv syscall strings bytes reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context io/fs internal/poll 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 7 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2023/04/12 22:20: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: 22:20:33.925331 drop table if exists "invoice_test"; [] gorptest: 22:20:33.926072 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:33.926145 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:33.926210 drop table if exists "invoice_override_test"; [] gorptest: 22:20:33.926258 drop table if exists "person_test"; [] gorptest: 22:20:33.926322 drop table if exists "ignored_column_test"; [] gorptest: 22:20:33.926376 drop table if exists "id_created_test"; [] gorptest: 22:20:33.926436 drop table if exists "type_conv_test"; [] gorptest: 22:20:33.926488 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:33.926547 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:33.926614 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:33.926680 drop table if exists "time_test"; [] gorptest: 22:20:33.926742 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:33.971267 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: 22:20:33.979172 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:33.984330 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:33.988996 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:33.994277 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.000445 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.007427 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.012749 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.017820 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.031843 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.044557 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.063742 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: 22:20:34.063853 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: 22:20:34.063945 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.064053 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: 22:20:34.064135 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: 22:20:34.064199 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.064274 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.064332 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.064411 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.064466 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.064544 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: 22:20:34.064605 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.064671 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:20:34.064728 drop table if exists "invoice_test"; [] gorptest: 22:20:34.068046 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.076004 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.079229 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.083149 drop table if exists "person_test"; [] gorptest: 22:20:34.086356 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.089989 drop table if exists "id_created_test"; [] gorptest: 22:20:34.093303 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.096616 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.099785 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.102849 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.105868 drop table if exists "time_test"; [] gorptest: 22:20:34.109129 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.18s) === RUN TestTruncateTables 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.109547 drop table if exists "invoice_test"; [] gorptest: 22:20:34.109908 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.109978 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.110028 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.110094 drop table if exists "person_test"; [] gorptest: 22:20:34.110155 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.110209 drop table if exists "id_created_test"; [] gorptest: 22:20:34.110275 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.110325 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.110390 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.110455 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.110522 drop table if exists "time_test"; [] gorptest: 22:20:34.110584 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.113596 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: 22:20:34.116855 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.120320 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.124291 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.132562 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.138840 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.142962 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.147154 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.150656 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.154127 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.157314 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.160871 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: 22:20:34.160961 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: 22:20:34.161010 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.161071 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: 22:20:34.161123 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: 22:20:34.161185 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.161231 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.161288 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.161337 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.161395 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.161460 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: 22:20:34.161522 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.161568 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:20:34.161650 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287634161623987 2:1681287634161623987 3:"Bob" 4:"Smith" 5:1] gorptest: 22:20:34.164771 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 22:20:34.167831 delete from "invoice_test"; [] gorptest: 22:20:34.171206 delete from "invoice_tag_test"; [] gorptest: 22:20:34.174537 delete from "alias_trans_field_test"; [] gorptest: 22:20:34.177582 delete from "invoice_override_test"; [] gorptest: 22:20:34.181021 delete from "person_test"; [] gorptest: 22:20:34.183951 delete from "ignored_column_test"; [] gorptest: 22:20:34.186797 delete from "id_created_test"; [] gorptest: 22:20:34.189726 delete from "type_conv_test"; [] gorptest: 22:20:34.194409 delete from "embedded_struct_test"; [] gorptest: 22:20:34.197775 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.200957 delete from "embedded_autoincr_test"; [] gorptest: 22:20:34.203899 delete from "time_test"; [] gorptest: 22:20:34.206640 delete from "id_created_test"; [] gorptest: 22:20:34.209376 SELECT * FROM person_test [] gorptest: 22:20:34.209590 SELECT * FROM invoice_test [] gorptest: 22:20:34.209743 drop table if exists "invoice_test"; [] gorptest: 22:20:34.213055 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.216194 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.219419 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.222788 drop table if exists "person_test"; [] gorptest: 22:20:34.226014 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.229255 drop table if exists "id_created_test"; [] gorptest: 22:20:34.232232 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.235505 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.239095 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.243223 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.246991 drop table if exists "time_test"; [] gorptest: 22:20:34.249960 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.14s) === RUN TestCustomDateType gorptest: 22:20:34.250207 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 22:20:34.253990 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-04-12 22:20:34 +1400 +14] gorptest: 22:20:34.256902 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 22:20:34.257035 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.01s) === RUN TestUIntPrimaryKey gorptest: 22:20:34.260448 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:20:34.263930 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:20:34.266978 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 22:20:34.270151 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 22:20:34.273393 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 22:20:34.276287 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 22:20:34.279431 drop table if exists "PersonUInt64"; [] gorptest: 22:20:34.282517 drop table if exists "PersonUInt32"; [] gorptest: 22:20:34.285440 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.03s) === RUN TestSetUniqueTogether gorptest: 22:20:34.288619 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 22:20:34.292057 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 22:20:34.294871 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 22:20:34.295013 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 22:20:34.295120 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 22:20:34.298514 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.01s) === RUN TestPersistentUser gorptest: 22:20:34.302257 drop table if exists PersistentUser [] gorptest: 22:20:34.302665 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:20:34.306446 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:20:34.309541 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 22:20:34.309661 select * from PersistentUser [] gorptest: 22:20:34.309777 select * from PersistentUser [] gorptest: 22:20:34.309887 select * from PersistentUser [] gorptest: 22:20:34.309999 select Id from PersistentUser [] gorptest: 22:20:34.310098 select mykey from PersistentUser [] gorptest: 22:20:34.310178 select PassedTraining from PersistentUser [] gorptest: 22:20:34.310244 select Id from PersistentUser [] gorptest: 22:20:34.310326 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.01s) === RUN TestNamedQueryMap gorptest: 22:20:34.313810 drop table if exists PersistentUser [] gorptest: 22:20:34.314145 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:20:34.317375 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:20:34.320328 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 22:20:34.322985 select * from PersistentUser where mykey = ? [1:43] gorptest: 22:20:34.323149 select * from PersistentUser where mykey = ? [1:43] gorptest: 22:20:34.323298 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 22:20:34.323497 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 22:20:34.323639 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.01s) === RUN TestNamedQueryStruct gorptest: 22:20:34.326680 drop table if exists PersistentUser [] gorptest: 22:20:34.327000 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 22:20:34.330326 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 22:20:34.333173 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 22:20:34.336265 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 22:20:34.336435 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.01s) === RUN TestReturnsNonNilSlice 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.339642 drop table if exists "invoice_test"; [] gorptest: 22:20:34.339972 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.340031 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.340070 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.340122 drop table if exists "person_test"; [] gorptest: 22:20:34.340162 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.340215 drop table if exists "id_created_test"; [] gorptest: 22:20:34.340255 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.340304 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.340361 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.340401 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.340452 drop table if exists "time_test"; [] gorptest: 22:20:34.340502 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.343739 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: 22:20:34.347098 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.350558 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.353772 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.356980 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.360501 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.363536 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.367692 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.371846 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.374900 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.378556 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.381604 select * from invoice_test where id=99999 [] gorptest: 22:20:34.381748 select * from invoice_test where id=99999 [] gorptest: 22:20:34.381869 drop table if exists "invoice_test"; [] gorptest: 22:20:34.385131 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.388653 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.393351 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.396819 drop table if exists "person_test"; [] gorptest: 22:20:34.400106 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.403325 drop table if exists "id_created_test"; [] gorptest: 22:20:34.406614 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.410105 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.413324 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.416698 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.419927 drop table if exists "time_test"; [] gorptest: 22:20:34.423609 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.08s) === RUN TestOverrideVersionCol gorptest: 22:20:34.423956 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 22:20:34.427385 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: 22:20:34.427531 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.01s) === RUN TestOptimisticLocking 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.431251 drop table if exists "invoice_test"; [] gorptest: 22:20:34.431582 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.431642 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.431681 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.431733 drop table if exists "person_test"; [] gorptest: 22:20:34.431771 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.431821 drop table if exists "id_created_test"; [] gorptest: 22:20:34.431859 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.431897 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.431948 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.431986 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.432024 drop table if exists "time_test"; [] gorptest: 22:20:34.432085 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.435404 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: 22:20:34.438913 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.442132 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.445290 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.448581 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.452576 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.456124 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.460037 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.463046 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.466260 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.469219 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.472707 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287634472679602 2:1681287634472679602 3:"Bob" 4:"Smith" 5:1] gorptest: 22:20:34.476115 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:34.476294 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1681287634472679602 2:1681287634472679602 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 22:20:34.479000 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1681287634472679602 2:1681287634472679602 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 22:20:34.479128 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:34.479254 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 22:20:34.479339 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:34.479486 drop table if exists "invoice_test"; [] gorptest: 22:20:34.482727 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.486036 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.489301 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.492744 drop table if exists "person_test"; [] gorptest: 22:20:34.496114 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.499346 drop table if exists "id_created_test"; [] gorptest: 22:20:34.503563 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.506574 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.510396 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.513808 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.516991 drop table if exists "time_test"; [] gorptest: 22:20:34.520005 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.09s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 22:20:34.520361 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 22:20:34.523781 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 22:20:34.526828 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 22:20:34.527002 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: 22:20:34.530703 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 22:20:34.530867 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.01s) === RUN TestColumnProps gorptest: 22:20:34.534438 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 22:20:34.538290 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 22:20:34.541716 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 22:20:34.541862 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 22:20:34.541970 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 22:20:34.542065 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.01s) === RUN TestRawSelect 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.545535 drop table if exists "invoice_test"; [] gorptest: 22:20:34.545914 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.545975 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.546019 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.546094 drop table if exists "person_test"; [] gorptest: 22:20:34.546146 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.546184 drop table if exists "id_created_test"; [] gorptest: 22:20:34.546222 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.546272 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.546310 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.546349 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.546399 drop table if exists "time_test"; [] gorptest: 22:20:34.546445 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.549844 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: 22:20:34.553593 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.557316 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.560388 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.563650 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.567339 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.571001 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.574538 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.577559 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.580849 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.584273 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.588214 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287634588190250 2:1681287634588190250 3:"bob" 4:"smith" 5:1] gorptest: 22:20:34.591529 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 22:20:34.595034 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 22:20:34.595232 drop table if exists "invoice_test"; [] gorptest: 22:20:34.598282 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.601461 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.604744 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.607820 drop table if exists "person_test"; [] gorptest: 22:20:34.610726 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.613716 drop table if exists "id_created_test"; [] gorptest: 22:20:34.617046 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.620310 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.623581 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.626605 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.630275 drop table if exists "time_test"; [] gorptest: 22:20:34.636250 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.09s) === RUN TestHooks 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.636569 drop table if exists "invoice_test"; [] gorptest: 22:20:34.636885 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.636945 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.636985 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.637037 drop table if exists "person_test"; [] gorptest: 22:20:34.637075 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.637126 drop table if exists "id_created_test"; [] gorptest: 22:20:34.637163 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.637201 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.637252 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.637291 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.637342 drop table if exists "time_test"; [] gorptest: 22:20:34.637389 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.640169 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: 22:20:34.643620 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.646662 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.649760 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.652818 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.656026 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.659258 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.662362 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.665713 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.668888 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.672095 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.675125 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287634675101261 2:1681287634675101261 3:"bob" 4:"smith" 5:1] gorptest: 22:20:34.678375 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:34.678550 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1681287634675101261 2:1681287634675101261 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 22:20:34.681597 select * from person_test where id = ? [1:1] gorptest: 22:20:34.681785 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 22:20:34.684858 drop table if exists "invoice_test"; [] gorptest: 22:20:34.687648 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.691510 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.694663 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.698285 drop table if exists "person_test"; [] gorptest: 22:20:34.703073 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.711263 drop table if exists "id_created_test"; [] gorptest: 22:20:34.715847 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.720617 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.723287 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.734001 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.745435 drop table if exists "time_test"; [] gorptest: 22:20:34.748878 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.11s) === RUN TestTransaction 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.749241 drop table if exists "invoice_test"; [] gorptest: 22:20:34.749557 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.749617 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.749657 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.749709 drop table if exists "person_test"; [] gorptest: 22:20:34.749747 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.749798 drop table if exists "id_created_test"; [] gorptest: 22:20:34.749835 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.749874 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.749925 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.749964 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.750002 drop table if exists "time_test"; [] gorptest: 22:20:34.750062 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.753459 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: 22:20:34.756540 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.759796 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.763051 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.766801 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.770292 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.773479 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.777167 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.780181 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.783406 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.787408 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.791027 begin; [] gorptest: 22:20:34.791125 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 22:20:34.791355 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 22:20:34.791458 commit; [] gorptest: 22:20:34.795241 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:34.795431 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 22:20:34.795550 drop table if exists "invoice_test"; [] gorptest: 22:20:34.799855 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.803521 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.806566 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.809821 drop table if exists "person_test"; [] gorptest: 22:20:34.812972 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.816171 drop table if exists "id_created_test"; [] gorptest: 22:20:34.820036 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.823187 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.826556 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.829567 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.833180 drop table if exists "time_test"; [] gorptest: 22:20:34.836205 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.09s) === RUN TestSavepoint 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.836535 drop table if exists "invoice_test"; [] gorptest: 22:20:34.836842 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.836901 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.836941 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.836993 drop table if exists "person_test"; [] gorptest: 22:20:34.837032 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.837082 drop table if exists "id_created_test"; [] gorptest: 22:20:34.837120 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.837159 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.837210 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.837253 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.837305 drop table if exists "time_test"; [] gorptest: 22:20:34.837351 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.840472 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: 22:20:34.843889 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.846918 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.850768 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.853866 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.857490 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.860832 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.865218 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.869140 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.872416 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.875794 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.878771 begin; [] gorptest: 22:20:34.878861 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 22:20:34.879052 select memo from invoice_test [] gorptest: 22:20:34.879154 savepoint "foo" [1:] gorptest: 22:20:34.879202 select memo from invoice_test [] gorptest: 22:20:34.879296 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 22:20:34.879394 select memo from invoice_test [] gorptest: 22:20:34.879464 rollback to savepoint "foo" [1:] gorptest: 22:20:34.879509 select memo from invoice_test [] gorptest: 22:20:34.879563 rollback; [] gorptest: 22:20:34.879700 drop table if exists "invoice_test"; [] gorptest: 22:20:34.884003 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.887589 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.890446 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.894007 drop table if exists "person_test"; [] gorptest: 22:20:34.897058 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.900328 drop table if exists "id_created_test"; [] gorptest: 22:20:34.903765 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.906832 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.910513 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.913831 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.917105 drop table if exists "time_test"; [] gorptest: 22:20:34.920402 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.08s) === RUN TestMultiple 2023/04/12 22:20:34 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:34.920726 drop table if exists "invoice_test"; [] gorptest: 22:20:34.921028 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:34.921088 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:34.921127 drop table if exists "invoice_override_test"; [] gorptest: 22:20:34.921179 drop table if exists "person_test"; [] gorptest: 22:20:34.921218 drop table if exists "ignored_column_test"; [] gorptest: 22:20:34.921269 drop table if exists "id_created_test"; [] gorptest: 22:20:34.921307 drop table if exists "type_conv_test"; [] gorptest: 22:20:34.921345 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:34.921396 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:34.921435 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:34.921486 drop table if exists "time_test"; [] gorptest: 22:20:34.921532 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.924610 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: 22:20:34.928109 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:34.943109 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:34.948029 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:34.951938 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.955186 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:34.958226 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:34.961853 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:34.965897 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:34.969050 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:34.972405 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:34.975661 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 22:20:34.978833 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 22:20:34.981905 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 22:20:34.984881 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 22:20:34.987989 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:34.990960 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 22:20:34.994210 drop table if exists "invoice_test"; [] gorptest: 22:20:34.997481 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.000649 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.004311 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.008704 drop table if exists "person_test"; [] gorptest: 22:20:35.012120 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.015144 drop table if exists "id_created_test"; [] gorptest: 22:20:35.018324 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.021323 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.025321 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.028358 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.031490 drop table if exists "time_test"; [] gorptest: 22:20:35.034951 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.11s) === RUN TestCrud 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.035277 drop table if exists "invoice_test"; [] gorptest: 22:20:35.035611 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.035671 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.035712 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.035768 drop table if exists "person_test"; [] gorptest: 22:20:35.035847 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.035901 drop table if exists "id_created_test"; [] gorptest: 22:20:35.035940 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.036005 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.036044 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.036096 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.036137 drop table if exists "time_test"; [] gorptest: 22:20:35.036184 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.042109 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: 22:20:35.045349 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.048157 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.051578 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.054868 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.058055 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.061415 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.064374 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.069241 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.072270 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.075397 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.079167 delete from invoice_test [] gorptest: 22:20:35.082526 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 22:20:35.086609 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:35.086788 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: 22:20:35.089925 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:35.090072 select * from invoice_test [] gorptest: 22:20:35.090222 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:35.093474 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 22:20:35.093602 delete from invoice_tag_test [] gorptest: 22:20:35.096690 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: 22:20:35.100410 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:20:35.100590 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: 22:20:35.103588 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:20:35.103740 select * from invoice_tag_test [] gorptest: 22:20:35.103889 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:20:35.107323 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 22:20:35.107475 delete from alias_trans_field_test [] gorptest: 22:20:35.110811 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 22:20:35.114264 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:20:35.114404 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 22:20:35.117363 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:20:35.117485 select * from alias_trans_field_test [] gorptest: 22:20:35.117595 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:20:35.121095 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 22:20:35.121213 drop table if exists "invoice_test"; [] gorptest: 22:20:35.124675 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.128506 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.132445 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.135785 drop table if exists "person_test"; [] gorptest: 22:20:35.138757 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.142240 drop table if exists "id_created_test"; [] gorptest: 22:20:35.146201 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.152490 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.156308 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.160309 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.163952 drop table if exists "time_test"; [] gorptest: 22:20:35.167448 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.13s) === RUN TestWithIgnoredColumn 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.167808 drop table if exists "invoice_test"; [] gorptest: 22:20:35.168250 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.168309 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.168389 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.168428 drop table if exists "person_test"; [] gorptest: 22:20:35.168484 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.168522 drop table if exists "id_created_test"; [] gorptest: 22:20:35.168561 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.168612 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.168650 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.168728 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.168780 drop table if exists "time_test"; [] gorptest: 22:20:35.168844 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.172475 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: 22:20:35.176208 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.179995 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.184176 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.187578 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.192663 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.196395 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.200565 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.204808 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.208360 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.212119 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.218081 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 22:20:35.220830 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:20:35.220968 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:20:35.224601 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 22:20:35.224720 drop table if exists "invoice_test"; [] gorptest: 22:20:35.227943 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.230999 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.234364 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.237491 drop table if exists "person_test"; [] gorptest: 22:20:35.240351 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.245091 drop table if exists "id_created_test"; [] gorptest: 22:20:35.248341 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.252523 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.256403 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.260594 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.263935 drop table if exists "time_test"; [] gorptest: 22:20:35.267601 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.10s) === RUN TestTypeConversionExample 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.267947 drop table if exists "invoice_test"; [] gorptest: 22:20:35.268298 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.268354 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.268394 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.268446 drop table if exists "person_test"; [] gorptest: 22:20:35.268484 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.268536 drop table if exists "id_created_test"; [] gorptest: 22:20:35.268573 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.268624 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.268709 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.268791 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.268845 drop table if exists "time_test"; [] gorptest: 22:20:35.268896 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.272541 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: 22:20:35.276691 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.280287 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.284504 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.287600 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.291284 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.295026 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.299442 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.302818 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.306384 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.309459 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.312974 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: 22:20:35.316659 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:20:35.316861 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: 22:20:35.320000 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:20:35.320152 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 22:20:35.323382 drop table if exists "invoice_test"; [] gorptest: 22:20:35.327045 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.331040 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.335471 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.338940 drop table if exists "person_test"; [] gorptest: 22:20:35.342136 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.344843 drop table if exists "id_created_test"; [] gorptest: 22:20:35.351905 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.356668 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.359923 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.363099 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.366072 drop table if exists "time_test"; [] gorptest: 22:20:35.369103 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.10s) === RUN TestWithEmbeddedStruct 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.369458 drop table if exists "invoice_test"; [] gorptest: 22:20:35.369833 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.369895 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.369936 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.369989 drop table if exists "person_test"; [] gorptest: 22:20:35.370029 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.370081 drop table if exists "id_created_test"; [] gorptest: 22:20:35.370120 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.370172 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.370224 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.370283 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.370334 drop table if exists "time_test"; [] gorptest: 22:20:35.370401 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.373254 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: 22:20:35.382680 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.385939 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.389159 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.392242 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.395766 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.398379 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.401184 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.405222 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.408387 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.411432 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.415585 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 22:20:35.418885 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 22:20:35.419053 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 22:20:35.422361 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 22:20:35.422490 select * from embedded_struct_test [] gorptest: 22:20:35.422619 drop table if exists "invoice_test"; [] gorptest: 22:20:35.425770 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.428881 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.432096 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.435025 drop table if exists "person_test"; [] gorptest: 22:20:35.437819 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.441311 drop table if exists "id_created_test"; [] gorptest: 22:20:35.444355 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.447507 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.450567 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.453497 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.456725 drop table if exists "time_test"; [] gorptest: 22:20:35.460128 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.09s) === RUN TestWithEmbeddedStructBeforeAutoincr 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.460486 drop table if exists "invoice_test"; [] gorptest: 22:20:35.460887 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.460944 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.460984 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.461037 drop table if exists "person_test"; [] gorptest: 22:20:35.461077 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.461129 drop table if exists "id_created_test"; [] gorptest: 22:20:35.461180 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.461232 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.461270 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.461353 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.461407 drop table if exists "time_test"; [] gorptest: 22:20:35.461490 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.464613 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: 22:20:35.467611 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.470801 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.473836 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.476729 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.480588 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.484004 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.487164 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.491013 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.494657 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.498728 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.501949 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 22:20:35.504915 drop table if exists "invoice_test"; [] gorptest: 22:20:35.509016 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.512106 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.515157 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.518344 drop table if exists "person_test"; [] gorptest: 22:20:35.522296 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.527335 drop table if exists "id_created_test"; [] gorptest: 22:20:35.530670 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.533504 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.537122 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.540365 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.544053 drop table if exists "time_test"; [] gorptest: 22:20:35.547650 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.09s) === RUN TestWithEmbeddedAutoincr 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.547978 drop table if exists "invoice_test"; [] gorptest: 22:20:35.548354 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.548411 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.548457 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.548510 drop table if exists "person_test"; [] gorptest: 22:20:35.548562 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.548602 drop table if exists "id_created_test"; [] gorptest: 22:20:35.548656 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.548696 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.548780 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.548833 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.548914 drop table if exists "time_test"; [] gorptest: 22:20:35.548964 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.552535 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: 22:20:35.555911 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.559151 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.562394 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.565320 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.568733 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.571908 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.574916 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.578430 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.582003 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.585271 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.588863 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 22:20:35.591972 drop table if exists "invoice_test"; [] gorptest: 22:20:35.594937 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.598028 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.601286 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.604395 drop table if exists "person_test"; [] gorptest: 22:20:35.607334 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.611241 drop table if exists "id_created_test"; [] gorptest: 22:20:35.614387 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.617388 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.620514 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.623754 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.627152 drop table if exists "time_test"; [] gorptest: 22:20:35.630214 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.08s) === RUN TestSelectVal gorptest: 22:20:35.630542 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 22:20:35.633985 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: 22:20:35.636898 select Int64 from TableWithNull where Str='abc' [] gorptest: 22:20:35.637023 select count(*) from TableWithNull [] gorptest: 22:20:35.637106 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 22:20:35.637193 select Int64 from TableWithNull where Str='notfound' [] gorptest: 22:20:35.637273 select Int64 from TableWithNull where Str='abc' [] gorptest: 22:20:35.637340 select Float64 from TableWithNull where Str='abc' [] gorptest: 22:20:35.637418 select min(Float64) from TableWithNull [] gorptest: 22:20:35.637503 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 22:20:35.637591 select Float64 from TableWithNull where Str='notfound' [] gorptest: 22:20:35.637672 select Float64 from TableWithNull where Str='abc' [] gorptest: 22:20:35.637753 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:20:35.637836 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 22:20:35.637911 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:20:35.637992 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 22:20:35.638091 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 22:20:35.638179 select Str from TableWithNull where Int64=? [1:78] gorptest: 22:20:35.638264 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.641263 drop table if exists "invoice_test"; [] gorptest: 22:20:35.641575 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.641633 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.641673 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.641726 drop table if exists "person_test"; [] gorptest: 22:20:35.641765 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.641818 drop table if exists "id_created_test"; [] gorptest: 22:20:35.641857 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.641908 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.641948 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.641989 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.642040 drop table if exists "time_test"; [] gorptest: 22:20:35.642087 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.644957 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: 22:20:35.648216 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.651282 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.654649 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.657763 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.660515 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.663433 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.666287 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.669937 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.672914 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.676864 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.679618 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287635679590126 2:1681287635679590126 3:"Bob" 4:"Smith" 5:1] gorptest: 22:20:35.683023 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287635683003218 2:1681287635683003218 3:"Jane" 4:"Smith" 5:1] gorptest: 22:20:35.685890 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287635685868574 2:1681287635685868574 3:"Mike" 4:"Smith" 5:1] gorptest: 22:20:35.688595 drop table if exists "invoice_test"; [] gorptest: 22:20:35.691433 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.694351 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.697370 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.700437 drop table if exists "person_test"; [] gorptest: 22:20:35.703658 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.706948 drop table if exists "id_created_test"; [] gorptest: 22:20:35.710127 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.714152 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.717359 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.720608 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.723865 drop table if exists "time_test"; [] gorptest: 22:20:35.727188 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.09s) === RUN TestWithStringPk gorptest: 22:20:35.727487 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 22:20:35.731431 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 22:20:35.734612 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.01s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.738117 drop table if exists "invoice_test"; [] gorptest: 22:20:35.738424 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.738480 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.738521 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.738573 drop table if exists "person_test"; [] gorptest: 22:20:35.738612 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.738664 drop table if exists "id_created_test"; [] gorptest: 22:20:35.738702 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.738741 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.738794 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.738833 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.738885 drop table if exists "time_test"; [] gorptest: 22:20:35.738937 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.742587 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: 22:20:35.745869 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.749733 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.752877 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.755622 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.759861 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.762987 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.766194 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.769305 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.772854 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.776228 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.780102 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-12 07:49:35.780057177 +0000 UTC] gorptest: 22:20:35.783388 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-12 07:50:36.780057177 +0000 UTC] gorptest: 22:20:35.786911 SELECT id FROM time_test WHERE Time < ? [1:2023-04-12 07:50:35.780057177 +0000 UTC] gorptest: 22:20:35.787083 drop table if exists "invoice_test"; [] gorptest: 22:20:35.790167 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.793192 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.796682 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.800224 drop table if exists "person_test"; [] gorptest: 22:20:35.803306 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.806536 drop table if exists "id_created_test"; [] gorptest: 22:20:35.809470 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.826851 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.846232 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.850863 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.856151 drop table if exists "time_test"; [] gorptest: 22:20:35.860849 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.12s) === RUN TestInvoicePersonView 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.861198 drop table if exists "invoice_test"; [] gorptest: 22:20:35.861572 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.861630 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.861671 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.861724 drop table if exists "person_test"; [] gorptest: 22:20:35.861765 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.861817 drop table if exists "id_created_test"; [] gorptest: 22:20:35.861855 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.861911 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.861982 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.862036 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.862075 drop table if exists "time_test"; [] gorptest: 22:20:35.862166 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.865002 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: 22:20:35.874940 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.883006 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.887661 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.891667 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.895383 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:35.899100 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:35.909212 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:35.917407 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:35.922637 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:35.926048 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:35.929122 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287635929094398 2:1681287635929094398 3:"bob" 4:"smith" 5:1] gorptest: 22:20:35.932352 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 22:20:35.935991 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 22:20:35.936189 drop table if exists "invoice_test"; [] gorptest: 22:20:35.939322 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.942356 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.945567 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.949427 drop table if exists "person_test"; [] gorptest: 22:20:35.952419 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.955858 drop table if exists "id_created_test"; [] gorptest: 22:20:35.959023 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.962332 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.965972 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.969082 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.972588 drop table if exists "time_test"; [] gorptest: 22:20:35.975955 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.12s) === RUN TestQuoteTableNames 2023/04/12 22:20:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:35.976343 drop table if exists "invoice_test"; [] gorptest: 22:20:35.976728 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:35.976789 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:35.976829 drop table if exists "invoice_override_test"; [] gorptest: 22:20:35.976882 drop table if exists "person_test"; [] gorptest: 22:20:35.976923 drop table if exists "ignored_column_test"; [] gorptest: 22:20:35.976983 drop table if exists "id_created_test"; [] gorptest: 22:20:35.977031 drop table if exists "type_conv_test"; [] gorptest: 22:20:35.977176 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:35.977246 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:35.977312 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:35.977362 drop table if exists "time_test"; [] gorptest: 22:20:35.977434 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.981265 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: 22:20:35.985902 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:35.989630 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:35.993130 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:35.996650 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.000225 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.006722 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.015751 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.019619 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.022973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.026549 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.10s) === RUN TestSelectTooManyCols 2023/04/12 22:20:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:36.073746 drop table if exists "invoice_test"; [] gorptest: 22:20:36.074049 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.074109 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.074149 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.074204 drop table if exists "person_test"; [] gorptest: 22:20:36.074243 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.074309 drop table if exists "id_created_test"; [] gorptest: 22:20:36.074353 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.074400 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.074449 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.074510 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.074557 drop table if exists "time_test"; [] gorptest: 22:20:36.074631 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.078142 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: 22:20:36.081247 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.084539 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.087828 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:36.090971 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.094323 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.097467 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.100510 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.103189 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.106791 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.109919 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.112980 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287636112954785 2:1681287636112954785 3:"bob" 4:"smith" 5:1] gorptest: 22:20:36.116084 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287636116064850 2:1681287636116064850 3:"jane" 4:"doe" 5:1] gorptest: 22:20:36.119232 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:36.119413 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 22:20:36.119574 select * from person_test where Id=? [1:1] gorptest: 22:20:36.119788 select * from person_test order by fname asc [] gorptest: 22:20:36.119975 drop table if exists "invoice_test"; [] gorptest: 22:20:36.123064 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.126464 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.130780 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.134932 drop table if exists "person_test"; [] gorptest: 22:20:36.138375 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.141910 drop table if exists "id_created_test"; [] gorptest: 22:20:36.145596 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.149480 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.153581 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.156892 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.160119 drop table if exists "time_test"; [] gorptest: 22:20:36.163486 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.09s) === RUN TestSelectSingleVal 2023/04/12 22:20:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:36.163848 drop table if exists "invoice_test"; [] gorptest: 22:20:36.164225 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.164302 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.164342 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.164399 drop table if exists "person_test"; [] gorptest: 22:20:36.164438 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.164506 drop table if exists "id_created_test"; [] gorptest: 22:20:36.164549 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.164627 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.164684 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.164764 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.164852 drop table if exists "time_test"; [] gorptest: 22:20:36.164919 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.167849 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: 22:20:36.171013 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.175656 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.178784 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:36.182318 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.185264 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.189054 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.192251 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.195429 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.198743 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.202019 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.205656 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287636205626840 2:1681287636205626840 3:"bob" 4:"smith" 5:1] gorptest: 22:20:36.208963 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 22:20:36.209118 select * from person_test where Id=? [1:1] gorptest: 22:20:36.209303 select FName from person_test where Id=? [1:1] gorptest: 22:20:36.209431 select * from person_test where Id=? [1:1] gorptest: 22:20:36.209647 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 22:20:36.209824 select * from person_test where Id=? [1:-2222] gorptest: 22:20:36.209997 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1681287636209981011 2:1681287636209981011 3:"bob" 4:"smith" 5:1] gorptest: 22:20:36.213088 select * from person_test where Fname='bob' [] gorptest: 22:20:36.213281 select * from person_test where Id=-123 [] gorptest: 22:20:36.213394 select * from person_test where Id=-123 [] gorptest: 22:20:36.213501 select * from person_test where Id=-123 [] gorptest: 22:20:36.213642 select * from person_test where Id=-123 [] gorptest: 22:20:36.213747 drop table if exists "invoice_test"; [] gorptest: 22:20:36.216947 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.221172 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.224917 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.228652 drop table if exists "person_test"; [] gorptest: 22:20:36.232425 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.236302 drop table if exists "id_created_test"; [] gorptest: 22:20:36.239960 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.243020 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.246049 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.248921 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.252274 drop table if exists "time_test"; [] gorptest: 22:20:36.255324 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.09s) === RUN TestSelectAlias 2023/04/12 22:20:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:36.255608 drop table if exists "invoice_test"; [] gorptest: 22:20:36.255998 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.256075 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.256122 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.256178 drop table if exists "person_test"; [] gorptest: 22:20:36.256223 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.256286 drop table if exists "id_created_test"; [] gorptest: 22:20:36.256335 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.256378 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.256461 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.256541 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.256604 drop table if exists "time_test"; [] gorptest: 22:20:36.256688 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.261606 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: 22:20:36.264611 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.267665 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.270798 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:36.273701 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.276727 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.280133 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.283290 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.287018 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.290337 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.293694 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.296845 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 22:20:36.299822 select * from id_created_test where Id=1 [] gorptest: 22:20:36.299975 SELECT *, 1 AS external FROM id_created_test [] gorptest: 22:20:36.300126 drop table if exists "invoice_test"; [] gorptest: 22:20:36.303676 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.306978 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.309754 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.314230 drop table if exists "person_test"; [] gorptest: 22:20:36.317506 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.320861 drop table if exists "id_created_test"; [] gorptest: 22:20:36.323753 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.326773 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.329964 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.333153 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.336162 drop table if exists "time_test"; [] gorptest: 22:20:36.339387 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.08s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2023/04/12 22:20:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:36.339828 drop table if exists "invoice_test"; [] gorptest: 22:20:36.340188 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.340248 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.340288 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.340347 drop table if exists "person_test"; [] gorptest: 22:20:36.340395 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.340457 drop table if exists "id_created_test"; [] gorptest: 22:20:36.340499 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.340537 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.340626 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.340687 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.340747 drop table if exists "time_test"; [] gorptest: 22:20:36.340840 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.343959 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: 22:20:36.347416 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.351892 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.381693 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:36.392189 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.395338 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.403836 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.415635 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.418975 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.422161 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.425131 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.427821 drop table if exists "invoice_test"; [] gorptest: 22:20:36.431469 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.437817 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.441195 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.444906 drop table if exists "person_test"; [] gorptest: 22:20:36.448381 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.451509 drop table if exists "id_created_test"; [] gorptest: 22:20:36.454893 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.458863 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.462009 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.465292 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.468668 drop table if exists "time_test"; [] gorptest: 22:20:36.471947 drop table if exists "id_created_test"; [] gorptest: 22:20:36.472031 drop table if exists "single_column_table"; [] gorptest: 22:20:36.472093 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: 22:20:36.475048 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: 22:20:36.478133 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.480990 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: 22:20:36.484211 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: 22:20:36.487163 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.490123 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.493113 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.496403 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.500198 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.503962 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: 22:20:36.507347 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.510318 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 22:20:36.510392 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 22:20:36.515450 delete from "invoice_test"; [] gorptest: 22:20:36.518642 delete from "invoice_tag_test"; [] gorptest: 22:20:36.521939 delete from "alias_trans_field_test"; [] gorptest: 22:20:36.525306 delete from "invoice_override_test"; [] gorptest: 22:20:36.529181 delete from "person_test"; [] gorptest: 22:20:36.532769 delete from "ignored_column_test"; [] gorptest: 22:20:36.536667 delete from "id_created_test"; [] gorptest: 22:20:36.540250 delete from "type_conv_test"; [] gorptest: 22:20:36.543283 delete from "embedded_struct_test"; [] gorptest: 22:20:36.546312 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.549370 delete from "embedded_autoincr_test"; [] gorptest: 22:20:36.552370 delete from "time_test"; [] gorptest: 22:20:36.555688 delete from "id_created_test"; [] gorptest: 22:20:36.558904 delete from "single_column_table"; [] gorptest: 22:20:36.561847 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 22:20:36.562002 drop table if exists "invoice_test"; [] gorptest: 22:20:36.565634 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.569743 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.572937 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.576090 drop table if exists "person_test"; [] gorptest: 22:20:36.579301 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.582309 drop table if exists "id_created_test"; [] gorptest: 22:20:36.584954 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.588046 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.591575 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.594609 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.597164 drop table if exists "time_test"; [] gorptest: 22:20:36.600376 drop table if exists "id_created_test"; [] gorptest: 22:20:36.600457 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.27s) === RUN TestPrepare 2023/04/12 22:20:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 22:20:36.605448 drop table if exists "invoice_test"; [] gorptest: 22:20:36.605918 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.605975 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.606015 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.606068 drop table if exists "person_test"; [] gorptest: 22:20:36.606107 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.606158 drop table if exists "id_created_test"; [] gorptest: 22:20:36.606197 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.606249 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.606334 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.606377 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.606430 drop table if exists "time_test"; [] gorptest: 22:20:36.606497 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.610107 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: 22:20:36.613200 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 22:20:36.617061 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 22:20:36.621990 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 22:20:36.625857 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.629104 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 22:20:36.632327 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 22:20:36.635330 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 22:20:36.637894 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 22:20:36.640938 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 22:20:36.644232 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 22:20:36.647303 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 22:20:36.650495 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 22:20:36.654044 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 22:20:36.657131 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 22:20:36.657327 begin; [] gorptest: 22:20:36.657390 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 22:20:36.657518 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:20:36.658198 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:20:36.658349 commit; [] gorptest: 22:20:36.661640 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 22:20:36.661882 drop table if exists "invoice_test"; [] gorptest: 22:20:36.665023 drop table if exists "invoice_tag_test"; [] gorptest: 22:20:36.668282 drop table if exists "alias_trans_field_test"; [] gorptest: 22:20:36.671768 drop table if exists "invoice_override_test"; [] gorptest: 22:20:36.675489 drop table if exists "person_test"; [] gorptest: 22:20:36.678584 drop table if exists "ignored_column_test"; [] gorptest: 22:20:36.681794 drop table if exists "id_created_test"; [] gorptest: 22:20:36.684402 drop table if exists "type_conv_test"; [] gorptest: 22:20:36.687271 drop table if exists "embedded_struct_test"; [] gorptest: 22:20:36.689959 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 22:20:36.693046 drop table if exists "embedded_autoincr_test"; [] gorptest: 22:20:36.696736 drop table if exists "time_test"; [] gorptest: 22:20:36.699877 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.09s) PASS ok gopkg.in/gorp.v1 2.782s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install --destdir=debian/golang-gopkg-gorp.v1-dev/ -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_i386.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_i386.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: user script /srv/workspace/pbuilder/6627/tmp/hooks/B01_cleanup starting I: user script /srv/workspace/pbuilder/6627/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/6627 and its subdirectories I: Current time: Wed Apr 12 22:20:41 +14 2023 I: pbuilder-time-stamp: 1681287641