Use pre-filled SQlite DB intead of dump txt files #Room #BIG

[mmathieum]

Pre-filled DB w/ SQLiteOpenHelper is a mess. Upgrading to Room (DAO...) is BIG.

• [ ] generate db after parsing
• [ ] load generated DB
• [ ] ? migrate to Room ? #BIG

Links:

• https://developer.android.com/training/data-storage/room/sqlite-room-migration
• https://developer.android.com/training/data-storage/room/prepopulate
• https://medium.com/androiddevelopers/packing-the-room-pre-populate-your-database-with-this-one-method-333ae190e680
• https://github.com/simonschiller/prefiller
• https://github.com/jgilfelt/android-sqlite-asset-helper
• https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html