[
https://issues.apache.org/jira/browse/PHOENIX-932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
alex kamil updated PHOENIX-932:
-------------------------------
Description:
add a trigger feature, calling a stored procedure in Java on DML changes
Syntax:
CREATE
TRIGGER trigger_name
trigger_time trigger_event
ON tbl_name
WHEN trigger_condition
FOR EACH ROW
CALL trigger_body
trigger_time: { BEFORE | AFTER }
trigger_condition: { condition AND|OR|NOT|>|<|= condition }
trigger_event: { UPSERT}
trigger_body: { '<Class Name>', '<Method Name>(args)'}
Example:
CREATE TRIGGER trigger1
AFTER UPSERT ON table1
FOR EACH ROW
WHEN (table1.col1 > table1.col2)
CALL 'myTriggerClass.java' , 'myMethod(table1.col1, table1.col2)';
References:
http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/04_call2.htm ,
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
was:
add a trigger feature, calling a stored procedure in Java on DML changes
Syntax:
CREATE
TRIGGER trigger_name
trigger_time trigger_event
ON tbl_name
WHEN trigger_condition
FOR EACH ROW
CALL trigger_body
trigger_time: { BEFORE | AFTER }
trigger_condition: { condition AND|OR|NOT|>|<|= condition }
trigger_event: { UPSERT}
trigger_body: { '<Java Class Name>', '<Method Name>(args)'}
Example:
CREATE TRIGGER trigger1
AFTER UPSERT ON table1
FOR EACH ROW
WHEN (table1.col1 > 3.77 * table2.col2)
CALL myTriggerClass.myMethod(table1.col1, table1.col2);
References:
http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/04_call2.htm ,
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
> db triggers
> -----------
>
> Key: PHOENIX-932
> URL: https://issues.apache.org/jira/browse/PHOENIX-932
> Project: Phoenix
> Issue Type: New Feature
> Reporter: alex kamil
>
> add a trigger feature, calling a stored procedure in Java on DML changes
> Syntax:
> CREATE
> TRIGGER trigger_name
> trigger_time trigger_event
> ON tbl_name
> WHEN trigger_condition
> FOR EACH ROW
> CALL trigger_body
> trigger_time: { BEFORE | AFTER }
> trigger_condition: { condition AND|OR|NOT|>|<|= condition }
> trigger_event: { UPSERT}
> trigger_body: { '<Class Name>', '<Method Name>(args)'}
> Example:
> CREATE TRIGGER trigger1
> AFTER UPSERT ON table1
> FOR EACH ROW
> WHEN (table1.col1 > table1.col2)
> CALL 'myTriggerClass.java' , 'myMethod(table1.col1, table1.col2)';
> References:
> http://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/04_call2.htm ,
> http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
--
This message was sent by Atlassian JIRA
(v6.2#6252)
