Execute a raw query to create object in Django

Question

I have a table which not defined as a Model in Django server. So I need to use raw query to create object in Database

My database:

Table name: msg_rooms

I want to create object { with_user: 5, room_name: 'abc', user_id: 2 } by using raw query in Django.

J. Ghyllebert · Accepted Answer · 2018-11-20T15:57:18.727

2

The raw query is only for model related queries. However you can use something like

from django.db import connection

with connection.cursor() as cursor:
    connection.execute(
        "INSERT INTO msg_rooms(with_user, room_name, user_id) "
        "VALUES (%s, %s, %s)", [5, 'abc', 2])

You can read more details on https://docs.djangoproject.com/en/2.1/topics/db/sql/#executing-custom-sql-directly

edited Nov 20 '18 at 15:57

answered Nov 20 '18 at 08:26

J. Ghyllebert

2,009
1
29
35

But how can i get the new id of created object? – KitKit Nov 20 '18 at 08:28
1

That would depend on your database, https://stackoverflow.com/questions/8479315/sql-inserting-a-row-and-returning-primary-key – J. Ghyllebert Nov 20 '18 at 08:30

Execute a raw query to create object in Django

1 Answers1