pipeline_test.go

package pgx_test

import (
	"context"
	"testing"

	"github.com/jackc/pgx/v5"
	"github.com/jackc/pgx/v5/pgconn"
	"github.com/stretchr/testify/require"
)

func TestPipelineWithoutPreparedOrDescribedStatements(t *testing.T) {
	t.Parallel()

	defaultConnTestRunner.RunTest(context.Background(), t, func(ctx context.Context, t testing.TB, conn *pgx.Conn) {
		pipeline := conn.PgConn().StartPipeline(ctx)

		eqb := pgx.ExtendedQueryBuilder{}

		err := eqb.Build(conn.TypeMap(), nil, []any{1, 2})
		require.NoError(t, err)
		pipeline.SendQueryParams(`select $1::bigint + $2::bigint`, eqb.ParamValues, nil, eqb.ParamFormats, eqb.ResultFormats)

		err = eqb.Build(conn.TypeMap(), nil, []any{3, 4, 5})
		require.NoError(t, err)
		pipeline.SendQueryParams(`select $1::bigint + $2::bigint + $3::bigint`, eqb.ParamValues, nil, eqb.ParamFormats, eqb.ResultFormats)

		err = pipeline.Sync()
		require.NoError(t, err)

		results, err := pipeline.GetResults()
		require.NoError(t, err)
		rr, ok := results.(*pgconn.ResultReader)
		require.True(t, ok)
		rows := pgx.RowsFromResultReader(conn.TypeMap(), rr)

		rowCount := 0
		var n int64
		for rows.Next() {
			err = rows.Scan(&n)
			require.NoError(t, err)
			rowCount++
		}
		require.NoError(t, rows.Err())
		require.Equal(t, 1, rowCount)
		require.Equal(t, "SELECT 1", rows.CommandTag().String())
		require.EqualValues(t, 3, n)

		results, err = pipeline.GetResults()
		require.NoError(t, err)
		rr, ok = results.(*pgconn.ResultReader)
		require.True(t, ok)
		rows = pgx.RowsFromResultReader(conn.TypeMap(), rr)

		rowCount = 0
		n = 0
		for rows.Next() {
			err = rows.Scan(&n)
			require.NoError(t, err)
			rowCount++
		}
		require.NoError(t, rows.Err())
		require.Equal(t, 1, rowCount)
		require.Equal(t, "SELECT 1", rows.CommandTag().String())
		require.EqualValues(t, 12, n)

		results, err = pipeline.GetResults()
		require.NoError(t, err)
		_, ok = results.(*pgconn.PipelineSync)
		require.True(t, ok)

		results, err = pipeline.GetResults()
		require.NoError(t, err)
		require.Nil(t, results)

		err = pipeline.Close()
		require.NoError(t, err)
	})
}