sminnee / silverstripe-framework

	/**

	 *  $list->filter(array('Name'=>'bob, 'Age'=>21)); // bob with the age 21

	 */

	public function testFilterMultipleArray() {

		$list = DataObjectTest_TeamComment::get();

		$list = $list->filter(array('Name'=>'Bob', 'Comment'=>'This is a team comment by Bob'));

		$list = $list->sort('Name', 'ASC');

		$this->assertEquals(1, $list->count());

		$this->assertEquals('Bob', $list->first()->Name, 'Only comment should be from Bob');

	}

	public function testFilterMultipleWithTwoMatches() {

		$list = DataObjectTest_TeamComment::get();

		);

	}

	public function testFilterAnyMultipleWithArrayFilter() {

		$list = DataObjectTest_TeamComment::get();

		$list = $list->filterAny(array('Name'=>array('Bob','Phil')));

		$this->assertEquals(2, $list->count(), 'There should be two comments');

		$this->assertEquals('Bob', $list->first()->Name, 'First comment should be from Bob');

		$this->assertEquals('Phil', $list->last()->Name, 'Last comment should be from Phil');

	}

	public function testFilterAnyArrayInArray() {

		$list = DataObjectTest_TeamComment::get();

		);

	}

	public function testFilterOnJoin() {

		$list = DataObjectTest_TeamComment::get()

			->leftJoin('DataObjectTest_Team',

				'"DataObjectTest_Team"."ID" = "DataObjectTest_TeamComment"."TeamID"'

			)->filter(array(

				'Title' => 'Team 1'

			));

		$this->assertEquals(2, $list->count());

		$values = $list->column('Name');

		$this->assertEquals(array_intersect($values, array('Joe', 'Bob')), $values);

	}

	public function testFilterOnImplicitJoin() {

		// Many to many