Input buildinfo: https://buildinfos.debian.net/buildinfo-pool/g/golang-gopkg-gorp.v1/golang-gopkg-gorp.v1_1.7.2-2_all.buildinfo
Use metasnap for getting required timestamps
New buildinfo file: /tmp/golang-gopkg-gorp.v1-1.7.2-2sucufzwm/golang-gopkg-gorp.v1_1.7.2-2_all.buildinfo
Get source package info: golang-gopkg-gorp.v1=1.7.2-2
Source URL: http://snapshot.notset.fr/mr/package/golang-gopkg-gorp.v1/1.7.2-2/srcfiles?fileinfo=1
env -i PATH=/usr/sbin:/usr/bin:/sbin:/bin TMPDIR=/tmp mmdebstrap --arch=amd64 --include=autoconf=2.69-11.1 automake=1:1.16.2-1 autopoint=0.19.8.1-10 autotools-dev=20180224.1 base-files=11 base-passwd=3.5.47 bash=5.0-6 binutils=2.34-6 binutils-common=2.34-6 binutils-x86-64-linux-gnu=2.34-6 bsdmainutils=11.1.2+b1 bsdutils=1:2.34-0.1 build-essential=12.8 bzip2=1.0.8-2 coreutils=8.30-3+b1 cpp=4:9.2.1-3.1 cpp-9=9.3.0-10 dash=0.5.10.2-7 debconf=1.5.73 debhelper=13 debianutils=4.9.1 dh-autoreconf=19 dh-golang=1.48 dh-strip-nondeterminism=1.8.0-1 diffutils=1:3.7-3 dpkg=1.19.7 dpkg-dev=1.19.7 dwz=0.13-5 fdisk=2.34-0.1 file=1:5.38-4 findutils=4.7.0-1 g++=4:9.2.1-3.1 g++-9=9.3.0-10 gcc=4:9.2.1-3.1 gcc-10-base=10-20200411-1 gcc-9=9.3.0-10 gcc-9-base=9.3.0-10 gettext=0.19.8.1-10 gettext-base=0.19.8.1-10 golang-1.14-go=1.14.2-1 golang-1.14-src=1.14.2-1 golang-any=2:1.14~1 golang-github-go-sql-driver-mysql-dev=1.4.1-1 golang-github-lib-pq-dev=1.3.0-1 golang-github-mattn-go-sqlite3-dev=1.6.0~ds1-2 golang-github-ziutek-mymysql-dev=1.5.4+git20170206.23.0582bcf-2 golang-go=2:1.14~1 golang-golang-x-net-dev=1:0.0+git20200226.491c5fc+dfsg-1 golang-golang-x-sys-dev=0.0~git20200219.cb0a6d8-1 golang-golang-x-text-dev=0.3.2-4 golang-pq-dev=1.3.0-1 golang-src=2:1.14~1 grep=3.4-1 groff-base=1.22.4-4 gzip=1.10-2 hostname=3.23 init-system-helpers=1.57 intltool-debian=0.35.0+20060710.5 libacl1=2.2.53-6 libarchive-zip-perl=1.68-1 libasan5=9.3.0-10 libatomic1=10-20200411-1 libattr1=1:2.4.48-5 libaudit-common=1:2.8.5-3 libaudit1=1:2.8.5-3+b1 libbinutils=2.34-6 libblkid1=2.34-0.1 libbsd0=0.10.0-1 libbz2-1.0=1.0.8-2 libc-bin=2.30-4 libc-dev-bin=2.30-4 libc6=2.30-4 libc6-dev=2.30-4 libcap-ng0=0.7.9-2.1+b2 libcc1-0=10-20200411-1 libcroco3=0.6.13-1 libcrypt-dev=1:4.4.16-1 libcrypt1=1:4.4.16-1 libctf-nobfd0=2.34-6 libctf0=2.34-6 libdb5.3=5.3.28+dfsg1-0.6 libdebconfclient0=0.251 libdebhelper-perl=13 libdpkg-perl=1.19.7 libelf1=0.176-1.1 libfdisk1=2.34-0.1 libffi7=3.3-4 libfile-stripnondeterminism-perl=1.8.0-1 libgcc-9-dev=9.3.0-10 libgcc-s1=10-20200411-1 libgcrypt20=1.8.5-5 libgdbm-compat4=1.18.1-5 libgdbm6=1.18.1-5 libglib2.0-0=2.64.2-1 libgmp10=2:6.2.0+dfsg-4 libgomp1=10-20200411-1 libgpg-error0=1.37-1 libicu63=63.2-3 libisl22=0.22.1-1 libitm1=10-20200411-1 liblsan0=10-20200411-1 liblz4-1=1.9.2-2 liblzma5=5.2.4-1+b1 libmagic-mgc=1:5.38-4 libmagic1=1:5.38-4 libmount1=2.34-0.1 libmpc3=1.1.0-1 libmpfr6=4.0.2-1 libncursesw6=6.2-1 libpam-modules=1.3.1-5 libpam-modules-bin=1.3.1-5 libpam-runtime=1.3.1-5 libpam0g=1.3.1-5 libpcre2-8-0=10.34-7 libpcre3=2:8.39-12+b1 libperl5.30=5.30.0-9 libpipeline1=1.5.2-2 libquadmath0=10-20200411-1 libseccomp2=2.4.3-1+b1 libselinux1=3.0-1+b3 libsigsegv2=2.12-2 libsmartcols1=2.34-0.1 libsqlite3-0=3.31.1-5 libsqlite3-dev=3.31.1-5 libstdc++-9-dev=9.3.0-10 libstdc++6=10-20200411-1 libsub-override-perl=0.09-2 libsystemd0=245.4-4 libtinfo6=6.2-1 libtool=2.4.6-14 libtsan0=10-20200411-1 libubsan1=10-20200411-1 libuchardet0=0.0.6-3 libudev1=245.4-4 libunistring2=0.9.10-2 libuuid1=2.34-0.1 libxml2=2.9.10+dfsg-5 linux-libc-dev=5.5.13-2 login=1:4.8.1-1 lsb-base=11.1.0 m4=1.4.18-4 make=4.2.1-1.2 man-db=2.9.1-1 mawk=1.3.4.20200120-2 ncurses-base=6.2-1 ncurses-bin=6.2-1 patch=2.7.6-6 perl=5.30.0-9 perl-base=5.30.0-9 perl-modules-5.30=5.30.0-9 po-debconf=1.0.21 sed=4.7-1 sensible-utils=0.0.12+nmu1 sysvinit-utils=2.96-3 tar=1.30+dfsg-7 util-linux=2.34-0.1 xz-utils=5.2.4-1+b1 zlib1g=1:1.2.11.dfsg-2 --variant=apt --aptopt=Acquire::Check-Valid-Until "false" --aptopt=Acquire::http::Dl-Limit "1000"; --aptopt=Acquire::https::Dl-Limit "1000"; --aptopt=Acquire::Retries "5"; --aptopt=APT::Get::allow-downgrades "true"; --keyring=/usr/share/keyrings/ --essential-hook=chroot "$1" sh -c "apt-get --yes install fakeroot util-linux" --essential-hook=copy-in /usr/share/keyrings/debian-archive-bullseye-automatic.gpg /usr/share/keyrings/debian-archive-bullseye-security-automatic.gpg /usr/share/keyrings/debian-archive-bullseye-stable.gpg /usr/share/keyrings/debian-archive-buster-automatic.gpg /usr/share/keyrings/debian-archive-buster-security-automatic.gpg /usr/share/keyrings/debian-archive-buster-stable.gpg /usr/share/keyrings/debian-archive-keyring.gpg /usr/share/keyrings/debian-archive-removed-keys.gpg /usr/share/keyrings/debian-archive-stretch-automatic.gpg /usr/share/keyrings/debian-archive-stretch-security-automatic.gpg /usr/share/keyrings/debian-archive-stretch-stable.gpg /usr/share/keyrings/debian-ports-archive-keyring-removed.gpg /usr/share/keyrings/debian-ports-archive-keyring.gpg /usr/share/keyrings/debian-keyring.gpg /etc/apt/trusted.gpg.d/ --essential-hook=chroot "$1" sh -c "rm /etc/apt/sources.list && echo 'deb http://snapshot.notset.fr/archive/debian/20210814T212851Z/ bookworm main
deb-src http://snapshot.notset.fr/archive/debian/20210814T212851Z/ bookworm main
deb http://snapshot.notset.fr/archive/debian/20200526T084721Z/ unstable main
deb http://snapshot.notset.fr/archive/debian/20200417T040322Z/ unstable main' >> /etc/apt/sources.list && apt-get update" --customize-hook=chroot "$1" useradd --no-create-home -d /nonexistent -p "" builduser -s /bin/bash --customize-hook=chroot "$1" env sh -c "apt-get source --only-source -d golang-gopkg-gorp.v1=1.7.2-2 && mkdir -p /build/golang-gopkg-gorp.v1-sH6GIP && dpkg-source --no-check -x /*.dsc /build/golang-gopkg-gorp.v1-sH6GIP/golang-gopkg-gorp.v1-1.7.2 && chown -R builduser:builduser /build/golang-gopkg-gorp.v1-sH6GIP" --customize-hook=chroot "$1" env --unset=TMPDIR runuser builduser -c "cd /build/golang-gopkg-gorp.v1-sH6GIP/golang-gopkg-gorp.v1-1.7.2 && env DEB_BUILD_OPTIONS="parallel=4" LANG="C.UTF-8" LC_ALL="C.UTF-8" SOURCE_DATE_EPOCH="1587308187" dpkg-buildpackage -uc -a amd64 --build=all" --customize-hook=sync-out /build/golang-gopkg-gorp.v1-sH6GIP /tmp/golang-gopkg-gorp.v1-1.7.2-2sucufzwm bullseye /dev/null deb http://snapshot.notset.fr/archive/debian/20200417T040322Z unstable main
I: automatically chosen mode: root
I: chroot architecture amd64 is equal to the host's architecture
I: automatically chosen format: tar
I: using /tmp/mmdebstrap.t3NYWIa_4k as tempdir
I: running apt-get update...
I: downloading packages with apt...
I: extracting archives...
I: installing essential packages...
I: running --essential-hook in shell: sh -c 'chroot "$1" sh -c "apt-get --yes install fakeroot util-linux"' exec /tmp/mmdebstrap.t3NYWIa_4k
Reading package lists...
Building dependency tree...
util-linux is already the newest version (2.34-0.1).
The following NEW packages will be installed:
  fakeroot libfakeroot
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 132 kB of archives.
After this operation, 393 kB of additional disk space will be used.
Get:1 http://snapshot.notset.fr/archive/debian/20200417T040322Z unstable/main amd64 libfakeroot amd64 1.24-1 [45.7 kB]
Get:2 http://snapshot.notset.fr/archive/debian/20200417T040322Z unstable/main amd64 fakeroot amd64 1.24-1 [85.9 kB]
debconf: delaying package configuration, since apt-utils is not installed
Fetched 132 kB in 0s (937 kB/s)
Selecting previously unselected package libfakeroot:amd64.
(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 ... 4504 files and directories currently installed.)
Preparing to unpack .../libfakeroot_1.24-1_amd64.deb ...
Unpacking libfakeroot:amd64 (1.24-1) ...
Selecting previously unselected package fakeroot.
Preparing to unpack .../fakeroot_1.24-1_amd64.deb ...
Unpacking fakeroot (1.24-1) ...
Setting up libfakeroot:amd64 (1.24-1) ...
Setting up fakeroot (1.24-1) ...
update-alternatives: using /usr/bin/fakeroot-sysv to provide /usr/bin/fakeroot (fakeroot) in auto mode
Processing triggers for libc-bin (2.30-4) ...
I: running special hook: copy-in /usr/share/keyrings/debian-archive-bullseye-automatic.gpg /usr/share/keyrings/debian-archive-bullseye-security-automatic.gpg /usr/share/keyrings/debian-archive-bullseye-stable.gpg /usr/share/keyrings/debian-archive-buster-automatic.gpg /usr/share/keyrings/debian-archive-buster-security-automatic.gpg /usr/share/keyrings/debian-archive-buster-stable.gpg /usr/share/keyrings/debian-archive-keyring.gpg /usr/share/keyrings/debian-archive-removed-keys.gpg /usr/share/keyrings/debian-archive-stretch-automatic.gpg /usr/share/keyrings/debian-archive-stretch-security-automatic.gpg /usr/share/keyrings/debian-archive-stretch-stable.gpg /usr/share/keyrings/debian-ports-archive-keyring-removed.gpg /usr/share/keyrings/debian-ports-archive-keyring.gpg /usr/share/keyrings/debian-keyring.gpg /etc/apt/trusted.gpg.d/
I: running --essential-hook in shell: sh -c 'chroot "$1" sh -c "rm /etc/apt/sources.list && echo 'deb http://snapshot.notset.fr/archive/debian/20210814T212851Z/ bookworm main
deb-src http://snapshot.notset.fr/archive/debian/20210814T212851Z/ bookworm main
deb http://snapshot.notset.fr/archive/debian/20200526T084721Z/ unstable main
deb http://snapshot.notset.fr/archive/debian/20200417T040322Z/ unstable main' >> /etc/apt/sources.list && apt-get update"' exec /tmp/mmdebstrap.t3NYWIa_4k
Get:1 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm InRelease [81.6 kB]
Get:2 http://snapshot.notset.fr/archive/debian/20200526T084721Z unstable InRelease [146 kB]
Hit:3 http://snapshot.notset.fr/archive/debian/20200417T040322Z unstable InRelease
Ign:4 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main Sources
Ign:5 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main amd64 Packages
Ign:4 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main Sources
Ign:5 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main amd64 Packages
Ign:4 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main Sources
Ign:5 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main amd64 Packages
Get:4 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main Sources [11.4 MB]
Get:5 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main amd64 Packages [11.1 MB]
Ign:6 http://snapshot.notset.fr/archive/debian/20200526T084721Z unstable/main amd64 Packages
Ign:6 http://snapshot.notset.fr/archive/debian/20200526T084721Z unstable/main amd64 Packages
Ign:6 http://snapshot.notset.fr/archive/debian/20200526T084721Z unstable/main amd64 Packages
Get:6 http://snapshot.notset.fr/archive/debian/20200526T084721Z unstable/main amd64 Packages [11.2 MB]
Fetched 33.9 MB in 28s (1205 kB/s)
Reading package lists...
I: installing remaining packages inside the chroot...
I: running --customize-hook in shell: sh -c 'chroot "$1" useradd --no-create-home -d /nonexistent -p "" builduser -s /bin/bash' exec /tmp/mmdebstrap.t3NYWIa_4k
I: running --customize-hook in shell: sh -c 'chroot "$1" env sh -c "apt-get source --only-source -d golang-gopkg-gorp.v1=1.7.2-2 && mkdir -p /build/golang-gopkg-gorp.v1-sH6GIP && dpkg-source --no-check -x /*.dsc /build/golang-gopkg-gorp.v1-sH6GIP/golang-gopkg-gorp.v1-1.7.2 && chown -R builduser:builduser /build/golang-gopkg-gorp.v1-sH6GIP"' exec /tmp/mmdebstrap.t3NYWIa_4k
Reading package lists...
NOTICE: 'golang-gopkg-gorp.v1' packaging is maintained in the 'Git' version control system at:
https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1.git
Please use:
git clone https://salsa.debian.org/go-team/packages/golang-gopkg-gorp.v1.git
to retrieve the latest (possibly unreleased) updates to the package.
Need to get 37.5 kB of source archives.
Get:1 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main golang-gopkg-gorp.v1 1.7.2-2 (dsc) [2257 B]
Get:2 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main golang-gopkg-gorp.v1 1.7.2-2 (tar) [32.6 kB]
Get:3 http://snapshot.notset.fr/archive/debian/20210814T212851Z bookworm/main golang-gopkg-gorp.v1 1.7.2-2 (diff) [2688 B]
Fetched 37.5 kB in 0s (600 kB/s)
Download complete and in download only mode
W: Download is performed unsandboxed as root as file 'golang-gopkg-gorp.v1_1.7.2-2.dsc' couldn't be accessed by user '_apt'. - pkgAcquire::Run (13: Permission denied)
dpkg-source: info: extracting golang-gopkg-gorp.v1 in /build/golang-gopkg-gorp.v1-sH6GIP/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: running --customize-hook in shell: sh -c 'chroot "$1" env --unset=TMPDIR runuser builduser -c "cd /build/golang-gopkg-gorp.v1-sH6GIP/golang-gopkg-gorp.v1-1.7.2 && env DEB_BUILD_OPTIONS="parallel=4" LANG="C.UTF-8" LC_ALL="C.UTF-8" SOURCE_DATE_EPOCH="1587308187" dpkg-buildpackage -uc -a amd64 --build=all"' exec /tmp/mmdebstrap.t3NYWIa_4k
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 <praveen@debian.org>
 dpkg-source --before-build .
 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-indep
