use crate::{
    ActiveModelTrait, ActiveValue, ColumnTrait, EntityName, EntityTrait, IntoActiveModel, Iterable,
    PrimaryKeyTrait, QueryTrait,
};
use core::marker::PhantomData;
use sea_query::{Expr, InsertStatement, Keyword, OnConflict, SimpleExpr, Value, ValueTuple};

/// Single-row `INSERT` builder, returned by
/// [`EntityTrait::insert`](crate::EntityTrait::insert). Chain `.on_conflict(...)`
/// or `.on_empty_returning(...)` then dispatch with `.exec(db)` or
/// `.exec_with_returning(db)`.
#[derive(Debug)]
pub struct Insert<A>
where
    A: ActiveModelTrait,
{
    pub(crate) query: InsertStatement,
    pub(crate) primary_key: Option<ValueTuple>,
    pub(crate) model: PhantomData<A>,
}

/// Multi-row `INSERT` builder, returned by
/// [`EntityTrait::insert_many`](crate::EntityTrait::insert_many). Adds
/// `.exec_with_returning_many` and `.exec_with_returning_keys` for batch
/// inserts that need the resulting rows or primary keys.
#[derive(Debug)]
pub struct InsertMany<A>
where
    A: ActiveModelTrait,
{
    pub(crate) query: InsertStatement,
    pub(crate) primary_key: Option<ValueTuple>,
    pub(crate) empty: bool,
    pub(crate) model: PhantomData<A>,
}

/// Wrapper of [`Insert`] / [`InsertMany`], treats "no row inserted/id returned" as a normal outcome.
///
/// Its `exec*` methods return [`crate::TryInsertResult`].
/// Mapping empty input to [`crate::TryInsertResult::Empty`] (no SQL executed) and
/// `DbErr::RecordNotInserted` to [`crate::TryInsertResult::Conflicted`].
///
/// Useful for idempotent inserts such as `ON CONFLICT ... DO NOTHING` (Postgres / SQLite) or the
/// MySQL polyfill (`ON DUPLICATE KEY UPDATE pk = pk`).
#[derive(Debug)]
pub struct TryInsert<A>
where
    A: ActiveModelTrait,
{
    pub(crate) insert_struct: Insert<A>,
    pub(crate) empty: bool,
}

