Django - executing queries in save method

Question

The following code:

>>> from mainapp.models import ServerType
>>> server_type = ServerType()
>>> server_type.name = 'Origin'
>>> server_type.save()
>>> server_type.id
4L

generates mysql log:

SET NAMES utf8
set autocommit=0
SET SQL_AUTO_IS_NULL = 0
INSERT INTO `ServerType` (`name`, `description`) VALUES ('Origin', '')
commit

How does django know the new id without extra select statement?

django=1.4

mysql=5.1

In addition to Daniels, answer, you can read this dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html - It is specific to mysql, but you get the idea. — karthikr
– karthikr, Commented Sep 20, 2013 at 19:15

Daniel Roseman · Accepted Answer · 2013-09-20 19:10:59Z

2

The database adapter always responds with the new primary key on an insert statement. No extra queries required.

answered Sep 20, 2013 at 19:10

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Answer 1