public function testcreate_export_query() { $call = new Call(); //test with empty string params $expected = 'SELECT calls.*, users.user_name as assigned_user_name FROM calls LEFT JOIN users ON calls.assigned_user_id=users.id where calls.deleted=0 ORDER BY calls.name'; $actual = $call->create_export_query('', ''); $this->assertSame($expected, $actual); //var_dump($actual); //test with empty string params $expected = 'SELECT calls.*, users.user_name as assigned_user_name FROM calls LEFT JOIN users ON calls.assigned_user_id=users.id where users.user_name="" AND calls.deleted=0 ORDER BY calls.name'; $actual = $call->create_export_query('name', 'users.user_name=""'); $this->assertSame($expected, $actual); //var_dump($actual); }