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, 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(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)
