Ionic 2 storage doesn’t have query method

[aggarwalankush]

I'm updating my app to Ionic 2 rc0 and using import {Storage} from "@ionic/storage"; But it doesn't have query method. It was there in beta 11 to query SQLite. How to query SQLite in rc0?

[bergmito]

Try it

import { SQLite } from 'ionic-native';

let db = new SQLite();
db.openDatabase({
name: 'data.db',
location: 'default' // the location field is required
}).then(() => {
db.executeSql('create table danceMoves(name VARCHAR(32))', {}).then(() => {

}, (err) => {
console.error('Unable to execute sql: ', err);
});
}, (err) => {
console.error('Unable to open database: ', err);
});

[aggarwalankush]

@bergmito Storage uses SQLite behind the scenes so why not query method because it was available in beta 11. I don't see any reason to remove it in rc0.

[okonon]

@aggarwalankush clearly something has changed in beta 11 i used to do:

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

But after rc0 upgrade am getting following error:
/node_modules/ionic-angular/index"' has no exported member 'SqlStorage'.
@jgw96 did you guys get rid of SqlStorage ?

[aggarwalankush]

@okonon I also used to do same but now we have @ionic/storage which automatically uses Sqlite behind the scenes, I don't know where is query method? @mlynch implemented that in this commit, maybe he can answer 👍

[baffleinc]

+1 - was using Storage.query() heavily!

[stephanowallace]

I'm having the same problem. In my app I have a "service" with a lot of queries that access and change data in my database (sqlite). I use the query method and return promises (it isn't working anymore too), will I have to change all my code because of this change?

[rafaelss95]

Same here. I'm using the query method for everything.

[danbucholtz]

Hi everyone,

I have passed this info along to the team and will keep you posted on this.

Thanks,
Dan

[chmdznr]

Additional Error (ionic rc 0)
When using example code from:
http://ionicframework.com/docs/v2/native/sqlite/
Got these errors (already try it on browser, emulator, ios device.. all the same) :
ERROR: ReferenceError: sqlitePlugin is not defined at http://localhost:8100/build/main.js:78458:13 at new t (http://localhost:8100/build/polyfills.js:3:15614) at SQLite.openDatabase (http://localhost:8100/build/main.js:78457:16) at new PCounter (http://localhost:8100/build/main.js:79945:24) at DebugAppView._View_HomePage_Host0.createInternal (HomePage_Host.ngfactory.js:20:24) at DebugAppView.AppView.create (http://localhost:8100/build/main.js:10658:21) at DebugAppView.create (http://localhost:8100/build/main.js:10870:44) at ComponentFactory.create (http://localhost:8100/build/main.js:6276:36) at NavControllerBase._viewInit (http://localhost:8100/build/main.js:46701:44) at NavControllerBase._transition (http://localhost:8100/build/main.js:46686:18)

[richardshergold]

I got the same - looking forward to hearing what we need to do!

[danielabbatt]

Yes agreed, rightly or wrongly I was relying on Storage as an abstraction later to interact with a DB using .query - It would nicely abstract to websql or sqlite depending on whether I was working with "ionic serve" in the browser or against an actual device.