{"id":8880,"date":"2017-10-06T10:26:08","date_gmt":"2017-10-06T14:26:08","guid":{"rendered":"https:\/\/blogs.mathworks.com\/pick\/?p=8880"},"modified":"2017-10-06T10:29:01","modified_gmt":"2017-10-06T14:29:01","slug":"mockobject","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/pick\/2017\/10\/06\/mockobject\/","title":{"rendered":"MockObject"},"content":{"rendered":"
\n <\/p>\n

Sean<\/a>‘s pick this week is Mock Object<\/a> by Paul Sexton<\/a>.\n <\/p>\n

<\/introduction><\/p>\n

Paul has provided a mock object that is useful for mocking inaccessible or slow software or hardware while executing unit
\n tests. Paul’s MockObject<\/tt> allows for adding methods, and output assignment (based on a call stack), and stores how it was used for later qualification.
\n I also like how he’s provided an example that shows the real software he’s testing and the mock object that mocks it.\n <\/p>\n

In R2017a, MATLAB came out with a native mocking framework<\/a>. It is used a little differently in that when you create a mock you get two objects back, a mock instance and a behavior
\n object for the mock. You then modify the behavior to tune how the mock object will behave.\n <\/p>\n

I’ve recently been using the MATLAB mocking framework for the purpose of mocking a database connection. Here’s what I’ve
\n done for one of the tests, albeit mine is inside of a unit test class that inherits from matlab.mock.TestCase<\/tt>. I’m testing that the LastUpdateTime<\/i> property of my class updates correctly when data are added to the various tables in the database.\n <\/p>\n

testCase = matlab.mock.TestCase.forInteractiveUse;\r\n\r\nimport matlab.mock.actions.AssignOutputs<\/span>;\r\nimport matlab.mock.constraints.WasCalled<\/span>;\r\nimport matlab.mock.actions.ThrowException<\/span>;<\/pre>\n
% Mock the database and the cursor<\/span>\r\n[dbmock, dbbehavior] = createMock(testCase, 'AddedMethods'<\/span>, ...<\/span>\r\n    {'isa'<\/span>, 'isopen'<\/span>, 'insert'<\/span>, 'update'<\/span>, 'exec'<\/span>});\r\n[cursmock, cursbehavior] = createMock(testCase, 'AddedMethods'<\/span>, ...<\/span>\r\n    {'close'<\/span>, 'fetch'<\/span>}, 'AddedProperties'<\/span>,{'Data'<\/span>});<\/pre>\n
Define the behavior of cursor and database connection.  Note that these read like English sentences.<\/p>\n
% Pass the validation tests<\/span>\r\nwhen(withAnyInputs(dbbehavior.isa), AssignOutputs('database.jdbc.connection'<\/span>));\r\nwhen(withAnyInputs(dbbehavior.isopen), AssignOutputs(true));\r\n\r\n% Return cursor mock when database or cursor are executed\/fetched.<\/span>\r\nwhen(withAnyInputs(dbbehavior.exec), AssignOutputs(cursmock));\r\nwhen(withAnyInputs(cursbehavior.fetch), AssignOutputs(cursmock));<\/pre>\n
We need to build data that looks like what is required.<\/p>\n
% Synthetic output times that mimic expectation of multiple hits to a<\/span>\r\n% database.<\/span>\r\nnowish = datetime('now'<\/span>, 'TimeZone'<\/span>, 'America\/New_York'<\/span>);\r\nt1 = table([nowish; nowish],  {'Weather'<\/span>; 'Energy'<\/span>}, 'VariableNames'<\/span>, {'lastModified'<\/span>, 'tableType'<\/span>})\r\nt2 = t1;\r\nt2.lastModified(1) = t2.lastModified(1)+seconds(1); % Just Weather<\/span>\r\nt3 = t2;\r\nt3.lastModified(2) = t3.lastModified(2)+seconds(3); % Just Energy<\/span>\r\n\r\n% Build table to insert in the format MySQL requires<\/span>\r\nc = {'01-May-2007 00:00:00'<\/span>,4854.40000000000,58,30;'01-May-2007 00:05:00'<\/span>,4802.30000000000,58.0833333333333,29.8333333333333;'01-May-2007 00:10:00'<\/span>,4740.30000000000,58.1666666666667,29.6666666666667;'01-May-2007 00:15:00'<\/span>,4700.34155844156,58.2500000000000,29.5000000000000;'01-May-2007 00:20:00'<\/span>,4681.77969924812,58.3333333333333,29.3333333333333;'01-May-2007 00:25:00'<\/span>,4648.99421487603,58.4166666666667,29.1666666666667;'01-May-2007 00:30:00'<\/span>,4633.70864197531,58.5000000000000,29};\r\ndata = cell2table(c, 'VariableNames'<\/span>, {'Time'<\/span>, 'N_Y_C_'<\/span>, 'TemperatureF_KLGA'<\/span>, 'Dewpoint_KLGA'<\/span>});\r\ndata.Time = datetime(data.Time);\r\ndata.KLGA = [data.TemperatureF_KLGA data.Dewpoint_KLGA];\r\ndata.TemperatureF_KLGA = [];\r\ndata.Dewpoint_KLGA = [];\r\ndata = table2timetable(data)<\/pre>\n
t1 =\r\n  2×2 table\r\n        lastModified        tableType\r\n    ____________________    _________\r\n    06-Oct-2017 10:22:12    'Weather'\r\n    06-Oct-2017 10:22:12    'Energy' \r\ndata =\r\n  7×2 timetable\r\n            Time            N_Y_C_          KLGA      \r\n    ____________________    ______    ________________\r\n    01-May-2007 00:00:00    4854.4        58        30\r\n    01-May-2007 00:05:00    4802.3    58.083    29.833\r\n    01-May-2007 00:10:00    4740.3    58.167    29.667\r\n    01-May-2007 00:15:00    4700.3     58.25      29.5\r\n    01-May-2007 00:20:00    4681.8    58.333    29.333\r\n    01-May-2007 00:25:00      4649    58.417    29.167\r\n    01-May-2007 00:30:00    4633.7      58.5        29\r\n<\/pre>\n
Set up outputs for the Data property.  Error after three uses.<\/p>\n
when(get(cursbehavior.Data), ...<\/span>\r\n    then(repeat(1, AssignOutputs(t1)), ...<\/span>\r\n    then(repeat(1, AssignOutputs(t2)), ...<\/span>\r\n    then(repeat(1, AssignOutputs(t3)), ThrowException))));<\/pre>\n
Exercise the system.<\/p>\n
% Build DatabaseHandler<\/span>\r\ndb = DatabaseHandler(dbmock);\r\n\r\n% Add energy and weather (both database tables)<\/span>\r\naddData(db, data);<\/pre>\n
Qualify database called properly and that LastUpdateTime<\/i> property updates correctly.  Add a 1 second buffer for processing time.\n   <\/p>\n
testCase.verifyThat(withAnyInputs(dbbehavior.insert()), WasCalled('WithCount'<\/span>, 2));\r\ntestCase.verifyThat(withAnyInputs(dbbehavior.update()), WasCalled('WithCount'<\/span>, 2));\r\nfirstlut = db.LastUpdateTime;\r\nnowish = datetime('now'<\/span>, 'TimeZone'<\/span>, 'America\/New_York'<\/span>)+seconds(1);\r\ntestCase.verifyLessThan(table2array(firstlut), nowish);<\/pre>\n
Interactive verification passed.\r\nInteractive verification passed.\r\nInteractive verification passed.\r\n<\/pre>\n
% Add just weather (just weather table in database)<\/span>\r\naddData(db, data(:, {'KLGA'<\/span>}));\r\ntestCase.verifyThat(withAnyInputs(dbbehavior.insert()), WasCalled('WithCount'<\/span>, 3));\r\ntestCase.verifyThat(withAnyInputs(dbbehavior.update()), WasCalled('WithCount'<\/span>, 3));\r\nsecondlut = db.LastUpdateTime;\r\ntestCase.verifyEqual(secondlut.Energy, firstlut.Energy);\r\ntestCase.verifyGreaterThan(secondlut.Weather, firstlut.Weather);<\/pre>\n
Interactive verification passed.\r\nInteractive verification passed.\r\nInteractive verification passed.\r\nInteractive verification passed.\r\n<\/pre>\n
% Add just energy (just energy table in database)<\/span>\r\naddData(db, data(:, {'N_Y_C_'<\/span>}));\r\ntestCase.verifyThat(withAnyInputs(dbbehavior.insert()), WasCalled('WithCount'<\/span>, 4));\r\ntestCase.verifyThat(withAnyInputs(dbbehavior.update()), WasCalled('WithCount'<\/span>, 4));\r\nthirdlut = db.LastUpdateTime;\r\ntestCase.verifyEqual(secondlut.Weather, thirdlut.Weather);\r\ntestCase.verifyGreaterThan(thirdlut.Energy, secondlut.Energy);<\/pre>\n
Interactive verification passed.\r\nInteractive verification passed.\r\nInteractive verification passed.\r\nInteractive verification passed.\r\n<\/pre>\n
Going forward, I’d recommend using the MATLAB testing frameworks for your testing needs.  They’re an area of MATLAB that has
\n      really matured quite well over the last few years.  If you need to design for older releases, then Paul’s MockObject<\/tt> can certainly help.\n   <\/p>\n
For another blog post on the MATLAB Mocking Framework, see this blog post<\/a> on the Developer Blog.\n   <\/p>\n
Comments<\/a><\/h3>\n
Give both mocking frameworks a try and let us know what you think here<\/a> or leave a comment<\/a> for Paul.\n   <\/p>\n
Mock the database<\/a> and the cursor<\/a>.\n   <\/p>\n