!Oj 2SrSSKJr SSKJrJr SSKJr SSKJ r S\ "\R5S\ "\R5S\RS\RS \R3 r\"\S S S S SS S9r\"\SSSS9r\"5rSrSrSrS\4Sjrg)a database.py PostgreSQL database configuration for LeafDoctor AI. Responsibilities ---------------- - Create SQLAlchemy engine - Configure connection pooling - Provide SessionLocal - Provide Base declarative class - Initialize database tables No business logic should exist here. ) create_engine)declarative_base sessionmaker)settings) quote_pluszpostgresql+psycopg2://:@/ TiF) pool_size max_overflow pool_pre_ping pool_recycleechofuture)bind autoflush autocommitexpire_on_commitc#t# [5nUv UR5 g!UR5 f=f7f)z? FastAPI dependency. Usage: db: Session = Depends(get_db) N) SessionLocalclose)dbs (/var/www/html/leaf-doctor-v1/database.pyget_dbr7s* B   s 8#858cNSSKn[RR[S9 g)z) Create all tables defined in models.py. rNr)modelsBasemetadata create_allenginers r create_tablesr%EsMM&)cNSSKn[RR[S9 g)z2 Drop all tables. Useful only during development. rNr)rr r!drop_allr#r$s r drop_tablesr)Ns MM'r&returncSSKJn [R5nUR U"S55 SSS5 g!,(df  g=f![ an[ SU35 SnAgSnAff=f)z_ Test PostgreSQL connectivity. Returns ------- bool True if database connection succeeds. r)textzSELECT 1NTzDatabase connection failed: F) sqlalchemyr,r#connectexecute Exceptionprint)r, connectionexcs rtest_connectionr4Xsa  ^^    tJ/ 0   ,SE23s1A=A A A A A0A++A0N)__doc__r-rsqlalchemy.ormrrconfigr urllib.parserDB_USER DB_PASSWORDDB_HOSTDB_PORTDB_NAME DATABASE_URLr#rr rr%r)boolr4r&rrAs %9#(""#$A(&&'(          *(r&