PHP Sabre\Katana Database::query Examples

Example #1

File: MySQL.php Project: nurtext/sabre-katana

 /**
  * Run the helper.
  *
  * @return string
  */
 function __invoke()
 {
     $database = new Database(HELPER_MYSQL_DSN, HELPER_MYSQL_USERNAME, HELPER_MYSQL_PASSWORD);
     $query = 'SELECT SCHEMA_NAME ' . 'FROM INFORMATION_SCHEMA.SCHEMATA';
     $databases = iterator_to_array($database->query($query, $database::FETCH_COLUMN, 0));
     while (in_array($databaseName = 'sabre_katana_test_' . uniqid(), $databases)) {
     }
     $query = 'CREATE DATABASE ' . $databaseName . ' ' . 'DEFAULT CHARACTER SET=utf8mb4 ' . 'DEFAULT COLLATE=utf8mb4_unicode_ci';
     $database->exec($query);
     unset($database);
     $this->databases[] = $databaseName;
     return $databaseName;
 }