Examples of DbLoader

org.apache.cayenne.access.DbLoader
Utility class that does reverse engineering of the database. It can create DataMaps using database meta data obtained via JDBC driver. @author Michael Shengaout @author Andrus Adamchik
org.jasig.portal.tools.dbloader.DbLoader
A tool to set up a uPortal database. This tool was created so that uPortal developers would only have to maintain a single set of xml documents to define the uPortal database schema and data. Previously it was necessary to maintain different scripts for each database we wanted to support.

DbLoader reads the generic types that are specified in tables.xml and tries to map them to local types by querying the database metadata via methods implemented by the JDBC driver. Fallback mappings can be supplied in dbloader.xml for cases where the JDBC driver is not able to determine the appropriate mapping. Such cases will be reported to standard out.

An xsl transformation is used to produce the DROP TABLE and CREATE TABLE SQL statements. These statements can be altered by modifying tables.xsl

Generic data types (as defined in java.sql.Types) which may be specified in tables.xml include: BIT, TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, NULL, OTHER, JAVA_OBJECT, DISTINCT, STRUCT, ARRAY, BLOB, CLOB, REF, DATALINK, BOOLEAN
WARNING: YOU MAY WANT TO MAKE A BACKUP OF YOUR DATABASE BEFORE RUNNING DbLoader

DbLoader will perform the following steps:
1. Read configurable properties from dbloader.xml
2. Get database connection from RDBMServices (reads JDBC database settings from rdbm.properties).
3. Read tables.xml and issue corresponding DROP TABLE and CREATE TABLE SQL statements.
4. Read data.xml and issue corresponding INSERT/UPDATE/DELETE SQL statements.
@author Ken Weiner, kweiner@unicon.net @author Mark Boyd, mboyd@sungardsct.com @version $Revision: 1.31 $ @see java.sql.Types @since uPortal 2.0

