Build An Event Approval Page With Checkboxes - Django Wednesdays #43

[@Codemycom]

▶️ Watch Entire Django Wednesdays Playlist ✅ Subscribe To My KZbin Channel: bit.ly/35Xo9jD bit.ly/2IGzvOR ▶️ See More At: ✅ Join My Facebook Group: Codemy.com bit.ly/2GFmOBz ▶️ Learn to Code at Codemy.com ✅ Buy a Codemy T-Shirt! Take $30 off with coupon code: youtube1 bit.ly/2VC9WUN ▶️ Get The Code bit.ly/3sJpeV6

[@jasondavis6850]

Thanks again for the series. Here's a way to send checked and unchecked values to the database. I'm only a newb to python/django so it took me a lot longer than 5 minutes. Enjoy! def admin_approval(request): event_list = Event.objects.all().order_by('-event_date') events_all = Event.objects.all() events_all_ids = [] for i in range(0, len(events_all), 1): events_all_ids.append(str(events_all[i].id)) if request.user.is_superuser: if request.method == 'POST': id_list_true = request.POST.getlist('boxes') for x in id_list_true: Event.objects.filter(pk=int(x)).update(approved=True) id_set_false = set(events_all_ids) - set(id_list_true) id_list_false = list(id_set_false) for y in id_list_false: Event.objects.filter(pk=int(y)).update(approved=False) messages.success(request, ('Event List Approval has been updated')) return redirect('events_list') else: return render(request, 'events/admin_approval.html', { 'event_list': event_list }) else: messages.success(request, ('You are not authorized to view this page.')) return redirect('home')

[@mateuszbaszkowski1429]

Man, youre doing great job. I was just struggling with checkboxes on my very first app. Thanks a million.

[@Codemycom]

Happy to help!

[@aldya1532]

Very simple and nice solution! Thanks a lot! And thanks for your wonderful English)

[@Codemycom]

Welcome

[@hemantsah8567]

I spent 2 hours working on this kind of issue, thanks to your video,

[@stardust_dweller]

This helped me so much! Thank you!

[@Codemycom]

Welcome!

[@prakalpitneupane9253]

I needed to do the same, your video saved my day 😃

[@Codemycom]

awesome

[@skyline-wd3gr]

You are my favorite KZbinr

[@Codemycom]

Thanks!

[@skyline-wd3gr]

I have implemented many things in my python project by watching your videos

[@Codemycom]

Glad to hear it!

[@kodeypatterson8973]

Great video, thanks a lot. I've been following for a while

[@Codemycom]

Thanks for watching!

[@eesakamaldien1917]

I love your videos always the best

[@Codemycom]

Thanks!

[@darthvader66]

Nice video and great explanation! Is it better to have Event.objects.filter(pk__in=id_list).update(approved=True) instead of hitting the database n times seperately in the for loop?

[@anilkumar-ug3yd]

If you have lots of rows and u want to use pagination filter and builk update and delete by checkbox. what should be done ?

[@ZAYN_ONE_DIRECTION]

Sir you had a video on adding images to buttons in tkinter. Does the same method shown in the video also work for buttons in a canvas?

[@Codemycom]

Try it and see

[@thomasnowak9825]

For this, is it worth covering checking dates and times of events? For example, if someone entered an event and then someone else entered an event with the same date and time, it would be cool to reject the last one saying there is already an event for that date and time.

[@Codemycom]

Why can’t there be two events at the same time?

[@thomziq]

Hey:) Is there a possibility to add Matplotlib graphs to Django? Maybe some stats about Events?

[@Codemycom]

Probably, though I don't have any videos on it

[@Adrian-mh8op]

Would you know how to create leaderboards in python. Do you have any videos for that

[@Codemycom]

Sorry, don't know what you mean by leaderboards

[@Adrian-mh8op]

I’m doing a python flashcard app, it tree ore where users enter details and it gets submitted into a database. But I want to do a leaderboard which ranks the most correct answers from users. Do u have any vids on that or know how to begin doing that

[@Codemycom]

I have tons of videos about getting data from a database and displaying it on a screen. Nothing specific about leaderboards, but it would be trivial to order by whatever.

[@tonystark3399]

Sir can you please make a video on making scientific calculator with kivy ?

[@Codemycom]

I've already done a calculator with kivy. Just add the scientific functions you want.

[@sinacoder]

💻☕🍔🍟

[@Codemycom]

:-)

[@hiwab41]

First

[@Codemycom]

Nice!

[@tariqjahhaf7113]

Your efforts are honorable.. Thanks alot.. and for the checkbox issue you are not updating the unchecked Events, This is how I solved that: events = Event.objects.all().order_by('-date', 'name') context = { 'events': events } all_true_list = [] for event in events: if event.approved: all_true_list.append(str(event.id)) if request.user.is_superuser: if request.method == 'POST': checked_id_list = request.POST.getlist('boxes') for item in all_true_list: if item not in checked_id_list: Event.objects.filter(pk=int(item)).update(approved=False) else: pass for item in checked_id_list: Event.objects.filter(pk=int(item)).update(approved=True) messages.success(request, "Events updated") return redirect('events_list.html') else: return render(request, 'events_list.html', context) else: messages.success(request, "You are not authorized to view this page") return redirect('home')