pls help me i cant solve my problem on ionic 2 sqlite. on the first run of my app i have successfully created the table "players", and i can also insert and fetch on this table. but when i try to exit and re-open my app it prompts me "plugin_not_installed".
i am following the new documentation of ionic frame work . i observe on this documentation it doesn't have db.openDatabase() function which some tutorials always mention.
import { SQLite, SQLiteObject } from '@ionic-native/sqlite';
import { AlertController } from 'ionic-angular';
export class Players {
name:string; //ngmodel from html
players:new Array<Object>(); //used to list all players
constructor(private sqlite: SQLite,public alertCtrl: AlertController) {
this.initializeDatabase(); //create table if not exists
}
ionViewDidLoad(){
this.fetch();
}
initializeDatabase(){
this.sqlite.create({
name: 'data.db',
location: 'default'
})
.then((db: SQLiteObject) => {
db.executeSql('create table if not exists(playerId integer primary key,fullname varchar(50));', {})
.then(() => console.log('Executed SQL'))
.catch(e => this.showAlert( JSON.stringify(e)));
})
.catch(e => this.showAlert( JSON.stringify(e)));
}
fetch(){
let sql="select fullname from players";
this.sqlite.create({
name: 'data.db',
location: 'default'
}).then((db: SQLiteObject) => {
db.executeSql(sql, {})
.then((data) => {
this.players=[];
for(let index=0;index,data.rows.length;index++){
this.players.push({fullname:data.rows.item(index).fullname});
}
})
.catch(e => this.showAlert( JSON.stringify(e)));
})
.catch(e => this.showAlert( JSON.stringify(e)));
}
create(){
let name=this.name;
let sql="INSERT INTO players (playerId,fullname) values (?,?)";
this.sqlite.create({
name: 'data.db',
location: 'default'
}).then((db: SQLiteObject) => {
db.executeSql(sql, [null,name])
.then(() => console.log('successfully created'))
.catch(e => this.showAlert( JSON.stringify(e)));
})
.catch(e => this.showAlert( JSON.stringify(e)));
}
showAlert(msg:string) {
let alert = this.alertCtrl.create({
title: 'Info',
subTitle:msg,
buttons: ['OK']
});
alert.present();
}
}
