Remove process remove query with filter like a mongodb.
(table string, availFields FieldMap, filter map[string]interface{}, justOne bool)
| 136 | |
| 137 | // Remove process remove query with filter like a mongodb. |
| 138 | func Remove(table string, availFields FieldMap, filter map[string]interface{}, justOne bool) ( |
| 139 | statement string, args []interface{}, fields FieldMap, err error) { |
| 140 | fields = FieldMap{} |
| 141 | |
| 142 | statement = `DELETE FROM "` + table + `" ` |
| 143 | |
| 144 | // delete filter statement |
| 145 | filterFields, filterStatement, filterArgs, err := ResolveFilter(filter, availFields) |
| 146 | if err != nil { |
| 147 | err = errors.Wrapf(err, "resolve query filter failed") |
| 148 | return |
| 149 | } |
| 150 | |
| 151 | fields.Merge(filterFields) |
| 152 | args = append(args, filterArgs...) |
| 153 | |
| 154 | if filterStatement != "" { |
| 155 | statement += " WHERE " |
| 156 | statement += filterStatement |
| 157 | } |
| 158 | |
| 159 | if justOne { |
| 160 | statement += " LIMIT 1" |
| 161 | } |
| 162 | |
| 163 | return |
| 164 | } |
| 165 | |
| 166 | // Count calculate record count in table applied with filter. |
| 167 | func Count(table string, availFields FieldMap, filter map[string]interface{}) ( |
no test coverage detected