PropelMigration_1455269455::getDownSQL() - Code Metrics - Inspection of "fix merge snafu" - Jalle19/tvheadend-status-manager - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 33443d...de9a4e )

by Sam

created 2016-02-12 10:03 UTC

PropelMigration_1455269455::getDownSQL() B

↳ Parent: PropelMigration_1455269455

Complexity

Conditions	1
Paths	1

Size

Total Lines	34
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	34
rs	8.8571
cc	1
eloc	3
nc	1
nop	0

<?php

/**
 * Data object containing the SQL and PHP code to migrate the database
 * up to version 1455269455.
 * Generated on 2016-02-12 09:30:55 by vagrant
 */
class PropelMigration_1455269455
namespace YourVendor;

class YourClass { }
{
    public $comment = '';

    public function preUp($manager)

    {
        // add the pre-migration code here
    }

    public function postUp($manager)

    {
        // add the post-migration code here
    }

    public function preDown($manager)

    {
        // add the pre-migration code here
    }

    public function postDown($manager)

    {
        // add the post-migration code here
    }

    /**
     * Get the SQL statements for the Up migration
     *
     * @return array list of the SQL strings to execute for the Up migration
     *               the keys being the datasources
     */
    public function getUpSQL()
    {
        return array (
  'tvheadend_status_manager' => '
PRAGMA foreign_keys = OFF;

CREATE TEMPORARY TABLE [subscription__temp__56bda64f12586] AS SELECT [id],[instance_name],[user_id],[channel_id],[subscription_id],[started],[stopped],[title],[service],[input_id] FROM [subscription];
DROP TABLE [subscription];

CREATE TABLE [subscription]
(
    [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [instance_name] VARCHAR(255) NOT NULL,
    [input_uuid] VARCHAR(255),
    [user_id] INTEGER,
    [channel_id] INTEGER NOT NULL,
    [subscription_id] INTEGER NOT NULL,
    [started] TIMESTAMP NOT NULL,
    [stopped] TIMESTAMP,
    [title] VARCHAR(255) NOT NULL,
    [service] VARCHAR(255) NOT NULL,
    UNIQUE ([id]),
    FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name]),
    FOREIGN KEY ([input_uuid]) REFERENCES [input] ([uuid]),
    FOREIGN KEY ([user_id]) REFERENCES [user] ([id]),
    FOREIGN KEY ([channel_id]) REFERENCES [channel] ([id])
);

INSERT INTO [subscription] (id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service) SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM [subscription__temp__56bda64f12586];
DROP TABLE [subscription__temp__56bda64f12586];

PRAGMA foreign_keys = ON;
',
);
    }

    /**
     * Get the SQL statements for the Down migration
     *
     * @return array list of the SQL strings to execute for the Down migration
     *               the keys being the datasources
     */
    public function getDownSQL()
    {
        return array (
  'tvheadend_status_manager' => '
PRAGMA foreign_keys = OFF;

CREATE TEMPORARY TABLE [subscription__temp__56bda64f128f1] AS SELECT [id],[instance_name],[input_uuid],[user_id],[channel_id],[subscription_id],[started],[stopped],[title],[service] FROM [subscription];
DROP TABLE [subscription];

CREATE TABLE [subscription]
(
    [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [instance_name] VARCHAR(255) NOT NULL,
    [user_id] INTEGER,
    [channel_id] INTEGER NOT NULL,
    [subscription_id] INTEGER NOT NULL,
    [started] TIMESTAMP NOT NULL,
    [stopped] TIMESTAMP,
    [title] VARCHAR(255) NOT NULL,
    [service] VARCHAR(255) NOT NULL,
    [input_id] INTEGER,
    UNIQUE ([id]),
    FOREIGN KEY ([channel_id]) REFERENCES [channel] ([id]),
    FOREIGN KEY ([user_id]) REFERENCES [user] ([id]),
    FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name])
);

INSERT INTO [subscription] (id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service) SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM [subscription__temp__56bda64f128f1];
DROP TABLE [subscription__temp__56bda64f128f1];

PRAGMA foreign_keys = ON;
',
);
    }

}

1			<?php
2
3			/**
4			* Data object containing the SQL and PHP code to migrate the database
5			* up to version 1455269455.
6			* Generated on 2016-02-12 09:30:55 by vagrant
7			*/
8			class PropelMigration_1455269455
			0 ignored issues – show Coding Style Compatibility introduced 2016-02-12 10:07 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
