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 )");