<commit_before>/**************************************************************
 *
 * Sample Data to Test Methods
 * 
 *************************************************************/

/* <NAME> -- use password '<PASSWORD>' */
INSERT INTO `users`(`user_id`, `user_first_name`, `user_last_name`, `user_city`, `user_state`, `user_email`, `user_password`) 
VALUES ('1', 'John', 'Doe', 'Seattle', 'WA', '<EMAIL>', <PASSWORD>$<PASSWORD>0Cz1c7NO3VnKyI72jR3t.wu6PE9.aCX3p1GDqOOJS.8y.y35F1mO');  

/* <NAME> -- use password '<PASSWORD>' */
INSERT INTO `users`(`user_id`, `user_first_name`, `user_last_name`, `user_city`, `user_state`, `user_email`, `user_password`) 
VALUES ('2', 'Mary', 'Moe', 'Seattle', 'WA', '<EMAIL>', '$2y$10$HB/hDcd1DJ0/XIe90koWr.xwlab/3ODECkECjYtP3JsJkqc5ZPoQW');      
            
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9780316066747', 'Started Early, Took My Dog', 
        '<NAME>', '<NAME>', '2011','https://covers.openlibrary.org/b/id/6935639-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9780525478812', 'The Fault in Our Stars', 
        '<NAME>', 'New York : Dutton Books', '2012','https://covers.openlibrary.org/w/id/7272823-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9781400067695', 'My Name Is <NAME>', 
        '<NAME>', 'New York : Random House', '2016','https://covers.openlibrary.org/w/id/7434845-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9781423160915', 'Magnus Chase and the Gods of Asgard, Book 1: The Sword of Summer', 
        '<NAME>', 'Los Angeles : Disney Hyperion', '2015','https://covers.openlibrary.org/b/id/7358586-M.jpg');


INSERT INTO `user_requests_book`(`user_id`, `isbn`, `entry_date`) 
    VALUES ('1','9780316066747','2017-03-12');   
    
INSERT INTO `user_requests_book`(`user_id`, `isbn`, `entry_date`) 
    VALUES ('1','9781423160915','2017-03-12'); 

INSERT INTO `user_owns_book`(`user_id`, `isbn`, `entry_date`) 
    VALUES ('1','9780525478812','2017-03-12');  

INSERT INTO `user_owns_book`(`user_id`, `isbn`, `entry_date`) 
    VALUES ('1','9781400067695','2017-03-12');  
<commit_msg>removed dates from sample data since these are no longer in db schema<commit_after>/**************************************************************
 *
 * Sample Data to Test Methods
 * 
 *************************************************************/

/* <NAME> -- use password '<PASSWORD>' */
INSERT INTO `users`(`user_id`, `user_first_name`, `user_last_name`, `user_city`, `user_state`, `user_email`, `user_password`) 
VALUES ('1', 'John', 'Doe', 'Seattle', 'WA', '<EMAIL>', <PASSWORD>jR3t.wu6PE9.<PASSWORD>.<PASSWORD>mO');  

/* <NAME> -- use password '<PASSWORD>' */
INSERT INTO `users`(`user_id`, `user_first_name`, `user_last_name`, `user_city`, `user_state`, `user_email`, `user_password`) 
VALUES ('2', 'Mary', 'Moe', 'Seattle', 'WA', '<EMAIL>', '$2y$10$HB/hDcd1DJ0/XIe90koWr.xwlab/3ODECkECjYtP3JsJkqc5ZPoQW');      
            
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9780316066747', 'Started Early, Took My Dog', 
        '<NAME>', '<NAME>', '2011','https://covers.openlibrary.org/b/id/6935639-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9780525478812', 'The Fault in Our Stars', 
        '<NAME>', 'New York : Dutton Books', '2012','https://covers.openlibrary.org/w/id/7272823-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9781400067695', 'My Name Is <NAME>', 
        '<NAME>', 'New York : Random House', '2016','https://covers.openlibrary.org/w/id/7434845-M.jpg');
        
INSERT INTO `book`(`isbn`, `title`, `author`, `publishers`, `publish_date`, `thumbnail_url`) 
VALUES ('9781423160915', '<NAME> and the Gods of Asgard, Book 1: The Sword of Summer', 
        '<NAME>', 'Los Angeles : Disney Hyperion', '2015','https://covers.openlibrary.org/b/id/7358586-M.jpg');


INSERT INTO `user_requests_book`(`user_id`, `isbn`) 
    VALUES ('1','9780316066747');   
    
INSERT INTO `user_requests_book`(`user_id`, `isbn`) 
    VALUES ('1','9781423160915'); 

INSERT INTO `user_owns_book`(`user_id`, `isbn`) 
    VALUES ('1','9780525478812');  

INSERT INTO `user_owns_book`(`user_id`, `isbn`) 
    VALUES ('1','9781400067695');  

{'fraction_non_alphanumeric': 0.25054466230936817, 'fraction_numerical': 0.08278867102396514, 'mean_word_length': 5.16241610738255, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 33, 'https://': 8, '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': '2712914', 'n_tokens_mistral': 1911, 'n_tokens_neox': 1663, 'n_words': 335}