def test_on_suggests_tables_and_join_conditions_right_side(sql):
suggestions = suggest_type(sql, sql)
tables = ((None, "abc", None, False), (None, "bcd", None, False))
assert set(suggestions) == {
JoinCondition(table_refs=tables, parent=None),
Alias(aliases=("abc", "bcd")),
}
def test_on_suggests_tables_and_join_conditions_right_side(sql):
suggestions = suggest_type(sql, sql)
tables = ((None, 'abc', None, False), (None, 'bcd', None, False))
assert set(suggestions) == set((
JoinCondition(table_refs=tables, parent=None),
Alias(aliases=(
'abc',
'bcd',
)),
))
def test_join_alias_dot_suggests_cols1(sql):
suggestions = suggest_type(sql, sql)
tables = ((None, 'abc', 'a', False), (None, 'def', 'd', False))
assert set(suggestions) == set([
Column(table_refs=((None, 'abc', 'a', False), )),
Table(schema='a'),
View(schema='a'),
Function(schema='a'),
JoinCondition(table_refs=tables, parent=(None, 'abc', 'a', False))
])
def test_join_alias_dot_suggests_cols1(sql):
suggestions = suggest_type(sql, sql)
tables = ((None, "abc", "a", False), (None, "def", "d", False))
assert set(suggestions) == set([
Column(table_refs=((None, "abc", "a", False), )),
Table(schema="a"),
View(schema="a"),
Function(schema="a"),
JoinCondition(table_refs=tables, parent=(None, "abc", "a", False)),
])
def test_on_suggests_aliases_and_join_conditions(sql):
suggestions = suggest_type(sql, sql)
assert set(suggestions) == set((
JoinCondition(tables=((None, 'abc', 'a', False), (None, 'bcd', 'b',
False)),
parent=None),
Alias(aliases=(
'a',
'b',
)),
))
def test_on_suggests_aliases_and_join_conditions(sql):
suggestions = suggest_type(sql, sql)
tables = ((None, "abc", "a", False), (None, "bcd", "b", False))
assert set(suggestions) == set(
(JoinCondition(table_refs=tables,
parent=None), Alias(aliases=("a", "b"))))
