sql django oracle unit-testing django-testing

django how to see 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.

Function vs. Stored Procedure in SQL Server
How to correctly join two tables that each have Start Date and Stop Date columns?
PHP XAMPP Config
SQL select distinct with condition
To get the previous record which is less than the given date and time
Create OBJECT with column values as Key in Snowflake
How to load multiline csv feature into MySQL
SQL copying data with new foreign keys
An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
SQLAlchemy - Get query results in same order as IN clause
SQL Grouping and Nested Concatenation
Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
How can I refer to a variable in postgresql dynamic SQL?
How to pull width & height out of string?
Add new columns without using Alter
Get columns of index on DB2
Athena Query - "NOT IN" slow performance
SQL one to one relationship vs. single table
How can I number the instance of a duplicate record?
How to fix SQL for AWS Athena
SQL SELECT query not working in mysql
How can i insert/ select into a table and delete copied records from original table?
How to convert oracle regex pattern into Databricks compatible version?
Select min or max based on where duplicate value exists
Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
WHERE clause pulling incorrect values
Sql select all conversation by group
Create an inline SQL table on the fly (for an excluding left join)
How to execute raw SQL in Flask-SQLAlchemy app