텍스트 비교

두 텍스트 파일의 차이점을 찾아보세요

실시간 편집

변경 없는 행 숨기기

줄바꿈 비활성화

레이아웃

비교 단위

구문 강조

Diffchecker Desktop 가장 안전하게 Diffchecker를 사용하는 방법. 데스크톱 앱을 사용하면 비교 데이터가 외부로 전송되지 않습니다!데스크톱 앱 받기

Django 2.2.23 vs 3.2.3

생성일 5년 전비교 결과 만료 없음

4 삭제

행
총
삭제

글자
총
삭제

이 기능을 계속 사용하려면 업그레이드해 주세요 Diffchecker Pro 요금제 보기

33 행

0 추가

행
총
추가

글자
총
추가

이 기능을 계속 사용하려면 업그레이드해 주세요 Diffchecker Pro 요금제 보기

33 행

SELECT "vle_journal"."id",

"vle_journal"."creation_date",

"vle_journal"."update_date",

"vle_journal"."assignment_id",

"vle_journal"."bonus_points",

"vle_journal"."author_limit",

"vle_journal"."stored_name",

"vle_journal"."stored_image",

"vle_journal"."locked",

"vle_journal"."lms_grade",

"vle_participation"."user_id" AS "p_user",

"vle_role"."can_have_journal" AS "can_have_journal"

FROM "vle_journal"

INNER JOIN "vle_assignment"

ON ( "vle_journal"."assignment_id" = "vle_assignment"."id" )

LEFT OUTER JOIN "vle_assignment_courses"

ON ( "vle_assignment"."id" =

"vle_assignment_courses"."assignment_id" )

LEFT OUTER JOIN "vle_course"

ON ( "vle_assignment_courses"."course_id" =

"vle_course"."id" )

LEFT OUTER JOIN "vle_participation"

ON ( "vle_course"."id" = "vle_participation"."course_id" )

LEFT OUTER JOIN "vle_role"

ON ( "vle_participation"."role_id" = "vle_role"."id" )

LEFT OUTER JOIN "vle_assignmentparticipation"

ON ( "vle_journal"."id" =

"vle_assignmentparticipation"."journal_id" )

WHERE ( "vle_assignment"."is_group_assignment" = true

WHERE ( "vle_assignment"."is_group_assignment"

OR ( "vle_role"."can_have_journal" = true

OR ( "vle_role"."can_have_journal"

AND "vle_participation"."user_id" IN

( "vle_assignmentparticipation"."user_id" ) ) )

"vle_assignmentparticipation"."user_id" ) )

LIMIT 1

저장된 비교 결과

원본

파일 열기

SELECT "vle_journal"."id",
       "vle_journal"."creation_date",
       "vle_journal"."update_date",
       "vle_journal"."assignment_id",
       "vle_journal"."bonus_points",
       "vle_journal"."author_limit",
       "vle_journal"."stored_name",
       "vle_journal"."stored_image",
       "vle_journal"."locked",
       "vle_journal"."lms_grade",
       "vle_participation"."user_id" AS "p_user",
       "vle_role"."can_have_journal" AS "can_have_journal"
FROM   "vle_journal"
       INNER JOIN "vle_assignment"
               ON ( "vle_journal"."assignment_id" = "vle_assignment"."id" )
       LEFT OUTER JOIN "vle_assignment_courses"
                    ON ( "vle_assignment"."id" =
                         "vle_assignment_courses"."assignment_id" )
       LEFT OUTER JOIN "vle_course"
                    ON ( "vle_assignment_courses"."course_id" =
                         "vle_course"."id" )
       LEFT OUTER JOIN "vle_participation"
                    ON ( "vle_course"."id" = "vle_participation"."course_id" )
       LEFT OUTER JOIN "vle_role"
                    ON ( "vle_participation"."role_id" = "vle_role"."id" )
       LEFT OUTER JOIN "vle_assignmentparticipation"
                    ON ( "vle_journal"."id" =
                         "vle_assignmentparticipation"."journal_id" )
WHERE  ( "vle_assignment"."is_group_assignment" = true
          OR ( "vle_role"."can_have_journal" = true
               AND "vle_participation"."user_id" IN
                   ( "vle_assignmentparticipation"."user_id" ) ) )
LIMIT  1

수정본

파일 열기

SELECT "vle_journal"."id",
       "vle_journal"."creation_date",
       "vle_journal"."update_date",
       "vle_journal"."assignment_id",
       "vle_journal"."bonus_points",
       "vle_journal"."author_limit",
       "vle_journal"."stored_name",
       "vle_journal"."stored_image",
       "vle_journal"."locked",
       "vle_journal"."lms_grade",
       "vle_participation"."user_id" AS "p_user",
       "vle_role"."can_have_journal" AS "can_have_journal"
FROM   "vle_journal"
       INNER JOIN "vle_assignment"
               ON ( "vle_journal"."assignment_id" = "vle_assignment"."id" )
       LEFT OUTER JOIN "vle_assignment_courses"
                    ON ( "vle_assignment"."id" =
                         "vle_assignment_courses"."assignment_id" )
       LEFT OUTER JOIN "vle_course"
                    ON ( "vle_assignment_courses"."course_id" =
                         "vle_course"."id" )
       LEFT OUTER JOIN "vle_participation"
                    ON ( "vle_course"."id" = "vle_participation"."course_id" )
       LEFT OUTER JOIN "vle_role"
                    ON ( "vle_participation"."role_id" = "vle_role"."id" )
       LEFT OUTER JOIN "vle_assignmentparticipation"
                    ON ( "vle_journal"."id" =
                         "vle_assignmentparticipation"."journal_id" )
WHERE  ( "vle_assignment"."is_group_assignment"
          OR ( "vle_role"."can_have_journal"
               AND "vle_participation"."user_id" IN
                   "vle_assignmentparticipation"."user_id" ) )
LIMIT  1