255466_en-US

liliconcom

How to reload updating jsl file

I have a jsl file (list.jsl) which has mane lists. Like following. This file is updated by a running a python file called from my GUI.jsl

I'm trying to refresh the tables by calling an action item called MongoDB_table_list_refresh - which is basically trying to reload the updated file.

 

But it is erroring! Any idea how to fix it or any new method?

</CODE></STRONG></P><PRE><CODE class=" language-jsl">MongoDB_table_list_refresh = Expr( Include( "./GUI_Files/Lists.jsl" ); );GUI.jsl

Button Box( "   Refresh\!NCollections",
         Caption( "Loading collections from Mongo DB. \!NPlease wait..." );
         Wait( 0 );
         RunProgram( executable( "python" ), options( mongo_path || "update_mongo_tables_lists_file.py" ) );
         Caption( remove );
         MongoDB_table_list_refresh;
         selected_db = Database_name << get selected;
         If( selected_db == "mongo_dev_amr",
          Mongo_Table << Set Items( Mongo_table_list_mongo_dev_amr )
         );
         If( selected_db == "mongo_amr",
          Mongo_Table << Set Items( Mongo_table_list_mongo_amr )
         );

list.jsl

Mongo_table_list_mongo_dev_amr = { "ddr_dv_dev", "ddr_dv_pi", "ddr_internal", "ddr_comp_fsm", "ddr_ac", "ddr_dc" }; // This variable is auto updated by generate_mongo_tables_lists_file.py
Mongo_table_list_mongo_amr = { "ddr_internal" }; // This variable is auto updated by generate_mongo_tables_lists_file.py

Re: How to reload updating jsl file

We found the solution by incorporating python into it. Get the updated list from python directly as a list and then parse it. In this case, we don't have to refresh and check the file where this list is updated. 

 

output = RunProgram( executable( "python" ),
               options( mongo_path || "update_mongo_tables_lists_file.py"),
               readfunction( "text" )
                );

lines = Words (output, "\!N");
         For( i = 1 , i <= N Items( lines ), i++,
          If( Pat Match( lines[i], "[" ),
           db_str = Word (2, Word (1, lines[i], ":"));
           
           collection_str = Word (1, Word (2, lines[i], "["), "]");
           collection_str = Substitute (collection_str, ",", "");
           collection_str = Substitute (collection_str, "'", "");
           collection_list = Words (collection_str);
           
           if( db_str == "mongo_dev_amr",
            Mongo_table_list_mongo_dev_amr = collection_list );
           if( db_str == "mongo_amr", 
            Mongo_table_list_mongo_amr = collection_list );
           
           selected_db = Database_name << get selected;
           if( db_str == selected_db, 
            Mongo_Table << Set Items( collection_list ); );
          ),
         );

Re: How to reload updating jsl file

What is the error message, and which program produced it?

Probably you want to add readfunction("text") to the runprogram arguments.