Subversion Repositories SmartDukaan

Rev

Rev 4090 | Rev 12785 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 4090 Rev 7808
Line 18... Line 18...
18 
@author: Ankur Singhal
 18 
@author: Ankur Singhal
19 
'''
 19 
'''
20 
import optparse
 20 
import optparse
21 
import xlrd
 21 
import xlrd
22 
from elixir import *
 22 
from elixir import *
- 
 
 23 
from shop2020.thriftpy.model.v1 import inventory
23 
 
 24 
 
24 
if __name__ == '__main__' and __package__ is None:
 25 
if __name__ == '__main__' and __package__ is None:
25 
    import sys
 26 
    import sys
26 
    import os
 27 
    import os
27 
    sys.path.insert(0, os.getcwd())
 28 
    sys.path.insert(0, os.getcwd())
28 
 
 29 
 
29 
from shop2020.logistics.service.impl import DataService
 30 
from shop2020.logistics.service.impl import DataService
30 
from shop2020.logistics.service.impl.DataService import Provider,\
 31 
from shop2020.logistics.service.impl.DataService import Provider, DestinationProviderAllocation
31 
    DestinationProviderAllocation
 - 
 
32 
from shop2020.thriftpy.logistics.ttypes import WarehouseLocation,\
 32 
from shop2020.thriftpy.model.v1.inventory.ttypes import WarehouseLocation, InventoryServiceException
33 
    LogisticsServiceException
 - 
 
34 
 
 33 
 
35 
def load_providers(filename, sheet_no, db_hostname):
 34 
def load_providers(filename, sheet_no, db_hostname):
36 
    DataService.initialize(dbname='logistics', db_hostname=db_hostname)
 35 
    DataService.initialize(dbname='logistics', db_hostname=db_hostname)
37 
 
 36 
 
38 
    workbook = xlrd.open_workbook(filename)
 37 
    workbook = xlrd.open_workbook(filename)
Line 58... Line 57...
58 
                dpa = DestinationProviderAllocation()
 57 
                dpa = DestinationProviderAllocation()
59 
                dpa.destination_pin = dest_pincode
 58 
                dpa.destination_pin = dest_pincode
60 
                dpa.warehouse_location = warehouse_loc
 59 
                dpa.warehouse_location = warehouse_loc
61 
            provider = provider_map[provider_name]
 60 
            provider = provider_map[provider_name]
62 
            if provider is None:
 61 
            if provider is None:
63 
                raise LogisticsServiceException(103, "Invalid provider --> " + provider_name)
 62 
                raise InventoryServiceException(103, "Invalid provider --> " + provider_name)
64 
            if sheet_no == 0:
 63 
            if sheet_no == 0:
65 
                dpa.provider_less_amount = provider
 64 
                dpa.provider_less_amount = provider
66 
            else:
 65 
            else:
67 
                dpa.provider_more_amount = provider
 66 
                dpa.provider_more_amount = provider
68 
    session.commit()
 67 
    session.commit()