Skip to content

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

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Description

Creates an api of pop by using chained sql functions for a bottle project. Has the ability to query by parameters.

Remotely tested with testify, the ssl is not verified.

Requires basic authentication for endpoints.

username password
user pass

Tech stack

  • python
    • bottle
    • sqlalchemy
    • testify
    • requests
  • mssql

Docker stack

  • python:latest
  • mcr.microsoft.com/mssql/server:2017-CU17-ubuntu

To run

sudo ./install.sh -u

  • Get all pops: https://localhost/pop
    • Schema id, name, and color
  • CRUD opperations
    • Create: curl -i -X PUT localhost/pop/ -u 'user:pass'
    • Read: https://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