[Typescript/expo-sqlite] SQLite _array does not exist on type

Please provide the following:

  1. SDK Version: 41
  2. Platforms(Android/iOS/web/all): iOS, Android
  3. Add the appropriate “Tag” based on what Expo library you have a question on.

I am trying to create a SQLite db using expo-sqlite. When I try to fetch the items from the file using

db.transaction((tx) => {
      tx.executeSql(
        `SELECT * FROM decks`,
        undefined,
        (_, { rows: { _array } }) => setDeckList(_array),
        (_, err) => console.log('ERROR: ', err)
      );
    });

the _array type does not exist on the returned SQLResultSetRowList interface. After looking into the node_modules I have confirmed that it does not exist

export interface SQLResultSet {
  insertId: number;
  rowsAffected: number;
  rows: SQLResultSetRowList;
}

export interface SQLResultSetRowList {
  length: number;
  item(index: number): any;
}

Is there a different way that I can grab the array? Also, I was looking to open the file manually with a SQLite browser but I could not find the file. The docs mention it should be in ${FileSystem.documentDirectory}/SQLite/${name}, but there is nothing in the file. Is there a new location where the files are being stored?

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.