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()
