How to update Django model fields in MySQL database

Question

I created a model for posts in Django and I'm trying to update one of the fields in the database (MySQL). I have the following block of code: model.py

class Post (models.Model):
    title = models.CharField()
    preamble = models.CharField()
    body = models.TextField ()
createdAt = models.DateTimeField(auto_now_add=True, blank=True)

I want to add another field called author author=models.ForeignKey(User, on_delete=models.CASCADE Also, I want to change the name of one of the fields from preamble to introduction

Whenever I run the command python manage.py makemigrations and then python manage.py migrate, I get an error which terminates the migration process. it's telling me that the field preamble which I have in my database is not recognized. Is it possible to update preamble to introduction?

AKX · Accepted Answer · 2020-12-30 08:23:24Z

1

Ensure you have a migration of the initial state of your app, before any modifications.
Rename the preamble field to introduction in your model, making no other changes.
Run makemigrations. It should ask you whether it was a rename.
Add the author foreign key.
Run makemigrations. It should ask you for a default for the user field if it's not nullable; 1 should hopefully refer to the first user created in your system.
Run migrate.

answered Dec 30, 2020 at 8:23

AKX

171k16 gold badges147 silver badges229 bronze badges

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

Comments

ijaz Bacha · Accepted Answer · 2020-12-30 08:20:27Z

0

This should be work:

delete the SQLite database and also migrations directory
change the model
then run the migrate command

answered Dec 30, 2020 at 8:20

ijaz Bacha

491 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to update Django model fields in MySQL database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related