ApiComponent::getDocumentByIdSql() - Code Metrics - Inspection of "Merge branch 'develop'" - jenskooij/cloudcontrol - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( a1bf27...3a2d72 )

by Jens

created 2018-03-27 12:54 UTC

ApiComponent::getDocumentByIdSql() A

↳ Parent: ApiComponent

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	2
nc	1
nop	2
dl	0
loc	5
rs	9.4285
c	0
b	0
f	0

<?php
/**
 * Created by jensk on 26-3-2018.
 */

namespace CloudControl\Cms\components;


use CloudControl\Cms\cc\Application;
use CloudControl\Cms\components\api\Response;
use CloudControl\Cms\search\CharacterFilter;
use CloudControl\Cms\search\results\SearchSuggestion;
use CloudControl\Cms\search\Search;
use CloudControl\Cms\search\Tokenizer;
use CloudControl\Cms\storage\entities\Document;
use CloudControl\Cms\storage\Storage;
use CloudControl\Cms\storage\storage\DocumentStorage;

class ApiComponent extends CachableBaseComponent
{
    /**
     * @var Response
     */
    protected $response;

    /**
     * @param Storage $storage
     */
    public function run(Storage $storage)
    {
        parent::run($storage);
        header('Content-Type: application/json');
        header('Access-Control-Allow-Origin: *');
        $this->response = $this->getResponse();
    }

    /**
     * @return Response
     */
    private function getResponse()
    {
        try {
            if (isset($_GET['id'])) {
                return $this->getSingleDocumentResponse();
            }

            if (isset($_GET['q'])) {
                return $this->getSearchDocumentsResponse();
            }

            return $this->getRootDocumentsResponse();
        } catch (\Exception $e) {
            $error = $e->getFile() . ':' . $e->getLine() . ' ' . $e->getMessage();
            return new Response(array(), false, $error);
        }
    }

    /**
     * @return Document
     */
    private function getDocumentById()
    {
        $id = intval($_GET['id']);
        $db = $this->storage->getRepository()->getContentRepository()->getContentDbHandle();
        $stmt = $this->getPDOStatement($db, $this->getDocumentByIdSql($db, $id));
        return $stmt->fetchObject(Document::class);
    }

    /**
     * @param \PDO $db
     * @param int $id
     * @return string
     */
    private function getDocumentByIdSql($db, $id)
    {
        return 'SELECT *
              FROM documents_published
             WHERE id = ' . $db->quote($id) . '
        ';
    }

    /**
     * @param \PDO $db
     * @param string $sql
     * @return \PDOStatement
     */
    private function getPDOStatement($db, $sql)
    {
        $stmt = $db->query($sql);
        if ($stmt === false) {
            $errorInfo = $db->errorInfo();
            $errorMsg = $errorInfo[2];
            throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
        }
        return $stmt;
    }

    /**
     * @return Response
     */
    private function getSingleDocumentResponse()
    {
        $document = $this->getDocumentById();

        if ($document === false) {

            return new Response();
        }

        if ($document->type === 'folder') {
            return $this->getFolderResponse($document);
        }

        $documentContent = $this->getDocumentContent($document);
        $document->documentContent = $documentContent;

        return new Response($document);
    }

    /**
     * @param Application $application
     */
    public function render($application = null)
    {
        $this->renderedContent = $this->response;
    }

    /**
     * @return Response
     * @throws \Exception
     */
    private function getRootDocumentsResponse()
    {
        $documents = $this->storage->getDocuments()->getDocuments('published');
        return new Response($documents);
    }

    /**
     * @return Response
     * @throws \Exception
     */
    private function getSearchDocumentsResponse()
    {
        $rawResults = $this->getRawResults();
        $results = array();
        $suggestions = array();
        foreach ($rawResults as $rawResult) {
            if ($rawResult instanceof SearchSuggestion) {
                $suggestions[] = $rawResults;
                continue;
            }
            $result = $rawResult->getDocument();
            $result->searchInfo = $rawResult;
            $results[] = $result;
        }
        $response = new Response($results);
        $response->searchSuggestions = $suggestions;
        return $response;
    }

    /**
     * @param Document $document
     * @return \stdClass
     */
    private function getDocumentContent($document)
    {
        $documentContent = new \stdClass();
        $documentContent->fields = $document->fields;
        $documentContent->bricks = $document->bricks;
        $documentContent->dynamicBricks = $document->dynamicBricks;
        return $documentContent;
    }

    /**
     * @return array
     * @throws \Exception
     */
    private function getRawResults()
    {
        $filteredQuery = new CharacterFilter($_GET['q']);
        $tokenizer = new Tokenizer($filteredQuery);
        $search = new Search($this->storage);
        $rawResults = $search->getDocumentsForTokenizer($tokenizer);
        return $rawResults;
    }

    /**
     * @param Document $document
     * @return Response
     */
    private function getFolderResponse($document)
    {
        $document->dbHandle = $this->storage->getContentDbHandle();
        $document->documentStorage = new DocumentStorage($this->storage->getRepository());
        $document->getContent();
        $response = new Response($document->getContent());
        $response->folder = $document->path;
        return $response;
    }


}

