class DbQuerySniff

Check that UPDATE/DELETE queries are not used in db_query() in Drupal 7.

@category PHP @package PHP_CodeSniffer @link http://pear.php.net/package/PHP_CodeSniffer

Hierarchy

class \Drupal\Sniffs\Semantics\FunctionCall implements \PHP_CodeSniffer\Sniffs\Sniff
- class \DrupalPractice\Sniffs\FunctionCalls\DbQuerySniff extends \Drupal\Sniffs\Semantics\FunctionCall

Expanded class hierarchy of DbQuerySniff

File

vendor/drupal/coder/coder_sniffer/DrupalPractice/Sniffs/FunctionCalls/DbQuerySniff.php, line 23

Namespace

DrupalPractice\Sniffs\FunctionCalls

View source

class DbQuerySniff extends FunctionCall {
    
    /**
     * Returns an array of function names this test wants to listen for.
     *
     * @return array<string>
     */
    public function registerFunctionNames() {
        return [
            'db_query',
        ];
    }
    
    //end registerFunctionNames()
    
    /**
     * Processes this function call.
     *
     * @param \PHP_CodeSniffer\Files\File $phpcsFile    The file being scanned.
     * @param int                         $stackPtr     The position of the function call in
     *                                                  the stack.
     * @param int                         $openBracket  The position of the opening
     *                                                  parenthesis in the stack.
     * @param int                         $closeBracket The position of the closing
     *                                                  parenthesis in the stack.
     *
     * @return void|int
     */
    public function processFunctionCall(File $phpcsFile, $stackPtr, $openBracket, $closeBracket) {
        // This check only applies to Drupal 7, not Drupal 6.
        if (Project::getCoreVersion($phpcsFile) !== 7) {
            return $phpcsFile->numTokens + 1;
        }
        $tokens = $phpcsFile->getTokens();
        $argument = $this->getArgument(1);
        $queryStart = '';
        for ($start = $argument['start']; $tokens[$start]['code'] === T_CONSTANT_ENCAPSED_STRING && empty($queryStart) === true; $start++) {
            // Remove quote and white space from the beginning.
            $queryStart = trim(substr($tokens[$start]['content'], 1));
            // Just look at the first word.
            $parts = explode(' ', $queryStart);
            $queryStart = $parts[0];
            if (in_array(strtoupper($queryStart), [
                'INSERT',
                'UPDATE',
                'DELETE',
                'TRUNCATE',
            ]) === true) {
                $warning = 'Do not use %s queries with db_query(), use %s instead';
                $phpcsFile->addWarning($warning, $start, 'DbQuery', [
                    $queryStart,
                    'db_' . strtolower($queryStart) . '()',
                ]);
            }
        }
    }
    
    //end processFunctionCall()

}

Members

Title Sort descending	Modifiers	Object type	Summary	Overriden Title	Overrides
DbQuerySniff::processFunctionCall	public	function	Processes this function call.
DbQuerySniff::registerFunctionNames	public	function	Returns an array of function names this test wants to listen for.
FunctionCall::$arguments	protected	property	Internal cache to save the calculated arguments of the function call.
FunctionCall::$closeBracket	protected	property	The token position of the closing bracket of the function call.
FunctionCall::$functionCall	protected	property	The token position of the function call.
FunctionCall::$includeMethodCalls	protected	property	Whether method invocations with the same function name should be processed, too.		1
FunctionCall::$openBracket	protected	property	The token position of the opening bracket of the function call.
FunctionCall::$phpcsFile	protected	property	The currently processed file.
FunctionCall::getArgument	public	function	Returns start and end token for a given argument number.
FunctionCall::isFunctionCall	protected	function	Checks if this is a function call.
FunctionCall::process	public	function	Processes this test, when one of its tokens is encountered.	Overrides Sniff::process	2
FunctionCall::register	public	function	Returns an array of tokens this test wants to listen for.	Overrides Sniff::register