[Mutti, Kristina] Implement the Private Database and Update API

[kristinatrajkovski]

In order to allow our users to create profiles we must have a database which would store the users' related information. Similarly, ir order to allow our users to create, follow, like, unlike, comment, share, and modify routes, we must store those routes and their app user/app specific information. Accordingly, we must also implement the API which would serve as an intermediary between the database and front end.

• Create a User scheme (do not forget to check our diagrams and requirements as reference). Make sure to include username, email, password at least for sign up and log in purposes.
• Create a Route scheme (do not forget to check our diagrams and requirements as reference). Make sure to include Nodes, photos, creator, durations...
• Create Node scheme (do not forget to check our diagrams and requirements as reference). Make sure to include location, link, etc.

Deadline: Friday, 19.04.2024.
Estimated Effort: 3-4 hours
Rewiever: @halil-karabacak

[Mutti499]

Connecting database with our api seems to be problematic. @halil-karabacak can you help me a little bit?

[halil-karabacak]

Do we still have any issue after the today's meeting mate? If we, we may discuss it further!

[Mutti499]

The problem is fixed and our mysql connections seem nice! Good work lets keep itt upppp!

[Mutti499]

For now we implemented:

• Node class model and endpoints to list all of them and one of them
• Route class model and endpoints to list all of them and one of them
• A basic HTML template for main webpage to test endpoints clearly.
• A local MySQL server

[Mutti499]

Okey

• Userclass model and endpoints to list all of them and one of them added
• Frontend to test user creation and node creaton added
  It looks like ready to go! @kristinatrajkovski can you control it ? I may have missed couple things

[kristinatrajkovski]

@Mutti499 I have checked your database and functions. It all works well on my machine.

For the future, please research how we can make the database universal for everyone. We should definitely not create brand new users and routes on every machine.

Besides that, if we are talking about the local version, I think it is perfect. Feel free to make a pull request so all of us can use the database.

[Mutti499]

We merged the branch and everything seems to be working now. Good job @kristinatrajkovski!