migration_233

Complexity

Total Complexity

10

Size/Duplication

Total Lines	51
Duplicated Lines	35.29 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getVersion()	0	4	1
A	getReleaseNotes()	0	4	1
C	upgrade()	18	34	7

<?php
namespace SymphonyCms\Installer\Migrations;

use SymphonyCms\Installer\Lib\Migration;
use Symphony;

class migration_233 extends Migration
{
    public static function getVersion()
    {
        return '2.3.3';
    }

    public static function getReleaseNotes()
    {
        return 'http://getsymphony.com/download/releases/version/2.3.3/';
    }

    public static function upgrade()
    {
        if (version_compare(self::$existing_version, '2.3.3beta1', '<=')) {
            // Update DB for the new author role #1692
            Symphony::Database()->query(
                "ALTER TABLE `tbl_authors` CHANGE `user_type` `user_type` ENUM('author', 'manager', 'developer') DEFAULT 'author'"
            );

            // Remove directory from the upload fields, #1719
            $upload_tables = Symphony::Database()->fetchCol(
                "field_id",
                "SELECT `field_id` FROM `tbl_fields_upload`"
            );

            if (is_array($upload_tables) && !empty($upload_tables)) {
                foreach ($upload_tables as $field) {
                    Symphony::Database()->query(sprintf(
                        "UPDATE tbl_entries_data_%d SET FILE = substring_index(FILE, '/', -1)",
                        $field
                    ));
                }
            }
        }

        if (version_compare(self::$existing_version, '2.3.3beta2', '<=')) {
            // Update rows for associations
            if (!Symphony::Configuration()->get('association_maximum_rows', 'symphony')) {
                Symphony::Configuration()->set('association_maximum_rows', '5', 'symphony');
            }
        }

        // Update the version information
        return parent::upgrade();
    }

    public static function preUpdateNotes()
    {
        return array(
            __("On update, all files paths will be removed from the core Upload field entry tables. If you are using an Upload field extension, ensure that the extension is compatible with this release before continuing.")
        );
    }
}