Written once a second a prepared INSERT, four bound values
the last reading
-- C
rows (TANK_TEMP)
--
min .. max
--
mean
-- C
rows whose tag looks like an attack
--
stored as text
The summary is asked of the database every ten seconds (--).
The last five rows SQL.qry: rows become <item> elements
| the first summary comes after ~10 s |
An SQL NULL, read back in script:
--Look for a tag the tag is BOUND, never pasted into the SQL
The engine runs
SELECT count(*), max(ts) FROM reading WHERE tag = ?
with what you typed as the one parameter. Try the attack: it finds the rows that carry that text - and the table is still there.