@@ -41,7 +41,7 @@ discard block |
||
| 41 | 41 | $query = <<<'SQL' |
| 42 | 42 | SELECT uuid FROM supplier |
| 43 | 43 | WHERE name = :name |
| 44 | -SQL; |
|
| 44 | +sql; |
|
| 45 | 45 | $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne(); |
| 46 | 46 | |
| 47 | 47 | return !(false === $statement); |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | supplier.slug as slug |
| 105 | 105 | FROM supplier |
| 106 | 106 | WHERE uuid = :uuid |
| 107 | -SQL; |
|
| 107 | +sql; |
|
| 108 | 108 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 109 | 109 | |
| 110 | 110 | if (null === $result) { |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | user.roles as roles |
| 83 | 83 | FROM user |
| 84 | 84 | WHERE uuid = :uuid |
| 85 | -SQL; |
|
| 85 | +sql; |
|
| 86 | 86 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 87 | 87 | |
| 88 | 88 | return User::create( |
@@ -102,7 +102,7 @@ discard block |
||
| 102 | 102 | $query = <<<'SQL' |
| 103 | 103 | SELECT username FROM user |
| 104 | 104 | WHERE username = :username |
| 105 | -SQL; |
|
| 105 | +sql; |
|
| 106 | 106 | $statement = $this->connection->executeQuery($query, ['username' => $username])->fetchAssociative(); |
| 107 | 107 | |
| 108 | 108 | return false !== $statement; |
@@ -116,7 +116,7 @@ discard block |
||
| 116 | 116 | $query = <<<'SQL' |
| 117 | 117 | SELECT email FROM user |
| 118 | 118 | WHERE email = :email |
| 119 | -SQL; |
|
| 119 | +sql; |
|
| 120 | 120 | $statement = $this->connection->executeQuery($query, ['email' => $email])->fetchAssociative(); |
| 121 | 121 | |
| 122 | 122 | return false !== $statement; |
@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | settings.locale as locale |
| 72 | 72 | FROM settings |
| 73 | 73 | WHERE uuid = :uuid |
| 74 | -SQL; |
|
| 74 | +sql; |
|
| 75 | 75 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 76 | 76 | |
| 77 | 77 | return Settings::create( |
@@ -88,7 +88,7 @@ discard block |
||
| 88 | 88 | { |
| 89 | 89 | $query = <<<'SQL' |
| 90 | 90 | SELECT uuid FROM settings |
| 91 | -SQL; |
|
| 91 | +sql; |
|
| 92 | 92 | |
| 93 | 93 | $statement = $this->connection->executeQuery($query)->fetchAssociative(); |
| 94 | 94 | |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | $query = <<<'SQL' |
| 41 | 41 | SELECT uuid FROM company |
| 42 | 42 | WHERE name = :name |
| 43 | -SQL; |
|
| 43 | +sql; |
|
| 44 | 44 | $statement = $this->connection->executeQuery($query, ['name' => $name])->fetchOne(); |
| 45 | 45 | |
| 46 | 46 | return !(false === $statement); |
@@ -112,7 +112,7 @@ discard block |
||
| 112 | 112 | company.slug as slug |
| 113 | 113 | FROM company |
| 114 | 114 | WHERE uuid = :uuid |
| 115 | -SQL; |
|
| 115 | +sql; |
|
| 116 | 116 | $result = $this->connection->executeQuery($query, ['uuid' => $uuid])->fetchAssociative(); |
| 117 | 117 | |
| 118 | 118 | return Company::create( |
@@ -138,7 +138,7 @@ discard block |
||
| 138 | 138 | { |
| 139 | 139 | $query = <<<'SQL' |
| 140 | 140 | SELECT uuid FROM company |
| 141 | -SQL; |
|
| 141 | +sql; |
|
| 142 | 142 | $statement = $this->connection->executeQuery($query)->fetchOne(); |
| 143 | 143 | |
| 144 | 144 | return !(false === $statement); |