Given the following model, I want to index the fields (sequence,stock)
class QuoteModel(models.Model):
quotedate = models.DateField()
high = models.FloatField() #(9,2) DEFAULT NULL,
low = models.FloatField() #(9,2) DEFAULT NULL,
close = models.FloatField() #(9,2) DEFAULT NULL,
closeadj = models.FloatField() #(9,2) DEFAULT NULL,
volume = models.IntegerField() #(9,2) DEFAULT NULL,
stock = models.IntegerField(db_index=True) #(9,2) DEFAULT NULL,
open = models.FloatField() #(9,2) DEFAULT NULL,
sequence = models.IntegerField() #(9,2) DEFAULT NULL,
This index should be non-unique - in mysql it should be something like:
create index ndx_1 on model_quotemodel(sequence,stock);
The only Django workaround I know of is creating an "sql" file that will be executed by django upon table creation. So, I created a "stockmodel.sql" containing the following query (same as above:)
create index ndx_1 on model_quotemodel(sequence,stock);
Is there any "cleaner" way of doing it?
As of Django 1.5, you can use the Meta.index_together
option:
class QuoteModel(models.Model):
# ... fields ...
class Meta:
index_together = [
("sequence", "stock"),
]
(note: the original answer from 2009 said it was not possible to index multiple fields; it has since been replaced)
There is a ticket for this feature. Take a look http://code.djangoproject.com/ticket/5805
You may apply the patch from this ticket yourself.
UPDATE
It's now in Django: https://docs.djangoproject.com/en/1.5/ref/models/options/#django.db.models.Options.index_together
To follow on from the accepted answer, if you are using South, you can easily add a composite key as follows:
manage.py schemamigration your_app_name name_for_migration --add-index ModelName.first_field_in_index
You can then edit the generated migration file to add the additional fields into the one index (you'll see it's just a list of field names that's needed).
Don't forget to update the reverse migration as well as the forward one.
It is index_together in django 1.5
See here https://docs.djangoproject.com/en/dev/ref/models/options/#index-together
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With