1			<?php
2			/**
3			* Created by jensk on 26-3-2018.
4			*/
5
6			namespace CloudControl\Cms\components;
7
8
9			use CloudControl\Cms\cc\Application;
10			use CloudControl\Cms\components\api\Response;
11			use CloudControl\Cms\search\CharacterFilter;
12			use CloudControl\Cms\search\results\SearchSuggestion;
13			use CloudControl\Cms\search\Search;
14			use CloudControl\Cms\search\Tokenizer;
15			use CloudControl\Cms\storage\entities\Document;
16			use CloudControl\Cms\storage\Storage;
17			use CloudControl\Cms\storage\storage\DocumentStorage;
18
19			class ApiComponent extends CachableBaseComponent
20			{
21			/**
22			* @var Response
23			*/
24			protected $response;
25
26			/**
27			* @param Storage $storage
28			*/
29			public function run(Storage $storage)
30			{
31			parent::run($storage);
32			header('Content-Type: application/json');
33			header('Access-Control-Allow-Origin: *');
34			$this->response = $this->getResponse();
35			}
36
37			/**
38			* @return Response
39			*/
40			private function getResponse()
41			{
42			try {
43			if (isset($_GET['id'])) {
44			return $this->getSingleDocumentResponse();
45			}
46
47			if (isset($_GET['q'])) {
48			return $this->getSearchDocumentsResponse();
49			}
50
51			return $this->getRootDocumentsResponse();
52			} catch (\Exception $e) {
53			$error = $e->getFile() . ':' . $e->getLine() . ' ' . $e->getMessage();
54			return new Response(array(), false, $error);
55			}
56			}
57
58			/**
59			* @return Document
60			*/
61			private function getDocumentById()
62			{
63			$id = intval($_GET['id']);
64			$db = $this->storage->getRepository()->getContentRepository()->getContentDbHandle();
65			$stmt = $this->getPDOStatement($db, $this->getDocumentByIdSql($db, $id));
66			return $stmt->fetchObject(Document::class);
67			}
68
69			/**
70			* @param \PDO $db
71			* @param int $id
72			* @return string
73			*/
74			private function getDocumentByIdSql($db, $id)
75			{
76			return 'SELECT *
77			FROM documents_published
78			WHERE id = ' . $db->quote($id) . '
79			';
80			}
81
82			/**
83			* @param \PDO $db
84			* @param string $sql
85			* @return \PDOStatement
86			*/
87			private function getPDOStatement($db, $sql)
88			{
89			$stmt = $db->query($sql);
90			if ($stmt === false) {
91			$errorInfo = $db->errorInfo();
92			$errorMsg = $errorInfo[2];
93			throw new \RuntimeException('SQLite Exception: ' . $errorMsg . ' in SQL: <br /><pre>' . $sql . '</pre>');
94			}
95			return $stmt;
96			}
97
98			/**
99			* @return Response
100			*/
101			private function getSingleDocumentResponse()
102			{
103			$document = $this->getDocumentById();
104
105			if ($document === false) {
			0 ignored issues – show introduced 2018-03-27 09:23 UTC by Report Bug Copy Issue Report The condition `$document === false` is always `false`. Loading history...
106			return new Response();
107			}
108
109			if ($document->type === 'folder') {
110			return $this->getFolderResponse($document);
111			}
112
113			$documentContent = $this->getDocumentContent($document);
114			$document->documentContent = $documentContent;
115
116			return new Response($document);
117			}
118
119			/**
120			* @param Application $application
121			*/
122			public function render($application = null)
123			{
124			$this->renderedContent = $this->response;
125			}
126
127			/**
128			* @return Response
129			* @throws \Exception
130			*/
131			private function getRootDocumentsResponse()
132			{
133			$documents = $this->storage->getDocuments()->getDocuments('published');
134			return new Response($documents);
135			}
136
137			/**
138			* @return Response
139			* @throws \Exception
140			*/
141			private function getSearchDocumentsResponse()
142			{
143			$rawResults = $this->getRawResults();
144			$results = array();
145			$suggestions = array();
146			foreach ($rawResults as $rawResult) {
147			if ($rawResult instanceof SearchSuggestion) {
148			$suggestions[] = $rawResults;
149			continue;
150			}
151			$result = $rawResult->getDocument();
152			$result->searchInfo = $rawResult;
153			$results[] = $result;
154			}
155			$response = new Response($results);
156			$response->searchSuggestions = $suggestions;
157			return $response;
158			}
159
160			/**
161			* @param Document $document
162			* @return \stdClass
163			*/
164			private function getDocumentContent($document)
165			{
166			$documentContent = new \stdClass();
167			$documentContent->fields = $document->fields;
168			$documentContent->bricks = $document->bricks;
169			$documentContent->dynamicBricks = $document->dynamicBricks;
170			return $documentContent;
171			}
172
173			/**
174			* @return array
175			* @throws \Exception
176			*/
177			private function getRawResults()
178			{
179			$filteredQuery = new CharacterFilter($_GET['q']);
180			$tokenizer = new Tokenizer($filteredQuery);
181			$search = new Search($this->storage);
182			$rawResults = $search->getDocumentsForTokenizer($tokenizer);
183			return $rawResults;
184			}
185
186			/**
187			* @param Document $document
188			* @return Response
189			*/
190			private function getFolderResponse($document)
191			{
192			$document->dbHandle = $this->storage->getContentDbHandle();
193			$document->documentStorage = new DocumentStorage($this->storage->getRepository());
194			$document->getContent();
195			$response = new Response($document->getContent());
196			$response->folder = $document->path;
197			return $response;
198			}
199
200
201			}

jenskooij / cloudcontrol

Push — master ( a1bf27...3a2d72 )

ApiComponent::getDocumentByIdSql() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like