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