Feature Request: Get transaction from SqlStorage

[GeeKanJi]

Short description of the problem:

Currently , it is not possible to get transaction directly from Storage with Ionic 2. The only way, is to make a request and get a transaction in return.

private storage = new Storage(SqlStorage, { name: 'myDatabase, location: 'default' });

this.storage.query("SELECT 'one request for transaction'")
            .then((response) => {
                response.tx.executeSql("CREATE TABLE IF NOT EXISTS USER (id integer primary key, name text");
                response.tx.executeSql("CREATE TABLE IF NOT EXISTS PROJECT (id integer primary key, name text");
            });

What behavior are you expecting?

Get transaction directly from SqlStorage

this.storage.transaction(function (transaction) {
    transaction.executeSql("CREATE TABLE IF NOT EXISTS USER (id integer primary key, name text");
    transaction.executeSql("CREATE TABLE IF NOT EXISTS PROJECT (id integer primary key, name text");
});

Ionic 2.x

[danbucholtz]

Hi @jeromeXoo,

I will discuss with team and see what we can do about this. I like the idea, too, and have been playing around with it on some side projects.

I'll keep you posted. Please sit tight. Might be a few weeks. I have a few ideas of some cool things we can do to dramatically improve the SQL experience.

Thanks,
Dan

[luchillo17]

Seriously this should been done a long time ago, here's another issue request about exposing the transaction api: #5245

[jfoscue]

is the ionic team going to address this issue? I'm really needing transactions especially for one-to-many relationships. Can anyone share some code that handles them?

Thanks!

[danbucholtz]

@jfoscue,

We are currently refactoring storage.

Thanks,
Dan

[jfoscue]

Thanks @danbucholtz! Is there a timeline to expect the changes?

[danbucholtz]

@jfoscue,

I would think before RC. No promises, though. So a few weeks most likely.

Thanks,
Dan

[luchillo17]

I hope so, i'm making a tutorial for the pluralsight's hack.guides() contest about database versioning ionic 2 apps but it looks just wrong to access the transaction from the private variable when i'm not supposed to.

[danbucholtz]

Yeah, I hear you on that one @Luchillo. Thanks again for contributing.

Thanks,
Dan