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

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

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

Table.getUpdatePlan介绍

暂无

代码示例

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

  1. private static String getPlanForEvent(Table t, TriggerEvent event) {
  2. switch (event) {
  3. case DELETE:
  4. return t.getDeletePlan();
  5. case INSERT:
  6. return t.getInsertPlan();
  7. case UPDATE:
  8. return t.getUpdatePlan();
  9. }
  10. throw new AssertionError();
  11. }

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

  1. private static String getPlanForEvent(Table t, TriggerEvent event) {
  2. switch (event) {
  3. case DELETE:
  4. return t.getDeletePlan();
  5. case INSERT:
  6. return t.getInsertPlan();
  7. case UPDATE:
  8. return t.getUpdatePlan();
  9. }
  10. throw new AssertionError();
  11. }

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

  1. private static String getPlanForEvent(Table t, TriggerEvent event) {
  2. switch (event) {
  3. case DELETE:
  4. return t.getDeletePlan();
  5. case INSERT:
  6. return t.getInsertPlan();
  7. case UPDATE:
  8. return t.getUpdatePlan();
  9. }
  10. throw new AssertionError();
  11. }

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

  1. public String getUpdatePlan(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  2. Table tableRecordImpl = (Table)groupID;
  3. if (!tableRecordImpl.isVirtual()) {
  4. throw new QueryMetadataException(QueryPlugin.Event.TEIID30359, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30359, tableRecordImpl.getFullName(), "Update")); //$NON-NLS-1$
  5. }
  6. return tableRecordImpl.isUpdatePlanEnabled()?tableRecordImpl.getUpdatePlan():null;
  7. }

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

  1. public String getUpdatePlan(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  2. Table tableRecordImpl = (Table)groupID;
  3. if (!tableRecordImpl.isVirtual()) {
  4. throw new QueryMetadataException(QueryPlugin.Event.TEIID30359, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30359, tableRecordImpl.getFullName(), "Update")); //$NON-NLS-1$
  5. }
  6. return tableRecordImpl.isUpdatePlanEnabled()?tableRecordImpl.getUpdatePlan():null;
  7. }

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

  1. public String getUpdatePlan(final Object groupID) throws TeiidComponentException, QueryMetadataException {
  2. Table tableRecordImpl = (Table)groupID;
  3. if (!tableRecordImpl.isVirtual()) {
  4. throw new QueryMetadataException(QueryPlugin.Event.TEIID30359, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30359, tableRecordImpl.getFullName(), "Update")); //$NON-NLS-1$
  5. }
  6. return tableRecordImpl.isUpdatePlanEnabled()?tableRecordImpl.getUpdatePlan():null;
  7. }

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

  1. @Test
  2. public void testInsteadOfTriggerIsDistinct() throws Exception {
  3. String ddl = "CREATE VIEW G1( e1 integer, e2 varchar) AS select * from foo;" +
  4. "CREATE TRIGGER ON G1 INSTEAD OF UPDATE AS " +
  5. "FOR EACH ROW \n" +
  6. "BEGIN ATOMIC \n" +
  7. "if (\"new\" is not distinct from \"old\") raise sqlexception 'error';\n" +
  8. "END;";
  9. Schema s = helpParse(ddl, "model").getSchema();
  10. assertEquals("FOR EACH ROW\nBEGIN ATOMIC\nIF(\"new\" IS NOT DISTINCT FROM \"old\")\nBEGIN\nRAISE SQLEXCEPTION 'error';\nEND\nEND", s.getTable("G1").getUpdatePlan());
  11. }

代码示例来源:origin: org.teiid/teiid-spring-boot-starter

  1. @Test
  2. public void testRedirectionLayerUpdatePlan() {
  3. RedirectionSchemaBuilder mg = new RedirectionSchemaBuilder(this.context, "redirected");
  4. ModelMetaData model = mg.buildRedirectionLayer(buildSourceTableWithPK().getAttachment(MetadataFactory.class),
  5. "base");
  6. String expected = "FOR EACH ROW\n" + "BEGIN ATOMIC\n" + "IF (CHANGING.id)\n" + "BEGIN\n"
  7. + " DECLARE boolean VARIABLES.Person_PK_EXISTS = (SELECT true FROM source.Person WHERE id = NEW.id);\n"
  8. + " IF (VARIABLES.Person_PK_EXISTS)\n" + " BEGIN\n"
  9. + " RAISE SQLEXCEPTION 'duplicate key';\n" + " END\n" + " ELSE\n" + " BEGIN\n"
  10. + " DECLARE boolean VARIABLES.address_FK_EXISTS = (SELECT COUNT(*) > 0 FROM teiid.address WHERE pid = OLD.id);\n"
  11. + " IF (VARIABLES.address_FK_EXISTS)\n" + " BEGIN\n"
  12. + " RAISE SQLEXCEPTION 'referential integrity check failed on address table, cascade deletes are not supported';\n"
  13. + " END\n"
  14. + " UPSERT INTO redirected.Person_REDIRECTED(id, ROW__STATUS) VALUES (OLD.id, 3);\n"
  15. + " UPSERT INTO redirected.Person_REDIRECTED(id, name, dob, ROW__STATUS) VALUES (NEW.id, NEW.name, NEW.dob, 1);\n"
  16. + " END\n" + "END\n" + "ELSE\n" + "BEGIN\n"
  17. + " UPSERT INTO redirected.Person_REDIRECTED(id, name, dob, ROW__STATUS) VALUES (NEW.id, NEW.name, NEW.dob, 2);\n"
  18. + "END\n" + "END";
  19. MetadataFactory mf = model.getAttachment(MetadataFactory.class);
  20. Table table = mf.getSchema().getTable("Person");
  21. assertEquals(expected, table.getUpdatePlan().replace("\t", " "));
  22. }

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

  1. buildTrigger(name, null, UPDATE, table.getUpdatePlan(), false);

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

  1. validateUpdatePlan(model, report, metadata, t, t.getInsertPlan(), Command.TYPE_INSERT);
  2. if (t.getUpdatePlan() != null && t.isUpdatePlanEnabled()) {
  3. validateUpdatePlan(model, report, metadata, t, t.getUpdatePlan(), Command.TYPE_UPDATE);

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

  1. validateUpdatePlan(model, report, metadata, t, t.getInsertPlan(), Command.TYPE_INSERT);
  2. if (t.getUpdatePlan() != null && t.isUpdatePlanEnabled()) {
  3. validateUpdatePlan(model, report, metadata, t, t.getUpdatePlan(), Command.TYPE_UPDATE);

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

  1. validateUpdatePlan(model, report, metadata, t, t.getInsertPlan(), Command.TYPE_INSERT);
  2. if (t.getUpdatePlan() != null && t.isUpdatePlanEnabled()) {
  3. validateUpdatePlan(model, report, metadata, t, t.getUpdatePlan(), Command.TYPE_UPDATE);

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

  1. buildTrigger(name, null, UPDATE, table.getUpdatePlan(), false);

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

  1. buildTrigger(name, null, UPDATE, table.getUpdatePlan(), false);

相关文章