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

Uses and replicate over 4 databases on the same server:

• animal, 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 dog using raw sql.

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

• python:latest
• mariadb

sudo ./install.sh -u

• Get all dogs: http:https://localhost/dog
  • Schema id, breed, and color
• CRUD opperations
  • Create: curl -i -X PUT localhost/dog/ -u 'user:pass'
  • Read: http:https://localhost/dog/ -u 'user:pass'
  • Update: curl -i -X POST localhost/dog/// -u 'user:pass'
  • Delete: curl -i -X DELETE localhost/dog/ -u 'user:pass'

sudo ./install.sh -d

sudo ./install.sh -h

Bottle sqlalchemy setup