Expo DB database

Expo SDK
1

Please provide the following:

  1. SDK Version: “expo”: “^33.0.0”, “expo-sqlite”: “~5.0.1”,
  2. Platforms: IOS

I just recently upgraded my expo to use expo-sqlite and the sdk. The simulator kept giving me the warning to do so. Since then now I get an error when accessing db:
Here is the error:

WebSQLTransaction {
  "_complete": false,
  "_error": null,
  "_running": true,
  "_runningTimeout": false,
  "_sqlQueue": Queue {
    "first": undefined,
    "last": undefined,
    "length": 0,
  },
  "_websqlDatabase": WebSQLDatabase {
    "_currentTask": TransactionTask {
      "errorCallback": [Function anonymous],
      "readOnly": false,
      "successCallback": [Function anonymous],
      "txnCallback": [Function anonymous],
    },
    "_db": SQLiteDatabase {
      "_closed": false,
      "_name": "db.db",
    },
    "_running": true,
    "_txnQueue": Queue {
      "first": Object {
        "item": TransactionTask {
          "errorCallback": [Function anonymous],
          "readOnly": false,
          "successCallback": [Function anonymous],
          "txnCallback": [Function anonymous],
        },
      },
      "last": Object {
        "item": TransactionTask {
          "errorCallback": [Function anonymous],
          "readOnly": false,
          "successCallback": [Function anonymous],
          "txnCallback": [Function anonymous],
        },
      },
      "length": 1,
    },
    "exec": [Function anonymous],
    "version": "1.0",
  },
}
- node_modules/expo/build/environment/muteWarnings.fx.js:27:24 in error
* src/screens/Category.js:81:27 in <unknown>
- node_modules/@expo/websql/lib/websql/WebSQLTransaction.js:64:39 in <unknown>
- node_modules/expo-sqlite/build/SQLite.js:17:21 in <unknown>

The code I’m using to get this is:

      'SELECT * FROM dr_template_relational'
      + 'INNER JOIN dr_report_subcategories ON dr_report_subcategories.id = dr_template_relational.subcategory_id'
      + ' WHERE dr_template_relational.template_id = (?)',
      [this.state.currentTemplateId], (trans) => success stuff here and below.

Any ideas what has changed?

1 Like
2

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