하나만 더 보고 자야지

$$config title: 드라마 기술 설명서 keywords: - IT - 기술 설명서 $$ # ? 개요 * 드라마 Q&A 게시판 구현 --- # ? 리포지터리 * [https://github.com/sunyoo1214/python_projects.git](https://github.com/sunyoo1214/python_projects.git) --- # ?‍? 사용된 기술 ## ? 버전 관리 * GIT, GITHUB --- ## ? 배포 * GITHUB, 젠킨스, 도커 --- ## ? 개발 환경 * Anaconda3 * PyCharm * SQLYog * Chrome * PIP * MariaDB * Windows 11 --- ## ? 서비스 환경 * MariaDB --- ## ?기술 스택 * Python 3 * Django 4 * Django MTV * MariaDB * HTML, CSS, JS * Jquery * Bootstrap5 --- # ?‍? 기능 현황 | 기능 | 구현 | 배포 | 테스트 | | ------------------- | --- | --- | --- | | 회원가입 | ✅ | ✅ | ✅ | | 로그인 | ✅ | ✅ | ✅ | | 로그아웃 | ✅ | ✅ | ✅ | | 질문 리스트 리스팅 | ✅ | ✅ | ✅ | | 질문 리스트 페이징 | ✅ | ✅ | ✅ | | 게시글 등록 | ✅ | ✅ | ✅ | | 게시글 수정, 삭제 | ✅ | ✅ | ✅ | | 게시글 추천 | ✅ | ✅ | ✅ | | 댓글 등록 | ✅ | ✅ | ✅ | | 댓글 수정, 삭제 | ✅ | ✅ | ✅ | | 앵커 | ✅ | ✅ | ✅ | ## ? Release 2022-02-24 v0.01 * 회원가입 * 로그인 * 로그아웃 * 게시글 리스팅 * 게시글 리스팅 페이징 * 게시글 추천 * 게시글에 댓글 작성 가능 * 댓글 삭제 가능 # ? 요구 사항 ## ? 요구 사항 분석표 | RQ-ID | 화면명 | 요구사항명 | 요구사항 내용 | 날짜 | 작성자 | 진행사항 | 버전명 | | ------------------- | --- | --- | --- | --- | --- | --- | --- | | RQ-001 | 공통 | 상단 | 네비게이션 메뉴 개발 - 홈이동, 로그인, 로그아웃 | ✅ | ✅ | ✅ | ✅ | | RQ-002 | 메인 | 콘텐츠 | 게시글 리스트 페이징처리 | ✅ | ✅ | ✅ | ✅ | | RQ-003 | 메인 | 콘텐츠 | 게시글 옵션 바 추가 - ID, TITLE 등| ✅ | ✅ | ✅ | ✅ | | RQ-004 | 메인 | 콘텐츠 | 질문 등록 버튼 추가 | ✅ | ✅ | ✅ | ✅ | | RQ-005 | 서브 | 콘텐츠 | 질문 폼 - 글 작성과 저장 | ✅ | ✅ | ✅ | ✅ | | RQ-006 | 서브 | 콘텐츠 | 작성한 글 수정, 삭제 기능 추가 | ✅ | ✅ | ✅ | ✅ | | RQ-007 | 서브 | 콘텐츠 | 답변 폼 - 글 작성, 저장 | ✅ | ✅ | ✅ | ✅ | | RQ-008 | 서브 | 콘텐츠 | 댓글 폼 - 글 작성, 저장 | ✅ | ✅ | ✅ | ✅ | | RQ-009 | 서브 | 콘텐츠 | 게시글, 댓글 - 수정, 삭제 기능 추가 | ✅ | ✅ | ✅ | ✅ | | RQ-010 | 서브 | 콘텐츠 | 게시글 추천 기능 추가 | ✅ | ✅ | ✅ | ✅ | | RQ-011 | 서브 | 콘텐츠 | 로그인 - 시도, 성공 | ✅ | ✅ | ✅ | ✅ | | RQ-012 | 서브 | 콘텐츠 | 로그아웃 - 시도, 성공 | ✅ | ✅ | ✅ | ✅ | | RQ-013 | 서브 | 콘텐츠 | 앵커 - 특정 답변, 댓글로 스크롤 이동 | ✅ | ✅ | ✅ | ✅ | ## 계정 생성 * 계정 생성이 가능하다. * 비밀번호 재검토 단계에서 불일치할 경우 경고메세지를 보여준다. ## 로그인과 로그아웃 * 로그인한 회원만 글 쓰기가 가능하다. * 로그아웃이 가능하다. ## 게시글 * 질문 * 질문 등록이 성공하면, 작성 시간과 작성자를 보여준다. * 수정과 삭제 권한은 작성자만 부여된다. --- * 답변 * 답변 등록이 성공하면, 작성 시간과 작성자를 보여준다. * 수정과 삭제 권한은 작성자만 부여된다. ## 추천 * 게시글에 대한 추천이 가능하다 * 본인이 작성한 게시글은 추천할 수 없다. ## 댓글 * 게시글에 대한 댓글 추가가 가능하다. * 본인이 작성한 댓글은 수정과 삭제가 가능하다. * 댓글 등록이 성공하면, 작성 시간과 작성자를 보여준다. # 기능 ## 회원 * 회원가입 * 로그인 * 로그아웃 ## 게시글 * 질문 리스트 리스팅 * 질문 리스트 페이징 * 질문 등록 | 수정 | 삭제 * 질문 추천 * 답변 등록 | 수정 | 삭제 * 답변 추천 ## 댓글 * 게시글에 댓글 추가 * 댓글 수정 | 삭제 ## 앵커 * 특정 게시글, 댓글 위치로 스크롤 이동 # ? ERD ![](https://i.postimg.cc/Lm4sh0CN/graphviz.png) # ? 주요 폴더 및 파일 * dramasite : 프로젝트 * config : 설정 * common : 회원앱 * drama : 게시판앱 * static : CSS, JS 담는 폴더 * templates : html 담는 파일 폴더 # ? 배포 구조 * 커밋, 푸시, 젠킨스 빌드 유발, 컨테이너 내의 소스코드 리빌드 ## 서버 구조 $$uml !theme mars frame 작업자PC { frame Windows10 { frame Chrome { } } } frame 운영서버머신 { frame CentOS7(public．drama．sunu_172．17．0．1) { circle 172．17．0．1――8000 circle 172．17．0．1――443 circle 172．17．0．1――3306 frame Docker { frame Nginx――1 { circle Nginx――1――443 } frame Mariadb――1 { circle Mariadb――1――3306 } frame drama { circle drama――8000 } frame drama――test { } } } } Chrome --> "172．17．0．1――443":1． https://drama．sunu．site 로 접속 "172．17．0．1――443" --> "Nginx――1――443" : 2． 외부 443 => Nginx 내부 443 "Nginx――1――443" --> "172．17．0．1――8000" : 3． Nginx Proxy Manager 에 의해 => 외부 8000 "172．17．0．1――8000" --> "drama――8000" : 4． 외부 8000 => drama 내부 8000 "drama――8000" -[#green]-* "172．17．0．1――3306" : 5． DB 쿼리, 내부 8000 => 외부 3306 "172．17．0．1――3306" -[#green]-* "Mariadb――1――3306" : 6． 외부 3306 => Mariadb__1 내부 3306 $$ ## 젠킨스 배포순서, 테스트 실패시 $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_drama컨테이너 entity 실서버용_drama컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_drama컨테이너 : 재배포 스크립트 실행 테스트용_drama컨테이너 -> Jenkins : 테스트가 실패했습니다... Jenkins -> Jenkins : 이번 빌드는 실패로 처리하고, 작업을 종료합니다. 개발자 -> Jenkins : 해당 빌드의 콘솔기록을 확인하여 테스트가 왜 실패했는지 분석 $$ ## 젠킨스 배포순서, 테스트 성공시 $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_drama컨테이너 entity 실서버용_drama컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_drama컨테이너 : 재배포 스크립트 실행 테스트용_drama컨테이너 -> Jenkins : All Clear Jenkins -> 실서버용_drama컨테이너 : 리빌드 후 다시 실행하세요! 개발자 -> 실서버용_drama컨테이너 : Web Brouser로 Build 되었는지 확인 $$ # ? 기술 설명 ## 네비게이션바 ![](https://i.imgur.com/RGgKNPF.jpg) ```html # base {% load static %} 하나만 더 보고 자야지 {% include "navbar.html" %} {% block content %} {% endblock %} {% block script %} {% endblock %} ``` ```html # nav ``` ## 페이징 ![](https://i.imgur.com/EwvvkB9.png) ![](https://i.imgur.com/h1chWjb.png) ```html # quesiton_list

