Cleanup

1 files changed, 25 insertions, 25 deletions

diff --git a/servo/management/commands/backup.py b/servo/management/commands/backup.py
index 9d63b27..28129e6 100644
--- a/servo/management/commands/backup.py
+++ b/servo/management/commands/backup.py
@@ -24,7 +24,7 @@ def write(path, header, cursor):
 class Command(BaseCommand):
 
     help = 'Export this servo database in a portable format'
-    
+
     def handle(self, *args, **options):
         # creates a folder, then dumps different portable tables as separate
         # files to it, then compresses the folder and deletes it
@@ -33,50 +33,50 @@ class Command(BaseCommand):
 
         dirname = datetime.now().strftime('%Y%m%d-%H%M')
         backupdir = os.path.join(settings.BACKUP_DIR, dirname)
-        
+
         if not os.path.exists(backupdir):
             os.mkdir(backupdir)
 
         path = os.path.join(backupdir, 'notes.csv')
 
         cursor = connection.cursor()
-        cursor.execute("""SELECT id, order_id, created_by_id, created_at, body 
-            FROM servo_note""")
+        cursor.execute("""SELECT id, order_id, created_by_id, created_at, body
+                       FROM servo_note""")
         header = ['ID', 'ORDER_ID', 'USER_ID', 'CREATED_AT', 'NOTE']
         write(path, header, cursor)
 
         path = os.path.join(backupdir, 'users.csv')
         header = ['ID', 'USERNAME', 'FIRST_NAME', 'LAST_NAME', 'EMAIL']
-        cursor.execute("""SELECT id, username, first_name, last_name, email 
+        cursor.execute("""SELECT id, username, first_name, last_name, email
             FROM servo_user WHERE is_visible = TRUE""")
         write(path, header, cursor)
 
         path = os.path.join(backupdir, 'orders.csv')
-        header = ['ID', 'CODE', 'CREATED_AT', 
-            'CLOSED_AT', 'CUSTOMER_ID', 'USER_ID', 'QUEUE_ID']
-        cursor.execute("""SELECT id, code, created_at, closed_at, 
+        header = ['ID', 'CODE', 'CREATED_AT',
+                  'CLOSED_AT', 'CUSTOMER_ID', 'USER_ID', 'QUEUE_ID']
+        cursor.execute("""SELECT id, code, created_at, closed_at,
             customer_id, user_id, queue_id 
             FROM servo_order""")
         write(path, header, cursor)
 
         path = os.path.join(backupdir, 'queues.csv')
         header = ['ID', 'NAME', 'DESCRIPTION', 
-            'CLOSED_AT', 'CUSTOMER_ID', 'USER_ID', 'QUEUE_ID']
+                  'CLOSED_AT', 'CUSTOMER_ID', 'USER_ID', 'QUEUE_ID']
         cursor.execute("""SELECT id, title, description FROM servo_queue""")
         write(path, header, cursor)
 
         path = os.path.join(backupdir, 'devices.csv')
         header = ['ID', 'SERIAL_NUMBER', 'IMEI', 
-        'CONFIGURATION', 'WARRANTY_STATUS', 'PURCHASE_DATE', 'NOTES']
+                  'CONFIGURATION', 'WARRANTY_STATUS', 'PURCHASE_DATE', 'NOTES']
         cursor.execute("""SELECT id, sn, imei, configuration, warranty_status,
         purchased_on, notes FROM servo_device""")
         write(path, header, cursor)
 
         path = os.path.join(backupdir, 'repairs.csv')
         header = ['ID', 'ORDER_ID', 'DEVICE_ID', 'USER_ID',
-            'SUBMITTED_AT', 'COMPLETED_AT', 'REQUEST_REVIEW', 
-            'TECH_ID', 'UNIT_RECEIVED', 'CONFIRMATION', 
-            'REFERENCE', 'SYMPTOM', 'DIAGNOSIS', 'NOTES']
+                  'SUBMITTED_AT', 'COMPLETED_AT', 'REQUEST_REVIEW',
+                  'TECH_ID', 'UNIT_RECEIVED', 'CONFIRMATION',
+                  'REFERENCE', 'SYMPTOM', 'DIAGNOSIS', 'NOTES']
         cursor.execute("""SELECT id, order_id, device_id, 
             created_by_id, submitted_at, completed_at, 
             request_review, tech_id, unit_received_at, confirmation, reference,
@@ -85,10 +85,10 @@ class Command(BaseCommand):
             WHERE submitted_at IS NOT NULL""")
         write(path, header, cursor)
 
