Get the last inserted id in django

Question

I am migrating some data from other databases , so i am using raw sql queries for inserting data into database . But i don't know how to get last inserted id from raw sql queries in django. I have tried this

affected_count1=cursor2.execute("table')")

and

SELECT IDENT_CURRENT(‘MyTable’)

but it gives me the error of "(1305, 'FUNCTION pydev.SCOPE_IDENTITY does not exist')"

So please tell me how can i get the last inserted id in raw sq l queries in django

http://stackoverflow.com/questions/2548493/in-python-after-i-insert-into-mysqldb-how-do-i-get-the-id — ndpu, Feb 12 '13 at 12:22

score 29 · Answer 1 · answered Feb 12 '13 at 12:38

29

You can get latest create obj like this:

obj = Foo.objects.latest('id')

more info here

answered Feb 12 '13 at 12:38

UnLiMiTeD

1,000
1
9
17

No, this is unrelated to the question. – wRAR Feb 12 '13 at 12:46
I know it is unrelated to the question: but whenever I try to add default=Foo.objects.latest('id') to a ForeignKey in a model; I get the error "App registry isn't ready yet." while launching. (Django 1.7a2); do you know why? – Martin Grohmann Mar 31 '14 at 13:54
1

is latest, use concurrency ? – Anurag May 13 '14 at 14:13

score 4 · Answer 2 · answered Jan 20 '22 at 12:28

4

Try this

LastInsertId = (TableName.objects.last()).id

answered Jan 20 '22 at 12:28

Merrin K

1,602
1
16
27

What's the benefit of using `last().id` over using `.latest('id')`, as proposed in the top-voted answer? – Jeremy Caney Jan 21 '22 at 00:46
.latest('id') Throwed an error :> TypeError: Object of type TableName is not JSON serializable – Merrin K Jan 21 '22 at 05:55

score 3 · Answer 3 · answered Dec 14 '13 at 21:57

3

In Django 1.6

obj = Foo.objects.latest('id')

obj = Foo.objects.earliest('id')

answered Dec 14 '13 at 21:57

adeleinr

665
7
14

Get the last inserted id in django

3 Answers3