def handle(self, *args, **options): products = settings.BASE_DIR.joinpath('products.json') with open(products, encoding='utf-8') as f: data = json.load(f) for item in data: category, created = Category.objects.get_or_create( name=item['category'][0]) if created: category.save() try: product = Product.objects.get(category=category, name=item['name'][0]) except Product.DoesNotExist: product = Product(category=category, name=item['name'][0]) product.price = float(item['price'][0][1:]) product.description = item['description'][0] product.save() photo, created = Photo.objects.get_or_create( product=product, url=item['photo'][1]) if created: photo.save() size, created = Size.objects.get_or_create(product=product) if created: size.size = self.random_size() size.save()
def handle(self, *args, **options): d = Product.objects.all() d.delete() for c in ShopProduct.objects.using('old').all(): category = Category.objects.filter(pk=c.category_id).first() prod = Product.objects.filter(category=category, slug=c.slug).first() if not prod: prod = Product(pk=c.pk) prod.name = c.name prod.category = category prod.slug = c.slug prod.title = c.title prod.description = c.metadesc prod.keywords = c.metakey prod.price = c.price prod.image = c.image prod.description = c.description prod.full_text = c.full_text prod.save() print(prod.id)
def main_product(author, category, name, description, material, model, color): pr = Product() pr.author = author pr.category = category pr.name = name pr.description = description pr.material = material pr.model = model pr.color = color pr.price = random.uniform(100, 2000) pr.like = random.randint(0, 1000) pr.rating = random.uniform(1, 5) pr.rating_count = 500 pr.rating_sum = int(pr.rating * 500) pr.save()
def create(request, manage_type): typee = ProductType.objects.all() message = '' if request.method == 'POST' and manage_type == 'type': typee = ProductType() typee.name = request.POST.get('input_name') typee.description = request.POST.get('input_desc') typee.save() message = 'Create %s product type sucessful' % typee.name elif request.method == 'POST' and manage_type == 'product': products = Product() products.name = request.POST.get('input_name') products.description = request.POST.get('input_desc') products.price = request.POST.get('input_price') products.ProductType_id = request.POST.get('input_type') products.save() message = 'Create product : %s sucessful' % products.name context = {'manage_type': manage_type, 'type': typee, 'message': message} return render(request, template_name='management/create.html', context=context)
project_dir = "C:/Users/Admin/Desktop/sample/enginesearch1/enginesearch/" sys.path.append(project_dir) os.environ['DJANGO_SETTINGS_MODULE'] = 'settings' import django django.setup() from shop.models import Product data2 = csv.reader( open("C:/Users/Admin/Desktop/sample/enginesearch1/Product1.csv"), delimiter=",") for row in data2: if row[0] != 'number_id': product = Product() product.number_id = row[0] product.name = row[1] product.slug = row[2] product.description = row[3] product.price = row[4] product.available = row[5] product.stock = row[6] product.created_at = row[7] product.updated_at = row[8] product.image = row[9] product.save()
6, 'Electronic', 'Samsung S9', 'Samsung_S9', 'products/2018/04/19/S9.jpg', 'Samsung Galaxy S9', 1099, 150, 0 ], ] server = Server() for pic in pic: try: p = Product.objects.get(pid=pic[0]) except: p = Product() p.pid = pic[0] category = pic[1] try: c = Category.objects.get(name=category) except: c = Category.objects.create(name=category, slug=category) p.category = c p.name = pic[2] p.slug = pic[3] p.image = pic[4] p.description = pic[5] p.price = pic[6] p.stock = pic[7] p.whnum = pic[8] p.save() print("fin") else: continue server.close()