sanic-sqlalchemy-example

Project is example of usage Sanic framework with Databases package uses async SQLAlchemy core (not orm).

Alembic is used for migrations.

PostgreSQL in Docker is configured for two databases, one is used for tests.

pytest-sanic and pytest-mock is used for tests.

Redis is used for cache.

About project

The project shows an example of implementing the api for an application that works with authorization and currency operations.

Modules in project

users contains the authorization logic and api.

currencies contains the logic of operations on currencies.

transfers contains an api for transferring funds and stores transaction history.

Usage

To run in Docker:

docker-compose build
docker-compose up

You can use backend with http://0.0.0.0/api/

Migrations

To make and run migrations:

docker exec -it sanic-sqlalchemy-example_backend_1 alembic revision --autogenerate -m "name"

docker exec -it sanic-sqlalchemy-example_backend_1 alembic upgrade head
docker exec -it sanic-sqlalchemy-example_backend_1 alembic current

You can specify database url with flag:

alembic -x dburl=postgres://user:password@postgresql/db2 upgrade head

Tests

To run tests:

docker exec -it sanic-sqlalchemy-example_backend_1 pytest tests.py

Commands

Command for update currencies exchange rate:

docker exec -it sanic-sqlalchemy-example_backend_1 python update_currencies.py