コード例 #1
0
def add(request):
    error = False
    added = False
    if request.method == "POST":
        manufacturer = request.POST.get("maker")

        # will return empty string if the field is empty
        model = (request.POST.get("model"))
        speed = convertInt(request.POST.get("speed"))
        RAM = convertInt(request.POST.get("ram"))
        hd = convertInt(request.POST.get("hd"))
        price = convertInt(request.POST.get("price"))

        if not model or not speed or not maker or not RAM or not hd or not price:
            error = True
        # check if the user entered a model number and that no PC exists with that model number
        else:
            try:
                Products.objects.get(model=model)
            except ObjectDoesNotExist:
                prod = Products(maker=manufacturer, model=model, type="PC")
                prod.save()
                pc = PCs(model=prod, speed=speed, ram=RAM, hd=hd, price=price)
                pc.save()
                added = True
    return render(request, "products/add.html", dict(added=added, error=error))
コード例 #2
0
    def handle(self, *args, **options):
        file_path = options.get('file')

        if not file_path:
            raise CommandError('File not provided.')

        if not file_path.endswith('.json'):
            raise CommandError('Only .json file supported.')

        file_path = os.path.join('data', file_path)
        try:
            with open(file_path) as import_file:
                products = json.load(import_file)
        except FileNotFoundError as e:
            raise CommandError('File at %s was not found' %
                               os.path.join('data', file_path))

        # user = AuthUserModel.objects.filter(id=product['user_id']).first()
        # print(user.first_name)

        for product in products:
            # print(product['user_id'])
            # user = AuthUserModel.objects.filter(id=product['user_id']).first()
            # print(user.first_name)
            db_product = Products(
                category=product['category'],
                name=product['name'],
                description=product['description'],
                image_url=product['image_url'],
                # user_id=AuthUserModel.objects.filter(id=product['user_id']).first()
                user_id=product['user_id'])
            db_product.save()
コード例 #3
0
ファイル: views.py プロジェクト: alokedesai/Delivery
def add(request):
    error = False
    added = False
    if request.method =="POST":
        manufacturer = request.POST.get("maker")

        # will return empty string if the field is empty
        model = (request.POST.get("model"))
        speed = convertInt(request.POST.get("speed"))
        RAM = convertInt(request.POST.get("ram"))
        hd = convertInt(request.POST.get("hd"))
        price = convertInt(request.POST.get("price"))
      
        if not model or not speed or not maker or not RAM or not hd or not price:
            error = True
        # check if the user entered a model number and that no PC exists with that model number
        else:
            try:
                Products.objects.get(model=model)
            except ObjectDoesNotExist:
                prod = Products(maker=manufacturer, model=model, type="PC")
                prod.save()
                pc = PCs(model= prod, speed=speed, ram=RAM, hd=hd, price=price)        
                pc.save()
                added= True
    return render(request, "products/add.html", dict(added= added, error = error))
コード例 #4
0
def dumpProducts( category_type, query, limit):
	'''
	@params
	category_type: string of the category name, for example "TV"
	query: the search engine query, for example "SONY TV"
	limit: the number of data entries you want to add to database
	'''
	target_category = Categories.objects.get(category_name = category_type)
	newproductstoadd = amazonListSearch(query, limit)

	for newproduct in newproductstoadd:
		product_name = newproduct[0]
		product_name = product_name[:95]
		print product_name
		imageURL = newproduct[1]
		print imageURL
		description = newproduct[2]
		print description
		slug = slugify(product_name)
		print slug
		price = amazonPriceSearch(product_name)
		print price
		print " "
		p1 = Products(product_name = product_name, image = imageURL , description = description, category = target_category, slug = slug, price = price)
		p1.save()
