Book Image

CakePHP 2 Application Cookbook

Book Image

CakePHP 2 Application Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
CakePHP 2 Application Cookbook
Aug, 2014 | 346 pages
No titles found
Table of Contents (20 chapters)
CakePHP 2 Application Cookbook
CakePHP 2 Application Cookbook
Credits
Credits
Foreword
Foreword
About the Authors
About the Authors
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Lightning Introduction
Lightning Introduction
Introduction
Listing and viewing records
Adding and editing records
Deleting records
Adding a login
Including a plugin
2
Advanced Routing
Advanced Routing
Introduction
Adding a prefix
Handling languages
Custom route class
Dispatch filter
3
HTTP Negotiation
HTTP Negotiation
Introduction
Parsing extensions
Processing Ajax requests
Building a response
Uploading a file
Using a detector
Working with cookies
Cache control
Error handling
4
API Strategies
API Strategies
Introduction
RESTful resources
Exposing a web service
Consuming a service
Authentication API
API versioning
5
Using Authentication
Using Authentication
Introduction
The HTTP authentication
Custom authorize class
Facebook authentication
Custom RBAC
Working with ACL
6
Model Layer
Model Layer
Introduction
Has and belongs to many (HABTM)
Joining through
Containing models
Custom finders
On-the-fly associations
Using transactions
7
Search and Pagination
Search and Pagination
Introduction
Pagination
Basic search and filter
The Search plugin
Advanced search
8
Events System
Events System
Introduction
Listeners and subscribers
Event-driven process
Event stacking
Managing event priorities
9
Creating Shells
Creating Shells
Introduction
Console API
Import parser
Running cron shells
Using the I18n shell
10
View Templates
View Templates
Introduction
Using blocks
Building an XML view
Generating a PDF
Writing some PDF content to a file
Translations
View caching
The AssetCompress plugin
11
Unit Tests
Unit Tests
Introduction
Dependency Injection
Creating a fixture
Mock objects
Stub method configuration
Model unit testing
12
Migrations
Migrations
Introduction
Schema handling
Syncing changes
The Migrations plugin
Injecting data
Index
Index

Running cron shells

Another typical scenario to use CakePHP console shells is to implement a data warehouse and a time-intensive and recurring task.

In this recipe, we'll create a recurring job to calculate our package ratings, based on some complex logic.

Getting ready

For this recipe, we'll assume that you have a packages table and the related model that we created in our previous recipe. However, we'll also add a new column to store our ratings per package with the following SQL statement:

ALTER TABLE packages ADD rating INT(20) UNSIGNED NOT NULL DEFAULT '0';

How to do it...

Perform the following steps:

  1. First, create a file named RatingShell.php in app/Console/Command/ with the following content:

    <?php
App::uses('AppShell', 'Console/Command');

class RatingShell extends AppShell {

  public function main() {
    $this->out($this->getOptionParser()->help());
  }

  public function getOptionParser() {
    $parser = parent::getOptionParser();
    return $parser->description('Rating...
Previous Section
End of Section 5
Next Section