// Copyright 2024 RisingWave Labs
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
//     http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

use risingwave_common::types::Fields;
use risingwave_frontend_macro::system_catalog;

/// The view schemata contains all schemas in the current database that the current user has access to (by way of being the owner or having some privilege).
/// Ref: `https://www.postgresql.org/docs/current/infoschema-schemata.html`
#[system_catalog(
    view,
    "information_schema.schemata",
    "SELECT CURRENT_DATABASE() AS catalog_name,
            s.name AS schema_name,
            u.name AS schema_owner,
            NULL,
            NULL,
            NULL,
            NULL
        FROM rw_catalog.rw_schemas s
        JOIN rw_catalog.rw_users u ON s.owner = u.id
        WHERE has_schema_privilege(s.name, 'CREATE, USAGE')
        ORDER BY catalog_name, schema_name"
)]
#[derive(Fields)]
struct Schemata {
    catalog_name: String,
    schema_name: String,
    schema_owner: String,
    default_character_set_catalog: String,
    default_character_set_schema: String,
    default_character_set_name: String,
    sql_path: String,
}
