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()