Error IntegrityError 1062 Duplicate entry 1-1-1 for key CSID

Question

I have a model with a unique_together defined for 3 fields to be unique together:

class MyModel(models.Model):
    clid = models.AutoField(primary_key=True, db_column='CLID')
    csid = models.IntegerField(db_column='CSID')
    cid = models.IntegerField(db_column='CID')
    uuid = models.CharField(max_length=96, db_column='UUID', blank=True)

    class Meta(models.Meta):
        unique_together = [
            ["csid", "cid", "uuid"],
        ]

Now, if I attempt to save a MyModel instance with an existing csid+cid+uuid combination, I would get:

IntegrityError: (1062, "Duplicate entry '1-1-1' for key 'CSID'")

Which is correct. But, is there a way to customize that key name? (CSID in this case)pyt

Answer 1

Hello @kartik,

Changing index name in ./manage.py sqlall output.

You could run ./manage.py sqlall yourself and add in the constraint name yourself and apply manually instead of syncdb.

$ ./manage.py sqlall test
BEGIN;
CREATE TABLE `test_mymodel` (
    `CLID` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `CSID` integer NOT NULL,
    `CID` integer NOT NULL,
    `UUID` varchar(96) NOT NULL,
    UNIQUE (`CSID`, `CID`, `UUID`)
)
;

COMMIT;

e.g.

$ ./manage.py sqlall test
BEGIN;
CREATE TABLE `test_mymodel` (
    `CLID` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
    `CSID` integer NOT NULL,
    `CID` integer NOT NULL,
    `UUID` varchar(96) NOT NULL,
    UNIQUE constraint_name (`CSID`, `CID`, `UUID`)
)
;

COMMIT;

Hope it helps!!
Thank You!!