<
<
{{ page_number }}
{{ page_number }}
>
>

``` ```python # base.views from django.core.paginator import Paginator from django.shortcuts import render, get_object_or_404 from ..models import Question def index(request): page = request.GET.get('page', '1') # 페이지 question_list = Question.objects.order_by('-create_date') paginator = Paginator(question_list, 10) page_obj = paginator.get_page(page) context = {'question_list': page_obj} return render(request, 'drama/question_list.html', context) def detail(request, question_id): question = get_object_or_404(Question, pk=question_id) context = {'question': question} return render(request, 'drama/question_detail.html', context) ``` ## 답변 개수 표시 ![](https://i.imgur.com/Z5o9wsk.png) ```html # question_list {{ question_list.paginator.count|sub:question_list.start_index|sub:forloop.counter0|add:1 }} {% if question.voter.all.count > 0 %} {{ question.voter.all.count }} {% endif %} {{ question.subject }} {% if question.answer_set.count > 0 %} {{ question.answer_set.count }} {% endif %} {{ question.author.username }} {{ question.create_date }} ``` ## 로그인, 로그아웃 ![](https://i.imgur.com/MYM1XAb.png) ![](https://i.imgur.com/rBuyAOg.png) ![](https://i.imgur.com/BBTuLg5.jpg) ![](https://i.imgur.com/DXdTZ6i.jpg) ```python # config.settings.py INSTALLED_APPS = [ 'common.apps.CommonConfig', 'pybo.apps.PyboConfig', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', ] ... # 로그인 성공후 이동하는 URL LOGIN_REDIRECT_URL = '/' # 로그아웃시 이동하는 URL LOGOUT_REDIRECT_URL = '/' ``` ```python # config.urls.py from django.contrib import admin from django.urls import path, include from drama.views import base_views urlpatterns = [ path('admin/', admin.site.urls), path('drama/', include('drama.urls')), path('common/', include('common.urls')), path('', base_views.index, name='index'), ] ``` ```python # common.urls.py from django.urls import path from django.contrib.auth import views as auth_views from . import views app_name = 'common' urlpatterns = [ path('login/', auth_views.LoginView.as_view(template_name='common/login.html'), name='login'), path('logout/', auth_views.LogoutView.as_view(), name='logout'), path('signup/', views.signup, name='signup'), ] ``` ```html # navbar ``` ```html # login {% extends "base.html" %} {% block content %}

