def test_pymssql_port_setting(self): dialect = pymssql.dialect() u = url.make_url("mssql+pymssql://scott:tiger@somehost/test") connection = dialect.create_connect_args(u) eq_( [ [], { "host": "somehost", "password": "******", "user": "******", "database": "test", }, ], connection, ) u = url.make_url("mssql+pymssql://scott:tiger@somehost:5000/test") connection = dialect.create_connect_args(u) eq_( [ [], { "host": "somehost:5000", "password": "******", "user": "******", "database": "test", }, ], connection, )
def test_pymssql_port_setting(self): dialect = pymssql.dialect() u = url.make_url("mssql+pymssql://scott:tiger@somehost/test") connection = dialect.create_connect_args(u) eq_( [ [], { "host": "somehost", "password": "******", "user": "******", "database": "test", }, ], connection, ) u = url.make_url("mssql+pymssql://scott:tiger@somehost:5000/test") connection = dialect.create_connect_args(u) eq_( [ [], { "host": "somehost:5000", "password": "******", "user": "******", "database": "test", }, ], connection, )
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ 'Adaptive Server connection timed out', 'message 20003', "Error 10054", "Not connected to any MS SQL server", "Connection is closed" ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ 'Adaptive Server connection timed out', 'Net-Lib error during Connection reset by peer', 'message 20003', 'Error 10054', 'Not connected to any MS SQL server', 'Connection is closed' ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ 'Adaptive Server connection timed out', 'message 20003', "Error 10054", "Not connected to any MS SQL server", "Connection is closed" ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ 'Adaptive Server connection timed out', 'Net-Lib error during Connection reset by peer', 'message 20003', 'Error 10054', 'Not connected to any MS SQL server', 'Connection is closed' ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_mssql_where_clause_n_prefix(self): dialect = pymssql.dialect() spec = MssqlEngineSpec str_col = column('col', type_=spec.get_sqla_column_type('VARCHAR(10)')) unicode_col = column('unicode_col', type_=spec.get_sqla_column_type('NTEXT')) tbl = table('tbl') sel = select([str_col, unicode_col]).\ select_from(tbl).\ where(str_col == 'abc').\ where(unicode_col == 'abc') query = str(sel.compile(dialect=dialect, compile_kwargs={'literal_binds': True})) query_expected = "SELECT col, unicode_col \nFROM tbl \nWHERE col = 'abc' AND unicode_col = N'abc'" # noqa self.assertEqual(query, query_expected)
def test_dates( self, type_, args, kw, res, server_version, use_type_descriptor, driver ): "Exercise type specification for date types." if driver == "base": from sqlalchemy.dialects.mssql import base dialect = base.MSDialect() elif driver == "pyodbc": from sqlalchemy.dialects.mssql import pyodbc dialect = pyodbc.dialect() elif driver == "pymssql": from sqlalchemy.dialects.mssql import pymssql dialect = pymssql.dialect() else: assert False if server_version: dialect.server_version_info = server_version else: dialect.server_version_info = MS_2008_VERSION metadata = MetaData() typ = type_(*args, **kw) if use_type_descriptor: typ = dialect.type_descriptor(typ) col = Column("date_c", typ, nullable=None) date_table = Table("test_mssql_dates", metadata, col) gen = dialect.ddl_compiler(dialect, schema.CreateTable(date_table)) testing.eq_( gen.get_column_specification(col), "%s %s" % ( col.name, res, ), ) self.assert_(repr(col))
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ "Adaptive Server connection timed out", "Net-Lib error during Connection reset by peer", "message 20003", "Error 10054", "Not connected to any MS SQL server", "Connection is closed", "message 20006", # Write to the server failed "message 20017", # Unexpected EOF from the server "message 20047", # DBPROCESS is dead or not enabled ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_pymssql_disconnect(self): dialect = pymssql.dialect() for error in [ "Adaptive Server connection timed out", "Net-Lib error during Connection reset by peer", "message 20003", "Error 10054", "Not connected to any MS SQL server", "Connection is closed", "message 20006", # Write to the server failed "message 20017", # Unexpected EOF from the server "message 20047", # DBPROCESS is dead or not enabled ]: eq_(dialect.is_disconnect(error, None, None), True) eq_(dialect.is_disconnect("not an error", None, None), False)
def test_pymssql_port_setting(self): dialect = pymssql.dialect() u = \ url.make_url('mssql+pymssql://scott:tiger@somehost/test') connection = dialect.create_connect_args(u) eq_( [[], {'host': 'somehost', 'password': '******', 'user': '******', 'database': 'test'}], connection ) u = \ url.make_url('mssql+pymssql://scott:tiger@somehost:5000/test') connection = dialect.create_connect_args(u) eq_( [[], {'host': 'somehost:5000', 'password': '******', 'user': '******', 'database': 'test'}], connection )
def test_pymssql_port_setting(self): dialect = pymssql.dialect() u = \ url.make_url('mssql+pymssql://scott:tiger@somehost/test') connection = dialect.create_connect_args(u) eq_([[], { 'host': 'somehost', 'password': '******', 'user': '******', 'database': 'test' }], connection) u = \ url.make_url('mssql+pymssql://scott:tiger@somehost:5000/test') connection = dialect.create_connect_args(u) eq_([[], { 'host': 'somehost:5000', 'password': '******', 'user': '******', 'database': 'test' }], connection)