GSoC project discussions

[Prasun Kumar]

Hi everyone,
So for the database, I am considering this approach.
At the time of release, the project will ship with a DB file which will
have a column of valid_upto for each entry. This valid_upto value would be
the last date of the current quarter. Then, at the time of build, the raw
file will be downloaded from the bank. For each of the entry in the raw
file, the python script will lookup in the DB using the BLZ code and update
the valid_upto value to the last date of the current quarter. If there is
no entry in the DB file corresponding to it, then a new entry will be
created. In this way, only those entries will be updated which exist in the
recent raw file.
When querying the database for use in the program, only those entries will
be selected which are valid at the current date.

Will this work?

Thanks,
Prasun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kde-finance-apps/attachments/20200511/bfa6cb9f/attachment.htm>