impl<A> Insert<A>
where
    A: ActiveModelTrait,
{
    /// Insert one Model or ActiveModel
    ///
    /// Model
    /// ```
    /// use sea_orm::{DbBackend, entity::*, query::*, tests_cfg::cake};
    ///
    /// assert_eq!(
    ///     Insert::one(cake::Model {
    ///         id: 1,
    ///         name: "Apple Pie".to_owned(),
    ///     })
    ///     .build(DbBackend::Postgres)
    ///     .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie')"#,
    /// );
    /// ```
    /// ActiveModel
    /// ```
    /// use sea_orm::{DbBackend, entity::*, query::*, tests_cfg::cake};
    ///
    /// assert_eq!(
    ///     Insert::one(cake::ActiveModel {
    ///         id: NotSet,
    ///         name: Set("Apple Pie".to_owned()),
    ///     })
    ///     .build(DbBackend::Postgres)
    ///     .to_string(),
    ///     r#"INSERT INTO "cake" ("name") VALUES ('Apple Pie')"#,
    /// );
    /// ```
    pub fn one<M>(m: M) -> Self
    where
        M: IntoActiveModel<A>,
    {
        let mut query = InsertStatement::new();
        query
            .into_table(A::Entity::default().table_ref())
            .or_default_values();

        let mut am: A = m.into_active_model();
        let primary_key =
            if !<<A::Entity as EntityTrait>::PrimaryKey as PrimaryKeyTrait>::auto_increment() {
                am.get_primary_key_value()
            } else {
                None
            };
        let mut columns = Vec::new();
        let mut values = Vec::new();

        for col in <A::Entity as EntityTrait>::Column::iter() {
            let av = am.take(col);

            match av {
                ActiveValue::Set(value) | ActiveValue::Unchanged(value) => {
                    columns.push(col);
                    values.push(col.save_as(Expr::val(value)));
                }
                ActiveValue::NotSet => {}
            }
        }

        query.columns(columns);
        query.values_panic(values);

        Self {
            query,
            primary_key,
            model: PhantomData,
        }
    }

    /// Insert many Model or ActiveModel.
    /// Alias to [`InsertMany::many`].
    ///
    /// ```
    /// use sea_orm::{DbBackend, entity::*, query::*, tests_cfg::cake};
    ///
    /// assert_eq!(
    ///     Insert::many([
    ///         cake::Model {
    ///             id: 1,
    ///             name: "Apple Pie".to_owned(),
    ///         },
    ///         cake::Model {
    ///             id: 2,
    ///             name: "Orange Scone".to_owned(),
    ///         }
    ///     ])
    ///     .build(DbBackend::Postgres)
    ///     .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie'), (2, 'Orange Scone')"#,
    /// );
    /// ```
    pub fn many<M, I>(models: I) -> InsertMany<A>
    where
        M: IntoActiveModel<A>,
        I: IntoIterator<Item = M>,
    {
        InsertMany::many(models)
    }

    /// Set ON CONFLICT logic
    ///
    /// on conflict do nothing
    /// ```
    /// use sea_orm::{DbBackend, entity::*, query::*, sea_query::OnConflict, tests_cfg::cake};
    ///
    /// let orange = cake::ActiveModel {
    ///     id: ActiveValue::set(2),
    ///     name: ActiveValue::set("Orange".to_owned()),
    /// };
    /// assert_eq!(
    ///     cake::Entity::insert(orange)
    ///         .on_conflict(
    ///             OnConflict::column(cake::Column::Name)
    ///                 .do_nothing()
    ///                 .to_owned()
    ///         )
    ///         .build(DbBackend::Postgres)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
    /// );
    /// ```
    ///
    /// on conflict do update (upsert)
    /// ```
    /// use sea_orm::{entity::*, query::*, sea_query::OnConflict, tests_cfg::cake, DbBackend};
    ///
    /// let orange = cake::ActiveModel {
    ///     id: ActiveValue::set(2),
    ///     name: ActiveValue::set("Orange".to_owned()),
    /// };
    /// let query = cake::Entity::insert(orange)
    ///     .on_conflict(
    ///         OnConflict::column(cake::Column::Name)
    ///             .update_column(cake::Column::Name)
    ///             .to_owned()
    ///     );
    /// assert_eq!(
    ///     query
    ///         .build(DbBackend::MySql)
    ///         .to_string(),
    ///     "INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`)"
    /// );
    /// assert_eq!(
    ///     query
    ///         .build(DbBackend::Postgres)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO UPDATE SET "name" = "excluded"."name""#,
    /// );
    /// assert_eq!(
    ///     query
    ///         .build(DbBackend::Sqlite)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO UPDATE SET "name" = "excluded"."name""#,
    /// );
    /// ```
    pub fn on_conflict(mut self, on_conflict: OnConflict) -> Self {
        self.query.on_conflict(on_conflict);
        self
    }

    /// Set ON CONFLICT do nothing, but with MySQL specific polyfill.
    pub fn on_conflict_do_nothing_on<I>(mut self, columns: I) -> TryInsert<A>
    where
        I: IntoIterator<Item = <A::Entity as EntityTrait>::Column>,
    {
        let primary_keys = <A::Entity as EntityTrait>::PrimaryKey::iter();
        let mut on_conflict = OnConflict::columns(columns);
        on_conflict.do_nothing_on(primary_keys);
        self.query.on_conflict(on_conflict);
        TryInsert::from_one(self)
    }

    /// Allow insert statement to return without error if nothing's been inserted.
    #[deprecated(
        since = "2.0.0",
        note = "Please use [`TryInsert::one`] or `on_conflict_do_nothing*` methods that return [`TryInsert`], or [`Insert::try_insert`]."
    )]
    pub fn do_nothing(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_one(self)
    }

    /// Convert self into a `TryInsert`. It is just a wrapper for converting `DbErr::RecordNotInserted` -> `TryInsertResult::Conflicted`.
    pub fn try_insert(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_one(self)
    }

    /// Alias to [`Insert::do_nothing`].
    #[deprecated(
        since = "2.0.0",
        note = "Please use [`TryInsert::one`] or `on_conflict_do_nothing*` methods that return [`TryInsert`]"
    )]
    pub fn on_empty_do_nothing(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_one(self)
    }

    /// Set ON CONFLICT on primary key do nothing, but with MySQL specific polyfill.
    ///
    /// ```
    /// use sea_orm::{entity::*, query::*, sea_query::OnConflict, tests_cfg::cake, DbBackend};
    ///
    /// let orange = cake::ActiveModel {
    ///     id: ActiveValue::set(2),
    ///     name: ActiveValue::set("Orange".to_owned()),
    /// };
    ///
    /// assert_eq!(
    ///     cake::Entity::insert(orange.clone())
    ///         .on_conflict_do_nothing()
    ///         .build(DbBackend::MySql)
    ///         .to_string(),
    ///     r#"INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `id` = `id`"#,
    /// );
    /// assert_eq!(
    ///     cake::Entity::insert(orange.clone())
    ///         .on_conflict_do_nothing()
    ///         .build(DbBackend::Postgres)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("id") DO NOTHING"#,
    /// );
    /// assert_eq!(
    ///     cake::Entity::insert(orange)
    ///         .on_conflict_do_nothing()
    ///         .build(DbBackend::Sqlite)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("id") DO NOTHING"#,
    /// );
    /// ```
    pub fn on_conflict_do_nothing(mut self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        self.query.on_conflict(on_conflict_primary_key::<A>());

        TryInsert::from_one(self)
    }
}

