/**************************************************************
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 *************************************************************/



package mod._dbaccess;

//import com.sun.star.awt.XControl;
//import com.sun.star.awt.XControlModel;
import com.sun.star.container.NoSuchElementException;
import com.sun.star.lang.WrappedTargetException;
import com.sun.star.sdbc.SQLException;
import com.sun.star.sdbc.XConnection;
import com.sun.star.uno.Exception;
import java.io.PrintWriter;

import lib.TestCase;
import lib.TestEnvironment;
import lib.TestParameters;
import util.DesktopTools;

import com.sun.star.beans.PropertyValue;
import com.sun.star.container.XNameAccess;
import com.sun.star.frame.XController;
import com.sun.star.frame.XDesktop;
import com.sun.star.frame.XDispatch;
import com.sun.star.frame.XDispatchProvider;
import com.sun.star.frame.XFrame;
import com.sun.star.frame.XModel;
import com.sun.star.lang.XInitialization;
import com.sun.star.lang.XMultiServiceFactory;
import com.sun.star.text.XTextDocument;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.uno.XInterface;
import com.sun.star.util.URL;
import lib.StatusException;
import util.SOfficeFactory;
import com.sun.star.sdb.XDocumentDataSource;
import com.sun.star.sdbc.XDataSource;

public class OQueryDesign extends TestCase {

	private static XDesktop xDesk;
	private static XFrame xFrame;
	private final String sDataSourceName = "Bibliography";
	private static XConnection xConn;
	private static XTextDocument xTextDoc;


	/**
	 * Creates the Desktop service (<code>com.sun.star.frame.Desktop</code>).
	 */
	protected void initialize(TestParameters Param, PrintWriter log) {
		xDesk = (XDesktop) UnoRuntime.queryInterface(
					XDesktop.class, DesktopTools.createDesktop((XMultiServiceFactory)Param.getMSF()) );
	}

	protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {

		log.println( "creating a test environment" );

		XInterface oObj = null;

		XDispatchProvider aProv = (XDispatchProvider)
				UnoRuntime.queryInterface(XDispatchProvider.class,xDesk);

		XDispatch getting = null;
		XMultiServiceFactory xMSF = (XMultiServiceFactory) Param.getMSF();

			XNameAccess xNameAccess = null;

			// we use the first DataSource
			XDataSource xDS = null;
		try {
			xNameAccess = (XNameAccess) UnoRuntime.queryInterface(
						XNameAccess.class,
						xMSF.createInstance("com.sun.star.sdb.DatabaseContext"));
		} catch (Exception ex) {
			ex.printStackTrace( log );
			throw new StatusException( "Could not get Databasecontext", ex );
		}
		try {
			xDS = (XDataSource) UnoRuntime.queryInterface(
					XDataSource.class, xNameAccess.getByName( "Bibliography" ));
		} catch (NoSuchElementException ex) {
			ex.printStackTrace( log );
			throw new StatusException( "Could not get XDataSource", ex );
		} catch (WrappedTargetException ex) {
			ex.printStackTrace( log );
			throw new StatusException( "Could not get XDataSource", ex );
		}
		try {
			xNameAccess = (XNameAccess) UnoRuntime.queryInterface(
						XNameAccess.class,
						xMSF.createInstance("com.sun.star.sdb.DatabaseContext"));
		} catch (Exception ex) {
			ex.printStackTrace( log );
			throw new StatusException( "Could not get DatabaseConext", ex );
		}

			log.println("check XMultiServiceFactory");

		try {
			xConn = xDS.getConnection(new String(), new String());
		} catch (SQLException ex) {
			ex.printStackTrace( log );
			throw new StatusException( "Could not get XConnection", ex );
		}

		log.println( "opening QueryDesign" );
		URL the_url = new URL();
		the_url.Complete = ".component:DB/QueryDesign";
		getting = aProv.queryDispatch(the_url,"Query",12);
		PropertyValue[] Args = new PropertyValue[2];
		PropertyValue param1 = new PropertyValue();
		param1.Name = "DataSourceName";
		param1.Value = "Bibliography";
		Args[0] = param1;
		PropertyValue param2 = new PropertyValue();
		param2.Name = "QueryDesignView";
		param2.Value = new Boolean(false);
		Args[1] = param2;
		param1.Name = "ActiveConnection";
		param1.Value = xConn;
		Args[1] = param2;
		getting.dispatch(the_url,Args);

		shortWait();

		Object oDBC = null;

		try {
			oDBC = xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" );
		}
		catch( com.sun.star.uno.Exception e ) {
			throw new StatusException("Could not instantiate DatabaseContext", e) ;
		}

		Object oDataSource = null;
		try{
			XNameAccess xNA = (XNameAccess) UnoRuntime.queryInterface(XNameAccess.class, oDBC);
			oDataSource = xNA.getByName(sDataSourceName);
		} catch ( com.sun.star.container.NoSuchElementException e){
			throw new StatusException("could not get '" + sDataSourceName + "'" , e) ;
		} catch ( com.sun.star.lang.WrappedTargetException e){
			throw new StatusException("could not get '" + sDataSourceName + "'" , e) ;
		}
		XDocumentDataSource xDDS = (XDocumentDataSource) UnoRuntime.queryInterface(XDocumentDataSource.class, oDataSource);
//		XModel xMod = (XModel) UnoRuntime.queryInterface(XModel.class, xDDS.getDatabaseDocument ());

//		Frame = xMod.getCurrentController().getFrame();

		xFrame = DesktopTools.getCurrentFrame(xMSF);

		 // get an instance of Frame
		Object oFrame = null;
		SOfficeFactory SOF = null;

		SOF = SOfficeFactory.getFactory( xMSF );
		try {
			log.println( "creating a textdocument" );
			xTextDoc = SOF.createTextDoc( null );
		} catch ( com.sun.star.uno.Exception e ) {
			e.printStackTrace( log );
			throw new StatusException( "Could not create document", e );
		}

		XModel xDocMod = (XModel) UnoRuntime.queryInterface(XModel.class, xTextDoc);

		XFrame xTextFrame = xDocMod.getCurrentController().getFrame();

		Object[] params = new Object[3];
		param1 = new PropertyValue();
		param1.Name = "DataSourceName";
		param1.Value = "Bibliography";
		params[0] = param1;
		param2 = new PropertyValue();
		param2.Name = "Frame";
		param2.Value = xTextFrame;
		params[1] = param2;
		PropertyValue param3 = new PropertyValue();
		param3.Name = "QueryDesignView";
		param3.Value = new Boolean(true);
		params[2] = param3;


		oObj = xFrame.getController();

		TestEnvironment tEnv = new TestEnvironment(oObj);

		//Adding ObjRelations for XInitialization
		tEnv.addObjRelation("XInitialization.args", params);

		//Object[] ExceptionParams = new Object[3];
		//ExceptionParams = params;
		//((PropertyValue) ExceptionParams[1]).Value = Frame;
		Object[] ExceptionParams = new Object[3];
		PropertyValue ExceptionParam1 = new PropertyValue();
		ExceptionParam1.Name = "DataSourceName";
		ExceptionParam1.Value = "Bibliography2";
		ExceptionParams[0] = ExceptionParam1;
		PropertyValue ExceptionParam2 = new PropertyValue();
		ExceptionParam2.Name = "Frame";
		ExceptionParam2.Value = null;
		ExceptionParams[1] = ExceptionParam2;
		PropertyValue ExceptionParam3 = new PropertyValue();
		ExceptionParam3.Name = "QueryDesignView";
		ExceptionParam3.Value = new Integer(17); // new Boolean(true);
		ExceptionParams[2] = ExceptionParam3;

		tEnv.addObjRelation("XInitialization.ExceptionArgs", ExceptionParams);

		tEnv.addObjRelation("Frame", xFrame);

		tEnv.addObjRelation("XInitialization.xIni", getUninitializedObj(Param));

		log.println("ImplementationName: "+util.utils.getImplName(oObj));

		return tEnv;

	} // finish method getTestEnvironment

