Currently I am working on developing mobile app using Phonegap. Phonegap comes up with very nice javascript methods to access phone specific api and the developer like me who have fair knowledge of javascript HTML and CSS can learn it very quickly.<\/p>\n
My app required bundling the database into the app but there is no straight forward way in Phonegap to do this but I found a way to do this.
\nI added “app.sql” file in my “www” folder and get the text of this file. My app.sql looks something like this<\/p>\n
[java]
\nCREATE TABLE ‘category’ (categoryId long NOT NULL, name varchar(255) NOT NULL);\\n
\nINSERT INTO ‘category’ VALUES(1,’cat_1′);\\n
\nINSERT INTO ‘category’ VALUES(2,’cat_2′);\\n
\nINSERT INTO ‘category’ VALUES(3,’cat_3′);\\n
\nINSERT INTO ‘category’ VALUES(4,’cat_4′);\\n
\n[\/java]<\/p>\n
I am using jquery in my example<\/p>\n
[java]
\nfunction runInitialSetup() {
\n var filePath = "app.sql";
\n $.get(filePath, function (response) {
\n var statements = response.split(‘\\n’);<\/p>\n
var shortName = "database";
\n var version = ‘1.0’;
\n var displayName = ‘App Database’;
\n var maxSize = 200000; \/\/ bytes
\n db = openDatabase(shortName, version, displayName, maxSize);<\/p>\n
db.transaction(function (transaction) {
\n jQuery.each(statements, function (index, value) {
\n if (value != ”) {
\n transaction.executeSql(value, [], successHandler, function (e) {
\n console.log("Error executing sql " + value)
\n });
\n }
\n });
\n });
\n });
\n}
\n[\/java]<\/p>\n
I executed above method whenever the app is installed first time.<\/p>\n
<\/p>\n
Lets see whats happening in the above example. I read my app.sql file which was bundled in the app and the response I got is the text, so I split the content on newline character. There is the assumption that each sql statement is separated with newline character and the content in sql do not have the newline character.<\/p>\n
<\/p>\n
Then I made the database connection and executed each statement to setup the database.<\/p>\n
<\/p>\n
You can read any text file bundled in your app build. You can always read the content from your bundled app but never think of writing files because its not possible.<\/p>\n
<\/p>\n
Hope it helps<\/p>\n
Uday Pratap Singh<\/a> Currently I am working on developing mobile app using Phonegap. Phonegap comes up with very nice javascript methods to access phone specific api and the developer like me who have fair knowledge of javascript HTML and CSS can learn it very quickly. My app required bundling the database into the app but there is no […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":7,"footnotes":""},"categories":[1],"tags":[922,924,925,921,923],"class_list":["post-6953","post","type-post","status-publish","format-standard","hentry","category-technology","tag-bundle-database-in-phonegap","tag-database-connection-in-phonegap","tag-executing-sql-in-phonegap","tag-phonegap","tag-reading-bundled-file-in-phonegap"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\nuday@intelligrape.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"