Java Axis.ROWS属性代码示例

/**
 * This method will set the header component to have the default message if
 * there are no hierarchies in this axis.
 */
private void setLabelAsEmptyNoHierarchies() {
	setLayout(new BorderLayout());
	JPanel panel = new JPanel(new MigLayout("flowy, align 50% 50%, ins 20", "align center", ""));
	panel.setBackground(Color.WHITE);
	String axisString = null;
	if (axis == Axis.COLUMNS) {
		axisString = "Columns Axis:";
	} else if (axis == Axis.ROWS) {
		axisString = "Rows Axis:";
	}
	JLabel axisLabel = new JLabel(axisString);
	axisLabel.setFont(axisLabel.getFont().deriveFont(Font.BOLD));
	panel.add(axisLabel, SwingConstants.CENTER);
	JLabel label = new JLabel("Drag Dimensions, Hierarchies,", SwingConstants.CENTER);
	panel.add(label);
	label = new JLabel("Measures, and Members here", SwingConstants.CENTER);
	panel.add(label);
	
	addGreyedButtonsToPanel(panel);
	
	panel.setBorder(defaultBorder);
	add(panel, BorderLayout.CENTER);
}
 

private int calcDropInsertIndex(Point p) {
	if (!(getComponentAt(p) instanceof HierarchyComponent)) return 0;
	HierarchyComponent hc = (HierarchyComponent) getComponentAt(p);
	int indexOfHC = Arrays.asList(getComponents()).indexOf(hc);
	if (indexOfHC == -1) {
		return 0;
	} else {
		Point hcRelativePos = SwingUtilities.convertPoint(
				CellSetTableHeaderComponent.this, new Point(p), hc);
		boolean beforeMiddle;
		if (axis == Axis.ROWS) {
			beforeMiddle = hcRelativePos.x < (hc.getWidth() / 2);
		} else if (axis == Axis.COLUMNS) {
			beforeMiddle = hcRelativePos.y < (hc.getHeight() / 2);
		} else {
			throw new IllegalStateException(
					"I only know how to deal with ROWS and COLUMNS," +
					" but this component is for " + axis);
		}
		if (beforeMiddle) {
			return indexOfHC;
		} else {
			return indexOfHC + 1;
		}
	}
}
 

public void mousePressed(MouseEvent e) {
     	boolean showedPopup = maybeShowPopup(e, selectedMember);
     	if (!showedPopup && selectedMember != null && e.getButton() == MouseEvent.BUTTON1) {
     		try {
     			if (selectedMember instanceof Measure) {
     				Axis sortAxis = axis.getAxisOrdinal() == Axis.ROWS ? Axis.COLUMNS : Axis.ROWS;
SortOrder order = query.getSortOrder(sortAxis);
     				SortOrder newOrder;
     				if (order == SortOrder.ASC) {
     					newOrder = SortOrder.DESC;
     				} else {
     					newOrder = SortOrder.ASC;
     				}
     				query.sortBy(sortAxis, newOrder, (Measure) selectedMember);
     			} else {
     				query.toggleMember(selectedMember);
     			}
     		} catch (Exception ex) {
      		throw new RuntimeException("Database error while trying to execute the OLAP query", ex);
     		}
     	}
     }
 

public Member getMemberAtPoint(Point p) {
	if (axis == null) return null;
	if (axis.getAxisOrdinal() == Axis.ROWS) {
		// This is a special-case optimization for members in the row axis
		int rowNum = (int) (p.y / rowHeight);
     if (rowNum >= getLayoutItems().size()) return null;
     if (rowNum < 0) return null;
     return getLayoutItems().get(rowNum).member;
	} else {
		for (LayoutItem item: getLayoutItems()) {
			if (item.bounds.contains(p)) {
				return item.member;
			}
		}
		return null;
	}
}
 

private void saveOlapAxis(WabitOlapAxis axis) {
	xml.print(out, "<olap4j-axis");
	printCommonAttributes(axis);
	printAttribute("ordinal", axis.getOrdinal().axisOrdinal());
	
	if (axis.getOrdinal() == Axis.ROWS) {
           printAttribute("non-empty", axis.isNonEmpty());
       }
       if (axis.getSortOrder() != null) {
       	printAttribute("sort-order", axis.getSortOrder());
       	printAttribute("sort-evaluation-literal", axis.getSortEvaluationLiteral());
       }
       xml.niprintln(out, ">");
       xml.indent++;
       
       for (WabitOlapDimension dimension : axis.getDimensions()) {
       	saveOlapDimension(dimension);
       }
       
       xml.indent--;
       xml.println(out, "</olap4j-axis>");
}
 

