GSoC/2020/StatusReports/PrasunKumar

Project Overview

KtoBLZCheck is a library to check bank account numbers and bank codes (BLZ) of German Banks and other international banks. Currently, KtoBLZCheck uses multiple bankdata files in text format which are valid at different dates. The data which is regularly retrieved from ​Deutsche Bundesbank is valid for three months. This leads to a lot of duplication of data.
The idea is to integrate the support for query and generation of SQLite databases into KtoBLZCheck to replace the text files used currently. This will avoid duplicate data and enable the support for multiple countries improving the scope of this library.
I also aim to create an API for querying the databases, so as to integrate these databases into other applications.

Mentors : Ralf Habacker, Thomas Baumgart, Ingo Klöcker

Blog

• GSoC Blog: http://prasunka.github.io/tag/gsoc

Repositories

• KtoBLZCheck
• Development fork

Deliverables Progress

Phase I

• To create a script that generates the SQLite database from the latest available bankdata file downloaded from the Deutsche Bundesbank's website by following the specifications available here. - Done

• Modifications in the CMake build system to run this script at build time. - Done

• Methods to allow the library to query required data from the databases. - Done

• Replacing the part of code that uses the text data-file with code that reads from the databases while maintaining the similar structure so as to least impact the public API. - Done

• Adding tests to work with the new database and documentation for the added code. - Done

• Updating the benchmark tool to work with the new database. - Done

• Modifying the command-line tool to enable support for the user-supplied database. - Done

Blog Posts

• GSoC'20 progress : Week 1

• GSoC'20 progress : Week 2 & 3

• GSoC'20 progress : Phase I

Phase II

• To create a script that generates the SQLite database for the Netherlands from the latest available bankdata Excel file downloaded from the Dutch Payments Association website. - Done

• To create a script that generates the SQLite database for Switzerland from the latest available bankdata file downloaded from the SIX group's website which operates the infrastructure for the Swiss financial centre. - Done

• Modifications in the CMake build system to generate these databases on build time - Done

• Modifications in the library to enable it to accept databases of these additional countries as there is support for only German databases - Done

• Modifications in the command-line tool to take 'country' as an option to distinguish between different country's validation checks. - Done

• Add tests and documentation for these additions. - Done

Blog Post : GSoC'20 progress : Phase II

Phase III

• Add support for validation of bankIds and accountIds for additional countries. - Done

• Mark the now redundant and unusable methods of the public API as deprecated. - Done

• Create a public API to enable and extend the functionality of checking for updates and updating of bank-data databases from the project's source site to a client of the library. - Setting up the remote source

• Create an API to enable the query of these databases to integrate them into other applications. - Work in Progress

• Add documentation for these APIs. - Adding along with code

Blog Post : GSoC'20 progress : Phase III

Bug Fixes

• Fixed test errors when run using python3
• Fix for code beautifier not finding any files
• Fixed warning on running code beautifier

Opened Merge Request

• Provision of bank data in SQLite Format

Proposal

• GSoC Proposal: https://drive.google.com/file/d/1bbmQB_THdbA0T15atBLEtAJjL05Zdfyu/view?usp=sharing

About Me

• Name  : Prasun Kumar
• Email  : [email protected]
• IRC Nick : prasunkr
• Location : Guwahati, India (UTC +05:30)

• Telegram  : prasunkr
• GitHub  : prasunka
• Phabricator : prasunkr
• SourceForge : prasun
• KDE Identity: prasunkr