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

//! generates and executes *INSERT* statements

use canyon_sql::crud::CrudOperations;

#[cfg(feature = "mysql")]

use crate::constants::MYSQL_DS;

#[cfg(feature = "postgres")]

use crate::constants::PSQL_DS;

#[cfg(feature = "mssql")]

use crate::constants::SQL_SERVER_DS;

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

/// Deletes a row from the database that is mapped into some instance of a `T` entity.

///

/// The `t.delete(&self)` operation is only enabled for types that

/// has, at least, one of it's fields annotated with a `#[primary_key]`

/// operation, because we use that concrete field to construct the clause that targets

/// that entity.

///

/// Attempt of usage the `t.delete(&self)` method on an entity without `#[primary_key]`

/// will raise a runtime error.

#[cfg(feature = "postgres")]

    // For test the delete, we will insert a new instance of the database, and then,

    // after inspect it, we will proceed to delete it

        ext_id: 7892635306594_i64,

    };

    // We insert the instance on the database, on the `League` entity

        new_league.id,

            .expect("Request error")

            .expect("None value")

            .id

    );

    // Now that we have an instance mapped to some entity by a primary key, we can now

    // remove that entry from the database with the delete operation

        .delete()

        .expect("Failed to delete the operation");

    // To check the success, we can query by the primary key value and check if, after unwrap()

    // the result of the operation, the find by primary key contains Some(v) or None

    // Remember that `find_by_primary_key(&dyn QueryParameter<'a>) -> Result<Option<T>>, Err>

            .expect("Unwrapping the result, letting the Option<T>"),

        None

    );

}

/// Same as the delete test, but performing the operations with the specified datasource

#[cfg(feature = "mssql")]

    // For test the delete, we will insert a new instance of the database, and then,

    // after inspect it, we will proceed to delete it

        ext_id: 7892635306594_i64,

    };

    // We insert the instance on the database, on the `League` entity

        .insert_datasource(SQL_SERVER_DS)

        .expect("Failed insert operation");

        new_league.id,

            .expect("Request error")

            .expect("None value")

            .id

    );

    // Now that we have an instance mapped to some entity by a primary key, we can now

    // remove that entry from the database with the delete operation

        .delete_datasource(SQL_SERVER_DS)

        .expect("Failed to delete the operation");

    // To check the success, we can query by the primary key value and check if, after unwrap()

    // the result of the operation, the find by primary key contains Some(v) or None

    // Remember that `find_by_primary_key(&dyn QueryParameter<'a>) -> Result<Option<T>>, Err>

            .expect("Unwrapping the result, letting the Option<T>"),

        None

    );

}

/// Same as the delete test, but performing the operations with the specified datasource

#[cfg(feature = "mysql")]

    // For test the delete, we will insert a new instance of the database, and then,

    // after inspect it, we will proceed to delete it

        ext_id: 7892635306594_i64,

    };

    // We insert the instance on the database, on the `League` entity

        .insert_datasource(MYSQL_DS)

        .expect("Failed insert operation");

        new_league.id,

            .expect("Request error")

            .expect("None value")

            .id

    );

    // Now that we have an instance mapped to some entity by a primary key, we can now

    // remove that entry from the database with the delete operation

        .delete_datasource(MYSQL_DS)

        .expect("Failed to delete the operation");

    // To check the success, we can query by the primary key value and check if, after unwrap()

    // the result of the operation, the find by primary key contains Some(v) or None

    // Remember that `find_by_primary_key(&dyn QueryParameter<'a>) -> Result<Option<T>>, Err>

            .expect("Unwrapping the result, letting the Option<T>"),

        None

    );

}