Exclude from search Lithium

Question

I would like to exclude the results of calling the lithium model find() method. I need to do this for models with MongoDB and MySQL data sources, but in SQL, I mean something like WHERE myfield NOT IN (1,2,3) .

I would just like to pass the not clause in the conditions array, as shown below, but this is not possible.

 Item::all(array('conditions' => array('not' => array('myfield' => array(1,2,3)))); 

So my question is: is it possible in Lithuania the way I forgot? And if not, what will be the lithium-ion way to implement it for my models?

Answer 1

The ease of filtering for MongoDB can be easily achieved as follows:

 Item::all(array('conditions' => array('myfield' => array( '$nin' => array(1,2,3) )) )); 

If this is what you are doing, you can even create a custom search for it:

 class MyModel extends \lithium\data\Model { public static function __init() { parent::__init(); static::finder('notin', function($self, $params, $chain) { // Take all array keys that are not option keys $array = array_diff_key($params['options'], array_fill_keys(array('conditions', 'fields','order','limit','page'),0)); // Clean up options leaving only what li3 expects $params['options'] = array_diff_key($params['options'], $array); $params['options']['conditions'] = array( 'myfield' => array( '$nin' => $array ) ); return $chain->next($self, $params, $chain); }); } } 

And name it as follows:

 MyModel::notin(array(1,2,3)); 

In the same way, you can create a custom search for MySQL sources.

As you probably see, this creates some problems if you pass something like array('fields'=>$array) as it will overwrite this option. What happens is that ::notin() (search engines in general) has clear behavior for the (array, null) signature. If this happens, he considers that the first array is the parameters, and the crawler did not accept the arguments. Using notin($array,array()) interrupts the previous search because the first argument ends in $params['notin'] when the real second argument (parameters) is passed.

If you mix data sources on the fly here, I would create a custom model that does not inherit \ lithium \ data \ Model and does not delegate it
to different models and create conditions based on the data source of the final models.

 class MyFacadeModel { public static function byNotIn($conditions, $source) { return ($source == "mongodb") ? $source::find( $rewrittenConditions) : $source::find( $rewrittenConditionsForMysql ); } } 

(The code may be a little wrong, as it is mostly extracted from the top of the head)

Answer 2

To clarify, the Lithium MongoDB adapter supports most SQL comparison statements as a convenience, so for Mongo or MySQL you can simply write a query like this:

 Item::all(array('conditions' => array( 'myfield' => array('!=' => array(1,2,3)) ))); 

And he should give you the expected results. For MySQL, the query should look something like this:

 SELECT * FROM items WHERE myfield NOT IN (1, 2, 3); 

And in Mongo:

 db.items.find({ myfield: { $nin: [1, 2, 3] }})