-        header = ['ID', 'CODE', 'TITLE', 'DESCRIPTION', 
-        'PRICE_PURCHASE_EXCHANGE', 'PRICE_PURCHASE_STOCK',
-        'PRICE_SALES_EXCHANGE', 'PRICE_SALES_STOCK', 'COMPONENT_CODE',
-        'PART_TYPE', 'EEE_CODE']
+        header = ['ID', 'CODE', 'TITLE', 'DESCRIPTION',
+                  'PRICE_PURCHASE_EXCHANGE', 'PRICE_PURCHASE_STOCK',
+                  'PRICE_SALES_EXCHANGE', 'PRICE_SALES_STOCK', 'COMPONENT_CODE',
+                  'PART_TYPE', 'EEE_CODE']
         cursor.execute("""SELECT id, code, title, description,
             price_purchase_exchange, price_purchase_stock,
             price_sales_exchange, price_sales_stock,
@@ -98,8 +98,8 @@ class Command(BaseCommand):
         write(path, header, cursor)
 
         header = ['ID', 'PARENT_ID', 'NAME', 'PHONE', 'EMAIL',
-        'STREET_ADDRESS', 'POSTAL_CODE', 'CITY'
-        'COUNTRY', 'NOTES']
+                  'STREET_ADDRESS', 'POSTAL_CODE', 'CITY'
+                  'COUNTRY', 'NOTES']
         cursor.execute("""SELECT id, parent_id, name, phone,
             email, street_address, zip_code, city, country, notes
             FROM servo_customer""")
@@ -108,9 +108,9 @@ class Command(BaseCommand):
 
         path = os.path.join(backupdir, 'order_products.csv')
         header = ['ID', 'PRODUCT_ID', 'ORDER_ID', 'CODE', 'TITLE',
-        'DESCRIPTION', 'AMOUNT', 'SERIAL_NUMBER', 'KBB_SN',
-        'IMEI', 'REPORTED', 'PRICE_CATEGORY', 'PRICE'
-        'COMPTIA_CODE', 'COMPTIA_MODIFIER']
+                  'DESCRIPTION', 'AMOUNT', 'SERIAL_NUMBER', 'KBB_SN',
+                  'IMEI', 'REPORTED', 'PRICE_CATEGORY', 'PRICE'
+                  'COMPTIA_CODE', 'COMPTIA_MODIFIER']
         cursor.execute("""SELECT id, product_id, order_id, code,
             title, description, amount, sn, price, kbb_sn,
             imei, should_report, price_category, price,
@@ -120,9 +120,9 @@ class Command(BaseCommand):
 
         path = os.path.join(backupdir, 'parts.csv')
         header = ['ID', 'REPAIR_ID', 'ORDER_ITEM_ID',
-        'NUMBER', 'TITLE', 'COMPTIA_CODE', 'COMPTIA_MODIFIER',
-        'RETURN_ORDER', 'RETURN_STATUS', 'RETURN_CODE',
-        'ORDER_STATUS', 'COVERAGE', 'SHIP_TO', 'RETURNED_AT']
+                  'NUMBER', 'TITLE', 'COMPTIA_CODE', 'COMPTIA_MODIFIER',
+                  'RETURN_ORDER', 'RETURN_STATUS', 'RETURN_CODE',
+                  'ORDER_STATUS', 'COVERAGE', 'SHIP_TO', 'RETURNED_AT']
         cursor.execute("""SELECT id, repair_id, order_item_id,
             part_number, part_title, comptia_code, comptia_modifier,
             return_order, return_status,  return_code,