[TestMethod] public void get_email() {
var db = new session();
var emails = db.all<string>("select email from users");
assert(emails.Count > 1);
var email = db.one<string>("select email from users where id = 2");
assert(email.Contains("@"));
}
[TestMethod] public void cache() {
var db = new session();
var count = db
.cache("count")
.one<int>("select count(email) from users");
db.execute("insert into users (email, password) values ('*****@*****.**', 'blood')");
var new_count = db
.cache("count")
.one<int>("select count(email) from users");
assert(count == new_count);
var diff = db.one<int>("select count(email) from users");
assert(diff > count);
}
