| 351 | |
| 352 | |
| 353 | def test_commit(session: Session, engine: Engine) -> None: |
| 354 | importorskip("sqlalchemy", "1.4.0") |
| 355 | session.execute(text("commit;")) |
| 356 | |
| 357 | InteractiveShell = importorskip("IPython.core.interactiveshell").InteractiveShell |
| 358 | |
| 359 | shell = InteractiveShell() |
| 360 | assert not shell.run_line_magic("load_ext", "sql") |
| 361 | assert not shell.run_line_magic("sql", "duckdb:///:memory:") |
| 362 | assert shell.run_line_magic("sql", "select 42;") == [(42,)] |
| 363 | |
| 364 | |
| 365 | def test_table_reflect(session: Session, engine: Engine) -> None: |