Hello, I performed some test and my first idea is:
Manage operator field for BETWEEN operand as an array/list with size 2 (~ to IN). I have developed a skeleton and I'm fixing some tests. Do you have other ideas? Regards, 2014-09-16 12:59 GMT+02:00 Kasper Sørensen <[email protected]>: > Hi Francisco, > > These sound like cool additions in deed. I think you're right wrt. where > the impact would be. > > Would also need to check other modules that does smart things with query > optimizations, but that comes second. > > Not sure how to fix the BETWEEN case since FilterItem only takes one > operand. Any ideas? > Den 16/09/2014 11.52 skrev "Francisco Javier Cano Bailen" < > [email protected]>: > > > Hello, > > > > Thanks Kasper for your first support. > > > > Regarding the OperatorType, MetaModel provides: > > > > EQUALS_TO("="), DIFFERENT_FROM("<>"), LIKE("LIKE"), GREATER_THAN(">"), > > LESS_THAN("<"), IN("IN"), > > > > If it is possible, I would like to implement "<=", ">="" and "BETWEEN" > > operator types. > > > > From my first review and test, I'm going to write new code in: > > > > FilterItem.java > > - toSql method > > - comparator method > > OperatorType.java > > - new OperatorType <= , >= and BETWEEN > > Query.java > > - BETWEEN operator syntax is BETWEEN X AND Y => manage Y operand without > > operator > > > > From your point of view, Do you have other ideas in mind? > > > > Regards, > > > > -- > > > > Francisco Javier Cano > > Senior Developer > > > > > > <http://www.stratio.com/> > > Avenida de Europa, 26. Ática 5. 3ª Planta > > 28224 Pozuelo de Alarcón, Madrid > > Tel: +34 91 352 59 42 // *@stratiobd <https://twitter.com/StratioBD>* > > > -- Francisco Javier Cano Senior Developer <http://www.stratio.com/> Avenida de Europa, 26. Ática 5. 3ª Planta 28224 Pozuelo de Alarcón, Madrid Tel: +34 91 352 59 42 // *@stratiobd <https://twitter.com/StratioBD>*
