Ask the tree XDB SQL, run by the engine with this page's role
(a Guest: it may read the lines, write nothing, and take in the database only through a named query)
The other way round SQLite's own query, every 5 s: the table
x is the tree's, built by the engine from
xdb('..')| line | name | unit | readings | mean | top |
|---|
The table
his holds a time, a point's id and a value. The names, the lines and
the units come from the tree at the moment of the query: rename a point and the next result says so.From any PostgreSQL client the same queries, as a database
psql "host=127.0.0.1 port=15432 user=eng dbname=SQL/S00" -- role Engineer psql "host=127.0.0.1 port=15433 user=mon dbname=SQL/S00" -- role Monitor, read only python pg_try.py "SELECT id, desc, val FROM \"LINE/*\".io" -- no psql? this folder's own client
On 15432 a query may also take in the database raw,
sql('CN_HIS', 'SELECT ..'),
and write the tree, UPDATE "LINE/L1".io SET hi = 70 WHERE id = 'L1_LT1'. The page may do
neither: try the last two buttons above.