# -*- coding: utf-8 -*-
# execfile('createuser.py')
import unicodecsv as csv
import io
import lms.lib.comment_client as cc
from optparse import make_option

from django.conf import settings
from django.contrib.auth.models import User
from django.core.management.base import BaseCommand
from django.utils import translation

from opaque_keys import InvalidKeyError
from opaque_keys.edx.keys import CourseKey
from opaque_keys.edx.locations import SlashSeparatedCourseKey
from student.forms import AccountCreationForm
from student.models import CourseEnrollment, create_comments_service_user
from student.views import _do_create_account, AccountValidationError
from track.management.tracked_command import TrackedCommand

f = io.open('createuser.csv','rb')
r = csv.reader(f, encoding='utf-8')
for t in r:
  username=t[0]
  email=username + '@edu-kuban.ru'
  name=t[1] or ' ' + " " + t[2] or ' ' + " " + t[3] or ' '
  fname=t[1]
  try:
    lname=t[2]
  except IndexError:
    lname = ''
  password='123456'

  form = AccountCreationForm(data={'username': username,'email': email,'password': password,'name': name,},tos_required=False)
  translation.activate('ru')
  try:
    user, _, reg = _do_create_account(form)
    user.is_staff = True
    user.first_name = fname
    user.last_name = lname
    user.save()
    reg.activate()
    reg.save()
    #cc_user = cc.User.from_django_user(user)
    #cc_user.save()
    create_comments_service_user(user)
  except AccountValidationError as e:
    print e.message
    user = User.objects.get(email=email)
  translation.deactivate()