func verifyNoActivity(db *pg.DB) error {
var queries pg.Strings
_, err := db.Query(&queries, `
SELECT query FROM pg_stat_activity WHERE datname = 'test'
`)
if err != nil {
return err
}
if len(queries) > 1 {
return fmt.Errorf("there are %d active queries running: %#v", len(queries), queries)
}
return nil
}
var db *pg.DB
BeforeEach(func() {
db = pg.Connect(pgOptions())
})
AfterEach(func() {
Expect(db.Close()).NotTo(HaveOccurred())
})
It("supports slice of structs", func() {
coll := []struct {
Id int
}{}
_, err := db.Query(&coll, `
WITH data (id) AS (VALUES (1), (2), (3))
SELECT id FROM data
`)
Expect(err).NotTo(HaveOccurred())
Expect(coll).To(HaveLen(3))
Expect(coll[0].Id).To(Equal(1))
Expect(coll[1].Id).To(Equal(2))
Expect(coll[2].Id).To(Equal(3))
})
It("supports slice of pointers", func() {
coll := []*struct {
Id int
}{}
_, err := db.Query(&coll, `
WITH data (id) AS (VALUES (1), (2), (3))
SELECT id FROM data
