GrammarTrait::getCreateTableQuery() - Code Metrics - Inspection of "New components for the table section pages." - lagdo/dbadmin-driver - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( faeaf0...5f5b5b )

by Thierry

created 2025-01-22 20:32 UTC

GrammarTrait::getCreateTableQuery() A

↳ Parent: GrammarTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	1
c	1
b	0
f	0
nc	1
nop	3
dl	0
loc	3
rs	10

<?php

namespace Lagdo\DbAdmin\Driver;

use Lagdo\DbAdmin\Driver\Entity\TableFieldEntity;
use Lagdo\DbAdmin\Driver\Entity\TableSelectEntity;
use Lagdo\DbAdmin\Driver\Entity\ForeignKeyEntity;
use Lagdo\DbAdmin\Driver\Entity\QueryEntity;

trait GrammarTrait
{
    /**
     * Get escaped table name
     *
     * @param string $idf
     *
     * @return string
     */
    public function escapeTableName(string $idf)
    {
        return $this->grammar->escapeTableName($idf);
    }

    /**
     * Escape database identifier
     *
     * @param string $idf
     *
     * @return string
     */
    public function escapeId(string $idf)
    {
        return $this->grammar->escapeId($idf);
    }

    /**
     * Unescape database identifier
     *
     * @param string $idf
     *
     * @return string
     */
    public function unescapeId(string $idf)
    {
        return $this->grammar->unescapeId($idf);
    }

    /**
     * Convert field in select and edit
     *
     * @param TableFieldEntity $field one element from $this->fields()
     *
     * @return string
     */
    public function convertField(TableFieldEntity $field)
    {
        return $this->grammar->convertField($field);
    }

    /**
     * Convert value in edit after applying functions back
     *
     * @param TableFieldEntity $field One element from $this->fields()
     * @param string $value
     *
     * @return string
     */
    public function unconvertField(TableFieldEntity $field, string $value)
    {
        return $this->grammar->unconvertField($field, $value);
    }

    /**
     * Get select clause for convertible fields
     *
     * @param array $columns
     * @param array $fields
     * @param array $select
     *
     * @return string
     */
    public function convertFields(array $columns, array $fields, array $select = [])
    {
        return $this->grammar->convertFields($columns, $fields, $select);
    }

    /**
     * Select data from table
     *
     * @param TableSelectEntity $select
     *
     * @return string
     */
    public function buildSelectQuery(TableSelectEntity $select)
    {
        return $this->grammar->buildSelectQuery($select);
    }

    /**
     * Parse a string containing SQL queries
     *
     * @param QueryEntity $queryEntity
     *
     * @return bool
     */
    public function parseQueries(QueryEntity $queryEntity)
    {
        return $this->grammar->parseQueries($queryEntity);
    }

    /**
     * Get query to compute number of found rows
     *
     * @param string $table
     * @param array $where
     * @param bool $isGroup
     * @param array $groups
     *
     * @return string
     */
    public function getRowCountQuery(string $table, array $where, bool $isGroup, array $groups)
    {
        return $this->grammar->getRowCountQuery($table, $where, $isGroup, $groups);
    }

    /**
     * Get default value clause
     *
     * @param TableFieldEntity $field
     *
     * @return string
     */
    public function getDefaultValueClause(TableFieldEntity $field)
    {
        return $this->grammar->getDefaultValueClause($field);
    }

    /**
     * Formulate SQL query with limit
     *
     * @param string $query Everything after SELECT
     * @param string $where Including WHERE
     * @param int $limit
     * @param int $offset
     *
     * @return string
     */
    public function getLimitClause(string $query, string $where, int $limit, int $offset = 0)
    {
        return $this->grammar->getLimitClause($query, $where, $limit, $offset);
    }

    /**
     * Format foreign key to use in SQL query
     *
     * @param ForeignKeyEntity $foreignKey
     *
     * @return string
     */
    public function formatForeignKey(ForeignKeyEntity $foreignKey)
    {
        return $this->grammar->formatForeignKey($foreignKey);
    }

    /**
     * Generate modifier for auto increment column
     *
     * @return string
     */
    public function getAutoIncrementModifier()
    {
        return $this->grammar->getAutoIncrementModifier();
    }

