#![allow(clippy::nonminimal_bool)]

#[cfg(feature = "mysql")]

use crate::constants::MYSQL_DS;

#[cfg(feature = "mssql")]

use crate::constants::SQL_SERVER_DS;

// Integration tests for the CRUD operations available in `Canyon` that

/// generates and executes *SELECT* statements

use crate::Error;

use canyon_sql::crud::CrudOperations;

use crate::tests_models::league::*;

use crate::tests_models::player::*;

/// Tests the behaviour of a SELECT * FROM {table_name} within Canyon, through the

/// `::find_all()` associated function derived with the `CanyonCrud` derive proc-macro

/// and using the *default datasource*

#[cfg(feature = "postgres")]

    let find_all_result: Result<Vec<League>, Box<dyn Error + Send + Sync>> =

    // Connection doesn't return an error

    let find_all_players: Result<Vec<Player>, Box<dyn Error + Send + Sync>> =

}

/// Same as the `find_all()`, but with the unchecked variant, which directly returns `Vec<T>` not

/// `Result` wrapped

#[cfg(feature = "postgres")]

}

/// Tests the behaviour of a SELECT * FROM {table_name} within Canyon, through the

/// `::find_all()` associated function derived with the `CanyonCrud` derive proc-macro

/// and using the specified datasource

#[cfg(feature = "mssql")]

    let find_all_result: Result<Vec<League>, Box<dyn Error + Send + Sync>> =

    // Connection doesn't return an error

}

#[cfg(feature = "mysql")]

    let find_all_result: Result<Vec<League>, Box<dyn Error + Send + Sync>> =

    // Connection doesn't return an error

}

/// Same as the `find_all_datasource()`, but with the unchecked variant and the specified dataosource,

/// returning directly `Vec<T>` and not `Result<Vec<T>, Err>`

#[cfg(feature = "mssql")]

}

/// Tests the behaviour of a SELECT * FROM {table_name} WHERE <pk> = <pk_value>, where the pk is

/// defined with the #[primary_key] attribute over some field of the type.

///

/// Uses the *default datasource*.

#[cfg(feature = "postgres")]

    let find_by_pk_result: Result<Option<League>, Box<dyn Error + Send + Sync>> =

        some_league.image_url,

        "http://static.lolesports.com/leagues/EM_Bug_Outline1.png"

    );

}

/// Tests the behaviour of a SELECT * FROM {table_name} WHERE <pk> = <pk_value>, where the pk is

/// defined with the #[primary_key] attribute over some field of the type.

///

/// Uses the *specified datasource mssql* in the second parameter of the function call.

#[cfg(feature = "mssql")]

    let find_by_pk_result: Result<Option<League>, Box<dyn Error + Send + Sync>> =

        some_league.image_url,

        "http://static.lolesports.com/leagues/1646396098648_CollegeChampionshiplogo.png"

    );

}

/// Tests the behaviour of a SELECT * FROM {table_name} WHERE <pk> = <pk_value>, where the pk is

/// defined with the #[primary_key] attribute over some field of the type.

///

/// Uses the *specified datasource mysql* in the second parameter of the function call.

#[cfg(feature = "mysql")]

    let find_by_pk_result: Result<Option<League>, Box<dyn Error + Send + Sync>> =

        some_league.image_url,

        "http://static.lolesports.com/leagues/1646396098648_CollegeChampionshiplogo.png"

    );

}

/// Counts how many rows contains an entity on the target database.

#[cfg(feature = "postgres")]

    );

}

/// Counts how many rows contains an entity on the target database using

/// the specified datasource mssql

#[cfg(feature = "mssql")]

            .unwrap()

            .len() as i64,

    );

}

/// Counts how many rows contains an entity on the target database using

/// the specified datasource mysql

#[cfg(feature = "mysql")]

    );

}