)]}'
{"id":"depot~13237","triplet_id":"depot~canon~Ibd5b67c77c87ce3d6aa0ab04ca3d66f9b90dc856","project":"depot","branch":"canon","hashtags":[],"change_id":"Ibd5b67c77c87ce3d6aa0ab04ca3d66f9b90dc856","subject":"refactor(users/Profpatsch/whatcd-resolver): prepare SQL changes","status":"MERGED","created":"2025-03-10 12:48:39.000000000","updated":"2025-03-10 16:55:15.000000000","submitted":"2025-03-10 16:55:15.000000000","submitter":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"13240","meta_rev_id":"a284eb201a369c7af0633b0bc046b6d7ad41e0bc","_number":13237,"virtual_id_number":13237,"owner":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"actions":{},"labels":{"Code-Review":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"tag":"autogenerated:gerrit:merged","value":2,"date":"2025-03-10 16:55:15.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{"-2":"This shall not be merged","-1":"I would prefer this is not merged as is"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me, approved"},"description":"","default_value":0},"Verified":{"approved":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:gerrit:merged","value":1,"date":"2025-03-10 16:55:15.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{"-1":"Fails"," 0":"No score","+1":"Verified"},"description":"","default_value":0},"Autosubmit":{"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}],"values":{" 0":"Submit manually","+1":"Submit automatically"},"description":"","default_value":0,"optional":true},"All-Comments-Resolved":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}]},"Conformant-Commit-Message":{"approved":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"all":[{"value":0,"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},{"value":0,"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}]}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2025-03-10 12:48:40.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2025-03-10 12:52:29.000000000","updated_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"reviewer":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"d97866a0b4048539e4a5cd8da1f89daf7424328e","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 12:48:39.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"462076b0f1db7d31e2b397a78b997e5c11051b83","tag":"autogenerated:buildkite~trigger","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 12:48:40.000000000","message":"Patch Set 1:\n\nStarted build for patchset #1 on: https://buildkite.com/tvl/depot/builds/38933","accounts_in_message":[],"_revision_number":1},{"id":"bb54fd0da3ac308e8a1b287fc5383a2dc6c25c75","tag":"autogenerated:buildkite~result","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 12:52:29.000000000","message":"Patch Set 1: Verified+1\n\nBuild of patchset 1 passed: https://buildkite.com/tvl/depot/builds/38933","accounts_in_message":[],"_revision_number":1},{"id":"2a06e8f05e860b6d6af1c58b4b1107697e234082","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:52:27.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"a284eb201a369c7af0633b0bc046b6d7ad41e0bc","tag":"autogenerated:gerrit:merged","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:55:15.000000000","message":"Change has been successfully rebased and submitted as 1e188ee116632fdf34c231d45b94cb8e9f8c8875","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"1e188ee116632fdf34c231d45b94cb8e9f8c8875","revisions":{"106522962d4d9ae814e3feac153305de5541feda":{"kind":"REWORK","_number":1,"created":"2025-03-10 12:48:39.000000000","uploader":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"ref":"refs/changes/37/13237/1","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/37/13237/1","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/37/13237/1"}}},"commit":{"parents":[{"commit":"b9336a57e19356111f0ae8559122fb329d2e7f0d","subject":"feat(users/Profpatsch/whatcd-resolver): add release type filter","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003db9336a57e19356111f0ae8559122fb329d2e7f0d"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 11:51:01.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 11:51:01.000000000","tz":60},"subject":"refactor(users/Profpatsch/whatcd-resolver): prepare SQL changes","message":"refactor(users/Profpatsch/whatcd-resolver): prepare SQL changes\n\nFor the next step, we need to put more things in WITH-Clauses, so\nlet’s prepare it now to get a nicer diff.\n\nChange-Id: Ibd5b67c77c87ce3d6aa0ab04ca3d66f9b90dc856\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d106522962d4d9ae814e3feac153305de5541feda"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d106522962d4d9ae814e3feac153305de5541feda"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"b9336a57e19356111f0ae8559122fb329d2e7f0d","is_merged_in_target_branch":false,"change_id":"I3a98d7b81d2ca7962dcef619d4dcfcbd18e98f84","change_number":13226,"patch_set_number":1,"change_status":"MERGED"}],"branch":"refs/heads/canon"},"1e188ee116632fdf34c231d45b94cb8e9f8c8875":{"kind":"REWORK","_number":2,"created":"2025-03-10 16:55:15.000000000","uploader":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"ref":"refs/changes/37/13237/2","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/37/13237/2","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/37/13237/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/37/13237/2"}}},"commit":{"parents":[{"commit":"2adf7b56348b353c4e9f279da0efc172bfcedf63","subject":"feat(users/Profpatsch/whatcd-resolver): add release type filter","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d2adf7b56348b353c4e9f279da0efc172bfcedf63"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 11:51:01.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:55:15.000000000","tz":0},"subject":"refactor(users/Profpatsch/whatcd-resolver): prepare SQL changes","message":"refactor(users/Profpatsch/whatcd-resolver): prepare SQL changes\n\nFor the next step, we need to put more things in WITH-Clauses, so\nlet’s prepare it now to get a nicer diff.\n\nChange-Id: Ibd5b67c77c87ce3d6aa0ab04ca3d66f9b90dc856\nReviewed-on: https://cl.tvl.fyi/c/depot/+/13237\nTested-by: BuildkiteCI\nReviewed-by: Profpatsch \u003cmail@profpatsch.de\u003e\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d1e188ee116632fdf34c231d45b94cb8e9f8c8875"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d1e188ee116632fdf34c231d45b94cb8e9f8c8875"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"2adf7b56348b353c4e9f279da0efc172bfcedf63","is_merged_in_target_branch":true,"change_id":"I3a98d7b81d2ca7962dcef619d4dcfcbd18e98f84","change_number":13226,"patch_set_number":2,"change_status":"MERGED"}],"branch":"refs/heads/canon","description":"Rebase"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~PrologRule","status":"CLOSED","labels":[{"label":"Autosubmit","status":"MAY"},{"label":"Conformant-Commit-Message","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}},{"label":"All-Comments-Resolved","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}},{"label":"Verified","status":"OK","applied_by":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"}}]},{"rule_name":"Code-Owners","status":"CLOSED"}],"submit_requirements":[{"name":"All-Comments-Resolved","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:All-Comments-Resolved\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:All-Comments-Resolved\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Owners","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"rule:Code-Owners","fulfilled":true,"status":"PASS","passing_atoms":["Code-Owners"],"failing_atoms":[]}},{"name":"Conformant-Commit-Message","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Conformant-Commit-Message\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Conformant-Commit-Message\u003dgerrit~PrologRule"],"failing_atoms":[]}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dgerrit~PrologRule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dgerrit~PrologRule"],"failing_atoms":[]}}]}