K-디지털트레이닝(빅데이터) 11일차

오늘은 aws에서 db설정이랑 로그인 기능 만들기를 했다.

1. forms.py

from django.contrib.auth.models import User
from django import forms


class RegisterForm(forms.ModelForm):
    password = forms.CharField(label='Password', widget=forms.PasswordInput)
    password2 = forms.CharField(label='Confirm Password', widget=forms.PasswordInput)

    class Meta:
        model = User
        fields = ['username', 'first_name', 'last_name', 'email']  # 필드이름은 정해져있다

    def clean_password2(self):
        cd = self.cleaned_data
        if cd['password'] != cd['password2']:
            raise forms.ValidationError('패스워드가 일치하지 않습니다.')
        return cd['password2']

2. views.py

from django.shortcuts import render
from .forms import RegisterForm

def register(request):
    if request.method == 'POST':
        user_form = RegisterForm(request.POST)
        if user_form.is_valid():#값이 있을 때 만
            new_user = user_form.save(commit=False)
            new_user.set_password(user_form.cleaned_data['password'])
            new_user.save()#문제없으면 save
            return render(request, 'registration/register_done.html', {'new_user':new_user})
    else:
        user_form = RegisterForm()

    return render(request, 'registration/register.html', {'form':user_form})

3. accounts/urls.py

from .views import register
path('register/', register, name='register')

4. register.html

{% extends 'base.html' %}

{% block title %}
    - Signup
{% endblock %}

{% block content %}
        <div class="row my-5">
         <div class="row">
            <div class="col-12 panel panel-default">
            <div class="alert alert-info">
                회원가입
            </div>
                <form action="" method="post">
                    {% csrf_token %}
                    {{ form.as_p }}
                    <input type="submit" class="btn btn-primary" value="등록">
                </form>
            </div>
        </div>
    </div>

{% endblock %}


register_done.html

{% extends 'base.html' %}

{% block title %}
    - 회원가입 축하합니다!
{% endblock %}

{% block content %}
        <div class="row my-5">
         <div class="row">
            <div class="col-12 panel panel-default">
            <div class="alert alert-info">
                어서오세요 ~ 회원가입 축하합니다!
            </div>
               <a class="btn btn-info" href="/">Move to Main</a>
            </div>
        </div>
    </div>

{% endblock %}

5. base.html 에서 Signup 페이지 연결시키기

# S3를 사용할 수 있는 곳
# 1. Static

AWS_ACCESS_KEY_ID = 'AKIAXEABGLSEPCA6BCMY'#키값(access키)
AWS_SECRET_ACCESS_KEY = 'BqV+FqEKr2gwR4WVs7KulDknNDIH0VtkQZ3NW/RO'#시크릿키
AWS_REGION = 'ap-northeast-2'
AWS_STORAGE_BUCKET_NAME = 'djangokd'

AWS_S3_CUSTOM_DOMAIN = '%s.s3.%s.amazonaws.com' % (AWS_STORAGE_BUCKET_NAME, AWS_REGION)

AWS_S3_FILE_OVERWRITE = False
AWS_S3_OBJECT_PARAMETERS = {
    'CacheControl':'max-age=86400',
}
AWS_DEFAULT_ACL = 'public-read'
AWS_LOCATION = 'static'

STATIC_URL = 'http://%s/%s/' % (AWS_S3_CUSTOM_DOMAIN, AWS_LOCATION)
STATICFILES_STORAGE = 'storages.backends.s3boto3.S3Boto3Storage'

# MEDIA_URL = '/media/'
# MEDIA_ROOT = os.path.join(BASE_DIR,'media')

DEFAULT_FILE_STORAGE = 'config.s3media.MediaStorage'
# Default primary key field type
# https://docs.djangoproject.com/en/3.2/ref/settings/#default-auto-field

# DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField'

pip install boto3
pip install django-storages

6. settings.py 앱에 등록하기

7. python manage.py collectstatic(장고에 있는 모든 ststic 파일을 넘긴다)
   -yes
   버킷 들어가서 static 안에 데이터 있으면 정상

8. settings.py

"""
Django settings for config project.

Generated by 'django-admin startproject' using Django 3.2.6.

For more information on this file, see
https://docs.djangoproject.com/en/3.2/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/3.2/ref/settings/
"""

from pathlib import Path
import os

# Build paths inside the project like this: BASE_DIR / 'subdir'.
BASE_DIR = Path(__file__).resolve().parent.parent

# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/3.2/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = 'django-insecure-x8g9444lshhx2*#39s4t*#$69)y2mu9!tle*idvqa!!remzen^'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = []

# Application definition

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'photo',
    'accounts',
    'django.contrib.sites',
    'storages',

]

MIDDLEWARE = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
]

ROOT_URLCONF = 'config.urls'

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [os.path.join(BASE_DIR, "templates")],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]

WSGI_APPLICATION = 'config.wsgi.application'

# Database
# https://docs.djangoproject.com/en/3.2/ref/settings/#databases

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

# Password validation
# https://docs.djangoproject.com/en/3.2/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
    },
]

# Internationalization
# https://docs.djangoproject.com/en/3.2/topics/i18n/

LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'UTC'

USE_I18N = True

USE_L10N = True

USE_TZ = True

# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/3.2/howto/static-files/

STATIC_URL = '/static/'

# Default primary key field type
# https://docs.djangoproject.com/en/3.2/ref/settings/#default-auto-field

#DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField'

9. config/s3.media.py 파일 생성

