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();
}
private void req_students(Pink.Request req, string format, int ean)
{
string stm = "SELECT Schueler.ID, Schueler.Vorname, Schueler.Name, SchuelerLernabschnittsdaten.Klasse, SchuelerLernabschnittsdaten.ASDJahrgang " +
"FROM EigeneSchule, Schueler INNER JOIN SchuelerLernabschnittsdaten ON Schueler.ID = SchuelerLernabschnittsdaten.Schueler_ID " +
"WHERE (((SchuelerLernabschnittsdaten.Jahr)=[EigeneSchule].[Schuljahr]) AND ((SchuelerLernabschnittsdaten.Abschnitt)=[EigeneSchule].[SchuljahrAbschnitt]));";
OleDbDataReader r = DB.Query(stm, 100);
string[] header = new string[] { "id", "student_givenname", "student_surname", "class", "grade" };
req.StatusCode = 200;
if (format == Pink.MIME.CSV)
{
req.ContentType = Pink.MIME.CSV;
Pink.CSV.Write(r, req.Output, SEP, header, ean);
}
else
{
req.ContentType = Pink.MIME.JSON;
Pink.JSON.Write(r, req.Output, header, ean);
}
r.Close();
return;
}
