Get the actual array of rows from SQL query with sqlite and Expo

Question

I am trying to get the whole result as array of rows from sqlite query results object:

I have tried results.rows.item(i).id and it work just fine but I need to get the whole array of rows instead of only one item, i tried to use rows.array (_number) from Expo documentation but I can't figure out how actually to use .array(_number)

my code snippet:

iris.transaction(tx => {
    tx.executeSql(
        `select id, date from days`,
        [],
        (tx, results) => {
            for(i=0; i<results.rows.length; i++){
                var date = results.rows.item(i).date.split('-');
            }
        }
    )
});

Prasun · Accepted Answer · 2019-02-19 18:12:07Z

3

As per the Expo document, the result.rows has an _array which returns all the items as array, you can try like

if (result && result.rows && result.rows._array) {
  /* do something with the items */
  // result.rows._array holds all the results.
}

Hope this will help!

answered Feb 19, 2019 at 18:12

Prasun

5,0132 gold badges23 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Armando Vasquez Over a year ago

As an added note for TypeScript users, it seems that TypeScript really doesn't like SQLResultSetRowList - when I try to use rows._array, I get an array saying the property _array does not exist on type rows. So, if you run into this, just reassign the rows object to a new variable and cast it to type any - you'll lose the validation, but you won't have the annoying error anymore!

roshnet Over a year ago

@ArmandoVasquez thanks, it works. You should really consider writing this in an answer.

Collectives™ on Stack Overflow

Get the actual array of rows from SQL query with sqlite and Expo

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related