SqlLite Ionic 2

import {Storage, SqlStorage} from 'ionic-angular';
storage: Storage = new Storage(SqlStorage);

// ....


    checkDB() {
        this.storage.query('CREATE TABLE IF NOT EXISTS user (id TEXT PRIMARY KEY NOT NULL, firstname TEXT, lastname TEXT, token TEXT)').then((data) => {
            console.log("TABLE CREATED -> " + JSON.stringify(data.res));
        }, (error) => {
            console.log("ERROR -> " + JSON.stringify(error.err));
        });
    }

    add() {
        this.storage.query("INSERT INTO user (id, firstname, lastname) VALUES ('123325654654', 'Nic', 'Raboy')").then((data) => {
            console.log(JSON.stringify(data.res));
        }, (error) => {
            console.log("ERROR -> " + JSON.stringify(error.err));
        });
    }

    refresh() {
        this.storage.query("SELECT * FROM user").then((data) => {
            let people = [];
            if (data.res.rows.length > 0) {
                for (var i = 0; i < data.res.rows.length; i++) {
                    people.push({
                        firstname: data.res.rows.item(i).firstname,
                        lastname: data.res.rows.item(i).lastname
                    });
                }
            }
        }, (error) => {
            console.log("ERROR -> " + JSON.stringify(error.err));
        });
    }