9			{
10			public $comment = '';
11
12			public function preUp($manager)
			0 ignored issues – show Unused Code introduced 2016-02-12 10:07 UTC by Report Bug Copy Issue Report The parameter `$manager` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
13			{
14			// add the pre-migration code here
15			}
16
17			public function postUp($manager)
			0 ignored issues – show Unused Code introduced 2016-02-12 10:07 UTC by Report Bug Copy Issue Report The parameter `$manager` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
18			{
19			// add the post-migration code here
20			}
21
22			public function preDown($manager)
			0 ignored issues – show Unused Code introduced 2016-02-12 10:07 UTC by Report Bug Copy Issue Report The parameter `$manager` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
23			{
24			// add the pre-migration code here
25			}
26
27			public function postDown($manager)
			0 ignored issues – show Unused Code introduced 2016-02-12 10:07 UTC by Report Bug Copy Issue Report The parameter `$manager` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
28			{
29			// add the post-migration code here
30			}
31
32			/**
33			* Get the SQL statements for the Up migration
34			*
35			* @return array list of the SQL strings to execute for the Up migration
36			* the keys being the datasources
37			*/
38			public function getUpSQL()
39			{
40			return array (
41			'tvheadend_status_manager' => '
42			PRAGMA foreign_keys = OFF;
43
44			CREATE TEMPORARY TABLE [subscription__temp__56bda64f12586] AS SELECT [id],[instance_name],[user_id],[channel_id],[subscription_id],[started],[stopped],[title],[service],[input_id] FROM [subscription];
45			DROP TABLE [subscription];
46
47			CREATE TABLE [subscription]
48			(
49			[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
50			[instance_name] VARCHAR(255) NOT NULL,
51			[input_uuid] VARCHAR(255),
52			[user_id] INTEGER,
53			[channel_id] INTEGER NOT NULL,
54			[subscription_id] INTEGER NOT NULL,
55			[started] TIMESTAMP NOT NULL,
56			[stopped] TIMESTAMP,
57			[title] VARCHAR(255) NOT NULL,
58			[service] VARCHAR(255) NOT NULL,
59			UNIQUE ([id]),
60			FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name]),
61			FOREIGN KEY ([input_uuid]) REFERENCES [input] ([uuid]),
62			FOREIGN KEY ([user_id]) REFERENCES [user] ([id]),
63			FOREIGN KEY ([channel_id]) REFERENCES [channel] ([id])
64			);
65
66			INSERT INTO [subscription] (id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service) SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM [subscription__temp__56bda64f12586];
67			DROP TABLE [subscription__temp__56bda64f12586];
68
69			PRAGMA foreign_keys = ON;
70			',
71			);
72			}
73
74			/**
75			* Get the SQL statements for the Down migration
76			*
77			* @return array list of the SQL strings to execute for the Down migration
78			* the keys being the datasources
79			*/
80			public function getDownSQL()
81			{
82			return array (
83			'tvheadend_status_manager' => '
84			PRAGMA foreign_keys = OFF;
85
86			CREATE TEMPORARY TABLE [subscription__temp__56bda64f128f1] AS SELECT [id],[instance_name],[input_uuid],[user_id],[channel_id],[subscription_id],[started],[stopped],[title],[service] FROM [subscription];
87			DROP TABLE [subscription];
88
89			CREATE TABLE [subscription]
90			(
91			[id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
92			[instance_name] VARCHAR(255) NOT NULL,
93			[user_id] INTEGER,
94			[channel_id] INTEGER NOT NULL,
95			[subscription_id] INTEGER NOT NULL,
96			[started] TIMESTAMP NOT NULL,
97			[stopped] TIMESTAMP,
98			[title] VARCHAR(255) NOT NULL,
99			[service] VARCHAR(255) NOT NULL,
100			[input_id] INTEGER,
101			UNIQUE ([id]),
102			FOREIGN KEY ([channel_id]) REFERENCES [channel] ([id]),
103			FOREIGN KEY ([user_id]) REFERENCES [user] ([id]),
104			FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name])
105			);
106
107			INSERT INTO [subscription] (id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service) SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM [subscription__temp__56bda64f128f1];
108			DROP TABLE [subscription__temp__56bda64f128f1];
109
110			PRAGMA foreign_keys = ON;
111			',
112			);
113			}
114
115			}

Jalle19 / tvheadend-status-manager

Push — master ( 33443d...de9a4e )

PropelMigration_1455269455::getDownSQL() B

Complexity

Size

Duplication

Duplication Side-by-Side

Filter issues like