コード例 #5
0
def dumpProducts(category_type, query, limit):
    '''
	@params
	category_type: string of the category name, for example "TV"
	query: the search engine query, for example "SONY TV"
	limit: the number of data entries you want to add to database
	'''
    target_category = Categories.objects.get(category_name=category_type)
    newproductstoadd = amazonListSearch(query, limit)

    for newproduct in newproductstoadd:
        product_name = newproduct[0]
        product_name = product_name[:95]
        print product_name
        imageURL = newproduct[1]
        print imageURL
        description = newproduct[2]
        print description
        slug = slugify(product_name)
        print slug
        price = amazonPriceSearch(product_name)
        print price
        print " "
        p1 = Products(product_name=product_name,
                      image=imageURL,
                      description=description,
                      category=target_category,
                      slug=slug,
                      price=price)
        p1.save()
コード例 #6
0
    def setUp(self):
        '''
        Creates the Database and one user for tests.
        '''

        i = 1
        while i <= 20:

            c = Categorys(category="category", )
            c.save()
            if 1 <= 10:
                p = Products(
                    product="123456" + str(i),
                    nutrition_grade_fr=1,
                    product_name_fr="Product" + str(i),
                    ingredients_text_fr="Ingredients" + str(i),
                    product_image_large="Product_img_l" + str(i),
                    product_image_small="Product_img_s" + str(i),
                    product_image_nutrition_large="Product_img_n_l" + str(i),
                    product_image_nutrition_small="Product_img_n_s" + str(i),
                    stores="Stores" + str(i),
                    url="Url" + str(i),
                )

                cat = Categorys.objects.get(category="category")
                p.category = cat
                p.save()
            else:
                p = Products(
                    product="123456" + str(i),
                    nutrition_grade_fr=2,
                    product_name_fr="Product" + str(i),
                    ingredients_text_fr="Ingredients" + str(i),
                    product_image_large="Product_img_l" + str(i),
                    product_image_small="Product_img_s" + str(i),
                    product_image_nutrition_large="Product_img_n_l" + str(i),
                    product_image_nutrition_small="Product_img_n_s" + str(i),
                    stores="Stores" + str(i),
                    url="Url" + str(i),
                )

                cat = Categorys.objects.get(category="category")
                p.category = cat
                p.save()
            i += 1

        user = CustomUser.objects.create(email="*****@*****.**",
                                         first_name="first_name",
                                         second_name="second_name",
                                         password="******")

        user = CustomUser.objects.get(email=user)
        chosen_product = Products.objects.get(product="1234561")
        remplacement_product = Products.objects.get(product="1234562")

        history = History.objects.create(
            user=user,
            chosen_product=chosen_product,
            remplacement_product=remplacement_product)
コード例 #7
0
def addProduct(request):
    if request.user.is_authenticated:
        try:
            product = Products(product_name=request.POST['product_name'])
        except Exception as e:
            print(e)
            return HttpResponse(status=404)
        else:
            product.save()
            return HttpResponseRedirect('/products/index/')
    else:
        return HttpResponse(status=401)
コード例 #8
0
    def test_results_page_shows(self):
        '''
        Tests the search page, and the products page.
        '''
        i = 1
        while i <= 20:
            
            c = Categorys(
                category="category",
            )
            c.save()
            if 1 <= 10:
                p = Products(
                    product="123456"+str(i),
                    nutrition_grade_fr= 1,
                    product_name_fr="Product"+str(i),
                    ingredients_text_fr="Ingredients"+str(i),
                    product_image_large="Product_img_l"+str(i),
                    product_image_small="Product_img_s"+str(i),
                    product_image_nutrition_large="Product_img_n_l"+str(i),
                    product_image_nutrition_small="Product_img_n_s"+str(i),
                    stores="Stores"+str(i),
                    url="Url"+str(i),
                    )
                
                cat = Categorys.objects.get(category="category")
                p.category = cat
                p.save()
            else:
                p = Products(
                    product="123456"+str(i),
                    nutrition_grade_fr= 2,
                    product_name_fr="Product"+str(i),
                    ingredients_text_fr="Ingredients"+str(i),
                    product_image_large="Product_img_l"+str(i),
                    product_image_small="Product_img_s"+str(i),
                    product_image_nutrition_large="Product_img_n_l"+str(i),
                    product_image_nutrition_small="Product_img_n_s"+str(i),
                    stores="Stores"+str(i),
                    url="Url"+str(i),
                    )
                
                cat = Categorys.objects.get(category="category")
                p.category = cat
                p.save()
            i += 1

        self.driver.get(self.live_server_url)
        self.driver.find_element_by_id("searchForm").send_keys('Product')
        self.driver.find_element_by_id("searchForm").submit()

        
        self.assertTrue(self.driver.title == 'Page Products')
