grncdr/node-any-db-sqlite3 — pull request #1 by velichkov (2014-06-11 20:35:33+00:00)
Title: Get the number of affected rows

Use run method to execute UPDATE and DELETE queries
and set result.affectedRows and result.changedRows properties

https://github.com/mapbox/node-sqlite3/wiki/API#databaserunsql-param--callback
> If execution was successful, the this object will contain two properties
> named lastID and changes which contain the value of the last inserted
> row ID and the number of rows affected by this query respectively. Note
> that lastID only contains valid information when the query was a
> successfully completed INSERT statement and changes only contains valid
> information when the query was a successfully completed UPDATE or DELETE
> statement. In all other cases, the content of these properties is
> inaccurate and should not be used. The .run() function is the only query
> method that sets these two values; all other query methods such as
> .all() or .get() don't retrieve these values.