fix chunking for different result types
We should be able to fix the commit chunking for different result_types by setting result_number, result_string and result_boolean to None before assigning the observation.value.
If we don't do this, then sqlalchemy is throwing a compile error:
sqlalchemy.exc.CompileError: INSERT value for column observation.result_number is explicitly rendered as a boundparameter in the VALUES clause; a Python-side value or SQL expression is required
Which again should be fixed by providing None as the python-side value.
Edited by Joost Hemmen