final_excel_to_f5_auto 通过excel配置F5 代码

import requests
import json
from requests.packages import urllib3
from nacl.pwhash import verify
import xlrd
from xpinyin import Pinyin
from idlelib.iomenu import encoding

p = Pinyin()
urllib3.disable_warnings() #disable ssl warning

导入excel数据 ——begin———-

config_file = input(“请输入需要导入的excel表格名称，请带后缀如：配置信息.xlsx，配置文件请放在python脚本一个文件夹下:”)
data = xlrd.open_workbook(config_file,’r’)

table = data.sheets()[0]
nrows = table.nrows
ncols = table.ncols

导入excel数据 ——–end———–

create auth token

f5_ip = input(“请输入F5管理IP:”)
username = input(“请输入F5管理账户:”)
password = input(“请输入F5管理密码:”)

req_url = ‘https://%s/mgmt/shared/authn/login’ %(f5_ip)
data = {‘username’:username,
‘password’:password,
‘loginProviderName’:’tmos’
}
r = requests.post(req_url,json.dumps(data),verify = False)

get auth token

f5_rep = json.loads(r.text)
f5_token = f5_rep[‘token’][‘token’]

header for connection f5

creat_header = {
‘X-F5-Auth-Token’:f5_token,
‘Content-Type’:’application/json’
}

create new pool

for l in range(1,nrows):
if table.cell(l,0).ctype != 0:
pool_url = ‘https://%s/mgmt/tm/ltm/pool/’ %(f5_ip)
desc = p.get_pinyin(table.cell(l,0).value)
name_to_py = p.get_pinyin(“%s” %(table.cell(l,0).value),”“)
pool_name = ‘1%s_pool’ %(name_to_py)
print(“创建的pool:”,pool_name)
creat_pool_data = {
‘partition’:’Common’,
‘name’:pool_name,
‘description’:desc,
‘monitor’:’http’
}
pool = requests.post(url = pool_url,headers = creat_header, data = json.dumps(creat_pool_data),verify = False)
else :
continue

members into pool

for l in range(1,nrows):
pool_name_last = pool_name
name_to_py = p.get_pinyin(“%s” %(table.cell(l,0).value),”“)
if table.cell(l,0).ctype == 0 :
pool_name = pool_name_last
else :
pool_name = ‘1%s_pool’ %(name_to_py)
pool_member_ip = table.cell(l,4).value
pool_member_port = table.cell(l,5).value
pool_member_url = ‘https://%s/mgmt/tm/ltm/pool/%s/members’ %(f5_ip,pool_name)
member_into_pool_data = {
‘partition’:’Common’,
‘name’:’%s:%s’ % (pool_member_ip,pool_member_port),’address’:pool_member_ip
}
pool = requests.post(url = pool_member_url,headers = creat_header, data = json.dumps(member_into_pool_data),verify = False)

create new vs type standard

vs_url = ‘https://%s/mgmt/tm/ltm/virtual/’ %(f5_ip)
for l in range(1,nrows) :
if table.cell(l,1).value == ‘standard’ and table.cell(l,0).ctype != 0 :
name_to_py = p.get_pinyin(“%s” %(table.cell(l,0).value),”“)
vs_name = ‘1%s_vs’ %(name_to_py)
print(“创建的VS:”,vs_name,”类型:standard”)
vs_ip = table.cell(l,2).value
vs_port = table.cell(l,3).value
desc = p.get_pinyin(table.cell(l,0).value)
pool_name = ‘1%s_pool’ %(name_to_py)
create_vs_data = {
‘partition’:’Common’,
‘name’:vs_name,
‘description’:desc,
‘destination’:’%s:%s’ %(vs_ip,vs_port),
‘pool’:pool_name,
‘profiles’: [
{‘name’:’tcp’},
{‘name’:’http’}
]
}
create_vs = requests.post(url = vs_url,headers = creat_header,data = json.dumps(create_vs_data),verify = False)

create new vs type performance(L4)

elif  table.cell(l,1).value == 'L4' and table.cell(l,0).ctype != 0  :
    vs_url = 'https://%s/mgmt/tm/ltm/virtual/' %(f5_ip)
    name_to_py = p.get_pinyin("%s" %(table.cell(l,0).value),"")
    vs_name = '_1_%s_vs'  %(name_to_py)
    print("创建的VS:",vs_name,"类型:L4")
    vs_ip = table.cell(l,2).value
    vs_port = table.cell(l,3).value
    desc = p.get_pinyin(table.cell(l,0).value)
    pool_name = '_1_%s_pool' %(name_to_py)
    create_vs_data = {
        'partition':'Common',
        'name':vs_name,
        'description':desc,
        'destination':'%s:%s' %(vs_ip,vs_port),
        'pool':pool_name,
        }
    create_vs = requests.post(url = vs_url,headers = creat_header,data = json.dumps(create_vs_data),verify = False)
else : 
    continue

save config

save_config_url = ‘https://%s/mgmt/tm/sys/config/’ %(f5_ip)
save_config_pyload = {
‘partition’:’Common’,
‘command’:’save’
}
save_config = requests.post(url = save_config_url,headers = creat_header,data = json.dumps(save_config_pyload),verify = False)
print(“配置创建并保存完毕”)