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);
}
