Package org.cyclop.model

Examples of org.cyclop.model.CqlQuery

232
233
234
235
236
237
238
239
240
241
    Iterator<QueryEntry> favIt = fav.iterator();
    assertEquals(50, fav.size());
    assertEquals(50, history.size());
    for (int i = 0; i < 50; i++) {
      assertTrue(favIt.hasNext());
      CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select * from MyTable where id=" + i);
      assertTrue(history.contains(new QueryEntry(query, 7754)));
      assertTrue(history.contains(favIt.next()));
    }
  }
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
    {
      QueryHistory history = new QueryHistory();

      for (int i = 0; i < 600; i++) {
        CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select * from MyTable1 where id=" + i);
        history.add(new QueryEntry(query, 4563));
      }
      assertEquals(500, history.size());
      testHistRange(history, 599, 100);
      storage.store(userId, history);
    }

    {
      Optional<QueryHistory> history = storage.read(userId, QueryHistory.class);
      assertNotNull(history);
      assertEquals(500, history.get().size());
      testHistRange(history.get(), 599, 100);

      for (int i = 0; i < 10; i++) {
        CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select * from MyTable2 where id=" + i);
        history.get().add(new QueryEntry(query, 567));
      }
      storage.store(userId, history.get());
    }

View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
  @Inject
  private CsvQueryResultExporter exporter;

  @Test
  public void testExportAsCsv_ResultEmpty() {
    CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select id from cqldemo.mybooks where pages=-1");
    String exportRsult = exporter.exportAsCsv(query);
    assertNotNull(exportRsult);

    try (Scanner scanner = new Scanner(exportRsult)) {
      int lineIndex = 0;
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
    }
  }

  @Test
  public void testExportAsCsv_SelectIdsFromMyBooks() {
    CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select id from cqldemo.mybooks where pages=2299");
    String exportRsult = exporter.exportAsCsv(query);
    assertNotNull(exportRsult);

    try (Scanner scanner = new Scanner(exportRsult)) {
      int lineIndex = 0;
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    }
  }

  @Test
  public void testExportAsCsv_SelectAutorsAndGerneFromMyBooks() {
    CqlQuery query = new CqlQuery(CqlQueryType.SELECT,
        "select authors, genre from cqldemo.mybooks where pages=2299");
    String exportRsult = exporter.exportAsCsv(query);
    assertNotNull(exportRsult);

    try (Scanner scanner = new Scanner(exportRsult)) {
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
    }
  }

  @Test
  public void testExportAsCsv_SelectAllFromMyBooks() {
    CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select * from cqldemo.mybooks where pages=2299");
    String exportRsult = exporter.exportAsCsv(query);
    assertNotNull(exportRsult);

    try (Scanner scanner = new Scanner(exportRsult)) {
      int lineIndex = 0;
View Full Code Here
129
130
131
132
133
134
135
    vh.verifyIsEmpty(index);
  }

  @Test(expected = BeanValidationException.class)
  public void testFindColumnNames_ViolationEmpty() {
    qs.execute(new CqlQuery(CqlQueryType.USE, " "));
  }
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
    qs.execute(null);
  }

  @Test
  public void testFindColumnNames_KeyspaceInSession() {
    qs.execute(new CqlQuery(CqlQueryType.USE, "use cqldemo"));
    ImmutableSortedSet<CqlColumnName> resp = qs.findColumnNames(Optional.of(new CqlTable("MyBooks")));
    assertNotNull(resp);
    assertTrue("readSize: " + resp.size(), resp.size() > 5);
    vh.verifyContainsMybooksColumns(resp, true);
    vh.verifyContainsSystemColumns(resp, false);
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
    vh.verifyContainsCompoundTestColumns(allColumnNames, true);
  }

  @Test
  public void testExecute_CompoundPkNoDynamicColumns() {
    qs.execute(new CqlQuery(CqlQueryType.USE, "USE CqlDemo"));
    CqlQuery query = new CqlQuery(CqlQueryType.SELECT, "select * from CompoundTest where deesc='TEST_SET_1'");
    try (QueryHistory.HistoryIterator iterator = hs.read().iterator()) {
      assertNotSame(query, iterator.next().query);
    }
    CqlQueryResult res = qs.execute(query);
    try (QueryHistory.HistoryIterator iterator = hs.read().iterator()) {
View Full Code Here
197
198
199
200
201
202
203
    assertEquals(50, rowsCnt);
  }

  @Test(expected = BeanValidationException.class)
  public void testExecute_IncorrectParams() {
    qs.execute(new CqlQuery(null, null));
  }
View Full Code Here
TOP

Related Classes of org.cyclop.model.CqlQuery

  • org.cyclop.service.cassandra.TestQueryService
  • org.cyclop.service.common.TestFileStorage
  • org.cyclop.service.completion.TestCompletionService
  • org.cyclop.service.exporter.TestCsvQueryResultExporter
  • org.cyclop.service.importer.AbstractImporterCase
  • org.cyclop.service.importer.intern.ImportWorker
  • org.cyclop.service.importer.intern.ParallelQueryImporter
  • org.cyclop.service.importer.intern.SerialQueryImporter
  • org.cyclop.service.importer.TestSerialQueryImporter
  • org.cyclop.service.queryprotocoling.intern.TestFavouritesService
    • 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.