Skip to content

Clean up unused db functions #1933

@exalate-issue-sync

Description

@exalate-issue-sync

Dan identified some unused db functions that we can remove from our db instances on dev, stage, test, and prod. Remove them.

  • FUNCTION public.calculate_calendar_ytd_per_election_office
  • FUNCTION public.calculate_entity_aggregates
  • FUNCTION public.calculate_is_loan
  • FUNCTION public.calculate_itemization
  • FUNCTION public.calculate_loan_date
  • FUNCTION public.calculate_loan_payment_to_date
  • FUNCTION public.calculate_original_loan_id
  • FUNCTION public.get_children_and_grandchildren_transaction_ids
  • FUNCTION public.get_parent_grandparent_transaction_ids
  • FUNCTION public.get_temp_tablename
  • FUNCTION public.handle_parent_itemization
  • FUNCTION public.needs_itemized_set
  • FUNCTION public.process_itemization
  • FUNCTION public.set_itemization_for_ids

We can do this before removing the unamend triggers and avoid rework by ensuring that we remove the unamend functions in the migrations that remove the triggers

QA Notes

null

DEV Notes

null

Design

null

See full ticket and images here: FECFILE-2957

Pull Request: #1946

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions