| /************************************************************** |
| * |
| * 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 complex.dbaccess; |
| |
| import com.sun.star.awt.FontSlant; |
| import com.sun.star.awt.TextAlign; |
| import com.sun.star.beans.XPropertySet; |
| import com.sun.star.container.XNameAccess; |
| import com.sun.star.form.runtime.XFormController; |
| import com.sun.star.frame.XController; |
| import com.sun.star.sdb.application.DatabaseObject; |
| import com.sun.star.uno.UnoRuntime; |
| import com.sun.star.util.XCloseable; |
| import connectivity.tools.CRMDatabase; |
| |
| // ---------- junit imports ----------------- |
| import org.junit.Test; |
| import static org.junit.Assert.*; |
| // ------------------------------------------ |
| |
| public class UISettings extends TestCase |
| { |
| // -------------------------------------------------------------------------------------------------------- |
| /** verifies that aliases for inner queries work as expected |
| */ |
| @Test |
| public void checkTableFormattingPersistence() throws java.lang.Exception |
| { |
| // create, load, and connect a DB doc |
| CRMDatabase database = new CRMDatabase( getMSF(), true ); |
| |
| // display a table |
| XFormController tableViewController = UnoRuntime.queryInterface( XFormController.class, |
| database.loadSubComponent( DatabaseObject.TABLE, "customers" ) ); |
| XPropertySet tableControlModel = UnoRuntime.queryInterface( XPropertySet.class, |
| tableViewController.getCurrentControl().getModel() ); |
| |
| // change the table's formatting |
| tableControlModel.setPropertyValue( "FontName", "Andale Sans UI" ); |
| tableControlModel.setPropertyValue( "FontHeight", Float.valueOf( 20 ) ); |
| tableControlModel.setPropertyValue( "FontSlant", FontSlant.ITALIC ); |
| |
| String docURL = database.getDatabase().getModel().getURL(); |
| |
| // save close the database document |
| database.saveAndClose(); |
| |
| // load a copy of the document |
| // normally, it should be sufficient to load the same doc. However, there might be objects in the Java VM |
| // which are not yet freed, and which effectively hold the document alive. More precise: The document (|doc|) |
| // is certainly disposed, but other objects might hold a reference to one of the many other components |
| // around the database document, the data source, the connection, etc. As long as those objects are |
| // not cleaned up, the "database model impl" - the structure holding all document data - will |
| // stay alive, and subsequent requests to load the doc will just reuse it, without really loading it. |
| docURL = copyToTempFile( docURL ); |
| loadDocument( docURL ); |
| database = new CRMDatabase( getMSF(), docURL ); |
| |
| // display the table, again |
| tableViewController = UnoRuntime.queryInterface( XFormController.class, |
| database.loadSubComponent( DatabaseObject.TABLE, "customers" ) ); |
| tableControlModel = UnoRuntime.queryInterface( XPropertySet.class, |
| tableViewController.getCurrentControl().getModel() ); |
| |
| // verify the properties |
| assertEquals( "wrong font name", "Andale Sans UI", (String)tableControlModel.getPropertyValue( "FontName" ) ); |
| assertEquals( "wrong font height", (float)20, ((Float)tableControlModel.getPropertyValue( "FontHeight" )).floatValue(), 0 ); |
| assertEquals( "wrong font slant", FontSlant.ITALIC, (FontSlant)tableControlModel.getPropertyValue( "FontSlant" ) ); |
| |
| // close the doc |
| database.saveAndClose(); |
| } |
| |
| /** |
| * checks whether query columns use the settings of the underlying table column, if they do not (yet) have own |
| * settings |
| * @throws java.lang.Exception |
| */ |
| @Test |
| public void checkTransparentQueryColumnSettings() throws java.lang.Exception |
| { |
| // create, load, and connect a DB doc |
| CRMDatabase database = new CRMDatabase( getMSF(), true ); |
| |
| // display a table |
| XController tableView = database.loadSubComponent( DatabaseObject.TABLE, "customers" ); |
| XFormController tableViewController = UnoRuntime.queryInterface( XFormController.class, |
| tableView ); |
| XNameAccess tableControlModel = UnoRuntime.queryInterface( XNameAccess.class, |
| tableViewController.getCurrentControl().getModel() ); |
| |
| // change the formatting of a table column |
| XPropertySet idColumn = UnoRuntime.queryInterface( XPropertySet.class, tableControlModel.getByName( "ID" ) ); |
| assertTrue( "precondition not met: column already centered", |
| ((Short)idColumn.getPropertyValue( "Align" )).shortValue() != TextAlign.CENTER ); |
| idColumn.setPropertyValue( "Align", TextAlign.CENTER ); |
| |
| // close the table data view |
| XCloseable closeSubComponent = UnoRuntime.queryInterface( XCloseable.class, tableView.getFrame() ); |
| closeSubComponent.close( true ); |
| |
| // create a query based on that column |
| database.getDatabase().getDataSource().createQuery( "q_customers", "SELECT * FROM \"customers\"" ); |
| |
| // load this query, and verify the table column settings was propagated to the query column |
| XFormController queryViewController = UnoRuntime.queryInterface( XFormController.class, |
| database.loadSubComponent( DatabaseObject.QUERY, "q_customers" ) ); |
| tableControlModel = UnoRuntime.queryInterface( XNameAccess.class, |
| queryViewController.getCurrentControl().getModel() ); |
| idColumn = UnoRuntime.queryInterface( XPropertySet.class, tableControlModel.getByName( "ID" ) ); |
| |
| assertTrue( "table column alignment was not propagated to the query column", |
| ((Short)idColumn.getPropertyValue( "Align" )).shortValue() == TextAlign.CENTER ); |
| |
| // save close the database document |
| database.saveAndClose(); |
| } |
| } |