def delete(self, res_id):
try:
session = db_base.get_session()
res = session.query(Resource).filter_by(id=res_id).first()
session.delete(res)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def get(self, env_id):
env = ''
try:
session = db_base.get_session()
env = session.query(Environment).filter_by(id=env_id).first()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return env
def get(self, name):
cont = ''
try:
session = db_base.get_session()
cont = session.query(Container).filter_by(name=name).first()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return cont
def get_all(self):
cont_list = ''
try:
session = db_base.get_session()
cont_list = session.query(Container).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return cont_list
def delete(self, env_id):
try:
session = db_base.get_session()
env = session.query(Environment).filter_by(id=env_id).first()
session.delete(env)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def get_all(self):
env_list = ''
try:
session = db_base.get_session()
env_list = session.query(Environment).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return env_list
def get_all(self):
app_list = ''
try:
session = db_base.get_session()
app_list = session.query(App).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return app_list
def delete(self, app_id):
try:
session = db_base.get_session()
app = session.query(App).filter_by(id=app_id).first()
session.delete(app)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def get(self, app_id):
app = ''
try:
session = db_base.get_session()
app = session.query(App).filter_by(id=app_id).first()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return app
def get_resources_for_env(self, env_id):
res = ''
try:
session = db_base.get_session()
res = session.query(Resource).filter_by(env_id=env_id).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return res
def update_by_name(self, app_name, app_data):
try:
session = db_base.get_session()
app = session.query(App).filter_by(name=app_name).first()
app = self._update(app, app_data)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def get_all(self):
res_list = ''
try:
session = db_base.get_session()
res_list = session.query(Resource).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return res_list
def get_apps_for_env(self, env_id):
apps = ''
try:
session = db_base.get_session()
apps = session.query(App).filter_by(env_id=env_id).all()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return apps
def get(self, res_id):
res = ''
try:
session = db_base.get_session()
res = session.query(Resource).filter_by(id=res_id).first()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return res
def delete(self, cont_name):
try:
session = db_base.get_session()
cont = session.query(Container).filter_by(name=cont_name).first()
session.delete(cont)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def update_res_for_env(self, env_id, res_data):
res = ''
try:
session = db_base.get_session()
res = session.query(Resource).filter_by(env_id=env_id).first()
if 'status' in res_data: res.status = res_data['status']
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return res.id
def update(self, cont_name, cont_data):
try:
session = db_base.get_session()
cont = session.query(Container).filter_by(name=cont_name).first()
if 'dep_target' in cont_data: cont.dep_target = cont_data['dep_target']
if 'status' in cont_data: cont.status = cont_data['status']
if 'output_config' in cont_data: cont.output_config = cont_data['output_config']
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def update(self, env_id, env_data):
try:
session = db_base.get_session()
env = session.query(Environment).filter_by(id=env_id).first()
if 'location' in env_data: env.location = env_data['location']
if 'status' in env_data: env.status = env_data['status']
if 'output_config' in env_data: env.output_config = env_data['output_config']
if 'env_definition' in env_data: env.env_definition = env_data['env_definition']
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def insert(self, cont_data):
self.name = cont_data['cont_name']
self.dep_target = cont_data['dep_target']
self.status = 'building'
self.output_config = ''
self.cont_store_path = cont_data['cont_store_path']
try:
session = db_base.get_session()
session.add(self)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return self.id
def insert(self, res_data):
self.env_id = res_data['env_id']
self.cloud_resource_id = res_data['cloud_resource_id']
self.type = res_data['type']
self.status = res_data['status']
if 'input_config' in res_data:
self.input_config = res_data['input_config']
try:
session = db_base.get_session()
session.add(self)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return self.id
def update(self, res_id, res_data):
try:
session = db_base.get_session()
res = session.query(Resource).filter_by(id=res_id).first()
if 'status' in res_data: res.status = res_data['status']
if 'input_config' in res_data:
res.input_config = res_data['input_config']
if 'filtered_description' in res_data:
res.filtered_description = res_data['filtered_description']
if 'detailed_description' in res_data:
res.detailed_description = res_data['detailed_description']
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
def insert(self, app_data):
self.name = app_data['name']
self.location = app_data['location']
self.version = app_data['version']
self.dep_target = app_data['dep_target']
self.status = 'deploying'
self.output_config = ''
self.env_id = app_data['env_id']
self.env_name = app_data['env_name']
try:
session = db_base.get_session()
session.add(self)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.debug(e)
return self.id
def insert(self, env_data):
self.name = env_data['name']
self.location = env_data['location']
self.env_definition = str(env_data['env_definition'])
self.status = 'creating'
output_config = {}
output_config['env_version_stamp'] = env_data['env_version_stamp']
self.output_config = str(output_config)
try:
session = db_base.get_session()
session.add(self)
session.commit()
session.close()
except IntegrityError as e:
fmlogger.error(e)
raise e
return self.id
