Dashboard Schema Migration Guide

Table of Contents

Overview

Current Schema Versions

Creating a New Migration

Step 1: Create the Migration File

Step 2: Register the Migration

Step 3: Create Test Data

Input Test File

Expected Output

Step 4: Run Tests

Step 5: Frontend-Backend Consistency Validation

Test Scenarios to Cover

Validation Process

Test Data Requirements

Step 6: Unit Testing

Backend Unit Tests

Frontend Unit Tests

Running Unit Tests

Utility Functions

Type Conversion

Data Access

Common Pitfalls

1. Type Assertions

2. Null Handling

3. Nested Panel Processing

Migration Beyond v42

When to Add Schema Migrations vs Panel Migrations

Testing Guidelines

Test File Naming

Test Data Requirements

Running Tests

Comprehensive Testing Strategy

Backend Migration Tests

Frontend Migration Comparison Tests

Single Version Migration Testing

Resources

Getting Help