import final
import talks as pytalks
from django.models.roomy import rooms, talks, schedules
import datetime

for day in final.schedule:
  print "Days: ", day


for sched_key in final.schedule:
  for talk in final.schedule[sched_key]:
    t_id=0
    r_id=0
    try:
      r_id = rooms.get_object(title__iexact=talk[0])
    except:
      r_id = rooms.Room(title=talk[0])
      r_id.save()
      print "Room %s is already in the DB"%(talk[0])

    if '#' in talk[3]:# if talk has id (indicated by #) then resolve to name
      idx = int(talk[3].split('#')[1])
      talk_title=pytalks.talk_dict[idx]
      talk_url="http://wiki.python.org/moin/PyCon2006/Talks#"+str(idx)
    else:
      talk[3]
      talk_title=talk[3]
      talk_url=''

    try:
      t_id=talks.get_object(title__iexact=talk_title)
    except:
      t_id = talks.Talk(title=talk_title, url=talk_url, duration=talk[2])
      t_id.save()
      print "Talk %s is already in the DB"%(talk_title)
    
    sdate=datetime.date(sched_key[0], sched_key[1], sched_key[2])
    hours,minutes = talk[1].split(':')
    stime=datetime.time(int(hours), int(minutes))
    try:
      s_id = schedules.Schedule(startdate=sdate, starttime=stime, room=r_id, talk=t_id)
      s_id.save( )
    except:
      print