<commit_before>-- Clear all rows from all tables.
-- WARNING: THIS LITERALLY DESTROYS ALL THE DATA IN ALL TABLES. 
-- NEVER RUN ONCE THE SITE IS LIVE.

DELETE FROM comments;
DELETE FROM submissions;
DELETE FROM assignments;

DELETE FROM sections_people;
DELETE FROM sections;

DELETE FROM course_terms_people;
DELETE FROM course_terms;
DELETE FROM courses;
DELETE FROM people;

-- Create fake data.

INSERT INTO people (user_system_id, given_name, family_name) VALUES 
('amainero', 'Anthony', 'Mainero'),
('maesenc', 'Maesen', 'Churchill'),
('odiab', '<NAME>', 'Diab'),
('rawatson', 'Reid', 'Watson');

INSERT INTO courses (course_system_id) VALUES
('CS106A'),
('CS106B');

INSERT INTO course_terms (course_id, course_name, term_name, period, active) VALUES
(1, 'Programming Methodology', 'Fall', '13-14', False),
(2, 'Programming Abstractions', 'Fall', '13-14', False),
(1, 'Programming Methodology', 'Winter', '13-14', True),
(2, 'Programming Abstractions', 'Winter', '13-14', True);

-- For CS106A Winter 2014, Reid is admin, Maesen leader, Omar and Anthony students.<commit_msg>Reset ID numbering so DB can be easily reset<commit_after>-- Clear all rows from all tables.
-- WARNING: THIS LITERALLY DESTROYS ALL THE DATA IN ALL TABLES. 
-- NEVER RUN ONCE THE SITE IS LIVE.

DELETE FROM comments;
DELETE FROM submissions;
DELETE FROM assignments;

DELETE FROM sections_people;
DELETE FROM sections;

DELETE FROM course_terms_people;
DELETE FROM course_terms;
DELETE FROM courses;
DELETE FROM people;

ALTER SEQUENCE comments_id_seq RESTART;
ALTER SEQUENCE submissions_id_seq RESTART;
ALTER SEQUENCE assignments_id_seq RESTART;

ALTER SEQUENCE sections_people_id_seq RESTART;
ALTER SEQUENCE sections_id_seq RESTART;

ALTER SEQUENCE course_terms_people_id_seq RESTART;
ALTER SEQUENCE course_terms_id_seq RESTART;
ALTER SEQUENCE courses_id_seq RESTART;
ALTER SEQUENCE people_id_seq RESTART;

-- Create fake data.

INSERT INTO people (user_system_id, given_name, family_name) VALUES 
('amainero', 'Anthony', 'Mainero'),
('maesenc', 'Maesen', 'Churchill'),
('odiab', '<NAME>', 'Diab'),
('rawatson', 'Reid', 'Watson');

INSERT INTO courses (course_system_id) VALUES
('CS106A'),
('CS106B');

INSERT INTO course_terms (course_id, course_name, term_name, period, active) VALUES
(1, 'Programming Methodology', 'Fall', '13-14', False),
(2, 'Programming Abstractions', 'Fall', '13-14', False),
(1, 'Programming Methodology', 'Winter', '13-14', True),
(2, 'Programming Abstractions', 'Winter', '13-14', True);

-- For CS106A Winter 2014, Reid is admin, Maesen leader, Omar and Anthony students.
{'fraction_non_alphanumeric': 0.12349980642663569, 'fraction_numerical': 0.025551684088269456, 'mean_word_length': 6.0989010989010985, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, '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': '630475', 'n_tokens_mistral': 926, 'n_tokens_neox': 839, 'n_words': 295}