python-web-bottle-basic-auth-chained-api-cockroachdb-multi-node-without-ssl-pop
Description
Simple web app that serves an api for a bottle project.
Uses sqlalchemy with chained functions to query a table pop
.
Remotely tested with testify. Requires basic authentication for endpoints.
username | password |
---|---|
user | pass |
Tech stack
- python
- bottle
- sqlalchemy
- testify
- requests
- cockroachdb
Docker stack
- python:latest
- cockroachdb/cockroach:v19.2.4
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