4math / guess-a-song Goto Github PK

Make a split between dev and prd environments, so that it can be possible to easily develop and also automatically deploy our solution onto the hosting.

Since our game is related to songs, then we need to get some game content.
Download about 100 examples of each genre: rock, pop, rap, Latvian?
Create an SQL file for the automatic data insertion and write all the appropriate data about the song.
Use the following structure to create an SQL query:

INSERT INTO Songs VALUES (SongName, SongPerfomer, SongPath(filename and relative path ATM), SongGenre, SongYear);

For example,

INSERT INTO Songs VALUES ('Numb', 'Linkin Park', 'songs/Linkin Park - Numb.mp3', 'rock', 2003);

Using Vue.js create a view for the home screen.
It should consist of the screen with the background(Possibly some interesting background, Max?)
Draft template:

Buttons should be clickable and add options to which game mode was chosen.

The project requires a database to store the data. The database structure is described in a design requirements document. The database should be automatically created when all containers are created and it should contain all the necessary data. A migration mechanism could be also implemented.

Prepare the full docker-compose build with frontend and backend examples, so that developers could easily start their work and understand how each part is interconnected with others.
This build will also allow to easily make production builds and deployments.

Create a Github Action which will allow after push or commit the deployment onto DigitalOcean platform. This will allow automatic code check and solution receival onto the hosting platform

Create correct networking. Pick a domain name.
The frontend part should be public, but other parts should be in a private network.
Users from outside should be able to access the page to play.