sminnee / silverstripe-framework

		);

	}

	public function testCanSortBy() {

		$query = new SQLSelect();

		$query->setSelect("Name","Meta")->setFrom("MyTable")->setWhere("Name = 'Name'")->addWhere("Meta = 'Test'");

		$this->assertTrue($query->canSortBy('Name ASC'));

		$this->assertTrue($query->canSortBy('Name'));

	}

	public function testSelectWithChainedFilterParameters() {

		$query = new SQLSelect();

		$this->assertTrue($query->canSortBy('Name'));

	}

	public function testSelectWithChainedFilterParameters() {

		$query = new SQLSelect();

		$query->setSelect(array("Name","Meta"))->setFrom("MyTable");

		$query->setWhere("Name = 'Name'")->addWhere("Meta = 'Test'")->addWhere("Beta != 'Gamma'");

		$this->assertSQLEquals(

			"SELECT Name, Meta FROM MyTable WHERE (Name = 'Name') AND (Meta = 'Test') AND (Beta != 'Gamma')",

			$query->sql($parameters)

		);

	}

	public function testSelectWithLimitClause() {

		if(!(DB::get_conn() instanceof MySQLDatabase || DB::get_conn() instanceof SQLite3Database