Method TestNonTrivialSubqueries

adapter/postgresql/postgresql_test.go:1315–1403

()

}

func (s *AdapterTests) TestNonTrivialSubqueries() {
	sess := s.Session()

	// Creating test data
	artist := sess.Collection("artist")

	artistNames := []string{"Ozzie", "Flea", "Slash", "Chrono"}
	for _, artistName := range artistNames {
		_, err := artist.Insert(map[string]string{
			"name": artistName,
		})
		s.NoError(err)
	}

	{
		q, err := sess.SQL().Query(`WITH test AS (?) ?`,
			sess.SQL().Select("id AS foo").From("artist"),
			sess.SQL().Select("foo").From("test").Where("foo > ?", 0),
		)

		s.NoError(err)
		s.NotNil(q)

		s.True(q.Next())

		var number int
		s.NoError(q.Scan(&number))

		s.Equal(1, number)
		s.NoError(q.Close())
	}

	{
		builder := sess.SQL()
		row, err := builder.QueryRow(`WITH test AS (?) ?`,
			builder.Select("id AS foo").From("artist"),
			builder.Select("foo").From("test").Where("foo > ?", 0),
		)

		s.NoError(err)
		s.NotNil(row)

		var number int
		s.NoError(row.Scan(&number))

		s.Equal(1, number)
	}

	{
		res, err := sess.SQL().Exec(
			`UPDATE artist a1 SET id = ?`,
			sess.SQL().Select(db.Raw("id + 5")).
				From("artist a2").
				Where("a2.id = a1.id"),
		)

		s.NoError(err)
		s.NotNil(res)