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

import (
	context "context"
	dbutil258 "gitee.com/knowgo/gpa/rt/dbutil"
	errs456 "gitee.com/knowgo/gotool/errs"
	models "gitee.com/knowgo/gpa/examples/pratics/models"
	rt540 "gitee.com/knowgo/gpa/rt"
)

type UserRepo struct {
	p *rt540.Provider
}

func (userRepo *UserRepo) Insert(ctx context.Context, user *models.User, name string) (*models.User, error) {
	user.Name = name
	var err error
	
	var2tp := dbutil258.NewTimeProp("DATETIME", true, userRepo.p.GetTimezone())
	var2 := dbutil258.FormatColumnTime(userRepo.p.GetTimeStampzFormat(),
		userRepo.p.GetTimezone(),
		var2tp,
		user.Cret)
	var1 := `INSERT INTO "user" ("id","name",age,gender,oka_us_url,cret,url) VALUES ($1,$2,$3,$4,$5,$6,$7)`
	
	_, err = userRepo.p.Executor().ExecContext(ctx, var1, user.ID, user.Name, user.Age, user.Gender, user.OkaUsURL, var2, user.URL)
	if err != nil {
		userRepo.p.Logger.Error(errs456.WrapStack(err, "insert error"))
		return nil, err
	}
	return user, nil 
}

func (userRepo *UserRepo) InsertA(user *models.User) error {
	var err error
	
	var2tp := dbutil258.NewTimeProp("DATETIME", true, userRepo.p.GetTimezone())
	var2 := dbutil258.FormatColumnTime(userRepo.p.GetTimeStampzFormat(),
		userRepo.p.GetTimezone(),
		var2tp,
		user.Cret)
	var1 := `INSERT INTO "user" ("id","name",age,gender,oka_us_url,cret,url) VALUES ($1,$2,$3,$4,$5,$6,$7)`
	
	_, err = userRepo.p.Executor().Exec(var1, user.ID, user.Name, user.Age, user.Gender, user.OkaUsURL, var2, user.URL)
	if err != nil {
		userRepo.p.Logger.Error(errs456.WrapStack(err, "insert error"))
		return err
	}
	return nil 
}

func (userRepo *UserRepo) InsertB(user *models.User, name string, URL string) (models.User, error) {
	user.Name = name
	user.URL = URL
	var err error
	
	var2tp := dbutil258.NewTimeProp("DATETIME", true, userRepo.p.GetTimezone())
	var2 := dbutil258.FormatColumnTime(userRepo.p.GetTimeStampzFormat(),
		userRepo.p.GetTimezone(),
		var2tp,
		user.Cret)
	var1 := `INSERT INTO "user" ("id","name",age,gender,oka_us_url,cret,url) VALUES ($1,$2,$3,$4,$5,$6,$7)`
	
	_, err = userRepo.p.Executor().Exec(var1, user.ID, user.Name, user.Age, user.Gender, user.OkaUsURL, var2, user.URL)
	if err != nil {
		userRepo.p.Logger.Error(errs456.WrapStack(err, "insert error"))
		return models.User{}, err
	}
	return *user, nil 
}

func (userRepo *UserRepo) InsertC(user *models.User) (*models.User, error) {
	var err error
	
	var2tp := dbutil258.NewTimeProp("DATETIME", true, userRepo.p.GetTimezone())
	var2 := dbutil258.FormatColumnTime(userRepo.p.GetTimeStampzFormat(),
		userRepo.p.GetTimezone(),
		var2tp,
		user.Cret)
	var1 := `INSERT INTO "user" ("id","name",age,gender,oka_us_url,cret,url) VALUES ($1,$2,$3,$4,$5,$6,$7)`
	
	_, err = userRepo.p.Executor().Exec(var1, user.ID, user.Name, user.Age, user.Gender, user.OkaUsURL, var2, user.URL)
	if err != nil {
		userRepo.p.Logger.Error(errs456.WrapStack(err, "insert error"))
		return nil, err
	}
	return user, nil 
}

func (userRepo *UserRepo) InsertUser(name string) (*models.User, error) {
	var2 := &models.User{}
	var2.Name = name
	var err error
	var1 := `INSERT INTO "user" ("name") VALUES ($1)`
	
	_, err = userRepo.p.Executor().Exec(var1, name)
	if err != nil {
		userRepo.p.Logger.Error(errs456.WrapStack(err, "insert error"))
		return nil, err
	}
	return var2, nil 
}