Examples of com.datastax.driver.core.RegularStatement

com.datastax.driver.core.RegularStatement
A regular (non-prepared and non batched) CQL statement.
This class represents a query string along with query options (and optionally binary values, see {@code getValues}). It can be extended but {@link SimpleStatement}is provided as a simple implementation to build a {@code RegularStatement} directlyfrom its query string.

        for (PropertyMeta counterMeta : meta.getAllCounterMetas()) {
            final String propertyName = counterMeta.getPropertyName();
            final String cql3ColumnName = counterMeta.getCQL3ColumnName();
            final boolean staticColumn = counterMeta.structure().isStaticColumn();


            RegularStatement incrementStatement = prepareWhereClauseForCounterUpdate(statementGenerator, update(keyspaceName,tableName).with(incr(cql3ColumnName, bindMarker(cql3ColumnName))), staticColumn, noOptions());
            RegularStatement decrementStatement = prepareWhereClauseForCounterUpdate(statementGenerator, update(keyspaceName,tableName).with(decr(cql3ColumnName, bindMarker(cql3ColumnName))), staticColumn, noOptions());


            RegularStatement selectStatement = statementGenerator.generateWhereClauseForSelect(Optional.fromNullable(counterMeta), select(cql3ColumnName).from(keyspaceName,tableName));


            incrStatementPerCounter.put(propertyName, session.prepare(incrementStatement));
            decrStatementPerCounter.put(propertyName, session.prepare(decrementStatement));
            selectStatementPerCounter.put(propertyName, session.prepare(selectStatement));
        }
        clusteredCounterPSMap.put(INCR, incrStatementPerCounter);
        clusteredCounterPSMap.put(DECR, decrStatementPerCounter);


        RegularStatement selectStatement = statementGenerator.generateWhereClauseForSelect(Optional.<PropertyMeta>absent(), select().from(keyspaceName,tableName));
        selectStatementPerCounter.put(SELECT_ALL.name(), session.prepare(selectStatement));
        clusteredCounterPSMap.put(SELECT, selectStatementPerCounter);


        RegularStatement deleteStatement = statementGenerator.generateWhereClauseForDelete(false, delete().from(keyspaceName,tableName));
        clusteredCounterPSMap.put(DELETE, of(DELETE_ALL.name(), session.prepare(deleteStatement)));


        return clusteredCounterPSMap;
    }

View Full Code Here

        final EntityMetaConfig metaConfig = entityMeta.config();


        Map<String, PreparedStatement> deletePSs = new HashMap<>();


        Delete mainFrom = delete().from(metaConfig.getKeyspaceName(), metaConfig.getTableName());
        RegularStatement mainStatement = idMeta.forStatementGeneration().generateWhereClauseForDelete(entityMeta.structure().hasOnlyStaticColumns(), mainFrom);
        deletePSs.put(metaConfig.getQualifiedTableName(), session.prepare(mainStatement.getQueryString()));


        return deletePSs;
    }

View Full Code Here

            case REMOVE_FROM_MAP:
                assignments = changeSet.generateUpdateForRemovedKey(conditions);
                break;
        }


        final RegularStatement regularStatement = prepareWhereClauseWithTTLForUpdate(meta.getIdMeta(), assignments,changeSet.getPropertyMeta().structure().isStaticColumn(), options);
        final PreparedStatement preparedStatement = session.prepare(regularStatement);
        return preparedStatement;
    }

View Full Code Here

            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

                .addPreference(2, "NewYork").version(CounterBuilder.incr(17L)).buid();


        manager.insert(entity1);
        manager.insert(entity2);


        RegularStatement statement = select("name", "age_in_years", "friends", "followers", "preferences")
                .from("CompleteBean").where(in("id", entity1.getId(), entity2.getId()));


        List<TypedMap> actual = manager.nativeQuery(statement).get();


        assertThat(actual).hasSize(2);

View Full Code Here

    @Test
    public void should_return_rows_for_native_query_with_bound_values() throws Exception {
        CompleteBean entity = builder().randomId().name("DuyHai").buid();
        manager.insert(entity);


        RegularStatement statement = select("name").from("CompleteBean").where(eq("id", bindMarker()));


        List<TypedMap> actual = manager.nativeQuery(statement, entity.getId()).get();


        assertThat(actual).hasSize(1);

View Full Code Here

    public void should_return_count_for_native_query() throws Exception {
        CompleteBean entity = builder().randomId().name("DuyHai").buid();


        manager.insert(entity);


        RegularStatement statement = select().countAll().from("CompleteBean").where(eq("id", entity.getId()));


        Long count = (Long) manager.nativeQuery(statement).first().get("count");


        assertThat(count).isEqualTo(1L);
    }

View Full Code Here


        Long timestamp = (System.currentTimeMillis() + 1234500) * 1000;


        manager.insert(entity, OptionsBuilder.withTtl(1000).withTimestamp(timestamp));


        RegularStatement statement = select().fcall("ttl", column("name")).fcall("writetime",column("age_in_years"))
                .from("CompleteBean").where(eq("id",entity.getId()));


        Map<String, Object> result = manager.nativeQuery(statement).first();


        assertThat((Integer) result.get("ttl(name)")).isLessThanOrEqualTo(1000);

View Full Code Here

        Long id = RandomUtils.nextLong(0, Long.MAX_VALUE);
        UUID date = UUIDGen.getTimeUUID();


        manager.insert(new ClusteredEntityWithTimeUUID(id, date, "value"));


        RegularStatement statement = select()
                .fcall("now")
                .fcall("dateOf", column("date"))
                .fcall("unixTimestampOf", column("date"))
                .from(ClusteredEntityWithTimeUUID.TABLE_NAME)
                .where(eq("id", id));

View Full Code Here

        manager.insert(entity4);
        manager.insert(entity5);


        List<String> possibleNames = Arrays.asList("DuyHai", "Paul", "George", "John", "Helen");


        RegularStatement statement = select().all().from("CompleteBean").limit(6);
        statement.setFetchSize(2);


        final Iterator<TypedMap> iterator = manager.nativeQuery(statement).iterator();


        assertThat(iterator.hasNext()).isTrue();
        assertThat(iterator.next().getTyped("name")).isIn(possibleNames);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.