Ionic and SQLite start help


#1

Hello,

today i tried to use sqlite with ionic but i failed.
I added the plugin:

<plugin name="cordova-sqlite-storage" spec="https://github.com/litehelpers/Cordova-sqlite-storage.git" />

And created a factory to open a database and create the tables:

angular.module("App")

.factory("DatabaseFactory", function ($cordovaSQLite) {
    var database = null;

    var factory = {};

    factory.getDatabase = function () {
        if (database == null) {
            database = $cordovaSQLite.openDB({
                name: "myDB.db"
            });

            database.transaction(function(tx) {
                tx.executeSql(create_user, [], function(tx, res) {
                    console.log("user: " + res.rows.item(0).uppertext); 
                }, function(error) {
                    console.log("error: " + error.message);
                });
                tx.executeSql(create_step, [], function(tx, res) {
                    console.log("step: " + res.rows.item(0).uppertext); 
                }, function(error) {
                    console.log("error: " + error.message);
                });
                tx.executeSql(create_goal, [], function(tx, res) {
                    console.log("goal: " + res.rows.item(0).uppertext); 
                }, function(error) {
                    console.log("error: " + error.message);
                });
            }, function(error) {
                console.log("transaction error: " + error.message);
            }, function() {
                console.log("transaction ok");
            });
        }

        return database;
    }

    return factory;
});

Unfortunately this does not seem to work because when i run my app and init my database the output is the following:

OPEN database: myDB.db
new transaction is waiting for open operation
DB opened: myDB.db

I cant figure out what the probem is. Maybe someone has ideas.


#2

See my best example to work with SQLite using ngCordova :smile:

Regards, Nicholls


#3

Hello,

thx for your reply.
I get the exact same result which i discribed in my opening post.


#4

See my starter template with SQLite: https://github.com/jdnichollsc/Ionic-Starter-Template

Regards, Nicholls