Difference between revisions of "Documentation/DevGuide/Database/The SingleSelectQueryComposer"

  public void testSingleSelectQueryComposer() {
      log.println("testing SingleSelectQueryComposer");
 
      try
      {
          XNameAccess xNameAccess = (XNameAccess)UnoRuntime.queryInterface(XNameAccess.class,
              ((XMultiServiceFactory)param.getMSF()).createInstance("com.sun.star.sdb.DatabaseContext"));
          // we use the first datasource
          XDataSource xDS = (XDataSource)UnoRuntime.queryInterface(XDataSource.class, 
              xNameAccess.getByName( "Bibliography" )); 
 
          log.println("check XMultiServiceFactory");
          XMultiServiceFactory xConn = (XMultiServiceFactory)UnoRuntime.queryInterface(XMultiServiceFactory.class, xDS.getConnection(new String(),new String()));
 
          log.println("check getAvailableServiceNames");
          String[] sServiceNames = xConn.getAvailableServiceNames();
          assure("Service 'SingleSelectQueryComposer' not supported" ,sServiceNames[0].equals("com.sun.star.sdb.SingleSelectQueryComposer"));
          XSingleSelectQueryAnalyzer xQueryAna = (XSingleSelectQueryAnalyzer)
              UnoRuntime.queryInterface(XSingleSelectQueryAnalyzer.class,xConn.createInstance( sServiceNames[0]));
 
          log.println("check setQuery");
          xQueryAna.setQuery("SELECT * FROM \"biblio\"");
          assure("Query not identical", xQueryAna.getQuery().equals("SELECT * FROM \"biblio\""));
 
          // XSingleSelectQueryComposer
          XSingleSelectQueryComposer xComposer = (XSingleSelectQueryComposer)
              UnoRuntime.queryInterface(XSingleSelectQueryComposer.class,xQueryAna);
 
          log.println("check setFilter");
          // filter
          xComposer.setFilter("\"Identifier\" = 'BOR02b'");
          assure("Query not identical:" + xQueryAna.getFilter() + " -> \"Identifier\" = 'BOR02b'", xQueryAna.getFilter().equals("\"Identifier\" = 'BOR02b'"));
 
          log.println("check setGroup");
          // group by
          xComposer.setGroup("\"Identifier\"");
          assure("Query not identical:" + xQueryAna.getGroup() + " -> \"Identifier\"", xQueryAna.getGroup().equals("\"Identifier\""));
 
          log.println("check setOrder");
          // order by
          xComposer.setOrder("\"Identifier\"");
          assure("Query not identical:" + xQueryAna.getOrder() + " -> \"Identifier\"", xQueryAna.getOrder().equals("\"Identifier\""));
 
          log.println("check setHavingClause");
          // having
          xComposer.setHavingClause("\"Identifier\" = 'BOR02b'");
          assure("Query not identical:" + xQueryAna.getHavingClause() + " -> \"Identifier\" = 'BOR02b'", xQueryAna.getHavingClause().equals("\"Identifier\" = 'BOR02b'"));
 
          log.println("check getOrderColumns");
          // order by columns
          XIndexAccess xOrderColumns = xQueryAna.getOrderColumns();
          assure("Order columns doesn't exist -> \"Identifier\"", xOrderColumns != null && xOrderColumns.getCount() == 1 && xOrderColumns.getByIndex(0) != null);
 
          log.println("check getGroupColumns");
          // group by columns
          XIndexAccess xGroupColumns = xQueryAna.getGroupColumns();
          assure("Group columns doesn't exist -> \"Identifier\"", xGroupColumns != null && xGroupColumns.getCount() == 1 && xGroupColumns.getByIndex(0) != null);
 
          log.println("check getColumns");
          // XColumnsSupplier
          XColumnsSupplier xSelectColumns = (XColumnsSupplier)
          UnoRuntime.queryInterface(XColumnsSupplier.class,xQueryAna);
          assure("Select columns doesn't exist", xSelectColumns != null && xSelectColumns.getColumns() != null && xSelectColumns.getColumns().getElementNames().length != 0);
 
          log.println("check structured filter");
          // structured filter
          xQueryAna.setQuery("SELECT \"Identifier\", \"Type\", \"Address\" FROM \"biblio\" \"biblio\"");
          xComposer.setFilter(complexFilter);
          PropertyValue[][] aStructuredFilter = xQueryAna.getStructuredFilter();
          xComposer.setFilter("");
          xComposer.setStructuredFilter(aStructuredFilter);
          assure("Structured Filter not identical" , xQueryAna.getFilter().equals(complexFilter));
 
          log.println("check structured having");
          // structured having clause
          xComposer.setHavingClause(complexFilter);
          PropertyValue[][] aStructuredHaving = xQueryAna.getStructuredHavingFilter();
          xComposer.setHavingClause("");
          xComposer.setStructuredHavingFilter(aStructuredHaving);
          assure("Structured Having Clause not identical" , xQueryAna.getHavingClause().equals(complexFilter));
      }
      catch(Exception e)
      {
          assure("Exception catched: " + e,false);
      }
  }