Mocking with Mockery

PHP
1

Im learning how to use mockery in order to run some unit test and Im not sure what to do to mock my database class. It consists of separate methods that can be chained like these two examples:

$db->select('someTblName',['fieldName'])
   ->where('fieldName', 'someValue')
   ->runQuery()
   ->fetch(); //returns array or null

Another use could be like:

$db->select('someTblName')
   ->where('fieldName', 'someValue')
   ->where('fieldName', array('>=' , 'someValue')
   ->runQuery()
   ->fetch(); //returns array or null

From reading some of the documentation I see that I can do something like:(for the first case)

$db = \\Mockery::mock('Database');
$db->shouldReceive('select', 'where', 'runQuery', 'fetcth')
    ->with(??????)
    ->andReturn(null);

Now Im interested on how to pass the “corresponting” parameters to the methods? And, how would I mock the second scenario.

2

According to the documentation, you should be able to do something like this:


$mock = \\Mockery::mock('Database');
$mock->shouldReceive('select->where->where->runQuery->fetch')->andReturn('null');
3

So omit the

->with()

all together?