sql django oracle-database unit-testing django-testing

Django: how to see the SQL query when running tests?

One of my django application unit test fails with

DatabaseError: ORA-00942: table or view does not exist

I would like to see actual SQL query that caused this error. Do you know how to achieve that?

Solution

The best solution I found so far is debugsqlshell custom django management command provided by django-debugtoolbar.

Query to find position in a string before keyword and extract data before that position
SQL: get next relative day of week. (Next Monday, Tuesday, Wed.....)
#1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
java.sql.SQLException: Column Index out of range, 2 > 1
Should LIKE 'searchstr%' use an index?
Multiple STRING_AGG in one query
Postgres: Add constraint if it doesn't already exist
UPDATE Statement ignores INNER JOIN
Execute Stored Procedure Minimal API .Net
Change default schema for user
Oracle SQL - Select oldest of 3 dates, but ignore NULLs
Housing Society management system database structure
Keep getting error: PLS-00103: Encountered the symbol "CREATE"
How to use an UPDATE Query with an INNER JOIN to update fields within a table
Extract 4 million rows from database in chunks of 1 million rows each
Aggregate into custom groups
SQL query for chat application
SQL basic problem when trying to SELECT 4 atributes and use GROUP BY with only 2
How to modify query converting DATEDIFF to Oracle accepted syntax?
Sales data analysis: calculate percentage of each product as per total sales
Calculate the sum of values for the columns that meet the criteria
Insert missing rows in time series consumption history
Oracle database dependencies in PL/SQL
How to autofill a field with data from another field in the same table?
In Oracle: How to sort by group/cluster by a column value
oracle SQL query - add date rows using different date
How to fix products without cover image in PrestaShop
IF ROW_COUNT() return error
Select with like is not returning the correct results
I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?