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

• 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

• 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