2021-07-05 23:54:34 UTC
This topic has come up a few times.
Now I have written something about it.
A conversion done by Python code running in JVM via Jython
using mapped Java classes:
IS record--(map)--Java class--(automap)--Java class--(map)--DB tables
Also showing some before code in:
and some after code in:
* Java (JDBC)
* Java (JPA)
I am pretty sure that it will be an interesting read for anyone
considering migrating data from index-sequential files to
SQLite (or other relational database).
You may not necessarily like the approach used, but even
if you decide against using the tripple mapping approach
then it may still be interesting as part of the due diligence.
And all the insert and list examples are valid no matter
how the conversion is done.
Enough talk - link:
Lot of code. Almost no comments. And the code may not always be
good for the languages that I do not know well (like Cobol).