<commit_before>BEGIN TRANSACTION;

-- Lights
insert into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) values (1, 'Front Spotlight', 1, 1, 0, 'host1', 8083);
insert into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) values (2, 'Front Lounge', 1, 2, 0, 'host1', 8083);
insert into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) values (3, 'Main Garage', 1, 3, 0, 'host1', 8083);
insert into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) values (4, 'Side Passage', 1, 3, 0, 'host1', 8083);

-- Scenes
insert into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) values (1, 'All On', 'Turns everything on', 1, 1, 'button', 'icon', 'on');
insert into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) values (2, 'All Off', 'Turns everything off', 1, 1, 'button', 'icon', 'off');
insert into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) values (3, 'Arrive At Night', 'Turns on a few lights when we arrive at night', 1, 1, 'button', 'icon', 'on');

-- Lights of scenes
insert into "scenes_lights" (id, scene_id, light_id) values (1, 1, 1);
insert into "scenes_lights" (id, scene_id, light_id) values (2, 1, 2);
insert into "scenes_lights" (id, scene_id, light_id) values (3, 1, 3);
insert into "scenes_lights" (id, scene_id, light_id) values (4, 1, 4);

insert into "scenes_lights" (id, scene_id, light_id) values (5, 2, 1);
insert into "scenes_lights" (id, scene_id, light_id) values (6, 2, 2);
insert into "scenes_lights" (id, scene_id, light_id) values (7, 2, 3);
insert into "scenes_lights" (id, scene_id, light_id) values (8, 2, 4);

insert into "scenes_lights" (id, scene_id, light_id) values (9, 3, 1);

COMMIT;
<commit_msg>Add the user seed data<commit_after>BEGIN TRANSACTION;

-- Lights
INSERT into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) VALUES (1, 'Front Spotlight', 1, 1, 0, 'host1', 8083);
INSERT into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) VALUES (2, 'Front Lounge', 1, 2, 0, 'host1', 8083);
INSERT into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) VALUES (3, 'Main Garage', 1, 3, 0, 'host1', 8083);
INSERT into "lights" (id, name, enabled, device, instance, controllerHost, controllerPort) VALUES (4, 'Side Passage', 1, 3, 0, 'host1', 8083);

-- Scenes
INSERT into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) VALUES (1, 'All On', 'Turns everything on', 1, 1, 'button', 'icon', 'on');
INSERT into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) VALUES (2, 'All Off', 'Turns everything off', 1, 1, 'button', 'icon', 'off');
INSERT into "scenes" (id, name, description, visible, enabled, buttonClass, iconClass, action) VALUES (3, 'Arrive At Night', 'Turns on a few lights when we arrive at night', 1, 1, 'button', 'icon', 'on');

-- Lights of scenes
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (1, 1, 1);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (2, 1, 2);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (3, 1, 3);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (4, 1, 4);

INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (5, 2, 1);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (6, 2, 2);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (7, 2, 3);
INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (8, 2, 4);

INSERT into "scenes_lights" (id, scene_id, light_id) VALUES (9, 3, 1);

-- Users
INSERT into "users" (id, email, screenName, password, enabled) VALUES (1, '<EMAIL>', 'Unicode', 'abc', 1);
INSERT into "users" (id, email, screenName, password, enabled) VALUES (2, '<EMAIL>', 'ASCII', 'abc', 1);

COMMIT;

{'fraction_non_alphanumeric': 0.16139640779155073, 'fraction_numerical': 0.037439919048823676, 'mean_word_length': 5.936842105263158, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, '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': '7407524', 'n_tokens_mistral': 1474, 'n_tokens_neox': 1352, 'n_words': 535}