This is an automated email from the ASF dual-hosted git repository.
Aman-Mittal pushed a change to branch main
in repository
https://gitbox.apache.org/repos/asf/fineract-business-intelligence.git
from 0b989e7 Merge pull request #65 from
airajena/chore/bi-linting-and-quality-gates
add ec6bb8a fix: RLS fail-open/injection, historical balance replication,
PAR/DPD misclassification, and extractor atomicity/delete-propagation gaps
add fb29727 Fix lint errors and reformat dbt models surfaced after
rebasing onto main
new 2a609fe Merge pull request #63 from airajena/fix/security-concerns
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.env.example | 4 +
.github/workflows/ci.yml | 16 +-
.../intermediate/int_loan_delinquency_status.sql | 241 +++++++++++++++---
.../presentations/mart_repayment_behavior.sql | 2 +-
dbt/models/staging/_staging.yml | 23 ++
.../staging/stg_m_loan_repayment_schedule.sql | 48 ++++
...shot_principal_matches_current_loan_balance.sql | 45 ++++
...ication_matches_actual_overdue_installments.sql | 52 ++++
extractor/cli.py | 5 +
extractor/config.py | 11 +-
extractor/extractor.py | 160 +++++++++---
extractor/watermark_manager.py | 1 -
requirements-dev.txt | 1 +
scripts/bootstrap_fineract_source.sh | 5 +-
scripts/bootstrap_source.sh | 24 +-
.../datasets/delinquency_par_secure_all_dates.sql | 27 +-
.../datasets/delinquency_par_secure_latest.sql | 27 +-
.../datasets/portfolio_health_secure_all_dates.sql | 27 +-
.../datasets/portfolio_health_secure_latest.sql | 27 +-
.../repayment_behavior_secure_all_dates.sql | 3 +-
.../datasets/repayment_behavior_secure_latest.sql | 27 +-
tests/conftest.py | 1 +
tests/integration/test_rls_isolation.py | 36 ++-
tests/unit/extractor/test_cob_gate.py | 24 +-
tests/unit/extractor/test_config.py | 40 +++
tests/unit/extractor/test_helpers.py | 6 +
tests/unit/extractor/test_reconcile.py | 106 ++++++++
tests/unit/extractor/test_source_query.py | 18 ++
tests/unit/extractor/test_upsert_rows.py | 43 ++++
tests/unit/extractor/test_watermark.py | 13 +-
tests/unit/superset/test_rls_templates.py | 70 ++++++
warehouse/schema/raw_tables.sql | 7 +
warehouse/seed/seed_fineract_source.sql | 279 +++++++++++----------
33 files changed, 1123 insertions(+), 296 deletions(-)
create mode 100644 dbt/models/staging/stg_m_loan_repayment_schedule.sql
create mode 100644
dbt/tests/assert_latest_snapshot_principal_matches_current_loan_balance.sql
create mode 100644
dbt/tests/assert_par_classification_matches_actual_overdue_installments.sql
create mode 100644 tests/unit/extractor/test_reconcile.py
create mode 100644 tests/unit/superset/test_rls_templates.py
