def test_set_pyodbc_master_connection_str(self): sqlbase = SQLBase(server_name=server_name, driver_name=driver_name) # Connects only to database called database_name conn_str = sqlbase._set_pyodbc_master_connection_str() conn_str_test = sqlbase.get_pyodbc_master_connection_str() conn_str_test2 = 'DRIVER={SQL Server Native Client 11.0}; SERVER=.\\DT_SQLEXPRESS; DATABASE=master; Trusted_Connection=yes;' self.assertEqual(conn_str, conn_str_test, conn_str_test2) return None
def test_set_pyodbc_master_connection_str(self): server_name = '.\DT_SQLEXPRESS' driver_name = 'SQL Server Native Client 11.0' path_mdf = r"C:\Users\z003vrzk\.spyder-py3\Scripts\Work\PanelBuilder\panel_builder\SQLTest\JHW\JobDB.mdf" path_ldf = r"C:\Users\z003vrzk\.spyder-py3\Scripts\Work\PanelBuilder\panel_builder\SQLTest\JHW\JobDB_Log.ldf" database_name = 'PBJobDB_test' sqlbase = SQLBase(server_name=server_name, driver_name=driver_name) # Connects only to database called database_name # Use connection string to execute SQL if needed conn_str = sqlbase._set_pyodbc_master_connection_str() conn_str_test = sqlbase.get_pyodbc_master_connection_str() conn_str_test2 = 'DRIVER={SQL Server Native Client 11.0}; SERVER=.\\DT_SQLEXPRESS; DATABASE=master; Trusted_Connection=yes;' self.assertEqual(conn_str, conn_str_test, conn_str_test2) return None