Function AddFilterToQuery

db/sql/sql.go:1241–1286

(s *schema.Schema, q sq.SelectBuilder, filter map[string]interface{}, join bool)

)

func AddFilterToQuery(s *schema.Schema, q sq.SelectBuilder, filter map[string]interface{}, join bool) (sq.SelectBuilder, error) {
	if filter == nil {
		return q, nil
	}
	for key, value := range filter {
		if key == OrCondition {
			orFilter, err := addOrToQuery(s, q, value, join)
			if err != nil {
				return q, err
			}
			q = q.Where(orFilter)
			continue
		} else if key == AndCondition {
			andFilter, err := addAndToQuery(s, q, value, join)
			if err != nil {
				return q, err
			}
			q = q.Where(andFilter)
			continue
		}
		property, err := s.GetPropertyByID(key)

		if err != nil {
			return q, err
		}

		var column string
		if join {
			column = makeColumn(s.GetDbTableName(), *property)
		} else {
			column = quote(key)
		}

		queryValues, ok := value.([]string)
		if ok && property.Type == "boolean" {
			v := make([]bool, len(queryValues))
			for i, j := range queryValues {
				v[i], _ = strconv.ParseBool(j)
			}
			q = q.Where(sq.Eq{column: v})
		} else {
			q = q.Where(sq.Eq{column: value})
		}
	}
	return q, nil
}

func addOrToQuery(s *schema.Schema, q sq.SelectBuilder, filter interface{}, join bool) (sq.Or, error) {
	return addToFilter(s, q, filter, join, sq.Or{})