@Test public void testPartialSubschema() { RevengPatternOutput output = subschemaPattern.evaluate("pat B.C"); assertThat(output.getSchema(), equalTo(null)); assertThat(output.getSubSchema(), equalTo("B")); assertThat(output.getPrimaryName(), equalTo("C")); }
@Test public void testBlankSchema() { RevengPatternOutput output = schemaPattern.evaluate("pat B"); assertThat(output.getSchema(), equalTo(null)); assertThat(output.getSubSchema(), equalTo(null)); assertThat(output.getPrimaryName(), equalTo("B")); } }
@Test public void testFullSchema() { RevengPatternOutput output = schemaPattern.evaluate("pat A.B"); assertThat(output.getSchema(), equalTo("A")); assertThat(output.getSubSchema(), equalTo(null)); assertThat(output.getPrimaryName(), equalTo("B")); }
@Test public void testFullSubschema() { RevengPatternOutput output = subschemaPattern.evaluate("pat A.B.C"); assertThat(output.getSchema(), equalTo("A")); assertThat(output.getSubSchema(), equalTo("B")); assertThat(output.getPrimaryName(), equalTo("C")); }
@Test public void testBlankSubschema() { RevengPatternOutput output = subschemaPattern.evaluate("pat C"); assertThat(output.getSchema(), equalTo(null)); assertThat(output.getSubSchema(), equalTo(null)); assertThat(output.getPrimaryName(), equalTo("C")); }
@Override public Pair<String, RevengPatternOutput> valueOf(String sqlSnippet) { for (RevengPattern revengPattern : revengPatterns) { RevengPatternOutput patternMatch = revengPattern.evaluate(sqlSnippet); if (patternMatch != null) { return Tuples.pair(sqlSnippet, patternMatch); } } return Tuples.pair(sqlSnippet, null); } };
@Override public Pair<String, RevengPatternOutput> valueOf(String sqlSnippet) { for (RevengPattern revengPattern : revengPatterns) { RevengPatternOutput patternMatch = revengPattern.evaluate(sqlSnippet); if (patternMatch != null) { return Tuples.pair(sqlSnippet, patternMatch); } } return Tuples.pair(sqlSnippet, null); } };
@Test public void testSchemaExtraction() { ImmutableList<AbstractDdlReveng.RevengPattern> patterns = Db2lookReveng.getRevengPatterns().select(Predicates.attributeEqual(AbstractDdlReveng.RevengPattern.TO_CHANGE_TYPE, "VIEW")); AbstractDdlReveng.RevengPattern revengPattern = patterns.get(0); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW SCHEMA.MYVIEW AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW \"SCHEMA\".\"MYVIEW\" AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW MYVIEW AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW \"MYVIEW\" AS ABC DEF GHI").getPrimaryName()); } }
@Test public void testSchemaExtraction() { ImmutableList<AbstractDdlReveng.RevengPattern> patterns = Db2lookReveng.getRevengPatterns().select(Predicates.attributeEqual(AbstractDdlReveng.RevengPattern.TO_CHANGE_TYPE, "VIEW")); AbstractDdlReveng.RevengPattern revengPattern = patterns.get(0); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW SCHEMA.MYVIEW AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW \"SCHEMA\".\"MYVIEW\" AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW MYVIEW AS ABC DEF GHI").getPrimaryName()); assertEquals("MYVIEW", revengPattern.evaluate("CREATE or REPLACE VIEW \"MYVIEW\" AS ABC DEF GHI").getPrimaryName()); } }