Diff of the two buildlogs: -- --- b1/build.log 2025-08-30 22:19:50.934943060 +0000 +++ b2/build.log 2025-08-30 22:20:44.483008657 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri Oct 2 16:42:06 -12 2026 -I: pbuilder-time-stamp: 1791002526 +I: Current time: Sun Aug 31 12:19:52 +14 2025 +I: pbuilder-time-stamp: 1756592392 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/forky-reproducible-base.tgz] I: copying local configuration @@ -22,53 +22,85 @@ 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/1649855/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/2093667/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 Aug 30 22:20 /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/2093667/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/2093667/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='forky' - HOME='/root' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=forky + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - INVOCATION_ID='003f64b162d843c993a83f8ae25933b2' - 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='1649855' - PS1='# ' - PS2='> ' + INVOCATION_ID=247789e534094e5f9e3260099c992cde + 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=2093667 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.YY9sct32/pbuilderrc_l97D --distribution forky --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.YY9sct32/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' - SUDO_GID='109' - SUDO_HOME='/var/lib/jenkins' - 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.YY9sct32/pbuilderrc_5ss9 --distribution forky --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/forky-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.YY9sct32/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' + SUDO_GID=109 + SUDO_HOME=/var/lib/jenkins + 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.12.41+deb13-cloud-arm64 #1 SMP Debian 6.12.41-1 (2025-08-12) aarch64 GNU/Linux + Linux i-capture-the-hostname 6.12.41+deb13-cloud-arm64 #1 SMP Debian 6.12.41-1 (2025-08-12) aarch64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Aug 10 2025 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/1649855/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Aug 10 12:30 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/2093667/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: 60 http://deb.debian.org/debian forky/main arm64 libsqlite3-dev arm64 3.46.1-7 [1060 kB] Get: 61 http://deb.debian.org/debian forky/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.27~ds1-1 [84.0 kB] Get: 62 http://deb.debian.org/debian forky/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 67.8 MB in 0s (215 MB/s) +Fetched 67.8 MB in 0s (233 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 ... 20011 files and directories currently installed.) @@ -441,7 +473,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/2093667/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for forky +I: user script /srv/workspace/pbuilder/2093667/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 @@ -460,52 +496,52 @@ 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/byteorder internal/godebugs -internal/asan -internal/goarch -internal/goexperiment internal/goos -internal/profilerecord -internal/msan internal/coverage/rtcov -internal/byteorder -internal/runtime/syscall +internal/msan internal/unsafeheader +internal/profilerecord +internal/asan +internal/runtime/syscall +internal/goexperiment internal/cpu -math/bits +internal/goarch sync/atomic -unicode +math/bits unicode/utf8 internal/itoa cmp -internal/abi -internal/runtime/math log/internal +unicode internal/chacha8rand +internal/runtime/math +internal/abi math internal/runtime/atomic internal/bytealg internal/runtime/sys -internal/runtime/exithook internal/stringslite +internal/runtime/exithook internal/race internal/sync internal/runtime/maps runtime -iter internal/reflectlite +iter sync maps slices errors sort -internal/bisect -internal/testlog internal/oserror +io +internal/bisect +path strconv math/rand/v2 -path -io +internal/testlog syscall internal/godebug bytes @@ -513,8 +549,8 @@ reflect regexp/syntax internal/syscall/execenv -internal/syscall/unix time +internal/syscall/unix regexp context io/fs @@ -530,1283 +566,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/10/03 04:42:45 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: 04:42:45.150541 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.154851 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.154890 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.154905 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.154919 drop table if exists "person_test"; [] -gorptest: 04:42:45.154932 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.154952 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.154969 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.154985 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.155006 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.155024 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.155037 drop table if exists "time_test"; [] -gorptest: 04:42:45.155059 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.155302 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: 04:42:45.155451 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.155594 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.155746 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.155884 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.156003 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.156136 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.156265 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.156379 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.156500 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.156621 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.156746 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: 04:42:45.156783 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: 04:42:45.156805 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.156828 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: 04:42:45.156852 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: 04:42:45.156873 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.156895 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.156932 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.156955 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.156977 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.156998 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: 04:42:45.157016 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.157036 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 04:42:45.157054 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.157202 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.157312 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.157406 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.157563 drop table if exists "person_test"; [] -gorptest: 04:42:45.157680 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.157774 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.157865 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.157951 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.158040 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.158129 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.158216 drop table if exists "time_test"; [] -gorptest: 04:42:45.158311 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.112024 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.114284 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.114364 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.114413 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.114459 drop table if exists "person_test"; [] +gorptest: 22:20:39.114502 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.114545 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.114583 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.114626 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.114668 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.114710 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.114752 drop table if exists "time_test"; [] +gorptest: 22:20:39.114815 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.115319 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.115644 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.115940 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.116285 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.116646 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.116966 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.117242 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.117523 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.117793 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.118063 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.118340 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.118629 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.118706 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.118764 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.118823 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.118882 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.118932 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.118990 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.119051 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.119103 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.119159 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.119214 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.119263 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.119313 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 22:20:39.119359 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.119669 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.119932 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.120160 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.120552 drop table if exists "person_test"; [] +gorptest: 22:20:39.120841 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.121111 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.121354 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.121590 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.121825 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.122060 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.122291 drop table if exists "time_test"; [] +gorptest: 22:20:39.122522 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables -2026/10/03 04:42:45 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: 04:42:45.158641 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.158812 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.158837 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.158852 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.158865 drop table if exists "person_test"; [] -gorptest: 04:42:45.158881 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.158894 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.158917 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.158934 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.158950 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.158966 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.158982 drop table if exists "time_test"; [] -gorptest: 04:42:45.159003 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.159157 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: 04:42:45.159306 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.159435 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.159584 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.159706 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.159822 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.159933 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.160045 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.160185 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.160313 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.160446 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.160571 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: 04:42:45.160607 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: 04:42:45.160630 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.160653 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: 04:42:45.160675 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: 04:42:45.160695 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.160713 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.160733 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.160762 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.160783 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.160803 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: 04:42:45.160825 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.160848 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 04:42:45.160886 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565160871565 2:1791002565160871565 3:"Bob" 4:"Smith" 5:1] -gorptest: 04:42:45.161019 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 04:42:45.161111 delete from "invoice_test"; [] -gorptest: 04:42:45.161173 delete from "invoice_tag_test"; [] -gorptest: 04:42:45.161226 delete from "alias_trans_field_test"; [] -gorptest: 04:42:45.161278 delete from "invoice_override_test"; [] -gorptest: 04:42:45.161334 delete from "person_test"; [] -gorptest: 04:42:45.161387 delete from "ignored_column_test"; [] -gorptest: 04:42:45.161437 delete from "id_created_test"; [] -gorptest: 04:42:45.161498 delete from "type_conv_test"; [] -gorptest: 04:42:45.161553 delete from "embedded_struct_test"; [] -gorptest: 04:42:45.161607 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.161658 delete from "embedded_autoincr_test"; [] -gorptest: 04:42:45.161714 delete from "time_test"; [] -gorptest: 04:42:45.161764 delete from "id_created_test"; [] -gorptest: 04:42:45.161815 SELECT * FROM person_test [] -gorptest: 04:42:45.161886 SELECT * FROM invoice_test [] -gorptest: 04:42:45.161928 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.162046 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.162148 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.162243 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.162404 drop table if exists "person_test"; [] -gorptest: 04:42:45.162519 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.162619 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.162711 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.162805 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.162898 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.162991 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.163079 drop table if exists "time_test"; [] -gorptest: 04:42:45.163166 drop table if exists "id_created_test"; [] ---- PASS: TestTruncateTables (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.123277 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.123638 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.123700 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.123745 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.123787 drop table if exists "person_test"; [] +gorptest: 22:20:39.123839 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.123892 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.123934 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.123976 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.124019 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.124060 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.124105 drop table if exists "time_test"; [] +gorptest: 22:20:39.124175 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.124626 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.124990 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.125300 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.125631 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.125914 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.126177 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.126459 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.126748 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.127048 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.127338 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.127664 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.127946 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.128020 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.128083 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.128143 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.128200 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.128250 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.128297 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.128348 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.128453 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.128565 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.128604 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.128623 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.128645 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 22:20:39.128694 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439128673555 2:1756592439128673555 3:"Bob" 4:"Smith" 5:1] +gorptest: 22:20:39.128860 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 22:20:39.128959 delete from "invoice_test"; [] +gorptest: 22:20:39.129025 delete from "invoice_tag_test"; [] +gorptest: 22:20:39.129086 delete from "alias_trans_field_test"; [] +gorptest: 22:20:39.129147 delete from "invoice_override_test"; [] +gorptest: 22:20:39.129211 delete from "person_test"; [] +gorptest: 22:20:39.129271 delete from "ignored_column_test"; [] +gorptest: 22:20:39.129329 delete from "id_created_test"; [] +gorptest: 22:20:39.129385 delete from "type_conv_test"; [] +gorptest: 22:20:39.129439 delete from "embedded_struct_test"; [] +gorptest: 22:20:39.129496 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.129551 delete from "embedded_autoincr_test"; [] +gorptest: 22:20:39.129607 delete from "time_test"; [] +gorptest: 22:20:39.129664 delete from "id_created_test"; [] +gorptest: 22:20:39.129717 SELECT * FROM person_test [] +gorptest: 22:20:39.129801 SELECT * FROM invoice_test [] +gorptest: 22:20:39.129845 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.130006 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.130119 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.130216 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.130430 drop table if exists "person_test"; [] +gorptest: 22:20:39.130551 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.130652 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.130753 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.130853 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.130951 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.131048 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.131138 drop table if exists "time_test"; [] +gorptest: 22:20:39.131227 drop table if exists "id_created_test"; [] +--- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType -gorptest: 04:42:45.163320 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 04:42:45.163641 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2026-10-03 04:42:45 +0000 UTC] -gorptest: 04:42:45.163746 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 04:42:45.163815 drop table if exists "WithCustomDate"; [] +gorptest: 22:20:39.131390 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 22:20:39.131719 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-08-30 22:20:39 +0000 UTC] +gorptest: 22:20:39.131827 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 22:20:39.131891 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey -gorptest: 04:42:45.164032 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 04:42:45.164331 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 04:42:45.164454 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 04:42:45.164574 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 04:42:45.164662 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 04:42:45.164740 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 04:42:45.164812 drop table if exists "PersonUInt64"; [] -gorptest: 04:42:45.164938 drop table if exists "PersonUInt32"; [] -gorptest: 04:42:45.165048 drop table if exists "PersonUInt16"; [] +gorptest: 22:20:39.132155 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 22:20:39.132435 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 22:20:39.132597 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 22:20:39.132770 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 22:20:39.132870 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 22:20:39.132952 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 22:20:39.133024 drop table if exists "PersonUInt64"; [] +gorptest: 22:20:39.133155 drop table if exists "PersonUInt32"; [] +gorptest: 22:20:39.133259 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether -gorptest: 04:42:45.165248 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 04:42:45.165552 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 04:42:45.165661 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 04:42:45.165721 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 04:42:45.165761 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 04:42:45.165841 drop table if exists "UniqueColumns"; [] +gorptest: 22:20:39.133448 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 22:20:39.133801 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 22:20:39.133910 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 22:20:39.133964 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 22:20:39.134001 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 22:20:39.134076 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser -gorptest: 04:42:45.166138 drop table if exists PersistentUser [] -gorptest: 04:42:45.166315 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 04:42:45.166469 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 04:42:45.166563 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 04:42:45.166622 select * from PersistentUser [] -gorptest: 04:42:45.166671 select * from PersistentUser [] -gorptest: 04:42:45.166709 select * from PersistentUser [] -gorptest: 04:42:45.166746 select Id from PersistentUser [] -gorptest: 04:42:45.166777 select mykey from PersistentUser [] -gorptest: 04:42:45.166807 select PassedTraining from PersistentUser [] -gorptest: 04:42:45.166836 select Id from PersistentUser [] -gorptest: 04:42:45.166862 drop table if exists "PersistentUser"; [] +gorptest: 22:20:39.134449 drop table if exists PersistentUser [] +gorptest: 22:20:39.134630 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 22:20:39.134790 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 22:20:39.134883 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 22:20:39.134943 select * from PersistentUser [] +gorptest: 22:20:39.134993 select * from PersistentUser [] +gorptest: 22:20:39.135039 select * from PersistentUser [] +gorptest: 22:20:39.135079 select Id from PersistentUser [] +gorptest: 22:20:39.135108 select mykey from PersistentUser [] +gorptest: 22:20:39.135133 select PassedTraining from PersistentUser [] +gorptest: 22:20:39.135156 select Id from PersistentUser [] +gorptest: 22:20:39.135182 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap -gorptest: 04:42:45.167034 drop table if exists PersistentUser [] -gorptest: 04:42:45.167196 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 04:42:45.167344 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 04:42:45.167441 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 04:42:45.167545 select * from PersistentUser where mykey = ? [1:43] -gorptest: 04:42:45.167622 select * from PersistentUser where mykey = ? [1:43] -gorptest: 04:42:45.167675 +gorptest: 22:20:39.135369 drop table if exists PersistentUser [] +gorptest: 22:20:39.135540 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 22:20:39.135691 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 22:20:39.135771 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 22:20:39.135900 select * from PersistentUser where mykey = ? [1:43] +gorptest: 22:20:39.135988 select * from PersistentUser where mykey = ? [1:43] +gorptest: 22:20:39.136078 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 04:42:45.167726 +gorptest: 22:20:39.136147 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 04:42:45.167769 drop table if exists "PersistentUser"; [] +gorptest: 22:20:39.136199 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct -gorptest: 04:42:45.167955 drop table if exists PersistentUser [] -gorptest: 04:42:45.168136 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 04:42:45.168299 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 04:42:45.168388 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 04:42:45.168467 +gorptest: 22:20:39.136406 drop table if exists PersistentUser [] +gorptest: 22:20:39.136601 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 22:20:39.136764 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 22:20:39.136854 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 22:20:39.136930 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 04:42:45.168532 drop table if exists "PersistentUser"; [] +gorptest: 22:20:39.136996 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice -2026/10/03 04:42:45 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: 04:42:45.168824 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.169391 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.169468 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.169530 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.169585 drop table if exists "person_test"; [] -gorptest: 04:42:45.169640 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.169686 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.169731 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.169779 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.169826 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.169871 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.169915 drop table if exists "time_test"; [] -gorptest: 04:42:45.169975 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.170398 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: 04:42:45.170765 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.171088 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.171488 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.171815 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.172307 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.172655 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.172981 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.173319 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.173649 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.173956 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.174266 select * from invoice_test where id=99999 [] -gorptest: 04:42:45.174413 select * from invoice_test where id=99999 [] -gorptest: 04:42:45.174521 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.174856 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.175134 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.175376 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.175725 drop table if exists "person_test"; [] -gorptest: 04:42:45.175969 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.176239 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.176480 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.176723 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.176989 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.177234 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.177459 drop table if exists "time_test"; [] -gorptest: 04:42:45.177686 drop table if exists "id_created_test"; [] ---- PASS: TestReturnsNonNilSlice (0.01s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.137237 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.137384 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.137408 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.137424 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.137440 drop table if exists "person_test"; [] +gorptest: 22:20:39.137454 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.137472 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.137487 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.137504 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.137518 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.137531 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.137547 drop table if exists "time_test"; [] +gorptest: 22:20:39.137565 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.137709 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.137834 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.137957 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.138098 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.138216 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.138324 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.138437 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.138553 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.138673 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.138796 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.138912 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.139026 select * from invoice_test where id=99999 [] +gorptest: 22:20:39.139087 select * from invoice_test where id=99999 [] +gorptest: 22:20:39.139135 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.139242 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.139339 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.139427 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.139588 drop table if exists "person_test"; [] +gorptest: 22:20:39.139692 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.139785 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.139874 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.139960 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.140055 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.140147 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.140236 drop table if exists "time_test"; [] +gorptest: 22:20:39.140324 drop table if exists "id_created_test"; [] +--- PASS: TestReturnsNonNilSlice (0.00s) === RUN TestOverrideVersionCol -gorptest: 04:42:45.177952 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 04:42:45.178737 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: 04:42:45.178892 drop table if exists "InvoicePersonView"; [] +gorptest: 22:20:39.140455 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 22:20:39.140823 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] +gorptest: 22:20:39.140899 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking -2026/10/03 04:42:45 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: 04:42:45.179471 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.179859 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.179927 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.179976 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.180022 drop table if exists "person_test"; [] -gorptest: 04:42:45.180069 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.180144 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.180196 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.180242 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.180288 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.180334 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.180382 drop table if exists "time_test"; [] -gorptest: 04:42:45.180441 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.180794 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: 04:42:45.181149 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.181464 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.181814 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.182127 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.182410 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.182682 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.182966 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.183253 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.183558 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.183842 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.184172 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565184144525 2:1791002565184144525 3:"Bob" 4:"Smith" 5:1] -gorptest: 04:42:45.184406 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.184587 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1791002565184144525 2:1791002565184144525 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 04:42:45.184801 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1791002565184144525 2:1791002565184144525 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 04:42:45.184921 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.185056 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 04:42:45.185140 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.185241 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.185501 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.185749 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.185979 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.186391 drop table if exists "person_test"; [] -gorptest: 04:42:45.186664 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.186904 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.187132 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.187361 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.187589 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.187819 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.188049 drop table if exists "time_test"; [] -gorptest: 04:42:45.188324 drop table if exists "id_created_test"; [] ---- PASS: TestOptimisticLocking (0.01s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.141191 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.141340 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.141364 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.141378 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.141401 drop table if exists "person_test"; [] +gorptest: 22:20:39.141415 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.141435 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.141449 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.141468 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.141485 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.141503 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.141516 drop table if exists "time_test"; [] +gorptest: 22:20:39.141534 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.141676 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.141798 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.141913 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.142047 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.142167 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.142275 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.142383 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.142496 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.142606 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.142717 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.142830 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.142958 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439142937768 2:1756592439142937768 3:"Bob" 4:"Smith" 5:1] +gorptest: 22:20:39.143056 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.143129 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1756592439142937768 2:1756592439142937768 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 22:20:39.143217 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1756592439142937768 2:1756592439142937768 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 22:20:39.143260 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.143304 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 22:20:39.143337 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.143372 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.143472 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.143573 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.143665 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.143824 drop table if exists "person_test"; [] +gorptest: 22:20:39.143932 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.144024 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.144118 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.144217 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.144311 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.144400 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.144486 drop table if exists "time_test"; [] +gorptest: 22:20:39.144596 drop table if exists "id_created_test"; [] +--- PASS: TestOptimisticLocking (0.00s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 04:42:45.188653 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 04:42:45.189360 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 04:42:45.189578 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 04:42:45.189780 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: 04:42:45.190013 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 04:42:45.190164 drop table if exists "TableWithNull"; [] +gorptest: 22:20:39.144779 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 22:20:39.145092 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 22:20:39.145181 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 22:20:39.145268 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] +gorptest: 22:20:39.145365 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 22:20:39.145424 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps -gorptest: 04:42:45.190645 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 04:42:45.191353 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 04:42:45.191609 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 04:42:45.191754 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 04:42:45.191876 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 04:42:45.191979 drop table if exists "Invoice"; [] +gorptest: 22:20:39.145609 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 22:20:39.145896 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 22:20:39.146001 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 22:20:39.146057 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 22:20:39.146111 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 22:20:39.146148 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect -2026/10/03 04:42:45 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: 04:42:45.192682 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.193111 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.193181 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.193235 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.193287 drop table if exists "person_test"; [] -gorptest: 04:42:45.193384 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.193440 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.193492 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.193539 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.193582 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.193625 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.193670 drop table if exists "time_test"; [] -gorptest: 04:42:45.193724 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.194096 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: 04:42:45.194438 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.194751 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.195109 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.195411 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.195712 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.196014 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.196365 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.196663 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.197025 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.197699 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.198013 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565197987885 2:1791002565197987885 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.198254 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 04:42:45.198468 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 04:42:45.198643 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.198901 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.199143 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.199369 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.199696 drop table if exists "person_test"; [] -gorptest: 04:42:45.199941 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.200187 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.200422 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.200646 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.200867 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.201475 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.201725 drop table if exists "time_test"; [] -gorptest: 04:42:45.201952 drop table if exists "id_created_test"; [] ---- PASS: TestRawSelect (0.01s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.146456 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.146599 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.146621 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.146634 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.146647 drop table if exists "person_test"; [] +gorptest: 22:20:39.146669 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.146683 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.146699 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.146712 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.146726 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.146742 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.146754 drop table if exists "time_test"; [] +gorptest: 22:20:39.146777 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.146911 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.147042 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.147162 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.147299 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.147420 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.147534 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.147642 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.147762 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.147878 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.147999 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.148121 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.148241 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439148230443 2:1756592439148230443 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.148335 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 22:20:39.148409 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 22:20:39.148492 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.148632 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.148735 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.148852 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.149026 drop table if exists "person_test"; [] +gorptest: 22:20:39.149138 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.149233 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.149321 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.149409 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.149512 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.149613 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.149706 drop table if exists "time_test"; [] +gorptest: 22:20:39.149790 drop table if exists "id_created_test"; [] +--- PASS: TestRawSelect (0.00s) === RUN TestHooks -2026/10/03 04:42:45 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: 04:42:45.202262 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.202606 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.202673 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.202726 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.202770 drop table if exists "person_test"; [] -gorptest: 04:42:45.202810 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.202849 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.202888 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.202928 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.202975 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.203022 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.203064 drop table if exists "time_test"; [] -gorptest: 04:42:45.203114 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.203428 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: 04:42:45.203719 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.203990 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.204334 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.204621 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.204873 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.205514 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.205799 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.206093 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.206384 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.206678 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.206987 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565206962845 2:1791002565206962845 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.207209 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.207349 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1791002565206962845 2:1791002565206962845 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 04:42:45.207527 select * from person_test where id = ? [1:1] -gorptest: 04:42:45.207667 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 04:42:45.207830 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.208043 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.208300 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.208524 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.208839 drop table if exists "person_test"; [] -gorptest: 04:42:45.209146 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.209650 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.209874 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.210080 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.210265 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.210451 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.210630 drop table if exists "time_test"; [] -gorptest: 04:42:45.210810 drop table if exists "id_created_test"; [] ---- PASS: TestHooks (0.01s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.149943 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.150091 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.150116 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.150131 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.150149 drop table if exists "person_test"; [] +gorptest: 22:20:39.150163 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.150181 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.150194 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.150207 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.150220 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.150237 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.150251 drop table if exists "time_test"; [] +gorptest: 22:20:39.150281 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.150427 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.150552 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.150673 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.150813 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.150933 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.151040 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.151149 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.151260 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.151374 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.151488 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.151599 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.151721 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439151709266 2:1756592439151709266 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.151821 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.151906 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1756592439151709266 2:1756592439151709266 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 22:20:39.151996 select * from person_test where id = ? [1:1] +gorptest: 22:20:39.152064 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 22:20:39.152146 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.152253 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.152359 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.152458 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.152648 drop table if exists "person_test"; [] +gorptest: 22:20:39.152787 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.152895 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.152989 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.153095 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.153190 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.153281 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.153369 drop table if exists "time_test"; [] +gorptest: 22:20:39.153570 drop table if exists "id_created_test"; [] +--- PASS: TestHooks (0.00s) === RUN TestTransaction -2026/10/03 04:42:45 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: 04:42:45.211076 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.211384 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.211430 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.211466 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.211503 drop table if exists "person_test"; [] -gorptest: 04:42:45.211540 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.211577 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.211616 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.211652 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.211690 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.211726 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.211771 drop table if exists "time_test"; [] -gorptest: 04:42:45.211818 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.212125 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: 04:42:45.212391 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.212637 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.212979 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.213833 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.214156 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.214352 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.214520 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.214676 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.214838 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.214993 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.215155 begin; [] -gorptest: 04:42:45.215214 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 04:42:45.215309 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 04:42:45.215341 commit; [] -gorptest: 04:42:45.215427 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.215536 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 04:42:45.215586 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.215781 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.215918 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.216040 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.216268 drop table if exists "person_test"; [] -gorptest: 04:42:45.216424 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.216549 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.216666 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.216778 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.216889 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.217025 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.217142 drop table if exists "time_test"; [] -gorptest: 04:42:45.217252 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.154132 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.154497 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.154552 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.154599 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.154645 drop table if exists "person_test"; [] +gorptest: 22:20:39.154688 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.154730 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.154772 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.154815 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.154859 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.154905 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.154948 drop table if exists "time_test"; [] +gorptest: 22:20:39.155021 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.155391 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.155737 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.156044 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.156410 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.156777 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.157108 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.157422 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.157737 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.158028 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.158317 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.158606 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.158889 begin; [] +gorptest: 22:20:39.158973 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 22:20:39.159140 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 22:20:39.159200 commit; [] +gorptest: 22:20:39.159335 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.159492 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 22:20:39.159591 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.159865 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.160117 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.160385 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.160834 drop table if exists "person_test"; [] +gorptest: 22:20:39.161122 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.161356 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.161598 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.161823 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.162046 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.162273 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.162495 drop table if exists "time_test"; [] +gorptest: 22:20:39.162713 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.01s) === RUN TestSavepoint -2026/10/03 04:42:45 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: 04:42:45.217488 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.217704 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.217731 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.217749 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.217770 drop table if exists "person_test"; [] -gorptest: 04:42:45.217786 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.217806 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.217827 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.217846 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.217873 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.217895 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.217912 drop table if exists "time_test"; [] -gorptest: 04:42:45.217940 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.218138 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: 04:42:45.218322 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.218519 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.218726 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.218902 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.219075 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.219257 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.219419 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.219564 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.219721 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.219891 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.220049 begin; [] -gorptest: 04:42:45.220118 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 04:42:45.220213 select memo from invoice_test [] -gorptest: 04:42:45.220267 savepoint "foo" [1:] -gorptest: 04:42:45.220280 select memo from invoice_test [] -gorptest: 04:42:45.220315 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 04:42:45.220362 select memo from invoice_test [] -gorptest: 04:42:45.220393 rollback to savepoint "foo" [1:] -gorptest: 04:42:45.220406 select memo from invoice_test [] -gorptest: 04:42:45.220422 rollback; [] -gorptest: 04:42:45.220479 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.220657 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.220802 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.221137 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.221375 drop table if exists "person_test"; [] -gorptest: 04:42:45.221510 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.221623 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.221734 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.221844 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.221951 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.222059 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.222174 drop table if exists "time_test"; [] -gorptest: 04:42:45.222281 drop table if exists "id_created_test"; [] ---- PASS: TestSavepoint (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.163048 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.163413 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.163474 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.163521 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.163565 drop table if exists "person_test"; [] +gorptest: 22:20:39.163616 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.163658 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.163700 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.163742 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.163784 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.163828 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.163870 drop table if exists "time_test"; [] +gorptest: 22:20:39.163955 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.164331 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.164686 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.165012 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.165353 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.165642 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.165908 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.166175 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.166453 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.166745 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.167035 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.167317 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.167583 begin; [] +gorptest: 22:20:39.167663 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 22:20:39.167813 select memo from invoice_test [] +gorptest: 22:20:39.167903 savepoint "foo" [1:] +gorptest: 22:20:39.167950 select memo from invoice_test [] +gorptest: 22:20:39.168034 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 22:20:39.168096 select memo from invoice_test [] +gorptest: 22:20:39.168157 rollback to savepoint "foo" [1:] +gorptest: 22:20:39.168209 select memo from invoice_test [] +gorptest: 22:20:39.168261 rollback; [] +gorptest: 22:20:39.168389 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.168681 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.168968 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.169207 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.169564 drop table if exists "person_test"; [] +gorptest: 22:20:39.169850 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.170092 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.170336 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.170606 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.170848 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.171074 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.171297 drop table if exists "time_test"; [] +gorptest: 22:20:39.171516 drop table if exists "id_created_test"; [] +--- PASS: TestSavepoint (0.01s) === RUN TestMultiple -2026/10/03 04:42:45 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: 04:42:45.222554 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.222972 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.223008 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.223038 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.223055 drop table if exists "person_test"; [] -gorptest: 04:42:45.223078 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.223095 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.223116 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.223132 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.223152 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.223171 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.223192 drop table if exists "time_test"; [] -gorptest: 04:42:45.223216 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.223407 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: 04:42:45.223561 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.223704 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.223878 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.224029 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.224202 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.224352 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.224494 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.224628 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.224782 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.225133 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.225312 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 04:42:45.225429 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 04:42:45.225526 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 04:42:45.225616 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 04:42:45.225695 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.225767 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 04:42:45.225837 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.225975 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.226092 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.226199 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.226393 drop table if exists "person_test"; [] -gorptest: 04:42:45.226512 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.226627 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.226739 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.226843 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.226945 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.227047 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.227147 drop table if exists "time_test"; [] -gorptest: 04:42:45.227254 drop table if exists "id_created_test"; [] ---- PASS: TestMultiple (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.171845 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.172226 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.172298 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.172346 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.172392 drop table if exists "person_test"; [] +gorptest: 22:20:39.172439 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.172485 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.172563 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.172614 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.172663 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.172710 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.172773 drop table if exists "time_test"; [] +gorptest: 22:20:39.172863 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.173230 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.173546 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.173852 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.174216 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.174515 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.174776 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.175042 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.175328 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.175606 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.175911 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.176188 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.176532 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 22:20:39.176790 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 22:20:39.177015 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 22:20:39.177204 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 22:20:39.177375 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.177531 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 22:20:39.177682 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.177940 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.178172 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.178404 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.178750 drop table if exists "person_test"; [] +gorptest: 22:20:39.178993 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.179219 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.179439 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.179656 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.179875 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.180094 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.180346 drop table if exists "time_test"; [] +gorptest: 22:20:39.180609 drop table if exists "id_created_test"; [] +--- PASS: TestMultiple (0.01s) === RUN TestCrud -2026/10/03 04:42:45 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: 04:42:45.227477 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.227662 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.227690 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.227710 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.227731 drop table if exists "person_test"; [] -gorptest: 04:42:45.227749 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.227767 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.227787 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.227802 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.227818 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.227833 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.227853 drop table if exists "time_test"; [] -gorptest: 04:42:45.227876 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.228047 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: 04:42:45.228225 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.228393 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.228573 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.228719 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.228844 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.229156 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.229318 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.229471 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.229610 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.229749 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.229877 delete from invoice_test [] -gorptest: 04:42:45.229963 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 04:42:45.230060 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.230151 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8003832153555894276 2:7117967868896384071 3:"random 1772052029518766272" 4:0 5:true 6:1] -gorptest: 04:42:45.230244 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.230302 select * from invoice_test [] -gorptest: 04:42:45.230378 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.230465 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 04:42:45.230509 delete from invoice_tag_test [] -gorptest: 04:42:45.230596 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: 04:42:45.230729 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 04:42:45.230797 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3189062832673001089 2:3456536146733126422 3:"random 3891148443263070545" 4:33 5:false 6:1] -gorptest: 04:42:45.230885 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 04:42:45.230935 select * from invoice_tag_test [] -gorptest: 04:42:45.230999 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 04:42:45.231081 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 04:42:45.231121 delete from alias_trans_field_test [] -gorptest: 04:42:45.231199 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 04:42:45.231288 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 04:42:45.231343 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 1582697290356227958" 2:1] -gorptest: 04:42:45.231426 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 04:42:45.231468 select * from alias_trans_field_test [] -gorptest: 04:42:45.231519 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 04:42:45.231598 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 04:42:45.231639 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.231788 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.231904 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.232013 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.232216 drop table if exists "person_test"; [] -gorptest: 04:42:45.232342 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.232456 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.232568 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.232685 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.232787 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.232894 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.233299 drop table if exists "time_test"; [] -gorptest: 04:42:45.233421 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.180995 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.181377 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.181435 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.181484 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.181530 drop table if exists "person_test"; [] +gorptest: 22:20:39.181579 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.181627 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.181674 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.181720 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.181766 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.181813 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.181861 drop table if exists "time_test"; [] +gorptest: 22:20:39.181920 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.182283 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.182597 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.182895 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.183241 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.183536 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.183828 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.184129 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.184437 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.184937 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.185244 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.185528 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.185799 delete from invoice_test [] +gorptest: 22:20:39.185975 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 22:20:39.186182 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.186363 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:3596971655289562653 2:8124929156886891763 3:"random 3644516681797387287" 4:0 5:true 6:1] +gorptest: 22:20:39.186569 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.186686 select * from invoice_test [] +gorptest: 22:20:39.186839 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.187013 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 22:20:39.187102 delete from invoice_tag_test [] +gorptest: 22:20:39.187276 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] +gorptest: 22:20:39.187492 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 22:20:39.187634 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:225147188144455520 2:3249457616588627471 3:"random 6840911823687571910" 4:33 5:false 6:1] +gorptest: 22:20:39.187832 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 22:20:39.187953 select * from invoice_tag_test [] +gorptest: 22:20:39.188112 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 22:20:39.188345 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 22:20:39.188472 delete from alias_trans_field_test [] +gorptest: 22:20:39.188676 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 22:20:39.188909 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 22:20:39.189031 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 7644468120803315114" 2:1] +gorptest: 22:20:39.189213 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 22:20:39.189312 select * from alias_trans_field_test [] +gorptest: 22:20:39.189419 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 22:20:39.189589 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 22:20:39.189674 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.189935 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.190193 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.190432 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.190779 drop table if exists "person_test"; [] +gorptest: 22:20:39.191022 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.191263 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.191487 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.191708 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.191928 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.192147 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.192394 drop table if exists "time_test"; [] +gorptest: 22:20:39.192647 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.01s) === RUN TestWithIgnoredColumn -2026/10/03 04:42:45 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: 04:42:45.233641 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.233830 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.233855 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.233874 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.233893 drop table if exists "person_test"; [] -gorptest: 04:42:45.233911 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.233928 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.233945 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.233961 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.233978 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.233995 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.234012 drop table if exists "time_test"; [] -gorptest: 04:42:45.234034 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.234196 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: 04:42:45.234349 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.234482 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.234636 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.234767 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.234886 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.235022 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.235158 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.235282 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.235413 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.235539 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.235671 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 04:42:45.235768 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 04:42:45.235829 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 04:42:45.235921 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 04:42:45.235961 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.236112 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.236231 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.236343 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.236531 drop table if exists "person_test"; [] -gorptest: 04:42:45.236642 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.236748 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.236854 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.237018 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.237166 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.237289 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.237407 drop table if exists "time_test"; [] -gorptest: 04:42:45.237518 drop table if exists "id_created_test"; [] ---- PASS: TestWithIgnoredColumn (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.193013 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.193375 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.193439 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.193484 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.193536 drop table if exists "person_test"; [] +gorptest: 22:20:39.193579 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.193621 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.193665 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.193709 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.193754 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.193809 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.193854 drop table if exists "time_test"; [] +gorptest: 22:20:39.193914 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.194245 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.194536 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.194808 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.195134 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.195409 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.195676 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.195937 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.196207 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.196532 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.196927 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.197249 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.197548 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 22:20:39.197756 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 22:20:39.197870 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 22:20:39.198058 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 22:20:39.198152 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.198391 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.198638 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.198861 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.199206 drop table if exists "person_test"; [] +gorptest: 22:20:39.199442 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.199714 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.199944 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.200171 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.200420 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.200874 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.201551 drop table if exists "time_test"; [] +gorptest: 22:20:39.201784 drop table if exists "id_created_test"; [] +--- PASS: TestWithIgnoredColumn (0.01s) === RUN TestTypeConversionExample -2026/10/03 04:42:45 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: 04:42:45.237715 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.237895 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.237919 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.237940 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.237957 drop table if exists "person_test"; [] -gorptest: 04:42:45.237973 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.237991 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.238008 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.238025 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.238042 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.238059 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.238075 drop table if exists "time_test"; [] -gorptest: 04:42:45.238104 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.238263 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: 04:42:45.238400 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.238527 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.238674 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.238799 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.238916 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.239032 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.239149 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.239267 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.239386 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.239508 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.239797 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: 04:42:45.239912 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 04:42:45.239993 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: 04:42:45.240145 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 04:42:45.240214 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 04:42:45.240303 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.240413 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.240517 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.240618 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.240773 drop table if exists "person_test"; [] -gorptest: 04:42:45.240879 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.241227 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.241349 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.241472 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.241580 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.241683 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.241776 drop table if exists "time_test"; [] -gorptest: 04:42:45.241870 drop table if exists "id_created_test"; [] ---- PASS: TestTypeConversionExample (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.202103 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.202430 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.202489 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.202529 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.202570 drop table if exists "person_test"; [] +gorptest: 22:20:39.202609 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.202648 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.202687 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.202726 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.202765 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.202804 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.202853 drop table if exists "time_test"; [] +gorptest: 22:20:39.202904 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.203251 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.203561 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.203851 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.204186 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.204533 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.204888 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.205540 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.205802 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.206042 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.206285 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.206526 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.206943 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] +gorptest: 22:20:39.207153 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 22:20:39.207298 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] +gorptest: 22:20:39.207467 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 22:20:39.207590 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 22:20:39.207739 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.207946 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.208181 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.208415 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.208811 drop table if exists "person_test"; [] +gorptest: 22:20:39.209348 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.209564 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.209758 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.209955 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.210140 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.210328 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.210509 drop table if exists "time_test"; [] +gorptest: 22:20:39.210688 drop table if exists "id_created_test"; [] +--- PASS: TestTypeConversionExample (0.01s) === RUN TestWithEmbeddedStruct -2026/10/03 04:42:45 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: 04:42:45.242078 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.242257 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.242284 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.242302 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.242319 drop table if exists "person_test"; [] -gorptest: 04:42:45.242337 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.242353 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.242370 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.242390 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.242407 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.242424 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.242441 drop table if exists "time_test"; [] -gorptest: 04:42:45.242465 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.242627 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: 04:42:45.242769 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.242909 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.243062 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.243197 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.243327 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.243458 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.243653 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.243781 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.243921 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.244053 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.244659 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 04:42:45.244784 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 04:42:45.244854 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 04:42:45.245153 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 04:42:45.245211 select * from embedded_struct_test [] -gorptest: 04:42:45.245263 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.245385 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.245493 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.245597 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.245777 drop table if exists "person_test"; [] -gorptest: 04:42:45.245889 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.245987 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.246080 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.246178 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.246296 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.246418 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.246522 drop table if exists "time_test"; [] -gorptest: 04:42:45.246616 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStruct (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.210992 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.211289 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.211338 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.211377 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.211412 drop table if exists "person_test"; [] +gorptest: 22:20:39.211446 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.211480 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.211513 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.211546 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.211580 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.211614 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.211648 drop table if exists "time_test"; [] +gorptest: 22:20:39.211697 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.211960 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.212192 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.212458 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.212827 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.213378 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.213611 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.213828 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.214051 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.214285 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.214509 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.214729 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.214964 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 22:20:39.215159 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 22:20:39.215274 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 22:20:39.215425 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 22:20:39.215507 select * from embedded_struct_test [] +gorptest: 22:20:39.215621 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.215827 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.216025 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.216207 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.216655 drop table if exists "person_test"; [] +gorptest: 22:20:39.216950 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.217191 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.217409 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.217596 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.217777 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.217943 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.218105 drop table if exists "time_test"; [] +gorptest: 22:20:39.218267 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStruct (0.01s) === RUN TestWithEmbeddedStructBeforeAutoincr -2026/10/03 04:42:45 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: 04:42:45.246807 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.246990 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.247019 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.247041 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.247061 drop table if exists "person_test"; [] -gorptest: 04:42:45.247078 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.247094 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.247114 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.247131 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.247148 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.247164 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.247183 drop table if exists "time_test"; [] -gorptest: 04:42:45.247205 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.247361 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: 04:42:45.247488 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.247619 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.247762 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.247882 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.247999 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.248140 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.248267 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.248391 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.248511 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.248635 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.248764 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 04:42:45.248857 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.249140 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.249259 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.249360 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.249536 drop table if exists "person_test"; [] -gorptest: 04:42:45.249643 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.249744 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.249854 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.249954 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.250064 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.250170 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.250273 drop table if exists "time_test"; [] -gorptest: 04:42:45.250383 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStructBeforeAutoincr (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.218563 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.218842 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.218882 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.218909 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.218936 drop table if exists "person_test"; [] +gorptest: 22:20:39.218968 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.219006 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.219042 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.219074 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.219108 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.219139 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.219169 drop table if exists "time_test"; [] +gorptest: 22:20:39.219220 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.219470 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.219700 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.219924 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.220179 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.220443 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.220689 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.221013 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.221513 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.221738 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.221949 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.222148 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.222356 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 22:20:39.222501 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.222666 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.222826 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.222985 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.223237 drop table if exists "person_test"; [] +gorptest: 22:20:39.223411 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.223590 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.223776 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.223936 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.224092 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.224258 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.224439 drop table if exists "time_test"; [] +gorptest: 22:20:39.224623 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr -2026/10/03 04:42:45 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: 04:42:45.250867 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.251058 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.251085 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.251103 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.251118 drop table if exists "person_test"; [] -gorptest: 04:42:45.251134 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.251151 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.251166 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.251185 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.251207 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.251223 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.251241 drop table if exists "time_test"; [] -gorptest: 04:42:45.251263 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.251413 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: 04:42:45.251538 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.251665 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.251806 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.251934 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.252090 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.252237 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.252367 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.252501 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.252620 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.252739 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.252865 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 04:42:45.253012 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.253130 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.253566 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.253678 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.253844 drop table if exists "person_test"; [] -gorptest: 04:42:45.253948 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.254050 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.254156 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.254257 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.254352 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.254453 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.254573 drop table if exists "time_test"; [] -gorptest: 04:42:45.254689 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedAutoincr (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.225368 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.225636 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.225674 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.225704 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.225732 drop table if exists "person_test"; [] +gorptest: 22:20:39.225760 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.225788 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.225821 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.225849 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.225881 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.225910 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.225938 drop table if exists "time_test"; [] +gorptest: 22:20:39.225980 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.226231 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.226445 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.226636 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.226860 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.227048 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.227227 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.227402 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.227581 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.227763 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.227945 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.228125 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.228341 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 22:20:39.228482 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.228672 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.228892 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.229412 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.229669 drop table if exists "person_test"; [] +gorptest: 22:20:39.229831 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.229977 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.230119 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.230259 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.230399 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.230538 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.230694 drop table if exists "time_test"; [] +gorptest: 22:20:39.230832 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal -gorptest: 04:42:45.254852 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 04:42:45.255169 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: 04:42:45.255264 select Int64 from TableWithNull where Str='abc' [] -gorptest: 04:42:45.255316 select count(*) from TableWithNull [] -gorptest: 04:42:45.255349 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 04:42:45.255384 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 04:42:45.255416 select Int64 from TableWithNull where Str='abc' [] -gorptest: 04:42:45.255442 select Float64 from TableWithNull where Str='abc' [] -gorptest: 04:42:45.255468 select min(Float64) from TableWithNull [] -gorptest: 04:42:45.255496 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 04:42:45.255526 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 04:42:45.255550 select Float64 from TableWithNull where Str='abc' [] -gorptest: 04:42:45.255576 select Str from TableWithNull where Int64=? [1:78] -gorptest: 04:42:45.255605 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 04:42:45.255634 select Str from TableWithNull where Int64=? [1:78] -gorptest: 04:42:45.255661 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 04:42:45.255720 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 04:42:45.255752 select Str from TableWithNull where Int64=? [1:78] -gorptest: 04:42:45.255779 drop table if exists "TableWithNull"; [] +gorptest: 22:20:39.231045 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 22:20:39.231485 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] +gorptest: 22:20:39.231619 select Int64 from TableWithNull where Str='abc' [] +gorptest: 22:20:39.231688 select count(*) from TableWithNull [] +gorptest: 22:20:39.231746 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 22:20:39.231793 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 22:20:39.231834 select Int64 from TableWithNull where Str='abc' [] +gorptest: 22:20:39.231875 select Float64 from TableWithNull where Str='abc' [] +gorptest: 22:20:39.231915 select min(Float64) from TableWithNull [] +gorptest: 22:20:39.231958 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 22:20:39.232003 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 22:20:39.232050 select Float64 from TableWithNull where Str='abc' [] +gorptest: 22:20:39.232107 select Str from TableWithNull where Int64=? [1:78] +gorptest: 22:20:39.232160 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 22:20:39.232200 select Str from TableWithNull where Int64=? [1:78] +gorptest: 22:20:39.232240 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 22:20:39.232338 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 22:20:39.232404 select Str from TableWithNull where Int64=? [1:78] +gorptest: 22:20:39.232458 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows -2026/10/03 04:42:45 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: 04:42:45.256040 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.256218 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.256246 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.256262 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.256279 drop table if exists "person_test"; [] -gorptest: 04:42:45.256298 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.256318 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.256334 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.256359 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.256376 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.256391 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.256412 drop table if exists "time_test"; [] -gorptest: 04:42:45.256450 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.256612 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: 04:42:45.256744 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.256866 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.257101 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.257266 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.257415 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.257545 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.257665 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.257778 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.257891 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.257999 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.258130 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565258110925 2:1791002565258110925 3:"Bob" 4:"Smith" 5:1] -gorptest: 04:42:45.258245 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565258236045 2:1791002565258236045 3:"Jane" 4:"Smith" 5:1] -gorptest: 04:42:45.258336 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565258331245 2:1791002565258331245 3:"Mike" 4:"Smith" 5:1] -gorptest: 04:42:45.258410 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.258512 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.258607 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.258698 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.258849 drop table if exists "person_test"; [] -gorptest: 04:42:45.258954 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.259048 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.259141 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.259231 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.259320 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.259406 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.259495 drop table if exists "time_test"; [] -gorptest: 04:42:45.259580 drop table if exists "id_created_test"; [] ---- PASS: TestVersionMultipleRows (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.233405 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.233644 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.233682 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.233711 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.233741 drop table if exists "person_test"; [] +gorptest: 22:20:39.233764 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.233789 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.233813 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.233839 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.233870 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.233897 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.233930 drop table if exists "time_test"; [] +gorptest: 22:20:39.233964 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.234195 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.234391 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.234576 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.234789 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.234977 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.235149 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.235316 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.235488 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.235658 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.235840 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.236016 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.236224 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439236196297 2:1756592439236196297 3:"Bob" 4:"Smith" 5:1] +gorptest: 22:20:39.236381 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439236370618 2:1756592439236370618 3:"Jane" 4:"Smith" 5:1] +gorptest: 22:20:39.236532 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439236498739 2:1756592439236498739 3:"Mike" 4:"Smith" 5:1] +gorptest: 22:20:39.236661 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.236873 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.237331 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.237487 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.237713 drop table if exists "person_test"; [] +gorptest: 22:20:39.237864 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.237992 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.238117 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.238243 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.238369 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.238493 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.238619 drop table if exists "time_test"; [] +gorptest: 22:20:39.238741 drop table if exists "id_created_test"; [] +--- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk -gorptest: 04:42:45.259749 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 04:42:45.260040 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 04:42:45.260145 drop table if exists "string_pk_test"; [] +gorptest: 22:20:39.238920 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 22:20:39.239398 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 22:20:39.239512 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2026/10/03 04:42:45 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: 04:42:45.260560 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.260739 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.260766 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.260783 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.260798 drop table if exists "person_test"; [] -gorptest: 04:42:45.260818 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.260834 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.260850 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.260866 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.260891 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.260921 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.260941 drop table if exists "time_test"; [] -gorptest: 04:42:45.260961 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.261115 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: 04:42:45.261264 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.261391 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.261551 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.261677 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.261798 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.261912 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.262036 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.262157 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.262274 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.262395 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.262525 insert into "time_test" ("Id","Time") values (null,?); [1:2026-10-03 04:11:45.262510805 +0000 UTC] -gorptest: 04:42:45.262616 insert into "time_test" ("Id","Time") values (null,?); [1:2026-10-03 04:12:46.262510805 +0000 UTC] -gorptest: 04:42:45.262713 SELECT id FROM time_test WHERE Time < ? [1:2026-10-03 04:12:45.262510805 +0000 UTC] -gorptest: 04:42:45.262784 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.262893 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.262993 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.263091 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.263256 drop table if exists "person_test"; [] -gorptest: 04:42:45.263356 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.263449 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.263542 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.263635 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.263727 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.263822 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.263920 drop table if exists "time_test"; [] -gorptest: 04:42:45.264014 drop table if exists "id_created_test"; [] ---- PASS: TestWithTimeSelect (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.240086 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.240324 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.240354 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.240376 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.240405 drop table if exists "person_test"; [] +gorptest: 22:20:39.240430 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.240457 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.240477 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.240528 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.240569 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.240599 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.240625 drop table if exists "time_test"; [] +gorptest: 22:20:39.240657 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.240927 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.241151 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.241326 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.241568 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.241747 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.241898 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.242049 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.242214 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.242370 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.242536 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.242700 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.242869 insert into "time_test" ("Id","Time") values (null,?); [1:2025-08-30 21:49:39.242852461 +0000 UTC] +gorptest: 22:20:39.242997 insert into "time_test" ("Id","Time") values (null,?); [1:2025-08-30 21:50:40.242852461 +0000 UTC] +gorptest: 22:20:39.243108 SELECT id FROM time_test WHERE Time < ? [1:2025-08-30 21:50:39.242852461 +0000 UTC] +gorptest: 22:20:39.243192 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.243334 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.243465 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.243592 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.243801 drop table if exists "person_test"; [] +gorptest: 22:20:39.243947 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.244080 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.244206 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.244357 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.244488 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.244650 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.244832 drop table if exists "time_test"; [] +gorptest: 22:20:39.244980 drop table if exists "id_created_test"; [] +--- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView -2026/10/03 04:42:45 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: 04:42:45.264219 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.264386 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.264411 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.264431 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.264448 drop table if exists "person_test"; [] -gorptest: 04:42:45.264466 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.264482 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.264497 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.264515 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.264531 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.264546 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.264561 drop table if exists "time_test"; [] -gorptest: 04:42:45.264582 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.264731 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: 04:42:45.264861 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.265019 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.265179 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.265303 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.265417 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.265528 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.265650 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.265769 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.265905 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.266030 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.266189 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565266149885 2:1791002565266149885 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.266303 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 04:42:45.266387 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 04:42:45.266466 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.266577 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.266676 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.266764 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.266916 drop table if exists "person_test"; [] -gorptest: 04:42:45.267020 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.267119 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.267209 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.267297 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.267388 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.267478 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.267566 drop table if exists "time_test"; [] -gorptest: 04:42:45.267652 drop table if exists "id_created_test"; [] ---- PASS: TestInvoicePersonView (0.00s) +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.245471 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.245696 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.245729 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.245758 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.245784 drop table if exists "person_test"; [] +gorptest: 22:20:39.245802 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.245828 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.245847 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.245870 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.245888 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.245911 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.245940 drop table if exists "time_test"; [] +gorptest: 22:20:39.245966 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.246151 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.246326 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.246483 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.246664 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.246814 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.246953 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.247099 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.247251 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.247400 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.247559 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.247714 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.247887 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439247871453 2:1756592439247871453 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.248015 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 22:20:39.248163 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 22:20:39.248269 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.248435 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.248737 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.249134 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.249348 drop table if exists "person_test"; [] +gorptest: 22:20:39.249497 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.249628 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.249751 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.249884 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.250008 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.250146 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.250274 drop table if exists "time_test"; [] +gorptest: 22:20:39.250414 drop table if exists "id_created_test"; [] +--- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames -2026/10/03 04:42:45 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: 04:42:45.267843 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.268005 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.268029 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.268045 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.268096 drop table if exists "person_test"; [] -gorptest: 04:42:45.268124 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.268139 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.268153 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.268170 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.268187 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.268202 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.268218 drop table if exists "time_test"; [] -gorptest: 04:42:45.268239 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.268387 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: 04:42:45.268514 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.268630 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.268778 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.268926 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.269070 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.269197 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.269323 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.269458 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.269583 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.269705 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.250624 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.250822 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.250856 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.250876 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.250900 drop table if exists "person_test"; [] +gorptest: 22:20:39.250919 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.250941 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.250959 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.250981 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.251000 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.251023 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.251042 drop table if exists "time_test"; [] +gorptest: 22:20:39.251070 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.251262 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.251433 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.251593 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.251795 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.251958 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.252115 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.252265 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.252440 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.252617 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.252819 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.252994 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.00s) === RUN TestSelectTooManyCols -2026/10/03 04:42:45 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: 04:42:45.271257 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.271415 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.271443 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.271463 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.271487 drop table if exists "person_test"; [] -gorptest: 04:42:45.271504 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.271520 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.271535 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.271550 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.271568 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.271585 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.271601 drop table if exists "time_test"; [] -gorptest: 04:42:45.271621 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.271767 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: 04:42:45.271899 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.272037 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.272212 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.272351 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.272466 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.272576 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.272689 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.272803 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.272931 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.273066 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.273208 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565273188245 2:1791002565273188245 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.273321 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565273316045 2:1791002565273316045 3:"jane" 4:"doe" 5:1] -gorptest: 04:42:45.273408 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.273468 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 04:42:45.273513 select * from person_test where Id=? [1:1] -gorptest: 04:42:45.273561 select * from person_test order by fname asc [] -gorptest: 04:42:45.273631 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.273745 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.273844 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.273933 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.274079 drop table if exists "person_test"; [] -gorptest: 04:42:45.274182 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.274278 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.274366 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.274451 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.274545 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.274635 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.274723 drop table if exists "time_test"; [] -gorptest: 04:42:45.274808 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.255282 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.255481 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.255518 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.255537 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.255561 drop table if exists "person_test"; [] +gorptest: 22:20:39.255579 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.255600 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.255617 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.255637 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.255661 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.255678 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.255699 drop table if exists "time_test"; [] +gorptest: 22:20:39.255722 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.255894 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.256048 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.256194 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.256386 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.256709 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.257071 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.257241 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.257410 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.257567 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.257719 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.257879 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.258052 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439258025920 2:1756592439258025920 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.258168 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439258161521 2:1756592439258161521 3:"jane" 4:"doe" 5:1] +gorptest: 22:20:39.258265 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.258333 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 22:20:39.258399 select * from person_test where Id=? [1:1] +gorptest: 22:20:39.258486 select * from person_test order by fname asc [] +gorptest: 22:20:39.258559 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.258701 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.258827 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.258946 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.259131 drop table if exists "person_test"; [] +gorptest: 22:20:39.259261 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.259378 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.259488 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.259595 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.259701 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.259805 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.259911 drop table if exists "time_test"; [] +gorptest: 22:20:39.260013 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.00s) === RUN TestSelectSingleVal -2026/10/03 04:42:45 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: 04:42:45.274980 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.275146 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.275170 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.275186 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.275202 drop table if exists "person_test"; [] -gorptest: 04:42:45.275218 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.275233 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.275251 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.275267 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.275282 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.275300 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.275318 drop table if exists "time_test"; [] -gorptest: 04:42:45.275339 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.275479 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: 04:42:45.275609 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.275728 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.275870 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.275986 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.276122 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.276251 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.276370 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.276482 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.276593 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.276703 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.276824 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565276811845 2:1791002565276811845 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.276936 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 04:42:45.277004 select * from person_test where Id=? [1:1] -gorptest: 04:42:45.277067 select FName from person_test where Id=? [1:1] -gorptest: 04:42:45.277100 select * from person_test where Id=? [1:1] -gorptest: 04:42:45.277158 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 04:42:45.277213 select * from person_test where Id=? [1:-2222] -gorptest: 04:42:45.277262 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1791002565277256325 2:1791002565277256325 3:"bob" 4:"smith" 5:1] -gorptest: 04:42:45.277356 select * from person_test where Fname='bob' [] -gorptest: 04:42:45.277424 select * from person_test where Id=-123 [] -gorptest: 04:42:45.277454 select * from person_test where Id=-123 [] -gorptest: 04:42:45.277478 select * from person_test where Id=-123 [] -gorptest: 04:42:45.277501 select * from person_test where Id=-123 [] -gorptest: 04:42:45.277527 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.277633 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.277748 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.277848 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.278014 drop table if exists "person_test"; [] -gorptest: 04:42:45.278125 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.278214 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.278308 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.278399 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.278502 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.278597 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.278690 drop table if exists "time_test"; [] -gorptest: 04:42:45.278780 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.260211 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.260415 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.260440 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.260461 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.260482 drop table if exists "person_test"; [] +gorptest: 22:20:39.260500 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.260547 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.260570 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.260587 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.260611 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.260635 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.260652 drop table if exists "time_test"; [] +gorptest: 22:20:39.260677 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.261031 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.261203 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.261345 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.261506 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.261639 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.261766 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.261893 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.262024 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.262153 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.262294 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.262436 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.262580 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439262565629 2:1756592439262565629 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.262686 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 22:20:39.262759 select * from person_test where Id=? [1:1] +gorptest: 22:20:39.262839 select FName from person_test where Id=? [1:1] +gorptest: 22:20:39.262875 select * from person_test where Id=? [1:1] +gorptest: 22:20:39.262931 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 22:20:39.262983 select * from person_test where Id=? [1:-2222] +gorptest: 22:20:39.263039 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1756592439263032752 2:1756592439263032752 3:"bob" 4:"smith" 5:1] +gorptest: 22:20:39.263139 select * from person_test where Fname='bob' [] +gorptest: 22:20:39.263216 select * from person_test where Id=-123 [] +gorptest: 22:20:39.263251 select * from person_test where Id=-123 [] +gorptest: 22:20:39.263281 select * from person_test where Id=-123 [] +gorptest: 22:20:39.263306 select * from person_test where Id=-123 [] +gorptest: 22:20:39.263337 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.263451 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.263562 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.263666 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.263847 drop table if exists "person_test"; [] +gorptest: 22:20:39.263977 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.264086 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.264191 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.264308 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.264415 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.264574 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.264705 drop table if exists "time_test"; [] +gorptest: 22:20:39.265045 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.00s) === RUN TestSelectAlias -2026/10/03 04:42:45 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: 04:42:45.278964 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.279128 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.279153 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.279183 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.279200 drop table if exists "person_test"; [] -gorptest: 04:42:45.279216 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.279233 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.279249 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.279268 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.279285 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.279300 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.279315 drop table if exists "time_test"; [] -gorptest: 04:42:45.279341 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.279509 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: 04:42:45.279644 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.279765 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.279922 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.280062 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.280209 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.280333 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.280448 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.280569 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.280683 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.280801 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.280938 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 04:42:45.281028 select * from id_created_test where Id=1 [] -gorptest: 04:42:45.281094 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 04:42:45.281146 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.281478 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.281597 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.281695 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.281876 drop table if exists "person_test"; [] -gorptest: 04:42:45.281982 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.282080 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.282183 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.282280 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.282378 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.282487 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.282586 drop table if exists "time_test"; [] -gorptest: 04:42:45.282724 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.265238 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.265412 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.265441 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.265457 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.265477 drop table if exists "person_test"; [] +gorptest: 22:20:39.265492 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.265511 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.265526 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.265544 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.265560 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.265582 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.265598 drop table if exists "time_test"; [] +gorptest: 22:20:39.265621 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.265780 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.265929 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.266070 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.266229 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.266361 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.266482 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.266602 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.266726 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.266852 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.266986 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.267117 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.267250 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 22:20:39.267344 select * from id_created_test where Id=1 [] +gorptest: 22:20:39.267408 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 22:20:39.267468 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.267833 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.267962 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.268071 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.268271 drop table if exists "person_test"; [] +gorptest: 22:20:39.268388 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.268494 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.268624 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.268731 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.269066 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.269191 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.269297 drop table if exists "time_test"; [] +gorptest: 22:20:39.269395 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.00s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2026/10/03 04:42:45 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: 04:42:45.283012 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.283225 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.283249 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.283269 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.283287 drop table if exists "person_test"; [] -gorptest: 04:42:45.283303 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.283320 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.283336 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.283354 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.283373 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.283414 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.283434 drop table if exists "time_test"; [] -gorptest: 04:42:45.283472 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.283629 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: 04:42:45.283751 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.283863 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.284003 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.284158 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.284280 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.284407 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.284526 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.284652 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.284770 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.284892 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.285076 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.285204 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.285313 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.285405 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.285588 drop table if exists "person_test"; [] -gorptest: 04:42:45.285703 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.285811 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.285907 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.285999 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.286090 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.286182 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.286273 drop table if exists "time_test"; [] -gorptest: 04:42:45.286378 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.286404 drop table if exists "single_column_table"; [] -gorptest: 04:42:45.286428 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: 04:42:45.286558 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: 04:42:45.286682 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.286798 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: 04:42:45.286935 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: 04:42:45.287054 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.287181 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.287298 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.287411 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.287539 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.287654 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: 04:42:45.287769 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.287873 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 04:42:45.287902 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 04:42:45.288019 delete from "invoice_test"; [] -gorptest: 04:42:45.288113 delete from "invoice_tag_test"; [] -gorptest: 04:42:45.288188 delete from "alias_trans_field_test"; [] -gorptest: 04:42:45.288244 delete from "invoice_override_test"; [] -gorptest: 04:42:45.288300 delete from "person_test"; [] -gorptest: 04:42:45.288351 delete from "ignored_column_test"; [] -gorptest: 04:42:45.288401 delete from "id_created_test"; [] -gorptest: 04:42:45.288450 delete from "type_conv_test"; [] -gorptest: 04:42:45.288500 delete from "embedded_struct_test"; [] -gorptest: 04:42:45.288549 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.288599 delete from "embedded_autoincr_test"; [] -gorptest: 04:42:45.288647 delete from "time_test"; [] -gorptest: 04:42:45.288695 delete from "id_created_test"; [] -gorptest: 04:42:45.288743 delete from "single_column_table"; [] -gorptest: 04:42:45.288811 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 04:42:45.288858 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.288979 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.289075 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.289169 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.289320 drop table if exists "person_test"; [] -gorptest: 04:42:45.289419 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.289512 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.289604 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.289706 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.289803 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.289893 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.289979 drop table if exists "time_test"; [] -gorptest: 04:42:45.290063 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.290086 drop table if exists "single_column_table"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.269614 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.269789 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.269813 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.269837 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.269856 drop table if exists "person_test"; [] +gorptest: 22:20:39.269872 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.269890 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.269905 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.269922 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.269938 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.269958 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.269973 drop table if exists "time_test"; [] +gorptest: 22:20:39.269998 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.270156 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.270299 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.270427 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.270575 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.270706 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.270831 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.270953 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.271077 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.271196 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.271329 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.271458 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.271579 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.271686 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.271800 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.271898 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.272086 drop table if exists "person_test"; [] +gorptest: 22:20:39.272197 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.272312 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.272415 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.272687 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.273053 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.273175 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.273275 drop table if exists "time_test"; [] +gorptest: 22:20:39.273368 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.273392 drop table if exists "single_column_table"; [] +gorptest: 22:20:39.273415 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.273547 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.273671 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.273789 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.273935 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.274064 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.274193 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.274309 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.274428 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.274575 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.274724 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.274856 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.274980 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 22:20:39.275013 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 22:20:39.275141 delete from "invoice_test"; [] +gorptest: 22:20:39.275207 delete from "invoice_tag_test"; [] +gorptest: 22:20:39.275267 delete from "alias_trans_field_test"; [] +gorptest: 22:20:39.275322 delete from "invoice_override_test"; [] +gorptest: 22:20:39.275393 delete from "person_test"; [] +gorptest: 22:20:39.275451 delete from "ignored_column_test"; [] +gorptest: 22:20:39.275507 delete from "id_created_test"; [] +gorptest: 22:20:39.275562 delete from "type_conv_test"; [] +gorptest: 22:20:39.275621 delete from "embedded_struct_test"; [] +gorptest: 22:20:39.275675 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.275730 delete from "embedded_autoincr_test"; [] +gorptest: 22:20:39.275783 delete from "time_test"; [] +gorptest: 22:20:39.275838 delete from "id_created_test"; [] +gorptest: 22:20:39.275891 delete from "single_column_table"; [] +gorptest: 22:20:39.275962 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 22:20:39.276010 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.276114 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.276218 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.276332 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.276545 drop table if exists "person_test"; [] +gorptest: 22:20:39.276665 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.276929 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.277141 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.277248 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.277346 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.277436 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.277525 drop table if exists "time_test"; [] +gorptest: 22:20:39.277613 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.277638 drop table if exists "single_column_table"; [] --- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) === RUN TestPrepare -2026/10/03 04:42:45 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: 04:42:45.290376 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.290548 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.290569 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.290588 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.290603 drop table if exists "person_test"; [] -gorptest: 04:42:45.290621 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.290637 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.290652 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.290668 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.290684 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.290699 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.290714 drop table if exists "time_test"; [] -gorptest: 04:42:45.290734 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.290875 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: 04:42:45.291001 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 04:42:45.291123 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 04:42:45.291260 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 04:42:45.291381 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.291495 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 04:42:45.291601 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 04:42:45.291710 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 04:42:45.291819 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 04:42:45.291930 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 04:42:45.292039 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 04:42:45.292181 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 04:42:45.292278 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 04:42:45.292363 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 04:42:45.292451 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 04:42:45.292529 begin; [] -gorptest: 04:42:45.292555 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 04:42:45.292615 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 04:42:45.292849 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 04:42:45.292920 commit; [] -gorptest: 04:42:45.292988 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 04:42:45.293060 drop table if exists "invoice_test"; [] -gorptest: 04:42:45.293236 drop table if exists "invoice_tag_test"; [] -gorptest: 04:42:45.293349 drop table if exists "alias_trans_field_test"; [] -gorptest: 04:42:45.293447 drop table if exists "invoice_override_test"; [] -gorptest: 04:42:45.293614 drop table if exists "person_test"; [] -gorptest: 04:42:45.293723 drop table if exists "ignored_column_test"; [] -gorptest: 04:42:45.293819 drop table if exists "id_created_test"; [] -gorptest: 04:42:45.293907 drop table if exists "type_conv_test"; [] -gorptest: 04:42:45.294001 drop table if exists "embedded_struct_test"; [] -gorptest: 04:42:45.294094 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 04:42:45.294189 drop table if exists "embedded_autoincr_test"; [] -gorptest: 04:42:45.294279 drop table if exists "time_test"; [] -gorptest: 04:42:45.294365 drop table if exists "id_created_test"; [] +2025/08/30 22:20:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 22:20:39.277992 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.278173 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.278200 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.278214 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.278232 drop table if exists "person_test"; [] +gorptest: 22:20:39.278246 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.278266 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.278280 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.278297 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.278311 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.278330 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.278344 drop table if exists "time_test"; [] +gorptest: 22:20:39.278366 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.278510 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] +gorptest: 22:20:39.278641 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 22:20:39.278757 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 22:20:39.278907 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 22:20:39.279043 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.279168 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 22:20:39.279286 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 22:20:39.279404 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 22:20:39.279528 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 22:20:39.279653 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 22:20:39.279786 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 22:20:39.279924 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 22:20:39.280025 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 22:20:39.280117 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 22:20:39.280204 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 22:20:39.280298 begin; [] +gorptest: 22:20:39.280329 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 22:20:39.280389 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 22:20:39.280672 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 22:20:39.280735 commit; [] +gorptest: 22:20:39.280842 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 22:20:39.280922 drop table if exists "invoice_test"; [] +gorptest: 22:20:39.281356 drop table if exists "invoice_tag_test"; [] +gorptest: 22:20:39.281483 drop table if exists "alias_trans_field_test"; [] +gorptest: 22:20:39.281585 drop table if exists "invoice_override_test"; [] +gorptest: 22:20:39.281770 drop table if exists "person_test"; [] +gorptest: 22:20:39.281878 drop table if exists "ignored_column_test"; [] +gorptest: 22:20:39.281974 drop table if exists "id_created_test"; [] +gorptest: 22:20:39.282064 drop table if exists "type_conv_test"; [] +gorptest: 22:20:39.282154 drop table if exists "embedded_struct_test"; [] +gorptest: 22:20:39.282245 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 22:20:39.282333 drop table if exists "embedded_autoincr_test"; [] +gorptest: 22:20:39.282421 drop table if exists "time_test"; [] +gorptest: 22:20:39.282509 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.00s) PASS -ok gopkg.in/gorp.v1 0.160s +ok gopkg.in/gorp.v1 0.190s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang @@ -1834,12 +1870,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/2093667/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/2093667/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/1649855 and its subdirectories -I: Current time: Fri Oct 2 16:42:49 -12 2026 -I: pbuilder-time-stamp: 1791002569 +I: removing directory /srv/workspace/pbuilder/2093667 and its subdirectories +I: Current time: Sun Aug 31 12:20:43 +14 2025 +I: pbuilder-time-stamp: 1756592443