<commit_before>INSERT INTO Search VALUES("123", 3, "microsoft", "", "", "pending", "wentao", "veloz");
INSERT INTO Search VALUES("456", 2, "interior designer", "", "", "pending", "wentao", "veloz");
UPDATE Search SET search_progress = 'pending' WHERE search_id = 123;

SELECT * FROM Email;
SELECT * FROM Customer;

SELECT * FROM Search;


SELECT * FROM Result;

INSERT INTO Result VALUES("789", "https://www.linkedin.com/in/annie-thomas-harrison-a0103354/");





-- after create db, excute these queries;
Insert into Linkedin_Account VALUES('adam','<EMAIL>','5056Veloz');
Insert into Internal_Company VALUES('CT','Custom Tobacco','adam');
Insert into Internal_Company VALUES('BHC','Beverly Hills Chairs','adam');
Insert into User VALUES('ryan','ryan','123');
Insert into User VALUES('caitlin','caitlin','123');


-- create some test data into db
Insert into Templete VALUES('1',"templete1","content1");
Insert into Templete VALUES('2',"templete2","content2");
Insert into Compaign VALUES('0','CT','1');
Insert into Customer VALUES('testurl1','Kobe','ceo','los angeles','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Customer VALUES('testurl2','James','ceo','cleveland','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Customer VALUES('testurl3','Tim','ceo','texas','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Company VALUES('baller','baller.com');
insert into Employment VALUES('testurl1','baller');
insert into Employment VALUES('testurl2','baller');
insert into Employment VALUES('testurl3','baller');
insert into Email VALUES('<EMAIL>','testurl1','baller','0');
insert into Email VALUES('<EMAIL>','testurl1','baller','0');
insert into Email VALUES('<EMAIL>','testurl1','baller','0');
insert into Email VALUES('<EMAIL>','testurl2','baller','0');
insert into Email VALUES('<EMAIL>','testurl2','baller','0');
insert into Email VALUES('<EMAIL>','testurl2','baller','0');
insert into Email VALUES('<EMAIL>','testurl3','baller','2');
insert into Result Values('20170621234247153','testurl1');
Insert into Result Values('20170621234247153','testurl2');
Insert into Result Values('20170621234247153','testurl3');
insert into Result Values('20170621234247153','testurl1');
Insert into Result Values('20170621234247153','testurl2');
Insert into Result Values('20170621234247153','testurl3');

update Search set search_progress="completed" where search_id="20170621234247153";
update Search set search_progress="processing" where search_id="20170621234436192";<commit_msg>database<commit_after>INSERT INTO Search VALUES("123", 3, "microsoft", "", "", "pending", "wentao", "veloz");
INSERT INTO Search VALUES("456", 2, "interior designer", "", "", "pending", "wentao", "veloz");
UPDATE Search SET search_progress = 'pending' WHERE search_id = 123;

SELECT * FROM Email;
SELECT * FROM Customer;

SELECT * FROM Search;


SELECT * FROM Result;

INSERT INTO Result VALUES("789", "https://www.linkedin.com/in/annie-thomas-harrison-a0103354/");





-- after create db, excute these queries;
Insert into Linkedin_Account VALUES('adam','<EMAIL>','5056Veloz');
Insert into Internal_Company VALUES('CT','Custom Tobacco','adam');
Insert into Internal_Company VALUES('BHC','Beverly Hills Chairs','adam');
Insert into User VALUES('ryan','ryan','123');
Insert into User VALUES('caitlin','caitlin','123');


-- create some test data into db
Insert into Templete VALUES('1',"templete1","content1");
Insert into Templete VALUES('2',"templete2","content2");
Insert into Compaign VALUES('0','CT','1');
Insert into Customer VALUES('testurl1','Kobe','ceo','los angeles','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Customer VALUES('testurl2','James','ceo','cleveland','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Customer VALUES('testurl3','Tim','ceo','texas','ceo','2017-06-18','2017-06-19','CT','0');
Insert into Customer VALUES('testurl4','Tony','ceo','texas','ceo','2017-06-18','2017-06-19','CT','0');

Insert into Company VALUES('baller','baller.com');
insert into Employment VALUES('testurl1','baller');
insert into Employment VALUES('testurl2','baller');
insert into Employment VALUES('testurl3','baller');
insert into Employment VALUES('testurl4','baller');

insert into Email VALUES('<EMAIL>','testurl1','baller','0');
insert into Email VALUES('kobe24<EMAIL>','testurl1','baller','0');
insert into Email VALUES('<EMAIL>','testurl1','baller','0');



insert into Email VALUES('<EMAIL>','testurl2','baller','0');
insert into Email VALUES('<EMAIL>','testurl2','baller','0');
insert into Email VALUES('<EMAIL>','testurl2','baller','0');


insert into Email VALUES('<EMAIL>','testurl3','baller','2');
insert into Result Values('20170621234247153','testurl1');
Insert into Result Values('20170621234247153','testurl2');
Insert into Result Values('20170621234247153','testurl3');
Insert into Result Values('20170621234247153','testurl4');


update Search set search_progress="completed" where search_id="20170621234247153";
update Search set search_progress="processing" where search_id="20170621234436192";
{'fraction_non_alphanumeric': 0.19797055312375647, 'fraction_numerical': 0.0972940708316753, 'mean_word_length': 9.407867494824016, 'pattern_counts': {'":': 0, '<': 19, '<?xml version=': 0, '>': 19, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, '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': '910176', 'n_tokens_mistral': 1890, 'n_tokens_neox': 1508, 'n_words': 367}