问题说明
从数据库字段中读取fields_name,让后生成自己的代码的函数格式的一个脚本,利用正则抓取,批量改名。
数据库字段
DAU,
device_regist_count,
device_active_count,
old_player_login_count,
old_player_login_rate,
pay_sum,
pay_count,
pay_player_count,
pay_rate,
new_first_pay_player_count,
new_first_pay_sum,
new_pay_count,
new_pay_sum,
new_pay_rate,
active_ARPU,
pay_ARPPU,
remain_count_2,
remain_rate_1,
remain_rate_2,
remain_rate_3,
remain_rate_7,
remain_rate_15,
remain_rate_30
函数名称规则
getNewAccount
getDAU
getDeviceRegistCount
getDeviceActiveCount
getOldPlayerLoginCount
getOldPlayerLoginRate
getPaySum
getPayCount
getPayPlayerCount
getPayRate
getNewFirstPayPlayerCount
getNewFirstPaySum
getNewPayCount
getNewPaySum
getNewPayRate
getActiveARPU
getPayARPPU
getRemainCount_2
getRemainRate_1
getRemainRate_2
getRemainRate_3
getRemainRate_7
getRemainRate_15
getRemainRate_30
实现
配置文件
name_list.txt
new_account
DAU
device_regist_count
device_active_count
old_player_login_count
old_player_login_rate
pay_sum
pay_count
pay_player_count
pay_rate
new_first_pay_player_count
new_first_pay_sum
new_pay_count
new_pay_sum
new_pay_rate
active_ARPU
pay_ARPPU
remain_count_2
remain_rate_1
remain_rate_2
remain_rate_3
remain_rate_7
remain_rate_15
remain_rate_30
python脚本
import re
fd = open('name_list.txt','r')
r = re.compile('_([a-zA-Z])')
for l in fd.readlines():
l = l.replace('\n','')
h = l[:1].upper()
l = h+l[1:]
result = r.findall(l)
for r1 in result:
l=l.replace("_"+r1,r1.upper())
print("get"+l)