コード例 #9
0
    def setUp(self):
        cat = Categorys.objects.create(category="test1")
        p = Products(
            product="123456",
            nutrition_grade_fr=1,
            product_name_fr="Product",
            ingredients_text_fr="Ingredients",
            product_image_large="Product_img_l",
            product_image_small="Product_img_s",
            product_image_nutrition_large="Product_img_n_l",
            product_image_nutrition_small="Product_img_n_s",
            stores="Stores",
            url="Url",
        )

        cat = Categorys.objects.get(category="test1")
        p.category = cat
        p.save()
コード例 #10
0
ファイル: api_views.py プロジェクト: frank223c/icycle
 def post(self, request):
     cat_type_id = request.data.get(RequestKeys.CATEGORY_TYPE.value, None)
     no_of_products = request.data.get(RequestKeys.NUMBER_OF_PRODUCTS.value,
                                       None)
     if cat_type_id and no_of_products:
         cat_type = Categories.objects.get(id=cat_type_id)
         products = [
             Products(category=cat_type, code=str(uuid.uuid4()))
             for i in range(no_of_products)
         ]
         Products.objects.bulk_create(products)
         return Response(ResponseHandler.get_result(
             SuccesMessages.PRODUCTS_GENERATED.value % no_of_products),
                         status=status.HTTP_200_OK)
     else:
         return Response(ResponseHandler.get_result(
             FailureMessages.INVALID_INPUT.value),
                         status=status.HTTP_400_BAD_REQUEST)
コード例 #11
0
ファイル: api_views.py プロジェクト: jtovarm/store-django
def add_product(request):
    params = json.loads(request.POST['json'])

    name = params['name']
    price = params['precio']
    description = params['description']
    date_up = datetime.now()

    if not name:
        return JsonResponse({}, status=400)

    product = Products()
    product.name = name
    product.description = description
    product.price = price
    product.date_up = date_up
    product.save()

    response = {
        'created': True
    }
    return JsonResponse(response, status=200)
コード例 #12
0
 def test_product(self):
     category = Category.objects.create(cat="pizzas")
     self.assertEqual(category.cat, "pizzas")
     product = Products.objects.create(
         id_code=2344393,
         food_name="pizzas",
         nutrition_grade="a",
         image_url="www.oeoeieoirie.com",
         food_link="www.didjdijddj.com",
         image_nutrition_url="www.oeoeouou.fr")
     categ = Category.objects.get(cat=category.cat)
     product.category.add(categ)
     product.save()
     self.assertEqual(product.id_code, 2344393)
     self.assertEqual(product.food_name, "pizzas")
     self.assertEqual(product.nutrition_grade, "a")
     self.assertEqual(product.image_url, "www.oeoeieoirie.com")
     self.assertEqual(product.food_link, "www.didjdijddj.com")
     self.assertEqual(product.image_nutrition_url, "www.oeoeouou.fr")
     cate = product.category.all()
     cate2 = str(cate[0])
     self.assertEqual(cate2, "pizzas")
     self.assertEqual(product.food_name, Products.__str__(product))
     self.assertEqual(category.cat, Category.__str__(category))
