import os
import sys
import time
import django
import json
local_path = os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
print(local_path)
if local_path not in sys.path:
    sys.path.append(local_path)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "kedong.settings")
django.setup()
from django.conf import settings
from smartfarming.models.device import MongoDeviceType
from smartfarming.models.user import UserPurview




with open(os.path.join(local_path, "scripts/test/sa_device_type.json") , 'r', encoding='utf-8') as f:
    sa_device_type = json.load(f)
    for row in sa_device_type.get("rows"):
        MongoDeviceType.objects.get_or_create(
            id=row.get("id"),
            defaults=row
        )