public function testcreate_export_query() { $meeting = new Meeting(); //test with empty string params $expected = 'SELECT meetings.*, users.user_name as assigned_user_name ,meetings_cstm.jjwg_maps_lng_c,meetings_cstm.jjwg_maps_lat_c,meetings_cstm.jjwg_maps_geocode_status_c,meetings_cstm.jjwg_maps_address_c FROM meetings LEFT JOIN users ON meetings.assigned_user_id=users.id LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c where meetings.deleted=0'; $actual = $meeting->create_export_query('', ''); $this->assertSame($expected, $actual); //test with valid string params $expected = 'SELECT meetings.*, users.user_name as assigned_user_name ,meetings_cstm.jjwg_maps_lng_c,meetings_cstm.jjwg_maps_lat_c,meetings_cstm.jjwg_maps_geocode_status_c,meetings_cstm.jjwg_maps_address_c FROM meetings LEFT JOIN users ON meetings.assigned_user_id=users.id LEFT JOIN meetings_cstm ON meetings.id = meetings_cstm.id_c where users.user_name="" AND meetings.deleted=0'; $actual = $meeting->create_export_query('meetings.id', 'users.user_name=""'); $this->assertSame($expected, $actual); }