Pre populated database about sugar HOT 6 OPEN

You can make some code that in the first run you populate the Database. I think this is the usual with applications today.

from sugar.

@razagill Yeah.. you could do as @tsuharesu suggested. There's a method in SugarRecord named saveInTx(T... objects). This would be better in case of large number of records.

from sugar.

There are two ways of doing this.

1. Use a migration file. Increase the version of the database by one and create the necessary .sql file. In that file, you can write a SQL statement to insert a record into the appropriate table for every record you need to prepopulate the database with. Remember that each statement should exist on its own line and end in a semicolon.
2. The second is to use, as @satyan suggested, a saveInTx(T... objects) somewhere in your Java code. You can check for an appropriate number of objects with Model.count(Model.class, null, null), and execute the saveInTx if there aren't enough objects. This functionality is available currently in v1.3 beta.

from sugar.

For anyone else looking for this feature, it only works on database upgrade, not on creation.
#87

Just wasted an hour trying to get the sql to fire on database creation...

from sugar.

What is the current state of this issue? I have a bunch of sql inserts and I would like to execute them when the app starts. It looks like the db upgrade is not an option because if the user is using the app for the first time the migration mechanism won't be triggered, right? The second approach (using saveInTx(T... object)) requires Sugar Records objects as input parameters. Is there a simple way for converting my sql statements in to Sugar Records or just execute the insert directly?

from sugar.

References #241.

from sugar.