DbDumpCommand::getFieldOrder

protected DbDumpCommand::getFieldOrder(Connection $connection, $table)

protected function getFieldOrder(Connection $connection, $table) {
  // @todo this is MySQL only since there are no Database API functions for
  // table column data.
  // @todo this code is duplicated in `core/scripts/migrate-db.sh`.
  $connection_info = $connection->getConnectionOptions();
  // Order by primary keys.
  $order = '';
  $query = "SELECT `COLUMN_NAME` FROM `information_schema`.`COLUMNS`
    WHERE (`TABLE_SCHEMA` = '" . $connection_info['database'] . "')
    AND (`TABLE_NAME` = '{" . $table . "}') AND (`COLUMN_KEY` = 'PRI')
    ORDER BY COLUMN_NAME";
  $results = $connection->query($query);
  while (($row = $results->fetchAssoc()) !== FALSE) {
    $order .= $row['COLUMN_NAME'] . ', ';
  }
  if (!empty($order)) {
    $order = ' ORDER BY ' . rtrim($order, ', ');
  }
  return $order;
}