SQL-Datenbank-Fixture-Matrix
Waehlen Sie SQL-Fixtures fuer Migrationen, Seed-Daten, Reporting und Rollback-Skripte.
7
Fixture-Zeilen
4
So verwenden Sie diese Matrix
Use the matrix when the validation target is a set of variants rather than one canonical sample.
So verwenden Sie diese Matrix
Coverage
- Deckt Schema-Migrationen, Seed-Datensaetze, Reporting-Queries und transaktionale Skripte ab.
- Nutzlich fuer lokale Datenbankinitialisierung und die Validierung von SQL-Workflows.
- Verankert im SQL-Paket und Datenbank-Seeding-Workflow.
- Anchored to the SQL database seed pack and workflow hub.
Fixture-Zeilen
Available Variants
| Variante | Profil | Testfokus | Datei | Groesse | Herunterladen |
|---|---|---|---|---|---|
|
Schema Migration SQL
Good baseline for migration ordering and DDL application checks.
|
DDL fixture | Schema change validation |
sql_schema_migration_sample.sql
|
188 B | Herunterladen |
|
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 | Herunterladen |
|
Reporting Query SQL
Targets reporting pipelines and result-shape validation.
|
Read/query fixture | Reporting and aggregation |
sql_reporting_query_sample.sql
|
167 B | Herunterladen |
|
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 | Herunterladen |
|
5MB SQL
Good first step when you need a larger SQL file but still want fast feedback on apply and rollback behavior.
|
Size fixture | Mid-size seed replay |
sql_sample_file_5MB.sql
|
5.0 MB | Herunterladen |
|
100MB SQL
Targets worker timeouts, database import throughput, and real SQL parser performance at size.
|
Large fixture | Bulk import and apply time |
sql_sample_file_100MB.sql
|
100.0 MB | Herunterladen |
|
250MB SQL
Best for rehearsal of large seed loads and database setup paths where file size changes execution behavior.
|
Huge fixture | Long-running seed and replay stress |
sql_sample_file_250MB.sql
|
250.0 MB | Herunterladen |
Verwandte Strategie-Seiten
Related Packs and Workflows
Verwandte Pakete
Fixture-Paket fuer SQL-Datenbank-Seeding
Verwandte Workflows
Fixtures fuer Datenbank-Seeding
Workflow oeffnenLarge SQL Seeding Fixtures
Workflow oeffnenVerwandte Strategie-Seiten
Related Pages
Beste-Format-Guides
Use-Case-Guides
Konvertierungs-Guides
How to Convert CSV to SQL
How to Convert SQL to CSV
How to Convert SQL to YAML
How to Convert YAML to SQL