<commit_before>DELETE FROM "icds_dashboard_daily_feeding_forms" WHERE month=%(month)s AND state_id = %(state)s
{"month": "2019-01-01", "state": "st1"}

        INSERT INTO "icds_dashboard_daily_feeding_forms" (
          state_id, supervisor_id, month, case_id, latest_time_end_processed,
          sum_attended_child_ids, lunch_count
        ) (
          SELECT DISTINCT ON (ucr.child_health_case_id)
            %(state_id)s AS state_id,
            ucr.supervisor_id,
            %(month)s AS month,
            ucr.child_health_case_id AS case_id,
            MAX(ucr.timeend) OVER w AS latest_time_end_processed,
            SUM(ucr.attended_child_ids) OVER w AS sum_attended_child_ids,
            SUM(ucr.lunch) OVER w AS lunch_count
          FROM "ucr_icds-cas_dashboard_child_health_daily_2cd9a7c1" ucr INNER JOIN daily_attendance ON (
            ucr.doc_id = daily_attendance.doc_id AND
            ucr.supervisor_id = daily_attendance.supervisor_id AND
            daily_attendance.month=%(current_month_start)s
          )
          WHERE ucr.state_id = %(state_id)s AND
                ucr.timeend >= %(current_month_start)s AND ucr.timeend < %(next_month_start)s AND
                ucr.child_health_case_id IS NOT NULL
          WINDOW w AS (PARTITION BY ucr.supervisor_id, ucr.child_health_case_id)
        )
        
{"current_month_start": "2019-01-01", "month": "2019-01-01", "next_month_start": "2019-02-01", "state_id": "st1"}<commit_msg>Update SQL output for tests<commit_after>DELETE FROM "icds_dashboard_daily_feeding_forms" WHERE month=%(month)s
{"month": "2019-01-01"}

        INSERT INTO "icds_dashboard_daily_feeding_forms" (
          state_id, supervisor_id, month, case_id, latest_time_end_processed,
          sum_attended_child_ids, lunch_count
        ) (
          SELECT DISTINCT ON (ucr.child_health_case_id)
            ucr.state_id AS state_id,
            ucr.supervisor_id,
            %(month)s AS month,
            ucr.child_health_case_id AS case_id,
            MAX(ucr.timeend) OVER w AS latest_time_end_processed,
            SUM(ucr.attended_child_ids) OVER w AS sum_attended_child_ids,
            SUM(ucr.lunch) OVER w AS lunch_count
          FROM "ucr_icds-cas_dashboard_child_health_daily_2cd9a7c1" ucr INNER JOIN daily_attendance ON (
            ucr.doc_id = daily_attendance.doc_id AND
            ucr.supervisor_id = daily_attendance.supervisor_id AND
            daily_attendance.month=%(current_month_start)s
          )
          WHERE ucr.timeend >= %(current_month_start)s AND ucr.timeend < %(next_month_start)s AND
                ucr.child_health_case_id IS NOT NULL
          WINDOW w AS (PARTITION BY ucr.supervisor_id, ucr.child_health_case_id)
        )
        
{"current_month_start": "2019-01-01", "month": "2019-01-01", "next_month_start": "2019-02-01"}
{'fraction_non_alphanumeric': 0.0872791519434629, 'fraction_numerical': 0.026148409893992933, 'mean_word_length': 2.7696404793608522, 'pattern_counts': {'":': 10, '<': 5, '<?xml version=': 0, '>': 5, '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': '2022017', 'n_tokens_mistral': 1036, 'n_tokens_neox': 961, 'n_words': 181}