带有--keepdb的django测试用例不会在测试之间重置对象ids

from django.db import connection
from myapp.models import MyModel

def reset_id_sequence(model):
    with connection.cursor() as cursor:
        cursor.execute(f"SELECT setval('{model._meta.db_table}_id_seq', (SELECT MAX(id) FROM {model._meta.db_table}));")

class MyTestCase(TestCase):
    def tearDown(self):
        super().tearDown()
        reset_id_sequence(MyModel)

# settings.py
TEST_RUNNER = 'django.test.runner.DiscoverRunner'

from django.test import TransactionTestCase

class MyTransactionTestCase(TransactionTestCase):
    # 测试代码

from django.test import TestCase
from myapp.models import MyModel

class MyModelTests(TestCase):
    def setUp(self):
        MyModel.objects.create(name="Test Item")

    def test_model_creation(self):
        item = MyModel.objects.get(name="Test Item")
        self.assertEqual(item.id, 1)

    def tearDown(self):
        # 手动重置 ID 序列
        from django.db import connection
        with connection.cursor() as cursor:
            cursor.execute("SELECT setval('myapp_mymodel_id_seq', (SELECT MAX(id) FROM myapp_mymodel));")