Version20161221133514::up() - Code Metrics - Inspection of "Improve loading Gedmo Loggable behaviour in CoreBu..." - pamil/Sylius - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — wtf-removal ( 4585f3 )

by Kamil

created 2016-12-28 22:30 UTC

Version20161221133514::up() A

↳ Parent: Version20161221133514

Complexity

Conditions	1
Paths	1

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	8
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	5
nc	1
nop	1

<?php

namespace Sylius\Migrations;

use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;

/**
 * @author Grzegorz Sadowski <[email protected]>
 */
class Version20161221133514 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE sylius_product_option ADD position INT NOT NULL');
        $this->addSql('SET @row_number = -1');
        $this->addSql('UPDATE sylius_product_option SET position = @row_number := @row_number + 1');
    }

    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');

        $this->addSql('ALTER TABLE sylius_product_option DROP position');
    }
}


1			<?php
2
3			namespace Sylius\Migrations;
4
5			use Doctrine\DBAL\Migrations\AbstractMigration;
6			use Doctrine\DBAL\Schema\Schema;
7
8			/**
9			* @author Grzegorz Sadowski <[email protected]>
10			*/
11			class Version20161221133514 extends AbstractMigration
12			{
13			/**
14			* @param Schema $schema
15			*/
16			public function up(Schema $schema)
17			{
18			$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
19
20			$this->addSql('ALTER TABLE sylius_product_option ADD position INT NOT NULL');
21			$this->addSql('SET @row_number = -1');
22			$this->addSql('UPDATE sylius_product_option SET position = @row_number := @row_number + 1');
23			}
24
25			/**
26			* @param Schema $schema
27			*/
28			public function down(Schema $schema)
29			{
30			$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
31
32			$this->addSql('ALTER TABLE sylius_product_option DROP position');
33			}
34			}
35

pamil / Sylius

Push — wtf-removal ( 4585f3 )

Version20161221133514::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like