i have a problem with my temperature sensor (GT-WT-01). I receive irregular values with 70°C.
Yet, I want to delete this directly in the Database.
I watch into the Database and Create a Statement:
WHERE id IN
left join deviceAttribute ON attributeValueNumber.deviceAttributeId = deviceAttribute.id
where value = 70
AND attributeName = “temperature”)”
I want a cronjob with sqlite3.
But, Error: database is locked.
Is it possible to do this or I will use pimatic-filter?