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/deleteorders.py | 54 +++++++++++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 servo/management/commands/deleteorders.py (limited to 'servo/management/commands/deleteorders.py') diff --git a/servo/management/commands/deleteorders.py b/servo/management/commands/deleteorders.py new file mode 100644 index 0000000..e531029 --- /dev/null +++ b/servo/management/commands/deleteorders.py @@ -0,0 +1,54 @@ +# -*- 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 logging +from django.core.management.base import BaseCommand + +from servo.models import (Order, Repair,) + +class Command(BaseCommand): + help = "Deletes orders listed in text file" + + def handle(self, *args, **options): + if len(args) < 1: + print 'Usage: deleteorders data.txt' + sys.exit(1) + + counter = 0 + dataf = open(args[0], 'r') + + for l in dataf.readlines(): + cols = l.strip().split("\t") + try: + print 'Deleting order %s' % cols[0] + order = Order.objects.get(code=cols[0]) + Repair.objects.filter(order=order).delete() + order.delete() + counter += 1 + except Order.DoesNotExist: + pass + + print '%d orders deleted' % counter -- cgit v1.2.3