Differential D12454 Diff 29950 src/infrastructure/query/PhabricatorQuery.php

Changeset View

Standalone View

src/infrastructure/query/PhabricatorQuery.php

	<?php			<?php

				/**
				* @task format Formatting Query Clauses
				*/
	abstract class PhabricatorQuery {			abstract class PhabricatorQuery {


	abstract public function execute();			abstract public function execute();

	final protected function formatWhereClause(array $parts) {
	$parts = array_filter($parts);

				/* -( Formatting Query Clauses )------------------------------------------- */


				/**
				* @task format
				*/
				protected function formatWhereClause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				return '';
				}

				return 'WHERE '.$this->formatWhereSubclause($parts);
				}


				/**
				* @task format
				*/
				protected function formatWhereSubclause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				return null;
				}

				return '('.implode(') AND (', $parts).')';
				}


				/**
				* @task format
				*/
				protected function formatSelectClause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				throw new Exception(pht('Can not build empty select clause!'));
				}

				return 'SELECT '.$this->formatSelectSubclause($parts);
				}


				/**
				* @task format
				*/
				protected function formatSelectSubclause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				return null;
				}
				return implode(', ', $parts);
				}


				/**
				* @task format
				*/
				protected function formatJoinClause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				return '';
				}

				return implode(' ', $parts);
				}


				/**
				* @task format
				*/
				protected function formatHavingClause(array $parts) {
				$parts = $this->flattenSubclause($parts);
	if (!$parts) {			if (!$parts) {
	return '';			return '';
	}			}

	return 'WHERE ('.implode(') AND (', $parts).')';			return 'HAVING '.$this->formatHavingSubclause($parts);
				}


				/**
				* @task format
				*/
				protected function formatHavingSubclause(array $parts) {
				$parts = $this->flattenSubclause($parts);
				if (!$parts) {
				return null;
				}

				return '('.implode(') AND (', $parts).')';
				}


				/**
				* @task format
				*/
				private function flattenSubclause(array $parts) {
				$result = array();
				foreach ($parts as $part) {
				if (is_array($part)) {
				foreach ($this->flattenSubclause($part) as $subpart) {
				$result[] = $subpart;
				}
				} else if (strlen($part)) {
				$result[] = $part;
				}
				}
				return $result;
	}			}

	}			}