Connecting API to Database

[MESC2004]

• Use Case Description Detail: Connecting the basic API and making it able to pull values from the MySQL database.

• Related Requirements: Finished MySQL database, finished basic API, determination of how the JSON files will be organized for pulling data from SQL.

• Goal In Context: Connecting the Js API to the MySQL server.

• Preconditions: Completion of issue #9 and issue #12.

• Successful End Condition: The API server runs and is able to get requests to pull data from the database.

• Failed End Condition: The server does not run, cannot connect to the MySQL server, or is unable to retrieve the data from the MySQL server.

• Primary Actors: Backend developer, Database developer.

• Secondary Actors: N/A

• Trigger: The API asks the MySQL server for data.

• Main Flow:

  • The API gets a request for data through an endpoint.
  • The API processes the request and asks the MySQL server for data.
  • The MySQL server gives the requested data to the API.
  • The API returns the requested data to the client, or an appropriate response depending on the situation.

• Extensions: Get, Post, Put and Delete requests.

[MESC2004]

Closed with PR #49.