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();
    }
 /**
  * Return the number of rows in this query if the limit were removed.  Useful in paged data sets.
  *
  * @param string $column
  * @return int
  */
 public function unlimitedRowCount($column = null)
 {
     // we can't clear the select if we're relying on its output by a HAVING clause
     if (count($this->having)) {
         $records = $this->execute();
         return $records->numRecords();
     }
     $clone = clone $this;
     $clone->limit = null;
     $clone->orderby = null;
     // Choose a default column
     if ($column == null) {
         if ($this->groupby) {
             // @todo Test case required here
             $countQuery = new SQLSelect();
             $countQuery->setSelect("count(*)");
             $countQuery->setFrom(array('(' . $clone->sql($innerParameters) . ') all_distinct'));
             $sql = $countQuery->sql($parameters);
             // $parameters should be empty
             $result = DB::prepared_query($sql, $innerParameters);
             return (int) $result->value();
         } else {
             $clone->setSelect(array("count(*)"));
         }
     } else {
         $clone->setSelect(array("count({$column})"));
     }
     $clone->setGroupBy(array());
     return (int) $clone->execute()->value();
 }
 /**
  * Set foreign keys of has_many objects to 0 where those objects were
  * disowned as a result of a partial publish / unpublish.
  * I.e. this object and its owned objects were recently written to $targetStage,
  * but deleted objects were not.
  *
  * Note that this operation does not create any new Versions
  *
  * @param string $sourceStage Objects in this stage will not be unlinked.
  * @param string $targetStage Objects which exist in this stage but not $sourceStage
  * will be unlinked.
  */
 public function unlinkDisownedObjects($sourceStage, $targetStage)
 {
     $owner = $this->owner;
     // after publishing, objects which used to be owned need to be
     // dis-connected from this object (set ForeignKeyID = 0)
     $owns = $owner->config()->owns;
     $hasMany = $owner->config()->has_many;
     if (empty($owns) || empty($hasMany)) {
         return;
     }
     $ownedHasMany = array_intersect($owns, array_keys($hasMany));
     foreach ($ownedHasMany as $relationship) {
         // Find metadata on relationship
         $joinClass = $owner->hasManyComponent($relationship);
         $joinField = $owner->getRemoteJoinField($relationship, 'has_many', $polymorphic);
         $idField = $polymorphic ? "{$joinField}ID" : $joinField;
         $joinTable = DataObject::getSchema()->tableForField($joinClass, $idField);
         // Generate update query which will unlink disowned objects
         $targetTable = $this->stageTable($joinTable, $targetStage);
         $disowned = new SQLUpdate("\"{$targetTable}\"");
         $disowned->assign("\"{$idField}\"", 0);
         $disowned->addWhere(array("\"{$targetTable}\".\"{$idField}\"" => $owner->ID));
         // Build exclusion list (items to owned objects we need to keep)
         $sourceTable = $this->stageTable($joinTable, $sourceStage);
         $owned = new SQLSelect("\"{$sourceTable}\".\"ID\"", "\"{$sourceTable}\"");
         $owned->addWhere(array("\"{$sourceTable}\".\"{$idField}\"" => $owner->ID));
         // Apply class condition if querying on polymorphic has_one
         if ($polymorphic) {
             $disowned->assign("\"{$joinField}Class\"", null);
             $disowned->addWhere(array("\"{$targetTable}\".\"{$joinField}Class\"" => get_class($owner)));
             $owned->addWhere(array("\"{$sourceTable}\".\"{$joinField}Class\"" => get_class($owner)));
         }
         // Merge queries and perform unlink
         $ownedSQL = $owned->sql($ownedParams);
         $disowned->addWhere(array("\"{$targetTable}\".\"ID\" NOT IN ({$ownedSQL})" => $ownedParams));
         $owner->extend('updateDisownershipQuery', $disowned, $sourceStage, $targetStage, $relationship);
         $disowned->execute();
     }
 }