Skip to content

README.md

Latest commit

 

History

History
58 lines (48 loc) · 1.16 KB

README.md

File metadata and controls

58 lines (48 loc) · 1.16 KB

Restore database ussd

psql -U username -c "CREATE DATABASE ussd;"
pg_restore --schema-only -U username -d ussd -f ussd.sql

API in Spring Boot to load records to the database from a CDR file

Requirements

  • Java 17
  • Maven 3.9
  • Postgres data base (ussd)
  • Spring Boot

prerequisite

  • update the value of the variables in the application.properties file
  • build the metadata for this property
spring.datasource.path

API to get call data record

Installation

Create and activate virtual environment

python3 -m venv env
source env/bin/activate

Install requirements

pip install -r requirements.txt

Add DB connection data to .env file

echo -e "# DB connection\nDB_HOST=\"\"\nDB_PASSWORD=\"\"\nDB_NAME=\"\"\nDB_USER=\"\"\nDB_PORT=5432" > .env

Running

uvicorn app.main:app --port 8000

Test example

curl --location --request GET 'http://localhost:8000/call_detail_records' \
--header 'Content-Type: application/json' \
--data '{
    "record_date_start": "2023-08-18 10:00:00",
    "record_date_end": "2023-08-18 10:34:00",
    "msisdn":"573213437398"
}'