mirror of
https://github.com/simonw/sqlite-utils.git
synced 2026-07-26 02:44:33 +02:00
69a1c0d960* Automated upgrades by Ruff
uvx --with 'ruff>=0.16.0' ruff check . --fix --unsafe-fixes
* Fix remaining Ruff errors with GPT-5.6 Sol high
https://gist.github.com/simonw/6da7906a9fea6e90da131c21a9055199
* Fix flake E501 long lines
* New Protocol for migrations to make ty happy
27 lines
919 B
Python
27 lines
919 B
Python
import pathlib
|
|
|
|
import pytest
|
|
from click.testing import CliRunner
|
|
|
|
from sqlite_utils import Database, cli
|
|
|
|
sniff_dir = pathlib.Path(__file__).parent / "sniff"
|
|
|
|
|
|
@pytest.mark.parametrize("filepath", sorted(sniff_dir.glob("example*")))
|
|
def test_sniff(tmpdir, filepath):
|
|
db_path = str(tmpdir / "test.db")
|
|
runner = CliRunner()
|
|
result = runner.invoke(
|
|
cli.cli,
|
|
["insert", db_path, "creatures", str(filepath), "--sniff", "--no-detect-types"],
|
|
catch_exceptions=False,
|
|
)
|
|
assert result.exit_code == 0, result.stdout
|
|
db = Database(db_path)
|
|
assert list(db["creatures"].rows) == [
|
|
{"id": "1", "species": "dog", "name": "Cleo", "age": "5"},
|
|
{"id": "2", "species": "dog", "name": "Pancakes", "age": "4"},
|
|
{"id": "3", "species": "cat", "name": "Mozie", "age": "8"},
|
|
{"id": "4", "species": "spider", "name": "Daisy, the tarantula", "age": "6"},
|
|
]
|