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