public function testget_all_prospect_lists() { $emailMarketing = new EmailMarketing(); //execute the method and verify that it retunrs expected results $expected = "select prospect_lists.* from prospect_lists left join prospect_list_campaigns on prospect_list_campaigns.prospect_list_id=prospect_lists.id where prospect_list_campaigns.deleted=0 and prospect_list_campaigns.campaign_id='' and prospect_lists.deleted=0 and prospect_lists.list_type not like 'exempt%'"; $actual = $emailMarketing->get_all_prospect_lists(); $this->assertSame($expected, $actual); }