impl<A> InsertMany<A>
where
    A: ActiveModelTrait,
{
    /// Insert many Model or ActiveModel
    pub fn many<M, I>(models: I) -> Self
    where
        M: IntoActiveModel<A>,
        I: IntoIterator<Item = M>,
    {
        let mut query = InsertStatement::new();
        query.into_table(A::Entity::default().table_ref());

        let mut columns: Vec<_> = <A::Entity as EntityTrait>::Column::iter()
            .map(|_| None)
            .collect();
        let mut null_value: Vec<Option<Value>> = std::iter::repeat_n(None, columns.len()).collect();
        let mut all_values: Vec<Vec<SimpleExpr>> = Vec::new();
        let mut primary_key = None;

        for model in models.into_iter() {
            let mut am: A = model.into_active_model();
            primary_key =
                if !<<A::Entity as EntityTrait>::PrimaryKey as PrimaryKeyTrait>::auto_increment() {
                    am.get_primary_key_value()
                } else {
                    None
                };
            let mut values = Vec::with_capacity(columns.len());
            for (idx, col) in <A::Entity as EntityTrait>::Column::iter().enumerate() {
                let av = am.take(col);
                match av {
                    ActiveValue::Set(value) | ActiveValue::Unchanged(value) => {
                        columns[idx] = Some(col); // mark the column as used
                        null_value[idx] = Some(value.as_null()); // store the null value with the correct type
                        values.push(col.save_as(Expr::val(value))); // same as add() above
                    }
                    ActiveValue::NotSet => {
                        values.push(SimpleExpr::Keyword(Keyword::Null)); // indicate a missing value
                    }
                }
            }
            all_values.push(values);
        }

        let empty = all_values.is_empty();

        if !all_values.is_empty() {
            // filter only used column
            query.columns(columns.iter().cloned().flatten());
        }

        for values in all_values {
            // since we've aligned the column set, this never panics
            query.values_panic(values.into_iter().enumerate().filter_map(|(i, v)| {
                if columns[i].is_some() {
                    // only if the column is used
                    if !matches!(v, SimpleExpr::Keyword(Keyword::Null)) {
                        // use the value expression
                        Some(v)
                    } else {
                        // use null as standin, which must be Some
                        null_value[i].clone().map(SimpleExpr::Value)
                    }
                } else {
                    None
                }
            }));
        }

        Self {
            query,
            primary_key,
            empty,
            model: PhantomData,
        }
    }

    /// Set ON CONFLICT logic
    pub fn on_conflict(mut self, on_conflict: OnConflict) -> Self {
        self.query.on_conflict(on_conflict);
        self
    }

    /// Set ON CONFLICT do nothing, but with MySQL specific polyfill.
    /// ```
    /// use sea_orm::{entity::*, query::*, sea_query::OnConflict, tests_cfg::cake, DbBackend};
    /// let orange = cake::ActiveModel {
    ///     id: ActiveValue::set(2),
    ///     name: ActiveValue::set("Orange".to_owned()),
    /// };
    /// assert_eq!(
    ///     cake::Entity::insert(orange.clone())
    ///         .on_conflict_do_nothing_on([cake::Column::Name])
    ///         .build(DbBackend::Postgres)
    ///         .to_string(),
    ///     r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
    /// );
    /// assert_eq!(
    ///     cake::Entity::insert(orange)
    ///         .on_conflict_do_nothing_on([cake::Column::Name])
    ///         .build(DbBackend::MySql)
    ///         .to_string(),
    ///     r#"INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `id` = `id`"#,
    /// );
    /// ```
    pub fn on_conflict_do_nothing_on<I>(mut self, columns: I) -> TryInsert<A>
    where
        I: IntoIterator<Item = <A::Entity as EntityTrait>::Column>,
    {
        let primary_keys = <A::Entity as EntityTrait>::PrimaryKey::iter();
        let mut on_conflict = OnConflict::columns(columns);
        on_conflict.do_nothing_on(primary_keys);
        self.query.on_conflict(on_conflict);
        TryInsert::from_many(self)
    }

    /// Allow insert statement to return without error if nothing's been inserted.
    #[deprecated(
        since = "2.0.0",
        note = "Please use [`TryInsert::many`] or `on_conflict_do_nothing*` methods that return [`TryInsert`], or [`InsertMany::try_insert`]"
    )]
    pub fn do_nothing(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_many(self)
    }

    /// Convert self into a `TryInsert`. It is just a wrapper for converting `DbErr::RecordNotInserted` -> `TryInsertResult::Conflicted`.
    pub fn try_insert(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_many(self)
    }

    /// Alias to [`InsertMany::do_nothing`].
    #[deprecated(
        since = "2.0.0",
        note = "Empty input is already handled by [`InsertMany::exec`] (no SQL executed). For conflict handling, use [`InsertMany::on_conflict_do_nothing`] or [`InsertMany::on_conflict_do_nothing_on`]."
    )]
    pub fn on_empty_do_nothing(self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        TryInsert::from_many(self)
    }

    /// Set ON CONFLICT on primary key do nothing, but with MySQL specific polyfill.
    /// See also [`Insert::on_conflict_do_nothing`].
    pub fn on_conflict_do_nothing(mut self) -> TryInsert<A>
    where
        A: ActiveModelTrait,
    {
        self.query.on_conflict(on_conflict_primary_key::<A>());

        TryInsert::from_many(self)
    }

    /// panic when self is empty
    pub(crate) fn into_one(self) -> Insert<A> {
        assert!(!self.empty);

        let Self {
            query,
            primary_key,
            empty: _,
            model,
        } = self;

        Insert {
            query,
            primary_key,
            model,
        }
    }
}

