<commit_before>-- This script adds rights to test Lizmap projects...
INSERT INTO lizmap.jacl2_rights 
VALUES 
-- ...without being logged in first (anonymous group)
('lizmap.repositories.view', '__anonymous', 'testsrepository', 0),
('lizmap.tools.displayGetCapabilitiesLinks', '__anonymous', 'testsrepository', 0),
('lizmap.tools.edition.use', '__anonymous', 'testsrepository', 0),
('lizmap.tools.layer.export', '__anonymous', 'testsrepository', 0),
-- ...for users in admins group
('lizmap.repositories.view', 'admins', 'testsrepository', 0),
('lizmap.tools.displayGetCapabilitiesLinks', 'admins', 'testsrepository', 0),
('lizmap.tools.edition.use', 'admins', 'testsrepository', 0),
('lizmap.tools.layer.export', 'admins', 'testsrepository', 0);
<commit_msg>e2e: add missing rights for filter by polygon test<commit_after>-- This script adds users, groups and rights to test Lizmap projects...

-- Groups
INSERT INTO lizmap.jacl2_group(
	id_aclgrp, name, grouptype, ownerlogin)
	VALUES ('group_a', 'group_a', 0, null),
    ('__priv_user_in_group_a', 'user_in_group_a', 2, 'user_in_group_a');

-- Users
INSERT INTO lizmap.jlx_user(
	usr_login, usr_email, usr_password, status, create_date)
	VALUES ('user_in_group_a', '<EMAIL>', '$2y$10$d2KZfxeYJP0l3YbNyDMZYe2vGSA3JWa8kFJSdecmSEIqInjnunTJ.', 1, NOW());

-- Users in Groups
INSERT INTO lizmap.jacl2_user_group(
	login, id_aclgrp)
	VALUES ('user_in_group_a', 'group_a'),
	('user_in_group_a', '__priv_user_in_group_a'),
	('user_in_group_a', 'users');

-- Rights
INSERT INTO lizmap.jacl2_rights 
VALUES 
-- ...without being logged in first (anonymous group)
('lizmap.repositories.view', '__anonymous', 'testsrepository', 0),
('lizmap.tools.displayGetCapabilitiesLinks', '__anonymous', 'testsrepository', 0),
('lizmap.tools.edition.use', '__anonymous', 'testsrepository', 0),
('lizmap.tools.layer.export', '__anonymous', 'testsrepository', 0),
-- ...for users in admins group
('lizmap.repositories.view', 'admins', 'testsrepository', 0),
('lizmap.tools.displayGetCapabilitiesLinks', 'admins', 'testsrepository', 0),
('lizmap.tools.edition.use', 'admins', 'testsrepository', 0),
('lizmap.tools.layer.export', 'admins', 'testsrepository', 0),
-- ...for users in group_a group
('lizmap.repositories.view', 'group_a', 'testsrepository', 0),
('lizmap.tools.displayGetCapabilitiesLinks', 'group_a', 'testsrepository', 0),
('lizmap.tools.edition.use', 'group_a', 'testsrepository', 0),
('lizmap.tools.layer.export', 'group_a', 'testsrepository', 0);

{'fraction_non_alphanumeric': 0.17323151125401928, 'fraction_numerical': 0.01487138263665595, 'mean_word_length': 6.705882352941177, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, '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': '5323110', 'n_tokens_mistral': 939, 'n_tokens_neox': 888, 'n_words': 194}