PhpBoot\DB\rules\insert\ValuesRule

Complexity

Total Complexity

2

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	values()	0	4	1
A	batchValues()	0	4	1

<?php

For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 14 and the first side effect is on line 11.

namespace PhpBoot\DB\rules\insert;

use PhpBoot\DB\DB;
use PhpBoot\DB\impls\OnDuplicateKeyUpdateImpl;
use PhpBoot\DB\rules\basic\BasicRule;
use PhpBoot\DB\rules\basic\ExecRule;
use PhpBoot\DB\impls\InsertImpl;
use PhpBoot\DB\impls\ValuesImpl;

require_once dirname(__DIR__).'/impls.php';
require_once __DIR__.'/basic.php';

class InsertRule extends BasicRule
{
    /**
     * 
     * insertInto('table')->values([1,2]) => "INSERT INTO table VALUES(1,2)"
     * @param string $table
     * @return \PhpBoot\DB\rules\insert\ValuesRule
     */
    public function insertInto($table) {
        InsertImpl::insertInto($this->context, $table);
        return new ValuesRule($this->context);
    }
}
class ValuesRule extends BasicRule

PSR1 recommends that each class should be in its own file to aid autoloaders.

{
    /**
     *
     * insertInto('table')->values([1,2]) => "INSERT INTO table VALUES(1,2)"
     * insertInto('table')->values(['a'=>1, 'b'=>Sql::raw('now()')]) => "INSERT INTO table(a,b) VALUES(1,now())"
     * @param array $values
     * @return \PhpBoot\DB\rules\insert\OnDuplicateKeyUpdateRule
     */
    public function values(array $values) {
        ValuesImpl::values($this->context, $values);
        return new OnDuplicateKeyUpdateRule($this->context);
    }

    /**
     * insertInto('table')->batchValues([[1,2],[3,4]]) => "INSERT INTO table VALUES(1,2), (3,2)"
     *
     * @param array $values
     * @return \PhpBoot\DB\rules\insert\OnDuplicateKeyUpdateRule
     */
    public function batchValues(array $values){
        ValuesImpl::batchValues($this->context, $values);
        return new OnDuplicateKeyUpdateRule($this->context);
    }
}

class OnDuplicateKeyUpdateRule extends ExecRule

PSR1 recommends that each class should be in its own file to aid autoloaders.

{
    public function __construct($context)
    {
        parent::__construct($context);
        $this->impl = new OnDuplicateKeyUpdateImpl();
    }

//    /**

43% of this comment could be valid code. Did you maybe forget this after debugging?

//     *
//     * insertInto('table')
//     *      ->values(['a'=>1, 'b'=>Sql::raw('now()')])
//     *      ->onDuplicateKeyUpdate('a', Sql::raw('a+1'))
//     *  => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
//     *
//     * @param string $column
//     * @param mixed $value
//     * @return \PhpBoot\DB\rules\basic\ExecRule
//     */
//    public function onDuplicateKeyUpdate($column, $value) {
//        $this->impl->set($this->context, $column, $value);
//        return new ExecRule($this->context);
//    }

//    /**

43% of this comment could be valid code. Did you maybe forget this after debugging?

//     *
//     * insertInto('table')
//     *      ->values(['a'=>1, 'b'=>Sql::raw('now()')])
//     *      ->onDuplicateKeyUpdateArgs(['a'=>Sql::raw('a+1')])
//     *  => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
//     *
//     * @param string $column
//     * @param mixed $value
//     * @return \PhpBoot\DB\rules\basic\ExecRule
//     */
//    public function onDuplicateKeyUpdateArgs($values) {
//        $this->impl->setArgs($this->context, $values);
//        return new ExecRule($this->context);
//    }

    /**
     *
     *  insertInto('table')
     *      ->values(['a'=>1, 'b'=>Sql::raw('now()')])
     *      ->onDuplicateKeyUpdate(['a'=>Sql::raw('a+1')])
     *  => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
     *
     * insertInto('table')
     *      ->values(['a'=>1, 'b'=>Sql::raw('now()')])
     *      ->onDuplicateKeyUpdate('a=a+1')
     *  => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
     *
     * @param string $column

There is no parameter named $column. Was it maybe removed?

     * @param mixed $value

There is no parameter named $value. Was it maybe removed?

     * @return \PhpBoot\DB\rules\basic\ExecRule
     */
    public function onDuplicateKeyUpdate($expr, $_=null) {

The parameter $_ is not used and could be removed.

        $this->impl->set($this->context, $expr, array_slice(func_get_args(), 1));
        return new ExecRule($this->context);
    }
    private $impl;
}