<commit_before>-- Data loaded into the testing database by runit.sh
--
-- These data are used by the acceptance testing.

--
-- We'll use two sample clients: app1 and app2
--
-- The password for app1 is <PASSWORD>password1, for app2 is <PASSWORD>password2
INSERT INTO clients (client_id, client_secret, confidential, redirect_url, name, description, app_url)
VALUES ( '5641ea27-1111-1111-1111-8fc06b502be0'
       , '14|8|1|k9we3Gaz58OYpKBC/cmzec+7UK0c5lp087aSHNssUVk=|bN0aQhnJq3wcX0EqNb8Y9ObupNqd4gVXQjm9KpTPyEyF5uAmX5jSxZWDe2dIY1VfFAHqiNMvd2dyUrXR5qbQeg=='
       , true
       , '{"http://app1.example.com/oauth2/redirect"}'
       , 'App 1'
       , 'Application One'
       , 'http://app1.example.com/'
       );
INSERT INTO clients (client_id, client_secret, confidential, redirect_url, name, description, app_url)
VALUES ( '5641ea27-2222-2222-2222-8fc06b502be0'
       , '14|8|<KEY>
       , true
       , '{"http://app2.example.com/oauth2/redirect"}'
       , 'App 2'
       , 'Application Two'
       , 'http://app2.example.com/'
       );

-- Valid bearer, valid refresh.
WITH parent AS (
    INSERT INTO tokens (token, token_type, scope, created, expires, client_id, user_id)
    VALUES ( 'hBC86fa6py9nDYMNNZAOfkseAJlN5WvnEmelbCuAUOqOYhYan8N7EgZh6b6k7DpWF6j9DomLlaGZ'
           , 'refresh'
           , '{"login", "profile"}'<commit_msg>Fix acceptance test breakage<commit_after>-- Data loaded into the testing database by runit.sh
--
-- These data are used by the acceptance testing.

--
-- We'll use two sample clients: app1 and app2
--
-- The password for app1 is <PASSWORD>, for app2 is <PASSWORD>
INSERT INTO clients (client_id, client_secret, confidential, redirect_url, name, description, app_url, scope, status)
VALUES ( '5641ea27-1111-1111-1111-8fc06b502be0'
       , '14|8|1|k9we3Gaz58OYpKBC/cmzec+7UK0c5lp087aSHNssUVk=|bN0aQhnJq3wcX0EqNb8Y9ObupNqd4gVXQjm9KpTPyEyF5uAmX5jSxZWDe2dIY1VfFAHqiNMvd2dyUrXR5qbQeg=='
       , true
       , '{"http://app1.example.com/oauth2/redirect"}'
       , 'App 1'
       , 'Application One'
       , 'http://app1.example.com/'
       , '{"verify_token", "<PASSWORD>"}'
       , 'active'
       );

INSERT INTO clients (client_id, client_secret, confidential, redirect_url, name, description, app_url, scope, status)
VALUES ( '5641ea27-2222-2222-2222-8fc06b502be0'
       , '14|8|1|lbTHuvsPLe453j6mAWyOLm/h0uOzCqH9nbh2nl2Yfxw=|<KEY>
       , true
       , '{"http://app2.example.com/oauth2/redirect"}'
       , 'App 2'
       , 'Application Two'
       , 'http://app2.example.com/'
       , '{"verify_token", "<PASSWORD>"}'
       , 'active'
       );

INSERT INTO clients (client_id, client_secret, confidential, redirect_url, name, description, app_url, scope, status)
VALUES ( '5641ea27-3333-3333-3333-8fc06b502be0'
       , '14|8|1|mLvYruvAFoAmsFfDO5TdVKBXTzQ4Zr4CjocZTJ8IP1g=|7i1hLbWSRXliD9Ug++t9EMv0Jrz6LhjNipmFdJLu11vHl3nkuJ5jqWYjUEcO6/fZw61RA8huUvdlc2yEeRckzg=='
       , true
       , '{"http://app3.example.com/oauth2/redirect"}'
       , 'App 3'
       , 'Application Three'
       , 'http://app3.example.com/'
       , '{"verify_token", "<PASSWORD>"}'
       , 'deleted'
       );

-- Valid bearer, valid refresh.
WITH parent AS (
    INSERT INTO tokens (token, token_type, scope, created, expires, client_id, user_id)
    VALUES ( '<KEY>'
           , 'refresh'
           , '{"login", "profile"}'
{'fraction_non_alphanumeric': 0.13410645257210824, 'fraction_numerical': 0.07731192387749034, 'mean_word_length': 3.3745123537061117, 'pattern_counts': {'":': 0, '<': 13, '<?xml version=': 0, '>': 13, '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': '5421540', 'n_tokens_mistral': 1469, 'n_tokens_neox': 1340, 'n_words': 231}