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