def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
users = load_from_json('user')
User.objects.all().delete()
for user in users:
new_user = User(**user)
new_user.save()
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
print(product)
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser('admin',
'*****@*****.**',
'admin',
age=24)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete() # Удаляет существующие записи
for category in categories:
new_category = ProductCategory(**category) # распаковка словорей в нужный формат
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
if "image" in product:
product_image_path = os.path.join('products_images', product["image"])
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
if ("image" in product):
product["image"] = product_image_path
else:
product["image"] = os.path.join('products_images', "nophoto.jpg")
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser('admin', '*****@*****.**', '12345678', age=27)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
local_config_path = os.path.join(CONFIG_PATH, 'local.conf')
config = RawConfigParser()
config.read(local_config_path)
super_user = ShopUser.objects.create_superuser(
config.get('admin', 'USERNAME'), config.get('admin', 'EMAIL'),
config.get('admin', 'PASSWORD'))
def handle(self, *args, **kwargs):
# создание категории
# ProductCategory.objects.create(
# name='Шкафы'
# )
categories = load_json('categories')
# print(categories)
ProductCategory.objects.all().delete() # очищаем базу, удаляем категории
for cat in categories:
new_cat = ProductCategory(**cat) # создали новую категорию с параметрами name и description
new_cat.save() # записали словарь в базу
products = load_json('products')
Product.objects.all().delete()
for product in products:
category_item = ProductCategory.objects.get(name=product['category'])
product['category'] = category_item
new_prod = Product(**product)
new_prod.save()
# Создаем суперпользователя при помощи менеджера модели
super_user = ShopUser.objects.create_superuser(
'django', # имя админа
'*****@*****.**', # почта
'geekbrains', # пароль
age=33 # возраст. ВКонтакте API не передает в ответе возраст пользователя
)
def handle(self, *args, **options):
categories = loadFromJSON('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
prod_pages = loadFromJSON('prod_page')
ProdPage.objects.all().delete()
for prod_page in prod_pages:
id_prod = prod_page["id_prod"]
_name = Product.objects.get(name = id_prod)
prod_page["id_prod"] = _name
new_prod_page = ProdPage(**prod_page)
new_prod_page.save()
# Создаем суперпользователя при помощи менеджера модели
super_user = ShopUser.objects.create_superuser('django', '', 'geekbrains', age=18)
def handle(self, *args, **kwargs):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save() # можем сделать одной строчкой с create
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Ищем категорию
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Суперпользователь
ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=30)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
ShopUser.objects.create_superuser('amicus',
'*****@*****.**',
'VBfgrt45',
age='25')
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
super_user = ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=33)
ShopUser.objects.create_superuser(username='******',
password='******',
age=30,
email='*****@*****.**',
first_name='Алексей',
last_name='Ш.')
def handle(self, *args, **options):
super_user = ShopUser.objects.create_superuser(
'django',
'*****@*****.**',
'geekbrains',
age=29
)
Product.objects.all().delete()
ProductCategory.objects.all().delete()
categories = load_json('ProductCategory')
cats_dict = {}
for cat in categories:
new_cat = ProductCategory(**cat)
new_cat.save()
cats_dict[cat['name']] = new_cat.id
products = load_json('Product')
for product in products:
product['category'] = ProductCategory.objects.get(name=product['category'])
# product['category_id'] = cats_dict[product['category']]
new_prod = Product(**product)
new_prod.save()
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser(username=config.get('superuser', 'username'),
email=config.get('superuser', 'email'),
password=config.get('superuser', 'password'),
age=config.getint('superuser', 'age'),
first_name=config.get('superuser', 'first_name')
)
def handle(self, *args, **options):
categories = load_from_json('main_mainapp_productcategory')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
brands = load_from_json('main_mainapp_productbrand')
ProductBrand.objects.all().delete()
for brand in brands:
new_brand = ProductBrand(**brand)
new_brand.save()
products = load_from_json('main_mainapp_product')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# ShopUser.objects.get(username="******", is_superuser=True).delete()
super_user = ShopUser.objects.create_superuser('django', '*****@*****.**', 'geekbrains', age=32)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
super_user = ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=33)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя
if not ShopUser.objects.filter(username='******').exists():
ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains')
def handle(self, *args, **options):
categories = loadFromJSON('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаём суперпользователя
ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=30)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser(config.get("admin", "admin_username"), config.get("admin", "admin_email"),\
config.get("admin", "admin_password"), config.get("admin", "admin_age"))
"""super_user = ShopUser.objects.create_superuser('django', '*****@*****.**', 'geekbrains', age=33)"""
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
contacts = load_from_json('contacts')
Contacts.objects.all().delete()
for contact in contacts:
new_contact = Contacts(**contact)
new_contact.save()
# Создаем суперпользователя при помощи менеджера модели
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser('django', '*****@*****.**', 'geekbrains', age=30)
def handle(self, *args, **options):
categories = loadFromJSON('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
ShopUser.objects.all().delete()
ShopUser.objects.create_superuser('admin',
'*****@*****.**',
'admin',
age=25)
def handle(self, *args, **options):
categories = loadFromJSON('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
super_user = User.objects.create_superuser('stp',
'*****@*****.**',
'Qwerty123!',
age=33)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
ShopUser.objects.all().delete()
django = ShopUser.objects.create_superuser('django', '*****@*****.**', \
'geekbrains', age=18)
user_1 = ShopUser.objects.create_user('user1', '*****@*****.**', \
'geekbrains', age=22)
user_2 = ShopUser.objects.create_user('user2', '*****@*****.**', \
'geekbrains', age=32)
user_3 = ShopUser.objects.create_user('user3', '*****@*****.**', \
'geekbrains', age=42)
products = list(Product.objects.all())
user_products = random.sample(products, 4)
for product in user_products:
Basket(user=django,
product=product,
quantity=int(random.random() * 20) + 1).save()
user_products = random.sample(products, 3)
for product in user_products:
Basket(user=user_1,
product=product,
quantity=int(random.random() * 15) + 1).save()
user_products = random.sample(products, 5)
for product in user_products:
Basket(user=user_2,
product=product,
quantity=int(random.random() * 10) + 1).save()
user_products = random.sample(products, 2)
for product in user_products:
Basket(user=user_3,
product=product,
quantity=int(random.random() * 25) + 1).save()
def category_check(category_name: str):
""" checks if category is in DB and creates one if not """
category = ProductCategory.objects.filter(name=category_name)
try:
return category[0]
except IndexError:
new_category = ProductCategory(name=category_name)
new_category.save()
return new_category
def import_data(self, csv_content, action):
if action == 'categories':
ProductCategory.objects.all().delete()
for row in csv_content:
category = row.get('category')
ProductCategory.upload_to_db(self, category)
if action == 'products':
Product.objects.all().delete()
for row in csv_content:
products = row.values()
Product.upload_to_db(self, list(products))
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
# [ProductCategory.objects.create(**category) for category in categories]
product_category_obj = [ProductCategory(**category) for category in \
categories]
ProductCategory.objects.bulk_create(product_category_obj)
products = load_from_json('products')
Product.objects.all().delete()
product_obj = []
chunk_size = 4000
for product in products:
category_name = product['category']
_category = ProductCategory.objects.filter(
name=category_name).first()
product['category'] = _category
product_obj.append(Product(**product))
if len(product_obj) == chunk_size:
Product.objects.bulk_create(product_obj)
product_obj = []
if product_obj:
Product.objects.bulk_create(product_obj)
if not ShopUser.objects.filter(username='******').exists():
ShopUser.objects.create_superuser(username='******',
email='admin@geekshop',
password='******')
def handle(self, *args, **options):
# delete all products & categories from db
Product.objects.all().delete()
ProductCategory.objects.all().delete()
# add categories to db
for name in ['home', 'office', 'furniture', 'modern', 'classic']:
ProductCategory(name=name).save()
# for each category add 3 products
# it is so complicated because I have only 6 images for all my products
counter = 0
for category in ProductCategory.objects.all():
for _ in range(3):
Product(
name=f'Product {counter + 1}',
short_description=
'Seat and back with upholstery made of cold cure foam',
description=
'Seat and back with upholstery made of cold cure foam. ' *
5,
image=f'products_images/product-{counter % 6 + 1}.jpg',
price=100,
quantity=100,
category=category).save()
counter += 1
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
ProductCategory(**category).save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
# Получаем категорию по имени
_category = ProductCategory.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
Product(**product).save()
# # Создаём суперпользователя при помощи менеджера модели
# if not User.objects.filter(username='******'):
# print('Создаём нового суперпользователя')
# User.objects.create_superuser('django', '*****@*****.**', 'geekbrains')
# Создаём суперпользователя при помощи менеджера модели
user = ShopUser.objects.filter(username='******')
if not user:
print('Создаём нового суперпользователя')
ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=25)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
category = category.get('fields')
new_category = ProductCategory(**category)
new_category.save()
brands = load_from_json('brands')
ProductBrand.objects.all().delete()
for brand in brands:
brand = brand.get('fields')
new_brand = ProductBrand(**brand)
new_brand.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
product = product.get('fields')
category_name = product["category"]
brand_name = product["brand_name"]
# Получаем категорию и бренд по имени
_category = ProductCategory.objects.get(name=category_name)
_brand = ProductBrand.objects.get(name=brand_name)
# Заменяем название категории и бренда объектом
product['category'] = _category
product['brand_name'] = _brand
new_product = Product(**product)
new_product.save()
hot_offers = load_from_json('hot_offers')
HotOffers.objects.all().delete()
for hot_offer in hot_offers:
hot_offer = hot_offer.get('fields')
new_hot_offer = HotOffers(**hot_offer)
new_hot_offer.save()
deals_of_the_weeks = load_from_json('deals_of_the_week')
DealsOfTheWeek.objects.all().delete()
for deal_of_the_week in deals_of_the_weeks:
deal_of_the_week = deal_of_the_week.get('fields')
new_deal_of_the_week = DealsOfTheWeek(**deal_of_the_week)
new_deal_of_the_week.save()
if not ShopUser.objects.filter(username='******').exists():
ShopUser.objects.create_superuser('django', '*****@*****.**', 'geekbrains')
def handle(self, *args, **options):
categories = loadFromJSON('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
def handle(self, *args, **options):
# категории
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
# print(category)
new_category = ProductCategory(**category)
new_category.save()
# рестораны
restaurants = load_from_json('restaurants')
Restaurant.objects.all().delete()
for restaurant in restaurants:
new_restaurant = Restaurant(**restaurant)
new_restaurant.save()
# продукты
# print(type(load_from_json('products1')))
products = load_from_json('products')
Products.objects.all().delete()
for product in products:
# print(product)
restaurant_name = product['restaurant']
_restaurant = Restaurant.objects.get(name=restaurant_name)
product['restaurant'] = _restaurant
category_name = product['category']
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Products(**product)
new_product.save()
# категории ресторанов
restaurant_category = load_from_json('restauran_category')
RestaurantCategory.objects.all().delete()
for RC in restaurant_category:
restaurant_name = RC['restaurant']
# print(restaurant_name)
# print(Restaurant.objects.get(name=restaurant_name))
_restaurant = Restaurant.objects.get(name=restaurant_name)
RC['restaurant'] = _restaurant
category_name = RC['category']
_category = ProductCategory.objects.get(name=category_name)
RC['category'] = _category
new_RC = RestaurantCategory(**RC)
new_RC.save()
def handle(self, *args, **options):
categories = loadFromJSON('categories')
# # ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**categories[category])
new_category.save()
products = loadFromJSON('products')
# Product.objects.all().delete()
for product in products:
category_name = products[product]['category']
_category = ProductCategory.objects.get(name=category_name)
products[product]['category'] = _category
new_product = Product(**products[product])
new_product.save()
# super_user = ShopUser.objects.create_superuser('admin', '*****@*****.**', '12345', age=36)
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategory.objects.all().delete()
for category in categories:
new_category = ProductCategory(**category)
new_category.save()
products = load_from_json('Products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
_category = ProductCategory.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
super_user = User.objects.create_superuser('admin', '', 'admin')