login

or Sign Up

{% endblock %} ``` ```html # form_errors {% if form.errors %} {% for field in form %} {% for error in field.errors %}

{{ field.label }} {{ error }}

{% endfor %} {% endfor %} {% for error in form.non_field_errors %}

{{ error }}

{% endfor %} {% endif %} ``` ## 계정 생성 ![](https://i.imgur.com/ZeRQiK4.png) ![](https://i.imgur.com/I8VZUT6.png) ![](https://i.imgur.com/ODk56EB.png) ![](https://i.imgur.com/fajESIx.png) ```html # login

login

or Sign Up

``` ```python # common.urls.py from django.urls import path from django.contrib.auth import views as auth_views from . import views app_name = 'common' urlpatterns = [ path('login/', auth_views.LoginView.as_view(template_name='common/login.html'), name='login'), path('logout/', auth_views.LogoutView.as_view(), name='logout'), path('signup/', views.signup, name='signup'), ] ``` ```python # common.form.py from django import forms from django.contrib.auth.forms import UserCreationForm from django.contrib.auth.models import User class UserForm(UserCreationForm): email = forms.EmailField(label="email") class Meta: model = User fields = ("username", "password1", "password2", "email") ``` ```python # common.views.py from django.contrib.auth import authenticate, login from django.shortcuts import render, redirect from common.forms import UserForm def signup(request): if request.method == "POST": form = UserForm(request.POST) if form.is_valid(): form.save() username = form.cleaned_data.get('username') raw_password = form.cleaned_data.get('password1') user = authenticate(username=username, password=raw_password) # 사용자 인증 login(request, user) # 로그인 return redirect('index') else: form = UserForm() return render(request, 'common/signup.html', {'form': form}) ``` ```html # common.signup {% extends "base.html" %} {% block content %}

