Generate table using raw SQL query and want to use those tables as ORM in Django

Question

table_title = 'transaction_' + username
with connection.cursor() as cursor:
    sql = 'CREATE TABLE ' + table_title + '(id uuid NOT NULL,
    sql += 'amount numeric(10,2) NOT NULL,
    sql += 'CONSTRAINT transaction_pkey' + username + ' PRIMARY KEY (id),'
    cursor.execute(sql)

I have create table using this code. Now what I want:

• I want to use them in the application's admin.py
• I want show them in Django's admin panel
• I want to use this table as ORM in views.

Is it possible? If yes, then how?

Answer 1

There is no way use ORM while you execute raw SQL. If you want to an admin panel you have to develop your own custom admin panel.