)]}'
{"id":"depot~13239","triplet_id":"depot~canon~I28f6546353e2930156eaeb427ba5122559aea49b","project":"depot","branch":"canon","hashtags":[],"change_id":"I28f6546353e2930156eaeb427ba5122559aea49b","subject":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query","status":"MERGED","created":"2025-03-10 16:50:13.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":"f2a6d21c33e53d119c3907fcc0abb344549f7c9f","_number":13239,"virtual_id_number":13239,"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 16:50:14.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 16:54:11.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":"5df1f3e576ecab4ade056314f209176548f0f977","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:50:13.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"21c863c8f0b338d2fe8021eddbc31017fc304679","tag":"autogenerated:buildkite~trigger","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 16:50:14.000000000","message":"Patch Set 1:\n\nStarted build for patchset #1 on: https://buildkite.com/tvl/depot/builds/38936","accounts_in_message":[],"_revision_number":1},{"id":"b2a0ee7dacbe635a24d8663d96599daa1b0629fb","author":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"date":"2025-03-10 16:52:34.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"ba22b2f3470f176e64ca023fcec687c43a5d8b2b","tag":"autogenerated:buildkite~result","author":{"_account_id":1000014,"name":"BuildkiteCI","username":"buildkite","tags":["SERVICE_USER"]},"date":"2025-03-10 16:54:11.000000000","message":"Patch Set 1: Verified+1\n\nBuild of patchset 1 passed: https://buildkite.com/tvl/depot/builds/38936","accounts_in_message":[],"_revision_number":1},{"id":"f2a6d21c33e53d119c3907fcc0abb344549f7c9f","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 5efe6cefe81951649923e6179a095f5f8ec22105","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"5efe6cefe81951649923e6179a095f5f8ec22105","revisions":{"0088d195d76887190c83abd41aa1641ca83fda7b":{"kind":"REWORK","_number":1,"created":"2025-03-10 16:50:13.000000000","uploader":{"_account_id":1000013,"name":"Profpatsch","email":"mail@profpatsch.de","username":"Profpatsch"},"ref":"refs/changes/39/13239/1","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/39/13239/1","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/39/13239/1"}}},"commit":{"parents":[{"commit":"4f728399364ca7ef8145f64cde630dc86860daf4","subject":"feat(users/Profpatsch/whatcd-resolver): add simple favourites","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d4f728399364ca7ef8145f64cde630dc86860daf4"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 13:33:42.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 13:33:42.000000000","tz":60},"subject":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query","message":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query\n\nOr rather make it less slow lol.\nI should put the artists in a computed column now.\n\nChange-Id: I28f6546353e2930156eaeb427ba5122559aea49b\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d0088d195d76887190c83abd41aa1641ca83fda7b"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d0088d195d76887190c83abd41aa1641ca83fda7b"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"4f728399364ca7ef8145f64cde630dc86860daf4","is_merged_in_target_branch":false,"change_id":"I7aa6d99dc26e24eb22ef56ffd4d2db5c6978ad48","change_number":13238,"patch_set_number":1,"change_status":"MERGED"}],"branch":"refs/heads/canon"},"5efe6cefe81951649923e6179a095f5f8ec22105":{"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/39/13239/2","fetch":{"anonymous http":{"url":"https://cl.tvl.fyi/depot","ref":"refs/changes/39/13239/2","commands":{"Checkout":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://cl.tvl.fyi/depot refs/changes/39/13239/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://cl.tvl.fyi/depot refs/changes/39/13239/2"}}},"commit":{"parents":[{"commit":"bc09c01dfdb1f33c5884f1c9858bc7f8a9a3fc6b","subject":"feat(users/Profpatsch/whatcd-resolver): add simple favourites","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003dbc09c01dfdb1f33c5884f1c9858bc7f8a9a3fc6b"}]}],"author":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 13:33:42.000000000","tz":60},"committer":{"name":"Profpatsch","email":"mail@profpatsch.de","date":"2025-03-10 16:55:15.000000000","tz":0},"subject":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query","message":"fix(users/Profpatsch/whatcd-resolver): speed up artistName query\n\nOr rather make it less slow lol.\nI should put the artists in a computed column now.\n\nChange-Id: I28f6546353e2930156eaeb427ba5122559aea49b\nReviewed-on: https://cl.tvl.fyi/c/depot/+/13239\nReviewed-by: Profpatsch \u003cmail@profpatsch.de\u003e\nTested-by: BuildkiteCI\n","web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d5efe6cefe81951649923e6179a095f5f8ec22105"}],"resolve_conflicts_web_links":[{"name":"cgit","tooltip":"Open in GitWeb","url":"https://code.tvl.fyi/commit/?id\u003d5efe6cefe81951649923e6179a095f5f8ec22105"}]},"parents_data":[{"branch_name":"refs/heads/canon","commit_id":"bc09c01dfdb1f33c5884f1c9858bc7f8a9a3fc6b","is_merged_in_target_branch":true,"change_id":"I7aa6d99dc26e24eb22ef56ffd4d2db5c6978ad48","change_number":13238,"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":[]}}]}