protected function setUp() { include(__DIR__ . '/../../config.php'); $db = $config['mysql_db']; $settings = new Settings($db); $database = $settings->getDatabase(); $settings->setDatabase(null); $this->connection = new Connection_MySQL($settings); $this->connection->query("DROP DATABASE IF EXISTS $database;"); $this->connection->query("CREATE DATABASE $database;"); $this->connection->query("USE $database;"); $settings->setDatabase($database); $this->connection->query("CREATE TABLE cat ( id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50), colour VARCHAR(50) ) ENGINE=InnoDB"); $this->connection->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array("Simon's Cat", 'black')); $this->connection->query("INSERT INTO cat (name, colour) VALUES (?, ?)", array("Garfield", 'ginger')); }
public function testProtoDatabase() { $connections = array( array('mysql', 'dbname'), array('sqlite', 'database_name'), array('sqlite', '/home/www/db/my_site.db'), array('sqlite', '/home/www/db/my_site.db?mode=666'), ); foreach ($connections as $connection) { list($driver, $dbname) = $connection; $dsn = "$driver:///$dbname"; $settings = new Settings($dsn); $this->assertEquals($settings->getDriver(), $driver, "Parse: $dsn"); $this->assertEquals($settings->getDatabase(), $dbname, "Parse: $dsn"); } }