Mock Version: 6.1 Mock Version: 6.1 Mock Version: 6.1 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target aarch64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'], chrootPath='/var/lib/mock/f43-build-58424724-6565297/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=201600uid=1000gid=425user='mockbuild'unshare_net=TrueprintOutput=Falsenspawn_args=['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11']) Using nspawn with args ['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11'] Executing command: ['/usr/bin/systemd-nspawn', '-q', '-M', '6d6fc41153704c809c4f4bd6047368b0', '-D', '/var/lib/mock/f43-build-58424724-6565297/root', '-a', '-u', 'mockbuild', '--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11', '--console=pipe', '--setenv=TERM=vt100', '--setenv=SHELL=/bin/bash', '--setenv=HOME=/builddir', '--setenv=HOSTNAME=mock', '--setenv=PATH=/usr/bin:/bin:/usr/sbin:/sbin', '--setenv=PROMPT_COMMAND=printf "\\033]0;\\007"', '--setenv=PS1= \\s-\\v\\$ ', '--setenv=LANG=C.UTF-8', '--resolv-conf=off', 'bash', '--login', '-c', '/usr/bin/rpmbuild -bs --noclean --target aarch64 --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', 'SYSTEMD_NSPAWN_TMPFS_TMP': '0', 'SYSTEMD_SECCOMP': '0'} and shell False Building target platforms: aarch64 Building for target aarch64 setting SOURCE_DATE_EPOCH=1737072000 Wrote: /builddir/build/SRPMS/golang-gopkg-gorp-1-1.7.2-12.fc43.src.rpm Child return code was: 0 ENTER ['do_with_status'](['bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target aarch64 --nodeps /builddir/build/SPECS/golang-gopkg-gorp-1.spec'], chrootPath='/var/lib/mock/f43-build-58424724-6565297/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=201600uid=1000gid=425user='mockbuild'unshare_net=TrueprintOutput=Falsenspawn_args=['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11']) Using nspawn with args ['--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11'] Executing command: ['/usr/bin/systemd-nspawn', '-q', '-M', '461ef4f79f70425abd8f559d9464b8c4', '-D', '/var/lib/mock/f43-build-58424724-6565297/root', '-a', '-u', 'mockbuild', '--capability=cap_ipc_lock', '--bind=/tmp/mock-resolv.asha7tug:/etc/resolv.conf', '--bind=/dev/btrfs-control', '--bind=/dev/mapper/control', '--bind=/dev/fuse', '--bind=/dev/loop-control', '--bind=/dev/loop0', '--bind=/dev/loop1', '--bind=/dev/loop2', '--bind=/dev/loop3', '--bind=/dev/loop4', '--bind=/dev/loop5', '--bind=/dev/loop6', '--bind=/dev/loop7', '--bind=/dev/loop8', '--bind=/dev/loop9', '--bind=/dev/loop10', '--bind=/dev/loop11', '--console=pipe', '--setenv=TERM=vt100', '--setenv=SHELL=/bin/bash', '--setenv=HOME=/builddir', '--setenv=HOSTNAME=mock', '--setenv=PATH=/usr/bin:/bin:/usr/sbin:/sbin', '--setenv=PROMPT_COMMAND=printf "\\033]0;\\007"', '--setenv=PS1= \\s-\\v\\$ ', '--setenv=LANG=C.UTF-8', '--resolv-conf=off', 'bash', '--login', '-c', '/usr/bin/rpmbuild -bb --noclean --target aarch64 --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', 'SYSTEMD_NSPAWN_TMPFS_TMP': '0', 'SYSTEMD_SECCOMP': '0'} and shell False Building target platforms: aarch64 Building for target aarch64 setting SOURCE_DATE_EPOCH=1737072000 Executing(%mkbuilddir): /bin/sh -e /var/tmp/rpm-tmp.xNkpnE Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.yl9eje + umask 022 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-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/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/vendor + [[ ! -e /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin ]] + install -m 0755 -vd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin install: creating directory '/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build' install: creating directory '/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin' + export GOPATH=/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build:/usr/share/gocode + GOPATH=/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build:/usr/share/gocode + [[ ! -e /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 ]] ++ dirname /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + install -m 0755 -vd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src/gopkg.in install: creating directory '/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src' install: creating directory '/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src/gopkg.in' + ln -fs /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2 /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src/gopkg.in/gorp.v1 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-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.xRVytn + umask 022 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build + '[' /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT '!=' / ']' + rm -rf /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT ++ dirname /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT + mkdir -p /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build + mkdir /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT + cd gorp-1.7.2 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-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/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin -s /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build -o golang-gopkg-gorp-1-devel.file-list -O /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2 -V 1.7.2-12.fc43 -p /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT -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/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/gocode/src/github.com/go-gorp/gorp + ln -rs /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/gocode/src/gopkg.in/gorp.v1 /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/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 + /usr/lib/rpm/redhat/brp-python-rpm-in-distinfo + env /usr/lib/rpm/redhat/brp-python-bytecompile '' 1 0 -j12 + /usr/lib/rpm/redhat/brp-python-hardlink + /usr/bin/add-determinism --brp -j12 /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT Scanned 10 directories and 6 files, processed 0 inodes, 0 modified (0 replaced + 0 rewritten), 0 unsupported format, 0 errors Reading /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/SPECPARTS/rpm-debuginfo.specpart Executing(%check): /bin/sh -e /var/tmp/rpm-tmp.8x9vTb + umask 022 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-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 + GO_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,pack-relative-relocs -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/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin -s /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build -V 1.7.2-12.fc43 -p /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT -g /usr/share/gocode -r '.*example.*' Testing in: /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/src PATH: /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/_build/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/sbin GOPATH: /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-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,pack-relative-relocs -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 2025/04/01 13:46: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: 13:46:09.261158 drop table if exists "invoice_test"; [] gorptest: 13:46:09.262741 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.262772 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.262786 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.262799 drop table if exists "person_test"; [] gorptest: 13:46:09.262811 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.262823 drop table if exists "id_created_test"; [] gorptest: 13:46:09.262835 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.262846 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.262859 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.262870 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.262881 drop table if exists "time_test"; [] gorptest: 13:46:09.262925 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.264719 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: 13:46:09.266459 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.267965 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.269490 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.270980 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.272455 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.273934 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.275437 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.276912 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.278400 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.279914 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.281621 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: 13:46:09.281689 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: 13:46:09.281710 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.281729 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: 13:46:09.281748 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: 13:46:09.281763 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.281777 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.281793 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.281809 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.281825 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.281840 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: 13:46:09.281855 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.281873 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:09.281888 drop table if exists "invoice_test"; [] gorptest: 13:46:09.283526 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.285108 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.286613 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.288399 drop table if exists "person_test"; [] gorptest: 13:46:09.289957 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.291520 drop table if exists "id_created_test"; [] gorptest: 13:46:09.293034 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.294614 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.296150 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.297581 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.299050 drop table if exists "time_test"; [] gorptest: 13:46:09.300606 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.300850 drop table if exists "invoice_test"; [] gorptest: 13:46:09.301043 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.301060 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.301073 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.301085 drop table if exists "person_test"; [] gorptest: 13:46:09.301097 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.301125 drop table if exists "id_created_test"; [] gorptest: 13:46:09.301140 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.301152 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.301164 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.301176 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.301189 drop table if exists "time_test"; [] gorptest: 13:46:09.301214 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.303076 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: 13:46:09.304759 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.306335 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.308054 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.309778 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.311515 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.313072 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.314767 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.316567 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.318359 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.320146 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.321946 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: 13:46:09.322001 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: 13:46:09.322019 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.322037 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: 13:46:09.322055 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: 13:46:09.322071 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.322091 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.322108 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.322123 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.322139 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.322155 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: 13:46:09.322171 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.322186 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:09.322279 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515169322211301 2:1743515169322211301 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:09.323974 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 13:46:09.325871 delete from "invoice_test"; [] gorptest: 13:46:09.327531 delete from "invoice_tag_test"; [] gorptest: 13:46:09.329140 delete from "alias_trans_field_test"; [] gorptest: 13:46:09.330787 delete from "invoice_override_test"; [] gorptest: 13:46:09.332750 delete from "person_test"; [] gorptest: 13:46:09.334532 delete from "ignored_column_test"; [] gorptest: 13:46:09.336080 delete from "id_created_test"; [] gorptest: 13:46:09.337705 delete from "type_conv_test"; [] gorptest: 13:46:09.339404 delete from "embedded_struct_test"; [] gorptest: 13:46:09.341065 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.342760 delete from "embedded_autoincr_test"; [] gorptest: 13:46:09.344889 delete from "time_test"; [] gorptest: 13:46:09.346889 delete from "id_created_test"; [] gorptest: 13:46:09.348693 SELECT * FROM person_test [] gorptest: 13:46:09.348810 SELECT * FROM invoice_test [] gorptest: 13:46:09.348861 drop table if exists "invoice_test"; [] gorptest: 13:46:09.350880 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.352854 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.354705 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.356609 drop table if exists "person_test"; [] gorptest: 13:46:09.358587 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.360455 drop table if exists "id_created_test"; [] gorptest: 13:46:09.362396 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.364069 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.365816 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.367469 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.369231 drop table if exists "time_test"; [] gorptest: 13:46:09.370931 drop table if exists "id_created_test"; [] gorptest: 13:46:09.371096 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 13:46:09.373266 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-04-01 13:46:09 +0000 UTC] gorptest: 13:46:09.375045 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 13:46:09.375158 drop table if exists "WithCustomDate"; [] gorptest: 13:46:09.377084 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:09.378964 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:09.380864 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:09.382601 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 13:46:09.384625 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 13:46:09.386448 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 13:46:09.388178 drop table if exists "PersonUInt64"; [] gorptest: 13:46:09.390060 drop table if exists "PersonUInt32"; [] gorptest: 13:46:09.391979 drop table if exists "PersonUInt16"; [] gorptest: 13:46:09.394338 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 13:46:09.396715 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 13:46:09.399146 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 13:46:09.399229 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 13:46:09.399278 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 13:46:09.401328 drop table if exists "UniqueColumns"; [] gorptest: 13:46:09.403374 drop table if exists PersistentUser [] gorptest: 13:46:09.403591 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:09.405432 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:09.407187 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 13:46:09.407281 select * from PersistentUser [] gorptest: 13:46:09.407326 select * from PersistentUser [] gorptest: 13:46:09.407354 select * from PersistentUser [] gorptest: 13:46:09.407382 select Id from PersistentUser [] gorptest: 13:46:09.407428 select mykey from PersistentUser [] gorptest: 13:46:09.407457 select PassedTraining from PersistentUser [] gorptest: 13:46:09.407479 select Id from PersistentUser [] gorptest: 13:46:09.407499 drop table if exists "PersistentUser"; [] gorptest: 13:46:09.409402 drop table if exists PersistentUser [] gorptest: 13:46:09.409601 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:09.411593 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:09.413346 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 13:46:09.415401 select * from PersistentUser where mykey = ? [1:43] gorptest: 13:46:09.415511 select * from PersistentUser where mykey = ? [1:43] gorptest: 13:46:09.415549 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 13:46:09.415588 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 13:46:09.415619 drop table if exists "PersistentUser"; [] gorptest: 13:46:09.417434 drop table if exists PersistentUser [] gorptest: 13:46:09.417629 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:09.419610 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:09.421623 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 13:46:09.423443 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 13:46:09.423549 drop table if exists "PersistentUser"; [] 2025/04/01 13:46: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: 13:46:09.425658 drop table if exists "invoice_test"; [] gorptest: 13:46:09.425810 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.425826 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.425838 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.425851 drop table if exists "person_test"; [] gorptest: 13:46:09.425863 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.425883 drop table if exists "id_created_test"; [] gorptest: 13:46:09.425922 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.425939 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.425960 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.425974 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.426037 drop table if exists "time_test"; [] gorptest: 13:46:09.426153 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.428300 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: 13:46:09.430475 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.432333 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.434315 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.436271 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.438170 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.440168 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.442109 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.444010 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.445953 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.448006 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.449826 select * from invoice_test where id=99999 [] gorptest: 13:46:09.449987 select * from invoice_test where id=99999 [] gorptest: 13:46:09.450027 drop table if exists "invoice_test"; [] gorptest: 13:46:09.452164 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.454014 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.456031 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.458018 drop table if exists "person_test"; [] gorptest: 13:46:09.459964 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.461693 drop table if exists "id_created_test"; [] gorptest: 13:46:09.463929 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.465999 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.467717 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.469558 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.471302 drop table if exists "time_test"; [] gorptest: 13:46:09.473043 drop table if exists "id_created_test"; [] gorptest: 13:46:09.473234 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 13:46:09.475449 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: 13:46:09.475551 drop table if exists "InvoicePersonView"; [] 2025/04/01 13:46: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: 13:46:09.477660 drop table if exists "invoice_test"; [] gorptest: 13:46:09.477821 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.477845 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.477858 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.477871 drop table if exists "person_test"; [] gorptest: 13:46:09.477883 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.477926 drop table if exists "id_created_test"; [] gorptest: 13:46:09.477943 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.477955 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.477967 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.477979 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.477991 drop table if exists "time_test"; [] gorptest: 13:46:09.478008 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.479883 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: 13:46:09.481977 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.484033 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.486007 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.487823 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.489703 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.491575 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.493616 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.495676 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.497552 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.499570 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.501685 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515169501654924 2:1743515169501654924 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:09.503491 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:09.503596 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515169501654924 2:1743515169501654924 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 13:46:09.505557 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515169501654924 2:1743515169501654924 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 13:46:09.505649 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:09.505719 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 13:46:09.505761 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:09.505791 drop table if exists "invoice_test"; [] gorptest: 13:46:09.507395 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.509122 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.510853 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.512758 drop table if exists "person_test"; [] gorptest: 13:46:09.514593 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.516428 drop table if exists "id_created_test"; [] gorptest: 13:46:09.518120 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.519883 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.521700 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.523459 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.525331 drop table if exists "time_test"; [] gorptest: 13:46:09.527120 drop table if exists "id_created_test"; [] gorptest: 13:46:09.527307 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 13:46:09.529384 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 13:46:09.531200 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 13:46:09.531324 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: 13:46:09.532797 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 13:46:09.532886 drop table if exists "TableWithNull"; [] gorptest: 13:46:09.534557 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 13:46:09.536379 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 13:46:09.537964 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 13:46:09.538052 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 13:46:09.538094 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 13:46:09.538119 drop table if exists "Invoice"; [] 2025/04/01 13:46: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: 13:46:09.539953 drop table if exists "invoice_test"; [] gorptest: 13:46:09.540107 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.540132 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.540145 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.540157 drop table if exists "person_test"; [] gorptest: 13:46:09.540170 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.540182 drop table if exists "id_created_test"; [] gorptest: 13:46:09.540194 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.540206 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.540218 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.540230 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.540243 drop table if exists "time_test"; [] gorptest: 13:46:09.540259 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.541969 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: 13:46:09.543589 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.545441 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.547373 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.549233 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.550933 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.552649 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.554486 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.556227 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.558143 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.560006 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.561998 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515169561980777 2:1743515169561980777 3:"bob" 4:"smith" 5:1] gorptest: 13:46:09.563762 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 13:46:09.565802 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 13:46:09.565933 drop table if exists "invoice_test"; [] gorptest: 13:46:09.567672 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.569591 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.571592 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.573439 drop table if exists "person_test"; [] gorptest: 13:46:09.575378 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.577175 drop table if exists "id_created_test"; [] gorptest: 13:46:09.578972 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.580762 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.582525 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.584426 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.586307 drop table if exists "time_test"; [] gorptest: 13:46:09.588112 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.588322 drop table if exists "invoice_test"; [] gorptest: 13:46:09.588473 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.588494 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.588506 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.588520 drop table if exists "person_test"; [] gorptest: 13:46:09.588531 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.588543 drop table if exists "id_created_test"; [] gorptest: 13:46:09.588555 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.588566 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.588579 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.588591 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.588603 drop table if exists "time_test"; [] gorptest: 13:46:09.588630 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.590559 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: 13:46:09.592458 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.594418 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.596554 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.598531 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.600506 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.602482 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.604391 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.606212 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.608116 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.609971 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.611789 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515169611771643 2:1743515169611771643 3:"bob" 4:"smith" 5:1] gorptest: 13:46:09.613498 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:09.613599 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515169611771643 2:1743515169611771643 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 13:46:09.615315 select * from person_test where id = ? [1:1] gorptest: 13:46:09.615419 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 13:46:09.617035 drop table if exists "invoice_test"; [] gorptest: 13:46:09.618838 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.620756 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.622392 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.624181 drop table if exists "person_test"; [] gorptest: 13:46:09.626089 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.627825 drop table if exists "id_created_test"; [] gorptest: 13:46:09.629653 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.631668 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.633560 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.635327 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.637281 drop table if exists "time_test"; [] gorptest: 13:46:09.639044 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.639277 drop table if exists "invoice_test"; [] gorptest: 13:46:09.639433 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.639447 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.639460 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.639473 drop table if exists "person_test"; [] gorptest: 13:46:09.639484 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.639496 drop table if exists "id_created_test"; [] gorptest: 13:46:09.639508 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.639520 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.639532 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.639544 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.639556 drop table if exists "time_test"; [] gorptest: 13:46:09.639574 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.641646 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: 13:46:09.643594 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.645536 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.648047 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.650603 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.652802 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.655203 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.657223 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.659283 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.661446 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.663516 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.665543 begin; [] gorptest: 13:46:09.665621 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 13:46:09.665779 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 13:46:09.665820 commit; [] gorptest: 13:46:09.667713 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.667818 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 13:46:09.667853 drop table if exists "invoice_test"; [] gorptest: 13:46:09.670030 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.672201 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.674229 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.676337 drop table if exists "person_test"; [] gorptest: 13:46:09.678319 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.680313 drop table if exists "id_created_test"; [] gorptest: 13:46:09.682330 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.684196 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.686182 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.688309 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.690402 drop table if exists "time_test"; [] gorptest: 13:46:09.692314 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.692550 drop table if exists "invoice_test"; [] gorptest: 13:46:09.692713 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.692729 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.692742 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.692756 drop table if exists "person_test"; [] gorptest: 13:46:09.692768 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.692779 drop table if exists "id_created_test"; [] gorptest: 13:46:09.692791 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.692802 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.692815 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.692827 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.692839 drop table if exists "time_test"; [] gorptest: 13:46:09.692858 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.695092 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: 13:46:09.697091 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.699108 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.701212 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.703337 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.705535 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.708222 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.710599 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.712834 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.714787 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.716934 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.718915 begin; [] gorptest: 13:46:09.718985 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 13:46:09.719130 select memo from invoice_test [] gorptest: 13:46:09.719187 savepoint "foo" [1:] gorptest: 13:46:09.719196 select memo from invoice_test [] gorptest: 13:46:09.719229 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 13:46:09.719260 select memo from invoice_test [] gorptest: 13:46:09.719274 rollback to savepoint "foo" [1:] gorptest: 13:46:09.719283 select memo from invoice_test [] gorptest: 13:46:09.719293 rollback; [] gorptest: 13:46:09.719380 drop table if exists "invoice_test"; [] gorptest: 13:46:09.721403 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.723362 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.725089 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.726892 drop table if exists "person_test"; [] gorptest: 13:46:09.728673 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.730488 drop table if exists "id_created_test"; [] gorptest: 13:46:09.732359 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.734151 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.735926 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.737661 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.740072 drop table if exists "time_test"; [] gorptest: 13:46:09.741969 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.742226 drop table if exists "invoice_test"; [] gorptest: 13:46:09.742414 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.742441 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.742455 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.742468 drop table if exists "person_test"; [] gorptest: 13:46:09.742480 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.742492 drop table if exists "id_created_test"; [] gorptest: 13:46:09.742504 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.742516 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.742528 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.742540 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.742552 drop table if exists "time_test"; [] gorptest: 13:46:09.742572 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.744768 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: 13:46:09.747046 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.749001 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.751076 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.753038 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.755056 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.757289 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.759228 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.761414 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.763381 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.765405 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.767172 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 13:46:09.769049 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 13:46:09.770960 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 13:46:09.772937 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 13:46:09.774960 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.776774 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 13:46:09.778747 drop table if exists "invoice_test"; [] gorptest: 13:46:09.780957 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.783010 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.785029 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.787216 drop table if exists "person_test"; [] gorptest: 13:46:09.789208 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.791299 drop table if exists "id_created_test"; [] gorptest: 13:46:09.793392 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.795427 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.797476 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.799421 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.801442 drop table if exists "time_test"; [] gorptest: 13:46:09.803349 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.803594 drop table if exists "invoice_test"; [] gorptest: 13:46:09.803762 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.803777 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.803799 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.803813 drop table if exists "person_test"; [] gorptest: 13:46:09.803826 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.803838 drop table if exists "id_created_test"; [] gorptest: 13:46:09.803849 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.803862 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.803874 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.803886 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.803929 drop table if exists "time_test"; [] gorptest: 13:46:09.803951 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.806041 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: 13:46:09.808203 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.810105 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.812152 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.814136 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.816400 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.818459 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.820523 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.822587 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.824968 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.827013 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.828994 delete from invoice_test [] gorptest: 13:46:09.830840 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 13:46:09.832844 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.833034 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:1349137931045699640 2:2737242269957057574 3:"random 8012004325483845317" 4:0 5:true 6:1] gorptest: 13:46:09.835010 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.835110 select * from invoice_test [] gorptest: 13:46:09.835184 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.837197 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:09.837276 delete from invoice_tag_test [] gorptest: 13:46:09.839386 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: 13:46:09.841439 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:09.841550 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:7237761871821373959 2:8035764630364442236 3:"random 3325253583017690507" 4:33 5:false 6:1] gorptest: 13:46:09.843531 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:09.843625 select * from invoice_tag_test [] gorptest: 13:46:09.843681 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:09.845721 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:09.845800 delete from alias_trans_field_test [] gorptest: 13:46:09.847819 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 13:46:09.849777 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:09.849873 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 2948172317754861987" 2:1] gorptest: 13:46:09.851841 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:09.851949 select * from alias_trans_field_test [] gorptest: 13:46:09.851996 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:09.853879 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:09.853976 drop table if exists "invoice_test"; [] gorptest: 13:46:09.856011 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.858060 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.860038 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.861982 drop table if exists "person_test"; [] gorptest: 13:46:09.863848 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.865992 drop table if exists "id_created_test"; [] gorptest: 13:46:09.868066 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.870154 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.872116 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.874282 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.876197 drop table if exists "time_test"; [] gorptest: 13:46:09.878180 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.878417 drop table if exists "invoice_test"; [] gorptest: 13:46:09.878585 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.878622 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.878635 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.878648 drop table if exists "person_test"; [] gorptest: 13:46:09.878666 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.878678 drop table if exists "id_created_test"; [] gorptest: 13:46:09.878691 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.878702 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.878714 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.878727 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.878738 drop table if exists "time_test"; [] gorptest: 13:46:09.878758 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.880847 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: 13:46:09.882778 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.884837 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.886950 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.888973 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.891159 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.893171 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.895109 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.897070 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.899011 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.900975 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.902858 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 13:46:09.905140 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:09.905239 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:09.907066 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:09.907144 drop table if exists "invoice_test"; [] gorptest: 13:46:09.909118 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.910993 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.912881 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.914887 drop table if exists "person_test"; [] gorptest: 13:46:09.916985 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.918985 drop table if exists "id_created_test"; [] gorptest: 13:46:09.920833 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.922616 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.924776 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.926777 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.928692 drop table if exists "time_test"; [] gorptest: 13:46:09.930585 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.930811 drop table if exists "invoice_test"; [] gorptest: 13:46:09.931006 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.931023 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.931036 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.931048 drop table if exists "person_test"; [] gorptest: 13:46:09.931061 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.931073 drop table if exists "id_created_test"; [] gorptest: 13:46:09.931085 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.931121 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.931138 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.931150 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.931163 drop table if exists "time_test"; [] gorptest: 13:46:09.931183 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.933172 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: 13:46:09.935111 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.937263 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.939470 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.941646 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.943560 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.945631 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:09.947548 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:09.949537 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:09.951660 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:09.953668 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:09.955746 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: 13:46:09.957622 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:09.957777 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: 13:46:09.959567 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:09.959671 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:09.961837 drop table if exists "invoice_test"; [] gorptest: 13:46:09.963718 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.965697 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.967687 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.969740 drop table if exists "person_test"; [] gorptest: 13:46:09.971725 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.973590 drop table if exists "id_created_test"; [] gorptest: 13:46:09.975382 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.977326 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.979316 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.981417 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.983205 drop table if exists "time_test"; [] gorptest: 13:46:09.985063 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:09.985299 drop table if exists "invoice_test"; [] gorptest: 13:46:09.985474 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:09.985490 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:09.985503 drop table if exists "invoice_override_test"; [] gorptest: 13:46:09.985516 drop table if exists "person_test"; [] gorptest: 13:46:09.985528 drop table if exists "ignored_column_test"; [] gorptest: 13:46:09.985540 drop table if exists "id_created_test"; [] gorptest: 13:46:09.985552 drop table if exists "type_conv_test"; [] gorptest: 13:46:09.985564 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:09.985577 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:09.985589 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:09.985601 drop table if exists "time_test"; [] gorptest: 13:46:09.985624 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.987865 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: 13:46:09.989849 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:09.991960 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:09.993991 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:09.996035 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:09.998032 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.000090 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.002125 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.004006 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.006113 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.008093 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.010059 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 13:46:10.012426 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 13:46:10.012533 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 13:46:10.015094 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 13:46:10.015192 select * from embedded_struct_test [] gorptest: 13:46:10.015241 drop table if exists "invoice_test"; [] gorptest: 13:46:10.017155 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.019166 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.021100 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.023463 drop table if exists "person_test"; [] gorptest: 13:46:10.025381 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.027274 drop table if exists "id_created_test"; [] gorptest: 13:46:10.029362 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.031283 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.036236 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.039217 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.041641 drop table if exists "time_test"; [] gorptest: 13:46:10.043464 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.043698 drop table if exists "invoice_test"; [] gorptest: 13:46:10.043869 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.043884 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.043916 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.043930 drop table if exists "person_test"; [] gorptest: 13:46:10.043943 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.043955 drop table if exists "id_created_test"; [] gorptest: 13:46:10.043967 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.043980 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.043992 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.044004 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.044016 drop table if exists "time_test"; [] gorptest: 13:46:10.044048 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.045871 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: 13:46:10.047716 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.049685 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.051514 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.053371 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.055473 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.057287 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.059110 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.061076 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.062973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.064839 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.066862 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 13:46:10.068851 drop table if exists "invoice_test"; [] gorptest: 13:46:10.070592 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.072407 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.074069 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.075789 drop table if exists "person_test"; [] gorptest: 13:46:10.077731 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.079347 drop table if exists "id_created_test"; [] gorptest: 13:46:10.081006 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.082605 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.084394 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.086227 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.087796 drop table if exists "time_test"; [] gorptest: 13:46:10.089378 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.089619 drop table if exists "invoice_test"; [] gorptest: 13:46:10.089791 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.089816 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.089837 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.089850 drop table if exists "person_test"; [] gorptest: 13:46:10.089862 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.089874 drop table if exists "id_created_test"; [] gorptest: 13:46:10.089886 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.089916 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.089930 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.089942 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.089954 drop table if exists "time_test"; [] gorptest: 13:46:10.089973 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.092065 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: 13:46:10.093865 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.095700 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.097523 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.099232 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.100950 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.102632 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.104609 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.106480 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.108180 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.109943 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.111668 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 13:46:10.113438 drop table if exists "invoice_test"; [] gorptest: 13:46:10.115224 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.116992 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.118676 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.120406 drop table if exists "person_test"; [] gorptest: 13:46:10.121985 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.123747 drop table if exists "id_created_test"; [] gorptest: 13:46:10.125411 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.127270 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.129201 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.130838 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.132696 drop table if exists "time_test"; [] gorptest: 13:46:10.134459 drop table if exists "id_created_test"; [] gorptest: 13:46:10.134667 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 13:46:10.136742 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: 13:46:10.138765 select Int64 from TableWithNull where Str='abc' [] gorptest: 13:46:10.138852 select count(*) from TableWithNull [] gorptest: 13:46:10.138882 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 13:46:10.138925 select Int64 from TableWithNull where Str='notfound' [] gorptest: 13:46:10.138949 select Int64 from TableWithNull where Str='abc' [] gorptest: 13:46:10.138968 select Float64 from TableWithNull where Str='abc' [] gorptest: 13:46:10.138986 select min(Float64) from TableWithNull [] gorptest: 13:46:10.139011 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 13:46:10.139032 select Float64 from TableWithNull where Str='notfound' [] gorptest: 13:46:10.139067 select Float64 from TableWithNull where Str='abc' [] gorptest: 13:46:10.139088 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:10.139108 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 13:46:10.139126 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:10.139144 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 13:46:10.139217 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 13:46:10.139242 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:10.139264 drop table if exists "TableWithNull"; [] 2025/04/01 13:46: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: 13:46:10.141255 drop table if exists "invoice_test"; [] gorptest: 13:46:10.141416 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.141431 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.141443 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.141455 drop table if exists "person_test"; [] gorptest: 13:46:10.141496 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.141509 drop table if exists "id_created_test"; [] gorptest: 13:46:10.141521 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.141533 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.141545 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.141562 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.141575 drop table if exists "time_test"; [] gorptest: 13:46:10.141593 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.143719 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: 13:46:10.145739 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.147736 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.149802 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.151844 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.154040 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.156061 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.158205 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.160196 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.162460 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.164692 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.166583 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170166564958 2:1743515170166564958 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:10.168596 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170168583859 2:1743515170168583859 3:"Jane" 4:"Smith" 5:1] gorptest: 13:46:10.170517 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170170505678 2:1743515170170505678 3:"Mike" 4:"Smith" 5:1] gorptest: 13:46:10.172666 drop table if exists "invoice_test"; [] gorptest: 13:46:10.174542 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.176441 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.178511 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.180323 drop table if exists "person_test"; [] gorptest: 13:46:10.182244 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.184144 drop table if exists "id_created_test"; [] gorptest: 13:46:10.186004 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.187809 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.189676 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.192331 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.194130 drop table if exists "time_test"; [] gorptest: 13:46:10.195859 drop table if exists "id_created_test"; [] gorptest: 13:46:10.196059 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 13:46:10.198038 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 13:46:10.199700 drop table if exists "string_pk_test"; [] 2025/04/01 13:46: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: 13:46:10.202111 drop table if exists "invoice_test"; [] gorptest: 13:46:10.202281 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.202296 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.202308 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.202321 drop table if exists "person_test"; [] gorptest: 13:46:10.202333 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.202345 drop table if exists "id_created_test"; [] gorptest: 13:46:10.202365 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.202377 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.202389 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.202400 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.202423 drop table if exists "time_test"; [] gorptest: 13:46:10.202443 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.204288 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: 13:46:10.206049 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.207833 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.209658 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.211782 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.213582 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.215377 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.217271 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.219260 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.221178 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.222839 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.224718 insert into "time_test" ("Id","Time") values (null,?); [1:2025-04-01 13:15:10.224698709 +0000 UTC] gorptest: 13:46:10.226533 insert into "time_test" ("Id","Time") values (null,?); [1:2025-04-01 13:16:11.224698709 +0000 UTC] gorptest: 13:46:10.228497 SELECT id FROM time_test WHERE Time < ? [1:2025-04-01 13:16:10.224698709 +0000 UTC] gorptest: 13:46:10.228593 drop table if exists "invoice_test"; [] gorptest: 13:46:10.230300 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.232108 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.233891 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.235753 drop table if exists "person_test"; [] gorptest: 13:46:10.237569 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.239352 drop table if exists "id_created_test"; [] gorptest: 13:46:10.241174 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.242925 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.244649 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.246492 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.248129 drop table if exists "time_test"; [] gorptest: 13:46:10.249949 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.250156 drop table if exists "invoice_test"; [] gorptest: 13:46:10.250316 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.250330 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.250343 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.250356 drop table if exists "person_test"; [] gorptest: 13:46:10.250373 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.250385 drop table if exists "id_created_test"; [] gorptest: 13:46:10.250397 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.250408 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.250420 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.250432 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.250444 drop table if exists "time_test"; [] gorptest: 13:46:10.250463 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.252269 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: 13:46:10.254049 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.256133 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.257957 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.260128 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.262000 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.264023 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.265939 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.267965 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.269985 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.271870 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.273861 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170273832888 2:1743515170273832888 3:"bob" 4:"smith" 5:1] gorptest: 13:46:10.275994 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 13:46:10.277829 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 13:46:10.277969 drop table if exists "invoice_test"; [] gorptest: 13:46:10.279844 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.281637 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.283474 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.285236 drop table if exists "person_test"; [] gorptest: 13:46:10.287004 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.288721 drop table if exists "id_created_test"; [] gorptest: 13:46:10.290497 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.292384 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.294093 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.295996 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.297640 drop table if exists "time_test"; [] gorptest: 13:46:10.299750 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.300008 drop table if exists "invoice_test"; [] gorptest: 13:46:10.300198 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.300214 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.300227 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.300239 drop table if exists "person_test"; [] gorptest: 13:46:10.300251 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.300263 drop table if exists "id_created_test"; [] gorptest: 13:46:10.300275 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.300287 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.300299 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.300311 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.300323 drop table if exists "time_test"; [] gorptest: 13:46:10.300342 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.302251 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: 13:46:10.304040 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.306242 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.308040 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.309966 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.311930 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.314049 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.315983 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.318013 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.319840 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.321990 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] 2025/04/01 13:46: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: 13:46:10.349766 drop table if exists "invoice_test"; [] gorptest: 13:46:10.349971 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.349988 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.350000 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.350012 drop table if exists "person_test"; [] gorptest: 13:46:10.350024 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.350036 drop table if exists "id_created_test"; [] gorptest: 13:46:10.350048 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.350060 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.350072 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.350083 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.350096 drop table if exists "time_test"; [] gorptest: 13:46:10.350114 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.351986 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: 13:46:10.353942 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.355777 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.357630 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.359694 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.361598 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.363674 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.365778 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.367860 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.369996 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.371984 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.373818 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170373798623 2:1743515170373798623 3:"bob" 4:"smith" 5:1] gorptest: 13:46:10.375726 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170375698003 2:1743515170375698003 3:"jane" 4:"doe" 5:1] gorptest: 13:46:10.377716 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:10.377809 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 13:46:10.377852 select * from person_test where Id=? [1:1] gorptest: 13:46:10.377923 select * from person_test order by fname asc [] gorptest: 13:46:10.378010 drop table if exists "invoice_test"; [] gorptest: 13:46:10.379944 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.381847 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.383600 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.385607 drop table if exists "person_test"; [] gorptest: 13:46:10.387575 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.389331 drop table if exists "id_created_test"; [] gorptest: 13:46:10.391131 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.392852 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.394660 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.396468 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.398241 drop table if exists "time_test"; [] gorptest: 13:46:10.400008 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.400252 drop table if exists "invoice_test"; [] gorptest: 13:46:10.400418 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.400434 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.400447 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.400459 drop table if exists "person_test"; [] gorptest: 13:46:10.400471 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.400482 drop table if exists "id_created_test"; [] gorptest: 13:46:10.400495 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.400506 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.400518 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.400530 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.400541 drop table if exists "time_test"; [] gorptest: 13:46:10.400560 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.402594 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: 13:46:10.404527 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.406758 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.408815 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.410716 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.412751 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.414556 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.416462 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.418374 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.420349 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.422182 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.424111 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170424092454 2:1743515170424092454 3:"bob" 4:"smith" 5:1] gorptest: 13:46:10.425986 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:10.426088 select * from person_test where Id=? [1:1] gorptest: 13:46:10.426151 select FName from person_test where Id=? [1:1] gorptest: 13:46:10.426176 select * from person_test where Id=? [1:1] gorptest: 13:46:10.426215 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 13:46:10.426250 select * from person_test where Id=? [1:-2222] gorptest: 13:46:10.426286 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515170426280596 2:1743515170426280596 3:"bob" 4:"smith" 5:1] gorptest: 13:46:10.428219 select * from person_test where Fname='bob' [] gorptest: 13:46:10.428327 select * from person_test where Id=-123 [] gorptest: 13:46:10.428351 select * from person_test where Id=-123 [] gorptest: 13:46:10.428369 select * from person_test where Id=-123 [] gorptest: 13:46:10.428386 select * from person_test where Id=-123 [] gorptest: 13:46:10.428405 drop table if exists "invoice_test"; [] gorptest: 13:46:10.430196 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.431940 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.433675 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.435562 drop table if exists "person_test"; [] gorptest: 13:46:10.437373 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.439057 drop table if exists "id_created_test"; [] gorptest: 13:46:10.440771 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.442934 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.444940 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.446936 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.448787 drop table if exists "time_test"; [] gorptest: 13:46:10.450649 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.450933 drop table if exists "invoice_test"; [] gorptest: 13:46:10.451131 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.451148 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.451161 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.451172 drop table if exists "person_test"; [] gorptest: 13:46:10.451185 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.451198 drop table if exists "id_created_test"; [] gorptest: 13:46:10.451209 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.451221 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.451233 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.451245 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.451257 drop table if exists "time_test"; [] gorptest: 13:46:10.451276 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.453252 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: 13:46:10.455610 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.457879 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.460098 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.462008 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.463980 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.465974 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.468073 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.470119 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.472029 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.474378 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.476399 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 13:46:10.478390 select * from id_created_test where Id=1 [] gorptest: 13:46:10.478493 SELECT *, 1 AS external FROM id_created_test [] gorptest: 13:46:10.478538 drop table if exists "invoice_test"; [] gorptest: 13:46:10.480768 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.482863 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.484816 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.487054 drop table if exists "person_test"; [] gorptest: 13:46:10.489069 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.491362 drop table if exists "id_created_test"; [] gorptest: 13:46:10.493385 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.495372 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.497327 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.499248 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.501034 drop table if exists "time_test"; [] gorptest: 13:46:10.502816 drop table if exists "id_created_test"; [] 2025/04/01 13:46: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: 13:46:10.503079 drop table if exists "invoice_test"; [] gorptest: 13:46:10.503252 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.503267 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.503279 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.503292 drop table if exists "person_test"; [] gorptest: 13:46:10.503304 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.503316 drop table if exists "id_created_test"; [] gorptest: 13:46:10.503328 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.503340 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.503352 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.503363 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.503375 drop table if exists "time_test"; [] gorptest: 13:46:10.503403 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.505321 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: 13:46:10.507349 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.509327 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.511280 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.513229 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.515148 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.517216 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.519048 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.521003 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.522933 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.524712 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.526868 drop table if exists "invoice_test"; [] gorptest: 13:46:10.528784 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.530583 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.532426 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.534189 drop table if exists "person_test"; [] gorptest: 13:46:10.536006 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.537586 drop table if exists "id_created_test"; [] gorptest: 13:46:10.539231 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.541022 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.542635 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.544382 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.546123 drop table if exists "time_test"; [] gorptest: 13:46:10.548148 drop table if exists "id_created_test"; [] gorptest: 13:46:10.548200 drop table if exists "single_column_table"; [] gorptest: 13:46:10.548300 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: 13:46:10.550400 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: 13:46:10.552457 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.554329 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: 13:46:10.556125 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: 13:46:10.557933 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.559624 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.561385 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.563033 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.564678 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.566362 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: 13:46:10.568116 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.569799 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:10.569855 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 13:46:10.571685 delete from "invoice_test"; [] gorptest: 13:46:10.573449 delete from "invoice_tag_test"; [] gorptest: 13:46:10.575046 delete from "alias_trans_field_test"; [] gorptest: 13:46:10.576689 delete from "invoice_override_test"; [] gorptest: 13:46:10.578525 delete from "person_test"; [] gorptest: 13:46:10.580328 delete from "ignored_column_test"; [] gorptest: 13:46:10.581952 delete from "id_created_test"; [] gorptest: 13:46:10.583723 delete from "type_conv_test"; [] gorptest: 13:46:10.585388 delete from "embedded_struct_test"; [] gorptest: 13:46:10.587080 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.588796 delete from "embedded_autoincr_test"; [] gorptest: 13:46:10.590510 delete from "time_test"; [] gorptest: 13:46:10.592504 delete from "id_created_test"; [] gorptest: 13:46:10.594176 delete from "single_column_table"; [] gorptest: 13:46:10.596054 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 13:46:10.596157 drop table if exists "invoice_test"; [] gorptest: 13:46:10.598171 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.600214 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.602306 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.604283 drop table if exists "person_test"; [] gorptest: 13:46:10.606383 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.608384 drop table if exists "id_created_test"; [] gorptest: 13:46:10.610280 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.612175 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.614066 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.615712 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.617653 drop table if exists "time_test"; [] gorptest: 13:46:10.619485 drop table if exists "id_created_test"; [] gorptest: 13:46:10.619540 drop table if exists "single_column_table"; [] 2025/04/01 13:46: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: 13:46:10.621435 drop table if exists "invoice_test"; [] gorptest: 13:46:10.621612 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.621637 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.621650 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.621662 drop table if exists "person_test"; [] gorptest: 13:46:10.621675 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.621687 drop table if exists "id_created_test"; [] gorptest: 13:46:10.621699 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.621710 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.621723 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.621735 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.621747 drop table if exists "time_test"; [] gorptest: 13:46:10.621766 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.623881 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: 13:46:10.625938 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:10.627981 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:10.630032 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:10.632204 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.634289 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:10.636214 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:10.637940 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:10.639929 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:10.642003 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:10.644167 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:10.645951 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 13:46:10.647731 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 13:46:10.650274 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 13:46:10.652085 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 13:46:10.652241 begin; [] gorptest: 13:46:10.652270 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 13:46:10.652390 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:10.652700 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:10.652765 commit; [] gorptest: 13:46:10.654861 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:10.655007 drop table if exists "invoice_test"; [] gorptest: 13:46:10.657158 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:10.658991 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:10.660943 drop table if exists "invoice_override_test"; [] gorptest: 13:46:10.662880 drop table if exists "person_test"; [] gorptest: 13:46:10.664960 drop table if exists "ignored_column_test"; [] gorptest: 13:46:10.666887 drop table if exists "id_created_test"; [] gorptest: 13:46:10.668963 drop table if exists "type_conv_test"; [] gorptest: 13:46:10.670782 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:10.672507 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:10.674415 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:10.676470 drop table if exists "time_test"; [] gorptest: 13:46:10.678325 drop table if exists "id_created_test"; [] PASS ok gopkg.in/gorp.v1 1.428s gopkg.in/gorp.v1 2025/04/01 13:46:11 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: 13:46:11.453521 drop table if exists "invoice_test"; [] gorptest: 13:46:11.455070 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.455273 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.455419 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.455563 drop table if exists "person_test"; [] gorptest: 13:46:11.455705 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.455850 drop table if exists "id_created_test"; [] gorptest: 13:46:11.456018 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.456048 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.456062 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.456075 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.456088 drop table if exists "time_test"; [] gorptest: 13:46:11.456119 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.458588 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: 13:46:11.460987 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.462974 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.464857 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.466705 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.468502 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.470342 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.472402 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.474410 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.476307 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.478316 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.480169 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: 13:46:11.480239 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: 13:46:11.480260 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.480277 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: 13:46:11.480296 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: 13:46:11.480310 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.480324 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.480340 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.480355 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.480370 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.480386 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: 13:46:11.480401 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.480419 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:11.480433 drop table if exists "invoice_test"; [] gorptest: 13:46:11.482339 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.484207 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.486190 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.488098 drop table if exists "person_test"; [] gorptest: 13:46:11.490173 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.491979 drop table if exists "id_created_test"; [] gorptest: 13:46:11.494020 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.496077 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.498016 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.500021 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.501828 drop table if exists "time_test"; [] gorptest: 13:46:11.504145 drop table if exists "id_created_test"; [] 2025/04/01 13:46:11 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: 13:46:11.504380 drop table if exists "invoice_test"; [] gorptest: 13:46:11.504566 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.504582 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.504594 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.504605 drop table if exists "person_test"; [] gorptest: 13:46:11.504618 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.504629 drop table if exists "id_created_test"; [] gorptest: 13:46:11.504640 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.504652 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.504663 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.504675 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.504686 drop table if exists "time_test"; [] gorptest: 13:46:11.504708 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.506699 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: 13:46:11.508599 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.510461 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.512381 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.514302 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.516316 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.518302 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.520418 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.522398 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.524275 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.526100 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.527882 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: 13:46:11.527955 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: 13:46:11.527976 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.527993 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: 13:46:11.528012 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: 13:46:11.528027 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.528041 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.528057 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.528073 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.528091 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.528108 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: 13:46:11.528125 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.528140 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:11.528252 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515171528156149 2:1743515171528156149 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:11.530169 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:1 3:"my invoice" 4:0 5:true] gorptest: 13:46:11.532008 delete from "invoice_test"; [] gorptest: 13:46:11.533607 delete from "invoice_tag_test"; [] gorptest: 13:46:11.535155 delete from "alias_trans_field_test"; [] gorptest: 13:46:11.536672 delete from "invoice_override_test"; [] gorptest: 13:46:11.538363 delete from "person_test"; [] gorptest: 13:46:11.539999 delete from "ignored_column_test"; [] gorptest: 13:46:11.541626 delete from "id_created_test"; [] gorptest: 13:46:11.543182 delete from "type_conv_test"; [] gorptest: 13:46:11.544844 delete from "embedded_struct_test"; [] gorptest: 13:46:11.546531 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.548331 delete from "embedded_autoincr_test"; [] gorptest: 13:46:11.550050 delete from "time_test"; [] gorptest: 13:46:11.551742 delete from "id_created_test"; [] gorptest: 13:46:11.553372 SELECT * FROM person_test [] gorptest: 13:46:11.553499 SELECT * FROM invoice_test [] gorptest: 13:46:11.553536 drop table if exists "invoice_test"; [] gorptest: 13:46:11.555517 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.557309 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.559187 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.561224 drop table if exists "person_test"; [] gorptest: 13:46:11.563068 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.564953 drop table if exists "id_created_test"; [] gorptest: 13:46:11.566829 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.568685 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.570471 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.572184 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.573972 drop table if exists "time_test"; [] gorptest: 13:46:11.575619 drop table if exists "id_created_test"; [] gorptest: 13:46:11.575776 create table "WithCustomDate" ("Id" integer not null primary key autoincrement, "Added" datetime) ; [] gorptest: 13:46:11.577792 insert into "WithCustomDate" ("Id","Added") values (null,?); [1:2025-04-01 13:46:11 +0000 UTC] gorptest: 13:46:11.579733 select "Id","Added" from "WithCustomDate" where "Id"=?; [1:1] gorptest: 13:46:11.579876 drop table if exists "WithCustomDate"; [] gorptest: 13:46:11.581729 create table if not exists "PersonUInt64" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:11.583519 create table if not exists "PersonUInt32" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:11.585249 create table if not exists "PersonUInt16" ("Id" integer not null primary key autoincrement, "Name" varchar(255)) ; [] gorptest: 13:46:11.587020 insert into "PersonUInt64" ("Id","Name") values (null,?); [1:"name1"] gorptest: 13:46:11.588844 insert into "PersonUInt32" ("Id","Name") values (null,?); [1:"name2"] gorptest: 13:46:11.590521 insert into "PersonUInt16" ("Id","Name") values (null,?); [1:"name3"] gorptest: 13:46:11.592262 drop table if exists "PersonUInt64"; [] gorptest: 13:46:11.593941 drop table if exists "PersonUInt32"; [] gorptest: 13:46:11.595998 drop table if exists "PersonUInt16"; [] gorptest: 13:46:11.597808 create table if not exists "UniqueColumns" ("FirstName" varchar(255), "LastName" varchar(255), "City" varchar(255), "ZipCode" integer, unique ("FirstName", "LastName"), unique ("City", "ZipCode")) ; [] gorptest: 13:46:11.599953 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Cupertino" 4:95014] gorptest: 13:46:11.601685 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Jobs" 3:"Sunnyvale" 4:94085] gorptest: 13:46:11.601790 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Cupertino" 4:95014] gorptest: 13:46:11.601832 insert into "UniqueColumns" ("FirstName","LastName","City","ZipCode") values (?,?,?,?); [1:"Steve" 2:"Wozniak" 3:"Sunnyvale" 4:94085] gorptest: 13:46:11.604123 drop table if exists "UniqueColumns"; [] gorptest: 13:46:11.606224 drop table if exists PersistentUser [] gorptest: 13:46:11.606437 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:11.608305 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:11.610035 select "mykey","Id","PassedTraining" from "PersistentUser" where "mykey"=?; [1:43] gorptest: 13:46:11.610150 select * from PersistentUser [] gorptest: 13:46:11.610219 select * from PersistentUser [] gorptest: 13:46:11.610257 select * from PersistentUser [] gorptest: 13:46:11.610287 select Id from PersistentUser [] gorptest: 13:46:11.610307 select mykey from PersistentUser [] gorptest: 13:46:11.610326 select PassedTraining from PersistentUser [] gorptest: 13:46:11.610345 select Id from PersistentUser [] gorptest: 13:46:11.610364 drop table if exists "PersistentUser"; [] gorptest: 13:46:11.612184 drop table if exists PersistentUser [] gorptest: 13:46:11.612398 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:11.614197 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:11.615993 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 13:46:11.617791 select * from PersistentUser where mykey = ? [1:43] gorptest: 13:46:11.617932 select * from PersistentUser where mykey = ? [1:43] gorptest: 13:46:11.617978 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 13:46:11.618019 select * from PersistentUser where mykey = ? and Id != 'abc:def' [1:43] gorptest: 13:46:11.618051 drop table if exists "PersistentUser"; [] gorptest: 13:46:11.620133 drop table if exists PersistentUser [] gorptest: 13:46:11.620329 create table if not exists "PersistentUser" ("mykey" integer not null primary key, "Id" varchar(255), "PassedTraining" integer) ; [] gorptest: 13:46:11.622442 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:43 2:"33r" 3:false] gorptest: 13:46:11.624260 insert into "PersistentUser" ("mykey","Id","PassedTraining") values (?,?,?); [1:500 2:"abc" 3:false] gorptest: 13:46:11.626059 select * from PersistentUser where mykey = ? and PassedTraining = ? and Id = ? [1:43 2:false 3:"33r"] gorptest: 13:46:11.626187 drop table if exists "PersistentUser"; [] 2025/04/01 13:46:11 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: 13:46:11.628301 drop table if exists "invoice_test"; [] gorptest: 13:46:11.628476 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.628499 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.628512 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.628524 drop table if exists "person_test"; [] gorptest: 13:46:11.628536 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.628548 drop table if exists "id_created_test"; [] gorptest: 13:46:11.628560 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.628571 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.628583 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.628595 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.628606 drop table if exists "time_test"; [] gorptest: 13:46:11.628624 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.630784 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: 13:46:11.632856 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.634570 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.636510 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.638196 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.639926 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.641768 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.643560 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.645305 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.647306 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.649577 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.651396 select * from invoice_test where id=99999 [] gorptest: 13:46:11.651484 select * from invoice_test where id=99999 [] gorptest: 13:46:11.651525 drop table if exists "invoice_test"; [] gorptest: 13:46:11.653285 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.655020 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.656793 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.658699 drop table if exists "person_test"; [] gorptest: 13:46:11.660768 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.662611 drop table if exists "id_created_test"; [] gorptest: 13:46:11.664422 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.666431 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.668141 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.669956 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.671830 drop table if exists "time_test"; [] gorptest: 13:46:11.673702 drop table if exists "id_created_test"; [] gorptest: 13:46:11.673930 create table "InvoicePersonView" ("InvoiceId" integer not null, "PersonId" integer not null, "Memo" varchar(255), "FName" varchar(255), "LegacyVersion" integer, primary key ("InvoiceId", "PersonId")) ; [] gorptest: 13:46:11.676283 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: 13:46:11.676387 drop table if exists "InvoicePersonView"; [] 2025/04/01 13:46:11 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: 13:46:11.678462 drop table if exists "invoice_test"; [] gorptest: 13:46:11.678629 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.678643 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.678657 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.678669 drop table if exists "person_test"; [] gorptest: 13:46:11.678681 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.678692 drop table if exists "id_created_test"; [] gorptest: 13:46:11.678704 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.678717 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.678729 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.678740 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.678753 drop table if exists "time_test"; [] gorptest: 13:46:11.678771 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.680952 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: 13:46:11.682968 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.685036 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.686931 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.688882 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.690822 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.692654 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.694780 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.696953 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.698995 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.701009 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.703210 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515171703191048 2:1743515171703191048 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:11.705313 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:11.705429 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515171703191048 2:1743515171703191048 3:"preupdate" 4:"Edwards" 5:2 6:1 7:1] gorptest: 13:46:11.707351 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515171703191048 2:1743515171703191048 3:"preupdate" 4:"Howard" 5:2 6:1 7:1] gorptest: 13:46:11.707435 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:11.707539 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:1] gorptest: 13:46:11.707570 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:11.707599 drop table if exists "invoice_test"; [] gorptest: 13:46:11.709618 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.711746 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.713984 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.715933 drop table if exists "person_test"; [] gorptest: 13:46:11.717924 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.719860 drop table if exists "id_created_test"; [] gorptest: 13:46:11.721815 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.723745 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.725729 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.727754 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.729745 drop table if exists "time_test"; [] gorptest: 13:46:11.731605 drop table if exists "id_created_test"; [] gorptest: 13:46:11.731819 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 13:46:11.734268 insert into TableWithNull values (10, null, null, null, null, null) [] gorptest: 13:46:11.736077 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 13:46:11.736207 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: 13:46:11.743036 select "Id","Str","Int64","Float64","Bool","Bytes" from "TableWithNull" where "Id"=?; [1:10] gorptest: 13:46:11.743163 drop table if exists "TableWithNull"; [] gorptest: 13:46:11.745320 create table "Invoice" ("Id" integer not null primary key autoincrement, "date_created" integer, "Memo" varchar(10), "PersonId" integer unique, "IsPaid" integer) ; [] gorptest: 13:46:11.747565 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice" 3:0 4:true] gorptest: 13:46:11.749887 select "Id","date_created","Memo","PersonId","IsPaid" from "Invoice" where "Id"=?; [1:1] gorptest: 13:46:11.749995 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"this memo is too long" 3:0 4:true] gorptest: 13:46:11.750037 insert into "Invoice" ("Id","date_created","Memo","PersonId","IsPaid") values (null,?,?,?,?); [1:0 2:"my invoice2" 3:0 4:false] gorptest: 13:46:11.750063 drop table if exists "Invoice"; [] 2025/04/01 13:46:11 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: 13:46:11.752292 drop table if exists "invoice_test"; [] gorptest: 13:46:11.752464 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.752480 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.752493 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.752504 drop table if exists "person_test"; [] gorptest: 13:46:11.752516 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.752528 drop table if exists "id_created_test"; [] gorptest: 13:46:11.752540 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.752552 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.752575 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.752589 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.752601 drop table if exists "time_test"; [] gorptest: 13:46:11.752619 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.754848 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: 13:46:11.756875 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.758974 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.761238 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.763101 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.765178 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.767223 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.769266 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.771155 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.773095 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.775173 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.777197 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515171777178399 2:1743515171777178399 3:"bob" 4:"smith" 5:1] gorptest: 13:46:11.778884 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:true] gorptest: 13:46:11.780544 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 13:46:11.780658 drop table if exists "invoice_test"; [] gorptest: 13:46:11.782380 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.784084 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.785945 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.787691 drop table if exists "person_test"; [] gorptest: 13:46:11.789666 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.791485 drop table if exists "id_created_test"; [] gorptest: 13:46:11.793193 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.795159 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.796994 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.798862 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.800827 drop table if exists "time_test"; [] gorptest: 13:46:11.802783 drop table if exists "id_created_test"; [] 2025/04/01 13:46:11 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: 13:46:11.803012 drop table if exists "invoice_test"; [] gorptest: 13:46:11.803180 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.803205 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.803217 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.803229 drop table if exists "person_test"; [] gorptest: 13:46:11.803241 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.803258 drop table if exists "id_created_test"; [] gorptest: 13:46:11.803271 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.803282 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.803294 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.803305 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.803317 drop table if exists "time_test"; [] gorptest: 13:46:11.803335 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.805229 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: 13:46:11.807206 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.809392 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.811288 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.813049 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.814818 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.816573 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.818186 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.819881 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.821641 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.823636 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.825590 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515171825572091 2:1743515171825572091 3:"bob" 4:"smith" 5:1] gorptest: 13:46:11.827246 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:11.827363 update "person_test" set "Created"=?, "Updated"=?, "FName"=?, "LName"=?, "Version"=? where "Id"=? and "Version"=?; [1:1743515171825572091 2:1743515171825572091 3:"preupdate" 4:"postget" 5:2 6:1 7:1] gorptest: 13:46:11.829311 select * from person_test where id = ? [1:1] gorptest: 13:46:11.829415 delete from "person_test" where "Id"=? and "Version"=?; [1:1 2:2] gorptest: 13:46:11.831151 drop table if exists "invoice_test"; [] gorptest: 13:46:11.833080 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.835115 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.837187 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.839243 drop table if exists "person_test"; [] gorptest: 13:46:11.841263 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.843106 drop table if exists "id_created_test"; [] gorptest: 13:46:11.844976 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.846856 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.848569 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.850469 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.852120 drop table if exists "time_test"; [] gorptest: 13:46:11.853808 drop table if exists "id_created_test"; [] 2025/04/01 13:46:11 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: 13:46:11.854065 drop table if exists "invoice_test"; [] gorptest: 13:46:11.854222 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.854249 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.854263 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.854274 drop table if exists "person_test"; [] gorptest: 13:46:11.854286 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.854298 drop table if exists "id_created_test"; [] gorptest: 13:46:11.854309 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.854321 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.854334 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.854346 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.854359 drop table if exists "time_test"; [] gorptest: 13:46:11.854381 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.856138 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: 13:46:11.857837 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.859534 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.861406 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.863200 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.864878 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.867485 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.869712 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.871889 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.874070 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.876165 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.878134 begin; [] gorptest: 13:46:11.878212 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t1" 4:0 5:true] gorptest: 13:46:11.878360 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"t2" 4:0 5:false] gorptest: 13:46:11.878381 commit; [] gorptest: 13:46:11.880175 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:11.880267 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:2] gorptest: 13:46:11.880298 drop table if exists "invoice_test"; [] gorptest: 13:46:11.882499 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.884351 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.886359 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.888369 drop table if exists "person_test"; [] gorptest: 13:46:11.890366 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.892476 drop table if exists "id_created_test"; [] gorptest: 13:46:11.894390 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.896294 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.898228 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.900220 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.902051 drop table if exists "time_test"; [] gorptest: 13:46:11.904175 drop table if exists "id_created_test"; [] 2025/04/01 13:46:11 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: 13:46:11.904390 drop table if exists "invoice_test"; [] gorptest: 13:46:11.904542 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.904557 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.904574 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.904587 drop table if exists "person_test"; [] gorptest: 13:46:11.904599 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.904610 drop table if exists "id_created_test"; [] gorptest: 13:46:11.904622 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.904633 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.904645 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.904657 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.904669 drop table if exists "time_test"; [] gorptest: 13:46:11.904685 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.906766 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: 13:46:11.908359 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.909947 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.911665 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.913648 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.915369 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.917208 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.918996 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.920796 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.922514 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.924426 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.926166 begin; [] gorptest: 13:46:11.926243 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"unpaid" 4:0 5:false] gorptest: 13:46:11.926374 select memo from invoice_test [] gorptest: 13:46:11.926421 savepoint "foo" [1:] gorptest: 13:46:11.926430 select memo from invoice_test [] gorptest: 13:46:11.926455 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"paid" 4:0 5:false 6:1] gorptest: 13:46:11.926479 select memo from invoice_test [] gorptest: 13:46:11.926499 rollback to savepoint "foo" [1:] gorptest: 13:46:11.926507 select memo from invoice_test [] gorptest: 13:46:11.926518 rollback; [] gorptest: 13:46:11.926600 drop table if exists "invoice_test"; [] gorptest: 13:46:11.928327 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.929990 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.932049 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.933779 drop table if exists "person_test"; [] gorptest: 13:46:11.935675 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.937494 drop table if exists "id_created_test"; [] gorptest: 13:46:11.939275 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.941400 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.943143 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.944807 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.946437 drop table if exists "time_test"; [] gorptest: 13:46:11.948248 drop table if exists "id_created_test"; [] 2025/04/01 13:46:11 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: 13:46:11.948447 drop table if exists "invoice_test"; [] gorptest: 13:46:11.948596 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.948611 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.948623 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.948634 drop table if exists "person_test"; [] gorptest: 13:46:11.948646 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.948658 drop table if exists "id_created_test"; [] gorptest: 13:46:11.948670 drop table if exists "type_conv_test"; [] gorptest: 13:46:11.948688 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:11.948701 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:11.948713 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:11.948725 drop table if exists "time_test"; [] gorptest: 13:46:11.948745 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.950732 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: 13:46:11.952958 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:11.954983 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:11.957052 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:11.958938 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.960851 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:11.962631 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:11.964977 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:11.967080 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:11.969043 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:11.971133 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:11.973059 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"a" 4:0 5:false] gorptest: 13:46:11.974856 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"b" 4:0 5:true] gorptest: 13:46:11.977055 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"c" 4:0 5:false 6:1] gorptest: 13:46:11.979128 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:100 2:200 3:"d" 4:0 5:true 6:2] gorptest: 13:46:11.980891 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:11.982801 delete from "invoice_test" where "Id"=?; [1:2] gorptest: 13:46:11.984686 drop table if exists "invoice_test"; [] gorptest: 13:46:11.986680 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:11.988686 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:11.990747 drop table if exists "invoice_override_test"; [] gorptest: 13:46:11.992604 drop table if exists "person_test"; [] gorptest: 13:46:11.994462 drop table if exists "ignored_column_test"; [] gorptest: 13:46:11.996431 drop table if exists "id_created_test"; [] gorptest: 13:46:11.998475 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.000359 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.002234 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.004225 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.006062 drop table if exists "time_test"; [] gorptest: 13:46:12.007970 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.008215 drop table if exists "invoice_test"; [] gorptest: 13:46:12.008389 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.008414 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.008429 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.008441 drop table if exists "person_test"; [] gorptest: 13:46:12.008454 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.008465 drop table if exists "id_created_test"; [] gorptest: 13:46:12.008477 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.008489 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.008500 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.008512 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.008524 drop table if exists "time_test"; [] gorptest: 13:46:12.008542 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.010588 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: 13:46:12.012865 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.014797 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.017005 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.019074 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.021054 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.022862 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.025067 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.027330 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.029488 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.031552 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.033794 delete from invoice_test [] gorptest: 13:46:12.035740 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"first order" 4:0 5:true] gorptest: 13:46:12.037665 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:12.037786 update "invoice_test" set "Created"=?, "Updated"=?, "Memo"=?, "PersonId"=?, "IsPaid"=? where "Id"=?; [1:7777462473879727739 2:3064809164211832781 3:"random 574509380762296770" 4:0 5:true 6:1] gorptest: 13:46:12.039703 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:12.039797 select * from invoice_test [] gorptest: 13:46:12.039851 delete from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:12.041791 select "Id","Created","Updated","Memo","PersonId","IsPaid" from "invoice_test" where "Id"=?; [1:1] gorptest: 13:46:12.041872 delete from invoice_tag_test [] gorptest: 13:46:12.043712 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: 13:46:12.045789 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:12.045917 update "invoice_tag_test" set "myCreated"=?, "date_updated"=?, "Memo"=?, "person_id"=?, "is_Paid"=? where "myid"=?; [1:4400211295088762955 2:6701971504191328417 3:"random 3566237177173786844" 4:33 5:false 6:1] gorptest: 13:46:12.047858 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:12.047975 select * from invoice_tag_test [] gorptest: 13:46:12.048032 delete from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:12.049957 select "myid","myCreated","date_updated","Memo","person_id","is_Paid" from "invoice_tag_test" where "myid"=?; [1:1] gorptest: 13:46:12.050033 delete from alias_trans_field_test [] gorptest: 13:46:12.052110 insert into "alias_trans_field_test" ("id","bar") values (null,?); [1:"some bar"] gorptest: 13:46:12.054307 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:12.054401 update "alias_trans_field_test" set "bar"=? where "id"=?; [1:"random 3596076314064251073" 2:1] gorptest: 13:46:12.056328 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:12.056413 select * from alias_trans_field_test [] gorptest: 13:46:12.056454 delete from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:12.058365 select "id","bar" from "alias_trans_field_test" where "id"=?; [1:1] gorptest: 13:46:12.058454 drop table if exists "invoice_test"; [] gorptest: 13:46:12.060680 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.062807 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.064919 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.066756 drop table if exists "person_test"; [] gorptest: 13:46:12.068761 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.070713 drop table if exists "id_created_test"; [] gorptest: 13:46:12.072608 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.074390 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.076159 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.077978 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.079892 drop table if exists "time_test"; [] gorptest: 13:46:12.082140 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.082348 drop table if exists "invoice_test"; [] gorptest: 13:46:12.082515 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.082536 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.082549 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.082561 drop table if exists "person_test"; [] gorptest: 13:46:12.082574 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.082586 drop table if exists "id_created_test"; [] gorptest: 13:46:12.082597 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.082609 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.082621 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.082632 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.082644 drop table if exists "time_test"; [] gorptest: 13:46:12.082662 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.084986 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: 13:46:12.086960 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.088969 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.091172 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.093055 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.095224 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.097444 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.099618 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.101735 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.103973 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.106145 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.108212 insert into "ignored_column_test" ("Id","Created") values (null,?); [1:1] gorptest: 13:46:12.110162 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:12.110261 delete from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:12.112335 select "Id","Created" from "ignored_column_test" where "Id"=?; [1:1] gorptest: 13:46:12.112413 drop table if exists "invoice_test"; [] gorptest: 13:46:12.114394 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.116498 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.118221 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.120032 drop table if exists "person_test"; [] gorptest: 13:46:12.121833 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.124004 drop table if exists "id_created_test"; [] gorptest: 13:46:12.125597 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.127507 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.129268 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.131132 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.133054 drop table if exists "time_test"; [] gorptest: 13:46:12.134785 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.135013 drop table if exists "invoice_test"; [] gorptest: 13:46:12.135187 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.135201 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.135214 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.135226 drop table if exists "person_test"; [] gorptest: 13:46:12.135238 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.135249 drop table if exists "id_created_test"; [] gorptest: 13:46:12.135261 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.135273 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.135285 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.135296 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.135308 drop table if exists "time_test"; [] gorptest: 13:46:12.135326 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.137488 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: 13:46:12.139339 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.141385 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.143191 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.145423 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.147525 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.149598 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.151687 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.153998 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.156058 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.157979 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.160224 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: 13:46:12.162037 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:12.162161 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: 13:46:12.164049 select "Id","PersonJSON","Name" from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:12.164152 delete from "type_conv_test" where "Id"=?; [1:1] gorptest: 13:46:12.166107 drop table if exists "invoice_test"; [] gorptest: 13:46:12.168164 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.170151 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.172012 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.173933 drop table if exists "person_test"; [] gorptest: 13:46:12.175958 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.177950 drop table if exists "id_created_test"; [] gorptest: 13:46:12.179833 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.182017 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.184157 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.186176 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.188181 drop table if exists "time_test"; [] gorptest: 13:46:12.190470 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.190690 drop table if exists "invoice_test"; [] gorptest: 13:46:12.190848 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.190863 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.190876 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.190888 drop table if exists "person_test"; [] gorptest: 13:46:12.190949 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.190968 drop table if exists "id_created_test"; [] gorptest: 13:46:12.190980 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.190992 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.191004 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.191016 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.191027 drop table if exists "time_test"; [] gorptest: 13:46:12.191045 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.193176 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: 13:46:12.195337 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.197279 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.199370 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.201560 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.203478 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.205454 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.207544 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.209754 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.211729 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.213936 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.216180 insert into "embedded_struct_test" ("Id","FirstName","LastName") values (null,?,?); [1:"Alice" 2:"Smith"] gorptest: 13:46:12.218242 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 13:46:12.218343 update "embedded_struct_test" set "FirstName"=?, "LastName"=? where "Id"=?; [1:"Bob" 2:"Smith" 3:1] gorptest: 13:46:12.220268 select "Id","FirstName","LastName" from "embedded_struct_test" where "Id"=?; [1:1] gorptest: 13:46:12.220356 select * from embedded_struct_test [] gorptest: 13:46:12.220398 drop table if exists "invoice_test"; [] gorptest: 13:46:12.222419 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.224460 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.226373 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.228352 drop table if exists "person_test"; [] gorptest: 13:46:12.230257 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.232205 drop table if exists "id_created_test"; [] gorptest: 13:46:12.234059 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.235923 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.238075 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.240045 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.241967 drop table if exists "time_test"; [] gorptest: 13:46:12.244034 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.244246 drop table if exists "invoice_test"; [] gorptest: 13:46:12.244401 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.244416 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.244428 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.244440 drop table if exists "person_test"; [] gorptest: 13:46:12.244451 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.244463 drop table if exists "id_created_test"; [] gorptest: 13:46:12.244475 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.244486 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.244498 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.244510 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.244522 drop table if exists "time_test"; [] gorptest: 13:46:12.244540 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.246577 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: 13:46:12.248419 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.250273 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.252172 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.254238 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.256503 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.259538 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.261932 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.263922 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.266051 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.268152 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.270413 insert into "embedded_struct_before_autoincr_test" ("FirstName","LastName","Id") values (?,?,null); [1:"Alice" 2:"Smith"] gorptest: 13:46:12.272469 drop table if exists "invoice_test"; [] gorptest: 13:46:12.274529 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.276345 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.278244 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.280017 drop table if exists "person_test"; [] gorptest: 13:46:12.281687 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.283525 drop table if exists "id_created_test"; [] gorptest: 13:46:12.285440 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.287424 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.289320 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.291243 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.293086 drop table if exists "time_test"; [] gorptest: 13:46:12.294835 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.295112 drop table if exists "invoice_test"; [] gorptest: 13:46:12.295284 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.295299 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.295311 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.295323 drop table if exists "person_test"; [] gorptest: 13:46:12.295335 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.295348 drop table if exists "id_created_test"; [] gorptest: 13:46:12.295359 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.295371 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.295383 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.295394 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.295406 drop table if exists "time_test"; [] gorptest: 13:46:12.295424 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.297522 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: 13:46:12.299494 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.301314 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.303430 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.305520 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.307638 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.309744 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.311805 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.313615 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.316052 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.318100 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.320120 insert into "embedded_autoincr_test" ("Id","FirstName","LastName","MiddleName") values (null,?,?,?); [1:"Alice" 2:"Smith" 3:"Rose"] gorptest: 13:46:12.321977 drop table if exists "invoice_test"; [] gorptest: 13:46:12.323835 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.325780 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.327531 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.329526 drop table if exists "person_test"; [] gorptest: 13:46:12.331244 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.333228 drop table if exists "id_created_test"; [] gorptest: 13:46:12.335075 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.336798 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.338644 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.340603 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.342536 drop table if exists "time_test"; [] gorptest: 13:46:12.344548 drop table if exists "id_created_test"; [] gorptest: 13:46:12.344714 create table "TableWithNull" ("Id" integer not null primary key, "Str" varchar(255), "Int64" integer, "Float64" real, "Bool" integer, "Bytes" blob) ; [] gorptest: 13:46:12.347059 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: 13:46:12.349010 select Int64 from TableWithNull where Str='abc' [] gorptest: 13:46:12.349114 select count(*) from TableWithNull [] gorptest: 13:46:12.349143 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 13:46:12.349169 select Int64 from TableWithNull where Str='notfound' [] gorptest: 13:46:12.349189 select Int64 from TableWithNull where Str='abc' [] gorptest: 13:46:12.349208 select Float64 from TableWithNull where Str='abc' [] gorptest: 13:46:12.349226 select min(Float64) from TableWithNull [] gorptest: 13:46:12.349248 select count(*) from TableWithNull where Str=? [1:"asdfasdf"] gorptest: 13:46:12.349269 select Float64 from TableWithNull where Str='notfound' [] gorptest: 13:46:12.349287 select Float64 from TableWithNull where Str='abc' [] gorptest: 13:46:12.349305 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:12.349338 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 13:46:12.349357 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:12.349376 select Str from TableWithNull where Str='asdfasdf' [] gorptest: 13:46:12.349420 select Int64 from TableWithNull where Str=? [1:"abc"] gorptest: 13:46:12.349444 select Str from TableWithNull where Int64=? [1:78] gorptest: 13:46:12.349463 drop table if exists "TableWithNull"; [] 2025/04/01 13:46:12 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: 13:46:12.351634 drop table if exists "invoice_test"; [] gorptest: 13:46:12.351792 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.351816 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.351828 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.351840 drop table if exists "person_test"; [] gorptest: 13:46:12.351853 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.351864 drop table if exists "id_created_test"; [] gorptest: 13:46:12.351876 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.351888 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.351929 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.351946 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.351958 drop table if exists "time_test"; [] gorptest: 13:46:12.351976 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.354061 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: 13:46:12.356000 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.358138 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.360157 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.362100 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.364035 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.366243 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.368246 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.370343 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.372417 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.374371 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.376582 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172376564088 2:1743515172376564088 3:"Bob" 4:"Smith" 5:1] gorptest: 13:46:12.378574 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172378562148 2:1743515172378562148 3:"Jane" 4:"Smith" 5:1] gorptest: 13:46:12.380665 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172380652649 2:1743515172380652649 3:"Mike" 4:"Smith" 5:1] gorptest: 13:46:12.382619 drop table if exists "invoice_test"; [] gorptest: 13:46:12.384929 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.386673 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.388707 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.390684 drop table if exists "person_test"; [] gorptest: 13:46:12.392606 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.394421 drop table if exists "id_created_test"; [] gorptest: 13:46:12.396482 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.398430 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.400207 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.402103 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.403858 drop table if exists "time_test"; [] gorptest: 13:46:12.405751 drop table if exists "id_created_test"; [] gorptest: 13:46:12.405922 create table string_pk_test (Id varchar(255), Name varchar(255)); [] gorptest: 13:46:12.408051 insert into "string_pk_test" ("Id","Name") values (null,?); [1:"foo"] gorptest: 13:46:12.409827 drop table if exists "string_pk_test"; [] 2025/04/01 13:46:12 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: 13:46:12.411930 drop table if exists "invoice_test"; [] gorptest: 13:46:12.412100 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.412124 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.412137 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.412149 drop table if exists "person_test"; [] gorptest: 13:46:12.412160 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.412172 drop table if exists "id_created_test"; [] gorptest: 13:46:12.412183 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.412195 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.412206 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.412218 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.412230 drop table if exists "time_test"; [] gorptest: 13:46:12.412248 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.414375 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: 13:46:12.416155 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.418039 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.420059 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.421977 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.424140 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.425856 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.427722 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.429560 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.431421 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.433557 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.435321 insert into "time_test" ("Id","Time") values (null,?); [1:2025-04-01 13:15:12.435300964 +0000 UTC] gorptest: 13:46:12.437142 insert into "time_test" ("Id","Time") values (null,?); [1:2025-04-01 13:16:13.435300964 +0000 UTC] gorptest: 13:46:12.439200 SELECT id FROM time_test WHERE Time < ? [1:2025-04-01 13:16:12.435300964 +0000 UTC] gorptest: 13:46:12.439298 drop table if exists "invoice_test"; [] gorptest: 13:46:12.441055 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.442944 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.444696 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.446377 drop table if exists "person_test"; [] gorptest: 13:46:12.447958 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.449646 drop table if exists "id_created_test"; [] gorptest: 13:46:12.451840 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.453994 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.456015 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.458056 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.459976 drop table if exists "time_test"; [] gorptest: 13:46:12.461887 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.462135 drop table if exists "invoice_test"; [] gorptest: 13:46:12.462314 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.462339 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.462359 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.462374 drop table if exists "person_test"; [] gorptest: 13:46:12.462387 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.462399 drop table if exists "id_created_test"; [] gorptest: 13:46:12.462410 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.462422 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.462434 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.462446 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.462458 drop table if exists "time_test"; [] gorptest: 13:46:12.462476 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.464630 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: 13:46:12.466927 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.469038 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.471080 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.473181 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.475283 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.477330 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.479361 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.481422 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.483578 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.485843 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.488045 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172488025540 2:1743515172488025540 3:"bob" 4:"smith" 5:1] gorptest: 13:46:12.490263 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:0 2:0 3:"xmas order" 4:1 5:false] gorptest: 13:46:12.492151 select i.Id InvoiceId, p.Id PersonId, i.Memo, p.FName from invoice_test i, person_test p where i.PersonId = p.Id [] gorptest: 13:46:12.492294 drop table if exists "invoice_test"; [] gorptest: 13:46:12.494381 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.496205 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.498153 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.500062 drop table if exists "person_test"; [] gorptest: 13:46:12.502161 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.504059 drop table if exists "id_created_test"; [] gorptest: 13:46:12.505888 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.508151 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.510077 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.511930 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.513941 drop table if exists "time_test"; [] gorptest: 13:46:12.515781 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.516024 drop table if exists "invoice_test"; [] gorptest: 13:46:12.516203 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.516230 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.516244 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.516257 drop table if exists "person_test"; [] gorptest: 13:46:12.516269 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.516281 drop table if exists "id_created_test"; [] gorptest: 13:46:12.516293 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.516304 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.516317 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.516329 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.516340 drop table if exists "time_test"; [] gorptest: 13:46:12.516358 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.518391 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: 13:46:12.520462 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.522414 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.524501 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.526652 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.528813 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.530999 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.533021 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.535117 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.537299 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.539309 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] 2025/04/01 13:46:12 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: 13:46:12.567647 drop table if exists "invoice_test"; [] gorptest: 13:46:12.567853 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.567869 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.567881 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.567912 drop table if exists "person_test"; [] gorptest: 13:46:12.567928 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.567940 drop table if exists "id_created_test"; [] gorptest: 13:46:12.567952 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.567993 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.568008 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.568020 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.568031 drop table if exists "time_test"; [] gorptest: 13:46:12.568062 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.570312 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: 13:46:12.572661 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.575012 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.577317 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.579595 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.581767 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.584088 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.586246 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.588310 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.590537 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.593194 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.595766 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172595718114 2:1743515172595718114 3:"bob" 4:"smith" 5:1] gorptest: 13:46:12.597815 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172597801255 2:1743515172597801255 3:"jane" 4:"doe" 5:1] gorptest: 13:46:12.599980 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:12.600098 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:2] gorptest: 13:46:12.600171 select * from person_test where Id=? [1:1] gorptest: 13:46:12.600219 select * from person_test order by fname asc [] gorptest: 13:46:12.600280 drop table if exists "invoice_test"; [] gorptest: 13:46:12.602516 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.604878 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.607118 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.609234 drop table if exists "person_test"; [] gorptest: 13:46:12.611425 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.613449 drop table if exists "id_created_test"; [] gorptest: 13:46:12.615623 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.617698 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.619738 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.621874 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.623957 drop table if exists "time_test"; [] gorptest: 13:46:12.625983 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.626230 drop table if exists "invoice_test"; [] gorptest: 13:46:12.626410 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.626439 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.626453 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.626465 drop table if exists "person_test"; [] gorptest: 13:46:12.626477 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.626488 drop table if exists "id_created_test"; [] gorptest: 13:46:12.626500 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.626513 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.626525 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.626547 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.626558 drop table if exists "time_test"; [] gorptest: 13:46:12.626583 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.628997 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: 13:46:12.631212 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.633225 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.635487 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.637720 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.640012 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.642247 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.644626 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.646826 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.649172 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.651391 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.653663 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172653644422 2:1743515172653644422 3:"bob" 4:"smith" 5:1] gorptest: 13:46:12.655995 select "Id","Created","Updated","FName","LName","Version" from "person_test" where "Id"=?; [1:1] gorptest: 13:46:12.656107 select * from person_test where Id=? [1:1] gorptest: 13:46:12.656164 select FName from person_test where Id=? [1:1] gorptest: 13:46:12.656208 select * from person_test where Id=? [1:1] gorptest: 13:46:12.656253 select * from person_test where 2<1 AND Id=? [1:1] gorptest: 13:46:12.656290 select * from person_test where Id=? [1:-2222] gorptest: 13:46:12.656326 insert into "person_test" ("Id","Created","Updated","FName","LName","Version") values (null,?,?,?,?,?); [1:1743515172656319250 2:1743515172656319250 3:"bob" 4:"smith" 5:1] gorptest: 13:46:12.658445 select * from person_test where Fname='bob' [] gorptest: 13:46:12.658568 select * from person_test where Id=-123 [] gorptest: 13:46:12.658595 select * from person_test where Id=-123 [] gorptest: 13:46:12.658613 select * from person_test where Id=-123 [] gorptest: 13:46:12.658630 select * from person_test where Id=-123 [] gorptest: 13:46:12.658649 drop table if exists "invoice_test"; [] gorptest: 13:46:12.660787 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.662960 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.665110 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.667103 drop table if exists "person_test"; [] gorptest: 13:46:12.669189 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.671231 drop table if exists "id_created_test"; [] gorptest: 13:46:12.673245 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.675223 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.677231 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.679267 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.681463 drop table if exists "time_test"; [] gorptest: 13:46:12.683526 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.683757 drop table if exists "invoice_test"; [] gorptest: 13:46:12.683960 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.683990 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.684003 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.684015 drop table if exists "person_test"; [] gorptest: 13:46:12.684027 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.684038 drop table if exists "id_created_test"; [] gorptest: 13:46:12.684050 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.684062 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.684074 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.684086 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.684097 drop table if exists "time_test"; [] gorptest: 13:46:12.684117 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.686415 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: 13:46:12.688420 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.690471 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.692623 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.694734 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.696931 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.699032 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.701119 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.703192 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.705699 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.707874 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.710106 insert into "id_created_test" ("Id","Created") values (null,?); [1:3] gorptest: 13:46:12.712439 select * from id_created_test where Id=1 [] gorptest: 13:46:12.712558 SELECT *, 1 AS external FROM id_created_test [] gorptest: 13:46:12.712608 drop table if exists "invoice_test"; [] gorptest: 13:46:12.715239 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.717272 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.719239 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.721233 drop table if exists "person_test"; [] gorptest: 13:46:12.723022 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.725071 drop table if exists "id_created_test"; [] gorptest: 13:46:12.727110 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.729180 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.731244 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.733287 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.735208 drop table if exists "time_test"; [] gorptest: 13:46:12.737256 drop table if exists "id_created_test"; [] 2025/04/01 13:46:12 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: 13:46:12.737503 drop table if exists "invoice_test"; [] gorptest: 13:46:12.737667 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.737692 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.737705 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.737717 drop table if exists "person_test"; [] gorptest: 13:46:12.737729 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.737741 drop table if exists "id_created_test"; [] gorptest: 13:46:12.737753 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.737765 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.737777 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.737788 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.737800 drop table if exists "time_test"; [] gorptest: 13:46:12.737819 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.740328 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: 13:46:12.742475 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.744369 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.746401 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.748517 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.750499 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.752858 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.755053 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.757173 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.759204 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.761389 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.763435 drop table if exists "invoice_test"; [] gorptest: 13:46:12.765486 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.767477 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.769484 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.771625 drop table if exists "person_test"; [] gorptest: 13:46:12.773550 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.775614 drop table if exists "id_created_test"; [] gorptest: 13:46:12.777659 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.779499 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.781294 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.783154 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.785027 drop table if exists "time_test"; [] gorptest: 13:46:12.787026 drop table if exists "id_created_test"; [] gorptest: 13:46:12.787084 drop table if exists "single_column_table"; [] gorptest: 13:46:12.787110 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: 13:46:12.789016 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: 13:46:12.791028 create table if not exists "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.792996 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: 13:46:12.795014 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: 13:46:12.796810 create table if not exists "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.798826 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.800916 create table if not exists "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.802799 create table if not exists "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.804765 create table if not exists "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.806873 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: 13:46:12.809049 create table if not exists "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.811095 create table if not exists "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer, "External" integer) ; [] gorptest: 13:46:12.811162 create table if not exists "single_column_table" ("SomeId" varchar(255) not null primary key) ; [] gorptest: 13:46:12.813107 delete from "invoice_test"; [] gorptest: 13:46:12.815060 delete from "invoice_tag_test"; [] gorptest: 13:46:12.816874 delete from "alias_trans_field_test"; [] gorptest: 13:46:12.818658 delete from "invoice_override_test"; [] gorptest: 13:46:12.820520 delete from "person_test"; [] gorptest: 13:46:12.822421 delete from "ignored_column_test"; [] gorptest: 13:46:12.824245 delete from "id_created_test"; [] gorptest: 13:46:12.826158 delete from "type_conv_test"; [] gorptest: 13:46:12.828468 delete from "embedded_struct_test"; [] gorptest: 13:46:12.830407 delete from "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.832172 delete from "embedded_autoincr_test"; [] gorptest: 13:46:12.834018 delete from "time_test"; [] gorptest: 13:46:12.836004 delete from "id_created_test"; [] gorptest: 13:46:12.838036 delete from "single_column_table"; [] gorptest: 13:46:12.839988 update "single_column_table" set "SomeId"=? where "SomeId"=?; [1:"A Unique Id String" 2:"A Unique Id String"] gorptest: 13:46:12.840079 drop table if exists "invoice_test"; [] gorptest: 13:46:12.842252 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.844246 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.846078 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.847942 drop table if exists "person_test"; [] gorptest: 13:46:12.849931 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.851967 drop table if exists "id_created_test"; [] gorptest: 13:46:12.854115 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.855985 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.857860 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.859618 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.861673 drop table if exists "time_test"; [] gorptest: 13:46:12.863498 drop table if exists "id_created_test"; [] gorptest: 13:46:12.863555 drop table if exists "single_column_table"; [] 2025/04/01 13:46:12 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: 13:46:12.865806 drop table if exists "invoice_test"; [] gorptest: 13:46:12.866025 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.866042 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.866053 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.866070 drop table if exists "person_test"; [] gorptest: 13:46:12.866082 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.866094 drop table if exists "id_created_test"; [] gorptest: 13:46:12.866106 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.866118 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.866131 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.866142 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.866153 drop table if exists "time_test"; [] gorptest: 13:46:12.866172 create table "invoice_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.868237 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: 13:46:12.870271 create table "alias_trans_field_test" ("id" integer not null primary key autoincrement, "bar" varchar(255)) ; [] gorptest: 13:46:12.872193 create table "invoice_override_test" ("Id" varchar(255) not null primary key, "Created" integer, "Updated" integer, "Memo" varchar(255), "PersonId" integer, "IsPaid" integer) ; [] gorptest: 13:46:12.874240 create table "person_test" ("Id" integer not null primary key autoincrement, "Created" integer, "Updated" integer, "FName" varchar(255), "LName" varchar(255), "Version" integer) ; [] gorptest: 13:46:12.876302 create table "ignored_column_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.878412 create table "id_created_test" ("Id" integer not null primary key autoincrement, "Created" integer) ; [] gorptest: 13:46:12.880453 create table "type_conv_test" ("Id" integer not null primary key autoincrement, "PersonJSON" varchar(255), "Name" varchar(255)) ; [] gorptest: 13:46:12.882538 create table "embedded_struct_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255)) ; [] gorptest: 13:46:12.884784 create table "embedded_struct_before_autoincr_test" ("FirstName" varchar(255), "LastName" varchar(255), "Id" integer not null primary key autoincrement) ; [] gorptest: 13:46:12.887037 create table "embedded_autoincr_test" ("Id" integer not null primary key autoincrement, "FirstName" varchar(255), "LastName" varchar(255), "MiddleName" varchar(255)) ; [] gorptest: 13:46:12.889212 create table "time_test" ("Id" integer not null primary key autoincrement, "Time" datetime) ; [] gorptest: 13:46:12.891306 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-foo" 4:0 5:false] gorptest: 13:46:12.893276 insert into "invoice_test" ("Id","Created","Updated","Memo","PersonId","IsPaid") values (null,?,?,?,?,?); [1:100 2:200 3:"prepare-bar" 4:0 5:false] gorptest: 13:46:12.895518 UPDATE invoice_test SET Memo=? WHERE Id=? [1:] gorptest: 13:46:12.897424 SELECT * from invoice_test WHERE Memo='prepare-baz' [] gorptest: 13:46:12.897561 begin; [] gorptest: 13:46:12.897590 UPDATE invoice_test SET IsPaid=? WHERE Id=? [1:] gorptest: 13:46:12.897708 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:12.897989 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:12.898052 commit; [] gorptest: 13:46:12.899996 SELECT * from invoice_test WHERE IsPaid=? [1:true] gorptest: 13:46:12.900110 drop table if exists "invoice_test"; [] gorptest: 13:46:12.902309 drop table if exists "invoice_tag_test"; [] gorptest: 13:46:12.904701 drop table if exists "alias_trans_field_test"; [] gorptest: 13:46:12.907031 drop table if exists "invoice_override_test"; [] gorptest: 13:46:12.909162 drop table if exists "person_test"; [] gorptest: 13:46:12.911238 drop table if exists "ignored_column_test"; [] gorptest: 13:46:12.913341 drop table if exists "id_created_test"; [] gorptest: 13:46:12.915449 drop table if exists "type_conv_test"; [] gorptest: 13:46:12.917468 drop table if exists "embedded_struct_test"; [] gorptest: 13:46:12.919429 drop table if exists "embedded_struct_before_autoincr_test"; [] gorptest: 13:46:12.921421 drop table if exists "embedded_autoincr_test"; [] gorptest: 13:46:12.923249 drop table if exists "time_test"; [] gorptest: 13:46:12.925430 drop table if exists "id_created_test"; [] PASS ok gopkg.in/gorp.v1 1.482s + RPM_EC=0 ++ jobs -p + exit 0 Processing files: golang-gopkg-gorp-1-devel-1.7.2-12.fc43.noarch Executing(%doc): /bin/sh -e /var/tmp/rpm-tmp.UVrCx1 + umask 022 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build + cd gorp-1.7.2 + DOCDIR=/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/doc/golang-gopkg-gorp-1-devel + export LC_ALL=C.UTF-8 + LC_ALL=C.UTF-8 + export DOCDIR + /usr/bin/mkdir -p /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/doc/golang-gopkg-gorp-1-devel + cp -pr /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/README.md /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/doc/golang-gopkg-gorp-1-devel + RPM_EC=0 ++ jobs -p + exit 0 Executing(%license): /bin/sh -e /var/tmp/rpm-tmp.7PaCt6 + umask 022 + cd /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build + cd gorp-1.7.2 + LICENSEDIR=/builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/licenses/golang-gopkg-gorp-1-devel + export LC_ALL=C.UTF-8 + LC_ALL=C.UTF-8 + export LICENSEDIR + /usr/bin/mkdir -p /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/usr/share/licenses/golang-gopkg-gorp-1-devel + cp -pr /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/gorp-1.7.2/LICENSE /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT/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-12.fc43 golang-gopkg-gorp-1-devel = 1.7.2-12.fc43 golang-ipath(gopkg.in/gorp.v1) = 1.7.2-12.fc43 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-12.fc43.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-12.fc43 golang(github.com/go-gorp/gorp/v1) = 1.7.2-12.fc43 golang-symlink(github.com/go-gorp/gorp/v1) = 1.7.2-12.fc43 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-12.fc43 Obsoletes: golang-github-gorp-1-devel < 1.7.2-12.fc43 Checking for unpackaged file(s): /usr/lib/rpm/check-files /builddir/build/BUILD/golang-gopkg-gorp-1-1.7.2-build/BUILDROOT Wrote: /builddir/build/RPMS/compat-golang-github-gorp-1-devel-1.7.2-12.fc43.noarch.rpm Wrote: /builddir/build/RPMS/golang-gopkg-gorp-1-devel-1.7.2-12.fc43.noarch.rpm Child return code was: 0