@Override protected File printInstructions(PrintStream out, AquaRevengArgs args) { DbEnvironment env = getDbEnvironment(args); JdbcDataSourceFactory jdbcFactory = new HsqlJdbcDataSourceFactory(); DataSource ds = jdbcFactory.createDataSource(env, new Credential(args.getUsername(), args.getPassword()), 1); JdbcHelper jdbc = new JdbcHelper(null, false); Path interim = new File(args.getOutputPath(), "interim").toPath(); interim.toFile().mkdirs(); try (Connection conn = ds.getConnection()) { // https://docs.oracle.com/database/121/ARPLS/d_metada.htm#BGBJBFGE // Note - can't remap schema name, object name, tablespace name within JDBC calls; we will leave that to the existing code in AbstractDdlReveng File outputFile = interim.resolve("output.sql").toFile(); outputFile.delete(); // clean before creating jdbc.update(conn, "SCRIPT '" + outputFile.getCanonicalPath() + "'"); } catch (SQLException | IOException e) { throw new RuntimeException(e); } return interim.toFile(); } }
@Override protected File printInstructions(PrintStream out, AquaRevengArgs args) { DbEnvironment env = getDbEnvironment(args); JdbcDataSourceFactory jdbcFactory = new HsqlJdbcDataSourceFactory(); DataSource ds = jdbcFactory.createDataSource(env, new Credential(args.getUsername(), args.getPassword()), 1); JdbcHelper jdbc = new JdbcHelper(null, false); Path interim = new File(args.getOutputPath(), "interim").toPath(); interim.toFile().mkdirs(); try (Connection conn = ds.getConnection()) { // https://docs.oracle.com/database/121/ARPLS/d_metada.htm#BGBJBFGE // Note - can't remap schema name, object name, tablespace name within JDBC calls; we will leave that to the existing code in AbstractDdlReveng File outputFile = interim.resolve("output.sql").toFile(); outputFile.delete(); // clean before creating jdbc.update(conn, "SCRIPT '" + outputFile.getCanonicalPath() + "'"); } catch (SQLException | IOException e) { throw new RuntimeException(e); } return interim.toFile(); } }
DataSource ds = jdbcFactory.createDataSource(env, new Credential(args.getUsername(), args.getPassword()), 1); JdbcHelper jdbc = new JdbcHelper(null, false);
DataSource ds = jdbcFactory.createDataSource(env, new Credential(args.getUsername(), args.getPassword()), 1); JdbcHelper jdbc = new JdbcHelper(null, false);
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbSchema, String outputFile) { return " SqlServerDdlReveng " + " " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputFile) + " " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + " " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + ObjectUtils.defaultIfNull(args.getPassword(), password); } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbServer, String dbSchema, String outputFile) { return " db2look " + "-d " + ObjectUtils.defaultIfNull(args.getDbServer(), dbServer) + " " + "-z " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + "-i " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + "-w " + ObjectUtils.defaultIfNull(args.getPassword(), password) + " " + "-o " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputFile) + " " + "-cor -e -td ~ "; } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbSchema, String outputFile) { return " SqlServerDdlReveng " + " " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputFile) + " " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + " " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + ObjectUtils.defaultIfNull(args.getPassword(), password); } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbServer, String dbSchema, String outputFile) { return " db2look " + "-d " + ObjectUtils.defaultIfNull(args.getDbServer(), dbServer) + " " + "-z " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + "-i " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + "-w " + ObjectUtils.defaultIfNull(args.getPassword(), password) + " " + "-o " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputFile) + " " + "-cor -e -td ~ "; } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbPort, String dbSchema, String outputDirectory) { return " C:\\Sybase_15_5_x64\\ASEP\\bin\\ddlgen " + "-U " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + "-P " + ObjectUtils.defaultIfNull(args.getPassword(), password) + " " + "-S " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + ":" + ObjectUtils.defaultIfNull(args.getDbPort(), dbPort) + " " + "-D " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + "-O " + ObjectUtils.defaultIfNull(args.getOutputDir(), outputDirectory); } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbPort, String dbName, String dbSchema, String outputDirectory) { return "pg_dump -O --disable-dollar-quoting -s" + " -h " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + " -p " + ObjectUtils.defaultIfNull(args.getDbPort(), dbPort) + " --username=" + ObjectUtils.defaultIfNull(args.getUsername(), username) + " -d " + ObjectUtils.defaultIfNull(args.getDbServer(), dbName) + " -n " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " -f " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputDirectory); } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbPort, String dbName, String dbSchema, String outputDirectory) { return "pg_dump -O --disable-dollar-quoting -s" + " -h " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + " -p " + ObjectUtils.defaultIfNull(args.getDbPort(), dbPort) + " --username=" + ObjectUtils.defaultIfNull(args.getUsername(), username) + " -d " + ObjectUtils.defaultIfNull(args.getDbServer(), dbName) + " -n " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " -f " + ObjectUtils.defaultIfNull(args.getOutputPath(), outputDirectory); } }
private String getCommandWithDefaults(AquaRevengArgs args, String username, String password, String dbHost, String dbPort, String dbSchema, String outputDirectory) { return " C:\\Sybase_15_5_x64\\ASEP\\bin\\ddlgen " + "-U " + ObjectUtils.defaultIfNull(args.getUsername(), username) + " " + "-P " + ObjectUtils.defaultIfNull(args.getPassword(), password) + " " + "-S " + ObjectUtils.defaultIfNull(args.getDbHost(), dbHost) + ":" + ObjectUtils.defaultIfNull(args.getDbPort(), dbPort) + " " + "-D " + ObjectUtils.defaultIfNull(args.getDbSchema(), dbSchema) + " " + "-O " + ObjectUtils.defaultIfNull(args.getOutputDir(), outputDirectory); } }
env.setSchemas(Sets.immutable.with(schema)); Credential credential = credentialReader.getCredential(args.getUsername(), args.getPassword(), false, null, null, null);
env.setSchemas(Sets.immutable.with(schema)); Credential credential = credentialReader.getCredential(args.getUsername(), args.getPassword(), false, null, null, null);
env.setSchemas(Sets.immutable.with(schema)); Credential credential = credentialReader.getCredential(args.getUsername(), args.getPassword(), false, null, null, null);
env.setSchemas(Sets.immutable.with(schema)); Credential credential = credentialReader.getCredential(args.getUsername(), args.getPassword(), false, null, null, null);