<commit_before>SELECT fn_recipe_flg           AS fn_recipe_flg,
       food_code               AS code,
       food_desc               AS name,
       group_c                 AS cnf_code,
       canada_food_subgroup_id AS cfg_code,
       NULL                    AS cfg_code_commit_date,
       NULL                    AS energy_kcal,
       NULL                    AS sodium_amount_per_100g,
       NULL                    AS sodium_imputation_reference,
       NULL                    AS sodium_imputation_date,
       NULL                    AS sugar_amount_per_100g,
       NULL                    AS sugar_imputation_reference,
       NULL                    AS sugar_imputation_date,
       NULL                    AS transfat_amount_per_100g,
       NULL                    AS transfat_imputation_reference,
       NULL                    AS transfat_imputation_date,
       NULL                    AS satfat_amout_per_100g,
       NULL                    AS satfat_imputation_reference,
       NULL                    AS satfat_imputation_date,
       NULL                    AS totalfat_amout_per_100g,
       NULL                    AS totalfat_imputation_reference,
       NULL                    AS totalfat_imputation_date,
       NULL                    AS contains_added_sodium,
       NULL                    AS contains_added_sodium_commit_date,
       NULL                    AS contains_added_sugar,
       NULL                    AS contains_added_sugar_commit_date,
       NULL                    AS contains_free_sugars,
       NULL                    AS contains_free_sugars_commit_date,
       NULL                    AS contains_added_fat,
       NULL                    AS contains_added_fat_commit_date,
       NULL                    AS contains_added_transfat,
       NULL                    AS contains_added_transfat_commit_date,
       NULL                    AS contains_caffeine,
       NULL                    AS contains_caffeine_commit_date,
       NULL                    AS contains_sugar_substitutes,
       NULL                    AS contains_sugar_substitutes_commit_date,
       NULL                    AS reference_amount_g,
       NULL                    AS reference_amount_measure,
       NULL                    AS reference_amount_commit_date,
       NULL                    AS food_guide_serving_g,
       NULL                    AS food_guide_serving_measure,
       NULL                    AS food_guide_commit_date,
       NULL                    AS tier_4_serving_g,
       NULL                    AS tier_4_serving_measure,
       NULL                    AS tier_4_serving_commit_date,
       NULL                    AS rolled_up,
       NULL                    AS rolled_up_commit_date,
       NULL                    AS apply_small_ra_adjustment,
       NULL                    AS comments
  FROM food_name
<commit_msg>latest canada_food_guide_food_name tbl data model<commit_after>SELECT canada_food_guide_food_name.fn_recipe_flg,
       code,
       name,
       cnf_code,
       cfg_code,
       cfg_code_commit_date,
       energy_kcal,
       sodium_amount_per_100g,
       sodium_imputation_reference,
       sodium_imputation_date,
       sugar_amount_per_100g,
       sugar_imputation_reference,
       sugar_imputation_date,
       transfat_amount_per_100g,
       transfat_imputation_reference,
       transfat_imputation_date,
       satfat_amout_per_100g,
       satfat_imputation_reference,
       satfat_imputation_date,
       totalfat_amout_per_100g,
       totalfat_imputation_reference,
       totalfat_imputation_date,
       contains_added_sodium,
       contains_added_sodium_commit_date,
       contains_added_sugar,
       contains_added_sugar_commit_date,
       contains_free_sugars,
       contains_free_sugars_commit_date,
       contains_added_fat,
       contains_added_fat_commit_date,
       contains_added_transfat,
       contains_added_transfat_commit_date,
       contains_caffeine,
       contains_caffeine_commit_date,
       contains_sugar_substitutes,
       contains_sugar_substitutes_commit_date,
       reference_amount_g,
       reference_amount_measure,
       reference_amount_commit_date,
       food_guide_serving_g,
       food_guide_serving_measure,
       food_guide_commit_date,
       tier_4_serving_g,
       tier_4_serving_measure,
       tier_4_serving_commit_date,
       rolled_up,
       rolled_up_commit_date,
       apply_small_ra_adjustment,
       comments
  FROM food_name
  JOIN canada_food_guide_food_name
    ON (canada_food_guide_food_name.code = food_name.food_code)

{'fraction_non_alphanumeric': 0.023519163763066203, 'fraction_numerical': 0.0078397212543554, 'mean_word_length': 1.5687919463087248, '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': '2371829', 'n_tokens_mistral': 1355, 'n_tokens_neox': 1221, 'n_words': 211}