def save(self):
items_csv = csv.reader(self.cleaned_data["file"])
Item.objects.all().delete()
for item_csv in items_csv:
item = Item()
item.item_id = item_csv[0]
item.name = item_csv[1]
item.category = item_csv[2]
item.price_cash = item_csv[3]
item.price_credit = item_csv[4]
item.save()
def get_or_create_item(item_name):
"""
Get or Create an Item instance
:param item_name: string
:return item: Item instance
"""
try:
item = Item.objects.get(name=item_name)
except Item.DoesNotExist:
item = Item()
item.name = item_name
item.save()
return item
def add( request ):
name = request.GET.get( 'name', '' )
mass = request.GET.get( 'mass', '' )
if name and mass:
item = Item()
item.name = name
item.mass = mass
item.item_id = len( Item.objects.all() )
item.save()
return HttpResponseRedirect( '/items/' )
item = Item.objects.all()
return render( request, 'items/add.html' )
def populate_items():
items = populate_instance(Item, API_ITEMS_URL, 'items')
for item in items:
try:
Item.objects.get(pk=item['id'])
continue
except Item.DoesNotExist:
new_instance = Item()
new_instance.id = item['id']
new_instance.name = item['name']
new_instance.localized_name = item['localized_name']
new_instance.is_recipe = item['recipe']
new_instance.cost = item['cost']
new_instance.save()
def handle(self, *args, **kwargs):
"""Loop thru Enum object ItemType and create sample data
Eg. For total = 10 will create 10 sample Item data into db
"""
current_time = timezone.now()
for x in ItemType:
prefix = x.name[:1]
for i in range(0, kwargs['total']):
item = Item()
item.sku = prefix + str(randint(1000000, 9999999))
item.name = x.name[:3] + str(randint(1, 99909990))
item.item_type = x.value
item.active_timestamp = current_time
item.expiry_timestamp = current_time + timedelta(days=5)
item.save()
price = Price()
price.item = item
price.price = uniform(10.00, 200.00)
price.effective_timestamp = current_time - timedelta(days=10)
price.save()
