Method TestSelectFromSubquery

internal/testsuite/sql_suite.go:1948–1977

()

}

func (s *SQLTestSuite) TestSelectFromSubquery() {
	sess := s.Session()

	{
		var artists []artistType
		q := sess.SQL().SelectFrom(
			sess.SQL().SelectFrom("artist").Where(db.Cond{
				"name": db.IsNotNull(),
			}),
		).As("_q")
		err := q.All(&artists)
		s.NoError(err)

		s.NotZero(len(artists))
	}

	{
		var artists []artistType
		q := sess.SQL().SelectFrom(
			sess.Collection("artist").Find(db.Cond{
				"name": db.IsNotNull(),
			}),
		).As("_q")
		err := q.All(&artists)
		s.NoError(err)

		s.NotZero(len(artists))
	}

}