feat(psql): Backfill payouts table where organization_id is null

[bsayak03]

Type of Change

• [ ] Bugfix
• [ ] New feature
• [x] Enhancement
• [ ] Refactoring
• [ ] Dependency updates
• [ ] Documentation
• [ ] CI/CD

Description

organization_id column was recently introduced in the payouts table. Hence, there exists entries in the payout table where organization_id is still NULL. Although the backfilling has been done for HS's hosted ones via running db-migrations but this particular change in the PR is for self-hosted merchants.

Additional Changes

• [ ] This PR modifies the API contract
• [ ] This PR modifies the database schema
• [ ] This PR modifies application configuration/environment variables

Motivation and Context

How did you test it?

Checklist

• [x] I formatted the code cargo +nightly fmt --all
• [x] I addressed lints thrown by cargo clippy
• [x] I reviewed the submitted code
• [x] I added unit tests for my changes where possible

[semanticdiff-com[bot]]

Review changes with  

[codecov[bot]]

Codecov Report

:white_check_mark: All modified and coverable lines are covered by tests. :warning: Please upload report for BASE (main@f5728e9). Learn more about missing BASE report.

Additional details and impacted files

@@           Coverage Diff           @@
##             main   #10210   +/-   ##
=======================================
  Coverage        ?    6.47%           
=======================================
  Files           ?     1251           
  Lines           ?   311515           
  Branches        ?        0           
=======================================
  Hits            ?    20165           
  Misses          ?   291350           
  Partials        ?        0           

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

:rocket: New features to boost your workflow:

• :snowflake: Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
• :package: JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

[bsayak03]

migrations must be DDL queries

We do have a lot of DML queries in our migrations dir currently @hrithikesh026