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

Phase I

• A script that generates the SQLite DB using blz datafile downloaded from the Deutsche Bundesbank - Done
• Modifications in the CMake build system to call this script at build time. - Done
• Replacing the part of code that uses the text datafile with the code that reads from this database. - Done
• Updating tests, documentation and benchmark 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

• Add database generating scripts for additional countries (Netherlands and Switzerland) - Done

• Enable automatic database generation on build time - Done

• Modifications in the library to enable it to accept databases of these additional countries - Done

• Modifications in the command-line tool to take 'country' as an option. - Done

• Add tests and documentation for this added code. - Done

Blog Post : https://prasunka.github.io/posts/gsoc2020-phase-2

Phase III

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

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