Package com.datastax.driver.core.querybuilder

Examples of com.datastax.driver.core.querybuilder.Select


                        insert.value(cm.getColumnName(), bindMarker());
                    return insert.toString();
                }
            case GET:
                {
                    Select select = table == null
                                  ? select().all().from(mapper.getKeyspace(), mapper.getTable())
                                  : select().all().from(table);
                    Select.Where where = select.where();
                    for (int i = 0; i < mapper.primaryKeySize(); i++)
                        where.and(eq(mapper.getPrimaryKeyColumn(i).getColumnName(), bindMarker()));
                    return select.toString();
                }
            case DEL:
                {
                    Delete delete = table == null
                                  ? delete().all().from(mapper.getKeyspace(), mapper.getTable())
                                  : delete().all().from(table);
                    Delete.Where where = delete.where();
                    for (int i = 0; i < mapper.primaryKeySize(); i++)
                        where.and(eq(mapper.getPrimaryKeyColumn(i).getColumnName(), bindMarker()));
                    return delete.toString();
                }
            case SLICE:
            case REVERSED_SLICE:
                {
                    Select select = table == null
                                  ? select().all().from(mapper.getKeyspace(), mapper.getTable())
                                  : select().all().from(table);
                    Select.Where where = select.where();
                    for (int i = 0; i < mapper.partitionKeys.size(); i++)
                        where.and(eq(mapper.partitionKeys.get(i).getColumnName(), bindMarker()));

                    if (startBoundSize > 0) {
                        if (startBoundSize == 1) {
                            String name = mapper.clusteringColumns.get(0).getColumnName();
                            where.and(startInclusive ? gte(name, bindMarker()) : gt(name, bindMarker()));
                        } else {
                            List<String> names = new ArrayList<String>(startBoundSize);
                            List<Object> values = new ArrayList<Object>(startBoundSize);
                            for (int i = 0; i < startBoundSize; i++) {
                                names.add(mapper.clusteringColumns.get(i).getColumnName());
                                values.add(bindMarker());
                            }
                            where.and(startInclusive ? gte(names, values) : gt(names, values));
                        }
                    }

                    if (endBoundSize > 0) {
                        if (endBoundSize == 1) {
                            String name = mapper.clusteringColumns.get(0).getColumnName();
                            where.and(endInclusive ? gte(name, bindMarker()) : gt(name, bindMarker()));
                        } else {
                            List<String> names = new ArrayList<String>(endBoundSize);
                            List<Object> values = new ArrayList<Object>(endBoundSize);
                            for (int i = 0; i < endBoundSize; i++) {
                                names.add(mapper.clusteringColumns.get(i).getColumnName());
                                values.add(bindMarker());
                            }
                            where.and(endInclusive ? lte(names, values) : lt(names, values));
                        }
                    }

                    select = select.limit(bindMarker());

                    if (kind == Kind.REVERSED_SLICE)
                        select = select.orderBy(desc(mapper.clusteringColumns.get(0).getColumnName()));

                    return select.toString();
                }
        }
        throw new AssertionError();
    }
View Full Code Here


  @Test
  public void test() {
    t.insert(c1);
    t.insert(c2);

    Select select = QueryBuilder.select().from("identity_correlations");
    select.where(QueryBuilder.eq("type", "a")).and(QueryBuilder.eq("value", "b"));
    select.setRetryPolicy(DowngradingConsistencyRetryPolicy.INSTANCE);
    select.setConsistencyLevel(ConsistencyLevel.ONE);
    List<CorrelationEntity> correlationEntities = t.select(select, CorrelationEntity.class);

    assertEquals(2, correlationEntities.size());

    QueryOptions qo = new QueryOptions();
View Full Code Here

    String stringQuery = cassandraQuery.createQuery(accesor);
    SimpleStatement actual = new SimpleStatement(stringQuery);

    String table = Person.class.getSimpleName().toLowerCase();
    Select expected = QueryBuilder.select().all().from(table);
    expected.setForceNoValues(true);
    expected.where(QueryBuilder.eq("lastname", "Matthews"));

    assertThat(actual.getQueryString(), is(expected.getQueryString()));
  }
View Full Code Here

    String stringQuery = cassandraQuery.createQuery(accesor);
    SimpleStatement actual = new SimpleStatement(stringQuery);

    String table = Person.class.getSimpleName().toLowerCase();
    Select expected = QueryBuilder.select().all().from(table);
    expected.setForceNoValues(true);
    expected.where(QueryBuilder.eq("lastname", "Matthews")).and(QueryBuilder.eq("firstname", "John"));

    assertThat(actual.getQueryString(), is(expected.getQueryString()));
  }
View Full Code Here

    b1.setAuthor("Cassandra Guru");
    b1.setPages(521);

    template.insert(b1);

    Select select = QueryBuilder.select().all().from("book");
    select.where(QueryBuilder.eq("isbn", "123456-1"));

    Book b = template.selectOne(select, Book.class);

    log.debug("SingleSelect Book Title -> " + b.getTitle());
    log.debug("SingleSelect Book Author -> " + b.getAuthor());
View Full Code Here

    List<Book> books = getBookList(20);

    template.insert(books);

    Select select = QueryBuilder.select().all().from("book");

    List<Book> bookz = template.select(select, Book.class);

    log.debug("Book Count -> " + bookz.size());
View Full Code Here

    Assert.notNull(type);
    Assert.notNull(id);

    CassandraPersistentEntity<?> entity = mappingContext.getPersistentEntity(type);

    Select select = QueryBuilder.select().countAll().from(entity.getTableName().toCql());
    appendIdCriteria(select.where(), entity, id);

    Long count = queryForObject(select, Long.class);

    return count != 0;
  }
View Full Code Here

      throw new IllegalArgumentException(String.format(
          "entity class [%s] uses a composite primary key class [%s] which this method can't support", type.getName(),
          entity.getIdProperty().getCompositePrimaryKeyEntity().getType().getName()));
    }

    Select select = QueryBuilder.select().all().from(entity.getTableName().toCql());
    select.where(QueryBuilder.in(entity.getIdProperty().getColumnName().toCql(), CollectionUtils.toArray(ids)));

    return select(select, type);
  }
View Full Code Here

    CassandraPersistentEntity<?> entity = mappingContext.getPersistentEntity(type);
    if (entity == null) {
      throw new IllegalArgumentException(String.format("unknown entity class [%s]", type.getName()));
    }

    Select select = QueryBuilder.select().all().from(entity.getTableName().toCql());
    appendIdCriteria(select.where(), entity, id);

    return selectOne(select, type);
  }
View Full Code Here

    if (criteria == null) {
      return null;
    }

    Select select = QueryBuilder.select().all().from("TODO");
    select.where(criteria);

    if (LOG.isDebugEnabled()) {
      LOG.debug("Created query " + select.getQueryString());
    }

    return select;
  }
View Full Code Here

TOP

Related Classes of com.datastax.driver.core.querybuilder.Select

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.