Diff of the two buildlogs: -- --- b1/build.log 2024-05-18 22:41:24.253865829 +0000 +++ b2/build.log 2024-05-18 22:43:17.753035325 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri Jun 20 17:03:35 -12 2025 -I: pbuilder-time-stamp: 1750482215 +I: Current time: Sat Jun 21 19:04:26 +14 2025 +I: pbuilder-time-stamp: 1750482266 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/trixie-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/1467198/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/128342/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 21 05:04 /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/128342/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/128342/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='trixie' - HOME='/root' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=trixie + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - INVOCATION_ID='0dd328a1a4914c5b8b67068d2696dc82' - 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='1467198' - PS1='# ' - PS2='> ' + INVOCATION_ID=16dcd3f56d1947a9907481b1190bdfed + 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=128342 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.WoSNXw1Z/pbuilderrc_Bf6z --distribution trixie --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.WoSNXw1Z/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.WoSNXw1Z/pbuilderrc_s8Gc --distribution trixie --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/trixie-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.WoSNXw1Z/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 codethink01-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 Jun 19 17:46 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/1467198/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Jun 18 17:46 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/128342/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 trixie/main arm64 libsqlite3-dev arm64 3.45.3-1 [1042 kB] Get: 59 http://deb.debian.org/debian trixie/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.19~ds1-1 [83.4 kB] Get: 60 http://deb.debian.org/debian trixie/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 67.7 MB in 1s (130 MB/s) +Fetched 67.7 MB in 1s (100.0 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package sensible-utils. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19745 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/128342/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for trixie +I: user script /srv/workspace/pbuilder/128342/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,50 +488,50 @@ dh_auto_configure -O--builddirectory=_build -O--buildsystem=golang dh_auto_build -O--builddirectory=_build -O--buildsystem=golang cd _build && go install -trimpath -v -p 12 gopkg.in/gorp.v1 -internal/goos -internal/itoa -internal/unsafeheader internal/goarch +unicode internal/goexperiment internal/godebugs -unicode +internal/goos +unicode/utf8 +internal/unsafeheader internal/race -sync/atomic -runtime/internal/syscall internal/coverage/rtcov +sync/atomic internal/cpu -unicode/utf8 -math/bits internal/abi +runtime/internal/sys +internal/itoa +runtime/internal/syscall +math/bits +cmp internal/chacha8rand runtime/internal/math -cmp -runtime/internal/sys log/internal -slices math -runtime/internal/atomic +slices internal/bytealg +runtime/internal/atomic runtime internal/reflectlite sync internal/testlog errors sort -internal/oserror io -path -internal/safefilepath +internal/oserror strconv +internal/safefilepath +path syscall bytes strings reflect regexp/syntax -internal/syscall/execenv +regexp time internal/syscall/unix -regexp +internal/syscall/execenv context internal/poll io/fs @@ -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 -2025/06/21 05:04:17 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: 05:04:17.734303 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.736752 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.736845 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.736898 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.736939 drop table if exists "person_test"; [] -gorptest: 05:04:17.736992 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.737031 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.737077 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.737121 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.737167 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.737215 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.737259 drop table if exists "time_test"; [] -gorptest: 05:04:17.737356 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.737944 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: 05:04:17.738351 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.738684 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.739073 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.739395 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.739689 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.739980 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.740277 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.740565 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.740865 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.741155 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.741608 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: 05:04:17.741697 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: 05:04:17.741756 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.741815 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: 05:04:17.741874 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: 05:04:17.741930 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.741980 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.742035 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.742089 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.742191 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.742253 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: 05:04:17.742307 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.742359 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 05:04:17.742407 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.742756 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.743015 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.743246 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.743648 drop table if exists "person_test"; [] -gorptest: 05:04:17.743907 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.744144 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.744367 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.744589 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.744812 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.745031 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.745248 drop table if exists "time_test"; [] -gorptest: 05:04:17.745518 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.612540 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.618725 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.618763 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.618779 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.618793 drop table if exists "person_test"; [] +gorptest: 05:06:09.618808 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.618821 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.618835 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.618850 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.618865 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.618879 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.618893 drop table if exists "time_test"; [] +gorptest: 05:06:09.618921 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.619197 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: 05:06:09.619348 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.619469 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.619629 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.619784 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.619907 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.620017 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.620124 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.620231 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.620337 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.620441 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.620652 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: 05:06:09.620680 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: 05:06:09.620701 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.620722 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: 05:06:09.620767 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: 05:06:09.620787 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.620805 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.620825 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.620842 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.620860 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.620879 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: 05:06:09.620896 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.620913 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 05:06:09.620928 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.621076 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.621177 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.621268 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.621454 drop table if exists "person_test"; [] +gorptest: 05:06:09.621560 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.625868 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.625999 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.626096 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.626185 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.626274 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.626358 drop table if exists "time_test"; [] +gorptest: 05:06:09.626461 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.01s) === RUN TestTruncateTables -2025/06/21 05:04:17 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: 05:04:17.746222 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.746631 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.746688 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.746735 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.746781 drop table if exists "person_test"; [] -gorptest: 05:04:17.746827 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.746875 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.746920 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.746965 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.747010 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.747055 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.747100 drop table if exists "time_test"; [] -gorptest: 05:04:17.747159 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.747539 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: 05:04:17.747867 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.748168 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.748578 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.748903 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.749190 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.749523 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.749833 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.750166 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.750480 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.750778 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.751126 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: 05:04:17.751240 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: 05:04:17.751312 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.751372 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: 05:04:17.751431 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: 05:04:17.751485 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.751536 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.751589 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.751646 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.751700 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.751756 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: 05:04:17.751809 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.751860 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 05:04:17.751952 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257751919379 2:1750482257751919379 3:"Bob" 4:"Smith" 5:1] -gorptest: 05:04:17.752216 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 05:04:17.752479 delete from "invoice_test"; [] -gorptest: 05:04:17.752637 delete from "invoice_tag_test"; [] -gorptest: 05:04:17.752775 delete from "alias_trans_field_test"; [] -gorptest: 05:04:17.752913 delete from "invoice_override_test"; [] -gorptest: 05:04:17.753059 delete from "person_test"; [] -gorptest: 05:04:17.753193 delete from "ignored_column_test"; [] -gorptest: 05:04:17.753359 delete from "id_created_test"; [] -gorptest: 05:04:17.753507 delete from "type_conv_test"; [] -gorptest: 05:04:17.753641 delete from "embedded_struct_test"; [] -gorptest: 05:04:17.753783 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.753918 delete from "embedded_autoincr_test"; [] -gorptest: 05:04:17.754051 delete from "time_test"; [] -gorptest: 05:04:17.754212 delete from "id_created_test"; [] -gorptest: 05:04:17.754351 SELECT * FROM person_test [] -gorptest: 05:04:17.754530 SELECT * FROM invoice_test [] -gorptest: 05:04:17.754643 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.754917 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.755158 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.755385 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.755771 drop table if exists "person_test"; [] -gorptest: 05:04:17.756041 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.756270 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.756490 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.756714 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.756934 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.757151 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.757406 drop table if exists "time_test"; [] -gorptest: 05:04:17.757643 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.626857 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.627053 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.627073 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.627087 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.627102 drop table if exists "person_test"; [] +gorptest: 05:06:09.627116 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.627130 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.627147 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.627162 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.627176 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.627191 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.627205 drop table if exists "time_test"; [] +gorptest: 05:06:09.627227 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.627398 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: 05:06:09.627528 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.627646 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.627799 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.627925 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.628034 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.628146 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.628258 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.628365 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.628475 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.628588 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.628704 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: 05:06:09.628764 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: 05:06:09.628799 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.628821 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: 05:06:09.628840 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: 05:06:09.628857 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.628874 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.628893 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.628911 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.628928 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.628946 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: 05:06:09.628963 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.628980 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 05:06:09.629021 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369629004854 2:1750482369629004854 3:"Bob" 4:"Smith" 5:1] +gorptest: 05:06:09.629144 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 05:06:09.629271 delete from "invoice_test"; [] +gorptest: 05:06:09.629332 delete from "invoice_tag_test"; [] +gorptest: 05:06:09.629382 delete from "alias_trans_field_test"; [] +gorptest: 05:06:09.629433 delete from "invoice_override_test"; [] +gorptest: 05:06:09.629488 delete from "person_test"; [] +gorptest: 05:06:09.629535 delete from "ignored_column_test"; [] +gorptest: 05:06:09.637721 delete from "id_created_test"; [] +gorptest: 05:06:09.637844 delete from "type_conv_test"; [] +gorptest: 05:06:09.637901 delete from "embedded_struct_test"; [] +gorptest: 05:06:09.637951 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.637999 delete from "embedded_autoincr_test"; [] +gorptest: 05:06:09.638048 delete from "time_test"; [] +gorptest: 05:06:09.638097 delete from "id_created_test"; [] +gorptest: 05:06:09.638145 SELECT * FROM person_test [] +gorptest: 05:06:09.638238 SELECT * FROM invoice_test [] +gorptest: 05:06:09.638281 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.638416 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.638512 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.638601 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.638771 drop table if exists "person_test"; [] +gorptest: 05:06:09.638882 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.638973 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.639055 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.639138 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.639218 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.639302 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.639382 drop table if exists "time_test"; [] +gorptest: 05:06:09.639464 drop table if exists "id_created_test"; [] --- PASS: TestTruncateTables (0.01s) === RUN TestCustomDateType -gorptest: 05:04:17.757921 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 05:04:17.758677 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-06-21 05:04:17 +0000 UTC] -gorptest: 05:04:17.758926 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 05:04:17.759065 drop table if exists "WithCustomDate"; [] +gorptest: 05:06:09.639616 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 05:06:09.639974 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-06-21 05:06:09 +0000 UTC] +gorptest: 05:06:09.640072 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 05:06:09.640135 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey -gorptest: 05:04:17.759562 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 05:04:17.760253 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 05:04:17.760572 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 05:04:17.760881 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 05:04:17.761097 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 05:04:17.761314 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 05:04:17.761514 drop table if exists "PersonUInt64"; [] -gorptest: 05:04:17.761790 drop table if exists "PersonUInt32"; [] -gorptest: 05:04:17.762038 drop table if exists "PersonUInt16"; [] +gorptest: 05:06:09.640353 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 05:06:09.640651 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 05:06:09.640802 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 05:06:09.640935 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 05:06:09.641024 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 05:06:09.641092 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 05:06:09.641157 drop table if exists "PersonUInt64"; [] +gorptest: 05:06:09.641260 drop table if exists "PersonUInt32"; [] +gorptest: 05:06:09.641349 drop table if exists "PersonUInt16"; [] --- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether -gorptest: 05:04:17.762526 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 05:04:17.763298 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 05:04:17.763538 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 05:04:17.763679 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 05:04:17.763777 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 05:04:17.763972 drop table if exists "UniqueColumns"; [] ---- PASS: TestSetUniqueTogether (0.00s) +gorptest: 05:06:09.641533 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 05:06:09.646239 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 05:06:09.646362 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 05:06:09.646427 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 05:06:09.646463 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 05:06:09.646534 drop table if exists "UniqueColumns"; [] +--- PASS: TestSetUniqueTogether (0.01s) === RUN TestPersistentUser -gorptest: 05:04:17.764740 drop table if exists PersistentUser [] -gorptest: 05:04:17.765167 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 05:04:17.766029 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 05:04:17.766458 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 05:04:17.766609 select * from PersistentUser [] -gorptest: 05:04:17.766756 select * from PersistentUser [] -gorptest: 05:04:17.766864 select * from PersistentUser [] -gorptest: 05:04:17.766967 select Id from PersistentUser [] -gorptest: 05:04:17.767042 select mykey from PersistentUser [] -gorptest: 05:04:17.767115 select PassedTraining from PersistentUser [] -gorptest: 05:04:17.767186 select Id from PersistentUser [] -gorptest: 05:04:17.767256 drop table if exists "PersistentUser"; [] +gorptest: 05:06:09.646958 drop table if exists PersistentUser [] +gorptest: 05:06:09.647185 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 05:06:09.647368 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 05:06:09.647458 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 05:06:09.647521 select * from PersistentUser [] +gorptest: 05:06:09.647568 select * from PersistentUser [] +gorptest: 05:06:09.647604 select * from PersistentUser [] +gorptest: 05:06:09.647635 select Id from PersistentUser [] +gorptest: 05:06:09.647662 select mykey from PersistentUser [] +gorptest: 05:06:09.647686 select PassedTraining from PersistentUser [] +gorptest: 05:06:09.647711 select Id from PersistentUser [] +gorptest: 05:06:09.647735 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap -gorptest: 05:04:17.767757 drop table if exists PersistentUser [] -gorptest: 05:04:17.768167 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 05:04:17.768541 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 05:04:17.768750 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 05:04:17.768989 select * from PersistentUser where mykey = ? [1:43] -gorptest: 05:04:17.769150 select * from PersistentUser where mykey = ? [1:43] -gorptest: 05:04:17.769270 +gorptest: 05:06:09.647939 drop table if exists PersistentUser [] +gorptest: 05:06:09.648115 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 05:06:09.648273 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 05:06:09.648362 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 05:06:09.648455 select * from PersistentUser where mykey = ? [1:43] +gorptest: 05:06:09.648527 select * from PersistentUser where mykey = ? [1:43] +gorptest: 05:06:09.648571 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 05:04:17.769783 +gorptest: 05:06:09.648618 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 05:04:17.769909 drop table if exists "PersistentUser"; [] +gorptest: 05:06:09.648656 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct -gorptest: 05:04:17.770380 drop table if exists PersistentUser [] -gorptest: 05:04:17.770748 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 05:04:17.771090 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 05:04:17.771268 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 05:04:17.771435 +gorptest: 05:06:09.648891 drop table if exists PersistentUser [] +gorptest: 05:06:09.649077 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 05:06:09.649237 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 05:06:09.649316 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 05:06:09.649389 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 05:04:17.771597 drop table if exists "PersistentUser"; [] +gorptest: 05:06:09.649457 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice -2025/06/21 05:04:17 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: 05:04:17.772098 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.772427 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.772479 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.772521 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.772562 drop table if exists "person_test"; [] -gorptest: 05:04:17.772604 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.772644 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.772689 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.772730 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.772772 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.772812 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.772853 drop table if exists "time_test"; [] -gorptest: 05:04:17.772905 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.773243 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: 05:04:17.773758 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.774036 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.774388 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.774665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.774911 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.775168 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.775423 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.775677 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.775935 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.776243 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.776533 select * from invoice_test where id=99999 [] -gorptest: 05:04:17.776668 select * from invoice_test where id=99999 [] -gorptest: 05:04:17.776761 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.776973 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.777174 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.777460 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.777839 drop table if exists "person_test"; [] -gorptest: 05:04:17.778059 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.778277 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.778466 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.778645 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.778820 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.778994 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.779172 drop table if exists "time_test"; [] -gorptest: 05:04:17.779347 drop table if exists "id_created_test"; [] ---- PASS: TestReturnsNonNilSlice (0.01s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.653805 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.654061 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.654081 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.654095 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.654110 drop table if exists "person_test"; [] +gorptest: 05:06:09.654126 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.654140 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.654154 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.654168 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.654182 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.654197 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.654211 drop table if exists "time_test"; [] +gorptest: 05:06:09.654237 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.654447 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: 05:06:09.654590 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.654713 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.654867 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.654995 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.655110 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.655219 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.655331 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.655450 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.655572 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.655687 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.655842 select * from invoice_test where id=99999 [] +gorptest: 05:06:09.655906 select * from invoice_test where id=99999 [] +gorptest: 05:06:09.655944 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.656055 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.656152 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.656281 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.656460 drop table if exists "person_test"; [] +gorptest: 05:06:09.656562 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.656651 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.656756 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.656863 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.656955 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.657043 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.657130 drop table if exists "time_test"; [] +gorptest: 05:06:09.657211 drop table if exists "id_created_test"; [] +--- PASS: TestReturnsNonNilSlice (0.00s) === RUN TestOverrideVersionCol -gorptest: 05:04:17.779594 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 05:04:17.780253 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: 05:04:17.780380 drop table if exists "InvoicePersonView"; [] ---- PASS: TestOverrideVersionCol (0.00s) +gorptest: 05:06:09.657365 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 05:06:09.666094 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: 05:06:09.666185 drop table if exists "InvoicePersonView"; [] +--- PASS: TestOverrideVersionCol (0.01s) === RUN TestOptimisticLocking -2025/06/21 05:04:17 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: 05:04:17.780972 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.781338 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.781399 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.781437 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.781473 drop table if exists "person_test"; [] -gorptest: 05:04:17.781798 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.781852 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.781893 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.781929 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.781965 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.782000 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.782036 drop table if exists "time_test"; [] -gorptest: 05:04:17.782090 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.782652 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: 05:04:17.782931 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.783185 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.783489 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.783743 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.783979 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.784225 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.784472 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.784710 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.784947 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.785182 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.785555 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257785524819 2:1750482257785524819 3:"Bob" 4:"Smith" 5:1] -gorptest: 05:04:17.786135 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.786283 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482257785524819 2:1750482257785524819 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 05:04:17.786469 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482257785524819 2:1750482257785524819 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 05:04:17.786551 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.786643 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 05:04:17.786706 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.786775 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.786970 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.787154 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.787328 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.787610 drop table if exists "person_test"; [] -gorptest: 05:04:17.787817 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.787993 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.788164 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.788333 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.788500 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.788663 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.788825 drop table if exists "time_test"; [] -gorptest: 05:04:17.788985 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.666551 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.666747 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.666765 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.666780 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.666796 drop table if exists "person_test"; [] +gorptest: 05:06:09.666812 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.666828 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.666846 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.666860 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.666875 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.666889 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.666903 drop table if exists "time_test"; [] +gorptest: 05:06:09.666924 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.667101 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: 05:06:09.667230 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.667354 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.667503 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.667627 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.667739 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.667850 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.667989 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.668127 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.668249 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.668364 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.668493 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369668477134 2:1750482369668477134 3:"Bob" 4:"Smith" 5:1] +gorptest: 05:06:09.668588 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.668675 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482369668477134 2:1750482369668477134 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 05:06:09.668815 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482369668477134 2:1750482369668477134 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 05:06:09.668868 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.668922 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 05:06:09.668951 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.668986 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.669104 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.669200 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.669286 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.669451 drop table if exists "person_test"; [] +gorptest: 05:06:09.669555 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.673851 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.673981 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.674074 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.674161 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.674245 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.674330 drop table if exists "time_test"; [] +gorptest: 05:06:09.674407 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.01s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 05:04:17.789563 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 05:04:17.790174 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 05:04:17.790338 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 05:04:17.790475 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: 05:04:17.790630 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 05:04:17.790731 drop table if exists "TableWithNull"; [] +gorptest: 05:06:09.674688 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 05:06:09.675031 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 05:06:09.675115 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 05:06:09.675201 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: 05:06:09.675298 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 05:06:09.675351 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps -gorptest: 05:04:17.791067 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 05:04:17.791613 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 05:04:17.791799 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 05:04:17.791906 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 05:04:17.791984 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 05:04:17.792044 drop table if exists "Invoice"; [] +gorptest: 05:06:09.675544 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 05:06:09.675888 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 05:06:09.675991 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 05:06:09.676056 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 05:06:09.676100 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 05:06:09.676129 drop table if exists "Invoice"; [] --- PASS: TestColumnProps (0.00s) === RUN TestRawSelect -2025/06/21 05:04:17 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: 05:04:17.792575 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.792836 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.792885 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.792918 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.792950 drop table if exists "person_test"; [] -gorptest: 05:04:17.792981 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.793013 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.793046 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.793079 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.793110 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.793141 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.793171 drop table if exists "time_test"; [] -gorptest: 05:04:17.793213 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.793715 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: 05:04:17.793953 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.794268 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.794542 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.794756 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.794948 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.795142 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.795337 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.795539 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.795738 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.795939 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.796157 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257796134859 2:1750482257796134859 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.796320 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 05:04:17.796447 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 05:04:17.796569 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.796745 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.796903 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.797053 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.797367 drop table if exists "person_test"; [] -gorptest: 05:04:17.797836 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.798013 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.798187 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.798347 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.798492 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.798634 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.798776 drop table if exists "time_test"; [] -gorptest: 05:04:17.798914 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.676481 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.676659 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.676677 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.676692 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.676706 drop table if exists "person_test"; [] +gorptest: 05:06:09.676722 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.676763 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.676783 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.676799 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.676814 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.676829 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.676844 drop table if exists "time_test"; [] +gorptest: 05:06:09.676866 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.677050 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: 05:06:09.677181 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.677298 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.677452 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.681745 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.682064 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.682209 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.682331 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.682455 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.682576 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.682691 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.682823 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369682807774 2:1750482369682807774 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.682920 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 05:06:09.682991 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 05:06:09.683066 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.683176 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.683267 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.683353 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.683551 drop table if exists "person_test"; [] +gorptest: 05:06:09.683694 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.683787 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.683873 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.683961 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.684045 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.684128 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.684207 drop table if exists "time_test"; [] +gorptest: 05:06:09.684286 drop table if exists "id_created_test"; [] --- PASS: TestRawSelect (0.01s) === RUN TestHooks -2025/06/21 05:04:17 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: 05:04:17.799169 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.799421 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.799458 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.799488 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.799516 drop table if exists "person_test"; [] -gorptest: 05:04:17.799544 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.799572 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.799600 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.799628 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.799654 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.799681 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.799708 drop table if exists "time_test"; [] -gorptest: 05:04:17.799747 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.799982 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: 05:04:17.800187 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.800375 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.800607 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.800805 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.800996 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.801192 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.801463 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.802036 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.802446 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.802655 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.802863 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257802842619 2:1750482257802842619 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.803015 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.803120 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482257802842619 2:1750482257802842619 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 05:04:17.803249 select * from person_test where id = ? [1:1] -gorptest: 05:04:17.803367 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 05:04:17.803482 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.803632 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.803773 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.803911 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.804149 drop table if exists "person_test"; [] -gorptest: 05:04:17.804315 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.804457 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.804594 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.804728 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.804863 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.805001 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.805192 drop table if exists "time_test"; [] -gorptest: 05:04:17.805424 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.684451 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.684621 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.684640 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.684656 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.684672 drop table if exists "person_test"; [] +gorptest: 05:06:09.684686 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.684699 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.684713 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.684745 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.684771 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.684786 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.684801 drop table if exists "time_test"; [] +gorptest: 05:06:09.684822 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.684995 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: 05:06:09.685121 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.685245 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.685388 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.685505 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.693949 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.694136 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.694267 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.694393 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.694521 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.694641 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.694776 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369694760414 2:1750482369694760414 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.694878 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.694944 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1750482369694760414 2:1750482369694760414 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 05:06:09.695023 select * from person_test where id = ? [1:1] +gorptest: 05:06:09.695093 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 05:06:09.695169 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.695269 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.695360 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.695446 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.695655 drop table if exists "person_test"; [] +gorptest: 05:06:09.695780 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.695872 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.695975 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.696084 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.696177 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.696263 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.696347 drop table if exists "time_test"; [] +gorptest: 05:06:09.696428 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.01s) === RUN TestTransaction -2025/06/21 05:04:17 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: 05:04:17.805700 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.805956 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.805992 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.806020 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.806048 drop table if exists "person_test"; [] -gorptest: 05:04:17.806076 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.806102 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.806146 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.806174 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.806197 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.806222 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.806249 drop table if exists "time_test"; [] -gorptest: 05:04:17.806284 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.806546 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: 05:04:17.806749 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.806926 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.807142 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.807327 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.807495 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.807670 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.807845 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.808017 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.808193 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.808366 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.808538 begin; [] -gorptest: 05:04:17.808605 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 05:04:17.808716 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 05:04:17.808748 commit; [] -gorptest: 05:04:17.808818 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.808907 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 05:04:17.808965 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.809122 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.809258 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.809818 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.810085 drop table if exists "person_test"; [] -gorptest: 05:04:17.810266 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.810407 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.810551 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.810686 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.810819 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.810946 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.811070 drop table if exists "time_test"; [] -gorptest: 05:04:17.811190 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.696633 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.696840 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.696862 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.696877 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.696891 drop table if exists "person_test"; [] +gorptest: 05:06:09.696906 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.696920 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.696936 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.696950 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.696975 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.696992 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.697005 drop table if exists "time_test"; [] +gorptest: 05:06:09.697026 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.697234 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: 05:06:09.697368 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.697486 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.701822 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.702049 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.702178 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.702291 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.702404 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.702519 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.702635 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.702749 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.702862 begin; [] +gorptest: 05:06:09.702914 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 05:06:09.702989 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 05:06:09.703007 commit; [] +gorptest: 05:06:09.703055 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.703117 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 05:06:09.703153 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.703271 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.703365 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.703449 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.703625 drop table if exists "person_test"; [] +gorptest: 05:06:09.703756 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.703855 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.703947 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.704039 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.704128 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.704209 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.704293 drop table if exists "time_test"; [] +gorptest: 05:06:09.704374 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.01s) === RUN TestSavepoint -2025/06/21 05:04:17 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: 05:04:17.811416 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.811633 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.811670 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.811694 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.811720 drop table if exists "person_test"; [] -gorptest: 05:04:17.811745 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.811770 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.811791 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.811815 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.811841 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.811865 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.811886 drop table if exists "time_test"; [] -gorptest: 05:04:17.811919 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.812128 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: 05:04:17.812307 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.812475 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.812683 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.812856 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.813013 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.813175 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.813612 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.813806 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.813979 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.814163 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.814330 begin; [] -gorptest: 05:04:17.814387 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 05:04:17.814502 select memo from invoice_test [] -gorptest: 05:04:17.814560 savepoint "foo" [1:] -gorptest: 05:04:17.814577 select memo from invoice_test [] -gorptest: 05:04:17.814616 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 05:04:17.814669 select memo from invoice_test [] -gorptest: 05:04:17.814703 rollback to savepoint "foo" [1:] -gorptest: 05:04:17.814718 select memo from invoice_test [] -gorptest: 05:04:17.814739 rollback; [] -gorptest: 05:04:17.814800 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.814969 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.815100 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.815228 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.815456 drop table if exists "person_test"; [] -gorptest: 05:04:17.815600 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.815727 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.815849 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.815968 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.816084 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.816201 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.816322 drop table if exists "time_test"; [] -gorptest: 05:04:17.816444 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.704553 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.704746 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.704771 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.704787 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.704801 drop table if exists "person_test"; [] +gorptest: 05:06:09.704820 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.704835 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.704850 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.704865 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.704880 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.704893 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.704907 drop table if exists "time_test"; [] +gorptest: 05:06:09.704945 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.705129 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: 05:06:09.705262 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.705374 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.705517 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.710030 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.710220 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.710346 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.710463 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.710581 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.710698 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.710814 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.710933 begin; [] +gorptest: 05:06:09.710978 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 05:06:09.711046 select memo from invoice_test [] +gorptest: 05:06:09.711083 savepoint "foo" [1:] +gorptest: 05:06:09.711090 select memo from invoice_test [] +gorptest: 05:06:09.711124 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 05:06:09.711150 select memo from invoice_test [] +gorptest: 05:06:09.711166 rollback to savepoint "foo" [1:] +gorptest: 05:06:09.711174 select memo from invoice_test [] +gorptest: 05:06:09.711186 rollback; [] +gorptest: 05:06:09.711229 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.711338 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.711431 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.711516 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.711684 drop table if exists "person_test"; [] +gorptest: 05:06:09.711784 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.711879 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.711964 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.712045 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.712175 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.712286 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.712378 drop table if exists "time_test"; [] +gorptest: 05:06:09.712462 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.01s) === RUN TestMultiple -2025/06/21 05:04:17 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: 05:04:17.816695 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.816924 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.816958 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.816988 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.817014 drop table if exists "person_test"; [] -gorptest: 05:04:17.817038 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.817058 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.817081 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.817101 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.817125 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.817146 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.817169 drop table if exists "time_test"; [] -gorptest: 05:04:17.817197 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.817485 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: 05:04:17.817717 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.817891 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.818303 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.818517 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.818677 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.818851 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.819016 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.819179 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.819345 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.819504 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.819680 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 05:04:17.819804 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 05:04:17.819915 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 05:04:17.820010 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 05:04:17.820103 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.820186 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 05:04:17.820262 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.820389 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.820506 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.820618 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.820827 drop table if exists "person_test"; [] -gorptest: 05:04:17.820960 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.821078 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.821191 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.821506 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.821649 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.821773 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.821886 drop table if exists "time_test"; [] -gorptest: 05:04:17.821995 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.712628 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.712838 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.712857 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.712873 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.712889 drop table if exists "person_test"; [] +gorptest: 05:06:09.712903 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.712917 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.712931 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.712947 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.712962 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.712976 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.712990 drop table if exists "time_test"; [] +gorptest: 05:06:09.713010 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.713172 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: 05:06:09.713296 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.713417 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.721614 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.721951 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.722097 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.722222 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.722343 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.722459 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.722577 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.722690 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.722828 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 05:06:09.722927 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 05:06:09.723007 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 05:06:09.723076 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 05:06:09.723150 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.723211 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 05:06:09.723265 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.723370 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.723458 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.723542 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.723712 drop table if exists "person_test"; [] +gorptest: 05:06:09.723811 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.723895 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.723978 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.724070 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.724152 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.724236 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.724317 drop table if exists "time_test"; [] +gorptest: 05:06:09.724397 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.01s) === RUN TestCrud -2025/06/21 05:04:17 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: 05:04:17.822238 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.822451 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.822482 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.822503 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.822526 drop table if exists "person_test"; [] -gorptest: 05:04:17.822545 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.822567 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.822586 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.822609 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.822629 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.822651 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.822672 drop table if exists "time_test"; [] -gorptest: 05:04:17.822700 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.822899 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: 05:04:17.823069 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.823240 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.823468 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.823631 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.823776 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.823927 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.824078 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.824227 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.824377 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.824527 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.824680 delete from invoice_test [] -gorptest: 05:04:17.824784 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 05:04:17.824899 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.824999 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:9088644742441910585 2:4892280748089350124 3:"random 2295857685704506826" 4:0 5:true 6:1] -gorptest: 05:04:17.825102 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.825163 select * from invoice_test [] -gorptest: 05:04:17.825239 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.825399 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 05:04:17.825479 delete from invoice_tag_test [] -gorptest: 05:04:17.825600 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: 05:04:17.825748 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 05:04:17.825848 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:4588127723855136514 2:3769927516844063351 3:"random 8416489161079558656" 4:33 5:false 6:1] -gorptest: 05:04:17.825956 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 05:04:17.826015 select * from invoice_tag_test [] -gorptest: 05:04:17.826170 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 05:04:17.826272 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 05:04:17.826320 delete from alias_trans_field_test [] -gorptest: 05:04:17.826402 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 05:04:17.826498 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 05:04:17.826568 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 3668471702749120767" 2:1] -gorptest: 05:04:17.826668 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 05:04:17.826715 select * from alias_trans_field_test [] -gorptest: 05:04:17.826767 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 05:04:17.826848 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 05:04:17.826889 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.827026 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.827148 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.827270 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.827487 drop table if exists "person_test"; [] -gorptest: 05:04:17.827620 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.827736 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.827848 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.827959 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.828066 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.828175 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.828283 drop table if exists "time_test"; [] -gorptest: 05:04:17.828387 drop table if exists "id_created_test"; [] ---- PASS: TestCrud (0.01s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.724567 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.724770 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.724789 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.724804 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.724818 drop table if exists "person_test"; [] +gorptest: 05:06:09.724831 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.724847 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.724861 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.724875 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.724891 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.724905 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.724922 drop table if exists "time_test"; [] +gorptest: 05:06:09.724951 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.725124 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: 05:06:09.725250 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.725365 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.725509 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.729921 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.730114 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.730248 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.730373 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.730495 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.730616 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.730733 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.730846 delete from invoice_test [] +gorptest: 05:06:09.730920 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 05:06:09.731007 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.731091 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:2841076832237205143 2:4390761395199131869 3:"random 7001024132760726342" 4:0 5:true 6:1] +gorptest: 05:06:09.731170 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.731225 select * from invoice_test [] +gorptest: 05:06:09.731281 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.731355 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 05:06:09.731387 delete from invoice_tag_test [] +gorptest: 05:06:09.731456 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: 05:06:09.731543 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 05:06:09.731601 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:9219546276943024811 2:8970372003343542420 3:"random 481525662169910987" 4:33 5:false 6:1] +gorptest: 05:06:09.731674 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 05:06:09.731713 select * from invoice_tag_test [] +gorptest: 05:06:09.731770 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 05:06:09.731836 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 05:06:09.731867 delete from alias_trans_field_test [] +gorptest: 05:06:09.731931 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 05:06:09.732005 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 05:06:09.732050 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 6071159903079063957" 2:1] +gorptest: 05:06:09.732114 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 05:06:09.732145 select * from alias_trans_field_test [] +gorptest: 05:06:09.732183 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 05:06:09.732247 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 05:06:09.732275 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.732382 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.732481 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.732575 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.732777 drop table if exists "person_test"; [] +gorptest: 05:06:09.732891 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.732982 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.733066 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.733152 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.733235 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.733317 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.733397 drop table if exists "time_test"; [] +gorptest: 05:06:09.733477 drop table if exists "id_created_test"; [] +--- PASS: TestCrud (0.02s) === RUN TestWithIgnoredColumn -2025/06/21 05:04:17 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: 05:04:17.828604 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.828816 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.828847 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.828866 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.828888 drop table if exists "person_test"; [] -gorptest: 05:04:17.828907 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.828929 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.828947 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.828969 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.828989 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.829011 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.829028 drop table if exists "time_test"; [] -gorptest: 05:04:17.829058 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.829269 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: 05:04:17.829538 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.829709 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.829976 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.830174 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.830327 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.830493 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.830660 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.830816 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.830969 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.831125 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.831273 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 05:04:17.831381 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 05:04:17.831451 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 05:04:17.831534 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 05:04:17.831574 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.831693 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.831803 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.831914 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.832116 drop table if exists "person_test"; [] -gorptest: 05:04:17.832244 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.832369 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.832482 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.832588 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.832692 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.832814 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.832928 drop table if exists "time_test"; [] -gorptest: 05:04:17.833037 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.742032 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.742321 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.742341 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.742356 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.742370 drop table if exists "person_test"; [] +gorptest: 05:06:09.742385 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.742399 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.742413 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.742430 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.742445 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.742459 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.742473 drop table if exists "time_test"; [] +gorptest: 05:06:09.742497 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.742698 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: 05:06:09.742832 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.742950 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.743098 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.743218 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.743325 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.743439 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.743550 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.743661 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.743774 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.743885 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.744006 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 05:06:09.744093 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 05:06:09.744148 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 05:06:09.744216 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 05:06:09.744244 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.744344 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.744430 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.744515 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.744691 drop table if exists "person_test"; [] +gorptest: 05:06:09.744833 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.744938 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.745027 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.745115 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.745201 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.745300 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.745398 drop table if exists "time_test"; [] +gorptest: 05:06:09.745487 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.00s) === RUN TestTypeConversionExample -2025/06/21 05:04:17 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: 05:04:17.833266 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.833552 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.833582 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.833601 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.833621 drop table if exists "person_test"; [] -gorptest: 05:04:17.833639 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.833659 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.833677 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.833699 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.833719 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.833763 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.833785 drop table if exists "time_test"; [] -gorptest: 05:04:17.833811 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.834013 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: 05:04:17.834336 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.834507 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.834695 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.834844 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.834977 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.835109 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.835248 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.835386 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.835524 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.835661 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.835975 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: 05:04:17.836104 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 05:04:17.836203 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: 05:04:17.836299 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 05:04:17.836364 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 05:04:17.836445 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.836565 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.836678 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.836780 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.836973 drop table if exists "person_test"; [] -gorptest: 05:04:17.837098 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.837206 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.837370 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.837524 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.837641 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.837776 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.837895 drop table if exists "time_test"; [] -gorptest: 05:04:17.838009 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.745974 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.746286 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.746308 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.746323 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.746339 drop table if exists "person_test"; [] +gorptest: 05:06:09.746354 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.746368 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.746383 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.746401 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.746415 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.746430 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.746446 drop table if exists "time_test"; [] +gorptest: 05:06:09.746467 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.746680 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: 05:06:09.746822 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.746941 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.747100 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.747220 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.747327 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.747438 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.747551 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.747686 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.747841 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.747971 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.748244 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: 05:06:09.748363 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 05:06:09.748448 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: 05:06:09.748529 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 05:06:09.748607 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 05:06:09.748694 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.748884 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.749004 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.749098 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.749289 drop table if exists "person_test"; [] +gorptest: 05:06:09.749390 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.749482 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.749965 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.750165 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.750266 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.750352 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.750438 drop table if exists "time_test"; [] +gorptest: 05:06:09.750520 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.00s) === RUN TestWithEmbeddedStruct -2025/06/21 05:04:17 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: 05:04:17.838241 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.838433 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.838461 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.838478 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.838497 drop table if exists "person_test"; [] -gorptest: 05:04:17.838515 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.838534 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.838551 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.838571 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.838588 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.838607 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.838623 drop table if exists "time_test"; [] -gorptest: 05:04:17.838650 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.838836 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: 05:04:17.838989 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.839129 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.839304 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.839450 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.839585 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.839722 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.839861 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.839995 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.840137 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.840273 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.840430 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 05:04:17.840540 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 05:04:17.840629 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 05:04:17.840720 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 05:04:17.840769 select * from embedded_struct_test [] -gorptest: 05:04:17.840823 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.840942 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.841059 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.841170 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.841442 drop table if exists "person_test"; [] -gorptest: 05:04:17.841930 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.842056 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.842180 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.842288 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.842391 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.842487 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.842581 drop table if exists "time_test"; [] -gorptest: 05:04:17.842676 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStruct (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.750715 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.750898 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.750917 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.750932 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.750946 drop table if exists "person_test"; [] +gorptest: 05:06:09.750961 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.750976 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.750991 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.751005 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.751018 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.751032 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.751047 drop table if exists "time_test"; [] +gorptest: 05:06:09.751069 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.751229 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: 05:06:09.751364 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.751479 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.751623 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.751746 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.751856 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.751997 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.752123 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.752237 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.752350 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.752462 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.752589 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 05:06:09.752685 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 05:06:09.752767 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 05:06:09.752857 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 05:06:09.752901 select * from embedded_struct_test [] +gorptest: 05:06:09.752949 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.753056 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.753145 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.753234 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.753391 drop table if exists "person_test"; [] +gorptest: 05:06:09.753489 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.761559 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.761814 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.761914 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.762009 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.762095 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.762176 drop table if exists "time_test"; [] +gorptest: 05:06:09.762258 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStruct (0.01s) === RUN TestWithEmbeddedStructBeforeAutoincr -2025/06/21 05:04:17 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: 05:04:17.842921 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.843120 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.843148 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.843165 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.843184 drop table if exists "person_test"; [] -gorptest: 05:04:17.843201 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.843220 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.843236 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.843254 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.843278 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.843297 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.843313 drop table if exists "time_test"; [] -gorptest: 05:04:17.843339 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.843507 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: 05:04:17.843649 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.843792 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.843961 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.844101 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.844225 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.844355 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.844482 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.844607 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.844769 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.844932 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.845085 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 05:04:17.845183 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.845345 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.845487 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.845609 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.845832 drop table if exists "person_test"; [] -gorptest: 05:04:17.845955 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.846059 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.846175 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.846276 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.846369 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.846469 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.846562 drop table if exists "time_test"; [] -gorptest: 05:04:17.846652 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStructBeforeAutoincr (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.762437 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.762620 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.762637 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.762652 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.762667 drop table if exists "person_test"; [] +gorptest: 05:06:09.762680 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.762694 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.762708 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.762722 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.762739 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.762754 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.762768 drop table if exists "time_test"; [] +gorptest: 05:06:09.762790 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.762962 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: 05:06:09.763089 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.763210 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.763353 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.763482 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.763594 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.763709 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.763825 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.763938 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.767973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.768142 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.768284 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 05:06:09.768373 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.768473 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.768559 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.768644 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.768846 drop table if exists "person_test"; [] +gorptest: 05:06:09.769000 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.769109 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.769202 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.769290 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.769377 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.769465 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.769551 drop table if exists "time_test"; [] +gorptest: 05:06:09.769660 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr -2025/06/21 05:04:17 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: 05:04:17.846867 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.847054 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.847079 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.847095 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.847115 drop table if exists "person_test"; [] -gorptest: 05:04:17.847131 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.847149 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.847164 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.847182 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.847198 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.847216 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.847241 drop table if exists "time_test"; [] -gorptest: 05:04:17.847268 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.847437 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: 05:04:17.847577 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.847711 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.847872 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.848007 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.848129 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.848262 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.848401 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.848544 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.848679 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.848817 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.848975 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 05:04:17.849088 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.849200 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.849363 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.849482 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.849708 drop table if exists "person_test"; [] -gorptest: 05:04:17.849832 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.849965 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.850075 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.850428 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.850545 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.850641 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.850739 drop table if exists "time_test"; [] -gorptest: 05:04:17.850828 drop table if exists "id_created_test"; [] +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.769834 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.770009 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.770029 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.770044 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.770060 drop table if exists "person_test"; [] +gorptest: 05:06:09.770079 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.770093 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.770107 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.770121 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.770136 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.770149 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.770163 drop table if exists "time_test"; [] +gorptest: 05:06:09.770183 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.770345 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: 05:06:09.770473 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.770589 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.770736 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.770861 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.770970 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.771113 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.771244 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.771368 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.771488 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.771600 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.771740 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 05:06:09.771830 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.771924 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.772013 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.772097 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.772252 drop table if exists "person_test"; [] +gorptest: 05:06:09.772350 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.772436 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.772519 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.772608 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.772692 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.772803 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.772908 drop table if exists "time_test"; [] +gorptest: 05:06:09.772993 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedAutoincr (0.00s) === RUN TestSelectVal -gorptest: 05:04:17.850995 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 05:04:17.851355 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: 05:04:17.851455 select Int64 from TableWithNull where Str='abc' [] -gorptest: 05:04:17.851506 select count(*) from TableWithNull [] -gorptest: 05:04:17.851540 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 05:04:17.851573 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 05:04:17.851601 select Int64 from TableWithNull where Str='abc' [] -gorptest: 05:04:17.851629 select Float64 from TableWithNull where Str='abc' [] -gorptest: 05:04:17.851655 select min(Float64) from TableWithNull [] -gorptest: 05:04:17.851690 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 05:04:17.851732 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 05:04:17.851759 select Float64 from TableWithNull where Str='abc' [] -gorptest: 05:04:17.851788 select Str from TableWithNull where Int64=? [1:78] -gorptest: 05:04:17.851816 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 05:04:17.851850 select Str from TableWithNull where Int64=? [1:78] -gorptest: 05:04:17.851878 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 05:04:17.851929 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 05:04:17.851964 select Str from TableWithNull where Int64=? [1:78] -gorptest: 05:04:17.851994 drop table if exists "TableWithNull"; [] ---- PASS: TestSelectVal (0.00s) +gorptest: 05:06:09.773138 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 05:06:09.773470 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: 05:06:09.773558 select Int64 from TableWithNull where Str='abc' [] +gorptest: 05:06:09.781792 select count(*) from TableWithNull [] +gorptest: 05:06:09.781857 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 05:06:09.781894 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 05:06:09.781920 select Int64 from TableWithNull where Str='abc' [] +gorptest: 05:06:09.781944 select Float64 from TableWithNull where Str='abc' [] +gorptest: 05:06:09.781967 select min(Float64) from TableWithNull [] +gorptest: 05:06:09.781996 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 05:06:09.782022 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 05:06:09.782043 select Float64 from TableWithNull where Str='abc' [] +gorptest: 05:06:09.782069 select Str from TableWithNull where Int64=? [1:78] +gorptest: 05:06:09.782094 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 05:06:09.782115 select Str from TableWithNull where Int64=? [1:78] +gorptest: 05:06:09.782138 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 05:06:09.782173 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 05:06:09.782201 select Str from TableWithNull where Int64=? [1:78] +gorptest: 05:06:09.782229 drop table if exists "TableWithNull"; [] +--- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows -2025/06/21 05:04:17 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: 05:04:17.852292 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.852465 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.852493 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.852509 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.852528 drop table if exists "person_test"; [] -gorptest: 05:04:17.852547 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.852565 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.852580 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.852596 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.852613 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.852629 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.852646 drop table if exists "time_test"; [] -gorptest: 05:04:17.852669 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.852836 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: 05:04:17.852977 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.853102 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.853258 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.853474 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.853972 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.854135 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.854277 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.854404 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.854529 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.854655 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.854796 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257854779299 2:1750482257854779299 3:"Bob" 4:"Smith" 5:1] -gorptest: 05:04:17.854897 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257854891299 2:1750482257854891299 3:"Jane" 4:"Smith" 5:1] -gorptest: 05:04:17.854990 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257854973739 2:1750482257854973739 3:"Mike" 4:"Smith" 5:1] -gorptest: 05:04:17.855108 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.855224 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.855322 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.855415 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.855609 drop table if exists "person_test"; [] -gorptest: 05:04:17.855724 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.855822 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.855918 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.856014 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.856109 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.856202 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.856292 drop table if exists "time_test"; [] -gorptest: 05:04:17.856378 drop table if exists "id_created_test"; [] ---- PASS: TestVersionMultipleRows (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.782559 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.782754 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.782772 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.782787 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.782801 drop table if exists "person_test"; [] +gorptest: 05:06:09.782816 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.782830 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.782843 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.782860 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.782875 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.782889 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.782902 drop table if exists "time_test"; [] +gorptest: 05:06:09.782925 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.783101 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: 05:06:09.783241 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.783358 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.783508 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.783628 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.783735 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.783845 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.783959 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.784068 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.784182 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.784294 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.784425 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369784408174 2:1750482369784408174 3:"Bob" 4:"Smith" 5:1] +gorptest: 05:06:09.784518 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369784512254 2:1750482369784512254 3:"Jane" 4:"Smith" 5:1] +gorptest: 05:06:09.784597 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369784592414 2:1750482369784592414 3:"Mike" 4:"Smith" 5:1] +gorptest: 05:06:09.784664 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.784795 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.784897 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.784985 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.785144 drop table if exists "person_test"; [] +gorptest: 05:06:09.785251 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.785336 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.785420 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.785503 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.790213 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.790422 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.790521 drop table if exists "time_test"; [] +gorptest: 05:06:09.790606 drop table if exists "id_created_test"; [] +--- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk -gorptest: 05:04:17.856542 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 05:04:17.856870 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 05:04:17.856955 drop table if exists "string_pk_test"; [] +gorptest: 05:06:09.790741 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 05:06:09.791066 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 05:06:09.791141 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2025/06/21 05:04:17 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: 05:04:17.857547 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.857783 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.857811 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.857827 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.857846 drop table if exists "person_test"; [] -gorptest: 05:04:17.857865 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.857880 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.857896 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.857911 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.857928 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.857944 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.857961 drop table if exists "time_test"; [] -gorptest: 05:04:17.857983 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.858178 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: 05:04:17.858320 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.858446 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.858609 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.858740 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.858862 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.858980 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.859100 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.859218 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.859354 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.859485 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.859638 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-21 04:33:17.859620379 +0000 UTC] -gorptest: 05:04:17.859758 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-21 04:34:18.859620379 +0000 UTC] -gorptest: 05:04:17.859843 SELECT id FROM time_test WHERE Time < ? [1:2025-06-21 04:34:17.859620379 +0000 UTC] -gorptest: 05:04:17.859913 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.860022 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.860119 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.860211 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.860390 drop table if exists "person_test"; [] -gorptest: 05:04:17.860496 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.860599 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.860690 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.860778 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.860866 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.860951 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.861041 drop table if exists "time_test"; [] -gorptest: 05:04:17.861133 drop table if exists "id_created_test"; [] ---- PASS: TestWithTimeSelect (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.791532 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.791738 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.791758 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.791773 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.791787 drop table if exists "person_test"; [] +gorptest: 05:06:09.791803 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.791817 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.791832 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.791847 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.791861 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.791875 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.791889 drop table if exists "time_test"; [] +gorptest: 05:06:09.791910 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.792090 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: 05:06:09.792237 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.792394 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.792568 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.792692 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.792837 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.792958 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.793074 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.793188 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.793301 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.793410 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.793543 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-21 04:35:09.793525894 +0000 UTC] +gorptest: 05:06:09.797823 insert into "time_test" ("Id","Time") values (null,?); [1:2025-06-21 04:36:10.793525894 +0000 UTC] +gorptest: 05:06:09.797960 SELECT id FROM time_test WHERE Time < ? [1:2025-06-21 04:36:09.793525894 +0000 UTC] +gorptest: 05:06:09.798057 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.798185 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.798284 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.798369 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.798556 drop table if exists "person_test"; [] +gorptest: 05:06:09.798673 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.798764 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.798851 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.798933 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.799017 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.799101 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.799181 drop table if exists "time_test"; [] +gorptest: 05:06:09.799269 drop table if exists "id_created_test"; [] +--- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView -2025/06/21 05:04:17 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: 05:04:17.861511 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.861706 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.861731 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.861747 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.861765 drop table if exists "person_test"; [] -gorptest: 05:04:17.861779 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.861797 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.861811 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.861828 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.861843 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.861859 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.861874 drop table if exists "time_test"; [] -gorptest: 05:04:17.861906 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.862073 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: 05:04:17.862226 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.862360 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.862516 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.862644 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.862759 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.862875 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.862995 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.863115 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.863238 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.863361 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.863500 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257863484419 2:1750482257863484419 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.863618 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 05:04:17.863701 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 05:04:17.863785 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.863915 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.864018 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.864112 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.864288 drop table if exists "person_test"; [] -gorptest: 05:04:17.864404 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.864509 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.864602 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.864692 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.864778 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.864865 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.864953 drop table if exists "time_test"; [] -gorptest: 05:04:17.865039 drop table if exists "id_created_test"; [] ---- PASS: TestInvoicePersonView (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.799435 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.799613 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.799629 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.799643 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.799658 drop table if exists "person_test"; [] +gorptest: 05:06:09.799671 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.799684 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.799698 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.799712 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.799726 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.799741 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.799755 drop table if exists "time_test"; [] +gorptest: 05:06:09.799775 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.799936 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: 05:06:09.800063 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.800174 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.800319 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.800433 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.800540 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.800650 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.800790 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.800917 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.801033 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.801146 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.801276 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369801255614 2:1750482369801255614 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.801371 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 05:06:09.801445 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 05:06:09.801520 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.810044 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.810214 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.810309 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.810468 drop table if exists "person_test"; [] +gorptest: 05:06:09.810581 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.810670 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.810757 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.810839 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.810919 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.811002 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.811083 drop table if exists "time_test"; [] +gorptest: 05:06:09.811165 drop table if exists "id_created_test"; [] +--- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames -2025/06/21 05:04:17 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: 05:04:17.865239 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.865475 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.865524 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.865546 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.865564 drop table if exists "person_test"; [] -gorptest: 05:04:17.865580 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.865596 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.865610 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.865627 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.865641 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.865659 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.865673 drop table if exists "time_test"; [] -gorptest: 05:04:17.865698 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.865892 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: 05:04:17.866031 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.866459 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.866654 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.866791 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.866907 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.867029 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.867165 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.867293 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.867419 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.867541 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] ---- PASS: TestQuoteTableNames (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.811346 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.811558 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.811577 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.811594 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.811608 drop table if exists "person_test"; [] +gorptest: 05:06:09.811622 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.811637 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.811651 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.811665 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.811680 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.811694 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.811710 drop table if exists "time_test"; [] +gorptest: 05:06:09.811731 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.811905 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: 05:06:09.812031 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.812149 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.812291 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.812410 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.812521 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.812632 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.812767 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.812903 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.813027 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.813147 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +--- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols -2025/06/21 05:04:17 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: 05:04:17.869115 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.869346 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.869379 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.869395 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.869413 drop table if exists "person_test"; [] -gorptest: 05:04:17.869430 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.869444 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.869462 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.869476 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.869493 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.869515 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.869533 drop table if exists "time_test"; [] -gorptest: 05:04:17.869554 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.869753 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: 05:04:17.869899 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.870026 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.870198 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.870320 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.870443 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.870558 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.870674 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.870789 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.870904 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.871023 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.871154 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257871138899 2:1750482257871138899 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.871249 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257871242019 2:1750482257871242019 3:"jane" 4:"doe" 5:1] -gorptest: 05:04:17.871325 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.871384 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 05:04:17.871445 select * from person_test where Id=? [1:1] -gorptest: 05:04:17.871508 select * from person_test order by fname asc [] -gorptest: 05:04:17.871574 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.871690 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.871787 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.871877 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.872048 drop table if exists "person_test"; [] -gorptest: 05:04:17.872154 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.872244 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.872331 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.872417 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.872501 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.872586 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.872672 drop table if exists "time_test"; [] -gorptest: 05:04:17.872756 drop table if exists "id_created_test"; [] ---- PASS: TestSelectTooManyCols (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.819122 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.819311 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.819328 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.819343 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.819358 drop table if exists "person_test"; [] +gorptest: 05:06:09.819375 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.819388 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.819404 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.819419 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.819434 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.819449 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.819462 drop table if exists "time_test"; [] +gorptest: 05:06:09.819486 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.819680 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: 05:06:09.819834 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.819953 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.820098 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.820217 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.820329 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.820437 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.820547 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.820661 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.820805 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.820933 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.821062 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369821046334 2:1750482369821046334 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.821157 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369821150374 2:1750482369821150374 3:"jane" 4:"doe" 5:1] +gorptest: 05:06:09.821230 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.821291 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 05:06:09.821334 select * from person_test where Id=? [1:1] +gorptest: 05:06:09.821381 select * from person_test order by fname asc [] +gorptest: 05:06:09.821435 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.821547 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.825963 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.826089 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.826253 drop table if exists "person_test"; [] +gorptest: 05:06:09.826359 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.826452 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.826533 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.826623 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.826710 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.826794 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.826873 drop table if exists "time_test"; [] +gorptest: 05:06:09.826954 drop table if exists "id_created_test"; [] +--- PASS: TestSelectTooManyCols (0.01s) === RUN TestSelectSingleVal -2025/06/21 05:04:17 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: 05:04:17.872949 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.873115 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.873149 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.873166 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.873183 drop table if exists "person_test"; [] -gorptest: 05:04:17.873198 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.873215 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.873231 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.873247 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.873261 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.873296 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.873318 drop table if exists "time_test"; [] -gorptest: 05:04:17.873341 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.873504 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: 05:04:17.873637 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.873759 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.873912 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.874042 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.874450 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.874602 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.874716 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.874889 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.875019 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.875145 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.875291 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257875267659 2:1750482257875267659 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.875386 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 05:04:17.875464 select * from person_test where Id=? [1:1] -gorptest: 05:04:17.875544 select FName from person_test where Id=? [1:1] -gorptest: 05:04:17.875578 select * from person_test where Id=? [1:1] -gorptest: 05:04:17.875637 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 05:04:17.875683 select * from person_test where Id=? [1:-2222] -gorptest: 05:04:17.875730 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482257875722339 2:1750482257875722339 3:"bob" 4:"smith" 5:1] -gorptest: 05:04:17.875829 select * from person_test where Fname='bob' [] -gorptest: 05:04:17.875899 select * from person_test where Id=-123 [] -gorptest: 05:04:17.875929 select * from person_test where Id=-123 [] -gorptest: 05:04:17.875955 select * from person_test where Id=-123 [] -gorptest: 05:04:17.875980 select * from person_test where Id=-123 [] -gorptest: 05:04:17.876005 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.876106 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.876210 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.876299 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.876471 drop table if exists "person_test"; [] -gorptest: 05:04:17.876582 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.876673 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.876769 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.876860 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.876950 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.877040 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.877127 drop table if exists "time_test"; [] -gorptest: 05:04:17.877213 drop table if exists "id_created_test"; [] ---- PASS: TestSelectSingleVal (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.827136 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.827319 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.827338 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.827352 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.827367 drop table if exists "person_test"; [] +gorptest: 05:06:09.827383 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.827397 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.827415 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.827429 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.827444 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.827458 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.827473 drop table if exists "time_test"; [] +gorptest: 05:06:09.827495 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.827665 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: 05:06:09.827832 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.827955 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.828102 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.828218 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.828330 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.828444 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.828560 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.828675 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.828818 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.828943 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.829081 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369829065454 2:1750482369829065454 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.829180 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 05:06:09.829245 select * from person_test where Id=? [1:1] +gorptest: 05:06:09.829306 select FName from person_test where Id=? [1:1] +gorptest: 05:06:09.829334 select * from person_test where Id=? [1:1] +gorptest: 05:06:09.829381 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 05:06:09.829421 select * from person_test where Id=? [1:-2222] +gorptest: 05:06:09.829471 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1750482369829458694 2:1750482369829458694 3:"bob" 4:"smith" 5:1] +gorptest: 05:06:09.829557 select * from person_test where Fname='bob' [] +gorptest: 05:06:09.833818 select * from person_test where Id=-123 [] +gorptest: 05:06:09.833869 select * from person_test where Id=-123 [] +gorptest: 05:06:09.833900 select * from person_test where Id=-123 [] +gorptest: 05:06:09.833924 select * from person_test where Id=-123 [] +gorptest: 05:06:09.833949 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.834112 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.834213 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.834302 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.834465 drop table if exists "person_test"; [] +gorptest: 05:06:09.834571 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.834659 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.834772 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.834878 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.834969 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.835054 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.835137 drop table if exists "time_test"; [] +gorptest: 05:06:09.835221 drop table if exists "id_created_test"; [] +--- PASS: TestSelectSingleVal (0.01s) === RUN TestSelectAlias -2025/06/21 05:04:17 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: 05:04:17.877417 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.877597 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.877640 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.877656 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.877676 drop table if exists "person_test"; [] -gorptest: 05:04:17.877692 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.877706 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.877722 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.877736 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.877753 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.877767 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.877784 drop table if exists "time_test"; [] -gorptest: 05:04:17.877806 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.877965 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: 05:04:17.878095 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.878237 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.878391 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.878528 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.878652 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.878768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.878884 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.879001 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.879125 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.879246 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.879368 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 05:04:17.879452 select * from id_created_test where Id=1 [] -gorptest: 05:04:17.879518 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 05:04:17.879572 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.879915 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.880032 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.880125 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.880332 drop table if exists "person_test"; [] -gorptest: 05:04:17.880438 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.880535 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.880629 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.880717 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.880835 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.880940 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.881037 drop table if exists "time_test"; [] -gorptest: 05:04:17.881125 drop table if exists "id_created_test"; [] ---- PASS: TestSelectAlias (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.835418 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.835604 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.835623 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.835638 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.835653 drop table if exists "person_test"; [] +gorptest: 05:06:09.835668 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.835685 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.835700 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.835713 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.835727 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.835742 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.835757 drop table if exists "time_test"; [] +gorptest: 05:06:09.835779 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.835959 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: 05:06:09.836089 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.836203 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.836349 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.836480 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.836593 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.836704 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.836852 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.836979 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.837104 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.837222 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.837344 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 05:06:09.837424 select * from id_created_test where Id=1 [] +gorptest: 05:06:09.837483 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 05:06:09.837530 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.846100 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.846237 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.846329 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.846495 drop table if exists "person_test"; [] +gorptest: 05:06:09.846595 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.846682 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.846772 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.846856 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.846938 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.847025 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.847111 drop table if exists "time_test"; [] +gorptest: 05:06:09.847192 drop table if exists "id_created_test"; [] +--- PASS: TestSelectAlias (0.01s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2025/06/21 05:04:17 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: 05:04:17.881383 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.881575 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.881604 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.881624 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.881639 drop table if exists "person_test"; [] -gorptest: 05:04:17.881656 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.881670 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.881686 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.881701 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.881718 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.881732 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.881750 drop table if exists "time_test"; [] -gorptest: 05:04:17.881773 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.881935 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: 05:04:17.882070 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.882215 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.882383 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.882516 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.882634 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.882753 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.882877 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.882993 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.883112 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.883228 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.883353 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.883457 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.883547 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.883634 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.883808 drop table if exists "person_test"; [] -gorptest: 05:04:17.883911 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.883998 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.884093 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.884183 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.884271 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.884356 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.884442 drop table if exists "time_test"; [] -gorptest: 05:04:17.884525 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.884549 drop table if exists "single_column_table"; [] -gorptest: 05:04:17.884572 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: 05:04:17.884728 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: 05:04:17.884860 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.884988 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: 05:04:17.885150 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: 05:04:17.885301 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.885439 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.885571 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.885698 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.885818 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.885938 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: 05:04:17.886059 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.886194 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 05:04:17.886226 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 05:04:17.886360 delete from "invoice_test"; [] -gorptest: 05:04:17.886425 delete from "invoice_tag_test"; [] -gorptest: 05:04:17.886478 delete from "alias_trans_field_test"; [] -gorptest: 05:04:17.886529 delete from "invoice_override_test"; [] -gorptest: 05:04:17.886606 delete from "person_test"; [] -gorptest: 05:04:17.886665 delete from "ignored_column_test"; [] -gorptest: 05:04:17.886720 delete from "id_created_test"; [] -gorptest: 05:04:17.886771 delete from "type_conv_test"; [] -gorptest: 05:04:17.886819 delete from "embedded_struct_test"; [] -gorptest: 05:04:17.886869 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.886917 delete from "embedded_autoincr_test"; [] -gorptest: 05:04:17.886965 delete from "time_test"; [] -gorptest: 05:04:17.887013 delete from "id_created_test"; [] -gorptest: 05:04:17.887061 delete from "single_column_table"; [] -gorptest: 05:04:17.887131 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 05:04:17.887185 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.887291 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.887383 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.887476 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.887659 drop table if exists "person_test"; [] -gorptest: 05:04:17.887762 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.887851 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.887936 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.888021 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.888103 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.888187 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.888273 drop table if exists "time_test"; [] -gorptest: 05:04:17.888354 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.888376 drop table if exists "single_column_table"; [] ---- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.01s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.847393 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.847577 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.847596 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.847614 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.847632 drop table if exists "person_test"; [] +gorptest: 05:06:09.847647 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.847662 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.847677 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.847692 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.847706 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.847721 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.847735 drop table if exists "time_test"; [] +gorptest: 05:06:09.847756 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.847930 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: 05:06:09.848055 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.848167 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.848308 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.848424 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.848534 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.848643 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.848780 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.848918 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.849040 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.849151 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.849265 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.849366 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.849452 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.849532 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.853947 drop table if exists "person_test"; [] +gorptest: 05:06:09.854115 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.854209 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.854296 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.854398 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.854506 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.854604 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.854691 drop table if exists "time_test"; [] +gorptest: 05:06:09.854774 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.854794 drop table if exists "single_column_table"; [] +gorptest: 05:06:09.854818 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: 05:06:09.854983 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: 05:06:09.855106 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.855221 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: 05:06:09.855362 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: 05:06:09.855478 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.855586 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.855697 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.855810 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.855978 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.856137 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: 05:06:09.856263 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.856381 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 05:06:09.856407 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 05:06:09.856539 delete from "invoice_test"; [] +gorptest: 05:06:09.856598 delete from "invoice_tag_test"; [] +gorptest: 05:06:09.856650 delete from "alias_trans_field_test"; [] +gorptest: 05:06:09.856697 delete from "invoice_override_test"; [] +gorptest: 05:06:09.856776 delete from "person_test"; [] +gorptest: 05:06:09.856834 delete from "ignored_column_test"; [] +gorptest: 05:06:09.856884 delete from "id_created_test"; [] +gorptest: 05:06:09.856931 delete from "type_conv_test"; [] +gorptest: 05:06:09.856978 delete from "embedded_struct_test"; [] +gorptest: 05:06:09.857028 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.857082 delete from "embedded_autoincr_test"; [] +gorptest: 05:06:09.857128 delete from "time_test"; [] +gorptest: 05:06:09.857173 delete from "id_created_test"; [] +gorptest: 05:06:09.857218 delete from "single_column_table"; [] +gorptest: 05:06:09.857287 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 05:06:09.857337 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.857444 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.857535 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.865883 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.866116 drop table if exists "person_test"; [] +gorptest: 05:06:09.866225 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.866313 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.866400 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.866482 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.866565 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.866649 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.866730 drop table if exists "time_test"; [] +gorptest: 05:06:09.866808 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.866826 drop table if exists "single_column_table"; [] +--- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.02s) === RUN TestPrepare -2025/06/21 05:04:17 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: 05:04:17.888717 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.888899 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.888924 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.888938 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.888955 drop table if exists "person_test"; [] -gorptest: 05:04:17.888970 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.888986 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.889011 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.889028 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.889044 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.889063 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.889076 drop table if exists "time_test"; [] -gorptest: 05:04:17.889100 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.889261 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: 05:04:17.889417 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 05:04:17.889548 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 05:04:17.889701 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 05:04:17.889829 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.889944 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 05:04:17.890059 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 05:04:17.890198 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 05:04:17.890320 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 05:04:17.890441 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 05:04:17.890563 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 05:04:17.890701 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 05:04:17.890797 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 05:04:17.890877 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 05:04:17.890965 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 05:04:17.891062 begin; [] -gorptest: 05:04:17.891100 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 05:04:17.891159 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 05:04:17.891416 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 05:04:17.891484 commit; [] -gorptest: 05:04:17.891544 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 05:04:17.891626 drop table if exists "invoice_test"; [] -gorptest: 05:04:17.891799 drop table if exists "invoice_tag_test"; [] -gorptest: 05:04:17.891903 drop table if exists "alias_trans_field_test"; [] -gorptest: 05:04:17.891994 drop table if exists "invoice_override_test"; [] -gorptest: 05:04:17.892177 drop table if exists "person_test"; [] -gorptest: 05:04:17.892280 drop table if exists "ignored_column_test"; [] -gorptest: 05:04:17.892420 drop table if exists "id_created_test"; [] -gorptest: 05:04:17.892513 drop table if exists "type_conv_test"; [] -gorptest: 05:04:17.892600 drop table if exists "embedded_struct_test"; [] -gorptest: 05:04:17.892688 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 05:04:17.892773 drop table if exists "embedded_autoincr_test"; [] -gorptest: 05:04:17.892858 drop table if exists "time_test"; [] -gorptest: 05:04:17.892944 drop table if exists "id_created_test"; [] ---- PASS: TestPrepare (0.00s) +2025/06/21 05:06:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 +gorptest: 05:06:09.867127 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.867325 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.867345 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.867363 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.867377 drop table if exists "person_test"; [] +gorptest: 05:06:09.867392 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.867405 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.867420 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.867434 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.867448 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.867462 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.867477 drop table if exists "time_test"; [] +gorptest: 05:06:09.867499 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.867670 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: 05:06:09.867797 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 05:06:09.867907 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 05:06:09.868050 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 05:06:09.868169 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.868275 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 05:06:09.868384 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 05:06:09.868492 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 05:06:09.868604 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 05:06:09.868720 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 05:06:09.868875 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 05:06:09.869012 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 05:06:09.869108 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 05:06:09.869175 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 05:06:09.869260 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 05:06:09.869334 begin; [] +gorptest: 05:06:09.869350 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 05:06:09.869396 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 05:06:09.873979 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 05:06:09.874053 commit; [] +gorptest: 05:06:09.874135 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 05:06:09.874214 drop table if exists "invoice_test"; [] +gorptest: 05:06:09.874413 drop table if exists "invoice_tag_test"; [] +gorptest: 05:06:09.874522 drop table if exists "alias_trans_field_test"; [] +gorptest: 05:06:09.874611 drop table if exists "invoice_override_test"; [] +gorptest: 05:06:09.874781 drop table if exists "person_test"; [] +gorptest: 05:06:09.874880 drop table if exists "ignored_column_test"; [] +gorptest: 05:06:09.874967 drop table if exists "id_created_test"; [] +gorptest: 05:06:09.875052 drop table if exists "type_conv_test"; [] +gorptest: 05:06:09.875135 drop table if exists "embedded_struct_test"; [] +gorptest: 05:06:09.875214 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 05:06:09.875298 drop table if exists "embedded_autoincr_test"; [] +gorptest: 05:06:09.875379 drop table if exists "time_test"; [] +gorptest: 05:06:09.875459 drop table if exists "id_created_test"; [] +--- PASS: TestPrepare (0.01s) PASS -ok gopkg.in/gorp.v1 0.176s +ok gopkg.in/gorp.v1 0.311s 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/128342/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/128342/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/1467198 and its subdirectories -I: Current time: Fri Jun 20 17:04:22 -12 2025 -I: pbuilder-time-stamp: 1750482262 +I: removing directory /srv/workspace/pbuilder/128342 and its subdirectories +I: Current time: Sat Jun 21 19:06:15 +14 2025 +I: pbuilder-time-stamp: 1750482375