from storages.backends.s3boto3 import S3Boto3Storage

class MediaStorage(S3Boto3Storage):
    location = 'media'
    file_overwrite = False

10 . 아마존

아마존 접속
aws 관리 콘솔(서울)
S3 -> 버킷만들기 -> 이름 ->
퍼블릿 액세스 차단(체크풀고) -> 모든 퍼블릭 체크 -> 만들기

11. 인증서 발급받기

IAM
사용자추가 -> 이름 입력 -> 프로그래밍 방식 액세스 -> 그룹 생성 ->
s3 검색 -> fullaccess -> 그룹이름 -> 태그는 아무거나 -> 만들기 -> 키값 받아놓기

12. settings.py에 aws 코드 적기

13. 데이터 베이스 생성

aws -> rds -> 파라미터그룹 ->생성 -> mysql8.0 -> 이름 적기 -> 생성
데이터베이스 -> 생성하기 -> MySQL -> 프리티어 -> 식별자이름 -> 암호 ->
자동조정 해제
새로생성 -> 보안그룹이름
추가 구성 -> 이름 -> 그룹 선택 -> 자동백업 하지말기 -> 마이너 x -> 생성
식별자 클릭 -> vpc 보안그룹 -> 인바운드 -> edit Inbound -> 사용자 지정 -> anywhere -> 저장

14. WORKBENCH 설치

Workbench -> download -> 설치
db 상세보기 -> 수정 -> 연결 -> 추가구성 -> 엑세스 가능 -> 수정 -> 즉시적용->
엔드포인트 -> 워크벤치 -> + >hostname :엔드포인트 / username:id/pass:비번

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
새로운 앱 만들기(쇼핑)

1. pip install django

2. django-admin startproject config .

3. pip install pymysql

4. settings.py

import pymysql
pymysql.install_as_MySQLdb()


DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'djangodatab',
        'USER': 'admin',
        'PASSWORD': 'dbgusals1',
        'HOST': 'django.c6f9olbkzmcs.ap-northeast-2.rds.amazonaws.com',
        'PORT': '3306'
    }
}#데이터베이스 이름 적는다, host는 엔드포인트

5. python manage.py migrate

6. python manage.py createsuperuser

7. config/settings.py

# S3를 사용할 수 있는 곳
# 1. Static

AWS_ACCESS_KEY_ID = ''
AWS_SECRET_ACCESS_KEY = ''
AWS_REGION = 'ap-northeast-2'
AWS_STORAGE_BUCKET_NAME = ''

AWS_S3_CUSTOM_DOMAIN = '%s.s3.%s.amazonaws.com' % (AWS_STORAGE_BUCKET_NAME, AWS_REGION)

AWS_S3_FILE_OVERWRITE = False
AWS_S3_OBJECT_PARAMETERS = {
    'CacheControl':'max-age=86400',
}
AWS_DEFAULT_ACL = 'public-read'
AWS_LOCATION = 'static'

STATIC_URL = 'http://%s/%s/' % (AWS_S3_CUSTOM_DOMAIN, AWS_LOCATION)
STATICFILES_STORAGE = 'storages.backends.s3boto3.S3Boto3Storage'
DEFAULT_FILE_STORAGE = 'config.s3media.MediaStorage'

8. pip install boto3

9. settings.py

'storages',

10. pip install django-storages

11. python manage.py collectstatic

12. 버킷 확인하기

13. config/settings.py

DEFAULT_FILE_STORAGE = 'config.asset_storage.MediaStorage'

14. asset_storage.py 생성

from storages.backends.s3boto3 import S3Boto3Storage


class MediaStorage(S3Boto3Storage):
    location = 'media'
    file_overwrite = False

15. 앱 생성
    python manage.py startapp shop

16. settings.py에 shop 추가

17. shop/models.py

from django.db import models

from django.urls import reverse


class Category(models.Model):
    name = models.CharField(max_length=200, db_index=True)
    meta_description = models.TextField(blank=True)  # 설명문

    slug = models.SlugField(max_length=200, db_index=True, unique=True, allow_unicode=True)  # unicode = 한글 안꺠지게

    class Meta:
        ordering = ['name']  # 정렬
        verbose_name = 'category'  # 어드민에 표시될때 필요한 내용
        verbose_name_plural = 'categories'

    def __str__(self):
        return self.name

    def get_absolute_url(self):
        return reverse('shop:product_in_category', args=[self.slug])


class Product(models.Model):
    category = models.ForeignKey(Category, on_delete=models.SET_NULL, null=True, related_name='products')
    name = models.CharField(max_length=200, db_index=True)
    slug = models.SlugField(max_length=200, db_index=True, unique=True, allow_unicode=True)  # unicode = 한글 안꺠지게

    image = models.ImageField(upload_to='products/%Y/%m/%d', blank=True)
    description = models.TextField(blank=True)
    meta_description = models.TextField(blank=True)

    price = models.PositiveIntegerField()
    sale = models.PositiveIntegerField()

    available_display = models.BooleanField('Display', default=True)
    available_order = models.BooleanField('Order', default=True)

    created = models.DateTimeField(auto_now_add=True)
    updated = models.DateTimeField(auto_now=True)

    class Meta:
        ordering = ['-created']
        index_together = [['id', 'slug']]

    def __str__(self):
        return self.name

    def get_absolute_url(self):
        return reverse('shop:product_detail', args=[self.id, self.slug])

18. pip install pillow

19. python manage.py makemigrations

20. python manage.py migrate