Last active
January 12, 2017 12:21
-
-
Save vgrivtsov/915bffeeea70aa89a19e98f73b5f3a6b to your computer and use it in GitHub Desktop.
scripts for change electrical tilts.
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 characters
| author__ = 'victor.grivtsov' | |
| #!/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(): | |
| 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 = [] | |
| for i in list(set(extdata())): | |
| 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)) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment