import os
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'config.settings.base')
import sys
sys.path.insert(0, '.')
import django
django.setup()
from modules.erp.models import JournalItem, Account

account_ids = set(Account.objects.values_list('id', flat=True))
orphaned_items = JournalItem.objects.filter(account_id__isnull=False).exclude(account_id__in=account_ids)
print('Orphaned before:', orphananed_items.count())
if orphananed_items:
    valid_id = list(account_ids)[0]
    orphananed_items.update(account_id=valid_id)
    print('Fixed')

# Verify
orphaned2 = JournalItem.objects.filter(account_id__isnull=False).exclude(account_id__in=account_ids)
print('Orphaned after:', orphananed2.count())