Examples of com.datastax.driver.core.Session.execute()

com.datastax.driver.core.Session.execute()
Executes the provided query. This is a convenience method for {@code execute(new SimpleStatement(query))}. @param query the CQL query to execute. @return the result of the query. That result will never be null but canbe empty (and will be for any non SELECT query). @throws NoHostAvailableException if no host in the cluster can becontacted successfully to execute this query. @throws QueryExecutionException if the query triggered an executionexception, i.e. an exception thrown by Cassandra when it cannot execute the query with the requested consistency level successfully. @throws QueryValidationException if the query if invalid (syntax error,unauthorized or any other validation problem).

    Cluster cluster = Cluster.builder()
        .addContactPoints("127.0.0.1")
            .withPort(9142)
        .build();
    Session session = cluster.connect("cassandra_unit_keyspace");
    ResultSet result = session.execute("select * from testCQLTable WHERE id=1690e8da-5bf8-49e8-9583-4dff8a570737");
    String val = result.iterator().next().getString("value");
    assertEquals("Cql loaded string", val);
  }


}

View Full Code Here


        com.datastax.driver.core.Cluster cluster =
                new com.datastax.driver.core.Cluster.Builder().addContactPoints(host).withPort(Integer.parseInt(port)).build();
        Session session = cluster.connect();


        ResultSet result = session.execute("select * from mykeyspace.testCQLTable WHERE id=1690e8da-5bf8-49e8-9583-4dff8a570737");
        String val = result.iterator().next().getString("value");
        Assert.assertThat("Cql loaded string",is(val));


        EmbeddedCassandraServerHelper.cleanEmbeddedCassandra();
    }

View Full Code Here


    // Make sure it is really dropped
    Session session = cm.getEmptySession();
    boolean caught = false;
    try {
      session.execute("USE " + definition.getName() + ";");
    } catch(InvalidQueryException e) {
      caught = true;
    }
    session.close();
    assertTrue(caught);

View Full Code Here

    sb.append("SELECT id from \"");
    sb.append(cm.getRhombusKeyspaceName());
    sb.append("\".\"__keyspace_definitions\" where name='");
    sb.append(NewKeyspaceDefinition.getName());
    sb.append("';");
    ResultSet resultSet = session.execute(sb.toString());
    Iterator<Row> rsIter = resultSet.iterator();
    int counter = 0;
    while(rsIter.hasNext()) {
      counter++;
      rsIter.next();

View Full Code Here

    Session session = cm.getEmptySession();
    assertNotNull(session);


    //Drop the functional keyspace if it exists
    try {
      session.execute("DROP KEYSPACE functional_create");
    } catch (InvalidQueryException e) {
      //Ignore
    }


    //Create the functional keyspace

View Full Code Here

    } catch (InvalidQueryException e) {
      //Ignore
    }


    //Create the functional keyspace
    session.execute("CREATE KEYSPACE functional_create WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }");


    //Change to our functional testing keyspace
    session.execute("USE functional_create");


    //Drop the functional keyspace

View Full Code Here


    //Create the functional keyspace
    session.execute("CREATE KEYSPACE functional_create WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }");


    //Change to our functional testing keyspace
    session.execute("USE functional_create");


    //Drop the functional keyspace
    try {
      session.execute("DROP KEYSPACE functional_create");
    } catch (InvalidQueryException e) {

View Full Code Here

    //Change to our functional testing keyspace
    session.execute("USE functional_create");


    //Drop the functional keyspace
    try {
      session.execute("DROP KEYSPACE functional_create");
    } catch (InvalidQueryException e) {
      //Ignore
    }


    //Shutdown the session

View Full Code Here

        }
        String query = select().all().from(db, table).where(eq(keycol, key))
                .getQueryString();
        Cluster cluster = Cluster.builder().addContactPoints("localhost").build();
        Session session = cluster.connect(db);
        ResultSet rs = session.execute(query);
        return convertResultSet(rs);
    }


    private String convertResultSet(ResultSet rs) {
        // TODO Auto-generated method stub

View Full Code Here

        Long rowKey = (Long.valueOf(evTime)/periodicity)*periodicity;
        String query = select().all().from(db, table).where(eq("key", String.valueOf(rowKey))).and(eq("column1",Long.valueOf(evTime)))
                .getQueryString();
        Cluster cluster = Cluster.builder().addContactPoints("localhost").build();
        Session session = cluster.connect(db);
        ResultSet rs = session.execute(query);
        return convertResultSet(rs);
    }
    public String doJoin(String db, String table1, String table2,
        String joincol, String value) {
        String res1 = listRow(db,table1,joincol,value);

View Full Code Here

0 1 2 3 4

TOP

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.