Esempio n. 1
0
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()
Esempio n. 2
0
    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)
Esempio n. 3
0
 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()
Esempio n. 4
0
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
Esempio n. 5
0
def rate(request, project_id, rate):
    p=Project.objects.get(id=project_id)
    user=User.objects.get(login=request.session['login'])
    r=Rating()
    r.rating=rate
    r.user=user
    r.project=p
    r.save()
    try:
            rates=Rating.objects.filter(Q(project__id=int(p.id)))
    except:
            rates=None
    j=int(rates.__len__())
    rating=0
    for rate in rates:
        rating+=rate.rating
    if j!=0:
        rating = rating/j
    rating = int(rating)

    html='Ocena:<nobr>'
    for i in range(1,6):
        if i>int(rating):
            print(i)
            html += '<img width=\"20\" height=\"20\" src=\"/static/emptystarr.png\" >'
        else:
            print(i)
            html += '<img width=\"20\" height=\"20\" src=\"/static/fillstar.jpg\"  >'
    html+='</nobr><br>'
    print(html)
    return HttpResponse(html)
Esempio n. 6
0
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("---------------------------------------------------------")
Esempio n. 7
0
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)
Esempio n. 8
0
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("---------------------------------------------------------")
Esempio n. 9
0
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"
Esempio n. 10
0
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 = []
Esempio n. 11
0
 def get(self, request, id, format=None):
     rating = Rating.get_article_ratings(Article.get_article(id))
     data = Article.get_article(id)
     serializers = ArticleSerializer(data, many=False)
     return response.Response(serializers.data, status=status.HTTP_200_OK)
Esempio n. 12
0
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
Esempio n. 13
0
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.'