Exemplo n.º 1
0
def test_expand_environment_variables_in_connection():
    os.environ["DATABASE_URL"] = "postgresql:///shakes"
    assert parse("$DATABASE_URL SELECT * FROM work", empty_config) == {
        "connection": "postgresql:///shakes",
        "sql": "SELECT * FROM work",
        "result_var": None,
    }
Exemplo n.º 2
0
def test_parse_with_sql():
    assert parse(
        "postgresql://*****:*****@localhost/shakes SELECT * FROM work",
        empty_config,
    ) == {
        "connection": "postgresql://*****:*****@localhost/shakes",
        "sql": "SELECT * FROM work",
        "result_var": None,
    }
Exemplo n.º 3
0
def test_parse_no_sql():
    assert parse("will:longliveliz@localhost/shakes", empty_config) == \
           {'connection': "will:longliveliz@localhost/shakes",
            'sql': '',
            'result_var': None}
Exemplo n.º 4
0
def test_expand_environment_variables_in_connection():
    os.environ['DATABASE_URL'] = 'postgresql:///shakes'
    assert parse("$DATABASE_URL SELECT * FROM work", empty_config) == \
            {'connection': "postgresql:///shakes",
            'sql': 'SELECT * FROM work',
            'flags': default_flags}
Exemplo n.º 5
0
def test_parse_postgresql_socket_connection():
    assert parse("postgresql:///shakes SELECT * FROM work", empty_config) == \
           {'connection': "postgresql:///shakes",
            'sql': 'SELECT * FROM work'}            
Exemplo n.º 6
0
def test_parse_with_sql():
    assert parse("postgresql://*****:*****@localhost/shakes SELECT * FROM work", 
                 empty_config) == \
           {'connection': "postgresql://*****:*****@localhost/shakes",
            'sql': 'SELECT * FROM work'}    
Exemplo n.º 7
0
def test_parse_shovel_operator():
    assert parse("dest << SELECT * FROM work", empty_config) == \
           {'connection': "",
            'sql': 'SELECT * FROM work',
            'result_var': "dest"}
Exemplo n.º 8
0
def test_parse_postgresql_socket_connection():
    assert parse("postgresql:///shakes SELECT * FROM work", empty_config) == \
           {'connection': "postgresql:///shakes",
            'sql': 'SELECT * FROM work',
            'result_var': None}
Exemplo n.º 9
0
def test_parse_sql_only():
    assert parse("SELECT * FROM work") == \
           {'connection': "",
            'sql': 'SELECT * FROM work'} 
Exemplo n.º 10
0
def test_parse_connect_plus_shovel():
    assert parse("sqlite:// dest << SELECT * FROM work", empty_config) == {
        "connection": "sqlite://",
        "sql": "SELECT * FROM work",
        "result_var": "dest",
    }
Exemplo n.º 11
0
def test_parse_shovel_operator():
    assert parse("dest << SELECT * FROM work", empty_config) == {
        "connection": "",
        "sql": "SELECT * FROM work",
        "result_var": "dest",
    }
Exemplo n.º 12
0
def test_parse_postgresql_socket_connection():
    assert parse("postgresql:///shakes SELECT * FROM work", empty_config) == {
        "connection": "postgresql:///shakes",
        "sql": "SELECT * FROM work",
        "result_var": None,
    }
Exemplo n.º 13
0
def test_parse_sql_only():
    assert parse("SELECT * FROM work", empty_config) == {
        "connection": "",
        "sql": "SELECT * FROM work",
        "result_var": None,
    }
Exemplo n.º 14
0
def test_parse_with_sql():
    assert parse("postgresql://*****:*****@localhost/shakes SELECT * FROM work",
                 empty_config) == \
           {'connection': "postgresql://*****:*****@localhost/shakes",
            'sql': 'SELECT * FROM work',
            'result_var': None}
Exemplo n.º 15
0
def test_parse_postgresql_socket_connection():
    assert parse("postgresql:///shakes SELECT * FROM work") == \
           {'connection': "postgresql:///shakes",
            'sql': 'SELECT * FROM work'}            
Exemplo n.º 16
0
def test_parse_sql_only():
    assert parse("SELECT * FROM work", empty_config) == \
           {'connection': "",
            'sql': 'SELECT * FROM work',
            'result_var': None}
Exemplo n.º 17
0
def test_parse_no_sql():
    assert parse("will:longliveliz@localhost/shakes") == \
           {'connection': "will:longliveliz@localhost/shakes",
            'sql': ''}
Exemplo n.º 18
0
def test_expand_environment_variables_in_connection():
    os.environ['DATABASE_URL'] = 'postgresql:///shakes'
    assert parse("$DATABASE_URL SELECT * FROM work", empty_config) == \
           {'connection': "postgresql:///shakes",
            'sql': 'SELECT * FROM work',
            'result_var': None}
Exemplo n.º 19
0
def test_parse_with_sql():
    assert parse("postgresql://*****:*****@localhost/shakes SELECT * FROM work") == \
           {'connection': "postgresql://*****:*****@localhost/shakes",
            'sql': 'SELECT * FROM work'}    
Exemplo n.º 20
0
def test_parse_connect_plus_shovel():
    assert parse("sqlite:// dest << SELECT * FROM work", empty_config) == \
           {'connection': "sqlite://",
            'sql': 'SELECT * FROM work',
            'result_var': "dest"}
Exemplo n.º 21
0
def test_parse_no_sql():
    assert parse("will:longliveliz@localhost/shakes", empty_config) == \
           {'connection': "will:longliveliz@localhost/shakes",
            'sql': '',
            'flags': default_flags}
Exemplo n.º 22
0
def test_parse_sql_only():
    assert parse("SELECT * FROM work", empty_config) == \
           {'connection': "",
            'sql': 'SELECT * FROM work'} 
Exemplo n.º 23
0
def test_parse_sql_only():
    assert parse("SELECT * FROM work", empty_config) == \
           {'connection': "",
            'sql': 'SELECT * FROM work',
            'flags': default_flags}
Exemplo n.º 24
0
def test_parse_no_sql():
    assert parse("will:longliveliz@localhost/shakes", empty_config) == \
           {'connection': "will:longliveliz@localhost/shakes",
            'sql': ''}
Exemplo n.º 25
0
def test_parse_no_sql():
    assert parse("will:longliveliz@localhost/shakes", empty_config) == {
        "connection": "will:longliveliz@localhost/shakes",
        "sql": "",
        "result_var": None,
    }