def get(self, request, game_id, **kwargs): player_library = Library_Model.objects.filter( owner_id=self.request.user.id) print(player_library) game = Library_Membership.objects.get(library=player_library[0], game=game_id) print( f"BEFORE:\nID: {game.game_id}, FTB: {game.forced_to_backlog}, LIB_ID: {game.library_id}" ) startdate = date.today() enddate = startdate + timedelta(days=-30) if enddate < game.last_played: queryDo( f"UPDATE public.index_library_membership SET forced_to_backlog=False WHERE (library_id={game.library_id} AND game_id={game_id})" ) else: messages.error( request, "Cannot remove from backlog, last played date exceeds 30 day limit" ) print( f"AFTER:\nID: {game.game_id}, FTB: {game.forced_to_backlog}, LIB_ID: {game.library_id}" ) return HttpResponseRedirect(reverse("backlog"))
def post(self, request, game_id, **kwargs): form = LastPlayedForm(request.POST or None) gameArticle = Game_Model.objects.get(game_id=game_id) if form.is_valid(): player_library, created = Library_Model.objects.get_or_create(owner_id=request.user) newDate = form.cleaned_data['last_played'].strftime("%Y-%m-%d") queryDo(f"UPDATE public.index_library_membership SET last_played=date('{newDate}'::TEXT) WHERE (library_id={player_library.id} AND game_id={game_id})") else: print(form.errors) return HttpResponseRedirect(reverse("library"))
def get(self, request, game_id, **kwargs): player_library = Library_Model.objects.filter( owner_id=self.request.user.id ) print(player_library) game = Library_Membership.objects.get(library=player_library[0], game=game_id) print(f"BEFORE:\nID: {game.game_id}, FTB: {game.forced_to_backlog}, LIB_ID: {game.library_id}") startdate = date.today() enddate = startdate + timedelta(days=-30) if enddate >= game.last_played or game.forced_to_backlog: messages.error(request,"Game is already in backlog") return HttpResponseRedirect(reverse("library")) queryDo(f"UPDATE public.index_library_membership SET forced_to_backlog=True WHERE (library_id={game.library_id} AND game_id={game_id})") print(f"AFTER:\nID: {game.game_id}, FTB: {game.forced_to_backlog}, LIB_ID: {game.library_id}") return HttpResponseRedirect(reverse("backlog"))