Sign up

or Login

{% endblock %} ``` ## 글쓴이 표시 ![](https://i.imgur.com/yMMIs4M.png) ![](https://i.imgur.com/CBH2JnS.png) ```html # question_list

{% if question_list %} {% for question in question_list %} {% endfor %} {% else %} {% endif %}

NO	RECOMMEND	SUBJECT	NAME	DATE
{{ question_list.paginator.count\|sub:question_list.start_index\|sub:forloop.counter0\|add:1 }}	{% if question.voter.all.count > 0 %} {{ question.voter.all.count }} {% endif %}	{{ question.subject }} {% if question.answer_set.count > 0 %} {{ question.answer_set.count }} {% endif %}	{{ question.author.username }}	{{ question.create_date }}
질문이 없습니다.

``` ```html # question_detail

{% if question.modify_date %}

modified at

{% endif %}

{% if request.user == question.author %}

수정 삭제

{% endif %} {% if question.comment_set.count > 0 %}

{% for comment in question.comment_set.all %}

{{ comment.content }} - {{ comment.author }}, {{ comment.create_date }} {% if comment.modify_date %} (수정:{{ comment.modify_date }}) {% endif %} {% if request.user == comment.author %} 수정, 삭제 {% endif %}

{% endfor %}

{% endif %}

댓글 추가 ..

``` ## 수정과 삭제 ![](https://i.imgur.com/RL9MYde.png) ![](https://i.imgur.com/uxs2l8p.png) ```html # answer_form {% extends 'base.html' %} {% block content %}

{% endblock %} ``` ```python # drama.models.py class Question(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_question') subject = models.CharField(max_length=200) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_question') def __str__(self): return self.subject class Answer(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_answer') question = models.ForeignKey(Question, on_delete=models.CASCADE) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_answer') ``` ```html # question_detail {% extends 'drama/base.html' %} {% block content %}

{% if messages %}

{% for message in messages %} {{ message.tags }}

{{ message.message }}

{% endfor %}

{% endif %}

{% if question.modify_date %}

modified at

{% endif %}

{% if request.user == question.author %}

수정 삭제

{% endif %} {% if question.comment_set.count > 0 %}

