sminnee / silverstripe-framework

		$this->assertEquals(10, $limit['start']);

	}

	public function testParameterisedInnerJoins() {

		$query = new SQLSelect();

		$query->setSelect(array('"SQLSelectTest_DO"."Name"', '"SubSelect"."Count"'));

		$query->setFrom('"SQLSelectTest_DO"');

		$query->addInnerJoin(

			'(SELECT "Title", COUNT(*) AS "Count" FROM "SQLSelectTestBase" GROUP BY "Title" HAVING "Title" NOT LIKE ?)',

			'"SQLSelectTest_DO"."Name" = "SubSelect"."Title"',

			'SubSelect',

			20,

			array('%MyName%')

		);

		$query->addWhere(array('"SQLSelectTest_DO"."Date" > ?' => '2012-08-08 12:00'));

		$this->assertSQLEquals('SELECT "SQLSelectTest_DO"."Name", "SubSelect"."Count"

			FROM "SQLSelectTest_DO" INNER JOIN (SELECT "Title", COUNT(*) AS "Count" FROM "SQLSelectTestBase"

		   GROUP BY "Title" HAVING "Title" NOT LIKE ?) AS "SubSelect" ON "SQLSelectTest_DO"."Name" =

		   "SubSelect"."Title"

			WHERE ("SQLSelectTest_DO"."Date" > ?)', $query->sql($parameters)

		);

		$this->assertEquals(array('%MyName%', '2012-08-08 12:00'), $parameters);

		$query->execute();

	}

	public function testParameterisedLeftJoins() {

		$query = new SQLSelect();

		$query->execute();

	}

	public function testParameterisedLeftJoins() {

		$query = new SQLSelect();

		$query->setSelect(array('"SQLSelectTest_DO"."Name"', '"SubSelect"."Count"'));

		$query->setFrom('"SQLSelectTest_DO"');

		$query->addLeftJoin(

			'(SELECT "Title", COUNT(*) AS "Count" FROM "SQLSelectTestBase" GROUP BY "Title" HAVING "Title" NOT LIKE ?)',

			'"SQLSelectTest_DO"."Name" = "SubSelect"."Title"',

			'SubSelect',

			20,

			array('%MyName%')

		);

		$query->addWhere(array('"SQLSelectTest_DO"."Date" > ?' => '2012-08-08 12:00'));

		$this->assertSQLEquals('SELECT "SQLSelectTest_DO"."Name", "SubSelect"."Count"

			FROM "SQLSelectTest_DO" LEFT JOIN (SELECT "Title", COUNT(*) AS "Count" FROM "SQLSelectTestBase"

		   GROUP BY "Title" HAVING "Title" NOT LIKE ?) AS "SubSelect" ON "SQLSelectTest_DO"."Name" =

		   "SubSelect"."Title"

			WHERE ("SQLSelectTest_DO"."Date" > ?)', $query->sql($parameters)

		);

		$this->assertEquals(array('%MyName%', '2012-08-08 12:00'), $parameters);

		$query->execute();

	}

}

class SQLSelectTest_DO extends DataObject implements TestOnly {