feat: use database transactions for the bulk generation

[boazpoolman]

What does it do?

Handle bulk generation using database transactions.

Why is it needed?

Because bulk generating the URL aliases could potentially be a very large task. Using database transactions we can assure the database is not in a "half" broken state mid bulk generation.

How to test it?

Test the different features of the bulk generation feature.

Related issue(s)/PR(s)

13

Todo

• [ ] See if we can remove this comment
• [ ] See if we can use the transactions format as documented here: https://contributor.strapi.io/docs/core/database/transactions
• [ ] See if the database gets "locked" during the transaction
• [ ] Make sure to properly rollback the transaction when an error occurs

[changeset-bot[bot]]

🦋 Changeset detected

Latest commit: 2b1f4113a58b1d4efcf1cc5bfcb10a2cfd41cfac

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 4 packages

| Name | Type | | ----------------------------------- | ----- | | @pluginpal/webtools-core | Minor | | @pluginpal/webtools-addon-menus | Major | | @pluginpal/webtools-addon-redirects | Major | | @pluginpal/webtools-addon-sitemap | Major |

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

[codecov-commenter]

:warning: Please install the to ensure uploads and comments are reliably processed by Codecov.

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 30.21%. Comparing base (16af956) to head (2b1f411).

:exclamation: Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #157 +/- ## ========================================== - Coverage 30.21% 30.21% -0.01% ========================================== Files 4 4 Lines 13968 13975 +7 Branches 4974 4975 +1 ========================================== + Hits 4221 4223 +2 - Misses 7709 7714 +5 Partials 2038 2038 ``` | [Flag](https://app.codecov.io/gh/pluginpal/strapi-webtools/pull/157/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=pluginpal) | Coverage Δ | | |---|---|---| | [unit](https://app.codecov.io/gh/pluginpal/strapi-webtools/pull/157/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=pluginpal) | `30.21% <ø> (-0.01%)` | :arrow_down: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=pluginpal#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.