private void advance(){ Clause queueNameClause = QueryBuilder.eq( ShardSerializationImpl.COLUMN_QUEUE_NAME, queueName); Clause regionClause = QueryBuilder.eq( ShardSerializationImpl.COLUMN_REGION, region); Clause activeClause = QueryBuilder.eq( ShardSerializationImpl.COLUMN_ACTIVE, 1); Clause shardIdClause; if (nextStart == 0L && lastShardId.isPresent()) { shardIdClause = QueryBuilder.gt( ShardSerializationImpl.COLUMN_SHARD_ID, lastShardId.get() ); } else if (nextStart == 0L && !lastShardId.isPresent()) { shardIdClause = QueryBuilder.gte( ShardSerializationImpl.COLUMN_SHARD_ID, 0L ); } else { shardIdClause = QueryBuilder.gt( ShardSerializationImpl.COLUMN_SHARD_ID, nextStart ); } Statement query = QueryBuilder.select().all().from(ShardSerializationImpl.getTableName(shardType)) .where(queueNameClause) .and(regionClause) .and(activeClause) .and(shardIdClause) .limit(PAGE_SIZE); List<Row> rows = cassandraClient.getQueueMessageSession().execute(query).all(); currentIterator = getIteratorFromRows(rows); }
queryStatement = select().from(getColumnFamilyName()) .where(eq(EP_BY_APP_ID_APPLICATION_ID_PROPERTY, appId)) .and(gte(EP_BY_APP_ID_ENDPOINT_KEY_HASH_PROPERTY, endpointKey)) .limit(Integer.valueOf(limit) + 1); LOG.debug("Try to find endpoint key hash list by endpoint group id {} "
queryStatement = select().from(getColumnFamilyName()) .where(eq(EP_BY_ENDPOINT_GROUP_ID_ENDPOINT_GROUP_ID_PROPERTY, endpointGroupId)) .and(gte(EP_BY_ENDPOINT_GROUP_ID_ENDPOINT_KEY_HASH_PROPERTY, endpointKey)) .limit(Integer.valueOf(limit) + 1); LOG.debug("Try to find endpoint key hash list by endpoint group id {} "
.from("foo") .where(eq("k", 4)) .and(gte(Arrays.asList("c1", "c2"), Arrays.<Object>asList("a", 2))) .and(lt(Arrays.asList("c1", "c2"), Arrays.<Object>asList("b", 0))); assertEquals(select.toString(), query);
.and(eq("l", "foo")) .and(lt("m", 4)) .and(gte("n", 1)); assertEquals(update.toString(), query);
/** * Generate an ... <strong>IF timeuuid >= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Delete.E Gte(final UUID timeuuid) { boundValues.add(timeuuid); encodedValues.add(meta.timeuuid.encodeFromJava(timeuuid, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.gte("timeuuid", QueryBuilder.bindMarker("timeuuid"))); return EntityWithComplexTypes_Delete.E.this; }
/** * Generate an ... <strong>IF jdkZonedDateTime >= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexTypes_Delete.E Gte(final ZonedDateTime jdkZonedDateTime) { boundValues.add(jdkZonedDateTime); encodedValues.add(meta.jdkZonedDateTime.encodeFromJava(jdkZonedDateTime, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.gte("jdkzoneddatetime", QueryBuilder.bindMarker("jdkzoneddatetime"))); return EntityWithComplexTypes_Delete.E.this; }
/** * Generate an ... <strong>IF indexOnMapValue >= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithComplexIndices_Update.E Gte(final Map<Integer, String> indexOnMapValue) { boundValues.add(indexOnMapValue); encodedValues.add(meta.indexOnMapValue.encodeFromJava(indexOnMapValue, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.gte("indexonmapvalue", QueryBuilder.bindMarker("indexonmapvalue"))); return EntityWithComplexIndices_Update.E.this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(id) >= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithByteBufferType_Select.E_TM Gte(Long tokenValue) { where.and(QueryBuilder.gte("token(id)", QueryBuilder.bindMarker("tokenValue"))); boundValues.add(tokenValue); encodedValues.add(tokenValue); return new EntityWithByteBufferType_Select.E_TM(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>priority >= ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E Gte(Integer priority) { where.and(QueryBuilder.gte("priority", QueryBuilder.bindMarker("priority"))); boundValues.add(priority); encodedValues.add(meta.priority.encodeFromJava(priority, Optional.of(cassandraOptions))); return new EntityWithCaseSensitivePK_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(layer) >= ? AND token(layer) < ?</strong> */ @SuppressWarnings("static-access") public final EntityLayer1_Select.E Gte_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gte("token(layer)",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lt("token(layer)",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityLayer1_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(id) >= ? AND token(id) < ?</strong> */ @SuppressWarnings("static-access") public final EntityAsChild_Select.E Gte_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gte("token(id)",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lt("token(id)",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityAsChild_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token("partitionKey") >= ? AND token("partitionKey") < ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E Gte_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gte("token(\"partitionKey\")",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lt("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>priority >= ? AND priority < ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E Gte_And_Lt(Integer priority_Gte, Integer priority_Lt) { where.and(QueryBuilder.gte("priority",QueryBuilder.bindMarker("priority_Lt"))); where.and(QueryBuilder.lt("priority",QueryBuilder.bindMarker("priority_Lt"))); boundValues.add(priority_Gte); encodedValues.add(meta.priority.encodeFromJava(priority_Gte, Optional.of(cassandraOptions))); boundValues.add(priority_Lt); encodedValues.add(meta.priority.encodeFromJava(priority_Lt, Optional.of(cassandraOptions))); return new EntityWithCaseSensitivePK_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token("partitionKey") >= ? AND token("partitionKey") < ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Select.E_TM Gte_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gte("token(\"partitionKey\")",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lt("token(\"partitionKey\")",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityWithCaseSensitivePK_Select.E_TM(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(id) >= ? AND token(id) < ?</strong> */ @SuppressWarnings("static-access") public final EntityWithBeanValidation_Select.E_TM Gte_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gte("token(id)",QueryBuilder.bindMarker("tokenValue1"))); where.and(QueryBuilder.lt("token(id)",QueryBuilder.bindMarker("tokenValue2"))); boundValues.add(tokenValue1); encodedValues.add(tokenValue1); boundValues.add(tokenValue2); encodedValues.add(tokenValue2); return new EntityWithBeanValidation_Select.E_TM(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 prepareSelectUidGte(Session session) { return session.prepare(select(FIELDS) .from(TABLE_NAME) .where(eq(MAILBOX_ID, bindMarker(MAILBOX_ID))) .and(gte(IMAP_UID, bindMarker(IMAP_UID)))); }
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)))); }