CreateUserSettingsTrigger::up() - Code Metrics - Inspection of "Corrected 'use' paths to correct case" - butcherman/Tech_Bench - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — dev5 ( b08d9a...c43caf )

by Ron

created 2019-11-09 04:12 UTC

CreateUserSettingsTrigger::up() A

↳ Parent: CreateUserSettingsTrigger

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	11
rs	9.9
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUserSettingsTrigger extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //  Create the trigger to build this table as a new user is created
        DB::unprepared(
            'CREATE TRIGGER `tr_user_settings` AFTER INSERT ON `users` 
                FOR EACH ROW 
                BEGIN
                    INSERT INTO `user_settings` (`user_id`) VALUES (NEW.user_id);
                END;'
        );
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::unprepared('DROP TRIGGER IF EXISTS `tr_user_settings`');
    }
}


1			<?php
2
3			use Illuminate\Support\Facades\Schema;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Migrations\Migration;
6
7			class CreateUserSettingsTrigger extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			// Create the trigger to build this table as a new user is created
17			DB::unprepared(
18			'CREATE TRIGGER `tr_user_settings` AFTER INSERT ON `users`
19			FOR EACH ROW
20			BEGIN
21			INSERT INTO `user_settings` (`user_id`) VALUES (NEW.user_id);
22			END;'
23			);
24			}
25
26			/**
27			* Reverse the migrations.
28			*
29			* @return void
30			*/
31			public function down()
32			{
33			DB::unprepared('DROP TRIGGER IF EXISTS `tr_user_settings`');
34			}
35			}
36

butcherman / Tech_Bench

Push — dev5 ( b08d9a...c43caf )

CreateUserSettingsTrigger::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like