Pre-Populated database

[Clay]

I know that there are workarounds, but it would be great if Icenium had a way to pre-populate a SQLite DB for distribution.

[Steve]

Hello Clay,

Thank you for the feedback! Currently there are a couple of approaches you could use to undertake this task described in the following posts:

• Creating a Database from a SQL Dump
• Building Pluggable and Mock Data Adapters for Web and PhoneGap Applications

As usual if we find a feasible way to ease developers with this task, we would investigate it and address it.

Regards,
Steve
Telerik

Don't miss the Icenium May Release Keynote - sign up now!
Share feedback and vote for features on our Feedback Portal.

[Clay]

I know about those options, but I have also seen ways that people working in XCode and Eclipse can copy a pre-populated db into the proper location. I would think you guys could do that in Icenium.

[Douglas]

Hello I'm trying to follow this site http://hansjar.blogspot.com.br/2013/04/how-to-easily-add-prepopulated-sqlite.html

For Android the DB file should be placed in the assets-folder, remember to use the file name *.db.
For example: TestDB.db

The iOS setup is very similar. Copy the db-file into the project, for example directly under the project root.

Someone knows how to copy the file to these location?

[Iva Koevska]

Hello Douglas,

From what I'm seeing, this blogpost recommends manually adding a custom plugin for both Android and iOS. If you want to follow this blogpost (which seems very outdated), you will have to complete a number of tasks.

1. Download the plugin version for iOS and Android. 
2. Update the plugin to target Apache Cordova 3.2 OR change the target version of your project to match the plugin. (From the dates when this has been modifies, it seems your best bet is Apache Cordova 2.4).
3. Update the plugin to make it Plugman compatible.
4. Add the plugin to your project.
5. Add the Android database file to assets folder nested inside the Plugins folder in your project by following this procedure.
6. Add the iOS database file to the root of your project by following this procedure.

However, we cannot verify that this will work. You still might need to make a number of tweaks to your project and code base to see what this blogpost describes in action.

Alternatively, you can enable the SQLite plugin in your project (Project Properties -> Plugins -> enable SQLIte) and follow the guidelines in the current thread or here, here, here, and here. You can also take a look at our sample app.

Regards,
Iva Koevska
Telerik