Skip to content
This repository was archived by the owner on Aug 21, 2023. It is now read-only.
This repository was 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

@ExoMonk

Description

@ExoMonk

- 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions