[DRF]-DB 세팅(MySQL)

1. DRF-MySQL 연동

• settings.py에 코드 추가

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': env('NAME'),
        'USER': env('DB_USER'),
        'PASSWORD': env('PASSWORD'),
        'HOST': env('HOST'),
        'PORT': env('PORT'),
        'OPTIONS': {
            'init_command': 'SET sql_mode="STRICT_TRANS_TABLES"'
        }
    }
}

• .env 세팅(backend(앱)/.env)

DEBUG=on
NAME={name}
DB_USER={user}
PASSWORD={password}
HOST={host}
PORT=3306

---

2. Model 생성

• user

class User(models.Model):
    user_id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False, null=False)
    email = models.EmailField(max_length=200, null=False,default=False)
    password = models.CharField(max_length=255, null=False, default=False)
    created_at = models.DateTimeField(auto_now_add=True, blank=True)

    deleted_at = models.DateTimeField(auto_now=True, blank=True)
    is_deleted = models.BooleanField(default=False)

    class Meta:
        db_table = 'user'

---

3. Migration

• Migration : model의 변경 내용을 DB에 알려줌

python3 manage.py makemigrations
: Migration 생성

python manage.py migrate
: Migration 적용

• 결과