impl<A> QueryTrait for Insert<A>
where
    A: ActiveModelTrait,
{
    type QueryStatement = InsertStatement;

    fn query(&mut self) -> &mut InsertStatement {
        &mut self.query
    }

    fn as_query(&self) -> &InsertStatement {
        &self.query
    }

    fn into_query(self) -> InsertStatement {
        self.query
    }
}

impl<A> QueryTrait for InsertMany<A>
where
    A: ActiveModelTrait,
{
    type QueryStatement = InsertStatement;

    fn query(&mut self) -> &mut InsertStatement {
        &mut self.query
    }

    fn as_query(&self) -> &InsertStatement {
        &self.query
    }

    fn into_query(self) -> InsertStatement {
        self.query
    }
}

impl<A> TryInsert<A>
where
    A: ActiveModelTrait,
{
    fn from_one(insert: Insert<A>) -> Self {
        Self {
            insert_struct: insert,
            empty: false,
        }
    }

    fn from_many(insert: InsertMany<A>) -> Self {
        let InsertMany {
            query,
            primary_key,
            empty,
            model,
        } = insert;

        Self {
            insert_struct: Insert {
                query,
                primary_key,
                model,
            },
            empty,
        }
    }

    /// Try insert one item
    pub fn one<M>(m: M) -> Self
    where
        M: IntoActiveModel<A>,
    {
        Self::from_one(Insert::one(m))
    }

    /// Try insert many items
    pub fn many<M, I>(models: I) -> Self
    where
        M: IntoActiveModel<A>,
        I: IntoIterator<Item = M>,
    {
        Self::from_many(Insert::many(models))
    }

    /// Set ON CONFLICT logic
    pub fn on_conflict(mut self, on_conflict: OnConflict) -> Insert<A> {
        self.insert_struct.query.on_conflict(on_conflict);
        self.insert_struct
    }

    /// Set ON CONFLICT on primary key do nothing, but with MySQL specific polyfill.
    pub fn on_conflict_do_nothing(mut self) -> Self {
        self.insert_struct
            .query
            .on_conflict(on_conflict_primary_key::<A>());

        self
    }

    /// Set ON CONFLICT do nothing, but with MySQL specific polyfill.
    pub fn on_conflict_do_nothing_on<I>(mut self, columns: I) -> Self
    where
        I: IntoIterator<Item = <A::Entity as EntityTrait>::Column>,
    {
        let primary_keys = <A::Entity as EntityTrait>::PrimaryKey::iter();
        let mut on_conflict = OnConflict::columns(columns);
        on_conflict.do_nothing_on(primary_keys);
        self.insert_struct.query.on_conflict(on_conflict);
        self
    }
}

