DBAL\Modifiers\Operators

Complexity

Total Complexity

5

Size/Duplication

Total Lines	93
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

87.5%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getOperatorFormat()	0	7	2
A	isOperatorValid()	0	7	2
A	isOperatorPrepared()	0	4	1

<?php

namespace DBAL\Modifiers;

class Operators
{
    const OPERATORS = array(
        '>' => array(
            'format' => '> ?',
            'prepared' => true
        ),
        '>=' => array(
            'format' => '>= ?',
            'prepared' => true
        ),
        '<' => array(
            'format' => '< ?',
            'prepared' => true
        ),
        '<=' => array(
            'format' => '<= ?',
            'prepared' => true
        ),
        '!=' => array(
            'format' => '!= ?',
            'prepared' => true
        ),
        'LIKE' => array(
            'format' => 'LIKE ?',
            'prepared' => true
        ),
        'NOT LIKE' => array(
            'format' => 'NOT LIKE ?',
            'prepared' => true
        ),
        'IN' => array(
            'format' => 'IN (%s)',
            'prepared' => true
        ),
        'NOT IN' => array(
            'format' => 'NOT IN (%s)',
            'prepared' => true
        ),
        'BETWEEN' => array(
            'format' => 'BETWEEN ? AND ?',
            'prepared' => true
        ),
        'NOT BETWEEN' => array(
            'format' => 'NOT BETWEEN ? AND ?',
            'prepared' => true
        ),
        'IS NULL' => array(
            'format' => 'IS NULL',
            'prepared' => false
        ),
        'IS NOT NULL' => array(
            'format' => 'IS NOT NULL',
            'prepared' => false
        )
    );
    
    /**
     * Gets the correct formated string for the operator
     * @param string $value This should be the operator value
     * @return string The string to add to the database will be added
     */
    public static function getOperatorFormat($value)
    {
        if (array_key_exists(strtoupper(strval($value)), self::OPERATORS)) {
            return self::OPERATORS[strtoupper($value)]['format'];
        }
        return '= ?';
    }
    
    /**
     * Checks to see if the operator is valid
     * @param string $operator This should be the operator value
     * @return boolean If the operator exists in the array will return true else returns false
     */
    public static function isOperatorValid($operator)
    {
        if (array_key_exists(strtoupper(strval($operator)), self::OPERATORS)) {
            return true;
        }
        return false;
    }
    
    /**
     * Checks to see if a prepared statement value should be added
     * @param string $value This should be the operator value
     * @return boolean If the operator should be prepared returns true else returns false
     */
    public static function isOperatorPrepared($value)
    {
        return self::OPERATORS[strtoupper(strval($value))]['prepared'];
    }
}