search

Devouring-the-World-of-Backend / QnA

0 stars 1 forks source link

INFO sqlalchemy.engine.Engine BEGIN (implicit) 오류 #1

Open sounmu opened 7 months ago

sounmu commented 7 months ago

Base.metadata.create_all(bind=engine) 이 코드를 main.py로 바꾸고 나서부터 2024-04-05 14:37:32,830 INFO sqlalchemy.engine.Engine BEGIN (implicit) 2024-04-05 14:37:32,830 INFO sqlalchemy.engine.Engine COMMIT 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine BEGIN (implicit) 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine PRAGMA main.table_info("users") 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine [raw sql] () 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine PRAGMA main.table_info("libs") 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine [raw sql] () 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine PRAGMA main.table_info("categories") 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine [raw sql] () 2024-04-05 14:37:32,835 INFO sqlalchemy.engine.Engine COMMIT

이런식으로 리로딩하거나 기능을 수행하면 원래 안뜨던 로그가 뜨기 시작합니다.. 계속 검색해도 해결법을 모르겠어서 질문 드립니다

sounmu commented 7 months ago

정확히 수행할 때는 2024-04-05 14:49:31,926 INFO sqlalchemy.engine.Engine BEGIN (implicit) 2024-04-05 14:49:31,927 INFO sqlalchemy.engine.Engine SELECT libs.id AS libs_id, libs.title AS libs_title, libs.author AS libs_author, libs.user_id AS libs_user_id FROM libs 2024-04-05 14:49:31,927 INFO sqlalchemy.engine.Engine [generated in 0.00011s] () 2024-04-05 14:49:31,928 INFO sqlalchemy.engine.Engine ROLLBACK

이와 같은 로그가 발생합니다..

sounmu commented 7 months ago

해결했습니다!!

create_engine 메소드를 사용할 때, 옵션으로 echo=True가 로그를 뜨게 만들었습니다.

하지만 왜 안뜨다 뜨게 되는 원론적인 원인은 모르겠네요..