Method TestSession

internal/testsuite/sql_suite.go:1704–1807

()

}

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

	var all []map[string]interface{}

	err := sess.Collection("artist").Truncate()
	s.NoError(err)

	_, err = sess.SQL().InsertInto("artist").Values(struct {
		Name string `db:"name"`
	}{"Rinko Kikuchi"}).Exec()
	s.NoError(err)

	// Using explicit iterator.
	iter := sess.SQL().SelectFrom("artist").Iterator()
	err = iter.All(&all)

	s.NoError(err)
	s.NotZero(all)

	// Using explicit iterator to fetch one item.
	var item map[string]interface{}
	iter = sess.SQL().SelectFrom("artist").Iterator()
	err = iter.One(&item)

	s.NoError(err)
	s.NotZero(item)

	// Using explicit iterator and NextScan.
	iter = sess.SQL().SelectFrom("artist").Iterator()
	var id int
	var name string

	if s.Adapter() == "ql" {
		err = iter.NextScan(&name)
		id = 1
	} else {
		err = iter.NextScan(&id, &name)
	}

	s.NoError(err)
	s.NotZero(id)
	s.NotEmpty(name)
	s.NoError(iter.Close())

	err = iter.NextScan(&id, &name)
	s.Error(err)

	// Using explicit iterator and ScanOne.
	iter = sess.SQL().SelectFrom("artist").Iterator()
	id, name = 0, ""
	if s.Adapter() == "ql" {
		err = iter.ScanOne(&name)
		id = 1
	} else {
		err = iter.ScanOne(&id, &name)
	}