BACKEND: Improve Boolean Comparison #9
Description
When making boolean comparisons, there are a couple of difficulties to consider from the parsed string information:
- When is a variable actually a constant, number, or a reference to a column from a table?
- How can you convert that string information to its actual value and data type?
- What is the best way to do the comparison operation with a comparison character?
A initial solution was to use eval(), however this is not ideal for many reasons as it converts a string into actual code. There could be some different approaches to improving this part of the code for readability, performance, and security. One idea was to use a class to handle the different data type conversions and perform comparisons based on them.
A current not so elegant solution can be found in the evalRemove branch of the booleanNodes.py file.