def create_or_update_categories(self, selector):
categories = Category.objects.filter(active=True)
category_by_name = {c.name.lower(): c for c in categories}
category_by_css = {}
for option in selector.xpath('//select[@name="category"]/option'):
category_name = option.extract_first_value_with_xpath('./text()')
if category_name == '':
continue
category_css_name = option.extract_first_value_with_xpath(
'./@value')
lower_name = category_name.lower()
if lower_name in category_by_name:
cat = category_by_name.pop(lower_name)
if not cat.active:
cat.name = category_name.capitalize()
cat.active = True
cat.save()
self.debug_info(
'Reactive category {0}'.format(category_name))
else:
cat = Category(name=category_name.capitalize(), active=True)
cat.save()
self.debug_info(
'Create new category {0}'.format(category_name))
category_by_css[category_css_name] = cat
self.category_by_css = category_by_css
def setUp(self):
self.client = APIClient()
self.basic_client = Client()
self.user = User.objects.create_superuser(
email=EMAIL_TEST, password=PASSWORD_TEST)
self.other_user = User.objects.create_superuser(
email=OTHER_EMAIL_TEST, password=PASSWORD_TEST
)
self.category3 = Category.objects.create(
category_title='title3',
user=self.user,
category_type='INCOME'
)
self.category4 = Category.objects.create(
category_title='title4',
user=self.user,
category_type='EXPENSE'
)
self.category5 = Category.objects.create(
category_title='title5',
user=self.other_user,
category_type='EXPENSE'
)
self.not_saved_category = Category(
category_title='not_saved',
user=self.user,
category_type='EXPENSE'
)
def import_csv(request):
if request.method == "POST":
csv_file = request.FILES.get('csv_file')
if not csv_file.name.endswith('.csv'):
error = "Please add 'CSV' File!"
link = request.META.get('HTTP_REFERER')
context = {'error': error, 'link': link}
return render(request, 'back/error.html', context=context)
file_data = csv_file.read().decode('utf-8')
lines = file_data.split("\n") # alt satıra \n ile geçer
lines.pop(
0
) # burada biz gelen csv'de ilk satırda kolon isimleri olduğundan listeden çıkardık
lines.pop(len(lines) - 1) # son eleman '' döndüğünden çıkardık
for line in lines:
fields = line.split(
',') # yan yana kolonlar birbirinden ',' ile ayrılır
try:
if len(Category.objects.filter(name=fields[0])
) == 0: # eğer o isimde bir kategori yoksa
cat = Category(name=fields[0], count=0)
cat.save()
except:
print("exception!!!")
return redirect('panel:category_list')
def setUp(self):
"""
Before each the test function
"""
self.client = APIClient()
# Create a fake todo item
self.user = User(name='test', user_name='te-st',
email='*****@*****.**', age=20)
self.user.save()
self.category = Category(category_name=1)
self.category.save()
self.item_data = {
'title': 'Test',
'user': self.user.id,
'category': self.category.id
}
# Fake post request
self.response = self.client.post(
'/api/todo/',
self.item_data,
format='json'
)
def create_or_update_categories(self, response):
json_result = loads(response.body.decode('utf8'))
selector = scrapy.Selector(text=json_result['html'], type="html")
categories = Category.objects.filter(active=True)
category_by_name = {c.name.lower(): c for c in categories}
category_by_css = {}
for option in selector.xpath(
"//ul[contains(@class, 'dropdown-menu')]/li/a"):
category_name = option.extract_first_value_with_xpath('./text()')
if category_name == '':
continue
category_css_name = option.extract_first_value_with_xpath(
'./@value')
lower_name = category_name.lower()
if lower_name in category_by_name:
cat = category_by_name.pop(lower_name)
if not cat.active:
cat.name = category_name.capitalize()
cat.active = True
cat.save()
self.debug_info(
'Reactive category {0}'.format(category_name))
else:
cat = Category(name=category_name.capitalize(), active=True)
cat.save()
self.debug_info(
'Create new category {0}'.format(category_name))
product_list_url = option.extract_first_value_with_xpath('./@href')
url = urlparse.urljoin(self.__class__.catalogue_base_url,
product_list_url)
yield scrapy.http.Request(url,
callback=self.create_or_update_products)
category_by_css[category_css_name] = cat
self.category_by_css = category_by_css
def post(request, lang, category_id):
category_model = Category()
category = category_model.get_by_id(category_id)
groups = Group.get_all()
category_count = category.video_set.all().count()
category_count_en = category.videoen_set.all().count()
try:
if category_count == 0 and category_count_en == 0:
category_model.delete_category(category_id)
return HttpResponseRedirect(
'/{}/admin/categories'.format(lang))
except:
pass
title = category.name_ja
return TemplateResponse(
request, 'category.html', {
'title': title + ' | カテゴリー | FEED App 管理',
'category': category,
'groups': groups,
'form_data': {},
'error_messages': {
'delete': ['invalid']
},
'lang': lang,
})
def post(self, request):
try:
body: str = request.body.decode('utf-8')
req_body: Dict = loads(body)
try:
Category.objects.get(name=req_body['name'])
err_resp = {
'success': False,
'message':
f'Category with {req_body["name"]} already exists.'
}
return JsonResponse(data=err_resp, status=409)
except Category.DoesNotExist:
category = Category()
category.name = req_body['name']
category.type = req_body['type'] if req_body['type'] in [
'DEVICE',
'GARMENTS',
'ACCESSORIES',
] else 'DEVICE'
category.save()
data = category_serializer(category)
return JsonResponse(data=data, status=201)
except Exception as e:
err_resp = {'success': False, 'message': str(e)}
return JsonResponse(data=err_resp, status=500)
def save_or_update(req):
msg = ''
if req.method == 'POST':
if int(req.POST["id"]) > 0:
category = Category(id=req.POST["id"], type=req.POST["type"])
msg = "Updation Operation Successfully...!"
category.save()
else:
category = Category(type=req.POST["type"])
msg = "Add Operation Successfully...!"
category.save()
return render(req, 'category.html', {
"cat": dummy_category(),
"note": msg,
"categories": get_active_category()
})
def get(_, lang, image_id):
delete_flag = True
image_model = Image()
category_model = Category()
if lang == 'ja':
topic_model = Topic()
introduction_model = Introduction()
else:
topic_model = TopicEn()
introduction_model = IntroductionEn()
try:
image = image_model.get_by_image_id(image_id)
topic_use_flag, topic_use_posts = topic_model.is_use_image(
image.image_url, image.id)
if topic_use_flag is True:
delete_flag = False
introduction_use_flag, introduction_use_posts = \
introduction_model.is_use_image(image.image_url)
if introduction_use_flag is True:
delete_flag = False
category_use_flag, category_use_posts = category_model.is_use_image(
image.image_url)
if category_use_flag is True:
delete_flag = False
use_posts = (
topic_use_posts +
category_use_posts +
introduction_use_posts
)
def get_unique_list(seq):
seen = []
return [x for x in seq if x not in seen and not seen.append(x)]
use_posts = get_unique_list(use_posts)
return JsonResponse({
'status': 200,
'delete_flag': delete_flag,
'use_posts': use_posts,
}, status=200)
except Exception as e:
return JsonResponse({
'status': 500,
'message': 'Exception Error ' + str(e)
}, status=500)
def add_category(request):
if request.method == 'POST':
name = request.POST['name']
cat_type = request.POST['cat_type']
icon = request.FILES['icon']
category = Category(name = name, cat_type = cat_type, icon = icon)
if category:
category.save()
return redirect('category')
return render(request, 'category/add-category.html')
def setUp(self):
self.title = 'Test title'
self.user = User(
name='test', user_name='te-st', email='*****@*****.**', age=20)
self.user.save()
self.category = Category(category_name=1)
self.category.save()
self.item = Item(title=self.title, user=self.user,
category=self.category)
def post(self, request, format=None):
users = Users.objects.get(id=request.data['users_id'])
request.data['users'] = users
serializer = Category(id=request.data['id'],
name=request.data['name'],
parent=request.data['parent'],
is_featured=request.data['is_featured'],
is_active=request.data['is_active'],
description=request.data['description'],
users=request.data['users'])
if serializer:
serializer.save()
return Response("Added", status=status.HTTP_201_CREATED)
return Response(serializer, status=status.HTTP_400_BAD_REQUEST)
def requestView(request):
form = RequestForm(request.POST or None)
if form.is_valid():
new_request = Request(
user = request.user,
dateS = request.POST['dateS'],
dateE = request.POST['dateE'],
category = Category(request.POST['category']),
)
new_request.save()
context = {
'form': form
}
return render(request, "request.html", context)
def post(self):
"""
Create Category
name string min_length 3, max_length 50
:return:
"""
try:
data = CategoryParser.parse_args()
category = Category(**data).create()
return responses.SuccessResponse(marshal(category, CategorySchema),
status=201).send()
except CustomException as e:
return responses.ErrorResponse(message=e.detail,
status=e.status_code).send()
def post(request, lang, category_id):
category_model = Category()
category = category_model.get_by_id(category_id)
groups = Group.get_all()
form = CategoryForm(request.POST)
if category is None:
return HttpResponseRedirect('/{}/admin/categories'.format(lang))
if form.errors:
messages.add_message(request, messages.INFO,
dict(form.errors.items()))
if form.is_valid():
try:
category_model.edit_category(
category_id, {
'name_ja': form.cleaned_data.get('name_ja'),
'name_en': form.cleaned_data.get('name_en'),
'image': form.cleaned_data.get('image'),
'order': form.cleaned_data.get('order'),
'group': Group.get_by_id(
form.cleaned_data.get('group')),
})
return HttpResponseRedirect(
'/{}/admin/categories'.format(lang))
except:
pass
title = category.name_ja
return TemplateResponse(
request, 'category.html', {
'title': title + ' | カテゴリー | FEED App 管理',
'category': category,
'groups': groups,
'form_data': form.cleaned_data,
'error_messages': get_error_message(request),
'lang': lang,
})
def test_create_product(self):
category = Category(name='Category 1')
category.save()
product = Product.objects.create(name='product 1',
slug='product-1',
description='description',
images='',
price=600,
stock=True,
is_available=True,
category=category)
self.assertEqual(product.name, 'product 1')
self.assertEqual(product.slug, 'product-1')
self.assertEqual(product.description, 'description')
self.assertEqual(product.images, '')
self.assertEqual(product.price, 600)
self.assertEqual(product.stock, True)
self.assertEqual(product.is_available, True)
self.assertEqual(product.category, category)
def post(request, lang):
form = CategoryForm(request.POST)
category_model = Category()
if form.errors:
messages.add_message(request, messages.INFO,
dict(form.errors.items()))
if form.is_valid():
try:
category_model.create_category({
'name_ja':
form.cleaned_data.get('name_ja'),
'name_en':
form.cleaned_data.get('name_en'),
'image_url':
form.cleaned_data.get('image_url'),
'order':
form.cleaned_data.get('order'),
'group':
Group.get_by_id(form.cleaned_data.get('group')),
})
return HttpResponseRedirect(
'/{}/admin/categories'.format(lang))
except:
pass
groups = Group.get_all()
return TemplateResponse(
request, 'category_create.html', {
'title': '新規投稿 | カテゴリー | FEED App 管理',
'groups': groups,
'form_data': form.cleaned_data,
'error_messages': get_error_message(request),
'lang': lang,
})
def get(request, lang, category_id):
category_model = Category()
category = category_model.get_by_id(category_id)
groups = Group.get_all()
if category is None:
raise Http404
title = category.name_ja
return TemplateResponse(
request, 'category.html', {
'title': title + ' | カテゴリー | FEED App 管理',
'category': category,
'groups': groups,
'error_messages': {},
'form_data': {},
'lang': lang,
})
import requests
from django.core.files import File
from category.models import Category
from product.models import Product
from galleryitem.models import GalleryItem
#Categories
category1 = Category(name="Computadoras",
icon="computer",
description="Computadoras, Laptops")
category2 = Category(name="Telefonos",
icon="smartphone",
description="Android y iOS")
category3 = Category(name="Disco Duro",
icon="storage",
description="HDD y SSD")
category4 = Category(name="Memorias", icon="memory", description="RAM")
category5 = Category(name="Monitores",
icon="monitor",
description="IPS, Curvos, ...")
category6 = Category(name="Accesorios de Computadora",
icon="mouse",
description="Mouse, Teclado, ...")
category7 = Category(name="TV", icon="tv", description="LED, Smart, ...")
category8 = Category(name="Audio",
icon="headset",
description="Bocinas, Headsets, ...")
category9 = Category(name="Impresoras",
icon="printer",
description="Matriz, Laser, ...")
category10 = Category(name="Tarjetas de video",
def dummy_category():
return Category(id=0, type='')
def test_should_throw_error_if_category_already_exists(self):
with self.assertRaises(IntegrityError) as context_message:
self.my_category.save()
my_category_1 = Category(name="my_category")
my_category_1.save()
def setUp(self):
self.category = CategoryFactory()
self.my_category = Category(name="my_category")
def handle(self, *args, **kwargs):
#start_time = time.time()
with open('outoutfile.json') as json_file:
data = json.load(json_file)
#print(data)
i = 0
for product in data:
print(i)
#print(product)
title = product['title']
description = product['description']
category = product['category']
try:
categoryObj = Category.objects.get(title=category)
except:
categoryObj = Category(title=category, catalog_rep='A')
categoryObj.save()
#dbProduct = Product(name= title,content=(description or ''), category=categoryObj)
dbProductList = Product.objects.filter(name=title,
category=categoryObj)
dbProduct = dbProductList.first()
if dbProduct == None:
dbProduct = Product(category=categoryObj,
name=title,
content=(description or ''),
buy_cost=0)
print('creating new product ', dbProduct.name,
'description: ', dbProduct.content)
else:
dbProduct.content = description or ''
print('updating product ', dbProduct.name, 'description: ',
dbProduct.content)
#print(dbProduct.name)
#print(dbProduct.content)
#print(dbProduct.category)
dbProduct.save()
if 'image1' in product:
dbImage1 = ProductImage(product=dbProduct)
with open(product['image1'], 'rb') as f:
image_data = File(f)
dbImage1.image.save(product['image1'], image_data,
True)
dbImage1.save()
if 'image2' in product:
dbImage1 = ProductImage(product=dbProduct)
with open(product['image2'], 'rb') as f:
image_data = File(f)
dbImage1.image.save(product['image2'], image_data,
True)
dbImage1.save()
colors = []
if 'צבע' in product:
colors = product['צבע']
else:
colors = ['no color']
sizes = []
if 'גודל' in product:
sizes = product['גודל']
else:
sizes = ['one size']
import itertools
productStuckList = list(itertools.product(colors, sizes))
#print(productStuckList)
from provider.models import Provider
try:
defultProvider = Provider.objects.all()[0]
except:
defultProvider = Provider(name='defult provider')
defultProvider.save()
from packingType.models import PackingType
try:
defultPackingType = PackingType.objects.all()[0]
except:
defultPackingType = PackingType(name='defult packing')
defultPackingType.save()
for stock in productStuckList:
from stock.models import Stock
from productSize.models import ProductSize
dbProductSize = None
try:
dbProductSize = ProductSize.objects.get(size=stock[1])
except:
dbProductSize = ProductSize(size=stock[1])
dbProductSize.save()
from productColor.models import ProductColor
dbProductColor = None
try:
dbProductColor = ProductColor.objects.get(
name=stock[0])
except:
dbProductColor = ProductColor(name=stock[0])
dbProductColor.save()
stock, created = Stock.objects.update_or_create(
provider=defultProvider,
productSize=dbProductSize,
productColor=dbProductColor,
product=dbProduct,
packingType=defultPackingType)
print(created, stock.product, stock.productSize,
stock.productColor)
stock.save()
i += 1
#end_time = time.time()
#print('imported in ' + (end_time - start_time) + ' seconds' )
pass
def fill_db(self):
now = datetime.datetime.now(tz=pytz.utc)
last_week = now - datetime.timedelta(days=7)
last_month = now - datetime.timedelta(days=31)
c1 = Category(pk=1, name='Электроника')
c1.save()
c2 = Category(pk=2, name='Бытовая техника', parent=c1)
c2.save()
c3 = Category(pk=3, name='Телевизоры', parent=c1)
c3.save()
c4 = Category(pk=4, name='Телефоны', parent=c1)
c4.save()
c5 = Category(pk=5, name='Смартфоны', parent=c4)
c5.save()
c6 = Category(pk=6, name='Холодильники', parent=c2)
c6.save()
c7 = Category(pk=7, name='Стиральные машины', parent=c2)
c7.save()
c8 = Category(pk=8, name='Посудомоечные машины', parent=c2)
c8.save()
categories = (
c1,
c2,
c3,
c4,
c5,
c6,
c7,
c8,
)
stocks = (
Stock(pk=1,
article=100,
category=categories[2],
name='Телевизор LG',
price=10000,
number=10),
Stock(pk=2,
article=101,
category=categories[2],
name='Телевизор Samsung',
price=11000,
number=9),
Stock(pk=3,
article=102,
category=categories[2],
name='Телевизор Sony',
price=12000,
number=20),
Stock(pk=4,
article=103,
category=categories[6],
name='Стиральная машина LG',
price=10500,
number=5),
Stock(pk=5,
article=104,
category=categories[4],
name='Смартфон Samsung Galaxy Note 8',
price=13000,
number=18),
Stock(pk=6,
article=105,
category=categories[5],
name='Холодильник LG',
price=10000,
number=12),
Stock(pk=7,
article=106,
category=categories[5],
name='Холодильник Samsung',
price=15000,
number=0),
)
Stock.objects.bulk_create(stocks)
suppliers = (
Supplier(pk=1,
organization='LG',
address='680000, Хабаровск, ул. Большая, 1-1',
phone_number='111111',
email='*****@*****.**',
legal_details='ИНН: 9909111111',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Сидоров')),
Supplier(pk=2,
organization='Samsung',
address='680000, Хабаровск, ул. Большая, 1-2',
phone_number='111112',
email='*****@*****.**',
legal_details='ИНН: 9909111112',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Семенов')),
Supplier(pk=3,
organization='Sony',
address='680000, Хабаровск, ул. Большая, 1-3',
phone_number='111113',
email='*****@*****.**',
legal_details='ИНН: 9909111113',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Петров')),
)
Supplier.objects.bulk_create(suppliers)
for i in range(7):
sc = SupplierCategory(supplier=suppliers[0],
category=categories[i])
sc.save()
sc = SupplierCategory(supplier=suppliers[1],
category=categories[i])
sc.save()
for i in range(6):
sc = SupplierCategory(supplier=suppliers[2],
category=categories[i])
sc.save()
customers = (
Customer(pk=1,
full_name='Иван Иванович Иванов',
phone_number='222222',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Иван Иванович Иванов')),
Customer(pk=2,
full_name='Петр Петрович Петров',
phone_number='222223',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Петр Петрович Петров')),
Customer(pk=3,
full_name='Светлана Семеновна Семенова',
phone_number='222224',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Светлана Семеновна Семенова')),
Customer(pk=4,
full_name='Анна Николаевна Николаева',
phone_number='222225',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Анна Николаевна Николаева')),
)
Customer.objects.bulk_create(customers)
cargo = (
Cargo(pk=1, supplier=suppliers[0], date=last_week),
Cargo(pk=2, supplier=suppliers[0], date=last_month),
Cargo(pk=3, supplier=suppliers[1], date=last_week),
Cargo(pk=4, supplier=suppliers[1], date=last_week),
Cargo(pk=5, supplier=suppliers[0], date=last_week),
)
Cargo.objects.bulk_create(cargo)
CargoStock.objects.create(cargo=cargo[0], stock=stocks[0], number=10)
CargoStock.objects.create(cargo=cargo[1], stock=stocks[3], number=5)
CargoStock.objects.create(cargo=cargo[1], stock=stocks[5], number=15)
CargoStock.objects.create(cargo=cargo[2], stock=stocks[0], number=10)
CargoStock.objects.create(cargo=cargo[2], stock=stocks[4], number=20)
CargoStock.objects.create(cargo=cargo[3], stock=stocks[6], number=10)
CargoStock.objects.create(cargo=cargo[4], stock=stocks[6], number=10)
shipments = (
Shipment(pk=1, customer=customers[0], date=now),
Shipment(pk=2, customer=customers[0], date=now),
Shipment(pk=3, customer=customers[0], date=now),
Shipment(pk=4, customer=customers[1], date=now),
Shipment(pk=5, customer=customers[2], date=now),
Shipment(pk=6, customer=customers[0], date=now),
Shipment(pk=7, customer=customers[1], date=now),
Shipment(pk=8, customer=customers[2], date=now),
)
Shipment.objects.bulk_create(shipments)
ShipmentStock.objects.create(shipment=shipments[0],
stock=stocks[6],
number=10)
ShipmentStock.objects.create(shipment=shipments[1],
stock=stocks[4],
number=1)
ShipmentStock.objects.create(shipment=shipments[2],
stock=stocks[5],
number=1)
ShipmentStock.objects.create(shipment=shipments[3],
stock=stocks[5],
number=2)
ShipmentStock.objects.create(shipment=shipments[4],
stock=stocks[0],
number=1)
ShipmentStock.objects.create(shipment=shipments[0],
stock=stocks[4],
number=1)
ShipmentStock.objects.create(shipment=shipments[6],
stock=stocks[5],
number=5)
ShipmentStock.objects.create(shipment=shipments[4],
stock=stocks[5],
number=4)
ShipmentStock.objects.create(shipment=shipments[5],
stock=stocks[4],
number=3)
ShipmentStock.objects.create(shipment=shipments[7],
stock=stocks[2],
number=7)
def add_category(category_entry):
print('Category:', category_entry['name'])
item = Category(**category_entry)
item.save()
