use serde::Deserialize;

use crate::canyon_database_connector::DatabaseType;

/// ```

#[test]

fn load_ds_config_from_array() {

    #[cfg(feature = "postgres")]

    {

        const CONFIG_FILE_MOCK_ALT_PG: &str = r#"

        [canyon_sql]

        datasources = [

            {name = 'PostgresDS', auth = { postgresql = { basic = { username = "postgres", password = "postgres" } } }, properties.host = 'localhost', properties.db_name = 'triforce', properties.migrations='enabled' },

        ]

        "#;

        let config: CanyonSqlConfig = toml::from_str(CONFIG_FILE_MOCK_ALT_PG)

            .expect("A failure happened retrieving the [canyon_sql] section");

        let ds_0 = &config.canyon_sql.datasources[0];

        assert_eq!(ds_0.name, "PostgresDS");

        assert_eq!(ds_0.get_db_type(), DatabaseType::PostgreSql);

        assert_eq!(

            ds_0.auth,

            Auth::Postgres(PostgresAuth::Basic {

                username: "postgres".to_string(),

                password: "postgres".to_string()

            })

        );

        assert_eq!(ds_0.properties.host, "localhost");

        assert_eq!(ds_0.properties.port, None);

        assert_eq!(ds_0.properties.db_name, "triforce");

        assert_eq!(ds_0.properties.migrations, Some(Migrations::Enabled));

    }

    #[cfg(feature = "mssql")]

    {

        const CONFIG_FILE_MOCK_ALT_MSSQL: &str = r#"

        [canyon_sql]

        datasources = [

            {name = 'SqlServerDS', auth = { sqlserver = { basic = { username = "sa", password = "SqlServer-10" } } }, properties.host = '192.168.0.250.1', properties.port = 3340, properties.db_name = 'triforce2', properties.migrations='disabled' },

            {name = 'SqlServerDS', auth = { sqlserver = { integrated = {} } }, properties.host = '192.168.0.250.1', properties.port = 3340, properties.db_name = 'triforce2', properties.migrations='disabled' }

        ]

        "#;

        let config: CanyonSqlConfig = toml::from_str(CONFIG_FILE_MOCK_ALT_MSSQL)

            .expect("A failure happened retrieving the [canyon_sql] section");

        let ds_1 = &config.canyon_sql.datasources[0];

        let ds_2 = &config.canyon_sql.datasources[1];

        assert_eq!(ds_1.name, "SqlServerDS");

        assert_eq!(ds_1.get_db_type(), DatabaseType::SqlServer);

        assert_eq!(

            ds_1.auth,

            Auth::SqlServer(SqlServerAuth::Basic {

                username: "sa".to_string(),

                password: "SqlServer-10".to_string()

            })

        );

        assert_eq!(ds_1.properties.host, "192.168.0.250.1");

        assert_eq!(ds_1.properties.port, Some(3340));

        assert_eq!(ds_1.properties.db_name, "triforce2");

        assert_eq!(ds_1.properties.migrations, Some(Migrations::Disabled));

        assert_eq!(ds_2.auth, Auth::SqlServer(SqlServerAuth::Integrated));

    }

    #[cfg(feature = "mysql")]

    {

        const CONFIG_FILE_MOCK_ALT_MYSQL: &str = r#"

        [canyon_sql]

        datasources = [

            {name = 'MysqlDS', auth = { mysql = { basic = { username = "root", password = "root" } } }, properties.host = '192.168.0.250.1', properties.port = 3340, properties.db_name = 'triforce2', properties.migrations='disabled' }

        ]

        "#;

        let config: CanyonSqlConfig = toml::from_str(CONFIG_FILE_MOCK_ALT_MYSQL)

            .expect("A failure happened retrieving the [canyon_sql] section");

        let ds_1 = &config.canyon_sql.datasources[0];

        assert_eq!(ds_1.name, "MysqlDS");

        assert_eq!(ds_1.get_db_type(), DatabaseType::MySQL);

        assert_eq!(

            ds_1.auth,

            Auth::MySQL(MySQLAuth::Basic {

                username: "root".to_string(),

                password: "root".to_string()

            })

        );

        assert_eq!(ds_1.properties.host, "192.168.0.250.1");

        assert_eq!(ds_1.properties.port, Some(3340));

        assert_eq!(ds_1.properties.db_name, "triforce2");

        assert_eq!(ds_1.properties.migrations, Some(Migrations::Disabled));

    }

}

///

pub struct CanyonSqlConfig {

}

pub struct Datasources {

}

pub struct DatasourceConfig {

}

impl DatasourceConfig {

            #[cfg(feature = "postgres")]

            #[cfg(feature = "mssql")]

            #[cfg(feature = "mysql")]

        }

}

pub enum Auth {

    #[serde(alias = "PostgresSQL", alias = "postgresql", alias = "postgres")]

    #[cfg(feature = "postgres")]

    #[serde(alias = "SqlServer", alias = "sqlserver", alias = "mssql")]

    #[cfg(feature = "mssql")]

    #[serde(alias = "MYSQL", alias = "mysql", alias = "MySQL")]

    #[cfg(feature = "mysql")]

}

#[cfg(feature = "postgres")]

pub enum PostgresAuth {

    #[serde(alias = "Basic", alias = "basic")]

}

#[cfg(feature = "mssql")]

    #[serde(alias = "Basic", alias = "basic")]

    #[serde(alias = "Integrated", alias = "integrated")]

    Integrated,

}

#[cfg(feature = "mysql")]

pub enum MySQLAuth {

    #[serde(alias = "Basic", alias = "basic")]

}

pub struct DatasourceProperties {

}

/// Represents the enabled or disabled migrations for a whole datasource

    #[serde(alias = "Enabled", alias = "enabled")]

    Enabled,

    #[serde(alias = "Disabled", alias = "disabled")]

    Disabled,

}