def test_suggested_multiple_column_names_with_alias(completer, complete_event):
 text = u'SELECT p.id, p. from custom.products p'
 position = len(u'SELECT u.id, u.')
 result = set(completer.get_completions(Document(text=text, cursor_position=position), complete_event))
 assert (set(result) == set(testdata.columns(u'products', u'custom')))

def test_suggested_multiple_column_names_with_alias ( completer , complete_event ) : text = u'SELECT p.id, p. from custom.products p' position = len ( u'SELECT u.id, u.' ) result = set ( completer . get_completions ( Document ( text = text , cursor_position = position ) , complete_event ) ) assert ( set ( result ) == set ( testdata . columns ( u'products' , u'custom' ) ) )
suggest column names on table alias and dot when selecting multiple columns from table .