def category_filters(self, *args, **kwargs):
category_id = cherrypy.request.params.get("category_id")
db = DBConnection(self.dbname)
if 'POST' in cherrypy.request.method:
title_search = cherrypy.request.params.get("title_search")
filename_search = cherrypy.request.params.get("filename_search")
try:
assign = cherrypy.request.params.get("assign")
except:
assign = True
new_filter = db.add_filter(title_search=title_search,
filename_search=filename_search,
category_id=category_id)
if assign:
db.assign_categories()
if 'DELETE' in cherrypy.request.method:
filter_id = cherrypy.request.params.get("id")
db.delete_filter(filter_id=filter_id)
try:
assign = cherrypy.request.params.get("assign")
except:
assign = True
if assign:
db.assign_categories()
filters = db.get_category_filters(category_id=category_id)
data = [pst.db.row2dict(row) for row in filters]
out = json.dumps(data, indent=4, sort_keys=True)
db.session.close()
return out
