Mock Version: 3.5 Mock Version: 3.5 Mock Version: 3.5 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target riscv64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'], chrootPath='/var/lib/mock/f38-build-side-42-init-devel-838820-28407/root'env={'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'}shell=Falselogger=timeout=864000uid=996gid=135user='mockbuild'nspawn_args=[]unshare_net=TrueprintOutput=False) Executing command: ['bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target riscv64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'] with env {'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'} and shell False Building target platforms: riscv64 Building for target riscv64 setting SOURCE_DATE_EPOCH=1674086400 Wrote: /builddir/build/SRPMS/golang-gopkg-gorp-1-1.7.2-5.fc38.src.rpm Child return code was: 0 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target riscv64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'], chrootPath='/var/lib/mock/f38-build-side-42-init-devel-838820-28407/root'env={'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'}shell=Falselogger=timeout=864000uid=996gid=135user='mockbuild'nspawn_args=[]unshare_net=TrueprintOutput=False) Executing command: ['bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target riscv64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'] with env {'TERM': 'vt100', 'SHELL': '/bin/bash', 'HOME': '/builddir', 'HOSTNAME': 'mock', 'PATH': '/usr/bin:/bin:/usr/sbin:/sbin', 'PROMPT_COMMAND': 'printf "\\033]0;\\007"', 'PS1': ' \\s-\\v\\$ ', 'LANG': 'C.UTF-8'} and shell False Building target platforms: riscv64 Building for target riscv64 setting SOURCE_DATE_EPOCH=1674086400 Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.T0D1Kk + umask 022 + cd /builddir/build/BUILD + cd /builddir/build/BUILD + rm -rf gorp-1.7.2 + /usr/lib/rpm/rpmuncompress -x /builddir/build/SOURCES/gorp-1.7.2.tar.gz + STATUS=0 + '[' 0 -ne 0 ']' + cd gorp-1.7.2 + /usr/bin/chmod -Rf a+rX,u+w,g-w,o-w . + rm -fr /builddir/build/BUILD/gorp-1.7.2/vendor + [[ ! -e /builddir/build/BUILD/gorp-1.7.2/_build/bin ]] + install -m 0755 -vd /builddir/build/BUILD/gorp-1.7.2/_build/bin install: creating directory '/builddir/build/BUILD/gorp-1.7.2/_build' install: creating directory '/builddir/build/BUILD/gorp-1.7.2/_build/bin' + export GOPATH=/builddir/build/BUILD/gorp-1.7.2/_build:/usr/share/gocode + GOPATH=/builddir/build/BUILD/gorp-1.7.2/_build:/usr/share/gocode + [[ ! -e /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 ]] ++ dirname /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + install -m 0755 -vd /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in install: creating directory '/builddir/build/BUILD/gorp-1.7.2/_build/src' install: creating directory '/builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in' + ln -fs /builddir/build/BUILD/gorp-1.7.2 /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + cd /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + /usr/lib/rpm/rpmuncompress /builddir/build/SOURCES/gorp-1-fix-format-string.patch + /usr/bin/patch -p1 -s --fuzz=0 --no-backup-if-mismatch -f + RPM_EC=0 ++ jobs -p + exit 0 Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.OBQadL + umask 022 + cd /builddir/build/BUILD + '[' /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 '!=' / ']' + rm -rf /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 ++ dirname /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 + mkdir -p /builddir/build/BUILDROOT + mkdir /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 + cd gorp-1.7.2 + cd /builddir/build/BUILD/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + IFS= + gosupfiles= + mapfile -t gosupfilesA + go-rpm-integration install -i gopkg.in/gorp.v1 -b /builddir/build/BUILD/gorp-1.7.2/_build/bin -s /builddir/build/BUILD/gorp-1.7.2/_build -o golang-gopkg-gorp-1-devel.file-list -O /builddir/build/BUILD/gorp-1.7.2 -V 1.7.2-5.fc38 -p /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 -g /usr/share/gocode -r '.*example.*' Installing: gopkg.in/gorp.v1 realpath: go.mod: No such file or directory + IFS= +++ realpath -e --relative-base=. CONTRIBUTING.md README.md +++ sort -u realpath: CONTRIBUTING.md: No such file or directory ++ listfiles_include=README.md ++ echo README.md + godocs=README.md + [[ -n README.md ]] + IFS= + read -r f + echo %doc '"README.md"' + IFS= + read -r f + IFS= +++ realpath -e --relative-base=. LICENSE +++ sort -u ++ listfiles_include=LICENSE ++ echo LICENSE + golicenses=LICENSE + [[ -n LICENSE ]] + IFS= + read -r f + echo %license '"LICENSE"' + IFS= + read -r f + install -m 0755 -d /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/gocode/src/github.com/go-gorp/gorp + ln -rs /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/gocode/src/gopkg.in/gorp.v1 /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/gocode/src/github.com/go-gorp/gorp/v1 + echo /usr/share/gocode/src/github.com/go-gorp/gorp/v1 + echo '%dir "/usr/share/gocode/src/github.com/go-gorp/gorp"' + echo '%dir "/usr/share/gocode/src/github.com/go-gorp"' + echo '%dir "/usr/share/gocode/src/github.com"' + /usr/lib/rpm/check-buildroot + /usr/lib/rpm/redhat/brp-ldconfig + /usr/lib/rpm/brp-compress + /usr/lib/rpm/brp-strip /usr/bin/strip + /usr/lib/rpm/brp-strip-comment-note /usr/bin/strip /usr/bin/objdump + /usr/lib/rpm/redhat/brp-strip-lto /usr/bin/strip + /usr/lib/rpm/brp-strip-static-archive /usr/bin/strip + /usr/lib/rpm/check-rpaths + /usr/lib/rpm/redhat/brp-mangle-shebangs + /usr/lib/rpm/brp-remove-la-files + env /usr/lib/rpm/redhat/brp-python-bytecompile '' 1 0 -j8 + /usr/lib/rpm/redhat/brp-python-hardlink Executing(%check): /bin/sh -e /var/tmp/rpm-tmp.u5qyk5 + umask 022 + cd /builddir/build/BUILD + cd gorp-1.7.2 + export GORP_TEST_DSN=gorptest.bin + GORP_TEST_DSN=gorptest.bin + export GORP_TEST_DIALECT=sqlite + GORP_TEST_DIALECT=sqlite + LDFLAGS=' -X gopkg.in/gorp.v1/version=1.7.2' + GO_TEST_FLAGS='-buildmode pie -compiler gc' + GO_TEST_EXT_LD_FLAGS='-Wl,-z,relro -Wl,--as-needed -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -Wl,--build-id=sha1 -specs=/usr/lib/rpm/redhat/redhat-package-notes ' + go-rpm-integration check -i gopkg.in/gorp.v1 -b /builddir/build/BUILD/gorp-1.7.2/_build/bin -s /builddir/build/BUILD/gorp-1.7.2/_build -V 1.7.2-5.fc38 -p /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 -g /usr/share/gocode -r '.*example.*' Testing in: /builddir/build/BUILD/gorp-1.7.2/_build/src PATH: /builddir/build/BUILD/gorp-1.7.2/_build/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/sbin GOPATH: /builddir/build/BUILD/gorp-1.7.2/_build:/usr/share/gocode GO111MODULE: off command: go test -buildmode pie -compiler gc -ldflags " -X gopkg.in/gorp.v1/version=1.7.2 -extldflags '-Wl,-z,relro -Wl,--as-needed -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -Wl,--build-id=sha1 -specs=/usr/lib/rpm/redhat/redhat-package-notes '" testing: gopkg.in/gorp.v1 gopkg.in/gorp.v1 2023/06/26 09:32:47 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:47.962912 drop table if exists "invoice_test"; [] gorptest: 09:32:48.102142 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:48.106776 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:48.108410 drop table if exists "invoice_override_test"; [] gorptest: 09:32:48.109862 drop table if exists "person_test"; [] gorptest: 09:32:48.111353 drop table if exists "ignored_column_test"; [] gorptest: 09:32:48.112942 drop table if exists "id_created_test"; [] gorptest: 09:32:48.114499 drop table if exists "type_conv_test"; [] gorptest: 09:32:48.115884 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:48.117909 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:48.133988 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:48.137746 drop table if exists "time_test"; [] gorptest: 09:32:48.142869 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:48.279883 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:48.371573 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:48.423818 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:48.468109 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:48.509446 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:48.538757 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:48.574875 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:48.608726 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:48.638823 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:48.669790 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:48.719142 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:48.777866 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:48.782147 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:48.785207 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:48.789130 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:48.793358 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:48.795894 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:48.798094 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:48.800625 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:48.803837 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:48.805989 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:48.808772 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:48.810901 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:48.814508 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:32:48.816764 drop table if exists "invoice_test"; [] gorptest: 09:32:48.855100 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:48.883084 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:48.914781 drop table if exists "invoice_override_test"; [] gorptest: 09:32:48.943797 drop table if exists "person_test"; [] gorptest: 09:32:48.967918 drop table if exists "ignored_column_test"; [] gorptest: 09:32:48.995078 drop table if exists "id_created_test"; [] gorptest: 09:32:49.017990 drop table if exists "type_conv_test"; [] gorptest: 09:32:49.041497 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:49.064957 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:49.097809 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:49.126992 drop table if exists "time_test"; [] gorptest: 09:32:49.151325 drop table if exists "id_created_test"; [] 2023/06/26 09:32:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:49.183254 drop table if exists "invoice_test"; [] gorptest: 09:32:49.204441 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:49.206685 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:49.208891 drop table if exists "invoice_override_test"; [] gorptest: 09:32:49.210581 drop table if exists "person_test"; [] gorptest: 09:32:49.212429 drop table if exists "ignored_column_test"; [] gorptest: 09:32:49.214202 drop table if exists "id_created_test"; [] gorptest: 09:32:49.215733 drop table if exists "type_conv_test"; [] gorptest: 09:32:49.217324 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:49.218806 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:49.220556 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:49.223217 drop table if exists "time_test"; [] gorptest: 09:32:49.227476 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:49.257282 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:49.284540 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:49.308968 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:49.339756 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:49.364353 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:49.401332 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:49.443089 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:49.468906 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:49.499856 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:49.532439 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:49.566444 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:49.595884 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:49.599472 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:49.602210 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:49.606830 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:49.608972 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:49.610771 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:49.613058 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:49.614829 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:49.616447 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:49.618065 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:49.619673 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:49.622270 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:49.624210 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:32:49.632672 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786369627191240 2:1687786369627191240 3:"Bob" 4:"Smith" 5:1] gorptest: 09:32:49.673499 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 09:32:49.709239 delete from "invoice_test"; [] gorptest: 09:32:49.741745 delete from "invoice_tag_test"; [] gorptest: 09:32:49.771086 delete from "alias_trans_field_test"; [] gorptest: 09:32:49.804664 delete from "invoice_override_test"; [] gorptest: 09:32:49.877496 delete from "person_test"; [] gorptest: 09:32:49.906255 delete from "ignored_column_test"; [] gorptest: 09:32:49.938992 delete from "id_created_test"; [] gorptest: 09:32:49.976404 delete from "type_conv_test"; [] gorptest: 09:32:50.007635 delete from "embedded_struct_test"; [] gorptest: 09:32:50.034733 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:50.069316 delete from "embedded_autoincr_test"; [] gorptest: 09:32:50.095614 delete from "time_test"; [] gorptest: 09:32:50.121217 delete from "id_created_test"; [] gorptest: 09:32:50.153513 SELECT * FROM person_test [] gorptest: 09:32:50.168621 SELECT * FROM invoice_test [] gorptest: 09:32:50.172822 drop table if exists "invoice_test"; [] gorptest: 09:32:50.204599 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:50.228020 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:50.257691 drop table if exists "invoice_override_test"; [] gorptest: 09:32:50.295619 drop table if exists "person_test"; [] gorptest: 09:32:50.325259 drop table if exists "ignored_column_test"; [] gorptest: 09:32:50.359207 drop table if exists "id_created_test"; [] gorptest: 09:32:50.390634 drop table if exists "type_conv_test"; [] gorptest: 09:32:50.415552 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:50.440494 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:50.465903 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:50.500712 drop table if exists "time_test"; [] gorptest: 09:32:50.531344 drop table if exists "id_created_test"; [] gorptest: 09:32:50.539970 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 09:32:50.584217 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-06-26 09:32:50 -0400 EDT] gorptest: 09:32:50.614740 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 09:32:50.628897 drop table if exists "WithCustomDate"; [] gorptest: 09:32:50.669603 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:32:50.706832 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:32:50.734123 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:32:50.766422 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 09:32:50.792730 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 09:32:50.821021 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 09:32:50.856859 drop table if exists "PersonUInt64"; [] gorptest: 09:32:50.887551 drop table if exists "PersonUInt32"; [] gorptest: 09:32:50.917711 drop table if exists "PersonUInt16"; [] gorptest: 09:32:50.956835 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 09:32:50.994769 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 09:32:51.025281 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 09:32:51.036840 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 09:32:51.040117 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 09:32:51.063190 drop table if exists "UniqueColumns"; [] gorptest: 09:32:51.101002 drop table if exists PersistentUser [] gorptest: 09:32:51.110637 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:32:51.140145 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:32:51.173091 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 09:32:51.179314 select * from PersistentUser [] gorptest: 09:32:51.191062 select * from PersistentUser [] gorptest: 09:32:51.196579 select * from PersistentUser [] gorptest: 09:32:51.200288 select Id from PersistentUser [] gorptest: 09:32:51.203191 select mykey from PersistentUser [] gorptest: 09:32:51.205658 select PassedTraining from PersistentUser [] gorptest: 09:32:51.208017 select Id from PersistentUser [] gorptest: 09:32:51.210362 drop table if exists "PersistentUser"; [] gorptest: 09:32:51.252743 drop table if exists PersistentUser [] gorptest: 09:32:51.269234 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:32:51.306581 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:32:51.343625 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 09:32:51.388597 select * from PersistentUser where mykey = ? [1:43] gorptest: 09:32:51.397447 select * from PersistentUser where mykey = ? [1:43] gorptest: 09:32:51.401569 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 09:32:51.405757 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 09:32:51.408450 drop table if exists "PersistentUser"; [] gorptest: 09:32:51.451616 drop table if exists PersistentUser [] gorptest: 09:32:51.460019 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:32:51.501126 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:32:51.532199 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 09:32:51.570069 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 09:32:51.574012 drop table if exists "PersistentUser"; [] 2023/06/26 09:32:51 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:51.620271 drop table if exists "invoice_test"; [] gorptest: 09:32:51.628510 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:51.630220 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:51.632267 drop table if exists "invoice_override_test"; [] gorptest: 09:32:51.634074 drop table if exists "person_test"; [] gorptest: 09:32:51.635774 drop table if exists "ignored_column_test"; [] gorptest: 09:32:51.637392 drop table if exists "id_created_test"; [] gorptest: 09:32:51.638935 drop table if exists "type_conv_test"; [] gorptest: 09:32:51.640567 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:51.642419 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:51.643996 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:51.645560 drop table if exists "time_test"; [] gorptest: 09:32:51.647542 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:51.691502 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:51.723823 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:51.749188 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:51.780317 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:51.809028 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:51.846071 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:51.877821 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:51.915671 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:51.961121 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:51.990069 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:52.029291 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:52.057851 select * from invoice_test where id=99999 [] gorptest: 09:32:52.060990 select * from invoice_test where id=99999 [] gorptest: 09:32:52.065056 drop table if exists "invoice_test"; [] gorptest: 09:32:52.098896 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:52.124947 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:52.149179 drop table if exists "invoice_override_test"; [] gorptest: 09:32:52.201415 drop table if exists "person_test"; [] gorptest: 09:32:52.229313 drop table if exists "ignored_column_test"; [] gorptest: 09:32:52.255558 drop table if exists "id_created_test"; [] gorptest: 09:32:52.286749 drop table if exists "type_conv_test"; [] gorptest: 09:32:52.323520 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:52.356580 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:52.385988 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:52.413330 drop table if exists "time_test"; [] gorptest: 09:32:52.436318 drop table if exists "id_created_test"; [] gorptest: 09:32:52.442572 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 09:32:52.489025 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] gorptest: 09:32:52.498886 drop table if exists "InvoicePersonView"; [] 2023/06/26 09:32:52 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:52.537311 drop table if exists "invoice_test"; [] gorptest: 09:32:52.545253 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:52.547185 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:52.548895 drop table if exists "invoice_override_test"; [] gorptest: 09:32:52.550495 drop table if exists "person_test"; [] gorptest: 09:32:52.552749 drop table if exists "ignored_column_test"; [] gorptest: 09:32:52.554741 drop table if exists "id_created_test"; [] gorptest: 09:32:52.556403 drop table if exists "type_conv_test"; [] gorptest: 09:32:52.557998 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:52.559621 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:52.561211 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:52.563271 drop table if exists "time_test"; [] gorptest: 09:32:52.565115 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:52.607787 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:52.637336 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:52.664950 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:52.693864 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:52.860088 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:52.894457 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:52.919674 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:52.949907 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:52.977363 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:53.002722 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:53.026567 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:53.066575 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786373066187170 2:1687786373066187170 3:"Bob" 4:"Smith" 5:1] gorptest: 09:32:53.094539 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:32:53.100332 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786373066187170 2:1687786373066187170 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 09:32:53.125904 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786373066187170 2:1687786373066187170 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 09:32:53.129022 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:32:53.133103 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 09:32:53.136218 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:32:53.138648 drop table if exists "invoice_test"; [] gorptest: 09:32:53.169471 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:53.192813 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:53.217563 drop table if exists "invoice_override_test"; [] gorptest: 09:32:53.270004 drop table if exists "person_test"; [] gorptest: 09:32:53.321236 drop table if exists "ignored_column_test"; [] gorptest: 09:32:53.351478 drop table if exists "id_created_test"; [] gorptest: 09:32:53.377442 drop table if exists "type_conv_test"; [] gorptest: 09:32:53.408020 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:53.429925 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:53.452519 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:53.476376 drop table if exists "time_test"; [] gorptest: 09:32:53.497940 drop table if exists "id_created_test"; [] gorptest: 09:32:53.504983 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 09:32:53.536736 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 09:32:53.556429 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 09:32:53.565138 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] gorptest: 09:32:53.586117 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 09:32:53.592011 drop table if exists "TableWithNull"; [] gorptest: 09:32:53.617749 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 09:32:53.654228 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 09:32:53.676422 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 09:32:53.683467 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 09:32:53.687471 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 09:32:53.691030 drop table if exists "Invoice"; [] 2023/06/26 09:32:53 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:53.719650 drop table if exists "invoice_test"; [] gorptest: 09:32:53.727312 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:53.729271 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:53.730905 drop table if exists "invoice_override_test"; [] gorptest: 09:32:53.734206 drop table if exists "person_test"; [] gorptest: 09:32:53.736131 drop table if exists "ignored_column_test"; [] gorptest: 09:32:53.738024 drop table if exists "id_created_test"; [] gorptest: 09:32:53.739653 drop table if exists "type_conv_test"; [] gorptest: 09:32:53.741200 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:53.743402 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:53.745185 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:53.746667 drop table if exists "time_test"; [] gorptest: 09:32:53.749580 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:53.768379 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:53.794722 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:53.818436 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:53.845966 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:53.870594 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:53.895708 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:53.921719 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:53.944442 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:53.968247 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:53.992921 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:54.021279 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:54.044745 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786374044213479 2:1687786374044213479 3:"bob" 4:"smith" 5:1] gorptest: 09:32:54.069069 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 09:32:54.089625 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 09:32:54.096950 drop table if exists "invoice_test"; [] gorptest: 09:32:54.117850 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:54.142883 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:54.177046 drop table if exists "invoice_override_test"; [] gorptest: 09:32:54.216377 drop table if exists "person_test"; [] gorptest: 09:32:54.249967 drop table if exists "ignored_column_test"; [] gorptest: 09:32:54.277436 drop table if exists "id_created_test"; [] gorptest: 09:32:54.308553 drop table if exists "type_conv_test"; [] gorptest: 09:32:54.337840 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:54.364752 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:54.398946 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:54.426601 drop table if exists "time_test"; [] gorptest: 09:32:54.455182 drop table if exists "id_created_test"; [] 2023/06/26 09:32:54 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:54.465413 drop table if exists "invoice_test"; [] gorptest: 09:32:54.473894 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:54.476075 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:54.478344 drop table if exists "invoice_override_test"; [] gorptest: 09:32:54.480486 drop table if exists "person_test"; [] gorptest: 09:32:54.483191 drop table if exists "ignored_column_test"; [] gorptest: 09:32:54.485405 drop table if exists "id_created_test"; [] gorptest: 09:32:54.487407 drop table if exists "type_conv_test"; [] gorptest: 09:32:54.489387 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:54.492256 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:54.494383 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:54.496353 drop table if exists "time_test"; [] gorptest: 09:32:54.498550 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:54.522902 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:54.552150 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:54.585668 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:54.631075 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:54.664411 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:54.694137 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:54.727397 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:54.754536 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:54.779793 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:54.806259 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:54.829545 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:54.852396 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786374851528686 2:1687786374851528686 3:"bob" 4:"smith" 5:1] gorptest: 09:32:54.878874 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:32:54.882921 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786374851528686 2:1687786374851528686 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 09:32:54.907287 select * from person_test where id = ? [1:1] gorptest: 09:32:54.910887 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 09:32:54.933484 drop table if exists "invoice_test"; [] gorptest: 09:32:54.960875 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:54.989379 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:55.015645 drop table if exists "invoice_override_test"; [] gorptest: 09:32:55.046210 drop table if exists "person_test"; [] gorptest: 09:32:55.077489 drop table if exists "ignored_column_test"; [] gorptest: 09:32:55.109455 drop table if exists "id_created_test"; [] gorptest: 09:32:55.140808 drop table if exists "type_conv_test"; [] gorptest: 09:32:55.163316 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:55.194444 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:55.223361 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:55.256212 drop table if exists "time_test"; [] gorptest: 09:32:55.288192 drop table if exists "id_created_test"; [] 2023/06/26 09:32:55 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:55.299777 drop table if exists "invoice_test"; [] gorptest: 09:32:55.312569 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:55.315980 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:55.318629 drop table if exists "invoice_override_test"; [] gorptest: 09:32:55.321284 drop table if exists "person_test"; [] gorptest: 09:32:55.324561 drop table if exists "ignored_column_test"; [] gorptest: 09:32:55.327822 drop table if exists "id_created_test"; [] gorptest: 09:32:55.330567 drop table if exists "type_conv_test"; [] gorptest: 09:32:55.333528 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:55.336392 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:55.339219 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:55.342325 drop table if exists "time_test"; [] gorptest: 09:32:55.345335 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:55.388432 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:55.420631 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:55.451617 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:55.481001 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:55.502319 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:55.529024 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:55.549751 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:55.570579 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:55.595548 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:55.618412 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:55.640577 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:55.663721 begin; [] gorptest: 09:32:55.670320 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 09:32:55.679136 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 09:32:55.680559 commit; [] gorptest: 09:32:55.709124 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:55.714378 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 09:32:55.717850 drop table if exists "invoice_test"; [] gorptest: 09:32:55.747562 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:55.776498 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:55.800680 drop table if exists "invoice_override_test"; [] gorptest: 09:32:55.838091 drop table if exists "person_test"; [] gorptest: 09:32:55.868609 drop table if exists "ignored_column_test"; [] gorptest: 09:32:55.894437 drop table if exists "id_created_test"; [] gorptest: 09:32:55.926909 drop table if exists "type_conv_test"; [] gorptest: 09:32:55.963503 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:55.995465 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:56.014918 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:56.035696 drop table if exists "time_test"; [] gorptest: 09:32:56.098000 drop table if exists "id_created_test"; [] 2023/06/26 09:32:56 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:56.116159 drop table if exists "invoice_test"; [] gorptest: 09:32:56.128863 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:56.131198 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:56.133983 drop table if exists "invoice_override_test"; [] gorptest: 09:32:56.136018 drop table if exists "person_test"; [] gorptest: 09:32:56.138107 drop table if exists "ignored_column_test"; [] gorptest: 09:32:56.140702 drop table if exists "id_created_test"; [] gorptest: 09:32:56.142981 drop table if exists "type_conv_test"; [] gorptest: 09:32:56.145001 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:56.147590 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:56.149588 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:56.151586 drop table if exists "time_test"; [] gorptest: 09:32:56.154653 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:56.193130 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:56.227187 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:56.251229 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:56.275391 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:56.304659 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:56.329291 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:56.356909 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:56.383561 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:56.415574 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:56.442333 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:56.465690 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:56.495634 begin; [] gorptest: 09:32:56.497214 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 09:32:56.505859 select memo from invoice_test [] gorptest: 09:32:56.507867 savepoint "foo" [1:] gorptest: 09:32:56.508804 select memo from invoice_test [] gorptest: 09:32:56.510941 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 09:32:56.514150 select memo from invoice_test [] gorptest: 09:32:56.516936 rollback to savepoint "foo" [1:] gorptest: 09:32:56.519517 select memo from invoice_test [] gorptest: 09:32:56.520731 rollback; [] gorptest: 09:32:56.527340 drop table if exists "invoice_test"; [] gorptest: 09:32:56.551710 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:56.581419 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:56.609438 drop table if exists "invoice_override_test"; [] gorptest: 09:32:56.639274 drop table if exists "person_test"; [] gorptest: 09:32:56.664460 drop table if exists "ignored_column_test"; [] gorptest: 09:32:56.689901 drop table if exists "id_created_test"; [] gorptest: 09:32:56.718513 drop table if exists "type_conv_test"; [] gorptest: 09:32:56.748075 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:56.770901 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:56.795246 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:56.823895 drop table if exists "time_test"; [] gorptest: 09:32:56.849960 drop table if exists "id_created_test"; [] 2023/06/26 09:32:56 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:56.857447 drop table if exists "invoice_test"; [] gorptest: 09:32:56.867899 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:56.870144 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:56.872524 drop table if exists "invoice_override_test"; [] gorptest: 09:32:56.874532 drop table if exists "person_test"; [] gorptest: 09:32:56.876487 drop table if exists "ignored_column_test"; [] gorptest: 09:32:56.878438 drop table if exists "id_created_test"; [] gorptest: 09:32:56.880366 drop table if exists "type_conv_test"; [] gorptest: 09:32:56.884351 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:56.886372 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:56.888346 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:56.890294 drop table if exists "time_test"; [] gorptest: 09:32:56.892756 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:56.919800 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:56.947335 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:57.021011 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:57.055911 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:57.106081 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:57.138009 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:57.187491 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:57.227254 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:57.260966 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:57.300035 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:57.337431 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:57.368237 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 09:32:57.400298 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 09:32:57.427889 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 09:32:57.450048 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 09:32:57.475054 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:57.506609 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 09:32:57.529444 drop table if exists "invoice_test"; [] gorptest: 09:32:57.556573 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:57.583736 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:57.605622 drop table if exists "invoice_override_test"; [] gorptest: 09:32:57.629656 drop table if exists "person_test"; [] gorptest: 09:32:57.655839 drop table if exists "ignored_column_test"; [] gorptest: 09:32:57.675616 drop table if exists "id_created_test"; [] gorptest: 09:32:57.696096 drop table if exists "type_conv_test"; [] gorptest: 09:32:57.728145 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:57.748694 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:57.775312 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:57.799245 drop table if exists "time_test"; [] gorptest: 09:32:57.860770 drop table if exists "id_created_test"; [] 2023/06/26 09:32:57 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:57.867413 drop table if exists "invoice_test"; [] gorptest: 09:32:57.875366 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:57.877026 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:57.878688 drop table if exists "invoice_override_test"; [] gorptest: 09:32:57.880197 drop table if exists "person_test"; [] gorptest: 09:32:57.881715 drop table if exists "ignored_column_test"; [] gorptest: 09:32:57.883624 drop table if exists "id_created_test"; [] gorptest: 09:32:57.885211 drop table if exists "type_conv_test"; [] gorptest: 09:32:57.886985 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:57.888500 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:57.890093 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:57.891689 drop table if exists "time_test"; [] gorptest: 09:32:57.893804 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:57.922135 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:57.949964 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:57.973434 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:58.002512 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:58.033341 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:58.070298 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:58.097802 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:58.120564 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:58.153253 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:58.194258 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:58.247245 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:58.299801 delete from invoice_test [] gorptest: 09:32:58.332765 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 09:32:58.366811 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:58.374032 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:7424466741990696569 2:1816179276377133043 3:"random 8646594593388078813" 4:0 5:true 6:1] gorptest: 09:32:58.400012 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:58.404140 select * from invoice_test [] gorptest: 09:32:58.410774 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:58.437927 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:32:58.443843 delete from invoice_tag_test [] gorptest: 09:32:58.473236 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] gorptest: 09:32:58.509508 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:32:58.514246 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:564450500075968389 2:4883858002787561518 3:"random 3838303410027494598" 4:33 5:false 6:1] gorptest: 09:32:58.547502 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:32:58.554190 select * from invoice_tag_test [] gorptest: 09:32:58.561504 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:32:58.595634 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:32:58.599154 delete from alias_trans_field_test [] gorptest: 09:32:58.628366 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 09:32:58.663180 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:32:58.666672 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 7594067023667617637" 2:1] gorptest: 09:32:58.695159 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:32:58.698201 select * from alias_trans_field_test [] gorptest: 09:32:58.701222 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:32:58.736556 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:32:58.740038 drop table if exists "invoice_test"; [] gorptest: 09:32:58.766860 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:58.796014 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:58.827570 drop table if exists "invoice_override_test"; [] gorptest: 09:32:58.859063 drop table if exists "person_test"; [] gorptest: 09:32:58.886347 drop table if exists "ignored_column_test"; [] gorptest: 09:32:58.916951 drop table if exists "id_created_test"; [] gorptest: 09:32:58.941104 drop table if exists "type_conv_test"; [] gorptest: 09:32:58.968912 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:58.996297 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:59.024332 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:59.050911 drop table if exists "time_test"; [] gorptest: 09:32:59.083417 drop table if exists "id_created_test"; [] 2023/06/26 09:32:59 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:59.090296 drop table if exists "invoice_test"; [] gorptest: 09:32:59.102207 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:59.105824 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:59.109433 drop table if exists "invoice_override_test"; [] gorptest: 09:32:59.113488 drop table if exists "person_test"; [] gorptest: 09:32:59.117031 drop table if exists "ignored_column_test"; [] gorptest: 09:32:59.120612 drop table if exists "id_created_test"; [] gorptest: 09:32:59.125376 drop table if exists "type_conv_test"; [] gorptest: 09:32:59.128919 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:59.133133 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:59.136690 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:59.140200 drop table if exists "time_test"; [] gorptest: 09:32:59.145284 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:59.175306 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:32:59.204797 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:32:59.234134 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:32:59.264929 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:32:59.294784 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:59.326418 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:32:59.357657 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:32:59.389867 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:32:59.429025 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:32:59.467271 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:32:59.499912 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:32:59.528218 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 09:32:59.562527 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:32:59.566387 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:32:59.590845 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:32:59.596902 drop table if exists "invoice_test"; [] gorptest: 09:32:59.621128 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:59.651602 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:59.684174 drop table if exists "invoice_override_test"; [] gorptest: 09:32:59.712172 drop table if exists "person_test"; [] gorptest: 09:32:59.737529 drop table if exists "ignored_column_test"; [] gorptest: 09:32:59.766001 drop table if exists "id_created_test"; [] gorptest: 09:32:59.791023 drop table if exists "type_conv_test"; [] gorptest: 09:32:59.816609 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:59.842222 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:59.869020 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:59.896533 drop table if exists "time_test"; [] gorptest: 09:32:59.922216 drop table if exists "id_created_test"; [] 2023/06/26 09:32:59 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:32:59.938182 drop table if exists "invoice_test"; [] gorptest: 09:32:59.945236 drop table if exists "invoice_tag_test"; [] gorptest: 09:32:59.946847 drop table if exists "alias_trans_field_test"; [] gorptest: 09:32:59.948730 drop table if exists "invoice_override_test"; [] gorptest: 09:32:59.950259 drop table if exists "person_test"; [] gorptest: 09:32:59.952022 drop table if exists "ignored_column_test"; [] gorptest: 09:32:59.953546 drop table if exists "id_created_test"; [] gorptest: 09:32:59.955382 drop table if exists "type_conv_test"; [] gorptest: 09:32:59.957044 drop table if exists "embedded_struct_test"; [] gorptest: 09:32:59.960890 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:32:59.964470 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:32:59.967590 drop table if exists "time_test"; [] gorptest: 09:32:59.970543 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:00.000636 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:00.029126 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:00.050069 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:00.072110 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:00.096096 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:00.116272 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:00.138430 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:00.159589 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:00.184684 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:00.214313 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:00.241531 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:00.301101 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] gorptest: 09:33:00.337968 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:33:00.349831 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] gorptest: 09:33:00.372560 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:33:00.380309 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:33:00.408390 drop table if exists "invoice_test"; [] gorptest: 09:33:00.436729 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:00.465659 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:00.494373 drop table if exists "invoice_override_test"; [] gorptest: 09:33:00.528053 drop table if exists "person_test"; [] gorptest: 09:33:00.558385 drop table if exists "ignored_column_test"; [] gorptest: 09:33:00.585000 drop table if exists "id_created_test"; [] gorptest: 09:33:00.610737 drop table if exists "type_conv_test"; [] gorptest: 09:33:00.638816 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:00.663247 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:00.691479 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:00.715300 drop table if exists "time_test"; [] gorptest: 09:33:00.743360 drop table if exists "id_created_test"; [] 2023/06/26 09:33:00 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:00.749966 drop table if exists "invoice_test"; [] gorptest: 09:33:00.757058 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:00.759508 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:00.761185 drop table if exists "invoice_override_test"; [] gorptest: 09:33:00.763472 drop table if exists "person_test"; [] gorptest: 09:33:00.765217 drop table if exists "ignored_column_test"; [] gorptest: 09:33:00.767138 drop table if exists "id_created_test"; [] gorptest: 09:33:00.769084 drop table if exists "type_conv_test"; [] gorptest: 09:33:00.770859 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:00.772895 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:00.775060 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:00.776792 drop table if exists "time_test"; [] gorptest: 09:33:00.778626 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:00.815010 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:00.839329 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:00.863695 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:00.887361 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:00.916649 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:00.954093 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:00.977360 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:01.006311 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:01.039500 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:01.072639 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:01.097504 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:01.125272 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 09:33:01.150535 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 09:33:01.154353 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 09:33:01.182581 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 09:33:01.185428 select * from embedded_struct_test [] gorptest: 09:33:01.188387 drop table if exists "invoice_test"; [] gorptest: 09:33:01.209384 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:01.231099 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:01.255018 drop table if exists "invoice_override_test"; [] gorptest: 09:33:01.285821 drop table if exists "person_test"; [] gorptest: 09:33:01.309015 drop table if exists "ignored_column_test"; [] gorptest: 09:33:01.334976 drop table if exists "id_created_test"; [] gorptest: 09:33:01.364244 drop table if exists "type_conv_test"; [] gorptest: 09:33:01.391067 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:01.421190 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:01.453729 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:01.476556 drop table if exists "time_test"; [] gorptest: 09:33:01.523074 drop table if exists "id_created_test"; [] 2023/06/26 09:33:01 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:01.530244 drop table if exists "invoice_test"; [] gorptest: 09:33:01.537487 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:01.539692 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:01.542613 drop table if exists "invoice_override_test"; [] gorptest: 09:33:01.544626 drop table if exists "person_test"; [] gorptest: 09:33:01.546242 drop table if exists "ignored_column_test"; [] gorptest: 09:33:01.547790 drop table if exists "id_created_test"; [] gorptest: 09:33:01.549442 drop table if exists "type_conv_test"; [] gorptest: 09:33:01.551141 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:01.553203 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:01.555311 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:01.557341 drop table if exists "time_test"; [] gorptest: 09:33:01.559090 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:01.589591 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:01.614133 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:01.636128 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:01.657959 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:01.681105 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:01.703193 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:01.728041 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:01.749807 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:01.770637 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:01.793633 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:01.814748 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:01.836931 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 09:33:01.859007 drop table if exists "invoice_test"; [] gorptest: 09:33:01.879072 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:01.904619 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:01.931597 drop table if exists "invoice_override_test"; [] gorptest: 09:33:01.959978 drop table if exists "person_test"; [] gorptest: 09:33:01.983248 drop table if exists "ignored_column_test"; [] gorptest: 09:33:02.005298 drop table if exists "id_created_test"; [] gorptest: 09:33:02.031122 drop table if exists "type_conv_test"; [] gorptest: 09:33:02.054488 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:02.082725 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:02.104917 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:02.125433 drop table if exists "time_test"; [] gorptest: 09:33:02.144832 drop table if exists "id_created_test"; [] 2023/06/26 09:33:02 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:02.157605 drop table if exists "invoice_test"; [] gorptest: 09:33:02.168248 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:02.170076 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:02.172211 drop table if exists "invoice_override_test"; [] gorptest: 09:33:02.174092 drop table if exists "person_test"; [] gorptest: 09:33:02.175783 drop table if exists "ignored_column_test"; [] gorptest: 09:33:02.177564 drop table if exists "id_created_test"; [] gorptest: 09:33:02.179106 drop table if exists "type_conv_test"; [] gorptest: 09:33:02.180670 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:02.182636 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:02.184669 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:02.186575 drop table if exists "time_test"; [] gorptest: 09:33:02.188461 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:02.222831 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:02.293726 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:02.341677 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:02.364973 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:02.396408 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:02.427159 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:02.449428 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:02.471102 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:02.496941 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:02.523922 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:02.555289 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:02.582069 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 09:33:02.617243 drop table if exists "invoice_test"; [] gorptest: 09:33:02.644997 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:02.675773 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:02.803109 drop table if exists "invoice_override_test"; [] gorptest: 09:33:02.913316 drop table if exists "person_test"; [] gorptest: 09:33:02.970857 drop table if exists "ignored_column_test"; [] gorptest: 09:33:02.996977 drop table if exists "id_created_test"; [] gorptest: 09:33:03.027648 drop table if exists "type_conv_test"; [] gorptest: 09:33:03.055149 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:03.079906 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:03.114720 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:03.146138 drop table if exists "time_test"; [] gorptest: 09:33:03.168075 drop table if exists "id_created_test"; [] gorptest: 09:33:03.173106 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 09:33:03.205559 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] gorptest: 09:33:03.226020 select Int64 from TableWithNull where Str='abc' [] gorptest: 09:33:03.228813 select count(*) from TableWithNull [] gorptest: 09:33:03.233423 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 09:33:03.240669 select Int64 from TableWithNull where Str='notfound' [] gorptest: 09:33:03.244655 select Int64 from TableWithNull where Str='abc' [] gorptest: 09:33:03.250413 select Float64 from TableWithNull where Str='abc' [] gorptest: 09:33:03.256512 select min(Float64) from TableWithNull [] gorptest: 09:33:03.263864 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 09:33:03.267673 select Float64 from TableWithNull where Str='notfound' [] gorptest: 09:33:03.270140 select Float64 from TableWithNull where Str='abc' [] gorptest: 09:33:03.273267 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:33:03.276041 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 09:33:03.278330 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:33:03.280662 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 09:33:03.287069 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 09:33:03.291108 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:33:03.294126 drop table if exists "TableWithNull"; [] 2023/06/26 09:33:03 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:03.318963 drop table if exists "invoice_test"; [] gorptest: 09:33:03.326453 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:03.328281 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:03.330000 drop table if exists "invoice_override_test"; [] gorptest: 09:33:03.331694 drop table if exists "person_test"; [] gorptest: 09:33:03.333840 drop table if exists "ignored_column_test"; [] gorptest: 09:33:03.335446 drop table if exists "id_created_test"; [] gorptest: 09:33:03.337007 drop table if exists "type_conv_test"; [] gorptest: 09:33:03.338568 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:03.340064 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:03.341605 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:03.343496 drop table if exists "time_test"; [] gorptest: 09:33:03.345649 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:03.376713 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:03.400250 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:03.426097 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:03.454279 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:03.476035 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:03.498955 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:03.520353 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:03.542576 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:03.564876 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:03.596139 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:03.625141 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:03.653134 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786383649029964 2:1687786383649029964 3:"Bob" 4:"Smith" 5:1] gorptest: 09:33:03.677694 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786383676985964 2:1687786383676985964 3:"Jane" 4:"Smith" 5:1] gorptest: 09:33:03.700039 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786383699310564 2:1687786383699310564 3:"Mike" 4:"Smith" 5:1] gorptest: 09:33:03.731530 drop table if exists "invoice_test"; [] gorptest: 09:33:03.764869 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:03.799647 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:03.823454 drop table if exists "invoice_override_test"; [] gorptest: 09:33:03.853239 drop table if exists "person_test"; [] gorptest: 09:33:03.879355 drop table if exists "ignored_column_test"; [] gorptest: 09:33:03.905782 drop table if exists "id_created_test"; [] gorptest: 09:33:03.937547 drop table if exists "type_conv_test"; [] gorptest: 09:33:03.959805 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:03.981244 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:04.005570 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:04.030009 drop table if exists "time_test"; [] gorptest: 09:33:04.055041 drop table if exists "id_created_test"; [] gorptest: 09:33:04.060101 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 09:33:04.092025 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 09:33:04.115776 drop table if exists "string_pk_test"; [] 2023/06/26 09:33:04 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:04.186215 drop table if exists "invoice_test"; [] gorptest: 09:33:04.197303 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:04.199249 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:04.201097 drop table if exists "invoice_override_test"; [] gorptest: 09:33:04.204347 drop table if exists "person_test"; [] gorptest: 09:33:04.206077 drop table if exists "ignored_column_test"; [] gorptest: 09:33:04.208579 drop table if exists "id_created_test"; [] gorptest: 09:33:04.210382 drop table if exists "type_conv_test"; [] gorptest: 09:33:04.212606 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:04.214292 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:04.216377 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:04.218013 drop table if exists "time_test"; [] gorptest: 09:33:04.220024 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:04.255881 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:04.280377 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:04.304823 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:04.329034 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:04.354392 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:04.379707 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:04.407158 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:04.431011 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:04.464930 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:04.489913 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:04.514160 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:04.544511 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-26 13:02:04.541381571 +0000 UTC] gorptest: 09:33:04.569657 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-26 13:03:05.541381571 +0000 UTC] gorptest: 09:33:04.593260 SELECT id FROM time_test WHERE Time < ? [1:2023-06-26 13:03:04.541381571 +0000 UTC] gorptest: 09:33:04.598689 drop table if exists "invoice_test"; [] gorptest: 09:33:04.622380 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:04.647908 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:04.677365 drop table if exists "invoice_override_test"; [] gorptest: 09:33:04.707624 drop table if exists "person_test"; [] gorptest: 09:33:04.730918 drop table if exists "ignored_column_test"; [] gorptest: 09:33:04.755897 drop table if exists "id_created_test"; [] gorptest: 09:33:04.776075 drop table if exists "type_conv_test"; [] gorptest: 09:33:04.799459 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:04.826062 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:04.849908 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:04.873790 drop table if exists "time_test"; [] gorptest: 09:33:04.901582 drop table if exists "id_created_test"; [] 2023/06/26 09:33:04 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:04.908003 drop table if exists "invoice_test"; [] gorptest: 09:33:04.916234 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:04.918222 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:04.919953 drop table if exists "invoice_override_test"; [] gorptest: 09:33:04.921690 drop table if exists "person_test"; [] gorptest: 09:33:04.924554 drop table if exists "ignored_column_test"; [] gorptest: 09:33:04.926697 drop table if exists "id_created_test"; [] gorptest: 09:33:04.928613 drop table if exists "type_conv_test"; [] gorptest: 09:33:04.930384 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:04.932658 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:04.934392 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:04.936917 drop table if exists "time_test"; [] gorptest: 09:33:04.938743 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:04.977823 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:05.004326 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:05.031380 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:05.059571 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:05.086832 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:05.110810 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:05.137646 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:05.162274 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:05.187208 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:05.214041 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:05.245186 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:05.277926 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786385277603778 2:1687786385277603778 3:"bob" 4:"smith" 5:1] gorptest: 09:33:05.315425 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 09:33:05.341105 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 09:33:05.345217 drop table if exists "invoice_test"; [] gorptest: 09:33:05.381455 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:05.408663 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:05.434599 drop table if exists "invoice_override_test"; [] gorptest: 09:33:05.460010 drop table if exists "person_test"; [] gorptest: 09:33:05.484569 drop table if exists "ignored_column_test"; [] gorptest: 09:33:05.506864 drop table if exists "id_created_test"; [] gorptest: 09:33:05.530076 drop table if exists "type_conv_test"; [] gorptest: 09:33:05.556232 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:05.578383 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:05.604870 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:05.625923 drop table if exists "time_test"; [] gorptest: 09:33:05.656611 drop table if exists "id_created_test"; [] 2023/06/26 09:33:05 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:05.663891 drop table if exists "invoice_test"; [] gorptest: 09:33:05.672203 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:05.674112 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:05.675825 drop table if exists "invoice_override_test"; [] gorptest: 09:33:05.678017 drop table if exists "person_test"; [] gorptest: 09:33:05.679700 drop table if exists "ignored_column_test"; [] gorptest: 09:33:05.681586 drop table if exists "id_created_test"; [] gorptest: 09:33:05.683694 drop table if exists "type_conv_test"; [] gorptest: 09:33:05.685425 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:05.687058 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:05.688895 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:05.690585 drop table if exists "time_test"; [] gorptest: 09:33:05.693078 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:05.720714 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:05.743845 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:05.764968 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:05.787244 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:05.812310 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:05.833991 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:05.857759 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:05.879367 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:05.899601 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:05.923413 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:05.945690 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] 2023/06/26 09:33: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: 09:33:06.319745 drop table if exists "invoice_test"; [] gorptest: 09:33:06.328337 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:06.330573 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:06.332904 drop table if exists "invoice_override_test"; [] gorptest: 09:33:06.335606 drop table if exists "person_test"; [] gorptest: 09:33:06.337910 drop table if exists "ignored_column_test"; [] gorptest: 09:33:06.339999 drop table if exists "id_created_test"; [] gorptest: 09:33:06.342350 drop table if exists "type_conv_test"; [] gorptest: 09:33:06.344624 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:06.346608 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:06.348582 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:06.350531 drop table if exists "time_test"; [] gorptest: 09:33:06.352943 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:06.380820 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:06.401100 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:06.438518 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:06.467920 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:06.493418 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:06.514906 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:06.541402 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:06.567570 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:06.591477 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:06.613066 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:06.653555 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:06.679880 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786386679406490 2:1687786386679406490 3:"bob" 4:"smith" 5:1] gorptest: 09:33:06.706572 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786386706295391 2:1687786386706295391 3:"jane" 4:"doe" 5:1] gorptest: 09:33:06.730881 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:33:06.736757 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 09:33:06.743996 select * from person_test where Id=? [1:1] gorptest: 09:33:06.748490 select * from person_test order by fname asc [] gorptest: 09:33:06.755361 drop table if exists "invoice_test"; [] gorptest: 09:33:06.776071 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:06.807245 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:06.869346 drop table if exists "invoice_override_test"; [] gorptest: 09:33:06.895680 drop table if exists "person_test"; [] gorptest: 09:33:06.923818 drop table if exists "ignored_column_test"; [] gorptest: 09:33:06.951096 drop table if exists "id_created_test"; [] gorptest: 09:33:06.975500 drop table if exists "type_conv_test"; [] gorptest: 09:33:07.001136 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:07.035118 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:07.190855 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:07.297393 drop table if exists "time_test"; [] gorptest: 09:33:07.439651 drop table if exists "id_created_test"; [] 2023/06/26 09:33: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: 09:33:07.449158 drop table if exists "invoice_test"; [] gorptest: 09:33:07.459382 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:07.461604 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:07.464157 drop table if exists "invoice_override_test"; [] gorptest: 09:33:07.466368 drop table if exists "person_test"; [] gorptest: 09:33:07.468477 drop table if exists "ignored_column_test"; [] gorptest: 09:33:07.470456 drop table if exists "id_created_test"; [] gorptest: 09:33:07.474536 drop table if exists "type_conv_test"; [] gorptest: 09:33:07.478085 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:07.480569 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:07.482922 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:07.484955 drop table if exists "time_test"; [] gorptest: 09:33:07.487237 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:07.522303 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:07.543786 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:07.564257 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:07.589756 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:07.613112 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:07.633830 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:07.685100 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:07.710269 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:07.733992 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:07.756548 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:07.782896 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:07.816339 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786387816010900 2:1687786387816010900 3:"bob" 4:"smith" 5:1] gorptest: 09:33:07.850377 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:33:07.854197 select * from person_test where Id=? [1:1] gorptest: 09:33:07.857643 select FName from person_test where Id=? [1:1] gorptest: 09:33:07.861071 select * from person_test where Id=? [1:1] gorptest: 09:33:07.865931 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 09:33:07.869502 select * from person_test where Id=? [1:-2222] gorptest: 09:33:07.873046 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786387872751001 2:1687786387872751001 3:"bob" 4:"smith" 5:1] gorptest: 09:33:07.902569 select * from person_test where Fname='bob' [] gorptest: 09:33:07.906622 select * from person_test where Id=-123 [] gorptest: 09:33:07.908996 select * from person_test where Id=-123 [] gorptest: 09:33:07.911618 select * from person_test where Id=-123 [] gorptest: 09:33:07.915794 select * from person_test where Id=-123 [] gorptest: 09:33:07.918272 drop table if exists "invoice_test"; [] gorptest: 09:33:07.955046 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:07.977535 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:08.000135 drop table if exists "invoice_override_test"; [] gorptest: 09:33:08.033023 drop table if exists "person_test"; [] gorptest: 09:33:08.057722 drop table if exists "ignored_column_test"; [] gorptest: 09:33:08.085329 drop table if exists "id_created_test"; [] gorptest: 09:33:08.109265 drop table if exists "type_conv_test"; [] gorptest: 09:33:08.133680 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:08.165045 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:08.193639 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:08.223483 drop table if exists "time_test"; [] gorptest: 09:33:08.248257 drop table if exists "id_created_test"; [] 2023/06/26 09:33:08 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:08.256022 drop table if exists "invoice_test"; [] gorptest: 09:33:08.263883 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:08.265707 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:08.267996 drop table if exists "invoice_override_test"; [] gorptest: 09:33:08.269765 drop table if exists "person_test"; [] gorptest: 09:33:08.271477 drop table if exists "ignored_column_test"; [] gorptest: 09:33:08.273763 drop table if exists "id_created_test"; [] gorptest: 09:33:08.275375 drop table if exists "type_conv_test"; [] gorptest: 09:33:08.277861 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:08.279537 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:08.281137 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:08.283024 drop table if exists "time_test"; [] gorptest: 09:33:08.284768 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:08.309797 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:08.339972 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:08.376284 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:08.410527 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:08.439661 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:08.484982 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:08.520591 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:08.552821 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:08.585094 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:08.609976 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:08.635401 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:08.655010 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 09:33:08.675420 select * from id_created_test where Id=1 [] gorptest: 09:33:08.678884 SELECT *, 1 AS external FROM id_created_test [] gorptest: 09:33:08.682641 drop table if exists "invoice_test"; [] gorptest: 09:33:08.717669 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:08.758315 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:08.778589 drop table if exists "invoice_override_test"; [] gorptest: 09:33:08.809568 drop table if exists "person_test"; [] gorptest: 09:33:08.850092 drop table if exists "ignored_column_test"; [] gorptest: 09:33:08.877103 drop table if exists "id_created_test"; [] gorptest: 09:33:08.901322 drop table if exists "type_conv_test"; [] gorptest: 09:33:08.924830 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:08.951359 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:08.979590 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:09.012200 drop table if exists "time_test"; [] gorptest: 09:33:09.034117 drop table if exists "id_created_test"; [] 2023/06/26 09:33:09 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:09.043355 drop table if exists "invoice_test"; [] gorptest: 09:33:09.057291 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:09.060443 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:09.063686 drop table if exists "invoice_override_test"; [] gorptest: 09:33:09.066596 drop table if exists "person_test"; [] gorptest: 09:33:09.069430 drop table if exists "ignored_column_test"; [] gorptest: 09:33:09.073195 drop table if exists "id_created_test"; [] gorptest: 09:33:09.076775 drop table if exists "type_conv_test"; [] gorptest: 09:33:09.079046 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:09.080941 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:09.084692 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:09.087783 drop table if exists "time_test"; [] gorptest: 09:33:09.090996 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:09.113930 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:09.136060 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:09.158847 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:09.190164 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:09.213193 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:09.235704 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:09.260578 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:09.287806 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:09.312173 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:09.337652 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:09.360918 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:09.388226 drop table if exists "invoice_test"; [] gorptest: 09:33:09.418863 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:09.449084 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:09.478347 drop table if exists "invoice_override_test"; [] gorptest: 09:33:09.521231 drop table if exists "person_test"; [] gorptest: 09:33:09.564381 drop table if exists "ignored_column_test"; [] gorptest: 09:33:09.589044 drop table if exists "id_created_test"; [] gorptest: 09:33:09.617311 drop table if exists "type_conv_test"; [] gorptest: 09:33:09.637973 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:09.660472 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:09.685826 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:09.711497 drop table if exists "time_test"; [] gorptest: 09:33:09.736622 drop table if exists "id_created_test"; [] gorptest: 09:33:09.739154 drop table if exists "single_column_table"; [] gorptest: 09:33:09.743144 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:09.769671 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:09.795492 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:09.823274 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:09.854637 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:09.886912 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:09.916960 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:09.945601 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:09.978510 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:10.011261 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:10.036846 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:10.059650 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:10.086706 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:33:10.091144 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 09:33:10.116716 delete from "invoice_test"; [] gorptest: 09:33:10.138472 delete from "invoice_tag_test"; [] gorptest: 09:33:10.164592 delete from "alias_trans_field_test"; [] gorptest: 09:33:10.189694 delete from "invoice_override_test"; [] gorptest: 09:33:10.214247 delete from "person_test"; [] gorptest: 09:33:10.236891 delete from "ignored_column_test"; [] gorptest: 09:33:10.260420 delete from "id_created_test"; [] gorptest: 09:33:10.290929 delete from "type_conv_test"; [] gorptest: 09:33:10.338480 delete from "embedded_struct_test"; [] gorptest: 09:33:10.367857 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:10.394302 delete from "embedded_autoincr_test"; [] gorptest: 09:33:10.423540 delete from "time_test"; [] gorptest: 09:33:10.453447 delete from "id_created_test"; [] gorptest: 09:33:10.486000 delete from "single_column_table"; [] gorptest: 09:33:10.524006 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 09:33:10.533737 drop table if exists "invoice_test"; [] gorptest: 09:33:10.561521 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:10.592120 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:10.612294 drop table if exists "invoice_override_test"; [] gorptest: 09:33:10.653374 drop table if exists "person_test"; [] gorptest: 09:33:10.688326 drop table if exists "ignored_column_test"; [] gorptest: 09:33:10.721505 drop table if exists "id_created_test"; [] gorptest: 09:33:10.753567 drop table if exists "type_conv_test"; [] gorptest: 09:33:10.786132 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:10.815907 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:10.869032 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:10.900863 drop table if exists "time_test"; [] gorptest: 09:33:10.936904 drop table if exists "id_created_test"; [] gorptest: 09:33:10.939335 drop table if exists "single_column_table"; [] 2023/06/26 09:33:10 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:33:10.983476 drop table if exists "invoice_test"; [] gorptest: 09:33:10.993376 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:10.995468 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:10.997190 drop table if exists "invoice_override_test"; [] gorptest: 09:33:10.999576 drop table if exists "person_test"; [] gorptest: 09:33:11.001605 drop table if exists "ignored_column_test"; [] gorptest: 09:33:11.004294 drop table if exists "id_created_test"; [] gorptest: 09:33:11.006327 drop table if exists "type_conv_test"; [] gorptest: 09:33:11.008933 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:11.010966 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:11.013541 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:11.016115 drop table if exists "time_test"; [] gorptest: 09:33:11.018405 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:11.047135 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:33:11.075864 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:33:11.102840 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:33:11.134687 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:33:11.160940 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:11.189922 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:33:11.212812 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:33:11.233833 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:33:11.255983 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:33:11.278959 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:33:11.303895 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:33:11.328468 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 09:33:11.363667 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 09:33:11.385062 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 09:33:11.410185 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 09:33:11.413997 begin; [] gorptest: 09:33:11.415278 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 09:33:11.422602 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:33:11.433783 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:33:11.435702 commit; [] gorptest: 09:33:11.486607 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:33:11.491118 drop table if exists "invoice_test"; [] gorptest: 09:33:11.517665 drop table if exists "invoice_tag_test"; [] gorptest: 09:33:11.553626 drop table if exists "alias_trans_field_test"; [] gorptest: 09:33:11.574202 drop table if exists "invoice_override_test"; [] gorptest: 09:33:11.600324 drop table if exists "person_test"; [] gorptest: 09:33:11.620360 drop table if exists "ignored_column_test"; [] gorptest: 09:33:11.642646 drop table if exists "id_created_test"; [] gorptest: 09:33:11.662515 drop table if exists "type_conv_test"; [] gorptest: 09:33:11.683461 drop table if exists "embedded_struct_test"; [] gorptest: 09:33:11.703048 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:33:11.722787 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:33:11.744490 drop table if exists "time_test"; [] gorptest: 09:33:11.764017 drop table if exists "id_created_test"; [] PASS ok gopkg.in/gorp.v1 24.489s gopkg.in/gorp.v1 2023/06/26 09:34:35 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:35.816043 drop table if exists "invoice_test"; [] gorptest: 09:34:35.944913 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:35.949284 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:35.950899 drop table if exists "invoice_override_test"; [] gorptest: 09:34:35.954617 drop table if exists "person_test"; [] gorptest: 09:34:35.956212 drop table if exists "ignored_column_test"; [] gorptest: 09:34:35.957694 drop table if exists "id_created_test"; [] gorptest: 09:34:35.959128 drop table if exists "type_conv_test"; [] gorptest: 09:34:35.960649 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:35.962588 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:35.977142 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:35.979236 drop table if exists "time_test"; [] gorptest: 09:34:35.984041 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:36.087733 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:36.122401 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:36.170058 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:36.203775 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:36.241348 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:36.264699 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:36.289247 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:36.317997 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:36.342647 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:36.373286 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:36.397142 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:36.430349 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:36.433513 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:36.435536 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:36.439583 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:36.442441 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:36.444567 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:36.446411 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:36.448239 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:36.450074 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:36.452505 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:36.454358 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:36.456454 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:36.458217 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:34:36.459956 drop table if exists "invoice_test"; [] gorptest: 09:34:36.494980 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:36.528765 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:36.554379 drop table if exists "invoice_override_test"; [] gorptest: 09:34:36.585272 drop table if exists "person_test"; [] gorptest: 09:34:36.611681 drop table if exists "ignored_column_test"; [] gorptest: 09:34:36.639193 drop table if exists "id_created_test"; [] gorptest: 09:34:36.675512 drop table if exists "type_conv_test"; [] gorptest: 09:34:36.700992 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:36.724693 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:36.753544 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:36.785789 drop table if exists "time_test"; [] gorptest: 09:34:36.821995 drop table if exists "id_created_test"; [] 2023/06/26 09:34:36 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:36.844641 drop table if exists "invoice_test"; [] gorptest: 09:34:36.866218 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:36.868424 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:36.870259 drop table if exists "invoice_override_test"; [] gorptest: 09:34:36.872673 drop table if exists "person_test"; [] gorptest: 09:34:36.874410 drop table if exists "ignored_column_test"; [] gorptest: 09:34:36.876043 drop table if exists "id_created_test"; [] gorptest: 09:34:36.878706 drop table if exists "type_conv_test"; [] gorptest: 09:34:36.880743 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:36.882810 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:36.885102 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:36.886870 drop table if exists "time_test"; [] gorptest: 09:34:36.889377 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:36.922773 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:36.954581 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:36.988765 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:37.023505 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:37.054017 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:37.085239 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:37.109783 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:37.133829 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:37.157154 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:37.181388 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:37.206573 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:37.234062 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:37.236550 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:37.238606 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:37.240625 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:37.242842 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:37.245499 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:37.247977 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:37.250117 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:37.252441 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:37.254376 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:37.256276 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:37.258052 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:37.260042 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:34:37.268845 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786477263387889 2:1687786477263387889 3:"Bob" 4:"Smith" 5:1] gorptest: 09:34:37.300622 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 09:34:37.333327 delete from "invoice_test"; [] gorptest: 09:34:37.354234 delete from "invoice_tag_test"; [] gorptest: 09:34:37.373748 delete from "alias_trans_field_test"; [] gorptest: 09:34:37.393785 delete from "invoice_override_test"; [] gorptest: 09:34:37.417760 delete from "person_test"; [] gorptest: 09:34:37.437847 delete from "ignored_column_test"; [] gorptest: 09:34:37.458935 delete from "id_created_test"; [] gorptest: 09:34:37.484230 delete from "type_conv_test"; [] gorptest: 09:34:37.506192 delete from "embedded_struct_test"; [] gorptest: 09:34:37.527762 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:37.550840 delete from "embedded_autoincr_test"; [] gorptest: 09:34:37.571010 delete from "time_test"; [] gorptest: 09:34:37.594001 delete from "id_created_test"; [] gorptest: 09:34:37.617324 SELECT * FROM person_test [] gorptest: 09:34:37.629311 SELECT * FROM invoice_test [] gorptest: 09:34:37.636868 drop table if exists "invoice_test"; [] gorptest: 09:34:37.663003 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:37.687663 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:37.713301 drop table if exists "invoice_override_test"; [] gorptest: 09:34:37.747624 drop table if exists "person_test"; [] gorptest: 09:34:37.775885 drop table if exists "ignored_column_test"; [] gorptest: 09:34:37.798576 drop table if exists "id_created_test"; [] gorptest: 09:34:37.821393 drop table if exists "type_conv_test"; [] gorptest: 09:34:37.845862 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:37.874057 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:37.896119 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:37.923793 drop table if exists "time_test"; [] gorptest: 09:34:37.955450 drop table if exists "id_created_test"; [] gorptest: 09:34:37.964997 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 09:34:38.004088 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2023-06-26 09:34:37 -0400 EDT] gorptest: 09:34:38.027733 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 09:34:38.038354 drop table if exists "WithCustomDate"; [] gorptest: 09:34:38.067211 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:34:38.108222 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:34:38.132326 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 09:34:38.157423 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 09:34:38.189621 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 09:34:38.212265 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 09:34:38.234744 drop table if exists "PersonUInt64"; [] gorptest: 09:34:38.262848 drop table if exists "PersonUInt32"; [] gorptest: 09:34:38.285832 drop table if exists "PersonUInt16"; [] gorptest: 09:34:38.319060 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 09:34:38.350569 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 09:34:38.379685 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 09:34:38.386864 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 09:34:38.390985 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 09:34:38.430105 drop table if exists "UniqueColumns"; [] gorptest: 09:34:38.472922 drop table if exists PersistentUser [] gorptest: 09:34:38.482675 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:34:38.536626 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:34:38.557989 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 09:34:38.564426 select * from PersistentUser [] gorptest: 09:34:38.570218 select * from PersistentUser [] gorptest: 09:34:38.580273 select * from PersistentUser [] gorptest: 09:34:38.585759 select Id from PersistentUser [] gorptest: 09:34:38.588650 select mykey from PersistentUser [] gorptest: 09:34:38.591389 select PassedTraining from PersistentUser [] gorptest: 09:34:38.594061 select Id from PersistentUser [] gorptest: 09:34:38.596467 drop table if exists "PersistentUser"; [] gorptest: 09:34:38.647975 drop table if exists PersistentUser [] gorptest: 09:34:38.656543 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:34:38.686194 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:34:38.711708 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 09:34:38.740543 select * from PersistentUser where mykey = ? [1:43] gorptest: 09:34:38.748075 select * from PersistentUser where mykey = ? [1:43] gorptest: 09:34:38.752787 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 09:34:38.756557 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 09:34:38.759529 drop table if exists "PersistentUser"; [] gorptest: 09:34:38.797689 drop table if exists PersistentUser [] gorptest: 09:34:38.806571 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 09:34:38.837005 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 09:34:38.861391 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 09:34:38.885066 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 09:34:38.889467 drop table if exists "PersistentUser"; [] 2023/06/26 09:34:38 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:38.923580 drop table if exists "invoice_test"; [] gorptest: 09:34:38.932524 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:38.934390 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:38.936184 drop table if exists "invoice_override_test"; [] gorptest: 09:34:38.938868 drop table if exists "person_test"; [] gorptest: 09:34:38.941685 drop table if exists "ignored_column_test"; [] gorptest: 09:34:38.945024 drop table if exists "id_created_test"; [] gorptest: 09:34:38.947781 drop table if exists "type_conv_test"; [] gorptest: 09:34:38.950807 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:38.953988 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:38.956755 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:38.960082 drop table if exists "time_test"; [] gorptest: 09:34:38.963911 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:38.998142 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:39.023145 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:39.049719 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:39.079584 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:39.103850 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:39.126523 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:39.148934 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:39.175246 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:39.197855 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:39.220399 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:39.241727 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:39.268596 select * from invoice_test where id=99999 [] gorptest: 09:34:39.274922 select * from invoice_test where id=99999 [] gorptest: 09:34:39.279607 drop table if exists "invoice_test"; [] gorptest: 09:34:39.314977 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:39.346672 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:39.379142 drop table if exists "invoice_override_test"; [] gorptest: 09:34:39.417561 drop table if exists "person_test"; [] gorptest: 09:34:39.439237 drop table if exists "ignored_column_test"; [] gorptest: 09:34:39.460322 drop table if exists "id_created_test"; [] gorptest: 09:34:39.488180 drop table if exists "type_conv_test"; [] gorptest: 09:34:39.515714 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:39.538161 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:39.560577 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:39.586180 drop table if exists "time_test"; [] gorptest: 09:34:39.609680 drop table if exists "id_created_test"; [] gorptest: 09:34:39.618840 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 09:34:39.652878 update "InvoicePersonView" set "InvoiceId"=?, "PersonId"=?, "Memo"=?, "FName"=?, "LegacyVersion"=? where "InvoiceId"=? and "PersonId"=? and "LegacyVersion"=?; [1:1 2:2 3:"memo" 4:"fname" 5:1 6:1 7:2 8:1] gorptest: 09:34:39.663394 drop table if exists "InvoicePersonView"; [] 2023/06/26 09:34:39 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:39.695478 drop table if exists "invoice_test"; [] gorptest: 09:34:39.704302 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:39.706227 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:39.708026 drop table if exists "invoice_override_test"; [] gorptest: 09:34:39.709721 drop table if exists "person_test"; [] gorptest: 09:34:39.711533 drop table if exists "ignored_column_test"; [] gorptest: 09:34:39.713551 drop table if exists "id_created_test"; [] gorptest: 09:34:39.715219 drop table if exists "type_conv_test"; [] gorptest: 09:34:39.716914 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:39.718594 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:39.720250 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:39.726209 drop table if exists "time_test"; [] gorptest: 09:34:39.728635 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:39.760060 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:39.782634 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:39.818593 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:39.870455 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:39.905263 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:39.930861 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:39.964334 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:39.987993 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:40.010307 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:40.031395 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:40.054424 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:40.085341 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786480084989314 2:1687786480084989314 3:"Bob" 4:"Smith" 5:1] gorptest: 09:34:40.112761 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:40.124235 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786480084989314 2:1687786480084989314 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 09:34:40.169121 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786480084989314 2:1687786480084989314 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 09:34:40.173363 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:40.180696 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 09:34:40.185466 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:40.189219 drop table if exists "invoice_test"; [] gorptest: 09:34:40.211988 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:40.238658 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:40.264560 drop table if exists "invoice_override_test"; [] gorptest: 09:34:40.290113 drop table if exists "person_test"; [] gorptest: 09:34:40.314068 drop table if exists "ignored_column_test"; [] gorptest: 09:34:40.337561 drop table if exists "id_created_test"; [] gorptest: 09:34:40.363504 drop table if exists "type_conv_test"; [] gorptest: 09:34:40.389760 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:40.412863 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:40.439694 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:40.463329 drop table if exists "time_test"; [] gorptest: 09:34:40.492766 drop table if exists "id_created_test"; [] gorptest: 09:34:40.503390 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 09:34:40.534347 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 09:34:40.556541 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 09:34:40.565390 update "TableWithNull" set "Id"=?, "Str"=?, "Int64"=?, "Float64"=?, "Bool"=?, "Bytes"=? where "Id"=?; [1:10 2:"hi" 3:999 4:53.33 5:true 6:[1 30 31 33] 7:10] gorptest: 09:34:40.588816 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 09:34:40.595101 drop table if exists "TableWithNull"; [] gorptest: 09:34:40.625143 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 09:34:40.658941 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 09:34:40.684608 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 09:34:40.688446 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 09:34:40.692701 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 09:34:40.696136 drop table if exists "Invoice"; [] 2023/06/26 09:34:40 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:40.726873 drop table if exists "invoice_test"; [] gorptest: 09:34:40.740443 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:40.743324 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:40.745489 drop table if exists "invoice_override_test"; [] gorptest: 09:34:40.748522 drop table if exists "person_test"; [] gorptest: 09:34:40.750550 drop table if exists "ignored_column_test"; [] gorptest: 09:34:40.753262 drop table if exists "id_created_test"; [] gorptest: 09:34:40.755466 drop table if exists "type_conv_test"; [] gorptest: 09:34:40.757664 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:40.759817 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:40.761774 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:40.764616 drop table if exists "time_test"; [] gorptest: 09:34:40.768421 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:40.794261 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:40.818107 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:40.867445 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:40.904120 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:40.955767 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:40.988568 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:41.014748 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:41.042621 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:41.065093 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:41.087145 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:41.109510 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:41.132619 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786481132161323 2:1687786481132161323 3:"bob" 4:"smith" 5:1] gorptest: 09:34:41.159229 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 09:34:41.185581 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 09:34:41.193221 drop table if exists "invoice_test"; [] gorptest: 09:34:41.217573 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:41.252762 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:41.290103 drop table if exists "invoice_override_test"; [] gorptest: 09:34:41.323510 drop table if exists "person_test"; [] gorptest: 09:34:41.356395 drop table if exists "ignored_column_test"; [] gorptest: 09:34:41.388197 drop table if exists "id_created_test"; [] gorptest: 09:34:41.420126 drop table if exists "type_conv_test"; [] gorptest: 09:34:41.460759 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:41.495853 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:41.527412 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:41.560694 drop table if exists "time_test"; [] gorptest: 09:34:41.592818 drop table if exists "id_created_test"; [] 2023/06/26 09:34:41 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:41.605352 drop table if exists "invoice_test"; [] gorptest: 09:34:41.613137 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:41.615035 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:41.616987 drop table if exists "invoice_override_test"; [] gorptest: 09:34:41.618669 drop table if exists "person_test"; [] gorptest: 09:34:41.620485 drop table if exists "ignored_column_test"; [] gorptest: 09:34:41.622568 drop table if exists "id_created_test"; [] gorptest: 09:34:41.624309 drop table if exists "type_conv_test"; [] gorptest: 09:34:41.625983 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:41.627732 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:41.629381 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:41.631010 drop table if exists "time_test"; [] gorptest: 09:34:41.634020 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:41.658302 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:41.680960 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:41.732512 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:41.776464 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:41.798036 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:41.839952 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:41.885486 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:41.909590 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:41.934122 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:41.974709 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:41.999616 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:42.022482 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786482020856831 2:1687786482020856831 3:"bob" 4:"smith" 5:1] gorptest: 09:34:42.044786 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:42.048188 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1687786482020856831 2:1687786482020856831 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 09:34:42.069100 select * from person_test where id = ? [1:1] gorptest: 09:34:42.074611 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 09:34:42.122010 drop table if exists "invoice_test"; [] gorptest: 09:34:42.150883 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:42.180210 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:42.221005 drop table if exists "invoice_override_test"; [] gorptest: 09:34:42.249028 drop table if exists "person_test"; [] gorptest: 09:34:42.302445 drop table if exists "ignored_column_test"; [] gorptest: 09:34:42.323748 drop table if exists "id_created_test"; [] gorptest: 09:34:42.350974 drop table if exists "type_conv_test"; [] gorptest: 09:34:42.381988 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:42.408058 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:42.456151 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:42.505835 drop table if exists "time_test"; [] gorptest: 09:34:42.534851 drop table if exists "id_created_test"; [] 2023/06/26 09:34:42 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:42.546235 drop table if exists "invoice_test"; [] gorptest: 09:34:42.558328 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:42.561261 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:42.564803 drop table if exists "invoice_override_test"; [] gorptest: 09:34:42.568462 drop table if exists "person_test"; [] gorptest: 09:34:42.571113 drop table if exists "ignored_column_test"; [] gorptest: 09:34:42.574552 drop table if exists "id_created_test"; [] gorptest: 09:34:42.578412 drop table if exists "type_conv_test"; [] gorptest: 09:34:42.581409 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:42.584891 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:42.587999 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:42.590822 drop table if exists "time_test"; [] gorptest: 09:34:42.594545 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:42.624136 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:42.648909 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:42.675813 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:42.708474 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:42.739447 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:42.768055 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:42.796909 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:42.818285 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:42.842294 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:42.867121 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:42.896982 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:42.927533 begin; [] gorptest: 09:34:42.929974 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 09:34:42.937863 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 09:34:42.939280 commit; [] gorptest: 09:34:42.966637 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:42.969921 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 09:34:42.973487 drop table if exists "invoice_test"; [] gorptest: 09:34:43.007959 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:43.039355 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:43.066582 drop table if exists "invoice_override_test"; [] gorptest: 09:34:43.095233 drop table if exists "person_test"; [] gorptest: 09:34:43.117806 drop table if exists "ignored_column_test"; [] gorptest: 09:34:43.142969 drop table if exists "id_created_test"; [] gorptest: 09:34:43.167771 drop table if exists "type_conv_test"; [] gorptest: 09:34:43.195445 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:43.225516 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:43.255876 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:43.287892 drop table if exists "time_test"; [] gorptest: 09:34:43.311430 drop table if exists "id_created_test"; [] 2023/06/26 09:34:43 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:43.318665 drop table if exists "invoice_test"; [] gorptest: 09:34:43.328627 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:43.330697 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:43.332998 drop table if exists "invoice_override_test"; [] gorptest: 09:34:43.334912 drop table if exists "person_test"; [] gorptest: 09:34:43.336884 drop table if exists "ignored_column_test"; [] gorptest: 09:34:43.338495 drop table if exists "id_created_test"; [] gorptest: 09:34:43.341050 drop table if exists "type_conv_test"; [] gorptest: 09:34:43.343056 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:43.344749 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:43.346379 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:43.347998 drop table if exists "time_test"; [] gorptest: 09:34:43.350218 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:43.376863 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:43.404985 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:43.429047 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:43.451336 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:43.473670 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:43.501097 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:43.524371 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:43.549386 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:43.576316 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:43.600089 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:43.630814 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:43.656092 begin; [] gorptest: 09:34:43.657500 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 09:34:43.663984 select memo from invoice_test [] gorptest: 09:34:43.666850 savepoint "foo" [1:] gorptest: 09:34:43.667820 select memo from invoice_test [] gorptest: 09:34:43.669782 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 09:34:43.673129 select memo from invoice_test [] gorptest: 09:34:43.675321 rollback to savepoint "foo" [1:] gorptest: 09:34:43.677325 select memo from invoice_test [] gorptest: 09:34:43.678491 rollback; [] gorptest: 09:34:43.684113 drop table if exists "invoice_test"; [] gorptest: 09:34:43.713282 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:43.745524 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:43.769617 drop table if exists "invoice_override_test"; [] gorptest: 09:34:43.794637 drop table if exists "person_test"; [] gorptest: 09:34:43.817058 drop table if exists "ignored_column_test"; [] gorptest: 09:34:43.841315 drop table if exists "id_created_test"; [] gorptest: 09:34:43.864041 drop table if exists "type_conv_test"; [] gorptest: 09:34:43.886378 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:43.907988 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:43.937754 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:43.964066 drop table if exists "time_test"; [] gorptest: 09:34:43.994308 drop table if exists "id_created_test"; [] 2023/06/26 09:34:43 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:44.000402 drop table if exists "invoice_test"; [] gorptest: 09:34:44.009655 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:44.011746 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:44.014021 drop table if exists "invoice_override_test"; [] gorptest: 09:34:44.015844 drop table if exists "person_test"; [] gorptest: 09:34:44.017798 drop table if exists "ignored_column_test"; [] gorptest: 09:34:44.019424 drop table if exists "id_created_test"; [] gorptest: 09:34:44.021118 drop table if exists "type_conv_test"; [] gorptest: 09:34:44.023233 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:44.024924 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:44.026789 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:44.028860 drop table if exists "time_test"; [] gorptest: 09:34:44.030793 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:44.059001 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:44.085652 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:44.110576 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:44.136057 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:44.159460 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:44.193937 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:44.217193 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:44.245667 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:44.266760 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:44.292497 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:44.316445 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:44.340507 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 09:34:44.362734 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 09:34:44.388710 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 09:34:44.410730 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 09:34:44.434740 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:44.457424 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 09:34:44.478857 drop table if exists "invoice_test"; [] gorptest: 09:34:44.505280 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:44.528201 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:44.552917 drop table if exists "invoice_override_test"; [] gorptest: 09:34:44.578226 drop table if exists "person_test"; [] gorptest: 09:34:44.601276 drop table if exists "ignored_column_test"; [] gorptest: 09:34:44.623698 drop table if exists "id_created_test"; [] gorptest: 09:34:44.646648 drop table if exists "type_conv_test"; [] gorptest: 09:34:44.670031 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:44.694020 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:44.717639 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:44.741480 drop table if exists "time_test"; [] gorptest: 09:34:44.763749 drop table if exists "id_created_test"; [] 2023/06/26 09:34:44 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:44.770199 drop table if exists "invoice_test"; [] gorptest: 09:34:44.780337 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:44.782770 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:44.784581 drop table if exists "invoice_override_test"; [] gorptest: 09:34:44.786709 drop table if exists "person_test"; [] gorptest: 09:34:44.788938 drop table if exists "ignored_column_test"; [] gorptest: 09:34:44.790882 drop table if exists "id_created_test"; [] gorptest: 09:34:44.793141 drop table if exists "type_conv_test"; [] gorptest: 09:34:44.794894 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:44.796631 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:44.798822 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:44.800537 drop table if exists "time_test"; [] gorptest: 09:34:44.803433 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:44.828435 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:44.851956 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:44.873265 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:44.904108 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:44.945159 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:44.968805 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:45.001516 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:45.027863 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:45.053464 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:45.082610 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:45.110589 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:45.139295 delete from invoice_test [] gorptest: 09:34:45.163390 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 09:34:45.190711 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:45.196764 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:8927351303181535882 2:924468280079630656 3:"random 1205599943076925698" 4:0 5:true 6:1] gorptest: 09:34:45.223840 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:45.229341 select * from invoice_test [] gorptest: 09:34:45.236376 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:45.263281 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 09:34:45.269404 delete from invoice_tag_test [] gorptest: 09:34:45.297655 insert into "invoice_tag_test" ("myid","myCreated","date_updated","Memo","person_id","is_Paid") values (null,?,?,?,?,?); [1:300 2:400 3:"some order" 4:33 5:false] gorptest: 09:34:45.329910 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:34:45.337452 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:5505709980567837941 2:9078988633074488319 3:"random 4627030903552456249" 4:33 5:false 6:1] gorptest: 09:34:45.365904 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:34:45.371521 select * from invoice_tag_test [] gorptest: 09:34:45.379626 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:34:45.404856 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 09:34:45.409255 delete from alias_trans_field_test [] gorptest: 09:34:45.498508 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 09:34:45.528073 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:34:45.534512 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 8789614487382857127" 2:1] gorptest: 09:34:45.560630 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:34:45.565974 select * from alias_trans_field_test [] gorptest: 09:34:45.572311 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:34:45.603656 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 09:34:45.608702 drop table if exists "invoice_test"; [] gorptest: 09:34:45.639012 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:45.679116 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:45.715021 drop table if exists "invoice_override_test"; [] gorptest: 09:34:45.755426 drop table if exists "person_test"; [] gorptest: 09:34:45.779828 drop table if exists "ignored_column_test"; [] gorptest: 09:34:45.800357 drop table if exists "id_created_test"; [] gorptest: 09:34:45.825862 drop table if exists "type_conv_test"; [] gorptest: 09:34:45.847867 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:45.888745 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:45.925922 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:45.952429 drop table if exists "time_test"; [] gorptest: 09:34:45.996231 drop table if exists "id_created_test"; [] 2023/06/26 09:34:46 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:46.003232 drop table if exists "invoice_test"; [] gorptest: 09:34:46.010945 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:46.013370 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:46.015261 drop table if exists "invoice_override_test"; [] gorptest: 09:34:46.017312 drop table if exists "person_test"; [] gorptest: 09:34:46.019249 drop table if exists "ignored_column_test"; [] gorptest: 09:34:46.020939 drop table if exists "id_created_test"; [] gorptest: 09:34:46.022900 drop table if exists "type_conv_test"; [] gorptest: 09:34:46.024565 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:46.026206 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:46.027813 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:46.029689 drop table if exists "time_test"; [] gorptest: 09:34:46.031395 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:46.058539 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:46.083862 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:46.108040 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:46.131312 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:46.157859 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:46.201696 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:46.229901 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:46.259789 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:46.282869 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:46.306238 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:46.329344 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:46.378634 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 09:34:46.398992 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:34:46.402446 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:34:46.420702 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 09:34:46.423716 drop table if exists "invoice_test"; [] gorptest: 09:34:46.444691 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:46.491084 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:46.538563 drop table if exists "invoice_override_test"; [] gorptest: 09:34:46.561235 drop table if exists "person_test"; [] gorptest: 09:34:46.583516 drop table if exists "ignored_column_test"; [] gorptest: 09:34:46.606501 drop table if exists "id_created_test"; [] gorptest: 09:34:46.652322 drop table if exists "type_conv_test"; [] gorptest: 09:34:46.674695 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:46.697714 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:46.738831 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:46.762919 drop table if exists "time_test"; [] gorptest: 09:34:46.784499 drop table if exists "id_created_test"; [] 2023/06/26 09:34:46 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:46.790392 drop table if exists "invoice_test"; [] gorptest: 09:34:46.797904 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:46.799577 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:46.801543 drop table if exists "invoice_override_test"; [] gorptest: 09:34:46.804473 drop table if exists "person_test"; [] gorptest: 09:34:46.806105 drop table if exists "ignored_column_test"; [] gorptest: 09:34:46.807698 drop table if exists "id_created_test"; [] gorptest: 09:34:46.809232 drop table if exists "type_conv_test"; [] gorptest: 09:34:46.810941 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:46.813498 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:46.815198 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:46.816836 drop table if exists "time_test"; [] gorptest: 09:34:46.819124 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:46.840280 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:46.860596 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:46.884835 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:46.909731 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:46.930685 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:46.949984 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:46.975500 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:46.995386 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:47.013536 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:47.034367 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:47.053487 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:47.082408 insert into "type_conv_test" ("Id","PersonJSON","Name") values (null,?,?); [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Bob\",\"LName\":\"Smith\",\"Version\":0}" 2:"hi"] gorptest: 09:34:47.101399 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:34:47.110918 update "type_conv_test" set "PersonJSON"=?, "Name"=? where "Id"=?; [1:"{\"Id\":0,\"Created\":0,\"Updated\":0,\"FName\":\"Jane\",\"LName\":\"Doe\",\"Version\":0}" 2:"hi2" 3:1] gorptest: 09:34:47.129370 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:34:47.132854 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 09:34:47.167851 drop table if exists "invoice_test"; [] gorptest: 09:34:47.191486 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:47.212666 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:47.235055 drop table if exists "invoice_override_test"; [] gorptest: 09:34:47.258427 drop table if exists "person_test"; [] gorptest: 09:34:47.279309 drop table if exists "ignored_column_test"; [] gorptest: 09:34:47.303875 drop table if exists "id_created_test"; [] gorptest: 09:34:47.334280 drop table if exists "type_conv_test"; [] gorptest: 09:34:47.355597 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:47.377931 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:47.399180 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:47.423135 drop table if exists "time_test"; [] gorptest: 09:34:47.444099 drop table if exists "id_created_test"; [] 2023/06/26 09:34:47 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:47.452994 drop table if exists "invoice_test"; [] gorptest: 09:34:47.460454 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:47.462522 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:47.464091 drop table if exists "invoice_override_test"; [] gorptest: 09:34:47.465658 drop table if exists "person_test"; [] gorptest: 09:34:47.467247 drop table if exists "ignored_column_test"; [] gorptest: 09:34:47.468788 drop table if exists "id_created_test"; [] gorptest: 09:34:47.470647 drop table if exists "type_conv_test"; [] gorptest: 09:34:47.473907 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:47.475776 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:47.477571 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:47.479131 drop table if exists "time_test"; [] gorptest: 09:34:47.480857 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:47.505967 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:47.527664 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:47.552614 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:47.582568 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:47.615114 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:47.656856 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:47.684404 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:47.709442 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:47.734868 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:47.760393 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:47.783860 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:47.814794 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 09:34:47.840473 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 09:34:47.844505 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 09:34:47.866602 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 09:34:47.869799 select * from embedded_struct_test [] gorptest: 09:34:47.873353 drop table if exists "invoice_test"; [] gorptest: 09:34:47.894338 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:47.918820 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:47.945075 drop table if exists "invoice_override_test"; [] gorptest: 09:34:47.971548 drop table if exists "person_test"; [] gorptest: 09:34:47.998750 drop table if exists "ignored_column_test"; [] gorptest: 09:34:48.034543 drop table if exists "id_created_test"; [] gorptest: 09:34:48.057432 drop table if exists "type_conv_test"; [] gorptest: 09:34:48.078959 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:48.104320 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:48.124844 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:48.146424 drop table if exists "time_test"; [] gorptest: 09:34:48.169483 drop table if exists "id_created_test"; [] 2023/06/26 09:34:48 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:48.176189 drop table if exists "invoice_test"; [] gorptest: 09:34:48.183863 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:48.185681 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:48.187546 drop table if exists "invoice_override_test"; [] gorptest: 09:34:48.189192 drop table if exists "person_test"; [] gorptest: 09:34:48.190803 drop table if exists "ignored_column_test"; [] gorptest: 09:34:48.192732 drop table if exists "id_created_test"; [] gorptest: 09:34:48.194363 drop table if exists "type_conv_test"; [] gorptest: 09:34:48.195933 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:48.197488 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:48.199198 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:48.201715 drop table if exists "time_test"; [] gorptest: 09:34:48.203843 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:48.224569 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:48.251151 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:48.274669 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:48.296267 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:48.318846 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:48.340864 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:48.379443 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:48.408280 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:48.437364 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:48.460961 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:48.488040 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:48.518151 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 09:34:48.556508 drop table if exists "invoice_test"; [] gorptest: 09:34:48.605227 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:48.637218 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:48.669160 drop table if exists "invoice_override_test"; [] gorptest: 09:34:48.708580 drop table if exists "person_test"; [] gorptest: 09:34:48.744217 drop table if exists "ignored_column_test"; [] gorptest: 09:34:48.768563 drop table if exists "id_created_test"; [] gorptest: 09:34:48.790332 drop table if exists "type_conv_test"; [] gorptest: 09:34:48.814023 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:48.843059 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:48.869028 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:48.893573 drop table if exists "time_test"; [] gorptest: 09:34:48.917651 drop table if exists "id_created_test"; [] 2023/06/26 09:34:48 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:48.924191 drop table if exists "invoice_test"; [] gorptest: 09:34:48.931462 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:48.934014 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:48.935888 drop table if exists "invoice_override_test"; [] gorptest: 09:34:48.937549 drop table if exists "person_test"; [] gorptest: 09:34:48.939077 drop table if exists "ignored_column_test"; [] gorptest: 09:34:48.942491 drop table if exists "id_created_test"; [] gorptest: 09:34:48.944324 drop table if exists "type_conv_test"; [] gorptest: 09:34:48.945908 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:48.947515 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:48.949148 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:48.952314 drop table if exists "time_test"; [] gorptest: 09:34:48.954391 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:48.978297 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:49.009837 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:49.045257 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:49.072385 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:49.097487 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:49.122332 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:49.153421 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:49.177969 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:49.209053 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:49.245078 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:49.275658 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:49.302106 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 09:34:49.326255 drop table if exists "invoice_test"; [] gorptest: 09:34:49.349796 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:49.376052 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:49.402655 drop table if exists "invoice_override_test"; [] gorptest: 09:34:49.428671 drop table if exists "person_test"; [] gorptest: 09:34:49.463202 drop table if exists "ignored_column_test"; [] gorptest: 09:34:49.493220 drop table if exists "id_created_test"; [] gorptest: 09:34:49.521197 drop table if exists "type_conv_test"; [] gorptest: 09:34:49.546449 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:49.570631 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:49.599055 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:49.625282 drop table if exists "time_test"; [] gorptest: 09:34:49.649758 drop table if exists "id_created_test"; [] gorptest: 09:34:49.656610 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 09:34:49.689788 insert into "TableWithNull" ("Id","Str","Int64","Float64","Bool","Bytes") values (?,?,?,?,?,?); [1:0 2:"abc" 3:78 4:32.2 5:true 6:[104 105]] gorptest: 09:34:49.714510 select Int64 from TableWithNull where Str='abc' [] gorptest: 09:34:49.717980 select count(*) from TableWithNull [] gorptest: 09:34:49.723842 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 09:34:49.728625 select Int64 from TableWithNull where Str='notfound' [] gorptest: 09:34:49.731852 select Int64 from TableWithNull where Str='abc' [] gorptest: 09:34:49.735430 select Float64 from TableWithNull where Str='abc' [] gorptest: 09:34:49.738453 select min(Float64) from TableWithNull [] gorptest: 09:34:49.747038 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 09:34:49.752130 select Float64 from TableWithNull where Str='notfound' [] gorptest: 09:34:49.755377 select Float64 from TableWithNull where Str='abc' [] gorptest: 09:34:49.759116 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:34:49.762764 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 09:34:49.765657 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:34:49.769431 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 09:34:49.773444 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 09:34:49.776698 select Str from TableWithNull where Int64=? [1:78] gorptest: 09:34:49.779771 drop table if exists "TableWithNull"; [] 2023/06/26 09:34:49 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:49.807875 drop table if exists "invoice_test"; [] gorptest: 09:34:49.820514 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:49.823334 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:49.825530 drop table if exists "invoice_override_test"; [] gorptest: 09:34:49.827625 drop table if exists "person_test"; [] gorptest: 09:34:49.829677 drop table if exists "ignored_column_test"; [] gorptest: 09:34:49.831724 drop table if exists "id_created_test"; [] gorptest: 09:34:49.834131 drop table if exists "type_conv_test"; [] gorptest: 09:34:49.836666 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:49.838904 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:49.842638 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:49.844852 drop table if exists "time_test"; [] gorptest: 09:34:49.847766 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:49.871500 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:49.896060 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:49.921158 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:49.970258 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:49.997551 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:50.019648 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:50.046905 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:50.076129 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:50.100353 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:50.122810 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:50.146909 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:50.176739 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786490176193403 2:1687786490176193403 3:"Bob" 4:"Smith" 5:1] gorptest: 09:34:50.206495 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786490205800403 2:1687786490205800403 3:"Jane" 4:"Smith" 5:1] gorptest: 09:34:50.239146 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786490238665604 2:1687786490238665604 3:"Mike" 4:"Smith" 5:1] gorptest: 09:34:50.270080 drop table if exists "invoice_test"; [] gorptest: 09:34:50.293435 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:50.315094 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:50.336685 drop table if exists "invoice_override_test"; [] gorptest: 09:34:50.359035 drop table if exists "person_test"; [] gorptest: 09:34:50.384509 drop table if exists "ignored_column_test"; [] gorptest: 09:34:50.411286 drop table if exists "id_created_test"; [] gorptest: 09:34:50.435590 drop table if exists "type_conv_test"; [] gorptest: 09:34:50.460515 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:50.490463 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:50.515700 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:50.537486 drop table if exists "time_test"; [] gorptest: 09:34:50.562666 drop table if exists "id_created_test"; [] gorptest: 09:34:50.567924 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 09:34:50.598620 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 09:34:50.626729 drop table if exists "string_pk_test"; [] 2023/06/26 09:34:50 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:50.686936 drop table if exists "invoice_test"; [] gorptest: 09:34:50.695051 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:50.697121 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:50.698881 drop table if exists "invoice_override_test"; [] gorptest: 09:34:50.700588 drop table if exists "person_test"; [] gorptest: 09:34:50.704597 drop table if exists "ignored_column_test"; [] gorptest: 09:34:50.706996 drop table if exists "id_created_test"; [] gorptest: 09:34:50.709342 drop table if exists "type_conv_test"; [] gorptest: 09:34:50.711258 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:50.713394 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:50.715099 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:50.717375 drop table if exists "time_test"; [] gorptest: 09:34:50.719233 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:50.741488 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:50.762976 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:50.784409 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:50.805774 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:50.828022 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:50.849626 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:50.868880 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:50.888902 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:50.912463 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:50.932410 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:50.956585 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:50.982214 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-26 13:03:50.97896591 +0000 UTC] gorptest: 09:34:51.005763 insert into "time_test" ("Id","Time") values (null,?); [1:2023-06-26 13:04:51.97896591 +0000 UTC] gorptest: 09:34:51.033272 SELECT id FROM time_test WHERE Time < ? [1:2023-06-26 13:04:50.97896591 +0000 UTC] gorptest: 09:34:51.037042 drop table if exists "invoice_test"; [] gorptest: 09:34:51.063447 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:51.093579 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:51.119912 drop table if exists "invoice_override_test"; [] gorptest: 09:34:51.155551 drop table if exists "person_test"; [] gorptest: 09:34:51.183520 drop table if exists "ignored_column_test"; [] gorptest: 09:34:51.209393 drop table if exists "id_created_test"; [] gorptest: 09:34:51.242706 drop table if exists "type_conv_test"; [] gorptest: 09:34:51.265664 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:51.297127 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:51.327265 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:51.355424 drop table if exists "time_test"; [] gorptest: 09:34:51.381688 drop table if exists "id_created_test"; [] 2023/06/26 09:34:51 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:51.388542 drop table if exists "invoice_test"; [] gorptest: 09:34:51.396131 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:51.398333 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:51.400104 drop table if exists "invoice_override_test"; [] gorptest: 09:34:51.402191 drop table if exists "person_test"; [] gorptest: 09:34:51.403848 drop table if exists "ignored_column_test"; [] gorptest: 09:34:51.405450 drop table if exists "id_created_test"; [] gorptest: 09:34:51.407545 drop table if exists "type_conv_test"; [] gorptest: 09:34:51.409434 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:51.411561 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:51.413758 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:51.415474 drop table if exists "time_test"; [] gorptest: 09:34:51.417464 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:51.444901 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:51.467773 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:51.494954 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:51.518596 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:51.540896 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:51.565929 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:51.593747 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:51.616162 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:51.643924 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:51.665788 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:51.688003 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:51.712501 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786491711712217 2:1687786491711712217 3:"bob" 4:"smith" 5:1] gorptest: 09:34:51.739251 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 09:34:51.760918 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 09:34:51.764775 drop table if exists "invoice_test"; [] gorptest: 09:34:51.790385 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:51.818397 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:51.859080 drop table if exists "invoice_override_test"; [] gorptest: 09:34:51.898902 drop table if exists "person_test"; [] gorptest: 09:34:51.933748 drop table if exists "ignored_column_test"; [] gorptest: 09:34:51.969493 drop table if exists "id_created_test"; [] gorptest: 09:34:52.081246 drop table if exists "type_conv_test"; [] gorptest: 09:34:52.123409 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:52.166835 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:52.195145 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:52.220996 drop table if exists "time_test"; [] gorptest: 09:34:52.248852 drop table if exists "id_created_test"; [] 2023/06/26 09:34:52 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:52.257014 drop table if exists "invoice_test"; [] gorptest: 09:34:52.267445 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:52.269845 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:52.271740 drop table if exists "invoice_override_test"; [] gorptest: 09:34:52.273920 drop table if exists "person_test"; [] gorptest: 09:34:52.275588 drop table if exists "ignored_column_test"; [] gorptest: 09:34:52.277780 drop table if exists "id_created_test"; [] gorptest: 09:34:52.279836 drop table if exists "type_conv_test"; [] gorptest: 09:34:52.282356 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:52.284296 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:52.286053 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:52.287743 drop table if exists "time_test"; [] gorptest: 09:34:52.289472 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:52.325801 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:52.356791 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:52.389390 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:52.424264 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:52.455365 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:52.483987 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:52.515200 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:52.542793 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:52.565241 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:52.591282 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:52.638684 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] 2023/06/26 09:34:53 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:53.208736 drop table if exists "invoice_test"; [] gorptest: 09:34:53.217461 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:53.219189 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:53.221148 drop table if exists "invoice_override_test"; [] gorptest: 09:34:53.223293 drop table if exists "person_test"; [] gorptest: 09:34:53.225025 drop table if exists "ignored_column_test"; [] gorptest: 09:34:53.227386 drop table if exists "id_created_test"; [] gorptest: 09:34:53.229269 drop table if exists "type_conv_test"; [] gorptest: 09:34:53.231037 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:53.233384 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:53.235115 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:53.236956 drop table if exists "time_test"; [] gorptest: 09:34:53.239606 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:53.261694 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:53.299091 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:53.323407 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:53.346444 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:53.374087 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:53.402346 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:53.445852 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:53.472211 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:53.500089 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:53.524021 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:53.544024 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:53.585561 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786493585012533 2:1687786493585012533 3:"bob" 4:"smith" 5:1] gorptest: 09:34:53.609895 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786493609454433 2:1687786493609454433 3:"jane" 4:"doe" 5:1] gorptest: 09:34:53.631735 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:53.635315 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 09:34:53.641340 select * from person_test where Id=? [1:1] gorptest: 09:34:53.647205 select * from person_test order by fname asc [] gorptest: 09:34:53.655779 drop table if exists "invoice_test"; [] gorptest: 09:34:53.684002 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:53.705899 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:53.728049 drop table if exists "invoice_override_test"; [] gorptest: 09:34:53.753859 drop table if exists "person_test"; [] gorptest: 09:34:53.775558 drop table if exists "ignored_column_test"; [] gorptest: 09:34:53.797868 drop table if exists "id_created_test"; [] gorptest: 09:34:53.821346 drop table if exists "type_conv_test"; [] gorptest: 09:34:53.848135 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:53.871652 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:53.894901 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:53.916460 drop table if exists "time_test"; [] gorptest: 09:34:53.939959 drop table if exists "id_created_test"; [] 2023/06/26 09:34:53 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:53.947154 drop table if exists "invoice_test"; [] gorptest: 09:34:53.955039 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:53.957547 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:53.959404 drop table if exists "invoice_override_test"; [] gorptest: 09:34:53.961669 drop table if exists "person_test"; [] gorptest: 09:34:53.963894 drop table if exists "ignored_column_test"; [] gorptest: 09:34:53.965668 drop table if exists "id_created_test"; [] gorptest: 09:34:53.967578 drop table if exists "type_conv_test"; [] gorptest: 09:34:53.969075 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:53.970733 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:53.972528 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:53.974094 drop table if exists "time_test"; [] gorptest: 09:34:53.976203 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:54.005402 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:54.028650 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:54.050684 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:54.078686 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:54.102262 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:54.128825 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:54.153609 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:54.179924 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:54.204033 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:54.225973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:54.250519 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:54.271643 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786494271306439 2:1687786494271306439 3:"bob" 4:"smith" 5:1] gorptest: 09:34:54.304625 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 09:34:54.308182 select * from person_test where Id=? [1:1] gorptest: 09:34:54.311487 select FName from person_test where Id=? [1:1] gorptest: 09:34:54.315507 select * from person_test where Id=? [1:1] gorptest: 09:34:54.320070 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 09:34:54.323784 select * from person_test where Id=? [1:-2222] gorptest: 09:34:54.326774 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1687786494326481440 2:1687786494326481440 3:"bob" 4:"smith" 5:1] gorptest: 09:34:54.350690 select * from person_test where Fname='bob' [] gorptest: 09:34:54.355280 select * from person_test where Id=-123 [] gorptest: 09:34:54.358044 select * from person_test where Id=-123 [] gorptest: 09:34:54.360274 select * from person_test where Id=-123 [] gorptest: 09:34:54.363099 select * from person_test where Id=-123 [] gorptest: 09:34:54.365406 drop table if exists "invoice_test"; [] gorptest: 09:34:54.393969 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:54.425969 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:54.450203 drop table if exists "invoice_override_test"; [] gorptest: 09:34:54.479432 drop table if exists "person_test"; [] gorptest: 09:34:54.505137 drop table if exists "ignored_column_test"; [] gorptest: 09:34:54.533095 drop table if exists "id_created_test"; [] gorptest: 09:34:54.557820 drop table if exists "type_conv_test"; [] gorptest: 09:34:54.580082 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:54.603029 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:54.624764 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:54.653194 drop table if exists "time_test"; [] gorptest: 09:34:54.679958 drop table if exists "id_created_test"; [] 2023/06/26 09:34:54 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:54.686812 drop table if exists "invoice_test"; [] gorptest: 09:34:54.695058 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:54.697175 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:54.698992 drop table if exists "invoice_override_test"; [] gorptest: 09:34:54.701480 drop table if exists "person_test"; [] gorptest: 09:34:54.703837 drop table if exists "ignored_column_test"; [] gorptest: 09:34:54.706243 drop table if exists "id_created_test"; [] gorptest: 09:34:54.708319 drop table if exists "type_conv_test"; [] gorptest: 09:34:54.710206 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:54.712346 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:54.714162 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:54.715893 drop table if exists "time_test"; [] gorptest: 09:34:54.717941 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:54.746110 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:54.772389 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:54.794850 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:54.816138 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:54.842357 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:54.867895 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:54.910118 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:54.940024 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:54.983400 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:55.005824 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:55.030789 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:55.061228 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 09:34:55.112839 select * from id_created_test where Id=1 [] gorptest: 09:34:55.118873 SELECT *, 1 AS external FROM id_created_test [] gorptest: 09:34:55.126567 drop table if exists "invoice_test"; [] gorptest: 09:34:55.163198 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:55.186178 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:55.210572 drop table if exists "invoice_override_test"; [] gorptest: 09:34:55.240805 drop table if exists "person_test"; [] gorptest: 09:34:55.261563 drop table if exists "ignored_column_test"; [] gorptest: 09:34:55.283966 drop table if exists "id_created_test"; [] gorptest: 09:34:55.307442 drop table if exists "type_conv_test"; [] gorptest: 09:34:55.332495 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:55.382726 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:55.411531 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:55.438591 drop table if exists "time_test"; [] gorptest: 09:34:55.459113 drop table if exists "id_created_test"; [] 2023/06/26 09:34:55 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:55.467542 drop table if exists "invoice_test"; [] gorptest: 09:34:55.475948 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:55.477720 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:55.479276 drop table if exists "invoice_override_test"; [] gorptest: 09:34:55.480788 drop table if exists "person_test"; [] gorptest: 09:34:55.482995 drop table if exists "ignored_column_test"; [] gorptest: 09:34:55.484874 drop table if exists "id_created_test"; [] gorptest: 09:34:55.486616 drop table if exists "type_conv_test"; [] gorptest: 09:34:55.488245 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:55.489829 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:55.491403 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:55.493770 drop table if exists "time_test"; [] gorptest: 09:34:55.495770 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:55.517939 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:55.539059 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:55.565192 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:55.590831 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:55.612474 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:55.632345 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:55.653541 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:55.677585 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:55.705616 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:55.732180 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:55.756652 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:55.779764 drop table if exists "invoice_test"; [] gorptest: 09:34:55.802622 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:55.823309 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:55.845698 drop table if exists "invoice_override_test"; [] gorptest: 09:34:55.872640 drop table if exists "person_test"; [] gorptest: 09:34:55.895728 drop table if exists "ignored_column_test"; [] gorptest: 09:34:55.917045 drop table if exists "id_created_test"; [] gorptest: 09:34:55.938392 drop table if exists "type_conv_test"; [] gorptest: 09:34:55.979475 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:56.007684 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:56.029441 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:56.050024 drop table if exists "time_test"; [] gorptest: 09:34:56.075275 drop table if exists "id_created_test"; [] gorptest: 09:34:56.077701 drop table if exists "single_column_table"; [] gorptest: 09:34:56.079940 create table if not exists "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:56.103703 create table if not exists "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:56.147780 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:56.177543 create table if not exists "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:56.202754 create table if not exists "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:56.227664 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:56.254528 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:56.279549 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:56.301447 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:56.325149 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:56.353508 create table if not exists "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:56.376817 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:56.403040 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 09:34:56.405700 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 09:34:56.434769 delete from "invoice_test"; [] gorptest: 09:34:56.456218 delete from "invoice_tag_test"; [] gorptest: 09:34:56.479253 delete from "alias_trans_field_test"; [] gorptest: 09:34:56.502139 delete from "invoice_override_test"; [] gorptest: 09:34:56.525107 delete from "person_test"; [] gorptest: 09:34:56.545563 delete from "ignored_column_test"; [] gorptest: 09:34:56.566059 delete from "id_created_test"; [] gorptest: 09:34:56.586654 delete from "type_conv_test"; [] gorptest: 09:34:56.606414 delete from "embedded_struct_test"; [] gorptest: 09:34:56.627358 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:56.649670 delete from "embedded_autoincr_test"; [] gorptest: 09:34:56.671427 delete from "time_test"; [] gorptest: 09:34:56.694700 delete from "id_created_test"; [] gorptest: 09:34:56.715581 delete from "single_column_table"; [] gorptest: 09:34:56.743301 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 09:34:56.748772 drop table if exists "invoice_test"; [] gorptest: 09:34:56.768456 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:56.798416 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:56.820918 drop table if exists "invoice_override_test"; [] gorptest: 09:34:56.854422 drop table if exists "person_test"; [] gorptest: 09:34:56.883294 drop table if exists "ignored_column_test"; [] gorptest: 09:34:56.911240 drop table if exists "id_created_test"; [] gorptest: 09:34:56.938982 drop table if exists "type_conv_test"; [] gorptest: 09:34:56.972058 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:57.049902 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:57.082664 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:57.109488 drop table if exists "time_test"; [] gorptest: 09:34:57.140134 drop table if exists "id_created_test"; [] gorptest: 09:34:57.144050 drop table if exists "single_column_table"; [] 2023/06/26 09:34:57 Warning: Automatic mapping of Version struct members to version columns (see optimistic locking) will be deprecated in next version (V2) See: https://github.com/go-gorp/gorp/pull/214 gorptest: 09:34:57.183580 drop table if exists "invoice_test"; [] gorptest: 09:34:57.195704 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:57.198157 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:57.200219 drop table if exists "invoice_override_test"; [] gorptest: 09:34:57.202598 drop table if exists "person_test"; [] gorptest: 09:34:57.204412 drop table if exists "ignored_column_test"; [] gorptest: 09:34:57.206184 drop table if exists "id_created_test"; [] gorptest: 09:34:57.208722 drop table if exists "type_conv_test"; [] gorptest: 09:34:57.210521 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:57.212616 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:57.214331 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:57.215993 drop table if exists "time_test"; [] gorptest: 09:34:57.217898 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:57.246204 create table "invoice_tag_test" ("myid" integer not null primary key autoincrement, "myCreated" integer, "date_updated" integer, "Memo" varchar(255), "person_id" integer, "is_Paid" integer) ; [] gorptest: 09:34:57.274526 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 09:34:57.307146 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 09:34:57.340013 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 09:34:57.373576 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:57.402743 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 09:34:57.430692 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 09:34:57.461497 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 09:34:57.489505 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 09:34:57.514628 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 09:34:57.540465 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 09:34:57.562263 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 09:34:57.583831 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 09:34:57.603085 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 09:34:57.623633 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 09:34:57.627254 begin; [] gorptest: 09:34:57.628099 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 09:34:57.633880 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:34:57.644956 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:34:57.647148 commit; [] gorptest: 09:34:57.668132 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 09:34:57.673030 drop table if exists "invoice_test"; [] gorptest: 09:34:57.695692 drop table if exists "invoice_tag_test"; [] gorptest: 09:34:57.715973 drop table if exists "alias_trans_field_test"; [] gorptest: 09:34:57.738708 drop table if exists "invoice_override_test"; [] gorptest: 09:34:57.766812 drop table if exists "person_test"; [] gorptest: 09:34:57.788043 drop table if exists "ignored_column_test"; [] gorptest: 09:34:57.808363 drop table if exists "id_created_test"; [] gorptest: 09:34:57.827225 drop table if exists "type_conv_test"; [] gorptest: 09:34:57.848923 drop table if exists "embedded_struct_test"; [] gorptest: 09:34:57.877761 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 09:34:57.903561 drop table if exists "embedded_autoincr_test"; [] gorptest: 09:34:57.926705 drop table if exists "time_test"; [] gorptest: 09:34:57.950768 drop table if exists "id_created_test"; [] PASS ok gopkg.in/gorp.v1 22.752s + RPM_EC=0 ++ jobs -p + exit 0 Processing files: golang-gopkg-gorp-1-devel-1.7.2-5.fc38.noarch Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.HgOqAz + umask 022 + cd /builddir/build/BUILD + cd gorp-1.7.2 + DOCDIR=/builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/doc/golang-gopkg-gorp-1-devel + export LC_ALL=C + LC_ALL=C + export DOCDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/doc/golang-gopkg-gorp-1-devel + cp -pr README.md /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/doc/golang-gopkg-gorp-1-devel + RPM_EC=0 ++ jobs -p + exit 0 Executing(%license): /bin/sh -e /var/tmp/rpm-tmp.PitbiN + umask 022 + cd /builddir/build/BUILD + cd gorp-1.7.2 + LICENSEDIR=/builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/licenses/golang-gopkg-gorp-1-devel + export LC_ALL=C + LC_ALL=C + export LICENSEDIR + /usr/bin/mkdir -p /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/licenses/golang-gopkg-gorp-1-devel + cp -pr LICENSE /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64/usr/share/licenses/golang-gopkg-gorp-1-devel + RPM_EC=0 ++ jobs -p + exit 0 grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : Provides: golang(gopkg.in/gorp.v1) = 1.7.2-5.fc38 golang-gopkg-gorp-1-devel = 1.7.2-5.fc38 golang-ipath(gopkg.in/gorp.v1) = 1.7.2-5.fc38 Requires(rpmlib): rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 Requires: go-filesystem Processing files: compat-golang-github-gorp-1-devel-1.7.2-5.fc38.noarch grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : grep: warning: stray \ before : Provides: compat-golang-github-gorp-1-devel = 1.7.2-5.fc38 golang(github.com/go-gorp/gorp/v1) = 1.7.2-5.fc38 golang-symlink(github.com/go-gorp/gorp/v1) = 1.7.2-5.fc38 Requires(rpmlib): rpmlib(CompressedFileNames) <= 3.0.4-1 rpmlib(FileDigests) <= 4.6.0-1 rpmlib(PayloadFilesHavePrefix) <= 4.0-1 Requires: go-filesystem golang-ipath(gopkg.in/gorp.v1) = 1.7.2-5.fc38 Obsoletes: golang-github-gorp-1-devel < 1.7.2-5.fc38 Checking for unpackaged file(s): /usr/lib/rpm/check-files /builddir/build/BUILDROOT/golang-gopkg-gorp-1-1.7.2-5.fc38.riscv64 Wrote: /builddir/build/RPMS/compat-golang-github-gorp-1-devel-1.7.2-5.fc38.noarch.rpm Wrote: /builddir/build/RPMS/golang-gopkg-gorp-1-devel-1.7.2-5.fc38.noarch.rpm Child return code was: 0