public function testcreate_export_query() { $project = new Project(); //test with empty string params $expected = "SELECT\n\t\t\t\tproject.*,\n users.user_name as assigned_user_name ,project_cstm.jjwg_maps_lng_c,project_cstm.jjwg_maps_lat_c,project_cstm.jjwg_maps_geocode_status_c,project_cstm.jjwg_maps_address_c FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c LEFT JOIN users\n \tON project.assigned_user_id=users.id where project.deleted=0 "; $actual = $project->create_export_query('', ''); $this->assertSame($expected, $actual); //test with valid string params $expected = "SELECT\n\t\t\t\tproject.*,\n users.user_name as assigned_user_name ,project_cstm.jjwg_maps_lng_c,project_cstm.jjwg_maps_lat_c,project_cstm.jjwg_maps_geocode_status_c,project_cstm.jjwg_maps_address_c FROM project LEFT JOIN project_cstm ON project.id = project_cstm.id_c LEFT JOIN users\n \tON project.assigned_user_id=users.id where (users.user_name) AND project.deleted=0 ORDER BY project.id"; $actual = $project->create_export_query('project.id', 'users.user_name'); $this->assertSame($expected, $actual); }