impl<A> QueryTrait for TryInsert<A>
where
    A: ActiveModelTrait,
{
    type QueryStatement = InsertStatement;

    fn query(&mut self) -> &mut InsertStatement {
        &mut self.insert_struct.query
    }

    fn as_query(&self) -> &InsertStatement {
        &self.insert_struct.query
    }

    fn into_query(self) -> InsertStatement {
        self.insert_struct.query
    }
}

fn on_conflict_primary_key<A: ActiveModelTrait>() -> OnConflict {
    let primary_keys = <A::Entity as EntityTrait>::PrimaryKey::iter();
    let mut on_conflict = OnConflict::columns(primary_keys.clone());
    on_conflict.do_nothing_on(primary_keys);
    on_conflict
}

#[cfg(test)]
mod tests {
    use sea_query::OnConflict;

    use crate::tests_cfg::{cake, cake_filling};
    use crate::{
        ActiveValue, DbBackend, DbErr, EntityTrait, Insert, IntoActiveModel, NotSet, QueryTrait,
        Set,
    };

    #[test]
    fn insert_1() {
        assert_eq!(
            Insert::<cake::ActiveModel>::one(cake::ActiveModel {
                id: ActiveValue::not_set(),
                name: ActiveValue::set("Apple Pie".to_owned()),
            })
            .build(DbBackend::Postgres)
            .to_string(),
            r#"INSERT INTO "cake" ("name") VALUES ('Apple Pie')"#,
        );
    }

