Django over Postgresql: using raw sql insert with returning statement not working

Question

Using Postgresql 9.3 + PostGIS with django, I'm trying to enter a record to my table and return the given id like so

def join(request):
    from django.db import connection, transaction
    cursor = connection.cursor()
    id = cursor.execute("insert into table1 values(DEFAULT, 'temp', null,-4, null,null, null, null, DEFAULT, 1,null,DEFAULT,DEFAULT, null) returning id")
    transaction.set_dirty()

    return HttpResponse(id)

this returns None, how can i get the id that is returned from the sql query

Matt Williamson · Accepted Answer · 2013-12-23 17:51:12Z

2

from django.db import connection, transaction

def join(request):
    cursor = connection.cursor()
    id = cursor.execute("insert into table1 values(DEFAULT, 'temp', null,-4, null,null, null, null, DEFAULT, 1,null,DEFAULT,DEFAULT, null)")
    transaction.set_dirty()
    last_id = connection.insert_id()
    return HttpResponse(str(last_id))

edited Dec 23, 2013 at 17:51

answered Dec 23, 2013 at 16:12

Matt Williamson

40.3k10 gold badges67 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Kukula Mula Over a year ago

I'm getting an error global name 'string' is not defined also if i print last_id i get 0

Matt Williamson Over a year ago

Sorry about that. Fixed. Use str

Matt Williamson Over a year ago

Edited again, to use the connection object to get the id

Kukula Mula Over a year ago

now i'm getting this error: 'DatabaseWrapper' object has no attribute 'insert_id'

adityasdarma1 · Accepted Answer · 2013-12-24 09:29:49Z

0

What is your database backend? If you use sqlite3,

def join(request):
    from django.db import connection, transaction
    cursor = connection.cursor()
    cursor.execute("insert into table1 values(DEFAULT, 'temp', null,-4, null,null, null, null, DEFAULT, 1,null,DEFAULT,DEFAULT, null)")
    cursor.execute("SELECT last_insert_rowid() FROM table1")
    id = cursor.fetchone()[0]
    transaction.set_dirty()

    return HttpResponse(id)

answered Dec 24, 2013 at 9:29

adityasdarma1

3251 silver badge8 bronze badges

Collectives™ on Stack Overflow

Django over Postgresql: using raw sql insert with returning statement not working

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related