StructScan for insert / updates?

[nielskrijger]

Am I correct in saying there is no StructScan equivalent for insert/updates?

If not, does anyone know about a lib providing this for PGQ? (I'm not talking about ORM's which all seem to include query bulders, migrators etc)

[rahmatismail]

sqlx version: v1.3.5

You can use NamedExec / NamedExecContext. It uses bindNamedMapper to map the struct tag into your query. Although they are not 100% equivalent with StructScan because you need to state struct tag value on the query

type (
	Consultants struct {
		ConsultantName string `db:"ConsultantName"`
		Technology     string `db:"Technology"`
		HourlyRate     int64  `db:"HourlyRate"`
	}
)

func insertWithStruct() {
	db, err := sql.Open("yourDriverName", "user:password@tcp(127.0.0.1:3306)/tablename")
	if err != nil {
		log.Fatalln(err)
	}
	dbx := sqlx.NewDb(db, "yourDriverName")

	data := Consultants{
		ConsultantName: "name-go",
		Technology:     "go",
		HourlyRate:     1234,
	}
	res, err := dbx.NamedExec("insert into Consultants (ConsultantName, Technology, HourlyRate) values (:ConsultantName, :Technology, :HourlyRate)", data)
	if err != nil {
		log.Fatalln(err)
	}

	lastInsertID, err := res.LastInsertId()
	if err != nil {
		log.Fatalln(err)
	}
	rowsAffected, err := res.RowsAffected()
	if err != nil {
		log.Fatalln(err)
	}
	fmt.Printf("%d %d\n", lastInsertID, rowsAffected)
}