bearddan2000 / python-web-bottle-api-basic-auth-ssl-dolt-chained-sql-pop

Simple web app that serves static pages

python-web-bottle-api-basic-auth-ssl-dolt-chained-sql-pop

Description

Simple web app that serves static pages for a bottle project.

Uses sqlalchemy chained sql function to query a table pop.

Is self-signed ssl cert. Requires basic authentication for endpoints.

username	password
user	pass

Remotely tested with testify, ssl is not verified.

Tech stack

• python
  • bottle
  • sqlalchemy
  • cheroot
  • testify
  • requests
• bootstrap
• jquery
• dataTable
• dolthub/dolt-sql-serverdb
• ssl

Docker stack

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

To run

sudo ./install.sh -u sudo ./install.sh -u

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

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h

Credit

• Bottle sqlalchemy setup
• Disable ssl for testing