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.


        when(sliceQueryProperties.getEntityClass()).thenReturn(CompleteBean.class);
        when(cache.getIfPresent(cacheKey)).thenReturn(ps);


        //When
        final PreparedStatement actual = manager.getCacheForSliceSelectAndIterator(session, cache, sliceQueryProperties);


        //Then
        assertThat(actual).isSameAs(ps);
    }

View Full Code Here

        when(sliceQueryProperties.getEntityClass()).thenReturn(CompleteBean.class);
        when(cache.getIfPresent(cacheKey)).thenReturn(null);
        when(generator.prepareSelectSliceQuery(session,sliceQueryProperties)).thenReturn(ps);


        //When
        final PreparedStatement actual = manager.getCacheForSliceSelectAndIterator(session, cache, sliceQueryProperties);


        //Then
        assertThat(actual).isSameAs(ps);
        verify(cache).put(cacheKey,ps);
    }

View Full Code Here


        when(sliceQueryProperties.getEntityClass()).thenReturn(CompleteBean.class);
        when(cache.getIfPresent(cacheKey)).thenReturn(ps);


        //When
        final PreparedStatement actual = manager.getCacheForSliceDelete(session, cache, sliceQueryProperties);


        //Then
        assertThat(actual).isSameAs(ps);
    }

View Full Code Here

        when(sliceQueryProperties.getEntityClass()).thenReturn(CompleteBean.class);
        when(cache.getIfPresent(cacheKey)).thenReturn(null);
        when(generator.prepareDeleteSliceQuery(session,sliceQueryProperties)).thenReturn(ps);


        //When
        final PreparedStatement actual = manager.getCacheForSliceDelete(session, cache, sliceQueryProperties);


        //Then
        assertThat(actual).isSameAs(ps);
        verify(cache).put(cacheKey,ps);
    }

View Full Code Here

    public void should_prepare_insert_ps() throws Exception {
        PropertyMeta nameMeta = mock(PropertyMeta.class, RETURNS_DEEP_STUBS);
        when(nameMeta.getCQL3ColumnName()).thenReturn("name");
        when(session.prepare(queryCaptor.capture())).thenReturn(ps);


        PreparedStatement actual = generator.prepareInsert(session, meta, asList(nameMeta), noOptions());


        assertThat(actual).isSameAs(ps);
        verify(idMeta.forStatementGeneration()).generateInsertPrimaryKey(isA(Insert.class));
        assertThat(queryCaptor.getValue()).isEqualTo("INSERT INTO ks.table(name) VALUES (:name) USING TTL :ttl;");
    }

View Full Code Here

        when(idMeta.forStatementGeneration().generateWhereClauseForSelect(Mockito.eq(fromNullable(nameMeta)), isA(Select.class)))
                .thenReturn(select("name").from("ks","table").where(eq("id",bindMarker("id"))));


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


        PreparedStatement actual = generator.prepareSelectField(session, meta, nameMeta);


        assertThat(actual).isSameAs(ps);


        assertThat(queryCaptor.getValue()).isEqualTo("SELECT name FROM ks.table WHERE id=:id;");
    }

View Full Code Here

        when(nameMeta.forStatementGeneration().prepareUpdateField(conditionsCaptor.capture())).thenReturn(assignments);
        when(ageMeta.forStatementGeneration().prepareUpdateField(isA(Assignments.class))).thenReturn(assignments);
        when(idMeta.forStatementGeneration().prepareCommonWhereClauseForUpdate(assignments, false)).thenReturn(assignments.where(eq("id", bindMarker("id"))));
        when(session.prepare(queryCaptor.capture())).thenReturn(ps);


        PreparedStatement actual = generator.prepareUpdateFields(session, meta, asList(nameMeta, ageMeta),
                ifConditions(new CASCondition("name", "John")).withTimestamp(100L));


        assertThat(actual).isSameAs(ps);


        assertThat(conditionsCaptor.getValue().getQueryString()).isEqualTo("UPDATE ks.table IF name=:name;");

View Full Code Here

        when(idMeta.forStatementGeneration().generateWhereClauseForSelect(Mockito.eq(Optional.<PropertyMeta>absent()), isA(Select.class)))
                .thenReturn(select("name").from("ks","table").where(eq("id", bindMarker("id"))));


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


        PreparedStatement actual = generator.prepareSelectAll(session, meta);


        assertThat(actual).isSameAs(ps);
        assertThat(queryCaptor.getValue()).isEqualTo("SELECT name FROM ks.table WHERE id=:id;");
    }

View Full Code Here

        when(idMeta.forStatementGeneration().generateWhereClauseForSelect(Mockito.eq(Optional.fromNullable(nameMeta)), isA(Select.class)))
                .thenReturn(select("name").from("ks","table").where(eq("id", bindMarker("id"))));


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


        PreparedStatement actual = generator.prepareSelectAll(session, meta);


        assertThat(actual).isSameAs(ps);
        assertThat(queryCaptor.getValue()).isEqualTo("SELECT name FROM ks.table WHERE id=:id;");
    }

View Full Code Here

        assertThat(queryCaptor.getValue()).isEqualTo("DELETE FROM ks.table WHERE id=:id;");
    }


    @Test
    public void should_prepare_simple_counter_queries() throws Exception {
        PreparedStatement incrPs = mock(PreparedStatement.class);
        PreparedStatement decrPs = mock(PreparedStatement.class);
        PreparedStatement selectPs = mock(PreparedStatement.class);
        PreparedStatement deletePs = mock(PreparedStatement.class);


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


        Map<CQLQueryType, PreparedStatement> actual = generator.prepareSimpleCounterQueryMap(session);

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.