Add Bulletin

[SaaammmyyyS]

Description: Create a new bulletin with optional PDF attachment.

Requirements:

• [x] Endpoint should be POST /api/bulletins'
• [x] Use a database transaction to ensure that both the bulletin creation and PDF attachment upload (if applicable) are completed successfully. If any part of the process fails, the transaction should be rolled back. Refer to this url: https://www.prisma.io/docs/orm/prisma-client/queries/transactions

Validation:

• [x] category_id: Required, must be a valid integer and exist in categories.
• [x] title: Required
• [x] pdf_attachment: Optional, if provided, should be a valid file.
• [x] content: Required, should be a text string.
• [x] author: Required, non-empty string.

Request Body: { "category_id": "integer", "title": "string", "content": "text", "author": "string", "pdf_attachment": "file" }

[khesir]

I'm committing but I got blocked by the pre-commit which says that. any fix on this?

Also, I have some troubles on JWT Access Token when uploading pdf to storage files.

I'm using buckets for pdf storages, but for some reason I need to login I think any fix on allowing me to save to supabase bucket storage?

Here's the code for storage uploads and where I get the error

[khesir]

Unit test problem fix has been commit added here in this commit 0b82803f2242084cdde3e83d616f0c33e37011e0

[khesir]

Problem fix on authentication, my bad on being inexperience

Fix: just used Service key for full admin to be able to use the storage :DD

[Miraii133]

Pinging backend dev @SaaammmyyyS

@khesir Since ivan is the backend head, make sure you set him as the reviewer of the PR. Afterwards, to ensure that he'll 100% see your PR, send a message to the GC to have it checked

[Miraii133]

Oops! I just realized you guys were communicating through the PRs

[khesir]

Pinging backend dev @SaaammmyyyS

@khesir Since ivan is the backend head, make sure you set him as the reviewer of the PR. Afterwards, to ensure that he'll 100% see your PR, send a message to the GC to have it checked

Actually, we were figuring out how pr works and we might did or me did some unnecessary pr and close it :DD

Will never do it again

[Miraii133]

Pinging backend dev @SaaammmyyyS @khesir Since ivan is the backend head, make sure you set him as the reviewer of the PR. Afterwards, to ensure that he'll 100% see your PR, send a message to the GC to have it checked

Actually, we were figuring out how pr works and we might did or me did some unnecessary pr and close it :DD

Will never do it again

It's totally fine dont worry, as long as you're learning something :^)