<commit_before>UPDATE
  mac_pool_ranges
SET
  from_mac = (
              SELECT
                string_agg(a, ':')
              FROM (
                    SELECT
                      regexp_replace(regexp_split_to_table(from_mac, ':'), '^(.)$', '0\1') AS a
                    ) AS b
              ),
  to_mac = (
              SELECT
                string_agg(a, ':')
              FROM (
                    SELECT
                      regexp_replace(regexp_split_to_table(to_mac, ':'), '^(.)$', '0\1') AS a
                    ) AS b
              )
;<commit_msg>core: fix badly generated macs in db<commit_after>UPDATE
  mac_pool_ranges
SET
  from_mac = ( SELECT
                substr(
                  regexp_replace(
                    lpad(replace(from_mac, ':', ''),
                      12,
                      '0'),
                    '(..)',
                    '\1:',
                    'g'),
                1,
                17)
              ),
  to_mac = (SELECT
              substr(
                regexp_replace(
                  lpad(replace(to_mac, ':', ''),
                    12,
                    '0'),
                  '(..)',
                  '\1:',
                  'g'),
              1,
              17)
            )
;
{'fraction_non_alphanumeric': 0.1188976377952756, 'fraction_numerical': 0.014173228346456693, 'mean_word_length': 0.7363387978142076, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '4228020', 'n_tokens_mistral': 371, 'n_tokens_neox': 327, 'n_words': 56}