@Override public Iterable<ChangeEntry> valueOf(FileProcessingContext fileProcessingContext) { String schema = getObjectSchema(args.getDbSchema(), fileProcessingContext.getFile().getName()); return revengFile(schemaObjectReplacer, fileProcessingContext.getSnippetPatternMatchPairs(), schema); } });
@Override public Iterable<ChangeEntry> valueOf(FileProcessingContext fileProcessingContext) { String schema = getObjectSchema(args.getDbSchema(), fileProcessingContext.getFile().getName()); return revengFile(schemaObjectReplacer, fileProcessingContext.getSnippetPatternMatchPairs(), schema); } });
" OBJECT_TYPE,\n" + " dbms_metadata.get_ddl(REPLACE(object_type,' ','_'), object_name, owner) || ';' AS object_ddl\n" + "FROM DBA_OBJECTS WHERE OWNER = '" + args.getDbSchema() + "' AND OBJECT_TYPE NOT IN ('PACKAGE BODY', 'LOB', 'TABLE PARTITION', 'DATABASE LINK')\n" + " AND OBJECT_NAME NOT LIKE 'MLOG$%' AND OBJECT_NAME NOT LIKE 'RUPD$%'" + // exclude the helper tables for materialized views " AND OBJECT_NAME NOT LIKE 'SYS_%' " + // exclude other system tables
" OBJECT_TYPE,\n" + " dbms_metadata.get_ddl(REPLACE(object_type,' ','_'), object_name, owner) || ';' AS object_ddl\n" + "FROM DBA_OBJECTS WHERE OWNER = '" + args.getDbSchema() + "' AND OBJECT_TYPE NOT IN ('PACKAGE BODY', 'LOB', 'TABLE PARTITION', 'DATABASE LINK')\n" + " AND OBJECT_NAME NOT LIKE 'MLOG$%' AND OBJECT_NAME NOT LIKE 'RUPD$%'" + // exclude the helper tables for materialized views " AND OBJECT_NAME NOT LIKE 'SYS_%' " + // exclude other system tables
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 ~ "; } }
Validate.notNull(args.getDbSchema(), "dbSchema argument must be specified"); Validate.notNull(input, "Directory " + input + " was not found"); // Maven supplies a null File value in this case env.setDriverClassName(args.getDriverClass()); Schema schema = new Schema(args.getDbSchema()); env.setSchemas(Sets.immutable.with(schema)); DaCatalog database = ctxt.getDbMetadataManager().getDatabase(args.getDbSchema(), new DaSchemaInfoLevel().setRetrieveRuleBindings(true), false, false); ImmutableCollection<RuleBinding> ruleBindings = database.getRuleBindings(); files = preprocessSchemaTokens(files, args.getDbSchema(), new File(outputDir, "interim-schemaReplaced"), args.getDbPlatform());
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); } }
Validate.notNull(args.getDbSchema(), "dbSchema argument must be specified"); Validate.notNull(input, "Directory " + input + " was not found"); // Maven supplies a null File value in this case env.setDriverClassName(args.getDriverClass()); Schema schema = new Schema(args.getDbSchema()); env.setSchemas(Sets.immutable.with(schema)); DaCatalog database = ctxt.getDbMetadataManager().getDatabase(args.getDbSchema(), new DaSchemaInfoLevel().setRetrieveRuleBindings(true), false, false); ImmutableCollection<RuleBinding> ruleBindings = database.getRuleBindings(); files = preprocessSchemaTokens(files, args.getDbSchema(), new File(outputDir, "interim-schemaReplaced"), args.getDbPlatform());
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.setDriverClassName(args.getDriverClass()); final PhysicalSchema physicalSchema = PhysicalSchema.parseFromString(args.getDbSchema()); final Schema schema = new Schema(physicalSchema.getPhysicalName()); // use the physical name as the schema name for the reverse-engineering env.setSchemas(Sets.immutable.with(schema));
env.setDriverClassName(args.getDriverClass()); final PhysicalSchema physicalSchema = PhysicalSchema.parseFromString(args.getDbSchema()); final Schema schema = new Schema(physicalSchema.getPhysicalName()); // use the physical name as the schema name for the reverse-engineering env.setSchemas(Sets.immutable.with(schema));