any-db-sqlite3: Delete query don't returns the affected rows

[juanluispaz]

When a delete query is executed using any-db-sqlite3, the number of affected rows (rowCount) is always 0 even when some rows was deleted in sqlite

[grncdr]

I think this is because the adapter is using eachQuery instead of runQuery for delete queries. Appending RETURNING 1 to your query might be viable workaround.

[juanluispaz]

Reading the code I found:

In the file packages/any-db-sqlite3/index.js line 75:

  if (query.text.match(/^\s*(insert|update|replace)\s+/i)) {
    runQuery(this._db, query)
  } else {
    eachQuery(this._db, query)
  }

The thing is delete is missing in the regex in order to call the correct implementation.

runQuery includes in the result the number of affected rows, but eachQuery not.

Note: Sqlite doesn't support returning