What exceptions should be caught in SQLAlchemy?

Question

Python

def setup_connection():
  engine = create_engine("postgresql://[email protected]:5432/testdb", echo=False)
  Session = sessionmaker(bind=engine)
  sess = Session()
  try:
    Base.metadata.create_all(engine)
  except Exception as e:
    print("Could not initialize DB: {0}".format(e))
  return sess

session = setup_connection()

What kind of exceptions does it make sense to catch in SQLAlchemy? How am I doing it right here? Is it worth catching here not the base Exception, but `SQLAlchemyError` ?

Answer 1

Never catch Exception. This leads to the appearance of hidden errors and unstable states, and also leads to heavy debugging. As a last resort, it is worth catching SQLAlchemyError. But in general, the more specific the error handler, the better.