root/trunk/examples/database/PackageTest.d

/*******************************************************************************

    License:    Boost Software License, v. 1.0
                Academic Free License, v. 3.0
                BSD License

    Authors:    Marcin Kuszczak, www.zapytajmnie.com (author's christian site)

    Version:    0.9.1
    Date:       30-Apr-2008

    History:    0.9.1 (30-Apr-2008) -   initial public version

 ******************************************************************************/

import std.stdio;

import dbi.sqlite.SqliteDatabase;

import doost.database.Sql;
import doost.database.Recordset;
import doost.database.Expression;
import doost.database.visitors.SqliteDb;

import examples.database.TestSchema;


//------------------------------------------------------------------------------

void printCols(COLS...)(Recordset r, COLS cols) {
    string rest;
    for(uint i=0; i<r.length; i++) {
        writef(i);
        writef(": ");

        rest = "";
        foreach(c; cols) {
            writef(rest);
            writef(r.column(c).row(i));
            rest = " - ";
        }
        writefln;
    }
}

void main(char[][] args) {
    auto db = new SqliteDb("database.sqlite");

    Sql sql;
    Recordset r;

    sql  = Create(AUTHORS).IfNotExists;
    sql ~= Create(BOOKS).IfNotExists;
    db.execute(sql);

    sql  = Insert(AUTHORS.ID, 1)(AUTHORS.FIRSTNAME, "Alfred")(AUTHORS.SURNAME,  "Szklarski");
    sql ~= Insert(AUTHORS.ID, 2)(AUTHORS.FIRSTNAME, "Zbigniew")(AUTHORS.SURNAME,  "Nienacki");
    sql ~= Insert(AUTHORS.ID, 3)(AUTHORS.FIRSTNAME, "Edmund")(AUTHORS.SURNAME,  "Niziurski");
    sql ~= Insert(AUTHORS.ID, 4)(AUTHORS.FIRSTNAME, "Aleksander")(AUTHORS.SURNAME,  "Fredro");
    db.execute(sql);

    sql  = Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek w krainie kangurów");
    sql ~= Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek wśród łowców głów");
    sql ~= Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek u źródeł Amazonki");
    sql ~= Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek na Czarnym LÄ
dzie");
    sql ~= Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek na tropach Yeti");
    sql ~= Insert(BOOKS.AUTHOR_ID, 1)(BOOKS.TITLE, "Tomek na wojennej ścieÅŒce");
    db.execute(sql);

    sql  = Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Pan Samochodzik i Fantomas");
    sql ~= Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Pan Samochodzik i tajemnica tajemnic");
    sql ~= Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Pan Samochodzik i Niewidzialni");
    sql ~= Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Pan Samochodzik i złota rękawica");
    sql ~= Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Pan Samochodzik i templariusze");
    sql ~= Insert(BOOKS.AUTHOR_ID, 2)(BOOKS.TITLE, "Wyspa Złoczyńców");
    db.execute(sql);

    sql  = Insert(BOOKS.AUTHOR_ID, 3)(BOOKS.TITLE, "Sposób na Alcybiadesa");
    sql ~= Insert(BOOKS.AUTHOR_ID, 3)(BOOKS.TITLE, "Klub włóczykijów");
    sql ~= Insert(BOOKS.AUTHOR_ID, 3)(BOOKS.TITLE, "Siódme wtajemniczenie");
    sql ~= Insert(BOOKS.AUTHOR_ID, 3)(BOOKS.TITLE, "Awantura w Niekłaju");
    db.execute(sql);

    sql  = Insert(BOOKS.AUTHOR_ID, 4)(BOOKS.TITLE, "Zemsta");
    db.execute(sql);

    sql = Select(AUTHORS.FIRSTNAME, AUTHORS.SURNAME, BOOKS.TITLE).Where(Equals(AUTHORS.ID, BOOKS.AUTHOR_ID));
    r = db.query(sql);
    printCols(r, AUTHORS.FIRSTNAME, AUTHORS.SURNAME, BOOKS.TITLE);
}