Menu

#20 bankdata databases does not contain a valid end date

1.58
open
nobody
1.57 (5)
2024-01-06
2024-01-06
No

The bank details downloaded from https://www.bundesbank.de/de/aufgaben/unbarer-zahlungsverkehr/serviceangebot/bankleitzahlen/download-bankleitzahlen-602592 are each valid for 3 months, from 4.12.y, 4.3.y+1, 4.6.y+1, 4.9.y+1 to 3.6.y, 3.9.y, 3.12.y, 3.3.y+1 (in German date format, y = year)

These date ranges are not added to the generated bankdata databases.

$ sqlite3 bankdata_de.db
sqlite>.schema institutions 
CREATE TABLE institutions ( country CHAR(2) DEFAULT 'DE' CONSTRAINT germanCountryCode NOT NULL CHECK(country == 'DE'), bankcode CHAR(8) NOT NULL PRIMARY KEY CHECK(length(bankcode) = 8), bic CHAR(11), method CHAR(2), name VARCHAR(60), location VARCHAR(40), valid_upto real );
CREATE INDEX bic_index ON institutions (bic);

which shows that there is a database column valid_upto.

sqlite> select count(*) from institutions where valid_upto is not null; 
0

but it is empty and should be filled with the associated end date.

Discussion

  • Ralf Habacker

    Ralf Habacker - 2024-01-06
    • labels: --> 1.57
    • Version: 1.50 --> 1.58
     
  • Ralf Habacker

    Ralf Habacker - 2024-01-06
    • Version: 1.58 --> unused
     
  • Ralf Habacker

    Ralf Habacker - 2024-01-06
    • Version: unused --> 1.58
     

Log in to post a comment.