def create_ratings(): for trainer in Trainer.objects.all(): for n in range(1, randrange(1, 890)): rating = randrange(1, 6) # rating pokemon = Pokemon.objects.get(pokedex_id=n) r = Rating(trainer=trainer, pokemon=pokemon, rating=rating) r.save()
def AddRating(rating): # try: r = Rating(numsurveyed=rating["NumSurveyed"], numenrolled=rating["NumEnrolled"]) r.coursewhole = Decimal( rating["Course"]) if len(rating["Course"]) > 0 else None r.coursecontent = Decimal( rating["Content"]) if len(rating["Content"]) > 0 else None r.instructoreffectiveness = Decimal( rating["Effectiveness"]) if len(rating["Effectiveness"]) > 0 else None r.instructorcontribution = Decimal( rating["Contrib"]) if len(rating["Contrib"]) > 0 else None r.instructorinterest = Decimal( rating["Interest"]) if len(rating["Interest"]) > 0 else None r.amountlearned = Decimal( rating["Learned"]) if len(rating["Learned"]) > 0 else None r.grading = Decimal( rating["Grading"]) if len(rating["Grading"]) > 0 else None #print r.coursewhole #print rating #print ",".join(rating.values()) r.save() return r
def populateRating(): print("Loading ratings...") lista=[] fileobj=open(path+"\\ratings.csv", "r") for line in fileobj.readlines()[1:]: rip = line.split(';') l=Rating(user=int(rip[0]), isbn=int(rip[1]), rating=int(rip[2])) lista.append(l) Rating.objects.bulk_create(lista) # bulk_create hace la carga masiva para acelerar el proceso print("Libros añadidos: " + str(Rating.objects.count())) print("---------------------------------------------------------")
def post(self, request, *args, **kwargs): try: data = json.loads(request.body) item = data['item'] rating = data['rating'] ts = int(time.time()) rating_record = Rating(user=request.user.id, item=Item.objects.get(id=item), rating=rating, timestamp=ts) rating_record.save() except: return HttpResponse(status=500) return HttpResponse(status=200)
def put(request, id): user_id = auth.get_user(request).id rating_id = None try: rating_id = Rating.objects.get(user_id=user_id, book_id=id).id except Rating.DoesNotExist: pass print(request.info) rating = Rating(book_id=id, user_id=user_id, rating=request.info['rating']) rating.id = rating_id rating.save() time.sleep(1) return RestJsonResponse()
def update_rating_table(): if Rating.objects.all(): Rating.objects.all().delete() with open('main/data/ratings.csv') as f: reader = csv.reader(f) next(reader) rating_objects = [ Rating( user_id=row[0], movie_id=row[1], rating=row[2], timestamp=row[3] if row[3] else None ) for row in reader ] Rating.objects.bulk_create(rating_objects)
def populateRatings(u, m): print("Loading ratings...") Rating.objects.all().delete() lista = [] fileobj = open(path + "\\u.data", "r") for line in fileobj.readlines(): rip = line.split('\t') lista.append( Rating(user=u[int(rip[0].strip())], film=m[int(rip[1].strip())], rating=int(rip[2].strip()), rateDate=datetime.fromtimestamp(int(rip[3].strip())))) fileobj.close() Rating.objects.bulk_create(lista) print("Ratings inserted: " + str(Rating.objects.count())) print("---------------------------------------------------------")
def create_ratings(): data = request.get_json() get_rating = Rating.query.filter_by(productId=data['productId'], userId=data['userId']).first() rating_schema = RatingSchema() rating = rating_schema.dump(get_rating) if not rating: new_rating = Rating(data['productId'], data['userId'], data['rating']) db.session.add(new_rating) getAll_ratings = Rating.query.filter_by( productId=data['productId']).all() ratings_schema = RatingSchema(many=True) product_ratings = ratings_schema.dump(getAll_ratings) tot = 0 for i in range(len(product_ratings)): tot += product_ratings[i]['rating'] get_product = Product.query.filter_by( productId=data['productId']).first() get_product.productRating = float(tot / len(product_ratings)) db.session.commit() else: get_rating.rating = data['rating'] getAll_ratings = Rating.query.filter_by( productId=data['productId']).all() ratings_schema = RatingSchema(many=True) product_ratings = ratings_schema.dump(getAll_ratings) tot = 0 for i in range(len(product_ratings)): tot += product_ratings[i]['rating'] get_product = Product.query.filter_by( productId=data['productId']).first() print(get_product.productRating) get_product.productRating = float(tot / len(product_ratings)) print(get_product.productRating) db.session.commit() return "pass"
def save_ratings(path_ratings='csvData/ratings.csv'): """Save all ratings with realtion: user-rating-movie.""" with open(path_ratings) as csvDataFile: csvReader = csv.reader(csvDataFile) next(csvReader, None) # skip the headers bulk = [] for row in csvReader: bulk.append( Rating(rating=row[2], movie_id=int(row[1]), user_id=int(row[0]))) if csvReader.line_num % 10 == 0: try: Rating.objects.bulk_create(bulk) except Exception as e: print("Error in ratings " + str(e)) print("reseting bulk at " + str(csvReader.line_num)) bulk = []
prop5.save() prop6.save() prop7.save() gallery17 = Gallery(name="milngavie4_m2dtqt.jpg", property=prop2) gallery17.save() gallery18 = Gallery(name="milngavie3_memqjg.jpg", property=prop2) gallery18.save() gallery19 = Gallery(name="milngavie2_bdt0r4.jpg", property=prop2) gallery19.save() gallery20 = Gallery(name="milngavie1_cazxmk.jpg", property=prop2) gallery20.save() prop2.img = gallery17 prop2.save() rating1 = Rating(score=1) rating1.save() rating2 = Rating(score=2) rating2.save() rating3 = Rating(score=3) rating3.save() rating4 = Rating(score=4) rating4.save() rating5 = Rating(score=5) rating5.save() review1 = Review( rating=rating1, user='******', description= 'Very poor experience. The accomodation provided lacked general hygiene. Food was OK though, I just wish there was more.'