database/tests/Database/ResultSet.fetch().phpt at 5ed5dfd03037e7d63ee645e264254dede03369f6 · nette/database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php

/**
 * Test: Nette\Database\ResultSet::fetch()
 * @dataProvider? databases.ini
 */

use Tester\Assert;

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

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


test(function () use ($context) {
	$res = $context->query('SELECT name, name FROM author');

	Assert::error(function () use ($res) {
		$res->fetch();
	}, E_USER_NOTICE);

	$res->fetch();
});


test(function () use ($context, $driverName) { // tests closeCursor()
	if ($driverName === 'mysql') {
		$context->query('CREATE DEFINER = CURRENT_USER PROCEDURE `testProc`(IN param int(10) unsigned) BEGIN SELECT * FROM book WHERE id != param; END;;');
		$context->getConnection()->getPdo()->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, FALSE);

		$res = $context->query('CALL testProc(1)');
		foreach ($res as $row) {}

		$res = $context->query('SELECT * FROM book');
		foreach ($res as $row) {}
	}
});

test(function () use ($context, $driverName) {

	$result = $context->query('SELECT book.id, author.id, author.name, translator.name FROM book JOIN author ON (author.id = book.author_id) JOIN author translator ON (translator.id = book.translator_id)');
	//Found duplicate columns in database result set: 'id' from book, author; 'name' from author, translator.
	Assert::error(function() use($result) {
		iterator_to_array($result);
	}, E_USER_NOTICE);
});