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

import (
	dbutil947 "gitee.com/knowgo/gpa/rt/dbutil"
	errs694 "gitee.com/knowgo/gotool/errs"
	models "gitee.com/knowgo/gpa/examples/pratics/models"
	rt300 "gitee.com/knowgo/gpa/rt"
	sql47 "database/sql"
)

type Teacher struct {
	p *rt300.Provider
}

func (teacher *Teacher) InsertTeacher(name string) (*models.Teacher, error) {
	var2 := &models.Teacher{}
	var2.Name = name
	var err error
	var1 := `INSERT INTO teacher ("name") VALUES ($1) RETURNING id`
	var var3InsertID int64
	var var3 *sql47.Row
	var3 = teacher.p.Executor().QueryRow(var1, name)
	err = var3.Scan(&var3InsertID)
	var2.ID = int(var3InsertID)
	if err != nil {
		teacher.p.Logger.Error(errs694.WrapStack(err, "insert error"))
		return nil, err
	}
	return var2, nil 
}

func (teacher *Teacher) Insert1Teacher(tc *models.Teacher) (*models.Teacher, error) {
	var err error
	
	var3tp := dbutil947.NewTimeProp("DATETIME", true, teacher.p.GetTimezone())
	var3 := dbutil947.FormatColumnTime(teacher.p.GetTimeStampzFormat(),
		teacher.p.GetTimezone(),
		var3tp,
		tc.BirthDay)
	var var4 []byte
	var4, err = tc.Addr.Write()
	if err != nil {
		teacher.p.Logger.Error(errs694.WrapStack(err, ""))
		return nil, err
	}
	
	var1 := `INSERT INTO teacher ("name",birth_day,address,addr) VALUES ($1,$2,$3,$4) RETURNING id`
	var var2InsertID int64
	var var2 *sql47.Row
	var2 = teacher.p.Executor().QueryRow(var1, tc.Name, var3, tc.Address, var4)
	err = var2.Scan(&var2InsertID)
	tc.ID = int(var2InsertID)
	if err != nil {
		teacher.p.Logger.Error(errs694.WrapStack(err, "insert error"))
		return nil, err
	}
	return tc, nil 
}

func (teacher *Teacher) UpdateByID(tc *models.Teacher) error {
	var err error
	
	var var2tp *dbutil947.TimeProp
	var2tp = dbutil947.NewTimeProp("DATETIME", true, teacher.p.GetTimezone())
	var2 := dbutil947.FormatColumnTime(teacher.p.GetTimeStampzFormat(),
		teacher.p.GetTimezone(),
		var2tp,
		tc.BirthDay)
	var var3 []byte
	var3, err = tc.Addr.Write()
	if err != nil {
		teacher.p.Logger.Error(errs694.WrapStack(err, ""))
		return err
	}
	
	var1 := `UPDATE teacher SET "name"=$1,birth_day=$2,address=$3,addr=$4 WHERE "id"=$5 `
	var1Params := []interface{}{tc.Name, var2, tc.Address, var3}
	// where 参数 
	var1Params = append(var1Params, tc.ID)
	
	_, err = teacher.p.Executor().Exec(var1, var1Params...)
	if err != nil {
		teacher.p.Logger.Error(errs694.WrapStack(err, ""))
		return err
	}
	
	return nil
}