public function setUp()
{
$face = new DBFace("sqlite::memory:");
$face->query("create table user ( id INTEGER PRIMARY KEY, name TEXT )");
$face->query("insert into user (name) values('bob')");
$face->query("insert into user (name) values('harry')");
$this->mapper = new ToolMapper($face);
/*
$result = $x->query("select * from user");
while ( $row = $result->fetch() ) {
print_r( $row );
}
*/
}
$this->pdo = new PDO($dsn, $user, $pass);
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
function query($query)
{
try {
$stmt = $this->pdo->query($query);
return $stmt;
} catch (Exception $e) {
print $e->getMessage() . "\n";
return null;
}
}
}
//$mode="mysql";
$mode = "sqlite";
if ($mode == 'mysql') {
$autoincrement = "AUTO_INCREMENT";
$dsn = "mysql:dbname=test";
} else {
// $dsn = "sqlite:/".dirname(__FILE__)."/data/woo.db";
$dsn = "sqlite://tmp/data/woo.db";
$autoincrement = "AUTOINCREMENT";
}
$db = new DBFace($dsn);
$db->query("DROP TABLE venue");
$db->query("CREATE TABLE venue ( id INTEGER PRIMARY KEY {$autoincrement}, name TEXT )");
$db->query("DROP TABLE space");
$db->query("CREATE TABLE space ( id INTEGER PRIMARY KEY {$autoincrement}, venue INTEGER, name TEXT )");
$db->query("DROP TABLE event");
$db->query("CREATE TABLE event ( id INTEGER PRIMARY KEY {$autoincrement}, space INTEGER, start long, duration int, name text )");
