'''
APPDDM analytical
ConfigurationDB analytical
DataHub analytical
DW model
MADW model
Mart analytical
MARTPH analytical
MARTPHMA analytical
PRESTAGE enriched
STAGE enriched
Yilian enriched
'''
#level1 手工
'''
a=input("db?")
s=a.upper()
if s=='PRESTAGE':
b='analytical'+'_'+s
elif s=='APPDDM':
b='analytical'+'_'+s
print(b)
'''
#level2 use list
'''
list=['appddm','configurationdb','datahub','dw','madw','mart','martph','martphma','prestage','stage','yilian']
for i in range(0,len(list)):
lista=list[i]
b=lista.upper()
if b=='APPDDM':
s = 'analytical' + '_' + lista
print(s)
elif b=='DW':
s = 'model' + '_' + lista
print(s)
else:
print("error")
'''
#level3 use_list+完整表名
'''
list=['appddm.ddm.report_distributor_permission','appddm.ddm.report_province_permission','appddm.ddm.report_estimate_summary_data','appddm.dbo.v_report_distributor_inven_esti_compute','appddm.ddm.report_t1_distributor_sales_by_province','appddm.ddm.report_t1_distributor_sales_progress_speed']
for i in range(0,len(list)):
lista=list[i]
'''
''''
str='as.de.frr'
a=str.split('.')
print(a)
print(a[0])
'''
#level3 use_list+完整表名
list=['appddm.ddm.report_distributor_permission','appddm.ddm.report_province_permission','appddm.ddm.report_estimate_summary_data','appddm.dbo.v_report_distributor_inven_esti_compute','appddm.ddm.report_t1_distributor_sales_by_province','appddm.ddm.report_t1_distributor_sales_progress_speed']
for i in range(0,len(list)):
lista=list[i]
listb=lista.split('.')
if listb[0].upper()=='APPDDM':
s='analytical'+'_'+listb[0]+'_'+listb[1]+'.'+listb[2]
print(s)
elif listb[0].upper()=='DW':
s='model' + '_' + listb[0] + '_' + listb[1] + '.' + listb[2]
print(s)
else :
print("error")
#level3.1用def
#level5 用字典
#level6 用文件