sqlite SELECT query returns error

Expo SDK
1

SDK Version: 37
Platforms(Android/iOS/web/all): Android

const executeSql = async (sql, params = []) => {
  const db = SQLite.openDatabase('test.db');
  return new Promise((resolve, reject) =>
    db.transaction(tx => {
      tx.executeSql(
        sql,
        params,
        (_, { rows }) => resolve(rows._array),
        (_, error) => reject(error)
      );
    })
  );
};

function get() {
const createBookDBSQLString = `PRAGMA encoding = "UTF-8";
CREATE TABLE IF NOT EXISTS
    book (id       TEXT PRIMARY KEY, --A hash of author and title
          author   TEXT not NULL,
          title    TEXT NOT NULL,
          synopsis TEXT); `;
const selectQuery = 'SELECT * FROM book'
try {
      const status = await executeSql(createBookDBSQLString);
      console.log(`[info] created ${status}`);
      const result = await executeSql(selectQuery);
      console.log(`[info] select result ${result}`);
    } catch (e) {
      console.log(`[error] ${JSON.stringify(e)}`);
    }
}

Here is the output I’m getting:

[info] created 
[error] {"line":123882,"column":25,"sourceURL":"http://192.168.8.13:19001/node_modules/expo/AppEntry.bundle?platform=android&dev=true&hot=false&minify=false"}
2

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