From 63b0fc6269b38edf7234b9f151b80d81f614c0a3 Mon Sep 17 00:00:00 2001 From: Filipp Lepalaan Date: Tue, 4 Aug 2015 10:11:24 +0300 Subject: Initial commit First public commit --- servo/management/commands/updateprices.py | 63 +++++++++++++++++++++++++++++++ 1 file changed, 63 insertions(+) create mode 100644 servo/management/commands/updateprices.py (limited to 'servo/management/commands/updateprices.py') diff --git a/servo/management/commands/updateprices.py b/servo/management/commands/updateprices.py new file mode 100644 index 0000000..a916870 --- /dev/null +++ b/servo/management/commands/updateprices.py @@ -0,0 +1,63 @@ +# -*- coding: utf-8 -*- +# Copyright (c) 2013, First Party Software +# All rights reserved. + +# Redistribution and use in source and binary forms, with or without modification, +# are permitted provided that the following conditions are met: + +# 1. Redistributions of source code must retain the above copyright notice, +# this list of conditions and the following disclaimer. + +# 2. Redistributions in binary form must reproduce the above copyright notice, +# this list of conditions and the following disclaimer in the documentation +# and/or other materials provided with the distribution. + +# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" +# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE +# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE +# ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE +# LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR +# CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT +# OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) +# HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, +# WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) +# ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF +# SUCH DAMAGE. + +import sys +import logging + +from django.core.management.base import BaseCommand +from servo.models import (Product, GsxAccount, User,) + + +class Command(BaseCommand): + help = "Updates all part prices from GSX" + + def handle(self, *args, **options): + if len(args) < 1: + print "Usage: updateprices username [start:finish]" + sys.exit(1) + + start, counter = 0, 0 + finish = 999999999999 + + if len(args) == 2: + start, finish = args[1].split(':') + + GsxAccount.default(User.objects.get(username=args[0])) + + products = Product.objects.filter(pk__gt=start, pk__lt=finish) + products = products.exclude(part_type='SERVICE') + products = products.exclude(fixed_price=True) + + for i in products.order_by('id'): + logging.debug('Updating product %d' % i.pk) + try: + i.update_price() + i.save() + counter += 1 + except Exception, e: + logging.debug(e) + + print '%d product prices updated' % counter -- cgit v1.2.3