TIL&TEL 23.05.01~23.05.07

TIL( Today I Learned)

23-05-02 화

• WORKPLACE

  • PHASE 1 9-12 | 6

    • 프로세스 변경

    • 처리 DB 스키마 변경하기

      • 컬럼 추가, 변경

  • PHASE 2 13-16 | 6

    • 프론트 필요한 API 데이터 정리하기

  • PHASE 3 16-18 | 4

23-05-03 수

• WORKPLACE

  • PHASE 1 9-12 | 6

    • 새로운 문제
    • 이벤트 통계 정리하기
    • 프론트 필요한 API 데이터 정리하기

  • PHASE 2 13-16 | 6

    • 데이터 뽑아내기

  • PHASE 3 16-18 | 4

    • 프론트 협의하기

23-05-04 목

• WORKPLACE

  • PHASE 1 9-12 | 6

    • 데이터 검토

    • 프로세스 업데이트
    • naver api 처리하기
    • 서비스 가입

  • PHASE 2 13-16 | 6

    • ncp async client

  • PHASE 3 16-18 | 4

TEL (Trial and Error Log)

23-05-02

• ERROR: ValueError: ‘useridentityuser_name’ is both an index level and a column label, which is ambiguous.

  • SITUATION:

    • pd merge

  • REASON:

    • target df is empty

  • SOLUTION:

    • empty check

23-05-03

• ERROR: ERROR: column “addendum” cannot be cast automatically to type jsonb

  • SITUATION:

    • varchar to jsonb
    • ALTER TABLE “hacksimulationlog”.“cloudtrailfromgroome” ALTER COLUMN “addendum” SET DATA TYPE jsonb;

  • REASON:

    • type error

  • SOLUTION:

    • ALTER TABLE “hacksimulationlog”.“cloudtrailfromgroome” ALTER COLUMN “addendum” SET DATA TYPE jsonb USING addendum::jsonb;

23-05-04

• ERROR: ERROR: EXCEPT types character varying and bigint cannot be matched

  • SITUATION:

    • delete duplicated

  • REASON:

    • varchar 에 min 적용함

  • SOLUTION:

    • 타입 다시 확인

• ERROR: TypeError: Cannot serialize non-str key b’

  • SITUATION:

    • aiohttp request

  • REASON:

    • Header can contain only str not bytes

  • SOLUTION:

    • Header cannot contain an int value. You have to convert it to a string as follows: