def get_limit(self, limit):
try:
if limit:
return db.session().query(Departments).order_by().limit(limit).all()
else:
return db.session().query(Departments).order_by().all()
except Exception as ex:
trace = TraceException("DepartmentsController:", "get_limit", ex.__str__())
raise CustomControllerException(trace.get_message())
def get_by_region_name(self, department_name, limit=0):
try:
if limit:
return db.session().query(Departments).filter(Departments.DEPARTMENT_NAME == department_name).order_by().limit(limit).all()
else:
return db.session().query(Departments).filter(Departments.DEPARTMENT_NAME == department_name).order_by().all()
except Exception as ex:
trace = TraceException("DepartmentsController:", "get_by_region_name", ex.__str__())
raise CustomControllerException(trace.get_message())
# </editor-fold>
def multi_delete(self, list_id):
session = db.session()
try:
delete_q = Departments.__table__.delete().where(Departments.DEPARTMENT_ID.in_(set(list_id)))
session.execute(delete_q)
session.commit()
return OK_MESSAGE
except Exception as ex:
session.rollback()
trace = TraceException("DepartmentsController: multi_delete " + ex.__str__())
raise CustomControllerException(trace.get_message())
def add(self, args):
"""add new region
:param args: dictionary for region params
:return:
"""
resend_case = Departments(**args)
session = db.session()
session.add(resend_case)
try:
session.commit()
return OK_MESSAGE
except Exception as e:
trace = TraceException("DepartmentsController:", "insert DB fail", e.__str__())
raise CustomControllerException(trace.get_message())
def delete_link(link_id):
link = Link.query.get_or_404(link_id)
db.session.delete(link)
db.session(commit)
flash('Link deleted.', 'success')
return redirect(url_for('.manage_link'))
def get_all_records(self):
try:
return db.session().query(Departments).order_by().all()
except Exception as ex:
trace = TraceException("DepartmentsController:", "get_all_records", ex.__str__())
raise CustomControllerException(trace.get_message())