How to delay a start of a query?

[Jiri]

Currently querying RDBMS on ‘start’ of the application. I have a need to delay the query by N seconds. How can I achieve that? Code snippet below:

define trigger StartTrigger at 'start';

@store(type = "rdbms", jdbc.url="", username ="", password="", table.name="", jdbc.driver.name="org.postgresql.Driver")

define table CepRulesTable(columnA string);

@info(name='StartTriggerJoinQuery')

from StartTrigger join CepRulesTable as t on t.columnA=="abc"

select t.columnA

insert into allCepRules;

[Senthuran Ambalavanar]

Hi,

We can use the Delay Window[1] as follows to delay the start event by 5 seconds (N = 5)

from StartTrigger#window.delay(5 sec)
select *
insert into DelayedStartStream;

We can then use the DelayedStartStream to perform the join.

from DelayedStartStream join CepRulesTable as t on t.columnA=="abc"

select t.columnA
insert into allCepRules;

[1] https://siddhi.io/en/v5.1/docs/api/latest/#delay-window

Thanks,

Senthuran.

--
Siddhi homepage: http://siddhi.io/
Siddhi Github repo: https://github.com/siddhi-io/siddhi
 
You received this message because you are subscribed to the Google Groups "Siddhi-dev" group.
To post to this group, send email to siddh...@googlegroups.com
To unsubscribe from this group, send email to siddhi-dev+...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/siddhi-dev?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups "siddhi-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to siddhi-dev+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/siddhi-dev/204382ee-cfcb-4441-9fd0-af611faaecdan%40googlegroups.com.

--

Senthuran Ambalavanar | Senior Software Engineer | WSO2 Inc.

(m) +94 757 875 887 | (e) sent...@wso2.com | (b) https://medium.com/@senthuran16