@Override public String handleRawFullSql(String string, ChangeInput change) { string = this.applyUnsupportedCommandPatterns(string);
public static SqlTranslatorConfigHelper createInMemoryDefault() { SqlTranslatorConfigHelper configHelper = new SqlTranslatorConfigHelper(); configHelper.setNameMapper(new DefaultSqlTranslatorNameMapper()); configHelper.setColumnSqlTranslators(FastList.<ColumnSqlTranslator>newListWith()); configHelper.setPostColumnSqlTranslators(FastList.<PostColumnSqlTranslator>newListWith()); configHelper.setPostParsedSqlTranslators(FastList.<PostParsedSqlTranslator>newListWith(new ForeignKeyNameRemovalSqlTranslator())); configHelper.setPreParsedSqlTranslators(FastList.<PreParsedSqlTranslator>newListWith(new RemoveWithPreParsedSqlTranslator())); configHelper.setUnparsedSqlTranslators(FastList.<UnparsedSqlTranslator>newListWith(new DefaultUnparsedSqlTranslator())); return configHelper; }
private InMemoryTranslator() { this.nameMapper = new DefaultSqlTranslatorNameMapper(); this.preParsedSqlTranslators = Lists.mutable.empty(); this.unparsedSqlTranslators = Lists.mutable.empty(); this.columnSqlTranslators = Lists.mutable.empty(); this.postColumnSqlTranslators = Lists.mutable.empty(); this.postParsedSqlTranslators = Lists.mutable.empty(); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.getPostParsedSqlTranslators() .with(new IqToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(IqToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Test public void testTranslate() { String result = new DefaultUnparsedSqlTranslator().handleRawFullSql(this.input, null); Assert.assertThat("Wrong result from translation", result, Matchers.equalToIgnoringWhiteSpace(this .expectedResult)); } }
@Test public void testRemoveGrantGrant() { assertThat(this.translator.handleRawFullSql("GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE_C TO GROUP GROUP1", null), Matchers.equalToIgnoringWhiteSpace("")); }
@Test public void testDateConversion() { String translated = this.translator.handleAnySqlPostTranslation("start default '9999-12-01-23.12.01.123' end", null); assertEquals("start default '9999-12-01 23:12:01.123' end", translated); translated = this.translator.handleAnySqlPostTranslation("start default '9999-12-01-23.12.01.000000' end", null); assertEquals("start default '9999-12-01 23:12:01.000' end", translated); } }
@Test public void testPreprocessSql() throws Exception { assertEquals( "\tPRIMARY KEY (idField)\n" + "\n" + ") LOCK DATAROWS\n", this.translator.preprocessSql( "\tPRIMARY KEY (idField)\n" + "\tWITH max_rows_per_page = 0, reservepagegap = 0\n" + ") LOCK DATAROWS\n" )); assertEquals( "\tPRIMARY KEY (idField)\n" + "\tSOMETHINGBEFORE_DONTREMOVE WITH max_rows_per_page = 0, reservepagegap = 0\n" + ") LOCK DATAROWS\n" , this.translator.preprocessSql( "\tPRIMARY KEY (idField)\n" + "\tSOMETHINGBEFORE_DONTREMOVE WITH max_rows_per_page = 0, reservepagegap = 0\n" + ") LOCK DATAROWS\n" )); } }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.getPostParsedSqlTranslators() .with(new IqToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(IqToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
public static SqlTranslatorConfigHelper createInMemoryDefault() { SqlTranslatorConfigHelper configHelper = new SqlTranslatorConfigHelper(); configHelper.setNameMapper(new DefaultSqlTranslatorNameMapper()); configHelper.setColumnSqlTranslators(FastList.<ColumnSqlTranslator>newListWith()); configHelper.setPostColumnSqlTranslators(FastList.<PostColumnSqlTranslator>newListWith()); configHelper.setPostParsedSqlTranslators(FastList.<PostParsedSqlTranslator>newListWith(new ForeignKeyNameRemovalSqlTranslator())); configHelper.setPreParsedSqlTranslators(FastList.<PreParsedSqlTranslator>newListWith(new RemoveWithPreParsedSqlTranslator())); configHelper.setUnparsedSqlTranslators(FastList.<UnparsedSqlTranslator>newListWith(new DefaultUnparsedSqlTranslator())); return configHelper; }
private InMemoryTranslator() { this.nameMapper = new DefaultSqlTranslatorNameMapper(); this.preParsedSqlTranslators = Lists.mutable.empty(); this.unparsedSqlTranslators = Lists.mutable.empty(); this.columnSqlTranslators = Lists.mutable.empty(); this.postColumnSqlTranslators = Lists.mutable.empty(); this.postParsedSqlTranslators = Lists.mutable.empty(); }
@Test public void testCommentGrantFalsePositive() { assertThat(this.translator.handleRawFullSql("blah blah 'SILVER GRANT' blah hello world", null), Matchers.equalToIgnoringWhiteSpace("blah blah 'SILVER GRANT' blah hello world")); } }
@Override public String handleRawFullSql(String string, ChangeInput change) { string = this.applyUnsupportedCommandPatterns(string);
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new Db2SqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new Db2ToH2SqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(Db2ToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new Db2SqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new Db2ToHsqlSqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(Db2ToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new Db2SqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new Db2ToHsqlSqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(Db2ToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new Db2SqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new Db2ToH2SqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(Db2ToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new Db2ToInMemorySqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new MsSqlSqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new MsSqlToHsqlSqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(MsSqlToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new MsSqlToHsqlDomainSqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new MsSqlSqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new MsSqlToHsqlSqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(MsSqlToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)); configHelper.getUnparsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new MsSqlToHsqlDomainSqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }
@Override public ImmutableList<PrepareDbChange> getAdditionalTranslators() { SqlTranslatorConfigHelper configHelper = SqlTranslatorConfigHelper.createInMemoryDefault(); configHelper.setNameMapper(new MsSqlSqlTranslatorNameMapper()); configHelper.getPostColumnSqlTranslators() .with(new MsSqlToH2SqlTranslator()); configHelper.getPostParsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new DateFormatterPostParsedSqlTranslator(MsSqlToInMemorySqlTranslator.ACCEPTED_DATE_FORMATS)) .with(new MsSqlToH2SqlTranslator()); configHelper.getUnparsedSqlTranslators() .with(new MsSqlToInMemorySqlTranslator()) .with(new MsSqlToH2DomainSqlTranslator()); return Lists.immutable.<PrepareDbChange>with(new InMemoryTranslator(configHelper)); }