#!/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")
