migrate 오류 질문

안녕하세요, 강사님.

제가 개인적으로 진행하고 있는 프로젝트의 models.py를 일부 수정하고 migration 이후 migrate를 진행할 때 오류가 나고 있어 질문드립니다.

from django.db import models
from django.contrib.auth.models import User
from urllib3 import encode_multipart_formdata


# Create your models here.


# Customer 모델
class Customer(models.Model):
user = models.OneToOneField(User, null=False, blank=False, on_delete=models.CASCADE, default=0) # User모델과 1대1 관계 / null=True는 비워도 괜찮다는 것. / on delete를 사용해서 회원이 지워지면 고객도 지워지게 한다.
name = models.CharField(max_length=100, null=False, default=0) # 디폴트 값을 미지정으로 수정
email = models.CharField(max_length=100)

def __str__(self):
return f'user: {self.user} | name: {self.name} | email: {self.email}'


# Products 모델
class Post(models.Model):
product_name = models.CharField(max_length=100)
brand = models.TextField()
price = models.PositiveIntegerField(default=0) # 가격이니까 실수가 아닌 정수 필드로 수정
image = models.ImageField(null=True, blank=True) # 이미지이니까 Image 필드 선택
created_at = models.DateTimeField(auto_now_add=True) # 상품 db에 추가할 때 날짜 설정
updated_at = models.DateTimeField(auto_now=True) # 수정될 떄마다 날짜 설정

def __str__(self):
return f'product_name: {self.product_name} | brand: {self.brand} | price: {self.price} | image: {self.image} |created_at: {self.created_at}'

@property
def imageURL(self):
try:
url = self.image.url
except:
url = 'posts/'
return url


# Order 모델
class Order(models.Model):
customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True) # Customer가 회원탈퇴 하더라도 주문 내역을 유지하기
date_ordered = models.DateTimeField(auto_now_add=True)
complete = models.BooleanField(default=True, null=True, blank=True)
transaction_id = models.CharField(max_length=200, null=True)

def __str__(self):
return f'id: {self.id} | customer: {self.customer} | date_ordered: {self.date_ordered} | complete: {self.complete} | transaction_id: {self.transaction_id}'


@property
# 장바구니에 담은 모든 상품들의 총 금액을 계산하는 코드
def get_cart_total(self):
orderitems = self.orderitem_set.all()
total = sum([item.get_total for item in orderitems])
return total

# 장바구니에 담은 모든 상품들의 수를 계산하는 코드
def get_cart_items(self):
orderitems = self.orderitem_set.all()
total = sum([item.quantity for item in orderitems])
return total




# Order item 모델
class OrderItem(models.Model):
product = models.ForeignKey(Post, on_delete=models.SET_NULL, blank=True, null=True)
order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True)
quantity = models.IntegerField(default=0, null=False, blank=False)
date_added = models.DateTimeField(auto_now_add=True)

def __str__(self):
return f'id: {self.id} | product: {self.product} | order: {self.order} | quantity: {self.quantity} | date_added: {self.date_added}'


# 장바구니에서 총 합계를 볼 수 있도록 property operator를 설정
@property
def get_total(self):
total = self.product.price * self.quantity
return total



# Shipping Address 모델
class ShippingAddress(models.Model):
customer = models.ForeignKey(Customer, on_delete=models.SET_NULL, blank=True, null=True)
order = models.ForeignKey(Order, on_delete=models.SET_NULL, blank=True, null=True)
address = models.CharField(max_length=200, null=True)
city = models.CharField(max_length=200, null=True)
zipcode = models.CharField(max_length=200, null=True)
date_added = models.DateTimeField(auto_now_add=True)

def __str__(self):
return f'{self.address}'

위의 코드들은 models.py인데, 제가 여기서 Customer 모델 클래스의 user와 name 필드의 속성을 수정했습니다. 기존에는 null과 blank가 True로 되어있어 False로 수정을 하고 migration을 진행했는데, name과 user 필드 모두 non-nullable로 바꾸는데 default를 주지 않았다고 나왔습니다.

그래서,

name = models.CharField(max_length=100, null=False, default='미지정')

user = models.OneToOneField(User, null=False, blank=False, on_delete=models.CASCADE, default='미지정')

이렇게 수정하고 migrations를 진행하니까 넘어가고 migrate를 진행하니까

(env) kimsangbaek@gimsangbaeg-ui-MacBookAir impactmuseum % python manage.py makemigrations posts

Migrations for 'posts':

posts/migrations/0004_auto_20220206_0259.py

- Alter field name on customer

- Alter field user on customer

(env) kimsangbaek@gimsangbaeg-ui-MacBookAir impactmuseum % python manage.py migrate posts

Operations to perform:

Apply all migrations: posts

Running migrations:

Applying posts.0003_auto_20220206_0249...Traceback (most recent call last):

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1823, in get_prep_value

return int(value)

ValueError: invalid literal for int() with base 10: '미지정'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

File "/Users/kimsangbaek/Desktop/likelion/env/impactmuseum/manage.py", line 22, in <module>

main()

File "/Users/kimsangbaek/Desktop/likelion/env/impactmuseum/manage.py", line 18, in main

execute_from_command_line(sys.argv)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 419, in execute_from_command_line

utility.execute()

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/__init__.py", line 413, in execute

self.fetch_command(subcommand).run_from_argv(self.argv)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/base.py", line 354, in run_from_argv

self.execute(*args, **cmd_options)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/base.py", line 398, in execute

output = self.handle(*args, **options)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/base.py", line 89, in wrapped

res = handle_func(*args, **kwargs)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 244, in handle

post_migrate_state = executor.migrate(

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 117, in migrate

state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards

state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/migrations/executor.py", line 227, in apply_migration

state = migration.apply(state, schema_editor)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/migrations/migration.py", line 126, in apply

operation.database_forwards(self.app_label, schema_editor, old_state, project_state)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/migrations/operations/fields.py", line 244, in database_forwards

schema_editor.alter_field(from_model, from_field, to_field)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/backends/sqlite3/schema.py", line 140, in alter_field

super().alter_field(model, old_field, new_field, strict=strict)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 608, in alter_field

self._alter_field(model, old_field, new_field, old_type, new_type,

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/backends/sqlite3/schema.py", line 362, in _alter_field

self._remake_table(model, alter_field=(old_field, new_field))

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/backends/sqlite3/schema.py", line 202, in _remake_table

'default': self.quote_value(self.effective_default(new_field))

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 324, in effective_default

return field.get_db_prep_save(self._effective_default(field), self.connection)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/models/fields/related.py", line 971, in get_db_prep_save

return self.target_field.get_db_prep_save(value, connection=connection)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 842, in get_db_prep_save

return self.get_db_prep_value(value, connection=connection, prepared=False)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 2486, in get_db_prep_value

value = self.get_prep_value(value)

File "/Users/kimsangbaek/Desktop/likelion/env/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 1825, in get_prep_value

raise e.__class__(

ValueError: Field 'id' expected a number but got '미지정'.

다음과 같이 id 필드에 숫자가 필요하다고 나오더라구요.. 그래서 최종적으로 위의 코드와 같이 user와 name의 default=0 이렇게 설정하고 다시 migration, migrate를 진행해도 위와 같이 오류가 해결되지 않고 있습니다.

구글링 해봤을 때 아예 migrations 파일을 지우라고 하는 경우도 있던데 확실하지가 않아 이렇게 질문을 드리게 되었습니다. 천천히 답변주시면 감사하겠습니다!

인프런 커뮤니티 질문&답변