sminnee / silverstripe-framework

		$this->resetDBSchema(true);

	}

	public function testMySQLCreateTableOptions() {

		if(!(DB::get_conn() instanceof MySQLDatabase)) {

			$this->markTestSkipped('MySQL only');

		}

		$ret = DB::query(sprintf(

			'SHOW TABLE STATUS WHERE "Name" = \'%s\'',

			'DatabaseTest_MyObject'

		))->first();

		$this->assertEquals($ret['Engine'],'InnoDB',

			"MySQLDatabase tables can be changed to InnoDB through DataObject::\$create_table_options"

		);

	}

	function testIsSchemaUpdating() {

		$schema = DB::get_schema();

		$this->assertEquals('Phil', $comment->Name);

	}

	public function testGetCaseInsensitive() {

		// Test get_one() with bad case on the classname

		// Note: This will succeed only if the underlying DB server supports case-insensitive

		// table names (e.g. such as MySQL, but not SQLite3)

		if(!(DB::get_conn() instanceof MySQLDatabase)) {

			$this->markTestSkipped('MySQL only');

		}

		$subteam1 = DataObject::get_one('dataobjecttest_subteam', array(

			'"DataObjectTest_Team"."Title"' => 'Subteam 1'

		), true);

		$this->assertNotEmpty($subteam1);

		$this->assertEquals($subteam1->Title, "Subteam 1");

	}

	public function testGetSubclassFields() {

		/* Test that fields / has_one relations from the parent table and the subclass tables are extracted */