@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("MYSCHEMA01"); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:oracle:thin:@myhost.me.com:1234:MYSERVER"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/oracle/input.sql")); new OracleDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/oracle/expected"), new File(outputDir, "final")); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("MYSCHEMA01"); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:oracle:thin:@myhost.me.com:1234:MYSERVER"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/oracle/input.sql")); new OracleDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/oracle/expected"), new File(outputDir, "final")); } }
@Test public void testReveng() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("DBDEPLOY01"); //args.setInputPath(new File("./src/test/resources/reveng/db2look/input/db2input.txt")); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:oracle:thin:@localhost:1521/ORCLPDB1.localdomain"); args.setUsername("deploydba"); args.setPassword("MyPassword"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); new OracleReveng().reveng(args); }
@Test public void testReveng() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("DBDEPLOY01"); //args.setInputPath(new File("./src/test/resources/reveng/db2look/input/db2input.txt")); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:oracle:thin:@localhost:1521/ORCLPDB1.localdomain"); args.setUsername("deploydba"); args.setPassword("MyPassword"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); new OracleReveng().reveng(args); }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("myschema01"); args.setGenerateBaseline(false); args.setDbHost("myhost.me.com"); args.setDbPort(1234); args.setDbServer("myserver"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/pgdump/input/input.sql")); new PostgreSqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/pgdump/expected"), new File(outputDir, "final")); } }
@Test public void test() { this.jdbc.execute(conn, "INSERT INTO " + schema + "." + table + " (INT1, STR1, DATE1, TIMESTAMP1) " + "VALUES (1, 'val1', '2017-01-01', '2016-02-02 22:22:22.2')"); this.jdbc.execute(conn, "INSERT INTO " + schema + "." + table + " (INT1, STR1, DATE1, TIMESTAMP1) " + "VALUES (2, null, '2017-02-02', null)"); this.jdbc.execute(conn, "INSERT INTO " + schema + "." + table + " (INT1, STR1, DATE1, TIMESTAMP1) " + "VALUES (null, 'val\\3', null, '2016-03-03 22:22:22.2')"); AquaRevengArgs args = new AquaRevengArgs(); args.setDbTypeStr("H2"); args.setJdbcUrl(url); args.setDriverClass(org.h2.Driver.class.getName()); args.setDbSchema(schema); args.setTables(new String[] { table }); args.setUsername("sa"); args.setPassword(""); File outputPath = new File("./target/csvoutput"); args.setOutputPath(outputPath); CsvStaticDataWriter.start(args, new File("./target/csvoutputwork")); FileAssert.assertEquals(new File("./src/test/resources/CsvStaticDataWriter/TABLE1.expected.csv"), new File(outputPath, "staticdata/TABLE1.csv")); }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("myschema01"); args.setGenerateBaseline(false); args.setDbHost("myhost.me.com"); args.setDbPort(1234); args.setDbServer("myserver"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/pgdump/input/input.sql")); new PostgreSqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/pgdump/expected"), new File(outputDir, "final")); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("myschema01"); args.setGenerateBaseline(false); args.setDbHost("myhost.me.com"); args.setDbPort(1234); args.setDbServer("myserver"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/pgdump/input/input.sql")); new MySqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/pgdump/expected"), new File(outputDir, "final")); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("myschema01"); args.setGenerateBaseline(false); args.setDbHost("myhost.me.com"); args.setDbPort(1234); args.setDbServer("myserver"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/input")); new MsSqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/expected"), new File(outputDir, "final")); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("MYSCHEMA01"); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:hsqldb:mem:hsqldbreveng"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/hsql/input.sql")); new HsqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/hsql/expected"), new File(outputDir, "final")); // Ensure that we can still build the schema that was reverse engineered DbEnvironment prod = DbEnvironmentFactory.getInstance().readOneFromSourcePath(new File(outputDir, "final").getAbsolutePath(), "prod"); prod.setCleanBuildAllowed(true); prod.buildAppContext("sa", "") .setupEnvInfra() .cleanEnvironment() .deploy(); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("MYSCHEMA01"); args.setGenerateBaseline(false); args.setJdbcUrl("jdbc:hsqldb:mem:hsqldbreveng"); args.setUsername("myuser"); args.setPassword("mypass"); File outputDir = new File("./target/outputReveng"); FileUtils.deleteDirectory(outputDir); args.setOutputPath(outputDir); args.setInputPath(new File("./src/test/resources/reveng/hsql/input.sql")); new HsqlDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/hsql/expected"), new File(outputDir, "final")); // Ensure that we can still build the schema that was reverse engineered DbEnvironment prod = DbEnvironmentFactory.getInstance().readOneFromSourcePath(new File(outputDir, "final").getAbsolutePath(), "prod"); prod.setCleanBuildAllowed(true); prod.buildAppContext("sa", "") .setupEnvInfra() .cleanEnvironment() .deploy(); } }
args.setPassword("");