12489544920

Committed 25 Dec 2024 04:53AM UTC coverage: 78.401% (+0.02%) from 78.385%

Build # 12489544920

Build Type

Pull #168

github

Committed by

web-flow

Commit Message

Merge a36445178 into 338a94856

Pull Request Pull Request #168: #140 global export mode not affect for email testing

Run Details

2 of 2 new or added lines in 1 file covered. (100.0%)

1020 of 1301 relevant lines covered (78.4%)

11.92 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

0.0

/src/Traits/MigrationTrait.php

<?php

namespace RonasIT\Support\Traits;

use Illuminate\Support\Str;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;

trait MigrationTrait
{
    public function addForeignKey($fromEntity, $toEntity, $needAddField = false, $onDelete = 'cascade')
    {
        Schema::table(
            $this->getTableName($fromEntity),
            function (Blueprint $table) use ($toEntity, $needAddField, $onDelete) {
                $fieldName = Str::snake($toEntity) . '_id';

                if ($needAddField) {
                    $table->unsignedInteger($fieldName);
                }

                $table
                    ->foreign($fieldName)
                    ->references('id')
                    ->on($this->getTableName($toEntity))
                    ->onDelete($onDelete);
            }
        );
    }

    public function dropForeignKey($fromEntity, $toEntity, $needDropField = false)
    {
        $field = Str::snake($toEntity) . '_id';
        $table = $this->getTableName($fromEntity);

        if (Schema::hasColumn($table, $field)) {
            Schema::table($table, function (Blueprint $table) use ($field, $needDropField) {
                $table->dropForeign([$field]);

                if ($needDropField) {
                    $table->dropColumn([$field]);
                }
            });
        }
    }

    public function createBridgeTable($fromEntity, $toEntity)
    {
        $bridgeTableName = $this->getBridgeTable($fromEntity, $toEntity);

        Schema::create($bridgeTableName, function (Blueprint $table) {
            $table->increments('id');
        });

        $this->addForeignKey($bridgeTableName, $fromEntity, true);
        $this->addForeignKey($bridgeTableName, $toEntity, true);
    }

    public function dropBridgeTable($fromEntity, $toEntity)
    {
        $bridgeTableName = $this->getBridgeTable($fromEntity, $toEntity);

        $this->dropForeignKey($bridgeTableName, $fromEntity, true);
        $this->dropForeignKey($bridgeTableName, $toEntity, true);

        Schema::drop($bridgeTableName);
    }

    protected function getBridgeTable($fromEntity, $toEntity)
    {
        $entities = [Str::snake($fromEntity), Str::snake($toEntity)];
        sort($entities, SORT_STRING);

        return implode('_', $entities);
    }

    protected function getTableName($entityName)
    {
        if (Schema::hasTable($entityName)) {
            return $entityName;
        }

        $entityName = Str::snake($entityName);

        return Str::plural($entityName);
    }
}

1	<?php
2
3	namespace RonasIT\Support\Traits;
4
5	use Illuminate\Support\Str;
6	use Illuminate\Support\Facades\Schema;
7	use Illuminate\Database\Schema\Blueprint;
8
9	trait MigrationTrait
10	{
11	public function addForeignKey($fromEntity, $toEntity, $needAddField = false, $onDelete = 'cascade')
12	{
13	Schema::table(	×
14	$this->getTableName($fromEntity),	×
15	function (Blueprint $table) use ($toEntity, $needAddField, $onDelete) {	×
16	$fieldName = Str::snake($toEntity) . '_id';	×
17
18	if ($needAddField) {	×
19	$table->unsignedInteger($fieldName);	×
20	}
21
22	$table	×
23	->foreign($fieldName)	×
24	->references('id')	×
25	->on($this->getTableName($toEntity))	×
26	->onDelete($onDelete);	×
27	}	×
28	);	×
29	}
30
31	public function dropForeignKey($fromEntity, $toEntity, $needDropField = false)
32	{
33	$field = Str::snake($toEntity) . '_id';	×
34	$table = $this->getTableName($fromEntity);	×
35
36	if (Schema::hasColumn($table, $field)) {	×
37	Schema::table($table, function (Blueprint $table) use ($field, $needDropField) {	×
38	$table->dropForeign([$field]);	×
39
40	if ($needDropField) {	×
41	$table->dropColumn([$field]);	×
42	}
43	});	×
44	}
45	}
46
47	public function createBridgeTable($fromEntity, $toEntity)
48	{
49	$bridgeTableName = $this->getBridgeTable($fromEntity, $toEntity);	×
50
51	Schema::create($bridgeTableName, function (Blueprint $table) {	×
52	$table->increments('id');	×
53	});	×
54
55	$this->addForeignKey($bridgeTableName, $fromEntity, true);	×
56	$this->addForeignKey($bridgeTableName, $toEntity, true);	×
57	}
58
59	public function dropBridgeTable($fromEntity, $toEntity)
60	{
61	$bridgeTableName = $this->getBridgeTable($fromEntity, $toEntity);	×
62
63	$this->dropForeignKey($bridgeTableName, $fromEntity, true);	×
64	$this->dropForeignKey($bridgeTableName, $toEntity, true);	×
65
66	Schema::drop($bridgeTableName);	×
67	}
68
69	protected function getBridgeTable($fromEntity, $toEntity)
70	{
71	$entities = [Str::snake($fromEntity), Str::snake($toEntity)];	×
72	sort($entities, SORT_STRING);	×
73
74	return implode('_', $entities);	×
75	}
76
77	protected function getTableName($entityName)
78	{
79	if (Schema::hasTable($entityName)) {	×
80	return $entityName;	×
81	}
82
83	$entityName = Str::snake($entityName);	×
84
85	return Str::plural($entityName);	×
86	}
87	}

RonasIT / laravel-helpers / 12489544920

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous