U 7h @sddlmZmZddlZddlmZddlZddlmZee de Z ee Z e de Ze deedZeZereD]pZe d ede d ed e d ed e deddzeedereednedZe de dejeddddddekrPe deddekrle deddekreederdedkre dedddedkre deddWqek rZze deW5dZ[XYqXqne de d eed!ZeZe d"ede d#ed e d$ede d%ed&W5QRXe d'eed(ZeZ eD]N\Z!z8ee!eree!ne!Zeeere "e#Wn YnXqe re d)e ne d*dS)+) create_enginetextN)Config) load_dotenv DATABASE_URLz)=== Checking Activity Data JSON Field ===z! 1. Sample activity_data content:z SELECT id, developer_id, activity_data, duration, timestamp FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' LIMIT 5 z Record ID: z Developer: z Timestamp: z Duration: z secondsz Activity Data:z )indentiz...Zappu ✓ Found 'app' field: titleu ✓ Found 'title' field: datau ✓ Found 'data.app' field: u! ✓ Found 'data.title' field: z Error parsing JSON: z' No records with activity_data found!z 2. Activity data statistics:aR SELECT COUNT(*) as total, COUNT(CASE WHEN activity_data IS NULL THEN 1 END) as null_data, COUNT(CASE WHEN activity_data = '{}' THEN 1 END) as empty_data, COUNT(CASE WHEN activity_data IS NOT NULL AND activity_data != '{}' THEN 1 END) as has_data FROM activity_records z Total records: z NULL activity_data: z Empty JSON ('{}'): z Has data: z/ 3. Checking data structure in activity_data...z SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' AND activity_data != '' LIMIT 10 z Found keys in activity_data: z, No valid JSON data found in activity_data)$Z sqlalchemyrrZjsonZconfigrosZdotenvrgetenvZget_database_urlrZengineprintZconnectZconnZexecuteresultZfetchallZrecordsrecord isinstancestrloadsr dumpsdict ExceptioneZfetchoneZstatssetZ unique_keysZdata_strupdatekeysrr./check_activity_json.pysl     &"  $