dh binary-indep --builddirectory=_build --buildsystem=golang --with=golang
   dh_update_autotools_config -i -O--builddirectory=_build -O--buildsystem=golang
   dh_autoreconf -i -O--builddirectory=_build -O--buildsystem=golang
   dh_auto_configure -i -O--builddirectory=_build -O--buildsystem=golang
   dh_auto_build -i -O--builddirectory=_build -O--buildsystem=golang
	cd _build && go install -trimpath -v -p 4 gopkg.in/gorp.v1
internal/race
runtime/internal/sys
internal/cpu
runtime/internal/atomic
sync/atomic
runtime/internal/math
unicode
unicode/utf8
internal/bytealg
math/bits
internal/testlog
math
runtime
internal/reflectlite
sync
errors
sort
internal/oserror
io
strconv
syscall
bytes
strings
reflect
regexp/syntax
internal/syscall/unix
time
internal/syscall/execenv
regexp
context
internal/poll
internal/fmtsort
os
fmt
database/sql/driver
log
database/sql
gopkg.in/gorp.v1
   dh_auto_test -i -O--builddirectory=_build -O--buildsystem=golang
	cd _build && go test -vet=off -v -p 4 gopkg.in/gorp.v1
=== RUN   TestCreateTablesIfNotExists
2021/10/08 16:58:54 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: 16:58:54.689801 drop table if exists "invoice_test"; []
gorptest: 16:58:54.690247 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.690954 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.691016 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.691059 drop table if exists "person_test"; []
gorptest: 16:58:54.691110 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.691153 drop table if exists "id_created_test"; []
gorptest: 16:58:54.691194 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.691237 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.691288 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.691333 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.691383 drop table if exists "time_test"; []
gorptest: 16:58:54.691438 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.693302 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: 16:58:54.695062 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.696327 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.697877 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.699434 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.701170 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.702758 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.704520 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.705924 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.707676 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.709331 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.710910 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: 16:58:54.710973 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: 16:58:54.711014 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.711054 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: 16:58:54.711097 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: 16:58:54.711140 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.711188 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.711228 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.711272 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.711314 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.711355 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: 16:58:54.711407 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.711448 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; []
gorptest: 16:58:54.711489 drop table if exists "invoice_test"; []
gorptest: 16:58:54.712556 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.713902 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.715425 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.716975 drop table if exists "person_test"; []
gorptest: 16:58:54.718165 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.719212 drop table if exists "id_created_test"; []
gorptest: 16:58:54.720268 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.721208 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.722323 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.723330 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.724309 drop table if exists "time_test"; []
gorptest: 16:58:54.725894 drop table if exists "id_created_test"; []
--- PASS: TestCreateTablesIfNotExists (0.04s)
=== RUN   TestTruncateTables
2021/10/08 16:58:54 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: 16:58:54.726244 drop table if exists "invoice_test"; []
gorptest: 16:58:54.726469 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.726518 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.726561 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.726603 drop table if exists "person_test"; []
gorptest: 16:58:54.726644 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.726683 drop table if exists "id_created_test"; []
gorptest: 16:58:54.726722 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.726766 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.726815 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.726862 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.726905 drop table if exists "time_test"; []
gorptest: 16:58:54.726959 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.728479 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: 16:58:54.729901 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.731115 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.732116 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.733650 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.734973 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.735996 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.737211 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.738311 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.739506 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.740799 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.741973 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: 16:58:54.742033 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: 16:58:54.742073 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.742111 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: 16:58:54.742154 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: 16:58:54.742192 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.742227 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.742264 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.742302 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.742338 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.742376 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: 16:58:54.742411 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.742447 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; []
gorptest: 16:58:54.742520 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712334742494761 2:1633712334742494761 3:"Bob" 4:"Smith" 5:1]
gorptest: 16:58:54.743500 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true]
gorptest: 16:58:54.744813 delete from "invoice_test"; []
gorptest: 16:58:54.746006 delete from "invoice_tag_test"; []
gorptest: 16:58:54.746936 delete from "alias_trans_field_test"; []
gorptest: 16:58:54.747971 delete from "invoice_override_test"; []
gorptest: 16:58:54.749018 delete from "person_test"; []
gorptest: 16:58:54.750126 delete from "ignored_column_test"; []
gorptest: 16:58:54.751062 delete from "id_created_test"; []
gorptest: 16:58:54.752223 delete from "type_conv_test"; []
gorptest: 16:58:54.753510 delete from "embedded_struct_test"; []
gorptest: 16:58:54.754888 delete from "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.756156 delete from "embedded_autoincr_test"; []
gorptest: 16:58:54.757226 delete from "time_test"; []
gorptest: 16:58:54.758168 delete from "id_created_test"; []
gorptest: 16:58:54.759104 SELECT * FROM person_test []
gorptest: 16:58:54.759224 SELECT * FROM invoice_test []
gorptest: 16:58:54.759306 drop table if exists "invoice_test"; []
gorptest: 16:58:54.760322 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.761696 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.762891 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.763917 drop table if exists "person_test"; []
gorptest: 16:58:54.765117 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.766184 drop table if exists "id_created_test"; []
gorptest: 16:58:54.767209 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.768365 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.770029 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.771399 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.772960 drop table if exists "time_test"; []
gorptest: 16:58:54.773991 drop table if exists "id_created_test"; []
--- PASS: TestTruncateTables (0.05s)
=== RUN   TestCustomDateType
gorptest: 16:58:54.774272 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; []
gorptest: 16:58:54.775598 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2021-10-08 16:58:54 +0000 UTC]
gorptest: 16:58:54.776972 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1]
gorptest: 16:58:54.777154 drop table if exists "WithCustomDate"; []
--- PASS: TestCustomDateType (0.00s)
=== RUN   TestUIntPrimaryKey
gorptest: 16:58:54.778473 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; []
gorptest: 16:58:54.779647 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; []
gorptest: 16:58:54.781041 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; []
gorptest: 16:58:54.782132 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"]
gorptest: 16:58:54.783592 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"]
gorptest: 16:58:54.785332 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"]
gorptest: 16:58:54.786797 drop table if exists "PersonUInt64"; []
gorptest: 16:58:54.787820 drop table if exists "PersonUInt32"; []
gorptest: 16:58:54.789042 drop table if exists "PersonUInt16"; []
--- PASS: TestUIntPrimaryKey (0.01s)
=== RUN   TestSetUniqueTogether
gorptest: 16:58:54.790502 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; []
gorptest: 16:58:54.792579 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014]
gorptest: 16:58:54.794521 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085]
gorptest: 16:58:54.794697 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014]
gorptest: 16:58:54.794832 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085]
gorptest: 16:58:54.795964 drop table if exists "UniqueColumns"; []
--- PASS: TestSetUniqueTogether (0.01s)
=== RUN   TestPersistentUser
gorptest: 16:58:54.797770 drop table if exists PersistentUser []
gorptest: 16:58:54.798085 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; []
gorptest: 16:58:54.799614 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false]
gorptest: 16:58:54.800944 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43]
gorptest: 16:58:54.801111 select * from PersistentUser []
gorptest: 16:58:54.801218 select * from PersistentUser []
gorptest: 16:58:54.801346 select * from PersistentUser []
gorptest: 16:58:54.801490 select Id from PersistentUser []
gorptest: 16:58:54.801609 select mykey from PersistentUser []
gorptest: 16:58:54.801702 select PassedTraining from PersistentUser []
gorptest: 16:58:54.801776 select Id from PersistentUser []
gorptest: 16:58:54.801849 drop table if exists "PersistentUser"; []
--- PASS: TestPersistentUser (0.01s)
=== RUN   TestNamedQueryMap
gorptest: 16:58:54.802963 drop table if exists PersistentUser []
gorptest: 16:58:54.803186 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; []
gorptest: 16:58:54.805034 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false]
gorptest: 16:58:54.806297 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false]
gorptest: 16:58:54.807633 select * from PersistentUser where mykey = ? [1:43]
gorptest: 16:58:54.807771 select * from PersistentUser where mykey = ? [1:43]
gorptest: 16:58:54.807877 
select * from PersistentUser
 where mykey = ?
   and PassedTraining = ?
   and Id = ? [1:43 2:false 3:"33r"]
