如何在Django后台使用存储过程？

from django.db import connection

def call_stored_procedure():
    with connection.cursor() as cursor:
        cursor.callproc('your_stored_procedure_name', [param1, param2])
        results = cursor.fetchall()
    return results

from django.db.models.signals import post_save
from django.dispatch import receiver
from yourapp.models import YourModel

@receiver(post_save, sender=YourModel)
def call_procedure_on_save(sender, instance, **kwargs):
    with connection.cursor() as cursor:
        cursor.callproc('your_stored_procedure_name', [instance.some_field])

# yourapp/management/commands/callprocedure.py
from django.core.management.base import BaseCommand
from django.db import connection

class Command(BaseCommand):
    help = 'Calls a stored procedure'

    def handle(self, *args, **options):
        with connection.cursor() as cursor:
            cursor.callproc('your_stored_procedure_name', [arg1, arg2])
            results = cursor.fetchall()
            self.stdout.write(self.style.SUCCESS(f'Stored procedure executed successfully: {results}'))

CREATE OR REPLACE FUNCTION add_numbers(a INTEGER, b INTEGER) RETURNS INTEGER AS $$
BEGIN
    RETURN a + b;
END;
$$ LANGUAGE plpgsql;

from django.db import connection

def add_two_numbers(x, y):
    with connection.cursor() as cursor:
        cursor.callproc('add_numbers', [x, y])
        result = cursor.fetchone()[0]
    return result