return QueryBuilder.lt(key, value); case LTE: return QueryBuilder.lte(key, value); case IN: List<?> values = (List<?>) value;
.from("foo") .where(eq("k", 4)) .and(lte(Arrays.asList("c1", "c2"), Arrays.<Object>asList("a", 2))); assertEquals(select.toString(), query);
/** * Generate an ... <strong>IF list <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Update.E Lte(final List<String> list) { boundValues.add(list); encodedValues.add(meta.list.encodeFromJava(list, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("\"listString\"", QueryBuilder.bindMarker("\"listString\""))); return EntityWithCaseSensitivePK_Update.E.this; }
/** * Generate an ... <strong>IF set <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Delete.E Lte(final Set<String> set) { boundValues.add(set); encodedValues.add(meta.set.encodeFromJava(set, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("\"setString\"", QueryBuilder.bindMarker("\"setString\""))); return EntityWithCaseSensitivePK_Delete.E.this; }
/** * Generate an ... <strong>IF udt <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Delete.E Lte(final UDTWithNoKeyspace udt) { boundValues.add(udt); encodedValues.add(meta.udt.encodeFromJava(udt, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("\"udtWithNoKeyspace\"", QueryBuilder.bindMarker("\"udtWithNoKeyspace\""))); return EntityWithCaseSensitivePK_Delete.E.this; }
/** * Generate an ... <strong>IF list <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithBeanValidation_Update.E Lte(final List<String> list) { boundValues.add(list); encodedValues.add(meta.list.encodeFromJava(list, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("list", QueryBuilder.bindMarker("list"))); return EntityWithBeanValidation_Update.E.this; }
/** * Generate an ... <strong>IF list <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithBeanValidation_Delete.E Lte(final List<String> list) { boundValues.add(list); encodedValues.add(meta.list.encodeFromJava(list, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("list", QueryBuilder.bindMarker("list"))); return EntityWithBeanValidation_Delete.E.this; }
/** * Generate an ... <strong>IF fullIndexOnCollection <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexIndices_Delete.E Lte(final Set<String> fullIndexOnCollection) { boundValues.add(fullIndexOnCollection); encodedValues.add(meta.fullIndexOnCollection.encodeFromJava(fullIndexOnCollection, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("fullindexoncollection", QueryBuilder.bindMarker("fullindexoncollection"))); return EntityWithComplexIndices_Delete.E.this; }
/** * Generate an ... <strong>IF primitiveByte <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Update.E Lte(final byte primitiveByte) { boundValues.add(primitiveByte); encodedValues.add(meta.primitiveByte.encodeFromJava(primitiveByte, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("primitive_byte", QueryBuilder.bindMarker("primitive_byte"))); return EntityWithComplexTypes_Update.E.this; }
/** * Generate an ... <strong>IF integer <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Update.E Lte(final Integer integer) { boundValues.add(integer); encodedValues.add(meta.integer.encodeFromJava(integer, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("integer", QueryBuilder.bindMarker("integer"))); return EntityWithComplexTypes_Update.E.this; }
/** * Generate an ... <strong>IF listOfLongArray <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Update.E Lte(final List<long[]> listOfLongArray) { boundValues.add(listOfLongArray); encodedValues.add(meta.listOfLongArray.encodeFromJava(listOfLongArray, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("listoflongarray", QueryBuilder.bindMarker("listoflongarray"))); return EntityWithComplexTypes_Update.E.this; }
/** * Generate an ... <strong>IF protocolVersionAsOrdinal <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Update.E Lte(final ProtocolVersion protocolVersionAsOrdinal) { boundValues.add(protocolVersionAsOrdinal); encodedValues.add(meta.protocolVersionAsOrdinal.encodeFromJava(protocolVersionAsOrdinal, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.lte("protocolversionasordinal", QueryBuilder.bindMarker("protocolversionasordinal"))); return EntityWithComplexTypes_Update.E.this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token("partitionKey") <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E_TM Lte(Long tokenValue) { where.and(QueryBuilder.lte("token(\"partitionKey\")", QueryBuilder.bindMarker("tokenValue"))); boundValues.add(tokenValue); encodedValues.add(tokenValue); return new EntityWithCaseSensitivePK_Select.E_TM(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(id) <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTuple_Select.E_TM Lte(Long tokenValue) { where.and(QueryBuilder.lte("token(id)", QueryBuilder.bindMarker("tokenValue"))); boundValues.add(tokenValue); encodedValues.add(tokenValue); return new EntityWithComplexTuple_Select.E_TM(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(layer) > ? AND token(layer) <= ?</strong> */ @SuppressWarnings("static-access") public final EntityLayer1_Select.E_TM Gt_And_Lte(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gt("token(layer)",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lte("token(layer)",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityLayer1_Select.E_TM(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token("partitionKey") > ? AND token("partitionKey") <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E Gt_And_Lte(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gt("token(\"partitionKey\")",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lte("token(\"partitionKey\")",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityWithCaseSensitivePK_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>"clusteringColumn" > ? AND "clusteringColumn" <= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E Gt_And_Lte(Long clust_Gt, Long clust_Lte) { where.and(QueryBuilder.gt("\"clusteringColumn\"",QueryBuilder.bindMarker("clusteringColumn_Lte"))); where.and(QueryBuilder.lte("\"clusteringColumn\"",QueryBuilder.bindMarker("clusteringColumn_Lte"))); boundValues.add(clust_Gt); encodedValues.add(meta.clust.encodeFromJava(clust_Gt, Optional.of(cassandraOptions))); boundValues.add(clust_Lte); encodedValues.add(meta.clust.encodeFromJava(clust_Lte, Optional.of(cassandraOptions))); return new EntityWithCaseSensitivePK_Select.E(where, cassandraOptions); }
private Select.Where getStoredAnnotationsQueryLikeKey(CassandraId mailboxId, String key) { return getStoredAnnotationsQuery(mailboxId) .and(gte(CassandraAnnotationTable.KEY, key)) .and(lte(CassandraAnnotationTable.KEY, buildNextKey(key))); }
private PreparedStatement prepareBetweenUidStatement(Session session) { return session.prepare(select(UID) .from(TABLE_NAME) .where(eq(MAILBOX_ID, bindMarker(MAILBOX_ID))) .and(gte(UID, bindMarker(UID_FROM))) .and(lte(UID, bindMarker(UID_TO)))); }