MORPH
SIGN IN SIGN UP
laravel / framework UNCLAIMED

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

34608 0 0 PHP
Normal View History Raw
first commit.
2013-01-10 15:28:59 -06:00
<?php
[5.4] All tests have been namespaced (#17148) * Basic Composer File * View Tests * Validation Tests * Translation Tests * Support Tests * Session Tests * Routing Tests * Redis Tests * Queue Tests * Pipeline Tests * Pagination Tests * Notification Tests * Mail Tests * Log Tests * Http Tests * Hashing Tests * Foundation Tests * Filesystem Tests * Events Tests * Encryption Tests * Database Tests * Cookie Tests * Container Tests * Console Tests * Config Tests * Cache Tests * Bus Tests * Broadcasting Tests * Blade Tests * Auth Tests * Http Tests * Fixed tests
2017-01-17 14:30:19 +00:00
namespace Illuminate\Tests\Database;
Use ::class notation in Database tests (#25906)
2018-10-03 22:05:43 +02:00
use Illuminate\Container\Container;
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
use Illuminate\Database\Capsule\Manager as DB;
Cleanup the db connection factory tests
2016-08-27 13:49:54 +01:00
use Illuminate\Database\Connectors\ConnectionFactory;
[6.x] Alpha ordered imports (#29933) * Order imports alphabetically * Apply fixes from StyleCI (#29931)
2019-09-10 17:16:05 +02:00
use InvalidArgumentException;
use Mockery as m;
use PDO;
use PHPUnit\Framework\TestCase;
use ReflectionProperty;
first commit.
2013-01-10 15:28:59 -06:00
[5.4] Use namespaced PHPUnit TestCase (#17058) * Use namespaced PHPUnit TestCase Coding standards fixes * Bumped minimum phpunit version
2016-12-30 21:31:11 +01:00
class DatabaseConnectionFactoryTest extends TestCase
PSR-2 Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 16:26:53 +01:00
{
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
protected $db;
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
Use proper method visibility
2019-02-08 23:05:58 +01:00
protected function setUp(): void
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
{
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
$this->db = new DB;
$this->db->addConnection([
'driver' => 'sqlite',
'database' => ':memory:',
]);
Parse Database Url when creating connection.
2019-04-23 13:10:10 +02:00
$this->db->addConnection([
'url' => 'sqlite:///:memory:',
], 'url');
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
$this->db->addConnection([
'driver' => 'sqlite',
'read' => [
style: Unalign double arrow symbols (#37905)
2021-07-05 23:30:07 +08:00
'database' => ':memory:',
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
],
'write' => [
style: Unalign double arrow symbols (#37905)
2021-07-05 23:30:07 +08:00
'database' => ':memory:',
Applied fixes from StyleCI
2016-01-06 11:20:43 -05:00
],
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
], 'read_write');
$this->db->setAsGlobal();
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
}
Defer creation of PDO in read / write scenario so write connection is not opened unless we actually need to write. This is accomplished by wrapping the PDO creation in a Closure and using that to defer the creation of the PDO instance in the Database\Connection itself.
2016-01-06 10:20:14 -06:00
public function testConnectionCanBeCreated()
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
{
Add some more tests.
2019-04-25 08:56:09 +02:00
$this->assertInstanceOf(PDO::class, $this->db->getConnection()->getPdo());
$this->assertInstanceOf(PDO::class, $this->db->getConnection()->getReadPdo());
$this->assertInstanceOf(PDO::class, $this->db->getConnection('read_write')->getPdo());
$this->assertInstanceOf(PDO::class, $this->db->getConnection('read_write')->getReadPdo());
$this->assertInstanceOf(PDO::class, $this->db->getConnection('url')->getPdo());
$this->assertInstanceOf(PDO::class, $this->db->getConnection('url')->getReadPdo());
}
public function testConnectionFromUrlHasProperConfig()
{
$this->db->addConnection([
'url' => 'mysql://root:pass@db/local?strict=true',
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => false,
'engine' => null,
], 'url-config');
$this->assertEquals([
'name' => 'url-config',
'driver' => 'mysql',
'database' => 'local',
'host' => 'db',
'username' => 'root',
'password' => 'pass',
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
], $this->db->getConnection('url-config')->getConfig());
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
}
Add tests for checking if the PDO connection is created.
2016-08-25 07:21:31 +00:00
public function testSingleConnectionNotCreatedUntilNeeded()
{
Add some more tests.
2019-04-25 08:56:09 +02:00
$connection = $this->db->getConnection();
Cleanup the db connection factory tests
2016-08-27 13:49:54 +01:00
$pdo = new ReflectionProperty(get_class($connection), 'pdo');
$readPdo = new ReflectionProperty(get_class($connection), 'readPdo');
Add tests for checking if the PDO connection is created.
2016-08-25 07:21:31 +00:00
[5.7] Use ::class notation for tests (#25939) * Use ::class notation in Auth tests * Use ::class notation in Cache tests * Use ::class notation in Container tests * Use ::class notation in Database tests * Use ::class notation in Events tests * Use ::class notation in Filesystem tests * Use ::class notation in Foundation tests * Use ::class notation in Hashing tests * Use ::class notation in Http tests * Use ::class notation in Integration tests * Use ::class notation in Log tests * Use ::class notation in Mail tests * Use ::class notation in Notifications tests * Use ::class notation in Pagination tests * Use ::class notation in Pipeline tests * Use ::class notation in Queue tests * Use ::class notation in Redis tests * Use ::class notation in Routing tests * Use ::class notation in Session tests * Use ::class notation in Support tests * Use ::class notation in Validation tests * Use ::class notation in View tests
2018-10-05 14:48:10 +02:00
$this->assertNotInstanceOf(PDO::class, $pdo->getValue($connection));
$this->assertNotInstanceOf(PDO::class, $readPdo->getValue($connection));
Add tests for checking if the PDO connection is created.
2016-08-25 07:21:31 +00:00
}
public function testReadWriteConnectionsNotCreatedUntilNeeded()
{
Add some more tests.
2019-04-25 08:56:09 +02:00
$connection = $this->db->getConnection('read_write');
Cleanup the db connection factory tests
2016-08-27 13:49:54 +01:00
$pdo = new ReflectionProperty(get_class($connection), 'pdo');
$readPdo = new ReflectionProperty(get_class($connection), 'readPdo');
Add tests for checking if the PDO connection is created.
2016-08-25 07:21:31 +00:00
[5.7] Use ::class notation for tests (#25939) * Use ::class notation in Auth tests * Use ::class notation in Cache tests * Use ::class notation in Container tests * Use ::class notation in Database tests * Use ::class notation in Events tests * Use ::class notation in Filesystem tests * Use ::class notation in Foundation tests * Use ::class notation in Hashing tests * Use ::class notation in Http tests * Use ::class notation in Integration tests * Use ::class notation in Log tests * Use ::class notation in Mail tests * Use ::class notation in Notifications tests * Use ::class notation in Pagination tests * Use ::class notation in Pipeline tests * Use ::class notation in Queue tests * Use ::class notation in Redis tests * Use ::class notation in Routing tests * Use ::class notation in Session tests * Use ::class notation in Support tests * Use ::class notation in Validation tests * Use ::class notation in View tests
2018-10-05 14:48:10 +02:00
$this->assertNotInstanceOf(PDO::class, $pdo->getValue($connection));
$this->assertNotInstanceOf(PDO::class, $readPdo->getValue($connection));
Add tests for checking if the PDO connection is created.
2016-08-25 07:21:31 +00:00
}
[12.x] Fix QueryException showing wrong connection details for read PDO (#58331) * [12.x] Fix QueryException showing wrong connection details for read PDO When using read/write database connections with useReadPdo: true, the QueryException was always showing the write connection details instead of the read connection details. This fix stores the read PDO configuration separately and uses it when building exception details for queries that failed on the read connection. * [12.x] Fix QueryException showing wrong connection details for read PDO When using read/write database connections with useReadPdo: true, the QueryException was always showing the write connection details instead of the read connection details. This fix stores the read PDO configuration separately and uses it when building exception details for queries that failed on the read connection. * [12.x] Fix QueryException showing wrong connection details for read PDO When using read/write database connections with useReadPdo: true, the QueryException was always showing the write connection details instead of the read connection details. This fix stores the read PDO configuration separately and uses it when building exception details for queries that failed on the read connection.
2026-01-09 12:56:19 -03:00
public function testReadWriteConnectionSetsReadPdoConfig()
{
$connection = $this->db->getConnection('read_write');
$readPdoConfig = new ReflectionProperty(get_class($connection), 'readPdoConfig');
$config = $readPdoConfig->getValue($connection);
$this->assertNotEmpty($config);
$this->assertArrayHasKey('database', $config);
$this->assertSame(':memory:', $config['database']);
}
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
public function testIfDriverIsntSetExceptionIsThrown()
{
Replace expect exception annotations
2019-02-07 17:04:40 +01:00
$this->expectException(InvalidArgumentException::class);
$this->expectExceptionMessage('A driver must be specified.');
Use ::class notation in Database tests (#25906)
2018-10-03 22:05:43 +02:00
$factory = new ConnectionFactory($container = m::mock(Container::class));
Additional cs fixes Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 16:35:44 +01:00
$factory->createConnector(['foo']);
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
}
public function testExceptionIsThrownOnUnsupportedDriver()
{
Replace expect exception annotations
2019-02-07 17:04:40 +01:00
$this->expectException(InvalidArgumentException::class);
$this->expectExceptionMessage('Unsupported driver [foo]');
Use ::class notation in Database tests (#25906)
2018-10-03 22:05:43 +02:00
$factory = new ConnectionFactory($container = m::mock(Container::class));
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
$container->shouldReceive('bound')->once()->andReturn(false);
Additional cs fixes Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 16:35:44 +01:00
$factory->createConnector(['driver' => 'foo']);
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
}
public function testCustomConnectorsCanBeResolvedViaContainer()
{
Use ::class notation in Database tests (#25906)
2018-10-03 22:05:43 +02:00
$factory = new ConnectionFactory($container = m::mock(Container::class));
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
$container->shouldReceive('bound')->once()->with('db.connector.foo')->andReturn(true);
$container->shouldReceive('make')->once()->with('db.connector.foo')->andReturn('connector');
[6.0] Use assertSame for string assertions (#29757) * Use assertSame for string comparisons. * Use assertNotSame for string comparisons. * Tweak 2 tests.
2019-08-27 14:48:17 +02:00
$this->assertSame('connector', $factory->createConnector(['driver' => 'foo']));
Tabs to spaces Signed-off-by: Graham Campbell <graham@cachethq.io>
2015-06-01 15:56:31 +01:00
}
add an sqlite config option to enable foreign key constraints For Sqlite, foreign key constraints need to be explicitly enabled for every database connection. So enabling them in the migrations (as suggested by the documentation) does not work. This PR enables the contraints for every connection to an sqlite database that has the config option `foreign_key_constraints` set to `true`. If the option is not set, nothing changes, so no breaking change is introduced. As foreign key constraints are the default behavior for all other databases I suggest switching this around for the next release and enable foreign keys unless this is set to `false`. If this is accepted I'll submit two more PRs for documentation and laravel/laravel.
2018-10-29 20:43:24 +01:00
public function testSqliteForeignKeyConstraints()
{
$this->db->addConnection([
Parse Database Url when creating connection.
2019-04-23 13:10:10 +02:00
'url' => 'sqlite:///:memory:?foreign_key_constraints=true',
add an sqlite config option to enable foreign key constraints For Sqlite, foreign key constraints need to be explicitly enabled for every database connection. So enabling them in the migrations (as suggested by the documentation) does not work. This PR enables the contraints for every connection to an sqlite database that has the config option `foreign_key_constraints` set to `true`. If the option is not set, nothing changes, so no breaking change is introduced. As foreign key constraints are the default behavior for all other databases I suggest switching this around for the next release and enable foreign keys unless this is set to `false`. If this is accepted I'll submit two more PRs for documentation and laravel/laravel.
2018-10-29 20:43:24 +01:00
], 'constraints_set');
Add some more tests.
2019-04-25 08:56:09 +02:00
$this->assertEquals(0, $this->db->getConnection()->select('PRAGMA foreign_keys')[0]->foreign_keys);
add an sqlite config option to enable foreign key constraints For Sqlite, foreign key constraints need to be explicitly enabled for every database connection. So enabling them in the migrations (as suggested by the documentation) does not work. This PR enables the contraints for every connection to an sqlite database that has the config option `foreign_key_constraints` set to `true`. If the option is not set, nothing changes, so no breaking change is introduced. As foreign key constraints are the default behavior for all other databases I suggest switching this around for the next release and enable foreign keys unless this is set to `false`. If this is accepted I'll submit two more PRs for documentation and laravel/laravel.
2018-10-29 20:43:24 +01:00
Add some more tests.
2019-04-25 08:56:09 +02:00
$this->assertEquals(1, $this->db->getConnection('constraints_set')->select('PRAGMA foreign_keys')[0]->foreign_keys);
add an sqlite config option to enable foreign key constraints For Sqlite, foreign key constraints need to be explicitly enabled for every database connection. So enabling them in the migrations (as suggested by the documentation) does not work. This PR enables the contraints for every connection to an sqlite database that has the config option `foreign_key_constraints` set to `true`. If the option is not set, nothing changes, so no breaking change is introduced. As foreign key constraints are the default behavior for all other databases I suggest switching this around for the next release and enable foreign keys unless this is set to `false`. If this is accepted I'll submit two more PRs for documentation and laravel/laravel.
2018-10-29 20:43:24 +01:00
}
[11.x] Add ability to configure SQLite `busy_timeout`, `journal_mode`, and `synchronous` pragmas (#52052) * Add tests for SQLite `busy_timeout` config option * Add `busy_timeout` config option * Add support for setting the SQLite `busy_timeout` connection option * Wip * Add tests for setting `journal_mode` and `synchronous` * Add `journal_mode` and `synchronous` * Wip * formatting --------- Co-authored-by: Taylor Otwell <taylor@laravel.com>
2024-07-10 15:49:27 -04:00
public function testSqliteBusyTimeout()
{
$this->db->addConnection([
'url' => 'sqlite:///:memory:?busy_timeout=1234',
], 'busy_timeout_set');
// Can't compare to 0, default value may be something else
$this->assertNotSame(1234, $this->db->getConnection()->select('PRAGMA busy_timeout')[0]->timeout);
$this->assertSame(1234, $this->db->getConnection('busy_timeout_set')->select('PRAGMA busy_timeout')[0]->timeout);
}
public function testSqliteSynchronous()
{
$this->db->addConnection([
'url' => 'sqlite:///:memory:?synchronous=NORMAL',
], 'synchronous_set');
$this->assertSame(2, $this->db->getConnection()->select('PRAGMA synchronous')[0]->synchronous);
$this->assertSame(1, $this->db->getConnection('synchronous_set')->select('PRAGMA synchronous')[0]->synchronous);
}
Fixed test whitespaces
2014-02-27 19:30:59 +00:00
}
Reference in New Issue Copy Permalink