def handle_uploaaded_file(request, f):
book = xlrd.open_workbook(file_contents=f.read())
for sheet in book.sheets():
number_of_rows = sheet.nrows
number_of_columns = sheet.ncols
for row in range(1, number_of_rows):
password = (sheet.cell(row, 1).value)
username = (sheet.cell(row, 2).value)
first_name = (sheet.cell(row, 3).value)
last_name = (sheet.cell(row, 4).value)
email = (sheet.cell(row, 5).value)
is_student = (sheet.cell(row, 6).value)
department_id = (sheet.cell(row, 7).value)
faculty_id = (sheet.cell(row, 8).value)
user = User()
user.username = username
user.password = make_password(password,
salt=None,
hasher='default')
user.first_name = first_name
user.last_name = last_name
user.email = email
user.is_student = True
user.department_id = department_id
user.faculty_id = faculty_id
user.save()
print(user.username)
def setUpClass(cls):
super(CreateFilmRatingTestCase, cls).setUpClass()
# create a User model object in temporary database.
user = User(email='tom', password='******')
user.save()
# get employee user.
CreateFilmRatingTestCase.user = User.objects.get(email='tom')
print(user)
def register(request):
if request.method == "POST" :
ret = "OK"
req = request.POST
userName = str(req["userName"])
userPassword = hashlib.md5(str(req["userPassword"])).hexdigest()
if User.objects.filter(userName=userName, userPassword=userPassword).exists():
ret = "EXIST"
else:
dob = req['userDOB'].split('-')
u = User(userName=req['userName'], userAlias=req['userAlias'], userPassword=hashlib.md5(str(req['userPassword'])).hexdigest(), userFoods=req['userFoods'], userDrinks=req['userDrinks'], userBooks=req['userBooks'], userMovies=req['userMovies'], userGender=req['userGender'], userOccupation=req['userOccupation'], userDOB=datetime.date(int(dob[0]), int(dob[1]), int(dob[2])))
u.save()
#user = User.objects.latest('userId')
#sp = SimilarityProcess()
#sp.processUser(user.userId)
return HttpResponse(ret)
else :
return HttpResponse("what?")