    #[test]
    fn insert_2() {
        assert_eq!(
            Insert::<cake::ActiveModel>::one(cake::ActiveModel {
                id: ActiveValue::set(1),
                name: ActiveValue::set("Apple Pie".to_owned()),
            })
            .build(DbBackend::Postgres)
            .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie')"#,
        );
    }

    #[test]
    fn insert_3() {
        assert_eq!(
            Insert::<cake::ActiveModel>::one(cake::Model {
                id: 1,
                name: "Apple Pie".to_owned(),
            })
            .build(DbBackend::Postgres)
            .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie')"#,
        );
    }

    #[test]
    fn insert_many_1() {
        assert_eq!(
            Insert::<cake::ActiveModel>::many([
                cake::Model {
                    id: 1,
                    name: "Apple Pie".to_owned(),
                },
                cake::Model {
                    id: 2,
                    name: "Orange Scone".to_owned(),
                }
            ])
            .build(DbBackend::Postgres)
            .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (1, 'Apple Pie'), (2, 'Orange Scone')"#,
        );
    }

    #[test]
    fn insert_many_2() {
        assert_eq!(
            Insert::<cake::ActiveModel>::many([
                cake::ActiveModel {
                    id: NotSet,
                    name: Set("Apple Pie".to_owned()),
                },
                cake::ActiveModel {
                    id: NotSet,
                    name: Set("Orange Scone".to_owned()),
                }
            ])
            .build(DbBackend::Postgres)
            .to_string(),
            r#"INSERT INTO "cake" ("name") VALUES ('Apple Pie'), ('Orange Scone')"#,
        );
    }

    #[test]
    fn insert_many_3() {
        let apple = cake_filling::ActiveModel {
            cake_id: ActiveValue::set(2),
            filling_id: ActiveValue::NotSet,
        };
        let orange = cake_filling::ActiveModel {
            cake_id: ActiveValue::NotSet,
            filling_id: ActiveValue::set(3),
        };
        assert_eq!(
            Insert::<cake_filling::ActiveModel>::many([apple, orange])
                .build(DbBackend::Postgres)
                .to_string(),
            r#"INSERT INTO "cake_filling" ("cake_id", "filling_id") VALUES (2, NULL), (NULL, 3)"#,
        );
    }

    #[test]
    fn insert_6() {
        let orange = cake::ActiveModel {
            id: ActiveValue::set(2),
            name: ActiveValue::set("Orange".to_owned()),
        };

        assert_eq!(
            cake::Entity::insert(orange)
                .on_conflict(
                    OnConflict::column(cake::Column::Name)
                        .do_nothing()
                        .to_owned()
                )
                .build(DbBackend::Postgres)
                .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
        );
    }

    #[test]
    fn insert_7() {
        let orange = cake::ActiveModel {
            id: ActiveValue::set(2),
            name: ActiveValue::set("Orange".to_owned()),
        };

        assert_eq!(
            cake::Entity::insert(orange)
                .on_conflict(
                    OnConflict::column(cake::Column::Name)
                        .update_column(cake::Column::Name)
                        .to_owned()
                )
                .build(DbBackend::Postgres)
                .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO UPDATE SET "name" = "excluded"."name""#,
        );
    }

