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

import (
	dbutil211 "gitee.com/knowgo/gpa/rt/dbutil"
	errs887 "gitee.com/knowgo/gotool/errs"
	models "gitee.com/knowgo/gpa/examples/pratics/models"
	rt81 "gitee.com/knowgo/gpa/rt"
)

type Count struct {
	p *rt81.Provider
}

func (count *Count) CountByName(user models.User) (int64, models.User, error) {
	var err error
	var1 := `SELECT count(0) FROM "user" WHERE "name"=$1  `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.Name)
	var2 := count.p.Executor().QueryRow(var1, var1Params...)
	var var3 int64
	err = var2.Scan(&var3)
	if err != nil {
		count.p.Logger.Error(errs887.WrapStack(err, "count error"))
		return 0, models.User{}, err
	}
	return var3, models.User{}, nil
}

func (count *Count) CountName(user *models.User, name string) (int64, error) {
	var err error
	var1 := `SELECT count(*) FROM "user" WHERE id=$1 and age>$2 `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.ID)
	var1Params = append(var1Params, user.Age)
	var2 := count.p.Executor().QueryRow(var1, var1Params...)
	var var3 int64
	err = var2.Scan(&var3)
	if err != nil {
		count.p.Logger.Error(errs887.WrapStack(err, "count error"))
		return 0, err
	}
	return var3, nil
}

func (count *Count) CountXName(user *models.User, name string, ids []uint64) (int64, error) {
	var err error
	var1 := `SELECT count(1) FROM "user" WHERE id in (@in-1649752149) and age>$1 `
	var var1Params []interface{}
	// where 参数 
	var1Params = append(var1Params, user.Age)
	if len(ids) <= 0 {
		err = dbutil211.NewErrParamIsEmpty("ids")
		count.p.Logger.Error(errs887.WrapStack(err, ""))
		return 0, err
	}
	var1 = dbutil211.TakeDollarPlaceHolder(var1, "@in-1649752149", len(ids), len(var1Params))
	for _, varP := range ids {
		var1Params = append(var1Params, varP)
	}
	var2 := count.p.Executor().QueryRow(var1, var1Params...)
	var var3 int64
	err = var2.Scan(&var3)
	if err != nil {
		count.p.Logger.Error(errs887.WrapStack(err, "count error"))
		return 0, err
	}
	return var3, nil
}