    /**
     * Get SQL command to create table
     *
     * @param string $table
     * @param bool $autoIncrement
     * @param string $style
     *
     * @return string
     */
    public function getCreateTableQuery(string $table, bool $autoIncrement, string $style)
    {
        return $this->grammar->getCreateTableQuery($table, $autoIncrement, $style);
    }

    /**
     * Command to create an index
     *
     * @param string $table
     * @param string $type
     * @param string $name
     * @param string $columns
     *
     * @return string
     */
    public function getCreateIndexQuery(string $table, string $type, string $name, string $columns)
    {
        return $this->grammar->getCreateIndexQuery($table, $type, $name, $columns);
    }

    /**
     * Get SQL command to create foreign keys
     *
     * getCreateTableQuery() produces CREATE TABLE without FK CONSTRAINTs
     * getForeignKeysQuery() produces all FK CONSTRAINTs as ALTER TABLE ... ADD CONSTRAINT
     * so that all FKs can be added after all tables have been created, avoiding any need
     * to reorder CREATE TABLE statements in order of their FK dependencies
     *
     * @param string $table
     *
     * @return string
     */
    public function getForeignKeysQuery(string $table)
    {
        return $this->grammar->getForeignKeysQuery($table);
    }

    /**
     * Get SQL command to truncate table
     *
     * @param string $table
     *
     * @return string
     */
    public function getTruncateTableQuery(string $table)
    {
        return $this->grammar->getTruncateTableQuery($table);
    }

    /**
     * Get SQL command to change database
     *
     * @param string $database
     *
     * @return string
     */
    public function getUseDatabaseQuery(string $database)
    {
        return $this->grammar->getUseDatabaseQuery($database);
    }

    /**
     * Get SQL commands to create triggers
     *
     * @param string $table
     *
     * @return string
     */
    public function getCreateTriggerQuery(string $table)
    {
        return $this->grammar->getCreateTriggerQuery($table);
    }

    /**
     * Return query to get connection ID
     *
     * @return string
     */
    // public function connectionId()
    // {
    //     return $this->grammar->connectionId();
    // }
}


