...
| Code Block | ||
|---|---|---|
| ||
// Produces SELECT `id`,`id_code` AS `key`,`user_id` FROM `clients`
$this->Record->select(array("id","id_code"=>"key","user_id"))->from("clients"); |
Tuple
Limit
| Code Block | ||
|---|---|---|
| ||
// Produces SELECT * FROM `clients` LIMIT 20, 10
$this->Record->select()->from("clients")->limit(10, 20); |
...
| Code Block | ||
|---|---|---|
| ||
// Produces SELECT `clients`.* FROM `clients`, `contacts`
$this->Record->select(array("clients.*"))->from("clients")->from("contacts");
// Produces SELECT `clients`.* FROM `clients`, JOIN `contacts`
$this->Record->select(array("clients.*"))->from("clients")->join("contacts"); |
...
| Code Block | ||
|---|---|---|
| ||
// Executes DELETE `clients`.*, `contacts`.* FROM `clients` INNER JOIN `contacts` ON `contacts`.`client_id`=`clients`.`id` WHERE `clients`.`id`='15'
$this->Record->from("clients")->innerJoin("contacts", "contacts.client_id", "=", "clients.id")->where("clients.id", "=", 15)->delete(array("clients.*","contacts.*")); |
Table Management
Create
| Code Block | ||
|---|---|---|
| ||
// Executes CREATE TABLE `feed_reader_feeds` (
// `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
// `url` varchar(255) NOT NULL,
// `updated` datetime DEFAULT NULL,
// PRIMARY KEY (`id`),
// UNIQUE KEY `url` (`url`)
// ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
$this->Record->
setField("id", array('type' => "int",'size' => 10,'unsigned' => true,'auto_increment' => true))->
setField("url", array('type' => "varchar", 'size' => 255))->
setField("updated", array('type' => "datetime", 'is_null' => true, 'default' => null))->
setKey(array("id"), "primary")->
setKey(array("url"), "unique")->
create("feed_reader_feeds"); |
Alter
Truncate
Drop
Transactions
...