import argparse
import logging
import pandas
from lib import my_env
from lib import murcsrest
if __name__ == "__main__":
# Configure command line arguments
parser = argparse.ArgumentParser(
description="Load a Site file into Murcs"
)
parser.add_argument('-f', '--filename', type=str, required=True,
help='Please provide the site file to load.')
args = parser.parse_args()
cfg = my_env.init_env("bellavista", __file__)
r = murcsrest.MurcsRest(cfg)
logging.info("Arguments: {a}".format(a=args))
# Read the file
df = pandas.read_excel(args.filename)
my_loop = my_env.LoopInfo("Sites", 20)
for row in df.iterrows():
my_loop.info_loop()
# Get excel row in dict format
xl = row[1].to_dict()
siteId = xl.pop("siteId")
payload = dict(
siteId=siteId
)
for k in xl:
if pandas.notnull(xl[k]):
"""
This script will collect information from Murcs and store it in a local database.
"""
import logging
from lib import localstore
from lib import my_env
from lib.murcs import *
from lib import murcsrest
solToSol_done = []
cfg = my_env.init_env("bellavista", __file__)
r = murcsrest.MurcsRest()
lcl = localstore.sqliteUtils()
logging.info("Get Version Information")
res = r.get_version()
lcl.insert_row("version", res)
res = []
logging.info("Get Site information")
r.get_data("sites", reslist=res)
lcl.insert_rows("site", res)
logging.info("Handling Person information")
res = []
r.get_data("persons", reslist=res)
lcl.insert_rows("person", res)
logging.info("Handling Servers")
res = []