phpffcms / ffcms

Private/Migrations/Updates/update_cms_310-2017-07-29-11-00-00.php

<?php

use Ffcms\Core\Migrations\MigrationInterface;
use Ffcms\Core\Migrations\Migration;

/**
 * Class update_cms_310
 */
class update_cms_310 extends Migration implements MigrationInterface

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    const UPDATE_EXTENSIONS = ['User', 'Profile', 'Content', 'Feedback', 'Search', 'Sitemap', 'Comments', 'Newcontent', 'Contenttag', 'Newcomment'];

    /**
     * Implement new update changes
     * @return void
     */
    public function up()
    {
        // set nullable varchar type for token column
        $this->getSchema()->table('users', function($table){
            $table->string('approve_token', 128)->nullable()->default(null)->change();
        });
        // set approve_token = null where it like '0' str or ''
        \Apps\ActiveRecord\User::where('approve_token', '=', '0')
            ->update('approve_token', null);

'approve_token' of type string is incompatible with the type array expected by parameter $attributes of Illuminate\Database\Eloquent\Model::update().

null of type null is incompatible with the type array expected by parameter $options of Illuminate\Database\Eloquent\Model::update().

        // update comment posts architecture: add app_name and app_id relationship
        if (!$this->getSchema()->hasColumn('comment_posts', 'app_name')) {
            $this->getSchema()->table('comment_posts', function($table) {
                $table->string('app_name')->after('id');
            });
        }
        if (!$this->getSchema()->hasColumn('comment_answers', 'app_relation_id')) {
            $this->getSchema()->table('comment_answers', function($table){
                $table->integer('app_relation_id')->unsigned()->default(0)->after('app_name');
            });
        }

        \Apps\ActiveRecord\App::whereIn('sys_name', static::UPDATE_EXTENSIONS)
            ->update(['version' => '1.0.1']);

        // @todo: add algo to find app_name & app_id for oldest comments
        if ($this->getSchema()->hasColumn('comment_posts', 'pathway')) {
            $this->getSchema()->table('comment_posts', function($table){
                $table->dropColumn('pathway');
            });
        }
        // remove comment_hash column from content
        if ($this->getSchema()->hasColumn('contents', 'comment_hash')) {
            $this->getSchema()->table('contents', function($table) {
                $table->dropColumn('comment_hash');
            });
        }
        // remove user login column
        if ($this->getSchema()->hasColumn('users', 'login')) {
            $this->getSchema()->table('users', function($table) {
                $table->dropColumn('login');
            });
        }
    }

    /**
     * @return void
     */
    public function down()
    {
        parent::down(); // TODO: Change the autogenerated stub
    }

    /**
     * Seed created table via up() method with some data
     * @return void
     */
    public function seed()
    {
        // TODO: Implement seed() method.
    }
}