Delete wrong values into the Databases

---

Hey Community,

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:

“DELETE
from attributeValueNumber
WHERE id IN
(select attributeValueNumber.id
from attributeValueNumber
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?

better to use pimatic filter.
and as long as pimatic is running the database cannot be edited.
and better to make a backup first …