Examples of util.DBTools

util.DBTools
Provides useful methods for working with SOffice databases. Database creation, data transfering, outputting infromation.

        tmpDir = (String) Param.get("TMPURL") ;
            tmpDir = utils.getOfficeTemp((XMultiServiceFactory)Param.getMSF());


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools((XMultiServiceFactory)Param.getMSF()) ;


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) Param.get("test.db.url");
        String dbUser = (String) Param.get("test.db.user");
        String dbPassword = (String) Param.get("test.db.password");

View Full Code Here

            XPropertySet xSrcProp = (XPropertySet)
                UnoRuntime.queryInterface(XPropertySet.class, newSource);


            xSrcProp.setPropertyValue("URL", tmpDatabaseUrl) ;
            
            DBTools dbt = new DBTools(((XMultiServiceFactory) Param.getMSF()));
            // registering source in DatabaseContext
            log.println("register database '"+tmpDatabaseUrl+"' as '"+databaseName+"'" );
            dbt.reRegisterDB(databaseName, newSource) ;
            
            uniqueSuffix++;
            Param.put("uniqueSuffix", new Integer(uniqueSuffix));
            
            return dbt.connectToSource(newSource);
        }
        catch( Exception e ) {
            uniqueSuffix++;
            Param.put("uniqueSuffix", new Integer(uniqueSuffix));
            log.println("could not register new database" );

View Full Code Here

    }
    
    protected void cleanup(TestParameters Param, PrintWriter log) {
        log.println("closing connections...");
        XMultiServiceFactory xMsf = (XMultiServiceFactory) Param.getMSF();
        DBTools dbt = new DBTools(xMsf);
        
        if (Param.containsKey("uniqueSuffix")){
            int uniqueSuffix = Param.getInt("uniqueSuffix");
            uniqueSuffix--;
            String databaseName =  "";
            while (uniqueSuffix >= 0){
                
                databaseName = "NewDatabaseSource" + uniqueSuffix ;
                
                log.println("revoke '"+databaseName+"'");
                
                try{
                    dbt.revokeDB(databaseName);
                } catch (com.sun.star.uno.Exception e){
                }
                
                uniqueSuffix--;
            }

View Full Code Here

            destTestDB = utils.getFullURL(destTestDB + "testDB.dbf");
            
            log.println("copy '"+sourceTestDB + "' -> '" + destTestDB + "'");
            utils.copyFile(xMSF, sourceTestDB, destTestDB);
            
            m_dbTools = new DBTools((xMSF));
            String tmpDir = utils.getOfficeTemp((xMSF));
        
            m_srcInf = m_dbTools.newDataSourceInfo();
            m_srcInf.URL = "sdbc:dbase:" + DBTools.dirToUrl(tmpDir);
            log.println("data source: " + m_srcInf.URL);

View Full Code Here

        //xTextDoc = WriterTools.createTextDoc(t((XMultiServiceFactory) Param.getMSF));
        tmpDir = utils.getOfficeTemp(((XMultiServiceFactory) tParam.getMSF()));


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools(((XMultiServiceFactory) tParam.getMSF()));


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) tParam.get("test.db.url");
        String dbUser = (String) tParam.get("test.db.user");
        String dbPassword = (String) tParam.get("test.db.password");

View Full Code Here

        tmpDir = (String) Param.get("TMPURL") ;
            tmpDir = utils.getOfficeTemp((XMultiServiceFactory)Param.getMSF());


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools((XMultiServiceFactory)Param.getMSF()) ;


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) Param.get("test.db.url");
        String dbUser = (String) Param.get("test.db.user");
        String dbPassword = (String) Param.get("test.db.password");

View Full Code Here

        //xTextDoc = WriterTools.createTextDoc(t((XMultiServiceFactory) Param.getMSF));
        tmpDir = utils.getOfficeTemp(((XMultiServiceFactory) tParam.getMSF()));


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools(((XMultiServiceFactory) tParam.getMSF()));


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) tParam.get("test.db.url");
        String dbUser = (String) tParam.get("test.db.user");
        String dbPassword = (String) tParam.get("test.db.password");

View Full Code Here

            destTestDB = utils.getFullURL(destTestDB + "testDB.dbf");
            
            log.println("copy '"+sourceTestDB + "' -> '" + destTestDB + "'");
            utils.copyFile(xMSF, sourceTestDB, destTestDB);
            
            m_dbTools = new DBTools((xMSF));
            String tmpDir = utils.getOfficeTemp((xMSF));
        
            m_srcInf = m_dbTools.newDataSourceInfo();
            m_srcInf.URL = "sdbc:dbase:" + DBTools.dirToUrl(tmpDir);
            log.println("data source: " + m_srcInf.URL);

View Full Code Here

        //xTextDoc = WriterTools.createTextDoc(t((XMultiServiceFactory) Param.getMSF));
        tmpDir = utils.getOfficeTemp(((XMultiServiceFactory) tParam.getMSF()));


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools(((XMultiServiceFactory) tParam.getMSF()));


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) tParam.get("test.db.url");
        String dbUser = (String) tParam.get("test.db.user");
        String dbPassword = (String) tParam.get("test.db.password");

View Full Code Here


        String tmpDir = utils.getOfficeTemp( m_orb );


        origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");


        dbTools = new DBTools( m_orb, _log );


        // creating DataSource and registering it in DatabaseContext
        String dbURL = (String) Param.get("test.db.url");
        String dbUser = (String) Param.get("test.db.user");
        String dbPassword = (String) Param.get("test.db.password");

View Full Code Here

0 1 2

TOP

Related Classes of util.DBTools

com.sun.star.beans.PropertyValue

com.sun.star.beans.XPropertySet

com.sun.star.container.XEnumeration

com.sun.star.container.XEnumerationAccess

com.sun.star.container.XNameAccess

com.sun.star.frame.XStorable

com.sun.star.sdb.XCompletedConnection

com.sun.star.sdb.XDocumentDataSource

com.sun.star.sdbc.XCloseable

com.sun.star.sdbc.XConnection

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.