//+gpa-ignore
// DO NOT EDIT THIS FILE
// Generated by mro at 2022-04-12 16:29:08
package postgres

import (
	dbutil237 "gitee.com/knowgo/gpa/rt/dbutil"
	errs59 "gitee.com/knowgo/gotool/errs"
	models "gitee.com/knowgo/gpa/examples/pratics/models"
	rt847 "gitee.com/knowgo/gpa/rt"
	sql445 "database/sql"
)

type Delete struct {
	p *rt847.Provider
}

func (delete *Delete) DeleteByName(user *models.User, gender bool) (int64, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE "name"=$1 `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.Name)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, err
	}
	return var3, nil
}

func (delete *Delete) DeleteByAgeAndCret(user *models.User) (int64, *models.User, error) {
	var err error
	
	
	var4tp := dbutil237.NewTimeProp("DATETIME", true, delete.p.GetTimezone())
	var4 := dbutil237.FormatColumnTime(delete.p.GetTimeStampzFormat(),
		delete.p.GetTimezone(),
		var4tp,
		user.Cret)
	var1 := `DELETE FROM "user" WHERE age=$1 And cret=$2 `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.Age)
	var1Params = append(var1Params, var4)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, nil, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, nil, err
	}
	return var3, nil, nil
}

func (delete *Delete) DeleteXByAge(age int, URL string) (int64, models.User, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE age=$1 `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, age)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, models.User{}, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, models.User{}, err
	}
	return var3, models.User{}, nil
}

func (delete *Delete) DeleteName(user *models.User, name string, ages []int) (int64, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE id=$1 and age in (@in-1649752149)`
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.ID)
	if len(ages) <= 0 {
		err = dbutil237.NewErrParamIsEmpty("ages")
		delete.p.Logger.Error(errs59.WrapStack(err, ""))
		return 0, err
	}
	var1 = dbutil237.TakeDollarPlaceHolder(var1, "@in-1649752149", len(ages), len(var1Params))
	for _, varP := range ages {
		var1Params = append(var1Params, varP)
	}
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, err
	}
	return var3, nil
}

func (delete *Delete) DeleteXName(user *models.User, name string) (int64, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE id = $1 and age>$2`
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.ID)
	var1Params = append(var1Params, user.Age)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, err
	}
	return var3, nil
}

func (delete *Delete) DeleteAll() (int64, models.User, error) {
	var err error
	var1 := `DELETE FROM "user"`
	var var1Params []interface{}
	// where 参数 
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, models.User{}, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, models.User{}, err
	}
	return var3, models.User{}, nil
}

func (delete *Delete) Delete1Name(id uint64) (int64, models.User, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE id=$1`
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, id)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, models.User{}, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, models.User{}, err
	}
	return var3, models.User{}, nil
}

func (delete *Delete) Delete2Name(user models.User, id uint64) (int64, error) {
	var err error
	var1 := `DELETE FROM "user" WHERE id=$1`
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, id)
	var var2 sql445.Result
	var2, err = delete.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return 0, err
	}
	var3, err := var2.RowsAffected()
	if err != nil {
		delete.p.Logger.Error(errs59.WrapStack(err, "delete error"))
		return var3, err
	}
	return var3, nil
}