def testReadSingleValueFromTable(self):
dbDriver = DBDriverMock()
sut = Pydblibrary()
sut.connect_to_database(dbDriver, 'someDbName', 'someUsername',
'somePassword', 'someHost', '7777')
responses = {"select name from employee where surname='Doe'":
[('John',)]}
dbDriver.connection.cursor().setQueryResponses(responses)
result = sut.read_single_value_from_table('employee', 'name',
"surname='Doe'")
self.assertTrue(responses[("select name from employee "
"where surname='Doe'")][0] ==
result, 'Read Single Value was performed with fail.')
def testReadSingleValueFromTable(self):
dbDriver = DBDriverMock()
sut = Pydblibrary()
sut.connect_to_database(dbDriver, 'someDbName', 'someUsername',
'somePassword', 'someHost', '7777')
responses = {
"select name from employee where surname='Doe'": [('John', )]
}
dbDriver.connection.cursor().setQueryResponses(responses)
result = sut.read_single_value_from_table('employee', 'name',
"surname='Doe'")
self.assertTrue(
responses[("select name from employee "
"where surname='Doe'")][0] == result,
'Read Single Value was performed with fail.')
