Diff of the two buildlogs: -- --- b1/build.log 2024-05-17 11:20:36.177164406 +0000 +++ b2/build.log 2024-05-17 11:21:28.794927719 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Thu May 16 23:19:53 -12 2024 -I: pbuilder-time-stamp: 1715944793 +I: Current time: Fri Jun 20 07:43:38 +14 2025 +I: pbuilder-time-stamp: 1750355018 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/unstable-reproducible-base.tgz] I: copying local configuration @@ -25,52 +25,84 @@ dpkg-source: info: unpacking golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz I: Not using root during the build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/3057374/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/3508731/tmp/hooks/D01_modify_environment starting +debug: Running on codethink03-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 Jun 19 17:43 /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/3508731/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/3508731/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]="21" [3]="1" [4]="release" [5]="aarch64-unknown-linux-gnu") + BASH_VERSION='5.2.21(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='unstable' - HOME='/root' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=unstable + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - INVOCATION_ID='1ed81c78297940ba9d1aa4ff502d57d4' - 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='3057374' - PS1='# ' - PS2='> ' + INVOCATION_ID=8faa88f838584c449e5dbfccbe0ecf7f + 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=3508731 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.yrmzUaU1/pbuilderrc_OQP4 --distribution unstable --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.yrmzUaU1/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' - SUDO_GID='109' - SUDO_UID='104' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://192.168.101.4:3128' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.yrmzUaU1/pbuilderrc_9CMd --distribution unstable --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.yrmzUaU1/b2 --logfile b2/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' + SUDO_GID=109 + SUDO_UID=104 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://192.168.101.4:3128 I: uname -a - Linux codethink02-arm64 6.1.0-21-cloud-arm64 #1 SMP Debian 6.1.90-1 (2024-05-03) aarch64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-21-cloud-arm64 #1 SMP Debian 6.1.90-1 (2024-05-03) aarch64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 May 17 07:42 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/3057374/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Jun 19 14:05 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/3508731/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: 58 http://deb.debian.org/debian unstable/main arm64 libsqlite3-dev arm64 3.45.3-1 [1042 kB] Get: 59 http://deb.debian.org/debian unstable/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.19~ds1-1 [83.4 kB] Get: 60 http://deb.debian.org/debian unstable/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 67.7 MB in 0s (229 MB/s) +Fetched 67.7 MB in 0s (154 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19764 files and directories currently installed.) @@ -433,7 +465,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/3508731/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for unstable +I: user script /srv/workspace/pbuilder/3508731/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 @@ -452,38 +488,38 @@ 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/coverage/rtcov -internal/goos -internal/godebugs +sync/atomic internal/unsafeheader +internal/cpu +runtime/internal/syscall +internal/godebugs +internal/goos +internal/goexperiment +internal/coverage/rtcov internal/goarch unicode -internal/goexperiment -internal/itoa internal/race -unicode/utf8 -internal/cpu -runtime/internal/syscall -sync/atomic -math/bits -cmp -log/internal internal/chacha8rand +unicode/utf8 internal/abi +internal/itoa +math/bits runtime/internal/math +cmp runtime/internal/sys +log/internal slices math -runtime/internal/atomic internal/bytealg +runtime/internal/atomic runtime internal/reflectlite sync internal/testlog errors sort -io internal/oserror +io internal/safefilepath path strconv @@ -492,8 +528,8 @@ strings reflect regexp/syntax -internal/syscall/execenv time +internal/syscall/execenv internal/syscall/unix regexp context @@ -509,1283 +545,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 -2024/05/17 11:20:31 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: 11:20:31.886553 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.888477 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.888530 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.888558 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.888581 drop table if exists "person_test"; [] -gorptest: 11:20:31.888607 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.888636 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.888664 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.888691 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.888717 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.888743 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.888766 drop table if exists "time_test"; [] -gorptest: 11:20:31.888807 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.889146 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: 11:20:31.889370 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.889579 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.889819 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.890015 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.890264 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.890481 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.890674 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.890847 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.891017 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.891171 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.891428 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: 11:20:31.891474 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: 11:20:31.891514 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.891545 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: 11:20:31.891574 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: 11:20:31.891602 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.891626 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.891653 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.891681 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.891707 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.891735 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: 11:20:31.891761 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.891785 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 11:20:31.891808 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.891996 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.892134 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.892256 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.892491 drop table if exists "person_test"; [] -gorptest: 11:20:31.892628 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.892754 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.892876 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.892995 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.893112 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.893229 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.893348 drop table if exists "time_test"; [] -gorptest: 11:20:31.893475 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.772642 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.774592 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.774619 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.774637 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.774677 drop table if exists "person_test"; [] +gorptest: 17:44:22.774699 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.774716 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.774732 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.774747 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.774762 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.774777 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.774792 drop table if exists "time_test"; [] +gorptest: 17:44:22.774821 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.775088 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: 17:44:22.775237 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.775357 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.775512 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.775638 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.775752 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.775863 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.775976 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.776092 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.776209 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.776512 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.776799 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: 17:44:22.776835 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: 17:44:22.776857 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.776879 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: 17:44:22.776901 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: 17:44:22.776920 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.776938 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.776957 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.776977 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.776996 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.777016 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: 17:44:22.777034 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.777052 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 17:44:22.777069 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.777217 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.777326 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.777424 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.777618 drop table if exists "person_test"; [] +gorptest: 17:44:22.777725 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.777818 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.777906 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.777996 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.778083 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.778248 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.778360 drop table if exists "time_test"; [] +gorptest: 17:44:22.778758 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables -2024/05/17 11:20:31 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: 11:20:31.893981 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.894292 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.894332 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.894354 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.894382 drop table if exists "person_test"; [] -gorptest: 11:20:31.894405 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.894425 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.894447 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.894474 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.894528 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.894552 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.894575 drop table if exists "time_test"; [] -gorptest: 11:20:31.894606 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.894827 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: 11:20:31.895014 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.895172 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.895381 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.895561 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.895707 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.895873 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.896046 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.896213 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.896374 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.896533 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.896700 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: 11:20:31.896742 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: 11:20:31.896776 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.896803 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: 11:20:31.896832 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: 11:20:31.896855 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.896878 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.896902 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.896941 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.896973 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.896999 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: 11:20:31.897030 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.897055 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 11:20:31.897109 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831897089313 2:1715944831897089313 3:"Bob" 4:"Smith" 5:1] -gorptest: 11:20:31.897258 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 11:20:31.897411 delete from "invoice_test"; [] -gorptest: 11:20:31.897519 delete from "invoice_tag_test"; [] -gorptest: 11:20:31.897601 delete from "alias_trans_field_test"; [] -gorptest: 11:20:31.897674 delete from "invoice_override_test"; [] -gorptest: 11:20:31.897751 delete from "person_test"; [] -gorptest: 11:20:31.897820 delete from "ignored_column_test"; [] -gorptest: 11:20:31.897888 delete from "id_created_test"; [] -gorptest: 11:20:31.897959 delete from "type_conv_test"; [] -gorptest: 11:20:31.898030 delete from "embedded_struct_test"; [] -gorptest: 11:20:31.898099 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.898225 delete from "embedded_autoincr_test"; [] -gorptest: 11:20:31.898325 delete from "time_test"; [] -gorptest: 11:20:31.898402 delete from "id_created_test"; [] -gorptest: 11:20:31.898474 SELECT * FROM person_test [] -gorptest: 11:20:31.898563 SELECT * FROM invoice_test [] -gorptest: 11:20:31.898655 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.898813 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.899238 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.899372 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.899595 drop table if exists "person_test"; [] -gorptest: 11:20:31.899740 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.899859 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.899974 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.900090 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.900198 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.900309 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.900417 drop table if exists "time_test"; [] -gorptest: 11:20:31.900527 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.779163 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.779354 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.779374 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.779390 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.779405 drop table if exists "person_test"; [] +gorptest: 17:44:22.779424 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.779439 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.779454 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.779471 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.779486 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.779501 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.779516 drop table if exists "time_test"; [] +gorptest: 17:44:22.779539 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.779705 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: 17:44:22.779839 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.779962 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.780123 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.780253 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.780600 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.780768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.780908 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.781030 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.781151 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.781275 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.781397 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: 17:44:22.781460 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: 17:44:22.781484 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.781506 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: 17:44:22.781529 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: 17:44:22.781547 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.781564 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.781583 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.781602 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.781631 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.781674 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: 17:44:22.781694 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.781713 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 17:44:22.781757 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062781736598 2:1750355062781736598 3:"Bob" 4:"Smith" 5:1] +gorptest: 17:44:22.781894 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 17:44:22.782051 delete from "invoice_test"; [] +gorptest: 17:44:22.782171 delete from "invoice_tag_test"; [] +gorptest: 17:44:22.782255 delete from "alias_trans_field_test"; [] +gorptest: 17:44:22.782324 delete from "invoice_override_test"; [] +gorptest: 17:44:22.782409 delete from "person_test"; [] +gorptest: 17:44:22.782493 delete from "ignored_column_test"; [] +gorptest: 17:44:22.782553 delete from "id_created_test"; [] +gorptest: 17:44:22.782605 delete from "type_conv_test"; [] +gorptest: 17:44:22.782685 delete from "embedded_struct_test"; [] +gorptest: 17:44:22.782754 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.782809 delete from "embedded_autoincr_test"; [] +gorptest: 17:44:22.782861 delete from "time_test"; [] +gorptest: 17:44:22.782911 delete from "id_created_test"; [] +gorptest: 17:44:22.782959 SELECT * FROM person_test [] +gorptest: 17:44:22.783038 SELECT * FROM invoice_test [] +gorptest: 17:44:22.783080 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.783202 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.783296 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.783384 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.783568 drop table if exists "person_test"; [] +gorptest: 17:44:22.783701 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.783796 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.783901 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.783996 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.784087 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.784178 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.784268 drop table if exists "time_test"; [] +gorptest: 17:44:22.784412 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType -gorptest: 11:20:31.900695 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 11:20:31.901075 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-05-17 11:20:31 +0000 UTC] -gorptest: 11:20:31.901200 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 11:20:31.901275 drop table if exists "WithCustomDate"; [] +gorptest: 17:44:22.784567 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 17:44:22.784916 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-06-19 17:44:22 +0000 UTC] +gorptest: 17:44:22.785037 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 17:44:22.785102 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey -gorptest: 11:20:31.901557 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 11:20:31.901914 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 11:20:31.902074 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 11:20:31.902296 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 11:20:31.902436 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 11:20:31.902550 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 11:20:31.902645 drop table if exists "PersonUInt64"; [] -gorptest: 11:20:31.902819 drop table if exists "PersonUInt32"; [] -gorptest: 11:20:31.902953 drop table if exists "PersonUInt16"; [] +gorptest: 17:44:22.785347 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 17:44:22.785642 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 17:44:22.785779 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 17:44:22.785905 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 17:44:22.785998 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 17:44:22.786077 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 17:44:22.786208 drop table if exists "PersonUInt64"; [] +gorptest: 17:44:22.786360 drop table if exists "PersonUInt32"; [] +gorptest: 17:44:22.786468 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether -gorptest: 11:20:31.903182 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 11:20:31.903571 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 11:20:31.903704 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 11:20:31.903775 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 11:20:31.903822 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 11:20:31.903917 drop table if exists "UniqueColumns"; [] +gorptest: 17:44:22.786957 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 17:44:22.787304 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 17:44:22.787418 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 17:44:22.787483 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 17:44:22.787523 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 17:44:22.787599 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser -gorptest: 11:20:31.904315 drop table if exists PersistentUser [] -gorptest: 11:20:31.904524 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 11:20:31.904720 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 11:20:31.904828 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 11:20:31.904896 select * from PersistentUser [] -gorptest: 11:20:31.904965 select * from PersistentUser [] -gorptest: 11:20:31.905019 select * from PersistentUser [] -gorptest: 11:20:31.905062 select Id from PersistentUser [] -gorptest: 11:20:31.905094 select mykey from PersistentUser [] -gorptest: 11:20:31.905125 select PassedTraining from PersistentUser [] -gorptest: 11:20:31.905155 select Id from PersistentUser [] -gorptest: 11:20:31.905190 drop table if exists "PersistentUser"; [] +gorptest: 17:44:22.787959 drop table if exists PersistentUser [] +gorptest: 17:44:22.788136 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 17:44:22.788299 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 17:44:22.788568 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 17:44:22.788636 select * from PersistentUser [] +gorptest: 17:44:22.788697 select * from PersistentUser [] +gorptest: 17:44:22.788734 select * from PersistentUser [] +gorptest: 17:44:22.788767 select Id from PersistentUser [] +gorptest: 17:44:22.788793 select mykey from PersistentUser [] +gorptest: 17:44:22.788816 select PassedTraining from PersistentUser [] +gorptest: 17:44:22.788840 select Id from PersistentUser [] +gorptest: 17:44:22.788865 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap -gorptest: 11:20:31.905406 drop table if exists PersistentUser [] -gorptest: 11:20:31.905630 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 11:20:31.905820 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 11:20:31.905930 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 11:20:31.906051 select * from PersistentUser where mykey = ? [1:43] -gorptest: 11:20:31.906184 select * from PersistentUser where mykey = ? [1:43] -gorptest: 11:20:31.906255 +gorptest: 17:44:22.789066 drop table if exists PersistentUser [] +gorptest: 17:44:22.789232 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 17:44:22.789379 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 17:44:22.789459 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 17:44:22.789544 select * from PersistentUser where mykey = ? [1:43] +gorptest: 17:44:22.789610 select * from PersistentUser where mykey = ? [1:43] +gorptest: 17:44:22.789653 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 11:20:31.906314 +gorptest: 17:44:22.789695 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 11:20:31.906361 drop table if exists "PersistentUser"; [] +gorptest: 17:44:22.789730 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct -gorptest: 11:20:31.906618 drop table if exists PersistentUser [] -gorptest: 11:20:31.906836 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 11:20:31.907019 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 11:20:31.907133 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 11:20:31.907222 +gorptest: 17:44:22.789926 drop table if exists PersistentUser [] +gorptest: 17:44:22.790096 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 17:44:22.790342 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 17:44:22.790439 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 17:44:22.790512 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 11:20:31.907297 drop table if exists "PersistentUser"; [] +gorptest: 17:44:22.790614 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice -2024/05/17 11:20:31 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: 11:20:31.907646 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.907812 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.907840 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.907859 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.907881 drop table if exists "person_test"; [] -gorptest: 11:20:31.907900 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.907918 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.907937 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.907954 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.907972 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.907990 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.908008 drop table if exists "time_test"; [] -gorptest: 11:20:31.908032 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.908208 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: 11:20:31.908366 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.908515 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.908701 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.908853 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.908998 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.909144 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.909288 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.909432 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.909799 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.909970 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.910160 select * from invoice_test where id=99999 [] -gorptest: 11:20:31.910251 select * from invoice_test where id=99999 [] -gorptest: 11:20:31.910308 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.910471 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.910611 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.910728 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.910985 drop table if exists "person_test"; [] -gorptest: 11:20:31.911144 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.911262 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.911375 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.911485 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.911592 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.911699 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.911820 drop table if exists "time_test"; [] -gorptest: 11:20:31.911929 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.790869 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.791023 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.791042 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.791057 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.791073 drop table if exists "person_test"; [] +gorptest: 17:44:22.791087 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.791102 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.791117 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.791131 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.791146 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.791160 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.791174 drop table if exists "time_test"; [] +gorptest: 17:44:22.791193 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.791341 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: 17:44:22.791470 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.791585 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.791732 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.791852 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.791963 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.792071 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.792184 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.792298 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.792685 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.792829 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.792959 select * from invoice_test where id=99999 [] +gorptest: 17:44:22.793019 select * from invoice_test where id=99999 [] +gorptest: 17:44:22.793059 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.793159 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.793250 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.793336 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.793509 drop table if exists "person_test"; [] +gorptest: 17:44:22.793611 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.793702 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.793786 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.793872 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.793955 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.794039 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.794173 drop table if exists "time_test"; [] +gorptest: 17:44:22.794295 drop table if exists "id_created_test"; [] --- PASS: TestReturnsNonNilSlice (0.00s) === RUN TestOverrideVersionCol -gorptest: 11:20:31.912081 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 11:20:31.912465 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: 11:20:31.912542 drop table if exists "InvoicePersonView"; [] +gorptest: 17:44:22.794735 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 17:44:22.795112 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: 17:44:22.795162 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking -2024/05/17 11:20:31 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: 11:20:31.912900 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.913072 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.913101 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.913122 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.913145 drop table if exists "person_test"; [] -gorptest: 11:20:31.913168 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.913190 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.913207 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.913225 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.913247 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.913267 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.913287 drop table if exists "time_test"; [] -gorptest: 11:20:31.913314 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.913508 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: 11:20:31.913675 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.913831 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.914012 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.914218 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.914407 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.914572 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.915022 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.915194 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.915352 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.915497 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.915643 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831915627742 2:1715944831915627742 3:"Bob" 4:"Smith" 5:1] -gorptest: 11:20:31.915747 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.915823 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715944831915627742 2:1715944831915627742 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 11:20:31.915955 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715944831915627742 2:1715944831915627742 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 11:20:31.916002 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.916058 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 11:20:31.916095 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.916134 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.916254 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.916358 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.916457 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.916632 drop table if exists "person_test"; [] -gorptest: 11:20:31.916749 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.916853 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.916953 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.917050 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.917148 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.917245 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.917341 drop table if exists "time_test"; [] -gorptest: 11:20:31.917434 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.795475 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.795631 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.795648 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.795664 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.795678 drop table if exists "person_test"; [] +gorptest: 17:44:22.795692 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.795705 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.795720 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.795734 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.795750 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.795764 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.795778 drop table if exists "time_test"; [] +gorptest: 17:44:22.795799 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.795946 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: 17:44:22.796070 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.796181 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.796428 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.796596 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.796728 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.796848 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.796969 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.797096 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.797227 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.797351 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.797498 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062797482478 2:1750355062797482478 3:"Bob" 4:"Smith" 5:1] +gorptest: 17:44:22.797600 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.797681 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750355062797482478 2:1750355062797482478 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 17:44:22.797770 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750355062797482478 2:1750355062797482478 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 17:44:22.797811 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.797862 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 17:44:22.797894 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.797929 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.798028 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.798322 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.798457 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.798653 drop table if exists "person_test"; [] +gorptest: 17:44:22.798778 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.798877 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.798968 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.799059 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.799149 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.799238 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.799328 drop table if exists "time_test"; [] +gorptest: 17:44:22.799414 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.00s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 11:20:31.917700 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 11:20:31.918065 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 11:20:31.918410 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 11:20:31.918507 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: 11:20:31.918618 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 11:20:31.918684 drop table if exists "TableWithNull"; [] +gorptest: 17:44:22.799699 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 17:44:22.800004 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 17:44:22.800097 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 17:44:22.800178 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: 17:44:22.800281 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 17:44:22.800376 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps -gorptest: 11:20:31.918913 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 11:20:31.919264 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 11:20:31.919386 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 11:20:31.919464 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 11:20:31.919514 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 11:20:31.919547 drop table if exists "Invoice"; [] +gorptest: 17:44:22.800589 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 17:44:22.800914 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 17:44:22.801026 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 17:44:22.801084 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 17:44:22.801130 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 17:44:22.801161 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect -2024/05/17 11:20:31 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: 11:20:31.919873 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.920034 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.920054 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.920070 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.920086 drop table if exists "person_test"; [] -gorptest: 11:20:31.920102 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.920123 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.920143 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.920159 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.920177 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.920194 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.920210 drop table if exists "time_test"; [] -gorptest: 11:20:31.920232 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.920396 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: 11:20:31.920533 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.920662 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.920824 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.920964 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.921086 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.921208 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.921336 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.921469 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.921737 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.921916 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.922084 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831922069220 2:1715944831922069220 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.922462 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 11:20:31.922564 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 11:20:31.922652 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.922775 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.922882 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.922994 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.923187 drop table if exists "person_test"; [] -gorptest: 11:20:31.923309 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.923410 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.923508 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.923605 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.923702 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.923801 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.923901 drop table if exists "time_test"; [] -gorptest: 11:20:31.923997 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.801491 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.801641 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.801668 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.801684 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.801699 drop table if exists "person_test"; [] +gorptest: 17:44:22.801714 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.801731 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.801745 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.801759 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.801776 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.801790 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.801804 drop table if exists "time_test"; [] +gorptest: 17:44:22.801825 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.802013 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: 17:44:22.802176 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.802315 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.802466 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.802608 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.802733 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.802850 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.802969 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.803096 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.803223 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.803351 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.803486 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062803468918 2:1750355062803468918 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.803589 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 17:44:22.803666 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 17:44:22.803745 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.803857 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.803954 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.804043 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.804237 drop table if exists "person_test"; [] +gorptest: 17:44:22.804459 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.804572 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.804661 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.804747 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.804833 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.804919 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.805013 drop table if exists "time_test"; [] +gorptest: 17:44:22.805094 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.00s) === RUN TestHooks -2024/05/17 11:20:31 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: 11:20:31.924178 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.924359 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.924384 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.924402 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.924425 drop table if exists "person_test"; [] -gorptest: 11:20:31.924441 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.924462 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.924481 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.924499 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.924518 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.924537 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.924554 drop table if exists "time_test"; [] -gorptest: 11:20:31.924579 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.924738 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: 11:20:31.924882 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.925010 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.925170 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.925301 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.925423 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.925573 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.925711 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.925840 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.925974 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.926105 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.926319 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831926303645 2:1715944831926303645 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.926459 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.926542 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1715944831926303645 2:1715944831926303645 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 11:20:31.926639 select * from person_test where id = ? [1:1] -gorptest: 11:20:31.926743 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 11:20:31.926848 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.926965 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.927073 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.927173 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.927361 drop table if exists "person_test"; [] -gorptest: 11:20:31.927485 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.927583 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.927679 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.927770 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.927860 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.927947 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.928035 drop table if exists "time_test"; [] -gorptest: 11:20:31.928124 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.805258 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.805416 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.805451 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.805466 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.805481 drop table if exists "person_test"; [] +gorptest: 17:44:22.805495 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.805518 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.805532 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.805558 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.805579 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.805594 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.805611 drop table if exists "time_test"; [] +gorptest: 17:44:22.805632 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.805784 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: 17:44:22.805925 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.806050 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.806224 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.806365 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.806491 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.806607 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.806726 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.806845 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.806966 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.807085 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.807216 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062807202358 2:1750355062807202358 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.807314 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.807380 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750355062807202358 2:1750355062807202358 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 17:44:22.807467 select * from person_test where id = ? [1:1] +gorptest: 17:44:22.807535 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 17:44:22.807617 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.807723 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.807818 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.807911 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.808091 drop table if exists "person_test"; [] +gorptest: 17:44:22.808204 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.808302 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.808424 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.808520 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.808608 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.808698 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.808783 drop table if exists "time_test"; [] +gorptest: 17:44:22.808866 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.00s) === RUN TestTransaction -2024/05/17 11:20:31 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: 11:20:31.928315 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.928489 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.928523 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.928543 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.928562 drop table if exists "person_test"; [] -gorptest: 11:20:31.928580 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.928599 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.928620 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.928643 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.928662 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.928680 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.928699 drop table if exists "time_test"; [] -gorptest: 11:20:31.928724 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.928914 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: 11:20:31.929065 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.929203 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.929368 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.929517 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.929649 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.929775 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.929902 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.930032 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.930395 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.930555 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.930692 begin; [] -gorptest: 11:20:31.930757 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 11:20:31.930835 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 11:20:31.930859 commit; [] -gorptest: 11:20:31.930910 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.930985 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 11:20:31.931029 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.931150 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.931251 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.931346 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.931525 drop table if exists "person_test"; [] -gorptest: 11:20:31.931648 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.931748 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.931841 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.931933 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.932026 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.932125 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.932217 drop table if exists "time_test"; [] -gorptest: 11:20:31.932306 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.809033 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.809194 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.809221 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.809236 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.809253 drop table if exists "person_test"; [] +gorptest: 17:44:22.809268 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.809285 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.809299 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.809317 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.809331 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.809351 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.809365 drop table if exists "time_test"; [] +gorptest: 17:44:22.809388 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.809570 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: 17:44:22.809712 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.809840 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.809990 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.810139 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.810276 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.810401 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.810523 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.810644 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.810765 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.810886 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.811003 begin; [] +gorptest: 17:44:22.811052 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 17:44:22.811131 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 17:44:22.811150 commit; [] +gorptest: 17:44:22.811196 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.811258 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 17:44:22.811296 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.811402 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.811491 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.811573 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.811745 drop table if exists "person_test"; [] +gorptest: 17:44:22.811842 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.811927 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.812008 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.812086 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.812164 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.812245 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.812646 drop table if exists "time_test"; [] +gorptest: 17:44:22.812779 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.00s) === RUN TestSavepoint -2024/05/17 11:20:31 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: 11:20:31.932477 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.932644 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.932667 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.932686 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.932704 drop table if exists "person_test"; [] -gorptest: 11:20:31.932725 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.932748 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.932764 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.932780 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.932796 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.932811 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.932826 drop table if exists "time_test"; [] -gorptest: 11:20:31.932848 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.933007 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: 11:20:31.933148 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.933276 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.933433 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.933771 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.933926 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.934085 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.934307 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.934461 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.934620 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.934760 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.934885 begin; [] -gorptest: 11:20:31.934927 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 11:20:31.934992 select memo from invoice_test [] -gorptest: 11:20:31.935033 savepoint "foo" [1:] -gorptest: 11:20:31.935040 select memo from invoice_test [] -gorptest: 11:20:31.935066 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 11:20:31.935097 select memo from invoice_test [] -gorptest: 11:20:31.935118 rollback to savepoint "foo" [1:] -gorptest: 11:20:31.935128 select memo from invoice_test [] -gorptest: 11:20:31.935140 rollback; [] -gorptest: 11:20:31.935184 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.935300 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.935401 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.935495 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.935674 drop table if exists "person_test"; [] -gorptest: 11:20:31.935780 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.935877 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.935969 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.936061 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.936153 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.936246 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.936334 drop table if exists "time_test"; [] -gorptest: 11:20:31.936420 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.812945 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.813101 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.813118 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.813132 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.813146 drop table if exists "person_test"; [] +gorptest: 17:44:22.813159 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.813173 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.813188 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.813201 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.813215 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.813229 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.813243 drop table if exists "time_test"; [] +gorptest: 17:44:22.813263 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.813406 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: 17:44:22.813524 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.813634 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.813772 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.813886 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.813991 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.814097 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.814245 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.814362 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.814476 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.814586 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.814695 begin; [] +gorptest: 17:44:22.814729 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 17:44:22.814789 select memo from invoice_test [] +gorptest: 17:44:22.814819 savepoint "foo" [1:] +gorptest: 17:44:22.814827 select memo from invoice_test [] +gorptest: 17:44:22.814849 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 17:44:22.814885 select memo from invoice_test [] +gorptest: 17:44:22.814907 rollback to savepoint "foo" [1:] +gorptest: 17:44:22.814916 select memo from invoice_test [] +gorptest: 17:44:22.814927 rollback; [] +gorptest: 17:44:22.814970 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.815068 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.815157 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.815239 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.815420 drop table if exists "person_test"; [] +gorptest: 17:44:22.815539 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.815628 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.815711 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.815795 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.815872 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.815956 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.816036 drop table if exists "time_test"; [] +gorptest: 17:44:22.816114 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.00s) === RUN TestMultiple -2024/05/17 11:20:31 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: 11:20:31.936598 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.936774 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.936797 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.936812 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.936829 drop table if exists "person_test"; [] -gorptest: 11:20:31.936847 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.936864 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.936881 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.936897 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.936914 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.936931 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.936949 drop table if exists "time_test"; [] -gorptest: 11:20:31.936972 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.937130 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: 11:20:31.937275 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.937400 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.937577 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.937718 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.937839 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.937957 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.938089 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.938484 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.938633 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.938766 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.938917 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 11:20:31.939023 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 11:20:31.939109 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 11:20:31.939185 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 11:20:31.939261 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.939325 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 11:20:31.939384 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.939481 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.939573 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.939666 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.939833 drop table if exists "person_test"; [] -gorptest: 11:20:31.939937 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.940026 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.940114 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.940202 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.940288 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.940375 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.940465 drop table if exists "time_test"; [] -gorptest: 11:20:31.940552 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.816274 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.816665 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.816689 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.816705 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.816720 drop table if exists "person_test"; [] +gorptest: 17:44:22.816734 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.816747 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.816761 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.816774 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.816789 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.816802 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.816815 drop table if exists "time_test"; [] +gorptest: 17:44:22.816845 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.817016 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: 17:44:22.817141 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.817253 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.817397 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.817521 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.817649 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.817758 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.817867 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.817977 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.818086 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.818237 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.818386 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 17:44:22.818492 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 17:44:22.818577 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 17:44:22.818654 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 17:44:22.818726 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.818787 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 17:44:22.818843 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.818936 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.819019 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.819112 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.819278 drop table if exists "person_test"; [] +gorptest: 17:44:22.819375 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.819458 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.819540 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.819622 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.819702 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.819782 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.819861 drop table if exists "time_test"; [] +gorptest: 17:44:22.819938 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.00s) === RUN TestCrud -2024/05/17 11:20:31 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: 11:20:31.940723 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.940886 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.940908 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.940923 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.940937 drop table if exists "person_test"; [] -gorptest: 11:20:31.940958 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.940972 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.940986 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.941000 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.941014 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.941029 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.941043 drop table if exists "time_test"; [] -gorptest: 11:20:31.941062 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.941215 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: 11:20:31.941349 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.941471 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.941640 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.941766 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.941882 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.942007 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.942437 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.942590 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.942723 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.942845 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.942955 delete from invoice_test [] -gorptest: 11:20:31.943034 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 11:20:31.943119 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.943195 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:4117051046416640600 2:5574761127131685547 3:"random 3773972748535336359" 4:0 5:true 6:1] -gorptest: 11:20:31.943282 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.943325 select * from invoice_test [] -gorptest: 11:20:31.943380 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.943466 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 11:20:31.943505 delete from invoice_tag_test [] -gorptest: 11:20:31.943588 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: 11:20:31.943706 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 11:20:31.943774 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:863407078796148594 2:6146491445850444110 3:"random 1757099716306235148" 4:33 5:false 6:1] -gorptest: 11:20:31.943853 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 11:20:31.943898 select * from invoice_tag_test [] -gorptest: 11:20:31.943957 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 11:20:31.944030 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 11:20:31.944065 delete from alias_trans_field_test [] -gorptest: 11:20:31.944129 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 11:20:31.944204 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 11:20:31.944250 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 1254935644359226169" 2:1] -gorptest: 11:20:31.944319 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 11:20:31.944360 select * from alias_trans_field_test [] -gorptest: 11:20:31.944400 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 11:20:31.944469 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 11:20:31.944509 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.944619 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.944721 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.944815 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.944995 drop table if exists "person_test"; [] -gorptest: 11:20:31.945101 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.945197 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.945288 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.945378 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.945474 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.945584 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.945677 drop table if exists "time_test"; [] -gorptest: 11:20:31.945765 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.820135 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.820340 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.820363 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.820377 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.820392 drop table if exists "person_test"; [] +gorptest: 17:44:22.820406 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.820420 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.820434 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.820448 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.820461 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.820475 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.820488 drop table if exists "time_test"; [] +gorptest: 17:44:22.820508 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.820672 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: 17:44:22.820821 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.820944 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.821091 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.821221 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.821326 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.821432 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.821552 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.821667 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.821790 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.821902 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.822025 delete from invoice_test [] +gorptest: 17:44:22.822103 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 17:44:22.822227 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.822324 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:957371841704234156 2:5596934697958117909 3:"random 1222895011123890544" 4:0 5:true 6:1] +gorptest: 17:44:22.822412 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.822464 select * from invoice_test [] +gorptest: 17:44:22.822517 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.822590 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 17:44:22.822623 delete from invoice_tag_test [] +gorptest: 17:44:22.822694 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: 17:44:22.822822 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 17:44:22.822892 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3367946854406452738 2:1116482329393016976 3:"random 259751277508311658" 4:33 5:false 6:1] +gorptest: 17:44:22.822972 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 17:44:22.823013 select * from invoice_tag_test [] +gorptest: 17:44:22.823066 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 17:44:22.823131 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 17:44:22.823162 delete from alias_trans_field_test [] +gorptest: 17:44:22.823221 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 17:44:22.823303 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 17:44:22.823350 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 2984640496378798349" 2:1] +gorptest: 17:44:22.823419 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 17:44:22.823452 select * from alias_trans_field_test [] +gorptest: 17:44:22.823486 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 17:44:22.823545 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 17:44:22.823582 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.823687 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.823787 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.823875 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.824043 drop table if exists "person_test"; [] +gorptest: 17:44:22.824164 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.824257 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.824663 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.824798 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.824898 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.824989 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.825083 drop table if exists "time_test"; [] +gorptest: 17:44:22.825173 drop table if exists "id_created_test"; [] --- PASS: TestCrud (0.01s) === RUN TestWithIgnoredColumn -2024/05/17 11:20:31 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: 11:20:31.945947 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.946111 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.946183 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.946213 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.946229 drop table if exists "person_test"; [] -gorptest: 11:20:31.946249 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.946266 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.946288 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.946306 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.946324 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.946346 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.946382 drop table if exists "time_test"; [] -gorptest: 11:20:31.946413 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.946581 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: 11:20:31.946760 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.946895 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.947043 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.947166 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.947282 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.947393 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.947512 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.947632 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.947757 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.947874 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.947993 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 11:20:31.948094 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 11:20:31.948150 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 11:20:31.948219 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 11:20:31.948252 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.948350 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.948441 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.948534 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.948706 drop table if exists "person_test"; [] -gorptest: 11:20:31.948810 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.948905 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.948990 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.949073 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.949155 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.949248 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.949337 drop table if exists "time_test"; [] -gorptest: 11:20:31.949423 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.825357 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.825528 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.825558 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.825573 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.825588 drop table if exists "person_test"; [] +gorptest: 17:44:22.825602 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.825620 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.825635 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.825651 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.825665 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.825682 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.825696 drop table if exists "time_test"; [] +gorptest: 17:44:22.825725 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.825882 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: 17:44:22.826017 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.826160 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.826323 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.826466 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.826598 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.826720 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.826839 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.826959 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.827081 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.827203 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.827329 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 17:44:22.827422 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 17:44:22.827481 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 17:44:22.827554 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 17:44:22.827589 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.827689 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.827782 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.827871 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.828046 drop table if exists "person_test"; [] +gorptest: 17:44:22.828151 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.828244 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.828354 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.828452 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.828542 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.828642 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.828738 drop table if exists "time_test"; [] +gorptest: 17:44:22.828827 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.00s) === RUN TestTypeConversionExample -2024/05/17 11:20:31 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: 11:20:31.949961 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.950196 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.950237 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.950256 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.950273 drop table if exists "person_test"; [] -gorptest: 11:20:31.950290 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.950315 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.950334 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.950348 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.950365 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.950382 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.950398 drop table if exists "time_test"; [] -gorptest: 11:20:31.950420 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.950611 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: 11:20:31.950751 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.950873 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.951027 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.951156 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.951269 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.951380 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.951498 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.951612 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.951730 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.951847 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.952107 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: 11:20:31.952213 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 11:20:31.952300 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: 11:20:31.952377 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 11:20:31.952422 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 11:20:31.952485 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.952579 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.952671 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.952757 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.952925 drop table if exists "person_test"; [] -gorptest: 11:20:31.953020 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.953105 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.953185 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.953270 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.953351 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.953431 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.953531 drop table if exists "time_test"; [] -gorptest: 11:20:31.953625 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.829019 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.829186 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.829214 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.829234 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.829249 drop table if exists "person_test"; [] +gorptest: 17:44:22.829264 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.829286 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.829304 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.829318 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.829337 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.829351 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.829365 drop table if exists "time_test"; [] +gorptest: 17:44:22.829386 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.829541 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: 17:44:22.829675 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.829796 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.829945 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.830071 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.830207 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.830327 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.830446 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.830567 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.830686 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.830806 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.831075 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: 17:44:22.831191 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 17:44:22.831280 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: 17:44:22.831366 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 17:44:22.831418 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 17:44:22.831490 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.831591 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.831685 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.831774 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.831951 drop table if exists "person_test"; [] +gorptest: 17:44:22.832061 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.832155 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.832262 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.832579 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.832693 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.832784 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.832873 drop table if exists "time_test"; [] +gorptest: 17:44:22.832960 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.00s) === RUN TestWithEmbeddedStruct -2024/05/17 11:20:31 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: 11:20:31.953803 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.953970 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.953987 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.954007 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.954021 drop table if exists "person_test"; [] -gorptest: 11:20:31.954035 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.954048 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.954063 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.954077 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.954095 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.954110 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.954143 drop table if exists "time_test"; [] -gorptest: 11:20:31.954172 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.954326 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: 11:20:31.954465 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.954623 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.954786 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.954919 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.955032 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.955146 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.955271 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.955395 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.955546 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.955671 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.955858 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 11:20:31.955995 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 11:20:31.956061 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 11:20:31.956149 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 11:20:31.956190 select * from embedded_struct_test [] -gorptest: 11:20:31.956235 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.956339 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.956436 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.956527 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.956693 drop table if exists "person_test"; [] -gorptest: 11:20:31.956796 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.956892 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.956985 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.957081 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.957171 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.957260 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.957394 drop table if exists "time_test"; [] -gorptest: 11:20:31.957473 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.833185 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.833365 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.833390 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.833405 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.833421 drop table if exists "person_test"; [] +gorptest: 17:44:22.833435 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.833452 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.833466 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.833483 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.833497 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.833514 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.833528 drop table if exists "time_test"; [] +gorptest: 17:44:22.833559 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.833722 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: 17:44:22.833858 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.834013 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.834219 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.834362 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.834480 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.834603 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.834745 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.834880 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.835007 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.835129 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.835264 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 17:44:22.835370 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 17:44:22.835450 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 17:44:22.835535 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 17:44:22.835580 select * from embedded_struct_test [] +gorptest: 17:44:22.835626 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.835733 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.835834 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.835925 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.836101 drop table if exists "person_test"; [] +gorptest: 17:44:22.836209 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.836320 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.836426 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.836525 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.836619 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.836710 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.836795 drop table if exists "time_test"; [] +gorptest: 17:44:22.836884 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.00s) === RUN TestWithEmbeddedStructBeforeAutoincr -2024/05/17 11:20:31 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: 11:20:31.957763 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.957942 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.957964 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.957978 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.957998 drop table if exists "person_test"; [] -gorptest: 11:20:31.958019 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.958033 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.958068 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.958082 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.958096 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.958110 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.958140 drop table if exists "time_test"; [] -gorptest: 11:20:31.958181 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.958353 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: 11:20:31.958487 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.958614 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.958771 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.958915 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.959031 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.959144 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.959278 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.959394 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.959652 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.959821 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.959987 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 11:20:31.960096 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.960196 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.960291 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.960417 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.960584 drop table if exists "person_test"; [] -gorptest: 11:20:31.960706 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.960844 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.960966 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.961052 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.961137 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.961225 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.961315 drop table if exists "time_test"; [] -gorptest: 11:20:31.961402 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.837078 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.837250 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.837280 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.837296 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.837312 drop table if exists "person_test"; [] +gorptest: 17:44:22.837335 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.837349 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.837363 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.837378 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.837392 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.837406 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.837419 drop table if exists "time_test"; [] +gorptest: 17:44:22.837440 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.837601 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: 17:44:22.837731 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.837863 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.838024 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.838173 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.838297 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.838416 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.838537 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.838674 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.838817 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.838947 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.839109 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 17:44:22.839212 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.839316 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.839433 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.839525 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.839699 drop table if exists "person_test"; [] +gorptest: 17:44:22.839806 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.839904 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.839994 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.840081 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.840169 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.840260 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.840661 drop table if exists "time_test"; [] +gorptest: 17:44:22.840791 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStructBeforeAutoincr (0.00s) === RUN TestWithEmbeddedAutoincr -2024/05/17 11:20:31 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: 11:20:31.961666 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.961829 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.961872 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.961887 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.961904 drop table if exists "person_test"; [] -gorptest: 11:20:31.961929 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.961948 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.961962 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.961983 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.962017 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.962046 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.962060 drop table if exists "time_test"; [] -gorptest: 11:20:31.962078 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.962262 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: 11:20:31.962468 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.962591 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.962826 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.962950 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.963086 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.963201 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.963328 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.963451 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.963568 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.963753 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.963942 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 11:20:31.964045 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.964156 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.964250 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.964335 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.964521 drop table if exists "person_test"; [] -gorptest: 11:20:31.964625 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.964740 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.964857 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.964942 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.965031 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.965131 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.965227 drop table if exists "time_test"; [] -gorptest: 11:20:31.965311 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.840994 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.841178 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.841202 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.841217 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.841234 drop table if exists "person_test"; [] +gorptest: 17:44:22.841249 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.841263 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.841277 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.841301 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.841325 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.841341 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.841358 drop table if exists "time_test"; [] +gorptest: 17:44:22.841382 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.841542 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: 17:44:22.841683 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.841809 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.841965 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.842094 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.842241 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.842355 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.842467 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.842588 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.842713 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.842837 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.842980 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 17:44:22.843073 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.843173 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.843269 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.843358 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.843527 drop table if exists "person_test"; [] +gorptest: 17:44:22.843634 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.843728 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.843814 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.843902 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.843990 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.844078 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.844178 drop table if exists "time_test"; [] +gorptest: 17:44:22.844259 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.00s) === RUN TestSelectVal -gorptest: 11:20:31.965487 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 11:20:31.965838 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: 11:20:31.965960 select Int64 from TableWithNull where Str='abc' [] -gorptest: 11:20:31.966008 select count(*) from TableWithNull [] -gorptest: 11:20:31.966039 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 11:20:31.966108 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 11:20:31.966158 select Int64 from TableWithNull where Str='abc' [] -gorptest: 11:20:31.966184 select Float64 from TableWithNull where Str='abc' [] -gorptest: 11:20:31.966213 select min(Float64) from TableWithNull [] -gorptest: 11:20:31.966242 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 11:20:31.966301 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 11:20:31.966324 select Float64 from TableWithNull where Str='abc' [] -gorptest: 11:20:31.966349 select Str from TableWithNull where Int64=? [1:78] -gorptest: 11:20:31.966380 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 11:20:31.966407 select Str from TableWithNull where Int64=? [1:78] -gorptest: 11:20:31.966450 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 11:20:31.966483 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 11:20:31.966510 select Str from TableWithNull where Int64=? [1:78] -gorptest: 11:20:31.966538 drop table if exists "TableWithNull"; [] +gorptest: 17:44:22.844511 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 17:44:22.845052 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: 17:44:22.845158 select Int64 from TableWithNull where Str='abc' [] +gorptest: 17:44:22.845210 select count(*) from TableWithNull [] +gorptest: 17:44:22.845252 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 17:44:22.845292 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 17:44:22.845317 select Int64 from TableWithNull where Str='abc' [] +gorptest: 17:44:22.845344 select Float64 from TableWithNull where Str='abc' [] +gorptest: 17:44:22.845368 select min(Float64) from TableWithNull [] +gorptest: 17:44:22.845395 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 17:44:22.845421 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 17:44:22.845443 select Float64 from TableWithNull where Str='abc' [] +gorptest: 17:44:22.845467 select Str from TableWithNull where Int64=? [1:78] +gorptest: 17:44:22.845490 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 17:44:22.845512 select Str from TableWithNull where Int64=? [1:78] +gorptest: 17:44:22.845534 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 17:44:22.845564 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 17:44:22.845600 select Str from TableWithNull where Int64=? [1:78] +gorptest: 17:44:22.845624 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.00s) === RUN TestVersionMultipleRows -2024/05/17 11:20:31 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: 11:20:31.966851 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.966999 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.967022 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.967037 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.967054 drop table if exists "person_test"; [] -gorptest: 11:20:31.967068 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.967085 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.967099 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.967115 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.967129 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.967143 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.967156 drop table if exists "time_test"; [] -gorptest: 11:20:31.967188 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.967337 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: 11:20:31.967463 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.967587 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.967733 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.967859 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.967971 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.968085 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.968202 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.968319 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.968445 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.968584 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.968721 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831968708294 2:1715944831968708294 3:"Bob" 4:"Smith" 5:1] -gorptest: 11:20:31.968821 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831968814935 2:1715944831968814935 3:"Jane" 4:"Smith" 5:1] -gorptest: 11:20:31.968900 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831968894175 2:1715944831968894175 3:"Mike" 4:"Smith" 5:1] -gorptest: 11:20:31.968977 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.969074 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.969165 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.969248 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.969411 drop table if exists "person_test"; [] -gorptest: 11:20:31.969591 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.969738 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.969854 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.969948 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.970040 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.970141 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.970236 drop table if exists "time_test"; [] -gorptest: 11:20:31.970321 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.845880 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.846047 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.846064 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.846079 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.846094 drop table if exists "person_test"; [] +gorptest: 17:44:22.846108 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.846144 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.846163 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.846178 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.846192 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.846206 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.846221 drop table if exists "time_test"; [] +gorptest: 17:44:22.846242 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.846402 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: 17:44:22.846528 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.846641 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.846795 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.846920 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.847030 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.847139 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.847268 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.847418 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.847562 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.847687 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.847830 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062847815118 2:1750355062847815118 3:"Bob" 4:"Smith" 5:1] +gorptest: 17:44:22.847922 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062847916438 2:1750355062847916438 3:"Jane" 4:"Smith" 5:1] +gorptest: 17:44:22.847996 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062847990718 2:1750355062847990718 3:"Mike" 4:"Smith" 5:1] +gorptest: 17:44:22.848062 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.848155 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.848256 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.848419 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.848596 drop table if exists "person_test"; [] +gorptest: 17:44:22.848725 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.848813 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.848908 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.848999 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.849089 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.849175 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.849260 drop table if exists "time_test"; [] +gorptest: 17:44:22.849347 drop table if exists "id_created_test"; [] --- PASS: TestVersionMultipleRows (0.00s) === RUN TestWithStringPk -gorptest: 11:20:31.970445 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 11:20:31.970734 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 11:20:31.970819 drop table if exists "string_pk_test"; [] +gorptest: 17:44:22.849488 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 17:44:22.849814 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 17:44:22.849910 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2024/05/17 11:20:31 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: 11:20:31.971230 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.971399 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.971417 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.971430 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.971444 drop table if exists "person_test"; [] -gorptest: 11:20:31.971457 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.971471 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.971485 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.971498 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.971512 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.971525 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.971540 drop table if exists "time_test"; [] -gorptest: 11:20:31.971560 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.971707 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: 11:20:31.971827 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.971961 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.972106 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.972242 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.972348 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.972455 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.972563 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.972671 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.972784 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.972896 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.973014 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-17 10:49:31.972999119 +0000 UTC] -gorptest: 11:20:31.973101 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-17 10:50:32.972999119 +0000 UTC] -gorptest: 11:20:31.973171 SELECT id FROM time_test WHERE Time < ? [1:2024-05-17 10:50:31.972999119 +0000 UTC] -gorptest: 11:20:31.973221 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.973318 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.973403 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.973485 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.973691 drop table if exists "person_test"; [] -gorptest: 11:20:31.973796 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.973886 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.973967 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.974044 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.974142 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.974231 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.974315 drop table if exists "time_test"; [] -gorptest: 11:20:31.974398 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.850407 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.850595 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.850624 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.850638 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.850653 drop table if exists "person_test"; [] +gorptest: 17:44:22.850666 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.850680 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.850693 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.850710 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.850724 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.850738 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.850751 drop table if exists "time_test"; [] +gorptest: 17:44:22.850771 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.850933 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: 17:44:22.851072 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.851195 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.851360 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.851496 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.851616 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.851736 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.851862 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.851985 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.852110 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.852230 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.852385 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-19 17:13:22.852370478 +0000 UTC] +gorptest: 17:44:22.852486 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-19 17:14:23.852370478 +0000 UTC] +gorptest: 17:44:22.852568 SELECT id FROM time_test WHERE Time < ? [1:2025-06-19 17:14:22.852370478 +0000 UTC] +gorptest: 17:44:22.852635 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.852753 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.852844 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.852971 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.853156 drop table if exists "person_test"; [] +gorptest: 17:44:22.853271 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.853357 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.853439 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.853529 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.853618 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.853704 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.853795 drop table if exists "time_test"; [] +gorptest: 17:44:22.853892 drop table if exists "id_created_test"; [] --- PASS: TestWithTimeSelect (0.00s) === RUN TestInvoicePersonView -2024/05/17 11:20:31 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: 11:20:31.974535 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.974684 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.974701 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.974715 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.974728 drop table if exists "person_test"; [] -gorptest: 11:20:31.974742 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.974756 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.974774 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.974787 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.974801 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.974815 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.974828 drop table if exists "time_test"; [] -gorptest: 11:20:31.974847 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.974981 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: 11:20:31.975100 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.975208 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.975342 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.975462 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.975576 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.975678 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.975786 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.975890 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.975997 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.976104 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.976219 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831976206458 2:1715944831976206458 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.976311 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 11:20:31.976386 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 11:20:31.976459 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.976556 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.976643 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.976728 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.976890 drop table if exists "person_test"; [] -gorptest: 11:20:31.976988 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.977070 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.977151 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.977229 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.977311 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.977392 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.977474 drop table if exists "time_test"; [] -gorptest: 11:20:31.977982 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.854081 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.854270 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.854295 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.854311 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.854325 drop table if exists "person_test"; [] +gorptest: 17:44:22.854341 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.854358 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.854373 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.854390 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.854404 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.854420 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.854434 drop table if exists "time_test"; [] +gorptest: 17:44:22.854454 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.854608 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: 17:44:22.854737 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.854866 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.855037 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.855172 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.855292 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.855407 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.855523 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.855646 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.855774 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.855901 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.856049 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062856034038 2:1750355062856034038 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.856158 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 17:44:22.856243 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 17:44:22.856517 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.856667 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.856769 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.856880 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.857065 drop table if exists "person_test"; [] +gorptest: 17:44:22.857177 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.857275 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.857364 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.857448 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.857531 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.857614 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.857692 drop table if exists "time_test"; [] +gorptest: 17:44:22.857771 drop table if exists "id_created_test"; [] --- PASS: TestInvoicePersonView (0.00s) === RUN TestQuoteTableNames -2024/05/17 11:20:31 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: 11:20:31.978160 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.978320 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.978337 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.978352 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.978366 drop table if exists "person_test"; [] -gorptest: 11:20:31.978379 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.978393 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.978408 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.978423 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.978436 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.978450 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.978464 drop table if exists "time_test"; [] -gorptest: 11:20:31.978483 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.978627 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: 11:20:31.978744 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.978853 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.978988 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.979099 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.979201 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.979303 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.979409 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.979516 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.979624 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.979731 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +2025/06/19 17:44:22 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: 17:44:22.857961 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.858153 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.858174 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.858188 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.858202 drop table if exists "person_test"; [] +gorptest: 17:44:22.858215 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.858229 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.858244 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.858257 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.858272 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.858285 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.858299 drop table if exists "time_test"; [] +gorptest: 17:44:22.858319 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.858485 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: 17:44:22.858630 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.858759 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.858910 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.859041 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.859158 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.859274 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.859390 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.859518 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.859646 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.859770 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] --- PASS: TestQuoteTableNames (0.00s) === RUN TestSelectTooManyCols -2024/05/17 11:20:31 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: 11:20:31.981165 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.981311 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.981328 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.981342 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.981359 drop table if exists "person_test"; [] -gorptest: 11:20:31.981373 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.981387 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.981401 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.981418 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.981431 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.981446 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.981459 drop table if exists "time_test"; [] -gorptest: 11:20:31.981478 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.981739 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: 11:20:31.981869 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.981980 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.982115 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.982253 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.982360 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.982465 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.982571 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.982678 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.982787 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.982891 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.983012 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831982997698 2:1715944831982997698 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.983101 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831983095299 2:1715944831983095299 3:"jane" 4:"doe" 5:1] -gorptest: 11:20:31.983174 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.983226 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 11:20:31.983272 select * from person_test where Id=? [1:1] -gorptest: 11:20:31.983321 select * from person_test order by fname asc [] -gorptest: 11:20:31.983373 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.983472 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.983560 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.983642 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.983806 drop table if exists "person_test"; [] -gorptest: 11:20:31.983909 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.983993 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.984072 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.984152 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.984235 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.984319 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.984397 drop table if exists "time_test"; [] -gorptest: 11:20:31.984473 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.861402 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.861575 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.861604 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.861618 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.861637 drop table if exists "person_test"; [] +gorptest: 17:44:22.861655 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.861672 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.861689 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.861705 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.861728 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.861743 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.861757 drop table if exists "time_test"; [] +gorptest: 17:44:22.861776 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.861934 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: 17:44:22.862071 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.862232 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.862412 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.862554 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.862675 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.862791 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.862910 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.863032 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.863160 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.863287 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.863423 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062863408118 2:1750355062863408118 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.863523 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062863517478 2:1750355062863517478 3:"jane" 4:"doe" 5:1] +gorptest: 17:44:22.863607 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.863667 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 17:44:22.863717 select * from person_test where Id=? [1:1] +gorptest: 17:44:22.863793 select * from person_test order by fname asc [] +gorptest: 17:44:22.863863 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.863979 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.864080 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.864171 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.864373 drop table if exists "person_test"; [] +gorptest: 17:44:22.864496 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.864595 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.864682 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.864777 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.864866 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.864962 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.865053 drop table if exists "time_test"; [] +gorptest: 17:44:22.865142 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.00s) === RUN TestSelectSingleVal -2024/05/17 11:20:31 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: 11:20:31.984628 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.984779 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.984800 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.984815 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.984831 drop table if exists "person_test"; [] -gorptest: 11:20:31.984845 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.984859 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.984873 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.984886 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.984900 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.985065 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.985086 drop table if exists "time_test"; [] -gorptest: 11:20:31.985107 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.985259 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: 11:20:31.985383 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.985578 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.985765 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.985884 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.985993 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.986096 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.986233 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.986346 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.986455 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.986567 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.986686 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831986673360 2:1715944831986673360 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.986771 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 11:20:31.986829 select * from person_test where Id=? [1:1] -gorptest: 11:20:31.986888 select FName from person_test where Id=? [1:1] -gorptest: 11:20:31.986915 select * from person_test where Id=? [1:1] -gorptest: 11:20:31.986962 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 11:20:31.987005 select * from person_test where Id=? [1:-2222] -gorptest: 11:20:31.987049 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1715944831987043322 2:1715944831987043322 3:"bob" 4:"smith" 5:1] -gorptest: 11:20:31.987127 select * from person_test where Fname='bob' [] -gorptest: 11:20:31.987188 select * from person_test where Id=-123 [] -gorptest: 11:20:31.987214 select * from person_test where Id=-123 [] -gorptest: 11:20:31.987236 select * from person_test where Id=-123 [] -gorptest: 11:20:31.987256 select * from person_test where Id=-123 [] -gorptest: 11:20:31.987279 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.987370 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.987460 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.987542 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.987707 drop table if exists "person_test"; [] -gorptest: 11:20:31.987802 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.987883 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.987964 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.988043 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.988130 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.988208 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.988286 drop table if exists "time_test"; [] -gorptest: 11:20:31.988362 drop table if exists "id_created_test"; [] +2025/06/19 17:44:22 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: 17:44:22.865352 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.865528 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.865561 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.865583 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.865607 drop table if exists "person_test"; [] +gorptest: 17:44:22.865625 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.865643 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.865661 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.865680 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.865695 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.865712 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.865726 drop table if exists "time_test"; [] +gorptest: 17:44:22.865753 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.865917 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: 17:44:22.866052 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.866224 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.866404 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.866538 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.866658 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.866780 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.866899 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.867024 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.867156 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.867280 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.867417 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062867400958 2:1750355062867400958 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.867531 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 17:44:22.867605 select * from person_test where Id=? [1:1] +gorptest: 17:44:22.867668 select FName from person_test where Id=? [1:1] +gorptest: 17:44:22.867703 select * from person_test where Id=? [1:1] +gorptest: 17:44:22.867761 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 17:44:22.867813 select * from person_test where Id=? [1:-2222] +gorptest: 17:44:22.867861 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750355062867854838 2:1750355062867854838 3:"bob" 4:"smith" 5:1] +gorptest: 17:44:22.867962 select * from person_test where Fname='bob' [] +gorptest: 17:44:22.868035 select * from person_test where Id=-123 [] +gorptest: 17:44:22.868068 select * from person_test where Id=-123 [] +gorptest: 17:44:22.868094 select * from person_test where Id=-123 [] +gorptest: 17:44:22.868120 select * from person_test where Id=-123 [] +gorptest: 17:44:22.868146 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.868254 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.868568 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.868694 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.868883 drop table if exists "person_test"; [] +gorptest: 17:44:22.868999 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.869099 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.869190 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.869282 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.869372 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.869461 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.869550 drop table if exists "time_test"; [] +gorptest: 17:44:22.869636 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.00s) === RUN TestSelectAlias -2024/05/17 11:20:31 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: 11:20:31.988503 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.988647 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.988663 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.988679 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.988692 drop table if exists "person_test"; [] -gorptest: 11:20:31.988706 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.988720 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.988733 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.988747 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.988764 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.988778 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.988792 drop table if exists "time_test"; [] -gorptest: 11:20:31.988810 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.988943 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: 11:20:31.989057 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.989163 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.989300 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.989409 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.989622 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.989763 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.989875 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.989985 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.990093 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.990232 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.990353 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 11:20:31.990428 select * from id_created_test where Id=1 [] -gorptest: 11:20:31.990487 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 11:20:31.990533 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.990855 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.990947 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.991031 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.991203 drop table if exists "person_test"; [] -gorptest: 11:20:31.991297 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.991380 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.991464 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.991547 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.991627 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.991706 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.991790 drop table if exists "time_test"; [] -gorptest: 11:20:31.991872 drop table if exists "id_created_test"; [] ---- PASS: TestSelectAlias (0.00s) +2025/06/19 17:44:22 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: 17:44:22.869850 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.870042 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.870060 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.870075 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.870120 drop table if exists "person_test"; [] +gorptest: 17:44:22.870310 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.870378 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.870430 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.870475 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.870522 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.870566 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.870610 drop table if exists "time_test"; [] +gorptest: 17:44:22.870673 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.871111 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: 17:44:22.871505 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.871828 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.872213 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.872560 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.872879 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.873181 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.873484 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.873780 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.874088 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.874445 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.874776 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 17:44:22.874984 select * from id_created_test where Id=1 [] +gorptest: 17:44:22.875127 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 17:44:22.875274 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.876240 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.876558 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.876810 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.877286 drop table if exists "person_test"; [] +gorptest: 17:44:22.877557 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.877798 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.878054 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.878401 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.878677 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.878944 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.879174 drop table if exists "time_test"; [] +gorptest: 17:44:22.879389 drop table if exists "id_created_test"; [] +--- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2024/05/17 11:20:31 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: 11:20:31.992080 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.992243 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.992261 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.992276 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.992290 drop table if exists "person_test"; [] -gorptest: 11:20:31.992306 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.992320 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.992334 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.992348 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.992361 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.992374 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.992388 drop table if exists "time_test"; [] -gorptest: 11:20:31.992408 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.992551 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: 11:20:31.992671 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.992779 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.992916 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:31.993027 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.993132 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.993243 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.993356 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.993466 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.994106 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:31.994268 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.994380 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.994473 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.994557 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.994642 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.994805 drop table if exists "person_test"; [] -gorptest: 11:20:31.994897 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.994979 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.995058 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.995137 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.995217 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.995296 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.995374 drop table if exists "time_test"; [] -gorptest: 11:20:31.995450 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.995467 drop table if exists "single_column_table"; [] -gorptest: 11:20:31.995487 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: 11:20:31.995607 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: 11:20:31.995719 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:31.995825 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: 11:20:31.995958 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: 11:20:31.996066 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.996172 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:31.996280 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:31.996402 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:31.996509 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:31.996646 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: 11:20:31.996760 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:31.996863 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 11:20:31.996894 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 11:20:31.997023 delete from "invoice_test"; [] -gorptest: 11:20:31.997092 delete from "invoice_tag_test"; [] -gorptest: 11:20:31.997147 delete from "alias_trans_field_test"; [] -gorptest: 11:20:31.997199 delete from "invoice_override_test"; [] -gorptest: 11:20:31.997255 delete from "person_test"; [] -gorptest: 11:20:31.997304 delete from "ignored_column_test"; [] -gorptest: 11:20:31.997356 delete from "id_created_test"; [] -gorptest: 11:20:31.997405 delete from "type_conv_test"; [] -gorptest: 11:20:31.997455 delete from "embedded_struct_test"; [] -gorptest: 11:20:31.997529 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.997587 delete from "embedded_autoincr_test"; [] -gorptest: 11:20:31.997645 delete from "time_test"; [] -gorptest: 11:20:31.997696 delete from "id_created_test"; [] -gorptest: 11:20:31.997747 delete from "single_column_table"; [] -gorptest: 11:20:31.997816 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 11:20:31.997867 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.997968 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.998060 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.998168 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.998349 drop table if exists "person_test"; [] -gorptest: 11:20:31.998455 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.998545 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.998639 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.998728 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.998814 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.998899 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.998982 drop table if exists "time_test"; [] -gorptest: 11:20:31.999064 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.999087 drop table if exists "single_column_table"; [] ---- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) +2025/06/19 17:44:22 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: 17:44:22.879798 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.880167 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.880218 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.880262 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.880323 drop table if exists "person_test"; [] +gorptest: 17:44:22.880378 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.880425 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.880469 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.880511 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.880553 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.880594 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.880634 drop table if exists "time_test"; [] +gorptest: 17:44:22.880689 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.881038 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: 17:44:22.881349 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.881657 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.882007 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.882654 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.882926 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.883186 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.883450 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.883694 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.883959 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.884215 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.884530 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.884738 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.884925 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.885105 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.885407 drop table if exists "person_test"; [] +gorptest: 17:44:22.885600 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.885783 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.885961 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.886209 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.886723 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.886947 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.887125 drop table if exists "time_test"; [] +gorptest: 17:44:22.887289 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.887347 drop table if exists "single_column_table"; [] +gorptest: 17:44:22.887400 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: 17:44:22.887678 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: 17:44:22.887931 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.888176 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: 17:44:22.888505 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: 17:44:22.888774 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.889000 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.889233 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.889473 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.889704 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.889942 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: 17:44:22.890239 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.890508 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 17:44:22.890558 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 17:44:22.890851 delete from "invoice_test"; [] +gorptest: 17:44:22.890994 delete from "invoice_tag_test"; [] +gorptest: 17:44:22.891101 delete from "alias_trans_field_test"; [] +gorptest: 17:44:22.891203 delete from "invoice_override_test"; [] +gorptest: 17:44:22.891316 delete from "person_test"; [] +gorptest: 17:44:22.891429 delete from "ignored_column_test"; [] +gorptest: 17:44:22.891530 delete from "id_created_test"; [] +gorptest: 17:44:22.891638 delete from "type_conv_test"; [] +gorptest: 17:44:22.891752 delete from "embedded_struct_test"; [] +gorptest: 17:44:22.891859 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.891968 delete from "embedded_autoincr_test"; [] +gorptest: 17:44:22.892072 delete from "time_test"; [] +gorptest: 17:44:22.892178 delete from "id_created_test"; [] +gorptest: 17:44:22.892282 delete from "single_column_table"; [] +gorptest: 17:44:22.892443 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 17:44:22.892539 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.892742 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.892926 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.893118 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.893424 drop table if exists "person_test"; [] +gorptest: 17:44:22.893630 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.893818 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.894002 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.894247 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.894482 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.894678 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.894900 drop table if exists "time_test"; [] +gorptest: 17:44:22.895094 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.895140 drop table if exists "single_column_table"; [] +--- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.02s) === RUN TestPrepare -2024/05/17 11:20:31 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: 11:20:31.999375 drop table if exists "invoice_test"; [] -gorptest: 11:20:31.999544 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:31.999570 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:31.999585 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:31.999602 drop table if exists "person_test"; [] -gorptest: 11:20:31.999619 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:31.999636 drop table if exists "id_created_test"; [] -gorptest: 11:20:31.999652 drop table if exists "type_conv_test"; [] -gorptest: 11:20:31.999669 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:31.999684 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:31.999700 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:31.999718 drop table if exists "time_test"; [] -gorptest: 11:20:31.999740 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:31.999894 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: 11:20:32.000024 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 11:20:32.000144 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 11:20:32.000295 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 11:20:32.000420 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:32.000532 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 11:20:32.000648 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 11:20:32.000761 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 11:20:32.000874 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 11:20:32.000989 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 11:20:32.001111 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 11:20:32.001234 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 11:20:32.001321 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 11:20:32.001390 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 11:20:32.001467 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 11:20:32.001574 begin; [] -gorptest: 11:20:32.001603 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 11:20:32.001663 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 11:20:32.001897 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 11:20:32.001963 commit; [] -gorptest: 11:20:32.002020 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 11:20:32.002081 drop table if exists "invoice_test"; [] -gorptest: 11:20:32.002246 drop table if exists "invoice_tag_test"; [] -gorptest: 11:20:32.002346 drop table if exists "alias_trans_field_test"; [] -gorptest: 11:20:32.002433 drop table if exists "invoice_override_test"; [] -gorptest: 11:20:32.002597 drop table if exists "person_test"; [] -gorptest: 11:20:32.002705 drop table if exists "ignored_column_test"; [] -gorptest: 11:20:32.002795 drop table if exists "id_created_test"; [] -gorptest: 11:20:32.002882 drop table if exists "type_conv_test"; [] -gorptest: 11:20:32.002967 drop table if exists "embedded_struct_test"; [] -gorptest: 11:20:32.003058 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 11:20:32.003144 drop table if exists "embedded_autoincr_test"; [] -gorptest: 11:20:32.003225 drop table if exists "time_test"; [] -gorptest: 11:20:32.003307 drop table if exists "id_created_test"; [] ---- PASS: TestPrepare (0.00s) +2025/06/19 17:44:22 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: 17:44:22.895644 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.895940 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.895981 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.896017 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.896051 drop table if exists "person_test"; [] +gorptest: 17:44:22.896088 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.896140 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.896174 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.896208 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.896242 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.896275 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.896342 drop table if exists "time_test"; [] +gorptest: 17:44:22.896394 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.896678 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: 17:44:22.896920 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 17:44:22.897142 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 17:44:22.897417 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 17:44:22.897648 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.897881 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 17:44:22.898100 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 17:44:22.898398 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 17:44:22.898940 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 17:44:22.899192 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 17:44:22.899412 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 17:44:22.899651 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 17:44:22.899827 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 17:44:22.899961 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 17:44:22.900109 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 17:44:22.900238 begin; [] +gorptest: 17:44:22.900279 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 17:44:22.900393 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 17:44:22.900825 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 17:44:22.900936 commit; [] +gorptest: 17:44:22.901029 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 17:44:22.901149 drop table if exists "invoice_test"; [] +gorptest: 17:44:22.901422 drop table if exists "invoice_tag_test"; [] +gorptest: 17:44:22.901610 drop table if exists "alias_trans_field_test"; [] +gorptest: 17:44:22.901777 drop table if exists "invoice_override_test"; [] +gorptest: 17:44:22.902052 drop table if exists "person_test"; [] +gorptest: 17:44:22.902299 drop table if exists "ignored_column_test"; [] +gorptest: 17:44:22.902515 drop table if exists "id_created_test"; [] +gorptest: 17:44:22.902708 drop table if exists "type_conv_test"; [] +gorptest: 17:44:22.902882 drop table if exists "embedded_struct_test"; [] +gorptest: 17:44:22.903040 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 17:44:22.903194 drop table if exists "embedded_autoincr_test"; [] +gorptest: 17:44:22.903348 drop table if exists "time_test"; [] +gorptest: 17:44:22.903493 drop table if exists "id_created_test"; [] +--- PASS: TestPrepare (0.01s) PASS -ok gopkg.in/gorp.v1 0.132s +ok gopkg.in/gorp.v1 0.145s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang @@ -1813,12 +1849,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/3508731/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/3508731/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/3057374 and its subdirectories -I: Current time: Thu May 16 23:20:35 -12 2024 -I: pbuilder-time-stamp: 1715944835 +I: removing directory /srv/workspace/pbuilder/3508731 and its subdirectories +I: Current time: Fri Jun 20 07:44:26 +14 2025 +I: pbuilder-time-stamp: 1750355066