python-web-bottle-tdd-api-basic-auth-dolt-raw-sql-pop

Description

Simple web app that serves an api for a bottle project using basic auth. Requires basic authentication for endpoints.

username	password
user	pass

Uses and replicate over 4 databases on the same server:

• beverage, the prod
• test_api, for remotely testing api by testify
• test_chained, tests strategy chained sql functions by pytest
• test_raw, tests strategy raw sql by pytest Note: test data should not be on same server as prod; only brevity made it necessary.

Pytests are aggregated to a single folder, reports, and viewable with an allure server.

Uses sqlalchemy query a table pop using raw sql.

Tech stack

• python
  • bottle
  • sqlalchemy
  • pytest
  • allure-pytest
  • testify
  • response
• dolt

Docker stack

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

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

Credit

Bottle sqlalchemy setup