DIRACGrid/DIRAC — pull request #532 by graciani (2012-02-21 15:21:43+00:00)
Title: New: move buildCondition from DB -> MySQL and improve the escape

This feature should go into v6r3.

The output of buildCondition method has slightly changed, including a better escaping:
New: WHERE `Owner` = "John" AND `JobID` IN ( 1234, 1235, 4567, "456", "5454" ) AND `LastUpdate` < "2012-02-21 15:12:02.129897" ORDER BY `order1` ASC LIMIT 100
Old: WHERE Owner='John' AND JobID in ("1234","1235","4567","456","5454") AND LastUpdate < '2012-02-21 15:12:02.129897' ORDER BY order1 ASC LIMIT 100

many DB classes are implementing their own __buildCondition, they should be updated

MySQL mehod _getFields will be updated to make use of this new method.
new MySQL methods _updatedFields and _deleteFields will be written based on this new method.