Ubiquity\db\SqlUtils

Complexity

Total Complexity

26

Size/Duplication

Total Lines	100
Duplicated Lines	21 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	getParameters()	0	7	2
A	getQuotedKeys()	0	7	2
A	getWhere()	7	7	2
A	getMultiWhere()	7	7	2
A	getSearchWhere()	0	7	2
A	getInsertFields()	0	3	1
A	getInsertFieldsValues()	0	3	1
A	getUpdateFieldsKeyAndValues()	7	7	2
A	checkWhere()	0	7	3
B	getCondition()	0	17	5
A	getFieldList()	0	13	4

<?php

namespace Ubiquity\db;

use Ubiquity\utils\base\UArray;
use Ubiquity\orm\OrmUtils;

/**
 * Utilitaires SQL
 * @author jc
 * @version 1.0.0.4
 */
class SqlUtils {
	
	public static $quote='`';

	private static function getParameters($keyAndValues) {
		$ret=array ();
		foreach ( $keyAndValues as $key => $value ) {
			$ret[]=":" . $key;
		}
		return $ret;
	}

	private static function getQuotedKeys($keyAndValues) {
		$ret=array ();
		foreach ( $keyAndValues as $key => $value ) {
			$ret[]=self::$quote . $key . self::$quote;
		}
		return $ret;
	}

	public static function getWhere($keyAndValues) {

This method seems to be duplicated in your project.

		$ret=array ();
		foreach ( $keyAndValues as $key => $value ) {
			$ret[]=self::$quote . $key . self::$quote . "= :" . $key;
		}
		return implode(" AND ", $ret);
	}

	public static function getMultiWhere($values, $field) {

This method seems to be duplicated in your project.

		$ret=array ();
		foreach ( $values as $value ) {
			$ret[]=self::$quote . $field . self::$quote . "='" . $value . "'";
		}
		return implode(" OR ", $ret);
	}
	
	public static function getSearchWhere($fields, $value,$jokerBefore="%",$jokerAfter="%") {
		$ret=array ();
		foreach ( $fields as $field ) {
			$ret[]=self::$quote . $field . self::$quote . " LIKE '".$jokerBefore . $value . $jokerAfter."'";
		}
		return implode(" OR ", $ret);
	}

	public static function getInsertFields($keyAndValues) {
		return implode(",", self::getQuotedKeys($keyAndValues));
	}

	public static function getInsertFieldsValues($keyAndValues) {
		return implode(",", self::getParameters($keyAndValues));
	}

	public static function getUpdateFieldsKeyAndValues($keyAndValues) {

This method seems to be duplicated in your project.

		$ret=array ();
		foreach ( $keyAndValues as $key => $value ) {
			$ret[]=self::$quote . $key . self::$quote . "= :" . $key;
		}
		return implode(",", $ret);
	}

	public static function checkWhere($condition){
		$c=\strtolower($condition);
		if ($condition != '' && \strstr($c, " join ")===false){
			$condition=" WHERE " . $condition;
		}
		return $condition;
	}

	public static function getCondition($keyValues,$classname=NULL,$separator=" AND ") {
		$retArray=array ();
		if (is_array($keyValues)) {
			if(!UArray::isAssociative($keyValues)){
				if(isset($classname)){
					$keys=OrmUtils::getKeyFields($classname);
					$keyValues=\array_combine($keys, $keyValues);
				}
			}
			foreach ( $keyValues as $key => $value ) {
				$retArray[]=self::$quote . $key . self::$quote . " = '" . $value . "'";
			}
			$condition=implode($separator, $retArray);
		} else
			$condition=$keyValues;
		return $condition;
	}

	public static function getFieldList($fields,$tableName=false){
		if(!\is_array($fields)){
			return $fields;
		}
		$result=[];
		$prefix="";
		if($tableName)
			$prefix=self::$quote.$tableName.self::$quote.".";
		foreach ($fields as $field) {
			$result[]= $prefix.self::$quote.$field.self::$quote;
		}
		return \implode(",", $result);
	}
}