Comparison operators JSQL

[tshemsedinov]

We have following syntax for Cursor.filter(fn):

(person) => (
  person.name !== '' &&
  person.age > 18 &&
  person.city === 'Rome'
)

But we need also declarative comparison operators for Category.find(query) and Cursor.find(query)

• === Equal to { field: value }
• !== Not equal to { field: '!value' }
• > Greater than { field: '>value' }
• < Less than { field: '<value' }
• >= Greater than or equal to { field: '>=value' }
• <= Less than or equal to { field: '<=value' }
• Range { field: 'from..to' }
• Logical and { age: '>20', city: 'Odessa' }
• Logical or [ { age: '>20' }, { city: 'Odessa' } ]

[tshemsedinov]

Preprocess:

• { name: 'Marcus' } to { name: ['=', 'Marcus'] }
• { name: '!Marcus' } to { name: ['!', 'Marcus'] }
• { age: '>20' } to { age: ['>', '20'] }
• { score: '200..500' } to { score: [ ['>=', 200], ['<=', 500] ] }

Convert to MongoDB syntax:

• { name: ['!', 'Marcus'] } to { name: { $ne: 'Marcus' } }
• { age: ['>', '20'] } to { age: { $gt: 20 } }
• { age: ['<', '20'] } to { age: { $lt: 20 } }
• { age: ['>=', '20'] } to { age: { $gte: 20 } }
• { age: ['<=', '20'] } to { age: { $lte: 20 } }
• { score: [ ['>=', 200], ['<=', 500] ] } to { score: { $gt: 200, $lt: 500 } }
• { city: ['Kiev', 'Roma'] } to { city: { $in: ['Kiev', 'Roma'] } }
• { city: { not: ['Kiev', 'Roma'] } } to { city: { $nin: ['Kiev', 'Roma'] } }