Golang SQL insert row and get returning ID example

insert.go

func InsertOrder(order *Order) (int, error) {
	var id int

	tx, err := db.Begin()

	if err != nil {
		return id, err
	}

	{
		stmt, err := tx.Prepare(`INSERT INTO orders(
			foo,
			bar
		) VALUES($1, $2)
		RETURNING id`)

		if err != nil {
			return id, err
		}

		defer stmt.Close()

		err = stmt.QueryRow(
			order.Foo,
			order.Bar,
		).Scan(&id)

		if err != nil {
			return id, err
		}
	}

	{
		err := tx.Commit()

		if err != nil {
			return id, err
		}
	}

	return id, nil
}