Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

I'm trying to mock os.path.isdir. I've setting mock_os_path_isdir.return_value = False and don't expected execute shutil_rmtree

Rathnakar

 os_tests.py 

 import os
 from os import path
 import shutil


 def create_dir():
    dir = "/home/MOCK/_dir"
    if os.path.isdir(_dir):
      shutil.rmtree(_dir)



 import os
 import shutil
 from os_tests import create_dir 

 class Test_unittests(unittest.TestCase):


    @patch("os_tests.os.path.isdir")
    @patch("os_tests.shutil.rmtree")
    def test_create_dir_False(self, mock_os_path_isdir, mock_shutil_rmtree):
       mock_os_path_isdir.return_value = False
       create_dir()
       mock_shutil_rmtree.assert_not_called()

python3 unit02.py F. FAIL: test_create_dir_False (main.Test_unittests)

Traceback (most recent call last): File "/usr/lib/python3.8/unittest/mock.py", line 1325, in patched return func(*newargs, **newkeywargs) File "unit02.py", line 22, in test_create_dir_False mock_shutil_rmtree.assert_not_called() File "/usr/lib/python3.8/unittest/mock.py", line 874, in assert_not_called raise AssertionError(msg) AssertionError: Expected 'isdir' to not have been called. Called 1 times. Calls: [call('/home/MOCK/_dir'), call().bool()].

enter code here