public function DatabaseEngine::calculateScore in Site Audit 8.3

.

Overrides SiteAuditCheckBase::calculateScore

File

src/Plugin/SiteAuditCheck/DatabaseEngine.php, line 86

Class

DatabaseEngine

Provides the CronLast Check.

Namespace

Drupal\site_audit\Plugin\SiteAuditCheck

Code

public function calculateScore() {
  $connection = Database::getConnection();
  $query = \Drupal::database()
    ->select('information_schema.TABLES', 'ist');
  $query
    ->addField('ist', 'TABLE_NAME', 'name');
  $query
    ->addField('ist', 'ENGINE', 'engine');
  $query
    ->condition('ist.ENGINE', 'InnoDB', '<>');
  $query
    ->condition('ist.table_schema', $connection
    ->getConnectionOptions()['database']);
  $result = $query
    ->execute();
  $count = 0;
  while ($row = $result
    ->fetchAssoc()) {
    $count++;
    $this->registry->engine_tables[$row['name']] = $row['engine'];
  }
  if ($count === 0) {
    return SiteAuditCheckBase::AUDIT_CHECK_SCORE_PASS;
  }
  return SiteAuditCheckBase::AUDIT_CHECK_SCORE_FAIL;
}