com.datastax.driver.core.querybuilder.QueryBuilder.lte()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(10.6k)|赞(0)|评价(0)|浏览(118)

本文整理了Java中com.datastax.driver.core.querybuilder.QueryBuilder.lte方法的一些代码示例,展示了QueryBuilder.lte的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryBuilder.lte方法的具体详情如下:
包路径:com.datastax.driver.core.querybuilder.QueryBuilder
类名称:QueryBuilder
方法名:lte

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))));
}

相关文章

微信公众号

最新文章

更多