Wed Jan 19 00:27:41 UTC 2022 I: starting to build golang-gopkg-gorp.v1/bullseye/amd64 on jenkins on '2022-01-19 00:27' Wed Jan 19 00:27:41 UTC 2022 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/amd64_30/50661/console.log Wed Jan 19 00:27:41 UTC 2022 I: Downloading source for bullseye/golang-gopkg-gorp.v1=1.7.2-2 --2022-01-19 00:27:41-- http://cdn-fastly.deb.debian.org/debian/pool/main/g/golang-gopkg-gorp.v1/golang-gopkg-gorp.v1_1.7.2-2.dsc Connecting to 78.137.99.97:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2257 (2.2K) Saving to: ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ 0K .. 100% 40.1M=0s 2022-01-19 00:27:41 (40.1 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Wed Jan 19 00:27:41 UTC 2022 I: golang-gopkg-gorp.v1_1.7.2-2.dsc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Format: 3.0 (quilt) Source: golang-gopkg-gorp.v1 Binary: golang-gopkg-gorp.v1-dev Architecture: all Version: 1.7.2-2 Maintainer: Debian Go Packaging Team Uploaders: Pirate Praveen Homepage: https://github.com/go-gorp/gorp Standards-Version: 4.5.0 Vcs-Browser: https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1 Vcs-Git: https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1.git Testsuite: autopkgtest-pkg-go Build-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 Package-List: golang-gopkg-gorp.v1-dev deb devel optional arch=all Checksums-Sha1: 2e6c04f1ca458b823029eec4c51ba40603255da4 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz bb7c09284f48f1c97a0ded67b382e55e75072591 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Checksums-Sha256: 8b443ae1e4435f005b9ee7dfcfe3aab4aeeb4bd0131c9729f93788178cb261d2 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz ad67e36f4b6be743fb215ff83513f5d99c0b7ce2a847ca5ff1f1047060a82887 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Files: a0b0d4b76dbac1ec83378e470166fdec 32572 golang-gopkg-gorp.v1_1.7.2.orig.tar.xz e3925e5666a5dcb9d7ca28a80cb5b893 2688 golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz Go-Import-Path: gopkg.in/gorp.v1 -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEE0whj4mAg5UP0cZqDj1PgGTspS3UFAl6cZ2wACgkQj1PgGTsp S3Uz3A//ZFGpjTXhy9rtNIFOj9Bz83Lz6qjL8iB6GSpYLayOk3rvcsECBhLzcI8j iCI9aqXUf/PH1pDx8TrcWCWtLqd8tHQFx0C52rLdy+MNTbMs5aN0xX8Lgy+6XYqv 7kSPAmLLF7aOPIwDvXDdCndu0zVV88ywZy/AzCK4QBTvQwdgnMg1yRxPQnvApJ53 4y0vjS915uIWF/2NW/T/dCLvcSO9Vcy8rcCgM+25Mob/KsN7aAyC+KYZjXgGtnz4 QD1mDe+b09ZlTKqcCYjQotTZdJV0nlehEaQzcGE10MnHuf2zw2XjdTpk6Ba/aH3P S0saS18pDw6Nr+TAgjBOH28oFi9lf8M6OZFwhwZ4KCe/hz3ruuLEFjPC+D1vuBks 5iy00WTmhhizDfMcfiGypmRJ0RimsfEPBqRFS2JCNr/+qGCkOgpCUD3NQuWVc0GI lIQ20zBNGMgYTroAqvn9Ls5VOL3ClWQ4G7MQ90zBRrkqWrvGOqfnmfNsDXvovQfA XnKyPY80C1O4vE12fENRjvJ8KZdnD3Wa+BMe+o2nCiXEuGeIBbrSfWbcErIBxefZ JKJf8TnVxIrEV/LaDIauejzL74hfi3LZCWy+8Ey1g18kktA6tG6sDxvnWPqTl5j1 9VqvEVa8h+vZJswFlThx5BO1aA9U3FkEFm2iU/aOAg+DxZtyRZw= =pQf6 -----END PGP SIGNATURE----- Wed Jan 19 00:27:41 UTC 2022 I: Checking whether the package is not for us Wed Jan 19 00:27:41 UTC 2022 I: Starting 1st build on remote node ionos5-amd64.debian.net. Wed Jan 19 00:27:41 UTC 2022 I: Preparing to do remote build '1' on ionos5-amd64.debian.net. Wed Jan 19 00:28:21 UTC 2022 I: Deleting $TMPDIR on ionos5-amd64.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Mon Feb 20 18:50:44 -12 2023 I: pbuilder-time-stamp: 1676962244 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bullseye-reproducible-base.tgz] I: copying local configuration I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: unknown type of key resource 'trustedkeys.kbx' gpgv: keyblock resource '/tmp/dpkg-verify-sig.3FNd41sK/trustedkeys.kbx': General error gpgv: Signature made Sun Apr 19 02:59:56 2020 -12 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: failed to verify signature on ./golang-gopkg-gorp.v1_1.7.2-2.dsc 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/915486/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build' BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' BUILDUSERNAME='pbuilder1' BUILD_ARCH='amd64' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all,-fixfilepath parallel=16' DISTRIBUTION='' HOME='/root' HOST_ARCH='amd64' IFS=' ' INVOCATION_ID='e928e66e014644679e495eb9439c63bb' LANG='C' LANGUAGE='en_US:en' LC_ALL='C' MAIL='/var/mail/root' OPTIND='1' PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' PBCURRENTCOMMANDLINEOPERATION='build' PBUILDER_OPERATION='build' PBUILDER_PKGDATADIR='/usr/share/pbuilder' PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' PBUILDER_SYSCONFDIR='/etc' PPID='915486' PS1='# ' PS2='> ' PS4='+ ' PWD='/' SHELL='/bin/bash' SHLVL='2' SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/pbuilderrc_T3jo --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bullseye-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='110' SUDO_UID='105' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://85.184.249.68:3128' I: uname -a Linux ionos5-amd64 5.14.0-0.bpo.2-amd64 #1 SMP Debian 5.14.9-2~bpo11+1 (2021-10-10) x86_64 GNU/Linux I: ls -l /bin total 5476 -rwxr-xr-x 1 root root 1234376 Aug 4 2021 bash -rwxr-xr-x 3 root root 38984 Jul 20 2020 bunzip2 -rwxr-xr-x 3 root root 38984 Jul 20 2020 bzcat lrwxrwxrwx 1 root root 6 Jul 20 2020 bzcmp -> bzdiff -rwxr-xr-x 1 root root 2225 Jul 20 2020 bzdiff lrwxrwxrwx 1 root root 6 Jul 20 2020 bzegrep -> bzgrep -rwxr-xr-x 1 root root 4877 Sep 4 2019 bzexe lrwxrwxrwx 1 root root 6 Jul 20 2020 bzfgrep -> bzgrep -rwxr-xr-x 1 root root 3775 Jul 20 2020 bzgrep -rwxr-xr-x 3 root root 38984 Jul 20 2020 bzip2 -rwxr-xr-x 1 root root 18424 Jul 20 2020 bzip2recover lrwxrwxrwx 1 root root 6 Jul 20 2020 bzless -> bzmore -rwxr-xr-x 1 root root 1297 Jul 20 2020 bzmore -rwxr-xr-x 1 root root 43936 Sep 23 2020 cat -rwxr-xr-x 1 root root 72672 Sep 23 2020 chgrp -rwxr-xr-x 1 root root 64448 Sep 23 2020 chmod -rwxr-xr-x 1 root root 72672 Sep 23 2020 chown -rwxr-xr-x 1 root root 151168 Sep 23 2020 cp -rwxr-xr-x 1 root root 125560 Dec 10 2020 dash -rwxr-xr-x 1 root root 113664 Sep 23 2020 date -rwxr-xr-x 1 root root 80968 Sep 23 2020 dd -rwxr-xr-x 1 root root 93936 Sep 23 2020 df -rwxr-xr-x 1 root root 147176 Sep 23 2020 dir -rwxr-xr-x 1 root root 84440 Jul 28 2021 dmesg lrwxrwxrwx 1 root root 8 Nov 6 2019 dnsdomainname -> hostname lrwxrwxrwx 1 root root 8 Nov 6 2019 domainname -> hostname -rwxr-xr-x 1 root root 39712 Sep 23 2020 echo -rwxr-xr-x 1 root root 28 Nov 9 2020 egrep -rwxr-xr-x 1 root root 39680 Sep 23 2020 false -rwxr-xr-x 1 root root 28 Nov 9 2020 fgrep -rwxr-xr-x 1 root root 69032 Jul 28 2021 findmnt -rwsr-xr-x 1 root root 34896 Feb 26 2021 fusermount -rwxr-xr-x 1 root root 203072 Nov 9 2020 grep -rwxr-xr-x 2 root root 2346 Mar 2 2021 gunzip -rwxr-xr-x 1 root root 6376 Mar 2 2021 gzexe -rwxr-xr-x 1 root root 98048 Mar 2 2021 gzip -rwxr-xr-x 1 root root 22600 Nov 6 2019 hostname -rwxr-xr-x 1 root root 72840 Sep 23 2020 ln -rwxr-xr-x 1 root root 56952 Feb 7 2020 login -rwxr-xr-x 1 root root 147176 Sep 23 2020 ls -rwxr-xr-x 1 root root 149736 Jul 28 2021 lsblk -rwxr-xr-x 1 root root 85184 Sep 23 2020 mkdir -rwxr-xr-x 1 root root 76896 Sep 23 2020 mknod -rwxr-xr-x 1 root root 48064 Sep 23 2020 mktemp -rwxr-xr-x 1 root root 59632 Jul 28 2021 more -rwsr-xr-x 1 root root 55528 Jul 28 2021 mount -rwxr-xr-x 1 root root 18664 Jul 28 2021 mountpoint -rwxr-xr-x 1 root root 147080 Sep 23 2020 mv lrwxrwxrwx 1 root root 8 Nov 6 2019 nisdomainname -> hostname lrwxrwxrwx 1 root root 14 Apr 18 2021 pidof -> /sbin/killall5 -rwxr-xr-x 1 root root 43872 Sep 23 2020 pwd lrwxrwxrwx 1 root root 4 Aug 4 2021 rbash -> bash -rwxr-xr-x 1 root root 52032 Sep 23 2020 readlink -rwxr-xr-x 1 root root 72704 Sep 23 2020 rm -rwxr-xr-x 1 root root 52032 Sep 23 2020 rmdir -rwxr-xr-x 1 root root 27472 Sep 27 2020 run-parts -rwxr-xr-x 1 root root 122224 Dec 22 2018 sed lrwxrwxrwx 1 root root 4 Feb 9 03:46 sh -> dash -rwxr-xr-x 1 root root 43808 Sep 23 2020 sleep -rwxr-xr-x 1 root root 84928 Sep 23 2020 stty -rwsr-xr-x 1 root root 71912 Jul 28 2021 su -rwxr-xr-x 1 root root 39744 Sep 23 2020 sync -rwxr-xr-x 1 root root 531928 Feb 16 2021 tar -rwxr-xr-x 1 root root 14456 Sep 27 2020 tempfile -rwxr-xr-x 1 root root 101408 Sep 23 2020 touch -rwxr-xr-x 1 root root 39680 Sep 23 2020 true -rwxr-xr-x 1 root root 14328 Feb 26 2021 ulockmgr_server -rwsr-xr-x 1 root root 35040 Jul 28 2021 umount -rwxr-xr-x 1 root root 39744 Sep 23 2020 uname -rwxr-xr-x 2 root root 2346 Mar 2 2021 uncompress -rwxr-xr-x 1 root root 147176 Sep 23 2020 vdir -rwxr-xr-x 1 root root 63744 Jul 28 2021 wdctl lrwxrwxrwx 1 root root 8 Nov 6 2019 ypdomainname -> hostname -rwxr-xr-x 1 root root 1984 Mar 2 2021 zcat -rwxr-xr-x 1 root root 1678 Mar 2 2021 zcmp -rwxr-xr-x 1 root root 5880 Mar 2 2021 zdiff -rwxr-xr-x 1 root root 29 Mar 2 2021 zegrep -rwxr-xr-x 1 root root 29 Mar 2 2021 zfgrep -rwxr-xr-x 1 root root 2081 Mar 2 2021 zforce -rwxr-xr-x 1 root root 7585 Mar 2 2021 zgrep -rwxr-xr-x 1 root root 2206 Mar 2 2021 zless -rwxr-xr-x 1 root root 1842 Mar 2 2021 zmore -rwxr-xr-x 1 root root 4553 Mar 2 2021 znew I: user script /srv/workspace/pbuilder/915486/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: amd64 Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19655 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.15-go{a} golang-1.15-src{a} golang-any{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-text-dev{a} golang-pq-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1{a} libfile-stripnondeterminism-perl{a} libicu67{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsigsegv2{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, 46 newly installed, 0 to remove and 0 not upgraded. Need to get 85.6 MB of archives. After unpacking 480 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian bullseye/main amd64 bsdextrautils amd64 2.36.1-8 [145 kB] Get: 2 http://deb.debian.org/debian bullseye/main amd64 libuchardet0 amd64 0.0.7-1 [67.8 kB] Get: 3 http://deb.debian.org/debian bullseye/main amd64 groff-base amd64 1.22.4-6 [936 kB] Get: 4 http://deb.debian.org/debian bullseye/main amd64 libpipeline1 amd64 1.5.3-1 [34.3 kB] Get: 5 http://deb.debian.org/debian bullseye/main amd64 man-db amd64 2.9.4-2 [1354 kB] Get: 6 http://deb.debian.org/debian bullseye/main amd64 sensible-utils all 0.0.14 [14.8 kB] Get: 7 http://deb.debian.org/debian bullseye/main amd64 libmagic-mgc amd64 1:5.39-3 [273 kB] Get: 8 http://deb.debian.org/debian bullseye/main amd64 libmagic1 amd64 1:5.39-3 [126 kB] Get: 9 http://deb.debian.org/debian bullseye/main amd64 file amd64 1:5.39-3 [69.1 kB] Get: 10 http://deb.debian.org/debian bullseye/main amd64 gettext-base amd64 0.21-4 [175 kB] Get: 11 http://deb.debian.org/debian bullseye/main amd64 libsigsegv2 amd64 2.13-1 [34.8 kB] Get: 12 http://deb.debian.org/debian bullseye/main amd64 m4 amd64 1.4.18-5 [204 kB] Get: 13 http://deb.debian.org/debian bullseye/main amd64 autoconf all 2.69-14 [313 kB] Get: 14 http://deb.debian.org/debian bullseye/main amd64 autotools-dev all 20180224.1+nmu1 [77.1 kB] Get: 15 http://deb.debian.org/debian bullseye/main amd64 automake all 1:1.16.3-2 [814 kB] Get: 16 http://deb.debian.org/debian bullseye/main amd64 autopoint all 0.21-4 [510 kB] Get: 17 http://deb.debian.org/debian bullseye/main amd64 libdebhelper-perl all 13.3.4 [189 kB] Get: 18 http://deb.debian.org/debian bullseye/main amd64 libtool all 2.4.6-15 [513 kB] Get: 19 http://deb.debian.org/debian bullseye/main amd64 dh-autoreconf all 20 [17.1 kB] Get: 20 http://deb.debian.org/debian bullseye/main amd64 libarchive-zip-perl all 1.68-1 [104 kB] Get: 21 http://deb.debian.org/debian bullseye/main amd64 libsub-override-perl all 0.09-2 [10.2 kB] Get: 22 http://deb.debian.org/debian bullseye/main amd64 libfile-stripnondeterminism-perl all 1.12.0-1 [26.3 kB] Get: 23 http://deb.debian.org/debian bullseye/main amd64 dh-strip-nondeterminism all 1.12.0-1 [15.4 kB] Get: 24 http://deb.debian.org/debian bullseye/main amd64 libelf1 amd64 0.183-1 [165 kB] Get: 25 http://deb.debian.org/debian bullseye/main amd64 dwz amd64 0.13+20210201-1 [175 kB] Get: 26 http://deb.debian.org/debian bullseye/main amd64 libicu67 amd64 67.1-7 [8622 kB] Get: 27 http://deb.debian.org/debian bullseye/main amd64 libxml2 amd64 2.9.10+dfsg-6.7 [693 kB] Get: 28 http://deb.debian.org/debian bullseye/main amd64 gettext amd64 0.21-4 [1311 kB] Get: 29 http://deb.debian.org/debian bullseye/main amd64 intltool-debian all 0.35.0+20060710.5 [26.8 kB] Get: 30 http://deb.debian.org/debian bullseye/main amd64 po-debconf all 1.0.21+nmu1 [248 kB] Get: 31 http://deb.debian.org/debian bullseye/main amd64 debhelper all 13.3.4 [1049 kB] Get: 32 http://deb.debian.org/debian bullseye/main amd64 dh-golang all 1.51 [24.6 kB] Get: 33 http://deb.debian.org/debian bullseye/main amd64 golang-1.15-src amd64 1.15.15-1~deb11u2 [13.9 MB] Get: 34 http://deb.debian.org/debian bullseye/main amd64 golang-1.15-go amd64 1.15.15-1~deb11u2 [47.4 MB] Get: 35 http://deb.debian.org/debian bullseye/main amd64 golang-src amd64 2:1.15~1 [4856 B] Get: 36 http://deb.debian.org/debian bullseye/main amd64 golang-go amd64 2:1.15~1 [23.9 kB] Get: 37 http://deb.debian.org/debian bullseye/main amd64 golang-any amd64 2:1.15~1 [4976 B] Get: 38 http://deb.debian.org/debian bullseye/main amd64 golang-github-go-sql-driver-mysql-dev all 1.5.0-1 [71.1 kB] Get: 39 http://deb.debian.org/debian bullseye/main amd64 golang-github-lib-pq-dev all 1.3.0-1 [76.1 kB] Get: 40 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-sys-dev all 0.0~git20210124.22da62e-1 [308 kB] Get: 41 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-text-dev all 0.3.6-1 [3857 kB] Get: 42 http://deb.debian.org/debian bullseye/main amd64 golang-golang-x-net-dev all 1:0.0+git20210119.5f4716e+dfsg-4 [659 kB] Get: 43 http://deb.debian.org/debian bullseye/main amd64 libsqlite3-dev amd64 3.34.1-3 [963 kB] Get: 44 http://deb.debian.org/debian bullseye/main amd64 golang-github-mattn-go-sqlite3-dev all 1.6.0~ds1-2 [58.1 kB] Get: 45 http://deb.debian.org/debian bullseye/main amd64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Get: 46 http://deb.debian.org/debian bullseye/main amd64 golang-pq-dev all 1.3.0-1 [3092 B] Fetched 85.6 MB in 1s (97.6 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package bsdextrautils. (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 ... 19655 files and directories currently installed.) Preparing to unpack .../00-bsdextrautils_2.36.1-8_amd64.deb ... Unpacking bsdextrautils (2.36.1-8) ... Selecting previously unselected package libuchardet0:amd64. Preparing to unpack .../01-libuchardet0_0.0.7-1_amd64.deb ... Unpacking libuchardet0:amd64 (0.0.7-1) ... Selecting previously unselected package groff-base. Preparing to unpack .../02-groff-base_1.22.4-6_amd64.deb ... Unpacking groff-base (1.22.4-6) ... Selecting previously unselected package libpipeline1:amd64. Preparing to unpack .../03-libpipeline1_1.5.3-1_amd64.deb ... Unpacking libpipeline1:amd64 (1.5.3-1) ... Selecting previously unselected package man-db. Preparing to unpack .../04-man-db_2.9.4-2_amd64.deb ... Unpacking man-db (2.9.4-2) ... Selecting previously unselected package sensible-utils. Preparing to unpack .../05-sensible-utils_0.0.14_all.deb ... Unpacking sensible-utils (0.0.14) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../06-libmagic-mgc_1%3a5.39-3_amd64.deb ... Unpacking libmagic-mgc (1:5.39-3) ... Selecting previously unselected package libmagic1:amd64. Preparing to unpack .../07-libmagic1_1%3a5.39-3_amd64.deb ... Unpacking libmagic1:amd64 (1:5.39-3) ... Selecting previously unselected package file. Preparing to unpack .../08-file_1%3a5.39-3_amd64.deb ... Unpacking file (1:5.39-3) ... Selecting previously unselected package gettext-base. Preparing to unpack .../09-gettext-base_0.21-4_amd64.deb ... Unpacking gettext-base (0.21-4) ... Selecting previously unselected package libsigsegv2:amd64. Preparing to unpack .../10-libsigsegv2_2.13-1_amd64.deb ... Unpacking libsigsegv2:amd64 (2.13-1) ... Selecting previously unselected package m4. Preparing to unpack .../11-m4_1.4.18-5_amd64.deb ... Unpacking m4 (1.4.18-5) ... Selecting previously unselected package autoconf. Preparing to unpack .../12-autoconf_2.69-14_all.deb ... Unpacking autoconf (2.69-14) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../13-autotools-dev_20180224.1+nmu1_all.deb ... Unpacking autotools-dev (20180224.1+nmu1) ... Selecting previously unselected package automake. Preparing to unpack .../14-automake_1%3a1.16.3-2_all.deb ... Unpacking automake (1:1.16.3-2) ... Selecting previously unselected package autopoint. Preparing to unpack .../15-autopoint_0.21-4_all.deb ... Unpacking autopoint (0.21-4) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../16-libdebhelper-perl_13.3.4_all.deb ... Unpacking libdebhelper-perl (13.3.4) ... Selecting previously unselected package libtool. Preparing to unpack .../17-libtool_2.4.6-15_all.deb ... Unpacking libtool (2.4.6-15) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../18-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../19-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 .../20-libsub-override-perl_0.09-2_all.deb ... Unpacking libsub-override-perl (0.09-2) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../21-libfile-stripnondeterminism-perl_1.12.0-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.12.0-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../22-dh-strip-nondeterminism_1.12.0-1_all.deb ... Unpacking dh-strip-nondeterminism (1.12.0-1) ... Selecting previously unselected package libelf1:amd64. Preparing to unpack .../23-libelf1_0.183-1_amd64.deb ... Unpacking libelf1:amd64 (0.183-1) ... Selecting previously unselected package dwz. Preparing to unpack .../24-dwz_0.13+20210201-1_amd64.deb ... Unpacking dwz (0.13+20210201-1) ... Selecting previously unselected package libicu67:amd64. Preparing to unpack .../25-libicu67_67.1-7_amd64.deb ... Unpacking libicu67:amd64 (67.1-7) ... Selecting previously unselected package libxml2:amd64. Preparing to unpack .../26-libxml2_2.9.10+dfsg-6.7_amd64.deb ... Unpacking libxml2:amd64 (2.9.10+dfsg-6.7) ... Selecting previously unselected package gettext. Preparing to unpack .../27-gettext_0.21-4_amd64.deb ... Unpacking gettext (0.21-4) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../28-intltool-debian_0.35.0+20060710.5_all.deb ... Unpacking intltool-debian (0.35.0+20060710.5) ... Selecting previously unselected package po-debconf. Preparing to unpack .../29-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../30-debhelper_13.3.4_all.deb ... Unpacking debhelper (13.3.4) ... Selecting previously unselected package dh-golang. Preparing to unpack .../31-dh-golang_1.51_all.deb ... Unpacking dh-golang (1.51) ... Selecting previously unselected package golang-1.15-src. Preparing to unpack .../32-golang-1.15-src_1.15.15-1~deb11u2_amd64.deb ... Unpacking golang-1.15-src (1.15.15-1~deb11u2) ... Selecting previously unselected package golang-1.15-go. Preparing to unpack .../33-golang-1.15-go_1.15.15-1~deb11u2_amd64.deb ... Unpacking golang-1.15-go (1.15.15-1~deb11u2) ... Selecting previously unselected package golang-src:amd64. Preparing to unpack .../34-golang-src_2%3a1.15~1_amd64.deb ... Unpacking golang-src:amd64 (2:1.15~1) ... Selecting previously unselected package golang-go. Preparing to unpack .../35-golang-go_2%3a1.15~1_amd64.deb ... Unpacking golang-go (2:1.15~1) ... Selecting previously unselected package golang-any:amd64. Preparing to unpack .../36-golang-any_2%3a1.15~1_amd64.deb ... Unpacking golang-any:amd64 (2:1.15~1) ... 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-1_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../38-golang-github-lib-pq-dev_1.3.0-1_all.deb ... Unpacking golang-github-lib-pq-dev (1.3.0-1) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../39-golang-golang-x-sys-dev_0.0~git20210124.22da62e-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../40-golang-golang-x-text-dev_0.3.6-1_all.deb ... Unpacking golang-golang-x-text-dev (0.3.6-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../41-golang-golang-x-net-dev_1%3a0.0+git20210119.5f4716e+dfsg-4_all.deb ... Unpacking golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Selecting previously unselected package libsqlite3-dev:amd64. Preparing to unpack .../42-libsqlite3-dev_3.34.1-3_amd64.deb ... Unpacking libsqlite3-dev:amd64 (3.34.1-3) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev. Preparing to unpack .../43-golang-github-mattn-go-sqlite3-dev_1.6.0~ds1-2_all.deb ... Unpacking golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../44-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) ... Selecting previously unselected package golang-pq-dev. Preparing to unpack .../45-golang-pq-dev_1.3.0-1_all.deb ... Unpacking golang-pq-dev (1.3.0-1) ... Setting up libpipeline1:amd64 (1.5.3-1) ... Setting up bsdextrautils (2.36.1-8) ... update-alternatives: using /usr/bin/write.ul to provide /usr/bin/write (write) in auto mode Setting up libicu67:amd64 (67.1-7) ... Setting up libmagic-mgc (1:5.39-3) ... Setting up golang-1.15-src (1.15.15-1~deb11u2) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up libdebhelper-perl (13.3.4) ... Setting up golang-golang-x-sys-dev (0.0~git20210124.22da62e-1) ... Setting up libmagic1:amd64 (1:5.39-3) ... Setting up gettext-base (0.21-4) ... Setting up golang-github-lib-pq-dev (1.3.0-1) ... Setting up file (1:5.39-3) ... Setting up autotools-dev (20180224.1+nmu1) ... Setting up libsqlite3-dev:amd64 (3.34.1-3) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libsigsegv2:amd64 (2.13-1) ... Setting up autopoint (0.21-4) ... Setting up sensible-utils (0.0.14) ... Setting up golang-golang-x-text-dev (0.3.6-1) ... Setting up golang-github-go-sql-driver-mysql-dev (1.5.0-1) ... Setting up libuchardet0:amd64 (0.0.7-1) ... Setting up libsub-override-perl (0.09-2) ... Setting up golang-pq-dev (1.3.0-1) ... Setting up golang-src:amd64 (2:1.15~1) ... Setting up golang-1.15-go (1.15.15-1~deb11u2) ... Setting up libelf1:amd64 (0.183-1) ... Setting up libxml2:amd64 (2.9.10+dfsg-6.7) ... Setting up libfile-stripnondeterminism-perl (1.12.0-1) ... Setting up gettext (0.21-4) ... Setting up libtool (2.4.6-15) ... Setting up golang-go (2:1.15~1) ... Setting up m4 (1.4.18-5) ... Setting up golang-any:amd64 (2:1.15~1) ... Setting up intltool-debian (0.35.0+20060710.5) ... Setting up golang-golang-x-net-dev (1:0.0+git20210119.5f4716e+dfsg-4) ... Setting up autoconf (2.69-14) ... Setting up dh-strip-nondeterminism (1.12.0-1) ... Setting up dwz (0.13+20210201-1) ... Setting up groff-base (1.22.4-6) ... Setting up automake (1:1.16.3-2) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up po-debconf (1.0.21+nmu1) ... Setting up man-db (2.9.4-2) ... Not building database; man-db/auto-update is not 'true'. Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev (1.6.0~ds1-2) ... Setting up debhelper (13.3.4) ... Setting up dh-golang (1.51) ... Processing triggers for libc-bin (2.31-13+deb11u2) ... Reading package lists... Building dependency tree... Reading state information... Reading extended state information... Initializing package states... Writing extended state information... Building tag database... -> Finished parsing the build-deps I: Building the package I: Running cd /build/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable dpkg-buildpackage: info: source changed by Pirate Praveen dpkg-source --before-build . dpkg-buildpackage: info: host architecture amd64 debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 16 gopkg.in/gorp.v1 internal/unsafeheader math/bits runtime/internal/sys internal/race internal/cpu unicode/utf8 runtime/internal/atomic unicode sync/atomic runtime/internal/math internal/testlog internal/bytealg math runtime internal/reflectlite sync errors sort io internal/oserror strconv syscall bytes strings reflect regexp/syntax internal/syscall/execenv internal/syscall/unix time regexp context 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 16 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.742145 drop table if exists "invoice_test"; [] gorptest: 06:51:19.742682 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.742731 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.742774 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.742810 drop table if exists "person_test"; [] gorptest: 06:51:19.742845 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.742886 drop table if exists "id_created_test"; [] gorptest: 06:51:19.742930 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.742970 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.743008 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.743054 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.743093 drop table if exists "time_test"; [] gorptest: 06:51:19.743150 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.743510 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: 06:51:19.743697 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.743878 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.744099 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.744279 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.744450 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.744630 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.744807 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.744982 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.745919 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.746124 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.746326 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: 06:51:19.746380 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: 06:51:19.746420 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.746453 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: 06:51:19.746493 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: 06:51:19.746526 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.746555 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.746594 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.746627 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.746661 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.746696 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: 06:51:19.746727 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.746762 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 06:51:19.746788 drop table if exists "invoice_test"; [] gorptest: 06:51:19.747014 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.747179 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.747338 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.747586 drop table if exists "person_test"; [] gorptest: 06:51:19.747748 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.748006 drop table if exists "id_created_test"; [] gorptest: 06:51:19.748173 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.748330 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.748490 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.748644 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.748797 drop table if exists "time_test"; [] gorptest: 06:51:19.748951 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.749199 drop table if exists "invoice_test"; [] gorptest: 06:51:19.749400 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.749443 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.749489 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.749537 drop table if exists "person_test"; [] gorptest: 06:51:19.749592 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.749636 drop table if exists "id_created_test"; [] gorptest: 06:51:19.749676 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.749712 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.749754 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.749795 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.749851 drop table if exists "time_test"; [] gorptest: 06:51:19.749910 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.750107 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: 06:51:19.750293 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.750474 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.750680 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.750866 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.751039 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.751233 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.751409 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.751611 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.751833 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.752040 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.752248 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: 06:51:19.752300 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: 06:51:19.752343 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.752382 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: 06:51:19.752426 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: 06:51:19.752460 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.752498 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.752541 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.752591 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.752635 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.752679 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: 06:51:19.752712 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.752747 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 06:51:19.752837 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279752810499 2:1676962279752810499 3:"Bob" 4:"Smith" 5:1] gorptest: 06:51:19.753026 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 06:51:19.753168 delete from "invoice_test"; [] gorptest: 06:51:19.753274 delete from "invoice_tag_test"; [] gorptest: 06:51:19.753381 delete from "alias_trans_field_test"; [] gorptest: 06:51:19.753478 delete from "invoice_override_test"; [] gorptest: 06:51:19.753591 delete from "person_test"; [] gorptest: 06:51:19.753695 delete from "ignored_column_test"; [] gorptest: 06:51:19.753863 delete from "id_created_test"; [] gorptest: 06:51:19.753969 delete from "type_conv_test"; [] gorptest: 06:51:19.754062 delete from "embedded_struct_test"; [] gorptest: 06:51:19.754144 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.754240 delete from "embedded_autoincr_test"; [] gorptest: 06:51:19.754325 delete from "time_test"; [] gorptest: 06:51:19.754410 delete from "id_created_test"; [] gorptest: 06:51:19.754504 SELECT * FROM person_test [] gorptest: 06:51:19.754601 SELECT * FROM invoice_test [] gorptest: 06:51:19.754681 drop table if exists "invoice_test"; [] gorptest: 06:51:19.754843 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.754999 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.755155 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.755390 drop table if exists "person_test"; [] gorptest: 06:51:19.755555 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.755709 drop table if exists "id_created_test"; [] gorptest: 06:51:19.755863 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.756016 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.756167 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.756318 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.756477 drop table if exists "time_test"; [] gorptest: 06:51:19.756630 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType gorptest: 06:51:19.756770 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 06:51:19.757135 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-02-21 06:51:19 +0000 UTC] gorptest: 06:51:19.757273 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 06:51:19.757355 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey gorptest: 06:51:19.757592 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 06:51:19.757929 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 06:51:19.758109 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 06:51:19.758324 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 06:51:19.758477 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 06:51:19.758603 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 06:51:19.758710 drop table if exists "PersonUInt64"; [] gorptest: 06:51:19.758870 drop table if exists "PersonUInt32"; [] gorptest: 06:51:19.759035 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether gorptest: 06:51:19.759277 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 06:51:19.759650 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 06:51:19.759790 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 06:51:19.759870 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 06:51:19.759931 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 06:51:19.760054 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser gorptest: 06:51:19.760413 drop table if exists PersistentUser [] gorptest: 06:51:19.760595 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 06:51:19.760825 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 06:51:19.760948 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 06:51:19.761032 select * from PersistentUser [] gorptest: 06:51:19.761147 select * from PersistentUser [] gorptest: 06:51:19.761217 select * from PersistentUser [] gorptest: 06:51:19.761282 select Id from PersistentUser [] gorptest: 06:51:19.761331 select mykey from PersistentUser [] gorptest: 06:51:19.761378 select PassedTraining from PersistentUser [] gorptest: 06:51:19.761422 select Id from PersistentUser [] gorptest: 06:51:19.761469 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap gorptest: 06:51:19.761702 drop table if exists PersistentUser [] gorptest: 06:51:19.761920 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 06:51:19.762125 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 06:51:19.762235 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 06:51:19.762357 select * from PersistentUser where mykey = ? [1:43] gorptest: 06:51:19.762438 select * from PersistentUser where mykey = ? [1:43] gorptest: 06:51:19.762515 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 06:51:19.762595 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 06:51:19.762664 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct gorptest: 06:51:19.762874 drop table if exists PersistentUser [] gorptest: 06:51:19.763055 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 06:51:19.763259 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 06:51:19.763367 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 06:51:19.763484 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 06:51:19.763577 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.763847 drop table if exists "invoice_test"; [] gorptest: 06:51:19.764029 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.764072 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.764113 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.764150 drop table if exists "person_test"; [] gorptest: 06:51:19.764190 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.764238 drop table if exists "id_created_test"; [] gorptest: 06:51:19.764277 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.764312 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.764363 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.764404 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.764439 drop table if exists "time_test"; [] gorptest: 06:51:19.764485 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.764724 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: 06:51:19.764908 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.765088 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.765294 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.765477 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.765683 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.765897 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.766087 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.766273 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.766468 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.766669 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.766875 select * from invoice_test where id=99999 [] gorptest: 06:51:19.766973 select * from invoice_test where id=99999 [] gorptest: 06:51:19.767061 drop table if exists "invoice_test"; [] gorptest: 06:51:19.767238 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.767415 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.767590 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.767833 drop table if exists "person_test"; [] gorptest: 06:51:19.768013 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.768188 drop table if exists "id_created_test"; [] gorptest: 06:51:19.768364 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.768531 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.768683 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.768837 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.768990 drop table if exists "time_test"; [] gorptest: 06:51:19.769171 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol gorptest: 06:51:19.769322 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 06:51:19.769686 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: 06:51:19.769790 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.770172 drop table if exists "invoice_test"; [] gorptest: 06:51:19.770352 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.770398 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.770436 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.770484 drop table if exists "person_test"; [] gorptest: 06:51:19.770531 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.770574 drop table if exists "id_created_test"; [] gorptest: 06:51:19.770620 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.770663 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.770709 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.770753 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.770801 drop table if exists "time_test"; [] gorptest: 06:51:19.770850 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.771040 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: 06:51:19.771219 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.771393 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.771617 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.771796 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.771972 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.772149 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.772323 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.772496 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.772675 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.772849 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.773035 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279773017747 2:1676962279773017747 3:"Bob" 4:"Smith" 5:1] gorptest: 06:51:19.773174 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.773285 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1676962279773017747 2:1676962279773017747 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 06:51:19.773424 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1676962279773017747 2:1676962279773017747 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 06:51:19.773484 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.773560 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 06:51:19.773614 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.773691 drop table if exists "invoice_test"; [] gorptest: 06:51:19.773857 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.774050 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.774199 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.774405 drop table if exists "person_test"; [] gorptest: 06:51:19.774570 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.774727 drop table if exists "id_created_test"; [] gorptest: 06:51:19.774881 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.775033 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.775187 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.775342 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.775514 drop table if exists "time_test"; [] gorptest: 06:51:19.775696 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.01s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 06:51:19.775888 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 06:51:19.776255 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 06:51:19.776387 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 06:51:19.776510 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: 06:51:19.776668 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 06:51:19.776769 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps gorptest: 06:51:19.777045 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 06:51:19.777441 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 06:51:19.777602 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 06:51:19.777680 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 06:51:19.777748 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 06:51:19.777807 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.778191 drop table if exists "invoice_test"; [] gorptest: 06:51:19.778365 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.778410 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.778449 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.778497 drop table if exists "person_test"; [] gorptest: 06:51:19.778536 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.778571 drop table if exists "id_created_test"; [] gorptest: 06:51:19.778615 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.778651 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.778691 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.778727 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.778767 drop table if exists "time_test"; [] gorptest: 06:51:19.778810 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.778999 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: 06:51:19.779178 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.779360 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.779569 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.779742 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.779915 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.780093 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.780274 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.780450 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.780667 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.780838 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.781024 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279781005517 2:1676962279781005517 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.781167 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 06:51:19.781290 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 06:51:19.781399 drop table if exists "invoice_test"; [] gorptest: 06:51:19.781584 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.781742 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.781919 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.782130 drop table if exists "person_test"; [] gorptest: 06:51:19.782293 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.782446 drop table if exists "id_created_test"; [] gorptest: 06:51:19.782600 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.782751 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.782905 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.783058 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.783211 drop table if exists "time_test"; [] gorptest: 06:51:19.783364 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.01s) === RUN TestHooks 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.783556 drop table if exists "invoice_test"; [] gorptest: 06:51:19.783738 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.783787 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.783834 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.783872 drop table if exists "person_test"; [] gorptest: 06:51:19.783913 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.783948 drop table if exists "id_created_test"; [] gorptest: 06:51:19.783990 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.784025 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.784068 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.784104 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.784144 drop table if exists "time_test"; [] gorptest: 06:51:19.784188 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.784390 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: 06:51:19.784586 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.784785 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.785042 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.785242 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.785447 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.785654 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.786076 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.786308 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.786517 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.786723 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.786950 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279786927901 2:1676962279786927901 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.787091 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.787194 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1676962279786927901 2:1676962279786927901 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 06:51:19.787330 select * from person_test where id = ? [1:1] gorptest: 06:51:19.787440 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 06:51:19.787562 drop table if exists "invoice_test"; [] gorptest: 06:51:19.787711 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.787859 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.788011 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.788223 drop table if exists "person_test"; [] gorptest: 06:51:19.788389 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.788542 drop table if exists "id_created_test"; [] gorptest: 06:51:19.788695 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.788848 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.789000 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.789153 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.789304 drop table if exists "time_test"; [] gorptest: 06:51:19.789453 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.01s) === RUN TestTransaction 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.789630 drop table if exists "invoice_test"; [] gorptest: 06:51:19.789811 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.789891 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.789944 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.789982 drop table if exists "person_test"; [] gorptest: 06:51:19.790030 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.790077 drop table if exists "id_created_test"; [] gorptest: 06:51:19.790112 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.790152 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.790196 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.790237 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.790273 drop table if exists "time_test"; [] gorptest: 06:51:19.790320 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.790516 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: 06:51:19.790691 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.790871 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.791080 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.791280 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.791456 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.791655 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.791837 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.792017 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.792192 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.792370 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.792544 begin; [] gorptest: 06:51:19.792588 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 06:51:19.792689 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 06:51:19.792727 commit; [] gorptest: 06:51:19.792789 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.792878 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 06:51:19.792946 drop table if exists "invoice_test"; [] gorptest: 06:51:19.793108 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.793263 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.793417 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.793621 drop table if exists "person_test"; [] gorptest: 06:51:19.793771 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.794170 drop table if exists "id_created_test"; [] gorptest: 06:51:19.794328 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.794485 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.794642 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.794829 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.794984 drop table if exists "time_test"; [] gorptest: 06:51:19.795135 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.01s) === RUN TestSavepoint 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.795326 drop table if exists "invoice_test"; [] gorptest: 06:51:19.795529 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.795583 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.795624 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.795659 drop table if exists "person_test"; [] gorptest: 06:51:19.795707 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.795749 drop table if exists "id_created_test"; [] gorptest: 06:51:19.795797 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.795841 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.795881 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.795923 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.795959 drop table if exists "time_test"; [] gorptest: 06:51:19.796005 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.796189 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: 06:51:19.796364 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.796576 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.796805 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.797003 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.797202 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.797405 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.797608 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.797809 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.798060 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.798268 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.798463 begin; [] gorptest: 06:51:19.798509 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 06:51:19.798617 select memo from invoice_test [] gorptest: 06:51:19.798661 savepoint "foo" [1:] gorptest: 06:51:19.798676 select memo from invoice_test [] gorptest: 06:51:19.798740 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 06:51:19.798791 select memo from invoice_test [] gorptest: 06:51:19.798833 rollback to savepoint "foo" [1:] gorptest: 06:51:19.798856 select memo from invoice_test [] gorptest: 06:51:19.798888 rollback; [] gorptest: 06:51:19.798936 drop table if exists "invoice_test"; [] gorptest: 06:51:19.799086 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.799241 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.799393 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.799603 drop table if exists "person_test"; [] gorptest: 06:51:19.799760 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.799914 drop table if exists "id_created_test"; [] gorptest: 06:51:19.800064 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.800216 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.800366 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.800520 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.800662 drop table if exists "time_test"; [] gorptest: 06:51:19.800802 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.01s) === RUN TestMultiple 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.801015 drop table if exists "invoice_test"; [] gorptest: 06:51:19.801196 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.801245 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.801285 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.801320 drop table if exists "person_test"; [] gorptest: 06:51:19.801368 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.801416 drop table if exists "id_created_test"; [] gorptest: 06:51:19.801457 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.801497 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.801531 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.801589 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.801631 drop table if exists "time_test"; [] gorptest: 06:51:19.801672 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.801887 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: 06:51:19.802081 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.802263 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.802467 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.802650 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.802818 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.802988 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.803161 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.803337 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.803510 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.803689 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.803880 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 06:51:19.804018 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 06:51:19.804154 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 06:51:19.804277 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 06:51:19.804394 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.804492 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 06:51:19.804595 drop table if exists "invoice_test"; [] gorptest: 06:51:19.804756 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.804912 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.805066 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.805274 drop table if exists "person_test"; [] gorptest: 06:51:19.805431 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.805584 drop table if exists "id_created_test"; [] gorptest: 06:51:19.805737 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.806135 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.806303 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.806454 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.806605 drop table if exists "time_test"; [] gorptest: 06:51:19.806788 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.01s) === RUN TestCrud 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.806976 drop table if exists "invoice_test"; [] gorptest: 06:51:19.807207 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.807258 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.807308 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.807355 drop table if exists "person_test"; [] gorptest: 06:51:19.807404 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.807455 drop table if exists "id_created_test"; [] gorptest: 06:51:19.807495 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.807539 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.807579 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.807633 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.807685 drop table if exists "time_test"; [] gorptest: 06:51:19.807733 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.807943 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: 06:51:19.808144 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.808349 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.808619 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.808801 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.808980 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.809161 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.809343 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.809526 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.809706 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.809913 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.810096 delete from invoice_test [] gorptest: 06:51:19.810202 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 06:51:19.810338 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.810447 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: 06:51:19.810565 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.810637 select * from invoice_test [] gorptest: 06:51:19.810738 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.810844 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 06:51:19.810910 delete from invoice_tag_test [] gorptest: 06:51:19.811029 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: 06:51:19.811163 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 06:51:19.811249 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: 06:51:19.811382 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 06:51:19.811455 select * from invoice_tag_test [] gorptest: 06:51:19.811572 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 06:51:19.811691 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 06:51:19.811760 delete from alias_trans_field_test [] gorptest: 06:51:19.811866 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 06:51:19.811986 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 06:51:19.812052 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] gorptest: 06:51:19.812163 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 06:51:19.812226 select * from alias_trans_field_test [] gorptest: 06:51:19.812297 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 06:51:19.812395 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 06:51:19.812453 drop table if exists "invoice_test"; [] gorptest: 06:51:19.812610 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.812774 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.812937 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.813147 drop table if exists "person_test"; [] gorptest: 06:51:19.813303 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.813457 drop table if exists "id_created_test"; [] gorptest: 06:51:19.813610 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.813769 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.813958 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.814117 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.814271 drop table if exists "time_test"; [] gorptest: 06:51:19.814421 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.01s) === RUN TestWithIgnoredColumn 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.814607 drop table if exists "invoice_test"; [] gorptest: 06:51:19.814787 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.814837 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.814873 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.814914 drop table if exists "person_test"; [] gorptest: 06:51:19.814948 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.814988 drop table if exists "id_created_test"; [] gorptest: 06:51:19.815023 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.815062 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.815098 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.815134 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.815180 drop table if exists "time_test"; [] gorptest: 06:51:19.815232 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.815423 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: 06:51:19.815600 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.815808 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.816034 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.816231 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.816426 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.816628 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.816832 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.817035 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.817237 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.817436 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.817651 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 06:51:19.817778 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 06:51:19.817984 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 06:51:19.818098 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 06:51:19.818158 drop table if exists "invoice_test"; [] gorptest: 06:51:19.818311 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.818467 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.818619 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.818830 drop table if exists "person_test"; [] gorptest: 06:51:19.818984 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.819144 drop table if exists "id_created_test"; [] gorptest: 06:51:19.819295 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.819448 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.819600 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.819754 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.819906 drop table if exists "time_test"; [] gorptest: 06:51:19.820058 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.01s) === RUN TestTypeConversionExample 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.820240 drop table if exists "invoice_test"; [] gorptest: 06:51:19.820416 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.820465 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.820509 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.820550 drop table if exists "person_test"; [] gorptest: 06:51:19.820586 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.820627 drop table if exists "id_created_test"; [] gorptest: 06:51:19.820665 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.820705 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.820740 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.820781 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.820816 drop table if exists "time_test"; [] gorptest: 06:51:19.820858 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.821057 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: 06:51:19.821238 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.821409 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.821617 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.821791 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.822001 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.822175 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.822356 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.822536 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.822716 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.822894 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.823139 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: 06:51:19.823279 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 06:51:19.823389 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: 06:51:19.823505 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 06:51:19.823578 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 06:51:19.823683 drop table if exists "invoice_test"; [] gorptest: 06:51:19.823835 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.823989 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.824142 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.824345 drop table if exists "person_test"; [] gorptest: 06:51:19.824501 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.824657 drop table if exists "id_created_test"; [] gorptest: 06:51:19.824811 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.824969 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.825162 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.825329 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.825502 drop table if exists "time_test"; [] gorptest: 06:51:19.825672 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.01s) === RUN TestWithEmbeddedStruct 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.825900 drop table if exists "invoice_test"; [] gorptest: 06:51:19.826105 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.826153 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.826194 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.826240 drop table if exists "person_test"; [] gorptest: 06:51:19.826281 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.826329 drop table if exists "id_created_test"; [] gorptest: 06:51:19.826373 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.826419 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.826460 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.826505 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.826550 drop table if exists "time_test"; [] gorptest: 06:51:19.826612 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.826833 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: 06:51:19.827042 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.827212 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.827412 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.827586 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.827759 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.827935 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.828106 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.828278 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.828451 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.828624 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.828812 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 06:51:19.828950 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 06:51:19.829029 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 06:51:19.829143 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 06:51:19.829201 select * from embedded_struct_test [] gorptest: 06:51:19.829276 drop table if exists "invoice_test"; [] gorptest: 06:51:19.829426 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.829584 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.829733 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.829982 drop table if exists "person_test"; [] gorptest: 06:51:19.830144 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.830306 drop table if exists "id_created_test"; [] gorptest: 06:51:19.830460 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.830614 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.830775 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.830926 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.831078 drop table if exists "time_test"; [] gorptest: 06:51:19.831227 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.01s) === RUN TestWithEmbeddedStructBeforeAutoincr 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.831413 drop table if exists "invoice_test"; [] gorptest: 06:51:19.831615 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.831665 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.831705 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.831740 drop table if exists "person_test"; [] gorptest: 06:51:19.831781 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.831815 drop table if exists "id_created_test"; [] gorptest: 06:51:19.831863 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.831906 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.831949 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.831987 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.832026 drop table if exists "time_test"; [] gorptest: 06:51:19.832070 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.832261 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: 06:51:19.832438 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.832616 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.832818 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.832992 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.833165 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.833342 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.833515 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.833704 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.834115 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.834332 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.834553 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 06:51:19.834696 drop table if exists "invoice_test"; [] gorptest: 06:51:19.834869 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.835048 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.835216 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.835452 drop table if exists "person_test"; [] gorptest: 06:51:19.835633 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.835799 drop table if exists "id_created_test"; [] gorptest: 06:51:19.835952 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.836104 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.836255 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.836419 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.836570 drop table if exists "time_test"; [] gorptest: 06:51:19.836719 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.836924 drop table if exists "invoice_test"; [] gorptest: 06:51:19.837108 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.837156 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.837204 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.837244 drop table if exists "person_test"; [] gorptest: 06:51:19.837285 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.837321 drop table if exists "id_created_test"; [] gorptest: 06:51:19.837361 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.837397 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.837438 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.837479 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.837522 drop table if exists "time_test"; [] gorptest: 06:51:19.837571 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.837762 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: 06:51:19.838004 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.838182 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.838391 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.838572 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.838749 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.838920 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.839095 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.839267 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.839440 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.839613 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.839816 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 06:51:19.839946 drop table if exists "invoice_test"; [] gorptest: 06:51:19.840095 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.840252 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.840407 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.840616 drop table if exists "person_test"; [] gorptest: 06:51:19.840773 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.840930 drop table if exists "id_created_test"; [] gorptest: 06:51:19.841085 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.841239 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.841391 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.841543 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.841723 drop table if exists "time_test"; [] gorptest: 06:51:19.841890 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal gorptest: 06:51:19.842041 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 06:51:19.842394 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: 06:51:19.842517 select Int64 from TableWithNull where Str='abc' [] gorptest: 06:51:19.842608 select count(*) from TableWithNull [] gorptest: 06:51:19.842668 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 06:51:19.842731 select Int64 from TableWithNull where Str='notfound' [] gorptest: 06:51:19.842791 select Int64 from TableWithNull where Str='abc' [] gorptest: 06:51:19.842851 select Float64 from TableWithNull where Str='abc' [] gorptest: 06:51:19.842908 select min(Float64) from TableWithNull [] gorptest: 06:51:19.842977 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 06:51:19.843035 select Float64 from TableWithNull where Str='notfound' [] gorptest: 06:51:19.843091 select Float64 from TableWithNull where Str='abc' [] gorptest: 06:51:19.843159 select Str from TableWithNull where Int64=? [1:78] gorptest: 06:51:19.843211 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 06:51:19.843263 select Str from TableWithNull where Int64=? [1:78] gorptest: 06:51:19.843310 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 06:51:19.843387 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 06:51:19.843445 select Str from TableWithNull where Int64=? [1:78] gorptest: 06:51:19.843503 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.843819 drop table if exists "invoice_test"; [] gorptest: 06:51:19.844017 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.844076 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.844129 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.844169 drop table if exists "person_test"; [] gorptest: 06:51:19.844216 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.844257 drop table if exists "id_created_test"; [] gorptest: 06:51:19.844302 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.844353 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.844407 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.844455 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.844505 drop table if exists "time_test"; [] gorptest: 06:51:19.844553 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.844735 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: 06:51:19.844917 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.845093 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.845295 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.845486 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.845657 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.845855 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.846052 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.846228 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.846408 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.846580 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.846766 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279846748539 2:1676962279846748539 3:"Bob" 4:"Smith" 5:1] gorptest: 06:51:19.847629 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279846896184 2:1676962279846896184 3:"Jane" 4:"Smith" 5:1] gorptest: 06:51:19.847884 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279847859027 2:1676962279847859027 3:"Mike" 4:"Smith" 5:1] gorptest: 06:51:19.848017 drop table if exists "invoice_test"; [] gorptest: 06:51:19.848209 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.848373 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.848529 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.848758 drop table if exists "person_test"; [] gorptest: 06:51:19.848927 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.849084 drop table if exists "id_created_test"; [] gorptest: 06:51:19.849237 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.849392 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.849549 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.849706 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.849887 drop table if exists "time_test"; [] gorptest: 06:51:19.850046 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk gorptest: 06:51:19.850221 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 06:51:19.850569 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 06:51:19.850714 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.851163 drop table if exists "invoice_test"; [] gorptest: 06:51:19.851340 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.851387 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.851423 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.851472 drop table if exists "person_test"; [] gorptest: 06:51:19.851512 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.851546 drop table if exists "id_created_test"; [] gorptest: 06:51:19.851615 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.851658 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.851706 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.851743 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.851782 drop table if exists "time_test"; [] gorptest: 06:51:19.851834 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.852026 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: 06:51:19.852303 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.852490 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.852697 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.852872 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.853066 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.853266 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.853462 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.853690 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.854421 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.854657 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.854880 insert into "time_test" ("Id","Time") values (null,?); [1:2023-02-21 06:20:19.8548598 +0000 UTC] gorptest: 06:51:19.855043 insert into "time_test" ("Id","Time") values (null,?); [1:2023-02-21 06:21:20.8548598 +0000 UTC] gorptest: 06:51:19.855157 SELECT id FROM time_test WHERE Time < ? [1:2023-02-21 06:21:19.8548598 +0000 UTC] gorptest: 06:51:19.855258 drop table if exists "invoice_test"; [] gorptest: 06:51:19.855413 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.855568 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.855725 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.855945 drop table if exists "person_test"; [] gorptest: 06:51:19.856104 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.856258 drop table if exists "id_created_test"; [] gorptest: 06:51:19.856412 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.856565 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.856719 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.856870 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.857023 drop table if exists "time_test"; [] gorptest: 06:51:19.857182 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.857398 drop table if exists "invoice_test"; [] gorptest: 06:51:19.857590 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.857639 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.857688 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.857723 drop table if exists "person_test"; [] gorptest: 06:51:19.857763 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.857803 drop table if exists "id_created_test"; [] gorptest: 06:51:19.857862 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.857906 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.857954 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.857997 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.858036 drop table if exists "time_test"; [] gorptest: 06:51:19.858078 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.858270 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: 06:51:19.858458 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.858633 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.858842 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.859024 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.859199 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.859374 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.859553 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.859734 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.859919 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.860099 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.860290 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279860271497 2:1676962279860271497 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.860432 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 06:51:19.860556 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 06:51:19.860668 drop table if exists "invoice_test"; [] gorptest: 06:51:19.860832 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.860982 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.861132 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.861330 drop table if exists "person_test"; [] gorptest: 06:51:19.861487 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.861672 drop table if exists "id_created_test"; [] gorptest: 06:51:19.861849 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.862021 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.862171 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.862320 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.862477 drop table if exists "time_test"; [] gorptest: 06:51:19.862622 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.862858 drop table if exists "invoice_test"; [] gorptest: 06:51:19.863042 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.863087 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.863136 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.863200 drop table if exists "person_test"; [] gorptest: 06:51:19.863252 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.863304 drop table if exists "id_created_test"; [] gorptest: 06:51:19.863343 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.863396 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.863435 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.863507 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.863561 drop table if exists "time_test"; [] gorptest: 06:51:19.863624 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.863848 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: 06:51:19.864055 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.864261 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.864498 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.864703 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.864899 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.865102 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.865300 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.865479 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.865660 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.865856 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.868237 drop table if exists "invoice_test"; [] gorptest: 06:51:19.868411 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.868463 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.868503 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.868537 drop table if exists "person_test"; [] gorptest: 06:51:19.868578 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.868612 drop table if exists "id_created_test"; [] gorptest: 06:51:19.868655 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.868689 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.868736 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.868779 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.868820 drop table if exists "time_test"; [] gorptest: 06:51:19.868863 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.869049 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: 06:51:19.869227 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.869404 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.869607 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.869783 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.870009 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.870190 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.870364 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.870537 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.870715 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.870906 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.871090 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279871073626 2:1676962279871073626 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.871228 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279871218188 2:1676962279871218188 3:"jane" 4:"doe" 5:1] gorptest: 06:51:19.871359 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.871439 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 06:51:19.871546 select * from person_test where Id=? [1:1] gorptest: 06:51:19.871651 select * from person_test order by fname asc [] gorptest: 06:51:19.871763 drop table if exists "invoice_test"; [] gorptest: 06:51:19.871923 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.872074 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.872228 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.872440 drop table if exists "person_test"; [] gorptest: 06:51:19.872635 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.872814 drop table if exists "id_created_test"; [] gorptest: 06:51:19.872987 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.873161 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.873337 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.873510 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.873681 drop table if exists "time_test"; [] gorptest: 06:51:19.874176 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.01s) === RUN TestSelectSingleVal 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.874387 drop table if exists "invoice_test"; [] gorptest: 06:51:19.874587 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.874632 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.874668 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.874715 drop table if exists "person_test"; [] gorptest: 06:51:19.874751 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.874791 drop table if exists "id_created_test"; [] gorptest: 06:51:19.874830 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.874870 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.874905 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.874945 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.874980 drop table if exists "time_test"; [] gorptest: 06:51:19.875034 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.875224 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: 06:51:19.875408 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.875582 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.875784 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.875964 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.876132 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.876303 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.876475 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.876645 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.876816 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.876988 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.877180 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279877162522 2:1676962279877162522 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.877315 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 06:51:19.877396 select * from person_test where Id=? [1:1] gorptest: 06:51:19.877501 select FName from person_test where Id=? [1:1] gorptest: 06:51:19.877555 select * from person_test where Id=? [1:1] gorptest: 06:51:19.877647 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 06:51:19.877732 select * from person_test where Id=? [1:-2222] gorptest: 06:51:19.877812 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1676962279877802438 2:1676962279877802438 3:"bob" 4:"smith" 5:1] gorptest: 06:51:19.877983 select * from person_test where Fname='bob' [] gorptest: 06:51:19.878091 select * from person_test where Id=-123 [] gorptest: 06:51:19.878148 select * from person_test where Id=-123 [] gorptest: 06:51:19.878209 select * from person_test where Id=-123 [] gorptest: 06:51:19.878268 select * from person_test where Id=-123 [] gorptest: 06:51:19.878336 drop table if exists "invoice_test"; [] gorptest: 06:51:19.878487 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.878642 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.878792 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.879002 drop table if exists "person_test"; [] gorptest: 06:51:19.879161 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.879314 drop table if exists "id_created_test"; [] gorptest: 06:51:19.879467 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.879613 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.879760 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.879913 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.880065 drop table if exists "time_test"; [] gorptest: 06:51:19.880208 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.01s) === RUN TestSelectAlias 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.880390 drop table if exists "invoice_test"; [] gorptest: 06:51:19.880568 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.880619 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.880661 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.880696 drop table if exists "person_test"; [] gorptest: 06:51:19.880743 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.880778 drop table if exists "id_created_test"; [] gorptest: 06:51:19.880818 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.880862 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.880902 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.880937 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.880984 drop table if exists "time_test"; [] gorptest: 06:51:19.881033 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.881217 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: 06:51:19.881410 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.881634 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.881884 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.882087 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.882279 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.882474 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.882684 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.882884 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.883083 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.883289 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.883484 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 06:51:19.883602 select * from id_created_test where Id=1 [] gorptest: 06:51:19.883675 SELECT *, 1 AS external FROM id_created_test [] gorptest: 06:51:19.883763 drop table if exists "invoice_test"; [] gorptest: 06:51:19.884153 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.884319 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.884479 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.884731 drop table if exists "person_test"; [] gorptest: 06:51:19.884894 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.885048 drop table if exists "id_created_test"; [] gorptest: 06:51:19.885209 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.885365 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.885515 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.885664 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.885812 drop table if exists "time_test"; [] gorptest: 06:51:19.886017 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.886250 drop table if exists "invoice_test"; [] gorptest: 06:51:19.886431 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.886481 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.886521 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.886556 drop table if exists "person_test"; [] gorptest: 06:51:19.886604 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.886645 drop table if exists "id_created_test"; [] gorptest: 06:51:19.886685 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.886720 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.886767 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.886806 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.886847 drop table if exists "time_test"; [] gorptest: 06:51:19.886895 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.887074 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: 06:51:19.887256 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.887435 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.887640 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.887813 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.887986 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.888161 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.888367 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.888549 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.888727 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.888909 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.889104 drop table if exists "invoice_test"; [] gorptest: 06:51:19.889282 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.889436 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.889590 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.889819 drop table if exists "person_test"; [] gorptest: 06:51:19.890011 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.890170 drop table if exists "id_created_test"; [] gorptest: 06:51:19.890323 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.890506 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.890679 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.890853 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.891026 drop table if exists "time_test"; [] gorptest: 06:51:19.891196 drop table if exists "id_created_test"; [] gorptest: 06:51:19.891260 drop table if exists "single_column_table"; [] gorptest: 06:51:19.891335 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: 06:51:19.891547 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: 06:51:19.891775 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.891979 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: 06:51:19.892214 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: 06:51:19.892417 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.892588 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.892765 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.892944 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.893127 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.893304 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: 06:51:19.893481 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.893653 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 06:51:19.893700 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 06:51:19.893899 delete from "invoice_test"; [] gorptest: 06:51:19.893996 delete from "invoice_tag_test"; [] gorptest: 06:51:19.894085 delete from "alias_trans_field_test"; [] gorptest: 06:51:19.894168 delete from "invoice_override_test"; [] gorptest: 06:51:19.894266 delete from "person_test"; [] gorptest: 06:51:19.894356 delete from "ignored_column_test"; [] gorptest: 06:51:19.894438 delete from "id_created_test"; [] gorptest: 06:51:19.894536 delete from "type_conv_test"; [] gorptest: 06:51:19.894627 delete from "embedded_struct_test"; [] gorptest: 06:51:19.894716 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.894800 delete from "embedded_autoincr_test"; [] gorptest: 06:51:19.894887 delete from "time_test"; [] gorptest: 06:51:19.894978 delete from "id_created_test"; [] gorptest: 06:51:19.895062 delete from "single_column_table"; [] gorptest: 06:51:19.895168 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 06:51:19.895231 drop table if exists "invoice_test"; [] gorptest: 06:51:19.895384 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.895539 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.895694 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.895913 drop table if exists "person_test"; [] gorptest: 06:51:19.896069 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.896221 drop table if exists "id_created_test"; [] gorptest: 06:51:19.896374 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.896525 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.896680 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.896835 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.896987 drop table if exists "time_test"; [] gorptest: 06:51:19.897140 drop table if exists "id_created_test"; [] gorptest: 06:51:19.897191 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) === RUN TestPrepare 2023/02/21 06:51:19 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 06:51:19.897581 drop table if exists "invoice_test"; [] gorptest: 06:51:19.897774 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.897824 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.897914 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.897966 drop table if exists "person_test"; [] gorptest: 06:51:19.898013 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.898060 drop table if exists "id_created_test"; [] gorptest: 06:51:19.898095 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.898139 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.898175 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.898218 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.898256 drop table if exists "time_test"; [] gorptest: 06:51:19.898307 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.898499 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: 06:51:19.898691 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 06:51:19.898867 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 06:51:19.899074 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 06:51:19.899251 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.899456 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 06:51:19.899652 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 06:51:19.899861 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 06:51:19.900065 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 06:51:19.900273 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 06:51:19.900477 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 06:51:19.900694 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 06:51:19.900852 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 06:51:19.900991 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 06:51:19.901150 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 06:51:19.901270 begin; [] gorptest: 06:51:19.901295 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 06:51:19.901384 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 06:51:19.901780 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 06:51:19.901883 commit; [] gorptest: 06:51:19.901955 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 06:51:19.902056 drop table if exists "invoice_test"; [] gorptest: 06:51:19.902273 drop table if exists "invoice_tag_test"; [] gorptest: 06:51:19.902640 drop table if exists "alias_trans_field_test"; [] gorptest: 06:51:19.902986 drop table if exists "invoice_override_test"; [] gorptest: 06:51:19.903465 drop table if exists "person_test"; [] gorptest: 06:51:19.903873 drop table if exists "ignored_column_test"; [] gorptest: 06:51:19.904185 drop table if exists "id_created_test"; [] gorptest: 06:51:19.904499 drop table if exists "type_conv_test"; [] gorptest: 06:51:19.904809 drop table if exists "embedded_struct_test"; [] gorptest: 06:51:19.905103 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 06:51:19.905397 drop table if exists "embedded_autoincr_test"; [] gorptest: 06:51:19.905676 drop table if exists "time_test"; [] gorptest: 06:51:19.905981 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.01s) PASS ok gopkg.in/gorp.v1 0.170s 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 -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 dpkg-genchanges --build=binary >../golang-gopkg-gorp.v1_1.7.2-2_amd64.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: 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/915486 and its subdirectories I: Current time: Mon Feb 20 18:51:23 -12 2023 I: pbuilder-time-stamp: 1676962283 Wed Jan 19 00:28:21 UTC 2022 I: 1st build successful. Starting 2nd build on remote node ionos11-amd64.debian.net. Wed Jan 19 00:28:21 UTC 2022 I: Preparing to do remote build '2' on ionos11-amd64.debian.net. Wed Jan 19 00:29:05 UTC 2022 I: Deleting $TMPDIR on ionos11-amd64.debian.net. Wed Jan 19 00:29:06 UTC 2022 I: golang-gopkg-gorp.v1_1.7.2-2_amd64.changes: Format: 1.8 Date: Sun, 19 Apr 2020 20:26:27 +0530 Source: golang-gopkg-gorp.v1 Binary: golang-gopkg-gorp.v1-dev Architecture: all Version: 1.7.2-2 Distribution: unstable Urgency: medium Maintainer: Debian Go Packaging Team Changed-By: Pirate Praveen Description: golang-gopkg-gorp.v1-dev - Go Relational Persistence - an ORM-ish library for Go (library) Changes: golang-gopkg-gorp.v1 (1.7.2-2) unstable; urgency=medium . * Source only upload for testing migration Checksums-Sha1: b0ff3c44f5e5144378ef12551b8a933ebc0ad14a 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 30a7e30803b51ee15abce57495b095df4c41065a 5457 golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 22239ec1334d1df5de195e0490e3322876271cbdd86cc6785fe9d5f8432f03c1 5457 golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 4d0bd18362942215b110493dec2e2d72 5457 devel optional golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo Wed Jan 19 00:29:07 UTC 2022 I: will be used to compare the two builds: # Profiling output for: /usr/bin/diffoscope --html /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.changes /srv/reproducible-results/rbuild-debian/tmp.XlCmRlnoZg/b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.changes ## command (total time: 0.000s) 0.000s 1 call cmp (internal) ## has_same_content_as (total time: 0.000s) 0.000s 1 call abc.DotChangesFile ## main (total time: 0.321s) 0.321s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.019s) 0.019s 10 calls diffoscope.comparators.binary.FilesystemFile 0.000s 8 calls abc.DotChangesFile Wed Jan 19 00:29:08 UTC 2022 I: found no differences in the changes files, and a .buildinfo file also exists. Wed Jan 19 00:29:08 UTC 2022 I: golang-gopkg-gorp.v1 from bullseye built successfully and reproducibly on amd64. Wed Jan 19 00:29:09 UTC 2022 I: Submitting .buildinfo files to external archives: Wed Jan 19 00:29:09 UTC 2022 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc Wed Jan 19 00:29:11 UTC 2022 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc Wed Jan 19 00:29:11 UTC 2022 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Wed Jan 19 00:29:11 UTC 2022 I: Done submitting .buildinfo files. Wed Jan 19 00:29:11 UTC 2022 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_amd64.buildinfo.asc'