private static string Fortunes(HttpListenerRequest request, HttpListenerResponse response)
{
List <Fortune> fortunes;
using (var conn = SqliteContext.GetConnection())
{
conn.Open();
fortunes = conn.Query <Fortune>(@"SELECT * FROM Fortune").ToList();
}
fortunes.Add(new Fortune {
ID = 0, Message = "Additional fortune added at request time."
});
fortunes.Sort();
response.ContentType = "text/html";
const string header = "<!DOCTYPE html><html><head><title>Fortunes</title></head><body><table><tr><th>id</th><th>message</th></tr>";
const string footer = "</table></body></html>";
var body = string.Join("", fortunes.Select(x => "<tr><td>" + x.ID + "</td><td>" + x.Message + "</td></tr>"));
return(header + body + footer);
}
private static string Db(HttpListenerRequest request, HttpListenerResponse response)
{
var rnd = new Random();
var id = rnd.Next(10000);
using (var conn = SqliteContext.GetConnection())
{
conn.Open();
var result = conn.Query <RandomNumber>(@"SELECT * FROM World WHERE id=@id", new { id = id }).FirstOrDefault();
return(JSON.Serialize <RandomNumber>(result));
}
}
private static void initDb()
{
var rnd = new Random();
using (var conn = SqliteContext.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
for (var i = 0; i < 10000; i++)
{
conn.Execute(@"INSERT INTO World (randomNumber) VALUES (@randomNumber)", new { randomNumber = rnd.Next(Int16.MaxValue) }, transaction: trans);
}
trans.Commit();
}
}
}
private static string Queries(HttpListenerRequest request, HttpListenerResponse response)
{
var count = GetQueries(request);
var results = new List <RandomNumber>();
var rnd = new Random();
using (var conn = SqliteContext.GetConnection())
{
conn.Open();
for (var i = 0; i < count; i++)
{
var id = rnd.Next(10000) + 1;
var n = conn.Query <RandomNumber>(@"SELECT * FROM World WHERE id=@id", new { id = id }).FirstOrDefault();
results.Add(n);
}
}
return(JSON.Serialize <List <RandomNumber> >(results));
}
