Last active
January 12, 2017 12:21
-
-
Save vgrivtsov/915bffeeea70aa89a19e98f73b5f3a6b to your computer and use it in GitHub Desktop.
Revisions
-
vgrivtsov revised this gist
Jan 12, 2017 . 1 changed file with 14 additions and 9 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -1,3 +1,4 @@ author__ = 'victor.grivtsov' #!/usr/bin/env python # -*- coding: utf-8 -*- @@ -7,24 +8,28 @@ dt = datetime.now().strftime('%m%d') etilts_csv = "./DB/e_tilts678.csv" def extip(dn): file_ip = open("./DB/IP_PLAN_KZ.csv", "r") for string in file_ip: if dn in string: string_list_ip = string.strip().split(";") mul_ip = string_list_ip[2] return mul_ip def extdata(): file_tilts = open(etilts_csv, "r") digi_name_arr = [] for string in file_tilts: string_list = string.strip().split(";") digi_name_arr.append(string_list[1][1:6]) return digi_name_arr def ext_tilts(dn): @@ -69,10 +74,10 @@ def ext_tilts(dn): return commands_chng_tilt_arr def main(args): node_commands = [] for i in list(set(extdata())): try: ip_node = extip(i) @@ -82,15 +87,15 @@ def main(args): node_commands.append(ext_tilts(i)) body =("amos "+ip_node+" '# %s; lt all; rbs; rbs; l+ /home/vicgri/scripts/logs/$nodename.log; confb+; " %i +" ".join(ext_tilts(i))+"cvms etilts_%s; acc RetSubUnit=1 forceCalibration; get . electricalAntennaTilt; l-'" %dt) print(body+"\n") with open("etilts_chg_%s.sh" %dt, "a") as file: file.write(body+"\n") file.close() print("bash -x ./etilts_chg_%s.sh > etilts_chg_%s.log" %(dt, dt)) return 0 if __name__ == '__main__': -
Dec 31, 2016 . 1 changed file with 2 additions and 5 deletions.There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -14,8 +14,7 @@ def extip(dn): if dn in string: string_list_ip = string.strip().split(";") mul_ip = string_list_ip[2] return mul_ip def extdata(): @@ -25,9 +24,7 @@ def extdata(): for string in file_tilts: string_list = string.strip().split(";") digi_name_arr.append(string_list[1][1:6]) return digi_name_arr def ext_tilts(dn): -
Dec 31, 2016 .There are no files selected for viewing
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode charactersOriginal file line number Diff line number Diff line change @@ -0,0 +1,101 @@ #!/usr/bin/env python # -*- coding: utf-8 -*- from datetime import datetime dt = datetime.now().strftime('%m%d') etilts_csv = "./DB/e_tilts678.csv" def extip(dn): file_ip = open("./DB/IP_PLAN_KZ.csv", "r") for string in file_ip: if dn in string: string_list_ip = string.strip().split(";") mul_ip = string_list_ip[2] return mul_ip def extdata(): global digi_name_arr file_tilts = open(etilts_csv, "r") digi_name_arr = [] for string in file_tilts: string_list = string.strip().split(";") digi_name_arr.append(string_list[1][1:6]) return digi_name_arr def ext_tilts(dn): file_tilts = open(etilts_csv, "r") global commands_chng_tilt_arr commands_chng_tilt_arr = [] for string in file_tilts: string_list = string.strip().split(";") if dn in string: sector = string_list[1][7:10] new_tilt = string_list[2]+"0" if sector == '100': sector = 'AntennaUnitGroup=1,AntennaNearUnit=RET-2,RetSubUnit=1' sector2 = 'AntennaUnitGroup=4,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S1L1800,AntennaNearUnit=L800,RetSubUnit=1' if sector == '102': sector = 'AntennaUnitGroup=2,AntennaNearUnit=RET-2,RetSubUnit=1' sector2 = 'AntennaUnitGroup=5,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S2L1800,AntennaNearUnit=L800,RetSubUnit=1' if sector == '104': sector = 'AntennaUnitGroup=3,AntennaNearUnit=RET-2,RetSubUnit=1' sector2 = 'AntennaUnitGroup=6,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S3L1800,AntennaNearUnit=L800,RetSubUnit=1' if sector == '110': sector = 'AntennaUnitGroup=1,AntennaNearUnit=RET-1,RetSubUnit=1' sector2 = 'AntennaUnitGroup=1,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S1L1800,AntennaNearUnit=L1800,RetSubUnit=1' if sector == '112': sector = 'AntennaUnitGroup=2,AntennaNearUnit=RET-1,RetSubUnit=1' sector2 = 'AntennaUnitGroup=3,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S2L1800,AntennaNearUnit=L1800,RetSubUnit=1' if sector == '114': sector = 'AntennaUnitGroup=3,AntennaNearUnit=RET-1,RetSubUnit=1' sector2 = 'AntennaUnitGroup=3,AntennaNearUnit=1,RetSubUnit=1' sector3 = 'AntennaUnitGroup=AUG-S3L1800,AntennaNearUnit=L1800,RetSubUnit=1' commands = ("set "+sector+ " electricalAntennaTilt "+new_tilt+"; "+"set "+sector2+ " electricalAntennaTilt "+new_tilt+"; "+"set "+sector3+ " electricalAntennaTilt "+new_tilt+"; ") commands_chng_tilt_arr.append(commands) return commands_chng_tilt_arr def main(args): node_commands = [] extdata() digi_name_arr2 = list(set(digi_name_arr)) for i in digi_name_arr2: try: ip_node = extip(i) except: ip_node = "no_ip" node_commands.append(ext_tilts(i)) body =("amos "+ip_node+" '# %s; lt all; rbs; rbs; l+ /home/vicgri/scripts/logs/$nodename.log; confb+; " %i +" ".join(ext_tilts(i))+"cvms etilts_%s; acc RetSubUnit=1 forceCalibration; get . electricalAntennaTilt; l-'" %dt) print(body+"\n") with open("etilts_chg_%s.sh" %dt, "a") as file: file.write(body+"\n") file.close() print("bash -x ./etilts_chg_%s.sh > etilts_chg_%s.log" %(dt, dt)) return 0 if __name__ == '__main__': import sys sys.exit(main(sys.argv))