Objective

The purpose of the mGramSeva Rollout Dashboard Scripts to aggregate the data points from mgramseva DB and services for Rollout dashboard in Metabase

Overview

mGramSeva Rollout Dashboard is a python script for pushing the data from the mGramSeva to Specific table in DB on daily basis which can be loaded to Metabase and graphical dashboard built on top of this table in the metabase.

Pre-requisites

Before you proceed with the configuration, make sure the following pre-requisites are met -

Python 3.9
mGramSeva DB
mGramseva user details who has access to mdms service api
mGramSeva mdms service access

Key Functionalities

Collecting the data on certain data points and inserting the data into the rollout dashboard table in the DB
User Story with details of the data point: https://digit-discuss.atlassian.net/browse/IFIX-485

Deployment Details

Please deploy the following build.

rollout-dashboard-cronjob:develop-2a8d6a44-3

Integration

Integration Scope

mGramSeva Rollout Dashboard is not directly integrated with any of the service except this scripts fetch the data from the MDMS service and mGramSeva DB

Configure the username, tenantId and password of the user for which mdms service access is available on the environment specific yaml file in DevOps. Example below
https://github.com/misdwss/iFix-DevOps/blob/e471be940b88ccd8811b2dfb7a0e4187b0ec39cd/deploy-as-code/helm/environments/mgramseva-qa.yaml#L224

Steps to run locally

please follow the steps below

https://github.com/misdwss/punjab-mgramseva/blob/master/utilities/rollout-dashboard-cronjob/LOCALSETUP.md

Loading to Metabase

The python script inserts the data into table “roll_out_dashboard“ in mgramSevaDb for every run it cleans the old data and creates new data.

This table has to loaded in to the metabase by adding mGramSeva DB to the metbase.