Diff of the two buildlogs: -- --- b1/build.log 2023-04-22 22:34:18.121833851 +0000 +++ b2/build.log 2023-04-22 22:35:36.382364149 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri May 24 16:55:20 -12 2024 -I: pbuilder-time-stamp: 1716612920 +I: Current time: Sun Apr 23 12:34:20 +14 2023 +I: pbuilder-time-stamp: 1682202860 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/bookworm-reproducible-base.tgz] I: copying local configuration @@ -16,7 +16,7 @@ I: copying [./golang-gopkg-gorp.v1_1.7.2.orig.tar.xz] I: copying [./golang-gopkg-gorp.v1_1.7.2-2.debian.tar.xz] I: Extracting source -gpgv: Signature made Sun Apr 19 02:59:56 2020 -12 +gpgv: Signature made Mon Apr 20 04:59:56 2020 +14 gpgv: using RSA key D30863E26020E543F4719A838F53E0193B294B75 gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify inline signature for ./golang-gopkg-gorp.v1_1.7.2-2.dsc: no acceptable signature found @@ -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/27821/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/14986/tmp/hooks/D01_modify_environment starting +debug: Running on codethink12-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 Apr 23 12:34 /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/14986/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/14986/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build' - 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]="15" [3]="1" [4]="release" [5]="aarch64-unknown-linux-gnu") + BASH_VERSION='5.2.15(1)-release' + BUILDDIR=/build + 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=8' - DISTRIBUTION='bookworm' - HOME='/var/lib/jenkins' - HOST_ARCH='arm64' + DIRSTACK=() + DISTRIBUTION=bookworm + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/var/lib/jenkins + HOSTNAME=i-capture-the-hostname + HOSTTYPE=aarch64 + HOST_ARCH=arm64 IFS=' ' - 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='27821' - PS1='# ' - PS2='> ' + 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=14986 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.UL7eA8ov/pbuilderrc_dAP7 --distribution bookworm --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.UL7eA8ov/b1 --logfile b1/build.log golang-gopkg-gorp.v1_1.7.2-2.dsc' - SUDO_GID='117' - SUDO_UID='110' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - USERNAME='root' - _='/usr/bin/systemd-run' - http_proxy='http://192.168.101.16: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.UL7eA8ov/pbuilderrc_QUwk --distribution bookworm --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/bookworm-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.UL7eA8ov/b2 --logfile b2/build.log --extrapackages usrmerge golang-gopkg-gorp.v1_1.7.2-2.dsc' + SUDO_GID=117 + SUDO_UID=110 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + USERNAME=root + _='I: set' + http_proxy=http://192.168.101.16:3128 I: uname -a - Linux codethink15-arm64 4.15.0-209-generic #220-Ubuntu SMP Tue Mar 21 19:52:44 UTC 2023 aarch64 GNU/Linux + Linux i-capture-the-hostname 4.15.0-209-generic #220-Ubuntu SMP Tue Mar 21 19:52:44 UTC 2023 aarch64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 May 24 04:47 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/27821/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Apr 22 00:25 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/14986/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 bookworm/main arm64 libsqlite3-dev arm64 3.40.1-2 [979 kB] Get: 59 http://deb.debian.org/debian bookworm/main arm64 golang-github-mattn-go-sqlite3-dev arm64 1.14.16~ds1-1 [82.2 kB] Get: 60 http://deb.debian.org/debian bookworm/main arm64 golang-github-ziutek-mymysql-dev all 1.5.4+git20170206.23.0582bcf-2 [46.8 kB] -Fetched 101 MB in 3s (32.9 MB/s) +Fetched 101 MB in 2s (56.8 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 ... 19616 files and directories currently installed.) @@ -432,8 +464,17 @@ Writing extended state information... Building tag database... -> Finished parsing the build-deps +Reading package lists... +Building dependency tree... +Reading state information... +usrmerge is already the newest version (35). +0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. I: Building the package -I: Running cd /build/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/14986/tmp/hooks/A99_set_merged_usr starting +Re-configuring usrmerge... +I: user script /srv/workspace/pbuilder/14986/tmp/hooks/A99_set_merged_usr finished +hostname: Temporary failure in name resolution +I: Running cd /build/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 @@ -455,20 +496,20 @@ internal/goarch internal/unsafeheader internal/goexperiment -internal/race +internal/cpu internal/goos -unicode +internal/race runtime/internal/syscall -internal/cpu -internal/abi +unicode/utf8 sync/atomic +unicode +internal/abi runtime/internal/math -unicode/utf8 runtime/internal/sys internal/itoa math/bits -internal/bytealg runtime/internal/atomic +internal/bytealg math runtime internal/reflectlite @@ -476,25 +517,25 @@ internal/testlog errors sort -io internal/oserror -strconv internal/safefilepath +io path +strconv syscall bytes strings reflect regexp/syntax -internal/syscall/unix -internal/syscall/execenv time +internal/syscall/execenv +internal/syscall/unix regexp context -internal/poll io/fs -internal/fmtsort +internal/poll os +internal/fmtsort fmt log database/sql/driver @@ -503,1283 +544,1283 @@ dh_auto_test -O--builddirectory=_build -O--buildsystem=golang cd _build && go test -vet=off -v -p 8 gopkg.in/gorp.v1 === RUN TestCreateTablesIfNotExists -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.624270 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.626088 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.626236 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.626336 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.626438 drop table if exists "person_test"; [] -gorptest: 16:57:06.626546 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.626644 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.626739 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.626836 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.626933 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.627056 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.627157 drop table if exists "time_test"; [] -gorptest: 16:57:06.627314 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.628464 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.629128 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.629881 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.630610 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.631249 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.631852 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.632475 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.633085 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.633818 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.634450 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.635073 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.635718 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.635875 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.636005 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.636135 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.636286 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.636417 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.636533 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.636657 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.636790 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.636927 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.637063 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.637370 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.637535 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 16:57:06.637663 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.638376 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.638947 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.639491 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.640224 drop table if exists "person_test"; [] -gorptest: 16:57:06.640809 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.641449 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.641990 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.642533 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.643081 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.643609 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.644129 drop table if exists "time_test"; [] -gorptest: 16:57:06.644649 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.247199 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.248287 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.248387 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.248503 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.248593 drop table if exists "person_test"; [] +gorptest: 12:35:28.248689 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.248807 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.248911 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.249008 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.249104 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.249219 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.249308 drop table if exists "time_test"; [] +gorptest: 12:35:28.249412 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.250271 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: 12:35:28.250807 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.251313 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.251909 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.252429 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.252947 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.253445 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.253956 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.254472 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.254981 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.255486 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.256004 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: 12:35:28.256137 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: 12:35:28.256253 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.256362 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: 12:35:28.256491 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: 12:35:28.256604 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.256704 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.256835 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.256948 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.257055 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.257161 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: 12:35:28.257264 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.257364 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 12:35:28.257457 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.257946 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.258384 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.258825 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.259411 drop table if exists "person_test"; [] +gorptest: 12:35:28.259848 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.260281 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.260713 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.261166 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.261595 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.262025 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.262453 drop table if exists "time_test"; [] +gorptest: 12:35:28.262878 drop table if exists "id_created_test"; [] --- PASS: TestCreateTablesIfNotExists (0.02s) === RUN TestTruncateTables -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.645440 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.646242 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.646385 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.646506 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.646630 drop table if exists "person_test"; [] -gorptest: 16:57:06.646741 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.646845 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.646948 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.647056 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.647165 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.647293 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.647413 drop table if exists "time_test"; [] -gorptest: 16:57:06.647582 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.648356 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.649002 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.649838 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.650587 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.651189 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.651766 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.652352 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.652958 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.653661 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.654391 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.655018 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.655645 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.655799 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.655929 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.656064 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.656201 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.656327 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.656448 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.656576 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.656745 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.656880 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.657042 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.657175 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.657391 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 16:57:06.657603 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613026657539160 2:1716613026657539160 3:"Bob" 4:"Smith" 5:1] -gorptest: 16:57:06.658215 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] -gorptest: 16:57:06.658676 delete from "invoice_test"; [] -gorptest: 16:57:06.658994 delete from "invoice_tag_test"; [] -gorptest: 16:57:06.659297 delete from "alias_trans_field_test"; [] -gorptest: 16:57:06.659603 delete from "invoice_override_test"; [] -gorptest: 16:57:06.659926 delete from "person_test"; [] -gorptest: 16:57:06.660249 delete from "ignored_column_test"; [] -gorptest: 16:57:06.660546 delete from "id_created_test"; [] -gorptest: 16:57:06.660846 delete from "type_conv_test"; [] -gorptest: 16:57:06.661149 delete from "embedded_struct_test"; [] -gorptest: 16:57:06.661543 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.661862 delete from "embedded_autoincr_test"; [] -gorptest: 16:57:06.662190 delete from "time_test"; [] -gorptest: 16:57:06.662507 delete from "id_created_test"; [] -gorptest: 16:57:06.662805 SELECT * FROM person_test [] -gorptest: 16:57:06.663152 SELECT * FROM invoice_test [] -gorptest: 16:57:06.663401 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.664046 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.664568 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.665090 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.665889 drop table if exists "person_test"; [] -gorptest: 16:57:06.666460 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.666986 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.667499 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.668014 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.668521 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.669036 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.669639 drop table if exists "time_test"; [] -gorptest: 16:57:06.670171 drop table if exists "id_created_test"; [] ---- PASS: TestTruncateTables (0.03s) +2023/04/23 12:35:28 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: 12:35:28.263350 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.263901 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.263999 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.264087 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.264166 drop table if exists "person_test"; [] +gorptest: 12:35:28.264252 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.264334 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.264416 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.264501 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.264581 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.264663 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.264761 drop table if exists "time_test"; [] +gorptest: 12:35:28.264881 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.265429 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: 12:35:28.265950 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.266458 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.267035 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.267550 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.268047 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.268561 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.269099 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.269677 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.270194 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.270724 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.271251 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: 12:35:28.271379 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: 12:35:28.271476 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.271589 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: 12:35:28.271696 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: 12:35:28.271790 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.271879 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.271969 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.272084 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.272206 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.272310 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: 12:35:28.272403 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.272490 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 12:35:28.272627 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928272580947 2:1682202928272580947 3:"Bob" 4:"Smith" 5:1] +gorptest: 12:35:28.273051 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] +gorptest: 12:35:28.273405 delete from "invoice_test"; [] +gorptest: 12:35:28.273664 delete from "invoice_tag_test"; [] +gorptest: 12:35:28.273915 delete from "alias_trans_field_test"; [] +gorptest: 12:35:28.274169 delete from "invoice_override_test"; [] +gorptest: 12:35:28.274433 delete from "person_test"; [] +gorptest: 12:35:28.274679 delete from "ignored_column_test"; [] +gorptest: 12:35:28.274925 delete from "id_created_test"; [] +gorptest: 12:35:28.275186 delete from "type_conv_test"; [] +gorptest: 12:35:28.275433 delete from "embedded_struct_test"; [] +gorptest: 12:35:28.275678 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.275924 delete from "embedded_autoincr_test"; [] +gorptest: 12:35:28.276172 delete from "time_test"; [] +gorptest: 12:35:28.276418 delete from "id_created_test"; [] +gorptest: 12:35:28.276661 SELECT * FROM person_test [] +gorptest: 12:35:28.276932 SELECT * FROM invoice_test [] +gorptest: 12:35:28.277141 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.277582 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.278012 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.278437 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.278981 drop table if exists "person_test"; [] +gorptest: 12:35:28.279428 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.279860 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.280285 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.280712 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.281157 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.281586 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.282008 drop table if exists "time_test"; [] +gorptest: 12:35:28.282428 drop table if exists "id_created_test"; [] +--- PASS: TestTruncateTables (0.02s) === RUN TestCustomDateType -gorptest: 16:57:06.670648 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] -gorptest: 16:57:06.672017 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2024-05-24 16:57:06 -1200 -12] -gorptest: 16:57:06.672493 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] -gorptest: 16:57:06.672819 drop table if exists "WithCustomDate"; [] +gorptest: 12:35:28.282764 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] +gorptest: 12:35:28.283781 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-04-23 12:35:28 +1400 +14] +gorptest: 12:35:28.284141 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] +gorptest: 12:35:28.284373 drop table if exists "WithCustomDate"; [] --- PASS: TestCustomDateType (0.00s) === RUN TestUIntPrimaryKey -gorptest: 16:57:06.674080 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 16:57:06.675333 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 16:57:06.675942 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] -gorptest: 16:57:06.676565 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] -gorptest: 16:57:06.676992 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] -gorptest: 16:57:06.677564 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] -gorptest: 16:57:06.677999 drop table if exists "PersonUInt64"; [] -gorptest: 16:57:06.678574 drop table if exists "PersonUInt32"; [] -gorptest: 16:57:06.679113 drop table if exists "PersonUInt16"; [] ---- PASS: TestUIntPrimaryKey (0.01s) +gorptest: 12:35:28.285041 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 12:35:28.285966 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 12:35:28.286464 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] +gorptest: 12:35:28.286976 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] +gorptest: 12:35:28.287329 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] +gorptest: 12:35:28.287665 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] +gorptest: 12:35:28.287980 drop table if exists "PersonUInt64"; [] +gorptest: 12:35:28.288423 drop table if exists "PersonUInt32"; [] +gorptest: 12:35:28.288885 drop table if exists "PersonUInt16"; [] +--- PASS: TestUIntPrimaryKey (0.00s) === RUN TestSetUniqueTogether -gorptest: 16:57:06.679988 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] -gorptest: 16:57:06.681734 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] -gorptest: 16:57:06.682237 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] -gorptest: 16:57:06.682528 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] -gorptest: 16:57:06.682769 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] -gorptest: 16:57:06.683200 drop table if exists "UniqueColumns"; [] +gorptest: 12:35:28.289531 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] +gorptest: 12:35:28.290594 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] +gorptest: 12:35:28.290958 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] +gorptest: 12:35:28.291174 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] +gorptest: 12:35:28.291343 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] +gorptest: 12:35:28.291693 drop table if exists "UniqueColumns"; [] --- PASS: TestSetUniqueTogether (0.00s) === RUN TestPersistentUser -gorptest: 16:57:06.684390 drop table if exists PersistentUser [] -gorptest: 16:57:06.685212 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 16:57:06.685946 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 16:57:06.686384 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] -gorptest: 16:57:06.686665 select * from PersistentUser [] -gorptest: 16:57:06.686941 select * from PersistentUser [] -gorptest: 16:57:06.687208 select * from PersistentUser [] -gorptest: 16:57:06.687456 select Id from PersistentUser [] -gorptest: 16:57:06.687662 select mykey from PersistentUser [] -gorptest: 16:57:06.687855 select PassedTraining from PersistentUser [] -gorptest: 16:57:06.688052 select Id from PersistentUser [] -gorptest: 16:57:06.688258 drop table if exists "PersistentUser"; [] +gorptest: 12:35:28.292560 drop table if exists PersistentUser [] +gorptest: 12:35:28.293324 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 12:35:28.293885 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 12:35:28.294259 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] +gorptest: 12:35:28.294488 select * from PersistentUser [] +gorptest: 12:35:28.294714 select * from PersistentUser [] +gorptest: 12:35:28.294934 select * from PersistentUser [] +gorptest: 12:35:28.295144 select Id from PersistentUser [] +gorptest: 12:35:28.295317 select mykey from PersistentUser [] +gorptest: 12:35:28.295468 select PassedTraining from PersistentUser [] +gorptest: 12:35:28.295607 select Id from PersistentUser [] +gorptest: 12:35:28.295751 drop table if exists "PersistentUser"; [] --- PASS: TestPersistentUser (0.00s) === RUN TestNamedQueryMap -gorptest: 16:57:06.689071 drop table if exists PersistentUser [] -gorptest: 16:57:06.689928 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 16:57:06.690652 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 16:57:06.691047 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 16:57:06.691519 select * from PersistentUser where mykey = ? [1:43] -gorptest: 16:57:06.691828 select * from PersistentUser where mykey = ? [1:43] -gorptest: 16:57:06.692112 +gorptest: 12:35:28.296329 drop table if exists PersistentUser [] +gorptest: 12:35:28.296927 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 12:35:28.297450 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 12:35:28.297761 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 12:35:28.298141 select * from PersistentUser where mykey = ? [1:43] +gorptest: 12:35:28.298389 select * from PersistentUser where mykey = ? [1:43] +gorptest: 12:35:28.298626 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 16:57:06.692414 +gorptest: 12:35:28.298881 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] -gorptest: 16:57:06.692681 drop table if exists "PersistentUser"; [] +gorptest: 12:35:28.299099 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryMap (0.00s) === RUN TestNamedQueryStruct -gorptest: 16:57:06.693652 drop table if exists PersistentUser [] -gorptest: 16:57:06.694479 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] -gorptest: 16:57:06.695201 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] -gorptest: 16:57:06.695604 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] -gorptest: 16:57:06.696042 +gorptest: 12:35:28.299688 drop table if exists PersistentUser [] +gorptest: 12:35:28.300261 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] +gorptest: 12:35:28.300803 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] +gorptest: 12:35:28.301122 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] +gorptest: 12:35:28.301437 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] -gorptest: 16:57:06.696385 drop table if exists "PersistentUser"; [] +gorptest: 12:35:28.301700 drop table if exists "PersistentUser"; [] --- PASS: TestNamedQueryStruct (0.00s) === RUN TestReturnsNonNilSlice -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.697390 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.698089 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.698211 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.698321 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.698427 drop table if exists "person_test"; [] -gorptest: 16:57:06.698546 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.698667 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.698782 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.698905 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.699029 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.699148 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.699256 drop table if exists "time_test"; [] -gorptest: 16:57:06.699400 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.700138 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.700747 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.701404 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.702126 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.702763 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.703344 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.703956 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.704555 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.705155 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.705854 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.706497 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.707128 select * from invoice_test where id=99999 [] -gorptest: 16:57:06.707419 select * from invoice_test where id=99999 [] -gorptest: 16:57:06.707668 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.708230 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.708758 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.709539 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.710301 drop table if exists "person_test"; [] -gorptest: 16:57:06.710863 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.711399 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.711923 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.712436 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.712963 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.713518 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.714080 drop table if exists "time_test"; [] -gorptest: 16:57:06.714594 drop table if exists "id_created_test"; [] ---- PASS: TestReturnsNonNilSlice (0.02s) +2023/04/23 12:35:28 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: 12:35:28.302389 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.302903 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.302988 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.303060 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.303148 drop table if exists "person_test"; [] +gorptest: 12:35:28.303226 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.303327 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.303424 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.303512 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.303606 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.303695 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.303778 drop table if exists "time_test"; [] +gorptest: 12:35:28.303880 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.304421 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: 12:35:28.305064 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.305571 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.306149 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.306664 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.307162 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.307674 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.308190 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.308697 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.309227 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.309743 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.310248 select * from invoice_test where id=99999 [] +gorptest: 12:35:28.310474 select * from invoice_test where id=99999 [] +gorptest: 12:35:28.310689 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.311116 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.311547 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.311975 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.312520 drop table if exists "person_test"; [] +gorptest: 12:35:28.312969 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.313396 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.313841 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.314281 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.314720 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.315147 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.315573 drop table if exists "time_test"; [] +gorptest: 12:35:28.315998 drop table if exists "id_created_test"; [] +--- PASS: TestReturnsNonNilSlice (0.01s) === RUN TestOverrideVersionCol -gorptest: 16:57:06.715137 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] -gorptest: 16:57:06.716624 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] -gorptest: 16:57:06.716923 drop table if exists "InvoicePersonView"; [] +gorptest: 12:35:28.316348 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] +gorptest: 12:35:28.317448 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: 12:35:28.317688 drop table if exists "InvoicePersonView"; [] --- PASS: TestOverrideVersionCol (0.00s) === RUN TestOptimisticLocking -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.718110 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.718816 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.718929 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.719026 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.719127 drop table if exists "person_test"; [] -gorptest: 16:57:06.719231 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.719365 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.719468 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.719579 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.719689 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.719790 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.719902 drop table if exists "time_test"; [] -gorptest: 16:57:06.720033 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.720776 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.721501 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.722112 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.722820 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.723433 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.724028 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.724613 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.725266 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.725869 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.726501 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.727138 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.727815 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613026727757880 2:1716613026727757880 3:"Bob" 4:"Smith" 5:1] -gorptest: 16:57:06.728316 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:06.728692 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1716613026727757880 2:1716613026727757880 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] -gorptest: 16:57:06.729170 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1716613026727757880 2:1716613026727757880 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] -gorptest: 16:57:06.729471 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:06.729768 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] -gorptest: 16:57:06.729991 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:06.730256 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.730861 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.731422 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.731979 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.732721 drop table if exists "person_test"; [] -gorptest: 16:57:06.733367 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.733917 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.734484 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.735031 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.735586 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.736146 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.736707 drop table if exists "time_test"; [] -gorptest: 16:57:06.737304 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.318517 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.319078 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.319188 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.319270 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.319344 drop table if exists "person_test"; [] +gorptest: 12:35:28.319415 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.319485 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.319577 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.319662 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.319736 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.319822 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.319916 drop table if exists "time_test"; [] +gorptest: 12:35:28.320025 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.320570 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: 12:35:28.321113 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.321630 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.322217 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.322745 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.323252 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.323768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.324296 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.324926 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.325446 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.325959 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.326493 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928326451745 2:1682202928326451745 3:"Bob" 4:"Smith" 5:1] +gorptest: 12:35:28.326870 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.327152 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928326451745 2:1682202928326451745 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] +gorptest: 12:35:28.327519 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928326451745 2:1682202928326451745 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] +gorptest: 12:35:28.327725 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.327983 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] +gorptest: 12:35:28.328161 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.328376 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.328823 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.329255 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.329683 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.330218 drop table if exists "person_test"; [] +gorptest: 12:35:28.330663 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.331092 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.331520 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.331962 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.332390 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.332836 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.333264 drop table if exists "time_test"; [] +gorptest: 12:35:28.333686 drop table if exists "id_created_test"; [] --- PASS: TestOptimisticLocking (0.02s) === RUN TestDoubleAddTable --- PASS: TestDoubleAddTable (0.00s) === RUN TestNullValues -gorptest: 16:57:06.738056 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 16:57:06.739428 insert into TableWithNull values (10, null, null, null, null, null) [] -gorptest: 16:57:06.739822 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 16:57:06.740212 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] -gorptest: 16:57:06.740774 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] -gorptest: 16:57:06.741062 drop table if exists "TableWithNull"; [] +gorptest: 12:35:28.334088 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 12:35:28.335076 insert into TableWithNull values (10, null, null, null, null, null) [] +gorptest: 12:35:28.335397 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 12:35:28.335723 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: 12:35:28.336189 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] +gorptest: 12:35:28.336434 drop table if exists "TableWithNull"; [] --- PASS: TestNullValues (0.00s) === RUN TestColumnProps -gorptest: 16:57:06.742125 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] -gorptest: 16:57:06.743333 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] -gorptest: 16:57:06.743806 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] -gorptest: 16:57:06.744093 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] -gorptest: 16:57:06.744344 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] -gorptest: 16:57:06.744569 drop table if exists "Invoice"; [] ---- PASS: TestColumnProps (0.01s) +gorptest: 12:35:28.337171 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] +gorptest: 12:35:28.338199 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] +gorptest: 12:35:28.338584 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] +gorptest: 12:35:28.338824 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] +gorptest: 12:35:28.339074 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] +gorptest: 12:35:28.339265 drop table if exists "Invoice"; [] +--- PASS: TestColumnProps (0.00s) === RUN TestRawSelect -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.750004 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.750732 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.750825 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.750896 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.750958 drop table if exists "person_test"; [] -gorptest: 16:57:06.751024 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.751095 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.751156 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.751214 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.751270 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.751329 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.751385 drop table if exists "time_test"; [] -gorptest: 16:57:06.751478 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.752219 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.752791 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.755103 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.755999 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.756668 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.757909 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.758643 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.759292 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.759934 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.760602 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.761716 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.762498 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613026762441580 2:1716613026762441580 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:06.763065 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] -gorptest: 16:57:06.763506 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 16:57:06.763890 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.764479 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.765020 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.766019 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.766758 drop table if exists "person_test"; [] -gorptest: 16:57:06.767307 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.767859 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.768379 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.768871 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.769785 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.770323 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.770834 drop table if exists "time_test"; [] -gorptest: 16:57:06.771364 drop table if exists "id_created_test"; [] ---- PASS: TestRawSelect (0.02s) +2023/04/23 12:35:28 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: 12:35:28.340173 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.340720 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.340835 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.340938 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.341032 drop table if exists "person_test"; [] +gorptest: 12:35:28.341114 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.341196 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.341274 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.341354 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.341439 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.341549 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.341651 drop table if exists "time_test"; [] +gorptest: 12:35:28.341776 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.342337 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: 12:35:28.342866 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.343388 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.343974 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.344497 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.345032 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.345546 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.346065 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.346580 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.347096 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.347614 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.348154 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928348121166 2:1682202928348121166 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.348532 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] +gorptest: 12:35:28.349024 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 12:35:28.349311 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.349767 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.350203 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.350628 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.351161 drop table if exists "person_test"; [] +gorptest: 12:35:28.351609 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.352034 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.352477 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.352929 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.353352 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.353806 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.354234 drop table if exists "time_test"; [] +gorptest: 12:35:28.354667 drop table if exists "id_created_test"; [] +--- PASS: TestRawSelect (0.01s) === RUN TestHooks -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.772020 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.772790 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.772900 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.772999 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.773090 drop table if exists "person_test"; [] -gorptest: 16:57:06.773762 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.773932 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.774034 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.774129 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.774226 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.774327 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.774418 drop table if exists "time_test"; [] -gorptest: 16:57:06.774524 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.775306 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.775931 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.776549 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.777648 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.778314 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.778898 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.779500 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.780112 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.780731 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.781755 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.782459 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.783125 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613026783073540 2:1716613026783073540 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:06.783638 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:06.783983 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1716613026783073540 2:1716613026783073540 3:"preupdate" 4:"postget" 5:2 6:1 7:1] -gorptest: 16:57:06.784414 select * from person_test where id = ? [1:1] -gorptest: 16:57:06.784754 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] -gorptest: 16:57:06.785159 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.786192 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.786737 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.787265 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.787952 drop table if exists "person_test"; [] -gorptest: 16:57:06.788530 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.789049 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.790244 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.790832 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.791365 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.791892 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.792415 drop table if exists "time_test"; [] -gorptest: 16:57:06.792945 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.355127 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.355687 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.355790 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.355875 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.355959 drop table if exists "person_test"; [] +gorptest: 12:35:28.356052 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.356142 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.356228 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.356309 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.356388 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.356469 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.356547 drop table if exists "time_test"; [] +gorptest: 12:35:28.356661 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.357218 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: 12:35:28.357740 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.358246 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.358832 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.359447 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.359982 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.360533 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.361165 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.361717 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.362261 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.362791 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.363375 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928363329426 2:1682202928363329426 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.363785 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.364071 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1682202928363329426 2:1682202928363329426 3:"preupdate" 4:"postget" 5:2 6:1 7:1] +gorptest: 12:35:28.364426 select * from person_test where id = ? [1:1] +gorptest: 12:35:28.364736 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] +gorptest: 12:35:28.365095 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.365550 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.366001 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.366445 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.367005 drop table if exists "person_test"; [] +gorptest: 12:35:28.367473 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.367930 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.368379 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.368827 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.369263 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.369697 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.370140 drop table if exists "time_test"; [] +gorptest: 12:35:28.370578 drop table if exists "id_created_test"; [] --- PASS: TestHooks (0.02s) === RUN TestTransaction -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.793946 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.794767 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.794882 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.794984 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.795110 drop table if exists "person_test"; [] -gorptest: 16:57:06.795222 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.795323 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.795449 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.795550 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.795628 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.795696 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.795787 drop table if exists "time_test"; [] -gorptest: 16:57:06.795926 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.796726 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.797972 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.798661 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.799369 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.799995 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.800601 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.801730 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.802470 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.803127 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.803786 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.804425 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.805070 begin; [] -gorptest: 16:57:06.805783 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] -gorptest: 16:57:06.806225 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] -gorptest: 16:57:06.806378 commit; [] -gorptest: 16:57:06.806650 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.806992 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] -gorptest: 16:57:06.807281 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.807906 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.808467 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.809004 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.810245 drop table if exists "person_test"; [] -gorptest: 16:57:06.810816 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.811334 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.811887 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.812422 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.812954 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.813971 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.814537 drop table if exists "time_test"; [] -gorptest: 16:57:06.815059 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.371053 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.371621 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.371717 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.371820 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.371938 drop table if exists "person_test"; [] +gorptest: 12:35:28.372042 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.372140 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.372246 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.372352 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.372446 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.372550 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.372655 drop table if exists "time_test"; [] +gorptest: 12:35:28.372794 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.373374 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: 12:35:28.373902 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.374421 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.375011 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.375543 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.376047 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.376569 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.377202 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.377725 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.378243 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.378759 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.379267 begin; [] +gorptest: 12:35:28.379376 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] +gorptest: 12:35:28.379655 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] +gorptest: 12:35:28.379783 commit; [] +gorptest: 12:35:28.379977 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.380221 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] +gorptest: 12:35:28.380442 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.380912 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.381355 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.381789 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.382341 drop table if exists "person_test"; [] +gorptest: 12:35:28.382786 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.383224 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.383654 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.384136 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.384577 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.385034 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.385468 drop table if exists "time_test"; [] +gorptest: 12:35:28.385910 drop table if exists "id_created_test"; [] --- PASS: TestTransaction (0.02s) === RUN TestSavepoint -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.815668 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.816434 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.816546 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.816649 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.816755 drop table if exists "person_test"; [] -gorptest: 16:57:06.816857 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.816962 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.817069 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.817171 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.817941 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.818077 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.818184 drop table if exists "time_test"; [] -gorptest: 16:57:06.818313 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.819103 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.819746 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.820355 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.821055 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.822214 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.822847 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.823472 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.824119 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.824739 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.825840 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.826521 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.827147 begin; [] -gorptest: 16:57:06.827318 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] -gorptest: 16:57:06.827671 select memo from invoice_test [] -gorptest: 16:57:06.827867 savepoint "foo" [1:] -gorptest: 16:57:06.827918 select memo from invoice_test [] -gorptest: 16:57:06.828067 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] -gorptest: 16:57:06.828227 select memo from invoice_test [] -gorptest: 16:57:06.828356 rollback to savepoint "foo" [1:] -gorptest: 16:57:06.828434 select memo from invoice_test [] -gorptest: 16:57:06.828550 rollback; [] -gorptest: 16:57:06.828738 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.829908 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.830530 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.831098 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.831822 drop table if exists "person_test"; [] -gorptest: 16:57:06.832393 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.832968 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.833995 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.834557 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.835088 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.835618 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.836147 drop table if exists "time_test"; [] -gorptest: 16:57:06.836652 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.386355 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.386905 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.387022 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.387135 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.387232 drop table if exists "person_test"; [] +gorptest: 12:35:28.387332 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.387417 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.387497 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.387589 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.387696 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.387782 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.387864 drop table if exists "time_test"; [] +gorptest: 12:35:28.387958 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.388512 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: 12:35:28.389145 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.389680 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.390284 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.390821 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.391335 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.391864 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.392393 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.392951 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.393492 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.394016 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.394540 begin; [] +gorptest: 12:35:28.394662 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] +gorptest: 12:35:28.394928 select memo from invoice_test [] +gorptest: 12:35:28.395091 savepoint "foo" [1:] +gorptest: 12:35:28.395140 select memo from invoice_test [] +gorptest: 12:35:28.395294 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] +gorptest: 12:35:28.395446 select memo from invoice_test [] +gorptest: 12:35:28.395580 rollback to savepoint "foo" [1:] +gorptest: 12:35:28.395640 select memo from invoice_test [] +gorptest: 12:35:28.395790 rollback; [] +gorptest: 12:35:28.395943 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.396371 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.396828 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.397265 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.397809 drop table if exists "person_test"; [] +gorptest: 12:35:28.398249 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.398675 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.399108 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.399537 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.399969 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.400405 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.400869 drop table if exists "time_test"; [] +gorptest: 12:35:28.401294 drop table if exists "id_created_test"; [] --- PASS: TestSavepoint (0.02s) === RUN TestMultiple -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.838052 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.838904 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.839027 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.839137 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.839243 drop table if exists "person_test"; [] -gorptest: 16:57:06.839353 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.839463 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.839569 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.839679 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.839790 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.839919 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.840032 drop table if exists "time_test"; [] -gorptest: 16:57:06.840167 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.840973 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.842270 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.842945 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.843696 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.844357 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.844966 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.846076 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.846750 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.847381 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.848024 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.848650 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.849815 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] -gorptest: 16:57:06.850396 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] -gorptest: 16:57:06.850903 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] -gorptest: 16:57:06.851348 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] -gorptest: 16:57:06.851763 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.852139 delete from "invoice_test" where "Id"=?; [1:2] -gorptest: 16:57:06.852491 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.853089 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.854200 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.854775 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.855442 drop table if exists "person_test"; [] -gorptest: 16:57:06.855976 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.856507 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.857025 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.858094 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.858663 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.859198 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.859719 drop table if exists "time_test"; [] -gorptest: 16:57:06.860233 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.401736 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.402264 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.402359 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.402460 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.402559 drop table if exists "person_test"; [] +gorptest: 12:35:28.402648 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.402731 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.402817 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.402902 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.403013 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.403105 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.403211 drop table if exists "time_test"; [] +gorptest: 12:35:28.403324 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.403879 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: 12:35:28.404408 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.404947 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.405540 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.406063 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.406573 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.407087 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.407610 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.408135 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.408662 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.409316 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.409899 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] +gorptest: 12:35:28.410277 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] +gorptest: 12:35:28.410652 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] +gorptest: 12:35:28.410997 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] +gorptest: 12:35:28.411336 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.411647 delete from "invoice_test" where "Id"=?; [1:2] +gorptest: 12:35:28.411938 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.412385 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.412845 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.413284 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.413838 drop table if exists "person_test"; [] +gorptest: 12:35:28.414292 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.414745 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.415191 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.415647 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.416090 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.416524 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.416979 drop table if exists "time_test"; [] +gorptest: 12:35:28.417424 drop table if exists "id_created_test"; [] --- PASS: TestMultiple (0.02s) === RUN TestCrud -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.861382 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.862245 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.862363 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.862462 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.862563 drop table if exists "person_test"; [] -gorptest: 16:57:06.862669 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.862775 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.862883 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.862985 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.863113 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.863237 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.863368 drop table if exists "time_test"; [] -gorptest: 16:57:06.863511 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.864332 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.864990 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.866273 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.867022 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.867648 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.868274 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.868918 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.870064 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.870754 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.871423 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.872106 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.872790 delete from invoice_test [] -gorptest: 16:57:06.873940 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] -gorptest: 16:57:06.874523 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.874916 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] -gorptest: 16:57:06.875334 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.875602 select * from invoice_test [] -gorptest: 16:57:06.875952 delete from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.876357 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] -gorptest: 16:57:06.876590 delete from invoice_tag_test [] -gorptest: 16:57:06.876980 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] -gorptest: 16:57:06.877975 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 16:57:06.878394 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] -gorptest: 16:57:06.878858 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 16:57:06.879158 select * from invoice_tag_test [] -gorptest: 16:57:06.879508 delete from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 16:57:06.879902 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] -gorptest: 16:57:06.880129 delete from alias_trans_field_test [] -gorptest: 16:57:06.880483 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] -gorptest: 16:57:06.880918 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 16:57:06.881623 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] -gorptest: 16:57:06.882091 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 16:57:06.882329 select * from alias_trans_field_test [] -gorptest: 16:57:06.882589 delete from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 16:57:06.882987 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] -gorptest: 16:57:06.883186 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.883794 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.884374 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.884950 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.886150 drop table if exists "person_test"; [] -gorptest: 16:57:06.886753 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.887304 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.887847 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.888375 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.888914 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.889944 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.890524 drop table if exists "time_test"; [] -gorptest: 16:57:06.891063 drop table if exists "id_created_test"; [] ---- PASS: TestCrud (0.03s) +2023/04/23 12:35:28 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: 12:35:28.417873 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.418453 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.418559 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.418675 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.418777 drop table if exists "person_test"; [] +gorptest: 12:35:28.418876 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.418959 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.419027 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.419096 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.419162 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.419230 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.419297 drop table if exists "time_test"; [] +gorptest: 12:35:28.419405 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.419971 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: 12:35:28.420520 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.421138 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.421757 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.422312 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.422827 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.423374 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.423915 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.424446 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.425079 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.425624 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.426167 delete from invoice_test [] +gorptest: 12:35:28.426469 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] +gorptest: 12:35:28.426870 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.427181 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8674665223082153551 2:6129484611666145821 3:"random 5577006791947779410" 4:0 5:true 6:1] +gorptest: 12:35:28.427535 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.427779 select * from invoice_test [] +gorptest: 12:35:28.428063 delete from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.428373 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] +gorptest: 12:35:28.428572 delete from invoice_tag_test [] +gorptest: 12:35:28.428878 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: 12:35:28.429279 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 12:35:28.429551 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:3916589616287113937 2:6334824724549167320 3:"random 4037200794235010051" 4:33 5:false 6:1] +gorptest: 12:35:28.429900 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 12:35:28.430131 select * from invoice_tag_test [] +gorptest: 12:35:28.430418 delete from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 12:35:28.430720 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] +gorptest: 12:35:28.430912 delete from alias_trans_field_test [] +gorptest: 12:35:28.431168 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] +gorptest: 12:35:28.431506 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 12:35:28.431712 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 605394647632969758" 2:1] +gorptest: 12:35:28.432018 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 12:35:28.432200 select * from alias_trans_field_test [] +gorptest: 12:35:28.432423 delete from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 12:35:28.432714 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] +gorptest: 12:35:28.432897 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.433341 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.433787 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.434279 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.434823 drop table if exists "person_test"; [] +gorptest: 12:35:28.435252 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.435706 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.436145 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.436574 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.437020 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.437453 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.437879 drop table if exists "time_test"; [] +gorptest: 12:35:28.438300 drop table if exists "id_created_test"; [] +--- PASS: TestCrud (0.02s) === RUN TestWithIgnoredColumn -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.891730 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.892551 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.892673 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.892786 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.892925 drop table if exists "person_test"; [] -gorptest: 16:57:06.893044 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.893155 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.893871 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.894005 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.894114 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.894227 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.894335 drop table if exists "time_test"; [] -gorptest: 16:57:06.894493 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.895316 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.895936 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.896549 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.897794 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.898481 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.899094 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.899700 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.900333 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.900970 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.902150 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.902836 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.903525 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] -gorptest: 16:57:06.903980 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 16:57:06.904270 delete from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 16:57:06.904667 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] -gorptest: 16:57:06.904891 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.906118 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.906729 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.907272 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.907935 drop table if exists "person_test"; [] -gorptest: 16:57:06.908483 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.909055 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.910132 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.910722 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.911306 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.911898 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.912436 drop table if exists "time_test"; [] -gorptest: 16:57:06.912982 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.438714 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.439280 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.439368 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.439434 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.439495 drop table if exists "person_test"; [] +gorptest: 12:35:28.439563 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.439665 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.439744 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.439810 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.439872 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.439933 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.439997 drop table if exists "time_test"; [] +gorptest: 12:35:28.440101 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.440633 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: 12:35:28.441292 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.441796 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.442376 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.442888 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.443410 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.443909 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.444422 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.444959 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.445530 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.446073 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.446657 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] +gorptest: 12:35:28.447041 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 12:35:28.447280 delete from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 12:35:28.447627 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] +gorptest: 12:35:28.447818 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.448313 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.448787 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.449265 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.449842 drop table if exists "person_test"; [] +gorptest: 12:35:28.450308 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.450781 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.451239 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.451691 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.452147 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.452600 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.453149 drop table if exists "time_test"; [] +gorptest: 12:35:28.453611 drop table if exists "id_created_test"; [] --- PASS: TestWithIgnoredColumn (0.02s) === RUN TestTypeConversionExample -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.914036 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.914859 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.914981 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.915087 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.915189 drop table if exists "person_test"; [] -gorptest: 16:57:06.915304 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.915406 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.915508 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.915618 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.915742 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.915864 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.915971 drop table if exists "time_test"; [] -gorptest: 16:57:06.916102 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.916906 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.918117 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.918801 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.919566 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.920213 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.920817 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.921956 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.922656 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.923319 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.923947 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.924601 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.925946 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] -gorptest: 16:57:06.926513 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 16:57:06.926921 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] -gorptest: 16:57:06.927362 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] -gorptest: 16:57:06.927651 delete from "type_conv_test" where "Id"=?; [1:1] -gorptest: 16:57:06.928032 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.928594 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.929135 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.930182 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.930886 drop table if exists "person_test"; [] -gorptest: 16:57:06.931425 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.931951 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.932510 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.933114 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.934202 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.934744 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.935292 drop table if exists "time_test"; [] -gorptest: 16:57:06.935831 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.454148 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.454763 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.454857 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.454968 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.455078 drop table if exists "person_test"; [] +gorptest: 12:35:28.455167 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.455243 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.455325 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.455422 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.455523 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.455618 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.455705 drop table if exists "time_test"; [] +gorptest: 12:35:28.455800 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.456385 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: 12:35:28.456966 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.457524 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.458143 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.458684 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.459246 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.459802 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.460340 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.461014 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.461553 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.462091 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.462772 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: 12:35:28.463149 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 12:35:28.463460 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: 12:35:28.463811 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] +gorptest: 12:35:28.464081 delete from "type_conv_test" where "Id"=?; [1:1] +gorptest: 12:35:28.464402 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.464872 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.465334 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.465789 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.466374 drop table if exists "person_test"; [] +gorptest: 12:35:28.466833 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.467276 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.467713 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.468181 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.468639 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.469116 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.469566 drop table if exists "time_test"; [] +gorptest: 12:35:28.470047 drop table if exists "id_created_test"; [] --- PASS: TestTypeConversionExample (0.02s) === RUN TestWithEmbeddedStruct -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.936477 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.937323 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.937438 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.937544 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.937667 drop table if exists "person_test"; [] -gorptest: 16:57:06.937802 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.937910 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.938013 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.938111 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.938223 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.938334 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.938439 drop table if exists "time_test"; [] -gorptest: 16:57:06.938560 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.939344 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.940016 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.940674 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.942070 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.942789 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.943434 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.944082 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.944727 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.945665 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.946334 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.946966 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.947687 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] -gorptest: 16:57:06.948172 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 16:57:06.948522 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] -gorptest: 16:57:06.948937 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] -gorptest: 16:57:06.949437 select * from embedded_struct_test [] -gorptest: 16:57:06.949746 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.950343 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.950890 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.951437 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.952097 drop table if exists "person_test"; [] -gorptest: 16:57:06.952611 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.953122 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.954143 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.954681 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.955233 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.955774 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.956311 drop table if exists "time_test"; [] -gorptest: 16:57:06.956836 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.470516 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.471111 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.471212 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.471298 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.471395 drop table if exists "person_test"; [] +gorptest: 12:35:28.471491 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.471578 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.471680 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.471779 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.471860 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.471937 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.472005 drop table if exists "time_test"; [] +gorptest: 12:35:28.472086 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.472640 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: 12:35:28.473191 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.473722 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.474346 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.474876 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.475417 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.475960 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.476505 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.477219 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.477797 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.478349 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.478926 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] +gorptest: 12:35:28.479316 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 12:35:28.479606 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] +gorptest: 12:35:28.479978 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] +gorptest: 12:35:28.480205 select * from embedded_struct_test [] +gorptest: 12:35:28.480461 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.480935 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.481377 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.481830 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.482418 drop table if exists "person_test"; [] +gorptest: 12:35:28.482867 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.483333 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.483825 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.484289 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.484762 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.485212 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.485655 drop table if exists "time_test"; [] +gorptest: 12:35:28.486101 drop table if exists "id_created_test"; [] --- PASS: TestWithEmbeddedStruct (0.02s) === RUN TestWithEmbeddedStructBeforeAutoincr -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.957813 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.958611 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.958738 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.958846 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.958957 drop table if exists "person_test"; [] -gorptest: 16:57:06.959088 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.959214 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.959331 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.959453 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.959566 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.959679 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.959790 drop table if exists "time_test"; [] -gorptest: 16:57:06.959911 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.960662 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.961596 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.962246 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.962985 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.963647 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.964259 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.964898 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.965830 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.966488 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.967090 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.967686 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.968329 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] -gorptest: 16:57:06.968771 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.969565 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.970125 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.970666 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.971347 drop table if exists "person_test"; [] -gorptest: 16:57:06.971910 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.972465 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.973031 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.973865 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.974417 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.974992 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.975542 drop table if exists "time_test"; [] -gorptest: 16:57:06.976062 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedStructBeforeAutoincr (0.02s) +2023/04/23 12:35:28 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: 12:35:28.486555 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.487136 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.487233 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.487312 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.487388 drop table if exists "person_test"; [] +gorptest: 12:35:28.487491 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.487583 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.487691 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.487803 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.487904 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.487992 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.488079 drop table if exists "time_test"; [] +gorptest: 12:35:28.488174 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.488733 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: 12:35:28.489290 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.489822 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.490438 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.490975 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.491515 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.492046 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.492570 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.493099 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.493626 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.494152 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.494686 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] +gorptest: 12:35:28.495029 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.495455 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.495883 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.496305 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.497007 drop table if exists "person_test"; [] +gorptest: 12:35:28.497440 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.497874 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.498298 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.498731 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.499154 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.499592 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.500023 drop table if exists "time_test"; [] +gorptest: 12:35:28.500440 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedStructBeforeAutoincr (0.01s) === RUN TestWithEmbeddedAutoincr -2024/05/24 16:57:06 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:06.976701 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.977753 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.977877 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.977976 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.978076 drop table if exists "person_test"; [] -gorptest: 16:57:06.978182 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.978278 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.978402 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.978518 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.978620 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.978720 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.978807 drop table if exists "time_test"; [] -gorptest: 16:57:06.978928 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.980194 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:06.980906 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:06.981595 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:06.982345 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:06.983004 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.983616 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:06.984224 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:06.984839 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:06.985776 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:06.986409 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:06.987043 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:06.987760 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] -gorptest: 16:57:06.988220 drop table if exists "invoice_test"; [] -gorptest: 16:57:06.988773 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:06.989609 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:06.990171 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:06.990870 drop table if exists "person_test"; [] -gorptest: 16:57:06.991437 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:06.991982 drop table if exists "id_created_test"; [] -gorptest: 16:57:06.992512 drop table if exists "type_conv_test"; [] -gorptest: 16:57:06.993038 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:06.993994 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:06.994575 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:06.995130 drop table if exists "time_test"; [] -gorptest: 16:57:06.995664 drop table if exists "id_created_test"; [] ---- PASS: TestWithEmbeddedAutoincr (0.02s) +2023/04/23 12:35:28 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: 12:35:28.500881 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.501445 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.501539 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.501632 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.501719 drop table if exists "person_test"; [] +gorptest: 12:35:28.501795 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.501865 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.501934 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.502002 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.502070 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.502146 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.502218 drop table if exists "time_test"; [] +gorptest: 12:35:28.502301 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.502875 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: 12:35:28.503403 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.503916 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.504515 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.505067 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.505569 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.506094 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.506610 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.507124 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.507638 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.508159 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.508875 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] +gorptest: 12:35:28.509235 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.509676 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.510121 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.510562 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.511115 drop table if exists "person_test"; [] +gorptest: 12:35:28.511556 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.511995 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.512433 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.512909 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.513346 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.513790 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.514240 drop table if exists "time_test"; [] +gorptest: 12:35:28.514673 drop table if exists "id_created_test"; [] +--- PASS: TestWithEmbeddedAutoincr (0.01s) === RUN TestSelectVal -gorptest: 16:57:06.996212 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] -gorptest: 16:57:06.998466 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] -gorptest: 16:57:06.998941 select Int64 from TableWithNull where Str='abc' [] -gorptest: 16:57:06.999181 select count(*) from TableWithNull [] -gorptest: 16:57:06.999363 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 16:57:06.999571 select Int64 from TableWithNull where Str='notfound' [] -gorptest: 16:57:06.999760 select Int64 from TableWithNull where Str='abc' [] -gorptest: 16:57:06.999954 select Float64 from TableWithNull where Str='abc' [] -gorptest: 16:57:07.000148 select min(Float64) from TableWithNull [] -gorptest: 16:57:07.000351 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] -gorptest: 16:57:07.000564 select Float64 from TableWithNull where Str='notfound' [] -gorptest: 16:57:07.000748 select Float64 from TableWithNull where Str='abc' [] -gorptest: 16:57:07.000935 select Str from TableWithNull where Int64=? [1:78] -gorptest: 16:57:07.001124 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 16:57:07.001675 select Str from TableWithNull where Int64=? [1:78] -gorptest: 16:57:07.001893 select Str from TableWithNull where Str='asdfasdf' [] -gorptest: 16:57:07.002153 select Int64 from TableWithNull where Str=? [1:"abc"] -gorptest: 16:57:07.002377 select Str from TableWithNull where Int64=? [1:78] -gorptest: 16:57:07.002583 drop table if exists "TableWithNull"; [] +gorptest: 12:35:28.515070 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] +gorptest: 12:35:28.516106 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: 12:35:28.516452 select Int64 from TableWithNull where Str='abc' [] +gorptest: 12:35:28.516656 select count(*) from TableWithNull [] +gorptest: 12:35:28.516859 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 12:35:28.517060 select Int64 from TableWithNull where Str='notfound' [] +gorptest: 12:35:28.517233 select Int64 from TableWithNull where Str='abc' [] +gorptest: 12:35:28.517409 select Float64 from TableWithNull where Str='abc' [] +gorptest: 12:35:28.517584 select min(Float64) from TableWithNull [] +gorptest: 12:35:28.517788 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] +gorptest: 12:35:28.517990 select Float64 from TableWithNull where Str='notfound' [] +gorptest: 12:35:28.518166 select Float64 from TableWithNull where Str='abc' [] +gorptest: 12:35:28.518356 select Str from TableWithNull where Int64=? [1:78] +gorptest: 12:35:28.518552 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 12:35:28.518720 select Str from TableWithNull where Int64=? [1:78] +gorptest: 12:35:28.518900 select Str from TableWithNull where Str='asdfasdf' [] +gorptest: 12:35:28.519128 select Int64 from TableWithNull where Str=? [1:"abc"] +gorptest: 12:35:28.519346 select Str from TableWithNull where Int64=? [1:78] +gorptest: 12:35:28.519542 drop table if exists "TableWithNull"; [] --- PASS: TestSelectVal (0.01s) === RUN TestVersionMultipleRows -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.003692 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.004468 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.004580 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.004676 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.004773 drop table if exists "person_test"; [] -gorptest: 16:57:07.004877 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.004980 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.005080 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.005533 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.005693 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.005835 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.005973 drop table if exists "time_test"; [] -gorptest: 16:57:07.006156 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.006995 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.007655 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.008308 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.009044 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.010249 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.010882 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.011506 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.012153 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.012792 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.013820 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.014493 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.015210 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027015156040 2:1716613027015156040 3:"Bob" 4:"Smith" 5:1] -gorptest: 16:57:07.015704 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027015676020 2:1716613027015676020 3:"Jane" 4:"Smith" 5:1] -gorptest: 16:57:07.016162 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027016132860 2:1716613027016132860 3:"Mike" 4:"Smith" 5:1] -gorptest: 16:57:07.016607 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.017644 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.018263 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.018800 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.019468 drop table if exists "person_test"; [] -gorptest: 16:57:07.020047 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.020588 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.021105 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.022021 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.022572 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.023118 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.023691 drop table if exists "time_test"; [] -gorptest: 16:57:07.024231 drop table if exists "id_created_test"; [] ---- PASS: TestVersionMultipleRows (0.02s) +2023/04/23 12:35:28 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: 12:35:28.520298 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.520863 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.520958 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.521043 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.521121 drop table if exists "person_test"; [] +gorptest: 12:35:28.521212 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.521326 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.521415 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.521502 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.521581 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.521661 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.521739 drop table if exists "time_test"; [] +gorptest: 12:35:28.521832 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.522382 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: 12:35:28.522936 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.523452 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.524060 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.524588 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.525122 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.525657 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.526173 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.526689 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.527209 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.527732 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.528287 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928528234993 2:1682202928528234993 3:"Bob" 4:"Smith" 5:1] +gorptest: 12:35:28.528660 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928528637016 2:1682202928528637016 3:"Jane" 4:"Smith" 5:1] +gorptest: 12:35:28.529167 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928529142161 2:1682202928529142161 3:"Mike" 4:"Smith" 5:1] +gorptest: 12:35:28.529513 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.529953 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.530390 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.530831 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.531376 drop table if exists "person_test"; [] +gorptest: 12:35:28.531831 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.532262 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.532686 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.533130 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.533608 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.534036 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.534462 drop table if exists "time_test"; [] +gorptest: 12:35:28.534882 drop table if exists "id_created_test"; [] +--- PASS: TestVersionMultipleRows (0.01s) === RUN TestWithStringPk -gorptest: 16:57:07.024721 create table string_pk_test (Id varchar(255), Name varchar(255)); [] -gorptest: 16:57:07.026603 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] -gorptest: 16:57:07.027032 drop table if exists "string_pk_test"; [] +gorptest: 12:35:28.535250 create table string_pk_test (Id varchar(255), Name varchar(255)); [] +gorptest: 12:35:28.536215 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] +gorptest: 12:35:28.536511 drop table if exists "string_pk_test"; [] --- PASS: TestWithStringPk (0.00s) === RUN TestSqlExecutorInterfaceSelects --- PASS: TestSqlExecutorInterfaceSelects (0.00s) === RUN TestWithTimeSelect -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.028438 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.029628 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.029790 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.029910 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.030017 drop table if exists "person_test"; [] -gorptest: 16:57:07.030127 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.030235 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.030345 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.030467 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.030592 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.030708 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.030802 drop table if exists "time_test"; [] -gorptest: 16:57:07.030926 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.031757 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.032418 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.033067 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.034272 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.034926 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.035518 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.036116 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.036714 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.037680 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.038368 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.038994 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.039666 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-25 04:26:07.03959858 +0000 UTC] -gorptest: 16:57:07.040114 insert into "time_test" ("Id","Time") values (null,?); [1:2024-05-25 04:27:08.03959858 +0000 UTC] -gorptest: 16:57:07.040527 SELECT id FROM time_test WHERE Time < ? [1:2024-05-25 04:27:07.03959858 +0000 UTC] -gorptest: 16:57:07.040815 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.041729 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.042280 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.042804 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.043464 drop table if exists "person_test"; [] -gorptest: 16:57:07.044044 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.044567 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.045098 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.046095 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.046663 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.047206 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.047762 drop table if exists "time_test"; [] -gorptest: 16:57:07.048323 drop table if exists "id_created_test"; [] ---- PASS: TestWithTimeSelect (0.02s) +2023/04/23 12:35:28 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: 12:35:28.537624 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.538154 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.538263 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.538344 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.538421 drop table if exists "person_test"; [] +gorptest: 12:35:28.538494 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.538564 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.538658 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.538760 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.538839 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.538913 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.538984 drop table if exists "time_test"; [] +gorptest: 12:35:28.539068 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.539614 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: 12:35:28.540148 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.540663 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.541274 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.541801 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.542318 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.542833 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.543361 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.543870 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.544382 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.545014 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.545561 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-22 22:04:28.545518553 +0000 UTC] +gorptest: 12:35:28.545929 insert into "time_test" ("Id","Time") values (null,?); [1:2023-04-22 22:05:29.545518553 +0000 UTC] +gorptest: 12:35:28.546278 SELECT id FROM time_test WHERE Time < ? [1:2023-04-22 22:05:28.545518553 +0000 UTC] +gorptest: 12:35:28.546510 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.546934 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.547366 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.547794 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.548332 drop table if exists "person_test"; [] +gorptest: 12:35:28.548795 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.549226 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.549652 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.550088 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.550513 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.550947 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.551372 drop table if exists "time_test"; [] +gorptest: 12:35:28.551814 drop table if exists "id_created_test"; [] +--- PASS: TestWithTimeSelect (0.01s) === RUN TestInvoicePersonView -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.048953 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.050176 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.050312 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.050412 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.050507 drop table if exists "person_test"; [] -gorptest: 16:57:07.050598 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.050693 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.050794 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.050904 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.051003 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.051107 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.051230 drop table if exists "time_test"; [] -gorptest: 16:57:07.051381 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.052162 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.052872 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.053892 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.054682 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.055317 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.055935 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.056561 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.057983 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.058820 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.059483 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.060130 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.060814 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027060752160 2:1716613027060752160 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:07.061733 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] -gorptest: 16:57:07.062256 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] -gorptest: 16:57:07.062710 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.063360 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.063938 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.064496 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.065173 drop table if exists "person_test"; [] -gorptest: 16:57:07.065894 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.066472 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.067023 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.067599 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.068204 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.068761 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.069803 drop table if exists "time_test"; [] -gorptest: 16:57:07.070431 drop table if exists "id_created_test"; [] ---- PASS: TestInvoicePersonView (0.02s) +2023/04/23 12:35:28 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: 12:35:28.552244 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.552817 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.552915 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.552993 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.553068 drop table if exists "person_test"; [] +gorptest: 12:35:28.553138 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.553208 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.553277 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.553352 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.553435 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.553568 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.553648 drop table if exists "time_test"; [] +gorptest: 12:35:28.553749 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.554309 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: 12:35:28.554851 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.555372 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.555970 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.556501 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.557028 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.557547 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.558055 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.558567 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.559087 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.559621 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.560162 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928560127888 2:1682202928560127888 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.560552 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] +gorptest: 12:35:28.561053 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] +gorptest: 12:35:28.561345 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.561787 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.562222 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.562646 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.563198 drop table if exists "person_test"; [] +gorptest: 12:35:28.563642 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.564072 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.564496 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.564943 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.565372 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.565793 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.566221 drop table if exists "time_test"; [] +gorptest: 12:35:28.566640 drop table if exists "id_created_test"; [] +--- PASS: TestInvoicePersonView (0.01s) === RUN TestQuoteTableNames -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.071065 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.071898 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.072031 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.072177 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.072301 drop table if exists "person_test"; [] -gorptest: 16:57:07.072408 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.072504 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.072596 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.072686 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.072775 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.072871 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.072961 drop table if exists "time_test"; [] -gorptest: 16:57:07.073074 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.074267 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.074934 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.075534 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.076235 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.076855 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.077813 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.078439 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.079063 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.079680 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.080295 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.080926 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] ---- PASS: TestQuoteTableNames (0.02s) +2023/04/23 12:35:28 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: 12:35:28.567085 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.567664 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.567764 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.567849 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.567930 drop table if exists "person_test"; [] +gorptest: 12:35:28.568006 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.568109 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.568199 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.568274 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.568346 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.568416 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.568485 drop table if exists "time_test"; [] +gorptest: 12:35:28.568587 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.569162 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: 12:35:28.569685 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.570189 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.570775 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.571294 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.571792 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.572303 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.572837 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.573353 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.573868 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.574398 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +--- PASS: TestQuoteTableNames (0.01s) === RUN TestSelectTooManyCols -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.089613 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.090364 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.090495 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.090600 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.090694 drop table if exists "person_test"; [] -gorptest: 16:57:07.090787 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.090868 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.090952 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.091046 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.091146 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.091262 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.091360 drop table if exists "time_test"; [] -gorptest: 16:57:07.091494 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.092222 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.092865 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.094026 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.094797 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.095421 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.096031 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.096677 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.097676 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.098356 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.098978 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.099616 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.100291 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027100236000 2:1716613027100236000 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:07.100765 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027100737740 2:1716613027100737740 3:"jane" 4:"doe" 5:1] -gorptest: 16:57:07.101873 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:07.102239 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] -gorptest: 16:57:07.102518 select * from person_test where Id=? [1:1] -gorptest: 16:57:07.102822 select * from person_test order by fname asc [] -gorptest: 16:57:07.103166 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.103761 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.104294 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.104830 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.105910 drop table if exists "person_test"; [] -gorptest: 16:57:07.106533 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.107072 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.107614 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.108175 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.108732 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.109761 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.110404 drop table if exists "time_test"; [] -gorptest: 16:57:07.110959 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.581224 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.581788 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.581880 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.581981 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.582078 drop table if exists "person_test"; [] +gorptest: 12:35:28.582179 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.582276 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.582377 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.582475 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.582574 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.582676 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.582787 drop table if exists "time_test"; [] +gorptest: 12:35:28.582917 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.583488 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: 12:35:28.584016 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.584544 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.585160 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.585689 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.586197 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.586707 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.587231 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.587759 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.588281 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.588834 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.589385 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928589350998 2:1682202928589350998 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.589777 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928589739862 2:1682202928589739862 3:"jane" 4:"doe" 5:1] +gorptest: 12:35:28.590145 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.590400 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] +gorptest: 12:35:28.590647 select * from person_test where Id=? [1:1] +gorptest: 12:35:28.590911 select * from person_test order by fname asc [] +gorptest: 12:35:28.591228 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.591669 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.592112 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.592553 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.593233 drop table if exists "person_test"; [] +gorptest: 12:35:28.593714 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.594154 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.594597 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.595030 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.595469 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.595916 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.596347 drop table if exists "time_test"; [] +gorptest: 12:35:28.596803 drop table if exists "id_created_test"; [] --- PASS: TestSelectTooManyCols (0.02s) === RUN TestSelectSingleVal -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.111587 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.112415 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.112540 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.112663 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.112789 drop table if exists "person_test"; [] -gorptest: 16:57:07.112929 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.113050 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.113163 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.113728 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.113870 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.114004 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.114116 drop table if exists "time_test"; [] -gorptest: 16:57:07.114244 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.115059 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.115723 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.116374 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.117119 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.118228 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.118873 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.119452 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.120023 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.120593 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.121179 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.122124 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.122773 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027122697460 2:1716613027122697460 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:07.123231 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] -gorptest: 16:57:07.123555 select * from person_test where Id=? [1:1] -gorptest: 16:57:07.123875 select FName from person_test where Id=? [1:1] -gorptest: 16:57:07.124087 select * from person_test where Id=? [1:1] -gorptest: 16:57:07.124359 select * from person_test where 2<1 AND Id=? [1:1] -gorptest: 16:57:07.124622 select * from person_test where Id=? [1:-2222] -gorptest: 16:57:07.124901 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1716613027124867500 2:1716613027124867500 3:"bob" 4:"smith" 5:1] -gorptest: 16:57:07.125875 select * from person_test where Fname='bob' [] -gorptest: 16:57:07.126306 select * from person_test where Id=-123 [] -gorptest: 16:57:07.126519 select * from person_test where Id=-123 [] -gorptest: 16:57:07.126720 select * from person_test where Id=-123 [] -gorptest: 16:57:07.126900 select * from person_test where Id=-123 [] -gorptest: 16:57:07.127090 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.127705 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.128247 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.128789 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.129776 drop table if exists "person_test"; [] -gorptest: 16:57:07.130360 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.130884 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.131397 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.131898 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.132400 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.132900 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.133739 drop table if exists "time_test"; [] -gorptest: 16:57:07.134269 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.597249 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.597807 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.597907 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.598013 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.598109 drop table if exists "person_test"; [] +gorptest: 12:35:28.598209 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.598305 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.598403 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.598503 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.598624 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.598721 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.598822 drop table if exists "time_test"; [] +gorptest: 12:35:28.598939 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.599488 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: 12:35:28.600015 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.600531 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.601143 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.601665 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.602172 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.602681 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.603201 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.603776 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.604319 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.604984 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.605543 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928605508028 2:1682202928605508028 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.605915 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] +gorptest: 12:35:28.606172 select * from person_test where Id=? [1:1] +gorptest: 12:35:28.606461 select FName from person_test where Id=? [1:1] +gorptest: 12:35:28.606650 select * from person_test where Id=? [1:1] +gorptest: 12:35:28.606935 select * from person_test where 2<1 AND Id=? [1:1] +gorptest: 12:35:28.607193 select * from person_test where Id=? [1:-2222] +gorptest: 12:35:28.607451 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1682202928607419966 2:1682202928607419966 3:"bob" 4:"smith" 5:1] +gorptest: 12:35:28.607815 select * from person_test where Fname='bob' [] +gorptest: 12:35:28.608107 select * from person_test where Id=-123 [] +gorptest: 12:35:28.608299 select * from person_test where Id=-123 [] +gorptest: 12:35:28.608501 select * from person_test where Id=-123 [] +gorptest: 12:35:28.608683 select * from person_test where Id=-123 [] +gorptest: 12:35:28.608882 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.609325 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.609765 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.610206 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.610761 drop table if exists "person_test"; [] +gorptest: 12:35:28.611219 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.611661 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.612098 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.612531 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.612998 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.613445 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.613875 drop table if exists "time_test"; [] +gorptest: 12:35:28.614319 drop table if exists "id_created_test"; [] --- PASS: TestSelectSingleVal (0.02s) === RUN TestSelectAlias -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.134899 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.135700 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.135808 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.135891 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.135973 drop table if exists "person_test"; [] -gorptest: 16:57:07.136071 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.136180 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.136285 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.136384 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.136476 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.136577 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.136683 drop table if exists "time_test"; [] -gorptest: 16:57:07.136822 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.137970 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.138660 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.139283 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.140015 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.140663 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.141698 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.142360 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.142990 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.143599 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.144228 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.144832 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.146195 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] -gorptest: 16:57:07.146683 select * from id_created_test where Id=1 [] -gorptest: 16:57:07.147025 SELECT *, 1 AS external FROM id_created_test [] -gorptest: 16:57:07.147384 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.148899 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.149806 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.150380 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.151065 drop table if exists "person_test"; [] -gorptest: 16:57:07.151606 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.152155 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.152722 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.153633 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.154238 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.154755 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.155276 drop table if exists "time_test"; [] -gorptest: 16:57:07.155820 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.614820 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.615411 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.615521 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.615623 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.615715 drop table if exists "person_test"; [] +gorptest: 12:35:28.615809 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.615902 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.615997 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.616089 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.616181 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.616277 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.616383 drop table if exists "time_test"; [] +gorptest: 12:35:28.616501 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.617170 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: 12:35:28.617728 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.618258 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.618873 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.619415 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.619935 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.620462 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.621023 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.621552 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.622091 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.622635 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.623178 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] +gorptest: 12:35:28.623517 select * from id_created_test where Id=1 [] +gorptest: 12:35:28.623781 SELECT *, 1 AS external FROM id_created_test [] +gorptest: 12:35:28.624075 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.625288 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.625739 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.626184 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.626752 drop table if exists "person_test"; [] +gorptest: 12:35:28.627197 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.627650 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.628113 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.628608 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.629067 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.629514 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.629969 drop table if exists "time_test"; [] +gorptest: 12:35:28.630417 drop table if exists "id_created_test"; [] --- PASS: TestSelectAlias (0.02s) === RUN TestMysqlPanicIfDialectNotInitialized --- PASS: TestMysqlPanicIfDialectNotInitialized (0.00s) === RUN TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.156537 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.157791 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.157935 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.158056 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.158177 drop table if exists "person_test"; [] -gorptest: 16:57:07.158273 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.158385 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.158495 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.158589 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.158686 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.158794 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.158920 drop table if exists "time_test"; [] -gorptest: 16:57:07.159078 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.159918 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.160590 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.161653 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.162450 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.163116 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.163741 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.164373 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.165008 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.166216 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.166987 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.167641 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.168270 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.168829 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.169730 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.170284 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.170957 drop table if exists "person_test"; [] -gorptest: 16:57:07.171485 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.172065 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.172636 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.173153 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.174064 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.174564 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.175046 drop table if exists "time_test"; [] -gorptest: 16:57:07.175510 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.175628 drop table if exists "single_column_table"; [] -gorptest: 16:57:07.175732 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.176385 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.176999 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.178074 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.178802 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.179403 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.179971 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.180607 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.181693 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.182389 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.183020 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.183626 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.184214 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] -gorptest: 16:57:07.184368 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] -gorptest: 16:57:07.185012 delete from "invoice_test"; [] -gorptest: 16:57:07.185736 delete from "invoice_tag_test"; [] -gorptest: 16:57:07.186083 delete from "alias_trans_field_test"; [] -gorptest: 16:57:07.186409 delete from "invoice_override_test"; [] -gorptest: 16:57:07.186745 delete from "person_test"; [] -gorptest: 16:57:07.187062 delete from "ignored_column_test"; [] -gorptest: 16:57:07.187355 delete from "id_created_test"; [] -gorptest: 16:57:07.187635 delete from "type_conv_test"; [] -gorptest: 16:57:07.187916 delete from "embedded_struct_test"; [] -gorptest: 16:57:07.188214 delete from "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.188506 delete from "embedded_autoincr_test"; [] -gorptest: 16:57:07.188801 delete from "time_test"; [] -gorptest: 16:57:07.189116 delete from "id_created_test"; [] -gorptest: 16:57:07.189782 delete from "single_column_table"; [] -gorptest: 16:57:07.190188 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] -gorptest: 16:57:07.190470 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.191020 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.191528 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.192015 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.192634 drop table if exists "person_test"; [] -gorptest: 16:57:07.193161 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.194030 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.194567 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.195052 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.195538 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.196033 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.196505 drop table if exists "time_test"; [] -gorptest: 16:57:07.196977 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.197088 drop table if exists "single_column_table"; [] ---- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.04s) +2023/04/23 12:35:28 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: 12:35:28.631008 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.631551 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.631641 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.631720 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.631792 drop table if exists "person_test"; [] +gorptest: 12:35:28.631872 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.631951 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.632026 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.632101 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.632192 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.632295 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.632379 drop table if exists "time_test"; [] +gorptest: 12:35:28.632485 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.633121 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: 12:35:28.633645 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.634155 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.634737 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.635265 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.635767 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.636284 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.636823 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.637336 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.637859 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.638386 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.638896 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.639334 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.639765 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.640189 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.640735 drop table if exists "person_test"; [] +gorptest: 12:35:28.641246 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.641685 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.642108 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.642547 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.642985 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.643408 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.643827 drop table if exists "time_test"; [] +gorptest: 12:35:28.644245 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.644352 drop table if exists "single_column_table"; [] +gorptest: 12:35:28.644462 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: 12:35:28.645027 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: 12:35:28.645561 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.646071 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: 12:35:28.646657 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: 12:35:28.647183 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.647679 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.648188 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.648700 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.649281 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.649801 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: 12:35:28.650316 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.650816 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] +gorptest: 12:35:28.650937 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] +gorptest: 12:35:28.651458 delete from "invoice_test"; [] +gorptest: 12:35:28.651725 delete from "invoice_tag_test"; [] +gorptest: 12:35:28.651978 delete from "alias_trans_field_test"; [] +gorptest: 12:35:28.652234 delete from "invoice_override_test"; [] +gorptest: 12:35:28.652508 delete from "person_test"; [] +gorptest: 12:35:28.652784 delete from "ignored_column_test"; [] +gorptest: 12:35:28.653051 delete from "id_created_test"; [] +gorptest: 12:35:28.653347 delete from "type_conv_test"; [] +gorptest: 12:35:28.653606 delete from "embedded_struct_test"; [] +gorptest: 12:35:28.653866 delete from "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.654126 delete from "embedded_autoincr_test"; [] +gorptest: 12:35:28.654407 delete from "time_test"; [] +gorptest: 12:35:28.654664 delete from "id_created_test"; [] +gorptest: 12:35:28.654909 delete from "single_column_table"; [] +gorptest: 12:35:28.655196 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] +gorptest: 12:35:28.655395 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.655816 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.656247 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.656672 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.657251 drop table if exists "person_test"; [] +gorptest: 12:35:28.657678 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.658112 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.658540 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.658966 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.659396 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.659837 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.660265 drop table if exists "time_test"; [] +gorptest: 12:35:28.660686 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.660814 drop table if exists "single_column_table"; [] +--- PASS: TestSingleColumnKeyDbReturnsZeroRowsUpdatedOnPKChange (0.03s) === RUN TestPrepare -2024/05/24 16:57:07 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 -gorptest: 16:57:07.198574 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.199295 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.199389 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.199462 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.199529 drop table if exists "person_test"; [] -gorptest: 16:57:07.199593 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.199674 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.199760 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.199834 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.199918 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.200035 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.200114 drop table if exists "time_test"; [] -gorptest: 16:57:07.200209 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.200952 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] -gorptest: 16:57:07.201669 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] -gorptest: 16:57:07.202325 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] -gorptest: 16:57:07.203085 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] -gorptest: 16:57:07.203779 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.204394 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] -gorptest: 16:57:07.205039 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] -gorptest: 16:57:07.206406 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] -gorptest: 16:57:07.207066 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] -gorptest: 16:57:07.207692 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] -gorptest: 16:57:07.208315 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] -gorptest: 16:57:07.209049 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] -gorptest: 16:57:07.209587 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] -gorptest: 16:57:07.210027 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] -gorptest: 16:57:07.210475 SELECT * from invoice_test WHERE Memo='prepare-baz' [] -gorptest: 16:57:07.210912 begin; [] -gorptest: 16:57:07.211026 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] -gorptest: 16:57:07.211345 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 16:57:07.212452 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 16:57:07.212744 commit; [] -gorptest: 16:57:07.212992 SELECT * from invoice_test WHERE IsPaid=? [1:true] -gorptest: 16:57:07.213776 drop table if exists "invoice_test"; [] -gorptest: 16:57:07.214559 drop table if exists "invoice_tag_test"; [] -gorptest: 16:57:07.215137 drop table if exists "alias_trans_field_test"; [] -gorptest: 16:57:07.215649 drop table if exists "invoice_override_test"; [] -gorptest: 16:57:07.216319 drop table if exists "person_test"; [] -gorptest: 16:57:07.216848 drop table if exists "ignored_column_test"; [] -gorptest: 16:57:07.217403 drop table if exists "id_created_test"; [] -gorptest: 16:57:07.217919 drop table if exists "type_conv_test"; [] -gorptest: 16:57:07.218405 drop table if exists "embedded_struct_test"; [] -gorptest: 16:57:07.218926 drop table if exists "embedded_struct_before_autoincr_test"; [] -gorptest: 16:57:07.219467 drop table if exists "embedded_autoincr_test"; [] -gorptest: 16:57:07.219979 drop table if exists "time_test"; [] -gorptest: 16:57:07.220481 drop table if exists "id_created_test"; [] +2023/04/23 12:35:28 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: 12:35:28.661671 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.662227 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.662314 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.662379 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.662443 drop table if exists "person_test"; [] +gorptest: 12:35:28.662503 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.662564 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.662623 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.662681 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.662740 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.662801 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.662865 drop table if exists "time_test"; [] +gorptest: 12:35:28.662956 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.663511 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: 12:35:28.664029 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] +gorptest: 12:35:28.664535 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] +gorptest: 12:35:28.665201 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] +gorptest: 12:35:28.665723 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.666216 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] +gorptest: 12:35:28.666729 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] +gorptest: 12:35:28.667236 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] +gorptest: 12:35:28.667744 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] +gorptest: 12:35:28.668278 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] +gorptest: 12:35:28.668817 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] +gorptest: 12:35:28.669356 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] +gorptest: 12:35:28.669747 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] +gorptest: 12:35:28.670089 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] +gorptest: 12:35:28.670424 SELECT * from invoice_test WHERE Memo='prepare-baz' [] +gorptest: 12:35:28.670739 begin; [] +gorptest: 12:35:28.670815 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] +gorptest: 12:35:28.671037 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 12:35:28.671839 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 12:35:28.672090 commit; [] +gorptest: 12:35:28.672274 SELECT * from invoice_test WHERE IsPaid=? [1:true] +gorptest: 12:35:28.672552 drop table if exists "invoice_test"; [] +gorptest: 12:35:28.673110 drop table if exists "invoice_tag_test"; [] +gorptest: 12:35:28.673541 drop table if exists "alias_trans_field_test"; [] +gorptest: 12:35:28.673971 drop table if exists "invoice_override_test"; [] +gorptest: 12:35:28.674523 drop table if exists "person_test"; [] +gorptest: 12:35:28.674959 drop table if exists "ignored_column_test"; [] +gorptest: 12:35:28.675382 drop table if exists "id_created_test"; [] +gorptest: 12:35:28.675806 drop table if exists "type_conv_test"; [] +gorptest: 12:35:28.676237 drop table if exists "embedded_struct_test"; [] +gorptest: 12:35:28.676659 drop table if exists "embedded_struct_before_autoincr_test"; [] +gorptest: 12:35:28.677106 drop table if exists "embedded_autoincr_test"; [] +gorptest: 12:35:28.677539 drop table if exists "time_test"; [] +gorptest: 12:35:28.677951 drop table if exists "id_created_test"; [] --- PASS: TestPrepare (0.02s) PASS -ok gopkg.in/gorp.v1 0.617s +ok gopkg.in/gorp.v1 0.440s create-stamp debian/debhelper-build-stamp dh_testroot -O--builddirectory=_build -O--buildsystem=golang dh_prep -O--builddirectory=_build -O--buildsystem=golang @@ -1807,12 +1848,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/14986/tmp/hooks/B01_cleanup starting +I: user script /srv/workspace/pbuilder/14986/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/27821 and its subdirectories -I: Current time: Fri May 24 16:57:16 -12 2024 -I: pbuilder-time-stamp: 1716613036 +I: removing directory /srv/workspace/pbuilder/14986 and its subdirectories +I: Current time: Sun Apr 23 12:35:35 +14 2023 +I: pbuilder-time-stamp: 1682202935