<commit_before>-- MAC 0211 - Laboratório de Banco de Dados
-- IME-USP  - Segundo  Semestre   de   2014
-- Turma 45 - Prof.ª  <NAME>  Bragheto

-- Data sample
SELECT create_account
    ('renatocf', '<EMAIL>', '14159265');
SELECT create_account
    ('ruan0408', '<EMAIL>', 'ruanruan');
SELECT create_account
    ('tuiuiu', '<EMAIL>', '38462643');
SELECT create_account
    ('karinaawoki', '<EMAIL>', '38327950');

SELECT grant_reviewer_permission('renatocf');
SELECT grant_reviewer_permission('ruan0408');

-- Books
SELECT create_book(_name := 'Harry Potter and the Philosopher''s Stone', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Chamber of Secrets', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Prisoner of Azkaban', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Goblet of Fire', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Order of the Phoenix', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Half-Blood Prince', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Deathly Hallows', _genre := 'Adventure', _num_editions := 1);

-- Comics
SELECT create_comic(_name := 'Superman', _genre := 'Action', _num := 423);

-- Movies
SELECT create_movie('The Lord of the Rings: The Fellowship of the Ring', 'A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sauron.', 'Adventure', 178, 'USA', 'G');
SELECT create_movie('Matrix', 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.', 'Action', 136, 'USA', 'G');

-- Musics
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);

-- Series
SELECT create_series(_name := 'Friends', _genre := 'Comedy', _date_init := '1994-09-22', _date_end := '2004-05-06', _num_seasons := 10);

SELECT create_change('renatocf', 'u_title_description', '1', 
'A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sauron.');
SELECT approve_change('ruan0408',1);<commit_msg>Update IEDB_data.sql<commit_after>-- MAC 0211 - Laboratório de Banco de Dados
-- IME-USP  - Segundo  Semestre   de   2014
-- Turma 45 - Prof.ª  <NAME>

-- Data sample
SELECT create_account
    ('renatocf', '<EMAIL>', '14159265');
SELECT create_account
    ('ruan0408', '<EMAIL>', 'ruanruan');
SELECT create_account
    ('tuiuiu', '<EMAIL>', '38462643');
SELECT create_account
    ('karinaawoki', '<EMAIL>', '38327950');

SELECT grant_reviewer_permission('renatocf');
SELECT grant_reviewer_permission('ruan0408');

-- Books
SELECT create_book(_name := 'Harry Potter and the Philosopher''s Stone', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Chamber of Secrets', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Prisoner of Azkaban', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Goblet of Fire', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Order of the Phoenix', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Half-Blood Prince', _genre := 'Adventure', _num_editions := 1);
SELECT create_book(_name := 'Harry Potter and the Deathly Hallows', _genre := 'Adventure', _num_editions := 1);

-- Comics
SELECT create_comic(_name := 'Superman', _genre := 'Action', _num := 423);

-- Movies
SELECT create_movie('The Lord of the Rings: The Fellowship of the Ring', 'A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sauron.', 'Adventure', 178, 'USA', 'G');
SELECT create_movie('Matrix', 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.', 'Action', 136, 'USA', 'G');
SELECT create_movie('The Lord of the Rings: The Two Towers', 'A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sauron.', 'Adventure', 178, 'USA', 'G');
SELECT create_movie('Matrix', 'A computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against its controllers.', 'Action', 136, 'USA', 'G');

-- Musics
SELECT create_music(_name := 'Lucy in the sky with diamonds', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Penny Lane', _genre := 'Rock', _duration := 3);
SELECT create_music(_name := 'Octavarium', _genre := 'Rock', _duration := 29);
SELECT create_music(_name := 'Mirror Mirror', _genre := 'Rock', _duration := 5);
SELECT create_music(_name := 'The Trooper', _genre := 'Rock', _duration := 4);
SELECT create_music(_name := 'Excalibur', _genre := 'Rock', _duration := 5);
SELECT create_music(_name := 'Applause', _genre := 'Pop', _duration := 4);
SELECT create_music(_name := 'Anaconda', _genre := 'Pop', _duration := 3);
SELECT create_music(_name := 'Harder, Better, Faster, Stronger', _genre := 'Electronic', _duration := 4);
SELECT create_music(_name := '<NAME>', _genre := 'Electronic', _duration := 4);

-- Series
SELECT create_series(_name := 'Friends', _genre := 'Comedy', _date_init := '1994-09-22', _date_end := '2004-05-06', _num_seasons := 10);

SELECT create_change('renatocf', 'u_title_description', '1', 
'A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sauron.');
SELECT approve_change('ruan0408',1);
{'fraction_non_alphanumeric': 0.14024294052689698, 'fraction_numerical': 0.029499921123205552, 'mean_word_length': 5.346346346346347, 'pattern_counts': {'":': 0, '<': 14, '<?xml version=': 0, '>': 14, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5678353', 'n_tokens_mistral': 2213, 'n_tokens_neox': 1979, 'n_words': 741}