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

•

데이터베이스 관리

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.

주요 기능

Pre-configured transactional blocks with robust error handling and rollbacks
81 GitHub stars
Database-agnostic syntax enforcement for cross-platform compatibility
Automated migration boilerplate for table creation and schema alterations
Standards-compliant data seeding with cross-database date formatting
Fixes for CLI-specific bugs involving string-based boolean parameters

사용 사례

Migrating production data without writing database-specific SQL functions
Building and modifying relational database schemas within CFWheels applications
Implementing soft-delete functionality using standardized timestamp columns

소개

주요 기능

Pre-configured transactional blocks with robust error handling and rollbacks
81 GitHub stars
Database-agnostic syntax enforcement for cross-platform compatibility
Automated migration boilerplate for table creation and schema alterations
Standards-compliant data seeding with cross-database date formatting
Fixes for CLI-specific bugs involving string-based boolean parameters

사용 사례

Migrating production data without writing database-specific SQL functions
Building and modifying relational database schemas within CFWheels applications
Implementing soft-delete functionality using standardized timestamp columns