statement.setKeyspace("keyspace");
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");
private void validateData(Session session, int id) { ResultSet result = session.execute( new SimpleStatement("select * from users where id = ?", id) .setKeyspace(keyspace2Internal)); assertThat(result.getAvailableWithoutFetching()).isEqualTo(3); Row row1 = result.one(); assertThat(row1.getInt("id")).isEqualTo(id); assertThat(row1.getInt("id2")).isEqualTo(1); assertThat(row1.getString("name")).isEqualTo("hello"); Row row2 = result.one(); assertThat(row2.getInt("id")).isEqualTo(id); assertThat(row2.getInt("id2")).isEqualTo(2); assertThat(row2.getString("name")).isEqualTo("sweet"); Row row3 = result.one(); assertThat(row3.getInt("id")).isEqualTo(id); assertThat(row3.getInt("id2")).isEqualTo(3); assertThat(row3.getString("name")).isEqualTo("world"); } }
private void queryWithKeyspaceOnStatement(Cluster cluster, String sessionKeyspace) { Session session; if (sessionKeyspace != null) { session = cluster.connect(sessionKeyspace); } else { session = cluster.connect(); } try { SimpleStatement statement = new SimpleStatement("SELECT name FROM users2 WHERE id = 2 and id2 = 3") .setKeyspace(keyspace2Internal); Row row = session.execute(statement).one(); assertThat(row).isNotNull(); assertThat(row.getString("name")).isEqualTo("test2"); } finally { session.close(); if (cluster != cluster()) { cluster.close(); } } }
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");
@CassandraVersion("4.0.0") @Test(groups = "short") public void should_inherit_keyspace_from_inner_statement() { int id = idCounter.incrementAndGet(); BatchStatement batch = new BatchStatement(); batch.add(new SimpleStatement("INSERT INTO users (id, id2, name) values (?, 1, 'hello')", id)); batch.add( new SimpleStatement("INSERT INTO users (id, id2, name) values (?, 2, 'sweet')", id) .setKeyspace(keyspace2Internal)); batch.add(new SimpleStatement("INSERT INTO users (id, id2, name) values (?, 3, 'world')", id)); // keyspace should be inherited from first statement that has one. assertThat(batch.getKeyspace()).isEqualTo(keyspace2Internal); session().execute(batch); validateData(session(), id); }
private void queryWithKeyspaceOnStatement(Cluster cluster, String sessionKeyspace) { Session session; if (sessionKeyspace != null) { session = cluster.connect(sessionKeyspace); } else { session = cluster.connect(); } try { SimpleStatement statement = new SimpleStatement("SELECT name FROM users WHERE id = 2 and id2 = 3") .setKeyspace(keyspace2Internal); // Keyspace should be propagated to prepared statement. PreparedStatement prepared = session.prepare(statement); assertThat(prepared.getQueryKeyspace()).isEqualTo(keyspace2Internal); BoundStatement bound = prepared.bind(); Row row = session.execute(bound).one(); assertThat(row).isNotNull(); assertThat(row.getString("name")).isEqualTo("test2"); } finally { session.close(); if (cluster != cluster()) { cluster.close(); } } } }
prep2 = session.prepare(new SimpleStatement("SELECT * from users").setKeyspace(keyspace2)); prep3 = session.prepare( new SimpleStatement("SELECT * from users").setKeyspace(keyspace3Internal)); } else {
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace") .setRoutingToken(range.getEnd());
statement.setKeyspace("keyspace");
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");
new SimpleStatement("select * from table where k=5") .setRoutingKey(routingKey) .setKeyspace("keyspace");