bearddan2000/python-web-api-flask-basic-auth-postgres-chained-sql-pop

Creates an api of `pop` by using chained sql for a flask project.

python-web-api-flask-basic-auth-postgres-chained-sql-pop

Description

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

Requires basic authentication for CRUD opperations.

username	password
user	pass

Remotely tested with testify.

Tech stack

• python
  • flask
  • sqlalchemy
  • testify
  • requests

Docker stack

• python:latest
• postgres:alpine

To run

sudo ./install.sh -u

• Get all pops: http://localhost/pop
  • Schema id, name, and color
• CRUD opperations
  • Create: curl -i -X PUT localhost/pop/ -u 'user:pass'
  • Read: http://localhost/pop/ -u 'user:pass'
  • Update: curl -i -X POST localhost/pop/// -u 'user:pass'
  • Delete: curl -i -X DELETE localhost/pop/ -u 'user:pass'

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h