[NFR] Multiple Modules Models Alias and leftJoin

[ovr]

Hi all,
I have model

class Event
  extends Model
{
  public $id;
  public $created_at;
  public $user_id;
  public $type_id;
  public $product_id;

  public function initialize()
  {
    $this->hasOne('product_id', 'Product\\Model\Product', 'id', array(
       'foreignKey' => true,
       'alias' => 'Product'
    ));
    $this->hasOne('user_id', 'User\\Model\User', 'id', array(
      'foreignKey' => true,
      'alias' => 'User'
    ));
    $this->hasOne('type_id', 'User\\Model\Events\Type', 'id', array(
      'foreignKey' => true,
      'alias' => 'Type'
    ));
    $this->hasMany('user_id', 'User\\Model\Follow\User', 'author_user_id', array(
      'foreignKey' => true,
      'alias' => 'Followers'
    ));
  }

  /**
   * Independent Column Mapping.
   */
  public function columnMap() {
    return array(
      'id' => 'id',
      'created_at' => 'created_at',
      'user_id' => 'user_id',
      'type_id' => 'type_id',
      'product_id' => 'product_id'
    );
  }
}

I would like to use

        $builder = $this->modelsManager->createBuilder('e')
            ->addFrom('User\Model\Event', 'e')

            ->leftJoin('e.User', null, 'u')

On Forum http://forum.phalconphp.com/discussion/766/multiple-relations-and-left-joind-models

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[jodator]

You can use multiple joins from the same model just like you wrote.

$builder->join('Tagged', 'Category.type = "Category" and Category.foreignKey = User.id', 'Category');
$builder->join('Tagged', 'Group.type = "Group" and Group.foreignKey = User.id', 'Group');

If this is not the case of your question please describe more clearly ;)

[ovr]

@jodator
I have multi modules models structure and i want to use alias what i inizialize in model to query and don`t write like it Category" and Category.foreignKey = User.id
but when i try to write in 1 arg leftJoin Product
it throws exception like \Product Model not found
sry for my english

[jodator]

Ah, OK. I didn't use multi modules structure before. But if Phalcon is not using aliases then it would be nice if it does use them.

[ovr]

@jodator Now i am porting big application more then 30k lines from zf1+doctrine1 to phalcon and now have big problem with no leftjoin on alias and 100500 select query on primary key when i use relations.
exml

$products = \Product\Model\Products\Table::find()**; // 1 select for 10 products
foreach($products as $product)
{
    echo $product->User->username; // 1 select for alias User 
}

Total 1*10 + 1 =11selects
It is very sad that so bad right now

I think you can use something like this:

<?php

namespace Model\Extreme;

class ProfileNote extends \Phalcon\Mvc\Model
{
    public $id;
    public $user_id;
    public $notes;
    public $added_by;
    public $dt;
    public $edited_by;
    public $edited_dt;

    /**
     * @return string
     * @global $wpdb
     */
    public function getSource()
    {
        global $wpdb;
        return $wpdb->prefix . 'em_profile_notes';
    }

    public function initialize()
    {
        $this->belongsTo('user_id',   '\\Model\\WordPress\\User', 'ID', array('alias' => 'User'));
        $this->belongsTo('added_by',  '\\Model\\WordPress\\User', 'ID', array('alias' => 'Creator'));
        $this->belongsTo('edited_by', '\\Model\\WordPress\\User', 'ID', array('alias' => 'Editor'));
    }

    public static function getComments($user_id)
    {
        $di   = \Phalcon\DI::getDefault();
        $mgr  = $di->get('modelsManager');
        $phql = "
            SELECT Note.*, Creator.*, Editor.*
                FROM \\Model\\Extreme\\ProfileNote AS Note
                    LEFT JOIN \\Model\\WordPress\\User AS Creator ON added_by = Creator.ID
                    LEFT JOIN \\Model\\WordPress\\User AS Editor ON edited_by = Editor.ID
                WHERE user_id = ?0
                ORDER BY dt
        ";

        return $mgr->executeQuery($phql, array(0 => $user_id));
    }
}

[ovr]

@sjinks Cпасибо за подсказку но было бы тут одно такое место да. а когда тут 50 таблиц куча сущностей и еще большей связей нельзя так делать. а еще в моделях есть метод $this->getModelsManager() ))

А QueryBuilder заюзать не вариант?

[ovr]

@sjinks Там в 1 аргументе нельзя использовать алиас он думает что это имя модели + надо дописывать связь и алиас в итоге это избыточно + он еще делает как я понимаю алиас токо для запроса а модель захочет использовать так $even->{"\User\Model\User"};

[ovr]

Could anyone implement this?

[ovr]

Now i am porting profiler from PhalconEye cms to current project on phalcon
On page 922 Mysql Db quieries Because phalcon doesn`t fetch result with leftJoin and when i use relation it go to select it from db on primary key
i use

            ->leftJoin('Product\Model\Product', 'e.product_id = Product.id', 'Product')
            ->leftJoin('User\Model\Shop', 'Product.shop_id = Shop.id', 'Shop')

But on foreach phalcon use select.
Its a realy hight task.

@phalcon It's really just a wild hole in ORM. While such things will not work excellent library can throw. People do not need a super fast framework that can`t perform 1 query and makes sense from hundreds of such a framework = zero.90% application work time is ORM not MVC and etc