Subversion Repositories SmartDukaan

#!/usr/bin/python

import optparse

import xlrd

from elixir import *

if __name__ == '__main__' and __package__ is None:

    import sys

    import os

    sys.path.insert(0, os.getcwd())

from shop2020.logistics.service.impl import DataService

from shop2020.logistics.service.impl.DataService import Awb, Provider

def load_awb_numbers(filename, provider_name):

    DataService.initialize('logistics')

    provider = Provider.get_by(name=provider_name)

    if provider is None:

        provider = Provider()

        provider.name = provider_name

        session.commit()

    workbook = xlrd.open_workbook(filename)

    sheet = workbook.sheet_by_index(0)

    num_rows = sheet.nrows

    for rownum in range(1, num_rows):

        awb_number = sheet.row_values(rownum)[0]

        awb = Awb()

        awb.awb_number = int(awb_number)

        awb.is_available = True

        awb.provider = provider

        awb.type = "Prepaid"

    session.commit()

def main():

    parser = optparse.OptionParser()

    parser.add_option("-f", "--file", dest="filename",

                   default="AwbNumbers.xls", type="string",

                   help="Read the AWB numbers from FILE",

                   metavar="FILE")

    parser.add_option("-P", "--provider", dest="provider_name",

                      type="string", help="Load these entries for PROVIDER",

                      metavar="PROVIDER")

    (options, args) = parser.parse_args()

    if len(args) != 0:

        parser.error("You've supplied extra arguments. Are you sure you want to run this program?")

    filename = options.filename

    provider_name = options.provider_name

    if filename is None or provider_name is None:

        parser.error("A provider's name and a filename must be provided. Use -h for usage details.")

    load_awb_numbers(filename, provider_name)

if __name__ == '__main__':

    main()