Diff of the two buildlogs: -- --- b1/build.log 2025-03-12 02:39:54.189944780 +0000 +++ b2/build.log 2025-03-12 02:41:16.586246024 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Mon Apr 13 21:01:59 -12 2026 -I: pbuilder-time-stamp: 1776157319 +I: Current time: Wed Mar 12 16:39:58 +14 2025 +I: pbuilder-time-stamp: 1741747198 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/trixie-reproducible-base.tgz] I: copying local configuration @@ -22,52 +22,84 @@ dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/1651141/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/D01_modify_environment starting +debug: Running on codethink04-arm64. +I: Changing host+domainname to test build reproducibility +I: Adding a custom variable just for the fun of it... +I: Changing /bin/sh to bash +'/bin/sh' -> '/bin/bash' +lrwxrwxrwx 1 root root 9 Mar 12 02:40 /bin/sh -> /bin/bash +I: Setting pbuilder2's login shell to /bin/bash +I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build/reproducible-path' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' - BUILD_ARCH='arm64' - DEBIAN_FRONTEND='noninteractive' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="2" [2]="37" [3]="1" [4]="release" [5]="aarch64-unknown-linux-gnu") + BASH_VERSION='5.2.37(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=arm64 + DEBIAN_FRONTEND=noninteractive DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=12 ' - DISTRIBUTION='trixie' - HOME='/root' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=trixie + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - INVOCATION_ID='030a6139bf504badbfe1fac5e679499f' - LANG='C' - LANGUAGE='en_US:en' - LC_ALL='C' - MAIL='/var/mail/root' - OPTIND='1' - PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' - PBCURRENTCOMMANDLINEOPERATION='build' - PBUILDER_OPERATION='build' - PBUILDER_PKGDATADIR='/usr/share/pbuilder' - PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' - PBUILDER_SYSCONFDIR='/etc' - PPID='1651141' - PS1='# ' - PS2='> ' + INVOCATION_ID=ea320efe43374c5bb2233f10a41a521e + LANG=C + LANGUAGE=nl_BE:nl + LC_ALL=C + MACHTYPE=aarch64-unknown-linux-gnu + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnu + PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path + PBCURRENTCOMMANDLINEOPERATION=build + PBUILDER_OPERATION=build + PBUILDER_PKGDATADIR=/usr/share/pbuilder + PBUILDER_PKGLIBDIR=/usr/lib/pbuilder + PBUILDER_SYSCONFDIR=/etc + PIPESTATUS=([0]="0") + POSIXLY_CORRECT=y + PPID=1416254 PS4='+ ' - PWD='/' - SHELL='/bin/bash' - SHLVL='2' - SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.UBbdTbkq/pbuilderrc_2rZS --distribution trixie --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.UBbdTbkq/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' - SUDO_GID='109' - SUDO_UID='104' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://192.168.101.4:3128' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.UBbdTbkq/pbuilderrc_NOy1 --distribution trixie --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.UBbdTbkq/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' + SUDO_GID=109 + SUDO_UID=104 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://192.168.101.4:3128 I: uname -a - Linux codethink03-arm64 6.1.0-31-cloud-arm64 #1 SMP Debian 6.1.128-1 (2025-02-07) aarch64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-31-cloud-arm64 #1 SMP Debian 6.1.128-1 (2025-02-07) aarch64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Mar 4 2025 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/1651141/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Mar 4 11:20 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -178,7 +210,7 @@ Get: 61 http://deb.debian.org/debian trixie/main arm64 libsqlite3-dev arm64 3.46.1-1 [1058 kB] Get: 62 http://deb.debian.org/debian trixie/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.24~ds1-1 [83.9 kB] Get: 63 http://deb.debian.org/debian trixie/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 76.7 MB in 0s (226 MB/s) +Fetched 76.7 MB in 1s (118 MB/s) Preconfiguring packages ... Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19914 files and directories currently installed.) @@ -445,7 +477,11 @@ Building tag database... -> Finished parsing the build-deps I: Building the package -I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for trixie +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/reproducible-path/golang-gopkg-gorp.v1-1.7.2/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../golang-gopkg-gorp.v1_1.7.2-2_source.changes dpkg-buildpackage: info: source package golang-gopkg-gorp.v1 dpkg-buildpackage: info: source version 1.7.2-2 dpkg-buildpackage: info: source distribution unstable @@ -464,62 +500,62 @@ dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 12 gopkg.in/gorp.v1 -internal/goos internal/byteorder +internal/goexperiment +internal/goarch +internal/asan internal/coverage/rtcov +internal/godebugs +internal/goos +internal/unsafeheader +internal/runtime/syscall internal/msan -internal/asan +sync/atomic +internal/runtime/math +internal/abi internal/profilerecord -internal/unsafeheader -internal/godebugs -internal/goarch -internal/goexperiment internal/cpu -internal/runtime/syscall +internal/chacha8rand math/bits -sync/atomic -cmp -internal/itoa unicode/utf8 -unicode +internal/itoa +cmp log/internal -internal/chacha8rand -internal/abi -internal/runtime/math +unicode math +internal/bytealg internal/runtime/atomic internal/runtime/sys -internal/bytealg internal/runtime/exithook internal/stringslite internal/race -internal/sync internal/runtime/maps +internal/sync runtime internal/reflectlite -iter sync -maps +iter slices -errors -sort +maps internal/bisect internal/testlog +errors +sort +internal/godebug io -math/rand/v2 internal/oserror strconv path +math/rand/v2 syscall -internal/godebug bytes strings reflect regexp/syntax -internal/syscall/execenv +regexp time internal/syscall/unix -regexp +internal/syscall/execenv context io/fs internal/poll @@ -534,1283 +570,1283 @@ dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 12 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists -2026/04/14 09:02:44 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: 09:02:44.640502 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.642774 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.642851 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.642891 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.642937 drop table if exists "person_test"; [] -gorptest: 09:02:44.642975 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.643013 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.643052 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.643099 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.643137 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.643187 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.643225 drop table if exists "time_test"; [] -gorptest: 09:02:44.643277 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.643806 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: 09:02:44.644104 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.644372 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.644680 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.644958 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.645205 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.645452 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.645709 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.645960 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.646211 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.646477 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.646942 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: 09:02:44.647034 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: 09:02:44.647099 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.647158 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: 09:02:44.647216 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: 09:02:44.647272 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.647319 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.647395 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.647447 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.647495 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.647544 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: 09:02:44.647589 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.647635 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 09:02:44.647676 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.648003 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.648244 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.648480 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.648887 drop table if exists "person_test"; [] -gorptest: 09:02:44.649126 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.649342 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.649554 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.649766 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.649978 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.650185 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.650392 drop table if exists "time_test"; [] -gorptest: 09:02:44.650595 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.275533 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.283146 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.283185 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.283201 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.283214 drop table if exists "person_test"; [] +gorptest: 02:41:11.283228 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.283242 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.283256 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.283269 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.283283 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.283297 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.283310 drop table if exists "time_test"; [] +gorptest: 02:41:11.283331 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.283556 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: 02:41:11.283677 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.283781 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.283906 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.284018 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.284118 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.284216 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.284318 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.284418 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.284514 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.284614 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.284723 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: 02:41:11.284750 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: 02:41:11.284770 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.284788 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: 02:41:11.284807 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: 02:41:11.284823 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.284839 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.284860 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.284877 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.284893 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.284910 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: 02:41:11.284926 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.284943 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:41:11.284958 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.285083 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.285176 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.285258 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.285403 drop table if exists "person_test"; [] +gorptest: 02:41:11.285500 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.285585 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.285704 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.285790 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.287411 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.287526 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.287614 drop table if exists "time_test"; [] +gorptest: 02:41:11.287697 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables -2026/04/14 09:02:44 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: 09:02:44.651364 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.651768 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.651814 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.651852 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.651890 drop table if exists "person_test"; [] -gorptest: 09:02:44.651928 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.651965 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.652003 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.652040 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.652077 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.652115 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.652154 drop table if exists "time_test"; [] -gorptest: 09:02:44.652202 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.652549 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: 09:02:44.652830 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.653091 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.653406 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.653667 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.653911 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.654172 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.654430 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.654848 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.655190 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.655527 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.655848 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: 09:02:44.655936 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: 09:02:44.655997 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.656058 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: 09:02:44.656118 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: 09:02:44.656169 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.656219 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.656271 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.656325 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.656380 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.656434 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: 09:02:44.656485 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.656543 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 09:02:44.656625 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364656596806 2:1776157364656596806 3:"Bob" 4:"Smith" 5:1] -gorptest: 09:02:44.656866 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 09:02:44.657047 delete from "invoice_test"; [] -gorptest: 09:02:44.657178 delete from "invoice_tag_test"; [] -gorptest: 09:02:44.657305 delete from "alias_trans_field_test"; [] -gorptest: 09:02:44.657428 delete from "invoice_override_test"; [] -gorptest: 09:02:44.657562 delete from "person_test"; [] -gorptest: 09:02:44.657688 delete from "ignored_column_test"; [] -gorptest: 09:02:44.657809 delete from "id_created_test"; [] -gorptest: 09:02:44.657930 delete from "type_conv_test"; [] -gorptest: 09:02:44.658051 delete from "embedded_struct_test"; [] -gorptest: 09:02:44.658180 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.658303 delete from "embedded_autoincr_test"; [] -gorptest: 09:02:44.658423 delete from "time_test"; [] -gorptest: 09:02:44.658547 delete from "id_created_test"; [] -gorptest: 09:02:44.658818 SELECT * FROM person_test [] -gorptest: 09:02:44.659035 SELECT * FROM invoice_test [] -gorptest: 09:02:44.659154 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.659499 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.659757 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.659985 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.660334 drop table if exists "person_test"; [] -gorptest: 09:02:44.660596 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.660827 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.661049 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.661266 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.661483 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.661701 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.661925 drop table if exists "time_test"; [] -gorptest: 09:02:44.662140 drop table if exists "id_created_test"; [] ---- PASS: TestTruncateTables (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.288057 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.288236 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.288253 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.288268 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.288285 drop table if exists "person_test"; [] +gorptest: 02:41:11.288299 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.288313 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.288327 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.288341 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.288355 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.288368 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.288381 drop table if exists "time_test"; [] +gorptest: 02:41:11.288400 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.288543 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: 02:41:11.288657 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.288761 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.288887 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.288990 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.289085 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.289180 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.289281 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.289379 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.289479 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.289594 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.289739 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: 02:41:11.289769 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: 02:41:11.289788 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.289822 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: 02:41:11.289870 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: 02:41:11.289890 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.289907 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.289925 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.289948 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.289966 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.289986 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: 02:41:11.290002 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.290019 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:41:11.290060 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271290040849 2:1741747271290040849 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:41:11.290169 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 02:41:11.290244 delete from "invoice_test"; [] +gorptest: 02:41:11.290292 delete from "invoice_tag_test"; [] +gorptest: 02:41:11.290340 delete from "alias_trans_field_test"; [] +gorptest: 02:41:11.290386 delete from "invoice_override_test"; [] +gorptest: 02:41:11.290437 delete from "person_test"; [] +gorptest: 02:41:11.290482 delete from "ignored_column_test"; [] +gorptest: 02:41:11.290527 delete from "id_created_test"; [] +gorptest: 02:41:11.290571 delete from "type_conv_test"; [] +gorptest: 02:41:11.290617 delete from "embedded_struct_test"; [] +gorptest: 02:41:11.290665 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.290709 delete from "embedded_autoincr_test"; [] +gorptest: 02:41:11.290754 delete from "time_test"; [] +gorptest: 02:41:11.290797 delete from "id_created_test"; [] +gorptest: 02:41:11.290841 SELECT * FROM person_test [] +gorptest: 02:41:11.290904 SELECT * FROM invoice_test [] +gorptest: 02:41:11.290940 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.291048 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.291136 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.291218 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.291482 drop table if exists "person_test"; [] +gorptest: 02:41:11.291589 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.291675 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.291754 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.291833 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.291911 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.291990 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.292068 drop table if exists "time_test"; [] +gorptest: 02:41:11.292146 drop table if exists "id_created_test"; [] +--- PASS: TestTruncateTables (0.00s) === RUN TestCustomDateType -gorptest: 09:02:44.662405 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 09:02:44.663260 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2026-04-14 09:02:44 +0000 UTC] -gorptest: 09:02:44.663528 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 09:02:44.663671 drop table if exists "WithCustomDate"; [] +gorptest: 02:41:11.292262 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 02:41:11.292559 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-03-12 02:41:11 +0000 UTC] +gorptest: 02:41:11.292654 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 02:41:11.292716 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey -gorptest: 09:02:44.664127 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 09:02:44.664751 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 09:02:44.665032 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 09:02:44.665365 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 09:02:44.665594 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 09:02:44.665796 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 09:02:44.665977 drop table if exists "PersonUInt64"; [] -gorptest: 09:02:44.666236 drop table if exists "PersonUInt32"; [] -gorptest: 09:02:44.666478 drop table if exists "PersonUInt16"; [] +gorptest: 02:41:11.292893 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:41:11.293144 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:41:11.293251 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 02:41:11.293357 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 02:41:11.293433 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 02:41:11.293495 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 02:41:11.293554 drop table if exists "PersonUInt64"; [] +gorptest: 02:41:11.293682 drop table if exists "PersonUInt32"; [] +gorptest: 02:41:11.293776 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether -gorptest: 09:02:44.666945 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 09:02:44.668093 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 09:02:44.668344 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 09:02:44.668475 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 09:02:44.668581 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 09:02:44.668771 drop table if exists "UniqueColumns"; [] +gorptest: 02:41:11.294183 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 02:41:11.294490 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 02:41:11.294575 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 02:41:11.294627 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 02:41:11.294659 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 02:41:11.294730 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser -gorptest: 09:02:44.669396 drop table if exists PersistentUser [] -gorptest: 09:02:44.669820 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 09:02:44.670144 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 09:02:44.670323 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 09:02:44.670432 select * from PersistentUser [] -gorptest: 09:02:44.670536 select * from PersistentUser [] -gorptest: 09:02:44.670821 select * from PersistentUser [] -gorptest: 09:02:44.670969 select Id from PersistentUser [] -gorptest: 09:02:44.671043 select mykey from PersistentUser [] -gorptest: 09:02:44.671114 select PassedTraining from PersistentUser [] -gorptest: 09:02:44.671178 select Id from PersistentUser [] -gorptest: 09:02:44.671240 drop table if exists "PersistentUser"; [] +gorptest: 02:41:11.295004 drop table if exists PersistentUser [] +gorptest: 02:41:11.295169 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:41:11.295305 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:41:11.295382 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 02:41:11.295433 select * from PersistentUser [] +gorptest: 02:41:11.295477 select * from PersistentUser [] +gorptest: 02:41:11.295510 select * from PersistentUser [] +gorptest: 02:41:11.295542 select Id from PersistentUser [] +gorptest: 02:41:11.295565 select mykey from PersistentUser [] +gorptest: 02:41:11.295588 select PassedTraining from PersistentUser [] +gorptest: 02:41:11.295612 select Id from PersistentUser [] +gorptest: 02:41:11.295633 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap -gorptest: 09:02:44.672053 drop table if exists PersistentUser [] -gorptest: 09:02:44.672446 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 09:02:44.672741 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 09:02:44.672906 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 09:02:44.673087 select * from PersistentUser where mykey = ? [1:43] -gorptest: 09:02:44.673214 select * from PersistentUser where mykey = ? [1:43] -gorptest: 09:02:44.673314 +gorptest: 02:41:11.295782 drop table if exists PersistentUser [] +gorptest: 02:41:11.295935 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:41:11.296071 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:41:11.296147 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 02:41:11.296225 select * from PersistentUser where mykey = ? [1:43] +gorptest: 02:41:11.296285 select * from PersistentUser where mykey = ? [1:43] +gorptest: 02:41:11.296327 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 09:02:44.673415 +gorptest: 02:41:11.296370 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 09:02:44.673501 drop table if exists "PersistentUser"; [] +gorptest: 02:41:11.296408 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct -gorptest: 09:02:44.673864 drop table if exists PersistentUser [] -gorptest: 09:02:44.674249 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 09:02:44.674548 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 09:02:44.674850 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 09:02:44.675038 +gorptest: 02:41:11.296558 drop table if exists PersistentUser [] +gorptest: 02:41:11.296701 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 02:41:11.296828 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 02:41:11.296902 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 02:41:11.296965 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 09:02:44.675172 drop table if exists "PersistentUser"; [] +gorptest: 02:41:11.297020 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice -2026/04/14 09:02:44 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: 09:02:44.676139 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.676459 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.676510 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.676543 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.676580 drop table if exists "person_test"; [] -gorptest: 09:02:44.676620 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.676657 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.676694 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.676731 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.676770 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.676814 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.676847 drop table if exists "time_test"; [] -gorptest: 09:02:44.676889 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.677175 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: 09:02:44.677431 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.677666 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.677946 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.678185 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.678409 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.678658 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.678900 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.679138 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.679440 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.679974 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.680221 select * from invoice_test where id=99999 [] -gorptest: 09:02:44.680331 select * from invoice_test where id=99999 [] -gorptest: 09:02:44.680416 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.680616 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.680807 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.680988 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.681264 drop table if exists "person_test"; [] -gorptest: 09:02:44.681457 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.681642 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.681818 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.681994 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.682169 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.682350 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.682528 drop table if exists "time_test"; [] -gorptest: 09:02:44.682811 drop table if exists "id_created_test"; [] ---- PASS: TestReturnsNonNilSlice (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.297202 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.297334 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.297358 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.297373 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.297387 drop table if exists "person_test"; [] +gorptest: 02:41:11.297400 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.297414 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.297428 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.297441 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.297454 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.297468 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.297484 drop table if exists "time_test"; [] +gorptest: 02:41:11.297502 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.297655 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: 02:41:11.297784 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.298063 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.298215 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.298329 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.298428 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.298531 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.298639 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.298744 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.298847 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.298959 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.299070 select * from invoice_test where id=99999 [] +gorptest: 02:41:11.299125 select * from invoice_test where id=99999 [] +gorptest: 02:41:11.299162 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.299258 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.299347 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.299435 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.299600 drop table if exists "person_test"; [] +gorptest: 02:41:11.299701 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.299789 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.299871 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.299954 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.300038 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.300119 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.300202 drop table if exists "time_test"; [] +gorptest: 02:41:11.300282 drop table if exists "id_created_test"; [] +--- PASS: TestReturnsNonNilSlice (0.00s) === RUN TestOverrideVersionCol -gorptest: 09:02:44.683038 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 09:02:44.684181 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: 09:02:44.684291 drop table if exists "InvoicePersonView"; [] +gorptest: 02:41:11.300413 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 02:41:11.300739 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: 02:41:11.300795 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking -2026/04/14 09:02:44 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: 09:02:44.684804 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.685089 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.685149 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.685183 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.685215 drop table if exists "person_test"; [] -gorptest: 09:02:44.685245 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.685275 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.685305 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.685334 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.685364 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.685393 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.685422 drop table if exists "time_test"; [] -gorptest: 09:02:44.685461 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.685715 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: 09:02:44.685960 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.686189 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.686456 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.686721 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.686955 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.687172 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.687455 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.688256 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.688487 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.688704 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.688945 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364688922406 2:1776157364688922406 3:"Bob" 4:"Smith" 5:1] -gorptest: 09:02:44.689120 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.689249 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1776157364688922406 2:1776157364688922406 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 09:02:44.689413 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1776157364688922406 2:1776157364688922406 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 09:02:44.689487 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.689578 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 09:02:44.689631 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.689702 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.689881 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.690058 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.690227 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.690482 drop table if exists "person_test"; [] -gorptest: 09:02:44.690997 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.691203 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.691440 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.691913 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.692090 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.692252 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.692406 drop table if exists "time_test"; [] -gorptest: 09:02:44.692557 drop table if exists "id_created_test"; [] ---- PASS: TestOptimisticLocking (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.301047 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.301188 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.301205 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.301219 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.301236 drop table if exists "person_test"; [] +gorptest: 02:41:11.301251 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.301265 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.301278 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.301293 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.301309 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.301323 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.301337 drop table if exists "time_test"; [] +gorptest: 02:41:11.301357 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.301492 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: 02:41:11.301602 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.301744 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.302034 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.302170 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.302280 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.302388 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.302497 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.302600 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.302704 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.302811 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.302946 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271302922292 2:1741747271302922292 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:41:11.303043 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.303111 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1741747271302922292 2:1741747271302922292 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 02:41:11.303188 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1741747271302922292 2:1741747271302922292 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 02:41:11.303221 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.303264 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 02:41:11.303292 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.303332 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.303428 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.303515 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.303598 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.303738 drop table if exists "person_test"; [] +gorptest: 02:41:11.303835 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.303920 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.304000 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.304082 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.304165 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.304247 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.304328 drop table if exists "time_test"; [] +gorptest: 02:41:11.304403 drop table if exists "id_created_test"; [] +--- PASS: TestOptimisticLocking (0.00s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 09:02:44.692829 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 09:02:44.693306 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 09:02:44.693463 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 09:02:44.693609 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: 09:02:44.693769 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 09:02:44.693882 drop table if exists "TableWithNull"; [] +gorptest: 02:41:11.304536 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 02:41:11.304801 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 02:41:11.304876 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 02:41:11.304963 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: 02:41:11.305059 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 02:41:11.305126 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps -gorptest: 09:02:44.694189 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 09:02:44.694749 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 09:02:44.694941 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 09:02:44.695048 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 09:02:44.695129 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 09:02:44.695187 drop table if exists "Invoice"; [] +gorptest: 02:41:11.305304 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 02:41:11.305590 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 02:41:11.305718 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 02:41:11.305774 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 02:41:11.305921 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 02:41:11.305981 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect -2026/04/14 09:02:44 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: 09:02:44.696031 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.696290 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.696327 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.696353 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.696379 drop table if exists "person_test"; [] -gorptest: 09:02:44.696409 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.696439 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.696469 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.696497 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.696526 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.696555 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.696584 drop table if exists "time_test"; [] -gorptest: 09:02:44.696621 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.696855 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: 09:02:44.697060 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.697251 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.697471 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.697660 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.697835 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.698011 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.698192 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.698370 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.698553 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.698765 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.698983 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364698951286 2:1776157364698951286 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.699144 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 09:02:44.699269 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 09:02:44.699458 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.700073 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.700251 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.700405 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.700628 drop table if exists "person_test"; [] -gorptest: 09:02:44.700792 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.700936 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.701077 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.701223 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.701365 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.701506 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.701650 drop table if exists "time_test"; [] -gorptest: 09:02:44.701786 drop table if exists "id_created_test"; [] ---- PASS: TestRawSelect (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.306298 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.306445 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.306461 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.306476 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.306491 drop table if exists "person_test"; [] +gorptest: 02:41:11.306505 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.306521 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.306535 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.306548 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.306565 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.306579 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.306595 drop table if exists "time_test"; [] +gorptest: 02:41:11.306615 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.306757 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: 02:41:11.306876 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.306988 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.307126 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.307245 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.307356 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.307465 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.307569 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.307672 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.307774 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.307880 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.307999 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271307978684 2:1741747271307978684 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.308090 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 02:41:11.308159 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 02:41:11.308229 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.308335 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.308446 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.308538 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.308685 drop table if exists "person_test"; [] +gorptest: 02:41:11.308790 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.308883 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.308964 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.309047 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.309127 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.309204 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.309285 drop table if exists "time_test"; [] +gorptest: 02:41:11.309365 drop table if exists "id_created_test"; [] +--- PASS: TestRawSelect (0.00s) === RUN TestHooks -2026/04/14 09:02:44 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: 09:02:44.702028 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.702278 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.702315 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.702340 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.702369 drop table if exists "person_test"; [] -gorptest: 09:02:44.702397 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.702435 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.702460 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.702483 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.702507 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.702530 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.702554 drop table if exists "time_test"; [] -gorptest: 09:02:44.702586 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.702990 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: 09:02:44.703189 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.703421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.704006 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.704198 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.704365 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.704530 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.704699 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.704869 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.705039 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.705239 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.705439 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364705421606 2:1776157364705421606 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.705581 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.705679 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1776157364705421606 2:1776157364705421606 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 09:02:44.705798 select * from person_test where id = ? [1:1] -gorptest: 09:02:44.705904 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 09:02:44.706021 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.706171 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.706312 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.706449 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.706689 drop table if exists "person_test"; [] -gorptest: 09:02:44.706852 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.706993 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.707134 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.707267 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.707463 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.707938 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.708094 drop table if exists "time_test"; [] -gorptest: 09:02:44.708229 drop table if exists "id_created_test"; [] ---- PASS: TestHooks (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.309501 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.309673 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.309691 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.309706 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.309720 drop table if exists "person_test"; [] +gorptest: 02:41:11.309735 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.309747 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.309765 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.309778 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.309792 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.309955 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.309997 drop table if exists "time_test"; [] +gorptest: 02:41:11.310030 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.310195 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: 02:41:11.310312 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.310418 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.310552 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.310664 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.310764 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.310868 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.310977 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.311081 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.311184 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.311293 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.311415 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271311403146 2:1741747271311403146 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.311507 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.311571 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1741747271311403146 2:1741747271311403146 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 02:41:11.311645 select * from person_test where id = ? [1:1] +gorptest: 02:41:11.311708 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 02:41:11.311775 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.311867 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.311953 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.312034 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.312181 drop table if exists "person_test"; [] +gorptest: 02:41:11.312278 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.312361 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.312444 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.312527 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.312608 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.312685 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.312766 drop table if exists "time_test"; [] +gorptest: 02:41:11.312843 drop table if exists "id_created_test"; [] +--- PASS: TestHooks (0.00s) === RUN TestTransaction -2026/04/14 09:02:44 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: 09:02:44.708476 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.708715 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.708752 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.708781 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.708804 drop table if exists "person_test"; [] -gorptest: 09:02:44.708826 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.708851 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.708873 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.708910 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.708938 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.708996 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.709025 drop table if exists "time_test"; [] -gorptest: 09:02:44.709060 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.709287 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: 09:02:44.709476 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.709645 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.709852 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.710021 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.710179 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.710338 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.710502 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.710691 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.710864 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.711030 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.711193 begin; [] -gorptest: 09:02:44.711267 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 09:02:44.711440 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 09:02:44.711513 commit; [] -gorptest: 09:02:44.711607 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.712112 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 09:02:44.712176 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.712349 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.712506 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.712642 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.712850 drop table if exists "person_test"; [] -gorptest: 09:02:44.713013 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.713149 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.713278 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.713406 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.713531 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.713665 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.713797 drop table if exists "time_test"; [] -gorptest: 09:02:44.713925 drop table if exists "id_created_test"; [] ---- PASS: TestTransaction (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.313003 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.313158 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.313175 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.313188 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.313202 drop table if exists "person_test"; [] +gorptest: 02:41:11.313217 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.313231 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.313244 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.313264 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.313279 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.313292 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.313306 drop table if exists "time_test"; [] +gorptest: 02:41:11.313324 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.313466 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: 02:41:11.313580 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.313723 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.313991 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.314128 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.314234 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.314339 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.314445 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.314549 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.314648 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.314750 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.314851 begin; [] +gorptest: 02:41:11.314885 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 02:41:11.314956 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 02:41:11.314974 commit; [] +gorptest: 02:41:11.315019 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.315075 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 02:41:11.315107 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.315206 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.315294 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.315374 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.315526 drop table if exists "person_test"; [] +gorptest: 02:41:11.315623 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.315703 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.315791 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.315874 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.315957 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.316038 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.316120 drop table if exists "time_test"; [] +gorptest: 02:41:11.316200 drop table if exists "id_created_test"; [] +--- PASS: TestTransaction (0.00s) === RUN TestSavepoint -2026/04/14 09:02:44 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: 09:02:44.714156 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.714381 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.714415 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.714436 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.714464 drop table if exists "person_test"; [] -gorptest: 09:02:44.714488 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.714513 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.714534 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.714558 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.714585 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.714607 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.714653 drop table if exists "time_test"; [] -gorptest: 09:02:44.714688 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.714898 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: 09:02:44.715071 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.715232 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.715483 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.715979 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.716145 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.716298 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.716454 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.716607 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.716775 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.716937 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.717088 begin; [] -gorptest: 09:02:44.717143 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 09:02:44.717230 select memo from invoice_test [] -gorptest: 09:02:44.717283 savepoint "foo" [1:] -gorptest: 09:02:44.717299 select memo from invoice_test [] -gorptest: 09:02:44.717336 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 09:02:44.717368 select memo from invoice_test [] -gorptest: 09:02:44.717392 rollback to savepoint "foo" [1:] -gorptest: 09:02:44.717408 select memo from invoice_test [] -gorptest: 09:02:44.717427 rollback; [] -gorptest: 09:02:44.717483 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.717627 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.717766 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.717911 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.718124 drop table if exists "person_test"; [] -gorptest: 09:02:44.718271 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.718399 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.718526 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.718766 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.718923 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.719062 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.719192 drop table if exists "time_test"; [] -gorptest: 09:02:44.719313 drop table if exists "id_created_test"; [] ---- PASS: TestSavepoint (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.316354 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.316509 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.316525 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.316539 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.316551 drop table if exists "person_test"; [] +gorptest: 02:41:11.316567 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.316579 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.316592 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.316605 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.316619 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.316632 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.316645 drop table if exists "time_test"; [] +gorptest: 02:41:11.316664 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.316815 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: 02:41:11.316929 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.317030 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.317151 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.317254 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.317350 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.317446 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.317548 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.317680 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.317800 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.318025 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.318146 begin; [] +gorptest: 02:41:11.318175 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 02:41:11.318233 select memo from invoice_test [] +gorptest: 02:41:11.318263 savepoint "foo" [1:] +gorptest: 02:41:11.318270 select memo from invoice_test [] +gorptest: 02:41:11.318294 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 02:41:11.318314 select memo from invoice_test [] +gorptest: 02:41:11.318333 rollback to savepoint "foo" [1:] +gorptest: 02:41:11.318341 select memo from invoice_test [] +gorptest: 02:41:11.318353 rollback; [] +gorptest: 02:41:11.318390 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.318489 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.318573 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.318664 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.318822 drop table if exists "person_test"; [] +gorptest: 02:41:11.318920 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.319004 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.319083 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.319160 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.319240 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.319326 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.319409 drop table if exists "time_test"; [] +gorptest: 02:41:11.319487 drop table if exists "id_created_test"; [] +--- PASS: TestSavepoint (0.00s) === RUN TestMultiple -2026/04/14 09:02:44 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: 09:02:44.719680 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.720233 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.720294 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.720340 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.720388 drop table if exists "person_test"; [] -gorptest: 09:02:44.720432 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.720475 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.720520 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.720565 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.720613 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.720658 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.720703 drop table if exists "time_test"; [] -gorptest: 09:02:44.720763 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.721152 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: 09:02:44.721484 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.721786 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.722140 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.722433 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.722828 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.723141 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.723470 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.723803 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.724100 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.724381 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.724675 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 09:02:44.724909 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 09:02:44.725116 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 09:02:44.725307 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 09:02:44.725489 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.725655 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 09:02:44.725803 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.726128 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.726396 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.726684 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.727086 drop table if exists "person_test"; [] -gorptest: 09:02:44.727367 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.727620 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.727854 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.728079 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.728301 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.728518 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.728751 drop table if exists "time_test"; [] -gorptest: 09:02:44.728973 drop table if exists "id_created_test"; [] ---- PASS: TestMultiple (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.319655 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.319819 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.319836 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.319849 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.319864 drop table if exists "person_test"; [] +gorptest: 02:41:11.319877 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.319890 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.319903 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.319917 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.319933 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.319947 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.319961 drop table if exists "time_test"; [] +gorptest: 02:41:11.319979 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.320111 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: 02:41:11.320222 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.320323 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.320446 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.320551 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.320652 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.320763 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.320869 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.320974 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.321076 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.321177 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.321299 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 02:41:11.321387 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 02:41:11.321461 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 02:41:11.321529 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 02:41:11.321595 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.321685 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 02:41:11.321746 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.321974 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.322087 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.322170 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.322308 drop table if exists "person_test"; [] +gorptest: 02:41:11.322404 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.322486 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.322568 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.322650 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.322730 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.322810 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.322887 drop table if exists "time_test"; [] +gorptest: 02:41:11.322964 drop table if exists "id_created_test"; [] +--- PASS: TestMultiple (0.00s) === RUN TestCrud -2026/04/14 09:02:44 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: 09:02:44.729285 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.729722 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.729819 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.729873 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.729919 drop table if exists "person_test"; [] -gorptest: 09:02:44.729962 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.730007 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.730045 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.730083 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.730122 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.730167 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.730210 drop table if exists "time_test"; [] -gorptest: 09:02:44.730267 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.730618 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: 09:02:44.730944 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.731224 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.731581 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.731871 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.732136 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.732404 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.732676 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.732956 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.733232 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.733508 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.733778 delete from invoice_test [] -gorptest: 09:02:44.733961 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 09:02:44.734171 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.734346 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:3021576060891696039 2:2154642842954751133 3:"random 2165631431901382647" 4:0 5:true 6:1] -gorptest: 09:02:44.734540 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.734677 select * from invoice_test [] -gorptest: 09:02:44.734828 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.735011 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 09:02:44.735100 delete from invoice_tag_test [] -gorptest: 09:02:44.735269 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: 09:02:44.735502 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 09:02:44.735653 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:2212620064667396559 2:5246229817246601909 3:"random 4749411672811906467" 4:33 5:false 6:1] -gorptest: 09:02:44.735858 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 09:02:44.735971 select * from invoice_tag_test [] -gorptest: 09:02:44.736119 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 09:02:44.736293 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 09:02:44.736382 delete from alias_trans_field_test [] -gorptest: 09:02:44.736536 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 09:02:44.736722 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 09:02:44.736834 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 5769054879597690616" 2:1] -gorptest: 09:02:44.737002 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 09:02:44.737092 select * from alias_trans_field_test [] -gorptest: 09:02:44.737190 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 09:02:44.737352 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 09:02:44.737431 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.737693 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.737942 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.738181 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.738566 drop table if exists "person_test"; [] -gorptest: 09:02:44.738851 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.739085 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.739312 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.739999 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.740239 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.740456 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.740665 drop table if exists "time_test"; [] -gorptest: 09:02:44.740870 drop table if exists "id_created_test"; [] ---- PASS: TestCrud (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.323113 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.323260 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.323276 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.323289 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.323303 drop table if exists "person_test"; [] +gorptest: 02:41:11.323326 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.323340 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.323354 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.323371 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.323385 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.323400 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.323413 drop table if exists "time_test"; [] +gorptest: 02:41:11.323431 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.323562 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: 02:41:11.323671 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.323785 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.323913 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.324018 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.324116 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.324211 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.324308 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.324407 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.324507 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.324607 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.324707 delete from invoice_test [] +gorptest: 02:41:11.324779 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 02:41:11.324867 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.324949 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:2694005006886540804 2:2005080882202648600 3:"random 1673213148957585487" 4:0 5:true 6:1] +gorptest: 02:41:11.325033 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.325073 select * from invoice_test [] +gorptest: 02:41:11.325126 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.325189 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 02:41:11.325220 delete from invoice_tag_test [] +gorptest: 02:41:11.325283 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: 02:41:11.325358 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:41:11.325410 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:1223137195285498331 2:895626925390828378 3:"random 8427435627937857805" 4:33 5:false 6:1] +gorptest: 02:41:11.325479 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:41:11.325517 select * from invoice_tag_test [] +gorptest: 02:41:11.325565 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:41:11.325659 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 02:41:11.325698 delete from alias_trans_field_test [] +gorptest: 02:41:11.325760 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 02:41:11.326237 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:41:11.326320 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 4949173799058500351" 2:1] +gorptest: 02:41:11.326401 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:41:11.326435 select * from alias_trans_field_test [] +gorptest: 02:41:11.326472 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:41:11.326533 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 02:41:11.326561 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.326658 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.326744 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.326828 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.326975 drop table if exists "person_test"; [] +gorptest: 02:41:11.327067 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.327148 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.327226 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.327302 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.327383 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.327461 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.327539 drop table if exists "time_test"; [] +gorptest: 02:41:11.327616 drop table if exists "id_created_test"; [] +--- PASS: TestCrud (0.00s) === RUN TestWithIgnoredColumn -2026/04/14 09:02:44 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: 09:02:44.741172 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.741512 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.741564 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.741605 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.741647 drop table if exists "person_test"; [] -gorptest: 09:02:44.741687 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.741728 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.741769 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.741810 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.741849 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.741888 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.741929 drop table if exists "time_test"; [] -gorptest: 09:02:44.741979 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.742285 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: 09:02:44.742556 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.742859 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.743168 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.743512 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.744144 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.744410 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.744670 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.744924 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.745180 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.745431 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.745690 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 09:02:44.745883 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 09:02:44.745996 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 09:02:44.746156 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 09:02:44.746236 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.746452 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.746736 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.746962 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.747248 drop table if exists "person_test"; [] -gorptest: 09:02:44.747544 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.748143 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.748356 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.748561 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.748756 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.748947 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.749140 drop table if exists "time_test"; [] -gorptest: 09:02:44.749330 drop table if exists "id_created_test"; [] ---- PASS: TestWithIgnoredColumn (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.327779 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.327935 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.327951 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.327966 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.327978 drop table if exists "person_test"; [] +gorptest: 02:41:11.327991 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.328004 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.328017 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.328031 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.328043 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.328056 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.328069 drop table if exists "time_test"; [] +gorptest: 02:41:11.328087 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.328223 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: 02:41:11.328334 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.328436 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.328558 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.328665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.328767 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.328863 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.328964 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.329078 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.329196 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.329303 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.329410 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 02:41:11.329485 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:41:11.329534 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:41:11.329598 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 02:41:11.329662 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.329769 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.330555 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.330682 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.330841 drop table if exists "person_test"; [] +gorptest: 02:41:11.330942 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.331030 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.331110 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.331188 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.331267 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.331345 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.331430 drop table if exists "time_test"; [] +gorptest: 02:41:11.331512 drop table if exists "id_created_test"; [] +--- PASS: TestWithIgnoredColumn (0.00s) === RUN TestTypeConversionExample -2026/04/14 09:02:44 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: 09:02:44.749629 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.749938 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.749994 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.750034 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.750071 drop table if exists "person_test"; [] -gorptest: 09:02:44.750109 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.750150 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.750188 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.750225 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.750263 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.750300 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.750336 drop table if exists "time_test"; [] -gorptest: 09:02:44.750384 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.750689 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: 09:02:44.750950 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.751186 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.751951 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.752218 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.752440 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.752653 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.752872 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.753094 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.753318 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.753538 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.753919 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: 09:02:44.754108 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 09:02:44.754246 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: 09:02:44.754398 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 09:02:44.754496 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 09:02:44.754694 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.754891 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.755077 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.755256 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.755569 drop table if exists "person_test"; [] -gorptest: 09:02:44.756058 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.756247 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.756416 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.756599 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.756767 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.756934 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.757100 drop table if exists "time_test"; [] -gorptest: 09:02:44.757259 drop table if exists "id_created_test"; [] ---- PASS: TestTypeConversionExample (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.331681 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.331851 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.331866 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.331880 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.331899 drop table if exists "person_test"; [] +gorptest: 02:41:11.331912 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.331925 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.331938 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.331950 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.331964 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.331976 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.331993 drop table if exists "time_test"; [] +gorptest: 02:41:11.332011 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.332145 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: 02:41:11.332251 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.332352 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.332476 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.332583 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.332682 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.332781 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.332884 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.332987 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.333089 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.333192 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.333431 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: 02:41:11.333534 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:41:11.333634 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: 02:41:11.333730 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:41:11.333781 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 02:41:11.334184 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.334311 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.334401 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.334488 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.334643 drop table if exists "person_test"; [] +gorptest: 02:41:11.334738 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.334820 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.334900 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.334992 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.335078 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.335158 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.335237 drop table if exists "time_test"; [] +gorptest: 02:41:11.335313 drop table if exists "id_created_test"; [] +--- PASS: TestTypeConversionExample (0.00s) === RUN TestWithEmbeddedStruct -2026/04/14 09:02:44 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: 09:02:44.757517 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.757803 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.757845 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.757878 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.757910 drop table if exists "person_test"; [] -gorptest: 09:02:44.757944 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.757972 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.758005 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.758038 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.758069 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.758102 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.758135 drop table if exists "time_test"; [] -gorptest: 09:02:44.758176 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.758421 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: 09:02:44.758659 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.758894 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.759154 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.759431 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.760451 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.760676 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.760881 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.761078 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.761273 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.761468 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.761673 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 09:02:44.761826 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 09:02:44.761941 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 09:02:44.762075 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 09:02:44.762146 select * from embedded_struct_test [] -gorptest: 09:02:44.762226 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.762399 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.762568 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.762974 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.763219 drop table if exists "person_test"; [] -gorptest: 09:02:44.763448 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.764037 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.764217 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.764382 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.764552 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.764712 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.764870 drop table if exists "time_test"; [] -gorptest: 09:02:44.765027 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStruct (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.335486 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.335655 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.335671 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.335685 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.335698 drop table if exists "person_test"; [] +gorptest: 02:41:11.335710 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.335723 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.335737 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.335761 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.335777 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.335790 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.335810 drop table if exists "time_test"; [] +gorptest: 02:41:11.335829 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.335965 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: 02:41:11.336072 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.336179 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.336307 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.336415 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.336511 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.336613 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.336719 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.336820 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.336921 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.337020 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.337132 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 02:41:11.337232 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 02:41:11.337304 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 02:41:11.337381 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 02:41:11.337422 select * from embedded_struct_test [] +gorptest: 02:41:11.337470 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.337568 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.337686 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.337781 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.338284 drop table if exists "person_test"; [] +gorptest: 02:41:11.338412 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.338499 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.338578 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.338666 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.338751 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.338835 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.338913 drop table if exists "time_test"; [] +gorptest: 02:41:11.338990 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStruct (0.00s) === RUN TestWithEmbeddedStructBeforeAutoincr -2026/04/14 09:02:44 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: 09:02:44.765294 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.765557 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.765598 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.765625 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.765659 drop table if exists "person_test"; [] -gorptest: 09:02:44.765691 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.765722 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.765752 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.765782 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.765813 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.765853 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.765884 drop table if exists "time_test"; [] -gorptest: 09:02:44.765923 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.766153 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: 09:02:44.766358 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.766548 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.766804 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.767009 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.767194 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.767436 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.767915 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.768120 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.768309 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.768494 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.768689 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 09:02:44.768830 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.768986 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.769138 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.769289 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.769499 drop table if exists "person_test"; [] -gorptest: 09:02:44.769656 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.769806 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.769952 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.770111 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.770262 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.770434 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.770582 drop table if exists "time_test"; [] -gorptest: 09:02:44.770749 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.339143 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.339305 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.339320 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.339334 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.339350 drop table if exists "person_test"; [] +gorptest: 02:41:11.339363 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.339378 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.339391 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.339405 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.339419 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.339432 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.339446 drop table if exists "time_test"; [] +gorptest: 02:41:11.339466 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.339600 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: 02:41:11.339712 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.339814 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.339934 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.340047 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.340148 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.340249 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.340348 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.340450 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.340550 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.340651 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.340760 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 02:41:11.340836 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.340921 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.341007 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.341087 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.341248 drop table if exists "person_test"; [] +gorptest: 02:41:11.341346 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.341427 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.341507 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.341584 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.341697 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.342094 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.342278 drop table if exists "time_test"; [] +gorptest: 02:41:11.342375 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.00s) === RUN TestWithEmbeddedAutoincr -2026/04/14 09:02:44 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: 09:02:44.771084 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.771389 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.771442 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.771478 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.771508 drop table if exists "person_test"; [] -gorptest: 09:02:44.771537 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.771565 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.771593 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.771623 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.771677 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.771714 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.771743 drop table if exists "time_test"; [] -gorptest: 09:02:44.771781 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.772038 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: 09:02:44.772237 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.772423 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.772637 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.772819 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.772986 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.773153 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.773325 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.773494 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.773665 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.773840 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.774035 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 09:02:44.774169 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.774321 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.774468 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.774619 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.774871 drop table if exists "person_test"; [] -gorptest: 09:02:44.775031 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.775174 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.775316 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.775593 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.775762 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.775942 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.776096 drop table if exists "time_test"; [] -gorptest: 09:02:44.776229 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedAutoincr (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.342628 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.342812 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.342829 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.342843 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.342858 drop table if exists "person_test"; [] +gorptest: 02:41:11.342872 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.342887 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.342901 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.342914 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.342927 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.342941 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.342956 drop table if exists "time_test"; [] +gorptest: 02:41:11.342977 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.343116 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: 02:41:11.343230 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.343338 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.343463 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.343564 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.343663 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.343762 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.343865 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.343970 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.344079 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.344186 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.344307 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 02:41:11.344391 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.344480 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.344564 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.344644 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.344789 drop table if exists "person_test"; [] +gorptest: 02:41:11.344882 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.344967 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.345047 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.345128 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.345207 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.345291 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.345377 drop table if exists "time_test"; [] +gorptest: 02:41:11.345456 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedAutoincr (0.00s) === RUN TestSelectVal -gorptest: 09:02:44.776403 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 09:02:44.776834 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: 09:02:44.776966 select Int64 from TableWithNull where Str='abc' [] -gorptest: 09:02:44.777031 select count(*) from TableWithNull [] -gorptest: 09:02:44.777083 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 09:02:44.777140 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 09:02:44.777190 select Int64 from TableWithNull where Str='abc' [] -gorptest: 09:02:44.777234 select Float64 from TableWithNull where Str='abc' [] -gorptest: 09:02:44.777275 select min(Float64) from TableWithNull [] -gorptest: 09:02:44.777324 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 09:02:44.777370 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 09:02:44.777409 select Float64 from TableWithNull where Str='abc' [] -gorptest: 09:02:44.777452 select Str from TableWithNull where Int64=? [1:78] -gorptest: 09:02:44.777498 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 09:02:44.777538 select Str from TableWithNull where Int64=? [1:78] -gorptest: 09:02:44.777580 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 09:02:44.777652 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 09:02:44.777702 select Str from TableWithNull where Int64=? [1:78] -gorptest: 09:02:44.777746 drop table if exists "TableWithNull"; [] +gorptest: 02:41:11.345580 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 02:41:11.346250 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: 02:41:11.346350 select Int64 from TableWithNull where Str='abc' [] +gorptest: 02:41:11.346398 select count(*) from TableWithNull [] +gorptest: 02:41:11.346426 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 02:41:11.346453 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 02:41:11.346479 select Int64 from TableWithNull where Str='abc' [] +gorptest: 02:41:11.346508 select Float64 from TableWithNull where Str='abc' [] +gorptest: 02:41:11.346534 select min(Float64) from TableWithNull [] +gorptest: 02:41:11.346562 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 02:41:11.346589 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 02:41:11.346617 select Float64 from TableWithNull where Str='abc' [] +gorptest: 02:41:11.346640 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:41:11.346664 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 02:41:11.346689 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:41:11.346712 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 02:41:11.346738 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 02:41:11.346762 select Str from TableWithNull where Int64=? [1:78] +gorptest: 02:41:11.346785 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows -2026/04/14 09:02:44 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: 09:02:44.778075 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.778289 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.778323 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.778349 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.778390 drop table if exists "person_test"; [] -gorptest: 09:02:44.778418 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.778445 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.778471 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.778496 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.778523 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.778549 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.778574 drop table if exists "time_test"; [] -gorptest: 09:02:44.778618 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.779003 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: 09:02:44.779190 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.779560 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.779784 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.779957 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.780121 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.780280 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.780439 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.780603 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.780769 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.780931 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.781106 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364781089206 2:1776157364781089206 3:"Bob" 4:"Smith" 5:1] -gorptest: 09:02:44.781253 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364781245006 2:1776157364781245006 3:"Jane" 4:"Smith" 5:1] -gorptest: 09:02:44.781369 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364781361206 2:1776157364781361206 3:"Mike" 4:"Smith" 5:1] -gorptest: 09:02:44.781475 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.781616 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.781750 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.781881 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.782064 drop table if exists "person_test"; [] -gorptest: 09:02:44.782209 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.782345 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.782475 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.782603 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.782754 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.782886 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.783014 drop table if exists "time_test"; [] -gorptest: 09:02:44.783147 drop table if exists "id_created_test"; [] ---- PASS: TestVersionMultipleRows (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.347030 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.347192 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.347209 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.347223 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.347237 drop table if exists "person_test"; [] +gorptest: 02:41:11.347252 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.347265 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.347278 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.347291 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.347304 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.347316 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.347330 drop table if exists "time_test"; [] +gorptest: 02:41:11.347348 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.347486 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: 02:41:11.347604 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.347706 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.347828 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.347933 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.348031 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.348125 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.348223 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.348323 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.348425 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.348527 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.348640 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271348628465 2:1741747271348628465 3:"Bob" 4:"Smith" 5:1] +gorptest: 02:41:11.348725 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271348720065 2:1741747271348720065 3:"Jane" 4:"Smith" 5:1] +gorptest: 02:41:11.348798 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271348793506 2:1741747271348793506 3:"Mike" 4:"Smith" 5:1] +gorptest: 02:41:11.348862 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.348952 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.349038 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.349122 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.349276 drop table if exists "person_test"; [] +gorptest: 02:41:11.349377 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.349460 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.349539 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.349640 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.349739 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.350158 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.350306 drop table if exists "time_test"; [] +gorptest: 02:41:11.350394 drop table if exists "id_created_test"; [] +--- PASS: TestVersionMultipleRows (0.00s) === RUN TestWithStringPk -gorptest: 09:02:44.783314 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 09:02:44.784005 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 09:02:44.784116 drop table if exists "string_pk_test"; [] +gorptest: 02:41:11.350524 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 02:41:11.350902 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 02:41:11.350976 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2026/04/14 09:02:44 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: 09:02:44.784656 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.784871 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.784906 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.784930 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.784964 drop table if exists "person_test"; [] -gorptest: 09:02:44.784989 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.785015 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.785039 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.785064 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.785089 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.785112 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.785135 drop table if exists "time_test"; [] -gorptest: 09:02:44.785167 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.785362 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: 09:02:44.785529 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.785684 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.785869 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.786023 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.786167 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.786315 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.786469 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.786617 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.786825 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.786988 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.787154 insert into "time_test" ("Id","Time") values (null,?); [1:2026-04-14 08:31:44.787135166 +0000 UTC] -gorptest: 09:02:44.787273 insert into "time_test" ("Id","Time") values (null,?); [1:2026-04-14 08:32:45.787135166 +0000 UTC] -gorptest: 09:02:44.787594 SELECT id FROM time_test WHERE Time < ? [1:2026-04-14 08:32:44.787135166 +0000 UTC] -gorptest: 09:02:44.787696 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.787846 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.787979 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.788104 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.788272 drop table if exists "person_test"; [] -gorptest: 09:02:44.788397 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.788522 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.788642 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.788758 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.788876 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.788995 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.789112 drop table if exists "time_test"; [] -gorptest: 09:02:44.789232 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.351319 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.351480 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.351498 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.351511 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.351525 drop table if exists "person_test"; [] +gorptest: 02:41:11.351537 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.351550 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.351563 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.351576 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.351589 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.351602 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.351615 drop table if exists "time_test"; [] +gorptest: 02:41:11.351638 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.351772 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: 02:41:11.351881 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.351982 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.352108 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.352215 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.352313 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.352409 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.352520 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.352629 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.352732 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.352835 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.352948 insert into "time_test" ("Id","Time") values (null,?); [1:2025-03-12 02:10:11.352933332 +0000 UTC] +gorptest: 02:41:11.353032 insert into "time_test" ("Id","Time") values (null,?); [1:2025-03-12 02:11:12.352933332 +0000 UTC] +gorptest: 02:41:11.353105 SELECT id FROM time_test WHERE Time < ? [1:2025-03-12 02:11:11.352933332 +0000 UTC] +gorptest: 02:41:11.353165 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.353268 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.353358 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.353441 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.353593 drop table if exists "person_test"; [] +gorptest: 02:41:11.353740 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.354221 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.354382 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.354472 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.354559 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.354652 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.354731 drop table if exists "time_test"; [] +gorptest: 02:41:11.354818 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.00s) === RUN TestInvoicePersonView -2026/04/14 09:02:44 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: 09:02:44.789437 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.789639 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.789673 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.789698 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.789721 drop table if exists "person_test"; [] -gorptest: 09:02:44.789744 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.789768 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.789790 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.789812 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.789838 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.789861 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.789889 drop table if exists "time_test"; [] -gorptest: 09:02:44.789920 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.790100 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: 09:02:44.790256 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.790402 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.790577 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.790910 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.791069 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.791215 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.791552 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.791726 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.791882 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.792023 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.792178 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364792162806 2:1776157364792162806 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.792313 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 09:02:44.792420 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 09:02:44.792527 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.792669 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.792791 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.792905 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.793077 drop table if exists "person_test"; [] -gorptest: 09:02:44.793209 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.793329 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.793443 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.793554 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.793663 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.793775 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.793886 drop table if exists "time_test"; [] -gorptest: 09:02:44.793992 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.355057 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.355238 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.355255 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.355270 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.355285 drop table if exists "person_test"; [] +gorptest: 02:41:11.355299 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.355314 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.355330 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.355344 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.355359 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.355373 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.355388 drop table if exists "time_test"; [] +gorptest: 02:41:11.355418 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.355567 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: 02:41:11.355689 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.355800 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.355930 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.356040 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.356148 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.356260 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.356371 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.356475 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.356581 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.356691 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.356819 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271356804597 2:1741747271356804597 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.356916 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 02:41:11.356988 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 02:41:11.357070 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.357180 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.357269 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.357351 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.357498 drop table if exists "person_test"; [] +gorptest: 02:41:11.357599 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.357729 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.358142 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.358293 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.358388 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.358473 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.358554 drop table if exists "time_test"; [] +gorptest: 02:41:11.358636 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.00s) === RUN TestQuoteTableNames -2026/04/14 09:02:44 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: 09:02:44.794214 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.794419 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.794449 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.794480 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.794507 drop table if exists "person_test"; [] -gorptest: 09:02:44.794529 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.794551 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.794568 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.794589 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.794634 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.794660 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.794679 drop table if exists "time_test"; [] -gorptest: 09:02:44.794710 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.794896 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: 09:02:44.795054 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.795196 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.795672 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.795845 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.795988 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.796119 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.796247 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.796384 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.796516 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.796652 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.358795 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.358956 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.358973 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.358987 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.359001 drop table if exists "person_test"; [] +gorptest: 02:41:11.359014 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.359027 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.359040 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.359054 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.359067 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.359080 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.359093 drop table if exists "time_test"; [] +gorptest: 02:41:11.359111 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.359248 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: 02:41:11.359358 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.359457 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.359581 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.359686 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.359790 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.359887 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.359992 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.360096 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.360200 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.360298 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.00s) === RUN TestSelectTooManyCols -2026/04/14 09:02:44 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: 09:02:44.798456 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.798891 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.798925 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.798948 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.798967 drop table if exists "person_test"; [] -gorptest: 09:02:44.798989 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.799011 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.799032 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.799053 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.799074 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.799094 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.799116 drop table if exists "time_test"; [] -gorptest: 09:02:44.799140 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.799319 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: 09:02:44.799660 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.799806 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.799967 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.800100 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.800228 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.800345 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.800483 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.800623 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.800792 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.800945 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.801097 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364801083206 2:1776157364801083206 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.801223 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364801206286 2:1776157364801206286 3:"jane" 4:"doe" 5:1] -gorptest: 09:02:44.801321 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.801390 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 09:02:44.801446 select * from person_test where Id=? [1:1] -gorptest: 09:02:44.801507 select * from person_test order by fname asc [] -gorptest: 09:02:44.801591 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.801718 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.801835 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.801937 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.802100 drop table if exists "person_test"; [] -gorptest: 09:02:44.802232 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.802341 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.802451 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.802554 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.802680 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.802792 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.802903 drop table if exists "time_test"; [] -gorptest: 09:02:44.803008 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.362633 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.362872 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.362889 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.362903 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.362916 drop table if exists "person_test"; [] +gorptest: 02:41:11.362930 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.362943 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.362958 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.362971 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.362985 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.362999 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.363014 drop table if exists "time_test"; [] +gorptest: 02:41:11.363042 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.363210 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: 02:41:11.363333 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.363438 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.363565 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.363672 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.363772 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.363873 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.363975 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.364076 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.364180 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.364281 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.364399 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271364379766 2:1741747271364379766 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.364492 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271364486526 2:1741747271364486526 3:"jane" 4:"doe" 5:1] +gorptest: 02:41:11.364565 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.364619 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 02:41:11.364696 select * from person_test where Id=? [1:1] +gorptest: 02:41:11.364753 select * from person_test order by fname asc [] +gorptest: 02:41:11.364808 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.364919 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.365010 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.365090 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.365241 drop table if exists "person_test"; [] +gorptest: 02:41:11.365341 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.365431 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.365511 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.365590 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.365705 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.365799 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.366225 drop table if exists "time_test"; [] +gorptest: 02:41:11.366332 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.00s) === RUN TestSelectSingleVal -2026/04/14 09:02:44 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: 09:02:44.803218 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.803626 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.803660 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.803686 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.803703 drop table if exists "person_test"; [] -gorptest: 09:02:44.803723 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.803744 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.803762 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.803782 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.803800 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.803824 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.803845 drop table if exists "time_test"; [] -gorptest: 09:02:44.803871 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.804051 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: 09:02:44.804196 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.804333 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.804490 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.804624 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.804751 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.804887 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.805020 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.805156 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.805289 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.805421 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.805568 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364805549006 2:1776157364805549006 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.805678 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 09:02:44.805755 select * from person_test where Id=? [1:1] -gorptest: 09:02:44.805826 select FName from person_test where Id=? [1:1] -gorptest: 09:02:44.805870 select * from person_test where Id=? [1:1] -gorptest: 09:02:44.805931 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 09:02:44.805984 select * from person_test where Id=? [1:-2222] -gorptest: 09:02:44.806035 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1776157364806029126 2:1776157364806029126 3:"bob" 4:"smith" 5:1] -gorptest: 09:02:44.806131 select * from person_test where Fname='bob' [] -gorptest: 09:02:44.806209 select * from person_test where Id=-123 [] -gorptest: 09:02:44.806247 select * from person_test where Id=-123 [] -gorptest: 09:02:44.806299 select * from person_test where Id=-123 [] -gorptest: 09:02:44.806332 select * from person_test where Id=-123 [] -gorptest: 09:02:44.806365 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.806484 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.806598 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.806726 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.806886 drop table if exists "person_test"; [] -gorptest: 09:02:44.807011 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.807119 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.807222 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.807326 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.807494 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.807922 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.808046 drop table if exists "time_test"; [] -gorptest: 09:02:44.808153 drop table if exists "id_created_test"; [] ---- PASS: TestSelectSingleVal (0.01s) +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.366514 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.366683 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.366700 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.366715 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.366728 drop table if exists "person_test"; [] +gorptest: 02:41:11.366749 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.366764 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.366780 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.366793 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.366807 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.366821 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.366835 drop table if exists "time_test"; [] +gorptest: 02:41:11.366856 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.366995 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: 02:41:11.367105 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.367203 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.367329 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.367433 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.367535 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.367630 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.367728 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.367842 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.367951 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.368061 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.368176 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271368163110 2:1741747271368163110 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.368260 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 02:41:11.368324 select * from person_test where Id=? [1:1] +gorptest: 02:41:11.368380 select FName from person_test where Id=? [1:1] +gorptest: 02:41:11.368407 select * from person_test where Id=? [1:1] +gorptest: 02:41:11.368450 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 02:41:11.368489 select * from person_test where Id=? [1:-2222] +gorptest: 02:41:11.368543 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1741747271368536792 2:1741747271368536792 3:"bob" 4:"smith" 5:1] +gorptest: 02:41:11.368627 select * from person_test where Fname='bob' [] +gorptest: 02:41:11.368695 select * from person_test where Id=-123 [] +gorptest: 02:41:11.368723 select * from person_test where Id=-123 [] +gorptest: 02:41:11.368744 select * from person_test where Id=-123 [] +gorptest: 02:41:11.368765 select * from person_test where Id=-123 [] +gorptest: 02:41:11.368788 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.368880 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.368965 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.369049 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.369199 drop table if exists "person_test"; [] +gorptest: 02:41:11.369297 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.369385 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.369469 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.369553 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.369665 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.369765 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.370156 drop table if exists "time_test"; [] +gorptest: 02:41:11.370281 drop table if exists "id_created_test"; [] +--- PASS: TestSelectSingleVal (0.00s) === RUN TestSelectAlias -2026/04/14 09:02:44 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: 09:02:44.808367 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.808556 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.808585 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.808607 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.808627 drop table if exists "person_test"; [] -gorptest: 09:02:44.808646 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.808665 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.808685 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.808701 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.808721 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.808740 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.808757 drop table if exists "time_test"; [] -gorptest: 09:02:44.808782 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.808953 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: 09:02:44.809093 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.809221 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.809381 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.809514 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.809635 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.809758 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.809885 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.810013 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.810151 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.810284 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.810419 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 09:02:44.810514 select * from id_created_test where Id=1 [] -gorptest: 09:02:44.810590 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 09:02:44.810667 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.811025 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.811152 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.811261 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.811520 drop table if exists "person_test"; [] -gorptest: 09:02:44.811924 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.812038 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.812145 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.812242 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.812347 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.812449 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.812553 drop table if exists "time_test"; [] -gorptest: 09:02:44.812652 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.370439 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.370600 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.370616 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.370632 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.370646 drop table if exists "person_test"; [] +gorptest: 02:41:11.370659 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.370672 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.370686 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.370700 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.370714 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.370730 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.370747 drop table if exists "time_test"; [] +gorptest: 02:41:11.370788 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.370940 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: 02:41:11.371056 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.371162 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.371285 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.371390 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.371486 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.371592 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.371698 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.371798 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.371905 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.372007 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.372123 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 02:41:11.372201 select * from id_created_test where Id=1 [] +gorptest: 02:41:11.372265 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 02:41:11.372311 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.372656 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.372760 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.372844 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.373015 drop table if exists "person_test"; [] +gorptest: 02:41:11.373115 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.373198 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.373294 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.373377 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.373461 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.373542 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.373653 drop table if exists "time_test"; [] +gorptest: 02:41:11.373749 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.00s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2026/04/14 09:02:44 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: 09:02:44.812888 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.813067 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.813095 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.813117 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.813136 drop table if exists "person_test"; [] -gorptest: 09:02:44.813152 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.813175 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.813194 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.813214 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.813233 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.813252 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.813271 drop table if exists "time_test"; [] -gorptest: 09:02:44.813296 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.813457 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: 09:02:44.813592 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.813716 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.813864 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.813992 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.814111 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.814233 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.814355 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.814482 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.814608 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.814956 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.815093 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.815201 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.815644 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.815783 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.815970 drop table if exists "person_test"; [] -gorptest: 09:02:44.816084 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.816186 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.816285 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.816380 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.816477 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.816573 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.816669 drop table if exists "time_test"; [] -gorptest: 09:02:44.816765 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.816789 drop table if exists "single_column_table"; [] -gorptest: 09:02:44.816822 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: 09:02:44.816954 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: 09:02:44.817079 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.817200 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: 09:02:44.817358 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: 09:02:44.817488 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.817613 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.817739 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.817856 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.817982 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.818107 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: 09:02:44.818227 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.818338 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 09:02:44.818367 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 09:02:44.818491 delete from "invoice_test"; [] -gorptest: 09:02:44.818556 delete from "invoice_tag_test"; [] -gorptest: 09:02:44.818614 delete from "alias_trans_field_test"; [] -gorptest: 09:02:44.818690 delete from "invoice_override_test"; [] -gorptest: 09:02:44.818755 delete from "person_test"; [] -gorptest: 09:02:44.818808 delete from "ignored_column_test"; [] -gorptest: 09:02:44.818864 delete from "id_created_test"; [] -gorptest: 09:02:44.818919 delete from "type_conv_test"; [] -gorptest: 09:02:44.818972 delete from "embedded_struct_test"; [] -gorptest: 09:02:44.819025 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.819079 delete from "embedded_autoincr_test"; [] -gorptest: 09:02:44.819137 delete from "time_test"; [] -gorptest: 09:02:44.819194 delete from "id_created_test"; [] -gorptest: 09:02:44.819243 delete from "single_column_table"; [] -gorptest: 09:02:44.819313 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 09:02:44.819404 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.819530 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.820184 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.820304 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.820480 drop table if exists "person_test"; [] -gorptest: 09:02:44.820590 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.820687 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.820779 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.820875 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.820966 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.821059 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.821147 drop table if exists "time_test"; [] -gorptest: 09:02:44.821246 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.821273 drop table if exists "single_column_table"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.374564 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.374771 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.374790 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.374804 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.374817 drop table if exists "person_test"; [] +gorptest: 02:41:11.374832 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.374845 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.374858 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.374872 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.374885 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.374897 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.374911 drop table if exists "time_test"; [] +gorptest: 02:41:11.374934 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.375083 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: 02:41:11.375195 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.375301 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.375427 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.375535 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.375636 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.375733 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.375834 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.375932 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.376037 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.376138 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.376243 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.376337 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.376425 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.376506 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.376677 drop table if exists "person_test"; [] +gorptest: 02:41:11.376775 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.376859 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.376941 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.377020 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.377112 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.377201 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.377290 drop table if exists "time_test"; [] +gorptest: 02:41:11.377367 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.377386 drop table if exists "single_column_table"; [] +gorptest: 02:41:11.377410 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: 02:41:11.377526 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: 02:41:11.377658 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.377776 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: 02:41:11.378237 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: 02:41:11.378370 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.378476 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.378579 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.378680 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.378791 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.378897 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: 02:41:11.379011 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.379107 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 02:41:11.379130 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 02:41:11.379241 delete from "invoice_test"; [] +gorptest: 02:41:11.379297 delete from "invoice_tag_test"; [] +gorptest: 02:41:11.379345 delete from "alias_trans_field_test"; [] +gorptest: 02:41:11.379392 delete from "invoice_override_test"; [] +gorptest: 02:41:11.379444 delete from "person_test"; [] +gorptest: 02:41:11.379487 delete from "ignored_column_test"; [] +gorptest: 02:41:11.379530 delete from "id_created_test"; [] +gorptest: 02:41:11.379574 delete from "type_conv_test"; [] +gorptest: 02:41:11.379619 delete from "embedded_struct_test"; [] +gorptest: 02:41:11.379665 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.379709 delete from "embedded_autoincr_test"; [] +gorptest: 02:41:11.379753 delete from "time_test"; [] +gorptest: 02:41:11.379798 delete from "id_created_test"; [] +gorptest: 02:41:11.379843 delete from "single_column_table"; [] +gorptest: 02:41:11.379903 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 02:41:11.379944 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.380041 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.380124 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.380203 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.380355 drop table if exists "person_test"; [] +gorptest: 02:41:11.380450 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.380531 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.380620 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.380702 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.380781 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.380861 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.380943 drop table if exists "time_test"; [] +gorptest: 02:41:11.381028 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.381046 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) === RUN TestPrepare -2026/04/14 09:02:44 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: 09:02:44.821608 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.821799 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.821825 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.821842 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.821863 drop table if exists "person_test"; [] -gorptest: 09:02:44.821884 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.821903 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.821920 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.821936 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.821954 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.821973 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.821987 drop table if exists "time_test"; [] -gorptest: 09:02:44.822024 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.822177 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: 09:02:44.822306 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 09:02:44.822424 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 09:02:44.822565 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 09:02:44.822715 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.822837 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 09:02:44.822959 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 09:02:44.823098 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 09:02:44.823220 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 09:02:44.823529 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 09:02:44.823679 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 09:02:44.823827 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 09:02:44.823933 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 09:02:44.824013 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 09:02:44.824102 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 09:02:44.824181 begin; [] -gorptest: 09:02:44.824210 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 09:02:44.824272 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 09:02:44.824523 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 09:02:44.824588 commit; [] -gorptest: 09:02:44.824646 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 09:02:44.824709 drop table if exists "invoice_test"; [] -gorptest: 09:02:44.824876 drop table if exists "invoice_tag_test"; [] -gorptest: 09:02:44.824995 drop table if exists "alias_trans_field_test"; [] -gorptest: 09:02:44.825093 drop table if exists "invoice_override_test"; [] -gorptest: 09:02:44.825281 drop table if exists "person_test"; [] -gorptest: 09:02:44.825399 drop table if exists "ignored_column_test"; [] -gorptest: 09:02:44.825499 drop table if exists "id_created_test"; [] -gorptest: 09:02:44.825593 drop table if exists "type_conv_test"; [] -gorptest: 09:02:44.825683 drop table if exists "embedded_struct_test"; [] -gorptest: 09:02:44.825771 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 09:02:44.825862 drop table if exists "embedded_autoincr_test"; [] -gorptest: 09:02:44.825956 drop table if exists "time_test"; [] -gorptest: 09:02:44.826051 drop table if exists "id_created_test"; [] +2025/03/12 02:41:11 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 02:41:11.381330 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.381512 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.381530 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.381543 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.381556 drop table if exists "person_test"; [] +gorptest: 02:41:11.381569 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.381582 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.381595 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.381608 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.381652 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.381667 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.381680 drop table if exists "time_test"; [] +gorptest: 02:41:11.381700 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.382133 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: 02:41:11.382293 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 02:41:11.382402 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 02:41:11.382529 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 02:41:11.382643 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.382747 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 02:41:11.382846 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 02:41:11.382944 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 02:41:11.383041 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 02:41:11.383151 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 02:41:11.383256 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 02:41:11.383373 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 02:41:11.383474 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 02:41:11.383544 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 02:41:11.383622 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 02:41:11.383689 begin; [] +gorptest: 02:41:11.383704 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 02:41:11.383756 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:41:11.383995 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:41:11.384039 commit; [] +gorptest: 02:41:11.384093 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 02:41:11.384158 drop table if exists "invoice_test"; [] +gorptest: 02:41:11.384300 drop table if exists "invoice_tag_test"; [] +gorptest: 02:41:11.384393 drop table if exists "alias_trans_field_test"; [] +gorptest: 02:41:11.384479 drop table if exists "invoice_override_test"; [] +gorptest: 02:41:11.384656 drop table if exists "person_test"; [] +gorptest: 02:41:11.384755 drop table if exists "ignored_column_test"; [] +gorptest: 02:41:11.384837 drop table if exists "id_created_test"; [] +gorptest: 02:41:11.384916 drop table if exists "type_conv_test"; [] +gorptest: 02:41:11.384999 drop table if exists "embedded_struct_test"; [] +gorptest: 02:41:11.385082 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 02:41:11.385163 drop table if exists "embedded_autoincr_test"; [] +gorptest: 02:41:11.385244 drop table if exists "time_test"; [] +gorptest: 02:41:11.385334 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.00s) PASS -ok gopkg.in/gorp.v1 0.202s +ok gopkg.in/gorp.v1 0.172s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang @@ -1838,12 +1874,14 @@ dpkg-buildpackage: info: binary-only upload (no source included) dpkg-genchanges: info: not including original source code in upload I: copying local configuration +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/1416254/tmp/hooks/B01_cleanup finished I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem I: cleaning the build env -I: removing directory /srv/workspace/pbuilder/1651141 and its subdirectories -I: Current time: Mon Apr 13 21:02:49 -12 2026 -I: pbuilder-time-stamp: 1776157369 +I: removing directory /srv/workspace/pbuilder/1416254 and its subdirectories +I: Current time: Wed Mar 12 16:41:15 +14 2025 +I: pbuilder-time-stamp: 1741747275