/************************************************************************* * * $RCSfile: DataSourceBrowser.idl,v $ * * $Revision: 1.10 $ * * last change: $Author: hr $ $Date: 2003-04-04 17:54:51 $ * * The Contents of this file are made available subject to the terms of * either of the following licenses * * - GNU Lesser General Public License Version 2.1 * - Sun Industry Standards Source License Version 1.1 * * Sun Microsystems Inc., October, 2000 * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2000 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * * * Sun Industry Standards Source License Version 1.1 * ================================================= * The contents of this file are subject to the Sun Industry Standards * Source License Version 1.1 (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.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. * * The Initial Developer of the Original Code is: Sun Microsystems, Inc. * * Copyright: 2000 by Sun Microsystems, Inc. * * All Rights Reserved. * * Contributor(s): _______________________________________ * * ************************************************************************/ #ifndef __com_sun_star_sdb_DataSourceBrowser_idl__ #define __com_sun_star_sdb_DataSourceBrowser_idl__ #ifndef __com_sun_star_frame_XController_idl__ #include #endif #ifndef __com_sun_star_lang_XInitialization_idl__ #include #endif #ifndef __com_sun_star_frame_XDispatchProvider_idl__ #include #endif #ifndef __com_sun_star_form_FormController_idl__ #include #endif module com { module sun { module star { module sdb { //============================================================================= /** implements a component which allows browsing the data sources registered on the system.

This service implements a user interface for browsing data sources registered on the DatabaseContext instance of the system.

It is possible to navigate through all the data sources, it's queries and it's tables. The queries/tables can be displayed in a grid-like view, where functionality for searching, sorting, filtering, and such is provided.

Usually, you won't instantiate this service directly, instead you use the dispatch mechanisms of the application framework to load the URL .component:DB/DataSourceBrowser into an arbitrary frame. This should involve a ContentLoader service, which creates and initializes the browser.

Some aspects of the browser can be controlled from outside, eg., it is possible to dispatch a sort or filter request, if a table or query is being displayed.

The communication between the browser and external instances works in two ways.
The way in is provided by the XDispatchProvider interface the service exports (Please see below for more details on this).
The way out works in another way. There are several URL's which an external instance can provide dispatches for (usually by implementing a XDispatchProviderInterceptor for the parent frame of the browser), thus indicating that the browser should provide special functionality.
In this case, the browser displays and maintains some additional slots (to be more concrete: toolbox items), which, upon triggering, call the XDispatch::dispatch()methodoftheobject provided by the external instance.

In particular, the supported URL's for communicating to an external instance are:

  • .uno:DataSourceBrowser/InsertColumns
    Available whenever an external instance provides a dispatcher ( XDispatch) for this URL.
    Enabled, if at least one row in the grid view of a table or query is selected.
    It is the task of the external instance to provide functionality for this URL, but usually it is used to implement some kind of "Data To Text" functionality.
  • .uno:DataSourceBrowser/InsertContent
    Available whenever an external instance provides a dispatcher( XDispatch ) for this URL.
    Enabled, if at least one row in the grid view of a table or query is selected.
    It is the task of the external instance to provide functionality for this URL, but usually it is used to implement some kind of "Data To Fields" functionality.
  • .uno:DataSourceBrowser/FormLetter
    Available whenever an external instance provides a dispatcher ( XDispatch)forthisURL.
    It is the task of the external instance to provide functionality for this URL, but usually it is used to implement some kind of "Form Letter" functionality.

For all kinds of URL's, the parameters supplied during dispatching build up a DataAccessDescriptor, where the following properties are present:

  • DataAccessDescriptor::DataSourceName
  • DataAccessDescriptor::Command
  • DataAccessDescriptor::CommandType
  • optional DataAccessDescriptor::Selection
  • optional DataAccessDescriptor::BookmarkSelection
  • optional DataAccessDescriptor::ResultSet

The default for DataAccessDescriptor::Selection is to contain bookmarks, if not specifies otherwise by DataAccessDescriptor::BookmarkSelection.

@see com::sun::star::sdb::ContentLoader @see com::sun::star::sdb::DatabaseContext @see com::sun::star::sdb::DataSource @see com::sun::star::frame::XDispatch @see com::sun::star::frame::XDispatchProvider @see com::sun::star::frame::XDispatchProviderInterceptor */ service DataSourceBrowser { /** implements basic form controller functionality.

With a data source browser implementing this interface, external components have access to

  • the grid control which is used to display the currently selected table/query (see XFormController::getControls() )
  • the data form used for displaying objects. As always for components implementing this service, the object returned by XTabController::getModel()isadataform.

*/ [optional] service com::sun::star::form::FormController; /** allows the component to be plugged into frames. */ interface com::sun::star::frame::XController; /** is used to initialize the browser.

Parameters (passed to the method XInitialization::initialize() ) have to be instances of PropertyValue , where the PropertyValue::Name member specifies what the parameter controls, with the PropertyValue::Value member containing the value to be used.
Recognized parameters are:

  • Frame
    has to be an XFrame interface specifying the frame to plug the browser component into.
  • DataSourceName
    The name of the globally registered DataSource to be used for initial display. It is only meaningful together with the other parameters specifying the object to display.
  • CommandType
    This has to be a CommandType value, specifying the type of the object to display initially. It is only meaningful together with the DataSourceName and the Command parameters.
  • Command
    This is a string giving the name of the object to display initially. Whether it is table name, a query name or a SQL string is controller by the CommandType parameter.

*/ interface com::sun::star::lang::XInitialization; /** is used to control the browser from outside.

You may use the XDispatchProvider::queryDispatch method to query for objects which implement the XDispatch interface, and which allow you to be notified on status changes and to dispatch special requests.

The recognized URLs are:

  • .uno:Copy
    implements the usual Copy command. Enabled if the grid view has the focus and text in any cell is selected.
  • .uno:Cut
    implements the usual Cut command. Enabled if the grid view has the focus and text in any cell is selected.
  • .uno:Paste
    implements the usual Paste command. Enabled if the grid view has the focus and a cell which allows text input is being edited.
  • .uno:EditDoc
    allows switching the edit mode of the grid view. Enabled if editing the data is allowed in general.
  • .uno:Undo
    revokes any changes done in the current row.
  • .uno:Save
    saves the changes done in the current row.

*/ interface com::sun::star::frame::XDispatchProvider; }; //============================================================================= }; }; }; }; #endif