o ü˜h§ã@sfUddlmZddlZddlmZmZdaeed<defdd„Zdd „Z d d „Z d e d e fdd„Z dS)é)Ú load_dotenvN)Ú create_clientÚClientÚ _supabaseÚreturncCs^tdur-tƒt d¡}t d¡}|r|stdƒ‚td|ƒtd|dd…dƒt||ƒatS)NÚ SUPABASE_URLÚ SUPABASE_KEYuR⌠SUPABASE_URL ë˜ëŠ” SUPABASE_KEY 환경변수가 설정ë˜ì§€ 않았습니다.z[DEBUG] SUPABASE_URL =z[DEBUG] SUPABASE_KEY =é z...)rrÚosÚgetenvÚ ValueErrorÚprintr)rr©rú./var/www/html/bot/services/supabase_service.pyÚ get_supabase s    rcCstƒ |¡ ||dœ¡ ¡S)N)Úchat_idÚ first_name)rÚtableÚupsertÚexecute)rrrrrrÚupsert_subscriptions þýrcCstƒ |¡ ¡ d|¡ ¡S)Nr)rrÚdeleteÚeqr)rrrrrÚdelete_subscription#srrÚkeywordc Cs¦z7td|ƒtƒ}| |¡ d¡ dd|›d¡ ¡}|jr"|jWS| |¡ d¡ dd|›d¡ ¡}|jWStyR}ztd|›ƒgWYd}~Sd}~ww)Nu[DEBUG] 검색 시작:Ú*Únameú%Ú departmentu[âŒ] Supabase 검색 오류: )r rrÚselectÚilikerÚdataÚ Exception)rrÚsbÚresultÚerrrÚ search_name's* ýý€þr&) Údotenvrr ÚsupabaserrrÚ__annotations__rrrÚstrr&rrrrÚs