| 319 | } |
| 320 | |
| 321 | func TestQuery_JSONBExistsAnyOperator(t *testing.T) { |
| 322 | // Test the ?| operator (any key exists) |
| 323 | q := Q().Space("DELETE FROM issue_comment"). |
| 324 | Where("(payload->'taskUpdate')??|'{toEarliestAllowedTime, fromEarliestAllowedTime}'") |
| 325 | sql, args, err := q.ToSQL() |
| 326 | require.NoError(t, err) |
| 327 | require.Equal(t, "DELETE FROM issue_comment WHERE (payload->'taskUpdate')?|'{toEarliestAllowedTime, fromEarliestAllowedTime}'", sql) |
| 328 | require.Empty(t, args) |
| 329 | } |
| 330 | |
| 331 | func TestQuery_JSONBExistsAllOperator(t *testing.T) { |
| 332 | // Test the ?& operator (all keys exist) |