Esper-home-temperature-status.md

create window HomeStatus.win:length(1) as (status string);
insert into HomeStatus select 'ok' as status 
from BedroomTemperatureStatus as bedroom ,
HallTemperatureStatus as hall
where bedroom.status = hall.status and bedroom.status = 'ok';

insert into HomeStatus select 'warning' as status 
from BedroomTemperatureStatus as bedroom ,
     HallTemperatureStatus as hall
where bedroom.status = 'warning' or hall.status = 'warning';


insert into HomeStatus select 'alert' as status 
from BedroomTemperatureStatus as bedroom ,
     HallTemperatureStatus as hall
where bedroom.status = hall.status and bedroom.status = 'alert';

@Name("out") select status from HomeStatus ;