#!/opt/envs/qlik/bin/python import os from lib.my_env import run_script my_path = os.path.dirname(__file__) run_script(my_path, 'qlik_explore_layout.py') run_script(my_path, 'git_processing.py', '-r', 'Layout')
""" This script will find all qif files in qif dump directory, then send each file to process_qif for load in transaction table. """ # Allow lib to library import path. import os import logging from lib import my_env from lib.my_env import run_script from lib import sqlstore from lib.sqlstore import * from sqlalchemy.orm.exc import * cfg = my_env.init_env("qif", __file__) logging.info("Start Application") script = "report_account" (fp, filename) = os.path.split(__file__) sql_eng = sqlstore.init_session(cfg["Main"]["db"]) code_query = sql_eng.query(Account) accounts = sql_eng.query(Account).filter(Account.type != "effect").all() for account in accounts: code = account.code logging.info("Run script: {s}.py -c {code}".format(s=script, code=code)) run_script(fp, "{s}.py".format(s=script), "-c", code) logging.info("End Application")
""" This script will convert murcs data and load it into Neo4J. This is done calling applications in sequence. """ # Allow lib to library import path. import os import logging from lib import my_env from lib.my_env import run_script scripts = ["rebuild_neo4j.py", "10_murcs_sites.py", "20_murcs_servers.py", "50_murcs_soft.py", "60_murcs_serversw.py", "100_murcs_solutions.py", "110_murcs_solcomp.py", "120_murcs_solinstcomp.py", "130_murcs_solinst.py", "140_murcs_soltosol.py", "150_waves_to_sol.py"] cfg = my_env.init_env("bellavista", __file__) logging.info("Start Application") (fp, filename) = os.path.split(__file__) for script in scripts: logging.info("Run script: {s}".format(s=script)) run_script(fp, script)
from lib.luft_store import * # Configure command line arguments parser = argparse.ArgumentParser(description="Get measurements for sensor.") parser.add_argument( '-s', '--sensor', type=str, default='sds011_sensor_13889', help= 'Please provide the sensor id (as used on https://www.madavi.de/sensor/csvfiles.php)' ) args = parser.parse_args() cfg = my_env.init_env("luftdaten", __file__) logging.info("Arguments: {a}".format(a=args)) luft = luft_class.Luft() sensor = args.sensor max_ts = luft.latest_measurement(sensor) start = datetime.datetime.fromtimestamp(max_ts, pytz.utc).date() today = datetime.datetime.now(pytz.utc).date() step = datetime.timedelta(days=1) (fp, filename) = os.path.split(__file__) while start < today: ds = start.strftime("%Y-%m-%d") my_env.run_script(fp, 'measurement4date.py', '-s', sensor, '-d', ds) start += step logging.info("End application")
#!/opt/envs/gnu/bin/python """ This script populates the accounts database and creates the consolidation excel. """ # Allow lib to library import path. import os import logging from lib import my_env from lib.my_env import run_script scripts = [ "10_rebuild_db", "20_populate_accounts", "30_populate_transactions", "40_populate_price", "50_update_account_currency", "consolidation" ] cfg = my_env.init_env("gnu", __file__) logging.info("Start Application") (fp, filename) = os.path.split(__file__) for script in scripts: logging.info("Run script: {s}.py".format(s=script)) run_script(fp, "{s}.py".format(s=script)) logging.info("End Application")
default='esp8266-72077', help= 'Please provide the sensor id (as used on https://www.madavi.de/sensor/csvfiles.php?sensor=)' ) args = parser.parse_args() cfg = my_env.init_env("luftdaten", __file__) logging.info("Arguments: {a}".format(a=args)) sensor = args.sensor url_base = os.getenv("URL_BASE") url = "{base}csvfiles.php?sensor={sensor}".format(base=url_base, sensor=args.sensor) logging.info("URL: {url}".format(url=url)) # Collect and process measurements. res = requests.get(url) (fp, filename) = os.path.split(__file__) if res.status_code == 200: soup = BeautifulSoup(res.content) all_refs = soup.find_all('a') links = [link.attrs['href'] for link in all_refs] zips = [link for link in links if '.zip' in link] for url in zips: my_env.run_script(fp, 'measurement4zip.py', '-s', sensor, '-u', url) my_env.run_script(fp, 'measurement4sensor.py', '-s', sensor) else: logging.info("Extract for sensor not successful, return code: {}".format( res.status_code)) logging.info("End application")
import os import logging import pandas from lib import my_env from lib.my_env import run_script parser = argparse.ArgumentParser( description="Batch coupling server to solution") parser.add_argument( '-f', '--filename', type=str, required=True, help='Please provide the file with servers - solutions to link.') args = parser.parse_args() cfg = my_env.init_env("bellavista", __file__) logging.info("Start Application") logging.info("Arguments: {a}".format(a=args)) cfg = my_env.init_env("bellavista", __file__) (fp, filename) = os.path.split(__file__) script = "server_to_application_create.py" df = pandas.read_excel(args.filename) for row in df.iterrows(): # Get excel row in dict format xl = row[1].to_dict() # Get solution component node hostName = xl.pop("hostName") solId = xl.pop("solID") params = ["-s", hostName, "-a", str(solId)] run_script(fp, script, *params)
#!/opt/envs/qlik/bin/python import os from lib.my_env import run_script my_path = os.path.dirname(__file__) run_script(my_path, 'qlik_explore.py') run_script(my_path, 'git_processing.py')
# Allow lib to library import path. import os import logging from lib import my_env from lib.my_env import run_script scripts = ["site_Load", "server_Load", "server_Load", # To link servers with parent servers "soft_Load", "softInst_Load", "solution_Load", "solutionInstance_Load", "solInstComp_Load", "solutionToSolution_Load", "netiface_Load", "ipaddress_Load", "person_Load", "contactServer_Load", "contactSolution_Load", "serverProperty_Load", "solutionProperty_Load", "solutionInstanceProperty_Load"] cfg = my_env.init_env("bellavista", __file__) logging.info("Start Application") (fp, filename) = os.path.split(__file__) for script in scripts: logging.info("Run script: {s}".format(s=script)) run_script(fp, script + ".py")