Examples of SQLReportDataFactory

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

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
  public void testMetaDataJndi()
  {
    final JndiConnectionProvider drc = new JndiConnectionProvider();
    drc.setConnectionPath("sampledata");

    final SQLReportDataFactory sqlReportDataFactory = new SQLReportDataFactory(drc);
    final DataFactoryMetaData metaData = sqlReportDataFactory.getMetaData();
    assertEquals("Name property set, so display name must be test",
        "sampledata", metaData.getDisplayConnectionName(sqlReportDataFactory));
    sqlReportDataFactory.setQuery("test", "SELECT * FROM TABLE");

    assertNotNull("QueryHash must exist",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()));

    final SQLReportDataFactory sqlReportDataFactory2 = new SQLReportDataFactory(drc);
    sqlReportDataFactory2.setQuery("test", "SELECT * FROM TABLE2");

    assertNotEquals("Physical Queries do not match, so query hash must be different",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()),
        (metaData.getQueryHash(sqlReportDataFactory2, "test", new StaticDataRow())));


    sqlReportDataFactory2.setQuery("test2", "SELECT * FROM TABLE");
    final Object qh1 = metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow());
    final Object qh2 = metaData.getQueryHash(sqlReportDataFactory2, "test2", new StaticDataRow());
    assertEquals("Physical Queries match, so queries are considered the same", qh1, qh2);

    final JndiConnectionProvider drc2 = new JndiConnectionProvider();
    drc.setConnectionPath("sampledata2");
    final SQLReportDataFactory sqlReportDataFactory3 = new SQLReportDataFactory(drc2);
    sqlReportDataFactory3.setQuery("test", "SELECT * FROM TABLE2");
    assertNotEquals("Connections do not match, so query hash must be different",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()),
        (metaData.getQueryHash(sqlReportDataFactory3, "test", new StaticDataRow())));

    sqlReportDataFactory3.setQuery("test2", "SELECT * FROM TABLE");
    assertNotEquals("Connections do not match, so queries are considered the same",
        metaData.getQueryHash(sqlReportDataFactory, "test", new StaticDataRow()),
        metaData.getQueryHash(sqlReportDataFactory3, "test2", new StaticDataRow()));
  }
View Full Code Here

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

109
110
111
112
113
114
115
116
117
  }

  protected DataFactory createDataFactory(final String query)
  {
    final JndiConnectionProvider drc = new JndiConnectionProvider("SampleData", null, null);
    final SQLReportDataFactory sqlReportDataFactory = new SQLReportDataFactory(drc);
    sqlReportDataFactory.setQuery("default", query);
    return sqlReportDataFactory;
  }
View Full Code Here

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

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
  public void testWrite() throws Exception
  {
    final JndiConnectionProvider dummy = new JndiConnectionProvider();
    dummy.setConnectionPath("Dummy");
    final SQLReportDataFactory  df = new SQLReportDataFactory(dummy);
    df.setGlobalScript("GlobalScript");
    df.setGlobalScriptLanguage("GlobalScriptLanguage");
    df.setQuery("QueryName", "QueryText", "ScriptLanguage", "Script");
    final MasterReport report = new MasterReport();
    report.setDataFactory(df);

    final MasterReport masterReport = postProcess(report);
    final SQLReportDataFactory dataFactory = (SQLReportDataFactory) masterReport.getDataFactory();
    assertEquals("QueryName", dataFactory.getQueryNames()[0]);
    assertEquals("QueryText", dataFactory.getQuery("QueryName"));
    assertEquals("ScriptLanguage", dataFactory.getScriptingLanguage("QueryName"));
    assertEquals("Script", dataFactory.getScript("QueryName"));
    assertEquals("GlobalScript", dataFactory.getGlobalScript());
    assertEquals("GlobalScriptLanguage", dataFactory.getGlobalScriptLanguage());
  }
View Full Code Here

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

45
46
47
48
49
50
51
  {
    DataSourcePlugin editor =
        DataFactoryRegistry.getInstance().getMetaData(SQLReportDataFactory.class.getName()).createEditor();
    assertNotNull(editor);

    assertTrue(editor.canHandle(new SQLReportDataFactory(new JndiConnectionProvider())));
  }
View Full Code Here

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

73
74
75
76
77
78
79
80
81
82
83
    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

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

195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
        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(), null, null);
        }

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

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

879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
    else
    {
      return null;
    }

    final SQLReportDataFactory newDataFactory = new SQLReportDataFactory(connectionProvider);
    newDataFactory.setPasswordField(dialogModel.getJdbcPasswordField());
    newDataFactory.setUserField(dialogModel.getJdbcUserField());
    newDataFactory.setGlobalScriptLanguage(getGlobalScriptingLanguage());
    if (StringUtils.isEmpty(globalScriptTextArea.getText()) == false)
    {
      newDataFactory.setGlobalScript(globalScriptTextArea.getText());
    }

    final DataSetComboBoxModel<String> queries = dialogModel.getQueries();
    for (int i = 0; i < queries.getSize(); i++)
    {
      final DataSetQuery<String> query = queries.getQuery(i);
      newDataFactory.setQuery(query.getQueryName(), query.getQuery(), query.getScriptLanguage(), query.getScript());
    }
    return newDataFactory;
  }
View Full Code Here

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

135
136
137
138
139
140
141
142
143
144
145
        }
        if (maxRows == null)
        {
          maxRows = 0;
        }
        final SQLReportDataFactory dataFactory = createDataFactory(connectionDefinition);
        DataFactoryEditorSupport.configureDataFactoryForPreview(dataFactory, designTimeContext);
        final JdbcPreviewWorker previewWorker = new JdbcPreviewWorker(dataFactory, query, 0, maxRows);
        dialog.showData(previewWorker);

        final ReportDataFactoryException theException = previewWorker.getException();
View Full Code Here

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

234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
      }

      Connection conn = null;
      try
      {
        final SQLReportDataFactory factory = createDataFactory(connectionDefinition);
        DataFactoryEditorSupport.configureDataFactoryForPreview(factory, designTimeContext);
        conn = factory.getConnectionProvider().createConnection(null, null);
        if (conn == null)
        {
          JOptionPane.showMessageDialog(JdbcDataSourceDialog.this,
              Messages.getString("JdbcDataSourceDialog.InvokeQueryDesignerError"),
              Messages.getString("JdbcDataSourceDialog.InvokeQueryDesignerError.Title"),
              JOptionPane.ERROR_MESSAGE);
          return;
        }

        final String schema = performQuerySchema(conn);

        final QueryBuilder queryBuilder = new QueryBuilder(conn);
        QueryBuilder.autoAlias = false;
        final JdbcQueryDesignerDialog queryDesigner = new JdbcQueryDesignerDialog(JdbcDataSourceDialog.this, queryBuilder);
        final String query = queryDesigner.designQuery(designTimeContext, factory.getConnectionProvider(),
                                                       schema, queryTextArea.getText());
        if (query != null)
        {
          queryTextArea.setText(query);
        }
View Full Code Here

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

77
78
79
80
81
82
83
84
    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, null, null);
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.