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"
}'