mysql - 如何在 Phalcon 中建立有条件的连接

Question

我有以下 SQL:

SELECT  `settings`.*, `character_settings`.`value`
FROM    `settings`
LEFT JOIN 
       `character_settings` 
ON     `character_settings`.`setting_id` = `settings`.`id`
        AND `character_settings`.`character_id` = '1'  

如何使用 Phalcon CreateBuilder() 重写相同的查询？

Answer 1

尝试这样的事情:

$rows = $this->modelsManager
             ->createBuilder()
             ->columns(array('Settings.*', 'CharacterSettings.value as char_value'))
             ->from('Settings')
             ->leftJoin('CharacterSettings', 'Settings.id = CharacterSettings.setting_id AND CharacterSettings.character_id  = 1')
             ->getQuery()
             ->execute();

foreach ($rows as $row) {
    print_r($row->settings->id . ' : ' . $row->char_value);
}

不要忘记将数据库列作为字段添加到模型中:

class Settings extends Phalcon\Mvc\Model
{
    public $id;

    public $name;

    ...