コード例 #13
0
    def handle(self, *args, **options):

        help = "Insert all products an relations in the models tables."

        print("Debout du travail!...")

        DataFiles.download_and_clean_all_products(DataFiles)

        products_to_insert = DataFiles.products_to_inser

        print(
            "Nous avons ",
            len(products_to_insert),
            "produits téléchargées et nettoyées!",
        )

        print("Insértion de tous les produits dans la base de données!")

        try:
            for data_dict in products_to_insert:
                c = Categorys(category=data_dict["category"])
                c.save()

                if data_dict["nutrition_grade_fr"] == "a":
                    nut = 1
                if data_dict["nutrition_grade_fr"] == "b":
                    nut = 2
                if data_dict["nutrition_grade_fr"] == "c":
                    nut = 3
                if data_dict["nutrition_grade_fr"] == "d":
                    nut = 4
                if data_dict["nutrition_grade_fr"] == "e":
                    nut = 5

                p = Products(
                    product=str(data_dict["product"]),
                    nutrition_grade_fr=nut,
                    product_name_fr=data_dict["product_name_fr"],
                    ingredients_text_fr=data_dict["ingredients_text_fr"],
                    product_image_large=data_dict["product_image_large"],
                    product_image_small=data_dict["product_image_small"],
                    product_image_nutrition_large=data_dict[
                        "product_image_nutrition_large"
                    ],
                    product_image_nutrition_small=data_dict[
                        "product_image_nutrition_small"
                    ],
                    stores=data_dict["stores"],
                    url=data_dict["url"],
                )

                cat = Categorys.objects.get(category=data_dict["category"])
                p.category = cat
                p.save()

        except:
            raise CommandError(
                "Ups une erreur est arrivé, insertion aborté!! sur le produit",
                p.product_name_fr,
            )

        self.stdout.write(
            self.style.SUCCESS(
                "Les produits sont, à present, sauvegardées dans la base de données!"
            )
        )
コード例 #14
0
ファイル: addToDb.py プロジェクト: alokedesai/Delivery
import random
import sys, os
os.environ['DJANGO_SETTINGS_MODULE'] = 'ecommerce.settings'
from django.conf import settings
from products.models import Products,PCs, Laptops, Printers
makers = ["Apple", "HP", "Lenovo", "Dell", "Sony"]
printerType=["laser", "ink-jet"]
colorVal = [True,False]
# add 100 pcs
for i in range(1,100):
	product = Products(maker=makers[random.randint(0,4)], model=i, type="PC")
	product.save()
	ram = random.uniform(1, 16)
	speed = random.uniform(1,4)
	hd = random.randint(100,1000)
	price = random.uniform(500,2000)
	ram = float(format(ram, ".2f"))
	speed = float(format(speed, ".2f"))
	price = float(format(price, ".2f"))

	pc = PCs(model=product, ram=ram,speed=speed, hd=hd, price=price)
	pc.save()
# add 100 laptops
for i in range(100,200):
	product = Products(maker=makers[random.randint(0,4)], model=i, type="Laptop")
	product.save()
	ram = random.uniform(1, 16)
	speed = random.uniform(1,4)
	hd = random.randint(100,1000)
	price = random.uniform(500,2000)
	screen = random.uniform(10,22)
