Cassandra : Modélisation et création de base de données

CREATE KEYSPACE ai07 WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };

CREATE KEYSPACE ai07 WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };

CREATE TABLE videos (

  video_id uuid,

  video_name varchar,

  video_uploaded timestamp,

  user_login varchar,

  PRIMARY KEY(video_id));

CREATE TABLE videos (
  video_id uuid,
  video_name varchar,
  video_uploaded timestamp,
  user_login varchar,
  PRIMARY KEY(video_id));

CREATE TABLE user_videos_index (

  login varchar,

  video_id uuid,

  video_name varchar,

  PRIMARY KEY(login, video_id));

CREATE TABLE user_videos_index (
  login varchar,
  video_id uuid,
  video_name varchar,
  PRIMARY KEY(login, video_id));

CREATE TABLE comments_by_video (

  video_id uuid,

  user_login varchar,

  comment_dat timestamp,

  comment varchar,

  PRIMARY KEY(video_id, user_login));

CREATE TABLE comments_by_video (
  video_id uuid,
  user_login varchar,
  comment_dat timestamp,
  comment varchar,
  PRIMARY KEY(video_id, user_login));

CREATE TABLE comments_by_user (

  user_login varchar,

  video_id uuid,

  comment_dat timestamp,

  comment varchar,

  PRIMARY KEY(user_login, video_id));

CREATE TABLE comments_by_user (
  user_login varchar,
  video_id uuid,
  comment_dat timestamp,
  comment varchar,
  PRIMARY KEY(user_login, video_id));

CREATE TABLE users (

login varchar,

firstname varchar,

lastname varchar,

PRIMARY KEY(login));

CREATE TABLE users (
login varchar,
firstname varchar,
lastname varchar,
PRIMARY KEY(login));

INSERT INTO users(login, firstname, lastname) VALUES ('cschmidt', 'chris', 'SCHMIDT');

INSERT INTO users(login, firstname, lastname) VALUES ('saraj00n', 'Sarah', 'JUNE');

INSERT INTO users(login, firstname, lastname) VALUES ('MasterTroll', 'Jean', 'FABRICE');

INSERT INTO videos (video_id, video_name, video_uploaded, user_login) VALUES (uuid(),'Keyboard Cat', dateof(now()), 'cshmidt');

INSERT INTO user_videos_index (login, video_id, video_name) VALUES ('cschmidt', the generated uuid, 'Keyboard Cat');

INSERT INTO videos (video_id, video_name, video_uploaded, user_login) VALUES (uuid(),'nyan cat', dateof(now()), 'saraj00n');

INSERT INTO user_videos_index (login, video_id, video_name) VALUES ('saraj00n', the generated uuid, 'nyan cat');

SELECT * FROM videos;

SELECT video_name FROM user_videos_index WHERE login='saraj00n';

INSERT INTO users(login, firstname, lastname) VALUES ('cschmidt', 'chris', 'SCHMIDT');
INSERT INTO users(login, firstname, lastname) VALUES ('saraj00n', 'Sarah', 'JUNE');
INSERT INTO users(login, firstname, lastname) VALUES ('MasterTroll', 'Jean', 'FABRICE');
INSERT INTO videos (video_id, video_name, video_uploaded, user_login) VALUES (uuid(),'Keyboard Cat', dateof(now()), 'cshmidt');
INSERT INTO user_videos_index (login, video_id, video_name) VALUES ('cschmidt', the generated uuid, 'Keyboard Cat');
INSERT INTO videos (video_id, video_name, video_uploaded, user_login) VALUES (uuid(),'nyan cat', dateof(now()), 'saraj00n');
INSERT INTO user_videos_index (login, video_id, video_name) VALUES ('saraj00n', the generated uuid, 'nyan cat');
SELECT * FROM videos;
SELECT video_name FROM user_videos_index WHERE login='saraj00n';

INSERT INTO comments_by_user (user_login, video_id, comment_dat, comment) VALUES (saraj00n, generated uuid, '1484481600', 'first');

INSERT INTO comments_by_videos (video_id, user_login, comment_dat, comment) VALUES (generated uuid, saraj00n, '1484481600', 'first');

INSERT INTO comments_by_user (user_login, video_id, comment_dat, comment) VALUES (MasterTroll, generated uuid, '1484481900', 'thats lame');

INSERT INTO comments_by_videos (video_id, user_login, comment_dat, comment) VALUES (generated uuid, 'MasterTroll', 1484481900, 'thats lame');

SELECT * FROM comments_by_user;

SELECT * FROM comments_by_video;

INSERT INTO comments_by_user (user_login, video_id, comment_dat, comment) VALUES (saraj00n, generated uuid, '1484481600', 'first');
INSERT INTO comments_by_videos (video_id, user_login, comment_dat, comment) VALUES (generated uuid, saraj00n, '1484481600', 'first');
INSERT INTO comments_by_user (user_login, video_id, comment_dat, comment) VALUES (MasterTroll, generated uuid, '1484481900', 'thats lame');
INSERT INTO comments_by_videos (video_id, user_login, comment_dat, comment) VALUES (generated uuid, 'MasterTroll', 1484481900, 'thats lame');
SELECT * FROM comments_by_user;
SELECT * FROM comments_by_video;

UPDATE users SET lastname='PAUL' WHERE login='MasterTroll';

SELECT * FROM users;

UPDATE users SET lastname='PAUL' WHERE login='MasterTroll';
SELECT * FROM users;

DELETE FROM users WHERE login = 'MasterTroll';

DELETE FROM users WHERE login = 'MasterTroll';

drop table users;

drop table users;

DROP KEYSPACE ai07;

DROP KEYSPACE ai07;