Upload pictures of played games

BGWE / BoardgameWE

Backend of the Board Game Componion application.

MIT License

2 stars 0 forks source link

Open FServais opened 4 years ago

FServais commented 4 years ago

When encoding the scores/result of a game, we could add the possibility to upload a picture.

FServais commented 4 years ago

FServais commented 4 years ago

Here's how I think we could design this: Upload Image Game (1)

In this case:

New API: PUT /game/<id>/img/upload to upload an image in game with id id
PUT /game/<id>/img/upload is waiting on PUT /game to finish and to use the game ID

Questions:

What do we need to store in DB?
- Only S3 URL in game table?
- Create a new table to reference all uploads?
Do we need other APIs?
How to handle picture remove?
What did I forget? :)

waliens commented 4 years ago

Having a table centralizing all uploaded files is a good idea.
We would need new API endpoints for any image upload i guess (profile pic? event picture?)
For removing, we can simply unlink files from related objects/tables in the database (game, event..) and have a cron job cleaning unused files once in a while.