/** * @deprecated Use {@link #setOutputPath(File)} */ @Deprecated @Argument(value = "outputDir", required = false) public void setOutputDir(File outputDir) { this.setOutputPath(outputDir); }
/** * @deprecated Use {@link #setOutputPath(File)} */ @Deprecated @Argument(value = "outputDir", required = false) public void setOutputDir(File outputDir) { this.setOutputPath(outputDir); }
public void convertDdlsToDaFormat(final DbPlatform platform, File inputPath, File outputPath, final String dbSchema, boolean generateBaseline, String excludeObjects) { ReladomoDdlReveng reladomoDdlReveng = new ReladomoDdlReveng(platform); AquaRevengArgs args = new AquaRevengArgs(); args.setInputPath(inputPath); args.setOutputPath(outputPath); args.setDbSchema(dbSchema); args.setGenerateBaseline(generateBaseline); args.setExcludeObjects(excludeObjects); reladomoDdlReveng.reveng(args); } }
public void convertDdlsToDaFormat(final DbPlatform platform, File inputPath, File outputPath, final String dbSchema, boolean generateBaseline, String excludeObjects) { ReladomoDdlReveng reladomoDdlReveng = new ReladomoDdlReveng(platform); AquaRevengArgs args = new AquaRevengArgs(); args.setInputPath(inputPath); args.setOutputPath(outputPath); args.setDbSchema(dbSchema); args.setGenerateBaseline(generateBaseline); args.setExcludeObjects(excludeObjects); reladomoDdlReveng.reveng(args); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { File outputDir = new File("./target/ddlreveng/execute"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("dbdeploy01"); args.setInputPath(new File("./src/test/resources/reveng/ddlgen/input/ase-ddlgen-input.txt")); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new AseDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/ddlgen/expected"), new File(outputDir, "final")); } }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { File outputDir = new File("./target/db2revengoutput"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema(SCHEMA); args.setInputPath(new File("./src/test/resources/reveng/db2look/input/db2input.txt")); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new Db2DbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/db2look/expected"), new File(outputDir, "final")); }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { File outputDir = new File("./target/db2revengoutput"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema(SCHEMA); args.setInputPath(new File("./src/test/resources/reveng/db2look/input/db2input.txt")); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new Db2DbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/db2look/expected"), new File(outputDir, "final")); }
@Test @Override public void testReverseEngineeringFromFile() throws Exception { File outputDir = new File("./target/ddlreveng/execute"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("dbdeploy01"); args.setInputPath(new File("./src/test/resources/reveng/ddlgen/input/ase-ddlgen-input.txt")); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new AseDbPlatform().getDdlReveng().reveng(args); DirectoryAssert.assertDirectoriesEqual(new File("./src/test/resources/reveng/ddlgen/expected"), new File(outputDir, "final")); } }
@Test public void testInstructions() throws Exception { File outputDir = new File("./target/ddlgen/instructions"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("dbdeploy01"); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new AseDbPlatform().getDdlReveng().reveng(args); }
@Test public void testInstructions() throws Exception { File outputDir = new File("./target/ddlgen/instructions"); FileUtils.deleteDirectory(outputDir); AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema("dbdeploy01"); args.setGenerateBaseline(false); args.setOutputPath(outputDir); new AseDbPlatform().getDdlReveng().reveng(args); }
@Test public void testInstructions() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema(SCHEMA); args.setGenerateBaseline(false); args.setOutputPath(new File("./target/db2revenginterm.txt")); new Db2DbPlatform().getDdlReveng().reveng(args); }
@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 testInstructions() throws Exception { AquaRevengArgs args = new AquaRevengArgs(); args.setDbSchema(SCHEMA); args.setGenerateBaseline(false); args.setOutputPath(new File("./target/db2revenginterm.txt")); new Db2DbPlatform().getDdlReveng().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.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 @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.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(); } }