If [_value] column is null in the last record, last() returns the previous record with a non-null value.
My last record with a non-null _value has the empty string for _value.
So far, the row is correctly identified.
But by the time I read _value from the result returned in Python, the record does not hold the empty string "" but None.
I verified that the value of _value is really the empty string in the database and not None by experimenting with filters (see commented code).
I find it more intuitive to leave the empty string as empty string in Python.
Specifications
Code sample to reproduce problem
Expected behavior
[{'result': '_result', 'table': 0, '_time': datetime.datetime(2023, 3, 2, 18, 47, 7, 547036, tzinfo=tzutc()), '_value': ''}]
Actual behavior
[{'result': '_result', 'table': 0, '_time': datetime.datetime(2023, 3, 2, 18, 47, 7, 547036, tzinfo=tzutc()), '_value': None}]
Additional info
last()
function:My last record with a non-null
_value
has the empty string for_value
. So far, the row is correctly identified. But by the time I read_value
from the result returned in Python, the record does not hold the empty string""
butNone
.I verified that the value of
_value
is really the empty string in the database and notNone
by experimenting with filters (see commented code). I find it more intuitive to leave the empty string as empty string in Python.