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, **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 = 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('mainapp_productcategory')
# subcategories = load_from_json('mainapp_productsubcategory')
ProductCategory.objects.all().delete()
[ProductCategory.objects.create(**category) for category in categories]
# ProductSubCategory.objects.all().delete()
# [ProductSubCategory.objects.create(**subcategory) for subcategory in subcategories]
products = load_from_json('mainapp_product')
Product.objects.all().delete()
for product in products:
product['category'] = ProductCategory.objects.get(
name=product['category'])
# product['subcategory'] = ProductSubCategory.objects.get(name=product['subcategory'])
new_product = Product(**product)
new_product.save()
if not ShopUser.objects.filter(username='******').exists():
ShopUser.objects.create_superuser('django',
'djangо@geekshop.local',
'geekbrains',
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()
# Создаём суперпользователя
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()
# Создаем суперпользователя при помощи менеджера модели
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:
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"]
# Получаем категорию по имени
_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):
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 = 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('catalog')
Catalog.objects.all().delete()
for category in categories:
new_category = Catalog(**category['fields'], pk=category['pk'])
new_category.save()
products = load_from_json('product')
Product.objects.all().delete()
for product in products:
category_id = product['fields']['category']
catalog_obj = Catalog.objects.get(id=category_id)
product['fields']['category'] = catalog_obj
new_product = Product(**product['fields'], pk=product['pk'])
new_product.save()
# Создаем суперпользователя при помощи менеджера модели
CakeShopUser.objects.all().delete()
super_user = CakeShopUser.objects.create_superuser(
username='******', password='******', email='')
user = CakeShopUser.objects.create_user(username='******',
password='******',
email='')
print("Данные успешно загружены")
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()
[ProductCategory.objects.create(**category) for category in categories]
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
# Получаем категорию по имени
# _category = ProductCategory.objects.get(name=category_name)
# _category = ProductCategory.objects.filter(name=category_name).first()
# _category = list(ProductCategory.objects.filter(name=category_name))[0]
_category = ProductCategory.objects.get(
name=category_name) # .get() -> concrete object
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# if not len(ShopUser.objects.filter(username='******'))
# if ShopUser.objects.filter(username='******').count() == 0:
if not ShopUser.objects.filter(username='******').exists():
# создать обычный экземпляр моделей, без особенных свойств (обычного пользователя)
# ShopUser.objects.create(username='******',
# email='*****@*****.**',
# password='******')
# создать суперюзера
ShopUser.objects.create_superuser(username='******',
email='*****@*****.**',
password='******',
age='29')
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()
[ProductCategory.objects.create(**category) for category in categories]
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_name = product['category']
# Получаем категорию по имени
# _category = ProductCategory.objects.get(name=category_name)
# _category = ProductCategory.objects.filter(name=category_name).first()
# _category = list(ProductCategory.objects.filter(name=category_name))[0]
_category = ProductCategory.objects.get(
name=category_name) # .get() -> concrete object
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
# if not len(ShopUser.objects.filter(username='******'))
# if ShopUser.objects.filter(username='******').count() == 0:
if not ShopUser.objects.filter(username='******').exists():
# ShopUser.objects.create(username='******', email='*****@*****.**', password='******')
ShopUser.objects.create_superuser(username='******',
email='*****@*****.**',
password='******')
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 = 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):
gender = loadFromJSON('genders')
Gender.objects.all().delete()
for category in gender:
new_category = Gender(**category)
new_category.save()
categories = loadFromJSON('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
menu_category = loadFromJSON('menu_categories')
MenuCategory.objects.all().delete()
for category in menu_category:
new_category = MenuCategory(**category)
new_category.save()
brand = loadFromJSON('brands')
Brand.objects.all().delete()
for category in brand:
new_category = Brand(**category)
new_category.save()
size = loadFromJSON('sizes')
Size.objects.all().delete()
for category in size:
new_category = Size(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
# заменяем пол на объект:
gender_name = product["gender"]
_gender = Gender.objects.get(name=gender_name)
product["gender"] = _gender
# заменяем категорию на объект:
category_name = product["category"]
_category = Category.objects.get(name=category_name)
product["category"] = _category
# заменяем меню_категорию на объект:
menu_category_name = product["menu_category"]
_menu_category = MenuCategory.objects.get(name=menu_category_name)
product["menu_category"] = _menu_category
# заменяем бренд на объект:
brand_name = product["brand"]
_brand = Brand.objects.get(name=brand_name)
product["brand"] = _brand
# заменяем размер на объект:
size_name = product["size"]
_size = Size.objects.get(name=size_name)
product["size"] = _size
# пихаем все в Product и сохраняем:
new_product = Product(**product)
new_product.save()
def handle(self, *args, **options):
categories = load_from_json('categories')
ProductCategories.objects.all().delete()
for category in categories:
new_category = ProductCategories(**category)
new_category.save()
products = load_from_json('products')
Product.objects.all().delete()
for product in products:
category_get_param = product["category"]
if isinstance(category_get_param, int):
_category = ProductCategories.objects.get(
id=category_get_param)
else:
_category = ProductCategories.objects.get(
name=category_get_param)
product['category'] = _category
new_product = Product(**product)
new_product.save()
super_user = ShopUser.objects.create_superuser('admin',
None,
'123456',
age=30)
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('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()
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, **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 = 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()
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, **options):
goods = load_from_csv('goods.csv')
goods.pop(0)
Product.objects.all().delete()
for item in goods:
print(item)
if int(item[2]) < 1000:
price_rozn = 1.2 * int(item[2])
else:
price_rozn = 1.1 * int(item[2])
product = {
'article': 'ПТ' + item[0],
'name': item[1],
'price_rozn': price_rozn,
'price_zakup': 0.9 * int(item[2]),
}
new_product = Product(**product)
new_product.save()
# Создаем суперпользователя/манагера при помощи менеджера модели
super_user = ShopUser.objects.create_superuser('*****@*****.**', 2, 'django')
print('goods added, superuser/manager created! login: [email protected] password: django')
def get_products():
if settings.LOW_CACHE:
key = 'all_products'
products = cache.get(key)
if products is None:
products = Product.get_items()
cache.set(key, products)
return products
return Product.get_items()
def get_products_by_category(pk):
if settings.LOW_CACHE:
key = f'category_{pk}_products'
products = cache.get(key)
if products is None:
products = Product.get_items().filter(category_id=pk)
cache.set(key, products)
return products
return Product.get_items().filter(category_id=pk)
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 setUp(self):
self.test_User = ShopUser(age='23')
self.test_User.save()
self.test_Product = Product(name='test_name', desc='test_desk', desc_full='test_desk_full', price=33,
price_low=21, count=44, image='test_image')
self.test_Product.save()
self.basket = Basket(user=self.test_User, product=self.test_Product, quantity=2)
self.basket.save()
def tearDown(self):
pass
