)]}'
{"id":"openstack%2Fwatcher~996849","triplet_id":"openstack%2Fwatcher~master~Ic064a00d2bd0d763e0800fb48e7c6b26cf26d2cc","project":"openstack/watcher","branch":"master","topic":"bp/audit-pipeline","attention_set":{"30002":{"account":{"_account_id":30002,"name":"Douglas Viroel","email":"viroel@gmail.com","username":"dviroel"},"last_update":"2026-07-10 20:00:57.000000000","reason":"Someone else replied on the change"}},"removed_from_attention_set":{},"hashtags":[],"change_id":"Ic064a00d2bd0d763e0800fb48e7c6b26cf26d2cc","subject":"Audit Pipeline Object and DBAPI","status":"NEW","created":"2026-07-10 20:00:42.000000000","updated":"2026-07-10 22:05:21.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":true,"submittable":false,"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"41a05b18b0e4744c7f5c1a35290bd59f4906504f","_number":996849,"virtual_id_number":996849,"owner":{"_account_id":30002,"name":"Douglas Viroel","email":"viroel@gmail.com","username":"dviroel"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"tag":"autogenerated:zuul:check","value":1,"date":"2026-07-10 22:05:21.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"disliked":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"all":[{"value":-1,"date":"2026-07-10 20:12:14.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","value":-1,"default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":28006,"name":"teim-ci","display_name":"teim-ci","email":"ci@seanmooney.info","username":"ci-sean-mooney","status":"this is a third-party ci account run by sean-k-mooney on irc\nhosted at zuul.teim.app"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2026-07-10 20:00:57.000000000","updated_by":{"_account_id":28006,"name":"teim-ci","display_name":"teim-ci","email":"ci@seanmooney.info","username":"ci-sean-mooney","status":"this is a third-party ci account run by sean-k-mooney on irc\nhosted at zuul.teim.app"},"reviewer":{"_account_id":28006,"name":"teim-ci","display_name":"teim-ci","email":"ci@seanmooney.info","username":"ci-sean-mooney","status":"this is a third-party ci account run by sean-k-mooney on irc\nhosted at zuul.teim.app"},"state":"CC"},{"updated":"2026-07-10 20:12:14.000000000","updated_by":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"reviewer":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"state":"REVIEWER"},{"updated":"2026-07-10 22:05:21.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"}],"messages":[{"id":"94c5b747f652efc75b0e09b01644af72eeb6541a","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":30002,"name":"Douglas Viroel","email":"viroel@gmail.com","username":"dviroel"},"date":"2026-07-10 20:00:42.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"9708a8675b00f63779db3ec3faf887ba2a9d8a57","tag":"autogenerated:zuul:automatic-ci","author":{"_account_id":28006,"name":"teim-ci","display_name":"teim-ci","email":"ci@seanmooney.info","username":"ci-sean-mooney","status":"this is a third-party ci account run by sean-k-mooney on irc\nhosted at zuul.teim.app"},"date":"2026-07-10 20:00:57.000000000","message":"Patch Set 1:\n\nStarting automatic-ci jobs.","accounts_in_message":[],"_revision_number":1},{"id":"a459d6b4095a1f3d1ba0e7439b90204b17fd31f8","author":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"},"date":"2026-07-10 20:12:14.000000000","message":"Patch Set 1: Code-Review-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttp://docs.openstack.org/infra/manual/developers.html#automated-testing\n\nhttps://gateway-cloud-softwarefactory.apps.ocp.cloud.ci.centos.org/zuul/t/rdoproject.org/buildset/afa6e5f5ddc54b1ab7b5e75fde63f9eb\n\n- openstack-meta-content-provider-master https://gateway-cloud-softwarefactory.apps.ocp.cloud.ci.centos.org/zuul/t/rdoproject.org/build/8b01c19af0ff4e1e851467debe69fdc7 : FAILURE in 10m 09s\n- watcher-operator-validation-master https://gateway-cloud-softwarefactory.apps.ocp.cloud.ci.centos.org/zuul/t/rdoproject.org/build/ef3705cdff784b1d87bd806db4d5c523 : SKIPPED Skipped due to failed job openstack-meta-content-provider-master","accounts_in_message":[],"_revision_number":1},{"id":"f2634f1771056d84ec7aa9e7a914aa97ef76a4f4","tag":"autogenerated:zuul:automatic-ci","author":{"_account_id":28006,"name":"teim-ci","display_name":"teim-ci","email":"ci@seanmooney.info","username":"ci-sean-mooney","status":"this is a third-party ci account run by sean-k-mooney on irc\nhosted at zuul.teim.app"},"date":"2026-07-10 20:41:00.000000000","message":"Patch Set 1:\n\n(2 comments)\n\nBuild succeeded (automatic-ci pipeline).\nhttps://zuul.teim.app/t/main/buildset/b839aa91b09f423f980e31b035f09dde\n\n- teim-code-review https://zuul.teim.app/t/main/build/b6d0fda7e6644e23a2f80edb0bb7f139 : SUCCESS in 15m 58s","accounts_in_message":[],"_revision_number":1},{"id":"41a05b18b0e4744c7f5c1a35290bd59f4906504f","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2026-07-10 22:05:21.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/2c3c3148f18e49b9b4850f67af71df21\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/1d4bda29651143d684ab448097c61ffe : SUCCESS in 7m 26s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3c7e5fe51f564be9bf629be1f17b0962 : SUCCESS in 4m 03s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/0839c2c7f78c491b9500abdab0aaf84a : SUCCESS in 4m 56s\n- openstack-tox-py313 https://zuul.opendev.org/t/openstack/build/12fd5f1c69cc495396ebfda3a90af04d : SUCCESS in 5m 05s\n- openstack-tox-py314 https://zuul.opendev.org/t/openstack/build/62e24387a01d40f3a314fbd5c40c3ed4 : SUCCESS in 8m 39s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/57515854bdc943648c58eb058dbb5bc7 : SUCCESS in 8m 28s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/7057829934a54481b3824718ca91d6bf : SUCCESS in 4m 41s\n- openstack-tox-py313-eventlet https://zuul.opendev.org/t/openstack/build/fd3a80d210084949b5d71213b04b28c6 : SUCCESS in 5m 21s\n- watcher-grenade https://zuul.opendev.org/t/openstack/build/8474516dfe084a1184e0bac24fbb0ebf : SUCCESS in 54m 26s\n- watcher-grenade-skip-level-always https://zuul.opendev.org/t/openstack/build/41e529f4e0d24e61bbe949a950b2c6d3 : SUCCESS in 24m 29s\n- watcher-tempest-api-ipv6-only https://zuul.opendev.org/t/openstack/build/ddfd30353cdc4ed3ae32423b8706e2df : SUCCESS in 42m 02s\n- watcher-tempest-gnocchi https://zuul.opendev.org/t/openstack/build/2ea969a4f4324baebb4c8bddc2c5f4bc : SUCCESS in 1h 56m 06s\n- watcher-tempest-prometheus https://zuul.opendev.org/t/openstack/build/55224aab0dcf42109ed0f68ce472420b : SUCCESS in 1h 57m 30s\n- watcher-tempest-prometheus-eventlet https://zuul.opendev.org/t/openstack/build/583d82c5f0f14d86bff0c6c12b16dc72 : SUCCESS in 1h 57m 36s\n- watcher-tempest-aetos https://zuul.opendev.org/t/openstack/build/5eca14545a7348c99448fc956fe87bec : SUCCESS in 1h 56m 54s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"4907103b961a2c7c6bf2d69ba8d10a85cee3f914","revisions":{"4907103b961a2c7c6bf2d69ba8d10a85cee3f914":{"kind":"REWORK","_number":1,"created":"2026-07-10 20:00:42.000000000","uploader":{"_account_id":30002,"name":"Douglas Viroel","email":"viroel@gmail.com","username":"dviroel"},"ref":"refs/changes/49/996849/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/watcher","ref":"refs/changes/49/996849/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/watcher refs/changes/49/996849/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/watcher refs/changes/49/996849/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/watcher refs/changes/49/996849/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/watcher refs/changes/49/996849/1"}}},"commit":{"parents":[{"commit":"cb00210504a32efa198a073621c3e20c8c2660cf","subject":"Add metric cache to DataSourceBase","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/cb00210504a32efa198a073621c3e20c8c2660cf"}]}],"author":{"name":"Douglas Viroel","email":"viroel@gmail.com","date":"2026-07-03 17:35:01.000000000","tz":-180},"committer":{"name":"Douglas Viroel","email":"viroel@gmail.com","date":"2026-07-10 19:59:42.000000000","tz":-180},"subject":"Audit Pipeline Object and DBAPI","message":"Audit Pipeline Object and DBAPI\n\nAdds database models, migration, DB API, and versioned objects for\nAuditPipeline and AuditPipelineStage resources, which together\nrepresent a multi-strategy audit execution pipeline.\n\nDB migration:\n- New audit_pipelines table (uuid, state, audit_type, execution_mode,\nauto_trigger, hostname, status_message; uuid/state/audit_type\nnon-nullable)\n- New audit_pipeline_stages table (uuid, position, name, goal,\nstrategy, scope, parameters; uuid non-nullable)\n- ActionPlan: audit_pipeline_id FK added; audit_id and strategy_id\nrelaxed to nullable to support pipeline-driven plans\n\nSQLAlchemy models:\n- AuditPipeline and AuditPipelineStage model classes\n- ActionPlan extended with audit_pipeline_id and relationship\n\nDB API (db/api.py + db/sqlalchemy/api.py):\n- Full CRUD for AuditPipeline: create, get by id/uuid, list, update,\ndestroy (cascades to stages), soft-delete (cascades soft-delete to\nstages)\n- Full CRUD for AuditPipelineStage: create, get by id/uuid, list,\nupdate, destroy, soft-delete\n\nPartially-implements: bp audit-pipeline\nAssisted-By: Claude Code (Sonnet 4.6)\nChange-Id: Ic064a00d2bd0d763e0800fb48e7c6b26cf26d2cc\nSigned-off-by: Douglas Viroel \u003cviroel@gmail.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/4907103b961a2c7c6bf2d69ba8d10a85cee3f914"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/watcher/commit/4907103b961a2c7c6bf2d69ba8d10a85cee3f914"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"OK","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY","applied_by":{"_account_id":26471,"name":"Software Factory CI","email":"softwarefactory-operations-team@redhat.com","username":"sf-project-io"}},{"label":"Workflow","status":"MAY"}]}],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{"label:Code-Review\u003dMAX":"","label:Code-Review\u003dMIN":""}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}