def handle_upload(self):
print("Started...")
self.data = self.data_as_list()
currency_list = self.data[0]
lan_list = self.data[1]
for row in currency_list:
country_objects = Country.objects.filter(name=row[0],
short_name2=row[1],
short_name3=row[2])
if not country_objects.exists():
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Country doesn\'t exist. Data: %s' % row
error_log.save()
continue
country_object = country_objects.first()
currency_objects = Currency.objects.filter(short_name=row[3])
if not currency_objects:
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Currency doesn\'t exist. Data: %s' % row
error_log.save()
continue
currency_object = currency_objects.first()
currency_object.country_id = country_object.pk
currency_object.save()
for row in lan_list:
country_objects = Country.objects.filter(name=row[0],
short_name2=row[1],
short_name3=row[2])
if not country_objects.exists():
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Country doesn\'t exist. Data: %s' % row
error_log.save()
continue
country_object = country_objects.first()
language_objects = Language.objects.filter(short_name=row[3])
if not language_objects:
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'language doesn\'t exist. Data: %s' % row
error_log.save()
continue
language_object = language_objects.first()
language_object.country_id = country_object.pk
language_object.save()
print("Ended...")
def handle_upload(self):
print("Started...")
self.data = self.data_as_list()
for row in self.data:
if len(row) != 3:
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Invalid format in country upload'
error_log.save()
continue
country_objects = Country.objects.filter(name=row[0],
short_name2=row[1],
short_name3=row[2])
if country_objects.exists():
country_object = country_objects.first()
else:
country_object = Country()
country_object.name = row[0]
country_object.short_name2 = row[1]
country_object.short_name3 = row[2]
country_object.save()
print("Ended...")
def handle_upload(self):
BookLanguage.objects.all().delete()
Language.objects.all().delete()
self.data = self.data_as_list()
for row in self.data:
if len(row) != 2:
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Invalid format in language upload'
error_log.save()
continue
language_objects = Language.objects.filter(short_name=row[0])
if language_objects.exists():
language_object = language_objects.first()
else:
language_object = Language()
language_object.short_name = row[0]
language_object.name = row[1]
language_object.save()
book_language_objects = BookLanguage.objects.filter(
short_name=row[0])
if book_language_objects.exists():
book_language_object = book_language_objects.first()
else:
book_language_object = BookLanguage()
book_language_object.short_name = row[0]
book_language_object.name = row[1]
book_language_object.save()
def handle_upload(self):
self.data = self.data_as_list()
for row in self.data:
if len(row) != 2:
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Invalid format in currency upload'
error_log.save()
continue
currency_objects = Currency.objects.filter(short_name=row[0])
if currency_objects.exists():
currency_object = currency_objects.first()
else:
currency_object = Currency()
currency_object.short_name = row[0]
currency_object.name = row[1]
currency_object.save()
def handle_rent_price_upload(self):
for row in self.data:
with transaction.atomic():
index = 0
rent_code = row[index]
index += 1
product_code = row[index]
index += 1
is_new = row[index]
index += 1
print_type = row[index]
index += 1
price_in_percentage = row[index]
index += 1
is_special_rent = row[index]
index += 1
special_rent_rate = row[index]
index += 1
offer_start_date = row[index]
index += 1
offer_end_date = row[index]
index += 1
currency = row[index]
if any([
not item for item in [
rent_code, product_code, is_new, print_type,
price_in_percentage, currency
]
]):
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Missing data.'
error_log.save()
continue
product_objects = Book.objects.filter(code=product_code)
if product_objects.exists():
product_object = product_objects.first()
else:
ErrorLog.log(
url='',
stacktrace=
'Invalid product code supplied. Skipping... Data %s' %
product_code)
continue
try:
is_new = int(is_new)
if is_new != 1 and is_new != 0:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_new supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if is_new == 1:
is_new = True
else:
is_new = False
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_new supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if not print_type in settings.SUPPORTED_PRINTING_TYPES:
ErrorLog.log(
url='',
stacktrace='printing type must be in %s. Skipping...' %
settings.SUPPORTED_PRINTING_TYPES)
continue
try:
price_in_percentage = Decimal(price_in_percentage)
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid price_in_percentage value. Decimal expected. Given: %s'
% row)
continue
try:
is_special_rent = int(is_special_rent)
if is_special_rent != 1 and is_special_rent != 0:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_special_rent supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if is_special_rent == 1:
is_special_rent = True
else:
is_special_rent = False
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_special_rent supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
try:
special_rent_rate = Decimal(special_rent_rate)
except:
if is_special_rent:
ErrorLog.log(
url='',
stacktrace=
'Invalid special_rent_rate value. Decimal expected. Given: %s'
% row)
continue
if is_special_rent:
if not offer_start_date or not offer_end_date:
ErrorLog.log(
url='',
stacktrace='Offer dates missing. Skipping...Data: '
% row)
continue
currency_objects = Currency.objects.filter(short_name=currency)
if currency_objects.exists():
currency_object = currency_objects.first()
else:
ErrorLog.log(
url='',
stacktrace=
'Invalid currency code value. Skipping...Data: ' % row)
continue
price_objects = PriceMatrix.objects.filter(
product_model='Book',
product_code=product_code,
is_new=is_new,
print_type=print_type)
if price_objects.exists():
price_object = price_objects.first()
else:
ErrorLog.log(
url='',
stacktrace=
'No price matrix object exists for this. Skipping...Data: '
% row)
continue
rent_plan_objects = RentPlan.objects.filter(code=rent_code)
if rent_plan_objects.exists():
rent_plan_object = rent_plan_objects.first()
else:
ErrorLog.log(
url='',
stacktrace='No rent plan exists. Skipping...Data: ' %
row)
continue
rent_rel_objects = RentPlanRelation.objects.filter(
plan_id=rent_plan_object.pk,
price_matrix_id=price_object.pk)
if rent_rel_objects.exists():
rent_rel_object = rent_rel_objects.first()
else:
rent_rel_object = RentPlanRelation(
plan_id=rent_plan_object.pk,
price_matrix_id=price_object.pk)
rent_plan_object.rent_rate = price_in_percentage
if is_special_rent:
rent_rel_object.start_time = Clock.convert_datetime_to_timestamp(
offer_start_date)
rent_rel_object.end_time = Clock.convert_datetime_to_timestamp(
offer_end_date)
rent_rel_object.special_rate = float(
special_rent_rate) / 100
rent_rel_object.is_special_offer = is_special_rent
rent_rel_object.save()
print("Done! Proceed to the next...")
def handle_sale_price_upload(self):
PriceMatrix = load_model(app_label="ecommerce",
model_name="PriceMatrix")
for row in self.data:
with transaction.atomic():
index = 0
product_code = row[index]
index += 1
is_new = row[index]
index += 1
print_type = row[index]
index += 1
market_price = row[index]
index += 1
base_price = row[index]
index += 1
sale_price = row[index]
index += 1
initial_rent_payable_price = row[index]
index += 1
is_special_sale = row[index]
index += 1
special_sale_rate = row[index]
index += 1
offer_start_date = row[index]
index += 1
offer_end_date = row[index]
index += 1
currency = row[index]
if any([
not item for item in [
product_code, is_new, print_type, market_price,
base_price, currency
]
]):
error_log = ErrorLog()
error_log.url = ''
error_log.stacktrace = 'Missing data.'
error_log.save()
continue
product_objects = Book.objects.filter(code=product_code)
if product_objects.exists():
product_object = product_objects.first()
else:
ErrorLog.log(
url='',
stacktrace=
'Invalid product code supplied. Skipping... Data %s' %
product_code)
continue
try:
is_new = int(is_new)
if is_new != 1 and is_new != 0:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_new supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if is_new == 1:
is_new = True
else:
is_new = False
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_new supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if not print_type in settings.SUPPORTED_PRINTING_TYPES:
ErrorLog.log(
url='',
stacktrace='printing type must be in %s. Skipping...' %
settings.SUPPORTED_PRINTING_TYPES)
continue
try:
market_price = Decimal(market_price)
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid market_price value. Decimal expected. Given: %s'
% row)
continue
try:
base_price = Decimal(base_price)
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid base_price value. Decimal expected. Given: %s'
% row)
continue
try:
if sale_price:
sale_price = Decimal(sale_price)
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid sale_price value. Decimal expected. Given: %s'
% row)
continue
try:
if initial_rent_payable_price:
initial_rent_payable_price = Decimal(
initial_rent_payable_price)
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid initial_rent_payable_price value. Decimal expected. Given: %s'
% row)
continue
try:
is_special_sale = int(
is_special_sale) if is_special_sale else 0
if is_special_sale != 1 and is_special_sale != 0:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_special_sale supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
if is_special_sale == 1:
is_special_sale = True
else:
is_special_sale = False
except:
ErrorLog.log(
url='',
stacktrace=
'Invalid is_special_sale supplied. 1 or 0 expected. Skipping... Data %s'
% row)
continue
try:
special_sale_rate = Decimal(special_sale_rate)
except:
if is_special_sale:
ErrorLog.log(
url='',
stacktrace=
'Invalid special_sale_rate value. Decimal expected. Given: %s'
% row)
continue
try:
offer_start_date = offer_start_date
except:
if is_special_sale:
ErrorLog.log(
url='',
stacktrace=
'Invalid offer_start_date value. Skipping... Expected format: dd/mm/yyyy. Given'
% row)
continue
try:
offer_end_date = offer_end_date
except:
if is_special_sale:
ErrorLog.log(
url='',
stacktrace=
'Invalid offer_end_date value. Skipping... Expected format: dd/mm/yyyy. Given'
% row)
continue
currency_objects = Currency.objects.filter(short_name=currency)
if currency_objects.exists():
currency_object = currency_objects.first()
else:
ErrorLog.log(
url='',
stacktrace=
'Invalid currency code value. Skipping...Data: ' % row)
continue
price_objects = PriceMatrix.objects.filter(
product_model='Book',
product_code=product_code,
is_new=is_new,
print_type=print_type)
if price_objects.exists():
price_object = price_objects.first()
else:
price_object = PriceMatrix(product_model='Book',
product_code=product_code,
is_new=is_new,
print_type=print_type)
price_object.is_rent = False
price_object.market_price = market_price
price_object.base_price = base_price
price_object.currency_id = currency_object.pk
if is_special_sale:
offer_start_ts = Clock.convert_datetime_to_timestamp(
offer_start_date)
offer_end_ts = Clock.convert_datetime_to_timestamp(
offer_end_date)
price_object.offer_date_start = offer_start_ts
price_object.offer_date_end = offer_end_ts
price_object.special_price = is_special_sale
if is_special_sale:
price_object.offer_price_p = float(special_sale_rate) / 100
price_object.offer_price_v = float(base_price) * (
float(special_sale_rate) / 100)
else:
price_object.offer_price_p = 1.0
price_object.offer_price_v = base_price
if sale_price:
price_object.sale_price = sale_price
if initial_payable_rent_price:
price_object.initial_payable_rent_price = initial_payable_rent_price
price_object.save()