public void test_total_changes() { using (sqlite3 db = ugly.open(":memory:")) { Assert.AreEqual(db.total_changes(), 0); Assert.AreEqual(db.changes(), 0); db.exec("CREATE TABLE foo (x int);"); Assert.AreEqual(db.total_changes(), 0); Assert.AreEqual(db.changes(), 0); db.exec("INSERT INTO foo (x) VALUES (1);"); Assert.AreEqual(db.total_changes(), 1); Assert.AreEqual(db.changes(), 1); db.exec("INSERT INTO foo (x) VALUES (2);"); db.exec("INSERT INTO foo (x) VALUES (3);"); Assert.AreEqual(db.total_changes(), 3); Assert.AreEqual(db.changes(), 1); db.exec("UPDATE foo SET x=5;"); Assert.AreEqual(db.total_changes(), 6); Assert.AreEqual(db.changes(), 3); } }