Multiple join about pixie HOT 4 CLOSED

Have you tried? :)

from pixie.

Wed, 10 Dec 2014 08:14:05 -0800 от Pavel Puchkin [email protected]:

Have you tried? :)
—
Reply to this email directly or view it on GitHub .

пример
$connection = new \Pixie\Connection('mysql', $config);
$QB = new \Pixie\QueryBuilder\QueryBuilderHandler($connection);

$qry = $QB->table("usr AS u")
->select(['DISTINCT u.id', 'ua.usrid'])
->join('usractive AS ua', 'ua.usrid', '=', 'u.id')
->join('usractive AS ua2', function($table)
{
$table->on('ua2.usrid', '<>', 'u.id');
$table->on('ua2.somefield', '=', 'Yes');
})
->where('u.id', '=', 1);

echo $queryObj = $qry->getQuery()->getRawSql();

result
SELECT DISTINCT u.id, ua.usrid FROM usr AS u INNER JOIN usractive AS ua ON ua.usrid = u.id INNER JOIN usractive AS ua2 ON ua2.usrid <> u.id AND ua2.somefield = Yes WHERE u.id = 1
Error Table 'usr AS u' doesn't exist

it works if in adapter class Mysql set
protected $sanitizer = '`'; -> protected $sanitizer = '';
it's no error but with 
sanitizer
may be better

from pixie.

This is because to use aliases in joins, you need to mark table name as a raw statement (at least until #48 is not accepted), something like that: QB::join(QB::raw('table AS table_alias')).

from pixie.

@pavelinside A better approach is implemented by @neoascetic #48 .

Please use master branch if you want use the new approach.

from pixie.