Migrations and models for group/project filters for group destinations

What does this MR do and why?

This MR adds migrations and models for supporting subgroup and project level filters for group level external audit event destinations.

Migrations

group_group_filter

up

rake db:migrate:up:main VERSION=20231016061148

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 89346
main: == 20231016061148 CreateAuditEventsStreamingHttpGroupGroupFilters: migrating ==
main: -- create_table(:audit_events_streaming_http_group_group_filters)
main:    -> 0.0148s
main: == 20231016061148 CreateAuditEventsStreamingHttpGroupGroupFilters: migrated (0.1662s)

down

rake db:migrate:down:main VERSION=20231016061148

main: == [advisory_lock_connection] object_id: 179400, pg_backend_pid: 88902
main: == 20231016061148 CreateAuditEventsStreamingHttpGroupGroupFilters: reverting ==
main: -- drop_table(:audit_events_streaming_http_group_group_filters)
main:    -> 0.0062s
main: == 20231016061148 CreateAuditEventsStreamingHttpGroupGroupFilters: reverted (0.0108s)

group_project_filter

up

rake db:migrate:up:main VERSION=20231016061239

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 90270
main: == 20231016061239 CreateAuditEventsStreamingHttpGroupProjectFilters: migrating
main: -- create_table(:audit_events_streaming_http_group_project_filters)
main:    -> 0.0059s
main: == 20231016061239 CreateAuditEventsStreamingHttpGroupProjectFilters: migrated (0.1472s)

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 90270

down

rake db:migrate:down:main VERSION=20231016061239

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 89796
main: == 20231016061239 CreateAuditEventsStreamingHttpGroupProjectFilters: reverting
main: -- drop_table(:audit_events_streaming_http_group_project_filters)
main:    -> 0.0023s
main: == 20231016061239 CreateAuditEventsStreamingHttpGroupProjectFilters: reverted (0.0076s)

main: == [advisory_lock_connection] object_id: 179420, pg_backend_pid: 89796

Sample queries for usage of tables

Fetch the list of all subgroup filters for a destination

select * from audit_events_streaming_http_group_group_filters where external_audit_event_destination_id = 6;

Fetch the list of all project filters for a destination

select * from audit_events_streaming_http_group_project_filters where external_audit_event_destination_id = 6;

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.

Closes #424173 (closed)