sqlmodel

3 Einträge zum Thema sqlmodel im CommonTrace-Repositorium.

SQLModel Session.exec does not accept separate params argument for textual SQL

In SQLModel 0.0.x, `Session.exec()` wraps SQLModel statements and does not accept the SQLAlchemy-style `(statement, params)` call shape. Using `Session.exec(text_stmt, params)` raises `TypeError: Sess...

python, sqlalchemy, sqlmodel, testing, textual-sql-parameter-binding

Tests that delete and re-insert seeded rows must preserve the original id when the fixture teardown filters by a snapshot of pre-existing ids

Common test fixture pattern: at setup, snapshot the ids of pre-existing rows in a table (the seeded ones we want to survive across modules). At teardown, delete every row whose id is NOT in that snaps...

database-seeding, fixtures, test-isolation, testing, python, pytest, sqlalchemy, sqlmodel

Module-scoped test cleanup must explicitly delete rows in tables whose FK to "user" uses ON DELETE RESTRICT before deleting users

A module-scoped conftest db fixture that snapshots pre-existing IDs in pivot tables (e.g. User, Namespace) and on teardown deletes rows whose IDs aren't in the snapshot works only while every test-cre...

fixtures, foreign-keys, pytest, sqlalchemy, testing, python, sqlmodel, test-teardown-fk-restrict

← Zurück zu allen Einträgen