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); }
@Override public List<CassandraNotification> findNotificationsByTopicIdAndVersionAndStartSecNum( String topicId, int seqNum, int sysNfVersion, int userNfVersion) { LOG.debug("Try to find notifications by topic id {} start sequence number {} " + "system schema version {} user schema version {}", topicId, seqNum, sysNfVersion, userNfVersion); List<CassandraNotification> resultList = new ArrayList<>(); Where systemQuery = select().from(getColumnFamilyName()) .where(eq(NF_TOPIC_ID_PROPERTY, topicId)) .and(eq(NF_NOTIFICATION_TYPE_PROPERTY, NotificationTypeDto.SYSTEM.name())) .and(eq(NF_VERSION_PROPERTY, sysNfVersion)) .and(QueryBuilder.gt(NF_SEQ_NUM_PROPERTY, seqNum)); Where userQuery = select().from(getColumnFamilyName()) .where(eq(NF_TOPIC_ID_PROPERTY, topicId)) .and(eq(NF_NOTIFICATION_TYPE_PROPERTY, NotificationTypeDto.USER.name())) .and(eq(NF_VERSION_PROPERTY, userNfVersion)) .and(QueryBuilder.gt(NF_SEQ_NUM_PROPERTY, seqNum)); List<CassandraNotification> systemList = findListByStatement(systemQuery); List<CassandraNotification> userList = findListByStatement(userQuery); resultList.addAll(systemList); resultList.addAll(userList); if (LOG.isTraceEnabled()) { LOG.trace("Found notifications {} by topic id {}, seqNum {}, sysVer {}, userVer {} ", Arrays.toString( resultList.toArray()), topicId, seqNum, sysNfVersion, userNfVersion); } return resultList; }
return QueryBuilder.eq(key, value); case GT: return QueryBuilder.gt(key, value); case GTE: return QueryBuilder.gte(key, value);
Clause messageIdClause = QueryBuilder.gt( COLUMN_QUEUE_MESSAGE_ID, nextStart); query = QueryBuilder.select().all().from(QueueMessageSerializationImpl.getTableName(messageType)) .where(queueNameClause)
.from("foo") .where(eq("k", 4)) .and(gt(Arrays.asList("c1", "c2"), Arrays.<Object>asList("a", 2))); assertEquals(select.toString(), query);
@Test(groups = "unit") public void should_not_serialize_raw_query_values() { RegularStatement select = select().from("test").where(gt("i", raw("1"))); assertThat(select.getQueryString()).doesNotContain("?"); assertThat(select.getValues(ProtocolVersion.NEWEST_SUPPORTED, CodecRegistry.DEFAULT_INSTANCE)) .isNull(); }
select = select().all().from("foo").where(eq("k", 4)).and(gt("c", "a")).and(lte("c", "z")); assertEquals(select.toString(), query); select().all().from("foo").where().and(eq("k", 4)).and(gt("c", "a")).and(lte("c", "z")); 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(token("k"), fcall("token", 42))); assertEquals(select.toString(), query); select = select().all().from("foo2").where(gt(token("a", "b"), fcall("token", 42, 101))); assertEquals(select.toString(), query);
.from("foo") .where(eq("a", bindMarker())) .and(gt("b", bindMarker())) .orderBy(desc("b")) .perPartitionLimit(bindMarker())
/** * Generate an ... <strong>IF set > ?</strong> */ @SuppressWarnings("static-access") public final EntityWithCaseSensitivePK_Delete.E Gt(final Set<String> set) { boundValues.add(set); encodedValues.add(meta.set.encodeFromJava(set, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.gt("\"setString\"", QueryBuilder.bindMarker("\"setString\""))); return EntityWithCaseSensitivePK_Delete.E.this; }
/** * Generate an ... <strong>IF list > ?</strong> */ @SuppressWarnings("static-access") public final EntityWithBeanValidation_Update.E Gt(final List<String> list) { boundValues.add(list); encodedValues.add(meta.list.encodeFromJava(list, Optional.of(cassandraOptions))); where.onlyIf(QueryBuilder.gt("list", QueryBuilder.bindMarker("list"))); return EntityWithBeanValidation_Update.E.this; }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(layer) > ?</strong> */ @SuppressWarnings("static-access") public final EntityLayer1_Select.E Gt(Long tokenValue) { where.and(QueryBuilder.gt("token(layer)", QueryBuilder.bindMarker("tokenValue"))); boundValues.add(tokenValue); encodedValues.add(tokenValue); return new EntityLayer1_Select.E(where, cassandraOptions); }
/** * Generate a SELECT ... FROM ... WHERE ... <strong>token(id) > ?</strong> */ @SuppressWarnings("static-access") public final EntityWithByteBufferType_Select.E_TM Gt(Long tokenValue) { where.and(QueryBuilder.gt("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>token(layer) > ? AND token(layer) < ?</strong> */ @SuppressWarnings("static-access") public final EntityLayer1_Select.E Gt_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gt("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(layer) > ? AND token(layer) < ?</strong> */ @SuppressWarnings("static-access") public final EntityLayer1_Select.E_TM Gt_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gt("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_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(id) > ? AND token(id) < ?</strong> */ @SuppressWarnings("static-access") public final EntityWithByteBufferType_Select.E_TM Gt_And_Lt(Long tokenValue1, Long tokenValue2) { where.and(QueryBuilder.gt("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 EntityWithByteBufferType_Select.E_TM(where, cassandraOptions); }
@Override protected ResultSet queryRowGroupRowsAfter(Row row) { Statement statement = selectDeltaFrom(_placement.getBlockedDeltaTableDDL()) .where(eq(_placement.getBlockedDeltaTableDDL().getRowKeyColumnName(), getKey(row))) .and(gt(ImmutableList.of(_placement.getBlockedDeltaTableDDL().getChangeIdColumnName(), _placement.getBlockedDeltaTableDDL().getBlockColumnName()), ImmutableList.of(getChangeId(row), getBlock(row)))) .orderBy(asc(_placement.getBlockedDeltaTableDDL().getChangeIdColumnName())) .setConsistencyLevel(_consistency); return AdaptiveResultSet.executeAdaptiveQuery(_placement.getKeyspace().getCqlSession(), statement, _driverConfig.getSingleRowFetchSize()); } }