session_iterate.go 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. // Copyright 2016 The Xorm Authors. All rights reserved.
  2. // Use of this source code is governed by a BSD-style
  3. // license that can be found in the LICENSE file.
  4. package xorm
  5. import "reflect"
  6. // IterFunc only use by Iterate
  7. type IterFunc func(idx int, bean interface{}) error
  8. // Rows return sql.Rows compatible Rows obj, as a forward Iterator object for iterating record by record, bean's non-empty fields
  9. // are conditions.
  10. func (session *Session) Rows(bean interface{}) (*Rows, error) {
  11. return newRows(session, bean)
  12. }
  13. // Iterate record by record handle records from table, condiBeans's non-empty fields
  14. // are conditions. beans could be []Struct, []*Struct, map[int64]Struct
  15. // map[int64]*Struct
  16. func (session *Session) Iterate(bean interface{}, fun IterFunc) error {
  17. if session.isAutoClose {
  18. defer session.Close()
  19. }
  20. rows, err := session.Rows(bean)
  21. if err != nil {
  22. return err
  23. }
  24. defer rows.Close()
  25. i := 0
  26. for rows.Next() {
  27. b := reflect.New(rows.beanType).Interface()
  28. err = rows.Scan(b)
  29. if err != nil {
  30. return err
  31. }
  32. err = fun(i, b)
  33. if err != nil {
  34. return err
  35. }
  36. i++
  37. }
  38. return err
  39. }