Code Monkey home page Code Monkey logo

phtuning-zephir's Introduction

Phalcon Tuning

CREATE TABLE test.comments (
  id INTEGER, 
  user_id INTEGER, 
  text TEXT
);

CREATE TABLE test.users (
  id INTEGER, 
  nickname TEXT
);
/**
 * Init tuning modelsManager
 */
$di->setShared('modelsManager', function () {
    return new \Phtuning\Mvc\Model\Manager;
});
<?php   // TestController.php

namespace App\Controllers;

class TestController extends \Phalcon\Mvc\Controller
{
    /**
     * Example with PHQL
     * @Route("/test1")
     */
    public function test1Action()
    {
        $sql = 'SELECT Comments.*, Users.*
            FROM App\Models\Test\Comments AS Comments
            INNER JOIN App\Models\Test\Users AS Users ON Users.id = Comments.user_id';

        $rows = $this->modelsManager->createQuery($sql)->execute();
        
        /*
         * Standard mode:
         * Executed query count: 1 + (found rows)
         *    (if reusable option is true at Comments.php initialize then little less,
         *     http://bit.ly/1Ghxa2A)
         */
        foreach ($rows as $row) {
            $row->Comments->getUserNickName();
        }

        /*
         * Tuning mode:
         * Executed query count: 1
         */
        foreach ($rows as $row) {
            $this->modelsManager->setLazyLink($row->Comments, 'User', $row->Users);

            $row->Comments->getUserNickName();
        }
    }
    
    /**
     * Example with QueryBuilder
     * @Route("/test2")
     */
    public function test2Action()
    {
      $rows = $this->modelsManager->createBuilder()
            ->columns('Comments.*, Users.*')
            ->from(['Comments' => 'App\Models\Test\Comments'])
            ->join('App\Models\Test\Users', 'Users.id = Comments.user_id', 'Users')
            ->getQuery()
            ->execute();
      /*
       * Executed query count: 1
       */
      foreach ($rows as $row) {
          $this->modelsManager->setLazyLink($row->Comments, 'User', $row->Users);

          $row->Comments->getUserNickName();
      }
    }
}
<?php   // Users.php

namespace App\Models\Test;

class Users extends \Phalcon\Mvc\Model
{
    public function initialize()
    {
        $this->setSchema('test');

        $this->setSource('users');
    }
}
<?php   // Comments.php

namespace App\Models\Test;

class Comments extends \Phalcon\Mvc\Model
{
    public function initialize()
    {
        $this->setSchema('test');

        $this->setSource('comments');

        $this->belongsTo('user_id', 'App\Models\Test\Users', 'id', [
            'alias'    => 'User',
            'reusable' => true,
        ]);
    }

    public function getUserNickName()
    {
        return $this->User->nickname;
    }
}

phtuning-zephir's People

Contributors

tmihalik avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.