Small Swoole Db 2.3 introduce left joins :
$selector = (new TableSelector('user'))
->leftJoin('post', 'messageOwner', 'message')
;
$selector->where()
->firstCondition(new Condition(
new ConditionElement(ConditionElementType::var, 'name', 'user'),
ConditionOperator::equal,
new ConditionElement(ConditionElementType::const, 'john')
))->andCondition(new Condition(
new ConditionElement(ConditionElementType::var, 'subject', 'message'),
ConditionOperator::like,
new ConditionElement(ConditionElementType::const, '%hiring%')
))
;
packagist : https://packagist.org/packages/small/swoole-db
git : https://git.small-project.dev/lib/small-swoole-db
Top comments (0)