/** * Print a message with the JSON representation of the SourceRecord. * * @param record the source record; may not be null */ public static void print(SourceRecord record) { Testing.print(SchemaUtil.asString(record)); }
@Test public void shouldListDatabases() { Testing.Print.enable(); Testing.print("Databases: " + primary.databaseNames()); } }
protected void readAsStringAndBytes(String resourceFile) throws IOException { String content = Testing.Files.readResourceAsString(resourceFile); Document doc = DocumentReader.defaultReader().read(content); roundTrip(doc, size -> Testing.print("message size " + size + " bytes: \n" + doc)); }
@FixFor("DBZ-198") @Test public void shouldParseProcedureWithCase() { parser.parse(readFile("ddl/mysql-dbz-198b.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); }
@Override public void shouldParseButSkipAlterTableWhenTableIsNotKnown() { parser.parse(readFile("ddl/mysql-dbz-198j.ddl"), tables); Testing.print(tables); listener.forEach(this::printEvent); assertThat(tables.size()).isEqualTo(1); int numberOfAlteredTablesWhichDoesNotExists = ((MySqlAntlrDdlParser) parser).getParsingExceptionsFromWalker().size(); assertThat(listener.total()).isEqualTo(2 - numberOfAlteredTablesWhichDoesNotExists); }
@FixFor("DBZ-415") @Test public void shouldParseProcedureIfWithParenthesisStart() { parser.parse(readFile("ddl/mysql-dbz-415b.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); }
@FixFor("DBZ-415") @Test public void shouldParseProcedureEmbeddedIfs() { parser.parse(readFile("ddl/mysql-dbz-415a.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); }
@Override public void shouldParseCreateStatements() { parser.parse(readFile("ddl/mysql-test-create.ddl"), tables); Testing.print(tables); int numberOfCreatedIndexesWhichNotMakeChangeOnTablesModel = 49; assertThat(tables.size()).isEqualTo(57); assertThat(listener.total()).isEqualTo(144 - numberOfCreatedIndexesWhichNotMakeChangeOnTablesModel); }
@Test public void shouldParseStatementForDbz106() { parser.parse(readFile("ddl/mysql-dbz-106.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(1); assertThat(listener.total()).isEqualTo(1); }
@FixFor("DBZ-346") @Test public void shouldParseAlterTableUnionStatement() { final String ddl = "CREATE TABLE `merge_table` (`id` int(11) NOT NULL, `name` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1;" + "ALTER TABLE `merge_table` UNION = (`table1`,`table2`)"; parser.parse(ddl, tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(1); assertThat(listener.total()).isEqualTo(2); }
@Test public void shouldParseCreateStatements() { parser.parse(readFile("ddl/mysql-test-create.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(57); assertThat(listener.total()).isEqualTo(144); }
@Test public void shouldParseIntegrationTestSchema() { parser.parse(readFile("ddl/mysql-integration.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(10); assertThat(listener.total()).isEqualTo(17); }
@FixFor("DBZ-162") @Test public void shouldParseAndIgnoreCreateFunction() { parser.parse(readFile("ddl/mysql-dbz-162.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(1); // 1 table assertThat(listener.total()).isEqualTo(2); // 1 create, 1 alter listener.forEach(this::printEvent); }
@FixFor("DBZ-198") @Test public void shouldParseButIgnoreCreateFunctionE() { parser.parse(readFile("ddl/mysql-dbz-198e.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); // 0 table assertThat(listener.total()).isEqualTo(0); listener.forEach(this::printEvent); }
@FixFor("DBZ-198") @Test public void shouldParseButIgnoreCreateFunctionH() { parser.parse(readFile("ddl/mysql-dbz-198h.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); // 0 table assertThat(listener.total()).isEqualTo(0); listener.forEach(this::printEvent); }
@FixFor("DBZ-198") @Test public void shouldParseButIgnoreCreateFunctionF() { parser.parse(readFile("ddl/mysql-dbz-198f.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); // 0 table assertThat(listener.total()).isEqualTo(0); listener.forEach(this::printEvent); }
@FixFor("DBZ-198") @Test public void shouldParseButIgnoreCreateFunctionG() { parser.parse(readFile("ddl/mysql-dbz-198g.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(0); // 0 table assertThat(listener.total()).isEqualTo(0); listener.forEach(this::printEvent); }
@FixFor("DBZ-419") @Test public void shouldParseCreateTableWithUnnamedPrimaryKeyConstraint() { final String ddl = "CREATE TABLE IF NOT EXISTS tables_exception (table_name VARCHAR(100), create_date TIMESTAMP DEFAULT NOW(), enabled INT(1), retention int(1) default 30, CONSTRAINT PRIMARY KEY (table_name));"; parser.parse(ddl, tables); Testing.print(tables); Table t = tables.forTable(new TableId(null, null, "tables_exception")); assertThat(t).isNotNull(); assertThat(t.primaryKeyColumnNames()).containsExactly("table_name"); assertThat(tables.size()).isEqualTo(1); }
@Test public void shouldParseStatementsWithQuotedIdentifiers() { parser.parse(readFile("ddl/mysql-quoted.ddl"), tables); Testing.print(tables); assertThat(tables.size()).isEqualTo(4); assertThat(listener.total()).isEqualTo(10); assertThat(tables.forTable("connector_test_ro", null, "products")).isNotNull(); assertThat(tables.forTable("connector_test_ro", null, "products_on_hand")).isNotNull(); assertThat(tables.forTable("connector_test_ro", null, "customers")).isNotNull(); assertThat(tables.forTable("connector_test_ro", null, "orders")).isNotNull(); }