database server. We’re going to be using MySQL server in this tutorial. You’ll need to know enough about SQL in order to create a database: CakePHP will be taking the reins from there. Since we’re using MySQL posts. We’ll also throw in a few posts right now to use for testing purposes. Execute the following SQL statements into your database: /* First, create our posts table: */ CREATE TABLE posts ( id INT support composite primary keys. If you want to directly manipulate your join table data, use direct query calls or add a primary key to act on it as a normal model. For example: CREATE TABLE posts_tags (

database server. We’re going to be using MySQL server in this tutorial. You’ll need to know enough about SQL in order to create a database: CakePHP will be taking the reins from there. Since we’re using MySQL posts. We’ll also throw in a few posts right now to use for testing purposes. Execute the following SQL statements into your database: /* First, create our posts table: */ CREATE TABLE posts ( id INT UNSIGNED support composite primary keys. If you want to directly manipulate your join table data, use direct query calls or add a primary key to act on it as a normal model. For example: CREATE TABLE posts_tags (

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Disabling Generic Tables Routing RouterBuilder Quick Tour Connecting Routes Route Elements Reserved Persistent URL Parameters Request & Response Objects Request ServerRequest Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

Connections iii. Running Queries iv. Database Transactions v. Accessing Connections vi. Query Logging ii. Query Builder i. Introduction ii. Selects iii. Joins iv. Advanced Wheres v. Aggregates vi Basic Usage iii. Mass Assignment iv. Insert, Update, Delete v. Soft Deleting vi. Timestamps vii. Query Scopes viii. Global Scopes ix. Relationships x. Querying Relations xi. Eager Loading xii. Inserting Indexes ix. Foreign Keys x. Dropping Indexes xi. Dropping Timestamps & Soft Deletes xii. Storage Engines v. Migrations & Seeding i. Introduction ii. Creating Migrations iii. Running Migrations iv.

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 323 13 Caching 505 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 506 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 513 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 514 Using Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 620 Creating Log Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 620 Log

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Bootstrapping CakePHP Application::bootstrap() Disabling Generic Tables Routing Quick Tour Connecting Named Parameters in URLs Dispatcher Filters Request & Response Objects Request Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

Configuration Files Storing Runtime Configuration Restoring Runtime Configuration Configuration Engines Disabling Generic Tables Routing RouterBuilder Quick Tour Connecting Routes Route Elements Reserved Persistent URL Parameters Request & Response Objects Request ServerRequest Request Parameters Query String Parameters Request Body Data File Uploads PUT, PATCH or DELETE Data Environment Variables (from JSON and XML views Helpers Database Access & ORM Quick Example More Information Database Basics Query Builder Table Objects Entities Retrieving Data & Results Sets Validating Data Saving Data Deleting

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 465 13 Caching 633 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 634 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641 Using Groups . . . TableRegistry::get('Users') $users = TableRegistry::getTableLocator()->get('Users'); $query = $users->find(); foreach ($query as $row) { echo $row->username; } You may notice that we didn’t have to write any

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 421 13 Caching 605 Configuring Cache Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 606 Writing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 613 Using Cache to Store Common Query Results . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614 Using Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 728 Creating Log Engines . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 728 Log

assumptions that reduce the overhead of parsing incoming requests. Why is my query parameter missing from the req object? If a query param does not have a value, Falcon will by default ignore that parameter org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an “AS IS” BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express localhost:8000/things More Features Here is a more involved example that demonstrates reading headers and query parameters, handling errors, and working with request and response bodies. import json import logging