feat(event_tags): Add event_tags table and migration script

imksoo commented 6 months ago

Description

This pull request introduces a new event_tags table and its associated migration script. By expanding and indexing the contents of the tags field of the events table in the events_tags table in advance, the search process by REQ can be made much faster than the original JSONB operation.

Related Issue

#348

Motivation and Context

The addition of the event_tags table is required to efficiently manage and query event tag data. This change aims to improve data organization and access, facilitating better event management within the application.

How Has This Been Tested?

The changes have been tested in a local development environment. I performed the following tests:

Successfully ran the migration script to create the event_tags table.
Inserted sample data into the event_tags table and verified its integrity.
Checked that the new table does not adversely affect other areas of the code.

Types of changes

[ ] Non-functional change (docs, style, minor refactor)
[x] 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 change)

Checklist:

[x] My code follows the code style of this project.
[ ] My change requires a change to the documentation.
[ ] I have updated the documentation accordingly.
[x] I have read the CONTRIBUTING document.
[x] I have added tests to cover my changes.
[x] All new and existing tests passed.

coveralls commented 6 months ago

Pull Request Test Coverage Report for Build 7443641804

0 of 0 changed or added relevant lines in 0 files are covered.
No unchanged relevant lines lost coverage.
Overall coverage increased (+0.1%) to 50.589%

Totals
Change from base Build 6132344305:	0.1%
Covered Lines:	1189
Relevant Lines:	2298

💛 - Coveralls

github-actions[bot] commented 5 months ago

:tada: This PR is included in version 1.26.0 :tada:

The release is available on GitHub release

Your semantic-release bot :package::rocket:

cameri / nostream