darya /
framework
| @@ 74-90 (lines=17) @@ | ||
| 71 | * @param bool $distinct [optional] |
|
| 72 | * @return string |
|
| 73 | */ |
|
| 74 | protected function prepareSelect( |
|
| 75 | $table, |
|
| 76 | $columns, |
|
| 77 | $joins = null, |
|
| 78 | $where = null, |
|
| 79 | $order = null, |
|
| 80 | $limit = null, |
|
| 81 | $groupings = null, |
|
| 82 | $having = null, |
|
| 83 | $distinct = false |
|
| 84 | ) { |
|
| 85 | $table = $this->identifier($table); |
|
| 86 | ||
| 87 | $distinct = $distinct ? 'DISTINCT' : ''; |
|
| 88 | ||
| 89 | return static::concatenate(array('SELECT', $distinct, $columns, 'FROM', $table, $joins, $where, $groupings, $having, $order, $limit)); |
|
| 90 | } |
|
| 91 | ||
| 92 | /** |
|
| 93 | * Prepare an UPDATE statement with the given table, data and clauses. |
|
| @@ 81-97 (lines=17) @@ | ||
| 78 | * @param bool $distinct [optional] |
|
| 79 | * @return string |
|
| 80 | */ |
|
| 81 | protected function prepareSelect( |
|
| 82 | $table, |
|
| 83 | $columns, |
|
| 84 | $joins = null, |
|
| 85 | $where = null, |
|
| 86 | $order = null, |
|
| 87 | $limit = null, |
|
| 88 | $groupings = null, |
|
| 89 | $having = null, |
|
| 90 | $distinct = false |
|
| 91 | ) { |
|
| 92 | $table = $this->identifier($table); |
|
| 93 | ||
| 94 | $distinct = $distinct ? 'DISTINCT' : ''; |
|
| 95 | ||
| 96 | return static::concatenate(array('SELECT', $distinct, $limit, $columns, 'FROM', $table, $joins, $where, $groupings, $having, $order)); |
|
| 97 | } |
|
| 98 | ||
| 99 | /** |
|
| 100 | * Prepare the column selection for an ANSI offset select statement. |
|
