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.

Filename, size & hash SHA256 hash help File type Python version Upload date
django_autosequence-0.3.3-py2.py3-none-any.whl (4.0 kB) Copy SHA256 hash SHA256 Wheel 3.6
django-autosequence-0.3.3.tar.gz (6.0 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page