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
