Difference between revisions of "EclipseLink/Development/DBWS/MetadataGenerationFromDDLMetaModel"

// use DatabaseTypeBuilder to generate a list of TableTypes
DatabaseTypeBuilder dbTypeBuilder = new DatabaseTypeBuilder();
try {
    List<TableType> dbTables = dbTypeBuilder.buildTables(conn, "SCOTT", "EMPLOYEE_TABLE");
    ...
} catch (ParseException e) {
    // handle exception
}

// use DatabaseTypeBuilder to generate a list of ProcedureTypes
DatabaseTypeBuilder dbTypeBuilder = new DatabaseTypeBuilder();
try {
    List<ProcedureType> dbProcedures = dbTypeBuilder.buildProcedures(conn, "TOPLEVEL", "GetAllEmployees");
    ...
} catch (ParseException e) {
    // handle exception
}

// use DatabaseTypeBuilder to generate a list of FunctionTypes
DatabaseTypeBuilder dbTypeBuilder = new DatabaseTypeBuilder();
try {
    List<FunctionType> dbFunctions = dbTypeBuilder.buildFunctions(conn, "TOPLEVEL", "GetEmployeeById");
    ...
} catch (ParseException e) {
    // handle exception
}

// add desired PL/SQL stored function/procedure names
List<String> procedurePatterns = new ArrayList<String>();
// PL/SQL stored procedures
procedurePatterns.add("COPYTABLE");
procedurePatterns.add("COPYPHONECOLLECTION");  
// PL/SQL stored functions
procedurePatterns.add("CREATETABLE");
procedurePatterns.add("GETALLTABLES");  
 
// use DatabaseTypeBuilder to generate a list of PLSQLPackageTypes
DatabaseTypeBuilder dbTypeBuilder = new DatabaseTypeBuilder();
try {
    List<ProcedureType> dbProcedures = new ArrayList<ProcedureType>();
    // process the package
    List<PLSQLPackageType> packages = dbTypeBuilder.buildPackages(conn, "SCOTT", "PACKAGE2");
    for (PLSQLPackageType pkgType : packages) {
        // now get the desired procedures/functions from the processed package
        for (ProcedureType procType : pkgType.getProcedures()) {
            if (procedurePatterns.contains(procType.getProcedureName())) {
                dbProcedures.add(procType);
            }
        }
    }
    ...
} catch (ParseException e) {
    // handle exception
}

// schema names
List<String> schemaNames = new ArrayList<String>();
schemaNames.add("HR");
schemaNames.add("SCOTT");
schemaNames.add("SCOTT");
 
// package names
List<String> packageNames = new ArrayList<String>();
packageNames.add("HR_DATA");
packageNames.add("MATH_FUNCTIONS");
packageNames.add("EMPLOYEE");
 
// procedure names
List<String> procedurePatterns= new ArrayList<String>();
procedurePatterns.add("findAllEmployees");
procedurePatterns.add("findEmployeeByPK");
procedurePatterns.add("getPersonalData");
procedurePatterns.add("removeEmployee");
procedurePatterns.add("calculateMaxAngle");
 
// use DatabaseTypeBuilder to generate a list of PLSQLPackageTypes
DatabaseTypeBuilder dbTypeBuilder = new DatabaseTypeBuilder();
try {
    // process the packages
    List<PLSQLPackageType> packages = dbTypeBuilder.buildPackages(conn, schemaNames, packageNames);
    for (PLSQLPackageType pkgType : packages) {
        // now get the desired procedures/functions from the processed package
        for (ProcedureType procType : pkgType.getProcedures()) {
            if (procedurePatterns.contains(procType.getProcedureName())) {
                dbProcedures.add(procType);
            }
        }
    }
    ...
} catch (ParseException e) {
    // handle exception
}

/**
 * Default constructor.  Sets the default package name to null, and dbPlatform to
 * org.eclipse.persistence.platform.database.oracle.Oracle11Platform.
 * 
 * The default package name will be prepended to generated class names for database
 * artifacts that are not in a PL/SQL package.
 * 
 * The database platform is used to get class names for database types, i.e. 
 * java.math.BigDecimal for DECIMAL.
 * 
 * @see org.eclipse.persistence.platform.database.oracle.Oracle11Platform
 * @see org.eorg.eclipse.persistence.internal.databaseaccess.DatabasePlatform
 */
public JPAMetadataGenerator()
 
/**
 * This constructor allows setting the default package name and database platform.
 * 
 * @param defaultPackage package name to be prepended to generated class names for artifacts
 * not in a PL/SQL package such as an Entity (to avoid having classes in the default package)
 * @param platformClassName class name of the DatabasePlatform to be used to get class names 
 * for database types, i.e. java.math.BigDecimal for DECIMAL.
 * @see org.eorg.eclipse.persistence.internal.databaseaccess.DatabasePlatform
 */
public JPAMetadataGenerator(String defaultPackage, String platformClassName)   
 
/**
 * This constructor allows setting the default package name and database platform.
 * 
 * @param defaultPackage package name to be prepended to generated class names for artifacts
 * not in a PL/SQL package such as an Entity (to avoid having classes in the default package)
 * @param dbPlatform DatabasePlatform to be used to get class names for database types, i.e. 
 * java.math.BigDecimal for DECIMAL.
 * @see org.eorg.eclipse.persistence.internal.databaseaccess.DatabasePlatform
 */
public JPAMetadataGenerator(String defaultPackage, DatabasePlatform dbPlatform)

/**
 * Generate an XMLEntityMappings instance based on a given list of meta-model database types.
 * 
 * @param databaseTypes the list of meta-model database types to be used to generate an XMLEntityMappings
 *
 * @see org.eclipse.persistence.tools.oracleddl.metadata.CompositeDatabaseType
 */
public XMLEntityMappings generateXmlEntityMappings(List<CompositeDatabaseType> databaseTypes)