def _convert_template_query_info_with_gsi(self, file_path, gsi_index_file_path = None, table_map= {}, table_name = "simple_table", define_gsi_index = True, gen_expected_result = False): helper = QueryHelper() f = open(gsi_index_file_path,'w') n1ql_queries = self._read_from_file(file_path) for n1ql_query in n1ql_queries: check = True if not helper._check_deeper_query_condition(n1ql_query): if "SUBQUERY" in n1ql_query: map = helper._convert_sql_template_to_value_with_subqueries( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes( n1ql_query, table_map = table_map, table_name = table_name, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries( n1ql_query, table_map = table_map, table_name = table_name, define_gsi_index= define_gsi_index) if gen_expected_result: query = map["sql"] try: sql_result = self._query_and_convert_to_json(query) map["expected_result"] = sql_result except Exception, ex: print ex check = False if check: f.write(json.dumps(map)+"\n")
def _convert_template_query_info(self, n1ql_queries=[], table_map={}, define_gsi_index=True, gen_expected_result=False, ansi_joins=False, aggregate_pushdown=False, partitioned_indexes=False): helper = QueryHelper() query_input_list = [] for n1ql_query in n1ql_queries: # check if ["UNION ALL", "INTERSECT ALL", "EXCEPT ALL", "UNION", "INTERSECT", "EXCEPT"] not in query if not helper._check_deeper_query_condition(n1ql_query): if "SUBTABLE" in n1ql_query: sql_n1ql_index_map = helper._convert_sql_template_to_value_with_subqueryenhancements(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) elif "SUBQUERY" in n1ql_query: sql_n1ql_index_map = helper._convert_sql_template_to_value_with_subqueries(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) else: # takes in sql and n1ql queries and create indexes for them sql_n1ql_index_map = helper._convert_sql_template_to_value_for_secondary_indexes(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index, ansi_joins=ansi_joins, aggregate_pushdown=aggregate_pushdown, partitioned_indexes=partitioned_indexes) else: sql_n1ql_index_map = helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index, partitioned_indexes=partitioned_indexes) if gen_expected_result: sql_query = sql_n1ql_index_map["sql"] try: sql_result = self._query_and_convert_to_json(sql_query) sql_n1ql_index_map["expected_result"] = sql_result except Exception, ex: print ex query_input_list.append(sql_n1ql_index_map)
def _convert_template_query_info_with_gsi(self, file_path, gsi_index_file_path=None, table_map={}, table_name="simple_table", define_gsi_index=True, gen_expected_result=False): helper = QueryHelper() f = open(gsi_index_file_path, 'w') n1ql_queries = self._read_from_file(file_path) for n1ql_query in n1ql_queries: check = True if not helper._check_deeper_query_condition(n1ql_query): if "SUBQUERY" in n1ql_query: map = helper._convert_sql_template_to_value_with_subqueries(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes(n1ql_query, table_map=table_map, table_name=table_name, define_gsi_index=define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries(n1ql_query, table_map=table_map, table_name=table_name, define_gsi_index=define_gsi_index) if gen_expected_result: query = map["sql"] try: sql_result = self._query_and_convert_to_json(query) map["expected_result"] = sql_result except Exception, ex: print ex check = False if check: f.write(json.dumps(map)+"\n")
def _convert_template_query_info(self, n1ql_queries=[], table_map={}, define_gsi_index=True, gen_expected_result=False, ansi_joins=False, aggregate_pushdown=False): helper = QueryHelper() query_input_list = [] for n1ql_query in n1ql_queries: # check if ["UNION ALL", "INTERSECT ALL", "EXCEPT ALL", "UNION", "INTERSECT", "EXCEPT"] not in query if not helper._check_deeper_query_condition(n1ql_query): if "SUBTABLE" in n1ql_query: sql_n1ql_index_map = helper._convert_sql_template_to_value_with_subqueryenhancements(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) elif "SUBQUERY" in n1ql_query: sql_n1ql_index_map = helper._convert_sql_template_to_value_with_subqueries(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) else: # takes in sql and n1ql queries and create indexes for them sql_n1ql_index_map = helper._convert_sql_template_to_value_for_secondary_indexes(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index, ansi_joins=ansi_joins, aggregate_pushdown=aggregate_pushdown) else: sql_n1ql_index_map = helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries(n1ql_query, table_map=table_map, define_gsi_index=define_gsi_index) if gen_expected_result: sql_query = sql_n1ql_index_map["sql"] try: sql_result = self._query_and_convert_to_json(sql_query) sql_n1ql_index_map["expected_result"] = sql_result except Exception, ex: print ex query_input_list.append(sql_n1ql_index_map)
def _convert_template_query_info(self, n1ql_queries = [], table_map= {}, define_gsi_index = True, gen_expected_result = False): helper = QueryHelper() query_input_list = [] for n1ql_query in n1ql_queries: check = True if not helper._check_deeper_query_condition(n1ql_query): if "SUBTABLE" in n1ql_query: map = helper._convert_sql_template_to_value_with_subqueryenhancements( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) elif "SUBQUERY" in n1ql_query : map = helper._convert_sql_template_to_value_with_subqueries( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) if gen_expected_result: query = map["sql"] try: sql_result = self._query_and_convert_to_json(query) map["expected_result"] = sql_result except Exception, ex: print ex check = False query_input_list.append(map)
def _convert_template_query_info(self, n1ql_queries = [], table_map= {}, define_gsi_index = True, gen_expected_result = False): helper = QueryHelper() query_input_list = [] for n1ql_query in n1ql_queries: check = True if not helper._check_deeper_query_condition(n1ql_query): if "SUBQUERY" in n1ql_query: map = helper._convert_sql_template_to_value_with_subqueries( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) else: map=helper._convert_sql_template_to_value_for_secondary_indexes_sub_queries( n1ql_query, table_map = table_map, define_gsi_index= define_gsi_index) if gen_expected_result: query = map["sql"] try: sql_result = self._query_and_convert_to_json(query) map["expected_result"] = sql_result except Exception, ex: print ex check = False query_input_list.append(map)