python-web-api-flask-dolt-chained-sql-simple

Description

Creates an api of dog by using raw sql for a flask project. Has the ability to query by parameters. If path is not found, will default to 404 error.

Remotely tested with testify.

Tech stack

• python
  • flask
  • sqlalchemy
  • testify
  • requests

Docker stack

• python:latest
• dolthub/dolt-sql-serverdb:latest

To run

sudo ./install.sh -u

• Get all dogs: http://localhost/dog
  • Schema id, breed, and color
• CRUD opperations
  • Create: curl -i -X PUT localhost/dog/
  • Read: http://localhost/dog/
  • Update: curl -i -X POST localhost/dog///
  • Delete: curl -i -X DELETE localhost/dog/

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h