getPrimaryKeys() public method

Returns the names of the primary key columns in the table.
public getPrimaryKeys ( ) : array
return array
Example #1
0
 /**
  * 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([$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([$databaseConnection, 'quoteSchemaObject'], $primaryKeys);
     }
     if (count($primaryKeys)) {
         $orderBy = 'ORDER BY ' . implode(' ASC, ', $primaryKeys) . ' ASC';
     } else {
         $orderBy = '';
     }
     return "SELECT {$columnList} FROM {$tableName} {$orderBy}";
 }
Example #2
0
 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;
 }
 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;
 }
Example #4
0
 /**
  * Returns the names of the primary key columns in the table.
  *
  * @return array
  */
 public function getPrimaryKeys()
 {
     return $this->originalMetaData->getPrimaryKeys();
 }
Example #5
0
 /**
  * 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}";
 }