Create new Album Routes

[rahulharpal1603]

After my #466 PR is merged, we need to create the full backend support for the Albums table defined in this diagram:

https://dbdiagram.io/d/PictoPy-685704c4f039ec6d364647e1

First, create a database file that has all the DB utils and table creation functions. Remember, we need to have hidden albums too, even if we show the hidden albums, the user will require password to open a hidden album.

Then implement these routes:

Core Album Operations

GET /albums/

Get all albums

• Query params: show_hidden=true/false (default: false)

POST /albums/

Create a new album

GET /albums/{album_id}

Get specific album details

PUT /albums/{album_id}

Update album (name, description, visibility, password)

DELETE /albums/{album_id}

Delete an album

Image Management

GET /albums/{album_id}/images

Get all images in an album

POST /albums/{album_id}/images

Add images to an album

DELETE /albums/{album_id}/images/{image_id}

Remove image from album

DELETE /albums/{album_id}/images

Remove multiple images from album

• Body: { image_ids: [uuid, uuid, ...] }

[rohan-pandeyy]

Hello @rahulharpal1603,
I'd like to have a take on this issue. Could you please assign it to me?

[rahulharpal1603]

Sure @rohan-pandeyy

To start working on this, you have to create a PR from my branch, because this branch is not merged yet.

Commands:

git remote add rahulRepo https://github.com/rahulharpal1603/PictoPy

git fetch rahulRepo

git checkout -b branch_name rahulRepo/backend-revamp

Then you can start working on this branch_name in your VS Code.

Make sure you do changes like this only, otherwise you won't see my backend changes

[rahulharpal1603]

Also, delete app/database/PictoPy.db file before starting the server.

To view SQLite database content use this VS code extension: https://marketplace.visualstudio.com/items?itemName=alexcvzz.vscode-sqlite

[rahulharpal1603]

@rohan-pandeyy

Use this updated postman collection: https://web.postman.co/workspace/cbd41f33-d0ac-4147-9494-4740c472b7ec

[rohan-pandeyy]

Sure @rohan-pandeyy

To start working on this, you have to create a PR from my branch, because this branch is not merged yet.

Commands:

git remote add rahulRepo https://github.com/rahulharpal1603/PictoPy

git fetch rahulRepo

git checkout -b branch_name rahulRepo/backend-revamp

Then you can start working on this branch_name in your VS Code.

Make sure you do changes like this only, otherwise you won't see my backend changes

Thanks for the commands, and thank you for assigning, much appreciated. :)

@rohan-pandeyy

Use this updated postman collection: https://web.postman.co/workspace/cbd41f33-d0ac-4147-9494-4740c472b7ec

And thank you for the updated Postman collection as well, I'll go through them