MCPcopy Create free account
hub / github.com/tobymao/sqlglot / test_non_expression_leaf_delta

Method test_non_expression_leaf_delta

tests/test_diff.py:310–346  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

308 self.assertEqual(["WARNING:sqlglot:Dummy warning"], cm.output)
309
310 def test_non_expression_leaf_delta(self):
311 expr_src = parse_one("SELECT a UNION SELECT b")
312 expr_tgt = parse_one("SELECT a UNION ALL SELECT b")
313
314 self._validate_delta_only(
315 diff_delta_only(expr_src, expr_tgt),
316 [
317 Update(source=expr_src, target=expr_tgt),
318 ],
319 )
320
321 expr_src = parse_one("SELECT a FROM t ORDER BY b ASC")
322 expr_tgt = parse_one("SELECT a FROM t ORDER BY b DESC")
323
324 self._validate_delta_only(
325 diff_delta_only(expr_src, expr_tgt),
326 [
327 Update(
328 source=expr_src.find(exp.Order).expressions[0],
329 target=expr_tgt.find(exp.Order).expressions[0],
330 ),
331 ],
332 )
333
334 expr_src = parse_one("SELECT a, b FROM t ORDER BY c ASC")
335 expr_tgt = parse_one("SELECT b, a FROM t ORDER BY c DESC")
336
337 self._validate_delta_only(
338 diff_delta_only(expr_src, expr_tgt),
339 [
340 Update(
341 source=expr_src.find(exp.Order).expressions[0],
342 target=expr_tgt.find(exp.Order).expressions[0],
343 ),
344 Move(source=expr_src.selects[0], target=expr_tgt.selects[1]),
345 ],
346 )
347
348 def test_none_args_are_not_treated_as_leaves(self):
349 expr_src = exp.Column(

Callers

nothing calls this directly

Calls 6

_validate_delta_onlyMethod · 0.95
parse_oneFunction · 0.90
UpdateClass · 0.90
MoveClass · 0.90
diff_delta_onlyFunction · 0.85
findMethod · 0.45

Tested by

no test coverage detected