popular_count
<what is it used for?>
<what is it used for?>
SOURCE '0_create_keyspace.cql';
DROP TABLE IF EXISTS cycling.popular_count;
// START-create
CREATE TABLE IF NOT EXISTS cycling.popular_count (
id UUID PRIMARY KEY,
popularity counter
);
// END-create
// START-batch
BEGIN COUNTER BATCH
UPDATE cycling.popular_count
SET popularity = popularity + 1
WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;
UPDATE cycling.popular_count
SET popularity = popularity + 125
WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;
UPDATE cycling.popular_count
SET popularity = popularity - 64
WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;
APPLY BATCH;
// END-batch
// START-count
UPDATE cycling.popular_count
SET popularity = popularity + 2
WHERE id = 6ab09bec-e68e-48d9-a5f8-97e6fb4c9b47;
// END-count
CAPTURE 'select_all_from_popular_count.results';
// START-select
SELECT *
FROM cycling.popular_count;
// END-select
CAPTURE OFF;