DatabaseCollation.php in Site Audit 8.3
File
src/Plugin/SiteAuditCheck/DatabaseCollation.php
View source
<?php
namespace Drupal\site_audit\Plugin\SiteAuditCheck;
use Drupal\Core\Database\Database;
use Drupal\site_audit\Plugin\SiteAuditCheckBase;
class DatabaseCollation extends SiteAuditCheckBase {
public function getResultFail() {
}
public function getResultInfo() {
if (TRUE) {
$ret_val = '<table class="table table-condensed">';
$ret_val .= '<thead><tr><th>' . $this
->t('Table Name') . '</th><th>' . $this
->t('Collation') . '</th></tr></thead>';
$ret_val .= '<tbody>';
foreach ($this->registry->collation_tables as $name => $collation) {
$ret_val .= '<tr>';
$ret_val .= '<td>' . $name . '</td>';
$ret_val .= '<td>' . $collation . '</td>';
$ret_val .= '</tr>';
}
$ret_val .= '</tbody>';
$ret_val .= '</table>';
}
else {
$ret_val = $this
->t('Table Name: Collation') . PHP_EOL;
if (!$this->options['json']) {
$ret_val .= str_repeat(' ', 4);
}
$ret_val .= '---------------------';
foreach ($this->registry->collation_tables as $name => $collation) {
$ret_val .= PHP_EOL;
if (!$this->options['json']) {
$ret_val .= str_repeat(' ', 4);
}
$ret_val .= "{$name}: {$collation}";
}
}
return $ret_val;
}
public function getResultPass() {
return $this
->t('Every table is using UTF-8.');
}
public function getResultWarn() {
return $this
->getResultInfo();
}
public function getAction() {
if ($this
->getScore() == SiteAuditCheckBase::AUDIT_CHECK_SCORE_WARN) {
return $this
->t('In MySQL, use the command "!command" to convert the affected tables. Of course, test first and ensure your data will not be negatively affected.', [
'!command' => 'ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;',
]);
}
}
public function calculateScore() {
$connection = Database::getConnection();
$query = \Drupal::database()
->select('information_schema.TABLES', 'ist');
$query
->addField('ist', 'TABLE_NAME', 'name');
$query
->addField('ist', 'TABLE_COLLATION', 'collation');
$query
->condition('ist.TABLE_COLLATION', [
'utf8_general_ci',
'utf8_unicode_ci',
'utf8_bin',
'utf8mb4_general_ci',
], 'NOT IN');
$query
->condition('ist.table_schema', $connection
->getConnectionOptions()['database']);
$result = $query
->execute();
$count = 0;
$warn = FALSE;
while ($row = $result
->fetchAssoc()) {
$count++;
$this->registry->collation_tables[$row['name']] = $row['collation'];
if ($row['collation'] == 'latin1_swedish_ci') {
$warn = TRUE;
}
}
if ($count === 0) {
return SiteAuditCheckBase::AUDIT_CHECK_SCORE_PASS;
}
if ($warn) {
return SiteAuditCheckBase::AUDIT_CHECK_SCORE_WARN;
}
return SiteAuditCheckBase::AUDIT_CHECK_SCORE_INFO;
}
}