The problem I’m having
Writing a unit test with condition (exact with <= )
The context of why I’m trying to do this
Charging capability of a Electric car charging station is classifid as normal or fast, normal Electric car charging station are classified with <= 22 kW
Value change of another column if value is smaller than.
What I’ve already tried
- Integrating the condition in the unittest code
- casting the test cases to different datatypes
Some example code or error messages
An error occurred during execution of unit test 'test_chargingtype'. There may be an error in the unit test definition: check the data types.
Database Error
invalid input syntax for type numeric: "< 22"
LINE 24: cast('< 22' as numeric)
^