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