public static void DbTests()
{
var db = new Sqlite3("BookDB.sqlite3");
using (var r = db.ExecuteReaderOne("select count(*) from book"))
{
var v = r.GetValues();
foreach (var i in Enumerable.Range(0, r.FieldCount))
{
Console.WriteLine("{0}: {1}", v.GetKey(i), r.GetValue(i));
}
}
}
public static void DbTests()
{
var db = new Sqlite3("BookDB.sqlite3");
using (var r = db.ExecuteReaderOne("select count(*) from book"))
{
var v = r.GetValues();
foreach (var i in Enumerable.Range(0, r.FieldCount))
{
Console.WriteLine("{0}: {1}", v.GetKey(i), r.GetValue(i));
}
}
}
public Book GetBook(int bookId)
{
using (var r = DB.ExecuteReaderOne("select * from book where book.id=?", 1))
{
if (r == null)
{
return(null);
}
var book = new Book(r.GetString(1), r.GetDateTime(2), r.GetString(3))
{
Id = r.GetInt64(0)
};
book.Hrefs.AddRange(GetHrefs(book.Id));
book.Categorys.AddRange(GetCategorys(book.Id));
book.Tags.AddRange(GetTags(book.Id));
return(book);
}
}
