private import firebirdCommon;
private import firebird_database;
private import firebird_transaction;
private import firebird_statement;
private import firebird_date;
private import firebird_blob;
private import firebird_array;
private import firebird_dbkey;
private import firebird_row;
private import firebird_status;
private import firebird_resultbuffer;
private import std.string;
private import std.stdio;

double scaler(double sc) {return std.c.math.pow(10.0, sc);}
void main()
{
  Database db = new Database();
  double sctest = scaler(0); writeln(sctest); sctest = scaler(1); writeln(sctest); sctest = scaler(2); writeln(sctest); sctest = scaler(3); writeln(sctest); sctest = scaler(4); writeln(sctest); sctest = scaler(18); writeln(sctest);
  bool ret = false;
  ret = db.Connect("m:/testdatabase.fdb","sysdba", "masterkey");
  uint dbhandle = db.Dialect;
  int Insert, Update, Delete, ReadIdx, ReadSeq;
  db.Counts(Insert, Update, Delete, ReadIdx, ReadSeq);

  Transaction transaction = new Transaction(&db);
  transaction.Start;
  string sql = "select * from TEST";
  Statement statemnt = new Statement(db, transaction);
  statemnt.Execute(sql);


  //int reti = db.query_statement("select * from test");
	Row mOutRow;
  mOutRow = statemnt.GetOutRow();
	int cols = statemnt.Columns;
	mOutRow = statemnt.FetchRow();
	string tester; cols = mOutRow.Columns;
  ret = statemnt.Get(1,tester); writeln(tester,"----");
	long ltester;
	string testnum = "testnum";
  ret = statemnt.Get(2, ltester);writeln(ltester,"----<");
	int itester;
  ret = mOutRow.Get(3, itester); writeln(itester,"----<<");
	short stester;
  ret = mOutRow.Get(4, stester); writeln(stester,"----<<");
	double ntester;
  ret = mOutRow.Get(5, ntester); writeln(ntester,"----<<");
	Date dtester;
  mOutRow.Get(3, dtester);
  int year, month, day;
	dtester.GetDate(year, month, day);
	writeln(dtester.toString);
	Time ttester;
    mOutRow.Get(4,ttester);
	int hour, minute, second, tenthousandths;
	ttester.GetTime(hour, minute, second, tenthousandths);
	writeln(ttester.toString);
	Timestamp tstester;
    mOutRow.Get(5,tstester);
	tstester.Now(year, month, day, hour, minute, second, tenthousandths);
	writeln("y ",year, " m ",month, " d ",day," <||>  h ",hour, " m ",minute, " s ",second," ms ",tenthousandths);
    writeln(tstester.toString);

	for(int xxx = 0;xxx<10;xxx++) {
      sql = "INSERT INTO TEST VALUES ('testrichard"~ toString(xxx+1100) ~ "', "~ toString(xxx) ~", 'NOW','NOW','NOW')";
      statemnt.Execute(sql);
      transaction.CommitRetain;
    }
	transaction.CommitRetain;

	statemnt.Prepare("SELECT * FROM TEST WHERE this_column = ?");
  //statemnt.Set(1, "abc");
  //statemnt.Execute();

    transaction.Commit;

}