Package org.teiid.query.sql.lang

Examples of org.teiid.query.sql.lang.AlterTrigger

48
49
50
51
52
53
54
55
56
57
58
    alterView.setDefinition((QueryCommand) QueryParser.getQueryParser().parseCommand("/*+ cache */ SELECT 1"));
    helpTest("alter view x as /*+ cache */ select 1", "ALTER VIEW x AS\n/*+ cache */ SELECT 1", alterView);
  }
 
  @Test public void testAlterTrigger() throws Exception {
    AlterTrigger alterTrigger = new AlterTrigger();
    alterTrigger.setTarget(new GroupSymbol("x"));
    alterTrigger.setEvent(TriggerEvent.UPDATE);
    alterTrigger.setDefinition((TriggerAction) QueryParser.getQueryParser().parseUpdateProcedure("for each row begin end"));
    helpTest("alter trigger on x instead of update as for each row begin end", "ALTER TRIGGER ON x INSTEAD OF UPDATE AS\nFOR EACH ROW\nBEGIN\nEND", alterTrigger);
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    alterTrigger.setDefinition((TriggerAction) QueryParser.getQueryParser().parseUpdateProcedure("for each row begin end"));
    helpTest("alter trigger on x instead of update as for each row begin end", "ALTER TRIGGER ON x INSTEAD OF UPDATE AS\nFOR EACH ROW\nBEGIN\nEND", alterTrigger);
  }
 
  @Test public void testAlterDisabled() throws Exception {
    AlterTrigger alterTrigger = new AlterTrigger();
    alterTrigger.setTarget(new GroupSymbol("x"));
    alterTrigger.setEvent(TriggerEvent.UPDATE);
    alterTrigger.setEnabled(false);
    helpTest("alter trigger on x instead of update disabled", "ALTER TRIGGER ON x INSTEAD OF UPDATE DISABLED", alterTrigger);
  }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
    alterTrigger.setEnabled(false);
    helpTest("alter trigger on x instead of update disabled", "ALTER TRIGGER ON x INSTEAD OF UPDATE DISABLED", alterTrigger);
  }
 
  @Test public void testCreateTrigger() throws Exception {
    AlterTrigger alterTrigger = new AlterTrigger();
    alterTrigger.setCreate(true);
    alterTrigger.setTarget(new GroupSymbol("x"));
    alterTrigger.setEvent(TriggerEvent.UPDATE);
    alterTrigger.setDefinition((TriggerAction) QueryParser.getQueryParser().parseUpdateProcedure("for each row begin end"));
    helpTest("create trigger on x instead of update as for each row begin end", "CREATE TRIGGER ON x INSTEAD OF UPDATE AS\nFOR EACH ROW\nBEGIN\nEND", alterTrigger);
  }
View Full Code Here
47
48
49
50
51
52
53
54
    Query q = (Query)alterProc.getDefinition().getResultsCommand();
    assertTrue(((ElementSymbol)q.getSelect().getSymbol(0)).isExternalReference());
  }
 
  @Test public void testAlterTriggerInsert() {
    AlterTrigger alterTrigger = (AlterTrigger) helpResolve("alter trigger on SmallA_2589 instead of insert as for each row select new.intkey;", RealMetadataFactory.exampleBQTCached());
    assertNotNull(alterTrigger.getTarget().getMetadataID());
  }
View Full Code Here
TOP

Related Classes of org.teiid.query.sql.lang.AlterTrigger

  • org.teiid.query.parser.TestParseAlter
  • org.teiid.query.resolver.TestAlterResolving
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.