sminnee / silverstripe-framework

			DB::query('SELECT COUNT(*) FROM "VersionedTest_DataObject_Live" WHERE "ID" = '.$pageID)->value());

	}

	public function testWritingNewToStage() {

		$origStage = Versioned::get_stage();

		Versioned::set_stage(Versioned::DRAFT);

		$page = new VersionedTest_DataObject();

		$page->Title = "testWritingNewToStage";

		$page->URLSegment = "testWritingNewToStage";

		$page->write();

		$live = Versioned::get_by_stage('VersionedTest_DataObject', 'Live', array(

			'"VersionedTest_DataObject_Live"."ID"' => $page->ID

		));

		$this->assertEquals(0, $live->count());

		$stage = Versioned::get_by_stage('VersionedTest_DataObject', 'Stage',array(

			'"VersionedTest_DataObject"."ID"' => $page->ID

		));

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

		$this->assertEquals($stage->First()->Title, 'testWritingNewToStage');

		Versioned::set_stage($origStage);

	}

	/**

	 * This tests for the situation described in the ticket #5596.

	 * then "changes it's mind" in Versioned and writes VersionedTest_DataObject_Live. It does not remove

	 * the VersionedTest_DataObject record though.

	 */

	public function testWritingNewToLive() {

		$origStage = Versioned::get_stage();

		Versioned::set_stage(Versioned::LIVE);

		$page = new VersionedTest_DataObject();

		$page->Title = "testWritingNewToLive";

		$page->URLSegment = "testWritingNewToLive";

		$page->write();

		$live = Versioned::get_by_stage('VersionedTest_DataObject', 'Live',array(

			'"VersionedTest_DataObject_Live"."ID"' => $page->ID

		));

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

		$this->assertEquals($live->First()->Title, 'testWritingNewToLive');

		$stage = Versioned::get_by_stage('VersionedTest_DataObject', 'Stage',array(

			'"VersionedTest_DataObject"."ID"' => $page->ID

		));

		$this->assertEquals(0, $stage->count());

		Versioned::set_stage($origStage);

	}

	/**

	 * Tests DataObject::hasOwnTableDatabaseField