Package com.datastax.driver.core

Examples of com.datastax.driver.core.RegularStatement

223
224
225
226
227
228
229
230
231
232
233
                .withClusterings("A", "B")
                .andClusteringsIN("C", "D")
                .async()
                .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
242
243
244
245
246
247
248
249
250
251
252
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).fromClusterings("A", "B").fromExclusiveToInclusiveBounds().orderByDescending().getOne();

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

        //Then
        assertThat(whereClause.getQueryString()).isEqualTo("SELECT * FROM table WHERE id=:id AND (col1,col2)>(:col1,:col2) ORDER BY col1 DESC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", 1);
    }
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).getMatching("A", "B", "C");

        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=:col3 LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", "C", 3);
    }
View Full Code Here
280
281
282
283
284
285
286
287
288
289
290
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).async().getMatching("A", "B", "C");

        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=:col3 LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", "C", 3);
    }
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).getFirstMatching(5, "A", "B", "C");

        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=:col3 ORDER BY col1 ASC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", "C", 5);
    }
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).async().getFirstMatching(5, "A", "B", "C");

        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=:col3 ORDER BY col1 ASC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", "C", 5);
    }
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
        //When
        final SelectFromPartition<String> start = builder.withPartitionComponents("a");

        start.limit(3).getLastMatching(5, "A", "B", "C");

        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=:col3 ORDER BY col1 DESC LIMIT :limitSize;");
        assertThat(start.properties.getBoundValues()).containsSequence("a", "A", "B", "C", 5);
    }
View Full Code Here
100
101
102
103
104
105
106
107
108
            throw new IllegalArgumentException(String.format("Cannot prepare statement for property '%s' of entity '%s' because it is a counter type",pm.getPropertyName(),entityMeta.getClassName()));
        } else {
            Selection select = pm.forStatementGeneration().prepareSelectField(select());
            final EntityMetaConfig metaConfig = entityMeta.config();
            Select from = select.from(metaConfig.getKeyspaceName(), metaConfig.getTableName());
            RegularStatement statement = idMeta.forStatementGeneration().generateWhereClauseForSelect(Optional.fromNullable(pm), from);
            return session.prepare(statement.getQueryString());
        }
    }
View Full Code Here
133
134
135
136
137
138
139
140
                assignments = pm.forStatementGeneration().prepareUpdateField(updateConditions);
            } else {
                assignments = pm.forStatementGeneration().prepareUpdateField(assignments);
            }
        }
        RegularStatement statement = prepareWhereClauseWithTTLForUpdate(idMeta, assignments, onlyStaticColumns, options);
        return session.prepare(statement.getQueryString());
    }
View Full Code Here
154
155
156
157
158
159
160
161
        Optional<PropertyMeta> staticMeta = Optional.absent();
        if (entityMeta.structure().hasOnlyStaticColumns()) {
            staticMeta = Optional.fromNullable(entityMeta.getAllMetasExceptId().get(0));
        }

        RegularStatement statement = idMeta.forStatementGeneration().generateWhereClauseForSelect(staticMeta, from);
        return session.prepare(statement.getQueryString());
    }
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.