<commit_before>use garlic;

# I had to use the absolute path as the database itself is saved in another location
# which has no relation to the location the data-files are stored in

set foreign_key_checks = 0;

#u_users
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/u_users.csv'
into table u_users
fields terminated by ','
lines terminated by '\n'
ignore 1 rows;

#p_posts
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/p_posts.csv'
into table p_posts
fields terminated by ','
lines terminated by '\n'
ignore 1 rows;

#c_cloves
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/c_cloves.csv'<commit_msg>added github link to the data<commit_after>use garlic;

# I had to use the absolute path as the database itself is saved in another location
# which has no relation to the location the data-files are stored in

# the data used can be found here: https://github.com/astwys/Garlic/tree/master/database/mysql/data

set foreign_key_checks = 0;

#u_users
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/u_users.csv'
into table u_users
fields terminated by ','
lines terminated by '\n'
ignore 1 rows;

#p_posts
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/p_posts.csv'
into table p_posts
fields terminated by ','
lines terminated by '\n'
ignore 1 rows;

#c_cloves
load data infile '/Users/michael/school/3EHIF/DBI/Garlic/database/mysql/data/c_cloves.csv'
{'fraction_non_alphanumeric': 0.09526982011992005, 'fraction_numerical': 0.007994670219853431, 'mean_word_length': 4.6893939393939394, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 1, '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': '6782325', 'n_tokens_mistral': 529, 'n_tokens_neox': 498, 'n_words': 160}