Examples of org.apache.cayenne.access.DbLoader

        ResultSet rs = null;
        try {
            conn = dataSource.getConnection();


            final DbMerger merger = this;
            DbLoader dbLoader = new DbLoader(conn, adapter, new LoaderDelegate()) {


                @Override
                public boolean includeTableName(String tableName) {
                    return merger.includeTableName(tableName);
                }
            };
            
            DataMap detectedDataMap = dbLoader.loadDataMapFromDB(
                    null,
                    null,
                    new DataMap());


            Map<String, DbEntity> dbEntityToDropByName = new HashMap<String, DbEntity>(

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        ResultSet rs = null;
        try {
            conn = dataSource.getConnection();


            final DbMerger merger = this;
            DbLoader dbLoader = new DbLoader(conn, adapter, new LoaderDelegate()) {


                @Override
                public boolean includeTableName(String tableName) {
                    return merger.includeTableName(tableName);
                }
            };
            
            DataMap detectedDataMap = dbLoader.loadDataMapFromDB(
                    null,
                    null,
                    new DataMap());


            Map<String, DbEntity> dbEntityToDropByName = new HashMap<String, DbEntity>(

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        ResultSet rs = null;
        try {
            conn = dataSource.getConnection();


            final DbMerger merger = this;
            DbLoader dbLoader = new DbLoader(conn, adapter, new LoaderDelegate()) {


                @Override
                public boolean includeTableName(String tableName) {
                    return merger.includeTableName(tableName);
                }
            };
            
            DataMap detectedDataMap = dbLoader.loadDataMapFromDB(
                    null,
                    null,
                    new DataMap());
            
            detectedDataMap.setQuotingSQLIdentifiers(dataMap.isQuotingSQLIdentifiers());

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        ResultSet rs = null;
        try {
            conn = dataSource.getConnection();


            final DbMerger merger = this;
            DbLoader dbLoader = new DbLoader(conn, adapter, new LoaderDelegate()) {


                @Override
                public boolean includeTableName(String tableName) {
                    return merger.includeTableName(tableName);
                }
            };
            
            DataMap detectedDataMap = dbLoader.loadDataMapFromDB(
                    null,
                    null,
                    new DataMap());
            
            detectedDataMap.setQuotingSQLIdentifiers(dataMap.isQuotingSQLIdentifiers());

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        Connection conn = null;
        ResultSet rs = null;
        try {
            conn = dataSource.getConnection();


            DbLoader dbLoader = new DbLoader(conn, adapter, new LoaderDelegate());
            DataMap detectedDataMap = dbLoader.loadDataMapFromDB(
                    null,
                    null,
                    new DataMap());


            Map<String, DbEntity> dbEntityToDropByName = new HashMap<String, DbEntity>(

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader


        DbImportParameters parameters = new DbImportParameters();


        Connection connection = mock(Connection.class);


        DbLoader loader = action.createLoader(parameters, mock(DbAdapter.class), connection,
                mock(DbLoaderDelegate.class));
        assertNotNull(loader);
        assertSame(connection, loader.getConnection());
        assertTrue(loader.includeTableName("dummy"));
    }

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        DbImportAction action = i.getInstance(DbImportAction.class);


        DbImportParameters parameters = new DbImportParameters();
        parameters.setIncludeTables("a,b,c*");


        DbLoader loader1 = action.createLoader(parameters, mock(DbAdapter.class), mock(Connection.class),
                mock(DbLoaderDelegate.class));


        assertFalse(loader1.includeTableName("dummy"));
        assertFalse(loader1.includeTableName("ab"));
        assertTrue(loader1.includeTableName("a"));
        assertTrue(loader1.includeTableName("b"));
        assertTrue(loader1.includeTableName("cd"));


        parameters.setExcludeTables("cd");


        DbLoader loader2 = action.createLoader(parameters, mock(DbAdapter.class), mock(Connection.class),
                mock(DbLoaderDelegate.class));


        assertFalse(loader2.includeTableName("dummy"));
        assertFalse(loader2.includeTableName("ab"));
        assertTrue(loader2.includeTableName("a"));
        assertTrue(loader2.includeTableName("b"));
        assertFalse(loader2.includeTableName("cd"));
        assertTrue(loader2.includeTableName("cx"));
    }

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        DbImportAction action = i.getInstance(DbImportAction.class);


        DbImportParameters parameters = new DbImportParameters();
        assertNull(parameters.getMeaningfulPkTables());


        DbLoader loader1 = action.createLoader(parameters, mock(DbAdapter.class), mock(Connection.class),
                mock(DbLoaderDelegate.class));


        DataMap map = new DataMap();


        DbEntity e1 = new DbEntity("e1");
        DbAttribute pk = new DbAttribute("pk", Types.INTEGER, e1);
        pk.setPrimaryKey(true);
        e1.addAttribute(pk);
        DbAttribute nonPk = new DbAttribute("nonPk", Types.INTEGER, e1);
        e1.addAttribute(nonPk);


        map.addDbEntity(e1);


        // DbLoader is so ugly and hard to test..
        Field dbEntityList = DbLoader.class.getDeclaredField("dbEntityList");
        dbEntityList.setAccessible(true);
        List<DbEntity> entities = (List<DbEntity>) dbEntityList.get(loader1);
        entities.add(e1);


        loader1.loadObjEntities(map);


        ObjEntity oe1 = map.getObjEntity("E1");
        assertEquals(1, oe1.getAttributes().size());
        assertNotNull(oe1.getAttribute("nonPk"));
    }

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        DbImportAction action = i.getInstance(DbImportAction.class);


        DbImportParameters parameters = new DbImportParameters();
        parameters.setMeaningfulPkTables("a*");


        DbLoader loader1 = action.createLoader(parameters, mock(DbAdapter.class), mock(Connection.class),
                mock(DbLoaderDelegate.class));


        // DbLoader is so ugly and hard to test..
        Field dbEntityList = DbLoader.class.getDeclaredField("dbEntityList");
        dbEntityList.setAccessible(true);
        List<DbEntity> entities = (List<DbEntity>) dbEntityList.get(loader1);


        DataMap map = new DataMap();


        DbEntity e1 = new DbEntity("e1");
        DbAttribute pk = new DbAttribute("pk", Types.INTEGER, e1);
        pk.setPrimaryKey(true);
        e1.addAttribute(pk);
        DbAttribute nonPk = new DbAttribute("nonPk", Types.INTEGER, e1);
        e1.addAttribute(nonPk);


        map.addDbEntity(e1);
        entities.add(e1);


        DbEntity a1 = new DbEntity("a1");
        DbAttribute apk = new DbAttribute("pk", Types.INTEGER, a1);
        apk.setPrimaryKey(true);
        a1.addAttribute(apk);
        DbAttribute anonPk = new DbAttribute("nonPk", Types.INTEGER, a1);
        a1.addAttribute(anonPk);


        map.addDbEntity(a1);
        entities.add(a1);


        loader1.loadObjEntities(map);


        ObjEntity oe1 = map.getObjEntity("E1");
        assertEquals(1, oe1.getAttributes().size());
        assertNotNull(oe1.getAttribute("nonPk"));

View Full Code Here

Examples of org.apache.cayenne.access.DbLoader

        DbImportAction action = i.getInstance(DbImportAction.class);


        DbImportParameters parameters = new DbImportParameters();
        parameters.setUsePrimitives(false);


        DbLoader loader1 = action.createLoader(parameters, mock(DbAdapter.class), mock(Connection.class),
                mock(DbLoaderDelegate.class));


        DataMap map = new DataMap();


        DbEntity e1 = new DbEntity("e1");
        DbAttribute nonPk = new DbAttribute("nonPk", Types.INTEGER, e1);
        e1.addAttribute(nonPk);


        map.addDbEntity(e1);


        // DbLoader is so ugly and hard to test..
        Field dbEntityList = DbLoader.class.getDeclaredField("dbEntityList");
        dbEntityList.setAccessible(true);
        List<DbEntity> entities = (List<DbEntity>) dbEntityList.get(loader1);
        entities.add(e1);


        loader1.loadObjEntities(map);


        ObjEntity oe1 = map.getObjEntity("E1");


        ObjAttribute oa1 = (ObjAttribute) oe1.getAttribute("nonPk");
        assertEquals("java.lang.Integer", oa1.getType());

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.