Django over Postgresql：使用raw sql insert与return语句不工作 [英] Django over Postgresql: using raw sql insert with returning statement not working

问题描述

使用Postgresql 9.3 + PostGIS与django，我试图输入一个记录到我的表，并返回给定的id像这样

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)

这返回无 ，如何从django获取从sql查询返回的id

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

推荐答案

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))

这篇关于Django over Postgresql：使用raw sql insert与return语句不工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！