@@ -66,7 +66,7 @@ |
||
| 66 | 66 | ) |
| 67 | 67 | SELECT DISTINCT uuid, parent_id, label, level, slug FROM cte |
| 68 | 68 | ORDER BY level DESC |
| 69 | -SQL; |
|
| 69 | +sql; |
|
| 70 | 70 | |
| 71 | 71 | $results = $this->connection->executeQuery($query)->fetchAllAssociative(); |
| 72 | 72 | |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | $query = <<<'SQL' |
| 43 | 43 | SELECT uuid FROM supplier |
| 44 | 44 | WHERE name = :name |
| 45 | -SQL; |
|
| 45 | +sql; |
|
| 46 | 46 | $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne(); |
| 47 | 47 | |
| 48 | 48 | return !(false === $statement); |
@@ -108,7 +108,7 @@ discard block |
||
| 108 | 108 | FROM supplier |
| 109 | 109 | JOIN family_log on family_log.uuid = supplier.family_log_id |
| 110 | 110 | WHERE supplier.uuid = :uuid |
| 111 | -SQL; |
|
| 111 | +sql; |
|
| 112 | 112 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 113 | 113 | if (null === $result) { |
| 114 | 114 | throw new SupplierNotFound(); |