Package com.datastax.driver.core.querybuilder.Select

Examples of com.datastax.driver.core.querybuilder.Select.Where

82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
    }
    return selectWhere;
  }

    public static Where createRowQueryFromValues(List<byte[]> values, DboColumnMeta colMeta, Select selectQuery, String rowKey) {
        Where selectWhere = selectQuery.where();

        Clause rkClause = QueryBuilder.eq("id", rowKey);
        selectWhere.and(rkClause);

        Object[] valStrings = new Object[values.size()];
        int count = 0;
        for (byte[] value : values) {
            valStrings[count] = StandardConverters.convertFromBytes(String.class, value);
            count++;
        }
       
        Clause inClause = QueryBuilder.in("colname", valStrings);
        selectWhere.and(inClause);
        return selectWhere;
    }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
    @Test
         public void should_build_from_clustering_keys_ascending_inclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.ASC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        INCLUSIVE_BOUNDS.buildFromClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)>=(:col1,:col2);");
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
    @Test
    public void should_build_from_clustering_keys_ascending_exclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.ASC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        EXCLUSIVE_BOUNDS.buildFromClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)>(:col1,:col2);");
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
    @Test
    public void should_build_from_clustering_keys_descending_inclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.DESC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        INCLUSIVE_BOUNDS.buildFromClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)<=(:col1,:col2);");
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
    @Test
    public void should_build_from_clustering_keys_descending_exclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.DESC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        EXCLUSIVE_BOUNDS.buildFromClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)<(:col1,:col2);");
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
    @Test
    public void should_build_to_clustering_keys_ascending_inclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.ASC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        INCLUSIVE_BOUNDS.buildToClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)<=(:col1,:col2);");
    }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
    @Test
    public void should_build_to_clustering_keys_ascending_exclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.ASC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        EXCLUSIVE_BOUNDS.buildToClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)<(:col1,:col2);");
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
    @Test
    public void should_build_to_clustering_keys_descending_inclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.DESC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        INCLUSIVE_BOUNDS.buildToClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)>=(:col1,:col2);");
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
    @Test
    public void should_build_to_clustering_keys_descending_exclusive() throws Exception {
        //Given
        ClusteringOrder clusteringOrder = new ClusteringOrder("col1", Sorting.DESC);
        final Where where = QueryBuilder.select().from("table").where();

        //When
        EXCLUSIVE_BOUNDS.buildToClusteringKeys(where, clusteringOrder, clusteringKeyNames);

        //Then
        assertThat(where.toString()).isEqualToIgnoringCase("SELECT * FROM table WHERE (col1,col2)>(:col1,:col2);");
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        final ImmutableMap<RetentionPolicy, ElementType> retentionPolicies = ImmutableMap.of(SOURCE, ANNOTATION_TYPE, RUNTIME, CONSTRUCTOR);

        manager.insert(new EntityWithEnumeratedConfig(id, ConsistencyLevel.LOCAL_ONE, elementTypes, retentionPolicies));

        //When
        final Where statement = select().from(TABLE_NAME).where(eq("id", bindMarker("id")));

        final TypedMap found = manager.nativeQuery(statement, id).first();

        //Then
        assertThat(found.getTyped("id")).isEqualTo(id);
View Full Code Here
TOP

Related Classes of com.datastax.driver.core.querybuilder.Select.Where

  • com.alvazan.orm.layer9z.spi.db.cassandracql3.Cql3Util
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.CqlSession
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.CursorOfIndexes
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.StartQueryManyKeys
  • com.netflix.astyanax.cql.reads.CFRowRangeQueryGen
  • com.netflix.astyanax.cql.reads.FlatTableRowSliceQueryGen
  • info.archinnov.achilles.query.slice.BoundingModeTest
  • info.archinnov.achilles.test.integration.tests.EnumeratedSupportIT
  • org.kiji.schema.impl.cassandra.CQLUtils
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.