get_test.go

package sqlwrap_test

import (
	"context"
	"database/sql"

	"github.com/jtarchie/sqlwrap"
	. "github.com/onsi/ginkgo/v2"
	. "github.com/onsi/gomega"
)

var _ = Describe("Get", func() {
	var client *sqlwrap.Client

	BeforeEach(func() {
		var err error

		client, err = createClient()
		Expect(err).NotTo(HaveOccurred())
	})

	AfterEach(func() {
		err := client.Close()
		Expect(err).NotTo(HaveOccurred())
	})

	It("bind with named parameters", func() {
		var firstName string

		err := client.Get(
			context.Background(),
			&firstName,
			"SELECT first_name FROM people WHERE email = :email",
			map[string]interface{}{
				"email": "bob@smith.com",
			},
		)
		Expect(err).NotTo(HaveOccurred())
		Expect(firstName).To(Equal("Bob"))
	})

	It("errors on missing values for bind params", func() {
		var firstName string

		err := client.Get(
			context.Background(),
			&firstName,
			"SELECT first_name FROM people WHERE email = :email",
			map[string]interface{}{},
		)
		Expect(err).To(HaveOccurred())
	})

	It("errors when binding is missing", func() {
		var firstName string

		err := client.Get(
			context.Background(),
			&firstName,
			"SELECT first_name FROM people WHERE email = :email",
			map[string]interface{}{},
		)
		Expect(err).To(HaveOccurred())
	})

	It("can handle IN clauses", func() {
		var firstName string

		err := client.Get(
			context.Background(),
			&firstName,
			"SELECT first_name FROM people WHERE email IN (:email)",
			map[string]interface{}{
				"email": sqlwrap.Values{"bob@smith.com"},
			},
		)
		Expect(err).NotTo(HaveOccurred())
		Expect(firstName).To(Equal("Bob"))

		row := client.QueryRowContext(
			context.Background(),
			"SELECT first_name FROM people WHERE email = :email",
			sql.Named("email", "bob@smith.com"),
		)

		err = row.Scan(&firstName)
		Expect(err).NotTo(HaveOccurred())
		Expect(firstName).To(Equal("Bob"))
	})

	It("errors with missing params of IN clauses", func() {
		var firstName string

		err := client.Get(
			context.Background(),
			&firstName,
			"SELECT first_name FROM people WHERE email IN (:email)",
			map[string]interface{}{},
		)
		Expect(err).To(HaveOccurred())
	})
})