Skip to content
This repository has been archived by the owner on Aug 21, 2023. It is now read-only.

Flask API: Instantiate starklings MySQL Database with a db.py file #227

Open
ExoMonk opened this issue Aug 8, 2022 · 0 comments
Open

Flask API: Instantiate starklings MySQL Database with a db.py file #227

ExoMonk opened this issue Aug 8, 2022 · 0 comments
Labels
Context: isolated no previous knowledge of the codebase required Difficulty: intermediate mobilise some notions about the field, but can be learned while doing Duration: few days will take a few days State: open ready for contribution Techno: python python

Comments

@ExoMonk
Copy link
Collaborator

ExoMonk commented Aug 8, 2022

- Using feat/backend branch, create your own

Onto the starklings/starklings-backend/db.py file, Instantiate the full Starklings DB using SQL

1 - Created Tables :

  • starklings_user ( #user_id: int AUTO INCREMENT, wallet_address: str, signature: str, username: str, github: str)
  • validated_exercise ( #id, ForeignKey(user_id), path_name, exercise_name)
  • path (#path_id, path_name)
  • exercise (#exercise_id, exercise_name)

2 - Inserting data in path & exercise tables :

  • Using Starklings repository, inserts path and exercise for each possible exercises

3 - Create dedicated models under starklings/starklings-backend/starklings-backend/models/***.py

Pull Request on feat/backend

@ExoMonk ExoMonk added Context: isolated no previous knowledge of the codebase required Duration: under a day wil take up to one day Difficulty: intermediate mobilise some notions about the field, but can be learned while doing State: open ready for contribution Techno: python python Duration: few days will take a few days and removed Duration: under a day wil take up to one day labels Aug 8, 2022
@ExoMonk ExoMonk changed the title Instantiate starklings MySQL Database with a db.py file Flask API: Instantiate starklings MySQL Database with a db.py file Aug 8, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Context: isolated no previous knowledge of the codebase required Difficulty: intermediate mobilise some notions about the field, but can be learned while doing Duration: few days will take a few days State: open ready for contribution Techno: python python
Projects
None yet
Development

No branches or pull requests

1 participant