sminnee / silverstripe-framework

    /**

     * Check that updates to a class fields are reflected in the database

     */

    public function testFieldsRequestChanges()

    {

        $schema = DB::get_schema();

        $test = $this;

        DB::quiet();

        // Table will have been initially created by the $extraDataObjects setting

        // Let's insert a new field here

        TestObject::config()->update(

            'db',

            array(

            'SecretField' => 'Varchar(100)'

            )

        );

        // Verify that the above extra field triggered a schema update

        $schema->schemaUpdate(

            function () use ($test, $schema) {

                $obj = new TestObject();

                $obj->requireTable();

                $needsUpdating = $schema->doesSchemaNeedUpdating();

                $schema->cancelSchemaUpdate();

                $test->assertTrue($needsUpdating);

    /**

     * Check that updates to a dataobject's indexes are reflected in DDL

     */

    public function testIndexesRerequestChanges()

    {

        $schema = DB::get_schema();

        $test = $this;

        DB::quiet();

        // Table will have been initially created by the $extraDataObjects setting

        // Update the SearchFields index here

        TestIndexObject::config()->update(

            'indexes',

            array(

            'SearchFields' => array(

                'value' => 'Title'

            )

            )

        );

        // Verify that the above index change triggered a schema update

        $schema->schemaUpdate(

            function () use ($test, $schema) {

                $obj = new TestIndexObject();

                $obj->requireTable();

                $needsUpdating = $schema->doesSchemaNeedUpdating();

                $schema->cancelSchemaUpdate();

                $test->assertTrue($needsUpdating);