createQueryTable() public method

Creates a table with the result of the specified SQL statement.
public createQueryTable ( string $resultName, string $sql ) : PHPUnit_Extensions_Database_DB_Table
$resultName string
$sql string
return PHPUnit_Extensions_Database_DB_Table
Exemplo n.º 1
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]);
 }