U ؠh @s>ddlmZmZddlZddlmZddlmZmZeedZ e seddZ edd Z ed d Z ed d Z eddZde dede de de Z ee Zede4ZedeedZeZededdD]&\ZZZededededqedeedZeZededed ed!ed"ed#ed$ed%ed&ed'ed(ed)ed)dkr4ed*eZz0eed+ZejZe ed,ed-Wn>e!k r2Z"ze#ed.e$e"W5dZ"["XYnXed/z\eed0Zd1d2eDZ%ed3d4&e%d5e%kreed6e ed7Wn6e!k rZ"zed8e$e"W5dZ"["XYnXed9d:Z'd;Z(de'iZeZ*e*ddkred?e*dd@e'dAedBe*d!dCe*d#eedDe'e(e)dEZedZedkred?edFe(dCe)nedGe(dCe)nedHe'dAWn6e!k rZ"zedIe$e"W5dZ"["XYnXW5QRXedJedKedLedMedNedOedPedQdS)R) create_enginetextN) load_dotenv)datetimedate DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/z/=== Fixing Common Causes of API 500 Errors === z*1. Checking for case sensitivity issues...a4 SELECT CAST(developer_id AS VARCHAR) as original_id, LOWER(CAST(developer_id AS VARCHAR)) as lower_id, COUNT(*) as record_count FROM activity_records WHERE developer_id IS NOT NULL GROUP BY developer_id ORDER BY COUNT(*) DESC z Developer IDs in database: z - 'z' (lowercase: 'z') - z recordsz3 2. Checking for NULL values in critical columns...a SELECT COUNT(*) as total, COUNT(CASE WHEN developer_id IS NULL THEN 1 END) as null_dev_id, COUNT(CASE WHEN timestamp IS NULL THEN 1 END) as null_timestamp, COUNT(CASE WHEN duration IS NULL THEN 1 END) as null_duration, COUNT(CASE WHEN application_name IS NULL THEN 1 END) as null_app_name, COUNT(CASE WHEN category IS NULL THEN 1 END) as null_category FROM activity_records z Total records: z NULL developer_id: z NULL timestamp: z NULL duration: z NULL application_name: z NULL category: z 3. Fixing missing categories...z UPDATE activity_records SET category = 'other' WHERE category IS NULL u ✓ Updated z records with default categoryu" ❌ Error updating categories: z. 4. Creating indexes for better performance...zu SELECT indexname FROM pg_indexes WHERE tablename = 'activity_records' cCsg|] }|dqS)r).0rowrr./fix_activity_api_500.py ^srz Existing indexes: z, Zidx_developer_id_lowerz CREATE INDEX idx_developer_id_lower ON activity_records (LOWER(CAST(developer_id AS VARCHAR))) u+ ✓ Created lowercase developer_id indexu ⚠️ Index creation: z( 5. Testing activity query with fixes...Zriddhidhakharaz 2025-09-30z 2025-10-08a  SELECT COUNT(*) as count, MIN(DATE(timestamp)) as min_date, MAX(DATE(timestamp)) as max_date FROM activity_records WHERE LOWER(CAST(developer_id AS VARCHAR)) = LOWER(:dev_id) dev_idu ✓ Found z records for ''z Date range: z to z SELECT COUNT(*) as count FROM activity_records WHERE LOWER(CAST(developer_id AS VARCHAR)) = LOWER(:dev_id) AND DATE(timestamp) BETWEEN :start_date AND :end_date )r start_dateend_datez records in date range u# ⚠️ No records in date range u ❌ No records found for 'u ❌ Query error: z 6. RECOMMENDATIONS:z5 1. Update your API to use case-insensitive queriesz4 2. Add proper error handling in the API endpointsz) 3. Set default values for NULL columnsz- 4. Add appropriate indexes for performancez7 5. Check the API logs for the specific error messagez 7. Quick Fix for your API:z In your API endpoint, change: WHERE developer_id = :dev_id To: WHERE LOWER(CAST(developer_id AS VARCHAR)) = LOWER(:dev_id) )+Z sqlalchemyrrosZdotenvrrrgetenvrrr r r r ZengineprintZconnectZconnZexecuteresultZfetchallZ developersZoriglowercountZfetchoneZstatsZbeginZtransZrowcountupdatedZcommit ExceptioneZrollbackstrZexisting_indexesjoinZ test_dev_idrrrrrrrs       "   $  $     .