Django ORM - Performing raw SQL queries

[@treblaoj]

Such an excellent peace of teaching!! Thanks to much for the class!

[@fabiofboful]

Thank you so much man.

[@vishnudasks]

You are Great

[@URKI3221]

hello, first i want to thank you because these totorials have been useful for me, and i want to ask you if it's possible to use stored procedure or function instead of raw sql to load data in a model. thanks in advance

[@veryacademy]

Good to hear. Do you mean using fixtures?

[@URKI3221]

​@@veryacademy not exactly, I mean, you're using raw sql to populate a model "SELECT * FROM SQLITETABLE", I'm using postgres function to return data. i'll reformulate my question, how can we load data retreived from a cursor into a model?

[@MrRahul15937]

Hello sir, Kindly guide on how to take Boolean searches from user forms and implement Raw queries

[@tusharjangid2492]

Really well explained, thanks for the video🙌.

[@PEMIDI]

very useful

[@veryacademy]

Glad you think so!

[@dharunap9906]

May i know how to perform insert and delete using this raw method

[@sanjaykrish8719]

Thanks a lot. Not a big fan of ORM

[@mateoscarafia5110]

long live raw sql

[@jenilgandhi2111]

def search_query(request): print(request.POST['search_query']) # x=likes.objects.raw("Select Like_id,likes.Post_id from home_likes") # Operational Error: No column found Post_id x=likes.get_treding() print(len(x)) return render(request,'search/search_query_page.html') CAN YOU SOLVE THIS

[@jenilgandhi2111]

my models is class likes(models.Model): like_id=models.AutoField(primary_key=True) post_id=models.ForeignKey(post,on_delete=models.CASCADE) liker_user=models.ForeignKey(User,on_delete=models.CASCADE) date_liked=models.DateField(default=datetime.date.today)