from django.db import connection
from django.test.utils import CaptureQueriesContext
with CaptureQueriesContext(connection) as ctx:
curo_entity, _ = CuroGenericModel.objects.update_or_create(
curo_id="__some_uuid__",
defaults={
"curo_entity": 't4a_riskprofile',
"name": '1 (Evalue)',
},
)
pp(ctx.captured_queries)
[{'sql': 'BEGIN', 'time': '0.000'},
{'sql': 'SELECT "oneview_curogenericmodel"."id", '
'"oneview_curogenericmodel"."is_deleted", '
'"oneview_curogenericmodel"."is_dummy", '
'"oneview_curogenericmodel"."date_deleted", '
'"oneview_curogenericmodel"."date_created", '
'"oneview_curogenericmodel"."date_updated", '
'"oneview_curogenericmodel"."created_by_system", '
'"oneview_curogenericmodel"."curo_id", '
'"oneview_curogenericmodel"."name", '
'"oneview_curogenericmodel"."curo_entity", '
'"oneview_curogenericmodel"."additional_data" FROM '
'"oneview_curogenericmodel" WHERE '
'"oneview_curogenericmodel"."curo_id" = '
"'__some_uuid__'::uuid LIMIT 21 FOR UPDATE",
'time': '0.003'},
{'sql': 'UPDATE "oneview_curogenericmodel" SET "date_deleted" = NULL, '
'"date_created" = \'2025-12-03T10:50:31.970014+00:00\'::timestamptz, '
'"date_updated" = \'2025-12-08T12:08:01.113885+00:00\'::timestamptz, '
'"name" = \'1 (Evalue)\', "curo_entity" = \'t4a_riskprofile\' WHERE '
'"oneview_curogenericmodel"."id" = '
"'__some_uuid__'::uuid",
'time': '0.012'},
{'sql': 'INSERT INTO "oneview_historicalcurogenericmodel" ("id", '
'"is_deleted", "is_dummy", "date_deleted", "date_created", '
'"date_updated", "created_by_system", "curo_id", "name", '
'"curo_entity", "additional_data", "history_date", '
'"history_change_reason", "history_type", "history_user_id") VALUES '
"('68f0ef89-4fef-4885-8651-a98e2c6f9e75'::uuid, false, false, NULL, "
"'2025-12-03T10:50:31.970014+00:00'::timestamptz, "
"'2025-12-08T12:08:01.113885+00:00'::timestamptz, 'oneview', "
"'4ffc3ee1-b948-ed11-a85b-000d3a7ef302'::uuid, '1 (Evalue)', "
"'t4a_riskprofile', NULL, "
"'2025-12-08T12:08:01.125829+00:00'::timestamptz, NULL, '~', NULL) "
'RETURNING "oneview_historicalcurogenericmodel"."history_id"',
'time': '0.010'},
{'sql': 'COMMIT', 'time': '0.002'}]See also this useful websites on other ways to see sql queries