Count calculate record count in table applied with filter.
(table string, availFields FieldMap, filter map[string]interface{})
| 165 | |
| 166 | // Count calculate record count in table applied with filter. |
| 167 | func Count(table string, availFields FieldMap, filter map[string]interface{}) ( |
| 168 | statement string, args []interface{}, fields FieldMap, err error) { |
| 169 | fields = FieldMap{} |
| 170 | statement = `SELECT COUNT(1) AS "cnt" FROM "` + table + `" ` |
| 171 | |
| 172 | // count filter statement |
| 173 | filterFields, filterStatement, filterArgs, err := ResolveFilter(filter, availFields) |
| 174 | if err != nil { |
| 175 | err = errors.Wrapf(err, "resolve query filter failed") |
| 176 | return |
| 177 | } |
| 178 | |
| 179 | fields.Merge(filterFields) |
| 180 | args = append(args, filterArgs...) |
| 181 | |
| 182 | if filterStatement != "" { |
| 183 | statement += " WHERE " |
| 184 | statement += filterStatement |
| 185 | } |
| 186 | |
| 187 | return |
| 188 | } |
no test coverage detected