How to use:

source venv/bin/activate
pip install -r requirements.txt 
>> without using current database
          removing current database -> (
            rm -rf __pycache__
            rm -rf migrations
            rm -rf ConsignmentDB.db
          )
- python manage.py db init
- python manage.py db migrate
- python manage.py db upgrade
- flask seed run 
- flask run
>> with current database
source venv/bin/activate
pip install -r requirements.txt 

- flask run

index:
http://localhost:5000/consignments/?page=1&per_page=1&filter_by_name=sample&filter_by_vehicle=car&filter_by_service=express
-----
sample result: 

http://localhost:5000/consignments/?page=1&per_page=1

{
    "items": [
        {
            "billing": {
                "billingref": "F6RTU150NFK7",
                "totalprice": "100"
            },
            "courier": {
                "courier_name": "Dianemarie",
                "courier_phone_number": "+6282045321414"
            },
            "date_created": "Fri, 07 May 2021 05:19:04 GMT",
            "date_modified": "Fri, 07 May 2021 05:19:04 GMT",
            "delivery": {
                "delivery_address": {
                    "detail": "Temple, Alma, Bukit Mertajam, Central Seberang Perai District, Seberang Perai, Penang, 14000, Malaysia",
                    "latitude": "5.329132899999999",
                    "longitude": "100.48077345323833",
                    "name": "Temple"
                },
                "delivery_date": "2021-1-20",
                "delivery_time_from": "08:45",
                "delivery_time_to": "10:45"
            },
            "id": 1,
            "name": "sample1-consignments",
            "pickup": {
                "pickup_address": {
                    "detail": "3, Jalan PJS 11/11, Bandar Sunway, 47500 Subang Jaya, Selangor, Malaysia",
                    "latitude": "3.0697",
                    "longitude": "101.60687",
                    "name": "Sunway Lagoon"
                },
                "pickup_date": "2021-1-20",
                "pickup_time_from": "08:00",
                "pickup_time_to": "08:30"
            },
            "purchase_order": {
                "order_from": "website",
                "order_ref": "QGPVOOESFGAD",
                "order_status": "completed",
                "payment_status": "completed",
                "payment_type": "online-payment"
            },
            "receiver": {
                "address": {
                    "detail": "Temple, Alma, Bukit Mertajam, Central Seberang Perai District, Seberang Perai, Penang, 14000, Malaysia",
                    "latitude": "5.329132899999999",
                    "longitude": "100.48077345323833",
                    "name": "Temple"
                },
                "contact": {
                    "name": "Nerita",
                    "phone_number": "+6286788937718"
                }
            },
            "sender": {
                "address": {
                    "detail": "3, Jalan PJS 11/11, Bandar Sunway, 47500 Subang Jaya, Selangor, Malaysia",
                    "latitude": "3.0697",
                    "longitude": "101.60687",
                    "name": "Sunway Lagoon"
                },
                "contact": {
                    "name": "Norma",
                    "phone_number": "+6289808470134"
                }
            },
            "service_type": "express",
            "vehicle_type": "car"
        }
    ],
    "next_page": 2,
    "no_of_items": 24,
    "page": 1,
    "per_page": 1,
    "prev_page": null,
    "total_pages": 24
}