コード例 #15
0
def addProduct(request):
    if request.method=='POST':
        print request.POST
        ##print request.POST
        product_id=request.POST['productid']
        subcategory_count=request.POST['count']
        if (subcategory_count==""):
            subcategory_count=0
        subcategory_count=int(subcategory_count)
        subcategory_count+=1
        category=request.POST['category']
        subcategory=[]
        if (subcategory_count>0):
            for each in range(1,subcategory_count):
                temp=('subcategory'+str(each))
                subcategory.append(request.POST[temp])
        print subcategory
        #form Category_objects
        if (len(subcategory)==1):
            category_objects=Category.objects.filter(category_name=category,subcategory_1=subcategory[0])
        elif (len(subcategory)==2):
            category_objects=Category.objects.filter(category_name=category,subcategory_1=subcategory[0],subcategory_2=subcategory[1])
        elif (len(subcategory)==3):
            category_objects=Category.objects.filter(category_name=category,subcategory_1=subcategory[0],subcategory_2=subcategory[1],subcategory_3=subcategory[2])
        else:
            category_objects=Category.objects.filter(category_name=category,subcategory_1=None,subcategory_2=None,subcategory_3=None)
        """saved_category=[]
        saved_category.append(category_objects.subcategory_1);
        saved_category.append(category_objects.subcategory_2);
        saved_category.append(category_objects.subcategory_3);
        for each in range(0,len(subcategory)):
            if(saved_category[each]!=subcategory[each]):
                category_objects=create_new_category(category,subcategory)"""
        if len(category_objects) == 0:
            category_objects=create_new_category(category, subcategory)
            category_id=category_objects.id
        else:
            category_id=category_objects[0].id
        brand=request.POST['brand']
        unit_price=request.POST['unit_price']
        model=request.POST['model']
        description=request.POST['description']
        product_name=request.POST['product_name']
        currenttime=datetime.datetime.now()
        product_item=Products()
        product_item.product_name=product_name
        product_item.product_id=product_id
        product_item.category_id=category_id
        product_item.brand=brand
        product_item.model_no=model
        product_item.short_description=description
        product_item.baseUnitPrice=unit_price
        product_item.arrival=currenttime
        product_item.save()
        print product_item
        return HttpResponseRedirect('/Home/Admin/')
コード例 #16
0
pwd = os.path.dirname(os.path.realpath(__file__))
sys.path.append(pwd + '../')
#在manage.py中
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "beenquickServer.settings")

import django
django.setup()

from db_tools.axf_json import JSONSTR
from products.models import Products

data = eval(JSONSTR)['data']
products = data['products']
for k, v in products.items():
    for product in v:
        p = Products()
        p.id = product['id']
        p.name = product['name']
        p.longname = product['long_name']
        p.store_nums = product['store_nums']
        p.specifics = product['specifics']
        p.attribute = product['attribute']
        p.sort = product['sort']
        p.brand_id = product['brand_id']
        p.brand_name = product['brand_name']
        p.hot_degree = product['hot_degree']
        p.safe_day = product['safe_day']
        p.safe_unit = product['safe_unit']
        p.market_price = product['market_price']
        p.partner_price = product['partner_price']
        p.pre_img = product['pre_img']
コード例 #17
0
ファイル: addToDb.py プロジェクト: danielfernades/Delivery
import random
import sys, os
os.environ['DJANGO_SETTINGS_MODULE'] = 'ecommerce.settings'
from django.conf import settings
from products.models import Products, PCs, Laptops, Printers
makers = ["Apple", "HP", "Lenovo", "Dell", "Sony"]
printerType = ["laser", "ink-jet"]
colorVal = [True, False]
# add 100 pcs
for i in range(1, 100):
    product = Products(maker=makers[random.randint(0, 4)], model=i, type="PC")
    product.save()
    ram = random.uniform(1, 16)
    speed = random.uniform(1, 4)
    hd = random.randint(100, 1000)
    price = random.uniform(500, 2000)
    ram = float(format(ram, ".2f"))
    speed = float(format(speed, ".2f"))
    price = float(format(price, ".2f"))

    pc = PCs(model=product, ram=ram, speed=speed, hd=hd, price=price)
    pc.save()
# add 100 laptops
for i in range(100, 200):
    product = Products(maker=makers[random.randint(0, 4)],
                       model=i,
                       type="Laptop")
    product.save()
    ram = random.uniform(1, 16)
    speed = random.uniform(1, 4)
    hd = random.randint(100, 1000)
コード例 #18
0
ファイル: views.py プロジェクト: dipikasuresh/CG3002-Final
def search(request):
    if 'name' in request.GET and request.GET['name']:
	name = request.GET['name']
	manufacturer = request.GET['manufacturer']
	p = Products(name=name,manufacturer=manufacturer) 
	p.save()