def test_suggested_cased_column_names_with_alias(cased_completer, complete_event):
 text = u'SELECT u.id, u. from users u'
 position = len(u'SELECT u.id, u.')
 result = set(cased_completer.get_completions(Document(text=text, cursor_position=position), complete_event))
 assert (set(result) == set(cased_users_cols))

def test_suggested_cased_column_names_with_alias ( cased_completer , complete_event ) : text = u'SELECT u.id, u. from users u' position = len ( u'SELECT u.id, u.' ) result = set ( cased_completer . get_completions ( Document ( text = text , cursor_position = position ) , complete_event ) ) assert ( set ( result ) == set ( cased_users_cols ) )
suggest column names on table alias and dot when selecting multiple columns from table .