Golang Tx.NamedQuery Examples

Example #1

File: conveyor.go Project: emmetog/conveyor

func insert(tx *sqlx.Tx, sql string, v interface{}, id *string) error {
	rows, err := tx.NamedQuery(sql, v)
	if err != nil {
		return err
	}
	defer rows.Close()
	if rows.Next() {
		rows.Scan(id)
	} else {
		panic("expected id to be returned")
	}
	return nil
}

Example #2

File: conveyor.go Project: atmos/conveyor

func insert(tx *sqlx.Tx, sql string, v interface{}, returns ...interface{}) error {
	rows, err := tx.NamedQuery(sql, v)
	if err != nil {
		return err
	}
	defer rows.Close()
	if rows.Next() {
		for _, r := range returns {
			rows.Scan(r)
		}
	} else {
		panic("expected id to be returned")
	}
	return nil
}