So how could I uses this to circumvent the Invalid Schema expected …. found ….? The following, albeit long winded shows an example that corrects a schema accordingly. Could I use this to introduce Triggers, as room doesn’t have annotations for the creation of triggers? Yes, although this hasn’t actually been tested but the example … Read more
Updated You can do this in 3 ways: important check this for migration details 1- Populate your database from exported asset schema Room.databaseBuilder(appContext, AppDatabase.class, “Sample.db”) .createFromAsset(“database/myapp.db”) .build(); 2- Populate your database from file Room.databaseBuilder(appContext, AppDatabase.class, “Sample.db”) .createFromFile(new File(“mypath”)) .build(); 3- You can run scripts after database is created or run every time database is opened … Read more
This is how I solved it, and how you can ship your application with a pre-populated database (up to Room v. alpha5) put your SQLite DB database_name.db into the assets/databases folder take the files from this repo and put them in a package called i.e. sqlAsset in your AppDatabase class, modify your Room’s DB creation … Read more