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);
}
}
