danielfbm
commented
10 years ago Hi, I just created an app to test this Cordova SQL plugin and the persistence.js "bridge". It works great for me on the mobile. Just a question, did you add plugin using the "cordova plugin add" command? Also, I didn't add this file:
js/libs/SQLitePlugin.js to the index.html file
I am using Cordova 3.4, I just created a basic HelloWorld app using $ cordova create test-app Then I added the plugin with: $ cordova plugin add https://github.com/brodysoft/Cordova-SQLitePlugin Here is my index.html file:
<div class="app">
<h1>Apache Cordova</h1>
<div id="deviceready" class="blink">
<p class="event listening">Connecting to Device</p>
<p class="event received">Device is Ready</p>
</div>
<div id="console">
</div>
</div>
<script type="text/javascript" src="cordova.js"></script>
<script type="text/javascript" src="js/index.js"></script>
<script type="text/javascript" src="js/persistence.js"></script>
<script type="text/javascript" src="js/persistence.store.sql.js"></script>
<script type="text/javascript" src="js/persistence.store.websql.js"></script>
<script type="text/javascript" src="js/persistence.store.cordovasql.js"></script>
<script type="text/javascript">
app.initialize();
</script>and here is my index.js file: var app = { // Application Constructor initialize: function() { this.bindEvents(); }, // Bind Event Listeners // // Bind any events that are required on startup. Common events are: // 'load', 'deviceready', 'offline', and 'online'. bindEvents: function() { document.addEventListener('deviceready', this.onDeviceReady, false); }, // deviceready Event Handler // // The scope of 'this' is the event. In order to call the 'receivedEvent' // function, we must explicity call 'app.receivedEvent(...);' onDeviceReady: function() { app.receivedEvent('deviceready');
app.setupDatabase();
app.log("database fully setup");
app.insertDummyData();
app.log("dummy data sucessfully inserted");
app.selectDummyData();
app.log("dummy data check complete");
},
setupDatabase: function(){
app.Article = persistence.define('Article', {
article_id: 'INT',
author: 'TEXT',
category: 'TEXT',
total_count: 'INT'
});
// Paragraph DB Model
app.Paragraph = persistence.define('Paragraph', {
paragraph_id: 'INT',
article_id: 'INT',
number: 'INT',
text: 'TEXT'
});
//Defining Database for articles (limit of 50 mb for app, 5 for web app);
persistence.store.cordovasql.config(persistence, 'testdatabase', '0.0.3', 'Main database to store local information', 50 * 1024 * 1024, 1);
//Removing verbose operations
persistence.debug = false;
//Defining relationships
app.Article.hasMany('paragraphs', app.Paragraph, 'article');
//Defining index and constraints
app.Article.index(['article_id'], {unique: true});
app.Paragraph.index(['article_id', 'number'], {unique: true});
//Apply definitions to the DB
persistence.schemaSync();
},
Article: null,
Paragraph: null,
numberOfArticles: 1000,
numberOfParagraphs: 10,
insertDummyData: function(){
try{
persistence.transaction(function (transaction) {
app.log("insertDummyData: Checking the number of Articles inserted...");
app.Article.all().list(transaction, function(data){
app.log("insertDummyData: Total number of Articles: "+data.length);
if (!data.length){
app.log("insertDummyData: No Articles in the database. Inserting "+app.numberOfArticles+" records and Paragraphs");
for (var i = 1, article, p = 1; i <= app.numberOfArticles; i++) {
article = new app.Article({article_id: i, author: "Author "+i, category: "category"+i, total_count: i});
//app.log("article var: "+article);
persistence.add(article);
for (var k = 1; k <= app.numberOfParagraphs; k++) {
persistence.add(new app.Paragraph({paragraph_id: p, article_id: i, number: k, text: "text "+i+" "+k, article: article}));
p++;
}
persistence.flush(transaction);
}
}
});
});
}
catch (exc) {
app.log("insertDummyData: Error: "+exc);
}
},
selectDummyData: function () {
persistence.transaction(function (transaction) {
app.log("selectDummyData: Checking the number of Articles inserted...");
app.Article.all().list(transaction, function(data){
app.log("selectDummyData: Total number of Articles: "+data.length);
if (data.length === app.numberOfArticles) {
app.log("selectDummyData: Total number of Articles is as expected: "+app.numberOfArticles);
}
});
app.log("selectDummyData: Checking the number of Paragraphs inserted...");
app.Paragraph.all().list(transaction, function(data) {
app.log("selectDummyData: Total number of Paragraphs: "+data.length);
if (data.length === app.numberOfArticles * app.numberOfParagraphs ) {
app.log("selectDummyData: Total number of Paragraphs is as expected: "+app.numberOfArticles * app.numberOfParagraphs);
}
});
});
},
log: function (string) {
var pElement = document.createElement("p");
pElement.appendChild(document.createTextNode(string));
document.getElementById("console").appendChild(pElement);
console.log(string);
},
// Update DOM on a Received Event
receivedEvent: function(id) {
var parentElement = document.getElementById(id);
var listeningElement = parentElement.querySelector('.listening');
var receivedElement = parentElement.querySelector('.received');
listeningElement.setAttribute('style', 'display:none;');
receivedElement.setAttribute('style', 'display:block;');
console.log('Received Event: ' + id);
}};
Hope it helps.
indrajit3010
Hi, I have used Peristance.js many times in my previous projects and it is doing great. Now, I am working on Phonegap (Cordova) Android app. So wish to take advantage of persistance JS capability, but some how its not working with SQLitePlugin (no errors).
But it never reached to "Database created".
_In the log I see following:_
04-01 18:03:52.932: I/Web Console(10500): [Tue Apr 01 2014 18:03:52 GMT+0530 (IST)]:[App] - Mobile initialized at file:///android_asset/www/js/Context.js:73 04-01 18:03:52.962: I/Web Console(10500): deviceready has not fired after 5 seconds. at file:///android_asset/www/cordova.js:6958 04-01 18:03:52.962: I/Web Console(10500): Channel not fired: onPluginsReady at file:///android_asset/www/cordova.js:6951 04-01 18:03:52.972: I/Web Console(10500): Channel not fired: onCordovaReady at file:///android_asset/www/cordova.js:6951 04-01 18:03:52.983: I/Web Console(10500): Channel not fired: onCordovaConnectionReady at file:///android_asset/www/cordova.js:6951 04-01 18:03:52.983: I/Web Console(10500): Channel not fired: onDOMContentLoaded at file:///android_asset/www/cordova.js:6951 04-01 18:03:54.432: I/Web Console(10500): [Tue Apr 01 2014 18:03:54 GMT+0530 (IST)]:[App] - Document is ready at file:///android_asset/www/js/Context.js:73 04-01 18:03:54.782: I/Web Console(10500): [Tue Apr 01 2014 18:03:54 GMT+0530 (IST)]:[App] - Device is ready at file:///android_asset/www/js/Context.js:73 04-01 18:03:55.222: I/Web Console(10500): SQLitePlugin openargs: {"name":"corporate","bgType":1} at file:///android_asset/www/js/plugins/SQLitePlugin.js:8 04-01 18:03:55.273: I/Web Console(10500): CREATE TABLE IF NOT EXISTS 'profiles' ('firstName' TEXT, 'lastName' TEXT, 'mobile' TEXT, 'email' TEXT, 'deviceId' TEXT, 'profileCreateDate' INT, 'VAR1' TEXT, 'VAR2' TEXT, 'VAR3' TEXT, 'id' VARCHAR(32) PRIMARY KEY) at file:///android_asset/www/js/libs/persistence.store.cordovasql.js:145I have included required js for the same (source code as below).
I don't know where my mistake is. Please guide.
Thank You, Indrajit