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)
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()
def UpLoadDataFromCsv(path=mypath): writeCsvFiles(path) with open('list.csv', 'rb') as csvfile: rows = csv.DictReader(x.replace('', '') for x in csvfile) for row in rows: try: Navbar.objects.get(name=row['navbar']) try: category = Category.objects.get(name=row['category']) try: Product.objects.get(name=row['name']) continue except Product.DoesNotExist: product = Product(category=category, name=row['name'], kilometers=row['kilometers'], price=row['price'], stock=['stock'], available=row['available']) name = row['name'] dir = row['directory'] product.image = ImageFile(open(dir, 'rb')) product.save() #product.image.save(File(open(dir,'rb'))) #product.image.save(name,File(open(dir,'r'))) #image = ImageFile(open("".join(row['directory']),"r")) #product = Product(category=category,name=row['name'],image=image,kilometers=row['kilometers'],price=row['price'],stock=['stock'],available=row['available']) #product = Product(category=category,name=row['name'],kilometers=row['kilometers'],price=row['price'],stock=['stock'],available=row['available']) #product.image = ImageFile(open("".join(row['directory']),"r")) #product.image = "products/".join(row['directory']) #product.save() except Category.DoesNotExist: category = Category(navbar=nav, name=row['category']) category.save() product = Product(category=category, name=row['name'], kilometers=row['kilometers'], price=row['price'], stock=['stock'], available=row['available']) name = row['name'] dir = row['directory'] product.image.save(name, File(open(dir, 'rb'))) #product.image.save(row['name'].join('.jpg'),File(open(row['directory'],'r'))) #product = Product(category=category,name=row['name'],kilometers=row['kilometers'],price=row['price'],stock=['stock'],available=row['available']) #product.image = ImageFile(open("".join(row['directory']),"r")) #product.image = "products/".join(row['directory']) #product.save() except Navbar.DoesNotExist: nav = Navbar(name=row['navbar']) nav.save() #createProduct(nav,row['category']) category = Category(navbar=nav, name=row['category']) category.save() name = row['name'] dir = row['directory'] product = Product(category=category, name=row['name'], kilometers=row['kilometers'], price=row['price'], stock=['stock'], available=row['available']) product.image.save(name, File(open(dir, 'rb'))) #product.image.save(row['name'].join('.jpg'),File(open(row['directory'],'r'))) #product = Product(category=category,name=row['name'],kilometers=row['kilometers'],price=row['price'],stock=['stock'],available=row['available']) #product.image = ImageFile(open("".join(row['directory']),"r")) #product.image = "products/".join(row['directory']) #product.save() csvfile.close()