Package org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql

Examples of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory


    final DriverConnectionProvider driverConnectionProvider = new DriverConnectionProvider();
    driverConnectionProvider.setDriver("org.hsqldb.jdbcDriver");
    driverConnectionProvider.setUrl("jdbc:hsqldb:mem:SampleData");
    driverConnectionProvider.setProperty("user", "sa");
    driverConnectionProvider.setProperty("password", "");
    final SQLReportDataFactory sdf = new SQLReportDataFactory(driverConnectionProvider);
    sdf.setQuery("default", "SELECT * FROM CUSTOMERS WHERE CUSTOMERNUMBER IN (${parameter})");
    sdf.setQuery("params", "SELECT DISTINCT CUSTOMERNUMBER FROM CUSTOMERS");
    sdf.open();

    final ReportParameterValues parameterValues = new ReportParameterValues();
    parameterValues.put("parameter", pvalue);
    sdf.queryData("default", parameterValues);
    sdf.close();

    final MasterReport report = new MasterReport();
    report.setDataFactory(sdf);

    final DefaultListParameter listParameter =
View Full Code Here


        drc.setDriver(selectedJNDIDataSourceReadHandler.getDriverClass());
        drc.setProperty("user", selectedJNDIDataSourceReadHandler.getUsername());
        drc.setProperty("password", selectedJNDIDataSourceReadHandler.getPassword());
        drc.setProperty("::pentaho-reporting::name", selectedJNDIDataSourceReadHandler.getJndiName());

        final SQLReportDataFactory dataFactory = new SQLReportDataFactory(drc);
        for (int i = 0; i < queries.size(); i++)
        {
          final QueryReadHandler handler = (QueryReadHandler) queries.get(i);
          dataFactory.setQuery(handler.getQueryName(), handler.getQuery());
        }

        final String queryNameProperty = result.getProperty("queryString");
        if (queryNameProperty != null)
        {
          dataFactory.setQuery("default", queryNameProperty);
        }
        this.dataFactory = dataFactory;
      }
    }
    else
View Full Code Here

    final DriverConnectionProvider connectionProvider = new DriverConnectionProvider();
    connectionProvider.setDriver(driverClass);
    connectionProvider.setUrl(connectionString);
    connectionProvider.setProperty("user", userName);
    connectionProvider.setProperty("password", password);
    dataFactory = new SQLReportDataFactory(connectionProvider);
    dataFactory.setQuery("default", sqlQuery);
  }
View Full Code Here

    if (xmlWriter == null)
    {
      throw new NullPointerException();
    }

    final SQLReportDataFactory sqlDataFactory = (SQLReportDataFactory) dataFactory;

    final AttributeList rootAttrs = new AttributeList();
    if (xmlWriter.isNamespaceDefined(SQLDataFactoryModule.NAMESPACE) == false)
    {
      rootAttrs.addNamespaceDeclaration("data", SQLDataFactoryModule.NAMESPACE);
    }
    xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "sql-datasource", rootAttrs, XmlWriterSupport.OPEN);
    xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "config", "label-mapping",
        String.valueOf(sqlDataFactory.isLabelMapping()), XmlWriterSupport.CLOSE);

    writeConnectionInfo(reportWriter, xmlWriter, sqlDataFactory.getConnectionProvider());

    final String[] queryNames = sqlDataFactory.getQueryNames();
    for (int i = 0; i < queryNames.length; i++)
    {
      final String queryName = queryNames[i];
      final String query = sqlDataFactory.getQuery(queryName);
      xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "query", "name", queryName, XmlWriterSupport.OPEN);
      xmlWriter.writeTextNormalized(query, false);
      xmlWriter.writeCloseTag();
    }
    xmlWriter.writeCloseTag();
View Full Code Here

    {
      throw new SAXException(
          "Unable to create SQL Factory: No connection provider specified or recognized.");
    }

    final SQLReportDataFactory srdf = new SQLReportDataFactory(provider);
    if (configReadHandler != null)
    {
      srdf.setLabelMapping(configReadHandler.isLabelMapping());
    }
    for (int i = 0; i < queries.size(); i++)
    {
      final PropertyReadHandler handler = (PropertyReadHandler) queries.get(i);
      srdf.setQuery(handler.getName(), handler.getResult());
    }
    dataFactory = srdf;
  }
