Skip to content

A reactive notebook for Python — run reproducible experiments, query with SQL, execute as a script, deploy as an app, and version with git. Stored as pure Python. All in a modern, AI-native editor.

25.1 KB
Raw Blame
# Copyright 2026 Marimo. All rights reserved.
from __future__ import annotations

from dataclasses import dataclass
from functools import partial
from typing import TYPE_CHECKING

import pytest

from marimo._ast import compiler
from marimo._dependencies.dependencies import DependencyManager
from marimo._runtime import dataflow
from marimo._types.ids import CellId_t

parse_cell = partial(compiler.compile_cell, cell_id=CellId_t("0"))

HAS_DUCKDB = DependencyManager.duckdb.has()

if TYPE_CHECKING:
    from collections.abc import Iterable


class KnownFailure(Exception):
    """An expected failure in a test case."""


@dataclass
class GraphTestCase:
    """A test case for dataflow graph operations."""

    # Test description
    name: str

    # If enabled

    # Code to create and register
    code: dict[str, str]

    # Expected graph structure
    expected_parents: dict[str, Iterable[str]] | None = None
    expected_children: dict[str, Iterable[str]] | None = None
    expected_stale: Iterable[str] | None = None

    # Expected refs/defs
    expected_refs: dict[str, Iterable[str]] | None = None
    expected_defs: dict[str, Iterable[str]] | None = None

    enabled: bool = True
    xfail: bool | str = False

    def __post_init__(self) -> None:
        # Convert all to a []
        if self.expected_parents is not None:
            self.expected_parents = {
                cell_id: set(parents)
                for cell_id, parents in self.expected_parents.items()
            }
        if self.expected_children is not None:
            self.expected_children = {
                cell_id: set(children)
                for cell_id, children in self.expected_children.items()
            }
        if self.expected_stale is not None:
            self.expected_stale = set(self.expected_stale)
        if self.expected_refs is not None:
            self.expected_refs = {
                cell_id: set(refs)
                for cell_id, refs in self.expected_refs.items()
            }
        if self.expected_defs is not None:
            self.expected_defs = {
                cell_id: set(defs)
                for cell_id, defs in self.expected_defs.items()
            }


PYTHON_CASES = [
    # Basic Python Cases
    GraphTestCase(
        name="single node",
        code={"0": "x = 0"},
        expected_parents={"0": []},
        expected_children={"0": []},
        expected_refs={"0": []},
        expected_defs={"0": ["x"]},
    ),
    GraphTestCase(
        name="chain",
        code={"0": "x = 0", "1": "y = x", "2": "z = y\nzz = x"},
        expected_parents={"0": [], "1": ["0"], "2": ["0", "1"]},
        expected_children={"0": ["1", "2"], "1": ["2"], "2": []},
        expected_refs={"0": [], "1": ["x"], "2": ["x", "y"]},
        expected_defs={
            "0": ["x"],
            "1": ["y"],
            "2": ["z", "zz"],
        },
    ),
    GraphTestCase(
        name="cycle",
        code={"0": "x = y", "1": "y = x"},
        expected_parents={"0": ["1"], "1": ["0"]},
        expected_children={"0": ["1"], "1": ["0"]},
        expected_refs={"0": ["y"], "1": ["x"]},
        expected_defs={"0": ["x"], "1": ["y"]},
    ),
    GraphTestCase(
        name="diamond",
        code={
            "0": "x = 0",
            "1": "y = x",
            "2": "z = y\nzz = x",
            "3": "a = z",
        },
        expected_parents={
            "0": [],
            "1": ["0"],
            "2": ["0", "1"],
            "3": ["2"],
        },
        expected_children={
            "0": ["1", "2"],
            "1": ["2"],
            "2": ["3"],
            "3": [],
        },
        expected_refs={
            "0": [],
            "1": ["x"],
            "2": ["x", "y"],
            "3": ["z"],
        },
        expected_defs={
            "0": ["x"],
            "1": ["y"],
            "2": ["z", "zz"],
            "3": ["a"],
        },
    ),
    GraphTestCase(
        name="variable del",
        code={"0": "x = 0", "1": "y = x", "2": "del x"},
        expected_parents={"0": [], "1": ["0"], "2": ["0", "1"]},
        expected_children={"0": ["1", "2"], "1": ["2"], "2": []},
        expected_refs={"0": [], "1": ["x"], "2": ["x"]},
        expected_defs={
            "0": ["x"],
            "1": ["y"],
            "2": [],
        },
    ),
]

