def clear_alone_base():
# 清空单独的库
db_table = {
'ct_db': ['t_account', 't_user_info'],
'sms_db': ['t_ip_limeit', 't_mobile_limit'],
'user_db': ['t_user_auto_info', 't_user_info']
}
for db in db_table:
for table in db_table[db]:
print('正在清空{}库{}表'.format(db, table))
query_sql = 'delete from {}'.format(table)
HandleMysql.handle_mysql(query_sql, db, 'update')
print('清空完毕')
def send_get_msg(mobile): # 发送并获取验证码
# 数据是固定的，只需更改手机号
data = {
'client_ip': getattr(GetData, 'ip'),
'tmpl_ip': '1',
'mobile': mobile
}
client = BaseRequest.base_request(getattr(GetData, 'sms_service_url'))
client.service.SendMCode(data)
# 查询验证码
query_sql = 'select Fverify_code from t_mvcode_info_{0} where Fmobile_no={1}'.format(
mobile[-3], mobile)
db_name = 'sms_db_{0}'.format(mobile[-2])
res = HandleMysql.handle_mysql(query_sql, db_name)
return res[0]