org.teiid.metadata.Table.getTriggers()方法的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(6.0k)|赞(0)|评价(0)|浏览(96)

本文整理了Java中org.teiid.metadata.Table.getTriggers()方法的一些代码示例,展示了Table.getTriggers()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Table.getTriggers()方法的具体详情如下:
包路径:org.teiid.metadata.Table
类名称:Table
方法名:getTriggers

Table.getTriggers介绍

暂无

代码示例

代码示例来源:origin: org.teiid/teiid-runtime

return null;
if (!t.getTriggers().isEmpty()) {
  if (columnNames != null) {
    if ((oldValues != null && oldValues.length != columnNames.length)

代码示例来源:origin: teiid/teiid

@Test public void testAfterTrigger() throws Exception {
  String ddl = "CREATE FOREIGN TABLE T ( e1 integer, e2 varchar);" +
      "CREATE TRIGGER tr ON T AFTER UPDATE AS " +
      "FOR EACH ROW \n" +
      "BEGIN ATOMIC \n" +
      "if (\"new\" is not distinct from \"old\") raise sqlexception 'error';\n" +
      "END;";
  
  Schema s = helpParse(ddl, "model").getSchema();
  Table t = s.getTable("T");
  assertEquals(1, t.getTriggers().size());
  Trigger tr = t.getTriggers().values().iterator().next();
  assertEquals("tr", tr.getName());
  assertEquals(TriggerEvent.UPDATE, tr.getEvent());
  assertNotNull(tr.getPlan());
}

代码示例来源:origin: org.jboss.teiid/teiid-engine

List<String> names = new ArrayList<String>();
for (Trigger tr : sec.getTable().getTriggers().values()) {
  int updateType = Command.TYPE_UPDATE;
  switch (tr.getEvent()) {

代码示例来源:origin: org.teiid/teiid-engine

List<String> names = new ArrayList<String>();
for (Trigger tr : sec.getTable().getTriggers().values()) {
  int updateType = Command.TYPE_UPDATE;
  switch (tr.getEvent()) {

代码示例来源:origin: teiid/teiid

List<String> names = new ArrayList<String>();
for (Trigger tr : sec.getTable().getTriggers().values()) {
  int updateType = Command.TYPE_UPDATE;
  switch (tr.getEvent()) {

代码示例来源:origin: org.teiid/teiid-engine

private void addLazyMatViewTrigger(VDBMetaData vdb, Table t, Table st, Table.TriggerEvent event) {
  String name = "ON_"+st.getName()+"_"+event.name()+"_FOR_"+t.getName()+"_FOR_LAZY_SNAPSHOT";
  String plan = "FOR EACH ROW\n"
      + "BEGIN ATOMIC\n"
      + "EXECUTE SYSADMIN.updateStaleCount(schemaName=>'"+t.getParent().getName()+"', viewName=>'"+t.getName()+"');\n"
      + "END\n";
  Trigger trigger = new Trigger();
  trigger.setName(name);
  trigger.setEvent(event);
  trigger.setPlan(plan);
  trigger.setAfter(true);
  trigger.setProperty(DDLStringVisitor.GENERATED, "true");
  st.getTriggers().put(name, trigger);
  LogManager.logDetail(LogConstants.CTX_MATVIEWS, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31256, st.getName(), t.getName()));
}

代码示例来源:origin: org.jboss.teiid/teiid-engine

private void addLazyMatViewTrigger(VDBMetaData vdb, Table t, Table st, Table.TriggerEvent event) {
  String name = "ON_"+st.getName()+"_"+event.name()+"_FOR_"+t.getName()+"_FOR_LAZY_SNAPSHOT";
  String plan = "FOR EACH ROW\n"
      + "BEGIN ATOMIC\n"
      + "EXECUTE SYSADMIN.updateStaleCount(schemaName=>'"+t.getParent().getName()+"', viewName=>'"+t.getName()+"');\n"
      + "END\n";
  Trigger trigger = new Trigger();
  trigger.setName(name);
  trigger.setEvent(event);
  trigger.setPlan(plan);
  trigger.setAfter(true);
  trigger.setProperty(DDLStringVisitor.GENERATED, "true");
  st.getTriggers().put(name, trigger);
  LogManager.logDetail(LogConstants.CTX_MATVIEWS, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31256, st.getName(), t.getName()));
}

代码示例来源:origin: teiid/teiid

private void addLazyMatViewTrigger(VDBMetaData vdb, Table t, Table st, Table.TriggerEvent event) {
  String name = "ON_"+st.getName()+"_"+event.name()+"_FOR_"+t.getName()+"_FOR_LAZY_SNAPSHOT";
  String plan = "FOR EACH ROW\n"
      + "BEGIN ATOMIC\n"
      + "EXECUTE SYSADMIN.updateStaleCount(schemaName=>'"+t.getParent().getName()+"', viewName=>'"+t.getName()+"');\n"
      + "END\n";
  Trigger trigger = new Trigger();
  trigger.setName(name);
  trigger.setEvent(event);
  trigger.setPlan(plan);
  trigger.setAfter(true);
  trigger.setProperty(DDLStringVisitor.GENERATED, "true");
  st.getTriggers().put(name, trigger);
  LogManager.logDetail(LogConstants.CTX_MATVIEWS, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31256, st.getName(), t.getName()));
}

代码示例来源:origin: teiid/teiid

} else if (table.getTriggers().containsKey(triggerName)) {
  throw new DuplicateRecordException(QueryPlugin.Event.TEIID31212, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31212, triggerName, table.getFullName()));
t.setPlan(triggerDefinition);
table.getTriggers().put(triggerName, t);
return;

代码示例来源:origin: org.jboss.teiid/teiid-engine

} else if (table.getTriggers().containsKey(triggerName)) {
  throw new DuplicateRecordException(QueryPlugin.Event.TEIID31212, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31212, triggerName, table.getFullName()));
t.setPlan(triggerDefinition);
table.getTriggers().put(triggerName, t);
return;

代码示例来源:origin: org.teiid/teiid-engine

} else if (table.getTriggers().containsKey(triggerName)) {
  throw new DuplicateRecordException(QueryPlugin.Event.TEIID31212, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID31212, triggerName, table.getFullName()));
t.setPlan(triggerDefinition);
table.getTriggers().put(triggerName, t);
return;

代码示例来源:origin: org.jboss.teiid/teiid-engine

for (Trigger tr : table.getTriggers().values()) {
  String generated = tr.getProperty(GENERATED, false);
  if (generated == null || !Boolean.valueOf(generated)) {

代码示例来源:origin: teiid/teiid

for (Trigger tr : table.getTriggers().values()) {
  String generated = tr.getProperty(GENERATED, false);
  if (generated == null || !Boolean.valueOf(generated)) {

代码示例来源:origin: org.teiid/teiid-engine

for (Trigger tr : table.getTriggers().values()) {
  String generated = tr.getProperty(GENERATED, false);
  if (generated == null || !Boolean.valueOf(generated)) {

代码示例来源:origin: teiid/teiid

for (Trigger tr : t.getTriggers().values()) {
  int commandType = Command.TYPE_INSERT;
  if (tr.getEvent() == TriggerEvent.DELETE) {

代码示例来源:origin: org.jboss.teiid/teiid-engine

for (Trigger tr : t.getTriggers().values()) {
  int commandType = Command.TYPE_INSERT;
  if (tr.getEvent() == TriggerEvent.DELETE) {

代码示例来源:origin: org.teiid/teiid-engine

for (Trigger tr : t.getTriggers().values()) {
  int commandType = Command.TYPE_INSERT;
  if (tr.getEvent() == TriggerEvent.DELETE) {

相关文章

微信公众号

最新文章

更多