Cake3 自分用メモ(Controllerに直接SQLを書く方法)

Controllerに直接SQLを書く方法

<?php
namespace App¥Controller

use Cake\Datasource\ConnectionManager;

class HogeController extends AppController
{
    public function index()
    {
         $conn = ConnectionManager::get('default');
         $results = $conn->query('SELECT * FROM articles')->fetchAll('assoc');

参考
http://book.cakephp.org/3.0/en/orm/database-basics.html