Examples of QueryResultsTable

org.openrdf.sesame.query.QueryResultsTable

Examples of org.openrdf.sesame.query.QueryResultsTable

   * @throws MalformedQueryException
   * @throws QueryEvaluationException
   * @throws AccessDeniedException
   */
  public List<Q> execute(final Thesaurus thesaurus) throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
      final QueryResultsTable table = rawExecute(thesaurus);
      return new QueryResults(table, thesaurus);
  }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

        super(true);
    }


    @Test
  public void selectIds() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
    QueryResultsTable results = builder().selectId().build().rawExecute(thesaurus);
    
    assertEquals(1, results.getColumnCount());
    assertEquals(keywords, results.getRowCount());
  }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    assertEquals(keywords, results.getRowCount());
  }
  
  @Test
  public void limit() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
    QueryResultsTable results = builder().selectId().limit(2).build().rawExecute(thesaurus);
    
    assertEquals(1, results.getColumnCount());
    assertEquals(2, results.getRowCount());
  }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    assertEquals(2, results.getRowCount());
  }
    
    @Test
    public void offset() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
        QueryResultsTable noOffset = builder().selectId().build().rawExecute(thesaurus);
        QueryResultsTable offset = builder().selectId().offset(2).build().rawExecute(thesaurus);


        assertEquals(noOffset.getValue(2, 0), offset.getValue(0,0));
    }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

        assertEquals(noOffset.getValue(2, 0), offset.getValue(0,0));
    }
    
    @Test
    public void distinct() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
        QueryResultsTable noDistinct = builder().select(Selectors.languages(Selectors.PREF_LABEL), true).build().rawExecute(thesaurus);
        QueryResultsTable distinct = builder().select(Selectors.languages(Selectors.PREF_LABEL), true).distinct(true).build().rawExecute(thesaurus);


        assertTrue(distinct.getRowCount() < noDistinct.getRowCount());
    }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    }
    
    
    @Test
    public void where() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
        QueryResultsTable noWhere = builder().selectId().build().rawExecute(thesaurus);
        QueryResultsTable where = builder().selectId().where(Selectors.ID.id+" LIKE \"*#1*\"").build().rawExecute(thesaurus);
        
        assertTrue(where.getRowCount() < noWhere.getRowCount());
    }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    }
    
  @Test
  public void optional() throws IOException, MalformedQueryException, QueryEvaluationException, AccessDeniedException {
    Selector path = new Selector("noSuch", "{id} gml:XX {noSuch}", Namespace.getNamespace("gml","http://www.opengis.net/gml#"));
    QueryResultsTable requireResults = builder().selectId().select(path , true).build().rawExecute(thesaurus);
    QueryResultsTable optionResults = builder().selectId().select(path , false).build().rawExecute(thesaurus);
    
    assertEquals(0, requireResults.getRowCount());
    assertEquals(keywords, optionResults.getRowCount());
    assertNotNull(optionResults.getValue(0, 0));
    assertNull(optionResults.getValue(0, 1));
  }

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

  
  public static UserRecommendationPrefs[] getUserRecommendationPrefs(String user) {
    UserRecommendationPrefs[] result = null;
    
    if(user != null && !"".equals(user)){
      QueryResultsTable table = SesameWrapper.performTableQuery(Repository.FOAFREALM_REPOSITORY.getLocalRepository(), 
                                  QueryLanguage.SERQL, 
                                  RecommendationQueries.LIST_RECOMMENDATIONS.toString(user));  
      
      
      if(table != null){
        result = new UserRecommendationPrefs[table.getRowCount()];
        
        for(int i = 0; i < table.getRowCount(); i++)
          result[i] = new UserRecommendationPrefs(((Literal)table.getValue(i, 0)).getLabel(), 
                              Integer.valueOf(((Literal)table.getValue(i, 1)).getLabel()), 
                              (table.getValue(i, 2)!=null)?Integer.valueOf(((Literal)table.getValue(i, 2)).getLabel()):null);
      }
    }
    
    if(result == null)
      result = INSTANCE.defaults;

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    
    return new SimpleRecommendation(name);
  }
  
  public static Value[][] performTwodimensionalTableQuery(LocalRepository repository, QueryLanguage queryLanguage, String query) {
    QueryResultsTable results = SesameWrapper.performTableQuery(repository, queryLanguage, query);
    Value[][] asUris;
    
    if(results != null) {
      asUris  = new Value[results.getRowCount()][results.getColumnCount()];
      for(int i = 0; i < results.getRowCount(); i++) {
        for(int j = 0; j < results.getColumnCount(); j++){
          asUris[i][j] = results.getValue(i, j);
        }
      }    
    }else
      asUris = new Value[0][0];

View Full Code Here

Examples of org.openrdf.sesame.query.QueryResultsTable

    Recommendation[] recoTable = set.toArray(new Recommendation[0]);
    for(int i = 0; i<uriTable.length; i++) {
      uriTable[i] = recoTable[i].getRecommendedBook();
    }
    
    QueryResultsTable foundTitlesAndAuthors = SesameWrapper.performTableQuery(Repository.JEROMEDL_REPOSITORY.getLocalRepository(), 
        QueryLanguage.SERQL, RecommendationQueries.TITLES_QUERY.titlesQuery(uriTable));
    
    for(int i = 0; i<foundTitlesAndAuthors.getRowCount(); i++)
      for(int j = 0; j<recoTable.length; j++) {
        if(recoTable[j].getRecommendedBook().equals(foundTitlesAndAuthors.getValue(i, 0))) {
          if(recoTable[j].getTitle() == null)
            recoTable[j].setTitle(foundTitlesAndAuthors.getValue(i, 1).toString());
//          if(recoTable[j].getAuthors() == null)
//            recoTable[j].setAuthors(foundTitlesAndAuthors.getValue(i, 2).toString());
//          else
//            recoTable[j].addAuthor(foundTitlesAndAuthors.getValue(i, 2).toString());
        }

View Full Code Here

0 1

TOP

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.