Package com.datastax.driver.core

Examples of com.datastax.driver.core.RegularStatement

69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
        final List<Object> clusteringKeys = Arrays.<Object>asList(20140830, PropertyType.COUNTER);

        final Select select = select().from("table");

        //When
        final RegularStatement statement = SliceQueryProperties.builder(meta, ClusteredEntity.class, SliceType.SELECT)
                .partitionKeysName(asList("id", "bucket")).partitionKeys(partitionKeys)
                .fromClusteringKeysName(asList("date")).fromClusteringKeys(clusteringKeys)
                .toClusteringKeysName(asList("date", "type")).toClusteringKeys(clusteringKeys)
                .bounding(BoundingMode.EXCLUSIVE_BOUNDS)
                .limit(12)
                .generateWhereClauseForSelect(select);

        //Then
        assertThat(statement.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id AND bucket=:bucket AND (date)<(:date) AND (date,type)>(:date,:type) LIMIT :limitSize;");
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
        final List<Object> clusteringKeys = Arrays.<Object>asList(20140830, PropertyType.COUNTER);

        final Select select = select().from("table");

        //When
        final RegularStatement statement = SliceQueryProperties.builder(meta, ClusteredEntity.class, SliceType.SELECT)
                .partitionKeysName(asList("id", "bucket")).partitionKeys(partitionKeys)
                .fromClusteringKeysName(asList("date")).fromClusteringKeys(clusteringKeys)
                .toClusteringKeysName(asList("date", "type")).toClusteringKeys(clusteringKeys)
                .bounding(BoundingMode.INCLUSIVE_BOUNDS)
                .ordering(null)
                .limit(12)
                .generateWhereClauseForSelect(select);

        //Then
        assertThat(statement.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id AND bucket=:bucket AND (date)<=(:date) AND (date,type)>=(:date,:type) LIMIT :limitSize;");
    }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
        final List<Object> clusteringKeys = Arrays.<Object>asList(20140830, PropertyType.COUNTER);

        final Delete delete = delete().from("table");

        //When
        final RegularStatement statement = SliceQueryProperties.builder(meta, ClusteredEntity.class, SliceType.SELECT)
                .partitionKeysName(asList("id", "bucket")).lastPartitionKeyName("year")
                .partitionKeys(partitionKeys).andPartitionKeysIn(partitionKeysIN)
                .withClusteringKeysName(asList("date", "type"))
                .withClusteringKeys(clusteringKeys)
                .generateWhereClauseForDelete(delete);

        //Then
        assertThat(statement.getQueryString()).isEqualTo("DELETE FROM table WHERE id=:id AND bucket=:bucket AND year IN :partitionComponentsIn AND date=:date AND type=:type;");
    }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
        final SelectFromPartition<String> start = builder
                .withPartitionComponents("a");

        start.limit(3).get(10);

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", 10);
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        final SelectFromPartition<String> start = builder
                .withPartitionComponents("a");

        start.limit(3).async().get(10);

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", 10);
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
        final SelectWithPartition<String> start = builder
                .withPartitionComponentsIN("a", "b");

        start.limit(2).fromClusterings("A","B").limit(3).orderByAscending().get(10);

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE bucket IN :partitionComponentsIn AND (col1,col2)>=(:col1,:col2) ORDER BY col1 ASC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence(asList("a","b"), "A","B",10);
    }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
        final SelectFromPartition<String> start = builder
                .withPartitionComponents("a");

        start.limit(3).orderByDescending().getOne();

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id ORDER BY col1 DESC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", 1);
    }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
        final SelectFromPartition<String> start = builder
                .withPartitionComponents("a");

        start.limit(3).async().getOne();

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", 1);
    }
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
            .withConsistency(QUORUM)
            .fromClusterings("A", "B")
            .toClusterings("C", "D")
            .get(10);

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id AND bucket IN :partitionComponentsIn AND (col1,col2)>=(:col1,:col2) AND (col1,col2)<=(:col1,:col2) LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", asList("b", "c"), "A", "B", "C", "D", 10);
    }
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
        start.limit(3)
                .withClusterings("A", "B")
                .andClusteringsIN("C", "D")
                .getOne();

        final RegularStatement whereClause = start.properties.generateWhereClauseForSelect(select);

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id AND col1=:col1 AND col2=:col2 AND col3 IN :clusteringKeysIn LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", asList("C", "D"), 1);
    }
View Full Code Here
TOP

Related Classes of com.datastax.driver.core.RegularStatement

  • com.datastax.driver.core.querybuilder.Batch
  • com.netflix.astyanax.cql.reads.QueryGenCache
  • info.archinnov.achilles.internal.context.BatchingFlushContextTest
  • info.archinnov.achilles.internal.context.DaoContextTest
  • info.archinnov.achilles.internal.context.ImmediateFlushContextTest
  • info.archinnov.achilles.internal.metadata.holder.PropertyMetaStatementGeneratorTest
  • info.archinnov.achilles.internal.persistence.operations.TypedQueryValidatorTest
  • info.archinnov.achilles.internal.statement.prepared.PreparedStatementGenerator
  • info.archinnov.achilles.internal.statement.wrapper.NativeStatementWrapperTest
  • info.archinnov.achilles.internal.statement.wrapper.RegularStatementWrapperTest
    • 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.