in 5-app-infra/3-artifact-publish/docker/cdmc/tag_engine_api/extensions/query_cookbook/summarize_sql/main.py [0:0]
def remove_false_positives(predictions, operation):
print('remove_false_positives')
print('predictions:', predictions)
if any(item == '' for item in predictions):
predictions.remove('')
if operation == 'FIELD':
if any(item == 'frequency' for item in predictions):
predictions.remove('frequency')
if any(item == 'select clause' for item in predictions):
predictions.remove('select clause')
if operation == 'WHERE':
if any(item == 'Where Clauses' for item in predictions):
predictions.remove('Where Clauses')
if any(item == 'Frequency' for item in predictions):
predictions.remove('Frequency')
if any(item == 'No WHERE clauses found' for item in predictions):
predictions.remove('No WHERE clauses found')
if any(item == 'Here are the most frequently occurring where clauses:' for item in predictions):
predictions.remove('Here are the most frequently occurring where clauses:')
if operation == 'FUNCTION':
if any(item == 'order by' for item in predictions):
predictions.remove('order by')
if any(item == 'group by' for item in predictions):
predictions.remove('group by')
if any(item == 'Frequency' for item in predictions):
predictions.remove('Frequency')
if any(item == 'Function' for item in predictions):
predictions.remove('Function')
if any(item == 'where' for item in predictions):
predictions.remove('where')
if operation == 'GROUP_BY':
if any(item == 'Frequency' for item in predictions):
predictions.remove('Frequency')
if any(item == 'Group By Clause' for item in predictions):
predictions.remove('Group By Clause')
if any(item == 'Rank' for item in predictions):
predictions.remove('Rank')
if operation == 'JOIN':
if any(item == 'FROM table_1 FULL JOIN table_2 ON table_1.column_name = table_2.column_name' for item in predictions):
predictions.remove('FROM table_1 FULL JOIN table_2 ON table_1.column_name = table_2.column_name')
if any(item == 'FROM table_1 JOIN table_2 ON table_1.column_name = table_2.column_name' for item in predictions):
predictions.remove('FROM table_1 JOIN table_2 ON table_1.column_name = table_2.column_name')
if any(item == 'FROM table_1 LEFT JOIN table_2 ON table_1.column_name = table_2.column_name' for item in predictions):
predictions.remove('FROM table_1 LEFT JOIN table_2 ON table_1.column_name = table_2.column_name')
if any(item == 'FROM table_1 RIGHT JOIN table_2 ON table_1.column_name = table_2.column_name' for item in predictions):
predictions.remove('FROM table_1 RIGHT JOIN table_2 ON table_1.column_name = table_2.column_name')
if any(item == 'No joins detected.' for item in predictions):
predictions.remove('No joins detected.')
if any(item == 'No joins were found in the query.' for item in predictions):
predictions.remove('No joins were found in the query.')
if any(item == 'Here are the most frequently occurring joins:' for item in predictions):
predictions.remove('Here are the most frequently occurring joins:')
if any(item == 'Here are the most frequent joins:' for item in predictions):
predictions.remove('Here are the most frequent joins:')
if any(item == 'The most frequently occurring join is "left outer join".' for item in predictions):
predictions.remove('The most frequently occurring join is "left outer join".')
if any(item == 'The most frequently occurring joins are:' for item in predictions):
predictions.remove('The most frequently occurring joins are:')
if any(item == 'The most frequent joins are:' for item in predictions):
predictions.remove('The most frequent joins are:')
if any(item == 'Join' for item in predictions):
predictions.remove('Join')
if any(item == 'ON' for item in predictions):
predictions.remove('ON')
if any(item == 'FROM' for item in predictions):
predictions.remove('FROM')
if any(item == 'WHERE' for item in predictions):
predictions.remove('WHERE')
if any(item == '```' for item in predictions):
predictions.remove('```')
if any(item == 'JOIN' for item in predictions):
predictions.remove('JOIN')
if any(item == 'INNER JOIN' for item in predictions):
predictions.remove('INNER JOIN')
if any(item == 'LEFT JOIN' for item in predictions):
predictions.remove('LEFT JOIN')
if any(item == 'LEFT OUTER JOIN' for item in predictions):
predictions.remove('LEFT OUTER JOIN')
if any(item == 'RIGHT JOIN' for item in predictions):
predictions.remove('RIGHT JOIN')
if any(item == 'RIGHT OUTER JOIN' for item in predictions):
predictions.remove('RIGHT OUTER JOIN')
if any(item == 'FULL JOIN' for item in predictions):
predictions.remove('FULL JOIN')
if any(item == 'FULL OUTER JOIN' for item in predictions):
predictions.remove('FULL OUTER JOIN')
if any(item == 'CROSS JOIN' for item in predictions):
predictions.remove('CROSS JOIN')
if any(item == 'NATURAL JOIN' for item in predictions):
predictions.remove('NATURAL JOIN')
if any(item == 'NATURAL LEFT JOIN' for item in predictions):
predictions.remove('NATURAL LEFT JOIN')
if any(item == 'NATURAL RIGHT JOIN' for item in predictions):
predictions.remove('NATURAL RIGHT JOIN')
if any(item == 'NATURAL FULL JOIN' for item in predictions):
predictions.remove('NATURAL FULL JOIN')
if any(item == 'NATURAL LEFT OUTER JOIN' for item in predictions):
predictions.remove('NATURAL LEFT OUTER JOIN')
if any(item == 'NATURAL RIGHT OUTER JOIN' for item in predictions):
predictions.remove('NATURAL RIGHT OUTER JOIN')
if any(item == 'NATURAL FULL OUTER JOIN' for item in predictions):
predictions.remove('NATURAL FULL OUTER JOIN')
if any(item == '`left outer join`' for item in predictions):
predictions.remove('`left outer join`')
if any(item == '`join`' for item in predictions):
predictions.remove('`join`')
if any(item == '`full join`' for item in predictions):
predictions.remove('`full join`')
if any(item == '`cross join`' for item in predictions):
predictions.remove('`cross join`')
if any(item == '`right outer join`' for item in predictions):
predictions.remove('`right outer join`')
if any(item == '`using`' for item in predictions):
predictions.remove('`using`')
return predictions