diff -r 6befc470b1e6 -r 74cc78bbd65f sql/update_db_00_05_to_00_06.py
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/update_db_00_05_to_00_06.py	Tue Oct 18 12:43:09 2011 +0200
@@ -0,0 +1,41 @@
+#! /usr/bin/env python
+
+from django.core.management import setup_environ
+from ldtplatform import settings
+
+setup_environ(settings)
+
+from django.db import connections
+import lxml.etree
+from ldt.ldt_utils.models import Media, Content
+
+cur = connections['migration_rs'].cursor()
+
+# Get all "regarssignes" contents
+cur.execute("SELECT * from ldt_content")
+rows = cur.fetchall()
+s = "Show me the databases:\n"
+for row in rows:
+    s += "\n   " + str(row)
+    # (id-0, u'iri_id'-1, u'iri_url'-2, u'videopath'-3, datetime creation_date-4, datetime update_date-5, u'title'-6, description-7, eternal_id-8)
+    # (1, u'laurentcantet_entrelesmurs', u'laurentcantet_entrelesmurs/laurentcantet_entrelesmurs.iri', u'rtmp://media.iri.centrepompidou.fr/ddc_player/video/regardssignes/', datetime.datetime(2010, 2, 17, 5, 24, 13, 69794, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None)), datetime.datetime(2010, 2, 17, 5, 24, 13, 91656, tzinfo=psycopg2.tz.FixedOffsetTimezone(offset=60, name=None)), u'Entre Les Murs', None, None)
+    # Get duration from the iri file
+    prePath = settings.MEDIA_ROOT +  u"ldt/"
+    doc = lxml.etree.parse(prePath + row[2])
+    res = doc.xpath("/iri/body/medias/media[@id='video']/video")
+    if len(res) > 0:
+        try:
+            dur = int(res[0].get(u'dur', 0) or 0)
+        except:
+            dur = 3600000
+    else:
+        dur = 3600000
+    # Build platform media and platform content from "regarssignes" contents
+    media = Media.objects.create(external_id=row[8], creation_date=row[4], update_date=row[5], videopath=row[3], duration=dur,
+                                 description=row[7], title=row[6], src=(row[1] + u".flv"), mimetype_field="('video/x-flv', None)")
+    media.save()
+    
+    content = Content.objects.create(iri_id=row[1], iriurl=row[2], creation_date=row[4], update_date=row[5], title=row[6], description=row[7],
+                                 content_creation_date=row[4], duration=dur, media_obj=media)
+    content.save()
+    
\ No newline at end of file