update_cms_310::up()

Complexity

Conditions	6
Paths	32

Size

Total Lines	41
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    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');
            });
}