การใช้งาน Recordset

// create Recordset
$rs = Recordset::create('Index\World\Model');
// SELECT * FROM world WHERE id = 100
$result = $rs->find(100);
var_dump($result);

namespace Index\World;

class Model extends \Kotchasan\Orm\Field
{
  /**
   * ชื่อของการเชื่อมต่อ ใช้สำหรับโหลด config จาก settings/database.php
   *
   * @var string
   */
  protected $conn = 'mysql';

  /**
   * ชื่อตาราง
   *
   * @var string
   */
  protected $table = 'world';
}

$rs = Recordset::create('Index\World\Model');

// SELECT * FROM `gcms_plus`.`world` AS world WHERE `world`.`id` = 1
$result = $rs->find(1);
var_dump($result);

// SELECT `id`, `created_at` FROM `gcms_plus`.`world` AS world WHERE `world`.`id` = 1 LIMIT 1
$search = $rs->where($id)->first('id', 'created_at');
echo $search->id.'='.$search->created_at;

// SELECT `id`, `created_at` FROM `gcms_plus`.`world` AS world WHERE `id` IN (1, 2, 3)
$query = $rs->where(array('id', array(1, 2, 3)));
foreach ($query->execute('id', 'created_at') as $item) {
  echo $item->id.'='.$item->created_at;
}

// SELECT `id`, `created_at` FROM `gcms_plus`.`world` AS world WHERE `id` IN (1, 2, 3)
$query = $rs->where(array('id', array(1, 2, 3)));
foreach ($query->execute('id', 'created_at') as $item) {
  // แก้ไขข้อมูลเป็นวันนี้
  $item->created_at = date('Y-m-d H:i:s');
  // UPDATE `gcms_plus`.`world` SET `id` = 1, `created_at` = '2016-09-14 20:41:36' WHERE `id` = 1
  $item->save();
}

$row = \Index\World\Model::create();
$row->created_at = date('Y-m-d H:i:s');
// INSERT INTO `gcms_plus`.`world` (`created_at`) VALUES ('2016-09-14 20:41:36')
// คืนค่า id ของรายการที่เพิ่มใหม่
echo $row->save();

// UPDATE `gcms_plus`.`world` SET `created_at` = '2016-09-14 20:41:36'
$rs->updateAll(array(
  'created_at' => date('Y-m-d H:i:s')
));

// SELECT COUNT(*) AS `count` FROM `gcms_plus`.`world` AS world
$count = $rs->count();

// TRUNCATE TABLE `gcms_plus`.`world`
$rs->emptyTable();

$query = $rs->where(array(
  array('MONTH(created_at)', 9),
  array('DAY(created_at)', 16)
));
/*
  SELECT COUNT(*) AS `count` FROM `gcms_plus`.`world` AS world
  WHERE MONTH(created_at) = 9 AND DAY(created_at) = 16
 */
echo 'พบข้อมูลทั้งหมด '.$query->count().' เร็คคอร์ด';
/*
  SELECT * FROM `gcms_plus`.`world` AS world
  WHERE MONTH(created_at) = 9 AND DAY(created_at) = 16
  ORDER BY `id` DESC LIMIT 5,10
 */
foreach ($query->take(5, 10)->order('id DESC')->execute() as $item) {
  print_r($item);
}