<commit_before>SET @username="<%= @settings['gerrit_admin_username'] %>";
SET @mail="<%= @settings['gerrit_admin_mail'] %>";
SET @pubkey="<%= @settings['gerrit_admin_sshkey'] %>";
SET @pubkey2="<%= @settings['gerrit_local_sshkey'] %>";

INSERT INTO account_external_ids VALUES (1,@mail,NULL,CONCAT('gerrit:',@username)),(1,NULL,NULL,CONCAT('username:', @username));
INSERT INTO account_group_members VALUES (1,1),(1,6);
INSERT INTO account_group_members_audit VALUES (1,NULL,NULL,1,CURRENT_TIMESTAMP(),1),(1,NULL,NULL,1,CURRENT_TIMESTAMP(),6);
INSERT INTO account_id VALUES (1);
INSERT INTO account_ssh_keys VALUES (@pubkey,'Y',1,1);
INSERT INTO accounts VALUES (NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,'SSH',25,'N','N','Y','N',NULL,'Y','N',@mail,CURRENT_TIMESTAMP(),1);

INSERT INTO account_ssh_keys VALUES(@pubkey2,'Y',1,2);<commit_msg>Fix duplicate key for admin user in database<commit_after>SET @username="<%= @settings['gerrit_admin_username'] %>";
SET @mail="<%= @settings['gerrit_admin_mail'] %>";
SET @pubkey="<%= @settings['gerrit_admin_sshkey'] %>";
SET @pubkey2="<%= @settings['gerrit_local_sshkey'] %>";

INSERT INTO account_external_ids VALUES (1,@mail,NULL,CONCAT('gerrit:',@username)),(1,NULL,NULL,CONCAT('username:', @username));
INSERT INTO account_group_members VALUES (1,1);
INSERT INTO account_group_members_audit VALUES (1,NULL,NULL,1,CURRENT_TIMESTAMP(),1),(1,NULL,NULL,1,CURRENT_TIMESTAMP(),6);
INSERT INTO account_id VALUES (1);
INSERT INTO account_ssh_keys VALUES (@pubkey,'Y',1,1);
INSERT INTO accounts VALUES (NULL,NULL,NULL,NULL,'N',NULL,NULL,NULL,'SSH',25,'N','N','Y','N',NULL,'Y','N',@mail,CURRENT_TIMESTAMP(),1);

INSERT INTO account_ssh_keys VALUES(@pubkey2,'Y',1,2);
{'fraction_non_alphanumeric': 0.20953502060035314, 'fraction_numerical': 0.024720423778693348, 'mean_word_length': 14.178571428571429, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 11, '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': '2274680', 'n_tokens_mistral': 661, 'n_tokens_neox': 597, 'n_words': 100}