readme.md

Steps to install -

1. Install sanic - pip install sanic
2. You may need to install scoop if not installed (windows command line installer) Set-ExecutionPolicy RemoteSigned -Scope CurrentUser # Optional: Needed to run a remote script the first time irm get.scoop.sh | iex
3. Install migration tool - scoop install dbmate
4. Install all requirements by - pip install -r requirements.txt
5. dbmate -u 'postgres://<db_user>:<db_pass>@localhost:/<db_name>?sslmode=disable' up

Run app - sanic service:app --debug --reload

Postman collection -

https://grey-rocket-908358.postman.co/workspace/Draipe~55b64f49-0be6-4066-bb02-d3449e1b12eb/collection/12799932-f5b0a6b7-dbcf-4291-81cd-9fd8f6216f4d?action=share&creator=12799932

Schema -

Table users {
  id integer [primary key]
  customer_xid string
  token string 
}

Table wallet {
  id integer [primary key]
  amount integer
  customer_xid string
  enabled_at timestamp
  is_enabled boolean
}

Table transactions {
  id integer [primary key]
  amount number
  final_amount number
  status string
  transaction_time timestamp
  transaction_from string
  transaction_to string
  transaction_type string
  reference_id string
}

Ref: users.customer_xid - wallet.customer_xid // many-to-one
Ref: users.customer_xid < transactions.transaction_from // many-to-one
Ref: users.customer_xid < transactions.transaction_to // many-to-one 

Note: This service is using tortoise-ORM for database interaction.