Skip to main content

A configurable automatic sequence field for Django models

Project description

Django AutoSequence

.. image::

.. image::

.. image::

A model field for Django that provides for a configurable automatic sequence of values


The full documentation is at


Install Django AutoSequence::

pip install django-autosequence

Add the AutoSequenceField to your models like so::

class ModelWithStartAt(Model):
sequence = AutoSequenceField(start_at=100)

class ModelWithUnique(Model):
name = CharField(max_length=200)
sequence = AutoSequenceField(unique_with='name')

class ModelWithUniqueCombo(Model):
name = CharField(max_length=200)
simple_model = ForeignKey(SimpleModel, on_delete=CASCADE)
sequence = AutoSequenceField(unique_with=('simple_model', 'name'))

AutoSequenceField is an AutoField that is available for non primary keys and can be configured with unique_with to have separate sequences based on other model fields.

For example, say you have a model Invoices that tracks Invoices you have issued to different customers and you would like the invoice number to be autoincrementing but unique for each customer. You would add a field like::
class Invoice(models.Model):
customer = models.ForeignKey('Customer')
invoice_number = AutoSequenceField(unique_with='customer')

It does this but running a select query against the model to find the highest sequence number for the given set of unique_with fields. This means that if you delete the last object created, the sequence number of that object will be reused next time you create a new object.

This behavior may be undesirable in some circumstances however in general this field type is intended to be used with models where deletions are infrequent or disabled entirely.

It is non editable and unique, either unique for all rows in the table or unique_with another field or fields in the table.

The following keywords may be passed to AutoSequenceField:

**start_at**: *integer*: the starting number of the sequence, defaults to 1. Ex: start_at=100

**unique_with**: *string or tuple of strings*: the name or names of other fields on this model that this sequence will be unique with. Ex: unique_with='category'

Running Tests

Does the code actually work?


$ pip install pipenv
$ pipenv install -d --three
$ pytest


Tools used in rendering this package:

* Cookiecutter_
* `cookiecutter-djangopackage`_

.. _Cookiecutter:
.. _`cookiecutter-djangopackage`:

0.3.0 (2016-11-14)

* Switched to pytest
* Dropped explicit support for Django <2 and Python < 3

0.2.0 (2016-11-14)

0.1.0 (2016-11-14)

* First release on PyPI.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for django-autosequence, version 0.3.4
Filename, size File type Python version Upload date Hashes
Filename, size django_autosequence-0.3.4-py2.py3-none-any.whl (3.8 kB) File type Wheel Python version 3.6 Upload date Hashes View
Filename, size django-autosequence-0.3.4.tar.gz (6.0 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page