Author: Mike Lively (m@digitalsandwich.com)
Inheritance: implements PHPUnit_Extensions_Database_DB_IDatabaseConnection
 /**
  * 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);
 }
 public function testRowCountForTableWithTwoRowsReturnsTwo()
 {
     $this->db->exec('INSERT INTO test (field1) VALUES (\'foobar\')');
     $this->db->exec('INSERT INTO test (field1) VALUES (\'foobarbaz\')');
     $conn = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($this->db);
     $this->assertEquals(2, $conn->getRowCount('test'));
 }
Exemple #3
0
 /**
  * Creates a DB Data Set from a data set spec.
  *
  * @param  string                                       $dataSetSpec
  * @return PHPUnit_Extensions_Database_DataSet_IDataSet
  */
 public function getDataSet($dataSetSpec)
 {
     list($dbLabel, $schema, $tables) = explode(':', $dataSetSpec, 3);
     $databaseInfo = $this->databases[$dbLabel];
     $pdoRflc = new ReflectionClass('PDO');
     $pdo = $pdoRflc->newInstanceArgs(explode('|', $databaseInfo));
     $dbConnection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, $schema);
     return !empty($tables) ? $dbConnection->createDataSet(explode(',', $tables)) : $dbConnection->createDataSet();
 }
Exemple #4
0
 /**
  * Creates a Default Data Set with a query table from a data set spec.
  *
  * @param  string                                             $dataSetSpec
  * @return PHPUnit_Extensions_Database_DataSet_DefaultDataSet
  */
 public function getDataSet($dataSetSpec)
 {
     list($dbLabel, $schema, $table, $sql) = explode(':', $dataSetSpec, 4);
     $databaseInfo = $this->databases[$dbLabel];
     $pdoRflc = new ReflectionClass('PDO');
     $pdo = $pdoRflc->newInstanceArgs(explode('|', $databaseInfo));
     $dbConnection = new PHPUnit_Extensions_Database_DB_DefaultDatabaseConnection($pdo, $schema);
     $table = $dbConnection->createQueryTable($table, $sql);
     return new PHPUnit_Extensions_Database_DataSet_DefaultDataSet([$table]);
 }
Exemple #5
0
 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;
 }
Exemple #6
0
 /**
  * Returns a list of table names for the database
  * 
  * @return Array
  */
 public function getTableNames()
 {
     return $this->databaseConnection->getMetaData()->getTableNames();
 }