0_i.ddlZddlmZdZdZdZdZy)N)datetimez auction.dbc4tjtS)N)sqlite3connectDB_PATH%/var/www/html/land_sniper/db_utils.pyget_connectionr s ??7 ##r ct}|j} |jd|d|dtjf|jd|d|ddtjf|j  |j y#t$r(}td|Yd}~|j y d}~wwxYw#|j wxYw) uJ 관심 물건 저장 (items 테이블 + saved_targets 테이블) zp INSERT OR IGNORE INTO items (auction_id, link, first_seen_at) VALUES (?, ?, ?) auction_idlinkzv INSERT INTO saved_targets (auction_id, link, status, created_at) VALUES (?, ?, ?, ?) u 관심등록TuDB 저장 에러: NF) r cursorexecuternowcommitclose Exceptionprint) item_dataconnres r save_targetr s  D [[]F  %y'8(,,. I K   %y'8.(,,. Y [   "1#&'  s*A+B C "C0C C  C Cct}|j}|jd|j}|j |S)u1 저장된 물건 리스트 가져오기 zSSELECT id, auction_id, link, status, created_at FROM saved_targets ORDER BY id DESC)r rrfetchallr)rrrowss r get_saved_listr%s>  D [[]F NNhi ?? DJJL Kr )rrrr rrrr r rs $8 r