Morph MORPH
SIGN IN SIGN UP
laravel / framework UNCLAIMED

Laravel is a web application framework with expressive, elegant syntax.

34610 0 0 PHP
Normal View History Raw
[12.x] Adds a new method "getRawSql" (with embedded bindings) to the QueryException class (#54849) * [12.x] Get Raw SQL (with embedded bindings) from QueryException (new method) * Reordering the imports * Reverting string concatenation format on untouched method * Reverting string concatenation format on untouched method * Resolving StyleCI complaint about extra line between namespace declaration and imports * Update QueryException.php --------- Co-authored-by: Taylor Otwell <taylor@laravel.com>
2025-02-28 13:48:36 -03:00
<?php
namespace Illuminate\Tests\Database;
use Illuminate\Database\Connection;
use Illuminate\Database\Query\Grammars\Grammar;
use Illuminate\Database\QueryException;
use Illuminate\Support\Facades\DB;
use Mockery as m;
use PDOException;
use PHPUnit\Framework\TestCase;
class DatabaseQueryExceptionTest extends TestCase
{
public function testIfItEmbedsBindingsIntoSql()
{
$connection = $this->getConnection();
$sql = 'SELECT * FROM huehue WHERE a = ? and hue = ?';
$bindings = [1, 'br'];
$expectedSql = "SELECT * FROM huehue WHERE a = 1 and hue = 'br'";
$pdoException = new PDOException('Mock SQL error');
$exception = new QueryException($connection->getName(), $sql, $bindings, $pdoException);
DB::shouldReceive('connection')->andReturn($connection);
$result = $exception->getRawSql();
$this->assertSame($expectedSql, $result);
}
public function testIfItReturnsSameSqlWhenThereAreNoBindings()
{
$connection = $this->getConnection();
$sql = "SELECT * FROM huehue WHERE a = 1 and hue = 'br'";
$bindings = [];
$expectedSql = $sql;
$pdoException = new PDOException('Mock SQL error');
$exception = new QueryException($connection->getName(), $sql, $bindings, $pdoException);
DB::shouldReceive('connection')->andReturn($connection);
$result = $exception->getRawSql();
$this->assertSame($expectedSql, $result);
}
Add connection details to QueryException error messages (#58218) * Add connection details to QueryException error messages Before: SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, SQL: select ...) After (MySQL with host/port): SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, Host: 192.168.1.10, Port: 3306, Database: laravel, SQL: select ...) After (MySQL with host/port for read and write connection): SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql::read, Host: 192.168.1.10, Port: 3306, Database: laravel, SQL: select ...) After (misconfigured - empty host): SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql, Host: , Port: 3306, Database: laravel, SQL: select ...) After (misconfigured - empty host for read and write connection): SQLSTATE[HY000] [2002] No such file or directory (Connection: mysql::read, Host: , Port: 3306, Database: laravel, SQL: select ...) After (SQLite): SQLSTATE[HY000] [2002] No such file or directory (Connection: sqlite, Database: /path/to/db.sqlite, SQL: select ...) This helps diagnose connection issues, especially with read/write configurations where hosts may differ from DB_HOST. Empty values are shown explicitly to make misconfiguration obvious * formatting --------- Co-authored-by: Taylor Otwell <taylor@laravel.com>
2025-12-28 14:58:19 -03:00
public function testMessageIncludesConnectionInfo()
{
$pdoException = new PDOException('SQLSTATE[HY000] [2002] No such file or directory');
$exception = new QueryException('mysql::read', 'SELECT * FROM users', [], $pdoException, [
'driver' => 'mysql',
'name' => 'mysql::read',
'host' => '192.168.1.10',
'port' => '3306',
'database' => 'laravel_db',
'unix_socket' => null,
]);
$this->assertStringContainsString('Host: 192.168.1.10', $exception->getMessage());
$this->assertStringContainsString('Port: 3306', $exception->getMessage());
$this->assertStringContainsString('Database: laravel_db', $exception->getMessage());
$this->assertStringContainsString('Connection: mysql::read', $exception->getMessage());
}
public function testMessageIncludesUnixSocket()
{
$pdoException = new PDOException('SQLSTATE[HY000] [2002] No such file or directory');
$exception = new QueryException('mysql', 'SELECT * FROM users', [], $pdoException, [
'driver' => 'mysql',
'unix_socket' => '/tmp/mysql.sock',
'database' => 'laravel_db',
]);
$this->assertStringContainsString('Socket: /tmp/mysql.sock', $exception->getMessage());
$this->assertStringContainsString('Database: laravel_db', $exception->getMessage());
$this->assertStringNotContainsString('Host:', $exception->getMessage());
}
public function testMessageHandlesArrayHosts()
{
$pdoException = new PDOException('SQLSTATE[HY000] [2002] No such file or directory');
$exception = new QueryException('mysql::read', 'SELECT * FROM users', [], $pdoException, [
'driver' => 'mysql',
'host' => ['192.168.1.10', '192.168.1.11'],
'port' => '3306',
'database' => 'laravel_db',
]);
$this->assertStringContainsString('Host: 192.168.1.10, 192.168.1.11', $exception->getMessage());
}
public function testMessageHandlesEmptyConnectionInfo()
{
$pdoException = new PDOException('SQLSTATE[HY000] [2002] No such file or directory');
$exception = new QueryException('mysql', 'SELECT * FROM users', [], $pdoException, [
'driver' => 'mysql',
'host' => '',
'port' => '',
'database' => '',
]);
$this->assertStringContainsString('Host: ,', $exception->getMessage());
$this->assertStringContainsString('Database: ', $exception->getMessage());
}
public function testMessageForSqliteOnlyShowsDatabase()
{
$pdoException = new PDOException('SQLSTATE[HY000]: General error: 1 no such table');
$exception = new QueryException('sqlite', 'SELECT * FROM users', [], $pdoException, [
'driver' => 'sqlite',
'name' => 'sqlite',
'host' => null,
'port' => null,
'database' => '/path/to/database.sqlite',
'unix_socket' => null,
]);
$this->assertStringContainsString('Database: /path/to/database.sqlite', $exception->getMessage());
$this->assertStringNotContainsString('Host:', $exception->getMessage());
$this->assertStringNotContainsString('Port:', $exception->getMessage());
}
public function testGetConnectionInfoReturnsConnectionInfo()
{
$pdoException = new PDOException('Mock error');
$connectionInfo = [
'driver' => 'mysql',
'name' => 'mysql::read',
'host' => '192.168.1.10',
'port' => '3306',
'database' => 'laravel_db',
'unix_socket' => null,
];
$exception = new QueryException('mysql::read', 'SELECT * FROM users', [], $pdoException, $connectionInfo);
$this->assertSame($connectionInfo, $exception->getConnectionDetails());
}
public function testBackwardCompatibilityWithoutConnectionInfo()
{
$pdoException = new PDOException('Mock SQL error');
$exception = new QueryException('mysql', 'SELECT * FROM users WHERE id = ?', [1], $pdoException);
$this->assertSame('Mock SQL error (Connection: mysql, SQL: SELECT * FROM users WHERE id = 1)', $exception->getMessage());
$this->assertSame([], $exception->getConnectionDetails());
}
[12.x] Adds a new method "getRawSql" (with embedded bindings) to the QueryException class (#54849) * [12.x] Get Raw SQL (with embedded bindings) from QueryException (new method) * Reordering the imports * Reverting string concatenation format on untouched method * Reverting string concatenation format on untouched method * Resolving StyleCI complaint about extra line between namespace declaration and imports * Update QueryException.php --------- Co-authored-by: Taylor Otwell <taylor@laravel.com>
2025-02-28 13:48:36 -03:00
protected function getConnection()
{
$connection = m::mock(Connection::class);
$grammar = new Grammar($connection);
$connection->shouldReceive('getName')->andReturn('default');
$connection->shouldReceive('getQueryGrammar')->andReturn($grammar);
$connection->shouldReceive('escape')->with(1, false)->andReturn(1);
$connection->shouldReceive('escape')->with('br', false)->andReturn("'br'");
return $connection;
}
}
Reference in New Issue Copy Permalink