protected function disablePrimaryKeys(PHPUnit_Extensions_Database_DataSet_ITableMetaData $databaseTableMetaData, PHPUnit_Extensions_Database_DataSet_ITable $table, PHPUnit_Extensions_Database_DB_IDatabaseConnection $connection)
{
if (count($databaseTableMetaData->getPrimaryKeys())) {
return TRUE;
}
return FALSE;
}
/**
* Asserts that the given tableMetaData matches this tableMetaData.
*
* @param PHPUnit_Extensions_Database_DataSet_ITableMetaData $other
*/
public function matches(PHPUnit_Extensions_Database_DataSet_ITableMetaData $other)
{
if ($this->getTableName() != $other->getTableName() || $this->getColumns() != $other->getColumns()) {
return FALSE;
}
return TRUE;
}
protected function buildOperationArguments(PHPUnit_Extensions_Database_DataSet_ITableMetaData $databaseTableMetaData, PHPUnit_Extensions_Database_DataSet_ITable $table, $row)
{
$args = array();
foreach ($databaseTableMetaData->getPrimaryKeys() as $columnName) {
$args[] = $table->getValue($row, $columnName);
}
return $args;
}
/**
* Creates the query necessary to pull all of the data from a table.
*
* @param PHPUnit_Extensions_Database_DataSet_ITableMetaData $tableMetaData
* @return unknown
*/
public static function buildTableSelect(PHPUnit_Extensions_Database_DataSet_ITableMetaData $tableMetaData, PHPUnit_Extensions_Database_DB_IDatabaseConnection $databaseConnection = NULL)
{
if ($tableMetaData->getTableName() == '') {
$e = new Exception("Empty Table Name");
echo $e->getTraceAsString();
throw $e;
}
$columns = $tableMetaData->getColumns();
if ($databaseConnection) {
$columns = array_map(array($databaseConnection, 'quoteSchemaObject'), $columns);
}
$columnList = implode(', ', $columns);
if ($databaseConnection) {
$tableName = $databaseConnection->quoteSchemaObject($tableMetaData->getTableName());
} else {
$tableName = $tableMetaData->getTableName();
}
$primaryKeys = $tableMetaData->getPrimaryKeys();
if ($databaseConnection) {
$primaryKeys = array_map(array($databaseConnection, 'quoteSchemaObject'), $primaryKeys);
}
if (count($primaryKeys)) {
$orderBy = 'ORDER BY ' . implode(' ASC, ', $primaryKeys) . ' ASC';
} else {
$orderBy = '';
}
return "SELECT {$columnList} FROM {$tableName} {$orderBy}";
}
/**
* Returns the name of the table.
*
* @return string
*/
public function getTableName()
{
return $this->originalMetaData->getTableName();
}
/**
* Asserts that the given tableMetaData matches this tableMetaData.
*
* @param PHPUnit_Extensions_Database_DataSet_ITableMetaData $other
*/
public function assertEquals(PHPUnit_Extensions_Database_DataSet_ITableMetaData $other)
{
if ($this->getTableName() != $other->getTableName()) {
throw new Exception("Expected table name of {$this->getTableName()}, has a name of {$other->getTableName()}");
}
if ($this->getColumns() != $other->getColumns()) {
throw new Exception("Expected following columns: " . implode(', ', $this->getColumns()) . "; has columns: " . implode(', ', $other->getColumns()));
}
return TRUE;
}
public function matches(\PHPUnit_Extensions_Database_DataSet_ITableMetaData $other)
{
return $this->getTableName() == $other->getTableName();
}
/**
* Creates the query necessary to pull all of the data from a table.
*
* @param PHPUnit_Extensions_Database_DataSet_ITableMetaData $tableMetaData
* @return unknown
*/
public static function buildTableSelect(PHPUnit_Extensions_Database_DataSet_ITableMetaData $tableMetaData)
{
if ($tableMetaData->getTableName() == '') {
$e = new Exception("Empty Table Name");
echo $e->getTraceAsString();
throw $e;
}
$columnList = implode(', ', $tableMetaData->getColumns());
$primaryKeys = $tableMetaData->getPrimaryKeys();
if (count($primaryKeys)) {
$orderBy = 'ORDER BY ' . implode(' ASC, ', $primaryKeys) . ' ASC';
} else {
$orderBy = '';
}
return "SELECT {$columnList} FROM {$tableMetaData->getTableName()} {$orderBy}";
}
