Package com.datastax.driver.core.querybuilder

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

138
139
140
141
142
143
144
145
146
147
148
            }

            if (list != null)
                list.beforeFetchingNextBatch();
            try {
                Clause inClause = QueryBuilder.in("id", keyStrings);
                //change the batchsize
                Query query = QueryBuilder.select().all().from(keys, cf.getColumnFamily()).where(inClause).limit(100);
                resultSet = session.execute(query);
            } catch (Exception e) {
                System.out.println(" Exception:" + e.getMessage());
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
            if (list != null)
                list.beforeFetchingNextBatch();
            try {
                // CHANGE THE BATCHSIZE
                Clause inClause = QueryBuilder.in("id", keyStrings);
                Query query = QueryBuilder.select().all().from(keys, cf.getColumnFamily()).where(inClause).limit(100);
                resultSet = session.execute(query);
            } catch (Exception e) {
                System.out.println(" Exception:" + e.getMessage());
            }
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
    return c;
  }

  public static Where createRowQuery(Key from, Key to, DboColumnMeta colMeta, Select selectQuery, String rowKey, String indTable) {
        Where selectWhere = selectQuery.where();
        Clause rkClause = QueryBuilder.eq("id", rowKey);
        selectWhere.and(rkClause);

        Object valFrom = null, valTo = null;
    if (colMeta != null) {
      if (from != null) {
        valFrom = colMeta.getStorageType().convertFromNoSql(from.getKey());
                valFrom = checkForBooleanAndNull(valFrom, indTable, colMeta);
      }
      if (to != null) {
        valTo = colMeta.getStorageType().convertFromNoSql(to.getKey());
                valTo = checkForBooleanAndNull(valTo, indTable, colMeta);
      }
    } else
      return selectWhere;

        if (from != null) {
            if (from.isInclusive()) {
                Clause gteClause = QueryBuilder.gte("colname", valFrom);
                selectWhere.and(gteClause);
            } else {
                Clause gtClause = QueryBuilder.gt("colname", valFrom);
                selectWhere.and(gtClause);
            }

        }
        if (to != null) {
            if (to.isInclusive()) {
                Clause lteClause = QueryBuilder.lte("colname", valTo);
                selectWhere.and(lteClause);
            }
            else {
                Clause ltClause = QueryBuilder.lt("colname", valTo);
                selectWhere.and(ltClause);
            }
    }
    return selectWhere;
  }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
  }

    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
123
124
125
126
127
128
129
130
131
132
133
        if (batchListener != null)
            batchListener.beforeFetchingNextBatch();

        columnNameType = sliceInfo.getColumnNameType();
        ResultSet resultSet = null;
        Clause rkClause = QueryBuilder.eq("id", ByteBuffer.wrap(rowKey));
        Query query = null;
        query = QueryBuilder.select().all().from(keys, table).where(rkClause).disableTracing();

        subList = new ArrayList<com.datastax.driver.core.Row>();
        try {
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
        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);
            value = Cql3Util.checkForBooleanAndNull(value, indTable, columnMeta);

            Clause valClause = QueryBuilder.eq("colname", value);
            selectWhere.and(valClause);

            Query query = selectWhere.disableTracing();

            Future future = session.executeAsync(query);
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
        }

    }

    private void checkIfRowExsits(String table, byte[] rowKey, String colName) {
        Clause rkClause = QueryBuilder.eq("id", ByteBuffer.wrap(rowKey));
        Clause cnClause = QueryBuilder.eq("colname", colName);
        try {
            Query query = QueryBuilder.select().all().from(keys, table).where(rkClause).and(cnClause);
            ResultSet resultSet = session.execute(query);
            if (resultSet.isExhausted())
                return;
View Full Code Here
176
177
178
179
180
181
182
183
184
185
186
        String table = lookupOrCreate(colFamily, ormSession);
        if (action.getAction() == null)
            throw new IllegalArgumentException("action param is missing ActionEnum so we know to remove entire row or just columns in the row");
        switch (action.getAction()) {
        case REMOVE_ENTIRE_ROW:
            Clause eqClause = QueryBuilder.eq("id", ByteBuffer.wrap(action.getRowKey()));
            Query query = QueryBuilder.delete().from(keys, table).where(eqClause);
            session.execute(query);
            break;
        case REMOVE_COLUMNS_FROM_ROW:
            removeColumns(action, table);
View Full Code Here
209
210
211
212
213
214
215
216
217
218
            removeColumnImpl(action.getRowKey(), table, colName);
        }
    }

    private void removeColumnImpl(byte[] rowKey, String table, String colName) {
        Clause eqClause = QueryBuilder.eq("id",ByteBuffer.wrap(rowKey));
        Clause eqColClause = QueryBuilder.eq("colname", colName);
        Query query = QueryBuilder.delete().from(keys, table).where(eqClause).and(eqColClause);
        session.execute(query);
    }
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
        boolean exists = findIndexRow(table, rowKey, fk, indValue);
        if (!exists) {
            if (log.isInfoEnabled())
                log.info("Index: " + column.toString() + " already removed.");
        } else {
            Clause eqClause = QueryBuilder.eq("id", rowKey);
            Clause indClause = null;
            if (indValue != null) {
                indClause = QueryBuilder.eq("colname", indValue);
            } else {
                if (table.equalsIgnoreCase("IntegerIndice")) {
                    indClause = QueryBuilder.eq("colname", ByteBuffer.wrap(new byte[0]));
                } else {
                    indClause = QueryBuilder.eq("colname", "");
                }
            }
            Clause fkClause = QueryBuilder.eq("colvalue", ByteBuffer.wrap(fk));
            Query query = QueryBuilder.delete().from(keys, table).where(eqClause).and(indClause).and(fkClause);
            session.execute(query);
        }
    }
View Full Code Here
TOP

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

  • com.alvazan.orm.layer9z.spi.db.cassandracql3.Cql3Util
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.CqlSession
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.CursorColumnSliceCql
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.CursorKeysToRowsCql3
  • com.alvazan.orm.layer9z.spi.db.cassandracql3.StartQueryManyKeys
  • com.facebook.presto.cassandra.CassandraSession
  • org.springframework.data.cassandra.repository.query.CassandraQueryCreator
    • 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.