def AddFavByCatID(): intCatID = request.form['intCatID'] strFavoriteTitle = request.form['strFavoriteTitle'] strDescription = request.form['strDescription'] intRanking = request.form['intRanking'] objCategory = Categories_Lookup.query.filter_by(id=intCatID).first() if not objCategory is None: objFavorite = Favorite.query.filter( Favorite.category_id == intCatID, Favorite.title == strFavoriteTitle).first() if objFavorite is None: objSameRankItem = Favorite.query.filter_by( category_id=intCatID, ranking=intRanking).first() if objSameRankItem: rankReorder(intCatID, intRanking) fav = Favorite(title=strFavoriteTitle, description=strDescription, ranking=intRanking, cteated_date=datetime.now(), modified_date=datetime.now(), Category=objCategory) db.session.add(fav) db.session.commit() response = success(fav.as_dict()) objLogs = Audit_Log( description="Add New Favorite (%s) for (%s) Category" % (strFavoriteTitle, objCategory.title), log_date=datetime.now()) db.session.add(objLogs) db.session.commit() else: response = failure("Favorite Name Must be Unique") else: response = failure("This Category is not exists") return jsonify(response)