function test_search()
{
$builder = new Dataface_QueryBuilder('Profiles');
$query = $builder->search('foo');
$this->assertEquals("SELECT `Profiles`.`id`,`Profiles`.`fname`,`Profiles`.`lname`,`Profiles`.`title`,`Profiles`.`description`,`Profiles`.`dob`,`Profiles`.`phone1`,`Profiles`.`phone2`,`Profiles`.`fax`,`Profiles`.`email`,`Profiles`.`datecreated`,`Profiles`.`lastmodified`,`Profiles`.`favtime`,`Profiles`.`lastlogin`,`Profiles`.`photo_mimetype`,`Profiles`.`tablefield` FROM `Profiles` WHERE MATCH (`Profiles`.`title`,`Profiles`.`description`) AGAINST ('foo' IN BOOLEAN MODE)", $query);
$query = $builder->search('foo', array('title', 'description'));
$this->assertEquals("SELECT `Profiles`.`title`,`Profiles`.`description` FROM `Profiles` WHERE MATCH (`Profiles`.`title`,`Profiles`.`description`) AGAINST ('foo' IN BOOLEAN MODE)", $query);
$query = $builder->search('foo', array('title', 'description'), array('-skip' => 5, '-limit' => 10));
$this->assertEquals("SELECT `Profiles`.`title`,`Profiles`.`description` FROM `Profiles` WHERE MATCH (`Profiles`.`title`,`Profiles`.`description`) AGAINST ('foo' IN BOOLEAN MODE) LIMIT 5,10", $query);
}
