def test_add_project_failure_wrong_project_type(self, mocksql, inputs):
inputs.side_effect = ['', 'invalid type', '@@@', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = [0]
assert BDO(mocksql).add_project() == False
def test_calculate_wage_success(self, mocksql, arg2):
""" Test calculate wage method."""
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = ['12-12-2020']
assert BDO(mocksql).calculate_wage(1, 1) == True
def test_show_gpm_success_without_data(self, mocksql):
""" Test show gpm method."""
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = []
assert BDO(mocksql).show_gpm() == True
def test_add_project_action_failure_sqlite3_error(self, mocksql):
""" Test add project action method."""
mocksql.execute.side_effect = sqlite3.DataError
assert BDO(mocksql).add_project_action('test', '', '', '', '',
'01-01-2020',
'10-01-2020') == False
def test_update_project_action_failure_value_error(self, mocksql):
""" Test update project action method."""
mocksql.execute.side_effect = ValueError
assert BDO(mocksql).update_project_action('12-12-2010', '12-01-2020',
'a', 'a', 'a', 'a',
'a') == False
def test_update_project_action_success(self, mocksql):
""" Test update project action method."""
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
assert BDO(mocksql).update_project_action('12-12-2019', '12-01-2020',
'a', 'a', 'a', 'a',
'a') == True
def test_update_gpm_success(self, arg1, mocksql, inputs):
""" Test update gpm method."""
inputs.side_effect = ['*****@*****.**', '', '', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = single_gpm_data
assert BDO(mocksql).update_gpm() == True
def test_update_project_failure_invalid_state(self, arg1, mocksql, inputs):
""" Test update project method."""
inputs.side_effect = ['project', '', '', '@@@', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.side_effect = [project_data_2, [0]]
assert BDO(mocksql).update_project() == False
def test_update_project_success(self, arg1, mocksql, inputs):
""" Test update project method."""
inputs.side_effect = ['project', '', '', '', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.side_effect = [project_data_2, [0]]
assert BDO(mocksql).update_project() == True
def test_bdo_wage_approval_requests_success_without_data(self, mocksql):
""" Test bdo wage approval requests method."""
sqlite_execute_mock = mock.Mock()
mocksql.cursor.return_value = sqlite_execute_mock
sqlite_execute_mock.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = []
assert BDO(mocksql).bdo_wage_approval_requests() == True
def test_bdo_project_approval_requests_with_data(self, mocksql, bdo):
""" Test bdo project approval requests method."""
sqlite_execute_mock = mock.Mock()
mocksql.cursor.return_value = sqlite_execute_mock
sqlite_execute_mock.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = member_data
assert BDO(mocksql).bdo_project_approval_requests() == True
def test_delete_project_with_action_aborted(self, mocksql, inputs):
""" Test delete project method."""
inputs.side_effect = ['project', 'w']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = project_approval_data
assert BDO(mocksql).delete_project() == False
def test_add_project_failure_wrong_state(self, mocksql, inputs):
""" Test add project method."""
inputs.side_effect = ['', 'road construction', '@@@', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = [0]
assert BDO(mocksql).add_project() == False
def test_delete_gpm_failure_action_aborted(self, mocksql, inputs):
""" Test delete gpm method."""
inputs.side_effect = ['project', 'w']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = single_gpm_data
assert BDO(mocksql).delete_gpm() == False
def test_delete_gpm_success(self, mocksql, inputs):
""" Test delete gpm method."""
inputs.side_effect = ['email', 'y']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = single_gpm_data
assert BDO(mocksql).delete_gpm() == True
def test_update_gpm_with_details_failure_sqlite3_error(self, mocksql):
""" Test update gpm method."""
mocksql.execute.side_effect = sqlite3.Error
assert BDO(mocksql).update_gpm_with_details('fname', 'lanme',
'*****@*****.**', 'kerala',
'adress', 123456,
1) == False
def test_update_gpm_failure_no_gpm_record(self, mocksql, inputs):
""" Test update gpm method."""
inputs.side_effect = ['*****@*****.**', '', '', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = None
assert BDO(mocksql).update_gpm() == False
def test_delete_project_success(self, mocksql, inputs):
""" Test delete project method."""
inputs.side_effect = ['project', 'y']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = project_approval_data
assert BDO(mocksql).delete_project() == True
def test_add_project_failure_project_name_exists(self, mocksql, inputs):
""" Test add project method."""
inputs.side_effect = ['test', 'invalid type', '@@@', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = [1]
assert BDO(mocksql).add_project() == False
def test_delete_project_without_data(self, mocksql, inputs):
""" Test delete project method."""
inputs.side_effect = ['project', 'y']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = None
assert BDO(mocksql).delete_project() == False
def test_add_project_action_success(self, mocksql):
""" Test add project action method."""
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
assert BDO(mocksql).add_project_action('test', '', '', '', '',
'01-11-2020',
'10-11-2020') == True
def test_add_project_action_failure_end_date_is_less(self, mocksql):
""" Test add project action method."""
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
assert BDO(mocksql).add_project_action('test', '', '', '', '',
'01-11-2020',
'10-01-2020') == False
def test_update_project_failure_no_project(self, mocksql, inputs):
""" Test update project method."""
inputs.side_effect = ['project', '', '', '', '', '', '', '']
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.side_effect = [None, [1]]
assert BDO(mocksql).update_project() == False
def test_add_gpm_failure_sqlite3_error(self, mocksql, inputs):
""" Test add gpm method."""
inputs.side_effect = [
'fname', 'lname', '*****@*****.**', 'kerala', 'address', '122335'
]
mocksql.execute.side_effect = sqlite3.Error
assert BDO(mocksql).add_gpm() == False
def test_login_bdo_failure_sql_error(self, inputs):
""" Test login bdo method."""
inputs.side_effect = ['id', 'pswd']
with mock.patch(
'block_development_officer.sqlite3.connect') as mocksql:
mocksql.execute.side_effect = sqlite3.Error
assert BDO(mocksql).login_bdo() == False
def test_complaints_filed_without_data(self, mocksql):
""" Test complaints filed method."""
sqlite_execute_mock = mock.Mock()
mocksql.cursor.return_value = sqlite_execute_mock
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = []
assert BDO(mocksql).complaints_filed() == True
def test_login_bdo_failure_with_multiple_wrong_attempts(self, input):
""" Test login bdo method."""
with mock.patch(
'block_development_officer.sqlite3.connect') as mocksql:
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = None
assert BDO(mocksql).login_bdo() == False
def test_login_bdo_success(self, arg1, input):
""" Test login bdo method."""
with mock.patch(
'block_development_officer.sqlite3.connect') as mocksql:
sqlite_execute_mock = mock.Mock()
mocksql.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchone.return_value = bdo_detail
assert BDO(mocksql).login_bdo() == True
def test_bdo_wage_approval_requests_invalid_sno(self, mocksql, inputs):
""" Test bdo wage approval requests method."""
inputs.return_value = '7'
sqlite_execute_mock = mock.Mock()
mocksql.cursor.return_value = sqlite_execute_mock
sqlite_execute_mock.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = member_data
assert BDO(mocksql).bdo_wage_approval_requests() == False
def test_bdo_wage_approval_requests_action_aborted(self, mocksql, inputs):
""" Test bdo wage approval requests method."""
inputs.side_effect = ['#']
sqlite_execute_mock = mock.Mock()
mocksql.cursor.return_value = sqlite_execute_mock
sqlite_execute_mock.execute.return_value = sqlite_execute_mock
sqlite_execute_mock.fetchall.return_value = member_data
assert BDO(mocksql).bdo_wage_approval_requests() == False