doctrine-dbal-util /
connection
These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more
| 1 | <?php |
||
| 78 | return $row; |
||
| 79 | } |
||
| 80 | } else { |
||
| 81 | die('tbS8k: '.basename(__FILE__)); // TODO |
||
|
|
|||
| 82 | } |
||
| 83 | // TODO: check if something should be ended or close... |
||
| 84 | } |
||
| 89 | // The construct with the array triggers a prepared statement |
||
| 90 | } |
||
| 91 | |||
| 92 | /* |
||
| 93 | public function insert_default_values($table) { |
||
| 94 | $this->getConnection()->executeUpdate('INSERT INTO ' . $table . ' DEFAULT VALUES'); |
||
| 95 | } |
||
| 149 | $qb = $this->getConnection()->createQueryBuilder(); // 149 |
||
| 150 | return $qb |
||
| 151 | ->select('d.*', 'l.*') // TODO: name collision RISK: seems to that data with same column name is taken from second (may be not reliable) |
||
| 152 | // ->select('d.*') // TODO: name collision RISK: seems to that data with same column name is taken from second (may be not reliable): to try... |
||
| 153 | ->from($base_table, 'b') |
||
| 154 | ->innerJoin('b', $link_table, 'l', 'b.'.$base_id.' = l.'.$link_base_id) |
||
| 155 | ->innerJoin('l', $distant_table, 'd', 'l.'.$link_distant_id.' = d.'.$distant_id) |
||
| 156 | // ->where('b.id = '.$queryBuilder->createPositionalParameter($id)) |
||
| 157 | ->where(call_user_func_array([$qb->expr(), 'andX'], |
||
| 158 | array_map( |
||
| 159 | [$qb->expr(), 'eq'], |
||
| 167 | |||
| 168 | public function sqlarray2dbal(array $sqlTree, $qb) |
||
| 169 | { |
||
| 170 | // $conn = $this->getConnection(); |
||
| 171 | // $qb = $this->getConnection()->createQueryBuilder(); |
||
| 172 | // $qb = $conn->createQueryBuilder(); |
||
| 173 | // dump($sqlTree); |
||
| 174 | foreach ($sqlTree as $key => $value) { |
||
| 175 | /// dump($key, $value); |
||
| 176 | switch ($key) { |
||
| 177 | case 'select': |
||
| 178 | $qb->select($value); |
||
| 192 | if (1 !== count($jvalue['table'])) { |
||
| 193 | 0 / 0; // TODO |
||
| 194 | } |
||
| 195 | // dump ($jvalue['from'], array_keys($jvalue['table'])[0], array_values($jvalue['table'])[0], $jvalue['on']); |
||
| 196 | $qb->innerJoin($jvalue['from'], array_keys($jvalue['table'])[0], array_values($jvalue['table'])[0], $jvalue['on']); |
||
| 197 | } |
||
| 198 | break; |
||
| 208 | $distant_id, $distant_table, array $where) |
||
| 209 | { |
||
| 210 | $qb = $this->getConnection()->createQueryBuilder(); // 210 |
||
| 211 | if (false) { // ---------------------------------------------------- |
||
| 212 | $qa0 = [ |
||
| 213 | 'select' => 'base.*', |
||
| 214 | 'from' => [ |
||
| 294 | ], |
||
| 295 | ], |
||
| 296 | ], $qb) |
||
| 297 | // ->select('base.*') |
||
| 298 | // ->from($base_table, 'base') |
||
| 299 | // ->innerJoin('base', '"' . $link_table . '"', 'link', 'base."' . $base_id . '" = link."' . $link_base_id . '"') |
||
| 300 | // ->innerJoin('link', '"' . $distant_table . '"', 'distant', 'link."' . $link_distant_id . '" = distant."'. $distant_id . '"') |
||
| 301 | ->where(call_user_func_array([$qb->expr(), 'andX'], |
||
| 302 | array_map( |
||
| 303 | [$qb->expr(), 'eq'], |
||
| 311 | } |
||
| 312 | |||
| 313 | public function getWhereManyToManyToManyQueryBuilder( |
||
| 314 | $base_table, $base_id, // $t0, $t0_id,... |
||
| 315 | $base_link_base_id, $base_link_table, $base_link_distant_id, |
||
| 316 | $distant_link_base_id, $distant_link_table, $distant_link_distant_id, |
||
| 317 | $distant_id, $distant_table, |
||
| 332 | array_map([$qb, 'createNamedParameter'], array_values($where)) |
||
| 333 | ) |
||
| 334 | )); |
||
| 335 | // if ($orderby != ''): |
||
| 336 | // $result->orderBy($orderby); |
||
| 337 | // endif; |
||
| 338 | return $result; |
||
| 339 | } |
||
| 387 | ], |
||
| 388 | ], |
||
| 389 | ], $qb) |
||
| 390 | // ->select('more.*, base.*, count(base.uuid=taxo.owned_url_uuid) AS taxocount') // collision risk! |
||
| 391 | // ->select('more.*, base.*') // collision risk! |
||
| 392 | // ->from($base_table, 'base') |
||
| 393 | // ->innerJoin('base', '"' . $more_table . '"', 'more', 'base."' . $base_more . '" = more."' . $more_id . '"') |
||
| 394 | // ->innerJoin('base', '"' . $link_table . '"', 'link', 'base."' . $base_id . '" = link."' . $link_base_id . '"') |
||
| 395 | // ->innerJoin('link', '"' . $distant_table . '"', 'distant', 'link."' . $link_distant_id . '" = distant."'. $distant_id . '"') |
||
| 396 | ->leftJoin('base', '"'.'link_owned_url_taxonomy'.'"', 'taxo', 'base."'.$base_id.'" = taxo."'.'owned_url_uuid'.'"') |
||
| 397 | ->where(call_user_func_array([$qb->expr(), 'andX'], |
||
| 398 | array_map( |
||
| 401 | array_merge([], array_map([$qb, 'createNamedParameter'], array_values($where))) |
||
| 402 | ) |
||
| 403 | )) |
||
| 404 | // ->orderBy('taxocount', 'ASC') |
||
| 405 | ; |
||
| 406 | } |
||
| 407 | } |
||
| 421 |
Nardberjean
Loading history...
An exit expression should only be used in rare cases. For example, if you write a short command line script.
In most cases however, using an
exitexpression makes the code untestable and often causes incompatibilities with other libraries. Thus, unless you are absolutely sure it is required here, we recommend to refactor your code to avoid its usage.