// Copyright 2023 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::id::{ConnectionId, SchemaId, UserId};
use risingwave_common::types::Fields;
use risingwave_frontend_macro::system_catalog;

use crate::catalog::system_catalog::{SysCatalogReaderImpl, get_acl_items};
use crate::error::Result;
use crate::handler::create_connection::print_connection_params_with_secret_visibility;

#[derive(Fields)]
struct RwConnection {
    #[primary_key]
    id: ConnectionId,
    name: String,
    schema_id: SchemaId,
    owner: UserId,
    type_: String,
    provider: String,
    acl: Vec<String>,
    connection_params: String,
}

#[system_catalog(table, "rw_catalog.rw_connections")]
fn read_rw_connections(reader: &SysCatalogReaderImpl) -> Result<Vec<RwConnection>> {
    let catalog_reader = reader.catalog_reader.read_guard();
    let schemas = catalog_reader.iter_schemas(&reader.auth_context.database)?;
    let user_reader = reader.user_info_reader.read_guard();
    let users = user_reader.get_all_users();
    let current_user = user_reader
        .get_user_by_name(&reader.auth_context.user_name)
        .expect("user not found");
    let username_map = user_reader.get_user_name_map();

    // todo: redesign the internal table for connection params
    Ok(schemas
        .flat_map(|schema| {
            schema.iter_connections_with_acl(current_user).map(|conn| {
                let mut rw_connection = RwConnection {
                    id: conn.id,
                    name: conn.name.clone(),
                    schema_id: schema.id(),
                    owner: conn.owner,
                    type_: conn.connection_type().into(),
                    provider: "".to_owned(),
                    acl: get_acl_items(conn.id, false, &users, username_map),
                    connection_params: "".to_owned(),
                };
                match &conn.info {
                    #[expect(deprecated)]
                    risingwave_pb::catalog::connection::Info::PrivateLinkService(_) => {
                        rw_connection.provider = conn.provider().into();
                    }
                    risingwave_pb::catalog::connection::Info::ConnectionParams(params) => {
                        rw_connection.connection_params =
                            print_connection_params_with_secret_visibility(
                                &reader.auth_context.database,
                                params,
                                &catalog_reader,
                                current_user,
                            );
                    }
                };

                rw_connection
            })
        })
        .collect())
}
