U hE @sddlZddlZejdejeddlmZmZddl m Z ddl m Z ddl mZeede Zedeeedd Ze d d ed Zed z.eZeed ZedW5QRXWn<ek r ZzedeedW5dZ[XYnXedzddlZedWnLek rtZz,ededdlZeedW5dZ[XYnXedzejj j!ededWnBek rZz"ededdlZeW5dZ[XYnXedzJeZ"e"#ej$%ej$j&dk'd(Z)ede*e)de"+WnBek rrZz"ededdlZeW5dZ[XYnXedzddlm,Z,eZ"e"#ej-j.e,/ej-j01de,2ej-j31d 4ej-j.5Z5e"#ej$e,6e5j7j8d1de5j7j9:e5ej$j.e5j7j.k%ej$j&dkZ#e#(Zed!e*ed"e"+WnBek rZz"ed#eddlZeW5dZ[XYnXed$dS)%N) create_enginetext) sessionmaker)Config) load_dotenv DATABASE_URLzDatabase URL: T)ZechoF)Z autocommitZ autoflushbindz" === Test 1: Simple Connection ===zSELECT 1u✅ Connection successfulu❌ Connection failed: z === Test 2: Import Models ===u ✅ Models imported successfullyu❌ Failed to import models: z === Test 3: Create Tables ===)ru✅ Tables created/verifiedu❌ Failed to create tables: z! === Test 4: Simple ORM Query ===u ✅ Found z active developersu❌ ORM query failed: z === Test 5: Test Join Query ===)funcactivity_count last_activityu!✅ Join query successful, found z resultsu❌ Join query failed: z === All tests completed ===);sysospathinsertdirname__file__Z sqlalchemyrrZsqlalchemy.ormrZconfigrZdotenvrgetenvZget_database_urlrprintZengineZ SessionLocalZconnectZconnZexecuteresult ExceptioneexitZmodels traceback print_excZBaseZmetadataZ create_allZdbZqueryZ DeveloperfilterZactivelimitallZ developerslencloser ZActivityRecordZ developer_idcountidZlabelmaxZ timestampZgroup_byZsubqueryZcoalescecr r Z outerjoinr%r%./test_orm_issue.pys       $