Using django how can I combine two queries from separate models into one query?

by

I would suggest that you use Model inheritance.

Create a base model that contains date and title. Subclass Msg1 and Msg2 off it as described. Do all your queries (to fill a page) using the base model and then switch to the derived type at the last moment.

The really great thing about inheritance is that django then allows you to use the base model in foreign keys from other models, so you can make your whole application more flexible. Under the hood it is just a table for the base model with a table per sub-model containing one-to-one keys.

More Related Contents:

  1. How to select a record and update it, with a single queryset in Django?
  2. How can I temporarily disable a foreign key constraint in MySQL?
  3. How can I see the raw SQL queries Django is running?
  4. LEFT JOIN Django ORM
  5. Django select only rows with duplicate field values
  6. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  7. What is the best way to access stored procedures in Django’s ORM
  8. Django in / not in query
  9. How to include excluded rows in RETURNING from INSERT … ON CONFLICT
  10. How to delete a record in Django models?
  11. MySQL: Alternatives to ORDER BY RAND()
  12. IN vs ANY operator in PostgreSQL
  13. sql query to return differences between two tables
  14. Generate SQL Create Scripts for existing tables with Query
  15. SQL Server 2005 How Create a Unique Constraint?
  16. Is there any boolean type in Oracle databases?
  17. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  18. How to express a One-To-Many relationship in Django?
  19. sql server select first row from a group
  20. Convert Unixtime to Datetime SQL (Oracle)
  21. sqlite alter table add MULTIPLE columns in a single statement
  22. CTE error: “Types don’t match between the anchor and the recursive part”
  23. Adding a new SQL column with a default value
  24. The text, ntext, and image data > types cannot be compared or sorted, except when using IS NULL or LIKE > operator
  25. Comma Separated values with SQL Query
  26. Looping through column names with dynamic SQL
  27. What’s the purpose of SQL keyword “AS”?
  28. Using SQL Server as a DB queue with multiple clients
  29. I want to copy table contained from one database and insert onto another database table
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment