U [Mhz @sdZddlZddlmZmZddlmZeddZedkre de d ere d e d e d e d e de de dne de ddS)zP Migration script to add detailed information columns to activity_records table N) create_enginetext) load_dotenvc CsJtd}t|}z|}|}ztdddddg}|D] }td||t|qB|td|td }d d | D}td |WW5QRWd St k r}z,| td|WYW5QRWdSd}~XYnXW5QRXWn8t k rD}ztd|WYdSd}~XYnXdS)z.Add new columns for detailed activity trackingZ DATABASE_URLu4🔄 Adding new columns to activity_records table...zDALTER TABLE activity_records ADD COLUMN IF NOT EXISTS file_path TEXTzVALTER TABLE activity_records ADD COLUMN IF NOT EXISTS database_connection VARCHAR(255)zSALTER TABLE activity_records ADD COLUMN IF NOT EXISTS specific_process VARCHAR(255)zLALTER TABLE activity_records ADD COLUMN IF NOT EXISTS detailed_activity TEXTz Executing: u.✅ Database migration completed successfully!aG SELECT column_name FROM information_schema.columns WHERE table_name = 'activity_records' AND column_name IN ('file_path', 'database_connection', 'specific_process', 'detailed_activity') ORDER BY column_name cSsg|] }|dqS)r).0rowrr./migrate_detailed_info.py /sz$migrate_database..u✅ Verified new columns: Tu❌ Error during migration: FNu❌ Database connection error: ) osgetenvrZconnectZbeginprintZexecuterZcommitZfetchall ExceptionZrollback) Z database_urlZengineZconnZtransZ new_columnsZsqlresultZ added_columnserrrmigrate_database s8  2r__main__z5Database Migration: Adding Detailed Activity Trackingz<============================================================u' 🎉 Migration completed successfully!z New features available:u$• 📁 File path tracking for IDEsu'• 🗄️ Database connection detailsu'• ⚙️ Specific process informationu'• 📋 Enhanced activity descriptionsz5 Restart your backend server to use the new features!u ❌ Migration failed!z4Please check the error messages above and try again.) __doc__r Z sqlalchemyrrZdotenvrr__name__r rrrrs$ 2