Where should I store my CFWheels migration files?

Migrations must be stored in 'app/migrator/migrations/'. Placing them in 'db/migrate/' or other locations will prevent Wheels from detecting them.

Does t.timestamps() include soft delete support?

Yes, in CFWheels, t.timestamps() automatically creates createdAt, updatedAt, and a nullable deletedAt column for soft delete support.

How do I handle dates in a database-agnostic way?

Avoid database functions like NOW() or DATE_SUB(). Instead, use CFML date functions like DateAdd() and format them using the TIMESTAMP string pattern provided by this skill.

How do I avoid the CLI generator boolean bug?

When using createTable(), remove explicit string parameters like force='false' or id='true'. Instead, use the default t = createTable(name='tablename') to avoid logic failures.

Wheels Migration Generator

Name: Wheels Migration Generator
Author: Microck

byMicrock

•

Database Management

Generates database-agnostic CFWheels migration files for schema changes, table creation, and data seeding.

This skill streamlines the creation of database migrations for CFWheels applications, ensuring cross-database compatibility by avoiding platform-specific SQL. It enforces critical best practices such as correct file placement in the app/migrator/migrations directory, proper use of timestamps for soft-delete support, and database-agnostic date formatting. The skill also provides essential production-tested fixes for common CLI generator bugs, specifically addressing issues with string-based boolean parameters that can lead to silent failures in table creation.

Key Features

01Pre-configured transactional blocks with robust error handling and rollbacks

0281 GitHub stars

03Database-agnostic syntax enforcement for cross-platform compatibility

04Automated migration boilerplate for table creation and schema alterations

05Standards-compliant data seeding with cross-database date formatting

06Fixes for CLI-specific bugs involving string-based boolean parameters

Use Cases

01Migrating production data without writing database-specific SQL functions

02Building and modifying relational database schemas within CFWheels applications

03Implementing soft-delete functionality using standardized timestamp columns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills wheels-migration-generator

For use in Claude.ai and ChatGPT

Download Skill