cyclist_sponsors

Cyclist sponsors set with TIMESTAMP and TTL

SOURCE '0_create_keyspace.cql';

DROP TABLE IF EXISTS cycling.cyclist_sponsors_expire;

// START-cyclistsponsorsexpireset
CREATE TABLE IF NOT EXISTS cycling.cyclist_sponsors_expire (
  cyclist_name text PRIMARY KEY,
  sponsorship set<text>
);
// END-cyclistsponsorsexpireset

// START-insertTTLexpireset
INSERT INTO cycling.cyclist_sponsors_expire (
  cyclist_name, sponsorship
) VALUES (
  'PRIETO, Marcela',
  { 'Castrelli', 'Alfa Romeo' }
) 
USING TIMESTAMP 100
AND TTL 10000;
// END-insertTTLexpireset

// START-updateTTLexpireset
UPDATE cycling.cyclist_sponsors_expire 
USING TIMESTAMP 200
AND TTL 20000 
SET sponsorship += { 'Tag Heuer' } 
WHERE cyclist_name = 'PRIETO, Marcela';
// END-updateTTLexpireset

// START-selectTTLexpireset
SELECT *
FROM cycling.cyclist_sponsors_expire;
// END-selectTTLexpireset