Skip to content

bearddan2000/python-web-bottle-api-cockroachdb-multi-node-without-ssl-chained-sql-pop

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

python-web-bottle-api-cockroachdb-multi-node-without-ssl-chained-sql-pop

Description

Simple web app that serves an api for a bottle project.

Uses sqlalchemy query a table pop using chained sql functions.

Remotely tested with testify.

Tech stack

  • python
    • bottle
    • sqlalchemy
    • testify
    • response
  • 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/
    • Read: http://localhost/pop/
    • Update: curl -i -X POST localhost/pop///
    • Delete: curl -i -X DELETE localhost/pop/

To stop

sudo ./install.sh -d

For help

sudo ./install.sh -h

Credit

Bottle sqlalchemy setup