SQL_CASES = [
    GraphTestCase(
        name="python -> sql",
        enabled=HAS_DUCKDB,
        code={
            "0": "df = pd.read_csv('data.csv')",
            "1": "result = mo.sql(f'FROM df WHERE name = {name}')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["pd"], "1": ["df", "mo", "name"]},
        expected_defs={"0": ["df"], "1": ["result"]},
    ),
    GraphTestCase(
        name="sql -> python via output",
        enabled=HAS_DUCKDB,
        code={
            "0": "result = mo.sql(f'FROM my_table WHERE name = {name}')",
            "1": "df = result.head()",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["mo", "name", "my_table"], "1": ["result"]},
        expected_defs={"0": ["result"], "1": ["df"]},
    ),
    GraphTestCase(
        name="sql -/> python when creating a table",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_table (name STRING)')",
            "1": "my_table = df.head()",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={"0": ["mo"], "1": ["df"]},
        expected_defs={"0": ["my_table"], "1": ["my_table"]},
    ),
    GraphTestCase(
        name="sql redefinition",
        enabled=HAS_DUCKDB,
        code={
            "0": "df = pd.read_csv('data.csv')",
            "1": "df = mo.sql(f'FROM df')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["pd"], "1": ["df", "mo"]},
        expected_defs={"0": ["df"], "1": ["df"]},
    ),
    GraphTestCase(
        name="sql should not reference python variables when schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "df = pd.read_csv('data.csv')",
            "1": "result = mo.sql(f'FROM my_schema.df')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={"0": ["pd"], "1": ["mo", "my_schema.df"]},
        expected_defs={"0": ["df"], "1": ["result"]},
    ),
    GraphTestCase(
        name="sql should not reference python variables when schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "my_schema = 100",
            "1": "_ = mo.sql(f'FROM my_schema.df')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={"0": [], "1": ["mo", "my_schema.df"]},
        expected_defs={"0": ["my_schema"], "1": []},
    ),
    GraphTestCase(
        name="sql should not reference python variables when catalog",
        enabled=HAS_DUCKDB,
        code={
            "0": "my_catalog = 100",
            "1": "_ = mo.sql(f'FROM my_catalog.my_schema.df')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={"0": [], "1": ["mo", "my_catalog.my_schema.df"]},
        expected_defs={"0": ["my_catalog"], "1": []},
    ),
    GraphTestCase(
        name="sql table reference resolves to table name even if created with schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "_df = mo.sql(f'CREATE TABLE my_schema.my_table (name STRING)')",
            "1": "_df = mo.sql(f'FROM my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["mo"], "1": ["my_table", "mo"]},
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="sql table reference resolves to table name even if created with catalog and schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "_df = mo.sql(f'CREATE TABLE my_catalog.my_schema.my_table (name STRING)')",
            "1": "_df = mo.sql(f'FROM my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["mo"], "1": ["my_table", "mo"]},
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="sql table created from another table reference",
        enabled=HAS_DUCKDB,
        code={
            "0": "_df = mo.sql(f'CREATE TABLE schema_one.my_table (name STRING)')",
            "1": "_df = mo.sql(f'CREATE TABLE schema_two.my_table_two AS SELECT * FROM schema_one.my_table')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={"0": ["mo"], "1": ["mo", "schema_one.my_table"]},
        expected_defs={"0": ["my_table"], "1": ["my_table_two"]},
    ),
    GraphTestCase(
        name="sql table reference with catalog and schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_catalog.my_schema.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM my_catalog.my_schema.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo"],
            "1": ["my_catalog.my_schema.my_table", "mo"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="different schemas with same table name",
        enabled=HAS_DUCKDB,
        code={
            "0": "_df = mo.sql(f'CREATE TABLE schema_one.my_table (name STRING)')",
            "1": "_df = mo.sql(f'CREATE TABLE schema_two.my_table (name STRING)')",
            "2": "_df = mo.sql(f'FROM schema_one.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": [], "2": ["0"]},
        expected_children={"0": ["2"], "1": [], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo"],
            "2": ["mo", "schema_one.my_table"],
        },
        expected_defs={"0": ["my_table"], "1": ["my_table"], "2": []},
    ),
    GraphTestCase(
        name="sql definitions with same name as qualified schema and table",
        enabled=HAS_DUCKDB,
        code={
            "0": "my_table = mo.sql(f'CREATE TABLE schema_one.my_table (name STRING)')",
            "1": "schema_one = mo.sql(f'CREATE TABLE schema_one.my_table (name STRING)')",
            "2": "my_table",
            "3": "schema_one",
        },
        expected_parents={"0": [], "1": [], "2": ["0"], "3": ["1"]},
        expected_children={"0": ["2"], "1": ["3"], "2": [], "3": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo"],
            "2": ["my_table"],
            "3": ["schema_one"],
        },
        expected_defs={
            "0": ["my_table"],
            "1": ["my_table", "schema_one"],
        },
    ),
    GraphTestCase(
        name="sql catalog and schema with same name",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_db.my_db.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM my_db.my_db.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "my_db.my_db.my_table"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="sql view creation with schema reference",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_schema.base_table (id INT)')",
            "1": "_ = mo.sql(f'CREATE VIEW my_schema.my_view AS SELECT * FROM my_schema.base_table')",
            "2": "_ = mo.sql(f'FROM my_schema.my_view SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"], "2": ["1"]},
        expected_children={"0": ["1"], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "my_schema.base_table"],
            "2": ["mo", "my_schema.my_view"],
        },
        expected_defs={"0": ["base_table"], "1": ["my_view"], "2": []},
    ),
    GraphTestCase(
        name="sql case insensitive schema matching",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE MY_SCHEMA.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM my_schema.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "my_schema.my_table"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="sql no reference to python variable when using catalog",
        enabled=HAS_DUCKDB,
        code={
            "0": "my_catalog_var = 'test_catalog'",
            "1": "_ = mo.sql(f'FROM my_catalog_var.schema.table SELECT *')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={
            "0": [],
            "1": ["mo", "my_catalog_var.schema.table"],
        },
        expected_defs={"0": ["my_catalog_var"], "1": []},
    ),
    GraphTestCase(
        name="sql no reference to python variable when using schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "my_schema_var = 'test_schema'",
            "1": "_ = mo.sql(f'FROM my_schema_var.table SELECT *')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={
            "0": [],
            "1": ["mo", "my_schema_var.table"],
        },
        expected_defs={"0": ["my_schema_var"], "1": []},
    ),
    GraphTestCase(
        name="sql catalog.schema.table requires both catalog and schema to match",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE catalog_one.schema_one.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM catalog_one.schema_one.my_table SELECT *')",
            "2": "_ = mo.sql(f'FROM catalog_two.schema_one.my_table SELECT *')",
            "3": "_ = mo.sql(f'FROM catalog_one.schema_two.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"], "2": [], "3": []},
        expected_children={"0": ["1"], "1": [], "2": [], "3": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "catalog_one.schema_one.my_table"],
            "2": ["mo", "catalog_two.schema_one.my_table"],
            "3": ["mo", "catalog_one.schema_two.my_table"],
        },
        expected_defs={"0": ["my_table"], "1": [], "2": [], "3": []},
    ),
    GraphTestCase(
        name="sql table substring doesn't cause false positive",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE catalog_one.schema_one.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM catalog_one.schema_one.my_table_suffix SELECT *')",
            "2": "_ = mo.sql(f'FROM catalog_one.schema_one.prefix_my_table SELECT *')",
        },
        expected_parents={"0": [], "1": [], "2": []},
        expected_children={"0": [], "1": [], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "catalog_one.schema_one.my_table_suffix"],
            "2": ["mo", "catalog_one.schema_one.prefix_my_table"],
        },
        expected_defs={"0": ["my_table"], "1": [], "2": []},
    ),
    GraphTestCase(
        name="sql table schema substring doesn't cause false positive",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE catalog_one.schema_one.my_table (name STRING)')",
            "1": "_ = mo.sql(f'FROM catalog_one.my_table.suffix SELECT *')",
        },
        expected_parents={"0": [], "1": []},
        expected_children={"0": [], "1": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "catalog_one.my_table.suffix"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="sql table attach statements, single definition",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f\"ATTACH 'my_db.db' as my_db\")",
            "1": "_ = mo.sql(f'FROM my_db.main.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "my_db.main.my_table"],
        },
        expected_defs={"0": ["my_db"], "1": []},
    ),
    GraphTestCase(
        name="sql table attach statements, multiple definitions",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f\"ATTACH 'my_db.db' as my_db\")",
            "1": "_ = mo.sql(f'CREATE OR REPLACE TABLE my_db.my_table AS SELECT 1')",
            "2": "_ = mo.sql(f'FROM my_db.main.my_table SELECT *')",
            "3": "_ = mo.sql(f'FROM my_db.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": [], "2": ["0", "1"], "3": ["0", "1"]},
        expected_children={"0": ["2", "3"], "1": ["2", "3"], "2": [], "3": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo"],
            "2": ["mo", "my_db.main.my_table"],
            "3": ["mo", "my_db.my_table"],
        },
        expected_defs={"0": ["my_db"], "1": ["my_table"], "2": [], "3": []},
    ),
    GraphTestCase(
        name="create table with the same name from a different schema",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_table AS SELECT * FROM schema_one.my_table')",
            "1": "_ = mo.sql(f'SELECT * FROM my_table')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo", "schema_one.my_table"],
            "1": ["mo", "my_table"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="create table with the same name from catalog.schema hierarchy",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE my_table AS SELECT * FROM catalog_one.schema_one.my_table')",
            "1": "_ = mo.sql(f'SELECT * FROM my_table')",
        },
        expected_parents={"0": [], "1": ["0"]},
        expected_children={"0": ["1"], "1": []},
        expected_refs={
            "0": ["mo", "catalog_one.schema_one.my_table"],
            "1": ["mo", "my_table"],
        },
        expected_defs={"0": ["my_table"], "1": []},
    ),
    GraphTestCase(
        name="create schema with the same name from a different catalog",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE SCHEMA my_schema')",
            "1": "_ = mo.sql(f'CREATE TABLE my_schema.my_table AS SELECT * FROM catalog_one.my_schema.my_table')",
            "2": "_ = mo.sql(f'SELECT * FROM my_schema.my_table')",
        },
        expected_parents={"0": [], "1": [], "2": ["1"]},
        expected_children={"0": [], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "catalog_one.my_schema.my_table"],
            "2": ["mo", "my_schema.my_table"],
        },
        expected_defs={"0": ["my_schema"], "1": ["my_table"], "2": []},
    ),
    GraphTestCase(
        name="create table that references itself in join prevents self-loop",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE users AS SELECT 1 as id')",
            "1": "_ = mo.sql(f'CREATE TABLE orders AS SELECT u.id FROM schema_one.users u JOIN schema_two.orders o ON u.id = o.user_id')",
            "2": "_ = mo.sql(f'SELECT * FROM orders')",
        },
        expected_parents={"0": [], "1": ["0"], "2": ["1"]},
        expected_children={"0": ["1"], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "schema_one.users", "schema_two.orders"],
            "2": ["mo", "orders"],
        },
        expected_defs={"0": ["users"], "1": ["orders"], "2": []},
    ),
    GraphTestCase(
        name="multiple tables with hierarchical self-reference patterns",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE table_a AS SELECT * FROM db1.table_a')",
            "1": "_ = mo.sql(f'CREATE TABLE table_b AS SELECT * FROM db2.table_b')",
            "2": "_ = mo.sql(f'SELECT * FROM table_a UNION ALL SELECT * FROM table_b')",
        },
        expected_parents={"0": [], "1": [], "2": ["0", "1"]},
        expected_children={"0": ["2"], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo", "db1.table_a"],
            "1": ["mo", "db2.table_b"],
            "2": ["mo", "table_a", "table_b"],
        },
        expected_defs={"0": ["table_a"], "1": ["table_b"], "2": []},
    ),
    GraphTestCase(
        name="create table from hierarchical ref then reference it hierarchically",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE SCHEMA my_schema')",
            "1": "_ = mo.sql(f'CREATE TABLE my_schema.data AS SELECT * FROM external.my_schema.data')",
            "2": "_ = mo.sql(f'SELECT * FROM my_schema.data')",
        },
        expected_parents={"0": [], "1": [], "2": ["1"]},
        expected_children={"0": [], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo", "external.my_schema.data"],
            "2": ["mo", "my_schema.data"],
        },
        expected_defs={"0": ["my_schema"], "1": ["data"], "2": []},
    ),
    GraphTestCase(
        name="sql table multiple definitions, different order",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE OR REPLACE TABLE my_db.my_table AS SELECT 1')",
            "1": "_ = mo.sql(f\"ATTACH 'my_db.db' as my_db\")",
            "2": "_ = mo.sql(f'FROM my_db.main.my_table SELECT *')",
        },
        expected_parents={"0": [], "1": [], "2": ["0", "1"]},
        expected_children={"0": ["2"], "1": ["2"], "2": []},
        expected_refs={
            "0": ["mo"],
            "1": ["mo"],
            "2": ["mo", "my_db.main.my_table"],
        },
        expected_defs={"0": ["my_table"], "1": ["my_db"], "2": []},
    ),
    GraphTestCase(
        name="sql table ordering doesn't cause false positives",
        enabled=HAS_DUCKDB,
        code={
            "0": "_ = mo.sql(f'CREATE TABLE catalog_one.schema_one.my_table (name STRING)')",
            "1": "_ = mo.sql(f'CREATE TABLE catalog_one.my_table.schema_one (name STRING)')",
            "2": "_ = mo.sql(f'CREATE TABLE schema_one.my_table.catalog_one (name STRING)')",
            "3": "_ = mo.sql(f'CREATE TABLE schema_one.catalog_one.my_table (name STRING)')",
            "4": "_ = mo.sql(f'CREATE TABLE my_table.catalog_one.schema_one (name STRING)')",
            "5": "_ = mo.sql(f'CREATE TABLE my_table.schema_one.catalog_one (name STRING)')",
        },
        expected_parents={
            "0": [],
            "1": [],
            "2": [],
            "3": [],
            "4": [],
            "5": [],
        },
        expected_children={
            "0": [],
            "1": [],
            "2": [],
            "3": [],
            "4": [],
            "5": [],
        },
        expected_refs={
            "0": ["mo"],
            "1": ["mo"],
            "2": ["mo"],
            "3": ["mo"],
            "4": ["mo"],
            "5": ["mo"],
        },
        expected_defs={
            "0": ["my_table"],
            "1": ["schema_one"],
            "2": ["catalog_one"],
            "3": ["my_table"],
            "4": ["schema_one"],
            "5": ["catalog_one"],
        },
    ),
]

