| 26 | } |
| 27 | |
| 28 | func generateDelete(msg message.DeleteRecord) string { |
| 29 | var sb strings.Builder |
| 30 | |
| 31 | sb.WriteString("DELETE FROM ") |
| 32 | sb.WriteString("\"" + msg.TableName + "\"") |
| 33 | sb.WriteString(" WHERE ") |
| 34 | if len(msg.WhereClause) == 0 { |
| 35 | sb.WriteString("1") |
| 36 | } else { |
| 37 | for i, predicateGroup := range msg.WhereClause { |
| 38 | if len(predicateGroup.Predicates) == 0 { |
| 39 | continue |
| 40 | } |
| 41 | sb.WriteString("(") |
| 42 | for j, predicate := range predicateGroup.Predicates { |
| 43 | if j > 0 { |
| 44 | sb.WriteString(" ") |
| 45 | sb.WriteString(predicateGroup.GroupingType) |
| 46 | sb.WriteString(" ") |
| 47 | } |
| 48 | sb.WriteString("\"" + predicate.Column + "\"") |
| 49 | sb.WriteString(" = ?") |
| 50 | } |
| 51 | sb.WriteString(")") |
| 52 | if i < len(msg.WhereClause)-1 { |
| 53 | sb.WriteString(" AND ") |
| 54 | } |
| 55 | } |
| 56 | } |
| 57 | |
| 58 | return sb.String() |
| 59 | } |
| 60 | |
| 61 | func extractPredicateValues(where message.PredicateGroups) ([]any, error) { |
| 62 | predicateCount := 0 |