o /^id @sdZddlZddlmZddlmZdedefddZded efd d Z deded efd d Z dede de de de f ddZ dededefddZdedede de de de f ddZde de fddZdedefddZdede fdd Zdefd!d"Zdede fd#d$ZdS)%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_servicecCstdtdtdtd|}t||tdt|||tdtdtdt||tdtdtdt|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_settingsr,/var/www/html/IGF-ODF-V3/ui/tabs/settings.pyrender_settings_tabs               rrcCstdtd\}}|%|rtdntd|}|r,td|Wdn1s6wY|td|dd Wdn1sSwY|d }t|}t 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)rrcol1col2rr masked_urirrrr <s"    r c Cstdtdtdtdtjd|dr |dnddd dd }tjd |d d dd}tdtd\}}|tjddd|dddd}Wdn1sXwY|tjddd|dddd}Wdn1swwYtdtgd\}}} |tjddd } Wdn1swY|tjd!d"d } Wdn1swYWdn1swY| rt|||||| r||||d#tj _ t d$tj vrt ||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)r3ru🧪 Test Connection secondaryr(u💾 Save Settingsprimary)rrr-r2pending_settings) rrr form text_inputr number_inputform_submit_button_handle_test_connection session_stater7rerun_show_save_confirmation) rrrrrr"r#r-r2col3 test_button save_buttonrrrr Zs      >   r rrr-r2cCstd|||||\}}Wdn1swY|r1tdtd|ddStdtd|tddS) 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.)rspinnertest_connectionrrrwarning)rrrr-r2rrrrrr<s    r<r7c Cs tdtdtd|dd|dd|dd td \}}|%tjd d d ddrFt|||d|d|d|dtj`Wdn1sPwY|%tjdd ddrttj`tdt WddSWddS1swYdS)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:** r-z'ms - **Server Selection Timeout:** r2zms This will: 1. Save settings to `app_config.yaml` 2. Update the environment variable for this session 3. Require a manual reconnection ru✅ Confirm SaveTr6confirm_save_btn)use_container_widthr(keyrNu ❌ Cancelcancel_save_btn)rGrHz%Save cancelled. No changes were made.) rr rErbutton _execute_saver=r7rr>)rrr7r"r#rrrr?s>       "r?c CsBtd|||||\}}Wdn1swY|rtdtd|tdtjdddd rtd |d |_ | }Wdn1sVwY|rqtd td t t dSt d|}|rt d|tddSdSt dt d|tddS)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 Nowr6 reconnect_btn)r(rHzReconnecting 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.)rrCsave_mongodb_settingsrr reload_configrErJ _load_configconfigconnectballoonsr>rr) rrrrr-r2rrreconnect_successrrrrK"s@             rKreturncCsf|sdSd|vr1|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:r3unknownz //***:***@)splitlen)rparts protocol_part host_partrrrr ds  "r cCsVtd|}|stddSt|}tjd|dd}|r)t||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))rr get_all_collectionsrlistkeys selectbox_render_collection_editor)rr collectionscollection_namesselected_collectionrrrr}s   rcollection_namecCsV||}td|td|tdtd|dg}tjdd|dd d d }td td |dg}tjdd|dddd }td|dd}tjdgdgd |dd}tj d|dddd} tdtj dd d!} | rd"d#| dD} d$d#| dD} | s|d%krt d& Wd'd'S| s|d(vrt d) Wd'd'S||| | || \} }| rtd*|td+d,| d-d,| d.|d/t| d0tnt d1|Wd'n 1s wYtdtd2td3\}}|$td4|r<|D] }td5|q/ntd6Wd'n 1sLwY|$td7|rk|D] }td5|q^ntd6Wd'n 1s{wYtd8|d9td:|ddrd;nd<tdtd=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)rlprimary_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 Configurationr6r5cSg|] }|r|qSrstrip.0krrr z-_render_collection_editor..cSrqrrrrtrrrrwrxrnuG❌ Business keys are required unless using 'alternative_only' strategyN)rmrnu<❌ 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_configrrr8r get text_areajoinr_rocheckboxr;rWrupdate_collection_configrrstrrRrr!_render_foreign_key_editor)rrdrPcurrent_business_keysbusiness_keys_textcurrent_alternative_keysalternative_keys_textcurrent_strategyrkrp submittedrfrjrrr"r#rHrrrr`s                C H  `     "  r`c Cs0td|}td|ddtdvtdtjddd |d d d }td tdtjddd}|rv||krFtdn8||\}}|rftd|dd|dtdt n t d|WddSWddSWddSWddS1swYdS)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 Loadrhir,zENumber of records to load from MongoDB for comparison (100 - 100,000)r.u` **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 Limitr6r5uℹ️ 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) rr get_record_limitrr8r:r;update_record_limitrrRr)r current_limit new_limitrrrrrrr(sF       %"rc CsZtd||}t|}td|Wtdtdtjddd|r1t|nddd }g}|dkrtd t |D]}td |d d t d\}}} |t|krd||ni} |tj d|| ddd|ddd} Wdn1swY|+tj ddg|| dd|vr|| ddd ndd|dd} Wdn1swY| tj d| ddd|dd d} Wdn1swY| r| r| r|| | | d!td qEtjd"d#d$}|rk|dkrt||krtd% WddS|||\}}|rctd&||rYtd t|d'|D]}td(|dd)|dd*|dq@ntd+tntd,|Wdn 1svwY|rtd-t|d D]\}}t|d.|dd)|dd*|dqdStd/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)r/r0r'r)rz**Foreign Key #r3z**z Field in field fk_field_zDField name in this collection (e.g., athlete_code, competition_code) athlete_code)r'rHr)r*NzReferences Collectionreferences_collection fk_ref_coll_zTarget collection name)optionsrorHr)zReferences Fieldreferences_field fk_ref_field_z0Field name in target collection (e.g., code, id)code)rrru💾 Save Foreign Keysr6r5uN❌ Please fill in all foreign key fields or reduce the number of foreign keysu'✅ Foreign keys saved for collection: z foreign key(s) configured:**ryr.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.)rr get_foreign_keysr]r\r^r8r:rXrangerr9r{r_roappendr;rupdate_foreign_keysrrr!rR enumerate)rrd current_fksall_collectionsnum_fks foreign_keysir"r#r@ current_fkrref_collection ref_fieldrrrfkidxrrrres        (     K,  Z 0r)__doc__ streamlitrservices.settings_servicerservices.mongorrdictr r rintr<r?rKr rr`rrrrrrsd  * s " 3 B  =