def UOM_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'UOM Conversions - DPL.xlsx'
sheet_name ='UOM'
header_row= 4
lookup_type = 'unit_of_measurement'
usecols = ['UNIT NAME',
'PA UNIT NAME', 'UNIT ALT NAME', 'CONVERSION FORMULA',
'CONVERSION FORMULA2', 'UNIT SYSTEM', 'UNIT TYPE', 'BASE UNIT']
lookup_val_column = 'UNIT NAME'
category_column = 'UNIT TYPE'
rename_cols = {'PA UNIT NAME': 'pa_unit_name', 'UNIT ALT NAME': 'unit_alt_name',
'CONVERSION FORMULA': 'conversion_formula',
'CONVERSION FORMULA2': 'conversion_formula2', 'UNIT SYSTEM': 'unit_system',
'BASE UNIT': 'base_unit'}
database=data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database,container_name,file_name,sheet_name,lookup_type,
lookup_val_column,category_column=category_column,
header=header_row,usecols=usecols,
rename_cols=rename_cols
)
def DiaphragmCompatibility_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='DiaphragmCompatibility'
header_row= 5
usecols = ['ProcessFillFluid']
lookup_type = 'process_fluid'
lookup_val_column = 'ProcessFillFluid'
database=data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database,container_name,file_name,sheet_name,lookup_type,
lookup_val_column,
header=header_row,usecols=usecols
)
def GasketMaterial_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='GasketMaterial'
header_row= 1
usecols = ['GasketMaterial']
lookup_type = 'gasket_material'
lookup_val_column = 'GasketMaterial'
database = data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database, container_name, file_name, sheet_name, lookup_type,
lookup_val_column,
header=header_row, usecols=usecols,
)
def IndustryStandard_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='IndustryStandard'
header_row= 1
usecols = ['IndustryStandard','Default','Restrictions']
lookup_type = 'industry_standard'
lookup_val_column = 'IndustryStandard'
rename_cols = {'Default': 'default', 'Restrictions': 'restrictions'}
database = data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database, container_name, file_name, sheet_name, lookup_type,
lookup_val_column,
header=header_row, usecols=usecols,
rename_cols=rename_cols
)
def GasketSurface_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='GasketSurface'
header_row= 1
usecols = ['ConnectionType','Default','Restrictions','Rule Logic']
lookup_type = 'gasket_surface'
lookup_val_column = 'ConnectionType'
rename_cols = {'Default': 'default', 'Restrictions': 'restrictions'}
category_column = 'Rule Logic'
database = data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database, container_name, file_name, sheet_name, lookup_type,
lookup_val_column,category_column=category_column,
header=header_row, usecols=usecols,
rename_cols=rename_cols
)
def DiaphragmMaterial_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='DiaphragmMaterial'
header_row= 1
usecols = ['DiaphragmMaterial','Tmax','Default','Restrictions','Rule Logic']
lookup_type = 'diaphragm_material'
lookup_val_column = 'DiaphragmMaterial'
rename_cols = {'Tmax':'max_temp','Default': 'default', 'Restrictions': 'restrictions'}
category_column = 'Rule Logic'
database = data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database, container_name, file_name, sheet_name, lookup_type,
lookup_val_column,category_column=category_column,
header=header_row, usecols=usecols,
rename_cols=rename_cols
)
def AddExtensionLength_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='AddExtensionLength'
header_row= 1
usecols = ['AddExtensionLength','LAddExL (inches)','Default','Restrictions','Rule Logic']
lookup_type = 'additional_extension_length'
lookup_val_column = 'AddExtensionLength'
rename_cols = {'LAddExL (inches)':'AddExlenValue','Default': 'default', 'Restrictions': 'restrictions'}
category_column = 'Rule Logic'
database = data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database, container_name, file_name, sheet_name, lookup_type,
lookup_val_column,category_column=category_column,
header=header_row, usecols=usecols,
rename_cols=rename_cols
)
def SealClass_upload():
dotenv.read_dotenv()
endpoint = os.environ['URL']
key = os.environ['CREDENTIAL']
database_name = os.environ['DATABASE_NAME']
container_name = 'lpa-lookup'
file_name = 'DP Level Product Advisor Logic_MVP_rev7_2020 Oct 5.xlsx'
sheet_name ='SealClass'
header_row= 1
lookup_type = 'seal_class'
usecols = ['SealClass','Default','Restrictions','World Area','Unnamed: 3']
lookup_val_column = 'SealClass'
category_column = 'Unnamed: 3'
rename_cols = {'Default': 'default', 'Restrictions': 'restrictions',
'World Area': 'world_area'}
database=data_upload.get_database(endpoint,
key,
database_name)
data_upload.data_upload(database,container_name,file_name,sheet_name,lookup_type,
lookup_val_column,category_column=category_column,
header=header_row,usecols=usecols,
rename_cols=rename_cols
)