gorptest: 16:58:54.807998 
select * from PersistentUser
 where mykey = ?
   and Id != 'abc:def' [1:43]
gorptest: 16:58:54.808130 drop table if exists "PersistentUser"; []
--- PASS: TestNamedQueryMap (0.01s)
=== RUN   TestNamedQueryStruct
gorptest: 16:58:54.809317 drop table if exists PersistentUser []
gorptest: 16:58:54.809585 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; []
gorptest: 16:58:54.810807 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false]
gorptest: 16:58:54.811680 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false]
gorptest: 16:58:54.812878 
select * from PersistentUser
 where mykey = ?
   and PassedTraining = ?
   and Id = ? [1:43 2:false 3:"33r"]
gorptest: 16:58:54.813065 drop table if exists "PersistentUser"; []
--- PASS: TestNamedQueryStruct (0.01s)
=== RUN   TestReturnsNonNilSlice
2021/10/08 16:58:54 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: 16:58:54.814688 drop table if exists "invoice_test"; []
gorptest: 16:58:54.814915 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.814965 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.815009 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.815052 drop table if exists "person_test"; []
gorptest: 16:58:54.815108 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.815184 drop table if exists "id_created_test"; []
gorptest: 16:58:54.815229 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.815298 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.815361 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.815431 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.815490 drop table if exists "time_test"; []
gorptest: 16:58:54.815543 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.816820 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: 16:58:54.817904 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.819179 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.820739 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.822452 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.823715 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.825420 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.826775 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.828106 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.829660 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.830965 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.832485 select * from invoice_test where id=99999 []
gorptest: 16:58:54.832787 select * from invoice_test where id=99999 []
gorptest: 16:58:54.832923 drop table if exists "invoice_test"; []
gorptest: 16:58:54.834756 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.836205 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.837965 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.839289 drop table if exists "person_test"; []
gorptest: 16:58:54.840868 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.842269 drop table if exists "id_created_test"; []
gorptest: 16:58:54.843493 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.845023 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.846412 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.847735 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.849184 drop table if exists "time_test"; []
gorptest: 16:58:54.850689 drop table if exists "id_created_test"; []
--- PASS: TestReturnsNonNilSlice (0.04s)
=== RUN   TestOverrideVersionCol
gorptest: 16:58:54.850922 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; []
gorptest: 16:58:54.852239 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: 16:58:54.852421 drop table if exists "InvoicePersonView"; []
--- PASS: TestOverrideVersionCol (0.00s)
=== RUN   TestOptimisticLocking
2021/10/08 16:58:54 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: 16:58:54.854022 drop table if exists "invoice_test"; []
gorptest: 16:58:54.854221 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.854272 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.854320 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.854366 drop table if exists "person_test"; []
gorptest: 16:58:54.854411 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.854476 drop table if exists "id_created_test"; []
gorptest: 16:58:54.854552 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.854623 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.854685 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.854734 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.854780 drop table if exists "time_test"; []
gorptest: 16:58:54.854833 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.855816 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: 16:58:54.857361 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.858834 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.859919 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.861236 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.862523 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.863753 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.865277 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.866717 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.868472 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.870069 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.871644 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712334871615630 2:1633712334871615630 3:"Bob" 4:"Smith" 5:1]
gorptest: 16:58:54.873364 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:54.873511 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1633712334871615630 2:1633712334871615630 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1]
gorptest: 16:58:54.874927 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1633712334871615630 2:1633712334871615630 3:"preupdate" 4:"Howard" 5:2 6:1 7:1]
gorptest: 16:58:54.875064 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:54.875202 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1]
gorptest: 16:58:54.875296 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:54.875412 drop table if exists "invoice_test"; []
gorptest: 16:58:54.876641 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.878018 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.879329 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.880609 drop table if exists "person_test"; []
gorptest: 16:58:54.882186 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.883978 drop table if exists "id_created_test"; []
gorptest: 16:58:54.885575 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.887103 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.888928 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.890485 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.891827 drop table if exists "time_test"; []
gorptest: 16:58:54.893521 drop table if exists "id_created_test"; []
--- PASS: TestOptimisticLocking (0.04s)
=== RUN   TestDoubleAddTable
--- PASS: TestDoubleAddTable (0.00s)
=== RUN   TestNullValues
gorptest: 16:58:54.893905 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; []
gorptest: 16:58:54.895410 insert into TableWithNull values (10, null, null, null, null, null) []
gorptest: 16:58:54.896677 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10]
gorptest: 16:58:54.896839 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: 16:58:54.897895 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10]
gorptest: 16:58:54.898014 drop table if exists "TableWithNull"; []
--- PASS: TestNullValues (0.01s)
=== RUN   TestColumnProps
gorptest: 16:58:54.899288 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; []
gorptest: 16:58:54.901167 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true]
gorptest: 16:58:54.902526 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1]
gorptest: 16:58:54.902702 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true]
gorptest: 16:58:54.902848 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false]
gorptest: 16:58:54.902964 drop table if exists "Invoice"; []
--- PASS: TestColumnProps (0.01s)
=== RUN   TestRawSelect
2021/10/08 16:58:54 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: 16:58:54.904423 drop table if exists "invoice_test"; []
gorptest: 16:58:54.904666 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.904716 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.904766 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.904810 drop table if exists "person_test"; []
gorptest: 16:58:54.904859 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.904927 drop table if exists "id_created_test"; []
gorptest: 16:58:54.904995 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.905062 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.905157 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.905243 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.905303 drop table if exists "time_test"; []
gorptest: 16:58:54.905356 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.906598 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: 16:58:54.907672 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.908984 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.910509 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.911937 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.913434 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.914899 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.916446 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.917960 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.919469 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.920838 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.922285 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712334922259228 2:1633712334922259228 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:54.923542 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true]
gorptest: 16:58:54.925138 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id []
gorptest: 16:58:54.925367 drop table if exists "invoice_test"; []
gorptest: 16:58:54.926882 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.928195 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.929930 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.931397 drop table if exists "person_test"; []
gorptest: 16:58:54.933215 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.934958 drop table if exists "id_created_test"; []
gorptest: 16:58:54.936364 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.937661 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.938808 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.940152 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.941729 drop table if exists "time_test"; []
gorptest: 16:58:54.943133 drop table if exists "id_created_test"; []
--- PASS: TestRawSelect (0.04s)
=== RUN   TestHooks
2021/10/08 16:58:54 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: 16:58:54.943470 drop table if exists "invoice_test"; []
gorptest: 16:58:54.943690 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.943766 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.943835 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.943902 drop table if exists "person_test"; []
gorptest: 16:58:54.943960 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.944003 drop table if exists "id_created_test"; []
gorptest: 16:58:54.944087 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.944163 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.944224 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.944290 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.944335 drop table if exists "time_test"; []
gorptest: 16:58:54.944392 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.946176 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: 16:58:54.947240 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.948438 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.949599 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.950516 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.951594 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.952747 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.954009 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.955242 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.956216 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:54.957450 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:54.958734 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712334958709861 2:1633712334958709861 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:54.959916 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:54.960052 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1633712334958709861 2:1633712334958709861 3:"preupdate" 4:"postget" 5:2 6:1 7:1]
gorptest: 16:58:54.961282 select * from person_test where id = ? [1:1]
gorptest: 16:58:54.961408 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2]
gorptest: 16:58:54.962533 drop table if exists "invoice_test"; []
gorptest: 16:58:54.963333 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.964297 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.965624 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.966975 drop table if exists "person_test"; []
gorptest: 16:58:54.968093 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.969149 drop table if exists "id_created_test"; []
gorptest: 16:58:54.970493 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.971651 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.972859 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.974357 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.976331 drop table if exists "time_test"; []
gorptest: 16:58:54.978114 drop table if exists "id_created_test"; []
--- PASS: TestHooks (0.03s)
=== RUN   TestTransaction
2021/10/08 16:58:54 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: 16:58:54.978429 drop table if exists "invoice_test"; []
gorptest: 16:58:54.978722 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:54.978789 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:54.978847 drop table if exists "invoice_override_test"; []
gorptest: 16:58:54.978892 drop table if exists "person_test"; []
gorptest: 16:58:54.978952 drop table if exists "ignored_column_test"; []
gorptest: 16:58:54.978997 drop table if exists "id_created_test"; []
gorptest: 16:58:54.979044 drop table if exists "type_conv_test"; []
gorptest: 16:58:54.979089 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:54.979153 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:54.979220 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:54.979268 drop table if exists "time_test"; []
gorptest: 16:58:54.979354 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.980854 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: 16:58:54.982065 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:54.983112 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:54.984238 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:54.985802 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.987346 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:54.988674 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:54.992973 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:54.993954 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:54.995232 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.000233 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.001791 begin; []
gorptest: 16:58:55.001859 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true]
gorptest: 16:58:55.002115 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false]
gorptest: 16:58:55.002186 commit; []
gorptest: 16:58:55.003013 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.003187 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2]
gorptest: 16:58:55.003318 drop table if exists "invoice_test"; []
gorptest: 16:58:55.004648 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.005816 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.006563 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.007345 drop table if exists "person_test"; []
gorptest: 16:58:55.008100 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.009114 drop table if exists "id_created_test"; []
gorptest: 16:58:55.010224 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.011257 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.012264 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.013499 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.014736 drop table if exists "time_test"; []
gorptest: 16:58:55.015738 drop table if exists "id_created_test"; []
--- PASS: TestTransaction (0.04s)
=== RUN   TestSavepoint
2021/10/08 16:58:55 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: 16:58:55.016104 drop table if exists "invoice_test"; []
gorptest: 16:58:55.016348 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.016419 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.016471 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.016539 drop table if exists "person_test"; []
gorptest: 16:58:55.016591 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.016654 drop table if exists "id_created_test"; []
gorptest: 16:58:55.016716 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.016812 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.016903 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.016973 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.017035 drop table if exists "time_test"; []
gorptest: 16:58:55.017097 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.017899 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: 16:58:55.018783 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.019890 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.021236 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.022451 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.023624 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.024751 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.025972 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.027032 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.028129 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.029408 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.030569 begin; []
gorptest: 16:58:55.030627 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false]
gorptest: 16:58:55.030868 select memo from invoice_test []
gorptest: 16:58:55.030957 savepoint "foo" [1:<nil>]
gorptest: 16:58:55.030982 select memo from invoice_test []
gorptest: 16:58:55.031075 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1]
gorptest: 16:58:55.031162 select memo from invoice_test []
gorptest: 16:58:55.031228 rollback to savepoint "foo" [1:<nil>]
gorptest: 16:58:55.031263 select memo from invoice_test []
gorptest: 16:58:55.031311 rollback; []
gorptest: 16:58:55.031445 drop table if exists "invoice_test"; []
gorptest: 16:58:55.032471 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.033496 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.034617 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.035684 drop table if exists "person_test"; []
gorptest: 16:58:55.036751 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.037862 drop table if exists "id_created_test"; []
gorptest: 16:58:55.038998 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.040053 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.041271 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.042339 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.043395 drop table if exists "time_test"; []
gorptest: 16:58:55.044637 drop table if exists "id_created_test"; []
--- PASS: TestSavepoint (0.03s)
=== RUN   TestMultiple
2021/10/08 16:58:55 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: 16:58:55.044912 drop table if exists "invoice_test"; []
gorptest: 16:58:55.045235 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.045309 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.045371 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.045445 drop table if exists "person_test"; []
gorptest: 16:58:55.045489 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.045532 drop table if exists "id_created_test"; []
gorptest: 16:58:55.045579 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.045626 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.045673 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.045717 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.045762 drop table if exists "time_test"; []
gorptest: 16:58:55.045817 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.046683 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: 16:58:55.047449 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.048350 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.049249 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.050155 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.050954 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.051768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.052579 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.053471 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.054457 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.055269 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.056093 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false]
gorptest: 16:58:55.057245 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true]
gorptest: 16:58:55.058429 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1]
gorptest: 16:58:55.059514 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2]
gorptest: 16:58:55.060608 delete from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.061762 delete from "invoice_test" where "Id"=?; [1:2]
gorptest: 16:58:55.062787 drop table if exists "invoice_test"; []
gorptest: 16:58:55.063912 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.065006 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.066156 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.067309 drop table if exists "person_test"; []
gorptest: 16:58:55.068421 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.069647 drop table if exists "id_created_test"; []
gorptest: 16:58:55.070755 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.071729 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.075712 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.077066 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.078319 drop table if exists "time_test"; []
gorptest: 16:58:55.079428 drop table if exists "id_created_test"; []
--- PASS: TestMultiple (0.03s)
=== RUN   TestCrud
2021/10/08 16:58:55 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: 16:58:55.079746 drop table if exists "invoice_test"; []
gorptest: 16:58:55.080131 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.080212 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.080276 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.080341 drop table if exists "person_test"; []
gorptest: 16:58:55.080387 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.080433 drop table if exists "id_created_test"; []
gorptest: 16:58:55.080479 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.080528 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.080577 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.080626 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.080668 drop table if exists "time_test"; []
gorptest: 16:58:55.080725 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.081630 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: 16:58:55.082570 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.083438 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.084679 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.085764 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.086844 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.087959 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.089286 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.090505 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.091677 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.093060 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.094242 delete from invoice_test []
gorptest: 16:58:55.094983 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true]
gorptest: 16:58:55.096069 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.096263 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1]
gorptest: 16:58:55.097282 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.097425 select * from invoice_test []
gorptest: 16:58:55.097595 delete from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.098491 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1]
gorptest: 16:58:55.098622 delete from invoice_tag_test []
gorptest: 16:58:55.099647 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: 16:58:55.100700 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1]
gorptest: 16:58:55.100890 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1]
gorptest: 16:58:55.101928 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1]
gorptest: 16:58:55.102087 select * from invoice_tag_test []
gorptest: 16:58:55.102310 delete from "invoice_tag_test" where "myid"=?; [1:1]
gorptest: 16:58:55.103689 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1]
gorptest: 16:58:55.103816 delete from alias_trans_field_test []
gorptest: 16:58:55.105292 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"]
gorptest: 16:58:55.106529 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1]
gorptest: 16:58:55.106703 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1]
gorptest: 16:58:55.107686 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1]
gorptest: 16:58:55.107831 select * from alias_trans_field_test []
gorptest: 16:58:55.107964 delete from "alias_trans_field_test" where "id"=?; [1:1]
gorptest: 16:58:55.109345 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1]
gorptest: 16:58:55.109468 drop table if exists "invoice_test"; []
gorptest: 16:58:55.110497 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.111650 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.113013 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.114608 drop table if exists "person_test"; []
gorptest: 16:58:55.115676 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.116832 drop table if exists "id_created_test"; []
gorptest: 16:58:55.117924 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.118896 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.119895 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.121305 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.122903 drop table if exists "time_test"; []
gorptest: 16:58:55.124785 drop table if exists "id_created_test"; []
--- PASS: TestCrud (0.05s)
=== RUN   TestWithIgnoredColumn
2021/10/08 16:58:55 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: 16:58:55.125133 drop table if exists "invoice_test"; []
gorptest: 16:58:55.125518 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.125626 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.125703 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.125771 drop table if exists "person_test"; []
gorptest: 16:58:55.125838 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.125904 drop table if exists "id_created_test"; []
gorptest: 16:58:55.126023 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.126113 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.126192 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.126268 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.126346 drop table if exists "time_test"; []
gorptest: 16:58:55.126431 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.127796 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: 16:58:55.129254 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.130599 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.131650 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.132931 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.134241 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.135461 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.136502 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.138342 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.139512 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.140706 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.142128 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1]
gorptest: 16:58:55.143058 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1]
gorptest: 16:58:55.143175 delete from "ignored_column_test" where "Id"=?; [1:1]
gorptest: 16:58:55.143918 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1]
gorptest: 16:58:55.144018 drop table if exists "invoice_test"; []
gorptest: 16:58:55.145163 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.146657 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.147952 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.149379 drop table if exists "person_test"; []
gorptest: 16:58:55.150449 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.151576 drop table if exists "id_created_test"; []
gorptest: 16:58:55.152743 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.153865 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.155063 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.156420 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.157584 drop table if exists "time_test"; []
gorptest: 16:58:55.158951 drop table if exists "id_created_test"; []
--- PASS: TestWithIgnoredColumn (0.03s)
=== RUN   TestTypeConversionExample
2021/10/08 16:58:55 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: 16:58:55.159277 drop table if exists "invoice_test"; []
gorptest: 16:58:55.159595 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.159665 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.159728 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.159797 drop table if exists "person_test"; []
gorptest: 16:58:55.159869 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.159933 drop table if exists "id_created_test"; []
gorptest: 16:58:55.160011 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.160121 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.160191 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.160262 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.160333 drop table if exists "time_test"; []
gorptest: 16:58:55.160415 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.161658 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: 16:58:55.162771 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.163848 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.165225 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.166620 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.167637 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.173424 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.174548 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.175696 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.177126 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.178547 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.180214 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: 16:58:55.181371 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1]
gorptest: 16:58:55.181581 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: 16:58:55.182685 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1]
gorptest: 16:58:55.182843 delete from "type_conv_test" where "Id"=?; [1:1]
gorptest: 16:58:55.183765 drop table if exists "invoice_test"; []
gorptest: 16:58:55.184823 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.185966 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.186957 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.187966 drop table if exists "person_test"; []
gorptest: 16:58:55.189677 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.190675 drop table if exists "id_created_test"; []
gorptest: 16:58:55.191694 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.192723 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.193744 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.196409 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.197863 drop table if exists "time_test"; []
gorptest: 16:58:55.198992 drop table if exists "id_created_test"; []
--- PASS: TestTypeConversionExample (0.04s)
=== RUN   TestWithEmbeddedStruct
2021/10/08 16:58:55 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: 16:58:55.199341 drop table if exists "invoice_test"; []
gorptest: 16:58:55.199583 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.199631 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.199675 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.199722 drop table if exists "person_test"; []
gorptest: 16:58:55.199795 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.199869 drop table if exists "id_created_test"; []
gorptest: 16:58:55.199922 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.199973 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.200016 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.200106 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.200152 drop table if exists "time_test"; []
gorptest: 16:58:55.200215 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.201207 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: 16:58:55.202453 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.203913 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.205213 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.206825 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.208080 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.209451 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.215672 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.217166 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.218472 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.220181 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.221680 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"]
gorptest: 16:58:55.223122 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1]
gorptest: 16:58:55.223308 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1]
gorptest: 16:58:55.224597 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1]
gorptest: 16:58:55.224746 select * from embedded_struct_test []
gorptest: 16:58:55.224884 drop table if exists "invoice_test"; []
gorptest: 16:58:55.226008 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.227311 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.228415 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.229628 drop table if exists "person_test"; []
gorptest: 16:58:55.231080 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.232286 drop table if exists "id_created_test"; []
gorptest: 16:58:55.233200 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.234223 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.235104 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.236113 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.237173 drop table if exists "time_test"; []
gorptest: 16:58:55.238257 drop table if exists "id_created_test"; []
--- PASS: TestWithEmbeddedStruct (0.04s)
=== RUN   TestWithEmbeddedStructBeforeAutoincr
2021/10/08 16:58:55 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: 16:58:55.238500 drop table if exists "invoice_test"; []
gorptest: 16:58:55.238737 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.238784 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.238846 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.238919 drop table if exists "person_test"; []
gorptest: 16:58:55.238991 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.239058 drop table if exists "id_created_test"; []
gorptest: 16:58:55.239130 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.239202 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.239276 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.239353 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.239426 drop table if exists "time_test"; []
gorptest: 16:58:55.239513 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.240690 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: 16:58:55.241781 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.242910 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.244125 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.245238 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.246393 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.247564 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.248714 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.249837 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.250954 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.252014 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.253182 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"]
gorptest: 16:58:55.254247 drop table if exists "invoice_test"; []
gorptest: 16:58:55.255304 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.256527 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.257672 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.258931 drop table if exists "person_test"; []
gorptest: 16:58:55.260102 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.261422 drop table if exists "id_created_test"; []
gorptest: 16:58:55.262597 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.263764 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.265121 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.266409 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.267614 drop table if exists "time_test"; []
gorptest: 16:58:55.268847 drop table if exists "id_created_test"; []
--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.03s)
=== RUN   TestWithEmbeddedAutoincr
2021/10/08 16:58:55 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: 16:58:55.269152 drop table if exists "invoice_test"; []
gorptest: 16:58:55.269486 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.269561 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.269624 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.269697 drop table if exists "person_test"; []
gorptest: 16:58:55.269761 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.269829 drop table if exists "id_created_test"; []
gorptest: 16:58:55.269892 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.269981 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.270056 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.270127 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.270203 drop table if exists "time_test"; []
gorptest: 16:58:55.270287 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.271388 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: 16:58:55.272600 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.273867 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.275004 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.276149 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.277577 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.279012 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.280301 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.281435 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.282345 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.283498 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.284640 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"]
gorptest: 16:58:55.285672 drop table if exists "invoice_test"; []
gorptest: 16:58:55.286671 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.287506 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.288873 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.374066 drop table if exists "person_test"; []
gorptest: 16:58:55.375559 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.376817 drop table if exists "id_created_test"; []
gorptest: 16:58:55.378134 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.379271 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.380361 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.381449 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.382624 drop table if exists "time_test"; []
gorptest: 16:58:55.383558 drop table if exists "id_created_test"; []
--- PASS: TestWithEmbeddedAutoincr (0.11s)
=== RUN   TestSelectVal
gorptest: 16:58:55.383784 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; []
gorptest: 16:58:55.385359 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: 16:58:55.386307 select Int64 from TableWithNull where Str='abc' []
gorptest: 16:58:55.386404 select count(*) from TableWithNull []
gorptest: 16:58:55.386463 select count(*) from TableWithNull where Str=? [1:"asdfasdf"]
gorptest: 16:58:55.386537 select Int64 from TableWithNull where Str='notfound' []
gorptest: 16:58:55.386600 select Int64 from TableWithNull where Str='abc' []
gorptest: 16:58:55.386665 select Float64 from TableWithNull where Str='abc' []
gorptest: 16:58:55.386746 select min(Float64) from TableWithNull []
gorptest: 16:58:55.386831 select count(*) from TableWithNull where Str=? [1:"asdfasdf"]
gorptest: 16:58:55.386918 select Float64 from TableWithNull where Str='notfound' []
gorptest: 16:58:55.386987 select Float64 from TableWithNull where Str='abc' []
gorptest: 16:58:55.387055 select Str from TableWithNull where Int64=? [1:78]
gorptest: 16:58:55.387118 select Str from TableWithNull where Str='asdfasdf' []
gorptest: 16:58:55.387196 select Str from TableWithNull where Int64=? [1:78]
gorptest: 16:58:55.387292 select Str from TableWithNull where Str='asdfasdf' []
gorptest: 16:58:55.387397 select Int64 from TableWithNull where Str=? [1:"abc"]
gorptest: 16:58:55.387484 select Str from TableWithNull where Int64=? [1:78]
gorptest: 16:58:55.387572 drop table if exists "TableWithNull"; []
--- PASS: TestSelectVal (0.01s)
=== RUN   TestVersionMultipleRows
2021/10/08 16:58:55 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: 16:58:55.388914 drop table if exists "invoice_test"; []
gorptest: 16:58:55.389171 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.389224 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.389275 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.389326 drop table if exists "person_test"; []
gorptest: 16:58:55.389380 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.389429 drop table if exists "id_created_test"; []
gorptest: 16:58:55.389472 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.389517 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.389571 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.389615 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.389658 drop table if exists "time_test"; []
gorptest: 16:58:55.389714 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.391448 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: 16:58:55.392404 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.393400 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.394519 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.395409 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.396401 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.397784 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.398739 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.400456 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.401762 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.402860 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.404084 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335404006900 2:1633712335404006900 3:"Bob" 4:"Smith" 5:1]
gorptest: 16:58:55.405368 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335405330651 2:1633712335405330651 3:"Jane" 4:"Smith" 5:1]
gorptest: 16:58:55.406348 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335406335282 2:1633712335406335282 3:"Mike" 4:"Smith" 5:1]
gorptest: 16:58:55.407448 drop table if exists "invoice_test"; []
gorptest: 16:58:55.408857 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.410243 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.411584 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.412946 drop table if exists "person_test"; []
gorptest: 16:58:55.413863 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.414822 drop table if exists "id_created_test"; []
gorptest: 16:58:55.416322 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.417736 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.419253 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.420639 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.422141 drop table if exists "time_test"; []
gorptest: 16:58:55.423351 drop table if exists "id_created_test"; []
--- PASS: TestVersionMultipleRows (0.03s)
=== RUN   TestWithStringPk
gorptest: 16:58:55.423665 create table string_pk_test (Id varchar(255), Name varchar(255)); []
gorptest: 16:58:55.425277 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"]
gorptest: 16:58:55.426792 drop table if exists "string_pk_test"; []
--- PASS: TestWithStringPk (0.00s)
=== RUN   TestSqlExecutorInterfaceSelects
--- PASS: TestSqlExecutorInterfaceSelects (0.00s)
=== RUN   TestWithTimeSelect
2021/10/08 16:58:55 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: 16:58:55.428409 drop table if exists "invoice_test"; []
gorptest: 16:58:55.428737 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.428811 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.428886 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.428953 drop table if exists "person_test"; []
gorptest: 16:58:55.429020 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.429095 drop table if exists "id_created_test"; []
gorptest: 16:58:55.429146 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.429197 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.429285 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.429355 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.429405 drop table if exists "time_test"; []
gorptest: 16:58:55.429485 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.430549 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: 16:58:55.431691 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.432904 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.434484 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.435614 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.437239 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.438606 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.439744 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.440966 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.442183 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.443308 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.444513 insert into "time_test" ("Id","Time") values (null,?); [1:2021-10-08 16:27:55.444489771 +0000 UTC]
gorptest: 16:58:55.445625 insert into "time_test" ("Id","Time") values (null,?); [1:2021-10-08 16:28:56.444489771 +0000 UTC]
gorptest: 16:58:55.446801 SELECT id FROM time_test WHERE Time < ? [1:2021-10-08 16:28:55.444489771 +0000 UTC]
gorptest: 16:58:55.446957 drop table if exists "invoice_test"; []
gorptest: 16:58:55.447983 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.449290 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.450308 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.451363 drop table if exists "person_test"; []
gorptest: 16:58:55.452403 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.453585 drop table if exists "id_created_test"; []
gorptest: 16:58:55.454747 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.455809 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.456891 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.457883 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.458869 drop table if exists "time_test"; []
gorptest: 16:58:55.459894 drop table if exists "id_created_test"; []
--- PASS: TestWithTimeSelect (0.03s)
=== RUN   TestInvoicePersonView
2021/10/08 16:58:55 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: 16:58:55.460223 drop table if exists "invoice_test"; []
gorptest: 16:58:55.460535 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.460608 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.460680 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.460754 drop table if exists "person_test"; []
gorptest: 16:58:55.460821 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.460895 drop table if exists "id_created_test"; []
gorptest: 16:58:55.460963 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.461040 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.461089 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.461137 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.461196 drop table if exists "time_test"; []
gorptest: 16:58:55.461263 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.462012 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: 16:58:55.462832 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.463682 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.464932 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.466157 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.467183 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.468283 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.469339 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.470376 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.471456 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.472597 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.473734 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335473717684 2:1633712335473717684 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:55.474668 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false]
gorptest: 16:58:55.475603 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id []
gorptest: 16:58:55.475770 drop table if exists "invoice_test"; []
gorptest: 16:58:55.476744 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.477688 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.478724 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.479651 drop table if exists "person_test"; []
gorptest: 16:58:55.480856 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.481894 drop table if exists "id_created_test"; []
gorptest: 16:58:55.482987 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.484066 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.485124 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.486659 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.487586 drop table if exists "time_test"; []
gorptest: 16:58:55.490844 drop table if exists "id_created_test"; []
--- PASS: TestInvoicePersonView (0.03s)
=== RUN   TestQuoteTableNames
2021/10/08 16:58:55 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: 16:58:55.491336 drop table if exists "invoice_test"; []
gorptest: 16:58:55.491741 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.491835 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.491909 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.491973 drop table if exists "person_test"; []
gorptest: 16:58:55.492037 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.493501 drop table if exists "id_created_test"; []
gorptest: 16:58:55.493619 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.493722 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.493793 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.493857 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.493926 drop table if exists "time_test"; []
gorptest: 16:58:55.494015 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.507417 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: 16:58:55.520525 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.521930 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.523391 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.524715 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.525990 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.527192 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.528402 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.530107 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.531587 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.532948 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
--- PASS: TestQuoteTableNames (0.06s)
=== RUN   TestSelectTooManyCols
2021/10/08 16:58:55 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: 16:58:55.552032 drop table if exists "invoice_test"; []
gorptest: 16:58:55.552367 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.552442 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.552510 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.552580 drop table if exists "person_test"; []
gorptest: 16:58:55.552646 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.552689 drop table if exists "id_created_test"; []
gorptest: 16:58:55.552732 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.552774 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.552826 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.552898 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.552966 drop table if exists "time_test"; []
gorptest: 16:58:55.553050 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.553918 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: 16:58:55.554665 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.555481 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.556665 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.557907 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.558983 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.560153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.561364 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.562527 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.563621 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.564806 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.565960 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335565934067 2:1633712335565934067 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:55.567074 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335567055144 2:1633712335567055144 3:"jane" 4:"doe" 5:1]
gorptest: 16:58:55.568145 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:55.568313 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2]
gorptest: 16:58:55.568448 select * from person_test where Id=? [1:1]
gorptest: 16:58:55.568603 select * from person_test order by fname asc []
gorptest: 16:58:55.568804 drop table if exists "invoice_test"; []
gorptest: 16:58:55.569882 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.570762 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.571904 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.573676 drop table if exists "person_test"; []
gorptest: 16:58:55.574646 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.575574 drop table if exists "id_created_test"; []
gorptest: 16:58:55.576544 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.577657 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.578596 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.579536 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.580750 drop table if exists "time_test"; []
gorptest: 16:58:55.581820 drop table if exists "id_created_test"; []
--- PASS: TestSelectTooManyCols (0.03s)
=== RUN   TestSelectSingleVal
2021/10/08 16:58:55 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: 16:58:55.582156 drop table if exists "invoice_test"; []
gorptest: 16:58:55.582488 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.582571 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.582651 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.582731 drop table if exists "person_test"; []
gorptest: 16:58:55.582816 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.582897 drop table if exists "id_created_test"; []
gorptest: 16:58:55.582974 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.583055 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.583133 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.583221 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.583303 drop table if exists "time_test"; []
gorptest: 16:58:55.583391 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.584588 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: 16:58:55.585965 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.587421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.588728 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.590282 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.591877 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.593055 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.594550 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.595760 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.596867 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.597989 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.598957 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335598925875 2:1633712335598925875 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:55.600063 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1]
gorptest: 16:58:55.600270 select * from person_test where Id=? [1:1]
gorptest: 16:58:55.600459 select FName from person_test where Id=? [1:1]
gorptest: 16:58:55.600572 select * from person_test where Id=? [1:1]
gorptest: 16:58:55.600739 select * from person_test where 2<1 AND Id=? [1:1]
gorptest: 16:58:55.600882 select * from person_test where Id=? [1:-2222]
gorptest: 16:58:55.601042 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1633712335601024659 2:1633712335601024659 3:"bob" 4:"smith" 5:1]
gorptest: 16:58:55.601889 select * from person_test where Fname='bob' []
gorptest: 16:58:55.602075 select * from person_test where Id=-123 []
gorptest: 16:58:55.602177 select * from person_test where Id=-123 []
gorptest: 16:58:55.602277 select * from person_test where Id=-123 []
gorptest: 16:58:55.602376 select * from person_test where Id=-123 []
gorptest: 16:58:55.602503 drop table if exists "invoice_test"; []
gorptest: 16:58:55.603412 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.604767 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.605928 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.606979 drop table if exists "person_test"; []
gorptest: 16:58:55.608047 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.609023 drop table if exists "id_created_test"; []
gorptest: 16:58:55.610120 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.611106 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.612340 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.613548 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.614917 drop table if exists "time_test"; []
gorptest: 16:58:55.616029 drop table if exists "id_created_test"; []
--- PASS: TestSelectSingleVal (0.03s)
=== RUN   TestSelectAlias
2021/10/08 16:58:55 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: 16:58:55.616333 drop table if exists "invoice_test"; []
gorptest: 16:58:55.616669 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.616748 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.616835 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.616923 drop table if exists "person_test"; []
gorptest: 16:58:55.617003 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.617084 drop table if exists "id_created_test"; []
gorptest: 16:58:55.617165 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.617251 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.617331 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.617417 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.617497 drop table if exists "time_test"; []
gorptest: 16:58:55.617590 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.618628 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: 16:58:55.619607 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.620869 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.622221 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.623276 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.624515 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.626007 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.627002 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.628395 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.629823 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.630856 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.632103 insert into "id_created_test" ("Id","Created") values (null,?); [1:3]
gorptest: 16:58:55.633319 select * from id_created_test where Id=1 []
gorptest: 16:58:55.633505 SELECT *, 1 AS external FROM id_created_test []
gorptest: 16:58:55.633668 drop table if exists "invoice_test"; []
gorptest: 16:58:55.635225 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.636401 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.637515 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.638695 drop table if exists "person_test"; []
gorptest: 16:58:55.640106 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.641429 drop table if exists "id_created_test"; []
gorptest: 16:58:55.642360 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.643331 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.644249 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.645303 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.646329 drop table if exists "time_test"; []
gorptest: 16:58:55.647484 drop table if exists "id_created_test"; []
--- PASS: TestSelectAlias (0.03s)
=== RUN   TestMysqlPanicIfDialectNotInitialized
--- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s)
=== RUN   TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange
2021/10/08 16:58:55 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: 16:58:55.647766 drop table if exists "invoice_test"; []
gorptest: 16:58:55.648015 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.648095 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.648167 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.648227 drop table if exists "person_test"; []
gorptest: 16:58:55.648287 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.648346 drop table if exists "id_created_test"; []
gorptest: 16:58:55.648406 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.648466 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.648527 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.648595 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.648659 drop table if exists "time_test"; []
gorptest: 16:58:55.648727 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.649755 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: 16:58:55.650749 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.651674 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.652903 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.653832 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.654850 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.655706 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.656874 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.657839 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.658883 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.659769 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.660654 drop table if exists "invoice_test"; []
gorptest: 16:58:55.661557 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.662581 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.663613 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.664546 drop table if exists "person_test"; []
gorptest: 16:58:55.665383 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.666165 drop table if exists "id_created_test"; []
gorptest: 16:58:55.674295 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.675550 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.676659 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.677809 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.679085 drop table if exists "time_test"; []
gorptest: 16:58:55.680346 drop table if exists "id_created_test"; []
gorptest: 16:58:55.680411 drop table if exists "single_column_table"; []
gorptest: 16:58:55.680469 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: 16:58:55.681787 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: 16:58:55.682980 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.683879 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: 16:58:55.685565 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: 16:58:55.686576 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.687733 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.689106 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.690423 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.691358 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.692561 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: 16:58:55.693557 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.694691 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; []
gorptest: 16:58:55.694746 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; []
gorptest: 16:58:55.696087 delete from "invoice_test"; []
gorptest: 16:58:55.697372 delete from "invoice_tag_test"; []
gorptest: 16:58:55.698628 delete from "alias_trans_field_test"; []
gorptest: 16:58:55.699985 delete from "invoice_override_test"; []
gorptest: 16:58:55.701165 delete from "person_test"; []
gorptest: 16:58:55.702157 delete from "ignored_column_test"; []
gorptest: 16:58:55.703653 delete from "id_created_test"; []
gorptest: 16:58:55.705108 delete from "type_conv_test"; []
gorptest: 16:58:55.706221 delete from "embedded_struct_test"; []
gorptest: 16:58:55.706978 delete from "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.707753 delete from "embedded_autoincr_test"; []
gorptest: 16:58:55.708567 delete from "time_test"; []
gorptest: 16:58:55.709484 delete from "id_created_test"; []
gorptest: 16:58:55.710654 delete from "single_column_table"; []
gorptest: 16:58:55.711470 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"]
gorptest: 16:58:55.711596 drop table if exists "invoice_test"; []
gorptest: 16:58:55.712487 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.713525 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.714701 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.715584 drop table if exists "person_test"; []
gorptest: 16:58:55.716580 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.717471 drop table if exists "id_created_test"; []
gorptest: 16:58:55.718418 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.719351 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.720188 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.721470 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.722893 drop table if exists "time_test"; []
gorptest: 16:58:55.723761 drop table if exists "id_created_test"; []
gorptest: 16:58:55.723824 drop table if exists "single_column_table"; []
--- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.08s)
=== RUN   TestPrepare
2021/10/08 16:58:55 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: 16:58:55.725053 drop table if exists "invoice_test"; []
gorptest: 16:58:55.725304 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.725353 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.725395 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.725441 drop table if exists "person_test"; []
gorptest: 16:58:55.725482 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.725557 drop table if exists "id_created_test"; []
gorptest: 16:58:55.725608 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.725652 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.725699 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.725748 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.725795 drop table if exists "time_test"; []
gorptest: 16:58:55.725854 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.726969 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: 16:58:55.728080 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; []
gorptest: 16:58:55.729084 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; []
gorptest: 16:58:55.730229 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; []
gorptest: 16:58:55.731302 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.732304 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; []
gorptest: 16:58:55.733361 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; []
gorptest: 16:58:55.734496 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; []
gorptest: 16:58:55.735417 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; []
gorptest: 16:58:55.736464 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; []
gorptest: 16:58:55.737536 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; []
gorptest: 16:58:55.738550 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false]
gorptest: 16:58:55.739333 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false]
gorptest: 16:58:55.740075 UPDATE invoice_test SET Memo=? WHERE Id=? [1:<nil>]
gorptest: 16:58:55.741048 SELECT * from invoice_test WHERE Memo='prepare-baz' []
gorptest: 16:58:55.741211 begin; []
gorptest: 16:58:55.741246 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:<nil>]
gorptest: 16:58:55.741376 SELECT * from invoice_test WHERE IsPaid=? [1:true]
gorptest: 16:58:55.741765 SELECT * from invoice_test WHERE IsPaid=? [1:true]
gorptest: 16:58:55.741850 commit; []
gorptest: 16:58:55.742453 SELECT * from invoice_test WHERE IsPaid=? [1:true]
gorptest: 16:58:55.742577 drop table if exists "invoice_test"; []
gorptest: 16:58:55.743367 drop table if exists "invoice_tag_test"; []
gorptest: 16:58:55.744429 drop table if exists "alias_trans_field_test"; []
gorptest: 16:58:55.745480 drop table if exists "invoice_override_test"; []
gorptest: 16:58:55.746648 drop table if exists "person_test"; []
gorptest: 16:58:55.747853 drop table if exists "ignored_column_test"; []
gorptest: 16:58:55.749062 drop table if exists "id_created_test"; []
gorptest: 16:58:55.750278 drop table if exists "type_conv_test"; []
gorptest: 16:58:55.751368 drop table if exists "embedded_struct_test"; []
gorptest: 16:58:55.752627 drop table if exists "embedded_struct_before_autoincr_test"; []
gorptest: 16:58:55.753772 drop table if exists "embedded_autoincr_test"; []
gorptest: 16:58:55.754866 drop table if exists "time_test"; []
gorptest: 16:58:55.755923 drop table if exists "id_created_test"; []
--- PASS: TestPrepare (0.03s)
PASS
ok  	gopkg.in/gorp.v1	1.072s
   create-stamp debian/debhelper-build-stamp
   dh_testroot -i -O--builddirectory=_build -O--buildsystem=golang
   dh_prep -i -O--builddirectory=_build -O--buildsystem=golang
   dh_auto_install -i -O--builddirectory=_build -O--buildsystem=golang
   dh_installdocs -i -O--builddirectory=_build -O--buildsystem=golang
   dh_installchangelogs -i -O--builddirectory=_build -O--buildsystem=golang
   dh_installinit -i -O--builddirectory=_build -O--buildsystem=golang
   dh_installsystemduser -i -O--builddirectory=_build -O--buildsystem=golang
   dh_perl -i -O--builddirectory=_build -O--buildsystem=golang
   dh_link -i -O--builddirectory=_build -O--buildsystem=golang
   dh_strip_nondeterminism -i -O--builddirectory=_build -O--buildsystem=golang
   dh_compress -i -O--builddirectory=_build -O--buildsystem=golang
   dh_fixperms -i -O--builddirectory=_build -O--buildsystem=golang
   dh_missing -i -O--builddirectory=_build -O--buildsystem=golang
   dh_installdeb -i -O--builddirectory=_build -O--buildsystem=golang
   dh_golang -i -O--builddirectory=_build -O--buildsystem=golang
Use of uninitialized value $caller in string eq at /usr/share/perl5/Debian/Debhelper/Buildsystem/golang.pm line 567.
   dh_gencontrol -i -O--builddirectory=_build -O--buildsystem=golang
   dh_md5sums -i -O--builddirectory=_build -O--buildsystem=golang
   dh_builddeb -i -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=all
 dpkg-genchanges --build=all >../golang-gopkg-gorp.v1_1.7.2-2_all.changes
dpkg-genchanges: info: binary-only arch-indep upload (source code and arch-specific packages not included)
 dpkg-source --after-build .
dpkg-buildpackage: info: binary-only upload (no source included)
I: running special hook: sync-out /build/golang-gopkg-gorp.v1-sH6GIP /tmp/golang-gopkg-gorp.v1-1.7.2-2sucufzwm
I: cleaning package lists and apt cache...
W: deleting files in /tmp: gorptest.bin
I: creating tarball...
I: done
I: removing tempdir /tmp/mmdebstrap.t3NYWIa_4k...
I: success in 384.0568 seconds
md5: golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb: OK
sha1: golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb: OK
sha256: golang-gopkg-gorp.v1-dev_1.7.2-2_all.deb: OK
Checksums: OK