<?php
require '../vendor/autoload.php';
$client = new \RBM\SqlQuery\Select('client');
$client->filter()->eq('id', 2);
$select = new \RBM\SqlQuery\Select('projet');
$select->filter()->eq($client, 2);
$r = new RBM\SqlQuery\Renderer\SqlServer();
echo $r->render($select);
<?php
/**
* Created by JetBrains PhpStorm.
* User: rbm
* Date: 28/04/13
* Time: 17:19
* To change this template use File | Settings | File Templates.
*/
require 'bootstrap.php';
$select = new \RBM\SqlQuery\Select("Project");
$select->cols("project_id", "name");
$select->setGroup(["project_id", "name"]);
$messages = $select->join("ProjectMessages", "project_id");
$messages->having()->greaterThanEquals(new \RBM\SqlQuery\Func("COUNT", [new \RBM\SqlQuery\Column("message_id", $messages->getTable())]), 0);
$renderer = new \RBM\SqlQuery\Renderer\Generic();
echo $renderer->format($select);
