def write(request):
if request.method == "POST" :
ret = "OK"
user = User()
user.userId = int(request.POST["userId"])
place = Place()
place.placeId = int(request.POST["placeId"])
if Review.objects.filter(reviewUser=user, reviewPlace=place).exists():
ret = "EXIST"
else:
review = Review()
review.reviewUser = user
review.reviewPlace = place
review.reviewPointPrice = int(request.POST["reviewPointPrice"])
review.reviewPointService = int(request.POST["reviewPointService"])
review.reviewPointLocation = int(request.POST["reviewPointLocation"])
review.reviewPointCondition = int(request.POST["reviewPointCondition"])
review.reviewPointComfort = int(request.POST["reviewPointComfort"])
review.reviewText = request.POST["reviewText"]
review.save()
return HttpResponse(ret)
else :
return HttpResponse("what?")
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 listReviews(request):
if request.method == "POST" :
user = User()
user.userId = int(request.POST["userId"])
place = Place()
place.placeId = int(request.POST["placeId"])
typeId = int(request.POST["typeId"])
data = []
for r in Review.objects.filter(reviewPlace_id=place).exclude(reviewUser_id=user) :
dict = {}
dict['userId'] = r.reviewUser.userId
dict['userAlias'] = r.reviewUser.userAlias
dict['reviewPointPrice'] = r.reviewPointPrice
dict['reviewPointService'] = r.reviewPointService
dict['reviewPointLocation'] = r.reviewPointLocation
dict['reviewPointCondition'] = r.reviewPointCondition
dict['reviewPointComfort'] = r.reviewPointComfort
dict['reviewText'] = r.reviewText
average = float(r.reviewPointPrice+r.reviewPointService+r.reviewPointLocation+r.reviewPointCondition+r.reviewPointComfort) / 5
dict['averagePoint'] = average
sp = SimilarityProcess()
dict['similarityValue'] = sp.process(User.objects.get(userId=user.userId), r.reviewUser, typeId)
dict['newSimilarityValue'] = float(dict['similarityValue']) * average
data.append(dict)
#''' normalizing similarity on same place
minV = min(data, key=lambda x:x['similarityValue'])
maxV = max(data, key=lambda x:x['similarityValue'])
minValue = minV['similarityValue']
maxValue = maxV['similarityValue']
for dict in data:
dict["similarityValue"] = float((dict["similarityValue"] - minValue)/(maxValue - minValue))
dict['newSimilarityValue'] = dict['similarityValue'] * dict['averagePoint']
dict['averagePoint'] = str(dict['averagePoint'])
fuzzy = Fuzzy()
dict['similarityFlag'] = str(fuzzy.process(dict['similarityValue']))
#'''
data = sorted(data, key=lambda rev: rev['newSimilarityValue'], reverse=True)
return HttpResponse(json.dumps(data))
else :
return HttpResponse("what?")
def login(req):
req = HttpRequest()
user = User.check(req['username'], req['password'])
if user != None:
permissions = Permission.objects.filter(role__user__id=user.id)
_login_(req, user, permissions)
return {'success': True, 'msg': 'login success'}
else:
return {'success': False, 'msg': 'login failed'}
def login(req):
req=HttpRequest()
user=User.check(req['username'],req['password'])
if user!=None:
permissions= Permission.objects.filter(role__user__id=user.id)
_login_(req,user,permissions)
return {'success':True,'msg':'login success'}
else:
return {'success':False,'msg':'login failed'}
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?")
def register():
if current_user.is_authenticated:
return redirect(url_for('home'))
form = RegistrationForm()
if form.validate_on_submit():
hashed_password = bcrypt.generate_password_hash(
form.password.data).decode('utf-8')
user = User(username=form.username.data,
email=form.email.data,
password=hashed_password)
db.session.add(user)
db.session.commit()
flash('Your account has been created! You are now able to log in',
'success')
return redirect(url_for('login'))
return render_template('register.html', title='Register', form=form)
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)
