I can’t figure it out why my raw query multiplies the result as many time as the number of users. I’m using INNER JOIN and I bonded two objects so I really can’t get it. (I’m not experienced in Django Query Language so I’m using raw query). views.py If I’m using Django ORM …
Tag: django
Adding Variables to SQL queries
I have the following code which returns a table from my ms sql Database How would I add the one_yrs_ago variable to the SQL query in this situation , like so : Answer Not seeing the full context but this is how I would do it in SQL Server I would say parameterize what you pass in is important as
How to update a specific value of a object present in array of object within Postgres JSON Field
Here is my JSON field value. which is stored in the PostgreSQL table. I want to search and update the specific user_name in the user key whose name is Devang to Dev using Django JSONField for example I have tried the RAWQuery for the find. This is the query. It will return like this I have also tried JSON_SET…
Array to string with Django and MySQL
I need to design SQL query in html on Django I have an array in my table like : When I call this array in my page : I have : [‘aa’, ‘bb’, ‘cc’] What do I do if I want : a b c I tried with .split(‘,’) but I’ve already ‘[]’ I tried with for item …
Two dependent conditions in exclude DJANGO
I want to check whether the current user already has the same movie id in his personal list or not. If he has it then I want to exclude that movie from my trending list. I want it to be something like this. views.py models.py Answer You can .exclude(…) with: If you specified a related_query_name=… [Django-doc…
How to use variable column name in filter in Django ORM?
I have two tables BloodBank(id, name, phone, address) and BloodStock(id, a_pos, b_pos, a_neg, b_neg, bloodbank_id). I want to fetch all the columns from two tables where the variable column name (say bloodgroup) which have values like a_pos or a_neg… like that and their value should be greater than 0. H…
How to get the most liked users on a particular date in django
So I have a social media app, where users can like the posts of other users. Now I fetch the top 20 users who have received the most number of likes. Everything is perfect. But the problem is I cant …
adding many to many relations is producing an empty queryset
I have a model called Occurrence with a number of foreign key and manytomany relationships (i’ve only shown a few fields here). I am having issues when attempting to create any manytomany relation to an Occurrence instance after I have loaded bulk data to my postgres (postgis) database using the sqlalch…
Conditional annotations with Aggregation over only some fields in Django
So lets assume i have two databases in my Django project There exist multiple Price entries per day for the same article. Now I want to annotate an article queryset with the average price of every article on the previous day. But I have no idea on how to do this in one efficient query. What I have done is
How to perform translation from RAW SQL to django queryset
I am struggling with conversion to django query having raw sql I am new in django and any help will be appreciated There are simple models: Winemaker – target model Wine Post Winemaker has 1+ Wines Wine has 1+ Posts I know that it should be done with annotations but have no idea how to implement it. Ans…