Java Query类代码示例

import mondrian.olap.Query; //导入依赖的package包/类
@Override
public JRDataSource createDatasource() throws JRException
{
	JRDataSource dataSource = null;
	
	String queryStr = getQueryString();
	if (connection != null && queryStr != null)
	{
		if (log.isDebugEnabled())
		{
			log.debug("MDX query: " + queryStr);
		}
		
		Query query = connection.parseQuery(queryStr);
		result = connection.execute(query);
		logResult();
		
		dataSource = new JRMondrianDataSource(dataset, result);
	}

	return dataSource;
}
 

import mondrian.olap.Query; //导入依赖的package包/类
MondrianOlap4jCellSetMetaData(
    MondrianOlap4jStatement olap4jStatement,
    Query query)
{
    this.olap4jStatement = olap4jStatement;
    this.query = query;

    for (final QueryAxis queryAxis : query.getAxes()) {
        axesMetaData.add(
            new MondrianOlap4jCellSetAxisMetaData(
                this, queryAxis));
    }
    filterAxisMetaData =
        new MondrianOlap4jCellSetAxisMetaData(
            this, query.getSlicerAxis());
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public JRMondrianResult(Result result)
{
	this.result = result;

	JRMondrianFactory factory = new JRMondrianFactory();

	Query query = result.getQuery();
	Axis[] resultAxes = result.getAxes();
	axes = new JRMondrianAxis[resultAxes.length];
	for (int i = 0; i < resultAxes.length; i++)
	{
		AxisOrdinal ordinal = AxisOrdinal.StandardAxisOrdinal.forLogicalOrdinal(i);
		axes[i] = new JRMondrianAxis(resultAxes[i], query.getMdxHierarchiesOnAxis(ordinal), factory);
	}
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public void testSlicerAxisDoesNotGetNonEmptyApplied() {
   propSaver.set(
       MondrianProperties.instance().EnableNonEmptyOnAllAxis, true);
   String mdxQuery = "select from [Sales]\n"
       + "where [Time].[1997]\n";
   Query query = getConnection().parseQuery(mdxQuery);
   TestContext.assertEqualsVerbose(mdxQuery, query.toString());
}
 

import mondrian.olap.Query; //导入依赖的package包/类
protected Result executeQuery(String mdx, Connection connection) {
    Query query = connection.parseQuery(mdx);
    query.setResultStyle(ResultStyle.LIST);
    return connection.execute(query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
protected void parseQuery(Query query)
{

    QueryAxis[] axes = query.getAxes();
    for (QueryAxis axis : axes)
    {
        IROlapResultAxis jrAxis = new IROlapResultAxis();
        ((IROlapResult)xmlaResult).addAxis(jrAxis);

        Hierarchy[] hierarchies = query.getMdxHierarchiesOnAxis(axis.getAxisOrdinal());
        for (Hierarchy hierarchy : hierarchies)
        {
            boolean addMeasures = false;
            IROlapHierarchy jrHierarchy = new IROlapHierarchy(hierarchy.getName());
            if (hierarchy.getName().equals("Measures"))
            {
                addMeasures = true;
            }
            jrHierarchy.setHierarchyUniqueName( hierarchy.getUniqueName() );
            Level[] levels = hierarchy.getLevels();
            for (Level level : levels)
            {
                IROlapHierarchyLevel jrLevel = new IROlapHierarchyLevel(level.getName(), level.getDepth());

                jrHierarchy.addHierarchyLevel(jrLevel);
            }

            jrAxis.addHierarchy(jrHierarchy);

             // Add axis tubles for measures...
            if (addMeasures)
            {
                Set<Member> memberSet = query.getMeasuresMembers();
                IROlapMemberTuple tuple = new IROlapMemberTuple();

                Iterator iter = memberSet.iterator();
                while (iter.hasNext())
                {
                    Member m = (Member)iter.next();
                    JRXmlaMember member = new JRXmlaMember(m.getName(), m.getUniqueName(), m.getDimension().getName(), m.getLevel().getName(), m.getDepth());
                    tuple.addMember(member);

                }

                jrAxis.addTuple(tuple);
            }
        }



    }

}
 

import mondrian.olap.Query; //导入依赖的package包/类
/**
 * @return the query
 */
public Query getQuery() {
	return query;
}
 

import mondrian.olap.Query; //导入依赖的package包/类
/**
 * Sets the query. Automatically calls <code>{@link #setDirty}(true)</code>.
 */
public void setQuery(Query query) {
    this.query = query;
    setDirty();
}
 

import mondrian.olap.Query; //导入依赖的package包/类
Collection<RolapCube> getBaseCubeCollection(final Query query) {
    return query.getBaseCubes();
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public MondrianOlap4jCellSet newCellSet(
    MondrianOlap4jStatement olap4jStatement,
    Query query)
{
    return new MondrianOlap4jCellSetJdbc4(olap4jStatement, query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public MondrianOlap4jCellSetJdbc4(
    MondrianOlap4jStatement olap4jStatement,
    Query query)
{
    super(olap4jStatement, query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public MondrianOlap4jCellSet newCellSet(
    MondrianOlap4jStatement olap4jStatement,
    Query query)
{
    return new MondrianOlap4jCellSetJdbc3(olap4jStatement, query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public MondrianOlap4jCellSetJdbc3(
    MondrianOlap4jStatement olap4jStatement, Query query)
{
    super(olap4jStatement, query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
Result executeQuery(String mdx, Connection connection) {
    Query query = connection.parseQuery(mdx);
    return connection.execute(query);
}
 

import mondrian.olap.Query; //导入依赖的package包/类
public void
    testCallingLoadColumnsInAddCollapsedColumnOrAddzSpecialCollapsedColumn()
    throws Exception
{
    Logger logger = Logger.getLogger(AggGen.class);
    StringWriter writer = new StringWriter();
    Appender myAppender = new WriterAppender(new SimpleLayout(), writer);
    logger.addAppender(myAppender);
    logger.setLevel(Level.DEBUG);

    final String trueValue = "true";

    // This modifies the MondrianProperties for the whole of the
    // test run

    MondrianProperties props = MondrianProperties.instance();
    // If run in Ant and with mondrian.jar, please comment out this line:
    props.AggregateRules.setString("DefaultRules.xml");
    props.UseAggregates.setString(trueValue);
    props.ReadAggregates.setString(trueValue);
    props.GenerateAggregateSql.setString(trueValue);

    final RolapConnection rolapConn = (RolapConnection) getConnection();
    Query query =
        rolapConn.parseQuery(
            "select {[Measures].[Count]} on columns from [HR]");
    rolapConn.execute(query);

    logger.removeAppender(myAppender);

    final DataSource dataSource = rolapConn.getDataSource();
    Connection sqlConnection = null;
    try {
        sqlConnection = dataSource.getConnection();
        DatabaseMetaData dbmeta = sqlConnection.getMetaData();
        JdbcSchema jdbcSchema = JdbcSchema.makeDB(dataSource);
        final String catalogName = jdbcSchema.getCatalogName();
        final String schemaName = jdbcSchema.getSchemaName();

        String log = writer.toString();
        Pattern p = Pattern.compile(
            "DEBUG - Init: Column: [^:]+: `(\\w+)`.`(\\w+)`"
            + Util.nl
            + "WARN - Can not find column: \\2");
        Matcher m = p.matcher(log);

        while (m.find()) {
            ResultSet rs =
                dbmeta.getColumns(
                    catalogName, schemaName, m.group(1), m.group(2));
            assertTrue(!rs.next());
        }
    } finally {
        if (sqlConnection != null) {
            try {
                sqlConnection.close();
            } catch (SQLException e) {
                // ignore
            }
        }
    }
}