Django OR query

[@wannabedevo7]

Thanks, just thanks! I really love and enjoy this channel. You're possibly the only creator with this quality level serving really in-depth knowledge about django. I Would love more videos regarding DRF and Deployment, and freecodecamp is also a great idea.

[@veryacademy]

Thank you! - Yeah DRF I haven't lost focus on that promise. I know I seem to be moving away from it - I most definitely am not. Time is never on my side - but it will continue shortly.

[@heyrmi]

I came here for Django ORM. Now I am Hooked to your channel.

[@veryacademy]

Hi Rahul! Thank you, and long may it continue! 👍

[@chetty1212]

you never fail to impress. i am implementing this django ORM SQL logic into my own project works amazing. thanks

[@veryacademy]

Great to hear!

[@RafathBinZafarAuvee]

This channel is under rated

[@veryacademy]

👍 Thank you

[@oliver1231033]

your tutorials are NEXT LEVEL! keep up the great work!

[@veryacademy]

Thanks, will do!

[@djangodeveloper07]

you have solid knowledge which we can see through your videos and teaching method. just new to your channel. Subscribed and following for your next videos. for now following your other playlists to get more knowledge about Django

[@veryacademy]

Welcome aboard! Thank you!

[@rangabharath4253]

awesome. Everytime i watch your videos i will learn a new thing. Today i learned about sqlite extension in vscode. Previously about docker extension. Those are really very useful to explore data from vs code itself. Tq so much. You should definitely do a video on freecodecamp, so everyone will know about your awesome channnel. All the best :)

[@veryacademy]

Hi Ranga - thanks for the suggestion about freecodecamp - once I have everything in order and the plan is fully established here on KZbin I will start to actively look for these types of opportunities. If you could for the time being add a few links here and there on social media - that would be most appreciated. I do actively try and add something new in each video 👍

[@rangabharath4253]

@@veryacademy Sure. Cheers :)

[@Oda3908]

Great tutorial! I am using debug toolbar to show the detail of queries but have not idea where does that info come from. BTW django-extensions is also a good tool to enhance the Django shell by running python manage.py shell_plus, which will import all existed models, Q, F, aggregate, and many useful functions on your behalf when launched, and use an ipython shell, quite recommendable.

[@tbaror]

Like all your tutorials Gold value, thank you

[@veryacademy]

Glad you like them!

[@Ameyiscool]

Why isn't the or statement just returning the first query ??? Why is it returning both?

[@rajughorai3909]

really enjoying your content. do have any plan doing django cache.

[@veryacademy]

I am bumping it up the list - so many others have now asked for it.

[@amjadsaleem1270]

So for me print(connection.queries) returns an empty list what am I missing?

[@vamsikrishnaaliveli938]

Hello bro i have written code : "print(connections.queries) " but it print empty list what i have to do

[@veryacademy]

Hey, hmmm does this help docs.djangoproject.com/en/4.0/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running

[@vamsikrishnaaliveli938]

@@veryacademy Hi !!!!, I put the " DEBUG=True " but i get the same result

[@jhutchtor1]

Any chance this can be updated to Django 4 as it has changed and this no longer works.

[@veryacademy]

Noted, thank you.

[@shivaramsrikanth]

sir, if I want to activate this query from the webpage, how will I do it? What would be the url?

[@veryacademy]

Hey, Shivaram. Sounds like you are new to Django, it is a long explanation - however take a look at this beginners series kzbin.info/aero/PLOLrQ9Pn6cawWd-5UZM6CIm0uqFXeBcTd

[@samiulsalehin1560]

How to find which importables can be imported from django.db?

[@sanketnawale1938]

print(connection.query) is returning as empty list. Any suggestion?

[@veryacademy]

Would need to see a little more code

[@sanketnawale1938]

@@veryacademy Well, I found out the issue but didn't understand the concept behind it. It return empty string when I do the following print statements: print(posts.query) print(connection.queries) It return the output when I also add: print(post).

[@rare7647]

amazing

[@biplob9764]

Which version of Django are you using?

[@veryacademy]

Hi Bip, at the start of the tutorials it lists some of the important version numbers. Also, in the project repositories, normally you will see a file called requirements.txt - this gives you the version of all packages installed.

[@biplob9764]

@@veryacademy sorry I don't see any requirements file. can you please check this

[@veryacademy]

@@biplob9764 Sorry Bip - that is an older tutorial! I didnt notice that! It is Django 3.1

[@biplob9764]

@@veryacademy Thank you though. You are awesome!

[@aniketanuse5694]

How to enable | and query function

[@akshattrivedi4933]

how to get an option to open database in pycharm?

[@veryacademy]

www.jetbrains.com/help/pycharm/database-tool-window.html let me know if this helps

[@akshattrivedi4933]

@@veryacademy sorry but this didn't help

[@akshattrivedi4933]

@@veryacademy there is no such an option of database in tool windows of view , the only options relates to the database are DB browser and DB execution console

[@akshattrivedi4933]

@@veryacademy waiting for your reply sir

[@MagnusAnand]

QUESTION: What's the benefit of using a Q object???

[@veryacademy]

Hi Guz, You can compose statements of arbitrary complexity by combining Q objects with the & and | operators and use parenthetical grouping. Also, Q objects can be negated using the ~ operator, allowing for combined lookups that combine both a normal query and a negated (NOT) query. docs.djangoproject.com/en/3.1/topics/db/queries/ books.agiliq.com/projects/django-orm-cookbook/en/latest/query_relatedtool.html riptutorial.com/django/example/4565/advanced-queries-with-q-objects bradmontgomery.net/blog/adding-q-objects-in-django/

[@MagnusAnand]

@@veryacademy thanks