#!/usr/bin/php

<?php

echo "\n\n\n\n";

require '../../sql/SQLDialect.class.php';
require '../../sql/SQL92Dialect.class.php';
require '../../db-adapter/DBAdapter.class.php';
require '../../db-adapter/PDOAdapter.class.php';
require '../TableGateway.class.php';

$sqliteFile = '../../../../var/sqlite/test.sqlite';
$pdo = new PDO('sqlite:' . $sqliteFile);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db = new PDOAdapter($pdo, new SQL92Dialect());

try { $db->execute("DROP TABLE employees"); } catch (Exception $e) { };

$db->execute("
	CREATE TABLE employees (
		id INTEGER PRIMARY KEY AUTOINCREMENT,
		name TEXT,
		email TEXT
	);
");

include '1.php';
include '2.php';
include '3.php';
include '4.php';

unlink($sqliteFile);

?>