<commit_before>INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'GreggyP', 'User1',1);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'BobbyK', 'User2',2);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'HerbS', 'User3',3);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'JohnnyM', 'User4',4);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'MarcC', 'User5',5);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'Joe Sixpack', 'password',6);
Insert into post (userid, post, photoid) values (1,'I am the man!', 6);
Insert into post (userid, post, photoid) values (2,'Reboot it!!', 7);
Insert into post (userid, post, photoid) values (3,'User 3 First Post', 8);
Insert into post (userid, post, photoid) values (4,'User 4 First Post', 9);
Insert into post (userid, post, photoid) values (1,'User 1 Second Post', 10);
Insert into post (userid, post, photoid) values (1,'User 1 Third Post', 11);
Insert into post (userid, post, photoid) values (5,'User 5 First Post', 12);
Insert Into post (userid, referencepost, post) values (2, 1, 'no Im the man!!');
Insert Into post (userid, referencepost, post) values (4, 2, 'you said it');
Insert Into post (userid, referencepost, post) values (1, 3, 'Comment on post id 3');
Insert Into post (userid, referencepost, post) values (1, 4, 'Comment on post id 4');
Insert Into post (userid, referencepost, post) values (1, 1, 'Comment on post id 1 Again');
Insert Into post (userid, referencepost, post) values (2, 1, 'Comment on post id 1 Yet Again');
Insert into following (followerid, followeeid) values (1, 1);
Insert into following (followerid, followeeid) values (1, 2);
Insert into following (followerid, followeeid) values (2, 2);
Insert into following (followerid, followeeid) values (2, 1);
Insert into following (followerid, followeeid) values (4, 1);
Insert into following (followerid, followeeid) values (2, 3);
Insert into following (followerid, followeeid) values (2, 4);
Insert into following (followerid, followeeid) values (1, 5);
Insert into following (followerid, followeeid) values (5, 1);
Insert Into likes (likerid, likeeid, postid) values (2,1,1);
Insert Into likes (likerid, likeeid, postid) values (1,2,2);
Insert Into photo (photoname, mimetype) values ('User1.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User2.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User3.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User4.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User5.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('theman.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('reboot.jpg','Image/Jpeg');
Insert Into messages (messengerid, messageeid, subject, message) values ('1','2','first subject', 'first message text');
Insert Into education (userid, school, datestart, datefinished, degree) values (1,'University of Viriginia','10/1/2009', '6/1/2013','BS in Information System');
Insert Into education (userid, school, datestart, datefinished, degree) values (1,'University of Maryland','9/1/2013', '6/1/2015','MS in Computer Science');
Insert Into education (userid, school, datestart, datefinished, degree) values (2,'University of Phoenix','10/1/2011', '6/1/2015','BS');
Insert Into education (userid, school, datestart, datefinished, degree) values (3,'University of California Santa Cruz','10/1/2011', '6/1/2015','BS');
Insert Into education (userid, school, datestart, datefinished, degree) values (4,'University of Georgia','10/1/2011', '6/1/2015','BS');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (1,'<NAME>', 'cook', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (1,'Dominos','driver', '10/1/2006', '6/1/2009');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (2,'Walmart', 'stocker', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (3,'Best Buy','geek squad', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (4,'Target', 'cashier', '10/1/2004', '6/1/2006');
Insert Into skills (userid, skill, skilldesc) values (1,'J2EE', 'J2EE Skills');
Insert Into skills (userid, skill, skilldesc) values (1,'.Net','.Net Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'C++', 'MFC Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'Perl','Perl Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'HTML', 'Web Programming');
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hooli Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Google Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Apple Computer", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Pied Piper, a Compression Company", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Microsoft", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Oracle", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "<PASSWORD>", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hewlett Packard Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hooli", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hooli", "password", null);
insert into messages (messengerid, messageeid, subject,message) values ('1', "3", "Accept Follow Request", "Please accept");
insert into messages (messengerid, messageeid, subject,message) values ('1', "4", "Hello", "I have some news, call me");
insert into messages (messengerid, messageeid, subject,message) values ('1', "5", "Follow him", "Lewis is online now");
insert into messages (messengerid, messageeid, subject,message) values ('2', "4", "Remarks", "Update your jobs");
insert into messages (messengerid, messageeid, subject,message) values ('5', "6", "Touching base", "Hey there!");
insert into messages (messengerid, messageeid, subject,message) values ('6', "3", "Accept Follow Request", "Done");
insert into messages (messengerid, messageeid, subject,message) values ('4', "1", "Accept Follow Request", "Not sure if I know you?");
insert into messages (messengerid, messageeid, subject,message) values ('1', "6", "Unfollow 'cos", "I am quitting");
insert into messages (messengerid, messageeid, subject,message) values ('5', "2", "Its time to call", "Response needed");
<commit_msg>added more messages for dummby data<commit_after>INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'GreggyP', 'User1',1);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'BobbyK', 'User2',2);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', '<PASSWORD>', 'User3',3);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'JohnnyM', 'User4',4);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'MarcC', 'User5',5);
INSERT INTO user (username, fullname,password, photoid) values ('<EMAIL>', 'Joe Sixpack', 'password',6);
Insert into post (userid, post, photoid) values (1,'I am the man!', 6);
Insert into post (userid, post, photoid) values (2,'Reboot it!!', 7);
Insert into post (userid, post, photoid) values (3,'User 3 First Post', 8);
Insert into post (userid, post, photoid) values (4,'User 4 First Post', 9);
Insert into post (userid, post, photoid) values (1,'User 1 Second Post', 10);
Insert into post (userid, post, photoid) values (1,'User 1 Third Post', 11);
Insert into post (userid, post, photoid) values (5,'User 5 First Post', 12);
Insert Into post (userid, referencepost, post) values (2, 1, 'no Im the man!!');
Insert Into post (userid, referencepost, post) values (4, 2, 'you said it');
Insert Into post (userid, referencepost, post) values (1, 3, 'Comment on post id 3');
Insert Into post (userid, referencepost, post) values (1, 4, 'Comment on post id 4');
Insert Into post (userid, referencepost, post) values (1, 1, 'Comment on post id 1 Again');
Insert Into post (userid, referencepost, post) values (2, 1, 'Comment on post id 1 Yet Again');
Insert into following (followerid, followeeid) values (1, 1);
Insert into following (followerid, followeeid) values (1, 2);
Insert into following (followerid, followeeid) values (2, 2);
Insert into following (followerid, followeeid) values (2, 1);
Insert into following (followerid, followeeid) values (4, 1);
Insert into following (followerid, followeeid) values (2, 3);
Insert into following (followerid, followeeid) values (2, 4);
Insert into following (followerid, followeeid) values (1, 5);
Insert into following (followerid, followeeid) values (5, 1);
Insert Into likes (likerid, likeeid, postid) values (2,1,1);
Insert Into likes (likerid, likeeid, postid) values (1,2,2);
Insert Into photo (photoname, mimetype) values ('User1.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User2.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User3.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User4.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('User5.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('theman.jpg','Image/Jpeg');
Insert Into photo (photoname, mimetype) values ('reboot.jpg','Image/Jpeg');
Insert Into messages (messengerid, messageeid, subject, message) values ('1','2','first subject', 'first message text');
Insert Into education (userid, school, datestart, datefinished, degree) values (1,'University of Viriginia','10/1/2009', '6/1/2013','BS in Information System');
Insert Into education (userid, school, datestart, datefinished, degree) values (1,'University of Maryland','9/1/2013', '6/1/2015','MS in Computer Science');
Insert Into education (userid, school, datestart, datefinished, degree) values (2,'University of Phoenix','10/1/2011', '6/1/2015','BS');
Insert Into education (userid, school, datestart, datefinished, degree) values (3,'University of California Santa Cruz','10/1/2011', '6/1/2015','BS');
Insert Into education (userid, school, datestart, datefinished, degree) values (4,'University of Georgia','10/1/2011', '6/1/2015','BS');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (1,'<NAME>', 'cook', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (1,'Dominos','driver', '10/1/2006', '6/1/2009');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (2,'Walmart', 'stocker', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (3,'Best Buy','geek squad', '10/1/2004', '6/1/2006');
Insert Into jobs (userid, joblocation, jobtitle, datestart, datefinished) values (4,'Target', 'cashier', '10/1/2004', '6/1/2006');
Insert Into skills (userid, skill, skilldesc) values (1,'J2EE', 'J2EE Skills');
Insert Into skills (userid, skill, skilldesc) values (1,'.Net','.Net Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'C++', 'MFC Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'Perl','Perl Programming');
Insert Into skills (userid, skill, skilldesc) values (1,'HTML', 'Web Programming');
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hooli Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Google Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Apple Computer", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "P<NAME>per, a Compression Company", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Microsoft", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Oracle", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Mutiny", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "Hewlett Packard Inc.", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "<PASSWORD>", "password", null);
insert into user (username, fullname, password, photoid) values ('<EMAIL>', "<PASSWORD>", "password", null);
insert into messages (messengerid, messageeid, subject,message) values ('3', "1", "Accept Follow Request", "Please accept");
insert into messages (messengerid, messageeid, subject,message) values ('1', "4", "Hello", "I have some news, call me");
insert into messages (messengerid, messageeid, subject,message) values ('5', "1", "Follow him", "Lewis is online now");
insert into messages (messengerid, messageeid, subject,message) values ('2', "4", "Remarks", "Update your jobs");
insert into messages (messengerid, messageeid, subject,message) values ('5', "6", "Touching base", "Hey there!");
insert into messages (messengerid, messageeid, subject,message) values ('6', "1", "Accept Follow Request", "Done");
insert into messages (messengerid, messageeid, subject,message) values ('4', "1", "Accept Follow Request", "Not sure if I know you?");
insert into messages (messengerid, messageeid, subject,message) values ('1', "6", "Unfollow 'cos", "I am quitting");
insert into messages (messengerid, messageeid, subject,message) values ('5', "2", "Its time to call", "Response needed");

{'fraction_non_alphanumeric': 0.16404190123280837, 'fraction_numerical': 0.03477517280695504, 'mean_word_length': 6.933295647258338, 'pattern_counts': {'":': 0, '<': 42, '<?xml version=': 0, '>': 42, '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': '6304313', 'n_tokens_mistral': 4602, 'n_tokens_neox': 4320, 'n_words': 1650}