public static void Test()
{
// Connect
string provider = DB.GetProvider("ACE");
if (provider == null)
{
Console.WriteLine("Error: No ACE Provider");
return;
}
OleDbConnection db = DB.Connect(provider, @".\priv\db\example.accdb");
db.Open();
DBServer srv = new DBServer(db);
srv.Start();
//srv.Execute("Dies ist ein Test",10);
OleDbDataReader r = srv.Query("SELECT Title, Author, Date FROM Pages;", 10);
System.IO.StreamWriter file = new System.IO.StreamWriter(Console.OpenStandardOutput());
CSV.Write(r, file, ";", null, -1);
r.Close();
file.Close();
srv.Stop();
}
//string URL = "http://*****:*****@".\priv\db\example.accdb"));
DB.Start();
// setup static handler
Pink.StaticFileHandler staticHandler = new Pink.StaticFileHandler(@".\priv\static");
routes.Add("http://*****:*****@".\priv\tmpl\article.html"));
routes.Add("http://*****:*****@".\priv\tmpl\editor.html"));
routes.Add("http://*****:*****@".\priv\tmpl\index.html"));
}
public void Init()
{
Console.WriteLine("Read Config ...");
Config cfg = Config.Read(@".cfg");
// helper to check config
foreach (KeyValuePair <string, string> kv in cfg)
{
Console.WriteLine(">>> " + kv.Key + " = " + kv.Value);
}
Console.WriteLine("Open DB ...");
// DB connection
string provider = Pink.DB.GetProvider("ACE");
if (provider == null)
{
Console.WriteLine("Error: No ACE Provider"); return;
}
db = Pink.DB.Connect(provider, cfg["Database"]);
DB = new Pink.DBServer(db);
DB.Start();
Console.WriteLine("Start Webserver ... ");
staticHandler = new Pink.StaticFileHandler(cfg["StaticFiles"]);
//routes.Add(cfg["Server"]+"index.html", staticHandler);
routes.Add(cfg["Server"] + "img/", staticHandler);
routes.Add(cfg["Server"] + "css/", staticHandler);
routes.Add(cfg["Server"] + "js/", staticHandler);
routes.Add(cfg["Server"] + "favicon.ico", staticHandler);
routes.Add(cfg["Server"] + "schild/", this);
routes.Add(cfg["Server"] + "index.html", tmpl.fromFile("INDEX", cfg["IndexFile"]));
srv = new Pink.Server(cfg["Server"], routes);
srv.Start();
}
