m170707_070437_avatar_image

Complexity

Total Complexity

2

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	safeUp()	0	8	1
A	safeDown()	0	6	1

<?php

use inblank\activeuser\migrations\Migration;
use yii\db\Schema;

class m170707_070437_avatar_image extends Migration

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

{
    public function safeUp()
    {
        // set default value for `avatar` field to NULL
        $tab = self::tn(self::TAB_USERS);
        $this->alterColumn($tab, 'avatar', Schema::TYPE_STRING . "(45) DEFAULT NULL");
        // replace all empty `avatar`
        $this->db->createCommand("update " . $tab . " set [[avatar]]=NULL where [[avatar]]=''")->execute();
    }

    public function safeDown()
    {
        $tab = self::tn(self::TAB_USERS);
        $this->db->createCommand("update " . $tab . " set [[avatar]]='' where [[avatar]] IS NULL")->execute();
        $this->alterColumn($tab, 'avatar', Schema::TYPE_STRING . "(45) NOT NULL DEFAULT ''");
    }
}