python postgresql 연동

psycopg2 를 이용하여 Python Database 연동Database 정보 config.ini 설정config.ini123456[DB]host=172.23.174.55database=mydatabaseuser=mydbpassword=1234port=5432DB Load & Connectmain.py123456789101112import psycopg2import configimport sys# Load DB => config.{.ini파일}(section={해당 DB 설정변수})db=config.config(section='DB')conn = Nonetry: conn = psycopg2.connect(**db) curs = conn.cursor() curs.execute(query['select'],(user_id, phone_num))Python Database APIfatchonefatchallfatchmany(row개수)파일 데이터 처리읽기(r), 쓰기(...

Submit