Package org.openrdf.sesame.query

Examples of org.openrdf.sesame.query.QueryResultsTable

88
89
90
91
92
93
94
95
   * @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
18
19
20
21
22
23
24
25
26
27
        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
26
27
28
29
30
31
32
33
34
35
    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
34
35
36
37
38
39
40
41
42
43
    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
42
43
44
45
46
47
48
49
50
51
        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
51
52
53
54
55
56
57
58
59
60
    }
   
   
    @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
60
61
62
63
64
65
66
67
68
69
70
71
72
    }
   
  @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
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
 
  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
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
   
    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
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
    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
TOP

Related Classes of org.openrdf.sesame.query.QueryResultsTable

  • org.corrib.s3b.mbb.db.rdf.SesameWrapper
  • org.corrib.s3b.mbb.service.FrequentConceptsService
  • org.corrib.s3b.mbb.service.ListContextsService
  • org.corrib.s3b.recommendations.RecommendationUtils
  • org.corrib.s3b.recommendations.servlets.RecommendationsServlet
  • org.fao.geonet.kernel.rdf.Query
  • org.fao.geonet.kernel.rdf.QueryBuilderTest
  • VirtuosoExample1
  • VirtuosoExample2
  • VirtuosoExample3
    • 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.