def process_categories(self, *args, **kwargs): db = DBConnection(self.dbname) if 'POST' in cherrypy.request.method: title = cherrypy.request.params.get("title") 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_cat = db.add_category(title) new_filer = db.add_filter(title_search=title_search, filename_search=filename_search, category_id=new_cat.id) if assign: db.assign_categories() # out = json.dumps(pst.db.row2dict(new_cat), indent=4, sort_keys=True) # db.session.close() # return out if 'DELETE' in cherrypy.request.method: id = cherrypy.request.params.get("id") db.delete_category(id) try: assign = cherrypy.request.params.get("assign") except: assign = True if assign: db.assign_categories() process_categories = db.get_process_categories() data = [pst.db.row2dict(row) for row in process_categories] out = json.dumps(data, indent=4, sort_keys=True) db.session.close() return out
def reassign_categories(self, *args, **kwargs): db = DBConnection(self.dbname) db.assign_categories() process_categories = db.get_process_categories() data = [pst.db.row2dict(row) for row in process_categories] out = json.dumps(data, indent=4, sort_keys=True) db.session.close() return out