@Override
public Dimension getPreferredSize() {
    createLayout();
    Dimension ps = new Dimension();
    if (axis != null && axis.getAxisOrdinal() == Axis.ROWS) {
    	ps.width = cornerComponent.preferredSizes.get(hierarchyOrdinal).width;
    }
    for (LayoutItem li : getLayoutItems()) {
        ps.width = (int) Math.max(li.bounds.getX() + li.bounds.getWidth(), ps.width);
        ps.height = (int) Math.max(li.bounds.getY() + li.bounds.getHeight(), ps.height);
    }
    return ps;
}
 

@Override
protected void setUp() throws Exception {
    super.setUp();
    wabitAxis = new WabitOlapAxis(Axis.ROWS);
    OlapQuery query = new OlapQuery(new StubOlapConnectionMapping());
    query.addChild(wabitAxis, 0);
    getWorkspace().addOlapQuery(query);
}
 

@Override
protected void setUp() throws Exception {
    super.setUp();
    wabitExclusion = new WabitOlapExclusion(Operator.MEMBER, "unique/member/name");
    
    WabitOlapDimension wabitDimension = new WabitOlapDimension("dimension");
    wabitDimension.addChild(wabitExclusion, 0);
    OlapQuery query = new OlapQuery(new StubOlapConnectionMapping());
    WabitOlapAxis axis = new WabitOlapAxis(Axis.ROWS);
    axis.addDimension(wabitDimension);
    query.addChild(axis, 0);
    getWorkspace().addOlapQuery(query);
}
 

@Override
protected void setUp() throws Exception {
    super.setUp();
    
    wabitDimension = new WabitOlapDimension("Dimension");
    OlapQuery query = new OlapQuery(new StubOlapConnectionMapping());
    WabitOlapAxis axis = new WabitOlapAxis(Axis.ROWS);
    query.addAxis(axis);
    axis.addDimension(wabitDimension);
    getWorkspace().addOlapQuery(query);
}
 

@Override
protected void setUp() throws Exception {
    super.setUp();
    wabitInclusion = new WabitOlapInclusion(Operator.MEMBER, "unique/member/name");
    

    WabitOlapDimension wabitDimension = new WabitOlapDimension("dimension");
    wabitDimension.addChild(wabitInclusion, 0);
    OlapQuery query = new OlapQuery(new StubOlapConnectionMapping());
    WabitOlapAxis axis = new WabitOlapAxis(Axis.ROWS);
    axis.addDimension(wabitDimension);
    query.addChild(axis, 0);
    getWorkspace().addOlapQuery(query);
}
 

/**
    * Tests the initialization of a query as though it was loaded from a file.
    */
   public void testInitAsLoaded() throws Exception {
   	WabitOlapAxis rowsAxis = new WabitOlapAxis(Axis.ROWS);
   	WabitOlapDimension rowsDimension = new WabitOlapDimension("Geography");
   	rowsAxis.addDimension(rowsDimension);
   	WabitOlapInclusion rowsInclusion = new WabitOlapInclusion(Operator.MEMBER, "[Geography].[World]");
   	WabitOlapExclusion rowsExclusion = new WabitOlapExclusion(Operator.MEMBER, "[Geography].[World].[Africa]");
   	rowsDimension.addExclusion(rowsExclusion);
   	rowsDimension.addInclusion(rowsInclusion);
   	
   	WabitOlapAxis columnsAxis = new WabitOlapAxis(Axis.COLUMNS);
   	WabitOlapDimension columnsDimension = new WabitOlapDimension("Measures");
   	columnsAxis.addDimension(columnsDimension);
   	WabitOlapInclusion colInclusion = new WabitOlapInclusion(Operator.MEMBER, "[Measures].[Life Expectancy]");
   	columnsDimension.addInclusion(colInclusion);
   	
   	query.addAxis(columnsAxis);
   	query.addAxis(rowsAxis);
   	
   	//This should not throw an exception
   	query.execute(new SPVariableHelper(query), null);
   	
   	assertNotNull(rowsAxis.getQueryAxis());
   	assertTrue(rowsAxis.getQueryAxis().getDimensions().contains(rowsDimension.getDimension()));
   	
   	assertNotNull(columnsAxis.getQueryAxis());
   	assertTrue(columnsAxis.getQueryAxis().getDimensions().contains(columnsDimension.getDimension()));
   	
   	assertNotNull(rowsDimension.getDimension());
   	assertNotNull(columnsDimension.getDimension());
   	
   	assertNotNull(rowsInclusion.getSelection());
   	assertNotNull(rowsExclusion.getSelection());
   	assertNotNull(colInclusion.getSelection());
}
 

