ג[ic dZddlZddlmZddlmZdedefdZdedefd Z dededefd Z ded e d e d e de f dZ dededefdZdeded e d e d e de f dZd e de fdZdedefdZdede fdZdefdZdede fdZdS)aH Settings Tab UI This module provides the UI for managing application settings, specifically MongoDB connection configuration. Key principles: - Manual control: All actions require explicit user confirmation - Clear feedback: Success and error messages are always shown - No automation: No background reconnections or retries N)SettingsService) MongoServicesettings_service mongo_servicecftjdtjdtjdtjd|}t ||tjdt |||tjdtjdtjdt||tjdtjdtjdt|dS)z Render the Settings tab with MongoDB configuration. Args: settings_service: Settings service instance mongo_service: MongoDB service instance u⚙️ Settingsz6Configure MongoDB connection and application settings.---u 🔌 MongoDB Connection Settingsu📋 Collection Configurationu⚙️ Data Loading SettingsN) sttitlemarkdownheaderget_mongodb_settings_render_connection_status_render_configuration_form _render_collection_configuration_render_record_limit_settings)rrcurrent_settingss ,/var/www/html/IGF-ODF-V3/ui/tabs/settings.pyrender_settings_tabrs"H KHIIIKI0111(<<>>m-=>>>K/@PQQQKKI-...$%5}EEEKKI,---!"233333rc0tjdtjd\}}|5|rtjdnAtjd|}|rtjd|dddn #1swxYwY|5tjd|dd dddn #1swxYwY|d }t|}tj d |dS) z Render current connection status. Args: mongo_service: MongoDB service instance current_settings: Current MongoDB settings u📊 Current Connection Statusu✅ **Status:** Connectedu❌ **Status:** Not Connected **Error:** Nz**Active Database:** `database`urizConnection URI: ) r subheadercolumns is_connectedsuccesserrorget_connection_errorinfo _mask_uritext)rrcol1col2r r masked_uris rrr<sL1222AJD$ 00  % % ' ' 0 J2 3 3 3 3 H4 5 5 5!6688E 0.u..///000000000000000 JJ H)9*)EHHHIIIJJJJJJJJJJJJJJJ 5 !C3JG +z + +,,,,,s$A+B%%B),B)2CC!$C!c tjdtjdtjd5tjdtjd|dr|dnddd d }tjd |d d d}tjdtjd\}}|5tjddd|ddd}dddn #1swxYwY|5tjddd|ddd}dddn #1swxYwYtjdtjgd\}}} |5tjdd } dddn #1swxYwY|5tjd!d" } dddn #1swxYwYdddn #1swxYwY| rt|||||| r)||||d#tj _ tj d$tj vr"t||tj j dSdS)%z Render the configuration form for MongoDB settings. Args: settings_service: Settings service instance mongo_service: MongoDB service instance current_settings: Current MongoDB settings u🔧 Configurationz **Important:** - Changes will be saved to `app_config.yaml` - The MongoDB URI will be stored in the environment variable - You must click "Save Settings" to apply changes - After saving, the application will attempt to reconnect mongodb_settings_formz### Connection Detailsz MongoDB URIrzpmongodb://AdminUser:WnE0TjGIafVJutreZL7cTIoWNWU52YyxLVgwCUqIGCGg3YUT@18.184.249.241:27017/?authMechanism=DEFAULTpasswordzEFull MongoDB connection string (e.g., mongodb://user:pass@host:port/))valuetypehelp placeholderz Database Namerz#Name of the MongoDB database to useIGF_WORK)r+r-r.z#### Timeout Settings (milliseconds)rzConnection Timeouti`connection_timeoutz#Time to wait for initial connection min_value max_valuer+stepr-NzServer Selection Timeoutserver_selection_timeoutz!Time to wait for server selectionr)r7ru🧪 Test Connection secondaryr,u💾 Save Settingsprimary)rrr1r6pending_settings) r rr form text_inputr number_inputform_submit_button_handle_test_connection session_stater;rerun_show_save_confirmation) rrrrrr%r&r1r6col3 test_button save_buttons rrrZsL%&&&K    ( ) );; ,---m -=e-D}"5))K}XK    = ":.6"     9:::Z]] d   !#$&';<: """                  ')*&'AB8 ((( $                E:iii00dD   /& K                  /$K               o;;;;;;;;;;;;;;;|      $     "4(@ - - )  R--      -       sB G!C3' G3C7 7G:C7 ;G!D-! G-D1 1G4D1 53G(F ? G F GF GF;/ G;F? ?GF? GGGrrr1r6crtjd5|||||\}}dddn #1swxYwY|r.tjdtjd|ddStjdtjd|tjddS) a Handle test connection action. Args: settings_service: Settings service instance uri: MongoDB URI database: Database name connection_timeout: Connection timeout in ms server_selection_timeout: Server selection timeout in ms zTesting connection...Nu#✅ **Connection test successful!**z%Successfully connected to database: `ru❌ **Connection test failed!**rz4Please check your connection settings and try again.)r spinnertest_connectionrr"r warning)rrrr1r6rr s rr@r@s" + , ,  )99    $                  K 8999 CCCCDDDDD 2333 &u&&''' IJJJJJs=AAr;c tjdtjdtjd|dd|dd|dd tjd \}}|5tjd d d dr8t |||d|d|d|dtj`dddn #1swxYwY|5tjdd dr3tj`tjdtj ddddS#1swxYwYdS)z Show confirmation dialog for pending settings. Args: settings_service: Settings service instance mongo_service: MongoDB service instance pending_settings: Dictionary with pending settings ru"⚠️ **Confirm Settings Change**zS You are about to update the MongoDB connection settings: - **Database:** `rz ` - **Connection Timeout:** r1z'ms - **Server Selection Timeout:** r6zms This will: 1. Save settings to `app_config.yaml` 2. Update the environment variable for this session 3. Require a manual reconnection ru✅ Confirm Savestretchr:confirm_save_btn)widthr,keyrNu ❌ Cancelcancel_save_btn)rNrOz%Save cancelled. No changes were made.) r r rJrbutton _execute_saverAr;r"rB)rrr;r%r&s rrCrCsKJ3444K &z2   00DE  &66P%Q       AJD$ 2 2 9'yyN` a a a 2   ' , !56 !;<     1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2  9\8I J J J  1 G; < < < HJJJ s&2ACCCA D44D8;D8ctjd5|||||\}}dddn #1swxYwY|rmtjdtjd|tjdtjddd rtjd 5|d |_ | }dddn #1swxYwY|rPtjd tjd tj tj dStj d|}|rtj d|tjddSdStj dtj d|tjddS)aG Execute the save operation. Args: settings_service: Settings service instance mongo_service: MongoDB service instance uri: MongoDB URI database: Database name connection_timeout: Connection timeout in ms server_selection_timeout: Server selection timeout in ms zSaving settings...Nu$✅ **Settings saved successfully!**z-Settings have been saved to `app_config.yaml`z **Next Steps:** 1. The application needs to reconnect with the new settings 2. Click the button below to reconnect 3. Check the connection status in the sidebar u🔄 Reconnect Nowr: reconnect_btn)r,rOzReconnecting to MongoDB...zconfig/app_config.yamlu!✅ **Reconnected successfully!**z,MongoDB connection updated with new settingsu❌ **Reconnection failed!**rz)Please check your settings and try again.u ❌ **Failed to save settings!**z*Please verify your settings and try again.)r rHsave_mongodb_settingsrr" reload_configrJrQ _load_configconfigconnectballoonsrBr r!) rrrrr1r6rr reconnect_successs rrRrR"s& ( ) )  )??    $                  $A 9::: ?@@@ &&(((      9)  O O O H899 < <'4'A'ABZ'['[ $$1$9$9$;$;! < < < < < < < < < < < < < < < ! H >???FGGG  7888%::<<4H2522333 FGGGGG# H H& 3444 &u&&''' ?@@@@@s!=AA/DD Dreturnc|sdSd|vrf|d}d|dvr!|dddnd}t|dkr|dnd}|d|S|S) z Mask sensitive parts of MongoDB URI. Args: uri: MongoDB connection URI Returns: Masked URI string zNot configured@z//rzmongodb:r7unknownz //***:***@)splitlen)rparts protocol_part host_parts rr#r#ds   cz #37583CSat,,Q// #E Q=E!HHI 669666 rctjd|}|stjddSt |}tjd|d}|rt||dSdS)z Render collection configuration section. Args: settings_service: Settings service instance mongo_service: MongoDB service instance z Configure business keys, alternative keys, and matching strategies for each collection. This determines how duplicate records are detected during import. u%ℹ️ No collections configured yet.NzSelect Collection to Configurez-Choose which collection you want to configure)r-)r r get_all_collectionsr"listkeys selectbox_render_collection_editor)rr collectionscollection_namesselected_collections rrr}sK   #6688K  7888K,,..//,( < I!"24GHHHHHIIrcollection_namecd ||}tjd|tjd|5tjdtjd|dg}tjdd|dd d }tjd tjd |dg}tjdd|ddd }tjd|dd}tjdgdgd |d}tj d|ddd} tjdtj dd !} | rOd"| dD} d#| dD} | s(|d$kr"tj d% d&d&d&d&S| s&|d'vr"tj d( d&d&d&d&S||| | || \} }| rtjd)|tjd*d+| zd,zd+| zd-z|zd.zt#| zd/ztjntj d0|d&d&d&n #1swxYwYtjdtjd1tjd2\}}|5tjd3|r|D]}tjd4|ntjd5d&d&d&n #1swxYwY|5tjd6|r|D]}tjd4|ntjd5d&d&d&n #1swxYwYtjd7|d8tjd9|ddrd:nd;tjdtjd<t+||d&S)=z Render editor for a specific collection. Args: settings_service: Settings service instance collection_name: Name of the collection to edit u⚙️ Configure: collection_config_z### Business Keys (Primary)zFFields used to identify unique records. Enter one field name per line. business_keysz Business Keys dz3Example: code, athlete_id, player_id (one per line)zcode athlete_id)r+heightr-r.z ### Alternative Keys (Secondary)znAdditional fields used when primary keys don't match. Useful for finding the same person with different codes.alternative_keyszAlternative Keysz;Example: given_name, family_name, birth_date (one per line)z!given_name family_name birth_datez### Matching Strategymatching_strategy primary_onlyzMatching Strategy)rwprimary_or_alternativealternative_onlyz - primary_only: Match only by business keys - primary_or_alternative: Try business keys first, then alternative keys - alternative_only: Match only by alternative keys )indexr-zCollection EnabledenabledTz!Enable or disable this collection)r+r-ru"💾 Save Collection Configurationr:r9c^g|]*}||+Sstrip.0ks r z-_render_collection_editor..s2\\\1RSRYRYR[R[\QWWYY\\\rc^g|]*}||+Sr}r~rs rrz-_render_collection_editor..s2bbbaXYX_X_XaXab bbbrryuG❌ Business keys are required unless using 'alternative_only' strategyN)rxryu<❌ Alternative keys are required for this matching strategyu(✅ Configuration saved for collection: zM **Configuration updated:** - Business Keys: z, z% - Alternative Keys: z& - Matching Strategy: z - Enabled: un 💡 Changes will take effect on the next import operation. u"❌ Failed to save configuration: z### Current Configurationrz**Business Keys:** • z (none)z**Alternative Keys:**z**Matching Strategy:** `rz **Enabled:** u✅ Yesu❌ Noz### Foreign Key Relationships)get_collection_configr rr<r get text_areajoinrirzcheckboxr?r`r update_collection_configrr"strrZrr$_render_foreign_key_editor)rrnrXcurrent_business_keysbusiness_keys_textcurrent_alternative_keysalternative_keys_textcurrent_strategyrvr{ submittedrqrurr r%r&rOs rrjrjs 3 3O D DFL7o77888 7o77 8 8]G]G 1222 \]]]!' ?B ? ?\ ))122F*     6777 E F F F$*::.@"#E#E " ))455N= ! ! !  +,,,"::&9>JJL  J J JPPPVVWghh    + **Y--4    E) 0   $ G\\0B0H0H0N0N\\\Mbb3H3N3Nt3T3Tbbb ! %6:L%L bcccC]G]G]G]G]G]G]G]GF$ (9=k(k WXXXK]G]G]G]G]G]G]G]GP.FF ! NGU G WoWWXXX%'+yy'?'?@C((+/))4D*E*EFI)),= =@  "%W . 1  EeEEFFF{]G]G]G]G]G]G]G]G]G]G]G]G]G]G]G@KK+,,,AJD$    ()))  , ( ('''' ( GJ                       +,,, # / ( ('''' ( GJ                   K>+;>>>???KXVZZ 4-H-H V hXXYYYKK/000/AAAAAsFG!L%2L%B?L%%L),L)1AOO  O AP&&P*-P*c tjd|}tjd|ddtjd5tjdtjddd |d d }tjd tjdtjdd}|r||krtjdnu||\}}|rDtjd|dd|dtjdtj ntj d|ddddS#1swxYwYdS)zr Render record limit settings section. Args: settings_service: Settings service instance a1 Configure the maximum number of records to load from MongoDB when comparing with JSON files. **Important:** If your collection has more records than this limit, only the first N records will be loaded for comparison. This may cause duplicate detection to miss some existing records. u📊 Current record limit: **,z ** recordsrecord_limit_formz### Set Record LimitzMaximum Records to Loadrsir0zENumber of records to load from MongoDB for comparison (100 - 100,000)r2u` **Recommendations:** - **Small collections (<1,000 records):** Use 5,000 - **Medium collections (1,000-10,000 records):** Use 10,000-20,000 - **Large collections (>10,000 records):** Use 50,000-100,000 ⚠️ **Warning:** Higher limits use more memory and may slow down the comparison process. ru💾 Save Record Limitr:r9uℹ️ Record limit unchangedu✅ Record limit updated:  → uE💡 The new limit will be used for all future comparison operations.u#❌ Failed to update record limit: N) r r get_record_limitr"r<r>r?update_record_limitrrZr )r current_limit new_limitrrr s rrr(sK   %5577MG GM G G G GHHH $ % %'L'L *+++O %X          E) $    LM) L78888!1!E!Ei!P!PLJ_M___R[___```GcdddKMMMMHJ5JJKKKO'L'L'L'L'L'L'L'L'L'L'L'L'L'L'L'L'L'LsC?E""E&)E&c ztjd||}t|}tjd|5tjdtjdtjddd|rt|ndd }g}|dkrtjd t|D]}tjd |d zd tj d\}}} |t|kr||ni} |5tj d|| ddd|dd} dddn #1swxYwY|5tj ddg|z| dd|vr,|| ddd zndd|d} dddn #1swxYwY| 5tj d| ddd|dd } dddn #1swxYwY| r| r| r|| | | d!tjd tjd"d#$}|r|dkr5t||kr"tjd% ddddS|||\}}|rtjd&||rZtjd t|d'|D]1}tjd(|dd)|dd*|d2ntjd+tjntjd,|dddn #1swxYwY|r]tjd-t/|d D]6\}}tj|d.|dd)|dd*|d7dStjd/dS)0z Render foreign key relationship editor. Args: settings_service: Settings service instance collection_name: Name of the collection z Define foreign key relationships to validate data integrity. The system will check if referenced values exist in target collections. foreign_keys_z**Configure Foreign Keys**zXAdd relationships where fields in this collection reference fields in other collections.zNumber of Foreign Keysr z/How many foreign key relationships to configure)r3r4r+r-rz**Foreign Key #r7z**z Field in field fk_field_zDField name in this collection (e.g., athlete_code, competition_code) athlete_code)r+rOr-r.NzReferences Collectionreferences_collection fk_ref_coll_zTarget collection name)optionsrzrOr-zReferences Fieldreferences_field fk_ref_field_z0Field name in target collection (e.g., code, id)code)rrru💾 Save Foreign Keysr:r9uN❌ Please fill in all foreign key fields or reduce the number of foreign keysu'✅ Foreign keys saved for collection: z foreign key(s) configured:**rr.z4Foreign key validation disabled for this collection.u!❌ Failed to save foreign keys: z**Current Foreign Keys:**z. uIℹ️ No foreign keys configured. Data integrity validation is disabled.)r r get_foreign_keysrgrfrhr<r>rarangerr=rrirzappendr?r update_foreign_keysrr"r$rZ enumerate)rrn current_fksall_collectionsnum_fks foreign_keysir%r&rD current_fkrref_collection ref_fieldrrr fkidxs rrresK   #33ODDK+??AAFFHHIIO 222 3 3WFWF 0111 nooo/ $&18#k"""qB     Q;- # K   7^^* #* # 5ac555666#%:a== dD013{3C3C/CK[^^ M5O55(nnWb99+OOc$2 E%'\/!# 6hrhvhvxOQSiTiTXgigno33JNNCZ\^4_4_``cdddmn.1..5 &&&N " *(nn-?DD/A//O$* !!!I^  ''!&1?,5))  E"""") $    F{ s<00G; ijjjQWFWFWFWFWFWFWFWFV.AA/S_``NGU F V_VVWWWTGQ\!2!2QQQRRR*ss qG q q2>U;V q qY[\nYo q qrrrrsGRSSS DUDDEEEoWFWFWFWFWFWFWFWFWFWFWFWFWFWFWFt] /000 a00 h hGC Gsffbkff3J0KffbQcNdff g g g g h h [\\\\\s4CN=4F< N=F N=F N=A%H: N=H N= H N=1I N=I N=I A?N=$C N==OO)__doc__ streamlitr services.settings_servicerservices.mongorrdictrrrintr@rCrRr#rrjrrr}rrrsh  555555'''''''4/'4,'4'4'4'4T-\-T----