public void rollback_transaction_after_exception() {
using (var db = new session().start_transaction()) {
db.execute("update users set email = '*****@*****.**' where id = 5");
throw new Exception("This exception should cause rollback");
db.commit();
}
var user = new session()
.one<user>("where id = 5");
assert(user.email == "*****@*****.**");
}
public void commit_transaction() {
using (var db = new session().start_transaction()) {
db.execute("update users set email = '*****@*****.**' where id = 4");
db.commit();
}
var user = new session()
.param("@id", 4)
.one<user>("where id=@id");
assert(user.email == "*****@*****.**");
}