Scheduler Status

[Zandkever]

Hi,

I am implementing a UI for airco systems and use scheduler with events as a widget to schedule on/off times for the individual units. So far so good.

In the UI I would like to show additionally the status of each scheduler or for specific events in the scheduler, for the simple reason to quickly see if a schedule/event is active or not.
How do I retrieve the status of a schedule and its events to enable writing it to an object?

[admin]

Only via DB queries, change IDs to your scheduler/events IDs:

Code:

12345678910111213

-- scheduler id = 1 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('1/1/1', active) -- event id = 2 active = db:getone('SELECT active FROM scheduler_events WHERE id=?', id) active = toboolean(active) grp.checkupdate('1/1/2', active)

[Zandkever]

Thanks for the quick response, I got it working.

[davidchispas]

Hello, how can I simplify the script following this criterion?

Code:

1234567891011121314151617181920212223242526272829

-- scheduler1 id = 1 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('40/0/' .. id, active) -- scheduler2 id = 2 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('40/0/' .. id, active) -- scheduler3 id = 3 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('40/0/' .. id, active) -- scheduler4 id = 4 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('40/0/' .. id, active) -- scheduler5 id = 5 active = db:getone('SELECT active FROM schedulers WHERE id=?', id) active = toboolean(active) grp.checkupdate('40/0/' .. id, active)

[admin]

Use a numeric for loop:

Code:

1234

for id = 1, 5 do   active = db:getone('SELECT active FROM schedulers WHERE id=?', id)   grp.checkupdate('40/0/' .. id, toboolean(active)) end

[BartR]

is it also possible to adjust the time via DB queries?
In the Netherlands we can use variable hourly rates for electricity. Each hour of the day has a different rate. I'm working on a script that selects the best charging time based on when we need EV again. I just can't manage to send that time to a schedule.

[admin]

See this: https://forum.logicmachine.net/showthrea...2#pid28742

[BartR]

See this: https://forum.logicmachine.net/showthrea...2#pid28742

Thanks!

---

Maybe one more tip.
I have downloaded the config of my (HomeLynk). In the folder storage/db there is a file current.db. Here is the entire database of your homelynk.
Using a tool such as DB browser for SQLite you can easily search the entire DB and adjust advanced parts via your scripts.