import sys, os, os.path, time, tempfile, uuid

import json

from django.core.management import setup_environ

from blinkster import settings

import lxml.etree

setup_environ(settings)

from ldt.ldt_utils.models import Media, Content

fp = open(os.path.join(os.path.dirname(os.path.abspath(__file__)),"update_db_0_19_to_0_20_content.json"), "r")

content_list = json.load(fp)

for content_src in content_list:

    #load iri

    #get iri path

    iri_path = os.path.join(settings.MEDIA_ROOT,"media/ldt",content_src['fields']['iri'])

    iri_doc = lxml.etree.parse(iri_path)

    duration = int(iri_doc.xpath("/iri/body/medias/media[@id='video']/video/@dur")[0])

    src = unicode(iri_doc.xpath("/iri/body/medias/media[@id='video']/video/@src")[0])

    media_list = Media.objects.filter(src=src)

    if(len(media_list) > 0):

        media = media_list[0]

    else:

        media = Media(src=src)

    media.update_date=content_src['fields']['update_date']

    media.creation_date=content_src['fields']['creation_date']

    media.title = content_src['fields']['title']

    media.description = content_src['fields']['description']

    media.duration = duration

    media.save()

    iri_id = content_src['fields']['iri_id']

    content_list = Content.objects.filter(iri_id=iri_id)

    if(len(content_list)>0):

        content = content_list[0]

    else:

        content = Content(iri_id=iri_id)

    content.iriurl = content_src['fields']['iri']

    content.title = content_src['fields']['title']

    content.description = content_src['fields']['description']

    content.duration = duration

    content.media_obj = media

    content.save()