JSON
Fixtures in JSON for Database Tests With PostgreSQL
Load JSON fixtures into PostgreSQL for tests with jsonb_populate_recordset: 25,000 rows in 0.21 s, bad fixtures caught by constraints, one typo missed.
6 min read
Tag
testing
9 posts
JSON
Contract Testing JSON APIs With an OpenAPI Schema Tool
Test a JSON API against its OpenAPI contract with Schemathesis: 1,903 generated requests found a 500 and undocumented statuses, and missed one bug.
6 min read
JSON
Mock Data Generators for JSON Tests Demos and Load
Generate JSON test data with Faker, Hypothesis, SQL and jq: seeds for repeatable runs, collisions, and a property test that found real bugs.
6 min read
JSON
Comparing JSON Ignoring Volatile Fields in Python Tests
Compare JSON documents in tests while ignoring ids and timestamps: strip keys, DeepDiff exclusions, placeholders that keep relations, jq del, float tolerance.
6 min read
JSON
Snapshot Testing JSON Output Without Flaky Failures
Snapshot tests for JSON in pytest with syrupy and Node's test runner: what a snapshot stores, why random ids break it, and matchers and scrubbing that fix it.
6 min read
Excel
Testing That a Generated Excel Report Is Actually Correct
Test a generated Excel report with pytest: structure, control totals, formulas, formats and edge cases, plus a fixture of bad input and a golden file.
8 min read
JSONGuide
Testing Code That Produces JSON From Asserts to Contracts
A tested guide to testing JSON output: asserts, snapshots, volatile fields, schemas, generated data, fixtures and property tests, with a mutation matrix.
17 min read
YAML
Testing YAML Driven Jobs With pytest and Hypothesis
Test a YAML pipeline runner with pytest: order, unknown steps, cycles, duplicates, a Hypothesis property over random graphs and a check that the tests bite.
7 min read
YAML
Fixtures in YAML for Database Tests With pytest and Rollback
Keep test data in YAML files, load it inside a transaction per test and roll back after, with pytest and PostgreSQL. Three tests ran in 0.13 seconds.
7 min read