Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to make an auto-filled and auto-incrementing field in django admin

[Update: Changed question title to be more specific]

Sorry if I didn't make the question very well, I can't figure how to do this:

class WhatEver():
    number = model.IntegerField('Just a Field', default=callablefunction)
...

Where callablefunction does this query:

from myproject.app.models import WhatEver

def callablefunction():
    no = WhatEver.objects.count()
    return no + 1

I want to automatically write the next number, and I don't know how to do it.

I have errors from callablefunction stating that it cannot import the model, and I think there must be an easier way to do this. There's no need even to use this, but I can't figure how to do it with the pk number.

I've googled about this and the only thing I found was to use the save() method for auto incrementing the number... but I wanted to show it in the <textfield> before saving...

What would you do?

like image 862
CastleDweller Avatar asked Jun 26 '10 12:06

CastleDweller


3 Answers

Got it! I hope this will help everyone that has any problems making a auto-filled and auto-incrementing field in django. The solution is:

class Cliente(models.Model):
    """This is the client data model, it holds all client information. This
       docstring has to be improved."""
    def number():
        no = Cliente.objects.count()
        if no == None:
            return 1
        else:
            return no + 1

    clientcode = models.IntegerField(_('Code'), max_length=6, unique=True, \
    default=number)

    [... here goes the rest of your model ...]

Take in care:

  • The number function doesn't take any arguments (not even self)
  • It's written BEFORE everything in the model
  • This was tested on django 1.2.1

This function will automatically fill the clientcode field with the next number (i.e. If you have 132 clients, when you add the next one the field will be filled with clientcode number 133)

I know that this is absurd for most of the practical situations, since the PK number is also auto-incrementing, but there's no way to autofill or take a practical use for it inside the django admin.

[update: as I stated in my comment, there's a way to use the primary key for this, but it will not fill the field before saving]

like image 130
CastleDweller Avatar answered Sep 29 '22 19:09

CastleDweller


Every Django model already has an auto-generated primary key:

id = models.AutoField(primary_key=True)

It seems you are trying to duplicate an already existing behavior, just use the object primary key.

like image 37
Yuval Adam Avatar answered Sep 29 '22 19:09

Yuval Adam


I, too, came across this problem, my instance of it was customer.number which was relative to the customers Store. I was tempted to use something like:

# Don't do this:

class Customer(models.Model):
    # store = ...
    number = models.IntegerField(default=0)

    def save(self, *args, **kwargs):
        if self.number == 0:
            try:
                self.number = self.store.customer_set.count() + 1
            else:
                self.number = 1
        super(Customer, self).save(*args, **kwargs)

The above can cause several problems: Say there were 10 Customers, and I deleted customer number 6. The next customer to be added would be (seemingly) the 10th customer, which would then become a second Customer #10. (This could cause big errors in get() querysets)

What I ended up with was something like:

class Store(models.Model):
    customer_number = models.IntegerField(default=1)

class Customer(models.Model):
    store = models.ForeignKey(Store)
    number = models.IntegerField(default=0)

    def save(self, *args, **kwargs):
        if self.number == 0:
            self.number = self.store.customer_number
            self.store.number += 1
            self.store.save()
        super(Customer, self).save(*args, **kwargs)

PS:

You threw out several times that you wanted this field filled in "before". I imagine you wanted it filled in before saving so that you can access it. To that I would say: this method allows you to access store.customer_number to see the next number to come.

like image 32
Jacob Valenta Avatar answered Sep 29 '22 18:09

Jacob Valenta