1			<?php
2
3			namespace Lagdo\DbAdmin\Driver;
4
5			use Lagdo\DbAdmin\Driver\Entity\TableFieldEntity;
6			use Lagdo\DbAdmin\Driver\Entity\TableSelectEntity;
7			use Lagdo\DbAdmin\Driver\Entity\ForeignKeyEntity;
8			use Lagdo\DbAdmin\Driver\Entity\QueryEntity;
9
10			trait GrammarTrait
11			{
12			/**
13			* Get escaped table name
14			*
15			* @param string $idf
16			*
17			* @return string
18			*/
19			public function escapeTableName(string $idf)
20			{
21			return $this->grammar->escapeTableName($idf);
22			}
23
24			/**
25			* Escape database identifier
26			*
27			* @param string $idf
28			*
29			* @return string
30			*/
31			public function escapeId(string $idf)
32			{
33			return $this->grammar->escapeId($idf);
34			}
35
36			/**
37			* Unescape database identifier
38			*
39			* @param string $idf
40			*
41			* @return string
42			*/
43			public function unescapeId(string $idf)
44			{
45			return $this->grammar->unescapeId($idf);
46			}
47
48			/**
49			* Convert field in select and edit
50			*
51			* @param TableFieldEntity $field one element from $this->fields()
52			*
53			* @return string
54			*/
55			public function convertField(TableFieldEntity $field)
56			{
57			return $this->grammar->convertField($field);
58			}
59
60			/**
61			* Convert value in edit after applying functions back
62			*
63			* @param TableFieldEntity $field One element from $this->fields()
64			* @param string $value
65			*
66			* @return string
67			*/
68			public function unconvertField(TableFieldEntity $field, string $value)
69			{
70			return $this->grammar->unconvertField($field, $value);
71			}
72
73			/**
74			* Get select clause for convertible fields
75			*
76			* @param array $columns
77			* @param array $fields
78			* @param array $select
79			*
80			* @return string
81			*/
82			public function convertFields(array $columns, array $fields, array $select = [])
83			{
84			return $this->grammar->convertFields($columns, $fields, $select);
85			}
86
87			/**
88			* Select data from table
89			*
90			* @param TableSelectEntity $select
91			*
92			* @return string
93			*/
94			public function buildSelectQuery(TableSelectEntity $select)
95			{
96			return $this->grammar->buildSelectQuery($select);
97			}
98
99			/**
100			* Parse a string containing SQL queries
101			*
102			* @param QueryEntity $queryEntity
103			*
104			* @return bool
105			*/
106			public function parseQueries(QueryEntity $queryEntity)
107			{
108			return $this->grammar->parseQueries($queryEntity);
109			}
110
111			/**
112			* Get query to compute number of found rows
113			*
114			* @param string $table
115			* @param array $where
116			* @param bool $isGroup
117			* @param array $groups
118			*
119			* @return string
120			*/
121			public function getRowCountQuery(string $table, array $where, bool $isGroup, array $groups)
122			{
123			return $this->grammar->getRowCountQuery($table, $where, $isGroup, $groups);
124			}
125
126			/**
127			* Get default value clause
128			*
129			* @param TableFieldEntity $field
130			*
131			* @return string
132			*/
133			public function getDefaultValueClause(TableFieldEntity $field)
134			{
135			return $this->grammar->getDefaultValueClause($field);
136			}
137
138			/**
139			* Formulate SQL query with limit
140			*
141			* @param string $query Everything after SELECT
142			* @param string $where Including WHERE
143			* @param int $limit
144			* @param int $offset
145			*
146			* @return string
147			*/
148			public function getLimitClause(string $query, string $where, int $limit, int $offset = 0)
149			{
150			return $this->grammar->getLimitClause($query, $where, $limit, $offset);
151			}
152
153			/**
154			* Format foreign key to use in SQL query
155			*
156			* @param ForeignKeyEntity $foreignKey
157			*
158			* @return string
159			*/
160			public function formatForeignKey(ForeignKeyEntity $foreignKey)
161			{
162			return $this->grammar->formatForeignKey($foreignKey);
163			}
164
165			/**
166			* Generate modifier for auto increment column
167			*
168			* @return string
169			*/
170			public function getAutoIncrementModifier()
171			{
172			return $this->grammar->getAutoIncrementModifier();
173			}
174
175			/**
176			* Get SQL command to create table
177			*
178			* @param string $table
179			* @param bool $autoIncrement
180			* @param string $style
181			*
182			* @return string
183			*/
184			public function getCreateTableQuery(string $table, bool $autoIncrement, string $style)
185			{
186			return $this->grammar->getCreateTableQuery($table, $autoIncrement, $style);
187			}
188
189			/**
190			* Command to create an index
191			*
192			* @param string $table
193			* @param string $type
194			* @param string $name
195			* @param string $columns
196			*
197			* @return string
198			*/
199			public function getCreateIndexQuery(string $table, string $type, string $name, string $columns)
200			{
201			return $this->grammar->getCreateIndexQuery($table, $type, $name, $columns);
202			}
203
204			/**
205			* Get SQL command to create foreign keys
206			*
207			* getCreateTableQuery() produces CREATE TABLE without FK CONSTRAINTs
208			* getForeignKeysQuery() produces all FK CONSTRAINTs as ALTER TABLE ... ADD CONSTRAINT
209			* so that all FKs can be added after all tables have been created, avoiding any need
210			* to reorder CREATE TABLE statements in order of their FK dependencies
211			*
212			* @param string $table
213			*
214			* @return string
215			*/
216			public function getForeignKeysQuery(string $table)
217			{
218			return $this->grammar->getForeignKeysQuery($table);
219			}
220
221			/**
222			* Get SQL command to truncate table
223			*
224			* @param string $table
225			*
226			* @return string
227			*/
228			public function getTruncateTableQuery(string $table)
229			{
230			return $this->grammar->getTruncateTableQuery($table);
231			}
232
233			/**
234			* Get SQL command to change database
235			*
236			* @param string $database
237			*
238			* @return string
239			*/
240			public function getUseDatabaseQuery(string $database)
241			{
242			return $this->grammar->getUseDatabaseQuery($database);
243			}
244
245			/**
246			* Get SQL commands to create triggers
247			*
248			* @param string $table
249			*
250			* @return string
251			*/
252			public function getCreateTriggerQuery(string $table)
253			{
254			return $this->grammar->getCreateTriggerQuery($table);
255			}
256
257			/**
258			* Return query to get connection ID
259			*
260			* @return string
261			*/
262			// public function connectionId()
263			// {
264			// return $this->grammar->connectionId();
265			// }
266			}
267

lagdo / dbadmin-driver

Push — main ( faeaf0...5f5b5b )

GrammarTrait::getCreateTableQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like