Package com.datastax.driver.core.querybuilder

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

43
44
45
46
47
48
49
50
51
52
53
        final List<Object> partitionKeysIN = Arrays.<Object>asList(2013, 2014);

        final List<Object> clusteringKeys = Arrays.<Object>asList(20140830);
        final List<Object> clusteringKeysIN = Arrays.<Object>asList(PropertyType.LIST, PropertyType.SET);

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

        //When
        final RegularStatement statement = SliceQueryProperties.builder(meta, ClusteredEntity.class, SliceType.SELECT)
                .partitionKeysName(asList("id", "bucket")).lastPartitionKeyName("year")
                .partitionKeys(partitionKeys).andPartitionKeysIn(partitionKeysIN)
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        //Given
        final List<Object> partitionKeys = Arrays.<Object>asList(10L, 1);

        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)
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        //Given
        final List<Object> partitionKeys = Arrays.<Object>asList(10L, 1);

        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)
View Full Code Here
99
100
101
102
103
104
105
106
107
108
        if (pm.structure().isCounter()) {
            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
147
148
149
150
151
152
153
154
155
156
157
        Selection select = select();

        for (PropertyMeta pm : entityMeta.forOperations().getColumnsMetaToLoad()) {
            select = pm.forStatementGeneration().prepareSelectField(select);
        }
        Select from = select.from(metaConfig.getKeyspaceName(), metaConfig.getTableName());

        Optional<PropertyMeta> staticMeta = Optional.absent();
        if (entityMeta.structure().hasOnlyStaticColumns()) {
            staticMeta = Optional.fromNullable(entityMeta.getAllMetasExceptId().get(0));
        }
View Full Code Here
331
332
333
334
335
336
337
338
339
340
341
        for (PropertyMeta pm : entityMeta.forOperations().getColumnsMetaToLoad()) {
            select = pm.forStatementGeneration().prepareSelectField(select);
        }

        Select from = select.from(metaConfig.getKeyspaceName(), metaConfig.getTableName());

        final RegularStatement whereClause = sliceQueryProperties.generateWhereClauseForSelect(from);

        return session.prepare(whereClause.getQueryString());
    }
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
        }

        // ORDER BY
        if (orderingModeO.isPresent()) {

            final Select statement;
            final OrderingMode orderingMode = orderingModeO.get();
            if (orderingMode.isReverse()) {
                statement = where.orderBy(desc(clusteringOrder.getClusteringColumnName()));
            } else {
                statement = where.orderBy(asc(clusteringOrder.getClusteringColumnName()));
            }
            // LIMIT
            if (limitO.isPresent()) {
                statement.limit(bindMarker("limitSize"));
            }

            return statement;
        } else {
            // LIMIT
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    public void should_prepare_where_clause_for_select_with_embedded_id() throws Exception {
        //Given
        Optional<PropertyMeta> pmO = Optional.absent();
        when(meta.structure().isEmbeddedId()).thenReturn(true);
        when(embeddedIdProperties.getCQL3ComponentNames()).thenReturn(asList("id", "name"));
        Select select = QueryBuilder.select().from("table");

        //When
        final RegularStatement actual = view.generateWhereClauseForSelect(pmO, select);

        //Then
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
        Optional<PropertyMeta> pmO = Optional.fromNullable(staticMeta);

        when(meta.structure().isEmbeddedId()).thenReturn(true);
        when(embeddedIdProperties.getPartitionComponents().getCQL3ComponentNames()).thenReturn(asList("id"));
        Select select = QueryBuilder.select().from("table");

        //When
        final RegularStatement actual = view.generateWhereClauseForSelect(pmO, select);

        //Then
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
    public void should_prepare_where_clause_for_select_with_simple_id() throws Exception {
        //Given
        Optional<PropertyMeta> pmO = Optional.absent();
        when(meta.structure().isEmbeddedId()).thenReturn(false);
        when(meta.getCQL3ColumnName()).thenReturn("id");
        Select select = QueryBuilder.select().from("table");

        //When
        final RegularStatement actual = view.generateWhereClauseForSelect(pmO, select);

        //Then
View Full Code Here
TOP

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

  • 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.datastax.driver.mapping.QueryType
  • com.facebook.presto.cassandra.CassandraSession
  • info.archinnov.achilles.internal.metadata.holder.PropertyMetaStatementGeneratorTest
  • info.archinnov.achilles.internal.statement.prepared.PreparedStatementGenerator
  • info.archinnov.achilles.internal.statement.prepared.PreparedStatementGeneratorTest
  • info.archinnov.achilles.query.slice.SliceQueryProperties
  • info.archinnov.achilles.query.slice.SliceQueryPropertiesTest
    • 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.