Examples of com.datastax.driver.core.PreparedStatement

com.datastax.driver.core.PreparedStatement
Represents a prepared statement, a query with bound variables that has been prepared (pre-parsed) by the database.
A prepared statement can be executed once concrete values have been provided for the bound variables. A prepared statement and the values for its bound variables constitute a BoundStatement and can be executed (by {@link Session#execute}).
A {@code PreparedStatement} object allows you to define specific defaultsfor the different properties of a {@link Statement} (Consistency level, tracing, ...),in which case those properties will be inherited as default by every BoundedStatement created from the {PreparedStatement}. The default for those {@code PreparedStatement} properties is the same that in {@link Statement} if thePreparedStatement is created by {@link Session#prepare(String)} but will inheritof the properties of the {@link RegularStatement} used for the preparation if{@link Session#prepare(RegularStatement)} is used.

                .thenReturn(select().from("table"));
        when(statementGenerator.generateWhereClauseForDelete(false, delete().from("table")))
                .thenReturn(delete().from("table"));




        PreparedStatement incrPs = mock(PreparedStatement.class);
        PreparedStatement decrPs = mock(PreparedStatement.class);
        PreparedStatement selectPs = mock(PreparedStatement.class);
        PreparedStatement selectAllPs = mock(PreparedStatement.class);
        PreparedStatement deletePs = mock(PreparedStatement.class);


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(incrPs, decrPs, selectPs, selectAllPs, deletePs);


        Map<CQLQueryType, Map<String, PreparedStatement>> actual = generator.prepareClusteredCounterQueryMap(session,meta);

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet,
                ifConditions(new CASCondition("name", "John")).withTimestamp(100L));


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl AND TIMESTAMP :timestamp;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, true)).thenReturn(update("ks","table").where());


        when(session.prepare(regularStatementCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareCollectionAndMapUpdate(session, meta, changeSet, noOptions());


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(regularStatementCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table USING TTL :ttl;");
        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table;");

View Full Code Here

        when(meta.config().getQualifiedTableName()).thenReturn("table");
        when(sliceQueryProperties.generateWhereClauseForSelect(selectCaptor.capture())).thenReturn(select);
        when(session.prepare(queryCaptor.capture())).thenReturn(ps);


        //When
        final PreparedStatement actual = generator.prepareSelectSliceQuery(session, sliceQueryProperties);


        //Then
        assertThat(actual).isSameAs(ps);
        assertThat(selectCaptor.getValue().getQueryString()).isEqualTo("SELECT name FROM ks.table;");
        assertThat(queryCaptor.getValue()).isEqualTo("SELECT * FROM test WHERE id=10 LIMIT 1;");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.datastax.driver.core.PreparedStatement

ch.uzh.ifi.ddis.ifp.esper.cassandra.CassandraVirtualDataWindow

com.alvazan.orm.layer9z.spi.db.cassandracql3.CqlSession

com.datastax.driver.core.exceptions.DriverInternalError

com.netflix.astyanax.cql.direct.DirectCqlStatement

com.netflix.astyanax.cql.reads.QueryGenCache

com.netflix.astyanax.cql.writes.BatchedStatements

com.netflix.astyanax.cql.writes.CFMutationQueryGen$MutationQueryCache

com.netflix.astyanax.cql.writes.StatementCache

info.archinnov.achilles.internal.context.DaoContext

info.archinnov.achilles.internal.statement.cache.CacheManager

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.