Insert::orIgnore() - Code Metrics - Inspection of "fixed many-to-many relations" - oscarotero/simple-crud - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( cda99f...f447a0 )

by Oscar

created 2019-11-28 19:26 UTC

Insert::orIgnore() A

↳ Parent: Insert

Complexity

Conditions	3
Paths	3

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	15
rs	9.7666
c	0
b	0
f	0
cc	3
nc	3
nop	0

<?php
declare(strict_types = 1);

namespace SimpleCrud\Queries;

use SimpleCrud\Table;

final class Insert extends Query
{
    protected const ALLOWED_METHODS = [
        'setFlag',
        'set',
    ];

    public function __construct(Table $table, array $data = [])
    {
        $this->table = $table;

        $this->query = $table->getDatabase()
            ->insert()
            ->into((string) $table);

        foreach ($data as $fieldName => $value) {
            $this->table->{$fieldName}->insert($this->query, $value);
        }
    }

    public function orIgnore(): self
    {
        $engine = $this->table->getDatabase()->getConnection()->getDriverName();

        switch ($engine) {
            case 'mysql':
                $this->query->setFlag('IGNORE');
                break;
            case 'sqlite':
                $this->query->setFlag('OR IGNORE');
                break;
        }

        return $this;
    }

    public function run()
    {
        $this->__invoke();

        $id = $this->table->getDatabase()->lastInsertId();

        return $this->table->id->format($id);
    }
}


1			<?php
2			declare(strict_types = 1);
3
4			namespace SimpleCrud\Queries;
5
6			use SimpleCrud\Table;
7
8			final class Insert extends Query
9			{
10			protected const ALLOWED_METHODS = [
11			'setFlag',
12			'set',
13			];
14
15			public function __construct(Table $table, array $data = [])
16			{
17			$this->table = $table;
18
19			$this->query = $table->getDatabase()
20			->insert()
21			->into((string) $table);
22
23			foreach ($data as $fieldName => $value) {
24			$this->table->{$fieldName}->insert($this->query, $value);
25			}
26			}
27
28			public function orIgnore(): self
29			{
30			$engine = $this->table->getDatabase()->getConnection()->getDriverName();
31
32			switch ($engine) {
33			case 'mysql':
34			$this->query->setFlag('IGNORE');
35			break;
36			case 'sqlite':
37			$this->query->setFlag('OR IGNORE');
38			break;
39			}
40
41			return $this;
42			}
43
44			public function run()
45			{
46			$this->__invoke();
47
48			$id = $this->table->getDatabase()->lastInsertId();
49
50			return $this->table->id->format($id);
51			}
52			}
53

oscarotero / simple-crud

Push — master ( cda99f...f447a0 )

Insert::orIgnore() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like