Selection.order().phpt

<?php

/**
 * Test: Nette\Database\Table: Search and order items.
 * @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) {
	$apps = array();

	$selection = $context->table('book')->where('title LIKE ?', '%t%')->order('title DESC')->limit(3);
	foreach ($selection as $book) {  // SELECT * FROM `book` WHERE (`title` LIKE ?) ORDER BY `title` DESC LIMIT 3
		$apps[] = $book->title;
	}

	Assert::same(array(
		'Nette',
		'1001 tipu a triku pro PHP',
	), $apps);
});

test(function() use ($context) {
	$apps = array();

	$selection = $context->table('book')->order('title DESC')->resetOrder()->limit(3);
	foreach ($selection as $book) {  // SELECT * FROM `book` LIMIT 3
		$apps[] = $book->title;
	}

	Assert::same(array(
		'1001 tipu a triku pro PHP',
		'JUSH',
		'Nette',
	), $apps);
});