def init_table_values(self): Question.drop_table(self.database) Question.create_table(self.database) for i in range(len(op_list)): q_obj = Question(i+1, op_list[i], self.database) q_obj.save()
def rebuild_questions_table(self): """ Rebuilding Questions Table """ questions = self.grab_json(self.DEFAULT_QUESTIONS_JSON) # Convert questions dict to Question and save in db Questions = [] for i, row in enumerate(questions): Questions.append( Question(id=row['id'], text=row['text'], deck=row['deck'])) try: db.session.add_all(Questions) db.session.commit() db.session.close() except Exception as error: print("Problem while saving all answers") print(error)
def create(self, request): """ 문의하기 """ params = QeustionForm(data=request.data) params.is_valid(raise_exception=True) user_id = int(request.META.get('HTTP_IDREGISTER') or 0) _type = params.validated_data.get('type') contents = params.validated_data.get('contents') contact = params.validated_data.get('contact') writer = params.validated_data.get('writer') email = params.validated_data.get('email') brand_name = params.validated_data.get('brand_name') device_model = params.validated_data.get('device_model') device_os = params.validated_data.get('device_os') app_version = params.validated_data.get('app_version') extra_info = dict() if device_model: extra_info['device_model'] = device_model if device_os: extra_info['device_os'] = device_os if app_version: extra_info['app_version'] = app_version extra_info_json = json.dumps(extra_info) response = dict() try: question = Question(type=_type, contents=contents, user_id=user_id, writer_name=writer, brand_name=brand_name, contact=contact, email=email, extra_info=extra_info_json).save() response['is_success'] = True response['message'] = _("문의 완료!\n빠른 답변 드리겠습니다.") # slack-bot message send if not settings.DEBUG: try: nickname = User.objects.get(id=user_id).nickname except: nickname = "" title = "요청자 : " + nickname desc = "문의내용 : " + contents slack_django = AskHook() slack_django.send_message(title=title, desc=desc, question_id=question.id, _type=_type) except: response['is_success'] = False response['message'] = _("등록에 실패하였습니다.") return Response(SuccessMessageResponse(response).data, status=status.HTTP_201_CREATED)