Reflection.driver.phpt

<?php

/**
 * Test: Nette\Database\Connection: reflection
 * @dataProvider? databases.ini
 */

declare(strict_types=1);

use Nette\Database\Driver;
use Tester\Assert;

require __DIR__ . '/connect.inc.php'; // create $connection

Nette\Database\Helpers::loadFromFile($connection, __DIR__ . "/files/{$driverName}-nette_test1.sql");


$driver = $connection->getDriver();
$tables = $driver->getTables();
$tables = array_filter($tables, fn($t) => in_array($t['name'], ['author', 'book', 'book_tag', 'tag'], true));
usort($tables, fn($a, $b) => strcmp($a['name'], $b['name']));

if ($driver->isSupported(Driver::SupportSchema)) {
	Assert::same(
		[
			['name' => 'author', 'view' => false, 'fullName' => 'public.author'],
			['name' => 'book', 'view' => false, 'fullName' => 'public.book'],
			['name' => 'book_tag', 'view' => false, 'fullName' => 'public.book_tag'],
			['name' => 'tag', 'view' => false, 'fullName' => 'public.tag'],
		],
		$tables,
	);
} else {
	Assert::same([
		['name' => 'author', 'view' => false],
		['name' => 'book', 'view' => false],
		['name' => 'book_tag', 'view' => false],
		['name' => 'tag', 'view' => false],
	], $tables);
}


$columns = $driver->getColumns('author');
array_walk($columns, function (&$item) {
	Assert::type('array', $item['vendor']);
	unset($item['vendor']);
});

$expectedColumns = [
	[
		'name' => 'id',
		'table' => 'author',
		'nativetype' => 'int',
		'size' => 11,
		'nullable' => false,
		'default' => null,
		'autoincrement' => true,
		'primary' => true,
	],
	[
		'name' => 'name',
		'table' => 'author',
		'nativetype' => 'varchar',
		'size' => 30,
		'nullable' => false,
		'default' => null,
		'autoincrement' => false,
		'primary' => false,
	],
	[
		'name' => 'web',
		'table' => 'author',
		'nativetype' => 'varchar',
		'size' => 100,
		'nullable' => false,
		'default' => null,
		'autoincrement' => false,
		'primary' => false,
	],
	[
		'name' => 'born',
		'table' => 'author',
		'nativetype' => 'date',
		'size' => null,
		'nullable' => true,
		'default' => null,
		'autoincrement' => false,
		'primary' => false,
	],
];

switch ($driverName) {
	case 'mysql':
		$version = $connection->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);
		if (version_compare($version, '8.0', '>=')) {
			$expectedColumns[0]['size'] = null;
		}
		break;
	case 'pgsql':
		$expectedColumns[0]['nativetype'] = 'int4';
		$expectedColumns[0]['default'] = "nextval('author_id_seq'::regclass)";
		$expectedColumns[0]['size'] = null;
		break;
	case 'sqlite':
		$expectedColumns[0]['nativetype'] = 'INTEGER';
		$expectedColumns[0]['size'] = null;
		$expectedColumns[1]['nativetype'] = 'TEXT';
		$expectedColumns[1]['size'] = null;
		$expectedColumns[2]['nativetype'] = 'TEXT';
		$expectedColumns[2]['size'] = null;
		$expectedColumns[3]['nativetype'] = 'DATE';
		break;
	case 'sqlsrv':
		$expectedColumns[0]['size'] = null;
		$expectedColumns[1]['size'] = null;
		$expectedColumns[2]['size'] = null;
		break;
	default:
		Assert::fail("Unsupported driver $driverName");
}

Assert::same($expectedColumns, $columns);


$indexes = $driver->getIndexes('book_tag');
switch ($driverName) {
	case 'pgsql':
		Assert::same([
			[
				'name' => 'book_tag_pkey',
				'unique' => true,
				'primary' => true,
				'columns' => [
					'book_id',
					'tag_id',
				],
			],
		], $indexes);
		break;
	case 'sqlite':
		Assert::same([
			[
				'name' => 'sqlite_autoindex_book_tag_1',
				'unique' => true,
				'primary' => true,
				'columns' => [
					'book_id',
					'tag_id',
				],
			],
		], $indexes);
		break;
	case 'sqlsrv':
		Assert::same([
			[
				'name' => 'PK_book_tag',
				'unique' => true,
				'primary' => true,
				'columns' => [
					'book_id',
					'tag_id',
				],
			],
		], $indexes);
		break;
	case 'mysql':
		Assert::same([
			[
				'name' => 'PRIMARY',
				'unique' => true,
				'primary' => true,
				'columns' => [
					'book_id',
					'tag_id',
				],
			],
			[
				'name' => 'book_tag_tag',
				'unique' => false,
				'primary' => false,
				'columns' => [
					'tag_id',
				],
			],
		], $indexes);
		break;
	default:
		Assert::fail("Unsupported driver $driverName");
}

$structure->rebuild();
$primary = $structure->getPrimaryKey('book_tag');
Assert::same(['book_id', 'tag_id'], $primary);