.using(timeToLive) .value("key", getPartitionKey(scope, rowKeyString, bucket)) .value("column1", DataType.text().serialize(columnName, ProtocolVersion.NEWEST_SUPPORTED))
@Override public void writeMessageData( final UUID messageId, final DatabaseQueueMessageBody messageBody ) { Preconditions.checkArgument(QakkaUtils.isTimeUuid(messageId), "MessageId is not a type 1 UUID"); logger.trace("writeMessageData {}", messageId); Statement insert = QueryBuilder.insertInto(TABLE_MESSAGE_DATA) .value( COLUMN_MESSAGE_ID, messageId) .value( COLUMN_MESSAGE_DATA, messageBody.getBlob()) .value( COLUMN_CONTENT_TYPE, messageBody.getContentType()) .using( QueryBuilder.ttl( maxTtl ) ); cassandraClient.getApplicationSession().execute(insert); }
private static String insertSQL(final String table, final int timeout) { Insert insertInto = insertInto(table) .value(ID, raw("?")) .value(CREATED_AT, raw("?")) .value(ACCESSED_AT, raw("?")) .value(SAVED_AT, raw("?")) .value(ATTRIBUTES, raw("?")); if (timeout > 0) { insertInto.using(ttl(timeout)); } return insertInto.getQueryString(); }
.using(timeToLive) .value("key", getMapEntryPartitionKey(scope, key)) .value("column1", DataType.cboolean().serialize(true, ProtocolVersion.NEWEST_SUPPORTED)) .using(timeToLive) .value("key", getMapKeyPartitionKey(scope, bucket)) .value("column1", DataType.text().serialize(key, ProtocolVersion.NEWEST_SUPPORTED))
.value("column1", serializeUniqueValueColumn(ev)) .value("value", DataType.serializeValue(COL_VALUE, ProtocolVersion.NEWEST_SUPPORTED)) .using(ttl);
private Statement createWriteMessageStatement( DatabaseQueueMessage message ) { final UUID queueMessageId = message.getQueueMessageId() == null ? QakkaUtils.getTimeUuid() : message.getQueueMessageId(); final long shardId; if ( message.getShardId() != null ) { shardId = message.getShardId(); } else if ( DatabaseQueueMessage.Type.DEFAULT.equals( message.getType() )) { Shard shard = shardStrategy.selectShard( message.getQueueName(), message.getRegion(), Shard.Type.DEFAULT, message.getQueueMessageId() ); shardId = shard.getShardId(); } else { Shard shard = shardStrategy.selectShard( message.getQueueName(), message.getRegion(), Shard.Type.INFLIGHT, message.getQueueMessageId() ); shardId = shard.getShardId(); } Statement insert = QueryBuilder.insertInto(getTableName(message.getType())) .value( COLUMN_QUEUE_NAME, message.getQueueName()) .value( COLUMN_REGION, message.getRegion()) .value( COLUMN_SHARD_ID, shardId) .value( COLUMN_MESSAGE_ID, message.getMessageId()) .value( COLUMN_QUEUE_MESSAGE_ID, queueMessageId) .value( COLUMN_INFLIGHT_AT, message.getInflightAt()) .value( COLUMN_QUEUED_AT, message.getQueuedAt()) .using( QueryBuilder.ttl( maxTtl ) ); return insert; }
insert.using(QueryBuilder.ttl(TTL)); insertRequest.add(insert);
3.4 }) .using(ttl(24)) .and(timestamp(42)); assertEquals(insert.toString(), query);
.using(timestamp(42)) .and(ttl(24)); assertEquals(insert.toString(), query); 3.4 }) .using(ttl(24)) .and(timestamp(42)); assertEquals(insert.toString(), query); 3.4 }) .using(ttl(bindMarker())) .and(timestamp(bindMarker())); assertEquals(insert.toString(), query); insert = insertInto("foo", "bar") .using(timestamp(42)) .values( new String[] {"a", "b"}, insert = insertInto("foo") .using(timestamp(42)) .value("c", 123) .values(
private RegularStatement maybeUseTtl(Insert value) { return indexTtl == null ? value : value.using(QueryBuilder.ttl(QueryBuilder.bindMarker("ttl_"))); }
@Override void modifyQueryString(BuiltStatement query) { ((Insert) query).using().and( QueryBuilder.ttl(QueryBuilder.bindMarker())); }
@Override void modifyQueryString(BuiltStatement query) { if (query instanceof Insert) { ((Insert) query).using().and(QueryBuilder.timestamp(QueryBuilder.bindMarker())); } else if (query instanceof Delete) { ((Delete) query).using().and(QueryBuilder.timestamp(QueryBuilder.bindMarker())); } else { throw new AssertionError("Unexpected query type: " + query.getClass()); } }
@Override public RegularStatement toStatement() { LOG.trace("Inserting metric in context: '{}' with resource id: '{}' with name: '{}'", m_context, m_resourceId, m_metric); return insertInto(Constants.Schema.T_METRICS) .value(Constants.Schema.C_METRICS_CONTEXT, m_context.getId()) .value(Constants.Schema.C_METRICS_RESOURCE, m_resourceId) .value(Constants.Schema.C_METRICS_NAME, m_metric) .using(ttl(m_ttl)); }
@Override public RegularStatement toStatement() { LOG.trace("Inserting attribute in context: '{}' with resource id: '{}' with name: '{}' and value: '{}'", m_context, m_resourceId, m_field, m_value); return insertInto(Constants.Schema.T_ATTRS) .value(Constants.Schema.C_ATTRS_CONTEXT, m_context.getId()) .value(Constants.Schema.C_ATTRS_RESOURCE, m_resourceId) .value(Constants.Schema.C_ATTRS_ATTR, m_field) .value(Constants.Schema.C_ATTRS_VALUE, m_value) .using(ttl(m_ttl)); } }
@Override public RegularStatement toStatement() { LOG.trace("Inserting attribute in context: '{}' with resource id: '{}' with name: '{}' and value: '{}'", m_context, m_resourceId, m_field, m_value); return insertInto(Constants.Schema.T_ATTRS) .value(Constants.Schema.C_ATTRS_CONTEXT, m_context.getId()) .value(Constants.Schema.C_ATTRS_RESOURCE, m_resourceId) .value(Constants.Schema.C_ATTRS_ATTR, m_field) .value(Constants.Schema.C_ATTRS_VALUE, m_value) .using(ttl(m_ttl)); } }
Factory(CassandraStorage storage, int indexTtl) { super(storage.autocompleteTtl, storage.autocompleteCardinality); session = storage.session(); Insert insertQuery = QueryBuilder.insertInto(Tables.SERVICE_NAMES) .value("service_name", QueryBuilder.bindMarker("service_name")); if (indexTtl > 0) insertQuery.using(QueryBuilder.ttl(indexTtl)); preparedStatement = session.prepare(insertQuery); }
Factory(CassandraStorage storage, int indexTtl) { super(storage.autocompleteTtl, storage.autocompleteCardinality); session = storage.session(); Insert insertQuery = QueryBuilder.insertInto(TABLE_AUTOCOMPLETE_TAGS) .value("key", QueryBuilder.bindMarker("key")) .value("value", QueryBuilder.bindMarker("value")); if (indexTtl > 0) insertQuery.using(QueryBuilder.ttl(indexTtl)); preparedStatement = session.prepare(insertQuery); }
Factory(CassandraStorage storage, int indexTtl) { super(storage.autocompleteTtl, storage.autocompleteCardinality); session = storage.session(); Insert insertQuery = QueryBuilder.insertInto(Tables.SPAN_NAMES) .value("service_name", QueryBuilder.bindMarker("service_name")) .value("bucket", 0) // bucket is deprecated on this index .value("span_name", QueryBuilder.bindMarker("span_name")); if (indexTtl > 0) insertQuery.using(QueryBuilder.ttl(indexTtl)); preparedStatement = session.prepare(insertQuery); }
private static String insertSQL(final String table, final int timeout) { Insert insertInto = insertInto(table) .value(ID, raw("?")) .value(CREATED_AT, raw("?")) .value(ACCESSED_AT, raw("?")) .value(SAVED_AT, raw("?")) .value(ATTRIBUTES, raw("?")); if (timeout > 0) { insertInto.using(ttl(timeout)); } return insertInto.getQueryString(); }