<commit_before>-- --------------------------------------- --
--             InComb Data SQL             --
--                                         --
--   Please execute the schema.sql first.  --
-- --------------------------------------- --

-- Test Users --
-- Password is "<PASSWORD>-"
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (1, '<EMAIL>', '<PASSWORD>', 'Test1_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (2, '<EMAIL>', '<PASSWORD>', 'Test1_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (3, '<EMAIL>', '<PASSWORD>', '<PASSWORD>_<PASSWORD>', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (4, '<EMAIL>', '<PASSWORD>', 'Test3_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (5, '<EMAIL>', 'test4', 'Test4_Display', '<PASSWORD>', 'e<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (6, '<EMAIL>', '<PASSWORD>', 'Test5_Display', '<PASSWORD>', 'e<PASSWORD>78<PASSWORD>', '2014-12-27 21:47:43', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (7, '<EMAIL>', 'test6', 'Test6_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-27 21:47:43', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (8, '<EMAIL>', '<PASSWORD>', 'Test7_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (9, '<EMAIL>', 'test8', 'Test8_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-26 22:32:14', 0);
INSERT INTO `user` (`id`, `email`, `username`, `display_name`, `password_hash`, `salt`, `register_date`, `deleted`) VALUES (10, '<EMAIL>', 'test9', 'Test9_Display', '<PASSWORD>', '<PASSWORD>', '2014-12-27 21:47:43', 0);


-- fly withs --
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 2, '2015-01-04 01:26:34');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 3, '2015-01-04 01:26:45');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 4, '2015-01-04 01:26:48');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 5, '2015-01-04 01:26:51');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 6, '2015-01-04 01:26:55');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 7, '2015-01-04 01:26:35');

-- Modules --
INSERT INTO incomb.module (id, name_key, image_path, template_path) VALUES(1, "modules.news", "", "");

-- Categories --
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(1, 1, "categories.news.switzerland", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(2, 1, "categories.news.worldNews", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(3, 1, "categories.news.sport", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(4, 1, "categories.news.economy", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(5, 1, "categories.news.digital", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(6, 1, "categories.news.health", "");

INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 1, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 2, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 3, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 4, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 5, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 6, 1.0);


-- Providers --
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 1, "20 Minuten", "/img/providers/20min.png", "http://www.20min.ch");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 2, "Blick", "/img/providers/blick.png", "http://www.blick.ch");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 3, "Die Welt", "/img/providers/diewelt.png", "http://www.welt.de");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 4, "Engadget", "/img/providers/engadget.png", "http://www.engadget.com/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 5, "Frankfurter Allgemeine Zeitung", "/img/providers/faz.png", "http://www.faz.net/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 6, "Golem", "/img/providers/golem.png", "http://www.golem.de/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 7, "Microsoft", "/img/providers/microsoft.png", "http://www.microsoft.com");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 8, "New York Times", "/img/providers/newyorktimes.png", "http://www.nytimes.com/");<commit_msg>Removed test users from data.sql<commit_after>-- --------------------------------------- --
--             InComb Data SQL             --
--                                         --
--   Please execute the schema.sql first.  --
-- --------------------------------------- --

-- fly withs --
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 2, '2015-01-04 01:26:34');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 3, '2015-01-04 01:26:45');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 4, '2015-01-04 01:26:48');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 5, '2015-01-04 01:26:51');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 6, '2015-01-04 01:26:55');
INSERT INTO `fly_with` (`user_id`, `fly_with_id`, `fly_with_start_date`) VALUES (1, 7, '2015-01-04 01:26:35');

-- Modules --
INSERT INTO incomb.module (id, name_key, image_path, template_path) VALUES(1, "modules.news", "", "");

-- Categories --
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(1, 1, "categories.news.switzerland", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(2, 1, "categories.news.worldNews", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(3, 1, "categories.news.sport", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(4, 1, "categories.news.economy", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(5, 1, "categories.news.digital", "");
INSERT INTO incomb.category (id, module_id, name_key, image_path) VALUES(6, 1, "categories.news.health", "");

INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 1, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 2, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 3, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 4, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 5, 1.0);
INSERT INTO category_preference (user_id, category_id, factor) VALUES(1, 6, 1.0);

-- Providers --
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 1, "20 Minuten", "/img/providers/20min.png", "http://www.20min.ch");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 2, "Blick", "/img/providers/blick.png", "http://www.blick.ch");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 3, "Die Welt", "/img/providers/diewelt.png", "http://www.welt.de");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 4, "Engadget", "/img/providers/engadget.png", "http://www.engadget.com/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 5, "Frankfurter Allgemeine Zeitung", "/img/providers/faz.png", "http://www.faz.net/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 6, "Golem", "/img/providers/golem.png", "http://www.golem.de/");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 7, "Microsoft", "/img/providers/microsoft.png", "http://www.microsoft.com");
INSERT INTO incomb.provider (id, name, image_path, website) VALUES ( 8, "New York Times", "/img/providers/newyorktimes.png", "http://www.nytimes.com/");
{'fraction_non_alphanumeric': 0.21404241292165696, 'fraction_numerical': 0.051642676628941876, 'mean_word_length': 4.92578125, 'pattern_counts': {'":': 0, '<': 43, '<?xml version=': 0, '>': 43, 'https://': 0, 'lorem ipsum': 0, 'www.': 16, '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': '197869', 'n_tokens_mistral': 3567, 'n_tokens_neox': 3185, 'n_words': 828}