while s_label == "": s_label = input("Fabrik element LABEL name? ") # Input the joomla mysql fabrik element ORDER number print("") s_auto = "" while s_auto == "": s_auto = input("Fabrik element ORDERING number? ") # Script log file funcfile.writelog("Now") funcfile.writelog("SCRIPT: FABRIK_INSERT_05_ELEMENT_RADIOBUTTON") funcfile.writelog("--------------------------------------------") # Connect to the oracle database cnxn = funcmysql.mysql_open(s_database) curs = cnxn.cursor() funcfile.writelog("%t OPEN DATABASE: " + s_database) # Add default FINDING RATE data 1 s_sql = "INSERT INTO " + s_table + "(" + """ name, group_id, plugin, label, created, created_by, created_by_alias, hidden, ordering, show_in_list_summary,
def fabrik_groupcreate(b_input=False, s_db="Web_ia_joomla", s_tb="ianwu_fabrik_groups", s_lb="New GROUP to setup"): """ Create Joomla Fabrik group record :param b_input: Input database parameters if True (Default=False) :param s_db: Mysql database (Default=Web_ia_joomla) :param s_tb: Mysql table (Default=ianwu_fabrik_groups) :param s_lb: Fabrik group label (Default=New GROUP to setup) :return: """ """ INDEX ****************************************************************** ENVIRONMENT INPUT OPEN DATABASE INSERT GROUP RECORD *************************************************************************""" print("FABRIK CREATE GROUP STEP 1") print("--------------------------") print("ENVIRONMENT") # IMPORT SYSTEM OBJECTS import sys # OWN MODULE PATH sys.path.append('S:/_my_modules') # IMPORT PYTHON OBJECTS import pyodbc # IMPORT FUNCTIONS import funcfile import funcmysql # DECLARE VARIABLES s_sql = "" s_created_by = "854" """************************************************************************* INPUT *************************************************************************""" print("INPUT") # Input the joomla mysql fabrik DATABASE name s_dbi = s_db if b_input: print("") print("Default:"+s_db) s_dbi = input("Fabrik DATABASE name? ") if s_dbi == "": s_dbi = s_db # Input the joomla mysql fabrik TABLE name s_tbi = s_tb if b_input: print("") print("Default:"+s_tb) s_tbi = input("Fabrik TABLE name? ") if s_tbi == "": s_tbi = s_tb # Input the joomla mysql fabrik GROUP label s_lbi = s_lb if b_input: print("") print("Default:"+s_lb) s_lbi = input("Fabrik GROUP label? ") if s_lbi == "": s_lbi = s_lb print("") """************************************************************************* OPEN DATABASE *************************************************************************""" print("OPEN DATABASE") funcfile.writelog("OPEN DATABASE") # Connect to the oracle database cnxn = funcmysql.mysql_open(s_dbi) curs = cnxn.cursor() funcfile.writelog("%t OPEN DATABASE: " + s_dbi) """************************************************************************* INSERT GROUP RECORD *************************************************************************""" print("INSERT GROUP RECORD") funcfile.writelog("INSERT GROUP RECORD") # INSERT GROUP RECORD s_sql = "INSERT INTO `" + s_tbi + "` (" + """ `name`, `css`, `label`, `published`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `is_join`, `private`, `params` """ + ") VALUES (" + """ '%LABEL%', '', 'Add/Edit %LABEL%', 1, NOW(), %CREATED_BY%, 'Python', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '{ \"split_page\":\"0\", \"list_view_and_query\":\"1\", \"access\":\"1\", \"intro\":\"\", \"outro\":\"\", \"repeat_group_button\":\"0\", \"repeat_template\":\"repeatgroup\", \"repeat_max\":\"\", \"repeat_min\":\"\", \"repeat_num_element\":\"\", \"repeat_error_message\":\"\", \"repeat_no_data_message\":\"\", \"repeat_intro\":\"\", \"repeat_add_access\":\"1\", \"repeat_delete_access\":\"1\", \"repeat_delete_access_user\":\"\", \"repeat_copy_element_values\":\"0\", \"group_columns\":\"1\", \"group_column_widths\":\"\", \"repeat_group_show_first\":\"1\", \"random\":\"0\", \"labels_above\":\"-1\", \"labels_above_details\":\"-1\" }' """ + ");" #print(s_sql) # DEBUG s_sql = s_sql.replace("%LABEL%",s_lbi) s_sql = s_sql.replace("%CREATED_BY%",s_created_by) curs.execute(s_sql) cnxn.commit() funcfile.writelog("%t INSERT RECORD: "+s_dbi+"."+s_tbi+": "+s_lbi) # GROUP DEFAULT PARAMETERS """ ( 92, 'TEST List', '', 'TEST List', 1, '2019-03-20 05:14:04', 842, 'Albertjvr', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '{ \"split_page\":\"0\", \"list_view_and_query\":\"1\", \"access\":\"1\",\"intro\":\"\", \"outro\":\"\", \"repeat_group_button\":0, \"repeat_template\":\"repeatgroup\", \"repeat_max\":\"\", \"repeat_min\":\"\", \"repeat_num_element\":\"\", \"repeat_error_message\":\"\", \"repeat_no_data_message\":\"\", \"repeat_intro\":\"\", \"repeat_add_access\":\"1\", \"repeat_delete_access\":\"1\", \"repeat_delete_access_user\":\"\", \"repeat_copy_element_values\":\"0\", \"group_columns\":\"1\", \"group_column_widths\":\"\", \"repeat_group_show_first\":1, \"random\":\"0\", \"labels_above\":\"-1\", \"labels_above_details\":\"-1\" }' ); """ # GET NEWLY CREATED GROUP NUMBER curs.execute("SELECT "+s_tbi+".id, "+s_tbi+".name FROM "+s_tbi+" WHERE "+s_tbi+".name = '" + s_lbi +"'") for row in curs.fetchall(): print("Created group "+str(row[0])) funcfile.writelog("%t GROUP CREATED: "+str(row[0])) i_return = row[0] # RETURN NEWLY CREATED GROUP NUMBER return i_return
def Fabrik_formcreate(s_input="F", s_fl="New FORM to setup", s_db="Web_ia_joomla", s_tb="ianwu_fabrik_forms"): """ PARAMETERS ************************************************************* s_input = F=do not ask parameters(default) T=ask parameters s_fl = Form label s_db = Joomla database s_tb = Joomla table name *************************************************************************""" """ INDEX ****************************************************************** ENVIRONMENT INPUT OPEN DATABASE INSERT GROUP RECORD *************************************************************************""" print("FABRIK CREATE FORM STEP 2") print("-------------------------") print("ENVIRONMENT") # IMPORT SYSTEM OBJECTS import sys # OWN MODULE PATH sys.path.append('S:/_my_modules') # IMPORT PYTHON OBJECTS import pyodbc # IMPORT FUNCTIONS import funcfile import funcmysql # DECLARE VARIABLES s_sql = "" s_created_by = "854" """************************************************************************* INPUT *************************************************************************""" print("INPUT") # Input the joomla mysql fabrik DATABASE name s_dbi = s_db if s_input == "T": print("") print("Default:" + s_db) s_dbi = input("Fabrik DATABASE name? ") if s_dbi == "": s_dbi = s_db # Input the joomla mysql fabrik TABLE name s_tbi = s_tb if s_input == "T": print("") print("Default:" + s_tb) s_tbi = input("Fabrik TABLE name? ") if s_tbi == "": s_tbi = s_tb # Input the joomla mysql fabrik FORM name s_fli = s_fl if s_input == "T": print("") print("Default:" + s_fl) s_fli = input("Fabrik FORM label? ") if s_fli == "": s_fli = s_fl print("") """************************************************************************* OPEN DATABASE *************************************************************************""" print("OPEN DATABASE") funcfile.writelog("OPEN DATABASE") # Connect to the oracle database cnxn = funcmysql.mysql_open(s_dbi) curs = cnxn.cursor() funcfile.writelog("%t OPEN DATABASE: " + s_dbi) """************************************************************************* INSERT FORM RECORD *************************************************************************""" print("INSERT FORM RECORD") funcfile.writelog("INSERT FORM RECORD") # INSERT FORM RECORD s_sql = "INSERT INTO `" + s_tbi + "` (" + """ `label`, `record_in_database`, `error`, `intro`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `reset_button_label`, `submit_button_label`, `form_template`, `view_only_template`, `published`, `private`, `params` """ + ") VALUES (" + """ '%LABEL%', 1, 'Some parts of your form have not been correctly filled in', '', NOW(), %CREATED_BY%, 'Python', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'Reset', 'Save', 'bootstrap', 'bootstrap', 1, 0, '{ \"outro\":\"\", \"reset_button\":\"0\", \"reset_button_label\":\"Reset\", \"reset_button_class\":\"btn-warning\", \"reset_icon\":\"\", \"reset_icon_location\":\"before\", \"copy_button\":\"0\", \"copy_button_label\":\"Save as copy\", \"copy_button_class\":\"\", \"copy_icon\":\"\", \"copy_icon_location\":\"before\", \"goback_button\":\"0\", \"goback_button_label\":\"Go back\", \"goback_button_class\":\"\", \"goback_icon\":\"\", \"goback_icon_location\":\"before\", \"apply_button\":\"0\", \"apply_button_label\":\"Apply\", \"apply_button_class\":\"\", \"apply_icon\":\"\", \"apply_icon_location\":\"before\", \"delete_button\":\"0\", \"delete_button_label\":\"Delete\", \"delete_button_class\":\"btn-danger\", \"delete_icon\":\"\", \"delete_icon_location\":\"before\", \"submit_button\":\"1\", \"submit_button_label\":\"Save\", \"save_button_class\":\"btn-primary\", \"save_icon\":\"\", \"save_icon_location\":\"before\", \"submit_on_enter\":\"0\", \"labels_above\":\"0\", \"labels_above_details\":\"0\", \"pdf_template\":\"admin\", \"pdf_orientation\":\"portrait\", \"pdf_size\":\"letter\", \"show_title\":\"1\", \"print\":\"\", \"email\":\"\", \"pdf\":\"\", \"admin_form_template\":\"\", \"admin_details_template\":\"\", \"note\":\"\", \"show_referring_table_releated_data\":\"0\", \"tiplocation\":\"tip\", \"process_jplugins\":\"2\", \"ajax_validations\":\"0\", \"ajax_validations_toggle_submit\":\"0\", \"submit_success_msg\":\"\", \"suppress_msgs\":\"0\", \"show_loader_on_submit\":\"0\", \"spoof_check\":\"1\", \"multipage_save\":\"0\" }' """ + ");" #print(s_sql) # DEBUG s_sql = s_sql.replace("%LABEL%", s_fli) s_sql = s_sql.replace("%CREATED_BY%", s_created_by) curs.execute(s_sql) cnxn.commit() funcfile.writelog("%t INSERT RECORD: " + s_dbi + "." + s_tbi + ":" + s_fli) # FORM DEFAULT PARAMETERS """ ( 38, 'TEST List', 1, 'Some parts of your form have not been correctly filled in', '', '2019-03-20 05:14:04', 842, 'Albertjvr', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Save', 'bootstrap', 'bootstrap', 1, 0, '{ \"outro\":\"\", \"reset_button\":\"0\", \"reset_button_label\":\"Reset\", \"reset_button_class\":\"btn-warning\", \"reset_icon\":\"\", \"reset_icon_location\":\"before\", \"copy_button\":\"0\", \"copy_button_label\":\"Save as copy\", \"copy_button_class\":\"\", \"copy_icon\":\"\", \"copy_icon_location\":\"before\", \"goback_button\":\"0\", \"goback_button_label\":\"Go back\", \"goback_button_class\":\"\", \"goback_icon\":\"\", \"goback_icon_location\":\"before\", \"apply_button\":\"0\", \"apply_button_label\":\"Apply\", \"apply_button_class\":\"\", \"apply_icon\":\"\", \"apply_icon_location\":\"before\", \"delete_button\":\"0\", \"delete_button_label\":\"Delete\", \"delete_button_class\":\"btn-danger\", \"delete_icon\":\"\", \"delete_icon_location\":\"before\", \"submit_button\":\"1\", \"submit_button_label\":\"Save\", \"save_button_class\":\"btn-primary\", \"save_icon\":\"\", \"save_icon_location\":\"before\", \"submit_on_enter\":\"0\", \"labels_above\":\"0\", \"labels_above_details\":\"0\", \"pdf_template\":\"admin\", \"pdf_orientation\":\"portrait\", \"pdf_size\":\"letter\", \"show_title\":\"1\", \"print\":\"\", \"email\":\"\", \"pdf\":\"\", \"admin_form_template\":\"\", \"admin_details_template\":\"\", \"note\":\"\", \"show_referring_table_releated_data\":\"0\", \"tiplocation\":\"tip\", \"process_jplugins\":\"2\", \"ajax_validations\":\"0\", \"ajax_validations_toggle_submit\":\"0\", \"submit_success_msg\":\"\", \"suppress_msgs\":\"0\", \"show_loader_on_submit\":\"0\", \"spoof_check\":\"1\", \"multipage_save\":\"0\" }' ); """ # GET NEWLY CREATED FORM NUMBER curs.execute("SELECT " + s_tbi + ".id, " + s_tbi + ".label FROM " + s_tbi + " WHERE " + s_tbi + ".label = '" + s_fli + "'") for row in curs.fetchall(): print("Created list " + str(row[0])) funcfile.writelog("%t FORM CREATED: " + str(row[0])) i_return = row[0] # RETURN NEWLY CREATED FORM NUMBER return i_return
def Fabrik_listcreate(s_input="F", s_lb="New LIST to setup", s_fo="0", s_tt="0", s_kf="0", s_db="Web_ia_joomla", s_tb="ianwu_fabrik_lists"): """ PARAMETERS ************************************************************* s_input = F=do not ask parameters(default) T=ask parameters s_lb = List label s_db = Joomla database s_tb = Joomla table name *************************************************************************""" """ INDEX ****************************************************************** ENVIRONMENT INPUT OPEN DATABASE INSERT LIST RECORD *************************************************************************""" print("FABRIK CREATE LIST STEP 4") print("--------------------------") print("ENVIRONMENT") # IMPORT SYSTEM OBJECTS import sys # OWN MODULE PATH sys.path.append('S:/_my_modules') # IMPORT PYTHON OBJECTS import pyodbc # IMPORT FUNCTIONS import funcfile import funcmysql # DECLARE VARIABLES s_sql = "" s_created_by = "854" """************************************************************************* INPUT *************************************************************************""" print("INPUT") # INPUT THE JOOMLA MYSQL FABRIK DATABASE NAME s_dbi = s_db if s_input == "T": print("") print("Default:" + s_db) s_dbi = input("Fabrik DATABASE name? ") if s_dbi == "": s_dbi = s_db # INPUT THE JOOMLA MYSQL TABLE NAME s_tbi = s_tb if s_input == "T": print("") print("Default:" + s_tb) s_tbi = input("Fabrik TABLE name? ") if s_tbi == "": s_tbi = s_tb # INPUT THE JOOMLA MYSQL FABRIK LIST LABEL s_lbi = s_lb if s_input == "T": print("") print("Default:" + s_lb) s_lbi = input("Fabrik LIST label? ") if s_lbi == "": s_lbi = s_lb print("") # INPUT THE JOOMLA MYSQL FABRIK FORM NUMBER s_foi = s_fo if s_input == "T" or s_foi == "0": print("") print("Default:" + s_fo) while s_foi == "" or s_foi == "0": s_foi = input("Fabrik FORM number? ") print("") # INPUT THE JOOMLA MYSQL FABRIK LIST TARGET TABLE NAME s_tti = s_tt if s_input == "T" or s_tti == "0": print("") print("Default:" + s_tt) while s_tti == "" or s_tti == "0": s_tti = input("Fabrik LIST target table name? ") print("") # INPUT THE JOOMLA MYSQL FABRIK LIST KEY FIELD s_kfi = s_kf if s_input == "T" or s_kfi == "0": print("") print("Default:" + s_kf) while s_kfi == "" or s_kfi == "0": s_kfi = input("Fabrik LIST key field? ") print("") """************************************************************************* OPEN DATABASE *************************************************************************""" print("OPEN DATABASE") funcfile.writelog("OPEN DATABASE") # Connect to the oracle database cnxn = funcmysql.mysql_open(s_dbi) curs = cnxn.cursor() funcfile.writelog("%t OPEN DATABASE: " + s_dbi) """************************************************************************* INSERT LIST RECORD *************************************************************************""" print("INSERT LIST RECORD") funcfile.writelog("INSERT LIST RECORD") # INSERT LIST RECORD s_sql = "INSERT INTO `" + s_tbi + "` (" + """ `label`, `introduction`, `form_id`, `db_table_name`, `db_primary_key`, `auto_inc`, `connection_id`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `published`, `publish_up`, `publish_down`, `access`, `hits`, `rows_per_page`, `template`, `order_by`, `order_dir`, `filter_action`, `group_by`, `private`, `params` """ + ") VALUES (" + """ '%LABEL%', '', %FORM%, '%TABLE_TARGET%', '%TABLE_TARGET%.%KEY_FIELD%', 1, 2, NOW(), %CREATED_BY%, 'Python', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 10, 'bootstrap', '[\"\"]', '[\"ASC\"]', 'onchange', '', 0, '{ \"show-table-filters\":\"1\", \"advanced-filter\":\"0\", \"advanced-filter-default-statement\":\"=\", \"search-mode\":\"0\", \"search-mode-advanced\":\"0\", \"search-mode-advanced-default\":\"all\", \"search_elements\":\"\", \"list_search_elements\":\"null\", \"search-all-label\":\"All\", \"require-filter\":\"0\", \"filter-dropdown-method\":\"0\", \"toggle_cols\":\"0\", \"list_filter_cols\":\"1\", \"empty_data_msg\":\"\", \"outro\":\"\", \"list_ajax\":\"0\", \"show-table-add\":\"1\", \"show-table-nav\":\"1\", \"show_displaynum\":\"1\", \"showall-records\":\"1\", \"show-total\":\"1\", \"sef-slug\":\"\", \"show-table-picker\":\"1\", \"admin_template\":\"\", \"show-title\":\"1\", \"pdf\":\"\", \"pdf_template\":\"\", \"pdf_orientation\":\"portrait\", \"pdf_size\":\"a4\", \"bootstrap_stripped_class\":\"1\", \"bootstrap_bordered_class\":\"0\", \"bootstrap_condensed_class\":\"1\", \"bootstrap_hover_class\":\"1\", \"responsive_elements\":\"\", \"responsive_class\":\"\", \"list_responsive_elements\":\"null\", \"tabs_field\":\"\", \"tabs_max\":\"10\", \"tabs_all\":\"1\", \"list_ajax_links\":\"0\", \"actionMethod\":\"default\", \"detailurl\":\"\", \"detaillabel\":\"\", \"list_detail_link_icon\":\"search\", \"list_detail_link_target\":\"_self\", \"editurl\":\"\",\"editlabel\":\"\", \"list_edit_link_icon\":\"edit\", \"checkboxLocation\":\"end\", \"addurl\":\"\", \"addlabel\":\"\", \"list_add_icon\":\"plus\", \"list_delete_icon\":\"delete\", \"popup_width\":\"\", \"popup_height\":\"\", \"popup_offset_x\":\"\", \"popup_offset_y\":\"\", \"note\":\"\", \"alter_existing_db_cols\":\"default\", \"process-jplugins\":\"1\", \"cloak_emails\":\"0\", \"enable_single_sorting\":\"default\", \"collation\":\"utf8_general_ci\", \"force_collate\":\"\", \"list_disable_caching\":\"0\", \"distinct\":\"1\", \"group_by_raw\":\"1\", \"group_by_access\":\"1\", \"group_by_order\":\"\", \"group_by_template\":\"\", \"group_by_order_dir\":\"ASC\", \"group_by_start_collapsed\":\"0\", \"group_by_collapse_others\":\"0\", \"group_by_show_count\":\"1\", \"menu_module_prefilters_override\":\"1\", \"prefilter_query\":\"\", \"join-display\":\"default\", \"delete-joined-rows\":\"0\", \"show_related_add\":\"0\", \"show_related_info\":\"0\", \"rss\":\"0\", \"feed_title\":\"\", \"feed_date\":\"\", \"feed_image_src\":\"\", \"rsslimit\":\"150\", \"rsslimitmax\":\"2500\", \"csv_import_frontend\":\"3\", \"csv_export_frontend\":\"2\", \"csvfullname\":\"0\", \"csv_export_step\":\"100\", \"newline_csv_export\":\"nl2br\", \"csv_clean_html\":\"leave\", \"csv_custom_qs\":\"\", \"csv_frontend_selection\":\"0\", \"incfilters\":\"0\",\"csv_format\":\"0\", \"csv_which_elements\":\"selected\", \"show_in_csv\":\"\", \"csv_elements\":\"null\", \"csv_include_data\":\"1\", \"csv_include_raw_data\":\"1\", \"csv_include_calculations\":\"0\", \"csv_filename\":\"\", \"csv_encoding\":\"\", \"csv_double_quote\":\"1\", \"csv_local_delimiter\":\"\", \"csv_end_of_line\":\"n\", \"open_archive_active\":\"0\", \"open_archive_set_spec\":\"\", \"open_archive_timestamp\":\"\", \"open_archive_license\":\"http:\\/\\/creativecommons.org\\/licenses\\/by-nd\\/2.0\\/rdf\", \"dublin_core_element\":\"\", \"dublin_core_type\":\"dc:description.abstract\", \"raw\":\"0\", \"open_archive_elements\":\"null\", \"search_use\":\"0\", \"search_title\":\"\", \"search_description\":\"\", \"search_date\":\"\", \"search_link_type\":\"details\", \"dashboard\":\"0\", \"dashboard_icon\":\"\", \"allow_view_details\":\"1\", \"allow_edit_details\":\"1\", \"allow_edit_details2\":\"\", \"allow_add\":\"1\", \"allow_delete\":\"2\", \"allow_delete2\":\"\", \"allow_drop\":\"3\", \"isview\":\"0\" }' """ + ");" print(s_sql) # DEBUG s_sql = s_sql.replace("%LABEL%", s_lbi) s_sql = s_sql.replace("%CREATED_BY%", s_created_by) s_sql = s_sql.replace("%FORM%", s_foi) s_sql = s_sql.replace("%TABLE_TARGET%", s_tti) s_sql = s_sql.replace("%KEY_FIELD%", s_kfi) print(s_sql) # DEBUG curs.execute(s_sql) cnxn.commit() funcfile.writelog("%t INSERT RECORD: " + s_dbi + "." + s_tbi + ": " + s_lbi) # LIST DEFAULT PARAMETERS """ (38, 'TEST List', '', 38, 'ia_finding_6', 'ia_finding_6.ia_find_auto', 1, 2, '2019-03-19 22:00:00', 0, '', '2019-03-20 05:14:28', 842, 0, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, 10, 'bootstrap', '[\"\"]', '[\"ASC\"]', 'onchange', '', 0, '{ \"show-table-filters\":\"1\", \"advanced-filter\":\"0\", \"advanced-filter-default-statement\":\"=\", \"search-mode\":\"0\", \"search-mode-advanced\":\"0\", \"search-mode-advanced-default\":\"all\", \"search_elements\":\"\", \"list_search_elements\":\"null\", \"search-all-label\":\"All\", \"require-filter\":\"0\", \"filter-dropdown-method\":\"0\", \"toggle_cols\":\"0\", \"list_filter_cols\":\"1\", \"empty_data_msg\":\"\", \"outro\":\"\", \"list_ajax\":\"0\", \"show-table-add\":\"1\", \"show-table-nav\":\"1\", \"show_displaynum\":\"1\", \"showall-records\":\"0\", \"show-total\":\"0\", \"sef-slug\":\"\", \"show-table-picker\":\"1\", \"admin_template\":\"\", \"show-title\":\"1\", \"pdf\":\"\", \"pdf_template\":\"\", \"pdf_orientation\":\"portrait\", \"pdf_size\":\"a4\", \"bootstrap_stripped_class\":\"1\", \"bootstrap_bordered_class\":\"0\", \"bootstrap_condensed_class\":\"0\", \"bootstrap_hover_class\":\"1\", \"responsive_elements\":\"\", \"responsive_class\":\"\", \"list_responsive_elements\":\"null\", \"tabs_field\":\"\", \"tabs_max\":\"10\", \"tabs_all\":\"1\", \"list_ajax_links\":\"0\", \"actionMethod\":\"default\", \"detailurl\":\"\", \"detaillabel\":\"\", \"list_detail_link_icon\":\"search\", \"list_detail_link_target\":\"_self\", \"editurl\":\"\",\"editlabel\":\"\", \"list_edit_link_icon\":\"edit\", \"checkboxLocation\":\"end\", \"addurl\":\"\", \"addlabel\":\"\", \"list_add_icon\":\"plus\", \"list_delete_icon\":\"delete\", \"popup_width\":\"\", \"popup_height\":\"\", \"popup_offset_x\":\"\", \"popup_offset_y\":\"\", \"note\":\"\", \"alter_existing_db_cols\":\"default\", \"process-jplugins\":\"1\", \"cloak_emails\":\"0\", \"enable_single_sorting\":\"default\", \"collation\":\"utf8_general_ci\", \"force_collate\":\"\", \"list_disable_caching\":\"0\", \"distinct\":\"1\", \"group_by_raw\":\"1\", \"group_by_access\":\"1\", \"group_by_order\":\"\", \"group_by_template\":\"\", \"group_by_order_dir\":\"ASC\", \"group_by_start_collapsed\":\"0\", \"group_by_collapse_others\":\"0\", \"group_by_show_count\":\"1\", \"menu_module_prefilters_override\":\"1\", \"prefilter_query\":\"\", \"join-display\":\"default\", \"delete-joined-rows\":\"0\", \"show_related_add\":\"0\", \"show_related_info\":\"0\", \"rss\":\"0\", \"feed_title\":\"\", \"feed_date\":\"\", \"feed_image_src\":\"\", \"rsslimit\":\"150\", \"rsslimitmax\":\"2500\", \"csv_import_frontend\":\"3\", \"csv_export_frontend\":\"2\", \"csvfullname\":\"0\", \"csv_export_step\":\"100\", \"newline_csv_export\":\"nl2br\", \"csv_clean_html\":\"leave\", \"csv_custom_qs\":\"\", \"csv_frontend_selection\":\"0\", \"incfilters\":\"0\",\"csv_format\":\"0\", \"csv_which_elements\":\"selected\", \"show_in_csv\":\"\", \"csv_elements\":\"null\", \"csv_include_data\":\"1\", \"csv_include_raw_data\":\"1\", \"csv_include_calculations\":\"0\", \"csv_filename\":\"\", \"csv_encoding\":\"\", \"csv_double_quote\":\"1\", \"csv_local_delimiter\":\"\", \"csv_end_of_line\":\"n\", \"open_archive_active\":\"0\", \"open_archive_set_spec\":\"\", \"open_archive_timestamp\":\"\", \"open_archive_license\":\"http:\\/\\/creativecommons.org\\/licenses\\/by-nd\\/2.0\\/rdf\", \"dublin_core_element\":\"\", \"dublin_core_type\":\"dc:description.abstract\", \"raw\":\"0\", \"open_archive_elements\":\"null\", \"search_use\":\"0\", \"search_title\":\"\", \"search_description\":\"\", \"search_date\":\"\", \"search_link_type\":\"details\", \"dashboard\":\"0\", \"dashboard_icon\":\"\", \"allow_view_details\":\"1\", \"allow_edit_details\":\"1\", \"allow_edit_details2\":\"\", \"allow_add\":\"1\", \"allow_delete\":\"2\", \"allow_delete2\":\"\", \"allow_drop\":\"3\", \"isview\":\"0\" }'); """ # GET NEWLY CREATED LIST NUMBER curs.execute("SELECT " + s_tbi + ".id, " + s_tbi + ".label FROM " + s_tbi + " WHERE " + s_tbi + ".label = '" + s_lbi + "'") for row in curs.fetchall(): print("Created list " + str(row[0])) funcfile.writelog("%t LIST CREATED: " + str(row[0])) i_return = row[0] # RETURN NEWLY CREATED GROUP NUMBER return i_return