<commit_before>news_source_id := (select id from news_source where name = 'PTI' and locale = 'en');
update news_integration set "config" = '{
    "url": "http://www.ptinews.com/",
    "linkSelector": ".RightCatDiv :first-of-type .catBottomHead",
    "maxCacheSize": 6
}' where "newsSourceId" = news_source_id;
update news_source set "headlineSelectors" = '{
    "#liheading"
}' where "id" = news_source_id;
<commit_msg>bugfix: need to use a block<commit_after>do $$
  declare news_source_id integer;
  begin
    news_source_id := (select id from news_source where name = 'PTI' and locale = 'en');
    update news_integration set "config" = '{
        "url": "http://www.ptinews.com/",
        "linkSelector": ".RightCatDiv :first-of-type .catBottomHead",
        "maxCacheSize": 6
    }' where "newsSourceId" = news_source_id;
    update news_source set "headlineSelectors" = '{
        "#liheading"
    }' where "id" = news_source_id;
  end
$$

{'fraction_non_alphanumeric': 0.1439153439153439, 'fraction_numerical': 0.0021164021164021165, 'mean_word_length': 3.826530612244898, 'pattern_counts': {'":': 6, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, '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': '5624143', 'n_tokens_mistral': 320, 'n_tokens_neox': 315, 'n_words': 79}