Habari\InstallHandler::get_create_schema_and_user_queries PHP Метод

get_create_schema_and_user_queries() приватный Метод

Returns an RDMBS-specific CREATE SCHEMA plus user SQL expression(s)
private get_create_schema_and_user_queries ( ) : string[]
Результат string[] array of SQL queries to execute
    private function get_create_schema_and_user_queries()
    {
        $db_host = $this->handler_vars['db_host'];
        $db_type = $this->handler_vars['db_type'];
        $db_schema = $this->handler_vars['db_schema'];
        $db_user = $this->handler_vars['db_user'];
        $db_pass = $this->handler_vars['db_pass'];
        $queries = array();
        switch ($db_type) {
            case 'mysql':
                $queries[] = 'CREATE DATABASE ' . $db_schema . ';';
                $queries[] = 'GRANT ALL ON ' . $db_schema . '.* TO \'' . $db_user . '\'@\'' . $db_host . '\' ' . 'IDENTIFIED BY \'' . $db_pass . '\';';
                break;
            case 'pgsql':
                $queries[] = 'CREATE DATABASE ' . $db_schema . ';';
                $queries[] = 'GRANT ALL ON DATABASE ' . $db_schema . ' TO ' . $db_user . ';';
                break;
            default:
                die(_t('currently unsupported.'));
        }
        return $queries;
    }