Search in sources :

Example 1 with Insert

use of com.datastax.driver.core.querybuilder.Insert in project YCSB by brianfrankcooper.

the class CassandraCQLClient method insert.

/**
   * Insert a record in the database. Any field/value pairs in the specified
   * values HashMap will be written into the record with the specified record
   * key.
   *
   * @param table
   *          The name of the table
   * @param key
   *          The record key of the record to insert.
   * @param values
   *          A HashMap of field/value pairs to insert in the record
   * @return Zero on success, a non-zero error code on error
   */
@Override
public Status insert(String table, String key, HashMap<String, ByteIterator> values) {
    try {
        Insert insertStmt = QueryBuilder.insertInto(table);
        // Add key
        insertStmt.value(YCSB_KEY, key);
        // Add fields
        for (Map.Entry<String, ByteIterator> entry : values.entrySet()) {
            Object value;
            ByteIterator byteIterator = entry.getValue();
            value = byteIterator.toString();
            insertStmt.value(entry.getKey(), value);
        }
        insertStmt.setConsistencyLevel(writeConsistencyLevel);
        if (debug) {
            System.out.println(insertStmt.toString());
        }
        if (trace) {
            insertStmt.enableTracing();
        }
        session.execute(insertStmt);
        return Status.OK;
    } catch (Exception e) {
        e.printStackTrace();
    }
    return Status.ERROR;
}
Also used : ByteArrayByteIterator(com.yahoo.ycsb.ByteArrayByteIterator) ByteIterator(com.yahoo.ycsb.ByteIterator) Insert(com.datastax.driver.core.querybuilder.Insert) HashMap(java.util.HashMap) Map(java.util.Map) DBException(com.yahoo.ycsb.DBException)

Example 2 with Insert

use of com.datastax.driver.core.querybuilder.Insert in project YCSB by brianfrankcooper.

the class CassandraCQLClientTest method insertRow.

private void insertRow() {
    final String rowKey = DEFAULT_ROW_KEY;
    Insert insertStmt = QueryBuilder.insertInto(TABLE);
    insertStmt.value(CassandraCQLClient.YCSB_KEY, rowKey);
    insertStmt.value("field0", "value1");
    insertStmt.value("field1", "value2");
    session.execute(insertStmt);
}
Also used : Insert(com.datastax.driver.core.querybuilder.Insert)

Example 3 with Insert

use of com.datastax.driver.core.querybuilder.Insert in project camel by apache.

the class CassandraIdempotentRepository method initInsertStatement.

// -------------------------------------------------------------------------
// Add key to repository
protected void initInsertStatement() {
    Insert insert = generateInsert(table, pkColumns, true, ttl);
    insert = applyConsistencyLevel(insert, writeConsistencyLevel);
    LOGGER.debug("Generated Insert {}", insert);
    insertStatement = getSession().prepare(insert);
}
Also used : Insert(com.datastax.driver.core.querybuilder.Insert) CassandraUtils.generateInsert(org.apache.camel.utils.cassandra.CassandraUtils.generateInsert)

Example 4 with Insert

use of com.datastax.driver.core.querybuilder.Insert in project trellis-cassandra by ajs6f.

the class CassandraResourceService method write.

private Future<Boolean> write(final IRI id, final IRI ixnModel, final Dataset dataset) {
    Insert mutableDataInsert = insertInto(Mutable.tableName).values(DATA_COLUMNS, new Object[] { id, dataset });
    final RegularStatement metadataInsert = metadataInsert(id, ixnModel, dataset);
    RegularStatement[] ops = new RegularStatement[] { mutableDataInsert, metadataInsert };
    return execute(ops);
}
Also used : Insert(com.datastax.driver.core.querybuilder.Insert) RegularStatement(com.datastax.driver.core.RegularStatement)

Example 5 with Insert

use of com.datastax.driver.core.querybuilder.Insert in project thingsboard by thingsboard.

the class CassandraBaseEventDao method save.

private Optional<Event> save(EventEntity entity, boolean ifNotExists) {
    if (entity.getId() == null) {
        entity.setId(UUIDs.timeBased());
    }
    Insert insert = QueryBuilder.insertInto(getColumnFamilyName()).value(ModelConstants.ID_PROPERTY, entity.getId()).value(ModelConstants.EVENT_TENANT_ID_PROPERTY, entity.getTenantId()).value(ModelConstants.EVENT_ENTITY_TYPE_PROPERTY, entity.getEntityType()).value(ModelConstants.EVENT_ENTITY_ID_PROPERTY, entity.getEntityId()).value(ModelConstants.EVENT_TYPE_PROPERTY, entity.getEventType()).value(ModelConstants.EVENT_UID_PROPERTY, entity.getEventUid()).value(ModelConstants.EVENT_BODY_PROPERTY, entity.getBody());
    if (ifNotExists) {
        insert = insert.ifNotExists();
    }
    ResultSet rs = executeWrite(insert);
    if (rs.wasApplied()) {
        return Optional.of(DaoUtil.getData(entity));
    } else {
        return Optional.empty();
    }
}
Also used : ResultSet(com.datastax.driver.core.ResultSet) Insert(com.datastax.driver.core.querybuilder.Insert)

Aggregations

Insert (com.datastax.driver.core.querybuilder.Insert)38 BigInteger (java.math.BigInteger)5 ResultSetFuture (com.datastax.driver.core.ResultSetFuture)4 Select (com.datastax.driver.core.querybuilder.Select)3 ResultSet (com.datastax.driver.core.ResultSet)2 Batch (com.datastax.driver.core.querybuilder.Batch)2 BigDecimal (java.math.BigDecimal)2 ArrayList (java.util.ArrayList)2 Date (java.util.Date)2 HashMap (java.util.HashMap)2 Map (java.util.Map)2 UUID (java.util.UUID)2 CassandraUtils.generateInsert (org.apache.camel.utils.cassandra.CassandraUtils.generateInsert)2 Timer (com.codahale.metrics.Timer)1 BoundStatement (com.datastax.driver.core.BoundStatement)1 ColumnDefinitions (com.datastax.driver.core.ColumnDefinitions)1 PreparedStatement (com.datastax.driver.core.PreparedStatement)1 RegularStatement (com.datastax.driver.core.RegularStatement)1 Row (com.datastax.driver.core.Row)1 QueryBuilder.unloggedBatch (com.datastax.driver.core.querybuilder.QueryBuilder.unloggedBatch)1