Parsing complicated query parameters
- by Will
My Python server receives jobs that contain a list of the items to act against, rather like a search query term; an example input:
(Customer:24 OR Customer:24 OR (Group:NW NOT Customer:26))
To complicate matters, customers can join and leave groups at any time, and the job should be updated live when this happens.
How is best to parse, apply and store (in my RDBMS) this kind of list of constraints?