SQL Database Fixture Matrix

Use SQL fixtures for migrations, seed data, reporting queries, and transaction/rollback workflows.

Hoe je deze matrix gebruikt

  • Covers schema migration DDL, insert-heavy seed data, report queries, and rollback flows.
  • Useful for database migrations, fixture loading, reporting validation, and transactional QA.
  • Anchored to the SQL database seed pack and workflow hub.

Open primaire bibliotheek

Deze matrix is gekoppeld aan de SQL-bibliotheekpagina en het manifest.

Fixture-rijen

Variant Profile Testfocus File Size Download
Schema Migration SQL
Good baseline for migration ordering and DDL application checks.
DDL fixture Schema change validation sql_schema_migration_sample.sql 188 B Download
Seed Data SQL
Useful for fixture loading, database seeding, and smoke-test data setup.
Insert fixture Seed/import loading sql_seed_data_sample.sql 253 B Download
Reporting Query SQL
Targets reporting pipelines and result-shape validation.
Read/query fixture Reporting and aggregation sql_reporting_query_sample.sql 167 B Download
Rollback Transaction SQL
Useful for transaction semantics, rollback handling, and migration safety checks.
Transactional fixture Rollback and savepoints sql_transaction_rollback_sample.sql 187 B Download

Gerelateerde packs

SQL Database Seed Pack

Bundle of real SQL fixtures for schema migrations, seed data, reporting queries, and transaction-handling workflows.

sql_database_seed_pack.zip · 1.3 KB

Gerelateerde workflows

Database Seeding Fixtures

SQL fixtures for schema migrations, seed data, reporting queries, and transaction/rollback workflows.

Open Workflow