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: 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() 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: 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 = 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): 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 = 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 = 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() # Создаем суперпользователя при помощи менеджера модели 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, **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() # Создаем суперпользователя 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() 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)
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, **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 import_categories(csv_filename): data_reader = csv.reader(open(csv_filename), delimiter=',', quotechar='"') categories = [category.name for category in ProductCategory.objects.all()] for row in data_reader: if row[0] not in categories: category = ProductCategory() category.name = row[0] category.description = row[1] category.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 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 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.json') ProductCategory.objects.all().delete() for category in categories: new_category = ProductCategory(**category) new_category.save() products = load_from_json('products.json') Product.objects.all().delete() for product in products: _category = ProductCategory.objects.get(id=product['category']) product['category'] = _category new_product = Product(**product) new_product.save() super_user = ShopUser.objects.create_superuser('django_admin', '*****@*****.**', 'superpass123', age=120)
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')
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() product = load_from_json('products') Product.objects.all().delete() for prod in product: category_name = prod['category'] prod['category'] = ProductCategory.objects.get(name=category_name) new_product = Product(**prod) new_product.save() # Создаем суперпользователя при помощи менеджера модели super_user = ShopUser.objects.create_superuser('django', '*****@*****.**', 'geekbrains', age=32)
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 = ShopUser.objects.create_superuser( 'django', '*****@*****.**', 'geekbrains', age=31)