Access dataVersion for component definitions from GetClientSideWebParts

Category

[X] Question
[ ] Typo
[ ] Bug
[ ] Additional article idea

Expected or Desired Behavior
When I get the list of available components from the GetClientSideWebParts call I can then add them to the page as well as set properties. When I get the definitions there is no dataVersion anywhere in the component definition (please let me know if I missed it) so we always default to 1.0.
Is there a way to know the correct/latest dataVersion so we can set it correctly when creating web parts
Observed Behavior
Some properties do not "work" until I also update the dataVersion. You can see full explanation in this issue.
Steps to Reproduce
This code uses latest version of pnpjs libraries
npm install @pnp/logging @pnp/common @pnp/odata @pnp/sp
import { sp, ClientSideWebpart } from "@pnp/sp";

const partDefs = await sp.web.getClientSideWebParts();

// this is person web part
const yy = partDefs.filter(d => d.Id.startsWith("7f7184"));

const part = ClientSideWebpart.fromComponentDef(yy[0]);

part.setProperties({
    layout: 2,
    persons: [{
        id<EMAIL_ADDRESS>    }],
});

// FORCE dataVersion - can't do this in current pnp release, will change for upcoming
// the property is there it is just protected
(<any>part).dataVersion = "1.2";

const page = await ClientSidePage.fromFile(sp.web.getFileByServerRelativeUrl("/sites/dev/sitepages/Test_8q5L.aspx"));

page.addSection().addControl(part);

await page.save();

@waldekmastykarz since you are interested.

Thank you for your feedback.
Data version is not in the manifest as it's a runtime value. It depends on the actual code that's executing.
The reason behind this is that a web part could have a manifest pointing at a URL in the CDN that may get updated with a JS fix. If that changed the serialized data, a change in the data version would be required, but the manifest would never be updated.
From the pnp issue, I checked the People web part, and the layout property was added in data version 1.1, so using 1.0 will enforce the layout to be Compact (the default at the time).
When enforcing the properties of a web part externally, you should be aware of which data version are you using, as the web part code may run code to modify the properties to map with its current data version. This is done to ensure backwards compatibility regardless of when the web part was added to the page.
In order to check the data version, you can check the serialized data of the web part. BaseClientSideWebPart.dataVersion is the data version, and it defaults to 1.0

@mpasarin - when I add a web part through code how would one even know what data version is correct? Is there not a way to publish the latest version somehow in the manifest? Yes, if I add the web part manually and then pull down the content I can see the version - for folks trying to provision through code - is the idea they would have to do this step for each web part to ensure they have the correct data version?

Hi @patrick-rodgers - going through old bugs.  No, there currently isn't a documented way to know the latest data version for 1st party webparts.


Dynex v.2.2.2(b) Illegal instruction (core dumped)

Downloading the binaries for  v.2.2.2 or  v.2.2.2b Dynex-main-7106974-ubuntu-20.04-linux-x64-[all] and running the software using the command
./dynexd
./simplewallet
./walletd
as described in the documentation, all fail with:
Illegal instruction (core dumped) error.

I got the same error

Same issue here with the precompiled binaries for ubuntu 22.04. Compiled from source works fine except for errors syncing at block 108000

22.04 precompiled binaries in the new 2.2.2c still exhibit Illegal instruction error

Build it from source, this way it works. Follow the instructions from the Readme


Cannot login/register

Cannot login as admin or create user as visitor, possible due to inexistent .js/.css files (again)
Strangely enough, I've been able to login for one time after finally managing to install the script (see the link above), and in the DB I appear as Logged in! in the status field, table admins_log_login
For example, the admin login page (admin123) loads the script https://datesite.com/asset/js/mailcheckConfig.js, however the script request ends in 404. I'd upload an image but can't see an option here. So the following resources are missing:
/asset/js/mailcheckConfig.js
/asset/js/script.js
/asset/css/style.css
/asset/css/color.css
/asset/gzip/?t=css&d=templates/themes/datelove/css/&f=menu_inverse.css

found the attach files option :)

Never mind, too many things to fix. I'll just go back to the old osdate or maybe buddypress.

dont work on demo either https://www.softaculous.com/demos/pH7CMS


Update a PUBLISHED subset

Bug
It should be possible to update name, validUntil, shortDescription, description, createdBy, administrativeDetails.administrativeType('ANNOTATION').values.
The change has to affect all published versions of the subset.
Solution A:

write a patch to the last version and pick this data up for the earlier versions.
write a patch to each existent version to avoid merge;

Example:
Storage:
[
{ name: A, version: 1.0.0, DRAFT },
{ name: A, version: 1.0.1, OPEN},
{ name: A, version: 2.0.0, OPEN},
{ name: B, version: 2.0.1, OPEN }, /updated name/
{ name: C, version: 3.0.0, DRAFT },
]
GET /versions
[
{ name: B, version: 1.0.1, OPEN },
{ name: B, version: 2.0.0, OPEN },
{ name: C, version: 3.0.0, DRAFT },
]

Solution:
In GET /versions
After the final list of most recent major versions is built
Find the newest version that is OPEN, and apply the name stored in this version to each previous version.

@alina-lapina validUntil is different for each major version of a subset, and so should not be overwritten. The createdBy might also be different for each major version: The fact that organization A made major version 1 is not changed by the fact that organization B makes major version 2? The description and short description should maybe also be different from version to version, because the version contains different things and so a different description is appropriate. The description might also contain info on why a new version was made, and so it should not be applied to the old versions as well. The only value that I believe should truly overwrite all versions is "name", because we agreed on that with Anne Gro. Do you agree?

validUntil is not version dependent, It is one for the whole subset. It has to be flexible. It can also be null.
Version's validity period is based on verisionValidFrom and next version's versionValidFrom or, if last version, subset's validUntil.
Read a discussion here https://github.com/statisticsnorway/gsim-raml-schema/pull/29

createdBy

The createdBy might also be different for each major version:
The fact that organization A made major version 1 is not changed
by the fact that organization B makes major version 2?

It's interesting. We need Anne Gro's opinion here.


Allow catalog operator removal action

With this commit operator owners are able to remove an operator from a catalog. The removal process is handled by the IIB endpoint and is only supported for FBC operators.
 You can check that for the review process https://github.com/Allda/community-operators-pipeline-preprod/pulls?q=is%3Apr+is%3Aclosed


Replace time with chrono

Adding reqwest-retry in #135 pulled in chrono.  The rest of the code should switch to it so that it's all using a single time library.

Unfortunately, aws-config still uses time, so there's no way around compiling in two time libraries, so there's nothing to be gained from this issue.


Helpy

Hello @geep33 ,
Could you please post the outputs of flutter run -v and flutter doctor -v and a complete minimal reproducible code sample?
Or if you opened this issue by mistake, please close it
Thank you!

Because the issue does not have any valid information, I will close the issue.
I will reopen it if there is a valid information update.


Configuring outbox connector;

