How to get the number of updated/deleted rows?

[paulocoutinhox]

Hi,

How i can get the number of affected rows for update/delete?

Example:

auto sql =
    "UPDATE todo SET "
    "title = :title, "
    "body = :body, "
    "data = :data, "
    "done = :done, "
    "updated_at = :updated_at "
    "WHERE id = :id";

auto application = std::static_pointer_cast<ApplicationCoreImpl>(ApplicationCore::shared());
auto db = application->getDB();

SQLite::Statement query(*db, sql);

query.bind(":id", id);
query.bind(":title", todo.title);
query.bind(":body", todo.body);
query.bind(":data", MapHelper::toJsonString(todo.data));
query.bind(":done", todo.done);
query.bind(":updated_at", DateTime::getStringFromDateTime(todo.updatedAt));
query.exec();

Thanks.

[paulocoutinhox]

There is any utility for this?

sqlite3_changes(db->getHandle())

If not, can you add a function like this ?

int getTotalChanges() const noexcept; // nothrow

[paulocoutinhox]

You can add this:

// Get total number of rows modified by all INSERT, UPDATE or DELETE statement.
int Database::getChanges() const noexcept
{
    return sqlite3_changes(getHandle());
}

[SRombauts]

Hello @paulo-coutinho,

Your query.exec() call does already return the number of changes made :)

 * @return number of row modified by this SQL statement (INSERT, UPDATE or DELETE)
 */
int Statement::exec()

[SRombauts]

Thanks for the suggestion,

I implemented it and added it in examples and unit tests, even if it wasn't really strictly needed; it shows people might look for it like you did.

Cheers!
Sébastien