6. Model Layer | CakePHP 2 Application Cookbook

On-the-fly associations

Sometimes, you'll find it useful to create a new association on the fly before a find operation to retrieve specific data or filter unwanted result rows from your query.

In this recipe, we'll look at how associations can be defined at runtime on your models.

Getting ready

We'll assume you have the Package, Stock, and Warehouse models in place from our previous recipes, where Stock belongsTo Warehouse and Stock belongsTo Package.

We'll also add an active field to our packages and warehouses tables with the following SQL statement:

ALTER TABLE packages ADD active TINYINT(1) NOT NULL DEFAULT '1';
ALTER TABLE warehouses ADD active TINYINT(1) NOT NULL DEFAULT '1';

We want to retrieve only the stocks with a positive amount for both warehouses and packages that are active, so let's set amount for one join record, as shown in the following code:

UPDATE packages_warehouses SET amount = '1' WHERE id = 1;

Note that the ORM in CakePHP will translate the belongsTo associations to left...

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

On-the-fly associations

Getting ready

CakePHP 2 Application Cookbook - Third Edition

By : Watts

CakePHP 2 Application Cookbook

By: Watts

Overview of this book

On-the-fly associations

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