/**
 * Creates a CellSetTableRowHeaderComponent without a given CellSet. This is
 * mainly for providing an table row header for the user to drop Members,
 * Hierarchies, or Dimensions into. If the user has already dropped in a
 * Member, Hierarchy, or Dimension into one header, but not the other (and
 * thus does not yet have a complete query), then the header with members in
 * it can display its existing hierarchies so that the user can tell what
 * they have added already.
 * 
    * @param session
    *            the WabitSwingSession this component belongs to. Must not be
    *            null.
 * @param query
 *            The query that things dropped on the axis component should be
 *            added to.
 * @param axis
 *            The {@link Axis} this component is the header for
 */
   public CellSetTableHeaderComponent(OlapQuery query, Axis axis) throws QueryInitializationException {
       this.query = query;
   	this.axis = axis;
   	graphic = null;
   	int hierarchiesSize = 0;
   	
   	List<Hierarchy> hierarchies = null;
   	
   	if (axis == Axis.ROWS) {
   	    hierarchies = query.getRowHierarchies();
   		if (hierarchies != null) {
   			hierarchiesSize = hierarchies.size();
   			setLayout(new GridLayout(1, Math.max(1, hierarchiesSize)));
   		}
   	} else if (axis == Axis.COLUMNS) {
   	    hierarchies = query.getColumnHierarchies();
   		if (hierarchies != null) {
   			hierarchiesSize = hierarchies.size();
   			setLayout(new GridLayout(Math.max(1, hierarchiesSize), 1));
   		}
   	} else {
   		throw new IllegalArgumentException(
   				"Only rows and columns axes are supported, but I got " + axis);
   	}

   	if (hierarchiesSize == 0) {
   		// Currently defaultBorder needs to be set before calling
		// setLabelAsEmpty() because it uses defaultborder
   		defaultBorder = ROUNDED_DASHED_BORDER;
   	    setLabelAsEmptyNoHierarchies();
   	} else {
    	for (int i = 0; i < hierarchiesSize; i++) {
    		Hierarchy hierarchy = hierarchies.get(i);
    		HierarchyComponent hierarchyComponent = new HierarchyComponent(hierarchy, i);
			hierarchyComponent.setBackground(
					ColourScheme.HEADER_COLOURS[i % ColourScheme.HEADER_COLOURS.length]);
    		add(hierarchyComponent);
    	}
    	defaultBorder = DEFAULT_HIERARCHYCOMP_BORDER;
   	}
       setDropTarget(new DropTarget(this, dropTargetListener));
       setBorder(defaultBorder);
}
 

@Override
protected void setUp() throws Exception {
	final PlDotIni ini = new PlDotIni();
	ini.read(new File("src/test/resources/pl.regression.ini"));
	final Olap4jDataSource source = ini.getDataSource("World Facts OLAP Connection", Olap4jDataSource.class);
	final StubWabitSessionContext context = new StubWabitSessionContext() {
		@Override
		public UserPrompter createUserPrompter(String question,
				UserPromptType responseType, UserPromptOptions optionType,
				UserPromptResponse defaultResponseType,
				Object defaultResponse, String... buttonNames) {
			return new DefaultUserPrompter(optionType,
					defaultResponseType, defaultResponse);
		}
	};
	final OlapConnectionPool olapConnectionPool = new OlapConnectionPool(source, context);
	final OlapConnection con = olapConnectionPool.getConnection();
	//At the time of writing this test there is only one cube in the regression file.
	Cube singleCube = con.getCatalogs().get(0).getSchemas().get(0).getCubes().get(0);
	assertTrue(singleCube.getName().startsWith("World Countries"));
	query = new OlapQuery("test-uuid", 
			context, 
			"test cube", 
			"query", 
			singleCube.getSchema().getCatalog().getName(), 
			singleCube.getSchema().getName(), 
			singleCube.getName(), 
			null);
	WabitSession session = new StubWabitSession(context) {
		@Override
		public WabitSessionContext getContext() {
			return context;
		}
	};
	WabitWorkspace workspace = new WabitWorkspace();
	workspace.setSession(session);
	workspace.addOlapQuery(query);
	query.setOlapDataSource(source);
	rowAxis = new WabitOlapAxis(Axis.ROWS);
	query.addAxis(rowAxis);
}
 

