<?php

/*
		DROP TABLE IF EXISTS test;

		CREATE TABLE IF NOT EXISTS `test` (
		  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
		  `name` varchar(100) COLLATE utf8_czech_ci NOT NULL,
		  `ditime` timestamp NULL DEFAULT NULL,
		  `dutime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
		  PRIMARY KEY (`id`)
		) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

		DROP TRIGGER IF EXISTS test_insert;

		DELIMITER //
		CREATE TRIGGER test_insert BEFORE INSERT ON test
			 FOR EACH ROW BEGIN
			   IF NEW.ditime IS NULL THEN
			    SET NEW.ditime = NOW();
			   END IF;
			END//
		DELIMITER ;


*/

use Nette\Debug;
use Nette\Environment;
use Nette\Application\Route;
use Nette\Application\SimpleRouter;


// absolute filesystem path to the libraries
define('LIBS_DIR', realpath(dirname(__FILE__) . '/../libs'));
define('APP_DIR', realpath(dirname(__FILE__) . '/../app'));
define('CONFIG_DIR', APP_DIR . '/config');


require_once LIBS_DIR . '/Nette/0.9.5/loader.php';
require_once LIBS_DIR . '/dibi/1.1/dibi.php';

Environment::setName('unittests');

Environment::loadConfig(dirname(__FILE__) . '/../app/config.ini');

$loader = new \Nette\Loaders\RobotLoader();
$loader->addDirectory(APP_DIR);
$loader->addDirectory(LIBS_DIR);
$loader->register();


// dibi connection
dibi::connect(Environment::getConfig('database'));

$sql = dibi::getConnection();
$sql->query('TRUNCATE test');

$data = array();

$name = "X1_insert";
$_data = array(
	'name' => $name,
);
$sql->insert('test', $_data)->execute();
$data[$name] = (array) $sql->select('*')->from('test')->fetchAll();


// ziskame odlisny time
sleep(2);
$name = "X2_update";
$_data = array(
	'name' => $name,
);
$sql->update('test', $_data)->where('id = %i', 1)->execute();
$data[$name] = (array) $sql->select('*')->from('test')->fetchAll();


// ziskame odlisny time
sleep(2);
$name = "X3_update_di";
$_data = array(
	'name' => $name,
	'ditime' => date('2010-01-01 12:00')
);
$sql->update('test', $_data)->where('id = %i', 1)->execute();
$data[$name] = (array) $sql->select('*')->from('test')->fetchAll();


// ziskame odlisny time
sleep(2);
$name = "X4_update_didu";
$_data = array(
	'name' => $name,
	'ditime' => date('2010-01-01 13:00'),
	'dutime' => date('2010-01-01 14:00')
);
$sql->update('test', $_data)->where('id = %i', 1)->execute();
$data[$name] = (array) $sql->select('*')->from('test')->fetchAll();


// ziskame odlisny time
sleep(2);
$name = "X5_insert_alldates";
$_data = array(
	'name' => $name,
	'ditime' => date('2010-01-01 19:00'),
	'dutime' => date('2010-01-01 20:00')
);
$sql->insert('test', $_data)->execute();
$data[$name] = (array) $sql->select('*')->from('test')->fetchAll();


dump($data);