Complex classes like OracleGrammar often do a lot of different things. To break such a class down, we need to identify a cohesive component within that class. A common approach to find such a component is to look for fields/methods that share the same prefixes, or suffixes. You can also have a look at the cohesion graph to spot any un-connected, or weakly-connected components.
Once you have determined the fields that belong together, you can apply the Extract Class refactoring. If the component makes sense as a sub-class, Extract Subclass is also a candidate, and is often faster.
While breaking up the class, it is a good idea to analyze how other classes use OracleGrammar, and based on these observations, apply Extract Interface, too.
1 | <?php |
||
11 | class OracleGrammar extends Grammar |
||
12 | { |
||
13 | use OracleReservedWords; |
||
14 | |||
15 | /** |
||
16 | * The keyword identifier wrapper format. |
||
17 | * |
||
18 | * @var string |
||
19 | */ |
||
20 | protected $wrapper = '%s'; |
||
21 | |||
22 | /** |
||
23 | * @var string |
||
24 | */ |
||
25 | protected $schema_prefix = ''; |
||
26 | |||
27 | /** |
||
28 | * Compile an exists statement into SQL. |
||
29 | * |
||
30 | * @param \Illuminate\Database\Query\Builder $query |
||
31 | * @return string |
||
32 | */ |
||
33 | 3 | public function compileExists(Builder $query) |
|
42 | |||
43 | /** |
||
44 | * Compile a select query into SQL. |
||
45 | * |
||
46 | * @param \Illuminate\Database\Query\Builder |
||
47 | * @return string |
||
48 | */ |
||
49 | 159 | public function compileSelect(Builder $query) |
|
66 | |||
67 | /** |
||
68 | * @param Builder $query |
||
69 | * @param array $components |
||
70 | * @return bool |
||
71 | */ |
||
72 | 159 | protected function isPaginationable(Builder $query, array $components) |
|
76 | |||
77 | /** |
||
78 | * Create a full ANSI offset clause for the query. |
||
79 | * |
||
80 | * @param \Illuminate\Database\Query\Builder $query |
||
81 | * @param array $components |
||
82 | * @return string |
||
83 | */ |
||
84 | 12 | protected function compileAnsiOffset(Builder $query, $components) |
|
107 | |||
108 | 12 | /** |
|
109 | 6 | * Compile the limit / offset row constraint for a query. |
|
110 | * |
||
111 | * @param \Illuminate\Database\Query\Builder $query |
||
112 | 6 | * @return string |
|
113 | 6 | */ |
|
114 | protected function compileRowConstraint($query) |
||
129 | 12 | ||
130 | /** |
||
131 | 12 | * Compile a common table expression for a query. |
|
132 | 6 | * |
|
133 | * @param string $sql |
||
134 | 9 | * @param string $constraint |
|
135 | * @param Builder $query |
||
136 | * @return string |
||
137 | */ |
||
138 | protected function compileTableExpression($sql, $constraint, $query) |
||
146 | 3 | ||
147 | /** |
||
148 | * Compile a truncate table statement into SQL. |
||
149 | * |
||
150 | * @param \Illuminate\Database\Query\Builder $query |
||
151 | * @return array |
||
152 | */ |
||
153 | public function compileTruncate(Builder $query) |
||
157 | 201 | ||
158 | /** |
||
159 | * Wrap a value in keyword identifiers. |
||
160 | * |
||
161 | 201 | * Override due to laravel's stringify integers. |
|
162 | * |
||
163 | * @param \Illuminate\Database\Query\Expression|string $value |
||
164 | * @param bool $prefixAlias |
||
165 | 201 | * @return string |
|
166 | 201 | */ |
|
167 | 201 | public function wrap($value, $prefixAlias = false) |
|
175 | |||
176 | /** |
||
177 | * Wrap a table in keyword identifiers. |
||
178 | * |
||
179 | 201 | * @param \Illuminate\Database\Query\Expression|string $table |
|
180 | * @return string |
||
181 | 201 | */ |
|
182 | public function wrapTable($table) |
||
200 | 201 | ||
201 | /** |
||
202 | 201 | * Return the schema prefix. |
|
203 | 123 | * |
|
204 | * @return string |
||
205 | */ |
||
206 | 201 | public function getSchemaPrefix() |
|
210 | |||
211 | /** |
||
212 | * Set the schema prefix. |
||
213 | * |
||
214 | * @param string $prefix |
||
215 | */ |
||
216 | public function setSchemaPrefix($prefix) |
||
220 | |||
221 | 6 | /** |
|
222 | * Wrap a single string in keyword identifiers. |
||
223 | * |
||
224 | * @param string $value |
||
225 | 6 | * @return string |
|
226 | */ |
||
227 | 6 | protected function wrapValue($value) |
|
237 | |||
238 | /** |
||
239 | * Compile an insert and get ID statement into SQL. |
||
240 | * |
||
241 | * @param \Illuminate\Database\Query\Builder $query |
||
242 | * @param array $values |
||
243 | * @param string $sequence |
||
244 | 15 | * @return string |
|
245 | */ |
||
246 | public function compileInsertGetId(Builder $query, $values, $sequence = 'id') |
||
263 | |||
264 | 15 | /** |
|
265 | 3 | * Compile an insert statement into SQL. |
|
266 | 3 | * |
|
267 | 3 | * @param \Illuminate\Database\Query\Builder $query |
|
268 | 3 | * @param array $values |
|
269 | 2 | * @return string |
|
270 | 3 | */ |
|
271 | public function compileInsert(Builder $query, array $values) |
||
305 | 6 | ||
306 | 6 | /** |
|
307 | * Compile an insert with blob field statement into SQL. |
||
308 | 6 | * |
|
309 | 6 | * @param \Illuminate\Database\Query\Builder $query |
|
310 | * @param array $values |
||
311 | 6 | * @param array $binaries |
|
312 | 6 | * @param string $sequence |
|
313 | * @return string |
||
314 | 6 | */ |
|
315 | 6 | public function compileInsertLob(Builder $query, $values, $binaries, $sequence = 'id') |
|
346 | 6 | ||
347 | 4 | /** |
|
348 | 6 | * Compile an update statement into SQL. |
|
349 | 6 | * |
|
350 | * @param \Illuminate\Database\Query\Builder $query |
||
351 | * @param array $values |
||
352 | 6 | * @param array $binaries |
|
353 | 6 | * @param string $sequence |
|
354 | 6 | * @return string |
|
355 | 4 | */ |
|
356 | public function compileUpdateLob(Builder $query, array $values, array $binaries, $sequence = 'id') |
||
404 | |||
405 | /** |
||
406 | 12 | * Compile the lock into SQL. |
|
407 | * |
||
408 | 12 | * @param \Illuminate\Database\Query\Builder $query |
|
409 | * @param bool|string $value |
||
410 | * @return string |
||
411 | */ |
||
412 | protected function compileLock(Builder $query, $value) |
||
424 | |||
425 | /** |
||
426 | * Compile the "limit" portions of the query. |
||
427 | * |
||
428 | * @param \Illuminate\Database\Query\Builder $query |
||
429 | * @param int $limit |
||
430 | 3 | * @return string |
|
431 | */ |
||
432 | 3 | protected function compileLimit(Builder $query, $limit) |
|
436 | |||
437 | /** |
||
438 | * Compile the "offset" portions of the query. |
||
439 | * |
||
440 | * @param \Illuminate\Database\Query\Builder $query |
||
441 | * @param int $offset |
||
442 | * @return string |
||
443 | */ |
||
444 | protected function compileOffset(Builder $query, $offset) |
||
448 | |||
449 | 9 | /** |
|
450 | * Compile a "where date" clause. |
||
451 | * |
||
452 | * @param \Illuminate\Database\Query\Builder $query |
||
453 | * @param array $where |
||
454 | * @return string |
||
455 | */ |
||
456 | protected function whereDate(Builder $query, $where) |
||
462 | |||
463 | /** |
||
464 | * Compile a date based where clause. |
||
465 | * |
||
466 | * @param string $type |
||
467 | * @param \Illuminate\Database\Query\Builder $query |
||
468 | * @param array $where |
||
469 | * @return string |
||
470 | */ |
||
471 | protected function dateBasedWhere($type, Builder $query, $where) |
||
477 | } |
||
478 |
This check looks at variables that have been passed in as parameters and are passed out again to other methods.
If the outgoing method call has stricter type requirements than the method itself, an issue is raised.
An additional type check may prevent trouble.