How do I make an auto increment integer field in Django?

by

In Django

1 : Django model class has default field with name id which is auto increment Field.
2 : You can define your own auto increment field using AutoField
field.

class Order(models.Model):
    auto_increment_id = models.AutoField(primary_key=True)
    # primary_key = True if you do not want to use default field "id" given by django to your model

db design

+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table      | Create Table                                                                                                                                                  |
+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
| core_order | CREATE TABLE `core_order` (
  `auto_increment_id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`auto_increment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

If you want to use django’s default id as increment field .

class Order(models.Model):
    add_date = models.DateTimeField(auto_now_add=True)

db design

+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                                    |
+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| core_order | CREATE TABLE `core_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `add_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+

More Related Contents:

  1. django.core.exceptions.ImproperlyConfigured: Requested setting INSTALLED_APPS, but settings are not configured. plz help me out plz
  2. What is the difference between null=True and blank=True in Django?
  3. Django set default form values
  4. What’s the difference between select_related and prefetch_related in Django ORM?
  5. Can “list_display” in a Django ModelAdmin display attributes of ForeignKey fields?
  6. How to pull a random record using Django’s ORM?
  7. Django – No such table: main.auth_user__old
  8. Django rest framework serializing many to many field
  9. How to create an object for a Django model with a many to many field?
  10. Django Unique Together (with foreign keys)
  11. django template system, calling a function inside a model
  12. Django : Table doesn’t exist
  13. Get all related Django model objects
  14. Django Model MultipleChoice
  15. How to filter objects for count annotation in Django?
  16. Access django models inside of Scrapy
  17. How do I separate my models out in django?
  18. Django Many-to-Many (m2m) Relation to same model
  19. Writing a __init__ function to be used in django model
  20. Easiest way to rename a model using Django/South?
  21. Difference between AbstractUser and AbstractBaseUser in Django?
  22. Customize/remove Django select box blank option
  23. Duplicating model instances and their related objects in Django / Algorithm for recusrively duplicating an object
  24. Override a form in Django admin
  25. Identify the changed fields in django post_save signal
  26. How can I set two primary key fields for my models in Django?
  27. Django 2.1.3 Error: __init__() takes 1 positional argument but 2 were given
  28. Django foreign key relation in template
  29. Django get_profile() method not working on extended User model
  30. How to delete a record in Django models?

Leave a Comment