Sun Apr 28 23:26:05 UTC 2024 I: starting to build golang-gopkg-gorp.v1/trixie/armhf on jenkins on '2024-04-28 23:25' Sun Apr 28 23:26:05 UTC 2024 I: The jenkins build log is/was available at https://jenkins.debian.net/userContent/reproducible/debian/build_service/armhf_14/3533/console.log Sun Apr 28 23:26:05 UTC 2024 I: Downloading source for trixie/golang-gopkg-gorp.v1=1.7.2-2 --2024-04-28 23:26:06-- http://deb.debian.org/debian/pool/main/g/golang-gopkg-gorp.v1/golang-gopkg-gorp.v1_1.7.2-2.dsc Connecting to 46.16.76.132:3128... connected. Proxy request sent, awaiting response... 200 OK Length: 2257 (2.2K) [text/prs.lines.tag] Saving to: ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ 0K .. 100% 236M=0s 2024-04-28 23:26:06 (236 MB/s) - ‘golang-gopkg-gorp.v1_1.7.2-2.dsc’ saved [2257/2257] Sun Apr 28 23:26:06 UTC 2024 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----- Sun Apr 28 23:26:06 UTC 2024 I: Checking whether the package is not for us Sun Apr 28 23:26:06 UTC 2024 I: Starting 1st build on remote node virt32z-armhf-rb.debian.net. Sun Apr 28 23:26:06 UTC 2024 I: Preparing to do remote build '1' on virt32z-armhf-rb.debian.net. Sun Apr 28 23:31:41 UTC 2024 I: Deleting $TMPDIR on virt32z-armhf-rb.debian.net. I: pbuilder: network access will be disabled during build I: Current time: Sun Apr 28 11:26:13 -12 2024 I: pbuilder-time-stamp: 1714346773 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/trixie-reproducible-base.tgz] I: copying local configuration W: --override-config is not set; not updating apt.conf Read the manpage for details. I: mounting /proc filesystem I: mounting /sys filesystem I: creating /{dev,run}/shm I: mounting /dev/pts filesystem I: redirecting /dev/ptmx to /dev/pts/ptmx I: policy-rc.d already exists I: Copying source file I: copying [golang-gopkg-gorp.v1_1.7.2-2.dsc] I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source gpgv: Signature made Sun Apr 19 14:59:56 2020 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify inline signature for ./golang-gopkg-gorp.v1_1.7.2-2.dsc: no acceptable signature found dpkg-source: info: extracting golang-gopkg-gorp.v1 in golang-gopkg-gorp.v1-1.7.2 dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2.orig.tar.xz dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps I: user script /srv/workspace/pbuilder/17262/tmp/hooks/D02_print_environment starting I: set BUILDDIR='/build/reproducible-path' BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' BUILDUSERNAME='pbuilder1' BUILD_ARCH='armhf' DEBIAN_FRONTEND='noninteractive' DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=3 ' DISTRIBUTION='trixie' HOME='/root' HOST_ARCH='armhf' IFS=' ' INVOCATION_ID='6852a41754c04f9db2c7c4a976ed08f7' 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='17262' 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/r-b-build.a86kW5fl/pbuilderrc_YHWe --distribution trixie --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' SUDO_GID='110' SUDO_UID='103' SUDO_USER='jenkins' TERM='unknown' TZ='/usr/share/zoneinfo/Etc/GMT+12' USER='root' _='/usr/bin/systemd-run' http_proxy='http://10.0.0.15:3142/' I: uname -a Linux virt32z 6.1.0-20-armmp-lpae #1 SMP Debian 6.1.85-1 (2024-04-11) armv7l GNU/Linux I: ls -l /bin lrwxrwxrwx 1 root root 7 Apr 28 11:24 /bin -> usr/bin I: user script /srv/workspace/pbuilder/17262/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy Version: 0.invalid.0 Architecture: armhf Maintainer: Debian Pbuilder Team Description: Dummy package to satisfy dependencies with aptitude - created by pbuilder This package was created automatically by pbuilder to satisfy the build-dependencies of the package being currently built. Depends: debhelper-compat (= 12), dh-golang, golang-any, golang-github-go-sql-driver-mysql-dev, golang-github-mattn-go-sqlite3-dev, golang-github-ziutek-mymysql-dev, golang-pq-dev dpkg-deb: building package 'pbuilder-satisfydepends-dummy' in '/tmp/satisfydepends-aptitude/pbuilder-satisfydepends-dummy.deb'. Selecting previously unselected package pbuilder-satisfydepends-dummy. (Reading database ... 19470 files and directories currently installed.) Preparing to unpack .../pbuilder-satisfydepends-dummy.deb ... Unpacking pbuilder-satisfydepends-dummy (0.invalid.0) ... dpkg: pbuilder-satisfydepends-dummy: dependency problems, but configuring anyway as you requested: pbuilder-satisfydepends-dummy depends on debhelper-compat (= 12); however: Package debhelper-compat is not installed. pbuilder-satisfydepends-dummy depends on dh-golang; however: Package dh-golang is not installed. pbuilder-satisfydepends-dummy depends on golang-any; however: Package golang-any is not installed. pbuilder-satisfydepends-dummy depends on golang-github-go-sql-driver-mysql-dev; however: Package golang-github-go-sql-driver-mysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-mattn-go-sqlite3-dev; however: Package golang-github-mattn-go-sqlite3-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-github-ziutek-mymysql-dev; however: Package golang-github-ziutek-mymysql-dev is not installed. pbuilder-satisfydepends-dummy depends on golang-pq-dev; however: Package golang-pq-dev is not installed. Setting up pbuilder-satisfydepends-dummy (0.invalid.0) ... Reading package lists... Building dependency tree... Reading state information... Initializing package states... Writing extended state information... Building tag database... pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) pbuilder-satisfydepends-dummy is already installed at the requested version (0.invalid.0) The following NEW packages will be installed: autoconf{a} automake{a} autopoint{a} autotools-dev{a} bsdextrautils{a} debhelper{a} dh-autoreconf{a} dh-golang{a} dh-strip-nondeterminism{a} dwz{a} file{a} gettext{a} gettext-base{a} golang-1.22-go{a} golang-1.22-src{a} golang-any{a} golang-github-davecgh-go-spew-dev{a} golang-github-go-sql-driver-mysql-dev{a} golang-github-gorilla-securecookie-dev{a} golang-github-gorilla-sessions-dev{a} golang-github-hashicorp-go-uuid-dev{a} golang-github-jcmturner-aescts.v2-dev{a} golang-github-jcmturner-dnsutils.v2-dev{a} golang-github-jcmturner-gofork-dev{a} golang-github-jcmturner-goidentity.v6-dev{a} golang-github-jcmturner-gokrb5.v8-dev{a} golang-github-jcmturner-rpc.v2-dev{a} golang-github-lib-pq-dev{a} golang-github-mattn-go-sqlite3-dev{a} golang-github-pmezard-go-difflib-dev{a} golang-github-stretchr-objx-dev{a} golang-github-stretchr-testify-dev{a} golang-github-ziutek-mymysql-dev{a} golang-go{a} golang-golang-x-crypto-dev{a} golang-golang-x-net-dev{a} golang-golang-x-sys-dev{a} golang-golang-x-term-dev{a} golang-golang-x-text-dev{a} golang-gopkg-yaml.v3-dev{a} golang-src{a} groff-base{a} intltool-debian{a} libarchive-zip-perl{a} libdebhelper-perl{a} libelf1t64{a} libfile-stripnondeterminism-perl{a} libicu72{a} libmagic-mgc{a} libmagic1{a} libpipeline1{a} libsqlite3-dev{a} libsub-override-perl{a} libtool{a} libuchardet0{a} libxml2{a} m4{a} man-db{a} po-debconf{a} sensible-utils{a} The following packages are RECOMMENDED but will NOT be installed: curl libarchive-cpio-perl libltdl-dev libmail-sendmail-perl lynx pkg-config pkgconf wget 0 packages upgraded, 60 newly installed, 0 to remove and 0 not upgraded. Need to get 67.4 MB of archives. After unpacking 363 MB will be used. Writing extended state information... Get: 1 http://deb.debian.org/debian trixie/main armhf sensible-utils all 0.0.22 [22.4 kB] Get: 2 http://deb.debian.org/debian trixie/main armhf libmagic-mgc armhf 1:5.45-2+b1 [314 kB] Get: 3 http://deb.debian.org/debian trixie/main armhf libmagic1 armhf 1:5.45-2+b1 [97.9 kB] Get: 4 http://deb.debian.org/debian trixie/main armhf file armhf 1:5.45-2+b1 [42.2 kB] Get: 5 http://deb.debian.org/debian trixie/main armhf gettext-base armhf 0.21-14+b1 [157 kB] Get: 6 http://deb.debian.org/debian trixie/main armhf libuchardet0 armhf 0.0.8-1+b1 [65.7 kB] Get: 7 http://deb.debian.org/debian trixie/main armhf groff-base armhf 1.23.0-3 [1088 kB] Get: 8 http://deb.debian.org/debian trixie/main armhf bsdextrautils armhf 2.39.3-6 [81.2 kB] Get: 9 http://deb.debian.org/debian trixie/main armhf libpipeline1 armhf 1.5.7-2 [33.3 kB] Get: 10 http://deb.debian.org/debian trixie/main armhf man-db armhf 2.12.0-3 [1367 kB] Get: 11 http://deb.debian.org/debian trixie/main armhf m4 armhf 1.4.19-4 [264 kB] Get: 12 http://deb.debian.org/debian trixie/main armhf autoconf all 2.71-3 [332 kB] Get: 13 http://deb.debian.org/debian trixie/main armhf autotools-dev all 20220109.1 [51.6 kB] Get: 14 http://deb.debian.org/debian trixie/main armhf automake all 1:1.16.5-1.3 [823 kB] Get: 15 http://deb.debian.org/debian trixie/main armhf autopoint all 0.21-14 [496 kB] Get: 16 http://deb.debian.org/debian trixie/main armhf libdebhelper-perl all 13.15.3 [88.0 kB] Get: 17 http://deb.debian.org/debian trixie/main armhf libtool all 2.4.7-7 [517 kB] Get: 18 http://deb.debian.org/debian trixie/main armhf dh-autoreconf all 20 [17.1 kB] Get: 19 http://deb.debian.org/debian trixie/main armhf libarchive-zip-perl all 1.68-1 [104 kB] Get: 20 http://deb.debian.org/debian trixie/main armhf libsub-override-perl all 0.10-1 [10.6 kB] Get: 21 http://deb.debian.org/debian trixie/main armhf libfile-stripnondeterminism-perl all 1.13.1-1 [19.4 kB] Get: 22 http://deb.debian.org/debian trixie/main armhf dh-strip-nondeterminism all 1.13.1-1 [8620 B] Get: 23 http://deb.debian.org/debian trixie/main armhf libelf1t64 armhf 0.191-1+b1 [183 kB] Get: 24 http://deb.debian.org/debian trixie/main armhf dwz armhf 0.15-1+b2 [106 kB] Get: 25 http://deb.debian.org/debian trixie/main armhf libicu72 armhf 72.1-4+b1 [9070 kB] Get: 26 http://deb.debian.org/debian trixie/main armhf libxml2 armhf 2.9.14+dfsg-1.3+b3 [598 kB] Get: 27 http://deb.debian.org/debian trixie/main armhf gettext armhf 0.21-14+b1 [1230 kB] Get: 28 http://deb.debian.org/debian trixie/main armhf intltool-debian all 0.35.0+20060710.6 [22.9 kB] Get: 29 http://deb.debian.org/debian trixie/main armhf po-debconf all 1.0.21+nmu1 [248 kB] Get: 30 http://deb.debian.org/debian trixie/main armhf debhelper all 13.15.3 [901 kB] Get: 31 http://deb.debian.org/debian trixie/main armhf dh-golang all 1.62 [24.7 kB] Get: 32 http://deb.debian.org/debian trixie/main armhf golang-1.22-src all 1.22.2-2 [18.8 MB] Get: 33 http://deb.debian.org/debian trixie/main armhf golang-1.22-go armhf 1.22.2-2 [21.5 MB] Get: 34 http://deb.debian.org/debian trixie/main armhf golang-src all 2:1.22~3 [5020 B] Get: 35 http://deb.debian.org/debian trixie/main armhf golang-go armhf 2:1.22~3 [44.2 kB] Get: 36 http://deb.debian.org/debian trixie/main armhf golang-any armhf 2:1.22~3 [5104 B] Get: 37 http://deb.debian.org/debian trixie/main armhf golang-github-davecgh-go-spew-dev all 1.1.1-3 [30.1 kB] Get: 38 http://deb.debian.org/debian trixie/main armhf golang-github-go-sql-driver-mysql-dev all 1.7.1-2 [74.6 kB] Get: 39 http://deb.debian.org/debian trixie/main armhf golang-github-gorilla-securecookie-dev all 1.1.2-1 [14.0 kB] Get: 40 http://deb.debian.org/debian trixie/main armhf golang-github-gorilla-sessions-dev all 1.2.1-1 [12.8 kB] Get: 41 http://deb.debian.org/debian trixie/main armhf golang-github-hashicorp-go-uuid-dev all 1.0.3-1 [8636 B] Get: 42 http://deb.debian.org/debian trixie/main armhf golang-github-pmezard-go-difflib-dev all 1.0.0-3 [12.3 kB] Get: 43 http://deb.debian.org/debian trixie/main armhf golang-github-stretchr-objx-dev all 0.5.2-1 [25.5 kB] Get: 44 http://deb.debian.org/debian trixie/main armhf golang-gopkg-yaml.v3-dev all 3.0.1-3 [74.3 kB] Get: 45 http://deb.debian.org/debian trixie/main armhf golang-github-stretchr-testify-dev all 1.8.4-1 [71.8 kB] Get: 46 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-aescts.v2-dev all 2.0.0-2 [4828 B] Get: 47 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-dnsutils.v2-dev all 2.0.0-2 [3872 B] Get: 48 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-gofork-dev all 1.0.0-4 [25.1 kB] Get: 49 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-goidentity.v6-dev all 6.0.1-2 [3752 B] Get: 50 http://deb.debian.org/debian trixie/main armhf golang-golang-x-sys-dev all 0.18.0-1 [402 kB] Get: 51 http://deb.debian.org/debian trixie/main armhf golang-golang-x-term-dev all 0.18.0-1 [14.7 kB] Get: 52 http://deb.debian.org/debian trixie/main armhf golang-golang-x-text-dev all 0.14.0-2 [4001 kB] Get: 53 http://deb.debian.org/debian trixie/main armhf golang-golang-x-crypto-dev all 1:0.21.0-1 [1671 kB] Get: 54 http://deb.debian.org/debian trixie/main armhf golang-golang-x-net-dev all 1:0.23.0+dfsg-1 [896 kB] Get: 55 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-rpc.v2-dev all 2.0.3-2 [24.7 kB] Get: 56 http://deb.debian.org/debian trixie/main armhf golang-github-jcmturner-gokrb5.v8-dev all 8.4.3-2 [119 kB] Get: 57 http://deb.debian.org/debian trixie/main armhf golang-github-lib-pq-dev all 1.10.9-2 [86.6 kB] Get: 58 http://deb.debian.org/debian trixie/main armhf libsqlite3-dev armhf 3.45.1-1 [985 kB] Get: 59 http://deb.debian.org/debian trixie/main armhf golang-github-mattn-go-sqlite3-dev armhf 1.14.19~ds1-1 [83.4 kB] Get: 60 http://deb.debian.org/debian trixie/main armhf golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] Fetched 67.4 MB in 2s (38.0 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19470 files and directories currently installed.) Preparing to unpack .../00-sensible-utils_0.0.22_all.deb ... Unpacking sensible-utils (0.0.22) ... Selecting previously unselected package libmagic-mgc. Preparing to unpack .../01-libmagic-mgc_1%3a5.45-2+b1_armhf.deb ... Unpacking libmagic-mgc (1:5.45-2+b1) ... Selecting previously unselected package libmagic1:armhf. Preparing to unpack .../02-libmagic1_1%3a5.45-2+b1_armhf.deb ... Unpacking libmagic1:armhf (1:5.45-2+b1) ... Selecting previously unselected package file. Preparing to unpack .../03-file_1%3a5.45-2+b1_armhf.deb ... Unpacking file (1:5.45-2+b1) ... Selecting previously unselected package gettext-base. Preparing to unpack .../04-gettext-base_0.21-14+b1_armhf.deb ... Unpacking gettext-base (0.21-14+b1) ... Selecting previously unselected package libuchardet0:armhf. Preparing to unpack .../05-libuchardet0_0.0.8-1+b1_armhf.deb ... Unpacking libuchardet0:armhf (0.0.8-1+b1) ... Selecting previously unselected package groff-base. Preparing to unpack .../06-groff-base_1.23.0-3_armhf.deb ... Unpacking groff-base (1.23.0-3) ... Selecting previously unselected package bsdextrautils. Preparing to unpack .../07-bsdextrautils_2.39.3-6_armhf.deb ... Unpacking bsdextrautils (2.39.3-6) ... Selecting previously unselected package libpipeline1:armhf. Preparing to unpack .../08-libpipeline1_1.5.7-2_armhf.deb ... Unpacking libpipeline1:armhf (1.5.7-2) ... Selecting previously unselected package man-db. Preparing to unpack .../09-man-db_2.12.0-3_armhf.deb ... Unpacking man-db (2.12.0-3) ... Selecting previously unselected package m4. Preparing to unpack .../10-m4_1.4.19-4_armhf.deb ... Unpacking m4 (1.4.19-4) ... Selecting previously unselected package autoconf. Preparing to unpack .../11-autoconf_2.71-3_all.deb ... Unpacking autoconf (2.71-3) ... Selecting previously unselected package autotools-dev. Preparing to unpack .../12-autotools-dev_20220109.1_all.deb ... Unpacking autotools-dev (20220109.1) ... Selecting previously unselected package automake. Preparing to unpack .../13-automake_1%3a1.16.5-1.3_all.deb ... Unpacking automake (1:1.16.5-1.3) ... Selecting previously unselected package autopoint. Preparing to unpack .../14-autopoint_0.21-14_all.deb ... Unpacking autopoint (0.21-14) ... Selecting previously unselected package libdebhelper-perl. Preparing to unpack .../15-libdebhelper-perl_13.15.3_all.deb ... Unpacking libdebhelper-perl (13.15.3) ... Selecting previously unselected package libtool. Preparing to unpack .../16-libtool_2.4.7-7_all.deb ... Unpacking libtool (2.4.7-7) ... Selecting previously unselected package dh-autoreconf. Preparing to unpack .../17-dh-autoreconf_20_all.deb ... Unpacking dh-autoreconf (20) ... Selecting previously unselected package libarchive-zip-perl. Preparing to unpack .../18-libarchive-zip-perl_1.68-1_all.deb ... Unpacking libarchive-zip-perl (1.68-1) ... Selecting previously unselected package libsub-override-perl. Preparing to unpack .../19-libsub-override-perl_0.10-1_all.deb ... Unpacking libsub-override-perl (0.10-1) ... Selecting previously unselected package libfile-stripnondeterminism-perl. Preparing to unpack .../20-libfile-stripnondeterminism-perl_1.13.1-1_all.deb ... Unpacking libfile-stripnondeterminism-perl (1.13.1-1) ... Selecting previously unselected package dh-strip-nondeterminism. Preparing to unpack .../21-dh-strip-nondeterminism_1.13.1-1_all.deb ... Unpacking dh-strip-nondeterminism (1.13.1-1) ... Selecting previously unselected package libelf1t64:armhf. Preparing to unpack .../22-libelf1t64_0.191-1+b1_armhf.deb ... Unpacking libelf1t64:armhf (0.191-1+b1) ... Selecting previously unselected package dwz. Preparing to unpack .../23-dwz_0.15-1+b2_armhf.deb ... Unpacking dwz (0.15-1+b2) ... Selecting previously unselected package libicu72:armhf. Preparing to unpack .../24-libicu72_72.1-4+b1_armhf.deb ... Unpacking libicu72:armhf (72.1-4+b1) ... Selecting previously unselected package libxml2:armhf. Preparing to unpack .../25-libxml2_2.9.14+dfsg-1.3+b3_armhf.deb ... Unpacking libxml2:armhf (2.9.14+dfsg-1.3+b3) ... Selecting previously unselected package gettext. Preparing to unpack .../26-gettext_0.21-14+b1_armhf.deb ... Unpacking gettext (0.21-14+b1) ... Selecting previously unselected package intltool-debian. Preparing to unpack .../27-intltool-debian_0.35.0+20060710.6_all.deb ... Unpacking intltool-debian (0.35.0+20060710.6) ... Selecting previously unselected package po-debconf. Preparing to unpack .../28-po-debconf_1.0.21+nmu1_all.deb ... Unpacking po-debconf (1.0.21+nmu1) ... Selecting previously unselected package debhelper. Preparing to unpack .../29-debhelper_13.15.3_all.deb ... Unpacking debhelper (13.15.3) ... Selecting previously unselected package dh-golang. Preparing to unpack .../30-dh-golang_1.62_all.deb ... Unpacking dh-golang (1.62) ... Selecting previously unselected package golang-1.22-src. Preparing to unpack .../31-golang-1.22-src_1.22.2-2_all.deb ... Unpacking golang-1.22-src (1.22.2-2) ... Selecting previously unselected package golang-1.22-go. Preparing to unpack .../32-golang-1.22-go_1.22.2-2_armhf.deb ... Unpacking golang-1.22-go (1.22.2-2) ... Selecting previously unselected package golang-src. Preparing to unpack .../33-golang-src_2%3a1.22~3_all.deb ... Unpacking golang-src (2:1.22~3) ... Selecting previously unselected package golang-go:armhf. Preparing to unpack .../34-golang-go_2%3a1.22~3_armhf.deb ... Unpacking golang-go:armhf (2:1.22~3) ... Selecting previously unselected package golang-any:armhf. Preparing to unpack .../35-golang-any_2%3a1.22~3_armhf.deb ... Unpacking golang-any:armhf (2:1.22~3) ... Selecting previously unselected package golang-github-davecgh-go-spew-dev. Preparing to unpack .../36-golang-github-davecgh-go-spew-dev_1.1.1-3_all.deb ... Unpacking golang-github-davecgh-go-spew-dev (1.1.1-3) ... Selecting previously unselected package golang-github-go-sql-driver-mysql-dev. Preparing to unpack .../37-golang-github-go-sql-driver-mysql-dev_1.7.1-2_all.deb ... Unpacking golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Selecting previously unselected package golang-github-gorilla-securecookie-dev. Preparing to unpack .../38-golang-github-gorilla-securecookie-dev_1.1.2-1_all.deb ... Unpacking golang-github-gorilla-securecookie-dev (1.1.2-1) ... Selecting previously unselected package golang-github-gorilla-sessions-dev. Preparing to unpack .../39-golang-github-gorilla-sessions-dev_1.2.1-1_all.deb ... Unpacking golang-github-gorilla-sessions-dev (1.2.1-1) ... Selecting previously unselected package golang-github-hashicorp-go-uuid-dev. Preparing to unpack .../40-golang-github-hashicorp-go-uuid-dev_1.0.3-1_all.deb ... Unpacking golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... Selecting previously unselected package golang-github-pmezard-go-difflib-dev. Preparing to unpack .../41-golang-github-pmezard-go-difflib-dev_1.0.0-3_all.deb ... Unpacking golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Selecting previously unselected package golang-github-stretchr-objx-dev. Preparing to unpack .../42-golang-github-stretchr-objx-dev_0.5.2-1_all.deb ... Unpacking golang-github-stretchr-objx-dev (0.5.2-1) ... Selecting previously unselected package golang-gopkg-yaml.v3-dev. Preparing to unpack .../43-golang-gopkg-yaml.v3-dev_3.0.1-3_all.deb ... Unpacking golang-gopkg-yaml.v3-dev (3.0.1-3) ... Selecting previously unselected package golang-github-stretchr-testify-dev. Preparing to unpack .../44-golang-github-stretchr-testify-dev_1.8.4-1_all.deb ... Unpacking golang-github-stretchr-testify-dev (1.8.4-1) ... Selecting previously unselected package golang-github-jcmturner-aescts.v2-dev. Preparing to unpack .../45-golang-github-jcmturner-aescts.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-dnsutils.v2-dev. Preparing to unpack .../46-golang-github-jcmturner-dnsutils.v2-dev_2.0.0-2_all.deb ... Unpacking golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Selecting previously unselected package golang-github-jcmturner-gofork-dev. Preparing to unpack .../47-golang-github-jcmturner-gofork-dev_1.0.0-4_all.deb ... Unpacking golang-github-jcmturner-gofork-dev (1.0.0-4) ... Selecting previously unselected package golang-github-jcmturner-goidentity.v6-dev. Preparing to unpack .../48-golang-github-jcmturner-goidentity.v6-dev_6.0.1-2_all.deb ... Unpacking golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Selecting previously unselected package golang-golang-x-sys-dev. Preparing to unpack .../49-golang-golang-x-sys-dev_0.18.0-1_all.deb ... Unpacking golang-golang-x-sys-dev (0.18.0-1) ... Selecting previously unselected package golang-golang-x-term-dev. Preparing to unpack .../50-golang-golang-x-term-dev_0.18.0-1_all.deb ... Unpacking golang-golang-x-term-dev (0.18.0-1) ... Selecting previously unselected package golang-golang-x-text-dev. Preparing to unpack .../51-golang-golang-x-text-dev_0.14.0-2_all.deb ... Unpacking golang-golang-x-text-dev (0.14.0-2) ... Selecting previously unselected package golang-golang-x-crypto-dev. Preparing to unpack .../52-golang-golang-x-crypto-dev_1%3a0.21.0-1_all.deb ... Unpacking golang-golang-x-crypto-dev (1:0.21.0-1) ... Selecting previously unselected package golang-golang-x-net-dev. Preparing to unpack .../53-golang-golang-x-net-dev_1%3a0.23.0+dfsg-1_all.deb ... Unpacking golang-golang-x-net-dev (1:0.23.0+dfsg-1) ... Selecting previously unselected package golang-github-jcmturner-rpc.v2-dev. Preparing to unpack .../54-golang-github-jcmturner-rpc.v2-dev_2.0.3-2_all.deb ... Unpacking golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Selecting previously unselected package golang-github-jcmturner-gokrb5.v8-dev. Preparing to unpack .../55-golang-github-jcmturner-gokrb5.v8-dev_8.4.3-2_all.deb ... Unpacking golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Selecting previously unselected package golang-github-lib-pq-dev. Preparing to unpack .../56-golang-github-lib-pq-dev_1.10.9-2_all.deb ... Unpacking golang-github-lib-pq-dev (1.10.9-2) ... Selecting previously unselected package libsqlite3-dev:armhf. Preparing to unpack .../57-libsqlite3-dev_3.45.1-1_armhf.deb ... Unpacking libsqlite3-dev:armhf (3.45.1-1) ... Selecting previously unselected package golang-github-mattn-go-sqlite3-dev:armhf. Preparing to unpack .../58-golang-github-mattn-go-sqlite3-dev_1.14.19~ds1-1_armhf.deb ... Unpacking golang-github-mattn-go-sqlite3-dev:armhf (1.14.19~ds1-1) ... Selecting previously unselected package golang-github-ziutek-mymysql-dev. Preparing to unpack .../59-golang-github-ziutek-mymysql-dev_1.5.4+git20170206.23.0582bcf-2_all.deb ... Unpacking golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up libpipeline1:armhf (1.5.7-2) ... Setting up golang-github-jcmturner-gofork-dev (1.0.0-4) ... Setting up golang-github-hashicorp-go-uuid-dev (1.0.3-1) ... Setting up libicu72:armhf (72.1-4+b1) ... Setting up bsdextrautils (2.39.3-6) ... Setting up golang-github-stretchr-objx-dev (0.5.2-1) ... Setting up libmagic-mgc (1:5.45-2+b1) ... Setting up libarchive-zip-perl (1.68-1) ... Setting up golang-gopkg-yaml.v3-dev (3.0.1-3) ... Setting up libdebhelper-perl (13.15.3) ... Setting up golang-golang-x-sys-dev (0.18.0-1) ... Setting up libmagic1:armhf (1:5.45-2+b1) ... Setting up golang-github-pmezard-go-difflib-dev (1.0.0-3) ... Setting up gettext-base (0.21-14+b1) ... Setting up m4 (1.4.19-4) ... Setting up golang-golang-x-term-dev (0.18.0-1) ... Setting up file (1:5.45-2+b1) ... Setting up libelf1t64:armhf (0.191-1+b1) ... Setting up golang-github-davecgh-go-spew-dev (1.1.1-3) ... Setting up autotools-dev (20220109.1) ... Setting up libsqlite3-dev:armhf (3.45.1-1) ... Setting up golang-github-ziutek-mymysql-dev (1.5.4+git20170206.23.0582bcf-2) ... Setting up golang-github-stretchr-testify-dev (1.8.4-1) ... Setting up golang-github-jcmturner-aescts.v2-dev (2.0.0-2) ... Setting up golang-1.22-src (1.22.2-2) ... Setting up autopoint (0.21-14) ... Setting up autoconf (2.71-3) ... Setting up dwz (0.15-1+b2) ... Setting up sensible-utils (0.0.22) ... Setting up golang-golang-x-text-dev (0.14.0-2) ... Setting up golang-github-go-sql-driver-mysql-dev (1.7.1-2) ... Setting up libuchardet0:armhf (0.0.8-1+b1) ... Setting up libsub-override-perl (0.10-1) ... Setting up golang-golang-x-crypto-dev (1:0.21.0-1) ... Setting up golang-github-jcmturner-goidentity.v6-dev (6.0.1-2) ... Setting up golang-src (2:1.22~3) ... Setting up golang-github-gorilla-securecookie-dev (1.1.2-1) ... Setting up libxml2:armhf (2.9.14+dfsg-1.3+b3) ... Setting up golang-github-gorilla-sessions-dev (1.2.1-1) ... Setting up automake (1:1.16.5-1.3) ... update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode Setting up libfile-stripnondeterminism-perl (1.13.1-1) ... Setting up gettext (0.21-14+b1) ... Setting up golang-github-jcmturner-dnsutils.v2-dev (2.0.0-2) ... Setting up libtool (2.4.7-7) ... Setting up golang-1.22-go (1.22.2-2) ... Setting up intltool-debian (0.35.0+20060710.6) ... Setting up dh-autoreconf (20) ... Setting up golang-github-mattn-go-sqlite3-dev:armhf (1.14.19~ds1-1) ... Setting up golang-golang-x-net-dev (1:0.23.0+dfsg-1) ... Setting up dh-strip-nondeterminism (1.13.1-1) ... Setting up groff-base (1.23.0-3) ... Setting up golang-go:armhf (2:1.22~3) ... Setting up po-debconf (1.0.21+nmu1) ... Setting up golang-github-jcmturner-rpc.v2-dev (2.0.3-2) ... Setting up man-db (2.12.0-3) ... Not building database; man-db/auto-update is not 'true'. Setting up golang-any:armhf (2:1.22~3) ... Setting up golang-github-jcmturner-gokrb5.v8-dev (8.4.3-2) ... Setting up debhelper (13.15.3) ... Setting up golang-github-lib-pq-dev (1.10.9-2) ... Setting up dh-golang (1.62) ... Processing triggers for libc-bin (2.37-18) ... 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/reproducible-path/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 armhf debian/rules clean dh clean --builddirectory=_build --buildsystem=golang --with=golang dh_auto_clean -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf_clean -O--builddirectory=_build -O--buildsystem=golang dh_clean -O--builddirectory=_build -O--buildsystem=golang debian/rules binary dh binary --builddirectory=_build --buildsystem=golang --with=golang dh_update_autotools_config -O--builddirectory=_build -O--buildsystem=golang dh_autoreconf -O--builddirectory=_build -O--buildsystem=golang dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 3 gopkg.in/gorp.v1 internal/goarch internal/unsafeheader internal/cpu internal/abi internal/chacha8rand internal/bytealg internal/coverage/rtcov internal/godebugs internal/goexperiment internal/goos runtime/internal/atomic runtime/internal/math runtime/internal/sys runtime/internal/syscall internal/race sync/atomic unicode unicode/utf8 internal/itoa math/bits math runtime cmp slices log/internal sync internal/reflectlite internal/testlog errors sort io internal/oserror syscall bytes strconv internal/safefilepath path strings reflect regexp/syntax time internal/syscall/unix internal/syscall/execenv regexp context internal/poll io/fs internal/fmtsort os fmt database/sql/driver log database/sql gopkg.in/gorp.v1 dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 3 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists 2024/04/28 23:31:00 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: 23:31:00.921907 drop table if exists "invoice_test"; [] gorptest: 23:31:00.932031 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:00.932176 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:00.932235 drop table if exists "invoice_override_test"; [] gorptest: 23:31:00.932290 drop table if exists "person_test"; [] gorptest: 23:31:00.932347 drop table if exists "ignored_column_test"; [] gorptest: 23:31:00.932412 drop table if exists "id_created_test"; [] gorptest: 23:31:00.932468 drop table if exists "type_conv_test"; [] gorptest: 23:31:00.932523 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:00.932577 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:00.932632 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:00.932686 drop table if exists "time_test"; [] gorptest: 23:31:00.932793 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:00.955603 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: 23:31:00.975265 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:01.015594 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:01.026838 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:01.038463 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.059533 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.083562 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:01.103571 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:01.125825 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:01.180878 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:01.194296 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:01.209447 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: 23:31:01.209642 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: 23:31:01.209720 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:01.209799 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: 23:31:01.209879 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: 23:31:01.209951 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.210018 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.210092 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:01.210170 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:01.210242 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:01.210318 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: 23:31:01.210387 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:01.210455 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 23:31:01.210516 drop table if exists "invoice_test"; [] gorptest: 23:31:01.219571 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:01.235641 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:01.250952 drop table if exists "invoice_override_test"; [] gorptest: 23:31:01.267580 drop table if exists "person_test"; [] gorptest: 23:31:01.287551 drop table if exists "ignored_column_test"; [] gorptest: 23:31:01.303581 drop table if exists "id_created_test"; [] gorptest: 23:31:01.319684 drop table if exists "type_conv_test"; [] gorptest: 23:31:01.334064 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:01.355537 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:01.371529 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:01.387559 drop table if exists "time_test"; [] gorptest: 23:31:01.411550 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.49s) === RUN TestTruncateTables 2024/04/28 23:31:01 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: 23:31:01.412084 drop table if exists "invoice_test"; [] gorptest: 23:31:01.412628 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:01.412702 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:01.412762 drop table if exists "invoice_override_test"; [] gorptest: 23:31:01.412823 drop table if exists "person_test"; [] gorptest: 23:31:01.412881 drop table if exists "ignored_column_test"; [] gorptest: 23:31:01.412939 drop table if exists "id_created_test"; [] gorptest: 23:31:01.412996 drop table if exists "type_conv_test"; [] gorptest: 23:31:01.413054 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:01.413112 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:01.413169 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:01.413226 drop table if exists "time_test"; [] gorptest: 23:31:01.413303 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:01.427565 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: 23:31:01.443539 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:01.463597 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:01.479591 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:01.495546 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.515490 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.531560 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:01.548179 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:01.567558 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:01.583552 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:01.603560 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:01.619583 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: 23:31:01.619772 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: 23:31:01.619856 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:01.619936 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: 23:31:01.620019 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: 23:31:01.620130 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.620210 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:01.620291 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:01.620365 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:01.620438 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:01.620513 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: 23:31:01.620589 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:01.620654 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 23:31:01.620835 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347061620768789 2:1714347061620768789 3:"Bob" 4:"Smith" 5:1] gorptest: 23:31:01.643594 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 23:31:01.667555 delete from "invoice_test"; [] gorptest: 23:31:01.683536 delete from "invoice_tag_test"; [] gorptest: 23:31:01.699528 delete from "alias_trans_field_test"; [] gorptest: 23:31:01.715529 delete from "invoice_override_test"; [] gorptest: 23:31:01.731531 delete from "person_test"; [] gorptest: 23:31:01.747539 delete from "ignored_column_test"; [] gorptest: 23:31:01.758635 delete from "id_created_test"; [] gorptest: 23:31:01.767516 delete from "type_conv_test"; [] gorptest: 23:31:01.783514 delete from "embedded_struct_test"; [] gorptest: 23:31:01.799527 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:01.815522 delete from "embedded_autoincr_test"; [] gorptest: 23:31:01.831519 delete from "time_test"; [] gorptest: 23:31:01.847521 delete from "id_created_test"; [] gorptest: 23:31:01.863514 SELECT * FROM person_test [] gorptest: 23:31:01.863803 SELECT * FROM invoice_test [] gorptest: 23:31:01.863941 drop table if exists "invoice_test"; [] gorptest: 23:31:01.879528 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:01.895540 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:01.911529 drop table if exists "invoice_override_test"; [] gorptest: 23:31:01.927547 drop table if exists "person_test"; [] gorptest: 23:31:01.943532 drop table if exists "ignored_column_test"; [] gorptest: 23:31:01.954741 drop table if exists "id_created_test"; [] gorptest: 23:31:01.971536 drop table if exists "type_conv_test"; [] gorptest: 23:31:01.987532 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:02.003545 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:02.018276 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:02.039537 drop table if exists "time_test"; [] gorptest: 23:31:02.049598 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.64s) === RUN TestCustomDateType gorptest: 23:31:02.050036 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 23:31:02.059841 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-04-28 23:31:02 +0000 UTC] gorptest: 23:31:02.065923 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 23:31:02.066176 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.02s) === RUN TestUIntPrimaryKey gorptest: 23:31:02.072508 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 23:31:02.086045 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 23:31:02.102888 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 23:31:02.119604 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 23:31:02.135570 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 23:31:02.155556 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 23:31:02.167552 drop table if exists "PersonUInt64"; [] gorptest: 23:31:02.183509 drop table if exists "PersonUInt32"; [] gorptest: 23:31:02.203537 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.15s) === RUN TestSetUniqueTogether gorptest: 23:31:02.223841 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 23:31:02.244160 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 23:31:02.263603 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 23:31:02.263909 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 23:31:02.264046 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 23:31:02.283542 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.08s) === RUN TestPersistentUser gorptest: 23:31:02.303864 drop table if exists PersistentUser [] gorptest: 23:31:02.304419 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 23:31:02.327594 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 23:31:02.343549 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 23:31:02.343797 select * from PersistentUser [] gorptest: 23:31:02.343940 select * from PersistentUser [] gorptest: 23:31:02.344087 select * from PersistentUser [] gorptest: 23:31:02.344215 select Id from PersistentUser [] gorptest: 23:31:02.344302 select mykey from PersistentUser [] gorptest: 23:31:02.344387 select PassedTraining from PersistentUser [] gorptest: 23:31:02.344470 select Id from PersistentUser [] gorptest: 23:31:02.344558 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.06s) === RUN TestNamedQueryMap gorptest: 23:31:02.363795 drop table if exists PersistentUser [] gorptest: 23:31:02.364505 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 23:31:02.379579 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 23:31:02.395552 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 23:31:02.415616 select * from PersistentUser where mykey = ? [1:43] gorptest: 23:31:02.415907 select * from PersistentUser where mykey = ? [1:43] gorptest: 23:31:02.416048 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 23:31:02.416233 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 23:31:02.416352 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.07s) === RUN TestNamedQueryStruct gorptest: 23:31:02.435774 drop table if exists PersistentUser [] gorptest: 23:31:02.436328 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 23:31:02.455551 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 23:31:02.475557 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 23:31:02.495561 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 23:31:02.495862 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.08s) === RUN TestReturnsNonNilSlice 2024/04/28 23:31:02 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: 23:31:02.516145 drop table if exists "invoice_test"; [] gorptest: 23:31:02.516613 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:02.516674 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:02.516730 drop table if exists "invoice_override_test"; [] gorptest: 23:31:02.516785 drop table if exists "person_test"; [] gorptest: 23:31:02.516840 drop table if exists "ignored_column_test"; [] gorptest: 23:31:02.516894 drop table if exists "id_created_test"; [] gorptest: 23:31:02.516949 drop table if exists "type_conv_test"; [] gorptest: 23:31:02.517036 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:02.517100 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:02.517157 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:02.517213 drop table if exists "time_test"; [] gorptest: 23:31:02.517289 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:02.535562 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: 23:31:02.555556 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:02.571626 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:02.587561 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:02.606755 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:02.627557 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:02.647576 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:02.663553 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:02.679565 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:02.699555 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:02.715542 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:02.734583 select * from invoice_test where id=99999 [] gorptest: 23:31:02.734833 select * from invoice_test where id=99999 [] gorptest: 23:31:02.734952 drop table if exists "invoice_test"; [] gorptest: 23:31:02.751507 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:02.768973 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:02.783515 drop table if exists "invoice_override_test"; [] gorptest: 23:31:02.803525 drop table if exists "person_test"; [] gorptest: 23:31:02.819517 drop table if exists "ignored_column_test"; [] gorptest: 23:31:02.835503 drop table if exists "id_created_test"; [] gorptest: 23:31:02.851502 drop table if exists "type_conv_test"; [] gorptest: 23:31:02.871525 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:02.887515 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:02.903528 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:02.919549 drop table if exists "time_test"; [] gorptest: 23:31:02.935516 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.42s) === RUN TestOverrideVersionCol gorptest: 23:31:02.935933 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 23:31:02.951568 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: 23:31:02.951807 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.03s) === RUN TestOptimisticLocking 2024/04/28 23:31:02 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: 23:31:02.967967 drop table if exists "invoice_test"; [] gorptest: 23:31:02.968478 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:02.968540 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:02.968596 drop table if exists "invoice_override_test"; [] gorptest: 23:31:02.968652 drop table if exists "person_test"; [] gorptest: 23:31:02.968707 drop table if exists "ignored_column_test"; [] gorptest: 23:31:02.968762 drop table if exists "id_created_test"; [] gorptest: 23:31:02.968815 drop table if exists "type_conv_test"; [] gorptest: 23:31:02.968869 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:02.968923 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:02.968979 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:02.969033 drop table if exists "time_test"; [] gorptest: 23:31:02.969107 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:02.983615 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: 23:31:02.998122 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:03.006534 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:03.023583 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:03.039533 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:03.059589 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:03.078873 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:03.102155 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:03.115550 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:03.135575 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:03.155565 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:03.166941 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347063166855319 2:1714347063166855319 3:"Bob" 4:"Smith" 5:1] gorptest: 23:31:03.183591 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:03.183897 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1714347063166855319 2:1714347063166855319 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 23:31:03.199627 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1714347063166855319 2:1714347063166855319 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 23:31:03.200199 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:03.200629 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 23:31:03.200913 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:03.201208 drop table if exists "invoice_test"; [] gorptest: 23:31:03.227542 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:03.243536 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:03.259526 drop table if exists "invoice_override_test"; [] gorptest: 23:31:03.275532 drop table if exists "person_test"; [] gorptest: 23:31:03.287547 drop table if exists "ignored_column_test"; [] gorptest: 23:31:03.299263 drop table if exists "id_created_test"; [] gorptest: 23:31:03.319556 drop table if exists "type_conv_test"; [] gorptest: 23:31:03.331541 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:03.343228 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:03.359501 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:03.371512 drop table if exists "time_test"; [] gorptest: 23:31:03.387548 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.42s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues gorptest: 23:31:03.388055 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 23:31:03.403348 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 23:31:03.413012 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 23:31:03.413343 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: 23:31:03.431538 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 23:31:03.431866 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.07s) === RUN TestColumnProps gorptest: 23:31:03.455870 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 23:31:03.471177 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 23:31:03.492484 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 23:31:03.492766 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 23:31:03.492903 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 23:31:03.492998 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.06s) === RUN TestRawSelect 2024/04/28 23:31:03 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: 23:31:03.511917 drop table if exists "invoice_test"; [] gorptest: 23:31:03.512465 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:03.512527 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:03.512586 drop table if exists "invoice_override_test"; [] gorptest: 23:31:03.512643 drop table if exists "person_test"; [] gorptest: 23:31:03.512700 drop table if exists "ignored_column_test"; [] gorptest: 23:31:03.512756 drop table if exists "id_created_test"; [] gorptest: 23:31:03.512813 drop table if exists "type_conv_test"; [] gorptest: 23:31:03.512895 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:03.512955 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:03.513011 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:03.513066 drop table if exists "time_test"; [] gorptest: 23:31:03.513142 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:03.533325 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: 23:31:03.551544 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:03.571559 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:03.583597 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:03.607535 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:03.621945 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:03.639583 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:03.651564 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:03.663556 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:03.679572 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:03.691549 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:03.711672 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347063711557554 2:1714347063711557554 3:"bob" 4:"smith" 5:1] gorptest: 23:31:03.727606 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 23:31:03.743512 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 23:31:03.743843 drop table if exists "invoice_test"; [] gorptest: 23:31:03.759532 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:03.775546 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:03.791540 drop table if exists "invoice_override_test"; [] gorptest: 23:31:03.803575 drop table if exists "person_test"; [] gorptest: 23:31:03.819531 drop table if exists "ignored_column_test"; [] gorptest: 23:31:03.835535 drop table if exists "id_created_test"; [] gorptest: 23:31:03.847517 drop table if exists "type_conv_test"; [] gorptest: 23:31:03.862738 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:03.879573 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:03.895526 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:03.915539 drop table if exists "time_test"; [] gorptest: 23:31:03.931542 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.42s) === RUN TestHooks 2024/04/28 23:31:03 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: 23:31:03.932037 drop table if exists "invoice_test"; [] gorptest: 23:31:03.932539 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:03.932606 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:03.932664 drop table if exists "invoice_override_test"; [] gorptest: 23:31:03.932722 drop table if exists "person_test"; [] gorptest: 23:31:03.932779 drop table if exists "ignored_column_test"; [] gorptest: 23:31:03.932838 drop table if exists "id_created_test"; [] gorptest: 23:31:03.932928 drop table if exists "type_conv_test"; [] gorptest: 23:31:03.932989 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:03.933046 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:03.933106 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:03.933163 drop table if exists "time_test"; [] gorptest: 23:31:03.933241 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:03.951572 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: 23:31:03.967558 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:03.983579 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:03.999561 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:04.015544 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:04.031537 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:04.047563 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:04.063556 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:04.075570 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:04.095584 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:04.115550 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:04.131624 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347064131557295 2:1714347064131557295 3:"bob" 4:"smith" 5:1] gorptest: 23:31:04.147585 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:04.147877 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1714347064131557295 2:1714347064131557295 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 23:31:04.163571 select * from person_test where id = ? [1:1] gorptest: 23:31:04.163900 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 23:31:04.179506 drop table if exists "invoice_test"; [] gorptest: 23:31:04.195519 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:04.235593 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:04.451538 drop table if exists "invoice_override_test"; [] gorptest: 23:31:04.579556 drop table if exists "person_test"; [] gorptest: 23:31:04.595526 drop table if exists "ignored_column_test"; [] gorptest: 23:31:04.611528 drop table if exists "id_created_test"; [] gorptest: 23:31:04.627548 drop table if exists "type_conv_test"; [] gorptest: 23:31:04.643528 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:04.662524 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:04.679474 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:04.699569 drop table if exists "time_test"; [] gorptest: 23:31:04.719547 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.79s) === RUN TestTransaction 2024/04/28 23:31:04 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: 23:31:04.720049 drop table if exists "invoice_test"; [] gorptest: 23:31:04.720526 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:04.720588 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:04.720645 drop table if exists "invoice_override_test"; [] gorptest: 23:31:04.720708 drop table if exists "person_test"; [] gorptest: 23:31:04.720765 drop table if exists "ignored_column_test"; [] gorptest: 23:31:04.720819 drop table if exists "id_created_test"; [] gorptest: 23:31:04.720874 drop table if exists "type_conv_test"; [] gorptest: 23:31:04.720930 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:04.720984 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:04.721039 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:04.721094 drop table if exists "time_test"; [] gorptest: 23:31:04.721169 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:04.743554 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: 23:31:04.763528 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:04.787604 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:04.807620 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:04.827528 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:04.847554 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:04.867548 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:04.887570 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:04.907586 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:04.931590 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:04.951555 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:04.971528 begin; [] gorptest: 23:31:04.973780 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 23:31:04.974265 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 23:31:04.974337 commit; [] gorptest: 23:31:04.995536 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:04.995813 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 23:31:04.995929 drop table if exists "invoice_test"; [] gorptest: 23:31:05.015525 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:05.035699 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:05.055527 drop table if exists "invoice_override_test"; [] gorptest: 23:31:05.079538 drop table if exists "person_test"; [] gorptest: 23:31:05.097194 drop table if exists "ignored_column_test"; [] gorptest: 23:31:05.115548 drop table if exists "id_created_test"; [] gorptest: 23:31:05.135501 drop table if exists "type_conv_test"; [] gorptest: 23:31:05.171536 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:05.189687 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:05.211538 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:05.231527 drop table if exists "time_test"; [] gorptest: 23:31:05.251568 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.53s) === RUN TestSavepoint 2024/04/28 23:31:05 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: 23:31:05.252144 drop table if exists "invoice_test"; [] gorptest: 23:31:05.252591 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:05.252652 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:05.252709 drop table if exists "invoice_override_test"; [] gorptest: 23:31:05.252764 drop table if exists "person_test"; [] gorptest: 23:31:05.252818 drop table if exists "ignored_column_test"; [] gorptest: 23:31:05.252873 drop table if exists "id_created_test"; [] gorptest: 23:31:05.252928 drop table if exists "type_conv_test"; [] gorptest: 23:31:05.252983 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:05.253037 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:05.253092 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:05.253146 drop table if exists "time_test"; [] gorptest: 23:31:05.253219 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:05.267553 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: 23:31:05.287539 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:05.307538 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:05.327593 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:05.351514 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:05.371518 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:05.395560 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:05.405728 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:05.419585 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:05.435443 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:05.448496 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:05.467528 begin; [] gorptest: 23:31:05.467682 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 23:31:05.468078 select memo from invoice_test [] gorptest: 23:31:05.468225 savepoint "foo" [1:] gorptest: 23:31:05.468254 select memo from invoice_test [] gorptest: 23:31:05.468375 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 23:31:05.468450 select memo from invoice_test [] gorptest: 23:31:05.468510 rollback to savepoint "foo" [1:] gorptest: 23:31:05.468542 select memo from invoice_test [] gorptest: 23:31:05.468594 rollback; [] gorptest: 23:31:05.468789 drop table if exists "invoice_test"; [] gorptest: 23:31:05.487548 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:05.503534 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:05.525248 drop table if exists "invoice_override_test"; [] gorptest: 23:31:05.539555 drop table if exists "person_test"; [] gorptest: 23:31:05.552188 drop table if exists "ignored_column_test"; [] gorptest: 23:31:05.567535 drop table if exists "id_created_test"; [] gorptest: 23:31:05.583504 drop table if exists "type_conv_test"; [] gorptest: 23:31:05.600182 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:05.619536 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:05.643533 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:05.659520 drop table if exists "time_test"; [] gorptest: 23:31:05.683509 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.43s) === RUN TestMultiple 2024/04/28 23:31:05 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: 23:31:05.684065 drop table if exists "invoice_test"; [] gorptest: 23:31:05.684581 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:05.684648 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:05.684707 drop table if exists "invoice_override_test"; [] gorptest: 23:31:05.684764 drop table if exists "person_test"; [] gorptest: 23:31:05.684821 drop table if exists "ignored_column_test"; [] gorptest: 23:31:05.684876 drop table if exists "id_created_test"; [] gorptest: 23:31:05.684931 drop table if exists "type_conv_test"; [] gorptest: 23:31:05.684988 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:05.685042 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:05.685100 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:05.685170 drop table if exists "time_test"; [] gorptest: 23:31:05.685249 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:05.699579 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: 23:31:05.719518 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:05.739558 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:05.755130 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:05.771521 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:05.791239 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:05.803452 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:05.823465 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:05.839523 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:05.857411 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:05.867237 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:05.883564 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 23:31:05.895558 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 23:31:05.915577 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 23:31:05.935604 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 23:31:05.951587 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:05.967549 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 23:31:05.987515 drop table if exists "invoice_test"; [] gorptest: 23:31:06.003521 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:06.015512 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:06.035538 drop table if exists "invoice_override_test"; [] gorptest: 23:31:06.056078 drop table if exists "person_test"; [] gorptest: 23:31:06.075531 drop table if exists "ignored_column_test"; [] gorptest: 23:31:06.091503 drop table if exists "id_created_test"; [] gorptest: 23:31:06.103500 drop table if exists "type_conv_test"; [] gorptest: 23:31:06.119550 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:06.139539 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:06.155559 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:06.187515 drop table if exists "time_test"; [] gorptest: 23:31:06.207508 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.52s) === RUN TestCrud 2024/04/28 23:31:06 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: 23:31:06.208013 drop table if exists "invoice_test"; [] gorptest: 23:31:06.208485 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:06.208545 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:06.208602 drop table if exists "invoice_override_test"; [] gorptest: 23:31:06.208658 drop table if exists "person_test"; [] gorptest: 23:31:06.208714 drop table if exists "ignored_column_test"; [] gorptest: 23:31:06.208768 drop table if exists "id_created_test"; [] gorptest: 23:31:06.208822 drop table if exists "type_conv_test"; [] gorptest: 23:31:06.208876 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:06.208930 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:06.208985 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:06.209039 drop table if exists "time_test"; [] gorptest: 23:31:06.209114 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:06.227554 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: 23:31:06.243525 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:06.259550 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:06.275557 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:06.295543 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:06.314350 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:06.325120 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:06.339261 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:06.344832 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:06.355524 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:06.365455 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:06.373615 delete from invoice_test [] gorptest: 23:31:06.387589 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 23:31:06.399555 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:06.399883 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:6927095437957002423 2:4373819442685346493 3:"random 4384023056653835916" 4:0 5:true 6:1] gorptest: 23:31:06.415624 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:06.415896 select * from invoice_test [] gorptest: 23:31:06.416119 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:06.435545 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 23:31:06.435769 delete from invoice_tag_test [] gorptest: 23:31:06.455643 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: 23:31:06.475658 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 23:31:06.475983 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:1413471823911105195 2:1941129812196068841 3:"random 7746672479838314646" 4:33 5:false 6:1] gorptest: 23:31:06.495579 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 23:31:06.495861 select * from invoice_tag_test [] gorptest: 23:31:06.496091 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 23:31:06.515565 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 23:31:06.515797 delete from alias_trans_field_test [] gorptest: 23:31:06.535557 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 23:31:06.555599 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 23:31:06.555876 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 7033161697883872921" 2:1] gorptest: 23:31:06.575567 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 23:31:06.575831 select * from alias_trans_field_test [] gorptest: 23:31:06.575983 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 23:31:06.599577 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 23:31:06.599804 drop table if exists "invoice_test"; [] gorptest: 23:31:06.619578 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:06.639140 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:06.656058 drop table if exists "invoice_override_test"; [] gorptest: 23:31:06.671537 drop table if exists "person_test"; [] gorptest: 23:31:06.695691 drop table if exists "ignored_column_test"; [] gorptest: 23:31:06.715541 drop table if exists "id_created_test"; [] gorptest: 23:31:06.727544 drop table if exists "type_conv_test"; [] gorptest: 23:31:06.747342 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:06.767529 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:06.787120 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:06.799510 drop table if exists "time_test"; [] gorptest: 23:31:06.819513 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.61s) === RUN TestWithIgnoredColumn 2024/04/28 23:31:06 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: 23:31:06.820024 drop table if exists "invoice_test"; [] gorptest: 23:31:06.820492 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:06.820553 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:06.820610 drop table if exists "invoice_override_test"; [] gorptest: 23:31:06.820665 drop table if exists "person_test"; [] gorptest: 23:31:06.820720 drop table if exists "ignored_column_test"; [] gorptest: 23:31:06.820774 drop table if exists "id_created_test"; [] gorptest: 23:31:06.820829 drop table if exists "type_conv_test"; [] gorptest: 23:31:06.820883 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:06.820937 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:06.820992 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:06.821047 drop table if exists "time_test"; [] gorptest: 23:31:06.821120 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:06.843571 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: 23:31:06.863521 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:06.879550 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:06.903570 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:06.924015 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:06.939576 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:06.955568 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:06.971555 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:06.991583 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:07.011557 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:07.031544 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:07.055596 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 23:31:07.075556 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 23:31:07.075876 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 23:31:07.095562 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 23:31:07.095794 drop table if exists "invoice_test"; [] gorptest: 23:31:07.115562 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:07.135569 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:07.155530 drop table if exists "invoice_override_test"; [] gorptest: 23:31:07.179586 drop table if exists "person_test"; [] gorptest: 23:31:07.195603 drop table if exists "ignored_column_test"; [] gorptest: 23:31:07.215544 drop table if exists "id_created_test"; [] gorptest: 23:31:07.235511 drop table if exists "type_conv_test"; [] gorptest: 23:31:07.252935 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:07.275525 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:07.295529 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:07.327341 drop table if exists "time_test"; [] gorptest: 23:31:07.346828 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.53s) === RUN TestTypeConversionExample 2024/04/28 23:31:07 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: 23:31:07.347438 drop table if exists "invoice_test"; [] gorptest: 23:31:07.347995 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:07.348073 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:07.348185 drop table if exists "invoice_override_test"; [] gorptest: 23:31:07.348248 drop table if exists "person_test"; [] gorptest: 23:31:07.348312 drop table if exists "ignored_column_test"; [] gorptest: 23:31:07.348372 drop table if exists "id_created_test"; [] gorptest: 23:31:07.348431 drop table if exists "type_conv_test"; [] gorptest: 23:31:07.348489 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:07.348546 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:07.348607 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:07.348674 drop table if exists "time_test"; [] gorptest: 23:31:07.348751 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:07.393311 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: 23:31:07.423610 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:07.441548 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:07.462668 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:07.495564 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:07.515625 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:07.528371 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:07.559553 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:07.579562 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:07.595587 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:07.611538 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:07.627899 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: 23:31:07.643583 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 23:31:07.643900 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: 23:31:07.659544 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 23:31:07.659871 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 23:31:07.679536 drop table if exists "invoice_test"; [] gorptest: 23:31:07.693714 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:07.711514 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:07.727543 drop table if exists "invoice_override_test"; [] gorptest: 23:31:07.743619 drop table if exists "person_test"; [] gorptest: 23:31:07.756350 drop table if exists "ignored_column_test"; [] gorptest: 23:31:07.776303 drop table if exists "id_created_test"; [] gorptest: 23:31:07.791535 drop table if exists "type_conv_test"; [] gorptest: 23:31:07.807514 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:07.823510 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:07.835584 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:07.860758 drop table if exists "time_test"; [] gorptest: 23:31:07.891524 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.54s) === RUN TestWithEmbeddedStruct 2024/04/28 23:31:07 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: 23:31:07.892090 drop table if exists "invoice_test"; [] gorptest: 23:31:07.892612 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:07.892681 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:07.892740 drop table if exists "invoice_override_test"; [] gorptest: 23:31:07.892798 drop table if exists "person_test"; [] gorptest: 23:31:07.892855 drop table if exists "ignored_column_test"; [] gorptest: 23:31:07.892911 drop table if exists "id_created_test"; [] gorptest: 23:31:07.892976 drop table if exists "type_conv_test"; [] gorptest: 23:31:07.893035 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:07.893091 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:07.893148 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:07.893203 drop table if exists "time_test"; [] gorptest: 23:31:07.893282 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:07.923535 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: 23:31:07.943554 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:07.960442 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:07.984432 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:08.011526 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:08.032360 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:08.053452 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:08.070021 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:08.096364 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:08.119527 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:08.139516 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:08.151593 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 23:31:08.177739 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 23:31:08.178043 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 23:31:08.199500 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 23:31:08.199746 select * from embedded_struct_test [] gorptest: 23:31:08.199902 drop table if exists "invoice_test"; [] gorptest: 23:31:08.223480 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:08.247523 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:08.260943 drop table if exists "invoice_override_test"; [] gorptest: 23:31:08.269118 drop table if exists "person_test"; [] gorptest: 23:31:08.287478 drop table if exists "ignored_column_test"; [] gorptest: 23:31:08.303500 drop table if exists "id_created_test"; [] gorptest: 23:31:08.315487 drop table if exists "type_conv_test"; [] gorptest: 23:31:08.325461 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:08.343556 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:08.355015 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:08.371536 drop table if exists "time_test"; [] gorptest: 23:31:08.391510 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.50s) === RUN TestWithEmbeddedStructBeforeAutoincr 2024/04/28 23:31:08 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: 23:31:08.392005 drop table if exists "invoice_test"; [] gorptest: 23:31:08.392520 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:08.392591 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:08.392649 drop table if exists "invoice_override_test"; [] gorptest: 23:31:08.392707 drop table if exists "person_test"; [] gorptest: 23:31:08.392767 drop table if exists "ignored_column_test"; [] gorptest: 23:31:08.392822 drop table if exists "id_created_test"; [] gorptest: 23:31:08.392876 drop table if exists "type_conv_test"; [] gorptest: 23:31:08.392930 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:08.393001 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:08.393056 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:08.393110 drop table if exists "time_test"; [] gorptest: 23:31:08.393186 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:08.419638 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: 23:31:08.455834 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:08.469961 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:08.480852 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:08.503646 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:08.547667 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:08.571563 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:08.603555 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:08.627581 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:08.655563 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:08.679604 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:08.727600 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 23:31:08.749084 drop table if exists "invoice_test"; [] gorptest: 23:31:08.780486 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:08.803500 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:08.831519 drop table if exists "invoice_override_test"; [] gorptest: 23:31:08.859596 drop table if exists "person_test"; [] gorptest: 23:31:08.880479 drop table if exists "ignored_column_test"; [] gorptest: 23:31:08.923527 drop table if exists "id_created_test"; [] gorptest: 23:31:08.951513 drop table if exists "type_conv_test"; [] gorptest: 23:31:08.975514 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:08.995767 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:09.019530 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:09.060402 drop table if exists "time_test"; [] gorptest: 23:31:09.087526 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.70s) === RUN TestWithEmbeddedAutoincr 2024/04/28 23:31:09 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: 23:31:09.088007 drop table if exists "invoice_test"; [] gorptest: 23:31:09.088525 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:09.088593 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:09.088664 drop table if exists "invoice_override_test"; [] gorptest: 23:31:09.088781 drop table if exists "person_test"; [] gorptest: 23:31:09.088840 drop table if exists "ignored_column_test"; [] gorptest: 23:31:09.088897 drop table if exists "id_created_test"; [] gorptest: 23:31:09.088953 drop table if exists "type_conv_test"; [] gorptest: 23:31:09.089008 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:09.089063 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:09.089118 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:09.089173 drop table if exists "time_test"; [] gorptest: 23:31:09.089250 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:09.115533 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: 23:31:09.133669 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:09.152863 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:09.184089 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:09.207517 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:09.239527 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:09.259266 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:09.323820 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:09.343592 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:09.371575 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:09.399538 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:09.427604 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 23:31:09.451511 drop table if exists "invoice_test"; [] gorptest: 23:31:09.479520 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:09.503517 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:09.531524 drop table if exists "invoice_override_test"; [] gorptest: 23:31:09.555565 drop table if exists "person_test"; [] gorptest: 23:31:09.575531 drop table if exists "ignored_column_test"; [] gorptest: 23:31:09.719533 drop table if exists "id_created_test"; [] gorptest: 23:31:09.973882 drop table if exists "type_conv_test"; [] gorptest: 23:31:10.154827 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:10.367560 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:10.895089 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:11.439532 drop table if exists "time_test"; [] gorptest: 23:31:11.489463 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (2.40s) === RUN TestSelectVal gorptest: 23:31:11.490616 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 23:31:11.523671 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: 23:31:11.536650 select Int64 from TableWithNull where Str='abc' [] gorptest: 23:31:11.536877 select count(*) from TableWithNull [] gorptest: 23:31:11.536974 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 23:31:11.537069 select Int64 from TableWithNull where Str='notfound' [] gorptest: 23:31:11.537153 select Int64 from TableWithNull where Str='abc' [] gorptest: 23:31:11.537239 select Float64 from TableWithNull where Str='abc' [] gorptest: 23:31:11.537324 select min(Float64) from TableWithNull [] gorptest: 23:31:11.537420 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 23:31:11.537512 select Float64 from TableWithNull where Str='notfound' [] gorptest: 23:31:11.537590 select Float64 from TableWithNull where Str='abc' [] gorptest: 23:31:11.537677 select Str from TableWithNull where Int64=? [1:78] gorptest: 23:31:11.537763 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 23:31:11.537845 select Str from TableWithNull where Int64=? [1:78] gorptest: 23:31:11.537932 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 23:31:11.538035 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 23:31:11.538136 select Str from TableWithNull where Int64=? [1:78] gorptest: 23:31:11.538230 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.07s) === RUN TestVersionMultipleRows 2024/04/28 23:31:11 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: 23:31:11.559953 drop table if exists "invoice_test"; [] gorptest: 23:31:11.560508 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:11.560575 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:11.560633 drop table if exists "invoice_override_test"; [] gorptest: 23:31:11.560689 drop table if exists "person_test"; [] gorptest: 23:31:11.560745 drop table if exists "ignored_column_test"; [] gorptest: 23:31:11.560800 drop table if exists "id_created_test"; [] gorptest: 23:31:11.560855 drop table if exists "type_conv_test"; [] gorptest: 23:31:11.560910 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:11.560965 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:11.561021 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:11.561076 drop table if exists "time_test"; [] gorptest: 23:31:11.561153 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:11.594410 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: 23:31:11.627564 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:11.647584 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:11.671618 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:11.696065 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:11.718020 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:11.751570 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:11.774141 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:11.815565 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:11.843616 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:11.863560 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:11.891601 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347071891547332 2:1714347071891547332 3:"Bob" 4:"Smith" 5:1] gorptest: 23:31:11.915542 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347071915500643 2:1714347071915500643 3:"Jane" 4:"Smith" 5:1] gorptest: 23:31:11.942384 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347071942327328 2:1714347071942327328 3:"Mike" 4:"Smith" 5:1] gorptest: 23:31:11.967588 drop table if exists "invoice_test"; [] gorptest: 23:31:11.999525 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:12.031533 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:12.061781 drop table if exists "invoice_override_test"; [] gorptest: 23:31:12.083586 drop table if exists "person_test"; [] gorptest: 23:31:12.099516 drop table if exists "ignored_column_test"; [] gorptest: 23:31:12.111487 drop table if exists "id_created_test"; [] gorptest: 23:31:12.127525 drop table if exists "type_conv_test"; [] gorptest: 23:31:12.143542 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:12.159494 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:12.195546 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:12.231524 drop table if exists "time_test"; [] gorptest: 23:31:12.257787 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.70s) === RUN TestWithStringPk gorptest: 23:31:12.258247 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 23:31:12.287570 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 23:31:12.319568 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.09s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect 2024/04/28 23:31:12 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: 23:31:12.348574 drop table if exists "invoice_test"; [] gorptest: 23:31:12.349155 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:12.349220 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:12.349278 drop table if exists "invoice_override_test"; [] gorptest: 23:31:12.349336 drop table if exists "person_test"; [] gorptest: 23:31:12.349393 drop table if exists "ignored_column_test"; [] gorptest: 23:31:12.349449 drop table if exists "id_created_test"; [] gorptest: 23:31:12.349506 drop table if exists "type_conv_test"; [] gorptest: 23:31:12.349561 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:12.349617 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:12.349674 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:12.349730 drop table if exists "time_test"; [] gorptest: 23:31:12.349816 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:12.382309 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: 23:31:12.423497 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:12.459516 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:12.495507 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:12.527511 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:12.547564 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:12.563537 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:12.583582 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:12.629287 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:12.651602 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:12.667599 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:12.691577 insert into "time_test" ("Id","Time") values (null,?); [1:2024-04-28 23:00:12.691521338 +0000 UTC] gorptest: 23:31:12.711550 insert into "time_test" ("Id","Time") values (null,?); [1:2024-04-28 23:01:13.691521338 +0000 UTC] gorptest: 23:31:12.731542 SELECT id FROM time_test WHERE Time < ? [1:2024-04-28 23:01:12.691521338 +0000 UTC] gorptest: 23:31:12.731802 drop table if exists "invoice_test"; [] gorptest: 23:31:12.751573 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:12.765717 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:12.787530 drop table if exists "invoice_override_test"; [] gorptest: 23:31:12.806745 drop table if exists "person_test"; [] gorptest: 23:31:12.827560 drop table if exists "ignored_column_test"; [] gorptest: 23:31:12.851518 drop table if exists "id_created_test"; [] gorptest: 23:31:12.871542 drop table if exists "type_conv_test"; [] gorptest: 23:31:12.895535 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:12.915536 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:12.931548 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:12.955540 drop table if exists "time_test"; [] gorptest: 23:31:12.975509 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.63s) === RUN TestInvoicePersonView 2024/04/28 23:31:12 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: 23:31:12.975999 drop table if exists "invoice_test"; [] gorptest: 23:31:12.976468 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:12.976529 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:12.976586 drop table if exists "invoice_override_test"; [] gorptest: 23:31:12.976643 drop table if exists "person_test"; [] gorptest: 23:31:12.976698 drop table if exists "ignored_column_test"; [] gorptest: 23:31:12.976762 drop table if exists "id_created_test"; [] gorptest: 23:31:12.976818 drop table if exists "type_conv_test"; [] gorptest: 23:31:12.976873 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:12.976928 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:12.976987 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:12.977042 drop table if exists "time_test"; [] gorptest: 23:31:12.977118 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:12.999553 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: 23:31:13.018624 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:13.043736 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:13.066392 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:13.086804 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:13.107567 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:13.131660 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:13.151606 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:13.171558 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:13.199561 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:13.227540 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:13.247648 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347073247592872 2:1714347073247592872 3:"bob" 4:"smith" 5:1] gorptest: 23:31:13.271622 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 23:31:13.291558 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 23:31:13.291900 drop table if exists "invoice_test"; [] gorptest: 23:31:13.323549 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:13.351563 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:13.367308 drop table if exists "invoice_override_test"; [] gorptest: 23:31:13.391584 drop table if exists "person_test"; [] gorptest: 23:31:13.407524 drop table if exists "ignored_column_test"; [] gorptest: 23:31:13.426317 drop table if exists "id_created_test"; [] gorptest: 23:31:13.447532 drop table if exists "type_conv_test"; [] gorptest: 23:31:13.471640 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:13.491547 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:13.507591 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:13.527543 drop table if exists "time_test"; [] gorptest: 23:31:13.551566 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.58s) === RUN TestQuoteTableNames 2024/04/28 23:31:13 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: 23:31:13.552075 drop table if exists "invoice_test"; [] gorptest: 23:31:13.552640 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:13.552715 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:13.552774 drop table if exists "invoice_override_test"; [] gorptest: 23:31:13.552831 drop table if exists "person_test"; [] gorptest: 23:31:13.552887 drop table if exists "ignored_column_test"; [] gorptest: 23:31:13.552942 drop table if exists "id_created_test"; [] gorptest: 23:31:13.552998 drop table if exists "type_conv_test"; [] gorptest: 23:31:13.553053 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:13.553109 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:13.553165 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:13.553221 drop table if exists "time_test"; [] gorptest: 23:31:13.553295 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:13.566458 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: 23:31:13.576406 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:13.591551 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:13.611568 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:13.639539 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:13.663552 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:13.687566 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:13.715567 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:13.739578 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:13.767325 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:13.791602 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.52s) === RUN TestSelectTooManyCols 2024/04/28 23:31:14 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 23:31:14.076086 drop table if exists "invoice_test"; [] gorptest: 23:31:14.076595 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:14.076659 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:14.076716 drop table if exists "invoice_override_test"; [] gorptest: 23:31:14.076773 drop table if exists "person_test"; [] gorptest: 23:31:14.076828 drop table if exists "ignored_column_test"; [] gorptest: 23:31:14.076883 drop table if exists "id_created_test"; [] gorptest: 23:31:14.076938 drop table if exists "type_conv_test"; [] gorptest: 23:31:14.076994 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:14.077048 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:14.077103 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:14.077158 drop table if exists "time_test"; [] gorptest: 23:31:14.077233 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:14.099599 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: 23:31:14.113748 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:14.131572 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:14.151545 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:14.167536 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:14.187533 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:14.207553 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:14.227547 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:14.247583 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:14.267534 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:14.287534 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:14.303044 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347074302992324 2:1714347074302992324 3:"bob" 4:"smith" 5:1] gorptest: 23:31:14.319555 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347074319515911 2:1714347074319515911 3:"jane" 4:"doe" 5:1] gorptest: 23:31:14.335555 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:14.335809 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 23:31:14.335952 select * from person_test where Id=? [1:1] gorptest: 23:31:14.336099 select * from person_test order by fname asc [] gorptest: 23:31:14.336318 drop table if exists "invoice_test"; [] gorptest: 23:31:14.359492 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:14.375546 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:14.391552 drop table if exists "invoice_override_test"; [] gorptest: 23:31:14.419545 drop table if exists "person_test"; [] gorptest: 23:31:14.439547 drop table if exists "ignored_column_test"; [] gorptest: 23:31:14.455519 drop table if exists "id_created_test"; [] gorptest: 23:31:14.471521 drop table if exists "type_conv_test"; [] gorptest: 23:31:14.483518 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:14.503536 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:14.519509 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:14.529853 drop table if exists "time_test"; [] gorptest: 23:31:14.535093 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.46s) === RUN TestSelectSingleVal 2024/04/28 23:31:14 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 23:31:14.535608 drop table if exists "invoice_test"; [] gorptest: 23:31:14.536084 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:14.536218 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:14.536299 drop table if exists "invoice_override_test"; [] gorptest: 23:31:14.536356 drop table if exists "person_test"; [] gorptest: 23:31:14.536412 drop table if exists "ignored_column_test"; [] gorptest: 23:31:14.536467 drop table if exists "id_created_test"; [] gorptest: 23:31:14.536522 drop table if exists "type_conv_test"; [] gorptest: 23:31:14.536577 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:14.536631 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:14.536686 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:14.536742 drop table if exists "time_test"; [] gorptest: 23:31:14.536817 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:14.555555 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: 23:31:14.568558 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:14.577298 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:14.587325 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:14.603328 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:14.616580 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:14.626801 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:14.647550 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:14.663648 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:14.683556 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:14.703537 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:14.727591 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347074727540576 2:1714347074727540576 3:"bob" 4:"smith" 5:1] gorptest: 23:31:14.754779 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 23:31:14.755062 select * from person_test where Id=? [1:1] gorptest: 23:31:14.755294 select FName from person_test where Id=? [1:1] gorptest: 23:31:14.755406 select * from person_test where Id=? [1:1] gorptest: 23:31:14.755602 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 23:31:14.755742 select * from person_test where Id=? [1:-2222] gorptest: 23:31:14.755883 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1714347074755859525 2:1714347074755859525 3:"bob" 4:"smith" 5:1] gorptest: 23:31:14.779531 select * from person_test where Fname='bob' [] gorptest: 23:31:14.779912 select * from person_test where Id=-123 [] gorptest: 23:31:14.780015 select * from person_test where Id=-123 [] gorptest: 23:31:14.780101 select * from person_test where Id=-123 [] gorptest: 23:31:14.780226 select * from person_test where Id=-123 [] gorptest: 23:31:14.780329 drop table if exists "invoice_test"; [] gorptest: 23:31:14.807526 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:14.827524 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:14.852245 drop table if exists "invoice_override_test"; [] gorptest: 23:31:14.875615 drop table if exists "person_test"; [] gorptest: 23:31:14.893801 drop table if exists "ignored_column_test"; [] gorptest: 23:31:14.904785 drop table if exists "id_created_test"; [] gorptest: 23:31:14.919552 drop table if exists "type_conv_test"; [] gorptest: 23:31:14.946704 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:14.963585 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:14.987331 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:15.011563 drop table if exists "time_test"; [] gorptest: 23:31:15.031554 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.50s) === RUN TestSelectAlias 2024/04/28 23:31:15 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: 23:31:15.032062 drop table if exists "invoice_test"; [] gorptest: 23:31:15.032572 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:15.032635 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:15.032691 drop table if exists "invoice_override_test"; [] gorptest: 23:31:15.032748 drop table if exists "person_test"; [] gorptest: 23:31:15.032803 drop table if exists "ignored_column_test"; [] gorptest: 23:31:15.032858 drop table if exists "id_created_test"; [] gorptest: 23:31:15.032912 drop table if exists "type_conv_test"; [] gorptest: 23:31:15.032967 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:15.033022 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:15.033077 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:15.033132 drop table if exists "time_test"; [] gorptest: 23:31:15.033206 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:15.055570 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: 23:31:15.083544 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:15.106963 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:15.119549 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:15.139543 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:15.159544 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:15.179560 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:15.199572 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:15.219565 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:15.239549 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:15.259556 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:15.279576 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 23:31:15.299534 select * from id_created_test where Id=1 [] gorptest: 23:31:15.299803 SELECT *, 1 AS external FROM id_created_test [] gorptest: 23:31:15.299967 drop table if exists "invoice_test"; [] gorptest: 23:31:15.319535 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:15.335531 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:15.359564 drop table if exists "invoice_override_test"; [] gorptest: 23:31:15.387529 drop table if exists "person_test"; [] gorptest: 23:31:15.411523 drop table if exists "ignored_column_test"; [] gorptest: 23:31:15.439523 drop table if exists "id_created_test"; [] gorptest: 23:31:15.471529 drop table if exists "type_conv_test"; [] gorptest: 23:31:15.491543 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:15.511541 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:15.531587 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:15.551530 drop table if exists "time_test"; [] gorptest: 23:31:15.579553 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.55s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange 2024/04/28 23:31:15 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: 23:31:15.580113 drop table if exists "invoice_test"; [] gorptest: 23:31:15.580609 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:15.580671 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:15.580749 drop table if exists "invoice_override_test"; [] gorptest: 23:31:15.580807 drop table if exists "person_test"; [] gorptest: 23:31:15.580863 drop table if exists "ignored_column_test"; [] gorptest: 23:31:15.580917 drop table if exists "id_created_test"; [] gorptest: 23:31:15.580972 drop table if exists "type_conv_test"; [] gorptest: 23:31:15.581026 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:15.581081 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:15.581136 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:15.581192 drop table if exists "time_test"; [] gorptest: 23:31:15.581271 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:15.603573 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: 23:31:15.631566 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:15.651598 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:15.671576 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:15.691549 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:15.711556 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:15.731552 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:15.751525 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:15.771551 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:15.791566 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:15.811523 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:15.839569 drop table if exists "invoice_test"; [] gorptest: 23:31:15.867544 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:15.895562 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:15.911542 drop table if exists "invoice_override_test"; [] gorptest: 23:31:15.939591 drop table if exists "person_test"; [] gorptest: 23:31:15.971606 drop table if exists "ignored_column_test"; [] gorptest: 23:31:15.991552 drop table if exists "id_created_test"; [] gorptest: 23:31:16.011547 drop table if exists "type_conv_test"; [] gorptest: 23:31:16.031563 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:16.059526 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:16.079566 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:16.099535 drop table if exists "time_test"; [] gorptest: 23:31:16.127523 drop table if exists "id_created_test"; [] gorptest: 23:31:16.127676 drop table if exists "single_column_table"; [] gorptest: 23:31:16.127764 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: 23:31:16.160414 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: 23:31:16.179566 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:16.199563 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: 23:31:16.219565 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: 23:31:16.251547 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:16.271550 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:16.291552 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:16.311564 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:16.331537 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:16.351537 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: 23:31:16.367522 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:16.399538 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 23:31:16.399701 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 23:31:16.415590 delete from "invoice_test"; [] gorptest: 23:31:16.431510 delete from "invoice_tag_test"; [] gorptest: 23:31:16.447516 delete from "alias_trans_field_test"; [] gorptest: 23:31:16.463539 delete from "invoice_override_test"; [] gorptest: 23:31:16.479580 delete from "person_test"; [] gorptest: 23:31:16.486267 delete from "ignored_column_test"; [] gorptest: 23:31:16.519524 delete from "id_created_test"; [] gorptest: 23:31:16.535517 delete from "type_conv_test"; [] gorptest: 23:31:16.551569 delete from "embedded_struct_test"; [] gorptest: 23:31:16.574298 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:16.591584 delete from "embedded_autoincr_test"; [] gorptest: 23:31:16.611533 delete from "time_test"; [] gorptest: 23:31:16.631517 delete from "id_created_test"; [] gorptest: 23:31:16.655531 delete from "single_column_table"; [] gorptest: 23:31:16.678510 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 23:31:16.678792 drop table if exists "invoice_test"; [] gorptest: 23:31:16.684798 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:16.711535 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:16.731555 drop table if exists "invoice_override_test"; [] gorptest: 23:31:16.747588 drop table if exists "person_test"; [] gorptest: 23:31:16.767556 drop table if exists "ignored_column_test"; [] gorptest: 23:31:16.783080 drop table if exists "id_created_test"; [] gorptest: 23:31:16.799553 drop table if exists "type_conv_test"; [] gorptest: 23:31:16.811531 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:16.831567 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:16.847568 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:16.863553 drop table if exists "time_test"; [] gorptest: 23:31:16.879543 drop table if exists "id_created_test"; [] gorptest: 23:31:16.879699 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (1.32s) === RUN TestPrepare 2024/04/28 23:31:16 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: 23:31:16.896022 drop table if exists "invoice_test"; [] gorptest: 23:31:16.896582 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:16.896649 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:16.896707 drop table if exists "invoice_override_test"; [] gorptest: 23:31:16.896763 drop table if exists "person_test"; [] gorptest: 23:31:16.896818 drop table if exists "ignored_column_test"; [] gorptest: 23:31:16.896875 drop table if exists "id_created_test"; [] gorptest: 23:31:16.896930 drop table if exists "type_conv_test"; [] gorptest: 23:31:16.896984 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:16.897039 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:16.897104 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:16.897160 drop table if exists "time_test"; [] gorptest: 23:31:16.897237 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:16.911557 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: 23:31:16.931572 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 23:31:16.947546 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 23:31:16.963570 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 23:31:16.983567 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:16.999549 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 23:31:17.015574 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 23:31:17.035593 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 23:31:17.059557 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 23:31:17.079556 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 23:31:17.103547 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 23:31:17.127590 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 23:31:17.147563 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 23:31:17.167526 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 23:31:17.183502 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 23:31:17.183839 begin; [] gorptest: 23:31:17.183913 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 23:31:17.184272 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 23:31:17.185002 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 23:31:17.185173 commit; [] gorptest: 23:31:17.203532 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 23:31:17.203917 drop table if exists "invoice_test"; [] gorptest: 23:31:17.227070 drop table if exists "invoice_tag_test"; [] gorptest: 23:31:17.236671 drop table if exists "alias_trans_field_test"; [] gorptest: 23:31:17.255542 drop table if exists "invoice_override_test"; [] gorptest: 23:31:17.271527 drop table if exists "person_test"; [] gorptest: 23:31:17.286606 drop table if exists "ignored_column_test"; [] gorptest: 23:31:17.299570 drop table if exists "id_created_test"; [] gorptest: 23:31:17.319532 drop table if exists "type_conv_test"; [] gorptest: 23:31:17.335520 drop table if exists "embedded_struct_test"; [] gorptest: 23:31:17.383568 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 23:31:17.404659 drop table if exists "embedded_autoincr_test"; [] gorptest: 23:31:17.415549 drop table if exists "time_test"; [] gorptest: 23:31:17.431622 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.54s) PASS ok gopkg.in/gorp.v1 16.616s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang dh_auto_install --destdir=debian/golang-gopkg-gorp.v1-dev/ -O--builddirectory=_build -O--buildsystem=golang dh_installdocs -O--builddirectory=_build -O--buildsystem=golang dh_installchangelogs -O--builddirectory=_build -O--buildsystem=golang dh_installinit -O--builddirectory=_build -O--buildsystem=golang dh_installsystemduser -O--builddirectory=_build -O--buildsystem=golang dh_perl -O--builddirectory=_build -O--buildsystem=golang dh_link -O--builddirectory=_build -O--buildsystem=golang dh_strip_nondeterminism -O--builddirectory=_build -O--buildsystem=golang dh_compress -O--builddirectory=_build -O--buildsystem=golang dh_fixperms -O--builddirectory=_build -O--buildsystem=golang dh_missing -O--builddirectory=_build -O--buildsystem=golang dh_installdeb -O--builddirectory=_build -O--buildsystem=golang dh_golang -O--builddirectory=_build -O--buildsystem=golang dh_gencontrol -O--builddirectory=_build -O--buildsystem=golang dh_md5sums -O--builddirectory=_build -O--buildsystem=golang dh_builddeb -O--builddirectory=_build -O--buildsystem=golang dpkg-deb: building package 'golang-gopkg-gorp.v1-dev' in '../golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb'. dpkg-genbuildinfo --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo dpkg-genchanges --build=binary -O../golang-gopkg-gorp.v1_1.7.2-2_armhf.changes dpkg-genchanges: info: binary-only upload (no source code included) dpkg-source --after-build . dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration I: 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/17262 and its subdirectories I: Current time: Sun Apr 28 11:31:36 -12 2024 I: pbuilder-time-stamp: 1714347096 Sun Apr 28 23:31:45 UTC 2024 I: 1st build successful. Starting 2nd build on remote node ff64a-armhf-rb.debian.net. Sun Apr 28 23:31:45 UTC 2024 I: Preparing to do remote build '2' on ff64a-armhf-rb.debian.net. Sun Apr 28 23:37:34 UTC 2024 I: Deleting $TMPDIR on ff64a-armhf-rb.debian.net. Sun Apr 28 23:37:37 UTC 2024 I: golang-gopkg-gorp.v1_1.7.2-2_armhf.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 319ba9a922d27b539c60f0699c9bd19ffe62687b 6118 golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Checksums-Sha256: 1cc14b610fb7fb5bcdb0a0a503ea5cc9153298178a2fcea913ece8baab171aac 27848 golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 553c0da86f96a7eca355dabb3aa1abb1e0a17da169c42ae59165d5b839501b9a 6118 golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Files: ab68ec51d63d2eb7e26ed829b5ba2838 27848 devel optional golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb 66fc9e47385226dae4240722d79fc1a2 6118 devel optional golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo Sun Apr 28 23:37:38 UTC 2024 I: diffoscope 265 will be used to compare the two builds: Running as unit: rb-diffoscope-armhf_14-3533.service # Profiling output for: /usr/bin/diffoscope --timeout 7200 --html /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.html --text /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.txt --json /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/golang-gopkg-gorp.v1_1.7.2-2.diffoscope.json --profile=- /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.changes /srv/reproducible-results/rbuild-debian/r-b-build.a86kW5fl/b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.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.323s) 0.323s 2 calls outputs 0.000s 1 call cleanup ## recognizes (total time: 0.014s) 0.014s 12 calls diffoscope.comparators.binary.FilesystemFile ## specialize (total time: 0.000s) 0.000s 1 call specialize Finished with result: success Main processes terminated with: code=exited/status=0 Service runtime: 629ms CPU time consumed: 630ms Sun Apr 28 23:37:39 UTC 2024 I: diffoscope 265 found no differences in the changes files, and a .buildinfo file also exists. Sun Apr 28 23:37:39 UTC 2024 I: golang-gopkg-gorp.v1 from trixie built successfully and reproducibly on armhf. Sun Apr 28 23:37:40 UTC 2024 I: Submitting .buildinfo files to external archives: Sun Apr 28 23:37:40 UTC 2024 I: Submitting 8.0K b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc Sun Apr 28 23:37:42 UTC 2024 I: Submitting 8.0K b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc Sun Apr 28 23:37:43 UTC 2024 I: Done submitting .buildinfo files to http://buildinfo.debian.net/api/submit. Sun Apr 28 23:37:43 UTC 2024 I: Done submitting .buildinfo files. Sun Apr 28 23:37:43 UTC 2024 I: Removing signed golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc files: removed './b1/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc' removed './b2/golang-gopkg-gorp.v1_1.7.2-2_armhf.buildinfo.asc'