CASES = PYTHON_CASES + SQL_CASES


@pytest.mark.parametrize("case", CASES)
def test_cases(case: GraphTestCase) -> None:
    print(f"Running {case.name}")
    graph = dataflow.DirectedGraph()

    if not case.enabled:
        pytest.skip(f"Skipping {case.name} because it's not enabled")

    for cell_id, code in case.code.items():
        cell = parse_cell(code)
        graph.register_cell(CellId_t(cell_id), cell)

    def make_assertions():
        if case.expected_refs:
            for cell_id, refs in case.expected_refs.items():
                assert graph.cells[CellId_t(cell_id)].refs == refs, (
                    f"Cell {cell_id} has refs {graph.cells[CellId_t(cell_id)].refs}, expected {refs}"
                )
        if case.expected_defs:
            for cell_id, defs in case.expected_defs.items():
                assert graph.cells[CellId_t(cell_id)].defs == defs, (
                    f"Cell {cell_id} has defs {graph.cells[CellId_t(cell_id)].defs}, expected {defs}"
                )
        assert graph.parents == case.expected_parents, (
            f"Graph parents {graph.parents} do not match expected {case.expected_parents}"
        )
        assert graph.children == case.expected_children, (
            f"Graph children {graph.children} do not match expected {case.expected_children}"
        )

    if case.xfail:
        if isinstance(case.xfail, str):
            print(case.xfail)
        try:
            make_assertions()
        except AssertionError as e:
            pytest.xfail(str(e))
            raise KnownFailure(str(e)) from e
    else:
        make_assertions()