import json

from django.contrib.auth.models import User

from gui.models import Comments, Post

file = open('db.json')

dado = json.loads(file)


users = dados['users']

for u in users:
  user = User()
  user.username = u['username']
  user.email = u['email']
  user.password = 'abcd@1234'
  user.save()

posts = dados['posts']

for p in posts:
  post = Post()
  post.user = User.objects.get(pk=p['userId'])
  post.body = p.get('body') or 'sem corpo'
  post.title = p.get('title') or 'sem title'
  post.save()

comments  = dados['comments']
for c in comments:
  com = Comments()
  com.name = c['name']
  com.email = c['email']
  com.body = c['body']
  com.post = Post.objects.get(pk=c['postId'])
  com.save()