Algo-Web / POData

src/POData/UriProcessor/XML2Array.php

Doc Comments +2 added lines, -3 removed lines

@@ -17,8 +17,7 @@ 
     }
     /**
      * Convert an XML to Array
-     * @param string $node_name - name of the root node to be converted
-     * @param array $arr - aray to be converterd
+     * @param string $input_xml
      * @return DOMDocument
      */
     public static function &createArray($input_xml) {
@@ -40,7 +39,7 @@ 
     }
     /**
      * Convert an Array to XML
-     * @param mixed $node - XML as a string or as an object of DOMDocument
+     * @param \DOMElement $node - XML as a string or as an object of DOMDocument
      * @return mixed
      */
     private static function &convert($node) {

Indentation +68 added lines, -68 removed lines

@@ -3,7 +3,7 @@ 
 
 class XML2Array {
     private static $xml = null;
-	private static $encoding = 'UTF-8';
+    private static $encoding = 'UTF-8';
     /**
      * Initialize the root XML node [optional]
      * @param $version
@@ -13,7 +13,7 @@ 
     public static function init($version = '1.0', $encoding = 'UTF-8', $format_output = true) {
         self::$xml = new \DOMDocument($version, $encoding);
         self::$xml->formatOutput = $format_output;
-		self::$encoding = $encoding;
+        self::$encoding = $encoding;
     }
     /**
      * Convert an XML to Array
@@ -23,18 +23,18 @@ 
      */
     public static function &createArray($input_xml) {
         $xml = self::getXMLRoot();
-		if(is_string($input_xml)) {
-			$parsed = $xml->loadXML($input_xml);
-			if(!$parsed) {
-				throw new \Exception('[XML2Array] Error parsing the XML string.');
-			}
-		} else {
-			if(get_class($input_xml) != 'DOMDocument') {
-				throw new \Exception('[XML2Array] The input XML object should be of type: DOMDocument.');
-			}
-			$xml = self::$xml = $input_xml;
-		}
-		$array[$xml->documentElement->tagName] = self::convert($xml->documentElement);
+        if(is_string($input_xml)) {
+            $parsed = $xml->loadXML($input_xml);
+            if(!$parsed) {
+                throw new \Exception('[XML2Array] Error parsing the XML string.');
+            }
+        } else {
+            if(get_class($input_xml) != 'DOMDocument') {
+                throw new \Exception('[XML2Array] The input XML object should be of type: DOMDocument.');
+            }
+            $xml = self::$xml = $input_xml;
+        }
+        $array[$xml->documentElement->tagName] = self::convert($xml->documentElement);
         self::$xml = null;    // clear the xml node in the class for 2nd time use.
         return $array;
     }
@@ -44,60 +44,60 @@ 
      * @return mixed
      */
     private static function &convert($node) {
-		$output = array();
-		switch ($node->nodeType) {
-			case XML_CDATA_SECTION_NODE:
-				$output['@cdata'] = trim($node->textContent);
-				break;
-			case XML_TEXT_NODE:
-				$output = trim($node->textContent);
-				break;
-			case XML_ELEMENT_NODE:
-				// for each child node, call the covert function recursively
-				for ($i=0, $m=$node->childNodes->length; $i<$m; $i++) {
-					$child = $node->childNodes->item($i);
-					$v = self::convert($child);
-					if(isset($child->tagName)) {
-						$t = $child->tagName;
-						// assume more nodes of same kind are coming
-						if(!isset($output[$t])) {
-							$output[$t] = array();
-						}
-						$output[$t][] = $v;
-					} else {
-						//check if it is not an empty text node
-						if($v !== '') {
-							$output = $v;
-						}
-					}
-				}
-				if(is_array($output)) {
-					// if only one node of its kind, assign it directly instead if array($value);
-					foreach ($output as $t => $v) {
-						if(is_array($v) && count($v)==1) {
-							$output[$t] = $v[0];
-						}
-					}
-					if(empty($output)) {
-						//for empty nodes
-						$output = '';
-					}
-				}
-				// loop through the attributes and collect them
-				if($node->attributes->length) {
-					$a = array();
-					foreach($node->attributes as $attrName => $attrNode) {
-						$a[$attrName] = (string) $attrNode->value;
-					}
-					// if its an leaf node, store the value in @value instead of directly storing it.
-					if(!is_array($output)) {
-						$output = array('@value' => $output);
-					}
-					$output['@attributes'] = $a;
-				}
-				break;
-		}
-		return $output;
+        $output = array();
+        switch ($node->nodeType) {
+            case XML_CDATA_SECTION_NODE:
+                $output['@cdata'] = trim($node->textContent);
+                break;
+            case XML_TEXT_NODE:
+                $output = trim($node->textContent);
+                break;
+            case XML_ELEMENT_NODE:
+                // for each child node, call the covert function recursively
+                for ($i=0, $m=$node->childNodes->length; $i<$m; $i++) {
+                    $child = $node->childNodes->item($i);
+                    $v = self::convert($child);
+                    if(isset($child->tagName)) {
+                        $t = $child->tagName;
+                        // assume more nodes of same kind are coming
+                        if(!isset($output[$t])) {
+                            $output[$t] = array();
+                        }
+                        $output[$t][] = $v;
+                    } else {
+                        //check if it is not an empty text node
+                        if($v !== '') {
+                            $output = $v;
+                        }
+                    }
+                }
+                if(is_array($output)) {
+                    // if only one node of its kind, assign it directly instead if array($value);
+                    foreach ($output as $t => $v) {
+                        if(is_array($v) && count($v)==1) {
+                            $output[$t] = $v[0];
+                        }
+                    }
+                    if(empty($output)) {
+                        //for empty nodes
+                        $output = '';
+                    }
+                }
+                // loop through the attributes and collect them
+                if($node->attributes->length) {
+                    $a = array();
+                    foreach($node->attributes as $attrName => $attrNode) {
+                        $a[$attrName] = (string) $attrNode->value;
+                    }
+                    // if its an leaf node, store the value in @value instead of directly storing it.
+                    if(!is_array($output)) {
+                        $output = array('@value' => $output);
+                    }
+                    $output['@attributes'] = $a;
+                }
+                break;
+        }
+        return $output;
     }
     /*
      * Get the root XML node, if there isn't one, create it.

Spacing +16 added lines, -16 removed lines

@@ -23,19 +23,19 @@ 
      */
     public static function &createArray($input_xml) {
         $xml = self::getXMLRoot();
-		if(is_string($input_xml)) {
+		if (is_string($input_xml)) {
 			$parsed = $xml->loadXML($input_xml);
-			if(!$parsed) {
+			if (!$parsed) {
 				throw new \Exception('[XML2Array] Error parsing the XML string.');
 			}
 		} else {
-			if(get_class($input_xml) != 'DOMDocument') {
+			if (get_class($input_xml) != 'DOMDocument') {
 				throw new \Exception('[XML2Array] The input XML object should be of type: DOMDocument.');
 			}
 			$xml = self::$xml = $input_xml;
 		}
 		$array[$xml->documentElement->tagName] = self::convert($xml->documentElement);
-        self::$xml = null;    // clear the xml node in the class for 2nd time use.
+        self::$xml = null; // clear the xml node in the class for 2nd time use.
         return $array;
     }
     /**
@@ -54,43 +54,43 @@ 
 				break;
 			case XML_ELEMENT_NODE:
 				// for each child node, call the covert function recursively
-				for ($i=0, $m=$node->childNodes->length; $i<$m; $i++) {
+				for ($i = 0, $m = $node->childNodes->length; $i < $m; $i++) {
 					$child = $node->childNodes->item($i);
 					$v = self::convert($child);
-					if(isset($child->tagName)) {
+					if (isset($child->tagName)) {
 						$t = $child->tagName;
 						// assume more nodes of same kind are coming
-						if(!isset($output[$t])) {
+						if (!isset($output[$t])) {
 							$output[$t] = array();
 						}
 						$output[$t][] = $v;
 					} else {
 						//check if it is not an empty text node
-						if($v !== '') {
+						if ($v !== '') {
 							$output = $v;
 						}
 					}
 				}
-				if(is_array($output)) {
+				if (is_array($output)) {
 					// if only one node of its kind, assign it directly instead if array($value);
 					foreach ($output as $t => $v) {
-						if(is_array($v) && count($v)==1) {
+						if (is_array($v) && count($v) == 1) {
 							$output[$t] = $v[0];
 						}
 					}
-					if(empty($output)) {
+					if (empty($output)) {
 						//for empty nodes
 						$output = '';
 					}
 				}
 				// loop through the attributes and collect them
-				if($node->attributes->length) {
+				if ($node->attributes->length) {
 					$a = array();
-					foreach($node->attributes as $attrName => $attrNode) {
+					foreach ($node->attributes as $attrName => $attrNode) {
 						$a[$attrName] = (string) $attrNode->value;
 					}
 					// if its an leaf node, store the value in @value instead of directly storing it.
-					if(!is_array($output)) {
+					if (!is_array($output)) {
 						$output = array('@value' => $output);
 					}
 					$output['@attributes'] = $a;
@@ -102,8 +102,8 @@ 
     /*
      * Get the root XML node, if there isn't one, create it.
      */
-    private static function getXMLRoot(){
-        if(empty(self::$xml)) {
+    private static function getXMLRoot() {
+        if (empty(self::$xml)) {
             self::init();
         }
         return self::$xml;

services/NorthWind/NorthWindDSExpressionProvider.php

Switch Indentation +91 added lines, -91 removed lines

@@ -294,103 +294,103 @@
     public function onFunctionCallExpression($functionDescription, $params)
     {
         switch ($functionDescription->functionName) {
-        case ODataConstants::STRFUN_COMPARE:
-            return "STRCMP($params[0]; $params[1])";
-            break;
-        case ODataConstants::STRFUN_ENDSWITH:
-          return "(($params[1]) = RIGHT(($params[0]), LEN($params[1])))";
-            break;
-        case ODataConstants::STRFUN_INDEXOF:
-          // In SQLServer the index of string starts from 1, but in OData
-          // the string start with index 0, so the below subtraction of 1
-          return "(CHARINDEX($params[1], $params[0]) - 1)";
-            break;
-        case ODataConstants::STRFUN_REPLACE:
-          return "REPLACE($params[0], $params[1], $params[2])";
-            break;
-        case ODataConstants::STRFUN_STARTSWITH:
-          return "(($params[1]) = LEFT(($params[0]), LEN($params[1])))";
-            break;
-        case ODataConstants::STRFUN_TOLOWER:
-          return "LOWER($params[0])";
-            break;
-        case ODataConstants::STRFUN_TOUPPER:
-          return "UPPER($params[0])";
-            break;
-        case ODataConstants::STRFUN_TRIM:
-          // OData supports trim function
-          // We don't have the same function SQL Server, so use SQL functions LTRIM and RTRIM together
-          // to achieve TRIM functionality.
-          return "RTRIM(LTRIM($params[0]))";
-            break;
-        case ODataConstants::STRFUN_SUBSTRING:
-          if (count($params) == 3) {
-                // 3 Param version of OData substring
-                return "SUBSTRING($params[0], $params[1] + 1, $params[2])";
-            } else {
-                // 2 Params version of OData substring
-            // We don't have the same function for SQL Server, we have only:
+            case ODataConstants::STRFUN_COMPARE:
+                return "STRCMP($params[0]; $params[1])";
+                break;
+            case ODataConstants::STRFUN_ENDSWITH:
+              return "(($params[1]) = RIGHT(($params[0]), LEN($params[1])))";
+                break;
+            case ODataConstants::STRFUN_INDEXOF:
+              // In SQLServer the index of string starts from 1, but in OData
+              // the string start with index 0, so the below subtraction of 1
+              return "(CHARINDEX($params[1], $params[0]) - 1)";
+                break;
+            case ODataConstants::STRFUN_REPLACE:
+              return "REPLACE($params[0], $params[1], $params[2])";
+                break;
+            case ODataConstants::STRFUN_STARTSWITH:
+              return "(($params[1]) = LEFT(($params[0]), LEN($params[1])))";
+                break;
+            case ODataConstants::STRFUN_TOLOWER:
+              return "LOWER($params[0])";
+                break;
+            case ODataConstants::STRFUN_TOUPPER:
+              return "UPPER($params[0])";
+                break;
+            case ODataConstants::STRFUN_TRIM:
+              // OData supports trim function
+              // We don't have the same function SQL Server, so use SQL functions LTRIM and RTRIM together
+              // to achieve TRIM functionality.
+              return "RTRIM(LTRIM($params[0]))";
+                break;
+            case ODataConstants::STRFUN_SUBSTRING:
+              if (count($params) == 3) {
+                    // 3 Param version of OData substring
+                    return "SUBSTRING($params[0], $params[1] + 1, $params[2])";
+                } else {
+                    // 2 Params version of OData substring
+                // We don't have the same function for SQL Server, we have only:
 
-            // SUBSTRING ( value_expression , start_expression , length_expression )
-            // http://msdn.microsoft.com/en-us/library/ms187748.aspx
+                // SUBSTRING ( value_expression , start_expression , length_expression )
+                // http://msdn.microsoft.com/en-us/library/ms187748.aspx
 
-            // If the sum of start_expression and length_expression is greater than the number of characters
-            // in value_expression, the whole value expression beginning at start_expression is returned
-            // In OData substring function the index start from 0, in SQL Server its from 1
-            return "SUBSTRING($params[0], $params[1] + 1, LEN($params[0]))";
-            }
-            break;
-        case ODataConstants::STRFUN_SUBSTRINGOF:
-          return "(CHARINDEX($params[0], $params[1]) != 0)";
-            break;
-        case ODataConstants::STRFUN_CONCAT:
-            return "$params[0] + $params[1]";
-            break;
-        case ODataConstants::STRFUN_LENGTH:
-            return "LEN($params[0])";
-            break;
-        case ODataConstants::GUIDFUN_EQUAL:
-            return "($params[0] = $params[1])";
-            break;
-        case ODataConstants::DATETIME_COMPARE:
-            return "DATETIMECMP($params[0]; $params[1])";
-            break;
-        case ODataConstants::DATETIME_YEAR:
-            return "YEAR($params[0])";
-            break;
-        case ODataConstants::DATETIME_MONTH:
-            return "MONTH($params[0])";
-            break;
-        case ODataConstants::DATETIME_DAY:
-            return "DAY($params[0])";
-            break;
-        case ODataConstants::DATETIME_HOUR:
-            return "DATENAME(HOUR, $params[0])";
-            break;
-        case ODataConstants::DATETIME_MINUTE:
-            return "DATENAME(MINUTE, $params[0])";
-            break;
-        case ODataConstants::DATETIME_SECOND:
-            return "DATENAME(SECOND, $params[0])";
-            break;
-        case ODataConstants::MATHFUN_ROUND:
-            return "ROUND($params[0], $this->_default_round)";
-            break;
-        case ODataConstants::MATHFUN_CEILING:
-            return "CEILING($params[0])";
-            break;
-        case ODataConstants::MATHFUN_FLOOR:
-            return "FLOOR($params[0])";
-            break;
-        case ODataConstants::BINFUL_EQUAL:
-            return "($params[0] = $params[1])";
-            break;
+                // If the sum of start_expression and length_expression is greater than the number of characters
+                // in value_expression, the whole value expression beginning at start_expression is returned
+                // In OData substring function the index start from 0, in SQL Server its from 1
+                return "SUBSTRING($params[0], $params[1] + 1, LEN($params[0]))";
+                }
+                break;
+            case ODataConstants::STRFUN_SUBSTRINGOF:
+              return "(CHARINDEX($params[0], $params[1]) != 0)";
+                break;
+            case ODataConstants::STRFUN_CONCAT:
+                return "$params[0] + $params[1]";
+                break;
+            case ODataConstants::STRFUN_LENGTH:
+                return "LEN($params[0])";
+                break;
+            case ODataConstants::GUIDFUN_EQUAL:
+                return "($params[0] = $params[1])";
+                break;
+            case ODataConstants::DATETIME_COMPARE:
+                return "DATETIMECMP($params[0]; $params[1])";
+                break;
+            case ODataConstants::DATETIME_YEAR:
+                return "YEAR($params[0])";
+                break;
+            case ODataConstants::DATETIME_MONTH:
+                return "MONTH($params[0])";
+                break;
+            case ODataConstants::DATETIME_DAY:
+                return "DAY($params[0])";
+                break;
+            case ODataConstants::DATETIME_HOUR:
+                return "DATENAME(HOUR, $params[0])";
+                break;
+            case ODataConstants::DATETIME_MINUTE:
+                return "DATENAME(MINUTE, $params[0])";
+                break;
+            case ODataConstants::DATETIME_SECOND:
+                return "DATENAME(SECOND, $params[0])";
+                break;
+            case ODataConstants::MATHFUN_ROUND:
+                return "ROUND($params[0], $this->_default_round)";
+                break;
+            case ODataConstants::MATHFUN_CEILING:
+                return "CEILING($params[0])";
+                break;
+            case ODataConstants::MATHFUN_FLOOR:
+                return "FLOOR($params[0])";
+                break;
+            case ODataConstants::BINFUL_EQUAL:
+                return "($params[0] = $params[1])";
+                break;
             case 'is_null':
             return "is_null($params[0])";
             break;
 
-        default:
-            throw new \InvalidArgumentException('onFunctionCallExpression');
+            default:
+                throw new \InvalidArgumentException('onFunctionCallExpression');
         }
     }
 

services/WordPress/WordPressDSExpressionProvider.php

Spacing +6 added lines, -6 removed lines

@@ -285,22 +285,22 @@
                 return "DATETIMECMP($params[0]; $params[1])";
                 break;
             case ODataConstants::DATETIME_YEAR:
-                return 'EXTRACT(YEAR from '.$params[0].')';
+                return 'EXTRACT(YEAR from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_MONTH:
-                return 'EXTRACT(MONTH from '.$params[0].')';
+                return 'EXTRACT(MONTH from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_DAY:
-                return 'EXTRACT(DAY from '.$params[0].')';
+                return 'EXTRACT(DAY from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_HOUR:
-                return 'EXTRACT(HOUR from '.$params[0].')';
+                return 'EXTRACT(HOUR from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_MINUTE:
-                return 'EXTRACT(MINUTE from '.$params[0].')';
+                return 'EXTRACT(MINUTE from ' . $params[0] . ')';
                 break;
             case ODataConstants::DATETIME_SECOND:
-                return 'EXTRACT(SECOND from '.$params[0].')';
+                return 'EXTRACT(SECOND from ' . $params[0] . ')';
                 break;
             case ODataConstants::MATHFUN_ROUND:
                 return "ROUND($params[0])";

services/WordPress/WordPressQueryProvider.php

Spacing +24 added lines, -24 removed lines

@@ -189,7 +189,7 @@ 
                 $query = 'SELECT * FROM `wp_posts` WHERE'
                         ." wp_posts.post_type = 'post'"
                         ." AND wp_posts.post_status = 'publish'"
-                        .' AND wp_posts.ID = '.$namedKeyValues['PostID'][0];
+                        .' AND wp_posts.ID = ' . $namedKeyValues['PostID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -205,7 +205,7 @@ 
                         .' FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt'
                         .' ON tt.term_id = t.term_id'
                         ." WHERE tt.taxonomy = 'post_tag'"
-                        .' AND t.term_id = '.$namedKeyValues['TagID'][0];
+                        .' AND t.term_id = ' . $namedKeyValues['TagID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -221,7 +221,7 @@ 
                         .' FROM `wp_terms` AS t INNER JOIN `wp_term_taxonomy` as tt'
                         .' ON tt.term_id = t.term_id'
                         ." WHERE tt.taxonomy = 'category'"
-                        .' AND t.term_id = '.$namedKeyValues['CategoryID'][0];
+                        .' AND t.term_id = ' . $namedKeyValues['CategoryID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -235,7 +235,7 @@ 
             case 'Comments':
                 $query = 'SELECT * FROM `wp_comments`'
                         .' WHERE comment_approved = 1'
-                        .' AND comment_ID = '.$namedKeyValues['CommentID'][0];
+                        .' AND comment_ID = ' . $namedKeyValues['CommentID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -247,7 +247,7 @@ 
                 $result = $this->_serializeComment($data);
                 break;
             case 'Users':
-                $query = 'SELECT * FROM `wp_users` WHERE ID = '.$namedKeyValues['UserID'][0];
+                $query = 'SELECT * FROM `wp_users` WHERE ID = ' . $namedKeyValues['UserID'][0];
                 $stmt = mysql_query($query);
 
                 //If resource not found return null to the library
@@ -344,7 +344,7 @@ 
 
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -369,7 +369,7 @@ 
 
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Tag does not have navigation porperty with name: '.$navigationPropName);
+                    die('Tag does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -394,12 +394,12 @@ 
 
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Category does not have navigation porperty with name: '.$navigationPropName);
+                    die('Category does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
             case $srcClass == 'Comment':
-                die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 break;
 
             case $srcClass == 'User':
@@ -431,7 +431,7 @@ 
 
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('User does not have navigation porperty with name: '.$navigationPropName);
+                    die('User does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }
@@ -484,7 +484,7 @@ 
                             .' ON tr.term_taxonomy_id = tt.term_taxonomy_id'
                             ." WHERE tt.taxonomy IN ('post_tag')"
                             ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
-                            .' AND tt.term_id = '.$namedKeyValues['TagID'][0];
+                            .' AND tt.term_id = ' . $namedKeyValues['TagID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeTags($stmt);
                 } elseif ($navigationPropName == 'Categories') {
@@ -496,18 +496,18 @@ 
                             .' ON tr.term_taxonomy_id = tt.term_taxonomy_id'
                             ." WHERE tt.taxonomy IN ('category')"
                             ." AND tr.object_id IN ($sourceEntityInstance->PostID)"
-                            .' AND tt.term_id = '.$namedKeyValues['CategoryID'][0];
+                            .' AND tt.term_id = ' . $namedKeyValues['CategoryID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeCategories($stmt);
                 } elseif ($navigationPropName == 'Comments') {
                     $query = 'SELECT * FROM `wp_comments`'
                             .' WHERE comment_approved = 1'
                             ." AND comment_post_ID = $sourceEntityInstance->PostID"
-                            .' AND comment_ID = '.$namedKeyValues['CommentID'][0];
+                            .' AND comment_ID = ' . $namedKeyValues['CommentID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -522,11 +522,11 @@ 
                                 ." WHERE tt.term_id = $sourceEntityInstance->TagID"
                                 ." AND p.post_type = 'post'"
                                 ." AND p.post_status = 'publish'"
-                                .' AND p.ID = '.$namedKeyValues['PostID'][0];
+                                .' AND p.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Tag does not have navigation porperty with name: '.$navigationPropName);
+                    die('Tag does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -541,16 +541,16 @@ 
                                 ." WHERE tt.term_id = $sourceEntityInstance->CategoryID"
                                 ." AND p.post_type = 'post'"
                                 ." AND p.post_status = 'publish'"
-                                .' AND p.ID = '.$namedKeyValues['PostID'][0];
+                                .' AND p.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } else {
-                    die('Category does not have navigation porperty with name: '.$navigationPropName);
+                    die('Category does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
             case $srcClass == 'Comment':
-                die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 break;
 
             case $srcClass == 'User':
@@ -559,18 +559,18 @@ 
                             ." wp_posts.post_type = 'post'"
                             ." AND wp_posts.post_status = 'publish'"
                             ." AND wp_posts.post_author = $sourceEntityInstance->UserID"
-                            .' AND wp_posts.ID = '.$namedKeyValues['PostID'][0];
+                            .' AND wp_posts.ID = ' . $namedKeyValues['PostID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializePosts($stmt);
                 } elseif ($navigationPropName == 'Comments') {
                     $query = 'SELECT * FROM `wp_comments`'
                             .' WHERE comment_approved = 1'
                             ." AND wp_comments.user_id = $sourceEntityInstance->UserID"
-                            .' AND wp_comments.comment_ID = '.$namedKeyValues['CommentID'][0];
+                            .' AND wp_comments.comment_ID = ' . $namedKeyValues['CommentID'][0];
                     $stmt = mysql_query($query);
                     $result = $this->_serializeComments($stmt);
                 } else {
-                    die('User does not have navigation porperty with name: '.$navigationPropName);
+                    die('User does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }
@@ -616,7 +616,7 @@ 
                         $result = null;
                     }
                 } else {
-                    die('Post does not have navigation porperty with name: '.$navigationPropName);
+                    die('Post does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
 
@@ -651,7 +651,7 @@ 
                     $data = mysql_fetch_assoc($stmt);
                     $result = $this->_serializePost($data);
                 } else {
-                    die('Comment does not have navigation porperty with name: '.$navigationPropName);
+                    die('Comment does not have navigation porperty with name: ' . $navigationPropName);
                 }
                 break;
         }