	private XInitialization getUninitializedObj(TestParameters Param){
		// create an object which is not initialized

		// get a model of a DataSource
		Object oDBC = null;
		XMultiServiceFactory xMSF;

		try {
			xMSF = (XMultiServiceFactory)Param.getMSF();
			oDBC = xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" );
		}
		catch( com.sun.star.uno.Exception e ) {
			throw new StatusException("Could not instantiate DatabaseContext", e) ;
		}

		Object oDataSource = null;
		try{
			XNameAccess xNA = (XNameAccess) UnoRuntime.queryInterface(XNameAccess.class, oDBC);
			oDataSource = xNA.getByName(sDataSourceName);
		} catch ( com.sun.star.container.NoSuchElementException e){
			throw new StatusException("could not get '" + sDataSourceName + "'" , e) ;
		} catch ( com.sun.star.lang.WrappedTargetException e){
			throw new StatusException("could not get '" + sDataSourceName + "'" , e) ;
		}

		XDocumentDataSource xDDS = (XDocumentDataSource) UnoRuntime.queryInterface(XDocumentDataSource.class, oDataSource);
		XModel xMod = (XModel) UnoRuntime.queryInterface(XModel.class, xDDS.getDatabaseDocument ());

		// get an instance of QueryDesign
		Object oQueryDesign = null;
		try{
			oQueryDesign = xMSF.createInstance("com.sun.star.sdb.QueryDesign");
		}catch( com.sun.star.uno.Exception e ) {
			throw new StatusException("Could not instantiate QueryDesign", e) ;
		}

		XController xCont = (XController) UnoRuntime.queryInterface(XController.class, oQueryDesign);

		// marry them all
		xCont.attachModel(xMod);
		xMod.connectController(xCont);
		try{
			xMod.setCurrentController(xCont);
		} catch (com.sun.star.container.NoSuchElementException e){
			throw new StatusException("Could not set controller", e) ;
		}

		//xCont.attachFrame(xFrame);

		return (XInitialization) UnoRuntime.queryInterface(XInitialization.class, oQueryDesign);

	}

	@Override
	protected void cleanup(TestParameters tParam, PrintWriter log) {
		try {
			xConn.close() ;
			DesktopTools.closeDoc(xFrame);
			DesktopTools.closeDoc(xTextDoc);
		} catch (com.sun.star.uno.Exception e) {
			log.println("Can't close the connection") ;
			e.printStackTrace(log) ;
		} catch (com.sun.star.lang.DisposedException e) {
			log.println("Connection was already closed. It's OK.") ;
		}

	}

	/**
	* Sleeps for 0.2 sec. to allow OpenOffice to react on <code>
	* reset</code> call.
	*/
	private void shortWait() {
		try {
			Thread.sleep(5000) ;
		} catch (InterruptedException e) {
			System.out.println("While waiting :" + e) ;
		}
	}

}	// finish class oDatasourceBrowser