sqlc-dev
diff --git a/‎examples/batch/postgresql/db_test.go
Lines changed: 1 addition & 1 deletion b/‎examples/batch/postgresql/db_test.go
Lines changed: 1 addition & 1 deletion
diff --git a/‎examples/booktest/postgresql/db_test.go
Lines changed: 2 additions & 2 deletions b/‎examples/booktest/postgresql/db_test.go
Lines changed: 2 additions & 2 deletions
diff --git a/‎examples/ondeck/postgresql/city.sql.go
Lines changed: 7 additions & 4 deletions b/‎examples/ondeck/postgresql/city.sql.go
Lines changed: 7 additions & 4 deletions
diff --git a/‎examples/ondeck/postgresql/db.go
Lines changed: 155 additions & 9 deletions b/‎examples/ondeck/postgresql/db.go
Lines changed: 155 additions & 9 deletions
diff --git a/‎examples/ondeck/postgresql/db_test.go
Lines changed: 22 additions & 4 deletions b/‎examples/ondeck/postgresql/db_test.go
Lines changed: 22 additions & 4 deletions
diff --git a/‎examples/ondeck/postgresql/models.go
Lines changed: 9 additions & 9 deletions b/‎examples/ondeck/postgresql/models.go
Lines changed: 9 additions & 9 deletions
@@ -32,7 +32,7 @@ func TestBatchBooks(t *testing.T) {
 		t.Fatal(err)
 	}
 
-	now := pgtype.Timestamptz{Time: time.Now()}
+	now := pgtype.Timestamptz{Time: time.Now(), Valid: true}
 
 	// batch insert new books
 	newBooksParams := []CreateBookParams{
 
@@ -16,7 +16,7 @@ import (
 
 func TestBooks(t *testing.T) {
 	ctx := context.Background()
-	uri := hosted.PostgreSQL(t, []string{"schema"})
+	uri := hosted.PostgreSQL(t, []string{"schema.sql"})
 	db, err := pgx.Connect(ctx, uri)
 	if err != nil {
 		t.Fatal(err)
@@ -40,7 +40,7 @@ func TestBooks(t *testing.T) {
 	tq := dq.WithTx(tx)
 
 	// save first book
-	now := pgtype.Timestamptz{Time: time.Now()}
+	now := pgtype.Timestamptz{Time: time.Now(), Valid: true}
 	_, err = tq.CreateBook(ctx, CreateBookParams{
 		AuthorID:  a.AuthorID,
 		Isbn:      "1",
 
@@ -5,10 +5,11 @@ package ondeck
 
 import (
 	"context"
+	"database/sql"
 	"testing"
 
 	"github.com/google/go-cmp/cmp"
-	"github.com/jackc/pgx/v5"
+	_ "github.com/lib/pq"
 
 	"github.com/sqlc-dev/sqlc/internal/sqltest/hosted"
 )
@@ -122,16 +123,33 @@ func runOnDeckQueries(t *testing.T, q *Queries) {
 	}
 }
 
+func TestPrepared(t *testing.T) {
+	t.Parallel()
+
+	uri := hosted.PostgreSQL(t, []string{"schema"})
+	db, err := sql.Open("postgres", uri)
+	if err != nil {
+		t.Fatal(err)
+	}
+	defer db.Close()
+
+	q, err := Prepare(context.Background(), db)
+	if err != nil {
+		t.Fatal(err)
+	}
+
+	runOnDeckQueries(t, q)
+}
+
 func TestQueries(t *testing.T) {
 	t.Parallel()
 
-	ctx := context.Background()
 	uri := hosted.PostgreSQL(t, []string{"schema"})
-	db, err := pgx.Connect(ctx, uri)
+	db, err := sql.Open("postgres", uri)
 	if err != nil {
 		t.Fatal(err)
 	}
-	defer db.Close(ctx)
+	defer db.Close()
 
 	runOnDeckQueries(t, New(db))
 }
Original file line number	Diff line number	Diff line change
`@@ -32,7 +32,7 @@ func TestBatchBooks(t *testing.T) {`
`32`	`32`	`t.Fatal(err)`
`33`	`33`	`}`
`34`	`34`
`35`		`- now := pgtype.Timestamptz{Time: time.Now()}`
	`35`	`+ now := pgtype.Timestamptz{Time: time.Now(), Valid: true}`
`36`	`36`
`37`	`37`	`// batch insert new books`
`38`	`38`	`newBooksParams := []CreateBookParams{`