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