def handle(self, *args, **options):
categories = json_loader('new_categories')
for category in categories:
new_category = Category(**category)
new_category.save()
print('new_category added')
def handle(self, *args, **options):
categories = loadFromJSON('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
def get_category(self, category_name):
category = Category.objects.filter(buyer__in=(
DEFAULT_USER,
self.request.user,
)).filter(name=category_name).order_by('-buyer').first()
if not category:
category = Category()
category.buyer = self.request.user
category.name = category_name
last_category = Category.objects.filter(
buyer_id=category.buyer).order_by('-category_id').first()
category.category_id = last_category.category_id + 1 if last_category else 1
category.save()
return category
def handle(self, *args, **options):
categories = loadFromJSON('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
products = loadFromJSON('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
_category = Category.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
def handle(self, *args, **options):
categories = loadFromJSON('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
products = loadFromJSON('products')
for product in products:
category_name = product["category"]
_category = Category.objects.get(name=category_name)
product['category'] = _category
new_product = Product(**product)
new_product.save()
super_user = ShopUser.objects.create_superuser('admin', '*****@*****.**', '123456', age=28)
def handle(self, *args, **options):
categories = load_json('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
products = load_json('products')
Product.objects.all().delete()
for product in products:
category_name = product["category"]
# Получаем категорию по имени
_category = Category.objects.get(name=category_name)
# Заменяем название категории объектом
product['category'] = _category
new_product = Product(**product)
new_product.save()
def handle(self, *args, **options):
data = load_from_json()
Category.objects.all().delete()
for category in data['categories']:
new_cat = Category(**category)
print(f'Добавлена категория {new_cat}')
new_cat.save()
Brand.objects.all().delete()
for brand in data['brands']:
new_brand = Brand(**brand)
print(f'Добавлен бренд {new_brand}')
new_brand.save()
Product.objects.all().delete()
for product in data['products']:
_category = Category.objects.get(name=product['category'])
product['category'] = _category
_brand = Brand.objects.get(name=product['brand'])
product['brand'] = _brand
new_product = Product(**product)
print(f'Добавлен продукт {new_product}')
new_product.save()
ShopUser.objects.all().delete()
super_user = ShopUser.objects.create_superuser('django',
'*****@*****.**',
'geekbrains',
age=30)
print(f'Пользователь {super_user} создан!\nПароль: geekbrains')
def handle(self, *args, **options):
categories = loadFromJSON('categories')
Category.objects.all().delete()
for category in categories:
new_category = Category(**category)
new_category.save()
books = loadFromJSON('books')
Book.objects.all().delete()
for book in books:
category_name = book['category']
_category = Category.objects.get(name=category_name)
book['category'] = _category
new_book = Book(**book)
new_book.save()
ShopUser.objects.all().delete()
super_user = ShopUser.objects.create_superuser('lulik',
'*****@*****.**',
'luliksuperuser',
age=30)
def handle(self, *args, **kwargs):
data = loadFromJSON('data')
Category.objects.all().delete()
Author.objects.all().delete()
Item.objects.all().delete()
for rec in data:
if rec['model'] == 'mainapp.category':
new_category = Category(**rec['fields'])
new_category.save()
if rec['model'] == 'mainapp.author':
new_author = Author(**rec['fields'])
new_author.save()
for rec in data:
if rec['model'] == 'mainapp.item':
category_id = rec['fields']['category']
author_id = rec['fields']['author']
_category = Category.objects.all()[0]
_author = Author.objects.all()[0]
rec['fields']['category'] = _category
rec['fields']['author'] = _author
new_item = Item(**rec['fields'])
new_item.save()
def handle(self, *args, **options):
clear = input('Clear databases in mainapp (y/n)? ').lower()
if clear == 'y':
CatalogMenu.objects.all().delete()
MainMenu.objects.all().delete()
NewMenu.objects.all().delete()
Product.objects.all().delete()
Address.objects.all().delete()
Category.objects.all().delete()
for i in (
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_category";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_product";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_mainmenu";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_catalogmenu";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_newmenu";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_address";',
'UPDATE SQLITE_SEQUENCE SET SEQ= 0 WHERE NAME="mainapp_product_category";'
):
connection.cursor().execute(i)
su = input('Create superuser (y/n)? ').lower()
if su == 'y':
CustomUser.objects.create_superuser(
input('Введите имя суперпользователя: '),
'*****@*****.**',
input('Введите пароль суперпользователя: '),
age=18)
categories = load_from_json('all_categories')
for category in categories:
new_category = Category(**category)
new_category.save()
products = load_from_json('all_products')
for product_data in products:
category_names = product_data['category']
product_data.pop('category')
new_product = Product.objects.create(**product_data)
for category_name in category_names:
_category = Category.objects.get(name=category_name)
new_product.category.add(_category)
main_menu = load_from_json('main_menu')
for link in main_menu:
new_link = MainMenu(**link)
new_link.save()
new_menu = load_from_json('new_menu')
for link in new_menu:
category = Category.objects.get(name=link['category'])
link['category'] = category
new_link = NewMenu(**link)
new_link.save()
catalog_menu = load_from_json('catalog_menu')
for link in catalog_menu:
category = Category.objects.get(name=link['category'])
link['category'] = category
new_link = CatalogMenu(**link)
new_link.save()
addresses = load_from_json('all_addresses')
for link in addresses:
new_address = Address(**link)
new_address.save()