/**
* @param string|object $class_name_or_obj
* @param array $params
* @param lmbDbConnection $conn
* @param string $sql
* @return lmbARQuery
*/
static function create($class_name_or_obj, $params = array(), $conn = null, $sql = '')
{
if (!$conn) {
$conn = lmbToolkit::instance()->getDefaultDbConnection();
}
if (!is_object($class_name_or_obj)) {
$class_name_or_obj = new $class_name_or_obj();
}
$query = new lmbARQuery($class_name_or_obj, $conn, $sql, $params);
if (isset($params['criteria']) && $params['criteria']) {
$criteria = lmbSQLCriteria::objectify($params['criteria']);
} else {
$criteria = lmbSQLCriteria::create();
}
$has_class_criteria = false;
if (isset($params['class'])) {
$filter_object = new $params['class']();
$criteria = $filter_object->addClassCriteria($criteria);
$has_class_criteria = true;
}
if (!$has_class_criteria) {
$criteria = $class_name_or_obj->addClassCriteria($criteria);
}
$query->where($criteria);
$sort_params = isset($params['sort']) && $params['sort'] ? $params['sort'] : $class_name_or_obj->getDefaultSortParams();
$query->order($sort_params);
if (isset($params['group']) && $params['group']) {
$query->group($params['group']);
}
$join = isset($params['join']) && $params['join'] ? $params['join'] : array();
if (!is_array($join)) {
$join = explode(',', $join);
}
foreach ($join as $relation_name => $params_or_relation_name) {
if (is_numeric($relation_name)) {
$query->eagerJoin(trim($params_or_relation_name));
} else {
$query->eagerJoin(trim($relation_name), $params_or_relation_name);
}
}
$attach = isset($params['attach']) && $params['attach'] ? $params['attach'] : array();
if (!is_array($attach)) {
$attach = explode(',', $attach);
}
foreach ($attach as $relation_name => $params_or_relation_name) {
if (is_numeric($relation_name)) {
$query->eagerAttach(trim($params_or_relation_name));
} else {
$query->eagerAttach(trim($relation_name), $params_or_relation_name);
}
}
return $query;
}
function testEmptyCriteriaChainingIsSafe()
{
$c = lmbSQLCriteria::create()->add(new lmbSQLCriteria());
$this->assertEqual($c->toStatementString(), '1 = 1 AND 1 = 1');
}