View Full Code Here

    {
      throw new NullPointerException();
    }


    final SQLReportDataFactory sqlDataFactory = (SQLReportDataFactory) dataFactory;

    final String fileName = BundleUtilities.getUniqueName(bundle, state.getFileName(), "datasources/sql-ds{0}.xml");
    if (fileName == null)
    {
      throw new IOException("Unable to generate unique name for SQL-Data-Source");
    }

    final OutputStream outputStream = bundle.createEntry(fileName, "text/xml");
    final DefaultTagDescription tagDescription = new DefaultTagDescription(
        ClassicEngineBoot.getInstance().getGlobalConfig(), SQLDataFactoryModule.TAG_DEF_PREFIX);
    final XmlWriter xmlWriter = new XmlWriter(new OutputStreamWriter(outputStream, "UTF-8"), tagDescription, "  ",
        "\n");
    final AttributeList rootAttrs = new AttributeList();
    rootAttrs.addNamespaceDeclaration("data", SQLDataFactoryModule.NAMESPACE);
    xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "sql-datasource", rootAttrs, XmlWriterSupport.OPEN);

    final AttributeList configAttrs = new AttributeList();
    configAttrs.setAttribute(SQLDataFactoryModule.NAMESPACE, "user-field", sqlDataFactory.getUserField());
    configAttrs.setAttribute(SQLDataFactoryModule.NAMESPACE, "password-field", sqlDataFactory.getPasswordField());
    configAttrs.setAttribute(SQLDataFactoryModule.NAMESPACE, "label-mapping",
        String.valueOf(sqlDataFactory.isLabelMapping()));
    xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "config", configAttrs, XmlWriterSupport.CLOSE);

    writeConnectionInfo(bundle, state, xmlWriter, sqlDataFactory.getConnectionProvider());

    final String[] queryNames = sqlDataFactory.getQueryNames();
    for (int i = 0; i < queryNames.length; i++)
    {
      final String queryName = queryNames[i];
      final String query = sqlDataFactory.getQuery(queryName);
      xmlWriter.writeTag(SQLDataFactoryModule.NAMESPACE, "query", "name", queryName, XmlWriterSupport.OPEN);
      xmlWriter.writeTextNormalized(query, false);
      xmlWriter.writeCloseTag();
    }
View Full Code Here

    sampleDriverConnectionProvider.setDriver("org.hsqldb.jdbcDriver");
    sampleDriverConnectionProvider.setUrl("jdbc:hsqldb:./sql/sampledata");
    sampleDriverConnectionProvider.setProperty("user", "sa");
    sampleDriverConnectionProvider.setProperty("password", "");

    final SQLReportDataFactory dataFactory = new SQLReportDataFactory(sampleDriverConnectionProvider);
    dataFactory.setQuery(QUERY_NAME,
        "select CUSTOMERNAME, CITY, STATE, POSTALCODE, COUNTRY from CUSTOMERS order by UPPER(CUSTOMERNAME)");

    return dataFactory;
  }
View Full Code Here

    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:./sql/sampledata");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlDataFactory = new SQLReportDataFactory(drc);
    sqlDataFactory.setQuery("default", "      SELECT\n" +
        "           QUADRANT_ACTUALS.REGION,\n" +
        "           QUADRANT_ACTUALS.DEPARTMENT,\n" +
        "           QUADRANT_ACTUALS.POSITIONTITLE,\n" +
        "           QUADRANT_ACTUALS.ACTUAL,\n" +
        "           QUADRANT_ACTUALS.BUDGET,\n" +
View Full Code Here

    final DriverConnectionProvider drc = new DriverConnectionProvider();
    drc.setDriver("org.hsqldb.jdbcDriver");
    drc.setUrl("jdbc:hsqldb:./sql/sampledata");
    drc.setProperty("user", "sa");
    drc.setProperty("password", "");
    final SQLReportDataFactory sqlDataFactory = new SQLReportDataFactory(drc);
    sqlDataFactory.setQuery("default", "      SELECT\n" +
        "           QUADRANT_ACTUALS.REGION,\n" +
        "           QUADRANT_ACTUALS.DEPARTMENT,\n" +
        "           QUADRANT_ACTUALS.POSITIONTITLE,\n" +
        "           QUADRANT_ACTUALS.ACTUAL,\n" +
        "           QUADRANT_ACTUALS.BUDGET,\n" +
View Full Code Here

  {
    URL resource = getClass().getResource("Prd-4843.prpt");
    MasterReport report = (MasterReport)
        new ResourceManager().createDirectly(resource, MasterReport.class).getResource();
    CompoundDataFactory dataFactory = (CompoundDataFactory) report.getDataFactory();
    SQLReportDataFactory dataFactory1 = (SQLReportDataFactory) dataFactory.get(0);
    DriverConnectionProvider conProv1 = (DriverConnectionProvider) dataFactory1.getConnectionProvider();
    Assert.assertEquals("abcdefghijk", conProv1.getProperty("user"));
    Assert.assertEquals("abcdefghijk", conProv1.getProperty("password"));
    SQLReportDataFactory dataFactory2 = (SQLReportDataFactory) dataFactory.get(1);
    DriverConnectionProvider conProv2 = (DriverConnectionProvider) dataFactory2.getConnectionProvider();
    Assert.assertEquals("abcdefghijkl", conProv2.getProperty("user"));
    Assert.assertEquals("abcdefghijkl", conProv2.getProperty("password"));
  }
View Full Code Here

TOP

Related Classes of org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.