public void Test_Should_Exucute_Query()
{
var db = new TestDb();
Assert.NotNull(db);
int rows = db.Execute(@"INSERT INTO dictionary(title, description) VALUES('CMS',
'A content management system (CMS) is the collection of procedures used to manage work
flow in a collaborative environment. These procedures can be manual or computer-based.')");
Assert.Equal(1, rows);
}
public Facts()
{
TestDb db = new TestDb();
var tables = db.Query(@"SELECT name
FROM sqlite_master
WHERE type = 'table'");
if (tables.Count == 0)
{
db.Execute(@"CREATE TABLE dictionary(
id INTEGER PRIMARY KEY AUTOINCREMENT,
title VARCHAR(256),
description TEXT
)
;");
}
}
public void Test_Should_Execute_Parametrized_Query()
{
var db = new TestDb();
Assert.NotNull(db);
int rows = db.Execute(@"INSERT INTO dictionary(title, description) VALUES(@0,
@1)", "BBCode", @"Bulletin Board Code or BBCode is a
lightweight markup language used to format posts in many message boards.
The available tags are usually indicated by square brackets surrounding a keyword,
and they are parsed by the message board system before being translated into a markup
language that web browsers understand—usually HTML or XHTML.");
Assert.Equal(1, rows);
var res = db.Query("SELECT * FROM dictionary WHERE title = @0", "BBCode");
Assert.NotNull(res);
Assert.Equal(1, res.Count);
Assert.Equal("BBCode", res[0].title);
Assert.Same(typeof(System.Int64), res[0].id.GetType());
}
public void Test_Should_ScalarQuery_For_Count()
{
var db = new TestDb();
Assert.NotNull(db);
int rows = db.Execute(@"INSERT INTO dictionary(title, description) VALUES(@0,
@1)", "Textile", @"Textile is a lightweight markup language originally developed
by Dean Allen and billed as a ""humane Web text generator"".
Textile converts its marked-up text input to valid, well-formed XHTML and also
inserts character entity references for apostrophes, opening and closing
single and double quotation marks, ellipses and em dashes.");
var res = db.QueryScalar(@"SELECT COUNT(*) as RecordsCount
FROM dictionary");
Assert.NotNull(res);
Assert.NotEqual(0, res);
Assert.NotEqual(0, res);
}
public void Test_Should_Query_All_Records()
{
var db = new TestDb();
Assert.NotNull(db);
var res = db.Query("SELECT * FROM dictionary");
Assert.NotNull(res);
Assert.NotEqual(0, res.Count);
var count = db.Query(@"SELECT COUNT(*) as RecordsCount
FROM dictionary");
Assert.NotNull(count);
Assert.NotEqual(0, count.Count);
Assert.Equal(res.Count, count[0].RecordsCount);
}
