fix: robust smudge filter and cleaner shadow table detection

- smudge: Add resilience for "no such table" errors (warn & skip)
- smudge: Improve FTS trigger detection using regex for accuracy
- clean: Dynamically identify FTS shadow tables instead of rigid suffix matching
- test: Add regression test for smudge error handling ([test_smudge_resilience.py](cci:7://file:///home/shane/repos/git-sqlite-filter/test/test_smudge_resilience.py:0:0-0:0))
- test: Add persistence fixture `test/fixtures/trigger_persistence.db`
- dev: Add pylint and mypy to dev requirements and Makefile

fix: guard SIGPIPE for Windows compatibility

Merge branch 'cleanups'

fixup submodule skip logic

why was nss_helper deleted tho?

skip virtual tables; deterministic checks; sqlite ver

chore: fix sqlite filter to skip virtual tables

Fixed multiple code violations and quality issues across the codebase.

    - **[pyproject.toml](file:///home/shane/repos/git-sqlite-filter/pyproject.toml)**: Corrected `norecursedirs` to exclude `fixtures` properly.

    - **[clean.py](file:///home/shane/repos/git-sqlite-filter/src/git_sqlite_filter/clean.py)**:
        - Wrapped subprocess calls in `try/except subprocess.TimeoutExpired`.
        - Removed broad `except Exception` pass.
        - Used `shutil.copyfileobj` for efficient streaming.
        - Fixed `debug` variable usage.
    - **[smudge.py](file:///home/shane/repos/git-sqlite-filter/src/git_sqlite_filter/smudge.py)**:
        - Updated `ROLLBACK` check to allow `ROLLBACK TO savepoint`.

    - **`test_run.py`**: Added `stderr` capture to subprocess calls for better debugging.
    - **`ffpass_utils.py`**: Updated type hints to `list | None`.
    - **`test_mp_stdin.py`**: Improved mocking using `patch.object` and fixed indentation.
    - **`test_key.py`**: Implemented context manager for SQLite connections.
    - **`test_mixed_keys_run.py`**: Replaced system stdout patching with `contextlib.redirect_stdout`.
    - **`test_native_verify.py`**: Fixed broken import path (`.nss_helper` -> `ffpass_utils`).

    - **`nss_native.py`**:
        - Fixed memory leak by freeing `SECItem`.
        - Updated docstrings.
        - Removed commented-out logic and duplicate checks.

    - **`test_verification.py`**:
        - Fixed `PYTHONPATH` injection.
        - Added `sqlite3` binary availability check.
        - Cleaned up comments and syntax.

    - `pytest test/test_verification.py`: **PASSED** (Verifies core clean/smudge logic).
    - `pytest test/fixtures/ff-tests/...`: **RAN** (Failures due to missing `ffpass` dependency, but import/syntax errors resolved).

use git-sqlite-filter to checkout *.db on CI

cubic: lints/fixes

add %f and require to sqlite filter on git CI

address weird, sudden wheel failure on python 3.8

Merge pull request #2 from gamesguru/dependabot/pip/pip-92131b0f06

Bump wheel from 0.43.0 to 0.46.2 in the pip group across 1 directory

Bump wheel from 0.43.0 to 0.46.2 in the pip group across 1 directory

Bumps the pip group with 1 update in the / directory: [wheel](https://github.com/pypa/wheel).

Updates `wheel` from 0.43.0 to 0.46.2
- [Release notes](https://github.com/pypa/wheel/releases)
- [Changelog](https://github.com/pypa/wheel/blob/main/docs/news.rst)
- [Commits](https://github.com/pypa/wheel/compare/0.43.0...0.46.2)

---
updated-dependencies:
- dependency-name: wheel
  dependency-version: 0.46.2
  dependency-type: direct:development
  dependency-group: pip
...

Signed-off-by: dependabot[bot] <support@github.com>

enhance warning message

wip

fixup! remove maybe_warn() tty smudge nonsense bloat

remove maybe_warn() tty smudge nonsense bloat

small tidy

Skip FTS5 Internal Triggers

prompt for input to writes; faster test

fix warning/stdin hanging test; drop coverage

improved tests

add important smudge test

log sqlite binary version; improve warning/logging

simplify sentinel timeout

improve

simpler warning message for locked DBs

tidy up

avoid subprocess calls in tests; messed up coverage

rearrange pyproject stuff

update test files & distro version releases

clean with every deploy

Release v0.1.2

add missing make target, comment

Release v0.1.1

update for pypi inclusion of files

update rpm spec

Makefile

gitignore

debian stuff/fixes/tweaks

drop coverage to 55

add coverage

simplify test

Makefile; format python

keep going

wip

add license

keep adding, updating, debug note

wip, keep trucking

format code

update makefile and gitignore

update PKG-INFO

update/fix

debugging

broken

refactor/rename folders

tidy logic for ordering & such

track autoincrement (restore)

semantic/smart noise reduction

wip

add Makefile; format python

commit dbs? keep going?

update py scripts

wip

handle locked DBs?

keep trucking

fixup! add gitconfig example

update gitattributes

add gitconfig example

update

track smudge script

init