12. Migrations | CakePHP 2 Application Cookbook

Injecting data

Sometimes you need to save initial data for your newly created tables or ensure that old data is consistent with one of your migrations right after you applied it.

The CakeDC Migrations plugin provides a way to alter your database contents while running a migration, so you can execute custom logic before or after a given migration. This custom code can be used to insert or update data in your database to keep your changes consistent.

Getting ready

In this recipe, we'll add a new feature to our blog which involves setting up a unique group for our profiles. We'll want to allow groups to be dynamic, so a new groups table and Group model will be created and associated with our Profile model.

We'll first create a table for our groups using the following SQL statement:

CREATE TABLE groups (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  created DATETIME,
  modified DATETIME,
  PRIMARY KEY(id)
);

Now, we will use our profiles table created earlier (shown in the following...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

Injecting data

Getting ready

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

Injecting data

Getting ready

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access