Python fk_join Beispiele

Beispiel #1

Datei: test_smart_completion_public_schema_only.py Projekt: wxlg1117/pgcli

def test_suggested_join_conditions_with_same_table_twice(completer, text):
    result = get_result(completer, text)
    assert result == [
        fk_join('u2.userid = u.id'),
        fk_join('u2.userid = users.id'),
        name_join('u2.userid = "Users".userid'),
        name_join('u2.username = "******".username'),
        alias('u'),
        alias('u2'),
        alias('users'),
        alias('"Users"')
    ]

Beispiel #2

Datei: test_smart_completion_public_schema_only.py Projekt: alobaid/pgcli

def test_suggested_join_conditions_with_same_table_twice(completer, complete_event, text):
    position = len(text)
    result = completer.get_completions(
        Document(text=text, cursor_position=position),
        complete_event)
    assert result == [
        fk_join('u2.userid = u.id'),
        fk_join('u2.userid = users.id'),
        name_join('u2.userid = "Users".userid'),
        name_join('u2.username = "******".username'),
        alias('"Users"'),
        alias('u'),
        alias('u2'),
        alias('users')]

Beispiel #3

Datei: test_smart_completion_public_schema_only.py Projekt: LiuFang816/SALSTM_py_data

def test_suggested_join_conditions_with_same_table_twice(
        completer, complete_event, text):
    position = len(text)
    result = completer.get_completions(
        Document(text=text, cursor_position=position), complete_event)
    assert result == [
        fk_join('u2.userid = u.id'),
        fk_join('u2.userid = users.id'),
        name_join('u2.userid = "Users".userid'),
        name_join('u2.username = "******".username'),
        alias('u'),
        alias('u2'),
        alias('users'),
        alias('"Users"')
    ]

Beispiel #4

Datei: test_smart_completion_public_schema_only.py Projekt: thomasballinger/pgcli

def test_suggested_join_conditions(completer, complete_event, text):
    result = set(completer.get_completions(
        Document(text=text,), complete_event))
    assert set(result) == set([
        alias('U'),
        alias('U2'),
        fk_join('U2.userid = U.id')])

Beispiel #5

Datei: test_smart_completion_public_schema_only.py Projekt: thomasballinger/pgcli

def test_cased_join_conditions(cased_completer, complete_event, text):
    result = set(cased_completer.get_completions(
        Document(text=text), complete_event))
    assert set(result) == set([
        alias('U'),
        alias('U2'),
        fk_join('U2.UserID = U.ID')])

Beispiel #6

Datei: test_smart_completion_multiple_schemata.py Projekt: dbcli/pgcli

def test_suggested_join_conditions(completer, text):
    result = get_result(completer, text)
    assert completions_to_set(result) == completions_to_set([
        alias('users'),
        alias('shipments'),
        name_join('shipments.id = users.id'),
        fk_join('shipments.user_id = users.id')])

Beispiel #7

def test_suggested_join_conditions(completer, text):
    result = result_set(completer, text)
    assert result == set([
        alias('users'),
        alias('shipments'),
        name_join('shipments.id = users.id'),
        fk_join('shipments.user_id = users.id')])

Beispiel #8

def test_suggested_join_conditions(completer, text):
    result = get_result(completer, text)
    assert completions_to_set(result) == completions_to_set([
        alias("users"),
        alias("shipments"),
        name_join("shipments.id = users.id"),
        fk_join("shipments.user_id = users.id"),
    ])

Beispiel #9

Datei: test_smart_completion_public_schema_only.py Projekt: alobaid/pgcli

def test_suggested_join_conditions(completer, complete_event, text):
    position = len(text)
    result = set(completer.get_completions(
        Document(text=text, cursor_position=position),
        complete_event))
    assert set(result) == set([
        alias('u'),
        alias('u2'),
        fk_join('u2.userid = u.id')])

Beispiel #10

Datei: test_smart_completion_multiple_schemata.py Projekt: rjuju/pgcli

def test_suggested_join_conditions(completer, complete_event, text):
    position = len(text)
    result = set(completer.get_completions(
        Document(text=text, cursor_position=position),
        complete_event))
    assert set(result) == set([
        alias('users'),
        alias('shipments'),
        name_join('shipments.id = users.id'),
        fk_join('shipments.user_id = users.id')])

Beispiel #11

Datei: test_smart_completion_public_schema_only.py Projekt: wxlg1117/pgcli

def test_cased_join_conditions(completer, text):
    result = get_result(completer, text)
    assert completions_to_set(result) == completions_to_set(
        [alias('U'), alias('U2'), fk_join('U2.UserID = U.ID')]
    )

Beispiel #12

Datei: test_smart_completion_public_schema_only.py Projekt: wxlg1117/pgcli

def test_suggested_join_conditions(completer, text):
    result = get_result(completer, text)
    assert completions_to_set(result) == completions_to_set([
        alias('U'), alias('U2'), fk_join('U2.userid = U.id')
    ])

Beispiel #13

Datei: test_smart_completion_public_schema_only.py Projekt: piotrpawlaczek/pgcli

def test_cased_join_conditions(completer, text):
    result = result_set(completer, text)
    assert result == set(
        [alias('U'), alias('U2'), fk_join('U2.UserID = U.ID')]
    )

Beispiel #14

Datei: test_smart_completion_public_schema_only.py Projekt: piotrpawlaczek/pgcli

def test_suggested_join_conditions(completer, text):
    result = result_set(completer, text)
    assert result == set([
        alias('U'), alias('U2'), fk_join('U2.userid = U.id')
    ])

Beispiel #15

Datei: test_smart_completion_public_schema_only.py Projekt: arthurli1126/pgcli

def test_cased_join_conditions(completer, text):
    result = result_set(completer, text)
    assert result == set(
        [alias('U'), alias('U2'), fk_join('U2.UserID = U.ID')]
    )

Beispiel #16

Datei: test_smart_completion_public_schema_only.py Projekt: arthurli1126/pgcli

def test_suggested_join_conditions(completer, text):
    result = result_set(completer, text)
    assert result == set([
        alias('U'), alias('U2'), fk_join('U2.userid = U.id')
    ])