本文整理了Java中com.datastax.driver.core.querybuilder.QueryBuilder.lte
方法的一些代码示例,展示了QueryBuilder.lte
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryBuilder.lte
方法的具体详情如下:
包路径:com.datastax.driver.core.querybuilder.QueryBuilder
类名称:QueryBuilder
方法名:lte
[英]Creates a "lesser than or equal" WHERE clause for a group of clustering columns.
For instance, lte(Arrays.asList("a", "b"), Arrays.asList(2, "test")) will generate the CQL WHERE clause (a, b) <e; (2, 'test') .
Please note that this variant is only supported starting with Cassandra 2.0.6.
[中]为一组群集列创建“小于或等于”WHERE子句。
例如,lte(Arrays.asList(“a”、“b”)、阵列。asList(2,“测试”)将生成CQL WHERE条款(a,b)<e;(2,“测试”)。
请注意,仅从Cassandra 2.0.6开始支持此变体。
代码示例来源:origin: hugegraph/hugegraph
return QueryBuilder.lt(key, value);
case LTE:
return QueryBuilder.lte(key, value);
case IN:
List<?> values = (List<?>) value;
代码示例来源:origin: com.datastax.cassandra/cassandra-driver-core
.from("foo")
.where(eq("k", 4))
.and(lte(Arrays.asList("c1", "c2"), Arrays.<Object>asList("a", 2)));
assertEquals(select.toString(), query);
代码示例来源:origin: com.datastax.cassandra/cassandra-driver-core
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);
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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;
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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);
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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);
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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);
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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);
}
代码示例来源:origin: info.archinnov/integration-test-2_1
/**
* 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);
}
代码示例来源:origin: org.apache.james/apache-james-mailbox-cassandra
private Select.Where getStoredAnnotationsQueryLikeKey(CassandraId mailboxId, String key) {
return getStoredAnnotationsQuery(mailboxId)
.and(gte(CassandraAnnotationTable.KEY, key))
.and(lte(CassandraAnnotationTable.KEY, buildNextKey(key)));
}
代码示例来源:origin: org.apache.james/apache-james-mailbox-cassandra
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))));
}
内容来源于网络,如有侵权,请联系作者删除!