<commit_before>-- Populate user_level table
INSERT INTO qiita.user_level (name, description) VALUES ('admin', 'Can access and do all the things'), ('dev', 'Can access all data and info about errors'), ('superuser', 'Can see all studies, can run analyses'), ('user', 'Can see own and public data, can run analyses'), ('unverified', 'Email not verified'), ('guest', 'Can view & download public data');

-- Populate analysis_status table
INSERT INTO qiita.analysis_status (status) VALUES ('in_construction'), ('queued'), ('running'), ('completed'), ('error'), ('public');

-- Populate job_status table
INSERT INTO qiita.job_status (status) VALUES ('queued'), ('running'), ('completed'), ('error');

-- Populate data_type table
INSERT INTO qiita.data_type (data_type) VALUES ('16S'), ('18S'), ('ITS'), ('Proteomic'), ('Metabolomic'), ('Metagenomic');

-- Populate filetype table
INSERT INTO qiita.filetype (type) VALUES ('SFF'), ('FASTA-Sanger'), ('FASTQ');

-- Populate emp_status table
INSERT INTO qiita.emp_status (emp_status) VALUES ('EMP'), ('EMP_Processed'), ('NOT_EMP');

-- Populate study_status table
INSERT INTO qiita.study_status (status, description) VALUES ('awaiting_approval', 'Awaiting approval of metadata'), ('public', 'Anyone can see this study'), ('private', 'Only owner and shared users can see this study');

-- Populate timeseries_type table
INSERT INTO qiita.timeseries_type (timeseries_type) VALUES ('NOT_TIMESERIES'), ('TIMESERIES_1'), ('TIMESERIES_2'), ('TIMESERIES_3');

-- Populate severity table
INSERT INTO qiita.severity (severity) VALUES ('Warning'), ('Runtime'), ('Fatal');

-- Populate portal_type table<commit_msg>add sandbox mode for study<commit_after>-- Populate user_level table
INSERT INTO qiita.user_level (name, description) VALUES ('admin', 'Can access and do all the things'), ('dev', 'Can access all data and info about errors'), ('superuser', 'Can see all studies, can run analyses'), ('user', 'Can see own and public data, can run analyses'), ('unverified', 'Email not verified'), ('guest', 'Can view & download public data');

-- Populate analysis_status table
INSERT INTO qiita.analysis_status (status) VALUES ('in_construction'), ('queued'), ('running'), ('completed'), ('error'), ('public');

-- Populate job_status table
INSERT INTO qiita.job_status (status) VALUES ('queued'), ('running'), ('completed'), ('error');

-- Populate data_type table
INSERT INTO qiita.data_type (data_type) VALUES ('16S'), ('18S'), ('ITS'), ('Proteomic'), ('Metabolomic'), ('Metagenomic');

-- Populate filetype table
INSERT INTO qiita.filetype (type) VALUES ('SFF'), ('FASTA-Sanger'), ('FASTQ');

-- Populate emp_status table
INSERT INTO qiita.emp_status (emp_status) VALUES ('EMP'), ('EMP_Processed'), ('NOT_EMP');

-- Populate study_status table
INSERT INTO qiita.study_status (status, description) VALUES ('sandbox', 'Only available to the owner. No sharing'), ('awaiting_approval', 'Awaiting approval of metadata'), ('public', 'Anyone can see this study'), ('private', 'Only owner and shared users can see this study');

-- Populate timeseries_type table
INSERT INTO qiita.timeseries_type (timeseries_type) VALUES ('NOT_TIMESERIES'), ('TIMESERIES_1'), ('TIMESERIES_2'), ('TIMESERIES_3');

-- Populate severity table
INSERT INTO qiita.severity (severity) VALUES ('Warning'), ('Runtime'), ('Fatal');

-- Populate portal_type table
{'fraction_non_alphanumeric': 0.16512942576614104, 'fraction_numerical': 0.0041654269562630165, 'mean_word_length': 6.37280701754386, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3503315', 'n_tokens_mistral': 1027, 'n_tokens_neox': 979, 'n_words': 357}