Version20200812000000::up() - Code Metrics - Inspection of "Merge pull request #1774 from wmde/log-to-database" - wmde/FundraisingFrontend - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 33ee7a...35da7e )

by Gabriel

created 2020-08-21 11:57 UTC

Version20200812000000::up() A

↳ Parent: Version20200812000000

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	18
c	1
b	0
f	0
nc	1
nop	1
dl	0
loc	13
rs	9.6666

<?php

declare( strict_types = 1 );

namespace DoctrineMigrations;

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

final class Version20200812000000 extends AbstractMigration {

	public function up( Schema $schema ): void {
		$this->addSql(
			'CREATE TABLE bucket_log(
    				id INT AUTO_INCREMENT NOT NULL,
    				external_id INT NOT NULL,
    				event_name VARCHAR(24) NOT NULL,
    				date DATETIME NOT NULL,
    				PRIMARY KEY(id)
			   ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'
		);

		$this->addSql(
			'CREATE TABLE bucket_log_bucket(
    				id INT AUTO_INCREMENT NOT NULL,
    				bucket_log_id INT NOT NULL,
    				name VARCHAR(24) NOT NULL,
    				campaign VARCHAR(24) NOT NULL,
    				INDEX idx_bucket_log (bucket_log_id),
    				PRIMARY KEY(id),
    				FOREIGN KEY (bucket_log_id) REFERENCES bucket_log(id)
			   ) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'
		);
	}

	public function down( Schema $schema ): void {
		$this->addSql( 'DROP TABLE bucket_log_bucket' );
		$this->addSql( 'DROP TABLE bucket_log' );
	}
}


1			<?php
2
3			declare( strict_types = 1 );
4
5			namespace DoctrineMigrations;
6
7			use Doctrine\DBAL\Schema\Schema;
8			use Doctrine\Migrations\AbstractMigration;
9
10			final class Version20200812000000 extends AbstractMigration {
11
12			public function up( Schema $schema ): void {
13			$this->addSql(
14			'CREATE TABLE bucket_log(
15			id INT AUTO_INCREMENT NOT NULL,
16			external_id INT NOT NULL,
17			event_name VARCHAR(24) NOT NULL,
18			date DATETIME NOT NULL,
19			PRIMARY KEY(id)
20			) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'
21			);
22
23			$this->addSql(
24			'CREATE TABLE bucket_log_bucket(
25			id INT AUTO_INCREMENT NOT NULL,
26			bucket_log_id INT NOT NULL,
27			name VARCHAR(24) NOT NULL,
28			campaign VARCHAR(24) NOT NULL,
29			INDEX idx_bucket_log (bucket_log_id),
30			PRIMARY KEY(id),
31			FOREIGN KEY (bucket_log_id) REFERENCES bucket_log(id)
32			) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB'
33			);
34			}
35
36			public function down( Schema $schema ): void {
37			$this->addSql( 'DROP TABLE bucket_log_bucket' );
38			$this->addSql( 'DROP TABLE bucket_log' );
39			}
40			}
41

wmde / FundraisingFrontend

Push — master ( 33ee7a...35da7e )

Version20200812000000::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like