[Feature] 전체 검색 API 추가

[dchecheb]

식당, 숙박, 기도실 통합 검색

[dchecheb]

• 전체 검색용 uuid column 추가 or 기본 키를 String UUID로 변경
  • https://arctype.com/blog/postgres-uuid/#a-universally-unique-id-intro-to-uuids
  • uuid더라도 10억분의 1확률로 중복이 발생할 수 있다고 함. 중복 발생 시에 대한 처리도 해두기. -> 중복 있으면 일단 500으로 응답하고 uuid 새로 생성해서 넣기
  • JPA의 Entity로 Long 을 쓰는 이유
• DTO에 호텔, 레스토랑, 기도실 중 구분용 필드 추가

[dchecheb]

primary key를 UUID 타입으로 변경 하기

String uuid 컬럼 생성 방법

kosalaam=> create extension if not exists "uuid-ossp";
kosalaam=> alter table accommodation add uuid uuid default uuid_generate_v4 ();
ALTER TABLE
kosalaam=> alter table accommodation alter column uuid set not null;
ALTER TABLE
kosalaam=> create unique index accommodation_uuid_uindex
        on accommodation (uuid);

Primary key 변경 방법

• https://gist.github.com/scaryguy/6269293

[dchecheb]

-- Firstly, remove PRIMARY KEY attribute of former PRIMARY KEY
ALTER TABLE accommodation DROP CONSTRAINT pk_accommodation CASCADE;

ALTER TABLE accommodation DROP COLUMN id;

-- Then change column name of  your PRIMARY KEY and PRIMARY KEY candidates properly.
ALTER TABLE accommodation RENAME COLUMN uuid TO id;

-- Lastly set your new PRIMARY KEY
ALTER TABLE accommodation ADD PRIMARY KEY (id);

-- Review & Like
DELETE FROM accommodation_like;
DELETE FROM accommodation_review;

ALTER TABLE accommodation_like DROP COLUMN accommodation_id;
ALTER TABLE accommodation_review DROP COLUMN accommodation_id;

ALTER TABLE accommodation_like ADD COLUMN accommodation_id uuid;
ALTER TABLE accommodation_review ADD COLUMN accommodation_id uuid;

ALTER TABLE accommodation_like
    ADD CONSTRAINT fk_accommodation_like_id_accommodation_id
    FOREIGN KEY (accommodation_id)
    REFERENCES accommodation(id)
    ON DELETE CASCADE;

ALTER TABLE accommodation_review
    ADD CONSTRAINT fk_accommodation_review_id_accommodation_id
        FOREIGN KEY (accommodation_id)
            REFERENCES accommodation(id)
            ON DELETE CASCADE;

[dchecheb]

기본키를 uuid로 사용했을 때 단점

https://www.it-gundan.com/ko/postgresql/uuid-%EB%98%90%EB%8A%94-guid%EC%9D%84-%EA%B8%B0%EB%B3%B8-%ED%82%A4%EB%A1%9C-%EC%82%AC%EC%9A%A9%ED%95%98%EB%8A%94-%EA%B2%BD%EC%9A%B0%EC%9D%98-%EB%8B%A8%EC%A0%90%EC%9D%80-%EB%AC%B4%EC%97%87%EC%9E%85%EB%8B%88%EA%B9%8C/l957283162/