.limit(1)); stmt.setConsistencyLevel(readConsistencyLevel); if (trace) {
queryStatement = select().from(getColumnFamilyName()) .where(eq(EP_BY_APP_ID_APPLICATION_ID_PROPERTY, appId)) .limit(Integer.valueOf(limit) + 1); LOG.debug("Try to find first page of endpoint key hash by application " + "id {} with limit {}", .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 {} " + "with limit {} start from keyHash {}",
.where(eq( EP_BY_ENDPOINT_GROUP_ID_ENDPOINT_GROUP_ID_PROPERTY, endpointGroupId)) .limit(Integer.valueOf(limit) + 1); LOG.debug("Try to find first page of endpoint key hash by group id {} with limit {}", endpointGroupId, limit); .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 {} " + "with limit {} start from keyHash {}",
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithBeanValidation_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithUDTCollectionsPrimitive_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithCaseSensitivePK_Select.W_TM_Priority limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithUDTs_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithSimplePartitionKey_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithNonExistingKeyspace_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityWithCounterColumn_Select.E_TM limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final MultiClusteringEntity_Select.E_TM limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final MultiClusteringEntity_Select.W_C2 limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityForCastFunctionCall_Select.E_TM limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>LIMIT :limit</strong> */ public final EntityForCastFunctionCall_Select.E limit(final Integer limit) { where.limit(QueryBuilder.bindMarker("lim")); boundValues.add(limit); encodedValues.add(limit); return this; }
private Statement createQueryToGetTokensOwnedBy(String ownerId) { UUID ownerUuid = UUID.fromString(ownerId); return QueryBuilder .select() .all() .from(Tokens.TABLE_NAME_BY_OWNER) .where(eq(OWNER_ID, ownerUuid)) .limit(1000); }
private Statement createQueryForMessageWithId(String applicationId, String messageId) { UUID appId = UUID.fromString(applicationId); UUID msgId = UUID.fromString(messageId); return queryBuilder .select() .all() .from(Messages.TABLE_NAME) .where(eq(MESSAGE_ID, msgId)) .and(eq(APP_ID, appId)) .limit(2); }
.from("foo") .where(in("k")) .limit(bindMarker("limit")); assertEquals(select.toString(), query); .and(eq("bar", bindMarker("barmark"))) .and(eq("baz", bindMarker("bazmark"))) .limit(bindMarker("limit")); assertEquals(select.toString(), query); select = select().all().from("foo").where(gt("k", 42)).limit(42); assertEquals(select.toString(), query);
select = select().all().from("foo").where(gt("k=1 OR k", 42)).limit(42); assertEquals(select.toString(), query);
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); }