/**
* Set up the test database table.
*
* @param PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection $connection
*/
protected function setUpTable($connection)
{
$pdo = $connection->getConnection();
$sql = 'CREATE TABLE IF NOT EXISTS simple_table (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
address VARCHAR(100)
)';
$pdo->exec($sql);
$sql = 'CREATE TABLE IF NOT EXISTS books_array (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
book_id VARCHAR(50) NOT NULL,
info TEXT NOT NULL
)';
$pdo->exec($sql);
$sql = 'CREATE TABLE IF NOT EXISTS books_columns (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
author VARCHAR(100) NOT NULL,
title VARCHAR(100) NOT NULL,
genre VARCHAR(100) NOT NULL,
price VARCHAR(50) NOT NULL,
publish_date VARCHAR(50) NOT NULL,
description TEXT NOT NULL
)';
$pdo->exec($sql);
}
protected function getConnection()
{
if ($this->conn === null) {
if (self::$pdo == null) {
self::$pdo = new \PDO($GLOBALS['DB_DSN'], $GLOBALS['DB_USER'], $GLOBALS['DB_PASSWD']);
}
$this->conn = $this->createDefaultDBConnection(self::$pdo, $GLOBALS['DB_DBNAME']);
$this->conn->getConnection()->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_SILENT);
}
return $this->conn;
}