The "Expand JSON SMT" (https://github.com/RedHatInsights/expandjsonsmt/)
is used for un-stringifying the outbox event payload. As this SMT only works
for specific fields and not the entire message (see https://github.com/RedHatInsights/expandjsonsmt/issues/10),
the payload is first hoisted into a temporary field, then un-stringified and finally
promoted to the top level of the Kafka message value again.
Hey @kbastani, this gives a nice event structure finally:
{"createdAt":1624638360969,"lastModified":1624638371355,"status":"ORDER_ASSIGNED","accountId":62941725,"restaurant":{"id":4,"storeId":7946,"name":"California & Battery","city":"San Francisco","country":"US","latitude":37.793060302734375,"longitude":-122.3997573852539},"links":[],"orderId":976}

The topic is debezium.Order now. I think you can consume that data and sink it into Pinot now? Or is anything else needed for doing so?

Awesome! I'll merge in and get to work on updating the schema configuration for the Pinot tables.


Get Bruce & Gary up to speed on current security tools

Describe the issue
Currently in AWS we have an overwhelming amount of log and security data flowing from all accounts to some central areas.  There several summary channels in RC that begin with the prefix "public-cloud-security-aws-ECF..." and then we are also shipping all logs down to the SecOps SIEM service.
Additional context

The SecOps SIEM has currently limited operational capacity and support (frequent downtime) and it cannot be queried.  The SecOps SIEM logs are kept for a long time (forever?) but the SIEM ingests the logs as a single JSON blob field, so all the effort CPF put into crafting a nice queryable JSON log format cannot be leveraged.
We also have a new internal SIEM in AWS with this latest upgrade.  This is an OpenSearch solution (not magically deployed - see related ticket) but it is preconfigured to be easy to deploy.  This one is stable and queryable.
We also have CSPM as a snapshot view of our Posture stance, along with a time-series record in Quicksight.

Definition of done

One person will own this ticket, they need to create all the meetings early in the sprint
Meeting with Austin H for access to SecOps SIEM (new password resets)
Access to RC Channels (meeting with Prabhu)
Access to the Quicksite CSPM summary dashboard (Kevin)
Use password manager to store custom credentials (change the default pw asap)
Bruce and Gary get hands-on permanent access to all systems in additional context (except the OpenSearch one because that one is not deployed yet) plus the RC channels
They are comfortable accessing and can start to view events and logs, with the limited scope of getting ideas for future tickets (not solving all security problems)

Had a chat with Gary, Bruce, and Kevin. we had a chat about our current account structure and how we used them to create some solutions
Unfortunately, most of the solutions are still in the dev phase. But Gary and Bruce have access to SecOps SIEM and RC channels.


feat: YDB support in gorm

PR with YDB support to https://github.com/go-gorm/gorm (ORM)

Logs of Basic app with gorm for postgres:

2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:188
[6.102ms] [rows:0] DROP TABLE IF EXISTS "episodes" CASCADE
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:188
[3.477ms] [rows:0] DROP TABLE IF EXISTS "seasons" CASCADE
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:188
[2.664ms] [rows:0] DROP TABLE IF EXISTS "series" CASCADE
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:178
[5.962ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'series' AND table_type = 'BASE TABLE'
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:151
[11.614ms] [rows:0] CREATE TABLE "series" ("series_id" text NOT NULL,"title" text NOT NULL,"series_info" text,"comment" text,"release_date" timestamptz NOT NULL,PRIMARY KEY ("series_id"))
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:178
[1.895ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'seasons' AND table_type = 'BASE TABLE'
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:151
[8.077ms] [rows:0] CREATE TABLE "seasons" ("season_id" text,"series_id" text,"title" text NOT NULL,"first_aired" timestamptz NOT NULL,"last_aired" timestamptz NOT NULL,PRIMARY KEY ("season_id"),CONSTRAINT "fk_series_seasons" FOREIGN KEY ("series_id") REFERENCES "series"("series_id"))
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:119
[4.296ms] [rows:0] CREATE INDEX IF NOT EXISTS "idx_seasons_series_id" ON "seasons" ("series_id")
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:178
[2.673ms] [rows:1] SELECT count(*) FROM information_schema.tables WHERE table_schema = CURRENT_SCHEMA() AND table_name = 'episodes' AND table_type = 'BASE TABLE'
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:151
[9.536ms] [rows:0] CREATE TABLE "episodes" ("episode_id" text,"season_id" text NOT NULL,"title" text NOT NULL,"air_date" timestamptz NOT NULL,PRIMARY KEY ("episode_id"),CONSTRAINT "fk_seasons_episodes" FOREIGN KEY ("season_id") REFERENCES "seasons"("season_id"))
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/gorm-driver-postgres/migrator.go:119
[5.894ms] [rows:0] CREATE INDEX IF NOT EXISTS "idx_episodes_season_id" ON "episodes" ("season_id")
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[15.215ms] [rows:70] INSERT INTO "episodes" ("episode_id","season_id","title","air_date") VALUES ('a4bb791e-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','Yesterday's Jam','2006-02-03 00:00:00'),('a4bb796e-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','Calamity Jen','2006-02-03 00:00:00'),('a4bb7978-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','Fifty-Fifty','2006-02-10 00:00:00'),('a4bb7982-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','The Red Door','2006-02-17 00:00:00'),('a4bb798c-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','The Haunting of Bill Crouse','2006-02-24 00:00:00'),('a4bb7996-9c9a-11ed-adf8-acde48001122','a4ba6d9e-9c9a-11ed-adf7-acde48001122','Aunt Irma Visits','2006-03-03 00:00:00'),('a4bb7996-9c9a-11ed-adf9-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','The Work Outing','2006-08-24 00:00:00'),('a4bb79a0-9c9a-11ed-adf9-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','Return of the Golden Child','2007-08-31 00:00:00'),('a4bb79aa-9c9a-11ed-adf9-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','Moss and the German','2007-09-07 00:00:00'),('a4bb79aa-9c9a-11ed-adfa-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','The Dinner Party','2007-09-14 00:00:00'),('a4bb79b4-9c9a-11ed-adfa-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','Smoke and Mirrors','2007-09-21 00:00:00'),('a4bb79b4-9c9a-11ed-adfb-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','Men Without Women','2007-09-28 00:00:00'),('a4bb79be-9c9a-11ed-adfb-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','From Hell','2008-11-21 00:00:00'),('a4bb79be-9c9a-11ed-adfc-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','Are We Not Men?','2008-11-28 00:00:00'),('a4bb79c8-9c9a-11ed-adfc-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','Tramps Like Us','2008-12-05 00:00:00'),('a4bb79c8-9c9a-11ed-adfd-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','The Speech','2008-12-12 00:00:00'),('a4bb79c8-9c9a-11ed-adfe-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','Friendface','2008-12-19 00:00:00'),('a4bb79d2-9c9a-11ed-adfe-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','Calendar Geeks','2008-12-26 00:00:00'),('a4bb79d2-9c9a-11ed-adff-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','Jen The Fredo','2010-06-25 00:00:00'),('a4bb79dc-9c9a-11ed-adff-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','The Final Countdown','2010-07-02 00:00:00'),('a4bb79dc-9c9a-11ed-ae00-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','Something Happened','2010-07-09 00:00:00'),('a4bb79e6-9c9a-11ed-ae00-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','Italian For Beginners','2010-07-16 00:00:00'),('a4bb79e6-9c9a-11ed-ae01-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','Bad Boys','2010-07-23 00:00:00'),('a4bb79f0-9c9a-11ed-ae01-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','Reynholm vs Reynholm','2010-07-30 00:00:00'),('a4bb79f0-9c9a-11ed-ae02-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Minimum Viable Product','2014-04-06 00:00:00'),('a4bb79f0-9c9a-11ed-ae03-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','The Cap Table','2014-04-13 00:00:00'),('a4bb79fa-9c9a-11ed-ae03-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Articles of Incorporation','2014-04-20 00:00:00'),('a4bb79fa-9c9a-11ed-ae04-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Fiduciary Duties','2014-04-27 00:00:00'),('a4bb7a04-9c9a-11ed-ae04-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Signaling Risk','2014-05-04 00:00:00'),('a4bb7a04-9c9a-11ed-ae05-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Third Party Insourcing','2014-05-11 00:00:00'),('a4bb7a0e-9c9a-11ed-ae05-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Proof of Concept','2014-05-18 00:00:00'),('a4bb7a0e-9c9a-11ed-ae06-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','Optimal Tip-to-Tip Efficiency','2014-06-01 00:00:00'),('a4bb7a18-9c9a-11ed-ae06-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Sand Hill Shuffle','2015-04-12 00:00:00'),('a4bb7a18-9c9a-11ed-ae07-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Runaway Devaluation','2015-04-19 00:00:00'),('a4bb7a22-9c9a-11ed-ae07-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Bad Money','2015-04-26 00:00:00'),('a4bb7a2c-9c9a-11ed-ae07-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','The Lady','2015-05-03 00:00:00'),('a4bb7a2c-9c9a-11ed-ae08-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Server Space','2015-05-10 00:00:00'),('a4bb7a36-9c9a-11ed-ae08-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Homicide','2015-05-17 00:00:00'),('a4bb7a40-9c9a-11ed-ae08-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Adult Content','2015-05-24 00:00:00'),('a4bb7a4a-9c9a-11ed-ae08-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','White Hat/Black Hat','2015-05-31 00:00:00'),('a4bb7a4a-9c9a-11ed-ae09-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Binding Arbitration','2015-06-07 00:00:00'),('a4bb7a54-9c9a-11ed-ae09-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','Two Days of the Condor','2015-06-14 00:00:00'),('a4bb7a68-9c9a-11ed-ae09-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Founder Friendly','2016-04-24 00:00:00'),('a4bb7a72-9c9a-11ed-ae09-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Two in the Box','2016-05-01 00:00:00'),('a4bb7a72-9c9a-11ed-ae0a-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Meinertzhagen's Haversack','2016-05-08 00:00:00'),('a4bb7a7c-9c9a-11ed-ae0a-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Maleant Data Systems Solutions','2016-05-15 00:00:00'),('a4bb7a86-9c9a-11ed-ae0a-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','The Empty Chair','2016-05-22 00:00:00'),('a4bb7a86-9c9a-11ed-ae0b-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Bachmanity Insanity','2016-05-29 00:00:00'),('a4bb7a90-9c9a-11ed-ae0b-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','To Build a Better Beta','2016-06-05 00:00:00'),('a4bb7a9a-9c9a-11ed-ae0b-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Bachman's Earnings Over-Ride','2016-06-12 00:00:00'),('a4bb7a9a-9c9a-11ed-ae0c-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','Daily Active Users','2016-06-19 00:00:00'),('a4bb7aa4-9c9a-11ed-ae0c-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','The Uptick','2016-06-26 00:00:00'),('a4bb7aa4-9c9a-11ed-ae0d-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Success Failure','2017-04-23 00:00:00'),('a4bb7aae-9c9a-11ed-ae0d-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Terms of Service','2017-04-30 00:00:00'),('a4bb7aae-9c9a-11ed-ae0e-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Intellectual Property','2017-05-07 00:00:00'),('a4bb7ab8-9c9a-11ed-ae0e-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Teambuilding Exercise','2017-05-14 00:00:00'),('a4bb7ab8-9c9a-11ed-ae0f-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','The Blood Boy','2017-05-21 00:00:00'),('a4bb7ac2-9c9a-11ed-ae0f-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Customer Service','2017-05-28 00:00:00'),('a4bb7ac2-9c9a-11ed-ae10-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','The Patent Troll','2017-06-04 00:00:00'),('a4bb7acc-9c9a-11ed-ae10-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','The Keenan Vortex','2017-06-11 00:00:00'),('a4bb7acc-9c9a-11ed-ae11-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Hooli-Con','2017-06-18 00:00:00'),('a4bb7ad6-9c9a-11ed-ae11-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','Server Error','2017-06-25 00:00:00'),('a4bb7ad6-9c9a-11ed-ae12-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Grow Fast or Die Slow','2018-03-25 00:00:00'),('a4bb7ad6-9c9a-11ed-ae13-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Reorientation','2018-04-01 00:00:00'),('a4bb7ae0-9c9a-11ed-ae13-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Chief Operating Officer','2018-04-08 00:00:00'),('a4bb7aea-9c9a-11ed-ae13-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Tech Evangelist','2018-04-15 00:00:00'),('a4bb7aea-9c9a-11ed-ae14-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Facial Recognition','2018-04-22 00:00:00'),('a4bb7aea-9c9a-11ed-ae15-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Artificial Emotional Intelligence','2018-04-29 00:00:00'),('a4bb7af4-9c9a-11ed-ae15-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Initial Coin Offering','2018-05-06 00:00:00'),('a4bb7af4-9c9a-11ed-ae16-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122','Fifty-One Percent','2018-05-13 00:00:00') ON CONFLICT ("episode_id") DO UPDATE SET "season_id"="excluded"."season_id"
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[25.419ms] [rows:9] INSERT INTO "seasons" ("season_id","series_id","title","first_aired","last_aired") VALUES ('a4ba6d9e-9c9a-11ed-adf7-acde48001122','a4b99086-9c9a-11ed-adf7-acde48001122','Season 1','2006-02-03 00:00:00','2006-03-03 00:00:00'),('a4ba6db2-9c9a-11ed-adf7-acde48001122','a4b99086-9c9a-11ed-adf7-acde48001122','Season 2','2007-08-24 00:00:00','2007-09-28 00:00:00'),('a4ba6dbc-9c9a-11ed-adf7-acde48001122','a4b99086-9c9a-11ed-adf7-acde48001122','Season 3','2008-11-21 00:00:00','2008-12-26 00:00:00'),('a4ba6e52-9c9a-11ed-adf7-acde48001122','a4b99086-9c9a-11ed-adf7-acde48001122','Season 4','2010-06-25 00:00:00','2010-07-30 00:00:00'),('a4ba6e5c-9c9a-11ed-adf7-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122','Season 1','2006-02-03 00:00:00','2006-03-03 00:00:00'),('a4ba6e66-9c9a-11ed-adf7-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122','Season 2','2007-08-24 00:00:00','2007-09-28 00:00:00'),('a4ba6e70-9c9a-11ed-adf7-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122','Season 3','2008-11-21 00:00:00','2008-12-26 00:00:00'),('a4ba6e70-9c9a-11ed-adf8-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122','Season 4','2010-06-25 00:00:00','2010-07-30 00:00:00'),('a4ba6e7a-9c9a-11ed-adf8-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122','Season 5','2018-03-25 00:00:00','2018-05-13 00:00:00') ON CONFLICT ("season_id") DO UPDATE SET "series_id"="excluded"."series_id"
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[39.069ms] [rows:2] INSERT INTO "series" ("series_id","title","series_info","comment","release_date") VALUES ('a4b99086-9c9a-11ed-adf7-acde48001122','IT Crowd','The IT Crowd is a British sitcom produced by Channel 4, written by Graham Linehan, produced by Ash Atalla and starring Chris O'Dowd, Richard Ayoade, Katherine Parkinson, and Matt Berry.','','2006-02-03 00:00:00'),('a4b9970c-9c9a-11ed-adf7-acde48001122','Silicon Valley','Silicon Valley is an American comedy television series created by Mike Judge, John Altschuler and Dave Krinsky. The series focuses on five young men who founded a startup company in Silicon Valley.','','2014-04-06 00:00:00')
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[6.471ms] [rows:70] SELECT * FROM "episodes" WHERE "episodes"."season_id" IN ('a4ba6d9e-9c9a-11ed-adf7-acde48001122','a4ba6db2-9c9a-11ed-adf7-acde48001122','a4ba6dbc-9c9a-11ed-adf7-acde48001122','a4ba6e52-9c9a-11ed-adf7-acde48001122','a4ba6e5c-9c9a-11ed-adf7-acde48001122','a4ba6e66-9c9a-11ed-adf7-acde48001122','a4ba6e70-9c9a-11ed-adf7-acde48001122','a4ba6e70-9c9a-11ed-adf8-acde48001122','a4ba6e7a-9c9a-11ed-adf8-acde48001122')
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[12.952ms] [rows:9] SELECT * FROM "seasons" WHERE "seasons"."series_id" IN ('a4b99086-9c9a-11ed-adf7-acde48001122','a4b9970c-9c9a-11ed-adf7-acde48001122')
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[19.443ms] [rows:2] SELECT * FROM "series"
2023/01/25 13:25:52 all known series:
2023/01/25 13:25:52   > [a4b99086-9c9a-11ed-adf7-acde48001122]     IT Crowd (2006)
2023/01/25 13:25:52     > [a4ba6d9e-9c9a-11ed-adf7-acde48001122]   Season 1
2023/01/25 13:25:52       > [a4bb791e-9c9a-11ed-adf8-acde48001122] [2006-02-03] Yesterday's Jam
2023/01/25 13:25:52       > [a4bb796e-9c9a-11ed-adf8-acde48001122] [2006-02-03] Calamity Jen
2023/01/25 13:25:52       > [a4bb7978-9c9a-11ed-adf8-acde48001122] [2006-02-10] Fifty-Fifty
2023/01/25 13:25:52       > [a4bb7982-9c9a-11ed-adf8-acde48001122] [2006-02-17] The Red Door
2023/01/25 13:25:52       > [a4bb798c-9c9a-11ed-adf8-acde48001122] [2006-02-24] The Haunting of Bill Crouse
2023/01/25 13:25:52       > [a4bb7996-9c9a-11ed-adf8-acde48001122] [2006-03-03] Aunt Irma Visits
2023/01/25 13:25:52     > [a4ba6db2-9c9a-11ed-adf7-acde48001122]   Season 2
2023/01/25 13:25:52       > [a4bb7996-9c9a-11ed-adf9-acde48001122] [2006-08-24] The Work Outing
2023/01/25 13:25:52       > [a4bb79a0-9c9a-11ed-adf9-acde48001122] [2007-08-31] Return of the Golden Child
2023/01/25 13:25:52       > [a4bb79aa-9c9a-11ed-adf9-acde48001122] [2007-09-07] Moss and the German
2023/01/25 13:25:52       > [a4bb79aa-9c9a-11ed-adfa-acde48001122] [2007-09-14] The Dinner Party
2023/01/25 13:25:52       > [a4bb79b4-9c9a-11ed-adfa-acde48001122] [2007-09-21] Smoke and Mirrors
2023/01/25 13:25:52       > [a4bb79b4-9c9a-11ed-adfb-acde48001122] [2007-09-28] Men Without Women
2023/01/25 13:25:52     > [a4ba6dbc-9c9a-11ed-adf7-acde48001122]   Season 3
2023/01/25 13:25:52       > [a4bb79be-9c9a-11ed-adfb-acde48001122] [2008-11-21] From Hell
2023/01/25 13:25:52       > [a4bb79be-9c9a-11ed-adfc-acde48001122] [2008-11-28] Are We Not Men?
2023/01/25 13:25:52       > [a4bb79c8-9c9a-11ed-adfc-acde48001122] [2008-12-05] Tramps Like Us
2023/01/25 13:25:52       > [a4bb79c8-9c9a-11ed-adfd-acde48001122] [2008-12-12] The Speech
2023/01/25 13:25:52       > [a4bb79c8-9c9a-11ed-adfe-acde48001122] [2008-12-19] Friendface
2023/01/25 13:25:52       > [a4bb79d2-9c9a-11ed-adfe-acde48001122] [2008-12-26] Calendar Geeks
2023/01/25 13:25:52     > [a4ba6e52-9c9a-11ed-adf7-acde48001122]   Season 4
2023/01/25 13:25:52       > [a4bb79d2-9c9a-11ed-adff-acde48001122] [2010-06-25] Jen The Fredo
2023/01/25 13:25:52       > [a4bb79dc-9c9a-11ed-adff-acde48001122] [2010-07-02] The Final Countdown
2023/01/25 13:25:52       > [a4bb79dc-9c9a-11ed-ae00-acde48001122] [2010-07-09] Something Happened
2023/01/25 13:25:52       > [a4bb79e6-9c9a-11ed-ae00-acde48001122] [2010-07-16] Italian For Beginners
2023/01/25 13:25:52       > [a4bb79e6-9c9a-11ed-ae01-acde48001122] [2010-07-23] Bad Boys
2023/01/25 13:25:52       > [a4bb79f0-9c9a-11ed-ae01-acde48001122] [2010-07-30] Reynholm vs Reynholm
2023/01/25 13:25:52   > [a4b9970c-9c9a-11ed-adf7-acde48001122]     Silicon Valley (2014)
2023/01/25 13:25:52     > [a4ba6e5c-9c9a-11ed-adf7-acde48001122]   Season 1
2023/01/25 13:25:52       > [a4bb79f0-9c9a-11ed-ae02-acde48001122] [2014-04-06] Minimum Viable Product
2023/01/25 13:25:52       > [a4bb79f0-9c9a-11ed-ae03-acde48001122] [2014-04-13] The Cap Table
2023/01/25 13:25:52       > [a4bb79fa-9c9a-11ed-ae03-acde48001122] [2014-04-20] Articles of Incorporation
2023/01/25 13:25:52       > [a4bb79fa-9c9a-11ed-ae04-acde48001122] [2014-04-27] Fiduciary Duties
2023/01/25 13:25:52       > [a4bb7a04-9c9a-11ed-ae04-acde48001122] [2014-05-04] Signaling Risk
2023/01/25 13:25:52       > [a4bb7a04-9c9a-11ed-ae05-acde48001122] [2014-05-11] Third Party Insourcing
2023/01/25 13:25:52       > [a4bb7a0e-9c9a-11ed-ae05-acde48001122] [2014-05-18] Proof of Concept
2023/01/25 13:25:52       > [a4bb7a0e-9c9a-11ed-ae06-acde48001122] [2014-06-01] Optimal Tip-to-Tip Efficiency
2023/01/25 13:25:52     > [a4ba6e66-9c9a-11ed-adf7-acde48001122]   Season 2
2023/01/25 13:25:52       > [a4bb7a18-9c9a-11ed-ae06-acde48001122] [2015-04-12] Sand Hill Shuffle
2023/01/25 13:25:52       > [a4bb7a18-9c9a-11ed-ae07-acde48001122] [2015-04-19] Runaway Devaluation
2023/01/25 13:25:52       > [a4bb7a22-9c9a-11ed-ae07-acde48001122] [2015-04-26] Bad Money
2023/01/25 13:25:52       > [a4bb7a2c-9c9a-11ed-ae07-acde48001122] [2015-05-03] The Lady
2023/01/25 13:25:52       > [a4bb7a2c-9c9a-11ed-ae08-acde48001122] [2015-05-10] Server Space
2023/01/25 13:25:52       > [a4bb7a36-9c9a-11ed-ae08-acde48001122] [2015-05-17] Homicide
2023/01/25 13:25:52       > [a4bb7a40-9c9a-11ed-ae08-acde48001122] [2015-05-24] Adult Content
2023/01/25 13:25:52       > [a4bb7a4a-9c9a-11ed-ae08-acde48001122] [2015-05-31] White Hat/Black Hat
2023/01/25 13:25:52       > [a4bb7a4a-9c9a-11ed-ae09-acde48001122] [2015-06-07] Binding Arbitration
2023/01/25 13:25:52       > [a4bb7a54-9c9a-11ed-ae09-acde48001122] [2015-06-14] Two Days of the Condor
2023/01/25 13:25:52     > [a4ba6e70-9c9a-11ed-adf7-acde48001122]   Season 3
2023/01/25 13:25:52       > [a4bb7a68-9c9a-11ed-ae09-acde48001122] [2016-04-24] Founder Friendly
2023/01/25 13:25:52       > [a4bb7a72-9c9a-11ed-ae09-acde48001122] [2016-05-01] Two in the Box
2023/01/25 13:25:52       > [a4bb7a72-9c9a-11ed-ae0a-acde48001122] [2016-05-08] Meinertzhagen's Haversack
2023/01/25 13:25:52       > [a4bb7a7c-9c9a-11ed-ae0a-acde48001122] [2016-05-15] Maleant Data Systems Solutions
2023/01/25 13:25:52       > [a4bb7a86-9c9a-11ed-ae0a-acde48001122] [2016-05-22] The Empty Chair
2023/01/25 13:25:52       > [a4bb7a86-9c9a-11ed-ae0b-acde48001122] [2016-05-29] Bachmanity Insanity
2023/01/25 13:25:52       > [a4bb7a90-9c9a-11ed-ae0b-acde48001122] [2016-06-05] To Build a Better Beta
2023/01/25 13:25:52       > [a4bb7a9a-9c9a-11ed-ae0b-acde48001122] [2016-06-12] Bachman's Earnings Over-Ride
2023/01/25 13:25:52       > [a4bb7a9a-9c9a-11ed-ae0c-acde48001122] [2016-06-19] Daily Active Users
2023/01/25 13:25:52       > [a4bb7aa4-9c9a-11ed-ae0c-acde48001122] [2016-06-26] The Uptick
2023/01/25 13:25:52     > [a4ba6e70-9c9a-11ed-adf8-acde48001122]   Season 4
2023/01/25 13:25:52       > [a4bb7aa4-9c9a-11ed-ae0d-acde48001122] [2017-04-23] Success Failure
2023/01/25 13:25:52       > [a4bb7aae-9c9a-11ed-ae0d-acde48001122] [2017-04-30] Terms of Service
2023/01/25 13:25:52       > [a4bb7aae-9c9a-11ed-ae0e-acde48001122] [2017-05-07] Intellectual Property
2023/01/25 13:25:52       > [a4bb7ab8-9c9a-11ed-ae0e-acde48001122] [2017-05-14] Teambuilding Exercise
2023/01/25 13:25:52       > [a4bb7ab8-9c9a-11ed-ae0f-acde48001122] [2017-05-21] The Blood Boy
2023/01/25 13:25:52       > [a4bb7ac2-9c9a-11ed-ae0f-acde48001122] [2017-05-28] Customer Service
2023/01/25 13:25:52       > [a4bb7ac2-9c9a-11ed-ae10-acde48001122] [2017-06-04] The Patent Troll
2023/01/25 13:25:52       > [a4bb7acc-9c9a-11ed-ae10-acde48001122] [2017-06-11] The Keenan Vortex
2023/01/25 13:25:52       > [a4bb7acc-9c9a-11ed-ae11-acde48001122] [2017-06-18] Hooli-Con
2023/01/25 13:25:52       > [a4bb7ad6-9c9a-11ed-ae11-acde48001122] [2017-06-25] Server Error
2023/01/25 13:25:52     > [a4ba6e7a-9c9a-11ed-adf8-acde48001122]   Season 5
2023/01/25 13:25:52       > [a4bb7ad6-9c9a-11ed-ae12-acde48001122] [2018-03-25] Grow Fast or Die Slow
2023/01/25 13:25:52       > [a4bb7ad6-9c9a-11ed-ae13-acde48001122] [2018-04-01] Reorientation
2023/01/25 13:25:52       > [a4bb7ae0-9c9a-11ed-ae13-acde48001122] [2018-04-08] Chief Operating Officer
2023/01/25 13:25:52       > [a4bb7aea-9c9a-11ed-ae13-acde48001122] [2018-04-15] Tech Evangelist
2023/01/25 13:25:52       > [a4bb7aea-9c9a-11ed-ae14-acde48001122] [2018-04-22] Facial Recognition
2023/01/25 13:25:52       > [a4bb7aea-9c9a-11ed-ae15-acde48001122] [2018-04-29] Artificial Emotional Intelligence
2023/01/25 13:25:52       > [a4bb7af4-9c9a-11ed-ae15-acde48001122] [2018-05-06] Initial Coin Offering
2023/01/25 13:25:52       > [a4bb7af4-9c9a-11ed-ae16-acde48001122] [2018-05-13] Fifty-One Percent
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:112
[5.779ms] [rows:2] SELECT * FROM "episodes" WHERE "title" LIKE '%Bad%'
2023/01/25 13:25:52 all episodes with title with word 'bad':
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[3.354ms] [rows:1] SELECT * FROM "seasons" WHERE "seasons"."season_id" = 'a4ba6e52-9c9a-11ed-adf7-acde48001122' LIMIT 1
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[3.090ms] [rows:1] SELECT * FROM "series" WHERE "series"."series_id" = 'a4b99086-9c9a-11ed-adf7-acde48001122' LIMIT 1
2023/01/25 13:25:52   > [a4b99086-9c9a-11ed-adf7-acde48001122]     IT Crowd (2006)
2023/01/25 13:25:52     > [a4ba6e52-9c9a-11ed-adf7-acde48001122]   Season 4
2023/01/25 13:25:52       > [a4bb79e6-9c9a-11ed-ae01-acde48001122] [2010-07-23] Bad Boys
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[3.218ms] [rows:1] SELECT * FROM "seasons" WHERE "seasons"."season_id" = 'a4ba6e66-9c9a-11ed-adf7-acde48001122' LIMIT 1
2023/01/25 13:25:52 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[1.783ms] [rows:1] SELECT * FROM "series" WHERE "series"."series_id" = 'a4b9970c-9c9a-11ed-adf7-acde48001122' LIMIT 1
2023/01/25 13:25:52   > [a4b9970c-9c9a-11ed-adf7-acde48001122]     Silicon Valley (2014)
2023/01/25 13:25:52     > [a4ba6e66-9c9a-11ed-adf7-acde48001122]   Season 2
2023/01/25 13:25:52       > [a4bb7a22-9c9a-11ed-ae07-acde48001122] [2015-04-26] Bad Money
Exiting.

Logs of Basic app with gorm for sqlite3:

2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:21
[0.062ms] [rows:1] PRAGMA foreign_keys
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:45
[6.040ms] [rows:0] DROP TABLE IF EXISTS episodes
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:45
[2.847ms] [rows:0] DROP TABLE IF EXISTS seasons
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:45
[2.676ms] [rows:0] DROP TABLE IF EXISTS series
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:33
[0.065ms] [rows:-] SELECT count(*) FROM sqlite_master WHERE type='table' AND name="series"
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:71
[1.551ms] [rows:0] CREATE TABLE series (series_id text NOT NULL,title text NOT NULL,series_info text,comment text,release_date datetime NOT NULL,PRIMARY KEY (series_id))
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:33
[0.106ms] [rows:-] SELECT count(*) FROM sqlite_master WHERE type='table' AND name="seasons"
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:71
[1.545ms] [rows:0] CREATE TABLE seasons (season_id text,series_id text,title text NOT NULL,first_aired datetime NOT NULL,last_aired datetime NOT NULL,PRIMARY KEY (season_id),CONSTRAINT fk_series_seasons FOREIGN KEY (series_id) REFERENCES series(series_id))
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:293
[1.379ms] [rows:0] CREATE INDEX idx_seasons_series_id ON seasons(series_id)
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:33
[0.080ms] [rows:-] SELECT count(*) FROM sqlite_master WHERE type='table' AND name="episodes"
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:71
[1.672ms] [rows:0] CREATE TABLE episodes (episode_id text,season_id text NOT NULL,title text NOT NULL,air_date datetime NOT NULL,PRIMARY KEY (episode_id),CONSTRAINT fk_seasons_episodes FOREIGN KEY (season_id) REFERENCES seasons(season_id))
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/gorm-driver-sqlite/migrator.go:293
[1.566ms] [rows:0] CREATE INDEX idx_episodes_season_id ON episodes(season_id)
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[1.950ms] [rows:70] INSERT INTO episodes (episode_id,season_id,title,air_date) VALUES ("75a602d8-9c9b-11ed-85df-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","Yesterday's Jam","2006-02-03 00:00:00"),("75a60328-9c9b-11ed-85df-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","Calamity Jen","2006-02-03 00:00:00"),("75a60332-9c9b-11ed-85df-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","Fifty-Fifty","2006-02-10 00:00:00"),("75a6033c-9c9b-11ed-85df-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","The Red Door","2006-02-17 00:00:00"),("75a60350-9c9b-11ed-85df-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","The Haunting of Bill Crouse","2006-02-24 00:00:00"),("75a60350-9c9b-11ed-85e0-acde48001122","75a5737c-9c9b-11ed-85dd-acde48001122","Aunt Irma Visits","2006-03-03 00:00:00"),("75a60364-9c9b-11ed-85e0-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","The Work Outing","2006-08-24 00:00:00"),("75a6036e-9c9b-11ed-85e0-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","Return of the Golden Child","2007-08-31 00:00:00"),("75a6036e-9c9b-11ed-85e1-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","Moss and the German","2007-09-07 00:00:00"),("75a60378-9c9b-11ed-85e1-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","The Dinner Party","2007-09-14 00:00:00"),("75a60382-9c9b-11ed-85e1-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","Smoke and Mirrors","2007-09-21 00:00:00"),("75a6038c-9c9b-11ed-85e1-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","Men Without Women","2007-09-28 00:00:00"),("75a60396-9c9b-11ed-85e1-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","From Hell","2008-11-21 00:00:00"),("75a603a0-9c9b-11ed-85e1-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","Are We Not Men?","2008-11-28 00:00:00"),("75a603a0-9c9b-11ed-85e2-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","Tramps Like Us","2008-12-05 00:00:00"),("75a603aa-9c9b-11ed-85e2-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","The Speech","2008-12-12 00:00:00"),("75a603b4-9c9b-11ed-85e2-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","Friendface","2008-12-19 00:00:00"),("75a603be-9c9b-11ed-85e2-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","Calendar Geeks","2008-12-26 00:00:00"),("75a603be-9c9b-11ed-85e3-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","Jen The Fredo","2010-06-25 00:00:00"),("75a603c8-9c9b-11ed-85e3-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","The Final Countdown","2010-07-02 00:00:00"),("75a603d2-9c9b-11ed-85e3-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","Something Happened","2010-07-09 00:00:00"),("75a603e6-9c9b-11ed-85e3-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","Italian For Beginners","2010-07-16 00:00:00"),("75a603f0-9c9b-11ed-85e3-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","Bad Boys","2010-07-23 00:00:00"),("75a603f0-9c9b-11ed-85e4-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","Reynholm vs Reynholm","2010-07-30 00:00:00"),("75a603fa-9c9b-11ed-85e4-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Minimum Viable Product","2014-04-06 00:00:00"),("75a60404-9c9b-11ed-85e4-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","The Cap Table","2014-04-13 00:00:00"),("75a6040e-9c9b-11ed-85e4-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Articles of Incorporation","2014-04-20 00:00:00"),("75a6040e-9c9b-11ed-85e5-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Fiduciary Duties","2014-04-27 00:00:00"),("75a60418-9c9b-11ed-85e5-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Signaling Risk","2014-05-04 00:00:00"),("75a60418-9c9b-11ed-85e6-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Third Party Insourcing","2014-05-11 00:00:00"),("75a60422-9c9b-11ed-85e6-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Proof of Concept","2014-05-18 00:00:00"),("75a6047c-9c9b-11ed-85e6-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","Optimal Tip-to-Tip Efficiency","2014-06-01 00:00:00"),("75a6047c-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Sand Hill Shuffle","2015-04-12 00:00:00"),("75a60486-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Runaway Devaluation","2015-04-19 00:00:00"),("75a60490-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Bad Money","2015-04-26 00:00:00"),("75a6049a-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","The Lady","2015-05-03 00:00:00"),("75a604a4-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Server Space","2015-05-10 00:00:00"),("75a604ae-9c9b-11ed-85e7-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Homicide","2015-05-17 00:00:00"),("75a604ae-9c9b-11ed-85e8-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Adult Content","2015-05-24 00:00:00"),("75a604b8-9c9b-11ed-85e8-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","White Hat/Black Hat","2015-05-31 00:00:00"),("75a604c2-9c9b-11ed-85e8-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Binding Arbitration","2015-06-07 00:00:00"),("75a604c2-9c9b-11ed-85e9-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","Two Days of the Condor","2015-06-14 00:00:00"),("75a604cc-9c9b-11ed-85e9-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Founder Friendly","2016-04-24 00:00:00"),("75a6051c-9c9b-11ed-85e9-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Two in the Box","2016-05-01 00:00:00"),("75a6051c-9c9b-11ed-85ea-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Meinertzhagen's Haversack","2016-05-08 00:00:00"),("75a60526-9c9b-11ed-85ea-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Maleant Data Systems Solutions","2016-05-15 00:00:00"),("75a60530-9c9b-11ed-85ea-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","The Empty Chair","2016-05-22 00:00:00"),("75a6053a-9c9b-11ed-85ea-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Bachmanity Insanity","2016-05-29 00:00:00"),("75a6053a-9c9b-11ed-85eb-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","To Build a Better Beta","2016-06-05 00:00:00"),("75a60544-9c9b-11ed-85eb-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Bachman's Earnings Over-Ride","2016-06-12 00:00:00"),("75a6054e-9c9b-11ed-85eb-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","Daily Active Users","2016-06-19 00:00:00"),("75a6054e-9c9b-11ed-85ec-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","The Uptick","2016-06-26 00:00:00"),("75a60558-9c9b-11ed-85ec-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Success Failure","2017-04-23 00:00:00"),("75a60562-9c9b-11ed-85ec-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Terms of Service","2017-04-30 00:00:00"),("75a60562-9c9b-11ed-85ed-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Intellectual Property","2017-05-07 00:00:00"),("75a6056c-9c9b-11ed-85ed-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Teambuilding Exercise","2017-05-14 00:00:00"),("75a60576-9c9b-11ed-85ed-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","The Blood Boy","2017-05-21 00:00:00"),("75a60576-9c9b-11ed-85ee-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Customer Service","2017-05-28 00:00:00"),("75a60580-9c9b-11ed-85ee-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","The Patent Troll","2017-06-04 00:00:00"),("75a6058a-9c9b-11ed-85ee-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","The Keenan Vortex","2017-06-11 00:00:00"),("75a6058a-9c9b-11ed-85ef-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Hooli-Con","2017-06-18 00:00:00"),("75a6058a-9c9b-11ed-85f0-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","Server Error","2017-06-25 00:00:00"),("75a60594-9c9b-11ed-85f0-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Grow Fast or Die Slow","2018-03-25 00:00:00"),("75a60594-9c9b-11ed-85f1-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Reorientation","2018-04-01 00:00:00"),("75a6059e-9c9b-11ed-85f1-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Chief Operating Officer","2018-04-08 00:00:00"),("75a6059e-9c9b-11ed-85f2-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Tech Evangelist","2018-04-15 00:00:00"),("75a6059e-9c9b-11ed-85f3-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Facial Recognition","2018-04-22 00:00:00"),("75a605a8-9c9b-11ed-85f3-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Artificial Emotional Intelligence","2018-04-29 00:00:00"),("75a605a8-9c9b-11ed-85f4-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Initial Coin Offering","2018-05-06 00:00:00"),("75a605b2-9c9b-11ed-85f4-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122","Fifty-One Percent","2018-05-13 00:00:00") ON CONFLICT (episode_id) DO UPDATE SET season_id=excluded.season_id
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[8.927ms] [rows:9] INSERT INTO seasons (season_id,series_id,title,first_aired,last_aired) VALUES ("75a5737c-9c9b-11ed-85dd-acde48001122","75a54492-9c9b-11ed-85dd-acde48001122","Season 1","2006-02-03 00:00:00","2006-03-03 00:00:00"),("75a573a4-9c9b-11ed-85dd-acde48001122","75a54492-9c9b-11ed-85dd-acde48001122","Season 2","2007-08-24 00:00:00","2007-09-28 00:00:00"),("75a573ae-9c9b-11ed-85dd-acde48001122","75a54492-9c9b-11ed-85dd-acde48001122","Season 3","2008-11-21 00:00:00","2008-12-26 00:00:00"),("75a573b8-9c9b-11ed-85dd-acde48001122","75a54492-9c9b-11ed-85dd-acde48001122","Season 4","2010-06-25 00:00:00","2010-07-30 00:00:00"),("75a573b8-9c9b-11ed-85de-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122","Season 1","2006-02-03 00:00:00","2006-03-03 00:00:00"),("75a573c2-9c9b-11ed-85de-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122","Season 2","2007-08-24 00:00:00","2007-09-28 00:00:00"),("75a573cc-9c9b-11ed-85de-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122","Season 3","2008-11-21 00:00:00","2008-12-26 00:00:00"),("75a573d6-9c9b-11ed-85de-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122","Season 4","2010-06-25 00:00:00","2010-07-30 00:00:00"),("75a573d6-9c9b-11ed-85df-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122","Season 5","2018-03-25 00:00:00","2018-05-13 00:00:00") ON CONFLICT (season_id) DO UPDATE SET series_id=excluded.series_id
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[11.966ms] [rows:2] INSERT INTO series (series_id,title,series_info,comment,release_date) VALUES ("75a54492-9c9b-11ed-85dd-acde48001122","IT Crowd","The IT Crowd is a British sitcom produced by Channel 4, written by Graham Linehan, produced by Ash Atalla and starring Chris O'Dowd, Richard Ayoade, Katherine Parkinson, and Matt Berry.","","2006-02-03 00:00:00"),("75a54cf8-9c9b-11ed-85dd-acde48001122","Silicon Valley","Silicon Valley is an American comedy television series created by Mike Judge, John Altschuler and Dave Krinsky. The series focuses on five young men who founded a startup company in Silicon Valley.","","2014-04-06 00:00:00")
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[0.646ms] [rows:70] SELECT * FROM episodes WHERE episodes.season_id IN ("75a5737c-9c9b-11ed-85dd-acde48001122","75a573a4-9c9b-11ed-85dd-acde48001122","75a573ae-9c9b-11ed-85dd-acde48001122","75a573b8-9c9b-11ed-85dd-acde48001122","75a573b8-9c9b-11ed-85de-acde48001122","75a573c2-9c9b-11ed-85de-acde48001122","75a573cc-9c9b-11ed-85de-acde48001122","75a573d6-9c9b-11ed-85de-acde48001122","75a573d6-9c9b-11ed-85df-acde48001122")
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[1.294ms] [rows:9] SELECT * FROM seasons WHERE seasons.series_id IN ("75a54492-9c9b-11ed-85dd-acde48001122","75a54cf8-9c9b-11ed-85dd-acde48001122")
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[1.784ms] [rows:2] SELECT * FROM series
2023/01/25 13:31:42 all known series:
2023/01/25 13:31:42   > [75a54492-9c9b-11ed-85dd-acde48001122]     IT Crowd (2006)
2023/01/25 13:31:42     > [75a5737c-9c9b-11ed-85dd-acde48001122]   Season 1
2023/01/25 13:31:42       > [75a602d8-9c9b-11ed-85df-acde48001122] [2006-02-03] Yesterday's Jam
2023/01/25 13:31:42       > [75a60328-9c9b-11ed-85df-acde48001122] [2006-02-03] Calamity Jen
2023/01/25 13:31:42       > [75a60332-9c9b-11ed-85df-acde48001122] [2006-02-10] Fifty-Fifty
2023/01/25 13:31:42       > [75a6033c-9c9b-11ed-85df-acde48001122] [2006-02-17] The Red Door
2023/01/25 13:31:42       > [75a60350-9c9b-11ed-85df-acde48001122] [2006-02-24] The Haunting of Bill Crouse
2023/01/25 13:31:42       > [75a60350-9c9b-11ed-85e0-acde48001122] [2006-03-03] Aunt Irma Visits
2023/01/25 13:31:42     > [75a573a4-9c9b-11ed-85dd-acde48001122]   Season 2
2023/01/25 13:31:42       > [75a60364-9c9b-11ed-85e0-acde48001122] [2006-08-24] The Work Outing
2023/01/25 13:31:42       > [75a6036e-9c9b-11ed-85e0-acde48001122] [2007-08-31] Return of the Golden Child
2023/01/25 13:31:42       > [75a6036e-9c9b-11ed-85e1-acde48001122] [2007-09-07] Moss and the German
2023/01/25 13:31:42       > [75a60378-9c9b-11ed-85e1-acde48001122] [2007-09-14] The Dinner Party
2023/01/25 13:31:42       > [75a60382-9c9b-11ed-85e1-acde48001122] [2007-09-21] Smoke and Mirrors
2023/01/25 13:31:42       > [75a6038c-9c9b-11ed-85e1-acde48001122] [2007-09-28] Men Without Women
2023/01/25 13:31:42     > [75a573ae-9c9b-11ed-85dd-acde48001122]   Season 3
2023/01/25 13:31:42       > [75a60396-9c9b-11ed-85e1-acde48001122] [2008-11-21] From Hell
2023/01/25 13:31:42       > [75a603a0-9c9b-11ed-85e1-acde48001122] [2008-11-28] Are We Not Men?
2023/01/25 13:31:42       > [75a603a0-9c9b-11ed-85e2-acde48001122] [2008-12-05] Tramps Like Us
2023/01/25 13:31:42       > [75a603aa-9c9b-11ed-85e2-acde48001122] [2008-12-12] The Speech
2023/01/25 13:31:42       > [75a603b4-9c9b-11ed-85e2-acde48001122] [2008-12-19] Friendface
2023/01/25 13:31:42       > [75a603be-9c9b-11ed-85e2-acde48001122] [2008-12-26] Calendar Geeks
2023/01/25 13:31:42     > [75a573b8-9c9b-11ed-85dd-acde48001122]   Season 4
2023/01/25 13:31:42       > [75a603be-9c9b-11ed-85e3-acde48001122] [2010-06-25] Jen The Fredo
2023/01/25 13:31:42       > [75a603c8-9c9b-11ed-85e3-acde48001122] [2010-07-02] The Final Countdown
2023/01/25 13:31:42       > [75a603d2-9c9b-11ed-85e3-acde48001122] [2010-07-09] Something Happened
2023/01/25 13:31:42       > [75a603e6-9c9b-11ed-85e3-acde48001122] [2010-07-16] Italian For Beginners
2023/01/25 13:31:42       > [75a603f0-9c9b-11ed-85e3-acde48001122] [2010-07-23] Bad Boys
2023/01/25 13:31:42       > [75a603f0-9c9b-11ed-85e4-acde48001122] [2010-07-30] Reynholm vs Reynholm
2023/01/25 13:31:42   > [75a54cf8-9c9b-11ed-85dd-acde48001122]     Silicon Valley (2014)
2023/01/25 13:31:42     > [75a573b8-9c9b-11ed-85de-acde48001122]   Season 1
2023/01/25 13:31:42       > [75a603fa-9c9b-11ed-85e4-acde48001122] [2014-04-06] Minimum Viable Product
2023/01/25 13:31:42       > [75a60404-9c9b-11ed-85e4-acde48001122] [2014-04-13] The Cap Table
2023/01/25 13:31:42       > [75a6040e-9c9b-11ed-85e4-acde48001122] [2014-04-20] Articles of Incorporation
2023/01/25 13:31:42       > [75a6040e-9c9b-11ed-85e5-acde48001122] [2014-04-27] Fiduciary Duties
2023/01/25 13:31:42       > [75a60418-9c9b-11ed-85e5-acde48001122] [2014-05-04] Signaling Risk
2023/01/25 13:31:42       > [75a60418-9c9b-11ed-85e6-acde48001122] [2014-05-11] Third Party Insourcing
2023/01/25 13:31:42       > [75a60422-9c9b-11ed-85e6-acde48001122] [2014-05-18] Proof of Concept
2023/01/25 13:31:42       > [75a6047c-9c9b-11ed-85e6-acde48001122] [2014-06-01] Optimal Tip-to-Tip Efficiency
2023/01/25 13:31:42     > [75a573c2-9c9b-11ed-85de-acde48001122]   Season 2
2023/01/25 13:31:42       > [75a6047c-9c9b-11ed-85e7-acde48001122] [2015-04-12] Sand Hill Shuffle
2023/01/25 13:31:42       > [75a60486-9c9b-11ed-85e7-acde48001122] [2015-04-19] Runaway Devaluation
2023/01/25 13:31:42       > [75a60490-9c9b-11ed-85e7-acde48001122] [2015-04-26] Bad Money
2023/01/25 13:31:42       > [75a6049a-9c9b-11ed-85e7-acde48001122] [2015-05-03] The Lady
2023/01/25 13:31:42       > [75a604a4-9c9b-11ed-85e7-acde48001122] [2015-05-10] Server Space
2023/01/25 13:31:42       > [75a604ae-9c9b-11ed-85e7-acde48001122] [2015-05-17] Homicide
2023/01/25 13:31:42       > [75a604ae-9c9b-11ed-85e8-acde48001122] [2015-05-24] Adult Content
2023/01/25 13:31:42       > [75a604b8-9c9b-11ed-85e8-acde48001122] [2015-05-31] White Hat/Black Hat
2023/01/25 13:31:42       > [75a604c2-9c9b-11ed-85e8-acde48001122] [2015-06-07] Binding Arbitration
2023/01/25 13:31:42       > [75a604c2-9c9b-11ed-85e9-acde48001122] [2015-06-14] Two Days of the Condor
2023/01/25 13:31:42     > [75a573cc-9c9b-11ed-85de-acde48001122]   Season 3
2023/01/25 13:31:42       > [75a604cc-9c9b-11ed-85e9-acde48001122] [2016-04-24] Founder Friendly
2023/01/25 13:31:42       > [75a6051c-9c9b-11ed-85e9-acde48001122] [2016-05-01] Two in the Box
2023/01/25 13:31:42       > [75a6051c-9c9b-11ed-85ea-acde48001122] [2016-05-08] Meinertzhagen's Haversack
2023/01/25 13:31:42       > [75a60526-9c9b-11ed-85ea-acde48001122] [2016-05-15] Maleant Data Systems Solutions
2023/01/25 13:31:42       > [75a60530-9c9b-11ed-85ea-acde48001122] [2016-05-22] The Empty Chair
2023/01/25 13:31:42       > [75a6053a-9c9b-11ed-85ea-acde48001122] [2016-05-29] Bachmanity Insanity
2023/01/25 13:31:42       > [75a6053a-9c9b-11ed-85eb-acde48001122] [2016-06-05] To Build a Better Beta
2023/01/25 13:31:42       > [75a60544-9c9b-11ed-85eb-acde48001122] [2016-06-12] Bachman's Earnings Over-Ride
2023/01/25 13:31:42       > [75a6054e-9c9b-11ed-85eb-acde48001122] [2016-06-19] Daily Active Users
2023/01/25 13:31:42       > [75a6054e-9c9b-11ed-85ec-acde48001122] [2016-06-26] The Uptick
2023/01/25 13:31:42     > [75a573d6-9c9b-11ed-85de-acde48001122]   Season 4
2023/01/25 13:31:42       > [75a60558-9c9b-11ed-85ec-acde48001122] [2017-04-23] Success Failure
2023/01/25 13:31:42       > [75a60562-9c9b-11ed-85ec-acde48001122] [2017-04-30] Terms of Service
2023/01/25 13:31:42       > [75a60562-9c9b-11ed-85ed-acde48001122] [2017-05-07] Intellectual Property
2023/01/25 13:31:42       > [75a6056c-9c9b-11ed-85ed-acde48001122] [2017-05-14] Teambuilding Exercise
2023/01/25 13:31:42       > [75a60576-9c9b-11ed-85ed-acde48001122] [2017-05-21] The Blood Boy
2023/01/25 13:31:42       > [75a60576-9c9b-11ed-85ee-acde48001122] [2017-05-28] Customer Service
2023/01/25 13:31:42       > [75a60580-9c9b-11ed-85ee-acde48001122] [2017-06-04] The Patent Troll
2023/01/25 13:31:42       > [75a6058a-9c9b-11ed-85ee-acde48001122] [2017-06-11] The Keenan Vortex
2023/01/25 13:31:42       > [75a6058a-9c9b-11ed-85ef-acde48001122] [2017-06-18] Hooli-Con
2023/01/25 13:31:42       > [75a6058a-9c9b-11ed-85f0-acde48001122] [2017-06-25] Server Error
2023/01/25 13:31:42     > [75a573d6-9c9b-11ed-85df-acde48001122]   Season 5
2023/01/25 13:31:42       > [75a60594-9c9b-11ed-85f0-acde48001122] [2018-03-25] Grow Fast or Die Slow
2023/01/25 13:31:42       > [75a60594-9c9b-11ed-85f1-acde48001122] [2018-04-01] Reorientation
2023/01/25 13:31:42       > [75a6059e-9c9b-11ed-85f1-acde48001122] [2018-04-08] Chief Operating Officer
2023/01/25 13:31:42       > [75a6059e-9c9b-11ed-85f2-acde48001122] [2018-04-15] Tech Evangelist
2023/01/25 13:31:42       > [75a6059e-9c9b-11ed-85f3-acde48001122] [2018-04-22] Facial Recognition
2023/01/25 13:31:42       > [75a605a8-9c9b-11ed-85f3-acde48001122] [2018-04-29] Artificial Emotional Intelligence
2023/01/25 13:31:42       > [75a605a8-9c9b-11ed-85f4-acde48001122] [2018-05-06] Initial Coin Offering
2023/01/25 13:31:42       > [75a605b2-9c9b-11ed-85f4-acde48001122] [2018-05-13] Fifty-One Percent
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:112
[0.215ms] [rows:2] SELECT * FROM episodes WHERE title LIKE "%Bad%"
2023/01/25 13:31:42 all episodes with title with word 'bad':
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[0.095ms] [rows:1] SELECT * FROM seasons WHERE seasons.season_id = "75a573b8-9c9b-11ed-85dd-acde48001122" LIMIT 1
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[0.079ms] [rows:1] SELECT * FROM series WHERE series.series_id = "75a54492-9c9b-11ed-85dd-acde48001122" LIMIT 1
2023/01/25 13:31:42   > [75a54492-9c9b-11ed-85dd-acde48001122]     IT Crowd (2006)
2023/01/25 13:31:42     > [75a573b8-9c9b-11ed-85dd-acde48001122]   Season 4
2023/01/25 13:31:42       > [75a603f0-9c9b-11ed-85e3-acde48001122] [2010-07-23] Bad Boys
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[0.085ms] [rows:1] SELECT * FROM seasons WHERE seasons.season_id = "75a573c2-9c9b-11ed-85de-acde48001122" LIMIT 1
2023/01/25 13:31:42 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[0.100ms] [rows:1] SELECT * FROM series WHERE series.series_id = "75a54cf8-9c9b-11ed-85dd-acde48001122" LIMIT 1
2023/01/25 13:31:42   > [75a54cf8-9c9b-11ed-85dd-acde48001122]     Silicon Valley (2014)
2023/01/25 13:31:42     > [75a573c2-9c9b-11ed-85de-acde48001122]   Season 2
2023/01/25 13:31:42       > [75a60490-9c9b-11ed-85e7-acde48001122] [2015-04-26] Bad Money
Exiting.

Logs of Basic app with gorm for sqlite3:

2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[27.779ms] [rows:0] DECLARE $values AS List<Struct<'air_date':Datetime,'episode_id':Utf8,'season_id':Utf8,'title':Utf8>>;
UPSERT INTO /dev02/home/xenoxeno/db1/gorm/episodes (
episode_id,
season_id,
title,
air_date
) SELECT
episode_id,
season_id,
title,
air_date
FROM AS_TABLE($values);
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[53.293ms] [rows:0] DECLARE $values AS List<Struct<'first_aired':Datetime,'last_aired':Datetime,'season_id':Utf8,'series_id':Utf8,'title':Utf8>>;
UPSERT INTO /dev02/home/xenoxeno/db1/gorm/seasons (
season_id,
series_id,
title,
first_aired,
last_aired
) SELECT
season_id,
series_id,
title,
first_aired,
last_aired
FROM AS_TABLE($values);
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:79
[91.612ms] [rows:0] DECLARE $values AS List<Struct<'comment':Utf8,'release_date':Datetime,'series_id':Utf8,'series_info':Utf8,'title':Utf8>>;
UPSERT INTO /dev02/home/xenoxeno/db1/gorm/series (
series_id,
title,
series_info,
comment,
release_date
) SELECT
series_id,
title,
series_info,
comment,
release_date
FROM AS_TABLE($values);
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[14.986ms] [rows:70] DECLARE $_season_id_0 AS List;
SELECT
episode_id,
season_id,
title,
air_date
FROM /dev02/home/xenoxeno/db1/gorm/episodes WHERE season_id IN $_season_id_0
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[30.902ms] [rows:9] DECLARE $_series_id_0 AS List;
SELECT
season_id,
series_id,
title,
first_aired,
last_aired
FROM /dev02/home/xenoxeno/db1/gorm/seasons WHERE series_id IN $_series_id_0
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:85
[41.878ms] [rows:2] SELECT
series_id,
title,
series_info,
comment,
release_date
FROM /dev02/home/xenoxeno/db1/gorm/series
2023/01/31 11:44:37 all known series:
2023/01/31 11:44:37   > [7e8f8f66-a143-11ed-9047-acde48001122]     IT Crowd (2006)
2023/01/31 11:44:37     > [7e91cc68-a143-11ed-9047-acde48001122]   Season 1
2023/01/31 11:44:37       > [7e958fec-a143-11ed-904b-acde48001122] [2006-02-03] Yesterday's Jam
2023/01/31 11:44:37       > [7e958ff6-a143-11ed-904b-acde48001122] [2006-02-03] Calamity Jen
2023/01/31 11:44:37       > [7e959000-a143-11ed-904b-acde48001122] [2006-02-10] Fifty-Fifty
2023/01/31 11:44:37       > [7e959000-a143-11ed-904c-acde48001122] [2006-02-17] The Red Door
2023/01/31 11:44:37       > [7e95900a-a143-11ed-904c-acde48001122] [2006-02-24] The Haunting of Bill Crouse
2023/01/31 11:44:37       > [7e95900a-a143-11ed-904d-acde48001122] [2006-03-03] Aunt Irma Visits
2023/01/31 11:44:37     > [7e91cc7c-a143-11ed-9047-acde48001122]   Season 2
2023/01/31 11:44:37       > [7e959014-a143-11ed-904d-acde48001122] [2006-08-24] The Work Outing
2023/01/31 11:44:37       > [7e959014-a143-11ed-904e-acde48001122] [2007-08-31] Return of the Golden Child
2023/01/31 11:44:37       > [7e959014-a143-11ed-904f-acde48001122] [2007-09-07] Moss and the German
2023/01/31 11:44:37       > [7e95901e-a143-11ed-904f-acde48001122] [2007-09-14] The Dinner Party
2023/01/31 11:44:37       > [7e95901e-a143-11ed-9050-acde48001122] [2007-09-21] Smoke and Mirrors
2023/01/31 11:44:37       > [7e959028-a143-11ed-9050-acde48001122] [2007-09-28] Men Without Women
2023/01/31 11:44:37     > [7e91cc7c-a143-11ed-9048-acde48001122]   Season 3
2023/01/31 11:44:37       > [7e959028-a143-11ed-9051-acde48001122] [2008-11-21] From Hell
2023/01/31 11:44:37       > [7e959028-a143-11ed-9052-acde48001122] [2008-11-28] Are We Not Men?
2023/01/31 11:44:37       > [7e959032-a143-11ed-9052-acde48001122] [2008-12-05] Tramps Like Us
2023/01/31 11:44:37       > [7e959032-a143-11ed-9053-acde48001122] [2008-12-12] The Speech
2023/01/31 11:44:37       > [7e95903c-a143-11ed-9053-acde48001122] [2008-12-19] Friendface
2023/01/31 11:44:37       > [7e95903c-a143-11ed-9054-acde48001122] [2008-12-26] Calendar Geeks
2023/01/31 11:44:37     > [7e91cc86-a143-11ed-9048-acde48001122]   Season 4
2023/01/31 11:44:37       > [7e95903c-a143-11ed-9055-acde48001122] [2010-06-25] Jen The Fredo
2023/01/31 11:44:37       > [7e959046-a143-11ed-9055-acde48001122] [2010-07-02] The Final Countdown
2023/01/31 11:44:37       > [7e959046-a143-11ed-9056-acde48001122] [2010-07-09] Something Happened
2023/01/31 11:44:37       > [7e959050-a143-11ed-9056-acde48001122] [2010-07-16] Italian For Beginners
2023/01/31 11:44:37       > [7e959050-a143-11ed-9057-acde48001122] [2010-07-23] Bad Boys
2023/01/31 11:44:37       > [7e959050-a143-11ed-9058-acde48001122] [2010-07-30] Reynholm vs Reynholm
2023/01/31 11:44:37   > [7e8f96fa-a143-11ed-9047-acde48001122]     Silicon Valley (2014)
2023/01/31 11:44:37     > [7e91cc86-a143-11ed-9049-acde48001122]   Season 1
2023/01/31 11:44:37       > [7e95905a-a143-11ed-9058-acde48001122] [2014-04-06] Minimum Viable Product
2023/01/31 11:44:37       > [7e95905a-a143-11ed-9059-acde48001122] [2014-04-13] The Cap Table
2023/01/31 11:44:37       > [7e959064-a143-11ed-9059-acde48001122] [2014-04-20] Articles of Incorporation
2023/01/31 11:44:37       > [7e959064-a143-11ed-905a-acde48001122] [2014-04-27] Fiduciary Duties
2023/01/31 11:44:37       > [7e959064-a143-11ed-905b-acde48001122] [2014-05-04] Signaling Risk
2023/01/31 11:44:37       > [7e95906e-a143-11ed-905b-acde48001122] [2014-05-11] Third Party Insourcing
2023/01/31 11:44:37       > [7e95906e-a143-11ed-905c-acde48001122] [2014-05-18] Proof of Concept
2023/01/31 11:44:37       > [7e959078-a143-11ed-905c-acde48001122] [2014-06-01] Optimal Tip-to-Tip Efficiency
2023/01/31 11:44:37     > [7e91cc90-a143-11ed-9049-acde48001122]   Season 2
2023/01/31 11:44:37       > [7e959078-a143-11ed-905d-acde48001122] [2015-04-12] Sand Hill Shuffle
2023/01/31 11:44:37       > [7e959078-a143-11ed-905e-acde48001122] [2015-04-19] Runaway Devaluation
2023/01/31 11:44:37       > [7e959082-a143-11ed-905e-acde48001122] [2015-04-26] Bad Money
2023/01/31 11:44:37       > [7e959082-a143-11ed-905f-acde48001122] [2015-05-03] The Lady
2023/01/31 11:44:37       > [7e95908c-a143-11ed-905f-acde48001122] [2015-05-10] Server Space
2023/01/31 11:44:37       > [7e95908c-a143-11ed-9060-acde48001122] [2015-05-17] Homicide
2023/01/31 11:44:37       > [7e95908c-a143-11ed-9061-acde48001122] [2015-05-24] Adult Content
2023/01/31 11:44:37       > [7e959096-a143-11ed-9061-acde48001122] [2015-05-31] White Hat/Black Hat
2023/01/31 11:44:37       > [7e959096-a143-11ed-9062-acde48001122] [2015-06-07] Binding Arbitration
2023/01/31 11:44:37       > [7e959096-a143-11ed-9063-acde48001122] [2015-06-14] Two Days of the Condor
2023/01/31 11:44:37     > [7e91cc9a-a143-11ed-9049-acde48001122]   Season 3
2023/01/31 11:44:37       > [7e9590a0-a143-11ed-9063-acde48001122] [2016-04-24] Founder Friendly
2023/01/31 11:44:37       > [7e9590a0-a143-11ed-9064-acde48001122] [2016-05-01] Two in the Box
2023/01/31 11:44:37       > [7e9590aa-a143-11ed-9064-acde48001122] [2016-05-08] Meinertzhagen's Haversack
2023/01/31 11:44:37       > [7e9590aa-a143-11ed-9065-acde48001122] [2016-05-15] Maleant Data Systems Solutions
2023/01/31 11:44:37       > [7e9590aa-a143-11ed-9066-acde48001122] [2016-05-22] The Empty Chair
2023/01/31 11:44:37       > [7e9590b4-a143-11ed-9066-acde48001122] [2016-05-29] Bachmanity Insanity
2023/01/31 11:44:37       > [7e9590b4-a143-11ed-9067-acde48001122] [2016-06-05] To Build a Better Beta
2023/01/31 11:44:37       > [7e9590b4-a143-11ed-9068-acde48001122] [2016-06-12] Bachman's Earnings Over-Ride
2023/01/31 11:44:37       > [7e9590be-a143-11ed-9068-acde48001122] [2016-06-19] Daily Active Users
2023/01/31 11:44:37       > [7e9590be-a143-11ed-9069-acde48001122] [2016-06-26] The Uptick
2023/01/31 11:44:37     > [7e91cc9a-a143-11ed-904a-acde48001122]   Season 4
2023/01/31 11:44:37       > [7e9590c8-a143-11ed-9069-acde48001122] [2017-04-23] Success Failure
2023/01/31 11:44:37       > [7e9590c8-a143-11ed-906a-acde48001122] [2017-04-30] Terms of Service
2023/01/31 11:44:37       > [7e9590d2-a143-11ed-906a-acde48001122] [2017-05-07] Intellectual Property
2023/01/31 11:44:37       > [7e9590d2-a143-11ed-906b-acde48001122] [2017-05-14] Teambuilding Exercise
2023/01/31 11:44:37       > [7e9590d2-a143-11ed-906c-acde48001122] [2017-05-21] The Blood Boy
2023/01/31 11:44:37       > [7e9590dc-a143-11ed-906c-acde48001122] [2017-05-28] Customer Service
2023/01/31 11:44:37       > [7e9590f0-a143-11ed-906c-acde48001122] [2017-06-04] The Patent Troll
2023/01/31 11:44:37       > [7e9590f0-a143-11ed-906d-acde48001122] [2017-06-11] The Keenan Vortex
2023/01/31 11:44:37       > [7e9590fa-a143-11ed-906d-acde48001122] [2017-06-18] Hooli-Con
2023/01/31 11:44:37       > [7e9590fa-a143-11ed-906e-acde48001122] [2017-06-25] Server Error
2023/01/31 11:44:37     > [7e91cc9a-a143-11ed-904b-acde48001122]   Season 5
2023/01/31 11:44:37       > [7e959104-a143-11ed-906e-acde48001122] [2018-03-25] Grow Fast or Die Slow
2023/01/31 11:44:37       > [7e959104-a143-11ed-906f-acde48001122] [2018-04-01] Reorientation
2023/01/31 11:44:37       > [7e95910e-a143-11ed-906f-acde48001122] [2018-04-08] Chief Operating Officer
2023/01/31 11:44:37       > [7e95910e-a143-11ed-9070-acde48001122] [2018-04-15] Tech Evangelist
2023/01/31 11:44:37       > [7e95910e-a143-11ed-9071-acde48001122] [2018-04-22] Facial Recognition
2023/01/31 11:44:37       > [7e959118-a143-11ed-9071-acde48001122] [2018-04-29] Artificial Emotional Intelligence
2023/01/31 11:44:37       > [7e959118-a143-11ed-9072-acde48001122] [2018-05-06] Initial Coin Offering
2023/01/31 11:44:37       > [7e959122-a143-11ed-9072-acde48001122] [2018-05-13] Fifty-One Percent
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:112
[16.890ms] [rows:2] DECLARE $_title_0 AS Utf8;
SELECT
episode_id,
season_id,
title,
air_date
FROM /dev02/home/xenoxeno/db1/gorm/episodes WHERE title LIKE $_title_0
2023/01/31 11:44:37 all episodes with title with word 'bad':
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[11.425ms] [rows:1] DECLARE $_season_id_0 AS Utf8;
SELECT
season_id,
series_id,
title,
first_aired,
last_aired
FROM /dev02/home/xenoxeno/db1/gorm/seasons WHERE season_id=$_season_id_0
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[11.660ms] [rows:1] DECLARE $_series_id_0 AS Utf8;
SELECT
series_id,
title,
series_info,
comment,
release_date
FROM /dev02/home/xenoxeno/db1/gorm/series WHERE series_id=$_series_id_0
2023/01/31 11:44:37   > [7e8f8f66-a143-11ed-9047-acde48001122]     IT Crowd (2006)
2023/01/31 11:44:37     > [7e91cc86-a143-11ed-9048-acde48001122]   Season 4
2023/01/31 11:44:37       > [7e959050-a143-11ed-9057-acde48001122] [2010-07-23] Bad Boys
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:123
[6.502ms] [rows:1] DECLARE $_season_id_0 AS Utf8;
SELECT
season_id,
series_id,
title,
first_aired,
last_aired
FROM /dev02/home/xenoxeno/db1/gorm/seasons WHERE season_id=$_season_id_0
2023/01/31 11:44:37 /Users/asmyasnikov/ydb/examples/basic/gorm/main.go:129
[9.772ms] [rows:1] DECLARE $_series_id_0 AS Utf8;
SELECT
series_id,
title,
series_info,
comment,
release_date
FROM /dev02/home/xenoxeno/db1/gorm/series WHERE series_id=$_series_id_0
2023/01/31 11:44:37   > [7e8f96fa-a143-11ed-9047-acde48001122]     Silicon Valley (2014)
2023/01/31 11:44:37     > [7e91cc90-a143-11ed-9049-acde48001122]   Season 2
2023/01/31 11:44:37       > [7e959082-a143-11ed-905e-acde48001122] [2015-04-26] Bad Money
Exiting.


Hide re-enable and forgive buttons on success

Description
Make re-enable and forgive failure buttons disappear on server response. Also add the ability to hold alt with the re-enable to get an update like with forgive failures. This doesn't check for whether the server was successful in its response.
Motivation and Context
After fixing a bug or system issue that causes a class of jobs to fail, I'm often left with a lot of disabled jobs that need to be re-enabled. I usually click one button and then try to quickly click as many as I can before the refresh. This process is made much slower and less reliable by all the reloads. Some of my co-workers use the javascript console to ensure they can click every available button in time.
On the other hand, I'm not even sure if I successfully clicked on the forgive failures button when I want to make a job pending again. These buttons have very similar functions but wildly different behavior. In order to make them more consistent and more reasonable, we delete them to indicate receipt of the server response.
Have you tested this? If so, how?
I tried this out on my production server and it works fine.

LGTM


Page size fix

Fixing too large page size in terminal display when handing large lists/options.
I am still unsure of why in the code I need to do this (as it shouldn't be neccessary) but debugging shows the correct values and variables are coming through so fixing this for now as it passes all tests.

Oh, and I forgot, please add a line to the CHANGELOG.md describing the fix.

Updates made

Sorry for the gajillion reports. Learning how to do upstream -> downstream merge and resolve conflicts, and then needed to learn to get it to run rust-fmt locally. I think I have a good build submission process now! (Submitted another PR to handle some pre-commit tasks if possible, I can rebase it once this goes through)

Sorry for the gajillion reports. Learning how to do upstream -> downstream merge and resolve conflicts, and then needed to learn to get it to run rust-fmt locally. I think I have a good build submission process now! (Submitted another PR to handle some pre-commit tasks if possible, I can rebase it once this goes through)

No worries at all, I just periodically check my github notification in the web browser and don't let it notify me directly.  So you do you!
I use a rebase workflow and keep amending the initial commit, which makes it a little easier for me as long as I keep the PR size low.

Needs a rebase and conflict resolution


api/tunnels returns empty response when using auth

Seems like there's an issue with the api responses when using an auth token.
I've tested the setup once with and once without an config file, and if the auth is in the config file, the api response returns empty.
The issue doesnt exist when using the non-docker version of ngrok.
Steps to reproduce:

docker run --rm -it -p 4040:4040 -v ${HOME}/.ngrok2/ngrok.yml:/ngrok_auth.yml:ro  --name www_ngrok wernight/ngrok ngrok http -config=/ngrok_auth.yml 3000
curl $(docker port www_ngrok 4040)/api/tunnels
Expected:
To have a response with the tunnel listed
Actual result:
curl: (52) Empty reply from server

Were you able to resolve this issue?


Add demo .gif of using rgr to the readme

From @abitrolly, here: https://github.com/BurntSushi/ripgrep/issues/74#issuecomment-1207332747

But.. if there was a recorded .gif demo (which fastmod does not) I could at least watch it. Frankly, because of lack of demo, I would ignore fastmod too, but facebook name together with stars convinced my to give it a try and spend 15 minutes to try.

In other words, people think a gif demo would really help promote the utility of this tool. I agree.
Tools I'll need:

https://superuser.com/questions/1107200/optimize-animated-gif-size-in-command-line/1107201#1107201
https://askubuntu.com/questions/648603/how-to-create-an-animated-gif-from-mp4-video-via-command-line#comment2393212_837574

Listing alternatives is also a good practice to collect stars for the reference.


ssh keyscan with username

Discussed in https://github.com/deployphp/deployer/discussions/2666

Originally posted by underdpt September 23, 2021
Hello,
With v7.0.0-beta25, this setup:
set('repository', 'ssh://git@git.server.com:2233/folder/project.git');
set('ssh_multiplexing', PHP_OS_FAMILY === 'Windows' ? false : true);
set('default_timeout', null);

host('my.server.host')
    ->set('labels', ['stage' => 'production'])
    ->set('branch', 'master')
    ->set('remote_user', 'mainsip')
    ->set('port', 2223)
    ->set('deploy_path', '/var/www/project');

produces this error:
info deploying master
task deploy:setup
task deploy:lock
task deploy:release
task deploy:update_code
[my.server.host]  error  in update_code.php on line 54:
[my.server.host] run ssh-keyscan -p 2233 -H<EMAIL_ADDRESS>>> ~/.ssh/known_hosts
[my.server.host] err getaddrinfo<EMAIL_ADDRESS>Name or service not known
[my.server.host] err getaddrinfo<EMAIL_ADDRESS>Name or service not known
[my.server.host] err getaddrinfo<EMAIL_ADDRESS>Name or service not known
[my.server.host] err getaddrinfo<EMAIL_ADDRESS>Name or service not known
[my.server.host] err getaddrinfo<EMAIL_ADDRESS>Name or service not known
[my.server.host] exit code 1 (General error)

I think the error might be that the hostname is including the user part<EMAIL_ADDRESS>for the ssh-keyscan command.
This works with v7.0.0-beta24

https://github.com/deployphp/deployer/blob/363f7ed6a15c4a7a967f38a29bf357a82784196f/recipe/deploy/update_code.php#L48
This regex is to naïve. It will also fail when the repository is pulled over http, in which case key-scanning makes no sense.

Coming up...

Could you please release a new beta? This issue is breaking quite some pipelines.

Released beta.26


Improve ECS update_service and describing tasks.

Have update_service throw the correct error if the service doesn't exist
Allow describe_tasks to accept the task id in addition to ARNs.

Coverage increased (+0.08%) to 92.313% when pulling 7c1fd0a2f1b834dcc7cd6e9c852cff765b066cc7 on ecs-tasks into 38a45589252ca3466c317a55dfcd80c211810ee7 on master.


NSwagStudio update to 13.15.10

Also changed the version regex and changed to zip release

[X] I have read the Contributing Guide.

/verify

/verify


Adding missing args to do a custom online archive

Description
Hello @gssbzn , @andreaangiolillo , adding missing attributes required to do a custom type archive log.

added the query parameter in criteria
changed from float64 to *float64 to avoid sending  expireAfterDays when it's custom type.

│ Error: error creating MongoDB Atlas Online Archive:: POST https://cloud.mongodb.com/api/atlas/v1.0/groups/5cf5a45a9ccf6400e60981b6/clusters/test-angel-cloud-backup1/onlineArchives: 400 (request "INVALID_ATTRIBUTE") Invalid attribute expireAfterDays specified.
│
│   with mongodbatlas_online_archive.users_archive_query,
│   on main.tf line 25, in resource "mongodbatlas_online_archive" "users_archive_query":
│   25: resource "mongodbatlas_online_archive" "users_archive_query" {

required in https://github.com/mongodb/terraform-provider-mongodbatlas/pull/413
Link to any related issue(s):
Type of change:

[ ] Bug fix (non-breaking change which fixes an issue)
[X] New feature (non-breaking change which adds functionality)
[ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)
[ ] This change requires a documentation update

Required Checklist:

[X] I have signed the MongoDB CLA
[X] I have added tests that prove my fix is effective or that my feature works
[X] I have added any necessary documentation (if appropriate)
[X] I have run make fmt and formatted my code

Further comments

Hi @gssbzn fixed the comments :) , regarding the partitionFields , they were already there but at the onlineArchive level


Remember settings on application closure

Hello there!
It would be awesome if the app could save settings, both for what adapter is being listened to and what are the filters applied (because most people won't keep switching between network adapters), and also any modification done in the settings pop-in, since at the moment none of that persists through the app closure. (Also I'd love to be able to set where the sniffnet_report folder should be.)
Basically that would mean looking up a setting file somewhere predefined like ~/.sniffnet on app startup and loading whatever values are written on initialisation, creating it with default values if absent, and writing to it on inspection start (maybe add a checkbox remember this setting so that it is not automatically saved for people actually using multiple adapters), and on either modification or exit on the settings pop-in.
Thanks for reading, and also thanks for the awesome app!

Hey @Lysarion, thanks for the very detailed issue!
I have some good news already:

the settings of the pop-up (notifications, style, and language) was already meant to be saved in v1.1.0; please, try closing settings touching a point on the background and let me know if they are actually saved. There was a bug causing settings not to be saved when closing the pop-up from the 'x' button on the top right corner, but it has already been solved with 2705b541a49757a179d8f3c213e79cc192a92aa8 and the fix will be published in the next release
I already implemented adapter-remembering (55eee9f7126fb5e256dac8786357d45b57f159f3) and it will be introduced in the next release as well; the application will save and remember an adapter without the need of specifying it, it will always remember the last adapter for which some packets were successfully sniffed by the user
I also worked on the output folder of the report and, following the suggestions mentioned in #51, I decided to save it in a fixed location which is coincident of that of the configuration files used for remembering the settings and the adapter. Every time the inspection is restarted, the file is overwritten and if you'd like to save the file of a particular inspection you just have to open it and save it wherever you want. I would appreciate having a further discussion on this point with you though.
For what concerns filters, I still have not saved them into a configuration file but I could consider it. Also for this point, don't hesitate to share your thoughts.

Can confirm the settings not being saved was me clicking the X button.
For some reason my report is generated in C:\Windows\System32\sniffnet_report\report.txt, it's running as admin from C:\Program Files\sniffnet\bin\.
As for report retention, I'd probably just append to the current file (as each line is timestamped anyway) but that's only logical to do so if the same adapter is being monitored, or include in the filename the timestamp for the current session.

I think that most users are interested in monitoring the traffic in real-time (through the GUI) rather than a posteriori (through the textual reports).
For this reason I think that generating a different report for each session or a single huge report common to all sessions would be just a waste of memory for the vast majority of users.

Can confirm that's my case too, I mostly see sniffnet as a good Glasswire replacement (as the free feature-set of Glasswire is pretty bare, and the default color-scheme they use is horrendous).
About that, I'd point the fact that the non-GUI part could be started in a minimized state rather than it's own independent window, to reduce clutter.

About that, I'd point the fact that the non-GUI part could be started in a minimized state rather than it's own independent window, to reduce clutter.

I will see if I can do something about that.

Settings configurations problems have been solved and published in today's release.
I moved your last advice in a new issue: #85.

About that, I'd point the fact that the non-GUI part could be started in a minimized state rather than it's own independent window, to reduce clutter.

A new release solving this issue has just been published!


RFC: Textmate scopes for tuple structs and enum members

I'd like to improve the highlighting of tuple structs and enum members, which are currently getting function scope when they wrap values in round brackets, and type scope when there are no round brackets.
The default fallback scopes for VS Code are:

Semantic Token Selector
Fallback Textmate Scope

type
entity.name.type

struct
storage.type.struct

enum
entity.name.type.enum

enumMember
variable.other.enummember

Unique scopes are easy at declaration, because we have a keyword to capture (enum, struct, trait, type), but I think it may not be possible to distinguish enum members from tuple structs at other locations in the code. I need to pick a sensible scope to distinguish these from function calls. At the moment, I am tempted to use variable.other.enummember, but this is less generic than entity.name.type, and might feel wrong in the case of tuple structs. Using variable scope provides a little more visual distinction, because it would scope enum members differently from the parent enum, which is already getting entity.name.type.

I think a reasonable compromise for adding some distinctions would be to use the following patterns (happy for feedback as always):
// nonspecific - no distinction can be made
Type
namespace::Type

// likely enum
Enum::Member
Enum::Member()
Enum::Member {}

// likely struct
Struct {}
namespace::Struct()

// inside enum declarations, favor member:
enum Enum {
    Member(),
    Member
}

// outside enum declarations, favor Struct
Struct()

// leverage impl
impl Struct {}
impl Trait for Struct {}

There are issues navigating interspersed type parameters and such, but I think I can negotiate those with lookarounds.
(also relevant to #6528)

In Rust there is also a thing as trait. So I guess storage.type.trait might also be added

We currently capture traits at declaration as entity.name.type.trait, but the issue is that (outside of impl blocks) traits don't offer a unique target for the regex, so they can't be separated from other capitalized words (types, enums). There are many partial workarounds, such as grabbing calls to derive() in attributes, and hard-coding trait names provided by the standard library, but these half measures will result in traits being highlighted inconsistently.
At the moment, my plan is to use entity.name.type.trait at declaration and in impl, and entity.name.type elsewhere. This at least reduces the chances of highlighting non-traits as traits.
The Textmate grammar can only go so far. It's designed to give newcomers to the language a good experience out of the box, and to provide reasonable highlighting if semantic scopes need to be disabled for some reason. I would like to get it to a reasonably stable 1.0 for that purpose, but I don't expect we can match the precision of semantic highlighting.

@dustypomerleau you probably want to cc @georgewfraser on these issues. You two are way more knowledgeable then most other folks on this area :-)

I ran into a snag at the intersection of trying to implement these patterns along with tests (https://github.com/microsoft/vscode-textmate/issues/142). Seems that my method of catching the patterns with lookbehinds essentially makes the grammar untestable (with default tooling). I think I'll close this for now - I should be able to refactor to get a similar result, at which point it will be easier for people to give feedback.


Update identifiers to use UUIDs instead of integers

Since integer identifiers make version tree modifications difficult, this branch seeks to replace them with UUIDs.

There are a lot of tests that break with this right now. Much more work to be done.

Things to watch out for: reading IDs from annotations (for instance, upgraded versions) probably currently always involve a str->int cast.
Also, some methods (at least API) accept either tag name or version number, and these are usually discriminated by type.

Yes, I was also thinking about modifying the db objects/calls to check types to catch these cases, but it is true that some of the logic is at the core level. I want to roll in bundle/sqlalchemy support at the same time since we need to have a "bundle upgrade" for this type of translation (e.g. ids in the log need to be remapped to match the ids in the vistrail).


DynamicArray support for non-copyable type

Please add a test and rebase.

Even with this patch, the following still doesn't work:
	struct S { @disable this(this); }
	DynamicArray!S a;

@Panke How did you test this?

Superseded by #182.


Quiz/Poll: Backend Endpoint

Feature Description

For the quizzes and polls feature (#8275) we need to create a backend endpoint as per the documentation.
// Getting the votes for an interactive.
// If no client param, selected will always be false
// (can be used to display the results on a dashboard).

// GET https://backend.com/v1/interactives/<id>?type=0&client=amp-281391283

Response: {
	  "options": [
		    {"index": 0, "selected": false, "count": 0},
		    {"index": 1, "selected": false, "count": 5},
		    {"index": 2, "selected": false, "count": 7},
		    {"index": 3, "selected": false, "count": 2}
	  ]
}

// POST http://localhost:3000/interactives/<id>:vote?
        type=0&
        client=amp-281391283 body:{"option_selected": 2}

// Posting the vote for an interactive. Client param is required.

POST_URL = "{endpoint}/{interactiveId}:vote?type={interactiveType}&client={ampId}"
POST_BODY = {'option_selected': 1}

Response: No response necessary

interactiveId is basically ${base64(CANONICAL_URL)}+${ELEMENT_ID}, so just a long string
endpoint in the above examples is the full API endpoint, e.g. https://backend.com/v1/interactives
ampId: client ID that identifies the session
interactiveType is an enum (0=quiz, 1=poll, 2=results)

Security and Privacy
AMP gives Client IDs to sessions that identify users. In order to prevent the database to contain these IDs, the client ID will be hashed with the interactiveIDs to prevent records to be identified across different interactive components in a way that cannot be reversed.
In the database, the users cannot be matched, and the only way to retrieve the data of a user is to provide the client ID and the interactive ID. This means the ID stored in the backend for a client/user will be unique across all the interactive components (eg: the same client can vote on two interactive components on the same story, but the ID used as a key to identify the votes will be different).
No IP addresses or anything will be stored.
To-do
We need to implement this backend endpoint in the WordPress plugin.

[ ] Create design brief for implementation

Alternatives Considered

Additional Context

When consider this functionality, this is what I was thinking.
Create a new post type, called story_quiz. This post type would store, the questions / options. Maybe as a json object in post_content_filtered or post meta.
When a user answers the quiz, the data can be stored in comments against the quiz story id. We could also story, a summary of the data, like number of responses to a question for easier querying. Comments will be stored in a custom comment type.
I really don't want to add a custom table here, it will add a lot of overhead and not all hosts support adding new tables.

I don't think we can make a case for any approach before first addressing all the open questions and also the security and privacy concerns in a design brief. Then we get a better sense for what makes most sense.
Some thoughts on the required data structure / example above to help with that:

Since interactiveId contains the element ID, does that mean creating a new quiz in the editor needs to create a new quiz entry in the database?

If so, how does that work when duplicating/deleting the element in the editor?
Also, how does that work when modifying an existing poll's options in the editor? What happens to the existing replies?

Since interactiveId contains the story's URL, how does that work when the story's URL changes (site migration, permalink change)?
Are we planning on surfacing quiz / polls data somehow in the admin/editor so they can see all responses?
Do creators need to be able to modify responses somehow, for example to reset all responses back to 0 after testing?

Some of these are product-related questions, so needs some clearer definition there first.
cc @o-fernandez @choumx


Fixes in displaying and converting timestamps in Mavlink

I tested this by comparing camera trigger times with video stream timestamps on the remote system sent back in VISION_POSITION_ESTIMATE messages. They matched with accuracy of at least 1ms, so it works.

@tommises Thanks for the PR. Reviewed, looks sane.
Can you rebase out that last commit? I explained why above.

Rebased and applied to master. The synchronised timestamp is now called "timestamp" as for all other messages.

Perhaps VISION_POSITION_ESTIMATE.usec should be also using .timestamp and not .timestamp_boot?

timestamp_boot is from the monotonic clock (CLOCK_REALTIME), which
won't skew with time corrections from e.g GPS. So it's a stable time base
for timestamping.

Ooops, I didn't notice @LorenzMeier has already done precisely what I suggested:
https://github.com/PX4/Firmware/commit/8b3045baa28eeefaca5195916a267aba3dce401f


Ability to sell grown Cats for Death runes.

🚀 Feature Proposal
Ability to sell grown cats for Death runes, this would give reason to grow cats other than cl in bso and would actually give reason to buy kittens and grow them in osb. Since you can buy and grow kittens into cats on both but currently it only actually purpose on Bso for cl. The amount of runes would be doubled via easy Ardy diary.

I thought you can sell them for death runes? Have you tried to sell your cat?

note: selling of cats is done by sacrifice

ah thank you. what an obscure way to do that. i guess this can be closed.