diff options
Diffstat (limited to 'test/dialect/mssql/test_engine.py')
| -rw-r--r-- | test/dialect/mssql/test_engine.py | 25 |
1 files changed, 13 insertions, 12 deletions
diff --git a/test/dialect/mssql/test_engine.py b/test/dialect/mssql/test_engine.py index 5482e2616..e14fd164a 100644 --- a/test/dialect/mssql/test_engine.py +++ b/test/dialect/mssql/test_engine.py @@ -32,26 +32,27 @@ from sqlalchemy.testing.mock import Mock class ParseConnectTest(fixtures.TestBase): def test_pyodbc_connect_dsn_trusted(self): dialect = pyodbc.dialect() - u = url.make_url("mssql://mydsn") + u = url.make_url("mssql+pyodbc://mydsn") connection = dialect.create_connect_args(u) eq_([["dsn=mydsn;Trusted_Connection=Yes"], {}], connection) def test_pyodbc_connect_old_style_dsn_trusted(self): dialect = pyodbc.dialect() - u = url.make_url("mssql:///?dsn=mydsn") + u = url.make_url("mssql+pyodbc:///?dsn=mydsn") connection = dialect.create_connect_args(u) eq_([["dsn=mydsn;Trusted_Connection=Yes"], {}], connection) def test_pyodbc_connect_dsn_non_trusted(self): dialect = pyodbc.dialect() - u = url.make_url("mssql://username:password@mydsn") + u = url.make_url("mssql+pyodbc://username:password@mydsn") connection = dialect.create_connect_args(u) eq_([["dsn=mydsn;UID=username;PWD=password"], {}], connection) def test_pyodbc_connect_dsn_extra(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://username:password@mydsn/?LANGUAGE=us_" "english&foo=bar" + "mssql+pyodbc://username:password@mydsn/?LANGUAGE=us_" + "english&foo=bar" ) connection = dialect.create_connect_args(u) dsn_string = connection[0][0] @@ -61,7 +62,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_hostname(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://username:password@hostspec/database?driver=SQL+Server" + "mssql+pyodbc://username:password@hostspec/database?driver=SQL+Server" # noqa ) connection = dialect.create_connect_args(u) eq_( @@ -84,7 +85,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_host_no_driver(self): dialect = pyodbc.dialect() - u = url.make_url("mssql://username:password@hostspec/database") + u = url.make_url("mssql+pyodbc://username:password@hostspec/database") def go(): return dialect.create_connect_args(u) @@ -111,7 +112,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_connect_comma_port(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://username:password@hostspec:12345/data" + "mssql+pyodbc://username:password@hostspec:12345/data" "base?driver=SQL Server" ) connection = dialect.create_connect_args(u) @@ -129,7 +130,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_connect_config_port(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://username:password@hostspec/database?p" + "mssql+pyodbc://username:password@hostspec/database?p" "ort=12345&driver=SQL+Server" ) connection = dialect.create_connect_args(u) @@ -147,7 +148,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_extra_connect(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://username:password@hostspec/database?L" + "mssql+pyodbc://username:password@hostspec/database?L" "ANGUAGE=us_english&foo=bar&driver=SQL+Server" ) connection = dialect.create_connect_args(u) @@ -186,7 +187,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_odbc_connect(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql:///?odbc_connect=DRIVER%3D%7BSQL+Server" + "mssql+pyodbc:///?odbc_connect=DRIVER%3D%7BSQL+Server" "%7D%3BServer%3Dhostspec%3BDatabase%3Ddatabase" "%3BUID%3Dusername%3BPWD%3Dpassword" ) @@ -205,7 +206,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_odbc_connect_with_dsn(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql:///?odbc_connect=dsn%3Dmydsn%3BDatabase" + "mssql+pyodbc:///?odbc_connect=dsn%3Dmydsn%3BDatabase" "%3Ddatabase%3BUID%3Dusername%3BPWD%3Dpassword" ) connection = dialect.create_connect_args(u) @@ -217,7 +218,7 @@ class ParseConnectTest(fixtures.TestBase): def test_pyodbc_odbc_connect_ignores_other_values(self): dialect = pyodbc.dialect() u = url.make_url( - "mssql://userdiff:passdiff@localhost/dbdiff?od" + "mssql+pyodbc://userdiff:passdiff@localhost/dbdiff?od" "bc_connect=DRIVER%3D%7BSQL+Server%7D%3BServer" "%3Dhostspec%3BDatabase%3Ddatabase%3BUID%3Duse" "rname%3BPWD%3Dpassword" |