U h5 @sddlmZmZmZmZddlZddlZddlmZddlm Z e e dZ e se ddZ e dd Z e d d Ze d d Ze ddZdedede de de Z ee ZddZddZddZedkredS)) create_enginetextColumnStringN)datetime) load_dotenv DATABASE_URLDB_HOSTZ localhostDB_PORTZ5432DB_NAMEZ timesheet_dbDB_USERZpostgres DB_PASSWORDz postgresql://:@/c sntZ}|td}dd|DtdD]}td|q4dddd g}fd d|D}|rTtd |td |D]}zf|d kr|td|dtd|n4|dks|dkr|td|dtd|Wqtk rH}z8dt|kr$td|dntd|d|W5d}~XYqXq|W5QRSQRXdS)zACheck if the required columns exist in the activity_records tablez SELECT column_name FROM information_schema.columns WHERE table_name = 'activity_records' ORDER BY ordinal_position cSsg|] }|dqS)r).0rowrr./flexible_dashboard_fix.py #sz'check_table_columns..z+Existing columns in activity_records table:z - application_name window_titlecategory project_namecsg|]}|kr|qSrr)rcolcolumnsrrr)su ⚠️ Missing columns: zCreating missing columns...)rrrr project_typez(ALTER TABLE activity_records ADD COLUMN z VARCHAR(255)u ✓ Added column: url file_pathz TEXTzalready existsz - Column z already existsu ❌ Error adding column : N)engineconnectexecuterprint Exceptionstrcommit)connresultrZrequired_columnsZmissing_columnserrrcheck_table_columnss2  (r,c CsRzt|tr,|dkr iWSt|}n|}dddddddd}t|trd|kshd|kshd |kr|dp|dp|d d|d <d |ksd |kr|d p|d d|d <d |krt|d tr|d }d|kr|d|d <d |kr|d |d <d |kr|d |d <d|kr|dd}|r|dkr||d<|drdd|d <d|d<nL|drd|d <d|d<n.|drd|d <d|d<nd|d <d|d<|d s||d <d|kr|ddkr|d|d<d|d<d|kr8|ddkr8|d r|d dkr8|dd|d <d|d<d |kr|d |d <d |d <d!|d<z.d"d#lm }||d j }||d<d$|d<Wn YnXd%|ksd&|kr|d%p|d&|d <|d d'krd(|d <|WSt k rL}zJt d)|t d*t|dd+d,d-t|dd.d/d0WYSd}~XYnXdS)1zA Flexible parser that can handle various JSON structures )rz{}ZnullZUnknownrNotherrrrr rrrappZ applicationrtitlerdatarfileunknownr z.phpzPHP DevelopmentZiderz.pyzPython Development)z.jsz.jsxz.tsz.tsxzJavaScript Developmentz Code EditorZprojectrZ Developmentrlanguagez Developmentz Web BrowserZbrowserr)urlparseZBrowsingZprocessZprogram)Nrr3Unknown ApplicationzError parsing activity data: zData: ...z Parse Errorderror)rrr) isinstancer'stripjsonloadsdictgetendswithZ urllib.parser5Znetlocr&r%) activity_datar1 extractednestedr r5domainr+rrrflexible_parse_activity_dataAs                         rFc" Cs:tdtdtt}td|td}tdt|D]t\}\}zHt|trht |n|}td|ddtd t j |d d WqHtd|dd YqHXqHtd |td}g}d}d}|D]}|\} } } } } t | }|r| | | | d|}| ||dkr|ddkrtd|ddtd| td|dtd|dddddtd|dd|drtd |d|d7}q|d7}qtd!t|d"|d#|r4td$|}zd%}tdt||D]}||||}|D]}g}d&|d&i}d'D]>}||krL||dk rL| |d(|||||<qL|r4d)d*|d+}|t||q4td,t||t|d-t|d.q|td/Wn<tk r2}z|td0|W5d}~XYnXtd1|td2}td3|}|r|D] \}}td4|d5|d6qdntd7|td8}td9|}|r|D]@\}}}} | r| nd}!td4|d5|d:|d;|!d<d= qntd>td?td@tdAtdBtdCW5QRXdS)Dz*Main function to update the dashboard dataz$=== Flexible Dashboard Data Fix === z1. Checking table structure...z 2. Analyzing current data...z SELECT activity_data FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' AND activity_data != '' LIMIT 5 z Sample JSON structures:z Sample rz )indentz: Unable to parsez 3. Processing records...a SELECT id, activity_data, developer_id, timestamp, duration FROM activity_records WHERE activity_data IS NOT NULL AND activity_data != '{}' AND activity_data != '' ORDER BY timestamp DESC r)id developer_id timestampdurationrr6z Developer: z App: z Title: rzN/ANPr8z Category: rr-rz Project: z 4. Found z records to update (z errors)z 5. Updating database...r9rJr.z = :z] UPDATE activity_records SET z, zL WHERE id = :id z Updated rz records...u& ✅ Successfully updated all records!u ❌ Error during update: z 6. Verification:z SELECT application_name, COUNT(*) as count FROM activity_records WHERE application_name IS NOT NULL GROUP BY application_name ORDER BY count DESC LIMIT 10 z Top applications:z - r!z recordsu ❌ No applications found!a SELECT developer_id, COUNT(DISTINCT application_name) as app_count, COUNT(*) as record_count, SUM(duration) / 3600 as hours FROM activity_records WHERE application_name IS NOT NULL AND application_name != 'Unknown Application' GROUP BY developer_id z Developer activity:z apps, z records, z.1fz hoursu# ❌ No developer activity found!u ✅ Dashboard fix completed!z Next steps:z$1. Restart your dashboard API serverz2. Clear your browser cachez3. Refresh the dashboard)r%r,r"r#r$r enumerater;r'r=r>dumpsrFappendr@lenZbeginrangejoinminr(r&ZrollbackZfetchall)"r)r*idxr1ZparsedZupdatesZ sample_countZ error_countrecordZ record_idrBrKrLrMrCZ update_dataZtransZ batch_sizeiZbatchZ update_fieldsparamsZfieldZqueryr+Zappsr/countZdevsZdev_idZ app_countZ record_countZhoursZ hours_valrrrupdate_dashboard_datas         ,    *r\__main__)Z sqlalchemyrrrrr=osrZdotenvrgetenvrr r r r r r"r,rFr\__name__rrrrs(        "(q%