Python, MySQL, Django: set default value for table columns

Question

My tables are specified as models in Python, which are then made into MySQL tables by Django. In Python:

class my_table(models.Model):
    is_correct = models.IntegerField(default = 0)

If I do an insert into this table then I want it to automatically insert 0 for the column is_correct unless I specify a different value. I also want this to happen if I am using raw sql or if I am inserting from a MySQL stored procedure.

The default argument only seems to work from within Python. It's not translated into anything that MySQL sees. Is such a thing possible?

This seems to be a problem that the Django project has decided to classify as wontfix. — eradman
– eradman, Commented Mar 12, 2013 at 20:15

San4ez · Accepted Answer · 2012-05-08 13:25:27Z

2

Yes, default argument works on django level. If you want to move it to mysql, perform ALTER TABLE ... query manually.

You also can try to extend models.IntegerField and override db_type. But it should be done for every field...

answered May 8, 2012 at 13:25

San4ez

8,2714 gold badges44 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python, MySQL, Django: set default value for table columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related