    #[test]
    fn test_on_conflict_do_nothing_on() {
        let orange = cake::ActiveModel {
            id: ActiveValue::set(2),
            name: ActiveValue::set("Orange".to_owned()),
        };

        assert_eq!(
            cake::Entity::insert(orange.clone())
                .on_conflict_do_nothing_on([cake::Column::Name])
                .build(DbBackend::Postgres)
                .to_string(),
            r#"INSERT INTO "cake" ("id", "name") VALUES (2, 'Orange') ON CONFLICT ("name") DO NOTHING"#,
        );
        assert_eq!(
            cake::Entity::insert(orange)
                .on_conflict_do_nothing_on([cake::Column::Name])
                .build(DbBackend::MySql)
                .to_string(),
            r#"INSERT INTO `cake` (`id`, `name`) VALUES (2, 'Orange') ON DUPLICATE KEY UPDATE `id` = `id`"#,
        );
    }

    #[test]
    fn insert_8() -> Result<(), DbErr> {
        use crate::{DbBackend, MockDatabase, Statement, Transaction};

        mod post {
            use crate as sea_orm;
            use crate::entity::prelude::*;

            #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
            #[sea_orm(table_name = "posts")]
            pub struct Model {
                #[sea_orm(primary_key, select_as = "INTEGER", save_as = "TEXT")]
                pub id: i32,
                pub title: String,
                pub text: String,
            }

            #[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
            pub enum Relation {}

            impl ActiveModelBehavior for ActiveModel {}
        }

        let model = post::Model {
            id: 1,
            title: "News wrap up 2022".into(),
            text: "brbrbrrrbrbrbrr...".into(),
        };

        let db = MockDatabase::new(DbBackend::Postgres)
            .append_query_results([[model.clone()]])
            .into_connection();

        post::Entity::insert(model.into_active_model()).exec(&db)?;

        assert_eq!(
            db.into_transaction_log(),
            [Transaction::many([Statement::from_sql_and_values(
                DbBackend::Postgres,
                r#"INSERT INTO "posts" ("id", "title", "text") VALUES (CAST($1 AS TEXT), $2, $3) RETURNING CAST("id" AS INTEGER)"#,
                [
                    1.into(),
                    "News wrap up 2022".into(),
                    "brbrbrrrbrbrbrr...".into(),
                ]
            )])]
        );

        Ok(())
    }

    #[test]
    fn insert_9() -> Result<(), DbErr> {
        use crate::{DbBackend, MockDatabase, MockExecResult, Statement, Transaction};

        mod post {
            use crate as sea_orm;
            use crate::entity::prelude::*;

            #[derive(Clone, Debug, PartialEq, Eq, DeriveEntityModel)]
            #[sea_orm(table_name = "posts")]
            pub struct Model {
                #[sea_orm(
                    primary_key,
                    auto_increment = false,
                    select_as = "INTEGER",
                    save_as = "TEXT"
                )]
                pub id_primary: i32,
                #[sea_orm(
                    primary_key,
                    auto_increment = false,
                    select_as = "INTEGER",
                    save_as = "TEXT"
                )]
                pub id_secondary: i32,
                pub title: String,
                pub text: String,
            }

            #[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]
            pub enum Relation {}

            impl ActiveModelBehavior for ActiveModel {}
        }

        let model = post::Model {
            id_primary: 1,
            id_secondary: 1001,
            title: "News wrap up 2022".into(),
            text: "brbrbrrrbrbrbrr...".into(),
        };

        let db = MockDatabase::new(DbBackend::Postgres)
            .append_query_results([[model.clone()]])
            .into_connection();

        post::Entity::insert(model.into_active_model()).exec(&db)?;

        assert_eq!(
            db.into_transaction_log(),
            [Transaction::many([Statement::from_sql_and_values(
                DbBackend::Postgres,
                r#"INSERT INTO "posts" ("id_primary", "id_secondary", "title", "text") VALUES (CAST($1 AS TEXT), CAST($2 AS TEXT), $3, $4) RETURNING CAST("id_primary" AS INTEGER), CAST("id_secondary" AS INTEGER)"#,
                [
                    1.into(),
                    1001.into(),
                    "News wrap up 2022".into(),
                    "brbrbrrrbrbrbrr...".into(),
                ]
            )])]
        );

        Ok(())
    }
}