public void testAddAndRemoveChildAfterInit() throws Exception {
    
    OlapQuery query = new OlapQuery(
    						null, 
    						getContext(), 
    						"Life Expectancy And GNP Correlation", 
    						"GUI Query", 
    						"LOCALDB", 
    						"World", 
    						"World Countries",
    						null);
    
    WabitOlapAxis rowAxis = new WabitOlapAxis(Axis.ROWS);
    WabitOlapAxis colAxis = new WabitOlapAxis(Axis.COLUMNS);
    query.addAxis(rowAxis);
    query.addAxis(colAxis);
    
    query.setOlapDataSource((Olap4jDataSource)getSession().getDataSources().getDataSource("World Facts OLAP Connection"));
    
    getWorkspace().addOlapQuery(query);
    query.init();
    query.updateAttributes();
    
    Dimension dimension = query.getCurrentCube().getDimensions().get("Geography");
    
    final Member defaultMember = dimension.getDefaultHierarchy().getDefaultMember();
    query.addToAxis(0, defaultMember, rowAxis.getOrdinal());

    assertEquals(1, rowAxis.getChildren().size());
    
    WabitOlapDimension wabitDimension = (WabitOlapDimension) rowAxis.getChildren().get(0);
    
    rowAxis.removeChild(wabitDimension);
    
    assertFalse(rowAxis.getChildren().contains(wabitDimension));
    assertEquals(0, rowAxis.getChildren().size());
    
    rowAxis.addChild(wabitDimension, 0);
    
    assertTrue(rowAxis.getChildren().contains(wabitDimension));
    assertEquals(1, rowAxis.getChildren().size());
}
 

/**
 * Tests the initialization of a query as though it was loaded from a file
 * and then tries to expand a member.
 */
   public void testInitAsLoadedAndExpandMember() throws Exception {
   	WabitOlapAxis rowsAxis = new WabitOlapAxis(Axis.ROWS);
   	WabitOlapDimension rowsDimension = new WabitOlapDimension("Geography");
   	rowsAxis.addDimension(rowsDimension);
   	WabitOlapInclusion rowsInclusion = new WabitOlapInclusion(Operator.MEMBER, "[Geography].[World]");
   	WabitOlapExclusion rowsExclusion = new WabitOlapExclusion(Operator.MEMBER, "[Geography].[World].[Africa]");
   	rowsDimension.addExclusion(rowsExclusion);
   	rowsDimension.addInclusion(rowsInclusion);
   	
   	WabitOlapAxis columnsAxis = new WabitOlapAxis(Axis.COLUMNS);
   	WabitOlapDimension colDimension = new WabitOlapDimension("Measures");
   	columnsAxis.addDimension(colDimension);
   	WabitOlapInclusion colInclusion = new WabitOlapInclusion(Operator.MEMBER, "[Measures].[Life Expectancy]");
   	colDimension.addInclusion(colInclusion);
   	
   	query.addAxis(columnsAxis);
   	query.addAxis(rowsAxis);

   	//What a train wreck.
   	Cube cube = connectionMapping.createConnection(ds).getSchema().getCubes().get("World Countries");
   	Member worldMember = cube.getDimensions().get("Geography").getHierarchies().get("Geography").getLevels().get(0).getMembers().get(0);
   	
   	assertEquals("World", worldMember.getName());
   	
   	query.execute(new SPVariableHelper(query), null);
   	query.toggleMember(worldMember);

   	WabitOlapAxis afterRowsAxis = null;
   	for (WabitOlapAxis axis : query.getAxes()) {
   		if (axis.getOrdinal() == Axis.ROWS) {
   			afterRowsAxis = axis;
   			break;
   		}
   	}
   	
   	WabitOlapDimension afterRowsDimension = null;
   	for (WabitOlapDimension dimension : afterRowsAxis.getDimensions()) {
   		if (dimension.getName().equals("Geography")) {
   			afterRowsDimension = dimension;
   			break;
   		}
   	}
   	
   	assertEquals(2, afterRowsDimension.getInclusions().size());
   	WabitOlapInclusion inclusion1 = afterRowsDimension.getInclusions().get(0);
   	assertEquals("[Geography].[World]", inclusion1.getUniqueMemberName());
   	
   	WabitOlapInclusion inclusion2 = afterRowsDimension.getInclusions().get(1);
   	assertEquals("[Geography].[World]", inclusion2.getUniqueMemberName());
}