import csv

from django.contrib.auth.hashers import make_password
from django.utils.encoding import smart_str

from app.models import User, Student


def read_csv():
    file_name = 'new_data.csv'
    csv_file = open(file_name, 'rb')
    reader = csv.reader(csv_file, quoting=csv.QUOTE_ALL)
    for i, row in enumerate(reader):
        roll_no = int(row[0])
        full_name = smart_str(row[1])
        web_mail = smart_str(row[2])

        user = User.objects.create(
            username=web_mail,
            password=make_password('helloworld'),
            is_active=False
        )
        student = Student.objects.create(
            user=user,
            full_name=full_name,
            roll_no=roll_no,
            gender='Male',
            department='BioSciences and Bioengineering',
            programme='programme',
            web_mail=web_mail
        )

if __name__ == "__main__":
    read_csv()