def start_grid_wise(self, sres, ijson, cmp_n): cm = ijson['cmp_id'] import modules.tablets.tablets as tb_api tb_obj = tb_api.Tablets() page_cords_dic = {} fs_info = [] for grid, cellinfo in sres.items(): #if '5131_101_2' not in grid:continue self.get_page_cords(grid.split('_'), cm, page_cords_dic) grid_info = tb_obj.create_inc_table_data(cm, grid, '') if not grid_info: continue doc, page, bgrid = grid.split('_') cc = self.get_cords_info(grid_info, cellinfo, grid.split('_')) if len(cc['slices']): #fs_info.append(cc) cpage_cord = {} cpage_cord.setdefault(doc, {})[page] = page_cords_dic.get( doc, {}).get(page, [0, 0, 0, 0]) fs_info.append({ "ref_path": { "ref_image": "/var_html_path/WorkSpaceBuilder_DB/34/1/pdata/docs/{0}/html_pages/{0}-page-{1}.png", "ref_html": "/var_html_path/WorkSpaceBuilder_DB/34/1/pdata/docs/{0}/html_output/{1}.html", "ref_pdf": "/var_html_path/WorkSpaceBuilder_DB/34/1/pdata/docs/{0}/pages/{1}.pdf", "ref_svg": "/var_html_path/WorkSpaceBuilder_DB/34/1/pdata/docs/{0}/html_pages/{0}-page-{1}.svg" }, "cards": cc, "page_cord": cpage_cord }) return [{'message': 'done', 'data': fs_info}]
def doc_indexing(self, info, cmp_id): import modules.tablets.tablets as tbs tbs_obj = tbs.Tablets() for doc, pageinfo in info.items(): indexing_info = [] for pagegrid, gg in pageinfo.items(): grid = '%s_%s' % (doc, pagegrid) grid_info = tbs_obj.create_inc_table_data(cmp_id, grid) self.update_index_info(grid_info, indexing_info, doc, pagegrid.split('_')) index_name = '%s_%s' % (cmp_id, doc) print[doc, cmp_id, doc] self.start_index(indexing_info, index_name)
def create_search_final_results_between(self, ijson): company_id = ijson['company_id'] doc_id = ijson['doc_id'] search_data = ijson['data'] search_res1, search_res2 = search_data tab_lets_path = config.Config.equality_path.format(company_id) db_path = os.path.join(tab_lets_path, '{0}.db'.format(doc_id)) conn, cur = conn_obj.sqlite_connection(db_path) grd_cell_grp_map, groupid_wise_data = self.read_rawdb_info(conn, cur) res_data = self.search_final_results_between(search_res1, search_res2, company_id, doc_id) import modules.tablets.tablets as mtt m_Obj = mtt.Tablets() data = m_Obj.get_search_traverse_path_result(company_id, doc_id, res_data) return data
def process(self, cmd_id, ijson): res = [] if 1 == cmd_id: res = self.validate_login(ijson) elif 2 == cmd_id: res = self.get_company_info_cid(ijson) elif 3 == cmd_id: res = self.read_docs(ijson) elif 4 == cmd_id: import tree_view_data_builder as pyf t_Obj = pyf.GridModel() res = t_Obj.read_rawdb_tree(ijson) elif 5 == cmd_id: import tree_view_data_builder as pyf t_Obj = pyf.GridModel() res = t_Obj.cell_id_reference(ijson) elif cmd_id == 6: #insert Model import model_api as ma ma_obj = ma.model_api() res = ma_obj.insert_model(ijson) elif cmd_id == 7: #read template import model_api as ma ma_obj = ma.model_api() res = ma_obj.read_templates(ijson) elif cmd_id == 8: #read sheets import model_api as ma ma_obj = ma.model_api() res = ma_obj.read_sheets(ijson) elif cmd_id == 9: #read sheet data import model_api as ma ma_obj = ma.model_api() res = ma_obj.sheet_gridinfo(ijson) elif 10 == cmd_id: import tree_view_data_builder as pyf t_Obj = pyf.GridModel() res = t_Obj.read_formula_cell_id(ijson) elif 11 == cmd_id: import child_parent as pyf t_Obj = pyf.GridModel() res = t_Obj.search_operation_data_flgs(ijson) elif 12 == cmd_id: import databuilder_info as pyf db_Obj = pyf.INC_DataBuilder() res = db_Obj.read_distinct_table_types(ijson) elif 13 == cmd_id: import databuilder_info as pyf db_Obj = pyf.INC_DataBuilder() res = db_Obj.save_classification_info(ijson) elif 14 == cmd_id: import databuilder_info as pyf db_Obj = pyf.INC_DataBuilder() res = db_Obj.multi_table_module_info(ijson) elif 15 == cmd_id: import databuilder_info as pyf db_Obj = pyf.INC_DataBuilder() res = db_Obj.insert_table_type_global(ijson) elif 16 == cmd_id: import databuilder_info as pyf db_obj = pyf.INC_DataBuilder() res = db_obj.doc_wise_well_connected_tables_ib(ijson) elif 17 == cmd_id: import databuilder_info as pyf db_obj = pyf.INC_DataBuilder() res = db_obj.data_according_to_table_id(ijson) elif 18 == cmd_id: import databuilder_info as pyf db_obj = pyf.INC_DataBuilder() res = db_obj.table_id_poss_with_across_docs(ijson) elif 19 == cmd_id: import databuilder_info as pyf db_obj = pyf.INC_DataBuilder() res = db_obj.read_well_collected_table_info(ijson) elif 20 == cmd_id: import databuilder_info as pyf db_obj = pyf.INC_DataBuilder() res = db_obj.read_realtion_between_tables(ijson) elif 21 == cmd_id: res = self.read_companies_from_company_mgmt() elif 22 == cmd_id: res = self.read_data_builder_companies() elif 23 == cmd_id: res = self.read_all_table_types(ijson) elif 24 == cmd_id: res = self.read_all_industry(ijson) elif 25 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.read_project_details(ijson) elif 26 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.read_taxo_data(ijson) elif 27 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.read_data_builder_data(ijson) elif 28 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.read_reference_info(ijson) elif 29 == cmd_id: #import spreadheet_builder as pyf #s_Obj = pyf.SpreadSheet() res = self.read_kpi_data_cgi(ijson) elif 30 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.read_raw_DB(ijson) elif 31 == cmd_id: import spreadheet_builder as pyf s_Obj = pyf.SpreadSheet() res = s_Obj.data_builder_reference(ijson) elif 32 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_company_list() elif 33 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_distinct_table_types_data(ijson) elif 34 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_document_meta_data(ijson) elif 35 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_grid_information(ijson) elif 36 == cmd_id: import modules.tablets.tablets as tablets s_Obj = tablets.Tablets() res = s_Obj.get_tablet_cell_ref(ijson) elif 37 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.save_hgh_scoping(ijson) elif cmd_id == 38: if ijson.get('user', '') == 'prashant': import modules.tablets.chain_tablet_v2 as v2 else: import modules.tablets.chain_tablet_v3 as v2 v2_obj = v2.chain() res = v2_obj.get_equlity_rows(ijson) elif cmd_id == 39: import modules.tablets.scoping_info as v2 v2_obj = v2.classify() res = v2_obj.get_classify_info(ijson) elif 40 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_all_tt(ijson) elif 41 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.save_gv_scoping(ijson) elif 42 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.add_table_types(ijson) elif 43 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() #res = s_obj.read_scoped_gvs(ijson) res = s_obj.read_scoped_gv_information(ijson) elif 4003 == cmd_id: import t_company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() #res = s_obj.read_scoped_gvs(ijson) res = s_obj.read_scoped_gv_information(ijson) elif cmd_id == 44: import modules.tablets.chain_tablet_v5 as v2 v2_obj = v2.chain() res = v2_obj.get_equlity_rows(ijson) elif cmd_id == 45: import modules.databuilder.form_builder as v2 v2_obj = v2.DataBuilder() res = v2_obj.form_triplet_data(ijson) elif 46 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.read_scoped_gv_information(ijson) elif 47 == cmd_id: res = self.get_search_result(ijson) elif 48 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.all_scoped_table_types(ijson) elif 49 == cmd_id: res = self.form_auto_db(ijson) elif 50 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.across_doc_DB(ijson) elif 1000 == cmd_id: import search_info as pyf s_obj = pyf.Search_Information() res = s_obj.create_search_infos_table_lets(ijson) elif 51 == cmd_id: import display_search_info as pyf s_obj = pyf.Searched_Data() res = s_obj.basic_search(ijson) elif 510 == cmd_id: import test_company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.test_read_grid_information(ijson) elif 52 == cmd_id: res = self.hardcoded_coldef(ijson) elif 53 == cmd_id: res = self.get_navigation_hops(ijson) elif 54 == cmd_id: #res = [{"message": "done", "data": [{"ref_k": ["5131_137_1", "", "3_1"], "k": 1, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 1}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 2, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 2}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 3, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 3}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 4, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 4}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 5, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 5}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 6, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 6}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 7, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 7}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 8, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 8}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 9, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 9}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 10, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 10}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 11, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 11}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 12, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 12}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 13, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 13}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 14, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 14}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 15, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 15}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 16, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 16}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 17, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 17}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 18, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 18}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 19, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 19}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 20, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 20}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 21, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 21}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 22, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 22}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 23, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 23}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 24, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 24}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 25, "data": [["ROOT", "5131_137_1", "3_1"], ["623", "10_1", ""]], "n": 25}, {"ref_k": ["5131_137_1", "", "3_1"], "k": 26, "data": [["ROOT", "5131_137_1", "3_1"], ["624", "10_1", ""]], "n": 26}]}] import warnings warnings.filterwarnings("ignore") import search_info as pyf s_obj = pyf.Search_Information() res = s_obj.create_search_final_results_between(ijson) elif 55 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.delete_scoped_gv(ijson) elif 56 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.read_tt_wise_docs(ijson) elif 57 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.read_most_ref_grids(ijson) elif 58 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_grid_information(ijson) elif 59 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_project_info(ijson) elif 60 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.get_traversed_details(ijson) elif 61 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.scoped_predictor_info(ijson) elif 62 == cmd_id: res = self.read_templates(ijson) elif 63 == cmd_id: res = self.read_template_sheets(ijson) elif 64 == cmd_id: res = self.read_template_sheet_data(ijson) elif 65 == cmd_id: res = self.insert_new_template(ijson) elif 66 == cmd_id: import company_mgmt_data as pyf s_obj = pyf.INC_Company_Mgmt() res = s_obj.across_doc_DB(ijson) elif cmd_id == 67: import n_exc_api as ex ex_obj = ex.exe() res = ex_obj.search_elm(ijson) elif cmd_id == 68: res = self.read_all_grids(ijson) elif cmd_id == 69: res = self.insert_taxo_row(ijson) elif 70 == cmd_id: if '_' in ijson['table_id']: ijson['table_id'] = '#'.join(ijson['table_id'].split('_')) import test_company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() #res = s_Obj.read_grid_information_spread_sheet(ijson) res = s_Obj.spread_sheet_table_data(ijson) elif 71 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_all_grids_doc_wise(ijson) elif cmd_id == 72: res = self.delete_map_ids(ijson) elif cmd_id == 73: res = self.get_lookup_value(ijson) elif 74 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_rawdb_tree(ijson) elif cmd_id == 101: import map_api ma_obj = map_api.exe() res = ma_obj.get_grid_info(ijson) elif cmd_id == 102: import map_api ma_obj = map_api.exe() res = ma_obj.read_grid_info_g(ijson) elif cmd_id == 103: import map_api ma_obj = map_api.exe() res = ma_obj.read_grid_info(ijson) elif cmd_id == 104: res = self.read_table_lets(ijson) elif cmd_id == 105: import map_api ma_obj = map_api.exe() res = ma_obj.get_eq_rows(ijson) elif cmd_id == 106: import map_api ma_obj = map_api.exe() res = ma_obj.read_table_ids(ijson) elif cmd_id == 107: import map_api ma_obj = map_api.exe() res = ma_obj.read_group_ids(ijson) elif cmd_id == 108: res = self.read_scope_taxo_info(ijson) elif cmd_id == 109: import map_api ma_obj = map_api.exe() res = ma_obj.read_databuilder_info(ijson) elif cmd_id == 110: import map_api ma_obj = map_api.exe() res = ma_obj.formula_info(ijson) elif cmd_id == 111: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() #res = s_Obj.get_count_tables(ijson) res = s_Obj.table_stats(ijson) elif cmd_id == 112: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_all_grids_doc_wise_no_grid_header(ijson) elif cmd_id == 113: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_data_builder_info(ijson) elif cmd_id == 114: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_db_ref_info(ijson) elif cmd_id == 115: res = self.con_insert_taxo_row(ijson) elif cmd_id == 116: import map_api ma_obj = map_api.exe() res = ma_obj.read_group_grid(ijson) elif 117 == cmd_id: res = self.read_template_grids(ijson) #res = self.read_template_taxo(ijson) elif cmd_id == 118: import map_api ma_obj = map_api.exe() res = ma_obj.read_db_muthu_info(ijson) elif cmd_id == 119: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.data_builder_stats(ijson) elif cmd_id == 120: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() #res = s_Obj.get_doc_table_stats(ijson) res = s_Obj.grids_get_doc_table_stats(ijson) elif cmd_id == 121: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.delete_scoped(ijson) elif cmd_id == 122: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_rem_rc_table(ijson) elif cmd_id == 123: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_global_table_type_info(ijson) elif cmd_id == 124: import template_configuration as pyf tc_Obj = pyf.TemplateConfig() res = tc_Obj.insert_output_config(ijson) elif cmd_id == 125: import template_configuration as pyf tc_Obj = pyf.TemplateConfig() res = tc_Obj.read_template_info(ijson) elif cmd_id == 126: import create_excel as pyf tc_Obj = pyf.excel() res = tc_Obj.cl_create(ijson) elif cmd_id == 127: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_doc_meta_data(ijson) elif cmd_id == 128: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_index_info(ijson) elif cmd_id == 129: import company_config as pyf s_Obj = pyf.CompanyInfo() res = s_Obj.get_company_data(ijson) elif cmd_id == 130: import t_company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.grid_color_info_label_taxo_check(ijson) elif cmd_id == 131: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.update_table_type(ijson) elif cmd_id == 132: import insert_rule_information as pyf s_Obj = pyf.RuleInfo() res = s_Obj.insert_rule_populate_info(ijson) elif cmd_id == 133: res = self.read_model_default(ijson) elif cmd_id == 134: import dashboard_populate_wrapper as pyf d_Obj = pyf.DashBoard() res = d_Obj.get_running_stats() elif cmd_id == 135: res = self.read_all_primary_keys(ijson) elif cmd_id == 136: res = self.write_grouped_primary_keys(ijson) elif cmd_id == 137: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.update_sheet_data(ijson) elif cmd_id == 138: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.read_sheet_col_data(ijson) elif cmd_id == 139: res = self.get_all_column_for_sheet(ijson) elif cmd_id == 140: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_data_type_info(ijson) elif cmd_id == 141: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.add_data_type_from_interface(ijson) elif cmd_id == 142: import sheet_info_create_txt as pyf s_Obj = pyf.SheetInfo() res = s_Obj.sheet_drop_down(ijson) elif cmd_id == 143: res = self.update_lookup_sheet_info(ijson) elif cmd_id == 144: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.update_document_meta_info(ijson) elif cmd_id == 145: import insert_rule_information as pyf s_Obj = pyf.RuleInfo() #res = s_Obj.insert_doc_populate_info(ijson) #res = s_Obj.insert_company_doc_mgmt(ijson) res = s_Obj.insert_company_doc_mgmt_page(ijson) elif cmd_id == 146: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.create_groups_tables(ijson) elif cmd_id == 147: import dashboard_populate_wrapper as pyf d_Obj = pyf.DashBoard() res = d_Obj.rule_stats(ijson) elif cmd_id == 148: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.generate_rules(ijson) elif cmd_id == 149: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.table_type_flag_grid_module(ijson) elif cmd_id == 150: import sheet_info_create_txt_external obj = sheet_info_create_txt_external.SheetInfo() res = obj.sheet_drop_down(ijson) elif cmd_id == 151: import dashboard_populate_wrapper as pyf d_Obj = pyf.DashBoard() res = d_Obj.doc_stats(ijson) elif cmd_id == 152: import modules.tablets.tablets as tablets s_Obj = tablets.Tablets() res = s_Obj.read_table_bbox(ijson) elif cmd_id == 153: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_group_tables(ijson) elif cmd_id == 154: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.stats_gh_hgh_vgh(ijson) elif cmd_id == 155: import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.read_scoped(ijson) elif cmd_id == 156: import warnings warnings.filterwarnings("ignore") import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.add_tables_to_scoped_group(ijson) elif cmd_id == 157: import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.add_sugg_to_scoped_tables(ijson) elif cmd_id == 158: import warnings warnings.filterwarnings("ignore") import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.delete_from_scoped_group(ijson) elif cmd_id == 159: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.non_scoped_groups(ijson) elif cmd_id == 160: import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.run_applicator(ijson) elif 161 == cmd_id: res = self.read_INC_json_multi_tables(ijson) elif 162 == cmd_id: res = self.filter_groups(ijson) elif 163 == cmd_id: import modules.databuilder.scope_info as v2 v2_obj = v2.Scope() res = v2_obj.run_app_for_all(ijson) elif 164 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.delete_taxo_tagged_tt(ijson) #import modules.databuilder.scope_info as v2 #v2_obj = v2.Scope() #res = v2_obj.reset_tagging(ijson) elif 165 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_class_doc_type_wise(ijson) elif 166 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.read_super_key_sugg(ijson) elif 167 == cmd_id: res = self.update_super_key(ijson) elif 168 == cmd_id: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_tt_wise_taxo_group(ijson) elif cmd_id == 169: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_db_ref_info_skey(ijson) elif 170 == cmd_id: res = self.update_super_key_builder(ijson) elif 171 == cmd_id: res = self.read_poss_builder(ijson) elif 172 == cmd_id: res = self.read_super_keymerge_poss(ijson) elif cmd_id == 173: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.table_column_data(ijson) elif 174 == cmd_id: res = self.read_super_key_poss(ijson) elif 175 == cmd_id: res = self.update_super_key_to_db_row(ijson) elif 176 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.map_group(ijson) elif 177 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.read_distinct_values(ijson) elif 178 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.link_sheets(ijson) elif 179 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.read_header_map_grp(ijson) elif cmd_id == 180: import altered_table_store as ats a_Obj = ats.AlteredTables() res = a_Obj.save_altered_tables(ijson) elif cmd_id == 181: import altered_table_store as ats a_Obj = ats.AlteredTables() res = a_Obj.read_modified_tables(ijson) elif 182 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.insert_exclude_rows(ijson) elif 183 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.map_preview(ijson) elif 184 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.read_lookup_value(ijson) elif cmd_id == 185: import error_table_stats as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.error_table_stats(ijson) elif cmd_id == 186: import error_table_stats as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.read_validation_error_rcs(ijson) elif cmd_id == 187: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.superkey_data_builder_info(ijson) elif 188 == cmd_id: import modules.template_mgmt.model_mapping as pyf s_Obj = pyf.Mapping() res = s_Obj.read_Error_Info(ijson) elif cmd_id == 189: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.read_distinct_taxo_group_id(ijson) elif cmd_id == 190: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.give_sk_poss_builder_info(ijson) elif cmd_id == 191: import company_mgmt_data as pyf s_Obj = pyf.INC_Company_Mgmt() res = s_Obj.tab_module_format(ijson) elif cmd_id == 192: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.read_fe_signature(ijson) elif 193 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.primary_key_match(ijson) elif 194 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.update_primary_key_match(ijson) elif cmd_id == 195: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.read_column_signature_stats(ijson) elif cmd_id == 196: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.create_save_db_row_ids_info(ijson) elif cmd_id == 197: import super_builder_info as pyf s_Obj = pyf.SuperBuilder() res = s_Obj.read_multi_DB_data_builder(ijson) elif cmd_id == 198: import read_populate_error_stats s_Obj = read_populate_error_stats.READSTATS() res = s_Obj.read_data(ijson) elif cmd_id == 199: import read_populate_error_stats s_Obj = read_populate_error_stats.READSTATS() res = s_Obj.err_highlight(ijson) elif cmd_id == 200: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = [{ "message": "done" }] #ma_obj.delete_model_data_cell_wise(ijson) elif cmd_id == 201: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.insert_sheet_old_template(ijson) pass elif cmd_id == 202: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.check_avail_name(ijson) elif cmd_id == 203: import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.check_avail_sname(ijson) elif cmd_id == 204: #read sheets import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.read_sheets(ijson) elif cmd_id == 205: #delete sheet import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.delete_sheets(ijson) elif cmd_id == 206: #sheet insert import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.insert_sheet_old_template_new_229(ijson) elif cmd_id == 207: #sheet insert import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.sheet_gridinfo(ijson) elif 208 == cmd_id: res = self.read_template_grids_info(ijson) elif cmd_id == 209: #read ref info import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.read_ref_info(ijson) elif cmd_id == 210: #read ref info import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.insert_lk_value_mgmt(ijson) elif cmd_id == 212: #read ref info import modules.template_mgmt.model_api as ma ma_obj = ma.model_api() res = ma_obj.import_from_global(ijson) elif cmd_id == 213: import modules.databuilder.form_builder_from_traverse_path as ma ma_obj = ma.DataBuilder() res = ma_obj.form_builder_from_files(ijson) elif cmd_id == 214: import modules.template_mgmt.store_re as ma ma_obj = ma.restore_api() res = ma_obj.read_info(ijson) elif cmd_id == 215: import modules.template_mgmt.store_re as ma ma_obj = ma.restore_api() res = ma_obj.insert_row(ijson) elif cmd_id == 216: import modules.template_mgmt.store_re as ma ma_obj = ma.restore_api() res = ma_obj.restore_data(ijson) elif cmd_id == 217: import modules.template_mgmt.store_re as ma ma_obj = ma.restore_api() res = ma_obj.delete_row(ijson) elif cmd_id == 218: import create_excel_v1 as pyf tc_Obj = pyf.excel() res = tc_Obj.cl_create(ijson) elif cmd_id == 219: import modules.template_mgmt.read_info as ma ma_obj = ma.model_api() res = ma_obj.sheet_gridinfo(ijson) elif 220 == cmd_id: res = self.read_super_keymerge_poss_all(ijson) elif 221 == cmd_id: res = self.read_builder_data_row_ids(ijson) elif cmd_id == 222: import create_model_info as pyf s_Obj = pyf.ModelInfo() res = s_Obj.output_model_info_structure(ijson) elif 223 == cmd_id: import modules.databuilder.form_builder_from_template as f_builder db_obj = f_builder.TaxoBuilder() res = db_obj.read_super_key_builder(ijson) elif cmd_id == 2061: #sheet insert import modules.template_mgmt.tmodel_api as ma ma_obj = ma.model_api() res = ma_obj.insert_sheet_old_template_new_229(ijson) return json.dumps(res)