{% for comment in question.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

{{question.answer_set.count}}개의 답변이 있습니다.

{% for answer in question.answer_set.all %}

{% if answer.modify_date %}

modified at

{% endif %}

``` ```python # drama.urls.py from django.urls import path from .views import base_views, question_views, answer_views, comment_views, vote_views app_name = 'drama' urlpatterns = [ # base_views.py path('', base_views.index, name='index'), path('/', base_views.detail, name='detail'), # question_views.py path('question/create/', question_views.question_create, name='question_create'), path('question/modify//', question_views.question_modify, name='question_modify'), path('question/delete//', question_views.question_delete, name='question_delete'), # answer_views.py path('answer/create//', answer_views.answer_create, name='answer_create'), path('answer/modify//', answer_views.answer_modify, name='answer_modify'), path('answer/delete//', answer_views.answer_delete, name='answer_delete'), # comment_views.py path('comment/create/question//', comment_views.comment_create_question, name='comment_create_question'), path('comment/modify/question//', comment_views.comment_modify_question, name='comment_modify_question'), path('comment/delete/question//', comment_views.comment_delete_question, name='comment_delete_question'), path('comment/create/answer//', comment_views.comment_create_answer, name='comment_create_answer'), path('comment/modify/answer//', comment_views.comment_modify_answer, name='comment_modify_answer'), path('comment/delete/answer//', comment_views.comment_delete_answer, name='comment_delete_answer'), # vote_views.py path('vote/question//', vote_views.vote_question, name='vote_question'), path('vote/answer//', vote_views.vote_answer, name='vote_answer'), ] ``` ```python # drama.views.py from django.core.paginator import Paginator from django.shortcuts import render, get_object_or_404 from ..models import Question def index(request): page = request.GET.get('page', '1') # 페이지 question_list = Question.objects.order_by('-create_date') paginator = Paginator(question_list, 10) page_obj = paginator.get_page(page) context = {'question_list': page_obj} return render(request, 'drama/question_list.html', context) def detail(request, question_id): question = get_object_or_404(Question, pk=question_id) context = {'question': question} return render(request, 'drama/question_detail.html', context) ``` ```python # question_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import render, get_object_or_404, redirect from django.utils import timezone from ..forms import QuestionForm from ..models import Question @login_required(login_url='common:login') def question_create(request): if request.method == 'POST': form = QuestionForm(request.POST) if form.is_valid(): question = form.save(commit=False) question.author = request.user question.create_date = timezone.now() question.save() return redirect('drama:index') else: form = QuestionForm() context = {'form': form} return render(request, 'drama/question_form.html', context) @login_required(login_url='common:login') def question_modify(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.user != question.author: messages.error(request, '수정권한이 없습니다') return redirect('drama:detail', question_id=question.id) if request.method == "POST": form = QuestionForm(request.POST, instance=question) if form.is_valid(): question = form.save(commit=False) question.author = request.user question.modify_date = timezone.now() # 수정일시 저장 question.save() return redirect('drama:detail', question_id=question.id) else: form = QuestionForm(instance=question) context = {'form': form} return render(request, 'drama/question_form.html', context) @login_required(login_url='common:login') def question_delete(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.user != question.author: messages.error(request, '삭제 권한이 없습니다') return redirect('drama:detail', question_id=question.id) question.delete() return redirect('drama:index') ``` ```python # answer_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import render, get_object_or_404, redirect, resolve_url from django.utils import timezone from ..forms import AnswerForm from ..models import Question, Answer @login_required(login_url='common:login') def answer_create(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.method == "POST": form = AnswerForm(request.POST) if form.is_valid(): answer = form.save(commit=False) answer.author = request.user answer.create_date = timezone.now() answer.question = question answer.save() return redirect('{}#answer_{}'.format( resolve_url('drama:detail', question_id=question.id), answer.id)) else: form = AnswerForm() context = {'question': question, 'form': form} return render(request, 'drama/question_detail.html', context) @login_required(login_url='common:login') def answer_modify(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.user != answer.author: messages.error(request, '수정권한이 없습니다') return redirect('drama:detail', question_id=answer.question.id) if request.method == "POST": form = AnswerForm(request.POST, instance=answer) if form.is_valid(): answer = form.save(commit=False) answer.modify_date = timezone.now() answer.save() return redirect('{}#answer_{}'.format( resolve_url('drama:detail', question_id=answer.question.id), answer.id)) else: form = AnswerForm(instance=answer) context = {'answer': answer, 'form': form} return render(request, 'drama/answer_form.html', context) @login_required(login_url='common:login') def answer_delete(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.user != answer.author: messages.error(request, '삭제권한이 없습니다') else: answer.delete() return redirect('drama:detail', question_id=answer.question.id) ``` ## 댓글 ![](https://i.imgur.com/jy2viyw.png) ![](https://i.imgur.com/KsY5Lp3.png) ```python # drama.forms.py from django import forms from .models import Question, Answer, Comment class QuestionForm(forms.ModelForm): class Meta: model = Question fields = ['subject', 'content'] labels = { 'subject': '제목', 'content': '내용', } class AnswerForm(forms.ModelForm): class Meta: model = Answer fields = ['content'] labels = { 'content': '답변내용', } class CommentForm(forms.ModelForm): class Meta: model = Comment fields = ['content'] labels = { 'content': '댓글내용', } ``` ```python # drama.urls.py from django.urls import path from .views import base_views, question_views, answer_views, comment_views, vote_views app_name = 'drama' urlpatterns = [ # base_views.py path('', base_views.index, name='index'), path('/', base_views.detail, name='detail'), # question_views.py path('question/create/', question_views.question_create, name='question_create'), path('question/modify//', question_views.question_modify, name='question_modify'), path('question/delete//', question_views.question_delete, name='question_delete'), # answer_views.py path('answer/create//', answer_views.answer_create, name='answer_create'), path('answer/modify//', answer_views.answer_modify, name='answer_modify'), path('answer/delete//', answer_views.answer_delete, name='answer_delete'), # comment_views.py path('comment/create/question//', comment_views.comment_create_question, name='comment_create_question'), path('comment/modify/question//', comment_views.comment_modify_question, name='comment_modify_question'), path('comment/delete/question//', comment_views.comment_delete_question, name='comment_delete_question'), path('comment/create/answer//', comment_views.comment_create_answer, name='comment_create_answer'), path('comment/modify/answer//', comment_views.comment_modify_answer, name='comment_modify_answer'), path('comment/delete/answer//', comment_views.comment_delete_answer, name='comment_delete_answer'), # vote_views.py path('vote/question//', vote_views.vote_question, name='vote_question'), path('vote/answer//', vote_views.vote_answer, name='vote_answer'), ] ``` ```python # drama.model.py from django.contrib.auth.models import User from django.db import models class Question(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_question') subject = models.CharField(max_length=200) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_question') def __str__(self): return self.subject class Answer(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_answer') question = models.ForeignKey(Question, on_delete=models.CASCADE) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_answer') class Comment(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) question = models.ForeignKey(Question, null=True, blank=True, on_delete=models.CASCADE) answer = models.ForeignKey(Answer, null=True, blank=True, on_delete=models.CASCADE) ``` ```python # comment_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import render, get_object_or_404, redirect from django.utils import timezone from ..forms import CommentForm from ..models import Question, Answer, Comment @login_required(login_url='common:login') def comment_create_question(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.method == "POST": form = CommentForm(request.POST) if form.is_valid(): comment = form.save(commit=False) comment.author = request.user comment.create_date = timezone.now() comment.question = question comment.save() return redirect('drama:detail', question_id=question.id) else: form = CommentForm() context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_modify_question(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글수정권한이 없습니다') return redirect('drama:detail', question_id=comment.question.id) if request.method == "POST": form = CommentForm(request.POST, instance=comment) if form.is_valid(): comment = form.save(commit=False) comment.modify_date = timezone.now() comment.save() return redirect('drama:detail', question_id=comment.question.id) else: form = CommentForm(instance=comment) context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_delete_question(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글삭제권한이 없습니다') return redirect('drama:detail', question_id=comment.question.id) else: comment.delete() return redirect('drama:detail', question_id=comment.question.id) @login_required(login_url='common:login') def comment_create_answer(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.method == "POST": form = CommentForm(request.POST) if form.is_valid(): comment = form.save(commit=False) comment.author = request.user comment.create_date = timezone.now() comment.answer = answer comment.save() return redirect('drama:detail', question_id=comment.answer.question.id) else: form = CommentForm() context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_modify_answer(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글수정권한이 없습니다') return redirect('drama:detail', question_id=comment.answer.question.id) if request.method == "POST": form = CommentForm(request.POST, instance=comment) if form.is_valid(): comment = form.save(commit=False) comment.modify_date = timezone.now() comment.save() return redirect('drama:detail', question_id=comment.answer.question.id) else: form = CommentForm(instance=comment) context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_delete_answer(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글삭제권한이 없습니다') return redirect('drama:detail', question_id=comment.answer.question.id) else: comment.delete() return redirect('drama:detail', question_id=comment.answer.question.id) ``` ```html # question_detail

{% if question.modify_date %}

modified at

{% endif %}

{% if request.user == question.author %}

수정 삭제

{% endif %} {% if question.comment_set.count > 0 %}

{% for comment in question.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

{{question.answer_set.count}}개의 답변이 있습니다.

{% for answer in question.answer_set.all %}

{% if answer.modify_date %}

modified at

{% endif %}

{% if request.user == answer.author %}

수정 삭제

{% endif %} {% if answer.comment_set.count > 0 %}

{% for comment in answer.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

``` ```html # comment_form {% extends 'base.html' %} {% block content %}

댓글등록하기

{% endblock %} ``` ## 추천 ![](https://i.imgur.com/zcrbY5R.png) ![](https://i.imgur.com/syHn7oj.png) ![](https://i.imgur.com/GcDYk0n.png) ![](https://i.imgur.com/dPh5jYt.png) ![](https://i.imgur.com/hssF95v.png) ![](https://i.imgur.com/zcCvAHp.png) ![](https://i.imgur.com/ioSKOFX.png) ```python # drama.models.py from django.contrib.auth.models import User from django.db import models class Question(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_question') subject = models.CharField(max_length=200) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_question') def __str__(self): return self.subject class Answer(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE, related_name='author_answer') question = models.ForeignKey(Question, on_delete=models.CASCADE) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) voter = models.ManyToManyField(User, related_name='voter_answer') class Comment(models.Model): author = models.ForeignKey(User, on_delete=models.CASCADE) content = models.TextField() create_date = models.DateTimeField() modify_date = models.DateTimeField(null=True, blank=True) question = models.ForeignKey(Question, null=True, blank=True, on_delete=models.CASCADE) answer = models.ForeignKey(Answer, null=True, blank=True, on_delete=models.CASCADE) ``` ```python # drama.urls.py from django.urls import path from .views import base_views, question_views, answer_views, comment_views, vote_views app_name = 'drama' urlpatterns = [ # base_views.py path('', base_views.index, name='index'), path('/', base_views.detail, name='detail'), # question_views.py path('question/create/', question_views.question_create, name='question_create'), path('question/modify//', question_views.question_modify, name='question_modify'), path('question/delete//', question_views.question_delete, name='question_delete'), # answer_views.py path('answer/create//', answer_views.answer_create, name='answer_create'), path('answer/modify//', answer_views.answer_modify, name='answer_modify'), path('answer/delete//', answer_views.answer_delete, name='answer_delete'), # comment_views.py path('comment/create/question//', comment_views.comment_create_question, name='comment_create_question'), path('comment/modify/question//', comment_views.comment_modify_question, name='comment_modify_question'), path('comment/delete/question//', comment_views.comment_delete_question, name='comment_delete_question'), path('comment/create/answer//', comment_views.comment_create_answer, name='comment_create_answer'), path('comment/modify/answer//', comment_views.comment_modify_answer, name='comment_modify_answer'), path('comment/delete/answer//', comment_views.comment_delete_answer, name='comment_delete_answer'), # vote_views.py path('vote/question//', vote_views.vote_question, name='vote_question'), path('vote/answer//', vote_views.vote_answer, name='vote_answer'), ] ``` ```python # vote_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import get_object_or_404, redirect from ..models import Question, Answer @login_required(login_url='common:login') def vote_question(request, question_id): """ drama 질문추천등록 """ question = get_object_or_404(Question, pk=question_id) if request.user == question.author: messages.error(request, '본인이 작성한 글은 추천할수 없습니다') else: question.voter.add(request.user) return redirect('drama:detail', question_id=question.id) @login_required(login_url='common:login') def vote_answer(request, answer_id): """ drama 답글추천등록 """ answer = get_object_or_404(Answer, pk=answer_id) if request.user == answer.author: messages.error(request, '본인이 작성한 글은 추천할수 없습니다') else: answer.voter.add(request.user) return redirect('drama:detail', question_id=answer.question.id) ``` ```html # question_list

{% if question_list %} {% for question in question_list %} {% endfor %} {% else %} {% endif %}

NO	RECOMMEND	SUBJECT	NAME	DATE
{{ question_list.paginator.count\|sub:question_list.start_index\|sub:forloop.counter0\|add:1 }}	{% if question.voter.all.count > 0 %} {{ question.voter.all.count }} {% endif %}	{{ question.subject }} {% if question.answer_set.count > 0 %} {{ question.answer_set.count }} {% endif %}	{{ question.author.username }}	{{ question.create_date }}
질문이 없습니다.

``` ```html # question.detail

{% if question.modify_date %}

modified at

{% endif %}

{% if request.user == question.author %}

수정 삭제

{% endif %} {% if question.comment_set.count > 0 %}

{% for comment in question.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

{{question.answer_set.count}}개의 답변이 있습니다.

{% for answer in question.answer_set.all %}

{% if answer.modify_date %}

modified at

{% endif %}

{% if request.user == answer.author %}

수정 삭제

{% endif %} {% if answer.comment_set.count > 0 %}

{% for comment in answer.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

{% endfor %}

{% endblock %} {% block script %} {% endblock %} ``` ## 앵커 ![](https://i.imgur.com/ZCTU8aW.png) ![](https://i.imgur.com/lhYbeJV.png) ```html # question_detail

{% if answer.modify_date %}

modified at

{% endif %}

{% if request.user == answer.author %}

수정 삭제

{% endif %} {% if answer.comment_set.count > 0 %}

{% for comment in answer.comment_set.all %}

{% endfor %}

{% endif %}

댓글 추가 ..

``` ```python # answer_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import render, get_object_or_404, redirect, resolve_url from django.utils import timezone from ..forms import AnswerForm from ..models import Question, Answer @login_required(login_url='common:login') def answer_create(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.method == "POST": form = AnswerForm(request.POST) if form.is_valid(): answer = form.save(commit=False) answer.author = request.user answer.create_date = timezone.now() answer.question = question answer.save() return redirect('{}#answer_{}'.format( resolve_url('drama:detail', question_id=question.id), answer.id)) else: form = AnswerForm() context = {'question': question, 'form': form} return render(request, 'drama/question_detail.html', context) @login_required(login_url='common:login') def answer_modify(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.user != answer.author: messages.error(request, '수정권한이 없습니다') return redirect('drama:detail', question_id=answer.question.id) if request.method == "POST": form = AnswerForm(request.POST, instance=answer) if form.is_valid(): answer = form.save(commit=False) answer.modify_date = timezone.now() answer.save() return redirect('{}#answer_{}'.format( resolve_url('drama:detail', question_id=answer.question.id), answer.id)) else: form = AnswerForm(instance=answer) context = {'answer': answer, 'form': form} return render(request, 'drama/answer_form.html', context) @login_required(login_url='common:login') def answer_delete(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.user != answer.author: messages.error(request, '삭제권한이 없습니다') else: answer.delete() return redirect('drama:detail', question_id=answer.question.id) ``` ``` python #comment_views.py from django.contrib import messages from django.contrib.auth.decorators import login_required from django.shortcuts import render, get_object_or_404, redirect, resolve_url from django.utils import timezone from ..forms import CommentForm from ..models import Question, Answer, Comment @login_required(login_url='common:login') def comment_create_question(request, question_id): question = get_object_or_404(Question, pk=question_id) if request.method == "POST": form = CommentForm(request.POST) if form.is_valid(): comment = form.save(commit=False) comment.author = request.user comment.create_date = timezone.now() comment.question = question comment.save() return redirect('{}#comment_{}'.format( resolve_url('drama:detail', question_id=comment.question.id), comment.id)) else: form = CommentForm() context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_modify_question(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글수정권한이 없습니다') return redirect('drama:detail', question_id=comment.question.id) if request.method == "POST": form = CommentForm(request.POST, instance=comment) if form.is_valid(): comment = form.save(commit=False) comment.modify_date = timezone.now() comment.save() return redirect('{}#comment_{}'.format( resolve_url('drama:detail', question_id=comment.question.id), comment.id)) else: form = CommentForm(instance=comment) context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_delete_question(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글삭제권한이 없습니다') return redirect('drama:detail', question_id=comment.question.id) else: comment.delete() return redirect('drama:detail', question_id=comment.question.id) @login_required(login_url='common:login') def comment_create_answer(request, answer_id): answer = get_object_or_404(Answer, pk=answer_id) if request.method == "POST": form = CommentForm(request.POST) if form.is_valid(): comment = form.save(commit=False) comment.author = request.user comment.create_date = timezone.now() comment.answer = answer comment.save() return redirect('{}#comment_{}'.format( resolve_url('drama:detail', question_id=comment.answer.question.id), comment.id)) else: form = CommentForm() context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_modify_answer(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글수정권한이 없습니다') return redirect('drama:detail', question_id=comment.answer.question.id) if request.method == "POST": form = CommentForm(request.POST, instance=comment) if form.is_valid(): comment = form.save(commit=False) comment.modify_date = timezone.now() comment.save() return redirect('{}#comment_{}'.format( resolve_url('drama:detail', question_id=comment.answer.question.id), comment.id)) else: form = CommentForm(instance=comment) context = {'form': form} return render(request, 'drama/comment_form.html', context) @login_required(login_url='common:login') def comment_delete_answer(request, comment_id): comment = get_object_or_404(Comment, pk=comment_id) if request.user != comment.author: messages.error(request, '댓글삭제권한이 없습니다') return redirect('drama:detail', question_id=comment.answer.question.id) else: comment.delete() return redirect('drama:detail', question_id=comment.answer.question.id) ``` # 이상 포트폴리오 기술 설명을 마치겠습니다. 긴 글 읽어 주셔서 감사합니다.

??? 드라마 기술 설명서