root/trunk/samples/test5.d

private import std.string;
private import std.stdio;

import sdbo.odbc;

void main()
{
    OdbcEnvironment env = new OdbcEnvironment;
    
    writefln("List of available Driver:");
    foreach(char[][2] driver; env.drivers())
        writefln("%s - %s", driver[0], driver[1]);
    
    writefln();
        
    version(Windows) {
        char[] constr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=test1.mdb";
    }
    else {
        char[] constr = "DRIVER=/usr/lib/libmyodbc3.so;HOST=localhost;USER=root";
    } 
    

    
    OdbcConnection c = env.connectDriver(constr);
    
    SqlResult result;
    
    char[] createtable = "create table TestCount ( counter_id int, counter_label varchar(50), counter_date date )";
    
    version(linux) {
        c.execDirect("create database if not exists _sdbo_teste");
        c.execDirect("use _sdbo_teste;");
    }
    

    try {
        result = c.execDirect(createtable);
    } catch(SqlException e) {
        
        if(e.sqlState == "42S01") {
            result = c.execDirect("drop table TestCount");
            result.execDirect(createtable);
        } else {
            
            writefln(e.toString());
            writefln("Can't recover. Giving up...");

            delete env;
            return;
        }
    }
    
    version(Windows) {
        result.execDirect("insert into TestCount values (10, 'counter id is 10', date())");
    } else {
        result.execDirect("insert into TestCount values (10, 'counter id is 10', now())");
    }
        
    result.execDirect("select * from TestCount order by counter_id");
    
    result.bindAll = false;
    result.setBinding(2, result.D_CHAR);
    
    result.fetch();
    
    writefln("display a bound column");
    writefln("string counter_date: %s", result.string(2)); 
    /* column 2 is bound */
    
    writefln("retrieving unbound columns with longData and stringData");
    
    writefln("long counter_id: %d", result.longData(0)); 
    /* column 0 is unbound */
    
    writefln("string counter_label: %s", result.stringData("counter_label")); 
    /* column counter_label is unbound */
    
    
    try {
        /* using getdata twice or out of order might cause a SqlException or return invalid data,
           depending on the driver */
           
        writefln("long counter_id: %d", result.longData(0)); 
    } catch(SqlException e) {
        e.print();
    }
    
    delete env;
    
}