Package com.datastax.driver.core.querybuilder

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

50
51
52
53
54
55
56
57
58
59
    }

    protected Select prepareCount(Class<?> bean, ConsistencyLevel consistency) {
        ClassInformation classInformation = ClassInformations.INSTACE.getClass(bean);
        KeySpaceInformation key = classInformation.getKeySpace(keySpace);
        Select select = QueryBuilder.select().countAll()
                .from(key.getKeySpace(), key.getColumnFamily());
        select.setConsistencyLevel(consistency);
        return select;
    }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
        super(keySpace);
    }

    public void countAsync(Class<?> bean, Session session,
            ConsistencyLevel consistency, ResultAsyncCallBack<Long> resultCallBack) {
        Select select = prepareCount(bean, consistency);
        ResultSetFuture resultSet = session.executeAsync(select);
        AsyncResult.INSTANCE.runCount(resultCallBack, resultSet);

    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
     * @return - if get it or not
     */
    public boolean verifyColumnFamily(Session session, String keySpace, String familyColumn,
            Class<?> class1) {
        try {
            Select select = QueryBuilder.select().from(keySpace, familyColumn).limit(1);
            ResultSet resultSet = session.execute(select);
            verifyRowType(resultSet, class1, session);
            findIndex(class1, session);
            return true;
        } catch (InvalidQueryException exception) {
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        if (needToGetBatch) {
            if (batchListener != null)
                batchListener.beforeFetchingNextBatch();

            String rowKeyString = StandardConverters.convertFromBytes(String.class, rowKey);
            Select selectQuery = QueryBuilder.select().all().from(keySpace, indTable).allowFiltering();
            Where whereClause = Cql3Util.createRowQuery(from, to, columnMeta, selectQuery, rowKeyString);
            Query query = null;

            if (batchSize != null)
                query = whereClause.limit(batchSize);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
        List<Future<ResultSet>> futures = new ArrayList<Future<ResultSet>>();

        String rowKeyString = StandardConverters.convertFromBytes(String.class, rowKey);

        for (byte[] val : values) {
            Select selectQuery = QueryBuilder.select().all().from(keySpace, indTable).allowFiltering();
            Where selectWhere = selectQuery.where();
            Clause rkClause = QueryBuilder.eq("id", rowKeyString);
            selectWhere.and(rkClause);

            Object value = null;
            value = columnMeta.getStorageType().convertFromNoSql(val);
View Full Code Here
226
227
228
229
230
231
232
233
234
235
236
237
238
            session.execute(query);
        }
    }

    public boolean findIndexRow(String table, String rowKey, byte[] key) {
        Select selectQuery = QueryBuilder.select().all().from(keys, table).allowFiltering();
        //Where whereClause = Cql3Util.createRowQuery(from, to, columnMeta, selectQuery, rowKeyString);
        Where selectWhere = selectQuery.where();
        Clause rkClause = QueryBuilder.eq("id", rowKey);
        selectWhere.and(rkClause);
        Clause keyClause = QueryBuilder.lte("colvalue", ByteBuffer.wrap(key));
        selectWhere.and(keyClause);
        Query query = selectWhere.limit(1);
View Full Code Here
52
53
54
55
56
57
58
59
60
    return String
        .format("select * from %s where title in (%s)", TABLE, StringUtils.arrayToCommaDelimitedString(quoted));
  }

  public static Select select(String isbn) {
    Select select = QueryBuilder.select("isbn", "title").from(TABLE);
    select.where(QueryBuilder.eq("isbn", isbn));
    return select;
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
    b1.setCheckOuts(checkOutMap);

    template.insert(b1);

    Select select = QueryBuilder.select().all().from("bookHistory");
    select.where(QueryBuilder.eq("isbn", "123456-1"));

    BookHistory b = template.selectOne(select, BookHistory.class);

    Assert.assertNotNull(b.getCheckOuts());
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
    marks.add(144);
    b1.setBookmarks(marks);

    template.insert(b1);

    Select select = QueryBuilder.select().all().from("bookReference");
    select.where(QueryBuilder.eq("isbn", "123456-1"));

    BookReference b = template.selectOne(select, BookReference.class);

    Assert.assertNotNull(b.getReferences());
    Assert.assertNotNull(b.getBookmarks());
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
        List<CassandraColumnHandle> partitionKeyColumns = table.getPartitionKeyColumns();

        boolean fullPartitionKey = filterPrefix.size() == partitionKeyColumns.size();
        ResultSetFuture countFuture;
        if (!fullPartitionKey) {
            Select countAll = CassandraCqlUtils.selectCountAllFrom(tableHandle).limit(limitForPartitionKeySelect);
            countFuture = session.executeAsync(countAll);
        }
        else {
            // no need to count if partition key is completely known
            countFuture = null;
        }

        int limit = fullPartitionKey ? 1 : limitForPartitionKeySelect;
        Select partitionKeys = CassandraCqlUtils.selectDistinctFrom(tableHandle, partitionKeyColumns);
        partitionKeys.limit(limit);
        partitionKeys.setFetchSize(fetchSizeForPartitionKeySelect);
        addWhereClause(partitionKeys.where(), partitionKeyColumns, filterPrefix);
        ResultSetFuture partitionKeyFuture = session.executeAsync(partitionKeys);

        if (!fullPartitionKey) {
            long count = countFuture.getUninterruptibly().one().getLong(0);
            if (count == limitForPartitionKeySelect) {
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.